unico 2003/10/30 09:01:19
Modified: src/blocks/databases/conf cocoondb.script Log: add table for use by SimpleJdbSourceDescriptor in repository block. Revision Changes Path 1.2 +1 -0 cocoon-2.1/src/blocks/databases/conf/cocoondb.script Index: cocoondb.script =================================================================== RCS file: /home/cvs/cocoon-2.1/src/blocks/databases/conf/cocoondb.script,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- cocoondb.script 12 Mar 2003 11:08:58 -0000 1.1 +++ cocoondb.script 30 Oct 2003 17:01:19 -0000 1.2 @@ -5,6 +5,7 @@ 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 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)) GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC CREATE USER SA PASSWORD "" ADMIN
