102 gid bigint NOT NULL DEFAULT nextval('domain_gid'), |
102 gid bigint NOT NULL DEFAULT nextval('domain_gid'), |
103 qid bigint NOT NULL DEFAULT 1, -- default quota limit |
103 qid bigint NOT NULL DEFAULT 1, -- default quota limit |
104 ssid bigint NOT NULL DEFAULT 1, -- default service set |
104 ssid bigint NOT NULL DEFAULT 1, -- default service set |
105 tid bigint NOT NULL DEFAULT 1, -- default transport |
105 tid bigint NOT NULL DEFAULT 1, -- default transport |
106 domaindir varchar(40) NOT NULL, --/srv/mail/$RAND/4294967294 |
106 domaindir varchar(40) NOT NULL, --/srv/mail/$RAND/4294967294 |
107 note varchar NULL DEFAULT NULL, |
107 note text NULL DEFAULT NULL, |
108 CONSTRAINT pkey_domain_data PRIMARY KEY (gid), |
108 CONSTRAINT pkey_domain_data PRIMARY KEY (gid), |
109 CONSTRAINT fkey_domain_data_qid_quotalimit FOREIGN KEY (qid) |
109 CONSTRAINT fkey_domain_data_qid_quotalimit FOREIGN KEY (qid) |
110 REFERENCES quotalimit (qid), |
110 REFERENCES quotalimit (qid), |
111 CONSTRAINT fkey_domain_data_ssid_service_set FOREIGN KEY (ssid) |
111 CONSTRAINT fkey_domain_data_ssid_service_set FOREIGN KEY (ssid) |
112 REFERENCES service_set (ssid), |
112 REFERENCES service_set (ssid), |
131 gid bigint NOT NULL, |
131 gid bigint NOT NULL, |
132 mid bigint NOT NULL DEFAULT 1, |
132 mid bigint NOT NULL DEFAULT 1, |
133 qid bigint NULL DEFAULT NULL, |
133 qid bigint NULL DEFAULT NULL, |
134 ssid bigint NULL DEFAULT NULL, |
134 ssid bigint NULL DEFAULT NULL, |
135 tid bigint NULL DEFAULT NULL, |
135 tid bigint NULL DEFAULT NULL, |
136 note varchar NULL DEFAULT NULL, |
136 note text NULL DEFAULT NULL, |
137 CONSTRAINT pkey_users PRIMARY KEY (local_part, gid), |
137 CONSTRAINT pkey_users PRIMARY KEY (local_part, gid), |
138 CONSTRAINT ukey_users_uid UNIQUE (uid), |
138 CONSTRAINT ukey_users_uid UNIQUE (uid), |
139 CONSTRAINT fkey_users_gid_domain_data FOREIGN KEY (gid) |
139 CONSTRAINT fkey_users_gid_domain_data FOREIGN KEY (gid) |
140 REFERENCES domain_data (gid), |
140 REFERENCES domain_data (gid), |
141 CONSTRAINT fkey_users_mid_maillocation FOREIGN KEY (mid) |
141 CONSTRAINT fkey_users_mid_maillocation FOREIGN KEY (mid) |