SQL to remove module from DB (and reinstall)

[jaromirmuller]

Maybe you will find useful the following SQL to remove & reinstall module.

drop function ECOMDEV_CLEAN_URL_KEY;

drop table ecomdev_urlrewrite_category_relation;
drop table ecomdev_urlrewrite_category_request_path;
drop table ecomdev_urlrewrite_category_url_key;
drop table ecomdev_urlrewrite_duplicate;
drop table ecomdev_urlrewrite_duplicate_aggregate;
drop table ecomdev_urlrewrite_duplicate_increment;
drop table ecomdev_urlrewrite_duplicate_key;
drop table ecomdev_urlrewrite_duplicate_updated;
drop table ecomdev_urlrewrite_product_relation;
drop table ecomdev_urlrewrite_product_request_path;
drop table ecomdev_urlrewrite_product_url_key;
drop table ecomdev_urlrewrite_rewrite;
drop table ecomdev_urlrewrite_root_category;

delete from core_resource where code = 'ecomdev_urlrewrite_setup' limit 1;

I had to reinstall module again, there was issue with stored procedure for different user. I have happend during migration to another db server.