DB Cleanup Script

[SemperFidelis]

Basically Im looking for a script that takes my current vb 2.3.2 db which multiple hacks have been applied to and restore it to the same schema as a standard vb 2.3.2 db.

Obviously I want all members, forums, permissions etc kept.
Just stripping out anything I have added over time.

An added bonuswould also be removing all the additional styles and custom templates combined with rolling back the default ones to standard.

When the time is right, I want to be able to run this script to 'cleanse' my db before taking the upgrade to vb3.

Any assistnace would be greatly appreciated.
Thanks in advance.

[Logician]

Your best bet is to get through the installation instructions of your hacks and find which hack included ALTER/CREATE TABLE SQL commands. Then you can remove these hack tables/fields manually.

Also it is not a big deal anyway, because VB3 also has a clash check script and if your hacks created table fields which clash with new VB3 fields, it warns you. If there are no clashes, your hack fields/tables are harmless to VB3 anyway

[SemperFidelis]

Thanks for the reply Logician


Im not concerned about clashes, as I already know it upgrades just fine.
What Im trying to do is remove all the 'dead weight' that will no longer be required.

Ive upgraded this db from vb 2.0, so its being added to quite extensively.

Unfortunately for me, all my doco I had on what hacks did what, was lost in a damn nasty HD failure I had a coupel of months ago.
Ive manged to strip out 40 odd additional tables, buts its all the alters to the stock vb tables I really want to get rid of.

And then there is all the templates Id like to take out of the system.

It would be fantastic if I could just run a script that does all this for me right before I upgrade to vb 3.0.

So any suggestions on how to achieve this would be great !