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

[admin at sip-router.org]

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

Author: Juha Heinanen <jh at tutpro.com>
Committer: Juha Heinanen <jh at tutpro.com>
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);