[Devel] CVS commitlog: sip-server/scripts mysqldb.sh postgresqldb.sh

[Bogdan-Andrei Iancu]

Hi Norm,

thanks again for your help - the fixup is on the CVS!

Best regards,
Bogdan

Norman Brandinger wrote:

> The following change appears to work on PostgreSQL.
>
> /*
> * Extend table 'subscriber' with serweb specific columns
> */
> ALTER TABLE subscriber
>  add column phplib_id varchar(32) NOT NULL default '',
>  add column phone varchar(15) NOT NULL default '',
>  add column datetime_modified $TIMESTAMP,
>  add column confirmation varchar(64) NOT NULL default '',
>  add column flag char(1) NOT NULL default 'o',
>  add column sendnotification varchar(50) NOT NULL default '',
>  add column greeting varchar(50) NOT NULL default '',
>  add column allow_find char(1) NOT NULL default '0',
>  add constraint phplib_id_key unique (phplib_id)
> ;
>
> Regards,
> Norm
>
> Bogdan-Andrei Iancu wrote:
>
>> Hi,
>>
>> if some of the postgres users will be willing to test the changes 
>> into "postgresqldb.sh" will be very, very helpful - not sure if the 
>> ALTER TABLE syntax is similar to mysql ....
>>
>> regards,
>> bogdan
>>
>>
>>
>> Bogdan-Andrei Iancu wrote:
>>
>>> User: bogdan_iancu
>>> Date: 2006/10/27 06:21:54 PDT
>>>
>>>  OpenSER CVS - Commit Details
>>>
>>>  Modified files:
>>>    scripts              mysqldb.sh postgresqldb.sh  Commit Log:
>>>  - subscriber table cleanup:
>>>    unused columns dropped (uuid and dom)
>>>    added "id" column (autoincrement) as PRIMARY KEY
>>>    serweb specific columns/keys are added only id serweb is installed
>>>  - initial "admin" user creadted ONLY if serweb is installed.
>>>  
>>>  Revision  Changes    Path
>>>  1.40      +57 -56    sip-server/scripts/mysqldb.sh
>>>   [ 
>>> http://openser.cvs.sourceforge.net/openser/sip-server/scripts/mysqldb.sh?r1=1.39&r2=1.40 
>>> ]
>>>  1.48      +52 -57    sip-server/scripts/postgresqldb.sh
>>>   [ 
>>> http://openser.cvs.sourceforge.net/openser/sip-server/scripts/postgresqldb.sh?r1=1.47&r2=1.48 
>>> ]
>>>
>>> _______________________________________________
>>> Devel mailing list
>>> Devel at openser.org
>>> http://openser.org/cgi-bin/mailman/listinfo/devel
>>>
>>>  
>>>
>>
>>
>> _______________________________________________
>> Devel mailing list
>> Devel at openser.org
>> http://openser.org/cgi-bin/mailman/listinfo/devel
>>
>>
>