[sr-dev] git:master: db schema: removed unique requirement from pua expires_idx

Module: sip-router Branch: master Commit: bedb7fdc6d02e92fbf52ad4acb6dfcbb49f0bc49 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=bedb7fd… Author: Juha Heinanen &lt;jh(a)tutpro.com&gt; Committer: Juha Heinanen &lt;jh(a)tutpro.com&gt; Date: Fri Sep 7 19:16:37 2012 +0300 db schema: removed unique requirement from pua expires_idx - TODO: change also other than mysql table structures --- lib/srdb1/schema/pr_pua.xml | 1 - utils/kamctl/mysql/presence-create.sql | 3 +-- 2 files changed, 1 insertions(+), 3 deletions(-) diff --git a/lib/srdb1/schema/pr_pua.xml b/lib/srdb1/schema/pr_pua.xml index 5bd690b..0351768 100644 --- a/lib/srdb1/schema/pr_pua.xml +++ b/lib/srdb1/schema/pr_pua.xml @@ -163,7 +163,6 @@ <index> <name>expires_idx</name> <colref linkend="expires"/> - <unique/> </index> <index> diff --git a/utils/kamctl/mysql/presence-create.sql b/utils/kamctl/mysql/presence-create.sql index 5584f8e..7f68249 100644 --- a/utils/kamctl/mysql/presence-create.sql +++ b/utils/kamctl/mysql/presence-create.sql @@ -103,7 +103,6 @@ CREATE TABLE pua ( version INT(11) NOT NULL, extra_headers TEXT NOT NULL, CONSTRAINT pua_idx UNIQUE (etag, tuple_id, call_id, from_tag), - CONSTRAINT expires_idx UNIQUE (expires) ) ENGINE=MyISAM; CREATE INDEX dialog1_idx ON pua (call_id, from_tag, to_tag); @@ -112,4 +111,4 @@ CREATE INDEX tmp_dlg1_idx ON pua (call_id, from_tag); CREATE INDEX tmp_dlg2_idx ON pua (pres_id, pres_uri, call_id, from_tag); CREATE INDEX tmp_record1_idx ON pua (pres_id); CREATE INDEX tmp_record2_idx ON pua (pres_id, etag); - +CREATE INDEX expires_idx ON pua (expires);