[OpenEMed-commits] OpenEMed/dist/servers/coas/ojb/config hsqldb_coas.sql, 1.5, 1.6 mysql_coas.sql, 1.10, 1.11

[David F. <dwf...@us...>]

Update of /cvsroot/openmed/OpenEMed/dist/servers/coas/ojb/config
In directory sc8-pr-cvs3.sourceforge.net:/tmp/cvs-serv30311/dist/servers/coas/ojb/config

Modified Files:
	hsqldb_coas.sql mysql_coas.sql 
Log Message:
Updated to ojb1.0.4 for OJB_HL_SEQ table

Index: hsqldb_coas.sql
===================================================================
RCS file: /cvsroot/openmed/OpenEMed/dist/servers/coas/ojb/config/hsqldb_coas.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -C2 -d -r1.5 -r1.6
*** hsqldb_coas.sql	8 Sep 2003 15:50:27 -0000	1.5
--- hsqldb_coas.sql	4 Nov 2006 04:54:31 -0000	1.6
***************
*** 81,85 ****
      valueId  NUMERIC NOT NULL PRIMARY KEY,
      units    VARCHAR(256),
!     aValue    NUMERIC
  );
  
--- 81,85 ----
      valueId  NUMERIC NOT NULL PRIMARY KEY,
      units    VARCHAR(256),
!     aValue    REAL
  );
  
***************
*** 109,114 ****
      valueId  NUMERIC NOT NULL PRIMARY KEY,
      units    VARCHAR(256),
!     lower    FLOAT,
!     upper    FLOAT
  );
  
--- 109,114 ----
      valueId  NUMERIC NOT NULL PRIMARY KEY,
      units    VARCHAR(256),
!     lower    REAL,
!     upper    REAL
  );
  
***************
*** 152,160 ****
  CREATE TABLE OJB_HL_SEQ (
    TABLENAME    VARCHAR(175) NOT NULL,
-   FIELDNAME    VARCHAR(70) NOT NULL,
    MAX_KEY      INT,
    GRAB_SIZE    INT,
    VERSION	INT,
!   PRIMARY KEY (TABLENAME, FIELDNAME)
  );
  DROP TABLE OJB_NRM;
--- 152,159 ----
  CREATE TABLE OJB_HL_SEQ (
    TABLENAME    VARCHAR(175) NOT NULL,
    MAX_KEY      INT,
    GRAB_SIZE    INT,
    VERSION	INT,
!   PRIMARY KEY (TABLENAME)
  );
  DROP TABLE OJB_NRM;

Index: mysql_coas.sql
===================================================================
RCS file: /cvsroot/openmed/OpenEMed/dist/servers/coas/ojb/config/mysql_coas.sql,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** mysql_coas.sql	13 Sep 2006 04:22:01 -0000	1.10
--- mysql_coas.sql	4 Nov 2006 04:54:31 -0000	1.11
***************
*** 81,85 ****
      valueId  NUMERIC NOT NULL PRIMARY KEY,
      units    VARCHAR(255),
!     aValue    FLOAT
  );
  
--- 81,85 ----
      valueId  NUMERIC NOT NULL PRIMARY KEY,
      units    VARCHAR(255),
!     aValue    REAL
  );
  
***************
*** 109,114 ****
      valueId  NUMERIC NOT NULL PRIMARY KEY,
      units    VARCHAR(255),
!     lower    FLOAT,
!     upper    FLOAT
  );
  
--- 109,114 ----
      valueId  NUMERIC NOT NULL PRIMARY KEY,
      units    VARCHAR(255),
!     lower    REAL,
!     upper    REAL
  );