diff options
Diffstat (limited to 'isuifang_solr/example-DIH/hsqldb/ex.script')
| -rw-r--r-- | isuifang_solr/example-DIH/hsqldb/ex.script | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/isuifang_solr/example-DIH/hsqldb/ex.script b/isuifang_solr/example-DIH/hsqldb/ex.script new file mode 100644 index 0000000..6b151f4 --- /dev/null +++ b/isuifang_solr/example-DIH/hsqldb/ex.script @@ -0,0 +1,12 @@ +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 |