install/schemas/postgresql_stage2.sql
changeset 734 904fbf10f112
parent 711 f70d764aab33
child 770 62fed244fa1c
equal deleted inserted replaced
712:331e009416d5 734:904fbf10f112
   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(