Module: sip-router Branch: master Commit: d8fc55f0dec978a09bfd1aead4be55e2a1855d91 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=d8fc55f… Author: Marius Zbihlei <marius.zbihlei(a)1and1.ro> Committer: Marius Zbihlei <marius.zbihlei(a)1and1.ro> Date: Wed Mar 21 18:45:36 2012 +0200 modules_k/p_usrloc:Fixed sql table creation scheme TODO: create serdb schema definition Patch by Dragos Dinu (Dragos.Dinu AT 1and1.ro --- modules_k/p_usrloc/location.sql | 38 ++++++++++++++++++++------------------ 1 files changed, 20 insertions(+), 18 deletions(-) diff --git a/modules_k/p_usrloc/location.sql b/modules_k/p_usrloc/location.sql index d8203a7..a80902a 100644 --- a/modules_k/p_usrloc/location.sql +++ b/modules_k/p_usrloc/location.sql @@ -1,20 +1,22 @@ -drop table location; +drop table if exists location; CREATE TABLE location ( -username VARCHAR(64) NOT NULL, -aor VARCHAR(255) NOT NULL, -contact VARCHAR(255) NOT NULL, -server_id INT NOT NULL DEFAULT '0', -received VARCHAR(255), -expires DATETIME NOT NULL DEFAULT '1970-01-01 00:00:00', -q FLOAT NOT NULL DEFAULT '1.0', -callid VARCHAR(255), -cseq INT UNSIGNED, -flags INT UNSIGNED NOT NULL DEFAULT '0', -cflags INT UNSIGNED NOT NULL DEFAULT '0', -user_agent VARCHAR(64), -instance VARCHAR(255), -UNIQUE KEY location_key (username, contact), -KEY location_contact (contact), -KEY location_expires (expires) -); + id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL, + username VARCHAR(64) DEFAULT '' NOT NULL, + domain VARCHAR(64) DEFAULT NULL, + contact VARCHAR(255) DEFAULT '' NOT NULL, + received VARCHAR(128) DEFAULT NULL, + path VARCHAR(128) DEFAULT NULL, + expires DATETIME DEFAULT '2020-05-28 21:32:15' NOT NULL, + q FLOAT(10,2) DEFAULT 1.0 NOT NULL, + callid VARCHAR(255) DEFAULT 'Default-Call-ID' NOT NULL, + cseq INT(11) DEFAULT 1 NOT NULL, + last_modified DATETIME DEFAULT '1900-01-01 00:00:01' NOT NULL, + flags INT(11) DEFAULT 0 NOT NULL, + cflags INT(11) DEFAULT 0 NOT NULL, + user_agent VARCHAR(255) DEFAULT '' NOT NULL, + socket VARCHAR(64) DEFAULT NULL, + methods INT(11) DEFAULT NULL +) ENGINE=MyISAM; + +CREATE INDEX account_contact_idx ON location (username, domain, contact);