pgsql/create_tables-dovecot-1.2.x.pgsql
branchv0.6.x
changeset 368 be4bd77dbe57
parent 297 e21ceaabe871
child 382 5e6bcb2e010e
equal deleted inserted replaced
367:a6ad9895989d 368:be4bd77dbe57
    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 (