[sr-dev] git:master: db_sqlite: synchronize database schema with other engines

[Henning Westerholt]

Module: sip-router
Branch: master
Commit: 6e51a4d83fd13876c6bfa71cef65a001145de52e
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=6e51a4d83fd13876c6bfa71cef65a001145de52e

Author: Henning Westerholt <henning.westerholt at 1und1.de>
Committer: Henning Westerholt <henning.westerholt at 1und1.de>
Date:   Mon Jun 20 13:45:47 2011 +0200

db_sqlite: synchronize database schema with other engines

---

 utils/kamctl/db_sqlite/lcr-create.sql |    5 +++--
 utils/kamctl/db_sqlite/rls-create.sql |    4 ++--
 2 files changed, 5 insertions(+), 4 deletions(-)

diff --git a/utils/kamctl/db_sqlite/lcr-create.sql b/utils/kamctl/db_sqlite/lcr-create.sql
index bf93141..0671625 100644
--- a/utils/kamctl/db_sqlite/lcr-create.sql
+++ b/utils/kamctl/db_sqlite/lcr-create.sql
@@ -13,10 +13,11 @@ CREATE TABLE lcr_gw (
     prefix VARCHAR(16) DEFAULT NULL,
     tag VARCHAR(64) DEFAULT NULL,
     flags INTEGER DEFAULT 0 NOT NULL,
-    defunct INTEGER DEFAULT NULL,
-    CONSTRAINT lcr_gw_lcr_id_ip_addr_port_hostname_idx UNIQUE (lcr_id, ip_addr, port, hostname)
+    defunct INTEGER DEFAULT NULL
 );
 
+CREATE INDEX lcr_gw_lcr_id_idx ON lcr_gw (lcr_id);
+
 INSERT INTO version (table_name, table_version) values ('lcr_rule_target','1');
 CREATE TABLE lcr_rule_target (
     id INTEGER PRIMARY KEY NOT NULL,
diff --git a/utils/kamctl/db_sqlite/rls-create.sql b/utils/kamctl/db_sqlite/rls-create.sql
index b15120d..c3f3895 100644
--- a/utils/kamctl/db_sqlite/rls-create.sql
+++ b/utils/kamctl/db_sqlite/rls-create.sql
@@ -26,10 +26,10 @@ CREATE TABLE rls_watchers (
     event_id VARCHAR(64),
     to_tag VARCHAR(64) NOT NULL,
     from_tag VARCHAR(64) NOT NULL,
-    callid VARCHAR(64) NOT NULL,
+    callid VARCHAR(128) NOT NULL,
     local_cseq INTEGER NOT NULL,
     remote_cseq INTEGER NOT NULL,
-    contact VARCHAR(64) NOT NULL,
+    contact VARCHAR(128) NOT NULL,
     record_route TEXT,
     expires INTEGER NOT NULL,
     status INTEGER DEFAULT 2 NOT NULL,