SQL compare script

Use GitHub to post feature requests for phpwcms.
Locked
User avatar
pSouper
Posts: 1552
Joined: Tue 11. Nov 2003, 15:45
Location: London
Contact:

SQL compare script

Post by pSouper »

Hi guys,

I see a few issues that stem from an incomplete database and/or udpates to it and thought I'd love a script that will compare the latest version of the phpwcms required database and the settings of the tables within and then either hightlight or offer to correct the differences.

very simmiler to the upgrade.php but instead of using a seperate .sql it use the new full and amended .sql in a [try() catch()] kind of way.

is try() catch() even possible with php/sql?
I would be surprised if not and very doubtfull if it could not be coded at all.

of course this request wouldn't be because I'm having a f*ing nightmare with my database right now ;)
Locked