[Devel] Re: [Serdev] Problem creating tables for testing the Oracle module

Daniel-Constantin Mierla daniel at voice-system.ro
Tue Oct 11 19:30:13 CEST 2005


'server_monitoring' table is used only by serweb, neither openser nor 
ser uses it directly.

Cheers,
Daniel

On 10/11/05 20:18, Juan Carlos Castro y Castro wrote:
> "increment". Funny, it doesn't seem to be used anywhere in OpenSER. 
> Maybe it is used by SER proper.
>
> And now I get something more sinister. It seems there's no distinction 
> between zero-length strings and NULL value in Oracle. I may have to 
> allow NULLs in all char fields that have "empty string" as default. Is 
> that right?
>
> Klaus Darilion wrote:
>
>> Juan Carlos Castro y Castro wrote:
>>
>>> This table has a field name that is a reserved word in Oracle. 
>>> (You'll see this layout already has the other changes for Oracle) Is 
>>> this changed in CVS? Where could I change it in the stable version?
>>
>>
>> Which field?
>>
>> regards
>> klaus
>>
>>>
>>> CREATE TABLE server_monitoring (
>>>  time date default TIMESTAMP '0000-01-01 00:00:00' NOT NULL,
>>>  id int default '0' NOT NULL,
>>>  param varchar(32) default '' NOT NULL,
>>>  value int default '0' NOT NULL,
>>>  increment int default '0' NOT NULL,
>>>  PRIMARY KEY  (id,param)
>>> );
>>>
>>>
>>> _______________________________________________
>>> Serdev mailing list
>>> Serdev at iptel.org
>>> http://mail.iptel.org/mailman/listinfo/serdev
>>>
>>>
>>
>>
>
>
> _______________________________________________
> Devel mailing list
> Devel at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/devel
>



More information about the Devel mailing list