Diff of /cocoon/branches/BRANCH_2_1_X/src/blocks/hsqldb/conf/cocoondb.script

Parent Directory | Revision Log | Patch

--- cocoon/branches/BRANCH_2_1_X/src/blocks/hsqldb/samples/WEB-INF/db/cocoondb.script	2005/05/02 17:11:59	165647
+++ cocoon/branches/BRANCH_2_1_X/src/blocks/hsqldb/conf/cocoondb.script	2005/05/03 18:22:14	167951
@@ -12,32 +12,35 @@
 -- See the License for the specific language governing permissions and
 -- limitations under the License.
 
-CREATE TABLE DEPARTMENT(ID INTEGER NOT NULL,NAME VARCHAR NOT NULL,CONSTRAINT SYS_CT_1 UNIQUE(ID))
-CREATE TABLE EMPLOYEE(ID INTEGER NOT NULL,DEPARTMENT_ID INTEGER NOT NULL,NAME VARCHAR NOT NULL,CONSTRAINT SYS_CT_3 UNIQUE(ID))
-CREATE TABLE USER(UID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,NAME VARCHAR,FIRSTNAME VARCHAR,UNAME VARCHAR,CONSTRAINT SYS_CT_5 UNIQUE(UNAME))
-CREATE TABLE GROUPS(GID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,GNAME VARCHAR,CONSTRAINT SYS_CT_7 UNIQUE(GNAME))
-CREATE TABLE USER_GROUPS(UID INTEGER,GID INTEGER,CONSTRAINT SYS_CT_9 UNIQUE(UID,GID),CONSTRAINT SYS_FK_10 FOREIGN KEY(UID) REFERENCES USER(UID),CONSTRAINT SYS_FK_11 FOREIGN KEY(GID) REFERENCES GROUPS(GID))
+CREATE TABLE DEPARTMENT(ID INTEGER NOT NULL,NAME VARCHAR NOT NULL,DESCRIPTION VARCHAR NULL,UNIQUE(ID))
+CREATE TABLE EMPLOYEE(ID INTEGER NOT NULL,DEPARTMENT_ID INTEGER NOT NULL,NAME VARCHAR NOT NULL,DESCRIPTION VARCHAR NULL,UNIQUE(ID))
+CREATE TABLE USER(UID INTEGER IDENTITY PRIMARY KEY,NAME VARCHAR,FIRSTNAME VARCHAR,UNAME VARCHAR,UNIQUE(UNAME))
+CREATE TABLE GROUPS(GID INTEGER IDENTITY PRIMARY KEY,GNAME VARCHAR,UNIQUE(GNAME))
+CREATE TABLE USER_GROUPS(UID INTEGER,GID INTEGER,UNIQUE(UID,GID),FOREIGN KEY(UID)REFERENCES USER(UID),FOREIGN KEY(GID)REFERENCES GROUPS(GID))
 CREATE TABLE STATE_TAX(CATEGORY VARCHAR NOT NULL,GROSSTAX_COLLECTED DOUBLE NOT NULL,NETTAX_COLLECTED DOUBLE NOT NULL,YEAR INTEGER NOT NULL)
-CREATE TABLE MEDIA(ID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0)  NOT NULL PRIMARY KEY,IMAGE BINARY,MIMETYPE VARCHAR)
+CREATE TABLE MEDIA(ID INTEGER IDENTITY PRIMARY KEY,IMAGE BINARY,MIMETYPE VARCHAR)
 CREATE TABLE SOURCEPROPS(SOURCE VARCHAR NOT NULL,NAMESPACE VARCHAR NOT NULL,NAME VARCHAR NOT NULL,VALUE VARCHAR NOT NULL,CONSTRAINT SYS_CT_11 UNIQUE(SOURCE,NAMESPACE,NAME))
+CREATE TABLE OJB_HL_SEQ(TABLENAME VARCHAR(175) NOT NULL,FIELDNAME VARCHAR(70) NOT NULL,MAX_KEY BIGINT,GRAB_SIZE INTEGER,VERSION INTEGER,CONSTRAINT SYS_PK_OJB_HL_SEQ PRIMARY KEY(TABLENAME,FIELDNAME))
+CREATE TABLE QUERY(ID BIGINT IDENTITY PRIMARY KEY,USER_ID VARCHAR NOT NULL,Q_DATE TIMESTAMP,Q_BOOL VARCHAR,Q_NAME VARCHAR,Q_TYPE VARCHAR,Q_SIZE BIGINT,UNIQUE(ID))
+CREATE TABLE CRITERION(ID BIGINT IDENTITY PRIMARY KEY,Q_ID BIGINT,C_FIELD VARCHAR,C_MATCH VARCHAR,C_TERM VARCHAR,CONSTRAINT SYS_FK_20 FOREIGN KEY(Q_ID) REFERENCES QUERY(ID),UNIQUE(ID))
 CREATE USER SA PASSWORD "" ADMIN
 SET WRITE_DELAY 60
