| #202 | |
| #203 | $sql_table = "CREATE TABLE IF NOT EXISTS {$table_cms_flag} ( |
| #204 | flag tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '属性标记', |
| #205 | cid int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分类ID', |
| #206 | id int(10) unsigned NOT NULL DEFAULT '0' COMMENT '内容ID', |
| #207 | PRIMARY KEY (flag,id), |
| #208 | KEY flag_cid (flag,cid,id), |
| #209 | KEY id (id) |
| #210 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin"; |
| #211 | $this->db->query($sql_table); |