equal
deleted
inserted
replaced
112 user_registration_ip varchar(39), |
112 user_registration_ip varchar(39), |
113 user_rank int DEFAULT NULL, |
113 user_rank int DEFAULT NULL, |
114 user_timezone int NOT NULL DEFAULT 0, |
114 user_timezone int NOT NULL DEFAULT 0, |
115 user_title varchar(64) DEFAULT NULL, |
115 user_title varchar(64) DEFAULT NULL, |
116 user_group int NOT NULL DEFAULT 1, |
116 user_group int NOT NULL DEFAULT 1, |
117 CHECK (avatar_type IN ('jpg', 'png', 'gif')), |
117 CHECK (avatar_type IN ('jpg', 'png', 'gif', 'grv')), |
118 PRIMARY KEY (user_id) |
118 PRIMARY KEY (user_id) |
119 ); |
119 ); |
120 |
120 |
121 CREATE TABLE {{TABLE_PREFIX}}users_extra( |
121 CREATE TABLE {{TABLE_PREFIX}}users_extra( |
122 user_id int NOT NULL, |
122 user_id int NOT NULL, |