Skip to content

database changed

freefcw edited this page Jan 15, 2015 · 3 revisions
# support language
ALTER TABLE users ADD locale CHAR(7) NULL; 
# support user theme
ALTER TABLE users ADD theme CHAR(30) NULL; 

# add option table
CREATE TABLE `options` (
  `option_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL DEFAULT '',
  `desc` varchar(128) NOT NULL DEFAULT '',
  `value` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`option_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

INSERT INTO `options` (`option_id`, `name`, `desc`, `value`)
VALUES
	(2, 'ga_code', 'Google Analytics Code', 'UA-YOURCODE-1');
Clone this wiki locally