[Serdev] patch for msilo.sql
Vaclav Kubart
vaclav.kubart at iptel.org
Mon Jan 15 08:04:46 UTC 2007
Hi,
I'm sorry for confusion, the file doc/msilo.sql is a residue from very
old times and it should not be used. The "silo" table is described in
db/schema/silo.xml like other tables and SQL code for its creation is
generated together with the rest of SER's database.
Vaclav
On Sat, Jan 13, 2007 at 01:38:31AM +0100, Alfred E. Heggestad wrote:
> 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
>
> _______________________________________________
> Serdev mailing list
> Serdev at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serdev
More information about the Serdev
mailing list