ebourg 2004/09/23 05:05:33
Modified: configuration/conf testdb.script
Log:
Cleaning
Revision Changes Path
1.3 +1 -232 jakarta-commons/configuration/conf/testdb.script
Index: testdb.script
===================================================================
RCS file: /home/cvs/jakarta-commons/configuration/conf/testdb.script,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- testdb.script 24 Jul 2004 16:26:10 -0000 1.2
+++ testdb.script 23 Sep 2004 12:05:31 -0000 1.3
@@ -1,6 +1,7 @@
CREATE TABLE CONFIGURATION(KEY VARCHAR NOT NULL PRIMARY KEY,VALUE VARCHAR)
CREATE TABLE CONFIGURATIONS(NAME VARCHAR NOT NULL,KEY VARCHAR NOT NULL,VALUE
VARCHAR,CONSTRAINT SYS_PK_CONFIGURATIONS PRIMARY KEY(NAME,KEY))
CREATE TABLE CONFIGURATIONLIST(ID VARCHAR NOT NULL PRIMARY KEY, KEY VARCHAR NOT
NULL,VALUE VARCHAR)
+
GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
CREATE USER SA PASSWORD "" ADMIN
@@ -72,235 +73,3 @@
CREATE ALIAS LENGTH FOR "org.hsqldb.Library.length"
CREATE ALIAS ROUND FOR "org.hsqldb.Library.round"
CREATE ALIAS REPLACE FOR "org.hsqldb.Library.replace"
-INSERT INTO CONFIGURATION VALUES('key1','value1')
-INSERT INTO CONFIGURATION VALUES('key2','value2')
-INSERT INTO CONFIGURATIONS VALUES('test','key1','value1')
-INSERT INTO CONFIGURATIONS VALUES('test','key2','value2')
-/*C1*/CONNECT USER sa PASSWORD ""
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key1'
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key2'
-DELETE FROM CONFIGURATION WHERE KEY='key1'
-DELETE FROM CONFIGURATION WHERE KEY='key2'
-INSERT INTO CONFIGURATION VALUES('key1','value1')
-INSERT INTO CONFIGURATION VALUES('key2','value2')
-INSERT INTO CONFIGURATIONS VALUES('test','key1','value1')
-INSERT INTO CONFIGURATIONS VALUES('test','key2','value2')
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-INSERT INTO CONFIGURATION VALUES('key','value')
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-/*C2*/CONNECT USER sa PASSWORD ""
-CONNECT USER sa PASSWORD ""
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key1'
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key2'
-DELETE FROM CONFIGURATION WHERE KEY='key'
-DELETE FROM CONFIGURATION WHERE KEY='key1'
-DELETE FROM CONFIGURATION WHERE KEY='key2'
-INSERT INTO CONFIGURATION VALUES('key1','value1')
-INSERT INTO CONFIGURATION VALUES('key2','value2')
-INSERT INTO CONFIGURATIONS VALUES('test','key1','value1')
-INSERT INTO CONFIGURATIONS VALUES('test','key2','value2')
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-INSERT INTO CONFIGURATIONS VALUES('test','key','value')
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-/*C3*/CONNECT USER sa PASSWORD ""
-CONNECT USER sa PASSWORD ""
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key'
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key1'
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key2'
-DELETE FROM CONFIGURATION WHERE KEY='key1'
-DELETE FROM CONFIGURATION WHERE KEY='key2'
-INSERT INTO CONFIGURATION VALUES('key1','value1')
-INSERT INTO CONFIGURATION VALUES('key2','value2')
-INSERT INTO CONFIGURATIONS VALUES('test','key1','value1')
-INSERT INTO CONFIGURATIONS VALUES('test','key2','value2')
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-/*C4*/CONNECT USER sa PASSWORD ""
-CONNECT USER sa PASSWORD ""
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key1'
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key2'
-DELETE FROM CONFIGURATION WHERE KEY='key1'
-DELETE FROM CONFIGURATION WHERE KEY='key2'
-INSERT INTO CONFIGURATION VALUES('key1','value1')
-INSERT INTO CONFIGURATION VALUES('key2','value2')
-INSERT INTO CONFIGURATIONS VALUES('test','key1','value1')
-INSERT INTO CONFIGURATIONS VALUES('test','key2','value2')
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-/*C5*/CONNECT USER sa PASSWORD ""
-CONNECT USER sa PASSWORD ""
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key1'
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key2'
-DELETE FROM CONFIGURATION WHERE KEY='key1'
-DELETE FROM CONFIGURATION WHERE KEY='key2'
-INSERT INTO CONFIGURATION VALUES('key1','value1')
-INSERT INTO CONFIGURATION VALUES('key2','value2')
-INSERT INTO CONFIGURATIONS VALUES('test','key1','value1')
-INSERT INTO CONFIGURATIONS VALUES('test','key2','value2')
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-/*C6*/CONNECT USER sa PASSWORD ""
-CONNECT USER sa PASSWORD ""
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key1'
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key2'
-DELETE FROM CONFIGURATION WHERE KEY='key1'
-DELETE FROM CONFIGURATION WHERE KEY='key2'
-INSERT INTO CONFIGURATION VALUES('key1','value1')
-INSERT INTO CONFIGURATION VALUES('key2','value2')
-INSERT INTO CONFIGURATIONS VALUES('test','key1','value1')
-INSERT INTO CONFIGURATIONS VALUES('test','key2','value2')
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-/*C7*/CONNECT USER sa PASSWORD ""
-CONNECT USER sa PASSWORD ""
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key1'
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key2'
-DELETE FROM CONFIGURATION WHERE KEY='key1'
-DELETE FROM CONFIGURATION WHERE KEY='key2'
-INSERT INTO CONFIGURATION VALUES('key1','value1')
-INSERT INTO CONFIGURATION VALUES('key2','value2')
-INSERT INTO CONFIGURATIONS VALUES('test','key1','value1')
-INSERT INTO CONFIGURATIONS VALUES('test','key2','value2')
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-/*C8*/CONNECT USER sa PASSWORD ""
-CONNECT USER sa PASSWORD ""
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key1'
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key2'
-DELETE FROM CONFIGURATION WHERE KEY='key1'
-DELETE FROM CONFIGURATION WHERE KEY='key2'
-INSERT INTO CONFIGURATION VALUES('key1','value1')
-INSERT INTO CONFIGURATION VALUES('key2','value2')
-INSERT INTO CONFIGURATIONS VALUES('test','key1','value1')
-INSERT INTO CONFIGURATIONS VALUES('test','key2','value2')
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-/*C9*/CONNECT USER sa PASSWORD ""
-CONNECT USER sa PASSWORD ""
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key1'
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key2'
-DELETE FROM CONFIGURATION WHERE KEY='key1'
-DELETE FROM CONFIGURATION WHERE KEY='key2'
-INSERT INTO CONFIGURATION VALUES('key1','value1')
-INSERT INTO CONFIGURATION VALUES('key2','value2')
-INSERT INTO CONFIGURATIONS VALUES('test','key1','value1')
-INSERT INTO CONFIGURATIONS VALUES('test','key2','value2')
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-/*C10*/CONNECT USER sa PASSWORD ""
-CONNECT USER sa PASSWORD ""
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key1'
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key2'
-DELETE FROM CONFIGURATION WHERE KEY='key1'
-DELETE FROM CONFIGURATION WHERE KEY='key2'
-INSERT INTO CONFIGURATION VALUES('key1','value1')
-INSERT INTO CONFIGURATION VALUES('key2','value2')
-INSERT INTO CONFIGURATIONS VALUES('test','key1','value1')
-INSERT INTO CONFIGURATIONS VALUES('test','key2','value2')
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-/*C11*/CONNECT USER sa PASSWORD ""
-CONNECT USER sa PASSWORD ""
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key1'
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key2'
-DELETE FROM CONFIGURATION WHERE KEY='key1'
-DELETE FROM CONFIGURATION WHERE KEY='key2'
-INSERT INTO CONFIGURATION VALUES('key1','value1')
-INSERT INTO CONFIGURATION VALUES('key2','value2')
-INSERT INTO CONFIGURATIONS VALUES('test','key1','value1')
-INSERT INTO CONFIGURATIONS VALUES('test','key2','value2')
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-/*C12*/CONNECT USER sa PASSWORD ""
-CONNECT USER sa PASSWORD ""
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key1'
-DELETE FROM CONFIGURATIONS WHERE NAME='test' AND KEY='key2'
-DELETE FROM CONFIGURATION WHERE KEY='key1'
-DELETE FROM CONFIGURATION WHERE KEY='key2'
-INSERT INTO CONFIGURATION VALUES('key1','value1')
-INSERT INTO CONFIGURATION VALUES('key2','value2')
-INSERT INTO CONFIGURATIONS VALUES('test','key1','value1')
-INSERT INTO CONFIGURATIONS VALUES('test','key2','value2')
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
-SET AUTOCOMMIT TRUE
-SET READONLY FALSE
-SET AUTOCOMMIT TRUE
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
