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

Module: sip-router Branch: master Commit: 6e51a4d83fd13876c6bfa71cef65a001145de52e URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=6e51a4d… Author: Henning Westerholt <henning.westerholt(a)1und1.de> Committer: Henning Westerholt <henning.westerholt(a)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,