equal
deleted
inserted
replaced
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 ); |