[Serdev] Oracle reserved words in SER DB schema

[Jan Janak]

Dmitry,

I changed uid to uuid and access to attr_access for oracle. New oracle
scripts are in sip_router/scripts/oracle. Could you, please, try them to
make sure that they can be loaded into oracle and close:

http://tracker.iptel.org/browse/SER-150

if it works? (reopen the issue if it does not work).

  Jan.

Note that we will also need to reconfigure ser to use uuid instead of
uid, but I would like to verify that we can load the scripts into the
database first.

Dmitry Semyonov wrote:
> Hello Jan,
> 
> On Mon, 20 Nov 2006 at 00:43 +0100, Jan Janak wrote:
> 
>> Yes, we can override names that conflict with oracle reserved words. 
>> Could you get me the list of conflicting column names?
> 
> Column name (table(s)):
>  * uid (credentials, user_attrs, location, contact_attrs, phonebook,
>         grp, silo, uri, speed_dial, presentity, offline_winfo, cpl);
>  * access (attr_types).
> 
> Index name (table(s)):
>  * uid (credentials).
>