104   user_lang smallint(5) NOT NULL DEFAULT 1,

   104   user_lang smallint(5) NOT NULL DEFAULT 1,

   105   user_has_avatar tinyint(1) NOT NULL DEFAULT 0,

   105   user_has_avatar tinyint(1) NOT NULL DEFAULT 0,

   106   avatar_type ENUM('jpg', 'png', 'gif') NOT NULL DEFAULT 'png',

   106   avatar_type ENUM('jpg', 'png', 'gif') NOT NULL DEFAULT 'png',

   107   user_registration_ip varchar(39),

   107   user_registration_ip varchar(39),

   108   user_rank int(12) UNSIGNED NOT NULL DEFAULT 1,

   108   user_rank int(12) UNSIGNED NOT NULL DEFAULT 1,

   109   PRIMARY KEY  (user_id)

   110   PRIMARY KEY  (user_id)

   110 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;

   111 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;

   111 

   112 

   112 CREATE TABLE {{TABLE_PREFIX}}users_extra(

   113 CREATE TABLE {{TABLE_PREFIX}}users_extra(

   113   user_id mediumint(8) NOT NULL,

   114   user_id mediumint(8) NOT NULL,