it's done.
regards,
bogdan
Klaus Darilion wrote:
please backport to 1.1
regards
klaus
Bogdan-Andrei Iancu wrote:
User: bogdan_iancu
Date: 2006/07/14 10:28:57 PDT
OpenSER CVS - Commit Details
Modified files:
scripts postgresqldb.sh Commit Log:
Applied path for correcting syntax from MySQL to Postgres:
- moved INDEX creation out of CREATE table statement into
CREATE INDEX (usr_preferences, trusted)
- auto_increment isn't valid in Postgres, replaced with
local AUTO_INCREMENT
- datetime isn't valid in Postgres, replaced with local DATETIME
- split GRANTs for SERWeb tables so that it is only executed
if SERWeb tables are created
- added GRANTs for re_grp table
- added CREATE pd_multidomain table (from PDT module)
- corrected comments to indicate Postgres as opposed to MySQL
- made last_modified/created stamps consistent to now() using
local TIMESTAMP
Credits go to Norman Brandinger <[EMAIL PROTECTED]>
Closes 1522180, 1522182, 1522303
Revision Changes Path
1.33 +75 -48 sip-server/scripts/postgresqldb.sh
[
http://openser.cvs.sourceforge.net/openser/sip-server/scripts/postgresqldb.sh?r1=1.32&r2=1.33
]
_______________________________________________
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