pgsql/create_tables.pgsql
branchv0.7.x
changeset 724 348cd2cf9c18
parent 723 0cdd5e37f723
equal deleted inserted replaced
723:0cdd5e37f723 724:348cd2cf9c18
    32     transport   varchar(270) NOT NULL, -- smtps:[255-char.host.name:50025]
    32     transport   varchar(270) NOT NULL, -- smtps:[255-char.host.name:50025]
    33     CONSTRAINT  pkey_transport PRIMARY KEY (tid),
    33     CONSTRAINT  pkey_transport PRIMARY KEY (tid),
    34     CONSTRAINT  ukey_transport UNIQUE (transport)
    34     CONSTRAINT  ukey_transport UNIQUE (transport)
    35 );
    35 );
    36 -- Insert default transport
    36 -- Insert default transport
    37 INSERT INTO transport(transport) VALUES ('dovecot:');
    37 INSERT INTO transport(transport) VALUES ('lmtp:unix:private/dovecot-lmtp');
    38 
    38 
    39 CREATE TABLE mailboxformat (
    39 CREATE TABLE mailboxformat (
    40     fid         bigint NOT NULL DEFAULT nextval('mailboxformat_id'),
    40     fid         bigint NOT NULL DEFAULT nextval('mailboxformat_id'),
    41     format      varchar(20) NOT NULL,
    41     format      varchar(20) NOT NULL,
    42     CONSTRAINT  pkey_mailboxformat PRIMARY KEY (fid),
    42     CONSTRAINT  pkey_mailboxformat PRIMARY KEY (fid),