create_tables.pgsql
changeset 67 e4d25f50164d
parent 63 9b627307f4a8
child 71 4c94ba297698
equal deleted inserted replaced
66:995d538a6eb5 67:e4d25f50164d
    81         REFERENCES transport (tid)
    81         REFERENCES transport (tid)
    82 );
    82 );
    83 
    83 
    84 CREATE TABLE alias (
    84 CREATE TABLE alias (
    85     gid         bigint NOT NULL,
    85     gid         bigint NOT NULL,
    86     address     varchar(256) NOT NULL,
    86     address     varchar(64) NOT NULL,-- only localpart w/o '@'
    87     destination varchar(320) NOT NULL,
    87     destination varchar(320) NOT NULL,
    88     CONSTRAINT  pkey_alias PRIMARY KEY (gid, address, destination),
    88     CONSTRAINT  pkey_alias PRIMARY KEY (gid, address, destination),
    89     CONSTRAINT  fkey_alias_gid_domain_data FOREIGN KEY (gid)
    89     CONSTRAINT  fkey_alias_gid_domain_data FOREIGN KEY (gid)
    90         REFERENCES domain_data (gid)
    90         REFERENCES domain_data (gid)
    91 );
    91 );