[interchange-cvs] interchange - jon modified 15 files
interchange-core@icdevgroup.org
interchange-core@icdevgroup.org
Fri Dec 13 16:03:00 2002
User: jon
Date: 2002-12-13 21:01:41 GMT
Modified: dist/foundation/dbconf/mysql country.mysql options.mysql
Modified: orderline.mysql transactions.mysql userdb.mysql
Modified: dist/foundation/dbconf/oracle country.ora options.ora
Modified: orderline.ora transactions.ora userdb.ora
Modified: dist/foundation/dbconf/pgsql country.pgsql options.pgsql
Modified: orderline.pgsql transactions.pgsql userdb.pgsql
Log:
Change mv_shipmode to VARCHAR(255) from various smaller sizes.
Revision Changes Path
2.1 +2 -2 interchange/dist/foundation/dbconf/mysql/country.mysql
rev 2.1, prev_rev 2.0
Index: country.mysql
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/mysql/country.mysql,v
retrieving revision 2.0
retrieving revision 2.1
diff -u -u -r2.0 -r2.1
--- country.mysql 18 Jul 2001 02:20:53 -0000 2.0
+++ country.mysql 13 Dec 2002 21:01:40 -0000 2.1
@@ -7,8 +7,8 @@
endif
Database country COLUMN_DEF "code=CHAR(3) NOT NULL PRIMARY KEY"
Database country COLUMN_DEF "selector=CHAR(3)"
-Database country COLUMN_DEF "shipmodes=CHAR(64)"
+Database country COLUMN_DEF "shipmodes=VARCHAR(255)"
Database country COLUMN_DEF "iso=CHAR(3) DEFAULT '' NOT NULL"
Database country COLUMN_DEF "isonum=CHAR(3) DEFAULT '' NOT NULL"
-Database country COLUMN_DEF "name=CHAR(32) DEFAULT '' NOT NULL"
+Database country COLUMN_DEF "name=VARCHAR(32) DEFAULT '' NOT NULL"
Database country INDEX name
2.1 +1 -1 interchange/dist/foundation/dbconf/mysql/options.mysql
rev 2.1, prev_rev 2.0
Index: options.mysql
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/mysql/options.mysql,v
retrieving revision 2.0
retrieving revision 2.1
diff -u -u -r2.0 -r2.1
--- options.mysql 18 Jul 2001 02:20:53 -0000 2.0
+++ options.mysql 13 Dec 2002 21:01:40 -0000 2.1
@@ -25,7 +25,7 @@
Database options COLUMN_DEF "wholesale=varchar(20)"
Database options COLUMN_DEF "volume=varchar(20)"
Database options COLUMN_DEF "weight=varchar(20)"
-Database options COLUMN_DEF "mv_shipmode=varchar(128)"
+Database options COLUMN_DEF "mv_shipmode=varchar(255)"
Database options COLUMN_DEF "o_height=int"
Database options COLUMN_DEF "o_width=int"
2.2 +1 -1 interchange/dist/foundation/dbconf/mysql/orderline.mysql
rev 2.2, prev_rev 2.1
Index: orderline.mysql
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/mysql/orderline.mysql,v
retrieving revision 2.1
retrieving revision 2.2
diff -u -u -r2.1 -r2.2
--- orderline.mysql 17 Oct 2002 04:46:23 -0000 2.1
+++ orderline.mysql 13 Dec 2002 21:01:40 -0000 2.2
@@ -11,7 +11,7 @@
Database orderline COLUMN_DEF "order_number=varchar(14) NOT NULL"
Database orderline COLUMN_DEF "session=varchar(32) NOT NULL"
Database orderline COLUMN_DEF "username=varchar(20) default '' NOT NULL"
-Database orderline COLUMN_DEF "shipmode=varchar(32) default '' NOT NULL"
+Database orderline COLUMN_DEF "shipmode=varchar(255) default '' NOT NULL"
Database orderline COLUMN_DEF "sku=varchar(64) NOT NULL"
Database orderline COLUMN_DEF "quantity=varchar(9) NOT NULL"
Database orderline COLUMN_DEF "price=varchar(12) NOT NULL"
2.4 +1 -1 interchange/dist/foundation/dbconf/mysql/transactions.mysql
rev 2.4, prev_rev 2.3
Index: transactions.mysql
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/mysql/transactions.mysql,v
retrieving revision 2.3
retrieving revision 2.4
diff -u -u -r2.3 -r2.4
--- transactions.mysql 17 Oct 2002 04:46:23 -0000 2.3
+++ transactions.mysql 13 Dec 2002 21:01:40 -0000 2.4
@@ -13,7 +13,7 @@
Database transactions INDEX order_number
Database transactions COLUMN_DEF "session=varchar(32) NOT NULL"
Database transactions COLUMN_DEF "username=varchar(20) default '' NOT NULL"
-Database transactions COLUMN_DEF "shipmode=varchar(32) NOT NULL"
+Database transactions COLUMN_DEF "shipmode=varchar(255) NOT NULL"
Database transactions COLUMN_DEF "nitems=varchar(9) NOT NULL"
Database transactions COLUMN_DEF "subtotal=varchar(12) NOT NULL"
Database transactions COLUMN_DEF "shipping=varchar(12) NOT NULL"
2.2 +1 -1 interchange/dist/foundation/dbconf/mysql/userdb.mysql
rev 2.2, prev_rev 2.1
Index: userdb.mysql
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/mysql/userdb.mysql,v
retrieving revision 2.1
retrieving revision 2.2
diff -u -u -r2.1 -r2.2
--- userdb.mysql 24 Jul 2001 22:09:13 -0000 2.1
+++ userdb.mysql 13 Dec 2002 21:01:40 -0000 2.2
@@ -21,7 +21,7 @@
Database userdb COLUMN_DEF "zip=CHAR(10)"
Database userdb COLUMN_DEF "country=CHAR(10)"
Database userdb COLUMN_DEF "phone_day=CHAR(20)"
-Database userdb COLUMN_DEF "mv_shipmode=CHAR(64)"
+Database userdb COLUMN_DEF "mv_shipmode=CHAR(255)"
Database userdb COLUMN_DEF "b_nickname=text"
Database userdb COLUMN_DEF "b_fname=CHAR(30)"
Database userdb COLUMN_DEF "b_lname=CHAR(30)"
2.2 +1 -1 interchange/dist/foundation/dbconf/oracle/country.ora
rev 2.2, prev_rev 2.1
Index: country.ora
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/oracle/country.ora,v
retrieving revision 2.1
retrieving revision 2.2
diff -u -u -r2.1 -r2.2
--- country.ora 12 Feb 2002 03:15:44 -0000 2.1
+++ country.ora 13 Dec 2002 21:01:41 -0000 2.2
@@ -9,7 +9,7 @@
Database country DEFAULT_TYPE VARCHAR2(128)
Database country COLUMN_DEF "code=VARCHAR2(3) PRIMARY KEY"
Database country COLUMN_DEF "selector=VARCHAR2(3)"
-Database country COLUMN_DEF "shipmodes=VARCHAR2(64)"
+Database country COLUMN_DEF "shipmodes=VARCHAR2(255)"
Database country COLUMN_DEF "name=VARCHAR2(32) DEFAULT ''"
Database country COLUMN_DEF "iso=CHAR(3) DEFAULT ''"
Database country COLUMN_DEF "isonum=CHAR(3) DEFAULT ''"
2.2 +1 -1 interchange/dist/foundation/dbconf/oracle/options.ora
rev 2.2, prev_rev 2.1
Index: options.ora
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/oracle/options.ora,v
retrieving revision 2.1
retrieving revision 2.2
diff -u -u -r2.1 -r2.2
--- options.ora 29 Jan 2002 20:14:50 -0000 2.1
+++ options.ora 13 Dec 2002 21:01:41 -0000 2.2
@@ -28,7 +28,7 @@
Database options COLUMN_DEF "differential=VARCHAR2(2000)"
Database options COLUMN_DEF "volume=VARCHAR2(20)"
Database options COLUMN_DEF "weight=VARCHAR2(20)"
-Database options COLUMN_DEF "mv_shipmode=VARCHAR2(128)"
+Database options COLUMN_DEF "mv_shipmode=VARCHAR2(255)"
Database options COLUMN_DEF "o_label=VARCHAR2(2000)"
Database options COLUMN_DEF "o_value=VARCHAR2(2000)"
Database options COLUMN_DEF "o_height=INTEGER"
2.1 +1 -1 interchange/dist/foundation/dbconf/oracle/orderline.ora
rev 2.1, prev_rev 2.0
Index: orderline.ora
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/oracle/orderline.ora,v
retrieving revision 2.0
retrieving revision 2.1
diff -u -u -r2.0 -r2.1
--- orderline.ora 18 Jul 2001 02:20:55 -0000 2.0
+++ orderline.ora 13 Dec 2002 21:01:41 -0000 2.1
@@ -14,7 +14,7 @@
Database orderline INDEX order_number
Database orderline COLUMN_DEF "session__MVC_FIELDMUNGE__=VARCHAR2(32)"
Database orderline COLUMN_DEF "username=VARCHAR2(20) DEFAULT ''"
-Database orderline COLUMN_DEF "shipmode=VARCHAR2(32) DEFAULT ''"
+Database orderline COLUMN_DEF "shipmode=VARCHAR2(255) DEFAULT ''"
Database orderline COLUMN_DEF "sku=VARCHAR2(64)"
Database orderline COLUMN_DEF "quantity=VARCHAR2(9)"
Database orderline COLUMN_DEF "price=VARCHAR2(12)"
2.4 +1 -1 interchange/dist/foundation/dbconf/oracle/transactions.ora
rev 2.4, prev_rev 2.3
Index: transactions.ora
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/oracle/transactions.ora,v
retrieving revision 2.3
retrieving revision 2.4
diff -u -u -r2.3 -r2.4
--- transactions.ora 17 Oct 2002 04:46:23 -0000 2.3
+++ transactions.ora 13 Dec 2002 21:01:41 -0000 2.4
@@ -14,7 +14,7 @@
Database transactions INDEX order_number
Database transactions COLUMN_DEF "session__MVC_FIELDMUNGE__=VARCHAR2(32)"
Database transactions COLUMN_DEF "username=VARCHAR2(20) DEFAULT ''"
-Database transactions COLUMN_DEF "shipmode=VARCHAR2(32)"
+Database transactions COLUMN_DEF "shipmode=VARCHAR2(255)"
Database transactions COLUMN_DEF "nitems=VARCHAR2(9)"
Database transactions COLUMN_DEF "subtotal=VARCHAR2(12)"
Database transactions COLUMN_DEF "shipping=VARCHAR2(12)"
2.2 +1 -1 interchange/dist/foundation/dbconf/oracle/userdb.ora
rev 2.2, prev_rev 2.1
Index: userdb.ora
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/oracle/userdb.ora,v
retrieving revision 2.1
retrieving revision 2.2
diff -u -u -r2.1 -r2.2
--- userdb.ora 24 Jul 2001 22:09:13 -0000 2.1
+++ userdb.ora 13 Dec 2002 21:01:41 -0000 2.2
@@ -23,7 +23,7 @@
Database userdb COLUMN_DEF "zip=VARCHAR2(10)"
Database userdb COLUMN_DEF "country=VARCHAR2(10)"
Database userdb COLUMN_DEF "phone_day=VARCHAR2(20)"
-Database userdb COLUMN_DEF "mv_shipmode=VARCHAR2(64)"
+Database userdb COLUMN_DEF "mv_shipmode=VARCHAR2(255)"
Database userdb COLUMN_DEF "b_nickname=VARCHAR2(2000)"
Database userdb COLUMN_DEF "b_fname=VARCHAR2(30)"
Database userdb COLUMN_DEF "b_lname=VARCHAR2(30)"
2.1 +1 -1 interchange/dist/foundation/dbconf/pgsql/country.pgsql
rev 2.1, prev_rev 2.0
Index: country.pgsql
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/pgsql/country.pgsql,v
retrieving revision 2.0
retrieving revision 2.1
diff -u -u -r2.0 -r2.1
--- country.pgsql 18 Jul 2001 02:20:57 -0000 2.0
+++ country.pgsql 13 Dec 2002 21:01:41 -0000 2.1
@@ -8,7 +8,7 @@
Database country DEFAULT_TYPE VARCHAR(255)
Database country COLUMN_DEF "code=VARCHAR(3) NOT NULL PRIMARY KEY"
Database country COLUMN_DEF "selector=VARCHAR(3) NOT NULL"
-Database country COLUMN_DEF "shipmodes=VARCHAR(64)"
+Database country COLUMN_DEF "shipmodes=VARCHAR(255)"
Database country COLUMN_DEF "name=VARCHAR(64) NOT NULL"
Database country COLUMN_DEF "iso=VARCHAR(3) DEFAULT '' NOT NULL"
Database country COLUMN_DEF "isonum=VARCHAR(3) DEFAULT '' NOT NULL"
2.2 +1 -1 interchange/dist/foundation/dbconf/pgsql/options.pgsql
rev 2.2, prev_rev 2.1
Index: options.pgsql
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/pgsql/options.pgsql,v
retrieving revision 2.1
retrieving revision 2.2
diff -u -u -r2.1 -r2.2
--- options.pgsql 25 Jun 2002 02:33:02 -0000 2.1
+++ options.pgsql 13 Dec 2002 21:01:41 -0000 2.2
@@ -14,7 +14,7 @@
Database options COLUMN_DEF "code=varchar(64) primary key NOT NULL"
Database options COLUMN_DEF "description=text"
Database options COLUMN_DEF "differential=varchar(20)"
-Database options COLUMN_DEF "mv_shipmode=varchar(128)"
+Database options COLUMN_DEF "mv_shipmode=varchar(255)"
Database options COLUMN_DEF "o_default=varchar(64)"
Database options COLUMN_DEF "o_enable=varchar(1)"
Database options COLUMN_DEF "o_group=varchar(20)"
2.2 +1 -1 interchange/dist/foundation/dbconf/pgsql/orderline.pgsql
rev 2.2, prev_rev 2.1
Index: orderline.pgsql
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/pgsql/orderline.pgsql,v
retrieving revision 2.1
retrieving revision 2.2
diff -u -u -r2.1 -r2.2
--- orderline.pgsql 17 Oct 2002 04:46:23 -0000 2.1
+++ orderline.pgsql 13 Dec 2002 21:01:41 -0000 2.2
@@ -11,7 +11,7 @@
Database orderline COLUMN_DEF "order_number=varchar(14) NOT NULL"
Database orderline COLUMN_DEF "session=varchar(32) NOT NULL"
Database orderline COLUMN_DEF "username=varchar(20)"
-Database orderline COLUMN_DEF "shipmode=varchar(32)"
+Database orderline COLUMN_DEF "shipmode=varchar(255)"
Database orderline COLUMN_DEF "sku=varchar(64) NOT NULL"
Database orderline COLUMN_DEF "quantity=varchar(9) NOT NULL"
Database orderline COLUMN_DEF "price=varchar(12) NOT NULL"
2.4 +1 -1 interchange/dist/foundation/dbconf/pgsql/transactions.pgsql
rev 2.4, prev_rev 2.3
Index: transactions.pgsql
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/pgsql/transactions.pgsql,v
retrieving revision 2.3
retrieving revision 2.4
diff -u -u -r2.3 -r2.4
--- transactions.pgsql 17 Oct 2002 04:46:23 -0000 2.3
+++ transactions.pgsql 13 Dec 2002 21:01:41 -0000 2.4
@@ -11,7 +11,7 @@
Database transactions COLUMN_DEF "order_number=VARCHAR(14) NOT NULL"
Database transactions COLUMN_DEF "session=VARCHAR(32) NOT NULL"
Database transactions COLUMN_DEF "username=VARCHAR(20) DEFAULT '' NOT NULL"
-Database transactions COLUMN_DEF "shipmode=VARCHAR(32)"
+Database transactions COLUMN_DEF "shipmode=VARCHAR(255)"
Database transactions COLUMN_DEF "nitems=VARCHAR(9) NOT NULL"
Database transactions COLUMN_DEF "subtotal=VARCHAR(12) NOT NULL"
Database transactions COLUMN_DEF "shipping=VARCHAR(12) NOT NULL"
2.3 +1 -1 interchange/dist/foundation/dbconf/pgsql/userdb.pgsql
rev 2.3, prev_rev 2.2
Index: userdb.pgsql
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/pgsql/userdb.pgsql,v
retrieving revision 2.2
retrieving revision 2.3
diff -u -u -r2.2 -r2.3
--- userdb.pgsql 10 Aug 2001 17:02:50 -0000 2.2
+++ userdb.pgsql 13 Dec 2002 21:01:41 -0000 2.3
@@ -22,7 +22,7 @@
Database userdb COLUMN_DEF "zip=VARCHAR(10)"
Database userdb COLUMN_DEF "country=VARCHAR(10)"
Database userdb COLUMN_DEF "phone_day=VARCHAR(20)"
-Database userdb COLUMN_DEF "mv_shipmode=VARCHAR(64)"
+Database userdb COLUMN_DEF "mv_shipmode=VARCHAR(255)"
Database userdb COLUMN_DEF "b_nickname=text"
Database userdb COLUMN_DEF "b_fname=VARCHAR(30)"
Database userdb COLUMN_DEF "b_lname=VARCHAR(30)"