[interchange-cvs] interchange - heins modified 3 files
interchange-core@icdevgroup.org
interchange-core@icdevgroup.org
Thu Jan 23 14:06:00 2003
User: heins
Date: 2003-01-23 19:05:50 GMT
Modified: dist/foundation/dbconf/pgsql orderline.pgsql
Modified: transactions.pgsql userdb.pgsql
Log:
* Add greater length to Postgres databases to prevent data length error
problems. Why don't they allow auto-truncate?
Revision Changes Path
2.3 +4 -4 interchange/dist/foundation/dbconf/pgsql/orderline.pgsql
rev 2.3, prev_rev 2.2
Index: orderline.pgsql
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/pgsql/orderline.pgsql,v
retrieving revision 2.2
retrieving revision 2.3
diff -u -r2.2 -r2.3
--- orderline.pgsql 13 Dec 2002 21:01:41 -0000 2.2
+++ orderline.pgsql 23 Jan 2003 19:05:50 -0000 2.3
@@ -18,11 +18,11 @@
Database orderline COLUMN_DEF "subtotal=varchar(12) NOT NULL"
Database orderline COLUMN_DEF "shipping=varchar(12)"
Database orderline COLUMN_DEF "taxable=varchar(3)"
-Database orderline COLUMN_DEF "size=varchar(30)"
-Database orderline COLUMN_DEF "color=varchar(30)"
-Database orderline COLUMN_DEF "options=varchar(255)"
+Database orderline COLUMN_DEF "size=varchar(255)"
+Database orderline COLUMN_DEF "color=varchar(255)"
+Database orderline COLUMN_DEF "options=text"
Database orderline COLUMN_DEF "order_date=varchar(32) NOT NULL"
Database orderline COLUMN_DEF "update_date=timestamp"
-Database orderline COLUMN_DEF "status=varchar(32)"
+Database orderline COLUMN_DEF "status=varchar(64)"
Database orderline COLUMN_DEF "parent=varchar(9)"
Database orderline INDEX store_id order_number
2.5 +32 -29 interchange/dist/foundation/dbconf/pgsql/transactions.pgsql
rev 2.5, prev_rev 2.4
Index: transactions.pgsql
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/pgsql/transactions.pgsql,v
retrieving revision 2.4
retrieving revision 2.5
diff -u -r2.4 -r2.5
--- transactions.pgsql 13 Dec 2002 21:01:41 -0000 2.4
+++ transactions.pgsql 23 Jan 2003 19:05:50 -0000 2.5
@@ -9,7 +9,7 @@
Database transactions COLUMN_DEF "code=VARCHAR(14) 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 "session=VARCHAR(32) NOT NULL"
+Database transactions COLUMN_DEF "session=VARCHAR(64) NOT NULL"
Database transactions COLUMN_DEF "username=VARCHAR(20) DEFAULT '' NOT NULL"
Database transactions COLUMN_DEF "shipmode=VARCHAR(255)"
Database transactions COLUMN_DEF "nitems=VARCHAR(9) NOT NULL"
@@ -18,42 +18,45 @@
Database transactions COLUMN_DEF "handling=VARCHAR(12)"
Database transactions COLUMN_DEF "salestax=VARCHAR(12)"
Database transactions COLUMN_DEF "total_cost=VARCHAR(16) NOT NULL"
-Database transactions COLUMN_DEF "fname=VARCHAR(30)"
-Database transactions COLUMN_DEF "lname=VARCHAR(30)"
-Database transactions COLUMN_DEF "company=VARCHAR(30)"
-Database transactions COLUMN_DEF "address1=VARCHAR(64)"
-Database transactions COLUMN_DEF "address2=VARCHAR(64)"
-Database transactions COLUMN_DEF "city=VARCHAR(30) NOT NULL"
-Database transactions COLUMN_DEF "state=VARCHAR(10)"
-Database transactions COLUMN_DEF "zip=VARCHAR(10)"
-Database transactions COLUMN_DEF "country=VARCHAR(10)"
-Database transactions COLUMN_DEF "phone_day=VARCHAR(20)"
-Database transactions COLUMN_DEF "phone_night=VARCHAR(20)"
-Database transactions COLUMN_DEF "fax=VARCHAR(20)"
-Database transactions COLUMN_DEF "email=VARCHAR(42)"
-Database transactions COLUMN_DEF "b_fname=VARCHAR(30)"
-Database transactions COLUMN_DEF "b_lname=VARCHAR(30)"
-Database transactions COLUMN_DEF "b_company=VARCHAR(30)"
-Database transactions COLUMN_DEF "b_address1=VARCHAR(64)"
-Database transactions COLUMN_DEF "b_address2=VARCHAR(64)"
-Database transactions COLUMN_DEF "b_city=VARCHAR(30)"
-Database transactions COLUMN_DEF "b_state=VARCHAR(10)"
-Database transactions COLUMN_DEF "b_zip=VARCHAR(10)"
-Database transactions COLUMN_DEF "b_country=VARCHAR(10)"
-Database transactions COLUMN_DEF "b_phone=VARCHAR(20)"
-Database transactions COLUMN_DEF "payment_method=varchar(128)"
-Database transactions COLUMN_DEF "avs=varchar(32)"
+Database transactions COLUMN_DEF "fname=VARCHAR(128)"
+Database transactions COLUMN_DEF "lname=VARCHAR(128)"
+Database transactions COLUMN_DEF "company=VARCHAR(128)"
+Database transactions COLUMN_DEF "address1=VARCHAR(128)"
+Database transactions COLUMN_DEF "address2=VARCHAR(128)"
+Database transactions COLUMN_DEF "city=VARCHAR(128) NOT NULL"
+Database transactions COLUMN_DEF "state=VARCHAR(32)"
+Database transactions COLUMN_DEF "zip=VARCHAR(32)"
+Database transactions COLUMN_DEF "country=VARCHAR(32)"
+Database transactions COLUMN_DEF "phone_day=VARCHAR(32)"
+Database transactions COLUMN_DEF "phone_night=VARCHAR(32)"
+Database transactions COLUMN_DEF "fax=VARCHAR(32)"
+Database transactions COLUMN_DEF "email=VARCHAR(128)"
+Database transactions COLUMN_DEF "b_fname=VARCHAR(128)"
+Database transactions COLUMN_DEF "b_lname=VARCHAR(128)"
+Database transactions COLUMN_DEF "b_company=VARCHAR(128)"
+Database transactions COLUMN_DEF "b_address1=VARCHAR(128)"
+Database transactions COLUMN_DEF "b_address2=VARCHAR(128)"
+Database transactions COLUMN_DEF "b_city=VARCHAR(128)"
+Database transactions COLUMN_DEF "b_state=VARCHAR(32)"
+Database transactions COLUMN_DEF "b_zip=VARCHAR(32)"
+Database transactions COLUMN_DEF "b_country=VARCHAR(32)"
+Database transactions COLUMN_DEF "b_phone=VARCHAR(32)"
+Database transactions COLUMN_DEF "payment_method=varchar(255)"
+Database transactions COLUMN_DEF "avs=varchar(255)"
Database transactions COLUMN_DEF "order_id=varchar(32)"
Database transactions COLUMN_DEF "auth_code=varchar(32)"
Database transactions COLUMN_DEF "tracking_number=varchar(64)"
Database transactions COLUMN_DEF "order_date=varchar(32) NOT NULL"
Database transactions COLUMN_DEF "update_date=timestamp"
-Database transactions COLUMN_DEF "archived=CHAR(1) DEFAULT ''"
-Database transactions COLUMN_DEF "deleted=CHAR(1) DEFAULT ''"
-Database transactions COLUMN_DEF "complete=CHAR(1) DEFAULT ''"
+Database transactions COLUMN_DEF "archived=varchar(1) DEFAULT ''"
+Database transactions COLUMN_DEF "deleted=varchar(1) DEFAULT ''"
+Database transactions COLUMN_DEF "complete=varchar(1) DEFAULT ''"
Database transactions COLUMN_DEF "status=VARCHAR(32)"
Database transactions COLUMN_DEF "parent=VARCHAR(9)"
Database transactions COLUMN_DEF "comments=text"
Database transactions COLUMN_DEF "currency_locale=varchar(32)"
Database transactions INDEX store_id
Database transactions INDEX order_number
+Database transactions INDEX order_date
+Database transactions INDEX archived
+Database transactions INDEX deleted
2.4 +25 -25 interchange/dist/foundation/dbconf/pgsql/userdb.pgsql
rev 2.4, prev_rev 2.3
Index: userdb.pgsql
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/pgsql/userdb.pgsql,v
retrieving revision 2.3
retrieving revision 2.4
diff -u -r2.3 -r2.4
--- userdb.pgsql 13 Dec 2002 21:01:41 -0000 2.3
+++ userdb.pgsql 23 Jan 2003 19:05:50 -0000 2.4
@@ -6,41 +6,41 @@
Database userdb PASS __SQLPASS__
endif
Database userdb DEFAULT_TYPE VARCHAR(255)
-Database userdb COLUMN_DEF "code=VARCHAR(20) NOT NULL PRIMARY KEY"
+Database userdb COLUMN_DEF "username=VARCHAR(20) NOT NULL PRIMARY KEY"
Database userdb COLUMN_DEF "password=VARCHAR(20)"
Database userdb COLUMN_DEF "acl=text"
Database userdb COLUMN_DEF "mod_time=varchar(20)"
Database userdb COLUMN_DEF "s_nickname=text"
-Database userdb COLUMN_DEF "company=VARCHAR(30)"
-Database userdb COLUMN_DEF "fname=VARCHAR(30)"
-Database userdb COLUMN_DEF "lname=VARCHAR(30)"
-Database userdb COLUMN_DEF "address1=VARCHAR(64)"
-Database userdb COLUMN_DEF "address2=VARCHAR(64)"
-Database userdb COLUMN_DEF "address3=VARCHAR(64)"
-Database userdb COLUMN_DEF "city=VARCHAR(30)"
-Database userdb COLUMN_DEF "state=VARCHAR(10)"
-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 "company=VARCHAR(128)"
+Database userdb COLUMN_DEF "fname=VARCHAR(128)"
+Database userdb COLUMN_DEF "lname=VARCHAR(128)"
+Database userdb COLUMN_DEF "address1=VARCHAR(128)"
+Database userdb COLUMN_DEF "address2=VARCHAR(128)"
+Database userdb COLUMN_DEF "address3=VARCHAR(128)"
+Database userdb COLUMN_DEF "city=VARCHAR(128)"
+Database userdb COLUMN_DEF "state=VARCHAR(32)"
+Database userdb COLUMN_DEF "zip=VARCHAR(32)"
+Database userdb COLUMN_DEF "country=VARCHAR(32)"
+Database userdb COLUMN_DEF "phone_day=VARCHAR(32)"
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)"
-Database userdb COLUMN_DEF "b_address1=VARCHAR(64)"
-Database userdb COLUMN_DEF "b_address2=VARCHAR(64)"
-Database userdb COLUMN_DEF "b_address3=VARCHAR(64)"
-Database userdb COLUMN_DEF "b_city=VARCHAR(30)"
-Database userdb COLUMN_DEF "b_state=VARCHAR(10)"
-Database userdb COLUMN_DEF "b_zip=VARCHAR(10)"
-Database userdb COLUMN_DEF "b_country=VARCHAR(10)"
-Database userdb COLUMN_DEF "b_phone=VARCHAR(20)"
+Database userdb COLUMN_DEF "b_fname=VARCHAR(128)"
+Database userdb COLUMN_DEF "b_lname=VARCHAR(128)"
+Database userdb COLUMN_DEF "b_address1=VARCHAR(128)"
+Database userdb COLUMN_DEF "b_address2=VARCHAR(128)"
+Database userdb COLUMN_DEF "b_address3=VARCHAR(128)"
+Database userdb COLUMN_DEF "b_city=VARCHAR(128)"
+Database userdb COLUMN_DEF "b_state=VARCHAR(32)"
+Database userdb COLUMN_DEF "b_zip=VARCHAR(32)"
+Database userdb COLUMN_DEF "b_country=VARCHAR(32)"
+Database userdb COLUMN_DEF "b_phone=VARCHAR(32)"
Database userdb COLUMN_DEF "mv_credit_card_type=VARCHAR(16)"
Database userdb COLUMN_DEF "mv_credit_card_exp_month=VARCHAR(2)"
Database userdb COLUMN_DEF "mv_credit_card_exp_year=VARCHAR(4)"
Database userdb COLUMN_DEF "p_nickname=text"
-Database userdb COLUMN_DEF "email=VARCHAR(42)"
-Database userdb COLUMN_DEF "fax=VARCHAR(20)"
-Database userdb COLUMN_DEF "phone_night=VARCHAR(20)"
+Database userdb COLUMN_DEF "email=VARCHAR(128)"
+Database userdb COLUMN_DEF "fax=VARCHAR(32)"
+Database userdb COLUMN_DEF "phone_night=VARCHAR(32)"
Database userdb COLUMN_DEF "fax_order=VARCHAR(2)"
Database userdb COLUMN_DEF "address_book=TEXT"
Database userdb COLUMN_DEF "accounts=TEXT"