[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