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@openser.org
http://openser.org/cgi-bin/mailman/listinfo/devel
_______________________________________________
Devel mailing list
Devel@openser.org
http://openser.org/cgi-bin/mailman/listinfo/devel
_______________________________________________
Devel mailing list
Devel@openser.org
http://openser.org/cgi-bin/mailman/listinfo/devel
