[interchange] Allow userdb.usernick to be NULL

Jon Jensen <[email protected]> Thu, 02 Nov 2017 05:54:40 +0000
Newsgroups gmane.comp.web.interchange.cvs
Message-ID <[email protected]>
commit 57f71fefa006b50061c1f11f585134c8abc1738e
Author: Jon Jensen <[email protected]>
Date:   Wed Nov 1 23:41:05 2017 -0600

    Allow userdb.usernick to be NULL
    
    Otherwise guest checkout doesn't work.

 dist/strap/dbconf/mysql/userdb.mysql |    2 +-
 dist/strap/dbconf/pgsql/userdb.pgsql |    2 +-
 dist/strap/dbconf/sqlite/userdb.lite |    2 +-
 3 files changed, 3 insertions(+), 3 deletions(-)
---
diff --git a/dist/strap/dbconf/mysql/userdb.mysql b/dist/strap/dbconf/mysql/userdb.mysql
index b38e3a8..66153e3 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(255) NOT NULL PRIMARY KEY"
-Database  userdb  COLUMN_DEF   "usernick=varchar(255) NOT NULL"
+Database  userdb  COLUMN_DEF   "usernick=varchar(255)"
 Database  userdb  COLUMN_DEF   "password=varchar(64) NOT NULL"
 Database  userdb  COLUMN_DEF   "expiration=varchar(32)"
 Database  userdb  COLUMN_DEF   "accounts=BLOB"
diff --git a/dist/strap/dbconf/pgsql/userdb.pgsql b/dist/strap/dbconf/pgsql/userdb.pgsql
index f4b1330..74acfde 100644
--- a/dist/strap/dbconf/pgsql/userdb.pgsql
+++ b/dist/strap/dbconf/pgsql/userdb.pgsql
@@ -3,7 +3,7 @@ Database  userdb  LENGTH_EXCEPTION_DEFAULT  truncate_log
 Database  userdb  DEFAULT_TYPE  varchar(255)
 
 Database  userdb  COLUMN_DEF   "username=varchar(255) NOT NULL PRIMARY KEY"
-Database  userdb  COLUMN_DEF   "usernick=varchar(255) NOT NULL"
+Database  userdb  COLUMN_DEF   "usernick=varchar(255)"
 Database  userdb  COLUMN_DEF   "password=varchar(64)"
 Database  userdb  COLUMN_DEF   "expiration=varchar(32)"
 Database  userdb  COLUMN_DEF   "accounts=text"
diff --git a/dist/strap/dbconf/sqlite/userdb.lite b/dist/strap/dbconf/sqlite/userdb.lite
index 8366542..a8e1818 100644
--- a/dist/strap/dbconf/sqlite/userdb.lite
+++ b/dist/strap/dbconf/sqlite/userdb.lite
@@ -2,7 +2,7 @@ Database  userdb  userdb.txt   __SQLDSN__
 Database  userdb  DEFAULT_TYPE  varchar(255)
 
 Database  userdb  COLUMN_DEF   "username=varchar(255) NOT NULL PRIMARY KEY"
-Database  userdb  COLUMN_DEF   "usernick=varchar(255) NOT NULL"
+Database  userdb  COLUMN_DEF   "usernick=varchar(255)"
 Database  userdb  COLUMN_DEF   "password=varchar(64)"
 Database  userdb  COLUMN_DEF   "expiration=varchar(32)"
 Database  userdb  COLUMN_DEF   "accounts=text"