createdb bordeauxDB
psql bordeauxDB

CREATE TABLE Userinfo ( userID varchar(16) UNIQUE NOT NULL, password varchar(16) NOT NULL, firstname varchar(16) NOT NULL, lastname varchar(16) NOT NULL, emailaddress varchar(32) UNIQUE NOT NULL, CONSTRAINT userKey PRIMARY KEY (userID));
                                                                     ^
INSERT INTO Userinfo VALUES ('KingBombadil', 'winner', 'Thomas', 'Brereton', '2k00l4sk1@msn.com');
INSERT INTO Userinfo VALUES ('Sproglet', 'winner', 'Lois', 'Holman', 'climbergurrrrrrl94@hotmail.co.uk')
INSERT INTO Userinfo VALUES ('SirDavos', 'chicken', 'Alexander', 'Davenport', 'greeniepeenieprincess_xx@aol.com');
INSERT INTO Userinfo VALUES ('GuitarHero', 'dinner', 'Lloyd', 'Carswell', 'roxursoxtiludrop92@aol.com');