Upgrade Blues Rollback SQL Script

— This script is probably a one-off!
— Created to undo the damage of the original D6 to D7 upgrade to the live site before rehearsing on premise

USE cnueu_drpldb;
ALTER TABLE system DROP INDEX system_list;
ALTER TABLE `url_alias` DROP `alias`;
ALTER TABLE `url_alias` DROP `source`;
ALTER TABLE `menu_router` DROP `delivery_callback`;
ALTER TABLE `menu_router` DROP `context`;
ALTER TABLE `menu_router` DROP `theme_callback`;
ALTER TABLE `menu_router` DROP `theme_arguments`;
DROP TABLE `role_permission`;
DROP TABLE `date_formats`;
DROP TABLE `date_format_locale`;
DROP TABLE `date_format_type`;
RENAME TABLE d6_date_formats TO date_formats, d6_date_format_locale TO date_format_locale;
CREATE TABLE IF NOT EXISTS `actions_aid` (`aid` varchar(255) NOT NULL DEFAULT ‘0’);

And that’s it! Database repaired enough for the update utility to run. What next?