Displaying 1 result from an estimated 1 matches for "fk_alias1".
Did you mean:
fk_alias2
2011 Oct 10
1
To query two SQL tables for user verification over LMTP, should I use (a) two separate lookups? or (b) just one lookup with a boolean query?
...er (
userid TINYINT,
user VARCHAR(64),
domain VARCHAR(128),
password VARCHAR(64),
PRIMARY KEY (userid),
UNIQUE (user,domain)
);
CREATE TABLE alias (
aliasid TINYINT,
alias VARCHAR(64),
user VARCHAR(64),
domain VARCHAR(128),
PRIMARY KEY (aliasid),
UNIQUE (domain,user,alias),
CONSTRAINT fk_alias1 FOREIGN KEY (user) REFERENCES user (user) ON
DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT fk_alias2 FOREIGN KEY (domain) REFERENCES user (domain) ON
DELETE NO ACTION ON UPDATE NO ACTION
);
With flat file and just one table, 'users', I get how to setup LMTP. I
can get Postfix deliv...