equal
deleted
inserted
replaced
4 |
4 |
5 CREATE SEQUENCE transport_id; |
5 CREATE SEQUENCE transport_id; |
6 |
6 |
7 CREATE SEQUENCE mailboxformat_id; |
7 CREATE SEQUENCE mailboxformat_id; |
8 |
8 |
|
9 CREATE SEQUENCE maillocation_id; |
|
10 |
9 CREATE SEQUENCE quotalimit_id; |
11 CREATE SEQUENCE quotalimit_id; |
10 |
|
11 CREATE SEQUENCE maillocation_id; |
|
12 |
12 |
13 CREATE SEQUENCE service_set_id; |
13 CREATE SEQUENCE service_set_id; |
14 |
14 |
15 CREATE SEQUENCE domain_gid |
15 CREATE SEQUENCE domain_gid |
16 START WITH 70000 |
16 START WITH 70000 |
99 \. |
99 \. |
100 |
100 |
101 CREATE TABLE domain_data ( |
101 CREATE TABLE domain_data ( |
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 text 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) |