equal
deleted
inserted
replaced
103 user_lang smallint NOT NULL, |
103 user_lang smallint NOT NULL, |
104 user_has_avatar smallint NOT NULL, |
104 user_has_avatar smallint NOT NULL, |
105 avatar_type varchar(3) NOT NULL, |
105 avatar_type varchar(3) NOT NULL, |
106 user_registration_ip varchar(39), |
106 user_registration_ip varchar(39), |
107 user_rank int NOT NULL DEFAULT 1, |
107 user_rank int NOT NULL DEFAULT 1, |
|
108 user_timezone int NOT NULL DEFAULT 0, |
108 CHECK (avatar_type IN ('jpg', 'png', 'gif')), |
109 CHECK (avatar_type IN ('jpg', 'png', 'gif')), |
109 PRIMARY KEY (user_id) |
110 PRIMARY KEY (user_id) |
110 ); |
111 ); |
111 |
112 |
112 CREATE TABLE {{TABLE_PREFIX}}users_extra( |
113 CREATE TABLE {{TABLE_PREFIX}}users_extra( |