[interchange] Changed dbconf files for userdb, transactions, and orderline to reflect
Greg Hanson
interchange-cvs at icdevgroup.org
Mon Apr 25 18:15:21 UTC 2016
commit 3f2ab8829035c7116930bd0b026f0fdbad6572d5
Author: Greg Hanson <ghanson at central.endpoint.com>
Date: Mon Apr 25 13:44:40 2016 -0400
Changed dbconf files for userdb, transactions, and orderline to reflect
a varchar(255) definition for username, usernick, and email.
Previously were a mis-matched variations of lengths, that do not provide
adequate length for modern email addresses. In many cases, people are
using email as usernick, and in some cases username, so all 3 fields
should be consistent.
Changed on all 3 dbs, mysql, postgres, and sqllite.
dist/strap/dbconf/mysql/orderline.mysql | 2 +-
dist/strap/dbconf/mysql/transactions.mysql | 4 ++--
dist/strap/dbconf/mysql/userdb.mysql | 6 +++---
dist/strap/dbconf/pgsql/orderline.pgsql | 2 +-
dist/strap/dbconf/pgsql/transactions.pgsql | 4 ++--
dist/strap/dbconf/pgsql/userdb.pgsql | 6 +++---
dist/strap/dbconf/sqlite/orderline.lite | 2 +-
dist/strap/dbconf/sqlite/transactions.lite | 4 ++--
dist/strap/dbconf/sqlite/userdb.lite | 6 +++---
9 files changed, 18 insertions(+), 18 deletions(-)
---
diff --git a/dist/strap/dbconf/mysql/orderline.mysql b/dist/strap/dbconf/mysql/orderline.mysql
index 889024b..ed1950d 100644
--- a/dist/strap/dbconf/mysql/orderline.mysql
+++ b/dist/strap/dbconf/mysql/orderline.mysql
@@ -4,7 +4,7 @@ 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(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 "username=varchar(255) 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=int NOT NULL"
diff --git a/dist/strap/dbconf/mysql/transactions.mysql b/dist/strap/dbconf/mysql/transactions.mysql
index d15e217..30839d8 100644
--- a/dist/strap/dbconf/mysql/transactions.mysql
+++ b/dist/strap/dbconf/mysql/transactions.mysql
@@ -6,7 +6,7 @@ Database transactions INDEX store_id
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"
+Database transactions COLUMN_DEF "username=varchar(255) default '' 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"
@@ -26,7 +26,7 @@ Database transactions COLUMN_DEF "country=varchar(10) DEFAULT '' NOT NULL"
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 "email=varchar(255)"
Database transactions COLUMN_DEF "b_fname=varchar(30)"
Database transactions COLUMN_DEF "b_lname=varchar(30)"
Database transactions COLUMN_DEF "b_company=varchar(30)"
diff --git a/dist/strap/dbconf/mysql/userdb.mysql b/dist/strap/dbconf/mysql/userdb.mysql
index 66a624c..b38e3a8 100644
--- a/dist/strap/dbconf/mysql/userdb.mysql
+++ b/dist/strap/dbconf/mysql/userdb.mysql
@@ -1,7 +1,7 @@
Database userdb userdb.txt __SQLDSN__
Database userdb DEFAULT_TYPE varchar(255)
-Database userdb COLUMN_DEF "username=varchar(64) NOT NULL PRIMARY KEY"
-Database userdb COLUMN_DEF "usernick=varchar(64) NOT NULL"
+Database userdb COLUMN_DEF "username=varchar(255) NOT NULL PRIMARY KEY"
+Database userdb COLUMN_DEF "usernick=varchar(255) NOT NULL"
Database userdb COLUMN_DEF "password=varchar(64) NOT NULL"
Database userdb COLUMN_DEF "expiration=varchar(32)"
Database userdb COLUMN_DEF "accounts=BLOB"
@@ -30,7 +30,7 @@ Database userdb COLUMN_DEF "created=varchar(32)"
Database userdb COLUMN_DEF "credit_limit=varchar(16)"
Database userdb COLUMN_DEF "db_acl=BLOB"
Database userdb COLUMN_DEF "dealer=varchar(32)"
-Database userdb COLUMN_DEF "email=varchar(42)"
+Database userdb COLUMN_DEF "email=varchar(255)"
Database userdb COLUMN_DEF "fax=varchar(30)"
Database userdb COLUMN_DEF "file_acl=BLOB"
Database userdb COLUMN_DEF "fname=varchar(30)"
diff --git a/dist/strap/dbconf/pgsql/orderline.pgsql b/dist/strap/dbconf/pgsql/orderline.pgsql
index f340926..31f18e0 100644
--- a/dist/strap/dbconf/pgsql/orderline.pgsql
+++ b/dist/strap/dbconf/pgsql/orderline.pgsql
@@ -4,7 +4,7 @@ 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(24) NOT NULL"
Database orderline COLUMN_DEF "session=varchar(32) NOT NULL"
-Database orderline COLUMN_DEF "username=varchar(32)"
+Database orderline COLUMN_DEF "username=varchar(255)"
Database orderline COLUMN_DEF "shipmode=varchar(255)"
Database orderline COLUMN_DEF "sku=varchar(64) NOT NULL"
Database orderline COLUMN_DEF "quantity=int NOT NULL"
diff --git a/dist/strap/dbconf/pgsql/transactions.pgsql b/dist/strap/dbconf/pgsql/transactions.pgsql
index 68ba182..01a08ba 100644
--- a/dist/strap/dbconf/pgsql/transactions.pgsql
+++ b/dist/strap/dbconf/pgsql/transactions.pgsql
@@ -4,7 +4,7 @@ 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(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 "username=varchar(255) DEFAULT '' NOT NULL"
Database transactions COLUMN_DEF "shipmode=varchar(255)"
Database transactions COLUMN_DEF "nitems=int NOT NULL"
Database transactions COLUMN_DEF "subtotal=decimal(12,2) NOT NULL"
@@ -24,7 +24,7 @@ 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 "email=varchar(255)"
Database transactions COLUMN_DEF "b_fname=varchar(128)"
Database transactions COLUMN_DEF "b_lname=varchar(128)"
Database transactions COLUMN_DEF "b_company=varchar(128)"
diff --git a/dist/strap/dbconf/pgsql/userdb.pgsql b/dist/strap/dbconf/pgsql/userdb.pgsql
index 5a7f182..737b3de 100644
--- a/dist/strap/dbconf/pgsql/userdb.pgsql
+++ b/dist/strap/dbconf/pgsql/userdb.pgsql
@@ -2,8 +2,8 @@ Database userdb userdb.txt __SQLDSN__
Database userdb LENGTH_EXCEPTION_DEFAULT truncate_log
Database userdb DEFAULT_TYPE varchar(255)
-Database userdb COLUMN_DEF "username=varchar(64) NOT NULL PRIMARY KEY"
-Database userdb COLUMN_DEF "usernick=varchar(64) NOT NULL"
+Database userdb COLUMN_DEF "username=varchar(255) NOT NULL PRIMARY KEY"
+Database userdb COLUMN_DEF "usernick=varchar(255) NOT NULL"
Database userdb COLUMN_DEF "password=varchar(64)"
Database userdb COLUMN_DEF "expiration=varchar(32)"
Database userdb COLUMN_DEF "accounts=text"
@@ -32,7 +32,7 @@ Database userdb COLUMN_DEF "country=varchar(10)"
Database userdb COLUMN_DEF "credit_limit=varchar(16)"
Database userdb COLUMN_DEF "db_acl=text"
Database userdb COLUMN_DEF "dealer=varchar(32)"
-Database userdb COLUMN_DEF "email=varchar(42)"
+Database userdb COLUMN_DEF "email=varchar(255)"
Database userdb COLUMN_DEF "fax=varchar(30)"
Database userdb COLUMN_DEF "file_acl=text"
Database userdb COLUMN_DEF "fname=varchar(30)"
diff --git a/dist/strap/dbconf/sqlite/orderline.lite b/dist/strap/dbconf/sqlite/orderline.lite
index 7df770f..0f72dcd 100644
--- a/dist/strap/dbconf/sqlite/orderline.lite
+++ b/dist/strap/dbconf/sqlite/orderline.lite
@@ -4,7 +4,7 @@ Database orderline COLUMN_DEF "code=char(14) 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 "session=varchar(32) NOT NULL"
-Database orderline COLUMN_DEF "username=varchar(20) default '' NOT NULL"
+Database orderline COLUMN_DEF "username=varchar(255) 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"
diff --git a/dist/strap/dbconf/sqlite/transactions.lite b/dist/strap/dbconf/sqlite/transactions.lite
index ae02158..96aa0b8 100644
--- a/dist/strap/dbconf/sqlite/transactions.lite
+++ b/dist/strap/dbconf/sqlite/transactions.lite
@@ -6,7 +6,7 @@ Database transactions INDEX store_id
Database transactions COLUMN_DEF "order_number=varchar(14) NOT NULL"
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 "username=varchar(255) default '' 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"
@@ -26,7 +26,7 @@ Database transactions COLUMN_DEF "country=varchar(10) DEFAULT '' NOT NULL"
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 "email=varchar(255)"
Database transactions COLUMN_DEF "b_fname=varchar(30)"
Database transactions COLUMN_DEF "b_lname=varchar(30)"
Database transactions COLUMN_DEF "b_company=varchar(30)"
diff --git a/dist/strap/dbconf/sqlite/userdb.lite b/dist/strap/dbconf/sqlite/userdb.lite
index d56d64f..e1a13bc 100644
--- a/dist/strap/dbconf/sqlite/userdb.lite
+++ b/dist/strap/dbconf/sqlite/userdb.lite
@@ -1,8 +1,8 @@
Database userdb userdb.txt __SQLDSN__
Database userdb DEFAULT_TYPE varchar(255)
-Database userdb COLUMN_DEF "username=varchar(64) NOT NULL PRIMARY KEY"
-Database userdb COLUMN_DEF "usernick=varchar(64) NOT NULL"
+Database userdb COLUMN_DEF "username=varchar(255) NOT NULL PRIMARY KEY"
+Database userdb COLUMN_DEF "usernick=varchar(255) NOT NULL"
Database userdb COLUMN_DEF "password=varchar(64)"
Database userdb COLUMN_DEF "expiration=varchar(32)"
Database userdb COLUMN_DEF "accounts=text"
@@ -30,7 +30,7 @@ Database userdb COLUMN_DEF "company=varchar(64)"
Database userdb COLUMN_DEF "country=varchar(10)"
Database userdb COLUMN_DEF "credit_limit=varchar(16)"
Database userdb COLUMN_DEF "db_acl=text"
-Database userdb COLUMN_DEF "dealer=varchar(32)"
+Database userdb COLUMN_DEF "dealer=varchar(255)"
Database userdb COLUMN_DEF "email=varchar(42)"
Database userdb COLUMN_DEF "fax=varchar(30)"
Database userdb COLUMN_DEF "file_acl=text"
More information about the interchange-cvs
mailing list