Sha256: faa1ce2a92133bac37c21b220a31a21af04c0cf94f4243430e5ca50470966f27

Contents?: true

Size: 723 Bytes

Versions: 3

Compression:

Stored size: 723 Bytes

Contents

CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE 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)
CREATE CACHED TABLE FEATURE(ITEM_ID CHAR(8),DESCRIPTION VARCHAR(200),LAST_MODIFIED TIMESTAMP DEFAULT NOW)
CREATE CACHED TABLE CATEGORY(ID INTEGER,DESCRIPTION VARCHAR(30),LAST_MODIFIED TIMESTAMP DEFAULT NOW)
CREATE CACHED TABLE ITEM_CATEGORY(ITEM_ID CHAR(8),CATEGORY_ID INTEGER,LAST_MODIFIED TIMESTAMP DEFAULT NOW)
SET TABLE ITEM INDEX'15056 0'
SET TABLE FEATURE INDEX'22424 0'
SET TABLE CATEGORY INDEX'18856 0'
SET TABLE ITEM_CATEGORY INDEX'17328 0'
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 20

Version data entries

3 entries across 3 versions & 2 rubygems

Version Path
solrsrv-1.0.1 apache-solr-1.4.0/example-DIH/hsqldb/ex.script
solrsrv-1.0.0 apache-solr-1.4.0/example-DIH/hsqldb/ex.script
tanning_bed_solr-0.0.1 vendor/solr/example-DIH/hsqldb/ex.script