CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE MEMORY TABLE SANDWICH(SANDWICH_ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,SANDWICHNAME VARCHAR(30) NOT NULL,BREAD VARCHAR(30) NOT NULL,MEAT VARCHAR(30) NOT NULL,SPREAD VARCHAR(30) NOT NULL,TYPE VARCHAR(30) NOT NULL)
ALTER TABLE SANDWICH ALTER COLUMN SANDWICH_ID RESTART WITH 18
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 20
SET SCHEMA PUBLIC
INSERT INTO SANDWICH VALUES(1,'Dagwood','Hogie','Hot Beef','Mayo','Cold')
INSERT INTO SANDWICH VALUES(2,'Crooks','Whole Wheat','Tofu Slices','Mustard','Grilled')
INSERT INTO SANDWICH VALUES(3,'Mountain','Sourdough','Turkey','Mayo','Triple Decker')
INSERT INTO SANDWICH VALUES(4,'Pacific','Pumpernickel','Tuna','Mustard','Cold')
INSERT INTO SANDWICH VALUES(5,'Shove','Rye','Pastrami','Thousand Island','Baked')
INSERT INTO SANDWICH VALUES(6,'Gloucester','Whole Wheat','Turkey','Plain','Triple Decker')
