114 user_has_avatar smallint NOT NULL, |
114 user_has_avatar smallint NOT NULL, |
115 avatar_type varchar(3) NOT NULL, |
115 avatar_type varchar(3) NOT NULL, |
116 user_registration_ip varchar(39), |
116 user_registration_ip varchar(39), |
117 user_rank int DEFAULT NULL, |
117 user_rank int DEFAULT NULL, |
118 user_rank_userset smallint NOT NULL DEFAULT 0, |
118 user_rank_userset smallint NOT NULL DEFAULT 0, |
119 user_timezone int NOT NULL DEFAULT 0, |
119 user_timezone int NOT NULL DEFAULT 1440, |
120 user_title varchar(64) DEFAULT NULL, |
120 user_title varchar(64) DEFAULT NULL, |
121 user_group int NOT NULL DEFAULT 1, |
121 user_group int NOT NULL DEFAULT 1, |
122 user_dst varchar(11) NOT NULL DEFAULT '0;0;0;0;60', |
122 user_dst varchar(11) NOT NULL DEFAULT '0;0;0;0;60', |
123 CHECK (avatar_type IN ('jpg', 'png', 'gif', 'grv')), |
123 CHECK (avatar_type IN ('jpg', 'png', 'gif', 'grv')), |
124 PRIMARY KEY (user_id) |
124 PRIMARY KEY (user_id) |