219 search_id int(15) NOT NULL auto_increment, |
219 search_id int(15) NOT NULL auto_increment, |
220 search_time int(11) NOT NULL, |
220 search_time int(11) NOT NULL, |
221 query text, |
221 query text, |
222 results longblob, |
222 results longblob, |
223 PRIMARY KEY ( search_id ) |
223 PRIMARY KEY ( search_id ) |
|
224 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
|
225 |
|
226 -- Added in 1.0.1 |
|
227 |
|
228 CREATE TABLE {{TABLE_PREFIX}}page_groups( |
|
229 pg_id mediumint(8) NOT NULL auto_increment, |
|
230 pg_type tinyint(2) NOT NULL DEFAULT 1, |
|
231 pg_name varchar(255) NOT NULL DEFAULT '', |
|
232 pg_target varchar(255) DEFAULT NULL, |
|
233 PRIMARY KEY ( pg_id ) |
|
234 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
|
235 |
|
236 -- Added in 1.0.1 |
|
237 |
|
238 CREATE TABLE {{TABLE_PREFIX}}page_group_members( |
|
239 pg_member_id int(12) NOT NULL auto_increment, |
|
240 pg_id mediumint(8) NOT NULL, |
|
241 page_id varchar(63) NOT NULL, |
|
242 namespace varchar(63) NOT NULL DEFAULT 'Article', |
|
243 PRIMARY KEY ( pg_member_id ) |
224 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
244 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
225 |
245 |
226 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES |
246 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES |
227 ('site_name', '{{SITE_NAME}}'), |
247 ('site_name', '{{SITE_NAME}}'), |
228 ('main_page', 'Main_Page'), |
248 ('main_page', 'Main_Page'), |