install/schemas/mysql_stage2.sql
changeset 711 f70d764aab33
parent 685 17ebe24cdf85
child 770 62fed244fa1c
equal deleted inserted replaced
710:1fbce408813c 711:f70d764aab33
   113   user_registration_ip varchar(39),
   113   user_registration_ip varchar(39),
   114   user_rank int(12) UNSIGNED DEFAULT NULL,
   114   user_rank int(12) UNSIGNED DEFAULT NULL,
   115   user_timezone int(12) UNSIGNED NOT NULL DEFAULT 0,
   115   user_timezone int(12) UNSIGNED NOT NULL DEFAULT 0,
   116   user_title varchar(64) DEFAULT NULL,
   116   user_title varchar(64) DEFAULT NULL,
   117   user_group mediumint(5) NOT NULL DEFAULT 1,
   117   user_group mediumint(5) NOT NULL DEFAULT 1,
       
   118   user_dst varchar(11) NOT NULL DEFAULT '0;0;0;0;60',
   118   PRIMARY KEY  (user_id)
   119   PRIMARY KEY  (user_id)
   119 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   120 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   120 
   121 
   121 CREATE TABLE {{TABLE_PREFIX}}users_extra(
   122 CREATE TABLE {{TABLE_PREFIX}}users_extra(
   122   user_id mediumint(8) NOT NULL,
   123   user_id mediumint(8) NOT NULL,