equal
deleted
inserted
replaced
2 -- Upgrade schema - Enano 1.1.1 - 1.1.2 |
2 -- Upgrade schema - Enano 1.1.1 - 1.1.2 |
3 |
3 |
4 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN log_id int(15) NOT NULL auto_increment, ADD PRIMARY KEY ( log_id ); |
4 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN log_id int(15) NOT NULL auto_increment, ADD PRIMARY KEY ( log_id ); |
5 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN is_draft tinyint(1) NOT NULL DEFAULT 0; |
5 ALTER TABLE {{TABLE_PREFIX}}logs ADD COLUMN is_draft tinyint(1) NOT NULL DEFAULT 0; |
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 @ALTER TABLE {{TABLE_PREFIX}}users 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 |
11 ALTER TABLE {{TABLE_PREFIX}}themes |
12 ADD COLUMN group_list text DEFAULT NULL, |
12 ADD COLUMN group_list text DEFAULT NULL, |
13 ADD COLUMN group_policy ENUM('allow', 'deny') NOT NULL DEFAULT 'deny'; |
13 ADD COLUMN group_policy ENUM('allow', 'deny') NOT NULL DEFAULT 'deny'; |