Displaying 1 result from an estimated 1 matches for "fk_alias2".
Did you mean:
fk_alias1
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?
...,
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 delivering/rejecting over LMTP depending on if the user
exists in the Dovecot passdb or not.
I don't get ho...