47 edit_summary text, |
47 edit_summary text, |
48 minor_edit tinyint(1) |
48 minor_edit tinyint(1) |
49 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
49 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
50 |
50 |
51 CREATE TABLE {{TABLE_PREFIX}}page_text( |
51 CREATE TABLE {{TABLE_PREFIX}}page_text( |
52 page_id varchar(63), |
52 page_id varchar(255), |
53 namespace varchar(16) NOT NULL default 'Article', |
53 namespace varchar(16) NOT NULL default 'Article', |
54 page_text text, |
54 page_text text, |
55 char_tag varchar(63), |
55 char_tag varchar(63), |
56 FULLTEXT KEY {{TABLE_PREFIX}}page_search_idx (page_id, namespace, page_text) |
56 FULLTEXT KEY {{TABLE_PREFIX}}page_search_idx (page_id, namespace, page_text) |
57 ) ENGINE = MYISAM CHARACTER SET `utf8`; |
57 ) ENGINE = MYISAM CHARACTER SET `utf8`; |
58 |
58 |
59 CREATE TABLE {{TABLE_PREFIX}}pages( |
59 CREATE TABLE {{TABLE_PREFIX}}pages( |
60 page_order int(8), |
60 page_order int(8), |
61 name varchar(127), |
61 name varchar(255), |
62 urlname varchar(63), |
62 urlname varchar(255), |
63 namespace varchar(16) NOT NULL default 'Article', |
63 namespace varchar(16) NOT NULL default 'Article', |
64 special tinyint(1) default '0', |
64 special tinyint(1) default '0', |
65 visible tinyint(1) default '1', |
65 visible tinyint(1) default '1', |
66 comments_on tinyint(1) default '1', |
66 comments_on tinyint(1) default '1', |
67 protected tinyint(1) NOT NULL DEFAULT 0, |
67 protected tinyint(1) NOT NULL DEFAULT 0, |