[interchange-cvs] interchange - heins modified 4 files

[interchange-cvs at icdevgroup.org]

User:      heins
Date:      2008-07-03 18:16:17 GMT
Modified:  dist/standard/dbconf/mysql orderline.mysql
Modified:           transactions.mysql
Modified:  dist/standard/dbconf/pgsql orderline.pgsql
Modified:           transactions.pgsql
Log:
* Increase length of order_number -- it is now common to have to do this
  on client sites.

Revision  Changes    Path
1.2                  interchange/dist/standard/dbconf/mysql/orderline.mysql


rev 1.2, prev_rev 1.1
Index: orderline.mysql
===================================================================
RCS file: /var/cvs/interchange/dist/standard/dbconf/mysql/orderline.mysql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- orderline.mysql	25 Apr 2004 17:07:49 -0000	1.1
+++ orderline.mysql	3 Jul 2008 18:16:17 -0000	1.2
@@ -2,7 +2,7 @@
 Database  orderline  DEFAULT_TYPE varchar(128)
 Database  orderline  COLUMN_DEF   "code=varchar(32) NOT NULL PRIMARY KEY"
 Database  orderline  COLUMN_DEF   "store_id=varchar(9) DEFAULT '' NOT NULL"
-Database  orderline  COLUMN_DEF   "order_number=varchar(14) NOT NULL"
+Database  orderline  COLUMN_DEF   "order_number=varchar(24) NOT NULL"
 Database  orderline  COLUMN_DEF   "session=varchar(32) NOT NULL"
 Database  orderline  COLUMN_DEF   "username=varchar(32) default '' NOT NULL"
 Database  orderline  COLUMN_DEF   "shipmode=varchar(255) default '' NOT NULL"



1.2                  interchange/dist/standard/dbconf/mysql/transactions.mysql


rev 1.2, prev_rev 1.1
Index: transactions.mysql
===================================================================
RCS file: /var/cvs/interchange/dist/standard/dbconf/mysql/transactions.mysql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- transactions.mysql	25 Apr 2004 17:07:49 -0000	1.1
+++ transactions.mysql	3 Jul 2008 18:16:17 -0000	1.2
@@ -3,7 +3,7 @@
 Database  transactions  COLUMN_DEF   "code=varchar(32) NOT NULL PRIMARY KEY"
 Database  transactions  COLUMN_DEF   "store_id=varchar(9) DEFAULT '' NOT NULL"
 Database  transactions  INDEX         store_id
-Database  transactions  COLUMN_DEF   "order_number=varchar(14) NOT NULL"
+Database  transactions  COLUMN_DEF   "order_number=varchar(24) NOT NULL"
 Database  transactions  INDEX         order_number
 Database  transactions  COLUMN_DEF   "session=varchar(32) NOT NULL"
 Database  transactions  COLUMN_DEF   "username=varchar(32) default '' NOT NULL"



1.2                  interchange/dist/standard/dbconf/pgsql/orderline.pgsql


rev 1.2, prev_rev 1.1
Index: orderline.pgsql
===================================================================
RCS file: /var/cvs/interchange/dist/standard/dbconf/pgsql/orderline.pgsql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- orderline.pgsql	25 Apr 2004 17:07:49 -0000	1.1
+++ orderline.pgsql	3 Jul 2008 18:16:17 -0000	1.2
@@ -1,8 +1,8 @@
 Database  orderline  orderline.txt __SQLDSN__
 Database  orderline  DEFAULT_TYPE varchar(128)
-Database  orderline  COLUMN_DEF   "code=varchar(14) NOT NULL PRIMARY KEY"
+Database  orderline  COLUMN_DEF   "code=varchar(32) NOT NULL PRIMARY KEY"
 Database  orderline  COLUMN_DEF   "store_id=varchar(9)"
-Database  orderline  COLUMN_DEF   "order_number=varchar(14) NOT NULL"
+Database  orderline  COLUMN_DEF   "order_number=varchar(24) NOT NULL"
 Database  orderline  COLUMN_DEF   "session=varchar(32) NOT NULL"
 Database  orderline  COLUMN_DEF   "username=varchar(32)"
 Database  orderline  COLUMN_DEF   "shipmode=varchar(255)"



1.2                  interchange/dist/standard/dbconf/pgsql/transactions.pgsql


rev 1.2, prev_rev 1.1
Index: transactions.pgsql
===================================================================
RCS file: /var/cvs/interchange/dist/standard/dbconf/pgsql/transactions.pgsql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -r1.1 -r1.2
--- transactions.pgsql	25 Apr 2004 17:07:49 -0000	1.1
+++ transactions.pgsql	3 Jul 2008 18:16:17 -0000	1.2
@@ -1,8 +1,8 @@
 Database  transactions  transactions.txt __SQLDSN__
 Database  transactions  DEFAULT_TYPE varchar(128)
-Database  transactions  COLUMN_DEF   "code=varchar(14) NOT NULL PRIMARY KEY"
+Database  transactions  COLUMN_DEF   "code=varchar(24) NOT NULL PRIMARY KEY"
 Database  transactions  COLUMN_DEF   "store_id=varchar(9)"
-Database  transactions  COLUMN_DEF   "order_number=varchar(14) NOT NULL"
+Database  transactions  COLUMN_DEF   "order_number=varchar(24) NOT NULL"
 Database  transactions  COLUMN_DEF   "session=varchar(64) NOT NULL"
 Database  transactions  COLUMN_DEF   "username=varchar(32) DEFAULT '' NOT NULL"
 Database  transactions  COLUMN_DEF   "shipmode=varchar(255)"