nicolaken 02/04/19 05:44:19
Modified: src/webapp/WEB-INF/db cocoondb.properties cocoondb.script
Log:
Additions to the DB samples for the new POI samples.
Revision Changes Path
1.2 +2 -2 xml-cocoon2/src/webapp/WEB-INF/db/cocoondb.properties
Index: cocoondb.properties
===================================================================
RCS file: /home/cvs/xml-cocoon2/src/webapp/WEB-INF/db/cocoondb.properties,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- cocoondb.properties 3 Jan 2002 12:31:39 -0000 1.1
+++ cocoondb.properties 19 Apr 2002 12:44:19 -0000 1.2
@@ -1,4 +1,4 @@
#HSQL database
-#Fri Nov 23 11:13:29 CET 2001
+#Sat Apr 13 23:06:03 EDT 2002
version=1.6
-modified=no
+modified=yes
1.2 +67 -1 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.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- cocoondb.script 3 Jan 2002 12:31:39 -0000 1.1
+++ cocoondb.script 19 Apr 2002 12:44:19 -0000 1.2
@@ -3,8 +3,9 @@
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))
-GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
+CREATE TABLE STATE_TAX(CATEGORY VARCHAR NOT NULL,GROSSTAX_COLLECTED DOUBLE NOT
NULL,NETTAX_COLLECTED DOUBLE NOT NULL,YEAR INTEGER NOT NULL)
GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC
+GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC
CREATE USER SA PASSWORD "" ADMIN
CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname"
CREATE ALIAS SPACE FOR "org.hsqldb.Library.space"
@@ -80,5 +81,70 @@
INSERT INTO EMPLOYEE VALUES(3,2,'Pierpaolo Fumagalli')
INSERT INTO EMPLOYEE VALUES(4,3,'Torsten Curdt')
INSERT INTO EMPLOYEE VALUES(5,2,'Davanum Srinivas')
+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.0,718624.0,2000)
+INSERT INTO STATE_TAX VALUES('State Personal
Income',8.983891961E9,8.084576329E9,2000)
+INSERT INTO STATE_TAX VALUES('Corporation
Franchise',1.219484766E9,1.029883951E9,2000)
+INSERT INTO STATE_TAX VALUES('Motor Vehicle Fuel',1.418996649E9,1.404945725E9,2000)
+INSERT INTO STATE_TAX VALUES('Public Utility Excise',7.04245493E8,6.75339746E8,2000)
+INSERT INTO STATE_TAX VALUES('Kilowatt-Hour Excise',0.0,0.0,2000)
+INSERT INTO STATE_TAX VALUES('Cigarette Excise',2.89795508E8,2.87710095E8,2000)
+INSERT INTO STATE_TAX VALUES('Dealers in Intangibles',5055311.0,2.2333722E7,2000)
+INSERT INTO STATE_TAX VALUES('Motor Fuel Use',2.2615436E7,6.6889345E7,2000)
+INSERT INTO STATE_TAX VALUES('Alchoholic Beverage
Excise',5.6125329E7,5.5993783E7,2000)
+INSERT INTO STATE_TAX VALUES('Replacement Tire Fee',3339367.0,3339367.0,2000)
+INSERT INTO STATE_TAX VALUES('Local Alchoholic Beverage',6284465.0,5851787.0,2000)
+INSERT INTO STATE_TAX VALUES('Horse Racing',1.6582056E7,1.7321198E7,2000)
+INSERT INTO STATE_TAX VALUES('Severance',8295336.0,7981539.0,2000)
+INSERT INTO STATE_TAX VALUES('School District
Income',1.50083042E8,1.61257059E8,2000)
+INSERT INTO STATE_TAX VALUES('State Sales And Use',6.287758244E9,6.23711041E9,2001)
+INSERT INTO STATE_TAX VALUES('Local Sales And Use',1.352436625E9,1.352436625E9,2001)
+INSERT INTO STATE_TAX VALUES('Resort Area Excise',719420.0,719420.0,2001)
+INSERT INTO STATE_TAX VALUES('State Personal
Income',9.221429278E9,8.119314587E9,2001)
+INSERT INTO STATE_TAX VALUES('Corporation
Franchise',1.158910767E9,9.72967198E8,2001)
+INSERT INTO STATE_TAX VALUES('Motor Vehicle Fuel',1.325132798E9,1.307275001E9,2001)
+INSERT INTO STATE_TAX VALUES('Public Utility Excise',6.91925015E8,6.7431469E8,2001)
+INSERT INTO STATE_TAX VALUES('Kilowatt-Hour Excise',3.8026261E7,3.8026261E7,2001)
+INSERT INTO STATE_TAX VALUES('Cigarette Excise',2.83978172E8,2.82481419E8,2001)
+INSERT INTO STATE_TAX VALUES('Dealers in Intangibles',2.4913075E7,2.4881108E7,2001)
+INSERT INTO STATE_TAX VALUES('Motor Fuel Use',7.5662992E7,7.5311561E7,2001)
+INSERT INTO STATE_TAX VALUES('Alchoholic Beverage
Excise',5.5862063E7,5.5740722E7,2001)
+INSERT INTO STATE_TAX VALUES('Replacement Tire Fee',3470795.0,3470795.0,2001)
+INSERT INTO STATE_TAX VALUES('Local Alchoholic Beverage',5851787.0,5851787.0,2001)
+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)
/*C3*/CONNECT USER sa PASSWORD ""
/*C4*/CONNECT USER sa PASSWORD ""
+SET AUTOCOMMIT TRUE
+CONNECT USER sa PASSWORD ""
+/*C5*/CONNECT USER sa PASSWORD ""
+SET AUTOCOMMIT TRUE
+CONNECT USER sa PASSWORD ""
+/*C6*/CONNECT USER sa PASSWORD ""
+SET AUTOCOMMIT TRUE
+CONNECT USER sa PASSWORD ""
+/*C7*/CONNECT USER sa PASSWORD ""
+SET AUTOCOMMIT TRUE
+CONNECT USER sa PASSWORD ""
+/*C8*/CONNECT USER sa PASSWORD ""
+SET AUTOCOMMIT TRUE
+CONNECT USER sa PASSWORD ""
+/*C9*/CONNECT USER sa PASSWORD ""
+SET AUTOCOMMIT TRUE
+CONNECT USER sa PASSWORD ""
+/*C10*/CONNECT USER sa PASSWORD ""
+SET AUTOCOMMIT TRUE
+CONNECT USER sa PASSWORD ""
+/*C11*/CONNECT USER sa PASSWORD ""
+SET AUTOCOMMIT TRUE
+CONNECT USER sa PASSWORD ""
+/*C12*/CONNECT USER sa PASSWORD ""
+SET AUTOCOMMIT TRUE
+CONNECT USER sa PASSWORD ""
+/*C13*/CONNECT USER sa PASSWORD ""
+SET AUTOCOMMIT TRUE
+CONNECT USER sa PASSWORD ""
+/*C14*/CONNECT USER sa PASSWORD ""
+SET AUTOCOMMIT TRUE
----------------------------------------------------------------------
In case of troubles, e-mail: [EMAIL PROTECTED]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
