0853e1e2522c1ac17f697221758bcbd4781a7ff9ndCREATE SCHEMA PUBLIC AUTHORIZATION DBA
0853e1e2522c1ac17f697221758bcbd4781a7ff9ndCREATE CACHED TABLE ITEM(ID CHAR(8),NAME VARCHAR(100),MANU VARCHAR(50),WEIGHT REAL,PRICE REAL,POPULARITY INTEGER,INCLUDES VARCHAR(200),LAST_MODIFIED TIMESTAMP DEFAULT NOW)
0853e1e2522c1ac17f697221758bcbd4781a7ff9ndCREATE CACHED TABLE FEATURE(ITEM_ID CHAR(8),DESCRIPTION VARCHAR(200),LAST_MODIFIED TIMESTAMP DEFAULT NOW)
0853e1e2522c1ac17f697221758bcbd4781a7ff9ndCREATE CACHED TABLE CATEGORY(ID INTEGER,DESCRIPTION VARCHAR(30),LAST_MODIFIED TIMESTAMP DEFAULT NOW)
0853e1e2522c1ac17f697221758bcbd4781a7ff9ndCREATE CACHED TABLE ITEM_CATEGORY(ITEM_ID CHAR(8),CATEGORY_ID INTEGER,LAST_MODIFIED TIMESTAMP DEFAULT NOW)
0853e1e2522c1ac17f697221758bcbd4781a7ff9ndSET TABLE ITEM INDEX'15056 0'
0853e1e2522c1ac17f697221758bcbd4781a7ff9ndSET TABLE FEATURE INDEX'22424 0'
0853e1e2522c1ac17f697221758bcbd4781a7ff9ndSET TABLE CATEGORY INDEX'18856 0'
0853e1e2522c1ac17f697221758bcbd4781a7ff9ndSET TABLE ITEM_CATEGORY INDEX'17328 0'
0853e1e2522c1ac17f697221758bcbd4781a7ff9ndCREATE USER SA PASSWORD ""
0853e1e2522c1ac17f697221758bcbd4781a7ff9ndGRANT DBA TO SA
0853e1e2522c1ac17f697221758bcbd4781a7ff9ndSET WRITE_DELAY 20