equal
deleted
inserted
replaced
3 |
3 |
4 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN log_id SERIAL, ADD PRIMARY KEY ( log_id ); |
4 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN log_id SERIAL, ADD PRIMARY KEY ( log_id ); |
5 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN is_draft smallint NOT NULL DEFAULT 0; |
5 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN is_draft smallint NOT NULL DEFAULT 0; |
6 |
6 |
7 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int NOT NULL DEFAULT 1; |
7 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int NOT NULL DEFAULT 1; |
8 @ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_timezone int NOT NULL DEFAULT 0; |
8 @ALTER TABLE {{TABLE_PREFIX}}users DROP user_timezone; |
|
9 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_timezone int NOT NULL DEFAULT 0; |
9 |
10 |
10 ALTER TABLE {{TABLE_PREFIX}}themes |
11 ALTER TABLE {{TABLE_PREFIX}}themes |
11 ADD COLUMN group_list text DEFAULT NULL, |
12 ADD COLUMN group_list text DEFAULT NULL, |
12 ADD COLUMN group_policy varchar(5) NOT NULL DEFAULT 'deny', |
13 ADD COLUMN group_policy varchar(5) NOT NULL DEFAULT 'deny', |
13 ADD CHECK (group_policy IN ('allow', 'deny')); |
14 ADD CHECK (group_policy IN ('allow', 'deny')); |
23 code_id SERIAL, |
24 code_id SERIAL, |
24 session_id varchar(40) NOT NULL DEFAULT '', |
25 session_id varchar(40) NOT NULL DEFAULT '', |
25 code varchar(64) NOT NULL DEFAULT '', |
26 code varchar(64) NOT NULL DEFAULT '', |
26 session_data text, |
27 session_data text, |
27 source_ip varchar(39), |
28 source_ip varchar(39), |
28 user_id int(12), |
29 user_id int, |
29 PRIMARY KEY ( code_id ) |
30 PRIMARY KEY ( code_id ) |
30 ); |
31 ); |
31 |
32 |
32 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES |
33 INSERT INTO {{TABLE_PREFIX}}ranks(rank_id, rank_title, rank_style) VALUES |
33 (1, 'user_rank_member', ''), |
34 (1, 'user_rank_member', ''), |