[Serdev] patch for msilo.sql

Alfred E. Heggestad aeh at db.org
Sat Jan 13 00:38:31 UTC 2007


hi

I just installed MSILO with SER, and found that the SQL script for
creating the database was abit out of date. After reading the code
in modules/msilo I changed the SQL abit, and it seems to work..
Suggested patch below: (not sure if all columns are used..)


/alfred


Index: modules/msilo/doc/msilo.sql
===================================================================
RCS file: /cvsroot/ser/sip_router/modules/msilo/doc/msilo.sql,v
retrieving revision 1.8
diff -u -1 -r1.8 msilo.sql
--- modules/msilo/doc/msilo.sql 2 Sep 2005 10:53:08 -0000       1.8
+++ modules/msilo/doc/msilo.sql 13 Jan 2007 00:38:22 -0000
@@ -18,3 +18,3 @@

-INSERT INTO version (table_name, table_version) VALUES ('silo', 3);
+INSERT INTO version (table_name, table_version) VALUES ('silo', 4);

@@ -24,8 +24,8 @@
      mid INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
-      -- src address - From URI
-    src_addr VARCHAR(255) NOT NULL DEFAULT "",
-      -- dst address - To URI
-    dst_addr VARCHAR(255) NOT NULL DEFAULT "",
-      -- r-uri == username at domain (for compatibility with old version)
-    r_uri VARCHAR(255) NOT NULL DEFAULT "",
+      -- From URI
+    from_hdr VARCHAR(255) NOT NULL DEFAULT "",
+      -- To URI
+    to_hdr VARCHAR(255) NOT NULL DEFAULT "",
+      -- ruri == username at domain (for compatibility with old version)
+    ruri VARCHAR(255) NOT NULL DEFAULT "",
        -- username
@@ -35,5 +35,5 @@
        -- incoming time
-    inc_time INTEGER NOT NULL DEFAULT 0,
+    inc_time DATETIME NOT NULL DEFAULT 0,
        -- expiration time
-    exp_time INTEGER NOT NULL DEFAULT 0,
+    exp_time DATETIME NOT NULL DEFAULT 0,
        -- content type



More information about the Serdev mailing list