From d1e40a55aff988007d33fccff401e9e31caaf768 Mon Sep 17 00:00:00 2001 From: Antony Lesuisse Date: Mon, 26 Sep 2011 02:54:44 +0200 Subject: [IMP] directory cleanups, moved historical cruft into history bzr revid: al@openerp.com-20110926005444-a7vqjb05vep7xbvj --- sql/clean-model.sql | 24 ------------------------ 1 file changed, 24 deletions(-) delete mode 100644 sql/clean-model.sql (limited to 'sql') diff --git a/sql/clean-model.sql b/sql/clean-model.sql deleted file mode 100644 index 59b492aab2d..00000000000 --- a/sql/clean-model.sql +++ /dev/null @@ -1,24 +0,0 @@ - -SELECT model, res_id, module FROM ir_model_data - WHERE model = 'ir.actions.act_window' - AND NOT EXISTS (SELECT 1 FROM ir_act_window WHERE id = ir_model_data.res_id); - - -SELECT model, res_id, module FROM ir_model_data - WHERE model = 'ir.ui.menu' - AND NOT EXISTS (SELECT 1 FROM ir_ui_menu WHERE id = ir_model_data.res_id); - -SELECT model, res_id, module FROM ir_model_data - WHERE model = 'ir.ui.view' - AND NOT EXISTS (SELECT 1 FROM ir_ui_view WHERE id = ir_model_data.res_id); - -DONT DELETE FROM ir_model_data - WHERE model = 'ir.actions.act_window' - AND NOT EXISTS (SELECT 1 FROM ir_act_window WHERE id = ir_model_data.res_id); - -DONT DELETE FROM ir_model_data - WHERE model = 'ir.ui.menu' - AND NOT EXISTS (SELECT 1 FROM ir_ui_menu WHERE id = ir_model_data.res_id); --- Other cleanups: --- DELETE from ir_model_data where module = 'audittrail' AND model = 'ir.ui.view' AND NOT EXISTS( SELECT 1 FROM ir_ui_view WHERE ir_ui_view.id = ir_model_data.res_id); --- DELETE from ir_model_data where module = 'audittrail' AND model = 'ir.ui.menu' AND NOT EXISTS( SELECT 1 FROM ir_ui_menu WHERE id = ir_model_data.res_id); \ No newline at end of file -- cgit v1.2.3