[Devel] Re: [Serdev] Problem creating tables for testing the Oracle
module
Juan Carlos Castro y Castro
jcastro at instant.com.br
Tue Oct 11 19:18:57 CEST 2005
"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
>>
>>
>
>
More information about the Devel
mailing list