1 -- MySQL Workbench Synchronization
\r
2 -- Generated: 2017-07-10 12:52
\r
5 -- Project: Name of the project
\r
8 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
\r
9 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
\r
10 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
\r
12 ALTER SCHEMA `mso_catalog` DEFAULT CHARACTER SET latin1 DEFAULT COLLATE latin1_swedish_ci ;
\r
14 ALTER TABLE `mso_catalog`.`heat_nested_template`
\r
15 DROP FOREIGN KEY `fk_heat_nested_template__child_heat_temp_uuid__heat_template1`;
\r
17 ALTER TABLE `mso_catalog`.`heat_template_params`
\r
18 DROP FOREIGN KEY `fk_heat_template_params__heat_template1`;
\r
20 ALTER TABLE `mso_catalog`.`service_recipe`
\r
21 DROP FOREIGN KEY `fk_service_recipe__service1`;
\r
23 ALTER TABLE `mso_catalog`.`vf_module`
\r
24 DROP FOREIGN KEY `fk_vf_module__vol_heat_template_art_uuid__heat_template2`,
\r
25 DROP FOREIGN KEY `fk_vf_module__heat_template_art_uuid__heat_template1`;
\r
27 ALTER TABLE `mso_catalog`.`vf_module_to_heat_files`
\r
28 DROP FOREIGN KEY `fk_vf_module_to_heat_files__heat_files__artifact_uuid1`,
\r
29 DROP FOREIGN KEY `fk_vf_module_to_heat_files__vf_module__model_uuid1`;
\r
31 ALTER TABLE `mso_catalog`.`network_resource`
\r
32 DROP FOREIGN KEY `fk_network_resource__heat_template1`;
\r
34 ALTER TABLE `mso_catalog`.`temp_network_heat_template_lookup`
\r
35 DROP FOREIGN KEY `fk_temp_network_heat_template_lookup__heat_template1`;
\r
37 ALTER TABLE `mso_catalog`.`vf_module_customization`
\r
38 DROP FOREIGN KEY `fk_vf_module_customization__vol_env__heat_environment2`,
\r
39 DROP FOREIGN KEY `fk_vf_module_customization__heat_env__heat_environment1`;
\r
41 ALTER TABLE `mso_catalog`.`heat_environment`
\r
42 MODIFY COLUMN `ARTIFACT_UUID` VARCHAR(200) NOT NULL FIRST,
\r
43 MODIFY COLUMN `BODY` LONGTEXT NOT NULL AFTER `DESCRIPTION`,
\r
45 ADD PRIMARY KEY (`ARTIFACT_UUID`);
\r
47 ALTER TABLE `mso_catalog`.`heat_files`
\r
48 MODIFY COLUMN `ARTIFACT_UUID` VARCHAR(200) NOT NULL FIRST,
\r
49 MODIFY COLUMN `NAME` VARCHAR(200) NOT NULL AFTER `ARTIFACT_UUID`,
\r
50 MODIFY COLUMN `BODY` LONGTEXT NOT NULL AFTER `DESCRIPTION`,
\r
52 ADD PRIMARY KEY (`ARTIFACT_UUID`);
\r
54 ALTER TABLE `mso_catalog`.`heat_nested_template`
\r
55 MODIFY COLUMN `PARENT_HEAT_TEMPLATE_UUID` VARCHAR(200) NOT NULL FIRST,
\r
56 MODIFY COLUMN `CHILD_HEAT_TEMPLATE_UUID` VARCHAR(200) NOT NULL AFTER `PARENT_HEAT_TEMPLATE_UUID`,
\r
58 ADD PRIMARY KEY (`PARENT_HEAT_TEMPLATE_UUID`, `CHILD_HEAT_TEMPLATE_UUID`),
\r
59 DROP INDEX `fk_heat_nested_template__heat_template2_idx`,
\r
60 ADD INDEX `fk_heat_nested_template__heat_template2_idx` (`CHILD_HEAT_TEMPLATE_UUID` ASC);
\r
62 ALTER TABLE `mso_catalog`.`heat_template`
\r
63 MODIFY COLUMN `ARTIFACT_UUID` VARCHAR(200) NOT NULL FIRST,
\r
64 MODIFY COLUMN `NAME` VARCHAR(200) NOT NULL AFTER `ARTIFACT_UUID`,
\r
65 MODIFY COLUMN `BODY` LONGTEXT NOT NULL AFTER `DESCRIPTION`,
\r
67 ADD PRIMARY KEY (`ARTIFACT_UUID`);
\r
69 ALTER TABLE `mso_catalog`.`heat_template_params`
\r
70 MODIFY COLUMN `HEAT_TEMPLATE_ARTIFACT_UUID` VARCHAR(200) NOT NULL FIRST,
\r
72 ADD PRIMARY KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`, `PARAM_NAME`);
\r
74 ALTER TABLE `mso_catalog`.`network_recipe`
\r
75 MODIFY COLUMN `MODEL_NAME` VARCHAR(20) NOT NULL AFTER `id`,
\r
76 DROP INDEX `UK_rl4f296i0p8lyokxveaiwkayi`,
\r
77 ADD UNIQUE INDEX `UK_rl4f296i0p8lyokxveaiwkayi` (`MODEL_NAME` ASC, `ACTION` ASC, `VERSION_STR` ASC);
\r
79 ALTER TABLE `mso_catalog`.`service`
\r
80 ADD COLUMN `SERVICE_TYPE` VARCHAR(200) NULL DEFAULT NULL AFTER `DESCRIPTION`,
\r
81 ADD COLUMN `SERVICE_ROLE` VARCHAR(200) NULL DEFAULT NULL AFTER `SERVICE_TYPE`,
\r
82 MODIFY COLUMN `MODEL_UUID` VARCHAR(200) NOT NULL FIRST,
\r
83 MODIFY COLUMN `MODEL_NAME` VARCHAR(200) NOT NULL AFTER `MODEL_UUID`,
\r
84 MODIFY COLUMN `MODEL_VERSION` VARCHAR(20) NOT NULL AFTER `MODEL_INVARIANT_UUID`,
\r
86 ADD PRIMARY KEY (`MODEL_UUID`),
\r
87 ADD INDEX `fk_service__tosca_csar1_idx` (`TOSCA_CSAR_ARTIFACT_UUID` ASC),
\r
88 DROP INDEX `fk_service__tosca_csar1_idx`;
\r
90 ALTER TABLE `mso_catalog`.`service_recipe`
\r
91 MODIFY COLUMN `SERVICE_MODEL_UUID` VARCHAR(200) NOT NULL AFTER `CREATION_TIMESTAMP`,
\r
92 DROP INDEX `fk_service_recipe__service1_idx`,
\r
93 ADD INDEX `fk_service_recipe__service1_idx` (`SERVICE_MODEL_UUID` ASC),
\r
94 DROP INDEX `UK_7fav5dkux2v8g9d2i5ymudlgc`,
\r
95 ADD UNIQUE INDEX `UK_7fav5dkux2v8g9d2i5ymudlgc` (`SERVICE_MODEL_UUID` ASC, `ACTION` ASC);
\r
97 ALTER TABLE `mso_catalog`.`vf_module`
\r
98 MODIFY COLUMN `MODEL_UUID` VARCHAR(200) NOT NULL FIRST,
\r
99 MODIFY COLUMN `HEAT_TEMPLATE_ARTIFACT_UUID` VARCHAR(200) NULL DEFAULT NULL AFTER `IS_BASE`,
\r
100 MODIFY COLUMN `VOL_HEAT_TEMPLATE_ARTIFACT_UUID` VARCHAR(200) NULL DEFAULT NULL AFTER `HEAT_TEMPLATE_ARTIFACT_UUID`,
\r
102 ADD PRIMARY KEY (`MODEL_UUID`, `VNF_RESOURCE_MODEL_UUID`),
\r
103 ADD INDEX `fk_vf_module__heat_template_art_uuid__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID` ASC),
\r
104 ADD INDEX `fk_vf_module__vol_heat_template_art_uuid__heat_template2_idx` (`VOL_HEAT_TEMPLATE_ARTIFACT_UUID` ASC),
\r
105 DROP INDEX `fk_vf_module__vol_heat_template_art_uuid__heat_template2_idx`,
\r
106 DROP INDEX `fk_vf_module__heat_template_art_uuid__heat_template1_idx`;
\r
108 ALTER TABLE `mso_catalog`.`vf_module_to_heat_files`
\r
109 MODIFY COLUMN `VF_MODULE_MODEL_UUID` VARCHAR(200) NOT NULL FIRST,
\r
110 MODIFY COLUMN `HEAT_FILES_ARTIFACT_UUID` VARCHAR(200) NOT NULL AFTER `VF_MODULE_MODEL_UUID`,
\r
112 ADD PRIMARY KEY (`VF_MODULE_MODEL_UUID`, `HEAT_FILES_ARTIFACT_UUID`),
\r
113 DROP INDEX `fk_vf_module_to_heat_files__heat_files__artifact_uuid1_idx`,
\r
114 ADD INDEX `fk_vf_module_to_heat_files__heat_files__artifact_uuid1_idx` (`HEAT_FILES_ARTIFACT_UUID` ASC),
\r
117 ALTER TABLE `mso_catalog`.`vnf_components_recipe`
\r
118 MODIFY COLUMN `VF_MODULE_MODEL_UUID` VARCHAR(200) NULL DEFAULT NULL AFTER `CREATION_TIMESTAMP`,
\r
119 CHANGE COLUMN `VERSION` `VERSION` VARCHAR(20) NOT NULL,
\r
120 DROP INDEX `UK_4dpdwddaaclhc11wxsb7h59ma`,
\r
121 ADD UNIQUE INDEX `UK_4dpdwddaaclhc11wxsb7h59ma` (`VF_MODULE_MODEL_UUID` ASC, `VNF_COMPONENT_TYPE` ASC, `ACTION` ASC, `VERSION` ASC);
\r
123 ALTER TABLE `mso_catalog`.`vnf_resource`
\r
124 MODIFY COLUMN `MODEL_UUID` VARCHAR(200) NOT NULL FIRST,
\r
125 CHANGE COLUMN `DESCRIPTION` `DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL AFTER `TOSCA_NODE_TYPE`,
\r
126 CHANGE COLUMN `ORCHESTRATION_MODE` `ORCHESTRATION_MODE` VARCHAR(20) NOT NULL DEFAULT 'HEAT' AFTER `DESCRIPTION`,
\r
127 CHANGE COLUMN `AIC_VERSION_MIN` `AIC_VERSION_MIN` VARCHAR(20) NULL DEFAULT NULL AFTER `ORCHESTRATION_MODE`,
\r
128 CHANGE COLUMN `AIC_VERSION_MAX` `AIC_VERSION_MAX` VARCHAR(20) NULL DEFAULT NULL AFTER `AIC_VERSION_MIN`,
\r
129 CHANGE COLUMN `CREATION_TIMESTAMP` `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `AIC_VERSION_MAX`,
\r
131 ADD PRIMARY KEY (`MODEL_UUID`),
\r
132 DROP INDEX `fk_vnf_resource__heat_template1`,
\r
133 ADD INDEX `fk_vnf_resource__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID` ASC);
\r
135 ALTER TABLE `mso_catalog`.`allotted_resource_customization`
\r
136 MODIFY COLUMN `PROVIDING_SERVICE_MODEL_INVARIANT_UUID` VARCHAR(200) NULL DEFAULT NULL AFTER `MODEL_INSTANCE_NAME`,
\r
137 MODIFY COLUMN `TARGET_NETWORK_ROLE` VARCHAR(200) NULL DEFAULT NULL AFTER `PROVIDING_SERVICE_MODEL_INVARIANT_UUID`,
\r
138 MODIFY COLUMN `NF_NAMING_CODE` VARCHAR(200) NULL DEFAULT NULL AFTER `NF_FUNCTION`,
\r
139 CHANGE COLUMN `CREATION_TIMESTAMP` `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `MAX_INSTANCES`;
\r
141 ALTER TABLE `mso_catalog`.`vnf_resource_customization`
\r
142 MODIFY COLUMN `NF_NAMING_CODE` VARCHAR(200) NULL DEFAULT NULL AFTER `NF_FUNCTION`;
\r
144 ALTER TABLE `mso_catalog`.`network_resource`
\r
145 CHANGE COLUMN `NEUTRON_NETWORK_TYPE` `NEUTRON_NETWORK_TYPE` VARCHAR(20) NULL DEFAULT NULL AFTER `TOSCA_NODE_TYPE`,
\r
146 CHANGE COLUMN `DESCRIPTION` `DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL AFTER `NEUTRON_NETWORK_TYPE`,
\r
147 CHANGE COLUMN `HEAT_TEMPLATE_ARTIFACT_UUID` `HEAT_TEMPLATE_ARTIFACT_UUID` VARCHAR(200) NOT NULL AFTER `CREATION_TIMESTAMP`,
\r
148 CHANGE COLUMN `MODEL_INVARIANT_UUID` `MODEL_INVARIANT_UUID` VARCHAR(200) NULL DEFAULT NULL;
\r
150 ALTER TABLE `mso_catalog`.`temp_network_heat_template_lookup`
\r
151 ADD INDEX `fk_temp_network_heat_template_lookup__heat_template1_idx` (`HEAT_TEMPLATE_ARTIFACT_UUID` ASC),
\r
152 DROP INDEX `fk_temp_network_heat_template_lookup__heat_template1_idx`;
\r
154 ALTER TABLE `mso_catalog`.`vf_module_customization`
\r
155 ADD INDEX `fk_vf_module_customization__heat_env__heat_environment1_idx` (`HEAT_ENVIRONMENT_ARTIFACT_UUID` ASC),
\r
156 ADD INDEX `fk_vf_module_customization__vol_env__heat_environment2_idx` (`VOL_ENVIRONMENT_ARTIFACT_UUID` ASC),
\r
157 DROP INDEX `fk_vf_module_customization__vol_env__heat_environment2_idx`,
\r
158 DROP INDEX `fk_vf_module_customization__heat_env__heat_environment1_idx`;
\r
160 ALTER TABLE `mso_catalog`.`service_to_resource_customizations`
\r
161 DROP INDEX `fk_service_to_resource_cust__resource_model_customiz_uuid_idx`;
\r
163 ALTER TABLE `mso_catalog`.`heat_nested_template`
\r
164 DROP FOREIGN KEY `fk_heat_nested_template__parent_heat_temp_uuid__heat_template1`;
\r
166 ALTER TABLE `mso_catalog`.`heat_nested_template`
\r
167 ADD CONSTRAINT `fk_heat_nested_template__parent_heat_temp_uuid__heat_template1`
\r
168 FOREIGN KEY (`PARENT_HEAT_TEMPLATE_UUID`)
\r
169 REFERENCES `mso_catalog`.`heat_template` (`ARTIFACT_UUID`)
\r
172 ADD CONSTRAINT `fk_heat_nested_template__child_heat_temp_uuid__heat_template1`
\r
173 FOREIGN KEY (`CHILD_HEAT_TEMPLATE_UUID`)
\r
174 REFERENCES `mso_catalog`.`heat_template` (`ARTIFACT_UUID`)
\r
178 ALTER TABLE `mso_catalog`.`heat_template_params`
\r
179 ADD CONSTRAINT `fk_heat_template_params__heat_template1`
\r
180 FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`)
\r
181 REFERENCES `mso_catalog`.`heat_template` (`ARTIFACT_UUID`)
\r
185 ALTER TABLE `mso_catalog`.`service_recipe`
\r
186 ADD CONSTRAINT `fk_service_recipe__service1`
\r
187 FOREIGN KEY (`SERVICE_MODEL_UUID`)
\r
188 REFERENCES `mso_catalog`.`service` (`MODEL_UUID`)
\r
192 ALTER TABLE `mso_catalog`.`vf_module`
\r
193 ADD CONSTRAINT `fk_vf_module__heat_template_art_uuid__heat_template1`
\r
194 FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`)
\r
195 REFERENCES `mso_catalog`.`heat_template` (`ARTIFACT_UUID`)
\r
198 ADD CONSTRAINT `fk_vf_module__vol_heat_template_art_uuid__heat_template2`
\r
199 FOREIGN KEY (`VOL_HEAT_TEMPLATE_ARTIFACT_UUID`)
\r
200 REFERENCES `mso_catalog`.`heat_template` (`ARTIFACT_UUID`)
\r
204 ALTER TABLE `mso_catalog`.`vf_module_to_heat_files`
\r
205 ADD CONSTRAINT `fk_vf_module_to_heat_files__heat_files__artifact_uuid1`
\r
206 FOREIGN KEY (`HEAT_FILES_ARTIFACT_UUID`)
\r
207 REFERENCES `mso_catalog`.`heat_files` (`ARTIFACT_UUID`)
\r
210 ADD CONSTRAINT `fk_vf_module_to_heat_files__vf_module__model_uuid1`
\r
211 FOREIGN KEY (`VF_MODULE_MODEL_UUID`)
\r
212 REFERENCES `mso_catalog`.`vf_module` (`MODEL_UUID`)
\r
216 ALTER TABLE `mso_catalog`.`network_resource`
\r
217 ADD CONSTRAINT `fk_network_resource__heat_template1`
\r
218 FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`)
\r
219 REFERENCES `mso_catalog`.`heat_template` (`ARTIFACT_UUID`)
\r
223 ALTER TABLE `mso_catalog`.`temp_network_heat_template_lookup`
\r
224 ADD CONSTRAINT `fk_temp_network_heat_template_lookup__heat_template1`
\r
225 FOREIGN KEY (`HEAT_TEMPLATE_ARTIFACT_UUID`)
\r
226 REFERENCES `mso_catalog`.`heat_template` (`ARTIFACT_UUID`)
\r
230 ALTER TABLE `mso_catalog`.`vf_module_customization`
\r
231 ADD CONSTRAINT `fk_vf_module_customization__heat_env__heat_environment1`
\r
232 FOREIGN KEY (`HEAT_ENVIRONMENT_ARTIFACT_UUID`)
\r
233 REFERENCES `mso_catalog`.`heat_environment` (`ARTIFACT_UUID`)
\r
236 ADD CONSTRAINT `fk_vf_module_customization__vol_env__heat_environment2`
\r
237 FOREIGN KEY (`VOL_ENVIRONMENT_ARTIFACT_UUID`)
\r
238 REFERENCES `mso_catalog`.`heat_environment` (`ARTIFACT_UUID`)
\r
242 INSERT INTO mso_catalog.SERVICE_RECIPE (ACTION, VERSION_STR, DESCRIPTION, ORCHESTRATION_URI, RECIPE_TIMEOUT, SERVICE_MODEL_UUID)
\r
243 VALUES ('activateInstance', '1.0', 'VID_DEFAULT activate', '/mso/async/services/ActivateGenericMacroService', 180, (SELECT model_uuid from mso_catalog.SERVICE where MODEL_NAME = 'VID_DEFAULT'));
\r
245 INSERT INTO mso_catalog.SERVICE_RECIPE (ACTION, VERSION_STR, DESCRIPTION, ORCHESTRATION_URI, RECIPE_TIMEOUT, SERVICE_MODEL_UUID)
\r
246 VALUES ('deactivateInstance', '1.0', 'VID_DEFAULT deactivate', '/mso/async/services/DeactivateGenericMacroService', 180, (SELECT model_uuid from mso_catalog.SERVICE where MODEL_NAME = 'VID_DEFAULT'));
\r
248 INSERT INTO mso_catalog.VNF_RECIPE(VNF_TYPE, ACTION, VERSION_STR, DESCRIPTION, ORCHESTRATION_URI, RECIPE_TIMEOUT)
\r
249 VALUES ('VID_DEFAULT', 'updateInstance', '1', 'VID_DEFAULT update', '/mso/async/services/UpdateVnfInfra', 180);
\r
251 INSERT INTO mso_catalog.VNF_RECIPE(VNF_TYPE, ACTION, VERSION_STR, DESCRIPTION, ORCHESTRATION_URI, RECIPE_TIMEOUT)
\r
252 VALUES ('VID_DEFAULT', 'replaceInstance', '1', 'VID_DEFAULT replace', '/mso/async/services/ReplaceVnfInfra', 180);
\r
254 INSERT INTO mso_catalog.VNF_COMPONENTS_RECIPE(VNF_COMPONENT_TYPE, ACTION, VERSION, DESCRIPTION, ORCHESTRATION_URI, RECIPE_TIMEOUT, VF_MODULE_MODEL_UUID)
\r
255 VALUES ('vfModule', 'replaceInstance', '1', 'VID_DEFAULT vfModule replace', '/mso/async/services/ReplaceVfModuleInfra', 180, 'VID_DEFAULT');
\r
257 ALTER TABLE mso_requests.infra_active_requests modify LAST_MODIFIED_BY VARCHAR(100);
\r
259 SET SQL_MODE=@OLD_SQL_MODE;
\r
260 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
\r
261 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
\r