insert into service_recipe (ACTION,VERSION_STR,DESCRIPTION,ORCHESTRATION_URI,RECIPE_TIMEOUT,SERVICE_MODEL_UUID) values ('createRanSlice','1','Gr api recipe for RAN slicing','/mso/async/services/WorkflowActionBB',180,'dfcd7471-16c7-444e-8268-d4c50d90593a');
insert into service_recipe (ACTION,VERSION_STR,DESCRIPTION,ORCHESTRATION_URI,RECIPE_TIMEOUT,SERVICE_MODEL_UUID) values ('modifyRanSlice','1','Gr api recipe for RAN slicing','/mso/async/services/WorkflowActionBB',180,'dfcd7471-16c7-444e-8268-d4c50d90593a');
insert into service_recipe (ACTION,VERSION_STR,DESCRIPTION,ORCHESTRATION_URI,RECIPE_TIMEOUT,SERVICE_MODEL_UUID) values ('deleteRanSlice','1','Gr api recipe for RAN slicing','/mso/async/services/WorkflowActionBB',180,'dfcd7471-16c7-444e-8268-d4c50d90593a');

insert into northbound_request_ref_lookup (REQUEST_SCOPE,MACRO_ACTION,ACTION,IS_ALACARTE,MIN_API_VERSION,MAX_API_VERSION,IS_TOPLEVELFLOW,SERVICE_TYPE,CLOUD_OWNER)values ('NetworkSliceSubnet','Slice-Macro-Create','CeateranSlice',0,1,7,1,'*','DEFAULT');

insert into orchestration_flow_reference (COMPOSITE_ACTION,SEQ_NO,FLOW_NAME,FLOW_VERSION,NB_REQ_REF_LOOKUP_ID,SCOPE,ACTION) values('Slice-Macro-Create',1,'AssignRANNssiBB',1,175,null,null);
insert into orchestration_flow_reference (COMPOSITE_ACTION,SEQ_NO,FLOW_NAME,FLOW_VERSION,NB_REQ_REF_LOOKUP_ID,SCOPE,ACTION) values('Slice-Macro-Create',2,'ControllerExecutionBB',1,175,'createSliceProfile',null);
insert into orchestration_flow_reference (COMPOSITE_ACTION,SEQ_NO,FLOW_NAME,FLOW_VERSION,NB_REQ_REF_LOOKUP_ID,SCOPE,ACTION) values('Slice-Macro-Create',3,'ActivateRANNssiBB',1,175,null,null);



=============
modify
insert into service_recipe (ACTION,VERSION_STR,DESCRIPTION,ORCHESTRATION_URI,RECIPE_TIMEOUT,SERVICE_MODEL_UUID) values ('modifyRanSlice','1','Gr api recipe for RAN slicing','/mso/async/services/WorkflowActionBB',180,'dfcd7471-16c7-444e-8268-d4c50d90593a');

insert into northbound_request_ref_lookup (REQUEST_SCOPE,MACRO_ACTION,ACTION,IS_ALACARTE,MIN_API_VERSION,MAX_API_VERSION,IS_TOPLEVELFLOW,SERVICE_TYPE,CLOUD_OWNER)values ('NetworkSliceSubnet','Slice-Macro-modify','modifyRanSlice',0,1,7,1,'*','DEFAULT');

insert into orchestration_flow_reference (COMPOSITE_ACTION,SEQ_NO,FLOW_NAME,FLOW_VERSION,NB_REQ_REF_LOOKUP_ID,ACTION,SCOPE) values('Slice-Macro-modify',1,'ModifyRANNssiBB',1,180,null,null);
insert into orchestration_flow_reference (COMPOSITE_ACTION,SEQ_NO,FLOW_NAME,FLOW_VERSION,NB_REQ_REF_LOOKUP_ID,ACTION,SCOPE) values('Slice-Macro-modify',2,'ControllerExecutionBB',1,180,'get-subscriber-type-workflow',null);


=============
delete
insert into service_recipe (ACTION,VERSION_STR,DESCRIPTION,ORCHESTRATION_URI,RECIPE_TIMEOUT,SERVICE_MODEL_UUID) values ('deleteRanSlice','1','Gr api recipe for RAN slicing','/mso/async/services/WorkflowActionBB',180,'dfcd7471-16c7-444e-8268-d4c50d90593a');

insert into northbound_request_ref_lookup (REQUEST_SCOPE,MACRO_ACTION,ACTION,IS_ALACARTE,MIN_API_VERSION,MAX_API_VERSION,IS_TOPLEVELFLOW,SERVICE_TYPE,CLOUD_OWNER)values ('NetworkSliceSubnet','Slice-Macro-delete','deleteRanSlice',0,1,7,1,'*','DEFAULT');

insert into orchestration_flow_reference (COMPOSITE_ACTION,SEQ_NO,FLOW_NAME,FLOW_VERSION,NB_REQ_REF_LOOKUP_ID,ACTION,SCOPE) values('Slice-Macro-delete',1,'DeleteRANNssiBB',1,181,null,null);
insert into orchestration_flow_reference (COMPOSITE_ACTION,SEQ_NO,FLOW_NAME,FLOW_VERSION,NB_REQ_REF_LOOKUP_ID,ACTION,SCOPE) values('Slice-Macro-delete',2,'ControllerExecutionBB',1,181,'get-subscriber-type-workflow',null);


select * from orchestration_flow_reference where COMPOSITE_ACTION='Slice-Macro-delete' order by seq_no;


insert into building_block_detail (BUILDING_BLOCK_NAME,RESOURCE_TYPE,TARGET_ACTION) values('AssignRANNssiBB','NO_VALIDATE','CUSTOM');

insert into building_block_detail (BUILDING_BLOCK_NAME,RESOURCE_TYPE,TARGET_ACTION) values('ModifyRANNssiBB','NO_VALIDATE','CUSTOM');

insert into building_block_detail (BUILDING_BLOCK_NAME,RESOURCE_TYPE,TARGET_ACTION) values('DeleteRANNssiBB','NO_VALIDATE','CUSTOM');
