[PATCH] Fix upgrade script for postgresql

[bram]

The upgrade script has several problems with postgresl:

a) postgresql does not support the syntax: alter table ... add ... after ....
This syntax is used to update the tables: 'faqdata' and 'faqdata_revisions'.
Fix this by creating a temporary table and copy'ing the data.

b) the 'faqsearches' was created with an id field of the type integer instead of serial.
No auto increment happens => errors when doing a second search


Attached is a patch that fixes this (0003-Fix-upgrade-script-for-postgresql.patch).
NOTE: this patch was originally written on 2.6.7. It is untested on the git HEAD.

[Thorsten]

Hi,

thanks for the patch, I reviewed it and added to phpMyFAQ 2.6.8.

bye
Thorsten