[sr-dev] git:master: srdb1/dbschema: regenerated db creation scripts

Module: sip-router Branch: master Commit: 861603806e72876e0348c25031bcd64892023a20 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=8616038… Author: Daniel-Constantin Mierla <miconda(a)gmail.com> Committer: Daniel-Constantin Mierla <miconda(a)gmail.com> Date: Tue May 22 12:41:05 2012 +0200 srdb1/dbschema: regenerated db creation scripts - lcr_rule version update was not taken in consideration - reported by Timo Teräs --- utils/kamctl/db_berkeley/kamailio/version | 2 +- utils/kamctl/db_sqlite/lcr-create.sql | 2 +- utils/kamctl/dbtext/kamailio/version | 2 +- utils/kamctl/mysql/lcr-create.sql | 2 +- utils/kamctl/oracle/lcr-create.sql | 2 +- utils/kamctl/postgres/lcr-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 235d82b..c51ace4 100644 --- a/utils/kamctl/db_berkeley/kamailio/version +++ b/utils/kamctl/db_berkeley/kamailio/version @@ -63,7 +63,7 @@ imc_rooms|1 lcr_gw| lcr_gw|2 lcr_rule| -lcr_rule|1 +lcr_rule|2 lcr_rule_target| lcr_rule_target|1 location| diff --git a/utils/kamctl/db_sqlite/lcr-create.sql b/utils/kamctl/db_sqlite/lcr-create.sql index 8493e26..63eb37d 100644 --- a/utils/kamctl/db_sqlite/lcr-create.sql +++ b/utils/kamctl/db_sqlite/lcr-create.sql @@ -31,7 +31,7 @@ CREATE TABLE lcr_rule_target ( CREATE INDEX lcr_rule_target_lcr_id_idx ON lcr_rule_target (lcr_id); -INSERT INTO version (table_name, table_version) values ('lcr_rule','1'); +INSERT INTO version (table_name, table_version) values ('lcr_rule','2'); CREATE TABLE lcr_rule ( id INTEGER PRIMARY KEY NOT NULL, lcr_id SMALLINT NOT NULL, diff --git a/utils/kamctl/dbtext/kamailio/version b/utils/kamctl/dbtext/kamailio/version index 31bf74b..0396a99 100644 --- a/utils/kamctl/dbtext/kamailio/version +++ b/utils/kamctl/dbtext/kamailio/version @@ -26,7 +26,7 @@ htable:2 imc_members:1 imc_rooms:1 lcr_gw:2 -lcr_rule:1 +lcr_rule:2 lcr_rule_target:1 location:5 matrix:1 diff --git a/utils/kamctl/mysql/lcr-create.sql b/utils/kamctl/mysql/lcr-create.sql index f7dbf26..efa65b2 100644 --- a/utils/kamctl/mysql/lcr-create.sql +++ b/utils/kamctl/mysql/lcr-create.sql @@ -31,7 +31,7 @@ CREATE TABLE lcr_rule_target ( CREATE INDEX lcr_id_idx ON lcr_rule_target (lcr_id); -INSERT INTO version (table_name, table_version) values ('lcr_rule','1'); +INSERT INTO version (table_name, table_version) values ('lcr_rule','2'); CREATE TABLE lcr_rule ( id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, lcr_id SMALLINT UNSIGNED NOT NULL, diff --git a/utils/kamctl/oracle/lcr-create.sql b/utils/kamctl/oracle/lcr-create.sql index 530a798..5fe88a0 100644 --- a/utils/kamctl/oracle/lcr-create.sql +++ b/utils/kamctl/oracle/lcr-create.sql @@ -47,7 +47,7 @@ BEGIN map2users('lcr_rule_target'); END; / CREATE INDEX lcr_rule_target_lcr_id_idx ON lcr_rule_target (lcr_id); -INSERT INTO version (table_name, table_version) values ('lcr_rule','1'); +INSERT INTO version (table_name, table_version) values ('lcr_rule','2'); CREATE TABLE lcr_rule ( id NUMBER(10) PRIMARY KEY, lcr_id NUMBER(5), diff --git a/utils/kamctl/postgres/lcr-create.sql b/utils/kamctl/postgres/lcr-create.sql index 52f51c5..958213a 100644 --- a/utils/kamctl/postgres/lcr-create.sql +++ b/utils/kamctl/postgres/lcr-create.sql @@ -31,7 +31,7 @@ CREATE TABLE lcr_rule_target ( CREATE INDEX lcr_rule_target_lcr_id_idx ON lcr_rule_target (lcr_id); -INSERT INTO version (table_name, table_version) values ('lcr_rule','1'); +INSERT INTO version (table_name, table_version) values ('lcr_rule','2'); CREATE TABLE lcr_rule ( id SERIAL PRIMARY KEY NOT NULL, lcr_id SMALLINT NOT NULL,