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

[Norman Brandinger]

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
>
>