RO/osm_ro/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',
  19   'instance_sfis',
  20   'instance_sfs',
  21   'instance_classifications',
  22   'instance_sfps') NOT NULL
  23   COMMENT 'table where the item is stored';
  24 ALTER TABLE `vim_wim_actions` MODIFY `datacenter_vim_id` varchar(36) NOT NULL;
  25 ALTER TABLE `vim_wim_actions` DROP `wim_internal_id`, DROP `wim_account_id`;
  26 ALTER TABLE `vim_wim_actions` RENAME TO `vim_actions`;
  27
  28 DROP TABLE IF EXISTS wim_accounts;
  29 DROP TABLE IF EXISTS wims;
  30
  31 DELETE FROM schema_version WHERE version_int='34';