[interchange] Changed dbconf files for userdb, transactions, and orderline to reflect
Greg Hanson <[email protected]> Mon, 25 Apr 2016 18:15:21 +0000
| Newsgroups | gmane.comp.web.interchange.cvs |
|---|---|
| Message-ID | <[email protected]> |
commit 3f2ab8829035c7116930bd0b026f0fdbad6572d5 Author: Greg Hanson <[email protected]> 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"