equal
deleted
inserted
replaced
48 fid bigint NOT NULL DEFAULT 1, |
48 fid bigint NOT NULL DEFAULT 1, |
49 directory varchar(20) NOT NULL, |
49 directory varchar(20) NOT NULL, |
50 extra varchar(1024), |
50 extra varchar(1024), |
51 CONSTRAINT pkey_maillocation PRIMARY KEY (mid), |
51 CONSTRAINT pkey_maillocation PRIMARY KEY (mid), |
52 CONSTRAINT fkey_maillocation_fid_mailboxformat FOREIGN KEY (fid) |
52 CONSTRAINT fkey_maillocation_fid_mailboxformat FOREIGN KEY (fid) |
53 REFERENCES mailboxformat (fid); |
53 REFERENCES mailboxformat (fid) |
54 ); |
54 ); |
55 -- Insert default Maildir-folder name |
55 -- Insert default Maildir-folder name |
56 INSERT INTO maillocation(directory) VALUES ('Maildir'); |
56 INSERT INTO maillocation(directory) VALUES ('Maildir'); |
57 |
57 |
58 CREATE TABLE domain_data ( |
58 CREATE TABLE domain_data ( |