239 pg_member_id int(12) NOT NULL auto_increment, |
239 pg_member_id int(12) NOT NULL auto_increment, |
240 pg_id mediumint(8) NOT NULL, |
240 pg_id mediumint(8) NOT NULL, |
241 page_id varchar(63) NOT NULL, |
241 page_id varchar(63) NOT NULL, |
242 namespace varchar(63) NOT NULL DEFAULT 'Article', |
242 namespace varchar(63) NOT NULL DEFAULT 'Article', |
243 PRIMARY KEY ( pg_member_id ) |
243 PRIMARY KEY ( pg_member_id ) |
|
244 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
|
245 |
|
246 -- Added in 1.0.1 |
|
247 |
|
248 CREATE TABLE {{TABLE_PREFIX}}tags( |
|
249 tag_id int(12) NOT NULL auto_increment, |
|
250 tag_name varchar(63) NOT NULL DEFAULT 'bla', |
|
251 page_id varchar(255) NOT NULL, |
|
252 namespace varchar(255) NOT NULL, |
|
253 user mediumint(8) NOT NULL DEFAULT 1, |
|
254 PRIMARY KEY ( tag_id ) |
244 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
255 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
245 |
256 |
246 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES |
257 INSERT INTO {{TABLE_PREFIX}}config(config_name, config_value) VALUES |
247 ('site_name', '{{SITE_NAME}}'), |
258 ('site_name', '{{SITE_NAME}}'), |
248 ('main_page', 'Main_Page'), |
259 ('main_page', 'Main_Page'), |