equal
deleted
inserted
replaced
39 -- Insert default Maildir-folder name |
39 -- Insert default Maildir-folder name |
40 INSERT INTO maillocation(maillocation) VALUES ('Maildir'); |
40 INSERT INTO maillocation(maillocation) VALUES ('Maildir'); |
41 |
41 |
42 CREATE TABLE domain_data ( |
42 CREATE TABLE domain_data ( |
43 gid bigint NOT NULL DEFAULT nextval('domain_gid'), |
43 gid bigint NOT NULL DEFAULT nextval('domain_gid'), |
44 tid bigint NOT NULL DEFAULT 1, -- defualt transport |
44 tid bigint NOT NULL DEFAULT 1, -- default transport |
45 domaindir varchar(40) NOT NULL, --/srv/mail/$RAND/4294967294 |
45 domaindir varchar(40) NOT NULL, --/srv/mail/$RAND/4294967294 |
46 CONSTRAINT pkey_domain_data PRIMARY KEY (gid), |
46 CONSTRAINT pkey_domain_data PRIMARY KEY (gid), |
47 CONSTRAINT fkey_domain_data_tid_transport FOREIGN KEY (tid) |
47 CONSTRAINT fkey_domain_data_tid_transport FOREIGN KEY (tid) |
48 REFERENCES transport (tid) |
48 REFERENCES transport (tid) |
49 ); |
49 ); |