pgsql/create_tables.pgsql
branchv0.6.x
changeset 257 5b8fde01e4f0
parent 160 639cf4003965
child 297 e21ceaabe871
equal deleted inserted replaced
256:ae80282301a3 257:5b8fde01e4f0
    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 );