Module: kamailio Branch: master Commit: ec0bcd9ba9ef3631a9f603b7ad7b8faa7c406c28 URL: https://github.com/kamailio/kamailio/commit/ec0bcd9ba9ef3631a9f603b7ad7b8fa… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)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/ec0bcd9ba9ef3631a9f603b7ad7b8fa… Patch: https://github.com/kamailio/kamailio/commit/ec0bcd9ba9ef3631a9f603b7ad7b8fa… --- 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) );