51 name varchar(128) NULL, |
51 name varchar(128) NULL, |
52 uid bigint NOT NULL DEFAULT nextval('users_uid'), |
52 uid bigint NOT NULL DEFAULT nextval('users_uid'), |
53 gid bigint NOT NULL, |
53 gid bigint NOT NULL, |
54 mid bigint NOT NULL DEFAULT 1, |
54 mid bigint NOT NULL DEFAULT 1, |
55 tid bigint NOT NULL DEFAULT 1, |
55 tid bigint NOT NULL DEFAULT 1, |
56 smpt boolean NOT NULL DEFAULT TRUE, |
56 smtp boolean NOT NULL DEFAULT TRUE, |
57 pop3 boolean NOT NULL DEFAULT TRUE, |
57 pop3 boolean NOT NULL DEFAULT TRUE, |
58 imap boolean NOT NULL DEFAULT TRUE, |
58 imap boolean NOT NULL DEFAULT TRUE, |
59 managesieve boolean NOT NULL DEFAULT TRUE, |
59 managesieve boolean NOT NULL DEFAULT TRUE, |
60 CONSTRAINT pkye_users PRIMARY KEY (local_part, gid), |
60 CONSTRAINT pkye_users PRIMARY KEY (local_part, gid), |
61 CONSTRAINT ukey_users_uid UNIQUE (uid), |
61 CONSTRAINT ukey_users_uid UNIQUE (uid), |