[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