1 CREATE TABLE core_setting (
2 id int(11) NOT NULL AUTO_INCREMENT,
6 ALTER TABLE core_setting ADD COLUMN module VARCHAR(64) NOT NULL DEFAULT '';
8 ALTER TABLE core_setting ADD COLUMN name VARCHAR(64) NOT NULL DEFAULT '';
10 ALTER TABLE core_setting ADD COLUMN description VARCHAR(128) NOT NULL DEFAULT '';
12 ALTER TABLE core_setting CHANGE COLUMN val val TEXT DEFAULT '';
13 ALTER TABLE core_setting ADD COLUMN val TEXT NOT NULL DEFAULT '';
15 ALTER TABLE core_setting ADD COLUMN updated_dt DATE NOT NULL DEFAULT '0000-00-00';
17 ALTER TABLE core_setting ADD COLUMN is_encrypt INT(2) NOT NULL DEFAULT 1;
19 ALTER TABLE core_setting ADD COLUMN is_valid INT(2) NOT NULL DEFAULT 0;
21 ALTER TABLE core_setting ADD INDEX lookup_module_name(module, name);