install/schemas/postgresql_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 DEFAULT NULL,
   114   user_rank int DEFAULT NULL,
   115   user_timezone int NOT NULL DEFAULT 0,
   115   user_timezone int NOT NULL DEFAULT 0,
   116   user_title varchar(64) DEFAULT NULL,
   116   user_title varchar(64) DEFAULT NULL,
   117   user_group int NOT NULL DEFAULT 1,
   117   user_group int NOT NULL DEFAULT 1,
       
   118   user_dst varchar(11) NOT NULL DEFAULT '0;0;0;0;60',
   118   CHECK (avatar_type IN ('jpg', 'png', 'gif', 'grv')),
   119   CHECK (avatar_type IN ('jpg', 'png', 'gif', 'grv')),
   119   PRIMARY KEY  (user_id)
   120   PRIMARY KEY  (user_id)
   120 );
   121 );
   121 
   122 
   122 CREATE TABLE {{TABLE_PREFIX}}users_extra(
   123 CREATE TABLE {{TABLE_PREFIX}}users_extra(