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',
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`
;
28 DROP TABLE IF EXISTS wim_accounts
;
29 DROP TABLE IF EXISTS wims
;
31 DELETE FROM schema_version
WHERE version_int
='34';