CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE ADDRESS(ID BIGINT NOT NULL PRIMARY KEY,HOUSENUM INTEGER,STNAME VARCHAR(25))
CREATE MEMORY TABLE CUSTOMER(CUSTID BIGINT NOT NULL PRIMARY KEY,FIRSTNME VARCHAR(255),LASTNAME VARCHAR(255),HOMEPHONE VARCHAR(255),REGDATE DATE,ADDR_ID BIGINT,CONSTRAINT FK27FBE3FE1DBEF1D7 FOREIGN KEY(ADDR_ID) REFERENCES ADDRESS(ID))
CREATE MEMORY TABLE HIBERNATE_SEQUENCES(SEQUENCE_NAME VARCHAR(255),SEQUENCE_NEXT_HI_VALUE INTEGER)
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 20
SET SCHEMA PUBLIC
INSERT INTO ADDRESS VALUES(1,10,'Main Street')
INSERT INTO ADDRESS VALUES(2,1001,'Main Street')
INSERT INTO ADDRESS VALUES(3,19,'Western Avenue')
INSERT INTO CUSTOMER VALUES(1,'John','Locke','045-232-2323','0016-12-26',1)
INSERT INTO CUSTOMER VALUES(2,'Sarah','Smith','045-132-0789','0016-12-26',2)
INSERT INTO CUSTOMER VALUES(3,'Robin','Wright','045-909-3482','0016-12-26',3)
