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

[Klaus Darilion]

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 <norm at goes.com>
>    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 at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/devel