[sr-dev] git:pd/msrp: sca: restore correct table version number in db creation files .

Peter Dunkley peter.dunkley at crocodile-rcs.com
Wed Feb 6 14:51:40 CET 2013


Module: sip-router
Branch: pd/msrp
Commit: 60e60e26cebeea2d8e07ec4ffd036ab1f35e2f12
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=60e60e26cebeea2d8e07ec4ffd036ab1f35e2f12

Author: Andrew Mortensen <admorten at isc.upenn.edu>
Committer: Andrew Mortensen <admorten at isc.upenn.edu>
Date:   Fri Feb  1 11:45:32 2013 -0500

sca: restore correct table version number in db creation files.

- Had been reverted by commit f636e215089a9b14daa113d93025831e827192b5
  because the schema xml file had the wrong version number.

---

 utils/kamctl/db_berkeley/kamailio/version |    2 +-
 utils/kamctl/db_sqlite/sca-create.sql     |    2 +-
 utils/kamctl/dbtext/kamailio/version      |    2 +-
 utils/kamctl/mysql/sca-create.sql         |    2 +-
 utils/kamctl/oracle/sca-create.sql        |    2 +-
 utils/kamctl/postgres/sca-create.sql      |    2 +-
 6 files changed, 6 insertions(+), 6 deletions(-)

diff --git a/utils/kamctl/db_berkeley/kamailio/version b/utils/kamctl/db_berkeley/kamailio/version
index eb1d8e7..ef9cac4 100644
--- a/utils/kamctl/db_berkeley/kamailio/version
+++ b/utils/kamctl/db_berkeley/kamailio/version
@@ -95,7 +95,7 @@ rls_presentity|1
 rls_watchers|
 rls_watchers|3
 sca_subscriptions|
-sca_subscriptions|0
+sca_subscriptions|1
 silo|
 silo|7
 sip_trace|
diff --git a/utils/kamctl/db_sqlite/sca-create.sql b/utils/kamctl/db_sqlite/sca-create.sql
index 1327b3f..46429fb 100644
--- a/utils/kamctl/db_sqlite/sca-create.sql
+++ b/utils/kamctl/db_sqlite/sca-create.sql
@@ -1,4 +1,4 @@
-INSERT INTO version (table_name, table_version) values ('sca_subscriptions','0');
+INSERT INTO version (table_name, table_version) values ('sca_subscriptions','1');
 CREATE TABLE sca_subscriptions (
     id INTEGER PRIMARY KEY NOT NULL,
     subscriber VARCHAR(255) NOT NULL,
diff --git a/utils/kamctl/dbtext/kamailio/version b/utils/kamctl/dbtext/kamailio/version
index 9a3fe62..f76df16 100644
--- a/utils/kamctl/dbtext/kamailio/version
+++ b/utils/kamctl/dbtext/kamailio/version
@@ -42,7 +42,7 @@ purplemap:1
 re_grp:1
 rls_presentity:1
 rls_watchers:3
-sca_subscriptions:0
+sca_subscriptions:1
 silo:7
 sip_trace:3
 speed_dial:2
diff --git a/utils/kamctl/mysql/sca-create.sql b/utils/kamctl/mysql/sca-create.sql
index f1633c6..b48d38b 100644
--- a/utils/kamctl/mysql/sca-create.sql
+++ b/utils/kamctl/mysql/sca-create.sql
@@ -1,4 +1,4 @@
-INSERT INTO version (table_name, table_version) values ('sca_subscriptions','0');
+INSERT INTO version (table_name, table_version) values ('sca_subscriptions','1');
 CREATE TABLE sca_subscriptions (
     id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
     subscriber VARCHAR(255) NOT NULL,
diff --git a/utils/kamctl/oracle/sca-create.sql b/utils/kamctl/oracle/sca-create.sql
index 430fd66..f63ee40 100644
--- a/utils/kamctl/oracle/sca-create.sql
+++ b/utils/kamctl/oracle/sca-create.sql
@@ -1,4 +1,4 @@
-INSERT INTO version (table_name, table_version) values ('sca_subscriptions','0');
+INSERT INTO version (table_name, table_version) values ('sca_subscriptions','1');
 CREATE TABLE sca_subscriptions (
     id NUMBER(10) PRIMARY KEY,
     subscriber VARCHAR2(255),
diff --git a/utils/kamctl/postgres/sca-create.sql b/utils/kamctl/postgres/sca-create.sql
index 94ce539..b5da925 100644
--- a/utils/kamctl/postgres/sca-create.sql
+++ b/utils/kamctl/postgres/sca-create.sql
@@ -1,4 +1,4 @@
-INSERT INTO version (table_name, table_version) values ('sca_subscriptions','0');
+INSERT INTO version (table_name, table_version) values ('sca_subscriptions','1');
 CREATE TABLE sca_subscriptions (
     id SERIAL PRIMARY KEY NOT NULL,
     subscriber VARCHAR(255) NOT NULL,




More information about the sr-dev mailing list