· 8 years ago · Jul 16, 2018, 04:58 PM
1CREATE TABLE IF NOT EXISTS `config` (
2 `id` int(11) NOT NULL auto_increment,
3 `group_name` varchar(32) character set utf8 NOT NULL,
4 `config_key` varchar(32) character set utf8 NOT NULL,
5 `label` varchar(64) character set utf8 NOT NULL,
6 `config_value` text character set utf8,
7 `default` text character set utf8,
8 `rules` text character set utf8,
9 `field_type` varchar(255) character set utf8 NOT NULL default 'text',
10 `date` timestamp NOT NULL default CURRENT_TIMESTAMP,
11 PRIMARY KEY (`id`),
12 UNIQUE KEY `group` (`group_name`,`config_key`)
13) ENGINE=InnoDB DEFAULT CHARSET=utf8;