database_utils/migrations/down/34_remove_wim_tables.sql

   1 --
   2 -- Tear down database structure required for integrating OSM with
   3 -- Wide Are Network Infrastructure Managers
   4 --
   5
   6 DROP TABLE IF EXISTS wim_port_mappings;
   7 DROP TABLE IF EXISTS wim_nfvo_tenants;
   8 DROP TABLE IF EXISTS instance_wim_nets;
   9
  10 ALTER TABLE `vim_wim_actions` DROP FOREIGN KEY `FK_actions_wims`;
  11 ALTER TABLE `vim_wim_actions` DROP INDEX `FK_actions_wims`;
  12 ALTER TABLE `vim_wim_actions` DROP INDEX `item_type_id`;
  13 ALTER TABLE `vim_wim_actions` MODIFY `item` enum(
  14   'datacenters_flavors',
  15   'datacenter_images',
  16   'instance_nets',
  17   'instance_vms',
  18   'instance_interfaces') NOT NULL
  19   COMMENT 'table where the item is stored';
  20 ALTER TABLE `vim_wim_actions` MODIFY `datacenter_vim_id` varchar(36) NOT NULL;
  21 ALTER TABLE `vim_wim_actions` DROP `wim_internal_id`, DROP `wim_account_id`;
  22 ALTER TABLE `vim_wim_actions` RENAME TO `vim_actions`;
  23
  24 DROP TABLE IF EXISTS wim_accounts;
  25 DROP TABLE IF EXISTS wims;
  26
  27 DELETE FROM schema_version WHERE version_int='34';