install/schemas/postgresql_stage2.sql
changeset 770 62fed244fa1c
parent 711 f70d764aab33
child 776 f37b60d393bc
equal deleted inserted replaced
769:1946d845bb25 770:62fed244fa1c
   110   user_lang smallint NOT NULL,
   110   user_lang smallint NOT NULL,
   111   user_has_avatar smallint NOT NULL,
   111   user_has_avatar smallint NOT NULL,
   112   avatar_type varchar(3) NOT NULL,
   112   avatar_type varchar(3) NOT NULL,
   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_rank_userset smallint NOT NULL DEFAULT 0,
   115   user_timezone int NOT NULL DEFAULT 0,
   116   user_timezone int NOT NULL DEFAULT 0,
   116   user_title varchar(64) DEFAULT NULL,
   117   user_title varchar(64) DEFAULT NULL,
   117   user_group int NOT NULL DEFAULT 1,
   118   user_group int NOT NULL DEFAULT 1,
   118   user_dst varchar(11) NOT NULL DEFAULT '0;0;0;0;60',
   119   user_dst varchar(11) NOT NULL DEFAULT '0;0;0;0;60',
   119   CHECK (avatar_type IN ('jpg', 'png', 'gif', 'grv')),
   120   CHECK (avatar_type IN ('jpg', 'png', 'gif', 'grv')),