You are viewing a plain text version of this content. The canonical link for it is here.
Posted to cvs@cocoon.apache.org by un...@apache.org on 2003/10/30 18:01:19 UTC
cvs commit: cocoon-2.1/src/blocks/databases/conf cocoondb.script
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