Quick Database Check
 

Quick Database Check

Description
Many Hacks add data (tables, fields) to your database, and not all of them do hav e uninstall functions.
So after some time you may end up with a total mess, as you don't know what is standard and what not.

Then this tool is for you - it shows you which tables are non-standard, which fields have been added to standard tables.

Maybe planned features

• Exact check of column definition
• Check indexes
• Check for non-standard settings, settinggroups, templates, phrase & phrasegroups

Please note: If you currently do have Hacks installed, it will report all their tables/fields as non-standard, as there is no way to determine which belong to installed Hacks.

Usage
Just "import" the product XML (import will not complete, so nothing is ever added to your DB or filesystem).

Version History
1.0.0
Initial Version

1.1.0
Added proper support for table prefixes
Changed field detaction a bit

Very nice and clean Kirby. Just a few questions that pop into my mind when i look at the xml:
- Will this not give a false positive if i for example activated full text search?
- Will it also detect missing tables/columns

No, as it currently does not check for missing tables/fields, only for added.
And if you enable FT, two tables will be dropped (postindex, word)

As said, this was just a quick shot as I was annoyed having to cleanup a DB manually ;)

Thanks for this hack, i have been getting aggrevated at the current state of my database.

THANK YOU!!!!

/me clicks install.

Might want to alert people that they need to have install/mysql-schema.php uploaded. Many delete their install folder.

PHP alert's you if it is not there ;)

True. Just trying to have people not asking you about the error they will get.

Btw, nice. Found a couple of importid's I had missed.

RE: Maybe planned features.
Please do! :)

This is great...I do not mean to sound like a total fool, however, once you know what changes have been made, how do you revert them?

Thank you!!

I think it is useful

Thanks :)