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

[Bogdan-Andrei Iancu]

User: bogdan_iancu
Date: 2006/07/17 08:45:45 PDT

  OpenSER CVS - Commit Details

  Modified files:        (Branch: rel_1_1_0)
    scripts              postgresqldb.sh 
  Commit Log:
  backport:
  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
   - removed double definition of "usr_preferences_types" table and added
     missing definition of "active_sessions" table
  
  Revision  Changes    Path
  1.32.2.1  +85 -57    sip-server/scripts/postgresqldb.sh
   [ http://openser.cvs.sourceforge.net/openser/sip-server/scripts/postgresqldb.sh?r1=1.32&r2=1.32.2.1 ]