Module: sip-router
Branch: master
Commit: 60e60e26cebeea2d8e07ec4ffd036ab1f35e2f12
URL:
http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=60e60e2…
Author: Andrew Mortensen <admorten(a)isc.upenn.edu>
Committer: Andrew Mortensen <admorten(a)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,