[interchange-cvs] interchange - jon modified dist/foundation/dbconf/oracle/country.ora

interchange-core@interchange.redhat.com interchange-core@interchange.redhat.com
Mon Feb 11 22:16:01 2002


User:      jon
Date:      2002-02-12 03:15:44 GMT
Modified:  dist/foundation/dbconf/oracle country.ora
Log:
Avoid Oracle constraint errors where empty string looks like NULL.

Revision  Changes    Path
2.1       +2 -2      interchange/dist/foundation/dbconf/oracle/country.ora


rev 2.1, prev_rev 2.0
Index: country.ora
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/oracle/country.ora,v
retrieving revision 2.0
retrieving revision 2.1
diff -u -u -r2.0 -r2.1
--- country.ora	18 Jul 2001 02:20:55 -0000	2.0
+++ country.ora	12 Feb 2002 03:15:44 -0000	2.1
@@ -11,6 +11,6 @@
 Database  country  COLUMN_DEF   "selector=VARCHAR2(3)"
 Database  country  COLUMN_DEF   "shipmodes=VARCHAR2(64)"
 Database  country  COLUMN_DEF   "name=VARCHAR2(32) DEFAULT ''"
-Database  country  COLUMN_DEF   "iso=CHAR(3) DEFAULT '' NOT NULL"
-Database  country  COLUMN_DEF   "isonum=CHAR(3) DEFAULT '' NOT NULL"
+Database  country  COLUMN_DEF   "iso=CHAR(3) DEFAULT ''"
+Database  country  COLUMN_DEF   "isonum=CHAR(3) DEFAULT ''"
 Database  country  INDEX         name