CREATE TABLE guest
(
	guestID		INT,
	firstName	CHAR(20),
	lastName	CHAR(20),
	email		CHAR(80),
	url		CHAR(200),
	country		CHAR(40),
	entryDate	DATE,
	comments	TEXT(80)
)\g

CREATE SEQUENCE ON guest STEP 1 VALUE 10000\g

CREATE UNIQUE INDEX guestPriKey ON guest(guestID)\g
