equal
deleted
inserted
replaced
11 -- 1.0-1.1-mysql.sql - Enano 1.0.x to 1.1.x migration queries, MySQL |
11 -- 1.0-1.1-mysql.sql - Enano 1.0.x to 1.1.x migration queries, MySQL |
12 |
12 |
13 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_lang smallint(5) NOT NULL; |
13 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_lang smallint(5) NOT NULL; |
14 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_has_avatar tinyint(1) NOT NULL; |
14 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_has_avatar tinyint(1) NOT NULL; |
15 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN avatar_type ENUM('jpg', 'png', 'gif') NOT NULL; |
15 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN avatar_type ENUM('jpg', 'png', 'gif') NOT NULL; |
|
16 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_registration_ip varchar(39); |
|
17 ALTER TABLE {{TABLE_PREFIX}}comments ADD COLUMN ip_address varchar(39); |
16 |
18 |
17 CREATE TABLE {{TABLE_PREFIX}}lockout( |
19 CREATE TABLE {{TABLE_PREFIX}}lockout( |
18 id int(12) NOT NULL auto_increment, |
20 id int(12) NOT NULL auto_increment, |
19 ipaddr varchar(40) NOT NULL, |
21 ipaddr varchar(40) NOT NULL, |
20 action ENUM('credential', 'level') NOT NULL DEFAULT 'credential', |
22 action ENUM('credential', 'level') NOT NULL DEFAULT 'credential', |