[sr-dev] git:master:ec0bcd9b: kamctl: regenerated db creation scripts for subscriber table

[Daniel-Constantin Mierla]

Module: kamailio
Branch: master
Commit: ec0bcd9ba9ef3631a9f603b7ad7b8faa7c406c28
URL: https://github.com/kamailio/kamailio/commit/ec0bcd9ba9ef3631a9f603b7ad7b8faa7c406c28

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: 2016-11-13T13:11:11+01:00

kamctl: regenerated db creation scripts for subscriber table

---

Modified: utils/kamctl/db_berkeley/kamailio/subscriber
Modified: utils/kamctl/db_sqlite/auth_db-create.sql
Modified: utils/kamctl/mysql/auth_db-create.sql
Modified: utils/kamctl/oracle/auth_db-create.sql
Modified: utils/kamctl/postgres/auth_db-create.sql

---

Diff:  https://github.com/kamailio/kamailio/commit/ec0bcd9ba9ef3631a9f603b7ad7b8faa7c406c28.diff
Patch: https://github.com/kamailio/kamailio/commit/ec0bcd9ba9ef3631a9f603b7ad7b8faa7c406c28.patch

---

diff --git a/utils/kamctl/db_berkeley/kamailio/subscriber b/utils/kamctl/db_berkeley/kamailio/subscriber
index 7f6d6f3..76fbed3 100644
--- a/utils/kamctl/db_berkeley/kamailio/subscriber
+++ b/utils/kamctl/db_berkeley/kamailio/subscriber
@@ -7,4 +7,4 @@ METADATA_READONLY
 METADATA_LOGFLAGS
 0
 METADATA_DEFAULTS
-NIL|''|''|''|''|''|''|NULL
+NIL|''|''|''|''|''|NULL|NULL
diff --git a/utils/kamctl/db_sqlite/auth_db-create.sql b/utils/kamctl/db_sqlite/auth_db-create.sql
index f49677e..827d865 100644
--- a/utils/kamctl/db_sqlite/auth_db-create.sql
+++ b/utils/kamctl/db_sqlite/auth_db-create.sql
@@ -5,7 +5,7 @@ CREATE TABLE subscriber (
     password VARCHAR(64) DEFAULT '' NOT NULL,
     ha1 VARCHAR(128) DEFAULT '' NOT NULL,
     ha1b VARCHAR(128) DEFAULT '' NOT NULL,
-    email_address VARCHAR(128) DEFAULT '' NOT NULL,
+    email_address VARCHAR(128) DEFAULT NULL,
     rpid VARCHAR(128) DEFAULT NULL,
     CONSTRAINT subscriber_account_idx UNIQUE (username, domain)
 );
diff --git a/utils/kamctl/mysql/auth_db-create.sql b/utils/kamctl/mysql/auth_db-create.sql
index a383e8b..ecc56a4 100644
--- a/utils/kamctl/mysql/auth_db-create.sql
+++ b/utils/kamctl/mysql/auth_db-create.sql
@@ -5,7 +5,7 @@ CREATE TABLE `subscriber` (
     `password` VARCHAR(64) DEFAULT '' NOT NULL,
     `ha1` VARCHAR(128) DEFAULT '' NOT NULL,
     `ha1b` VARCHAR(128) DEFAULT '' NOT NULL,
-    `email_address` VARCHAR(128) DEFAULT '' NOT NULL,
+    `email_address` VARCHAR(128) DEFAULT NULL,
     `rpid` VARCHAR(128) DEFAULT NULL,
     CONSTRAINT account_idx UNIQUE (`username`, `domain`)
 );
diff --git a/utils/kamctl/oracle/auth_db-create.sql b/utils/kamctl/oracle/auth_db-create.sql
index 74e2253..51cef59 100644
--- a/utils/kamctl/oracle/auth_db-create.sql
+++ b/utils/kamctl/oracle/auth_db-create.sql
@@ -5,7 +5,7 @@ CREATE TABLE subscriber (
     password VARCHAR2(64) DEFAULT '',
     ha1 VARCHAR2(128) DEFAULT '',
     ha1b VARCHAR2(128) DEFAULT '',
-    email_address VARCHAR2(128) DEFAULT '',
+    email_address VARCHAR2(128) DEFAULT NULL,
     rpid VARCHAR2(128) DEFAULT NULL,
     CONSTRAINT subscriber_account_idx  UNIQUE (username, domain)
 );
diff --git a/utils/kamctl/postgres/auth_db-create.sql b/utils/kamctl/postgres/auth_db-create.sql
index dcbb9ff..55dad4b 100644
--- a/utils/kamctl/postgres/auth_db-create.sql
+++ b/utils/kamctl/postgres/auth_db-create.sql
@@ -5,7 +5,7 @@ CREATE TABLE subscriber (
     password VARCHAR(64) DEFAULT '' NOT NULL,
     ha1 VARCHAR(128) DEFAULT '' NOT NULL,
     ha1b VARCHAR(128) DEFAULT '' NOT NULL,
-    email_address VARCHAR(128) DEFAULT '' NOT NULL,
+    email_address VARCHAR(128) DEFAULT NULL,
     rpid VARCHAR(128) DEFAULT NULL,
     CONSTRAINT subscriber_account_idx UNIQUE (username, domain)
 );