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

[Bogdan-Andrei Iancu]

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 <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
>
>
>