db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From arm...@apache.org
Subject cvs commit: db-ojb/src/test/org/apache/ojb/faraway-db OJB_FarAway.script
Date Wed, 13 Aug 2003 17:57:01 GMT
arminw      2003/08/13 10:57:01

  Modified:    src/test/org/apache/ojb/faraway-db OJB_FarAway.script
  Log:
  add new table
  
  Revision  Changes    Path
  1.6       +73 -72    db-ojb/src/test/org/apache/ojb/faraway-db/OJB_FarAway.script
  
  Index: OJB_FarAway.script
  ===================================================================
  RCS file: /home/cvs/db-ojb/src/test/org/apache/ojb/faraway-db/OJB_FarAway.script,v
  retrieving revision 1.5
  retrieving revision 1.6
  diff -u -r1.5 -r1.6
  --- OJB_FarAway.script	1 Apr 2003 14:06:11 -0000	1.5
  +++ OJB_FarAway.script	13 Aug 2003 17:57:01 -0000	1.6
  @@ -8,75 +8,76 @@
   CREATE TABLE OJB_DSET(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
   CREATE TABLE OJB_DSET_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DLIST_ID INTEGER,POSITION_
INTEGER,OID_ LONGVARBINARY)
   CREATE TABLE OJB_DMAP(ID INTEGER NOT NULL PRIMARY KEY,SIZE_ INTEGER)
  -CREATE TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID INTEGER,KEY_OID LONGVARBINARY,VALUE_OID
LONGVARBINARY)
  -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 HEXTORAW FOR "org.hsqldb.Library.hexToRaw"
  -CREATE ALIAS SQRT FOR "java.lang.Math.sqrt"
  -CREATE ALIAS ABS FOR "org.hsqldb.Library.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 RAWTOHEX FOR "org.hsqldb.Library.rawToHex"
  -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.hsqldb.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"
  +CREATE TABLE OJB_DMAP_ENTRIES(ID INTEGER NOT NULL PRIMARY KEY,DMAP_ID INTEGER,KEY_OID LONGVARBINARY,VALUE_OID
LONGVARBINARY)
  +CREATE TABLE SM_KEY(INT_KEY INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(250),STRING_KEY VARCHAR(250),LONG_KEY
BIGINT,INTEGER_KEY INTEGER)
  +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 HEXTORAW FOR "org.hsqldb.Library.hexToRaw"
  +CREATE ALIAS SQRT FOR "java.lang.Math.sqrt"
  +CREATE ALIAS ABS FOR "org.hsqldb.Library.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 RAWTOHEX FOR "org.hsqldb.Library.rawToHex"
  +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.hsqldb.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"
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org


Mime
View raw message