equal
deleted
inserted
replaced
29 ip_address varchar(39), |
29 ip_address varchar(39), |
30 PRIMARY KEY ( comment_id ) |
30 PRIMARY KEY ( comment_id ) |
31 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
31 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
32 |
32 |
33 CREATE TABLE {{TABLE_PREFIX}}logs( |
33 CREATE TABLE {{TABLE_PREFIX}}logs( |
|
34 log_id int(15) NOT NULL auto_increment, |
34 log_type varchar(16), |
35 log_type varchar(16), |
35 action varchar(16), |
36 action varchar(16), |
36 time_id int(12) NOT NULL DEFAULT '0', |
37 time_id int(12) NOT NULL DEFAULT '0', |
37 date_string varchar(63), |
38 date_string varchar(63), |
38 page_id text, |
39 page_id text, |
39 namespace text, |
40 namespace text, |
40 page_text text, |
41 page_text text, |
41 char_tag varchar(40), |
42 char_tag varchar(40), |
42 author varchar(63), |
43 author varchar(63), |
43 edit_summary text, |
44 edit_summary text, |
44 minor_edit tinyint(1) |
45 minor_edit tinyint(1), |
|
46 PRIMARY KEY ( log_id ) |
45 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
47 ) CHARACTER SET `utf8` COLLATE `utf8_bin`; |
46 |
48 |
47 CREATE TABLE {{TABLE_PREFIX}}page_text( |
49 CREATE TABLE {{TABLE_PREFIX}}page_text( |
48 page_id varchar(255), |
50 page_id varchar(255), |
49 namespace varchar(16) NOT NULL DEFAULT 'Article', |
51 namespace varchar(16) NOT NULL DEFAULT 'Article', |