3 DELETE FROM northbound_request_ref_lookup;
4 DELETE FROM orchestration_flow_reference;
5 DELETE FROM rainy_day_handler_macro;
6 DELETE FROM building_block_detail;
7 DELETE FROM orchestration_status_state_transition_directive;
10 INSERT INTO northbound_request_ref_lookup(MACRO_ACTION, ACTION, REQUEST_SCOPE, IS_ALACARTE,IS_TOPLEVELFLOW, MIN_API_VERSION, MAX_API_VERSION, CLOUD_OWNER) VALUES
11 ('Service-Create', 'createInstance', 'Service', true,true, '7','7', 'cloudOwner'),
12 ('Service-Delete', 'deleteInstance', 'Service', true,true, '7','7', 'cloudOwner'),
13 ('Service-Macro-Assign', 'assignInstance', 'Service', false,true, '7','7', 'cloudOwner'),
14 ('Service-Macro-Activate', 'activateInstance', 'Service', false,true, '7','7', 'cloudOwner'),
15 ('Service-Macro-Unassign', 'unassignInstance', 'Service', false,true, '7','7', 'cloudOwner'),
16 ('Service-Macro-Create', 'createInstance', 'Service', false,true, '7','7', 'cloudOwner'),
17 ('Service-Macro-Delete', 'deleteInstance', 'Service', false,true, '7','7', 'cloudOwner'),
18 ('Network-Create', 'createInstance', 'Network', true,true, '7','7', 'cloudOwner'),
19 ('Network-Delete', 'deleteInstance', 'Network', true,true, '7','7', 'cloudOwner'),
20 ('VNF-Macro-Recreate', 'recreateInstance', 'Vnf', false,true, '7','7', 'cloudOwner'),
21 ('VNF-Macro-Replace', 'replaceInstance', 'Vnf', false,true, '7','7', 'cloudOwner'),
22 ('VNF-Create', 'createInstance', 'Vnf', true,true, '7', '7', 'cloudOwner'),
23 ('VNF-Delete', 'deleteInstance', 'Vnf', true,true, '7', '7', 'cloudOwner'),
24 ('VolumeGroup-Create', 'createInstance', 'VolumeGroup', true,true, '7','7', 'cloudOwner'),
25 ('VolumeGroup-Delete', 'deleteInstance', 'VolumeGroup', true,true, '7','7', 'cloudOwner'),
26 ('VFModule-Create', 'createInstance', 'VfModule', true,true, '7','7', 'cloudOwner'),
27 ('VFModule-Delete', 'deleteInstance', 'VfModule', true,true, '7','7', 'cloudOwner'),
28 ('NetworkCollection-Macro-Create', 'createInstance', 'NetworkCollection', false,true, '7','7', 'cloudOwner'),
29 ('NetworkCollection-Macro-Delete', 'deleteInstance', 'NetworkCollection', false,true, '7','7', 'cloudOwner'),
30 ('VFModule-ScaleOut', 'createInstance', 'VfModule', true, true, '7','7', 'cloudOwner');
33 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
34 ('Service-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'cloudOwner')),
35 ('Service-Create', '2', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Create' and CLOUD_OWNER = 'cloudOwner')),
36 ('Service-Delete', '1', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'cloudOwner')),
37 ('Service-Delete', '2', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Delete' and CLOUD_OWNER = 'cloudOwner')),
38 ('Service-Macro-Assign', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'cloudOwner')),
39 ('Service-Macro-Assign', '2', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'cloudOwner')),
40 ('Service-Macro-Assign', '3', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'cloudOwner')),
41 ('Service-Macro-Assign', '4', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'cloudOwner')),
42 ('Service-Macro-Assign', '5', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Assign' and CLOUD_OWNER = 'cloudOwner')),
43 ('Service-Macro-Activate', '1', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'cloudOwner')),
44 ('Service-Macro-Activate', '2', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'cloudOwner')),
45 ('Service-Macro-Activate', '3', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'cloudOwner')),
46 ('Service-Macro-Activate', '4', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'cloudOwner')),
47 ('Service-Macro-Activate', '5', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'cloudOwner')),
48 ('Service-Macro-Activate', '6', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'cloudOwner')),
49 ('Service-Macro-Activate', '7', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'cloudOwner')),
50 ('Service-Macro-Activate', '8', 'ActivateServiceInstance', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Activate' and CLOUD_OWNER = 'cloudOwner')),
51 ('Service-Macro-Unassign', '1', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'cloudOwner')),
52 ('Service-Macro-Unassign', '2', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'cloudOwner')),
53 ('Service-Macro-Unassign', '3', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'cloudOwner')),
54 ('Service-Macro-Unassign', '4', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'cloudOwner')),
55 ('Service-Macro-Unassign', '5', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Unassign' and CLOUD_OWNER = 'cloudOwner')),
56 ('Service-Macro-Create', '1', 'AssignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
57 ('Service-Macro-Create', '2', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
58 ('Service-Macro-Create', '3', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
59 ('Service-Macro-Create', '4', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
60 ('Service-Macro-Create', '5', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
61 ('Service-Macro-Create', '6', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
62 ('Service-Macro-Create', '7', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
63 ('Service-Macro-Create', '8', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
64 ('Service-Macro-Create', '9', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
65 ('Service-Macro-Create', '10', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
66 ('Service-Macro-Create', '11', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
67 ('Service-Macro-Create', '12', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
68 ('Service-Macro-Create', '13', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
69 ('Service-Macro-Create', '14', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
70 ('Service-Macro-Create', '15', 'ActivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
71 ('Service-Macro-Delete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
72 ('Service-Macro-Delete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
73 ('Service-Macro-Delete', '3', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
74 ('Service-Macro-Delete', '4', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
75 ('Service-Macro-Delete', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
76 ('Service-Macro-Delete', '6', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
77 ('Service-Macro-Delete', '7', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
78 ('Service-Macro-Delete', '8', 'DeactivateNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
79 ('Service-Macro-Delete', '9', 'DeleteNetworkCollectionBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
80 ('Service-Macro-Delete', '10', 'DeactivateServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
81 ('Service-Macro-Delete', '11', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
82 ('Service-Macro-Delete', '12', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
83 ('Service-Macro-Delete', '13', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
84 ('Service-Macro-Delete', '14', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
85 ('Service-Macro-Delete', '15', 'UnassignServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
86 ('Network-Create', '1', 'AssignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'cloudOwner')),
87 ('Network-Create', '2', 'CreateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'cloudOwner')),
88 ('Network-Create', '3', 'ActivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Create' and CLOUD_OWNER = 'cloudOwner')),
89 ('Network-Delete', '1', 'DeactivateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'cloudOwner')),
90 ('Network-Delete', '2', 'DeleteNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'cloudOwner')),
91 ('Network-Delete', '3', 'UnassignNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Delete' and CLOUD_OWNER = 'cloudOwner')),
92 ('VNF-Create', '1', 'AssignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'cloudOwner')),
93 ('VNF-Create', '2', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Create' and CLOUD_OWNER = 'cloudOwner')),
94 ('VNF-Delete', '1', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'cloudOwner')),
95 ('VNF-Delete', '2', 'UnassignVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Delete' and CLOUD_OWNER = 'cloudOwner')),
96 ('VNF-Macro-Recreate', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'cloudOwner')),
97 ('VNF-Macro-Recreate', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'cloudOwner')),
98 ('VNF-Macro-Recreate', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'cloudOwner')),
99 ('VNF-Macro-Recreate', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'cloudOwner')),
100 ('VNF-Macro-Recreate', '5', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'cloudOwner')),
101 ('VNF-Macro-Recreate', '6', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'cloudOwner')),
102 ('VNF-Macro-Recreate', '7', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'cloudOwner')),
103 ('VNF-Macro-Recreate', '8', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'cloudOwner')),
104 ('VNF-Macro-Recreate', '9', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'cloudOwner')),
105 ('VNF-Macro-Recreate', '10', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Recreate' and CLOUD_OWNER = 'cloudOwner')),
106 ('VNF-Macro-Replace', '1', 'AAICheckVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'cloudOwner')),
107 ('VNF-Macro-Replace', '2', 'AAISetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'cloudOwner')),
108 ('VNF-Macro-Replace', '5', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'cloudOwner')),
109 ('VNF-Macro-Replace', '6', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'cloudOwner')),
110 ('VNF-Macro-Replace', '7', 'DeactivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'cloudOwner')),
111 ('VNF-Macro-Replace', '8', 'ChangeModelVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'cloudOwner')),
112 ('VNF-Macro-Replace', '9', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'cloudOwner')),
113 ('VNF-Macro-Replace', '10', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'cloudOwner')),
114 ('VNF-Macro-Replace', '13', 'ChangeModelVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'cloudOwner')),
115 ('VNF-Macro-Replace', '14', 'ActivateVnfBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'cloudOwner')),
116 ('VNF-Macro-Replace', '15', 'ChangeModelServiceInstanceBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'cloudOwner')),
117 ('VNF-Macro-Replace', '16', 'SDNOVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'cloudOwner')),
118 ('VNF-Macro-Replace', '17', 'AAIUnsetVnfInMaintBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VNF-Macro-Replace' and CLOUD_OWNER = 'cloudOwner')),
119 ('VolumeGroup-Create', '1', 'AssignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'cloudOwner')),
120 ('VolumeGroup-Create', '2', 'CreateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'cloudOwner')),
121 ('VolumeGroup-Create', '3', 'ActivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Create' and CLOUD_OWNER = 'cloudOwner')),
122 ('VolumeGroup-Delete', '1', 'DeactivateVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'cloudOwner')),
123 ('VolumeGroup-Delete', '2', 'DeleteVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'cloudOwner')),
124 ('VolumeGroup-Delete', '3', 'UnassignVolumeGroupBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VolumeGroup-Delete' and CLOUD_OWNER = 'cloudOwner')),
125 ('VFModule-Create', '1', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'cloudOwner')),
126 ('VFModule-Create', '2', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'cloudOwner')),
127 ('VFModule-Create', '3', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Create' and CLOUD_OWNER = 'cloudOwner')),
128 ('VFModule-Delete', '3', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'cloudOwner')),
129 ('VFModule-Delete', '4', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'cloudOwner')),
130 ('VFModule-Delete', '5', 'UnassignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-Delete' and CLOUD_OWNER = 'cloudOwner')),
131 ('NetworkCollection-Macro-Create', '1', 'CreateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
132 ('NetworkCollection-Macro-Create', '2', 'AssignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
133 ('NetworkCollection-Macro-Create', '3', 'CreateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
134 ('NetworkCollection-Macro-Create', '4', 'ActivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
135 ('NetworkCollection-Macro-Create', '5', 'ActivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Create' and CLOUD_OWNER = 'cloudOwner')),
136 ('NetworkCollection-Macro-Delete', '1', 'DeactivateNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
137 ('NetworkCollection-Macro-Delete', '2', 'DeleteNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
138 ('NetworkCollection-Macro-Delete', '3', 'UnassignNetworkBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
139 ('NetworkCollection-Macro-Delete', '4', 'DeactivateNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
140 ('NetworkCollection-Macro-Delete', '5', 'DeleteNetworkCollectionBB',1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'NetworkCollection-Macro-Delete' and CLOUD_OWNER = 'cloudOwner')),
141 ('VFModule-ScaleOut', '1', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'cloudOwner')),
142 ('VFModule-ScaleOut', '2', 'AssignVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'cloudOwner')),
143 ('VFModule-ScaleOut', '3', 'CreateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'cloudOwner')),
144 ('VFModule-ScaleOut', '4', 'ActivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'cloudOwner')),
145 ('VFModule-ScaleOut', '5', 'ConfigurationScaleOutBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'cloudOwner')),
146 ('VFModule-ScaleOut', '6', 'GenericVnfHealthCheckBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-ScaleOut' and CLOUD_OWNER = 'cloudOwner'));
148 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
150 ('ActivateNetworkBB', '*', '*', '*', '*' , 'Rollback'),
151 ('ActivateNetworkCollectionBB', '*', '*', '*', '*' , 'Rollback'),
152 ('ActivateServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
153 ('ActivateVfModuleBB', '*', '*', '*', '*' , 'RollbackToAssigned'),
154 ('ActivateVnfBB', '*', '*', '*', '*' , 'Rollback'),
155 ('ActivateVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
156 ('AssignNetworkBB', '*', '*', '*', '*' , 'Rollback'),
157 ('AssignServiceInstanceBB', '*', '*', '*', '*' , 'Rollback'),
158 ('AssignVfModuleBB', '*', '*', '*', '*' , 'Rollback'),
159 ('AssignVnfBB', '*', '*', '*', '*' , 'Rollback'),
160 ('AssignVolumeGroupBB', '*', '*', '*', '*' , 'Rollback'),
161 ('CreateNetworkBB', '*', '*', '*', '*' , 'Retry'),
162 ('CreateNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
163 ('CreateVfModuleBB', '*', '*', '*', '*' , 'Retry'),
164 ('CreateVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
165 ('ChangeModelServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
166 ('ChangeModelVfModuleBB', '*', '*', '*', '*' , 'Abort'),
167 ('ChangeModelVnfBB', '*', '*', '*', '*' , 'Abort'),
168 ('CreateCustomerBB', '*', '*', '*', '*' , 'Abort'),
169 ('DeactivateNetworkBB', '*', '*', '*', '*' , 'Abort'),
170 ('DeactivateServiceInstanceBB', '*', '*', '*', '*' , 'Abort'),
171 ('DeactivateVfModuleBB', '*', '*', '*', '*' , 'Abort'),
172 ('DeactivateVnfBB', '*', '*', '*', '*' , 'Abort'),
173 ('DeactivateVolumeGroupBB', '*', '*', '*', '*' , 'Abort'),
174 ('DeleteNetworkBB', '*', '*', '*', '*' , 'Retry'),
175 ('DeleteNetworkCollectionBB', '*', '*', '*', '*' , 'Retry'),
176 ('DeleteVfModuleBB', '*', '*', '*', '*' , 'Retry'),
177 ('DeleteVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
178 ('UnassignNetworkBB', '*', '*', '*', '*' , 'Retry'),
179 ('UnassignServiceInstanceBB', '*', '*', '*', '*' , 'Retry'),
180 ('UnassignVfModuleBB', '*', '*', '*', '*' , 'Retry'),
181 ('UnassignVnfBB', '*', '*', '*', '*' , 'Retry'),
182 ('UnassignVolumeGroupBB', '*', '*', '*', '*' , 'Retry'),
183 ('UpdateNetworkBB', '*', '*', '*', '*' , 'Retry'),
184 ('VnfAdapterBB', '*', '*', '*', '*' , 'Retry'),
185 ('AAICheckVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
186 ('AAISetVnfInMaintBB', '*', '*', '*', '*' , 'Abort'),
187 ('AAIUnsetVnfInMaintBB', '*', '*', '*', '*' , 'Abort');
191 INSERT INTO building_block_detail (building_block_name, resource_type, target_action)
193 ('AssignServiceInstanceBB', 'SERVICE', 'ASSIGN'),
194 ('AssignVnfBB', 'VNF', 'ASSIGN'),
195 ('AssignVolumeGroupBB', 'VOLUME_GROUP', 'ASSIGN'),
196 ('AssignVfModuleBB', 'VF_MODULE', 'ASSIGN'),
197 ('AssignNetworkBB', 'NETWORK', 'ASSIGN'),
199 ('UnassignServiceInstanceBB', 'SERVICE', 'UNASSIGN'),
200 ('UnassignVnfBB', 'VNF', 'UNASSIGN'),
201 ('UnassignVolumeGroup', 'VOLUME_GROUP', 'UNASSIGN'),
202 ('UnassignNetworkBB', 'NETWORK', 'UNASSIGN'),
204 ('ActivateServiceInstanceBB', 'SERVICE', 'ACTIVATE'),
205 ('ActivateVnfBB', 'VNF', 'ACTIVATE'),
206 ('ActivateVolumeGroupBB', 'VOLUME_GROUP', 'ACTIVATE'),
207 ('ActivateVfModuleBB', 'VF_MODULE', 'ACTIVATE'),
208 ('ActivateNetworkBB', 'NETWORK', 'ACTIVATE'),
209 ('ActivateNetworkCollectionBB', 'NETWORK', 'ACTIVATE'),
211 ('DeactivateServiceInstanceBB', 'SERVICE', 'DEACTIVATE'),
212 ('DeactivateVnfBB', 'VNF', 'DEACTIVATE'),
213 ('DeactivateVolumeGroupBB', 'VOLUME_GROUP', 'DEACTIVATE'),
214 ('DeactivateVfModuleBB', 'VF_MODULE', 'DEACTIVATE'),
215 ('DeactivateNetworkBB', 'NETWORK', 'DEACTIVATE'),
218 ('ChangeModelServiceInstanceBB', 'SERVICE', 'CHANGEMODEL'),
219 ('ChangeModelVnfBB', 'VNF', 'CHANGEMODEL'),
220 ('ChangeModelVfModuleBB', 'VF_MODULE', 'CHANGEMODEL'),
223 ('CreateVolumeGroupBB', 'VOLUME_GROUP', 'CREATE'),
224 ('CreateVfModuleBB', 'VF_MODULE', 'CREATE'),
225 ('CreateNetworkBB', 'NETWORK', 'CREATE'),
226 ('CreateNetworkCollectionBB', 'NETWORK', 'CREATE'),
228 ('DeleteVolumeGroupBB', 'VOLUME_GROUP', 'DELETE'),
229 ('DeleteVfModuleBB', 'VF_MODULE', 'DELETE'),
230 ('DeleteNetworkBB', 'NETWORK', 'DELETE'),
231 ('DeleteNetworkCollectionBB', 'NETWORK', 'DELETE'),
233 ('ConfigurationScaleOutBB', 'VF_MODULE', 'CREATE'),
234 ('GenericVnfHealthCheckBB', 'VF_MODULE', 'CREATE');
236 INSERT INTO orchestration_status_state_transition_directive (resource_type, orchestration_status, target_action, flow_directive)
239 ('SERVICE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
240 ('VNF', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
241 ('VOLUME_GROUP', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
242 ('VF_MODULE', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
243 ('NETWORK', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
245 ('SERVICE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
246 ('VNF', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
247 ('VOLUME_GROUP', 'INVENTORIED', 'ASSIGN', 'FAIL'),
248 ('VF_MODULE', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
249 ('NETWORK', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
251 ('SERVICE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
252 ('VNF', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
253 ('VOLUME_GROUP', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
254 ('VF_MODULE', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
255 ('NETWORK', 'ASSIGNED', 'ASSIGN', 'SILENT_SUCCESS'),
257 ('SERVICE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
258 ('VNF', 'CREATED', 'ASSIGN', 'CONTINUE'),
259 ('VOLUME_GROUP', 'CREATED', 'ASSIGN', 'FAIL'),
260 ('VF_MODULE', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
261 ('NETWORK', 'CREATED', 'ASSIGN', 'SILENT_SUCCESS'),
263 ('SERVICE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
264 ('VNF', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
265 ('VOLUME_GROUP', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
266 ('VF_MODULE', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
267 ('NETWORK', 'ACTIVE', 'ASSIGN', 'SILENT_SUCCESS'),
269 ('SERVICE', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
270 ('VNF', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
271 ('VOLUME_GROUP', 'PENDING_CREATE', 'ASSIGN', 'FAIL'),
272 ('VF_MODULE', 'PENDING_CREATE', 'ASSIGN', 'CONTINUE'),
273 ('NETWORK', 'PENDING_CREATE', 'ASSIGN', 'SILENT_SUCCESS'),
275 ('SERVICE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
276 ('VNF', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
277 ('VOLUME_GROUP', 'PENDING_DELETE', 'ASSIGN', 'FAIL'),
278 ('VF_MODULE', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
279 ('NETWORK', 'PENDING_DELETE', 'ASSIGN', 'SILENT_SUCCESS'),
281 ('SERVICE', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
282 ('VNF', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
283 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
284 ('VF_MODULE', 'PENDING_ACTIVATION', 'ASSIGN', 'SILENT_SUCCESS'),
285 ('NETWORK', 'PENDING_ACTIVATION', 'ASSIGN', 'FAIL'),
287 ('SERVICE', 'PENDING', 'ASSIGN', 'FAIL'),
288 ('VNF', 'PENDING', 'ASSIGN', 'FAIL'),
289 ('VOLUME_GROUP', 'PENDING', 'ASSIGN', 'SILENT_SUCCESS'),
290 ('VF_MODULE', 'PENDING', 'ASSIGN', 'FAIL'),
291 ('NETWORK', 'PENDING', 'ASSIGN', 'FAIL'),
294 ('SERVICE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
295 ('VNF', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
296 ('VOLUME_GROUP', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
297 ('VF_MODULE', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
298 ('NETWORK', 'PRECREATED', 'UNASSIGN', 'SILENT_SUCCESS'),
300 ('SERVICE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
301 ('VNF', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
302 ('VOLUME_GROUP', 'INVENTORIED', 'UNASSIGN', 'FAIL'),
303 ('VF_MODULE', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
304 ('NETWORK', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
306 ('SERVICE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
307 ('VNF', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
308 ('VOLUME_GROUP', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
309 ('VF_MODULE', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
310 ('NETWORK', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
312 ('SERVICE', 'CREATED', 'UNASSIGN', 'CONTINUE'),
313 ('VNF', 'CREATED', 'UNASSIGN', 'CONTINUE'),
314 ('VOLUME_GROUP', 'CREATED', 'UNASSIGN', 'FAIL'),
315 ('VF_MODULE', 'CREATED', 'UNASSIGN', 'FAIL'),
316 ('NETWORK', 'CREATED', 'UNASSIGN', 'FAIL'),
318 ('SERVICE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
319 ('VNF', 'ACTIVE', 'UNASSIGN', 'FAIL'),
320 ('VOLUME_GROUP', 'ACTIVE', 'UNASSIGN', 'FAIL'),
321 ('VF_MODULE', 'ACTIVE', 'UNASSIGN', 'FAIL'),
322 ('NETWORK', 'ACTIVE', 'UNASSIGN', 'FAIL'),
324 ('SERVICE', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
325 ('VNF', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
326 ('VOLUME_GROUP', 'PENDING_CREATE', 'UNASSIGN', 'FAIL'),
327 ('VF_MODULE', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
328 ('NETWORK', 'PENDING_CREATE', 'UNASSIGN', 'CONTINUE'),
330 ('SERVICE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
331 ('VNF', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
332 ('VOLUME_GROUP', 'PENDING_DELETE', 'UNASSIGN', 'FAIL'),
333 ('VF_MODULE', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
334 ('NETWORK', 'PENDING_DELETE', 'UNASSIGN', 'CONTINUE'),
336 ('SERVICE', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
337 ('VNF', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
338 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
339 ('VF_MODULE', 'PENDING_ACTIVATION', 'UNASSIGN', 'CONTINUE'),
340 ('NETWORK', 'PENDING_ACTIVATION', 'UNASSIGN', 'FAIL'),
342 ('SERVICE', 'PENDING', 'UNASSIGN', 'FAIL'),
343 ('VNF', 'PENDING', 'UNASSIGN', 'FAIL'),
344 ('VOLUME_GROUP', 'PENDING', 'UNASSIGN', 'CONTINUE'),
345 ('VF_MODULE', 'PENDING', 'UNASSIGN', 'FAIL'),
346 ('NETWORK', 'PENDING', 'UNASSIGN', 'FAIL'),
349 ('SERVICE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
350 ('VNF', 'PRECREATED', 'ACTIVATE', 'FAIL'),
351 ('VOLUME_GROUP', 'PRECREATED', 'ACTIVATE', 'FAIL'),
352 ('VF_MODULE', 'PRECREATED', 'ACTIVATE', 'FAIL'),
353 ('NETWORK', 'PRECREATED', 'ACTIVATE', 'FAIL'),
355 ('SERVICE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
356 ('VNF', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
357 ('VOLUME_GROUP', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
358 ('VF_MODULE', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
359 ('NETWORK', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
361 ('SERVICE', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
362 ('VNF', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
363 ('VOLUME_GROUP', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
364 ('VF_MODULE', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
365 ('NETWORK', 'ASSIGNED', 'ACTIVATE', 'FAIL'),
367 ('SERVICE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
368 ('VNF', 'CREATED', 'ACTIVATE', 'FAIL'),
369 ('VOLUME_GROUP', 'CREATED', 'ACTIVATE', 'CONTINUE'),
370 ('VF_MODULE', 'CREATED', 'ACTIVATE', 'CONTINUE'),
371 ('NETWORK', 'CREATED', 'ACTIVATE', 'CONTINUE'),
373 ('SERVICE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
374 ('VNF', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
375 ('VOLUME_GROUP', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
376 ('VF_MODULE', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
377 ('NETWORK', 'ACTIVE', 'ACTIVATE', 'SILENT_SUCCESS'),
379 ('SERVICE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
380 ('VNF', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
381 ('VOLUME_GROUP', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
382 ('VF_MODULE', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
383 ('NETWORK', 'PENDING_CREATE', 'ACTIVATE', 'FAIL'),
385 ('SERVICE', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
386 ('VNF', 'PENDING_DELETE', 'ACTIVATE', 'CONTINUE'),
387 ('VOLUME_GROUP', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
388 ('VF_MODULE', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
389 ('NETWORK', 'PENDING_DELETE', 'ACTIVATE', 'FAIL'),
391 ('SERVICE', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
392 ('VNF', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
393 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
394 ('VF_MODULE', 'PENDING_ACTIVATION', 'ACTIVATE', 'SILENT_SUCCESS'),
395 ('NETWORK', 'PENDING_ACTIVATION', 'ACTIVATE', 'FAIL'),
397 ('SERVICE', 'PENDING', 'ACTIVATE', 'FAIL'),
398 ('VNF', 'PENDING', 'ACTIVATE', 'FAIL'),
399 ('VOLUME_GROUP', 'PENDING', 'ACTIVATE', 'FAIL'),
400 ('VF_MODULE', 'PENDING', 'ACTIVATE', 'FAIL'),
401 ('NETWORK', 'PENDING', 'ACTIVATE', 'FAIL'),
403 ('SERVICE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
404 ('VNF', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
405 ('VOLUME_GROUP', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
406 ('VF_MODULE', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
407 ('NETWORK', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
409 ('SERVICE', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
410 ('VNF', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
411 ('VOLUME_GROUP', 'INVENTORIED', 'DEACTIVATE', 'FAIL'),
412 ('VF_MODULE', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
413 ('NETWORK', 'INVENTORIED', 'DEACTIVATE', 'SILENT_SUCCESS'),
415 ('SERVICE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
416 ('VNF', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
417 ('VOLUME_GROUP', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
418 ('VF_MODULE', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
419 ('NETWORK', 'ASSIGNED', 'DEACTIVATE', 'SILENT_SUCCESS'),
421 ('SERVICE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
422 ('VNF', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
423 ('VOLUME_GROUP', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
424 ('VF_MODULE', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
425 ('NETWORK', 'CREATED', 'DEACTIVATE', 'SILENT_SUCCESS'),
427 ('SERVICE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
428 ('VNF', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
429 ('VOLUME_GROUP', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
430 ('VF_MODULE', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
431 ('NETWORK', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
433 ('SERVICE', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
434 ('VNF', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
435 ('VOLUME_GROUP', 'PENDING_CREATE', 'DEACTIVATE', 'FAIL'),
436 ('VF_MODULE', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
437 ('NETWORK', 'PENDING_CREATE', 'DEACTIVATE', 'SILENT_SUCCESS'),
439 ('SERVICE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
440 ('VNF', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
441 ('VOLUME_GROUP', 'PENDING_DELETE', 'DEACTIVATE', 'FAIL'),
442 ('VF_MODULE', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
443 ('NETWORK', 'PENDING_DELETE', 'DEACTIVATE', 'SILENT_SUCCESS'),
445 ('SERVICE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
446 ('VNF', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
447 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
448 ('VF_MODULE', 'PENDING_ACTIVATION', 'DEACTIVATE', 'SILENT_SUCCESS'),
449 ('NETWORK', 'PENDING_ACTIVATION', 'DEACTIVATE', 'FAIL'),
451 ('SERVICE', 'PENDING', 'DEACTIVATE', 'FAIL'),
452 ('VNF', 'PENDING', 'DEACTIVATE', 'FAIL'),
453 ('VOLUME_GROUP', 'PENDING', 'DEACTIVATE', 'SILENT_SUCCESS'),
454 ('VF_MODULE', 'PENDING', 'DEACTIVATE', 'FAIL'),
455 ('NETWORK', 'PENDING', 'DEACTIVATE', 'FAIL'),
458 ('SERVICE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
459 ('VNF', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
460 ('VF_MODULE', 'PRECREATED', 'CHANGE_MODEL', 'FAIL'),
462 ('SERVICE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
463 ('VNF', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
464 ('VF_MODULE', 'INVENTORIED', 'CHANGE_MODEL', 'FAIL'),
466 ('SERVICE', 'ASSIGNED', 'CHANGE_MODEL', 'FAIL'),
467 ('VNF', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
468 ('VF_MODULE', 'ASSIGNED', 'CHANGE_MODEL', 'CONTINUE'),
470 ('SERVICE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
471 ('VNF', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
472 ('VF_MODULE', 'CREATED', 'CHANGE_MODEL', 'FAIL'),
474 ('SERVICE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
475 ('VNF', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
476 ('VF_MODULE', 'ACTIVE', 'CHANGE_MODEL', 'CONTINUE'),
478 ('SERVICE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
479 ('VNF', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
480 ('VF_MODULE', 'PENDING_CREATE', 'CHANGE_MODEL', 'FAIL'),
482 ('SERVICE', 'PENDING_DELETE', 'CHANGE_MODEL', 'FAIL'),
483 ('VNF', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
484 ('VF_MODULE', 'PENDING_DELETE', 'CHANGE_MODEL', 'CONTINUE'),
486 ('SERVICE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'FAIL'),
487 ('VNF', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
488 ('VF_MODULE', 'PENDING_ACTIVATION', 'CHANGE_MODEL', 'CONTINUE'),
490 ('SERVICE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
491 ('VNF', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
492 ('VF_MODULE', 'PENDING', 'CHANGE_MODEL', 'FAIL'),
495 ('VOLUME_GROUP', 'PRECREATED', 'CREATE', 'FAIL'),
496 ('VF_MODULE', 'PRECREATED', 'CREATE', 'FAIL'),
497 ('NETWORK', 'PRECREATED', 'CREATE', 'FAIL'),
499 ('VOLUME_GROUP', 'INVENTORIED', 'CREATE', 'FAIL'),
500 ('VF_MODULE', 'INVENTORIED', 'CREATE', 'FAIL'),
501 ('NETWORK', 'INVENTORIED', 'CREATE', 'FAIL'),
503 ('VOLUME_GROUP', 'ASSIGNED', 'CREATE', 'CONTINUE'),
504 ('VF_MODULE', 'ASSIGNED', 'CREATE', 'CONTINUE'),
505 ('NETWORK', 'ASSIGNED', 'CREATE', 'CONTINUE'),
507 ('VOLUME_GROUP', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
508 ('VF_MODULE', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
509 ('NETWORK', 'CREATED', 'CREATE', 'SILENT_SUCCESS'),
511 ('VOLUME_GROUP', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
512 ('VF_MODULE', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
513 ('NETWORK', 'ACTIVE', 'CREATE', 'SILENT_SUCCESS'),
515 ('VOLUME_GROUP', 'PENDING_CREATE', 'CREATE', 'FAIL'),
516 ('VF_MODULE', 'PENDING_CREATE', 'CREATE', 'FAIL'),
517 ('NETWORK', 'PENDING_CREATE', 'CREATE', 'CONTINUE'),
519 ('VOLUME_GROUP', 'PENDING_DELETE', 'CREATE', 'FAIL'),
520 ('VF_MODULE', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
521 ('NETWORK', 'PENDING_DELETE', 'CREATE', 'CONTINUE'),
523 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
524 ('VF_MODULE', 'PENDING_ACTIVATION', 'CREATE', 'SILENT_SUCCESS'),
525 ('NETWORK', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
527 ('VOLUME_GROUP', 'PENDING', 'CREATE', 'CONTINUE'),
528 ('VF_MODULE', 'PENDING', 'CREATE', 'FAIL'),
529 ('NETWORK', 'PENDING', 'CREATE', 'FAIL'),
532 ('VOLUME_GROUP', 'PRECREATED', 'DELETE', 'FAIL'),
533 ('VF_MODULE', 'PRECREATED', 'DELETE', 'FAIL'),
534 ('NETWORK', 'PRECREATED', 'DELETE', 'FAIL'),
536 ('VOLUME_GROUP', 'INVENTORIED', 'DELETE', 'FAIL'),
537 ('VF_MODULE', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
538 ('NETWORK', 'INVENTORIED', 'DELETE', 'SILENT_SUCCESS'),
540 ('VOLUME_GROUP', 'ASSIGNED', 'DELETE', 'CONTINUE'),
541 ('VF_MODULE', 'ASSIGNED', 'DELETE', 'CONTINUE'),
542 ('NETWORK', 'ASSIGNED', 'DELETE', 'CONTINUE'),
544 ('VOLUME_GROUP', 'CREATED', 'DELETE', 'CONTINUE'),
545 ('VF_MODULE', 'CREATED', 'DELETE', 'CONTINUE'),
546 ('NETWORK', 'CREATED', 'DELETE', 'CONTINUE'),
548 ('VOLUME_GROUP', 'ACTIVE', 'DELETE', 'FAIL'),
549 ('VF_MODULE', 'ACTIVE', 'DELETE', 'FAIL'),
550 ('NETWORK', 'ACTIVE', 'DELETE', 'FAIL'),
552 ('VOLUME_GROUP', 'PENDING_CREATE', 'DELETE', 'FAIL'),
553 ('VF_MODULE', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
554 ('NETWORK', 'PENDING_CREATE', 'DELETE', 'SILENT_SUCCESS'),
556 ('VOLUME_GROUP', 'PENDING_DELETE', 'DELETE', 'FAIL'),
557 ('VF_MODULE', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
558 ('NETWORK', 'PENDING_DELETE', 'DELETE', 'SILENT_SUCCESS'),
560 ('VOLUME_GROUP', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
561 ('VF_MODULE', 'PENDING_ACTIVATION', 'DELETE', 'SILENT_SUCCESS'),
562 ('NETWORK', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
564 ('VOLUME_GROUP', 'PENDING', 'DELETE', 'SILENT_SUCCESS'),
565 ('VF_MODULE', 'PENDING', 'DELETE', 'FAIL'),
566 ('NETWORK', 'PENDING', 'DELETE', 'FAIL');
568 UPDATE orchestration_flow_reference SET FLOW_NAME = 'HomingBB' WHERE FLOW_NAME = 'SniroHoming';
570 UPDATE orchestration_flow_reference
571 SET FLOW_NAME = 'ActivateServiceInstanceBB'
572 WHERE FLOW_NAME = 'ActivateServiceInstance';
574 DELETE FROM orchestration_flow_reference
575 WHERE FLOW_NAME = 'DeactivateNetworkCollectionBB';
577 UPDATE orchestration_flow_reference
578 SET SEQ_NO = SEQ_NO - 1
579 WHERE COMPOSITE_ACTION = 'Service-Macro-Delete' AND SEQ_NO > 8;
581 UPDATE orchestration_flow_reference
582 SET SEQ_NO = SEQ_NO - 1
583 WHERE COMPOSITE_ACTION = 'NetworkCollection-Macro-Delete' AND SEQ_NO > 4;
585 UPDATE building_block_detail
586 SET BUILDING_BLOCK_NAME = 'UnassignVolumeGroupBB'
587 WHERE BUILDING_BLOCK_NAME = 'UnassignVolumeGroup';
589 UPDATE building_block_detail
590 SET TARGET_ACTION = 'CHANGE_MODEL'
591 WHERE TARGET_ACTION = 'CHANGEMODEL';
593 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME, RESOURCE_TYPE, TARGET_ACTION)
595 ('UnassignVfModuleBB', 'VF_MODULE', 'UNASSIGN'),
596 ('SniroHoming', 'CUSTOM', 'CUSTOM'),
597 ('DeactivateAndUnassignVpnBondingLinksBB', 'CUSTOM', 'CUSTOM'),
598 ('DeactivateNetworkCollectionBB', 'CUSTOM', 'CUSTOM'),
599 ('AAICheckVnfInMaintBB', 'CUSTOM', 'CUSTOM'),
600 ('AAISetVnfInMaintBB', 'CUSTOM', 'CUSTOM'),
601 ('AAIUnsetVnfInMaintBB', 'CUSTOM', 'CUSTOM'),
602 ('SDNOVnfHealthCheckBB', 'CUSTOM', 'CUSTOM'),
603 ('VNF-Macro-Replace', 'CUSTOM', 'CUSTOM'),
604 ('HomingBB', 'CUSTOM', 'CUSTOM');
606 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
608 ('CUSTOM', 'ACTIVE', 'CUSTOM', 'CONTINUE'),
609 ('CUSTOM', 'ASSIGNED', 'CUSTOM', 'CONTINUE'),
610 ('CUSTOM', 'CREATED', 'CUSTOM', 'CONTINUE'),
611 ('CUSTOM', 'INVENTORIED', 'CUSTOM', 'CONTINUE'),
612 ('CUSTOM', 'PENDING', 'CUSTOM', 'CONTINUE'),
613 ('CUSTOM', 'PENDING_ACTIVATION', 'CUSTOM', 'CONTINUE'),
614 ('CUSTOM', 'PENDING_CREATE', 'CUSTOM', 'CONTINUE'),
615 ('CUSTOM', 'PENDING_DELETE', 'CUSTOM', 'CONTINUE'),
616 ('CUSTOM', 'PRECREATED', 'CUSTOM', 'CONTINUE');
618 INSERT INTO northbound_request_ref_lookup(MACRO_ACTION, ACTION, REQUEST_SCOPE, IS_ALACARTE, MIN_API_VERSION, MAX_API_VERSION, IS_TOPLEVELFLOW, CLOUD_OWNER) VALUES
619 ('VFModule-DeactivateAndCloudDelete', 'deactivateAndCloudDelete', 'VfModule', true, '7','7', true, 'cloudOwner');
621 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
622 ('VFModule-DeactivateAndCloudDelete', '1', 'DeactivateVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'cloudOwner')),
623 ('VFModule-DeactivateAndCloudDelete', '2', 'DeleteVfModuleBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'VFModule-DeactivateAndCloudDelete' and CLOUD_OWNER = 'cloudOwner'));
625 INSERT INTO northbound_request_ref_lookup (REQUEST_SCOPE, MACRO_ACTION, ACTION, IS_ALACARTE, MIN_API_VERSION, MAX_API_VERSION, IS_TOPLEVELFLOW, CLOUD_OWNER)
626 values ( 'Service', 'Service-Macro-Deactivate', 'deactivateInstance', '0', '7', '7', '1', 'cloudOwner');
628 INSERT INTO orchestration_flow_reference (COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID)
629 values ( 'Service-Macro-Deactivate', '1', 'DeactivateServiceInstanceBB', '1', (SELECT id FROM northbound_request_ref_lookup WHERE MACRO_ACTION = 'Service-Macro-Deactivate' and CLOUD_OWNER = 'cloudOwner'));
632 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Create';
633 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Delete';
634 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Activate';
636 UPDATE northbound_request_ref_lookup SET MIN_API_VERSION = 5 WHERE MACRO_ACTION = 'Service-Macro-Deactivate';
638 INSERT INTO northbound_request_ref_lookup(MACRO_ACTION, ACTION, REQUEST_SCOPE, IS_ALACARTE, MIN_API_VERSION, MAX_API_VERSION, IS_TOPLEVELFLOW, CLOUD_OWNER) VALUES
639 ('Network-Update', 'updateInstance', 'Network', true, '7','7','1', 'cloudOwner');
640 INSERT INTO orchestration_flow_reference(COMPOSITE_ACTION, SEQ_NO, FLOW_NAME, FLOW_VERSION, NB_REQ_REF_LOOKUP_ID) VALUES
641 ('Network-Update', '1', 'UpdateNetworkBB', 1.0,(SELECT id from northbound_request_ref_lookup WHERE MACRO_ACTION = 'Network-Update' and CLOUD_OWNER = 'cloudOwner'));
643 INSERT INTO building_block_detail(BUILDING_BLOCK_NAME,RESOURCE_TYPE,TARGET_ACTION) VALUES
644 ('UpdateNetworkBB','NETWORK','UPDATE');
646 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS,TARGET_ACTION,FLOW_DIRECTIVE) VALUES
647 ('NETWORK','PRECREATED','UPDATE','FAIL'),
648 ('NETWORK','INVENTORIED','UPDATE','FAIL'),
649 ('NETWORK','ASSIGNED','UPDATE','FAIL'),
650 ('NETWORK','CREATED','UPDATE','FAIL'),
651 ('NETWORK','PENDING_CREATE','UPDATE','FAIL'),
652 ('NETWORK','PENDING_DELETE','UPDATE','FAIL'),
653 ('NETWORK','PENDING_ACTIVATION','UPDATE','FAIL'),
654 ('NETWORK','ACTIVE','UPDATE','CONTINUE');
656 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'ActivateNetworkCollectionBB';
657 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'CreateNetworkCollectionBB';
658 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeleteNetworkCollectionBB';
659 UPDATE building_block_detail SET RESOURCE_TYPE = 'NETWORK_COLLECTION' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
660 UPDATE building_block_detail SET TARGET_ACTION = 'DEACTIVATE' WHERE BUILDING_BLOCK_NAME = 'DeactivateNetworkCollectionBB';
662 INSERT into orchestration_status_state_transition_directive (RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE) values
663 ('NETWORK_COLLECTION', 'PRECREATED', 'CREATE', 'CONTINUE'),
664 ('NETWORK_COLLECTION', 'ASSIGNED', 'CREATE', 'FAIL'),
665 ('NETWORK_COLLECTION', 'CREATED', 'CREATE', 'FAIL'),
666 ('NETWORK_COLLECTION', 'ACTIVE', 'CREATE', 'FAIL'),
667 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'CREATE', 'FAIL'),
668 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'CREATE', 'FAIL'),
669 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'CREATE', 'FAIL'),
670 ('NETWORK_COLLECTION', 'PENDING', 'CREATE', 'FAIL'),
671 ('NETWORK_COLLECTION', 'INVENTORIED', 'CREATE', 'SILENT_SUCCESS'),
673 ('NETWORK_COLLECTION', 'PRECREATED', 'DELETE', 'FAIL'),
674 ('NETWORK_COLLECTION', 'ASSIGNED', 'DELETE', 'FAIL'),
675 ('NETWORK_COLLECTION', 'CREATED', 'DELETE', 'FAIL'),
676 ('NETWORK_COLLECTION', 'ACTIVE', 'DELETE', 'CONTINUE'),
677 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'DELETE', 'FAIL'),
678 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'DELETE', 'FAIL'),
679 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'DELETE', 'FAIL'),
680 ('NETWORK_COLLECTION', 'PENDING', 'DELETE', 'FAIL'),
681 ('NETWORK_COLLECTION', 'INVENTORIED', 'DELETE', 'CONTINUE'),
683 ('NETWORK_COLLECTION', 'PRECREATED', 'ACTIVE', 'FAIL'),
684 ('NETWORK_COLLECTION', 'ASSIGNED', 'ACTIVE', 'FAIL'),
685 ('NETWORK_COLLECTION', 'CREATED', 'ACTIVE', 'FAIL'),
686 ('NETWORK_COLLECTION', 'ACTIVE', 'ACTIVE', 'SILENT_SUCCESS'),
687 ('NETWORK_COLLECTION', 'PENDING_CREATE', 'ACTIVE', 'FAIL'),
688 ('NETWORK_COLLECTION', 'PENDING_DELETE', 'ACTIVE', 'FAIL'),
689 ('NETWORK_COLLECTION', 'PENDING_ACTIVATION', 'ACTIVE', 'FAIL'),
690 ('NETWORK_COLLECTION', 'PENDING', 'ACTIVE', 'FAIL'),
691 ('NETWORK_COLLECTION', 'INVENTORIED', 'ACTIVE', 'CONTINUE');
693 UPDATE orchestration_status_state_transition_directive SET TARGET_ACTION = 'ACTIVATE' WHERE TARGET_ACTION = 'ACTIVE';
695 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
697 ('CONFIGURATION', 'PRECREATED', 'UNASSIGN', 'SILENT SUCCESS'),
698 ('CONFIGURATION', 'INVENTORIED', 'UNASSIGN', 'CONTINUE'),
699 ('CONFIGURATION', 'ASSIGNED', 'UNASSIGN', 'CONTINUE'),
700 ('CONFIGURATION', 'CREATED', 'UNASSIGN', 'FAIL'),
701 ('CONFIGURATION', 'ACTIVE', 'UNASSIGN', 'FAIL'),
702 ('CONFIGURATION', 'PENDING CREATE', 'UNASSIGN', 'FAIL'),
703 ('CONFIGURATION', 'PENDING DELETE', 'UNASSIGN', 'FAIL'),
704 ('CONFIGURATION', 'PENDING ACTIVATION', 'UNASSIGN', 'FAIL'),
705 ('CONFIGURATION', 'PENDING', 'UNASSIGN', 'FAIL');
707 UPDATE orchestration_flow_reference
708 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'SERVICE-MACRO-DELETE';
711 INSERT INTO orchestration_status_state_transition_directive(RESOURCE_TYPE, ORCHESTRATION_STATUS, TARGET_ACTION, FLOW_DIRECTIVE)
713 ('CONFIGURATION', 'PRECREATED', 'ASSIGN', 'CONTINUE'),
714 ('CONFIGURATION', 'INVENTORIED', 'ASSIGN', 'CONTINUE'),
715 ('CONFIGURATION', 'ASSIGNED', 'ASSIGN', 'SILENT SUCCESS'),
716 ('CONFIGURATION', 'CREATED', 'ASSIGN', 'SILENT SUCCESS'),
717 ('CONFIGURATION', 'ACTIVE', 'ASSIGN', 'SILENT SUCCESS'),
718 ('CONFIGURATION', 'PENDING CREATE', 'ASSIGN', 'FAIL'),
719 ('CONFIGURATION', 'PENDING DELETE', 'ASSIGN', 'FAIL'),
720 ('CONFIGURATION', 'PENDING ACTIVATION', 'ASSIGN', 'FAIL'),
721 ('CONFIGURATION', 'PENDING', 'ASSIGN', 'FAIL'),
723 ('CONFIGURATION', 'PRECREATED', 'ACTIVATE', 'FAIL'),
724 ('CONFIGURATION', 'INVENTORIED', 'ACTIVATE', 'FAIL'),
725 ('CONFIGURATION', 'ASSIGNED', 'ACTIVATE', 'CONTINUE'),
726 ('CONFIGURATION', 'CREATED', 'ACTIVATE', 'CONTINUE'),
727 ('CONFIGURATION', 'ACTIVE', 'ACTIVATE', 'SILENT SUCCESS'),
728 ('CONFIGURATION', 'PENDING CREATE', 'ACTIVATE', 'FAIL'),
729 ('CONFIGURATION', 'PENDING DELETE', 'ACTIVATE', 'FAIL'),
730 ('CONFIGURATION', 'PENDING ACTIVATION', 'ACTIVATE', 'FAIL'),
731 ('CONFIGURATION', 'PENDING', 'ACTIVATE', 'FAIL'),
733 ('CONFIGURATION', 'PRECREATED', 'DEACTIVATE', 'FAIL'),
734 ('CONFIGURATION', 'INVENTORIED', 'DEACTIVATE', 'SILENT SUCCESS'),
735 ('CONFIGURATION', 'ASSIGNED', 'DEACTIVATE', 'SILENT SUCCESS'),
736 ('CONFIGURATION', 'CREATED', 'DEACTIVATE', 'SILENT SUCCESS'),
737 ('CONFIGURATION', 'ACTIVE', 'DEACTIVATE', 'CONTINUE'),
738 ('CONFIGURATION', 'PENDING CREATE', 'DEACTIVATE', 'FAIL'),
739 ('CONFIGURATION', 'PENDING DELETE', 'DEACTIVATE', 'FAIL'),
740 ('CONFIGURATION', 'PENDING ACTIVATION', 'DEACTIVATE', 'FAIL'),
741 ('CONFIGURATION', 'PENDING', 'DEACTIVATE', 'FAIL');
743 UPDATE orchestration_flow_reference
744 SET SEQ_NO = SEQ_NO + 2 WHERE COMPOSITE_ACTION = 'Service-Macro-Create' AND SEQ_NO > 12;
746 UPDATE orchestration_flow_reference
747 SET SEQ_NO = SEQ_NO + 1 WHERE COMPOSITE_ACTION = 'Service-Macro-Activate' AND SEQ_NO > 6;
751 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Rollback';
752 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE POLICY = 'Abort';
753 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkBB';
754 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateNetworkCollectionBB';
755 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'RollbackToAssigned' WHERE FLOW_NAME = 'CreateVfModuleBB';
756 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'CreateVolumeGroupBB';
757 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkBB';
758 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteNetworkCollectionBB';
759 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVfModuleBB';
760 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'DeleteVolumeGroupBB';
761 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignNetworkBB';
762 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignServiceInstanceBB';
763 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVfModuleBB';
764 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVnfBB';
765 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Abort' WHERE FLOW_NAME = 'UnassignVolumeGroupBB';
766 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'UpdateNetworkBB';
767 UPDATE rainy_day_handler_macro SET Secondary_Policy = 'Rollback' WHERE FLOW_NAME = 'VnfAdapterBB';
772 INSERT INTO rainy_day_handler_macro (FLOW_NAME, SERVICE_TYPE, VNF_TYPE, ERROR_CODE, WORK_STEP, POLICY)
774 ('GenericVnfHealthCheckBB', '*', '*', '*', "*" , 'Retry'),
775 ('ConfigurationScaleOutBB', '*', '*', '*', "*" , 'Retry');