[Serdev] patch for msilo.sql

[Vaclav Kubart]

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