[sr-dev] git:master: scripts/mysql: updated 'gw' and 'lcr' table definitions

Juha Heinanen jh at tutpro.com
Sun Jul 5 09:59:07 CEST 2009


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

Author: Juha Heinanen <jh at tutpro.com>
Committer: Juha Heinanen <jh at tutpro.com>
Date:   Sun Jul  5 10:55:48 2009 +0300

scripts/mysql: updated 'gw' and 'lcr' table definitions

- Updated 'gw' and 'lcr' MySQL table definitions.
- No idea if a schema exists somewhere where sr tables are
  auto-generated.
- The tables are assumed to have versions 10 and 3, respectively
  although there is no 'version' table in sr database.

---

 scripts/mysql/my_create.sql |   38 +++++++++++++++++++-------------------
 1 files changed, 19 insertions(+), 19 deletions(-)

diff --git a/scripts/mysql/my_create.sql b/scripts/mysql/my_create.sql
index 45f38e7..fc27798 100644
--- a/scripts/mysql/my_create.sql
+++ b/scripts/mysql/my_create.sql
@@ -204,31 +204,31 @@ CREATE TABLE phonebook (
 );
 
 CREATE TABLE gw (
+    id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
+    lcr_id SMALLINT UNSIGNED NOT NULL DEFAULT 1,
     gw_name VARCHAR(128) NOT NULL,
-    ip_addr INT UNSIGNED NOT NULL,
+    grp_id INT UNSIGNED NOT NULL,
+    ip_addr VARCHAR(15) NOT NULL,
+    hostname VARCHAR(64),
     port SMALLINT UNSIGNED,
     uri_scheme TINYINT UNSIGNED,
-    transport SMALLINT UNSIGNED,
-    prefix VARCHAR(16) NOT NULL,
-    grp_id INT NOT NULL,
-    UNIQUE KEY gw_idx1 (gw_name),
-    KEY gw_idx2 (grp_id)
-);
-
-CREATE TABLE gw_grp (
-    grp_id INT AUTO_INCREMENT NOT NULL,
-    grp_name VARCHAR(64) NOT NULL,
-    UNIQUE KEY gwgrp_idx (grp_id)
+    transport TINYINT UNSIGNED,
+    strip TINYINT UNSIGNED,
+    tag VARCHAR(16) DEFAULT NULL,
+    weight INT UNSIGNED,
+    flags INT UNSIGNED DEFAULT 0 NOT NULL,
+    defunct INT UNSIGNED DEFAULT NULL,
+    CONSTRAINT lcr_id_gw_name_idx UNIQUE (lcr_id, gw_name)
 );
 
 CREATE TABLE lcr (
-    prefix VARCHAR(16) NOT NULL,
-    from_uri VARCHAR(255) NOT NULL DEFAULT '%',
-    grp_id INT,
-    priority INT,
-    KEY lcr_idx1 (prefix),
-    KEY lcr_idx2 (from_uri),
-    KEY lcr_idx3 (grp_id)
+    id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
+    lcr_id SMALLINT UNSIGNED NOT NULL DEFAULT 1,
+    prefix VARCHAR(16) DEFAULT NULL,
+    from_uri VARCHAR(64) DEFAULT NULL,
+    grp_id INT UNSIGNED NOT NULL,
+    priority TINYINT UNSIGNED NOT NULL,
+    INDEX lcr_id_idx (lcr_id)
 );
 
 CREATE TABLE grp (




More information about the sr-dev mailing list