haul 01/11/19 08:06:34 Modified: webapp/WEB-INF/db cocoondb.properties cocoondb.script Log: some additional tables Revision Changes Path 1.4 +1 -1 xml-cocoon2/webapp/WEB-INF/db/cocoondb.properties Index: cocoondb.properties =================================================================== RCS file: /home/cvs/xml-cocoon2/webapp/WEB-INF/db/cocoondb.properties,v retrieving revision 1.3 retrieving revision 1.4 diff -u -r1.3 -r1.4 --- cocoondb.properties 2001/10/01 14:03:56 1.3 +++ cocoondb.properties 2001/11/19 16:06:33 1.4 @@ -1,4 +1,4 @@ #HSQL database -#Mon Oct 01 11:28:21 CEST 2001 +#Mon Nov 19 17:19:34 CET 2001 version=1.6 modified=no 1.2 +80 -76 xml-cocoon2/webapp/WEB-INF/db/cocoondb.script Index: cocoondb.script =================================================================== RCS file: /home/cvs/xml-cocoon2/webapp/WEB-INF/db/cocoondb.script,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- cocoondb.script 2001/05/09 20:50:09 1.1 +++ cocoondb.script 2001/11/19 16:06:34 1.2 @@ -1,76 +1,80 @@ -CREATE TABLE DEPARTMENT_TABLE(ID INTEGER,NAME VARCHAR,UNIQUE(ID)) -CREATE TABLE EMPLOYEE_TABLE(ID INTEGER,DEPARTMENT_ID INTEGER,NAME VARCHAR,UNIQUE(ID)) -GRANT ALL ON CLASS "org.hsqldb.Library" TO PUBLIC -GRANT ALL ON CLASS "java.lang.Math" TO PUBLIC -CREATE USER SA PASSWORD "" ADMIN -CREATE ALIAS DAYNAME FOR "org.hsqldb.Library.dayname" -CREATE ALIAS SPACE FOR "org.hsqldb.Library.space" -CREATE ALIAS SUBSTRING FOR "org.hsqldb.Library.substring" -CREATE ALIAS SQRT FOR "java.lang.Math.sqrt" -CREATE ALIAS ABS FOR "java.lang.Math.abs" -CREATE ALIAS POWER FOR "java.lang.Math.pow" -CREATE ALIAS CHAR FOR "org.hsqldb.Library.character" -CREATE ALIAS CONCAT FOR "org.hsqldb.Library.concat" -CREATE ALIAS PI FOR "org.hsqldb.Library.pi" -CREATE ALIAS SECOND FOR "org.hsqldb.Library.second" -CREATE ALIAS TRUNCATE FOR "org.hsqldb.Library.truncate" -CREATE ALIAS MONTH FOR "org.hsqldb.Library.month" -CREATE ALIAS LOWER FOR "org.hsqldb.Library.lcase" -CREATE ALIAS ATAN2 FOR "java.lang.Math.atan2" -CREATE ALIAS REPEAT FOR "org.hsqldb.Library.repeat" -CREATE ALIAS DAYOFMONTH FOR "org.hsqldb.Library.dayofmonth" -CREATE ALIAS TAN FOR "java.lang.Math.tan" -CREATE ALIAS RADIANS FOR "java.lang.Math.toRadians" -CREATE ALIAS FLOOR FOR "java.lang.Math.floor" -CREATE ALIAS NOW FOR "org.hsqldb.Library.now" -CREATE ALIAS ACOS FOR "java.lang.Math.acos" -CREATE ALIAS DAYOFWEEK FOR "org.hsqldb.Library.dayofweek" -CREATE ALIAS CEILING FOR "java.lang.Math.ceil" -CREATE ALIAS DAYOFYEAR FOR "org.hsqldb.Library.dayofyear" -CREATE ALIAS LCASE FOR "org.hsqldb.Library.lcase" -CREATE ALIAS WEEK FOR "org.hsqldb.Library.week" -CREATE ALIAS SOUNDEX FOR "org.hsqldb.Library.soundex" -CREATE ALIAS ASIN FOR "java.lang.Math.asin" -CREATE ALIAS LOCATE FOR "org.hsqldb.Library.locate" -CREATE ALIAS EXP FOR "java.lang.Math.exp" -CREATE ALIAS MONTHNAME FOR "org.hsqldb.Library.monthname" -CREATE ALIAS YEAR FOR "org.hsqldb.Library.year" -CREATE ALIAS LEFT FOR "org.hsqldb.Library.left" -CREATE ALIAS ROUNDMAGIC FOR "org.hsqldb.Library.roundMagic" -CREATE ALIAS BITOR FOR "org.hsqldb.Library.bitor" -CREATE ALIAS LTRIM FOR "org.hsqldb.Library.ltrim" -CREATE ALIAS COT FOR "org.hsqldb.Library.cot" -CREATE ALIAS COS FOR "java.lang.Math.cos" -CREATE ALIAS MOD FOR "org.hsqldb.Library.mod" -CREATE ALIAS SIGN FOR "org.hsqldb.Library.sign" -CREATE ALIAS DEGREES FOR "java.lang.Math.toDegrees" -CREATE ALIAS LOG FOR "java.lang.Math.log" -CREATE ALIAS SIN FOR "java.lang.Math.sin" -CREATE ALIAS CURTIME FOR "org.hsqldb.Library.curtime" -CREATE ALIAS DIFFERENCE FOR "org.hsqldb.Library.difference" -CREATE ALIAS INSERT FOR "org.hsqldb.Library.insert" -CREATE ALIAS DATABASE FOR "org.hsqldb.Library.database" -CREATE ALIAS MINUTE FOR "org.hsqldb.Library.minute" -CREATE ALIAS HOUR FOR "org.hsqldb.Library.hour" -CREATE ALIAS IDENTITY FOR "org.hsqldb.Library.identity" -CREATE ALIAS QUARTER FOR "org.hsqldb.Library.quarter" -CREATE ALIAS CURDATE FOR "org.hsqldb.Library.curdate" -CREATE ALIAS BITAND FOR "org.hsqldb.Library.bitand" -CREATE ALIAS USER FOR "org.hsqldb.Library.user" -CREATE ALIAS UCASE FOR "org.hsqldb.Library.ucase" -CREATE ALIAS RTRIM FOR "org.hsqldb.Library.rtrim" -CREATE ALIAS LOG10 FOR "org.hsqldb.Library.log10" -CREATE ALIAS RIGHT FOR "org.hsqldb.Library.right" -CREATE ALIAS ATAN FOR "java.lang.Math.atan" -CREATE ALIAS UPPER FOR "org.hsqldb.Library.ucase" -CREATE ALIAS ASCII FOR "org.hsqldb.Library.ascii" -CREATE ALIAS RAND FOR "java.lang.Math.random" -CREATE ALIAS LENGTH FOR "org.hsqldb.Library.length" -CREATE ALIAS ROUND FOR "org.hsqldb.Library.round" -CREATE ALIAS REPLACE FOR "org.hsqldb.Library.replace" -INSERT INTO DEPARTMENT_TABLE VALUES(1,'Programmers') -INSERT INTO DEPARTMENT_TABLE VALUES(2,'Loungers') -INSERT INTO EMPLOYEE_TABLE VALUES(1,1,'Donald Ball') -INSERT INTO EMPLOYEE_TABLE VALUES(2,1,'Stefano Mazzocchi') -INSERT INTO EMPLOYEE_TABLE VALUES(3,2,'Pierpaolo Fumagalli') -INSERT INTO EMPLOYEE_TABLE VALUES(4,2,'Davanum Srinivas') +CREATE TABLE DEPARTMENT_TABLE(ID INTEGER,NAME VARCHAR,UNIQUE(ID)) +CREATE TABLE EMPLOYEE_TABLE(ID INTEGER,DEPARTMENT_ID INTEGER,NAME VARCHAR,UNIQUE(ID)) +CREATE TABLE USER(UID INTEGER IDENTITY PRIMARY KEY,NAME VARCHAR,SURNAME 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 "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" +CREATE ALIAS SUBSTRING FOR "org.hsqldb.Library.substring" +CREATE ALIAS SQRT FOR "java.lang.Math.sqrt" +CREATE ALIAS ABS FOR "java.lang.Math.abs" +CREATE ALIAS POWER FOR "java.lang.Math.pow" +CREATE ALIAS CHAR FOR "org.hsqldb.Library.character" +CREATE ALIAS CONCAT FOR "org.hsqldb.Library.concat" +CREATE ALIAS PI FOR "org.hsqldb.Library.pi" +CREATE ALIAS SECOND FOR "org.hsqldb.Library.second" +CREATE ALIAS TRUNCATE FOR "org.hsqldb.Library.truncate" +CREATE ALIAS MONTH FOR "org.hsqldb.Library.month" +CREATE ALIAS LOWER FOR "org.hsqldb.Library.lcase" +CREATE ALIAS ATAN2 FOR "java.lang.Math.atan2" +CREATE ALIAS REPEAT FOR "org.hsqldb.Library.repeat" +CREATE ALIAS DAYOFMONTH FOR "org.hsqldb.Library.dayofmonth" +CREATE ALIAS TAN FOR "java.lang.Math.tan" +CREATE ALIAS RADIANS FOR "java.lang.Math.toRadians" +CREATE ALIAS FLOOR FOR "java.lang.Math.floor" +CREATE ALIAS NOW FOR "org.hsqldb.Library.now" +CREATE ALIAS ACOS FOR "java.lang.Math.acos" +CREATE ALIAS DAYOFWEEK FOR "org.hsqldb.Library.dayofweek" +CREATE ALIAS CEILING FOR "java.lang.Math.ceil" +CREATE ALIAS DAYOFYEAR FOR "org.hsqldb.Library.dayofyear" +CREATE ALIAS LCASE FOR "org.hsqldb.Library.lcase" +CREATE ALIAS WEEK FOR "org.hsqldb.Library.week" +CREATE ALIAS SOUNDEX FOR "org.hsqldb.Library.soundex" +CREATE ALIAS ASIN FOR "java.lang.Math.asin" +CREATE ALIAS LOCATE FOR "org.hsqldb.Library.locate" +CREATE ALIAS EXP FOR "java.lang.Math.exp" +CREATE ALIAS MONTHNAME FOR "org.hsqldb.Library.monthname" +CREATE ALIAS YEAR FOR "org.hsqldb.Library.year" +CREATE ALIAS LEFT FOR "org.hsqldb.Library.left" +CREATE ALIAS ROUNDMAGIC FOR "org.hsqldb.Library.roundMagic" +CREATE ALIAS BITOR FOR "org.hsqldb.Library.bitor" +CREATE ALIAS LTRIM FOR "org.hsqldb.Library.ltrim" +CREATE ALIAS COT FOR "org.hsqldb.Library.cot" +CREATE ALIAS COS FOR "java.lang.Math.cos" +CREATE ALIAS MOD FOR "org.hsqldb.Library.mod" +CREATE ALIAS SIGN FOR "org.hsqldb.Library.sign" +CREATE ALIAS DEGREES FOR "java.lang.Math.toDegrees" +CREATE ALIAS LOG FOR "java.lang.Math.log" +CREATE ALIAS SIN FOR "java.lang.Math.sin" +CREATE ALIAS CURTIME FOR "org.hsqldb.Library.curtime" +CREATE ALIAS DIFFERENCE FOR "org.hsqldb.Library.difference" +CREATE ALIAS INSERT FOR "org.hsqldb.Library.insert" +CREATE ALIAS SUBSTR FOR "org.hsql.Library.substring" +CREATE ALIAS DATABASE FOR "org.hsqldb.Library.database" +CREATE ALIAS MINUTE FOR "org.hsqldb.Library.minute" +CREATE ALIAS HOUR FOR "org.hsqldb.Library.hour" +CREATE ALIAS IDENTITY FOR "org.hsqldb.Library.identity" +CREATE ALIAS QUARTER FOR "org.hsqldb.Library.quarter" +CREATE ALIAS CURDATE FOR "org.hsqldb.Library.curdate" +CREATE ALIAS BITAND FOR "org.hsqldb.Library.bitand" +CREATE ALIAS USER FOR "org.hsqldb.Library.user" +CREATE ALIAS UCASE FOR "org.hsqldb.Library.ucase" +CREATE ALIAS RTRIM FOR "org.hsqldb.Library.rtrim" +CREATE ALIAS LOG10 FOR "org.hsqldb.Library.log10" +CREATE ALIAS RIGHT FOR "org.hsqldb.Library.right" +CREATE ALIAS ATAN FOR "java.lang.Math.atan" +CREATE ALIAS UPPER FOR "org.hsqldb.Library.ucase" +CREATE ALIAS ASCII FOR "org.hsqldb.Library.ascii" +CREATE ALIAS RAND FOR "java.lang.Math.random" +CREATE ALIAS LENGTH FOR "org.hsqldb.Library.length" +CREATE ALIAS ROUND FOR "org.hsqldb.Library.round" +CREATE ALIAS REPLACE FOR "org.hsqldb.Library.replace" +INSERT INTO DEPARTMENT_TABLE VALUES(1,'Programmers') +INSERT INTO DEPARTMENT_TABLE VALUES(2,'Loungers') +INSERT INTO EMPLOYEE_TABLE VALUES(1,1,'Donald Ball') +INSERT INTO EMPLOYEE_TABLE VALUES(2,1,'Stefano Mazzocchi') +INSERT INTO EMPLOYEE_TABLE VALUES(3,2,'Pierpaolo Fumagalli') +INSERT INTO EMPLOYEE_TABLE VALUES(4,2,'Davanum Srinivas')
---------------------------------------------------------------------- In case of troubles, e-mail: [EMAIL PROTECTED] To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
