69 tid bigint NOT NULL DEFAULT 1, |
69 tid bigint NOT NULL DEFAULT 1, |
70 smtp boolean NOT NULL DEFAULT TRUE, |
70 smtp boolean NOT NULL DEFAULT TRUE, |
71 pop3 boolean NOT NULL DEFAULT TRUE, |
71 pop3 boolean NOT NULL DEFAULT TRUE, |
72 imap boolean NOT NULL DEFAULT TRUE, |
72 imap boolean NOT NULL DEFAULT TRUE, |
73 managesieve boolean NOT NULL DEFAULT TRUE, |
73 managesieve boolean NOT NULL DEFAULT TRUE, |
74 CONSTRAINT pkye_users PRIMARY KEY (local_part, gid), |
74 CONSTRAINT pkey_users PRIMARY KEY (local_part, gid), |
75 CONSTRAINT ukey_users_uid UNIQUE (uid), |
75 CONSTRAINT ukey_users_uid UNIQUE (uid), |
76 CONSTRAINT fkey_users_gid_domain_data FOREIGN KEY (gid) |
76 CONSTRAINT fkey_users_gid_domain_data FOREIGN KEY (gid) |
77 REFERENCES domain_data (gid), |
77 REFERENCES domain_data (gid), |
78 CONSTRAINT fkey_users_mid_maillocation FOREIGN KEY (mid) |
78 CONSTRAINT fkey_users_mid_maillocation FOREIGN KEY (mid) |
79 REFERENCES maillocation (mid), |
79 REFERENCES maillocation (mid), |