equal
deleted
inserted
replaced
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); |
16 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_registration_ip varchar(39); |
17 ALTER TABLE {{TABLE_PREFIX}}users ADD COLUMN user_timezone int(12) NOT NULL DEFAULT 0; |
|
18 ALTER TABLE {{TABLE_PREFIX}}comments ADD COLUMN ip_address varchar(39); |
17 ALTER TABLE {{TABLE_PREFIX}}comments ADD COLUMN ip_address varchar(39); |
19 |
18 |
20 CREATE TABLE {{TABLE_PREFIX}}lockout( |
19 CREATE TABLE {{TABLE_PREFIX}}lockout( |
21 id int(12) NOT NULL auto_increment, |
20 id int(12) NOT NULL auto_increment, |
22 ipaddr varchar(40) NOT NULL, |
21 ipaddr varchar(40) NOT NULL, |