-INSERT INTO DEPARTMENT VALUES(1,'Development')
-INSERT INTO DEPARTMENT VALUES(2,'Management')
-INSERT INTO DEPARTMENT VALUES(3,'Testers')
-INSERT INTO EMPLOYEE VALUES(1,1,'Donald Ball')
-INSERT INTO EMPLOYEE VALUES(2,1,'Sylvain Wallez')
-INSERT INTO EMPLOYEE VALUES(3,1,'Carsten Ziegeler')
-INSERT INTO EMPLOYEE VALUES(4,1,'Torsten Curdt')
-INSERT INTO EMPLOYEE VALUES(5,1,'Marcus Crafter')
-INSERT INTO EMPLOYEE VALUES(6,1,'Ovidiu Predescu')
-INSERT INTO EMPLOYEE VALUES(7,1,'Christian Haul')
-INSERT INTO EMPLOYEE VALUES(8,2,'Stefano Mazzocchi')
-INSERT INTO EMPLOYEE VALUES(9,3,'Pierpaolo Fumagalli')
-INSERT INTO EMPLOYEE VALUES(10,3,'Davanum Srinivas')
-INSERT INTO EMPLOYEE VALUES(11,3,'Carlos Chávez')
-INSERT INTO EMPLOYEE VALUES(12,3,'Antonio Gallardo')
-INSERT INTO EMPLOYEE VALUES(13,1,'Jeremy Quinn')
+INSERT INTO DEPARTMENT VALUES(1,'Development','<span>Department producing software packages, <i>on time</i>, and <i>bug free</i>.</span>')
+INSERT INTO DEPARTMENT VALUES(2,'Management','<span>Department spending all the budget on <i>meetings</i> and <i>donuts</i>.</span>')
+INSERT INTO DEPARTMENT VALUES(3,'Testers','<span>Department capable of finding issues in <i>bug free</i> software packages.</span>')
+INSERT INTO EMPLOYEE VALUES(1,1,'Donald Ball','')
+INSERT INTO EMPLOYEE VALUES(2,1,'Sylvain Wallez','')
+INSERT INTO EMPLOYEE VALUES(3,1,'Carsten Ziegeler','')
+INSERT INTO EMPLOYEE VALUES(4,1,'Torsten Curdt','')
+INSERT INTO EMPLOYEE VALUES(5,1,'Marcus Crafter','')
+INSERT INTO EMPLOYEE VALUES(6,1,'Ovidiu Predescu','')
+INSERT INTO EMPLOYEE VALUES(7,1,'Christian Haul','')
+INSERT INTO EMPLOYEE VALUES(8,2,'Stefano Mazzocchi','')
+INSERT INTO EMPLOYEE VALUES(9,3,'Pierpaolo Fumagalli','')
+INSERT INTO EMPLOYEE VALUES(10,3,'Davanum Srinivas','')
+INSERT INTO EMPLOYEE VALUES(11,3,'Carlos Chávez','')
+INSERT INTO EMPLOYEE VALUES(12,3,'Antonio Gallardo','')
+INSERT INTO EMPLOYEE VALUES(13,1,'Jeremy Quinn','')
 INSERT INTO STATE_TAX VALUES('State Sales And Use',6.263250997E9,6.213961851E9,2000)
 INSERT INTO STATE_TAX VALUES('Local Sales And Use',1.321129345E9,1.321129345E9,2000)
 INSERT INTO STATE_TAX VALUES('Resort Area Excise',718624.0E0,718624.0E0,2000)
@@ -72,3 +75,5 @@ INSERT INTO STATE_TAX VALUES('Local Alch
 INSERT INTO STATE_TAX VALUES('Horse Racing',1.7921198E7,1.7321198E7,2001)
 INSERT INTO STATE_TAX VALUES('Severance',7981539.0E0,7967438.0E0,2001)
 INSERT INTO STATE_TAX VALUES('School District Income',1.61257059E8,1.53238001E8,2001)
+INSERT INTO QUERY VALUES(1,'anon','1970-01-01 01:00:00.0',NULL,'test','simple',20)
+INSERT INTO CRITERION VALUES(1,1,'any','any','cocoon')