[Serdev] patch for msilo.sql

[Greger V. Teigre]

Alfred,
Could you please register it on the tracker?
We have not branched yet and some patches will have to wait. I just want 
to make that things disappear :-)
g-)

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
>
>