CREATE TABLE ITEM(ITEM_ID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(100),DESCRIPTION VARCHAR(1000),INITIAL_PRICE FLOAT,RESERVE_PRICE FLOAT,START_DATETIME TIMESTAMP NOT NULL,END_DATETIME TIMESTAMP NOT NULL,SUCCESSFUL_BID_ID BIGINT,SELLER_ID BIGINT NOT NULL,LAST_UPDATED TIMESTAMP NOT NULL)
CREATE TABLE USER(USER_ID BIGINT NOT NULL PRIMARY KEY,HANDLE VARCHAR(10) NOT NULL,NAME VARCHAR(100) NOT NULL,PASSWORD VARCHAR(16) NOT NULL)
CREATE TABLE BID(BID_ID BIGINT NOT NULL PRIMARY KEY,AMOUNT FLOAT NOT NULL,CREATED_DATETIME TIMESTAMP NOT NULL,BUYER_ID BIGINT NOT NULL,ITEM_ID BIGINT NOT NULL,CONSTRAINT BID_BUYER FOREIGN KEY(BUYER_ID) REFERENCES USER(USER_ID),CONSTRAINT BID_ITEM FOREIGN KEY(ITEM_ID) REFERENCES ITEM(ITEM_ID))
ALTER TABLE ITEM ADD CONSTRAINT ITEM_SUCCESSFUL_BID FOREIGN KEY(SUCCESSFUL_BID_ID) REFERENCES BID(BID_ID)
ALTER TABLE ITEM ADD CONSTRAINT ITEM_SELLER FOREIGN KEY(SELLER_ID) REFERENCES USER(USER_ID)
CREATE USER SA PASSWORD "" ADMIN
INSERT INTO ITEM VALUES(1,'Hibernate in Action','good condition',50.0E0,100.0E0,'2003-09-24 00:00:00.0','2003-09-24 00:00:00.0',3,1,'2003-09-24 00:00:00.0')
INSERT INTO ITEM VALUES(2,'Introduction to C++','extremely dated',2.0E0,2.0E0,'2003-09-24 00:00:00.0','2003-09-24 00:00:00.0',NULL,1,'2003-09-24 00:00:00.0')
INSERT INTO USER VALUES(1,'oney','Gavin King','hibernate')
INSERT INTO USER VALUES(2,'turin','Christian Bauer','hibernate')
INSERT INTO USER VALUES(3,'dchannon','David Channon','middlegen')
INSERT INTO BID VALUES(1,51.5E0,'2003-09-24 00:00:00.0',2,1)
INSERT INTO BID VALUES(2,100.0E0,'2003-09-24 00:00:00.0',2,1)
INSERT INTO BID VALUES(3,120.0E0,'2003-09-24 00:00:00.0',2,1)
INSERT INTO BID VALUES(4,1.5E0,'2003-09-24 00:00:00.0',1,2)