[sr-dev] sipcapture uses reserved SQL key word as column name

[Øyvind Kolbu]

On 17.01.2013 14:08, Alexandr Dubovikov wrote:
> HI,
>
> as a quick workaround, you can set the new field name for
> "authorization_column"
>
> ----- code start ----
> #PostgreSQL don't like "authorization"
> modparam("sipcapture", "authorization_column", "auth");
> ----- code end ----

The SQL standard doesn't like "authorization" and neither should MySQL.

> and change the db schema for postgress.
>
> or i can do opposite, rename the "authorization" field to "auth" and for
> back compatibility use modparam.

Thanks, but it should be done properly as the same change must also be
done in Homer. Thus update the general/mysql schema to not use SQL
reserved key words.

authorization -> auth is fine by me.

-- 
Øyvind