On Mon, Jul 23, 2007 at 11:02:49PM +0100, Chris Jones wrote: > CREATE TABLE doorcards ( > cardnumber integer NOT NULL UNIQUE, > uid integer REFERENCES members NOT NULL > ); Probably wants some kind of type field as well to make it easier for us (if not the door software) to tell the difference between mag swipe and rfid tags