 -- rename mc content types to accelerator
 UPDATE `django_content_type`
 SET `app_label` = 'accelerator'
-WHERE `django_content_type`.`app_label` = 'mc';
+WHERE `django_content_type`.`app_label` = 'mc' AND
+      `django_content_type`.model NOT IN ('userrolemenu',
+                                          'nodepublishedfor',
+                                          'categoryheaderpage',
+                                          'siteredirectpage',
+                                          'filepage');
 
 -- rename mc tables to accelerator
 RENAME TABLE

                                 509,
                                 510,
                                 511);
DELETE
FROM `django_content_type`
WHERE `django_content_type`.`id` IN (128,
                                     129,
                                     130,
                                     131,
                                     132,
                                     136,
                                     137,
                                     138,
                                     139,
                                     140,
                                     141,
                                     142,
                                     143,
                                     144,
                                     145,
                                     146,
                                     147,
                                     148,
                                     149,
                                     150,
                                     151,
                                     152,
                                     153,
                                     154,
                                     155,
                                     156,
                                     157,
                                     158,
                                     159,
                                     160,
                                     161,
                                     162,
                                     163,
                                     164,
                                     165,
                                     166,
                                     167,
                                     168,
                                     169,
                                     170,
                                     171,
                                     172,
                                     173,
                                     174,
                                     175,
                                     176,
                                     177,
                                     178,
                                     179,
                                     180,
                                     181,
                                     182,
                                     183,
                                     184,
                                     185,
                                     186,
                                     187,
                                     188,
                                     189,
                                     190,
                                     191,
                                     192,
                                     193,
                                     194,
                                     195,
                                     196,
                                     197,
                                     198,
                                     199,
                                     200,
                                     201,
                                     202,
                                     203,
                                     204,
                                     205,
                                     206,
                                     207,
                                     208,
                                     209,
                                     210,
                                     211,
                                     212,
                                     213);
-- delete unused accelerator tables

DROP TABLE accelerator_jobposting;

FROM `django_migrations`
WHERE (`django_migrations`.`app` = 'accelerator'
       AND NOT (`django_migrations`.`id` = 179));
/*
MigrationRecorder.Migration.objects.filter(app='accelerator').exclude(
id=MigrationRecorder.Migration.objects.filter(app='accelerator').first().id
).delete()
*/


DELETE
