install/schemas/mysql_stage2.sql
changeset 1159 a1cca4472a58
parent 1081 745200a9cc2a
child 1170 71cb87b7dc3f
equal deleted inserted replaced
1158:e733f984c990 1159:a1cca4472a58
   114   user_has_avatar tinyint(1) NOT NULL DEFAULT 0,
   114   user_has_avatar tinyint(1) NOT NULL DEFAULT 0,
   115   avatar_type ENUM('jpg', 'png', 'gif', 'grv') NOT NULL DEFAULT 'png',
   115   avatar_type ENUM('jpg', 'png', 'gif', 'grv') NOT NULL DEFAULT 'png',
   116   user_registration_ip varchar(39),
   116   user_registration_ip varchar(39),
   117   user_rank int(12) UNSIGNED DEFAULT NULL,
   117   user_rank int(12) UNSIGNED DEFAULT NULL,
   118   user_rank_userset tinyint(1) NOT NULL DEFAULT 0,
   118   user_rank_userset tinyint(1) NOT NULL DEFAULT 0,
   119   user_timezone int(12) UNSIGNED NOT NULL DEFAULT 0,
   119   user_timezone int(12) UNSIGNED NOT NULL DEFAULT 1440,
   120   user_title varchar(64) DEFAULT NULL,
   120   user_title varchar(64) DEFAULT NULL,
   121   user_group mediumint(5) NOT NULL DEFAULT 1,
   121   user_group mediumint(5) 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   PRIMARY KEY  (user_id)
   123   PRIMARY KEY  (user_id)
   124 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   124 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;