2 -- Tear down database structure required for integrating OSM with
3 -- Wide Are Network Infrastructure Managers
6 DROP TABLE IF EXISTS wim_port_mappings
;
7 DROP TABLE IF EXISTS wim_nfvo_tenants
;
8 DROP TABLE IF EXISTS instance_wim_nets
;
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',
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`
;
24 DROP TABLE IF EXISTS wim_accounts
;
25 DROP TABLE IF EXISTS wims
;
27 DELETE FROM schema_version
WHERE version_int
='34';