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 ); |
31 ); |
32 |
32 |
33 CREATE TABLE {{TABLE_PREFIX}}logs( |
33 CREATE TABLE {{TABLE_PREFIX}}logs( |
|
34 log_id SERIAL, |
34 log_type varchar(16), |
35 log_type varchar(16), |
35 action varchar(16), |
36 action varchar(16), |
36 time_id int NOT NULL default '0', |
37 time_id int 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 smallint |
45 minor_edit smallint, |
|
46 PRIMARY KEY ( log_id ) |
45 ); |
47 ); |
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', |