equal
deleted
inserted
replaced
6 |
6 |
7 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int(12) UNSIGNED NOT NULL DEFAULT 1, |
7 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_rank int(12) UNSIGNED NOT NULL DEFAULT 1, |
8 ADD COLUMN user_timezone int(12) UNSIGNED NOT NULL DEFAULT 0; |
8 ADD COLUMN user_timezone int(12) UNSIGNED NOT NULL DEFAULT 0; |
9 |
9 |
10 ALTER TABLE {{TABLE_PREFIX}}tags CHANGE user user_id mediumint(8) NOT NULL DEFAULT 1; |
10 ALTER TABLE {{TABLE_PREFIX}}tags CHANGE user user_id mediumint(8) NOT NULL DEFAULT 1; |
|
11 ALTER TABLE {{TABLE_PREFIX}}themes |
|
12 ADD COLUMN group_list text DEFAULT NULL, |
|
13 ADD COLUMN group_policy ENUM('allow', 'deny') NOT NULL DEFAULT 'deny'; |
11 |
14 |
12 CREATE TABLE {{TABLE_PREFIX}}ranks( |
15 CREATE TABLE {{TABLE_PREFIX}}ranks( |
13 rank_id int(12) NOT NULL auto_increment, |
16 rank_id int(12) NOT NULL auto_increment, |
14 rank_title varchar(63) NOT NULL DEFAULT '', |
17 rank_title varchar(63) NOT NULL DEFAULT '', |
15 rank_style varchar(255) NOT NULL DEFAULT '', |
18 rank_style varchar(255) NOT NULL DEFAULT '', |