diff options
Diffstat (limited to 'isuifang_solr/example-DIH/hsqldb')
| -rw-r--r-- | isuifang_solr/example-DIH/hsqldb/ex.backup | bin | 0 -> 11354 bytes | |||
| -rw-r--r-- | isuifang_solr/example-DIH/hsqldb/ex.data | bin | 0 -> 1048576 bytes | |||
| -rw-r--r-- | isuifang_solr/example-DIH/hsqldb/ex.log | 16 | ||||
| -rw-r--r-- | isuifang_solr/example-DIH/hsqldb/ex.properties | 17 | ||||
| -rw-r--r-- | isuifang_solr/example-DIH/hsqldb/ex.script | 12 |
5 files changed, 45 insertions, 0 deletions
diff --git a/isuifang_solr/example-DIH/hsqldb/ex.backup b/isuifang_solr/example-DIH/hsqldb/ex.backup Binary files differnew file mode 100644 index 0000000..7471d1f --- /dev/null +++ b/isuifang_solr/example-DIH/hsqldb/ex.backup diff --git a/isuifang_solr/example-DIH/hsqldb/ex.data b/isuifang_solr/example-DIH/hsqldb/ex.data Binary files differnew file mode 100644 index 0000000..dac9b13 --- /dev/null +++ b/isuifang_solr/example-DIH/hsqldb/ex.data diff --git a/isuifang_solr/example-DIH/hsqldb/ex.log b/isuifang_solr/example-DIH/hsqldb/ex.log new file mode 100644 index 0000000..8320f00 --- /dev/null +++ b/isuifang_solr/example-DIH/hsqldb/ex.log @@ -0,0 +1,16 @@ +/*C2*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +/*C3*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +/*C4*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +/*C5*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +/*C3*/DISCONNECT +/*C5*/DISCONNECT +/*C4*/DISCONNECT +/*C2*/DISCONNECT diff --git a/isuifang_solr/example-DIH/hsqldb/ex.properties b/isuifang_solr/example-DIH/hsqldb/ex.properties new file mode 100644 index 0000000..6177a75 --- /dev/null +++ b/isuifang_solr/example-DIH/hsqldb/ex.properties @@ -0,0 +1,17 @@ +#HSQL Database Engine 1.8.0.10 +#Mon Dec 13 17:24:59 PST 2010 +hsqldb.script_format=0 +runtime.gc_interval=0 +sql.enforce_strict_size=false +hsqldb.cache_size_scale=8 +readonly=false +hsqldb.nio_data_file=true +hsqldb.cache_scale=14 +version=1.8.0 +hsqldb.default_table_type=memory +hsqldb.cache_file_scale=1 +hsqldb.log_size=200 +modified=yes +hsqldb.cache_version=1.7.0 +hsqldb.original_version=1.8.0 +hsqldb.compatible_version=1.8.0 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 |