haul 2003/01/31 08:30:48
Modified: src/webapp/WEB-INF/db cocoondb.script
Log:
new table for file upload sample
Revision Changes Path
1.10 +1 -14 xml-cocoon2/src/webapp/WEB-INF/db/cocoondb.script
Index: cocoondb.script
===================================================================
RCS file: /home/cvs/xml-cocoon2/src/webapp/WEB-INF/db/cocoondb.script,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -r1.9 -r1.10
--- cocoondb.script 4 Dec 2002 21:44:15 -0000 1.9
+++ cocoondb.script 31 Jan 2003 16:30:48 -0000 1.10
@@ -4,6 +4,7 @@
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 IDENTITY PRIMARY KEY,IMAGE BINARY,MIMETYPE VARCHAR)
GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
CREATE USER SA PASSWORD "" ADMIN
@@ -121,17 +122,3 @@
INSERT INTO STATE_TAX VALUES('Horse Racing',1.7921198E7,1.7321198E7,2001)
INSERT INTO STATE_TAX VALUES('Severance',7981539.0,7967438.0,2001)
INSERT INTO STATE_TAX VALUES('School District
Income',1.61257059E8,1.53238001E8,2001)
-/*C1*/CONNECT USER sa PASSWORD ""
-/*C2*/CONNECT USER sa PASSWORD ""
-/*C3*/CONNECT USER sa PASSWORD ""
-/*C4*/CONNECT USER sa PASSWORD ""
-/*C5*/CONNECT USER sa PASSWORD ""
-/*C6*/CONNECT USER sa PASSWORD ""
-/*C7*/CONNECT USER sa PASSWORD ""
-/*C8*/CONNECT USER sa PASSWORD ""
-/*C9*/CONNECT USER sa PASSWORD ""
-/*C10*/CONNECT USER sa PASSWORD ""
-/*C11*/CONNECT USER sa PASSWORD ""
-/*C12*/CONNECT USER sa PASSWORD ""
-/*C13*/CONNECT USER sa PASSWORD ""
-/*C14*/CONNECT USER sa PASSWORD ""
----------------------------------------------------------------------
In case of troubles, e-mail: [EMAIL PROTECTED]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
