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

[Bogdan-Andrei Iancu]

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 ]