diff options
| author |   hekeguang <hekeguang@chinamobile.com> | 2022-10-29 18:24:38 +0800 |
|---|---|---|
| committer |   Dan Xu <xudan16@huawei.com> | 2022-10-31 07:10:23 +0000 |
| commit | 9699468e0f4c6d9f5bddd3b3726e06bdb225815c (patch) | |
| tree | 8e50bc2118ecbe83dda736dbd030d672e69f0f45 /intentanalysis/src/main/resources/intent-analysis-data.sql | |
| parent | 6d26f1827217363f8f65398cc57c7ec793182c57 (diff) | |
Cherry Pick Bugfix for intent analysis server update and delete function.
Issue-ID: USECASEUI-749
Change-Id: I6aa749924fdbd3b38cb60ea3e3a5ea7fbc6b458b
Signed-off-by: hekeguang <hekeguang@chinamobile.com>
(cherry picked from commit f80da8c8ae6c38ae5fbb2b20498133c68c2ed761)
Diffstat (limited to 'intentanalysis/src/main/resources/intent-analysis-data.sql')
| -rw-r--r-- | intentanalysis/src/main/resources/intent-analysis-data.sql | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/intentanalysis/src/main/resources/intent-analysis-data.sql b/intentanalysis/src/main/resources/intent-analysis-data.sql index c03f305..16c3739 100644 --- a/intentanalysis/src/main/resources/intent-analysis-data.sql +++ b/intentanalysis/src/main/resources/intent-analysis-data.sql @@ -1,6 +1,8 @@ -- ---------------------------- -- Records of intent_management_function_reg_info -- ---------------------------- -INSERT INTO intent_management_function_reg_info(imfr_info_id, imfr_info_description, support_area, support_model, support_interfaces, handle_name, intent_function_type) VALUES ('CLLBusinessId','CLLBusiness','CLLBUSINESS',null,'CREATE,DELETE,UPDATE,SEARCH','CLLBusinessIntentManagementFunction','INTERNALFUNCTION'); -INSERT INTO intent_management_function_reg_info(imfr_info_id, imfr_info_description, support_area, support_model, support_interfaces, handle_name, intent_function_type) VALUES ('CLLDeliveryId','CLLDelivery','CLLBUSINESS,DELIVERY',null,'CREATE,DELETE,UPDATE,SEARCH','CLLDeliveryIntentManagementFunction','INTERNALFUNCTION'); -INSERT INTO intent_management_function_reg_info(imfr_info_id, imfr_info_description, support_area, support_model, support_interfaces, handle_name, intent_function_type) VALUES ('CLLAssuranceId','CLLAssurance','CLLBUSINESS,ASSURANCE',null,'CREATE,DELETE,UPDATE,SEARCH','CLLAssuranceIntentManagementFunction','INTERNALFUNCTION'); + +insert into intent_management_function_reg_info(imfr_info_id, imfr_info_description, support_area, support_model, support_interfaces, handle_name, intent_function_type) select 'CLLBusinessId','CLLBusiness','CLLBUSINESS',null,'CREATE,DELETE,UPDATE,SEARCH','CLLBusinessIntentManagementFunction','INTERNALFUNCTION' where not exists(select * from intent_management_function_reg_info where imfr_info_id='CLLBusinessId' ) +insert into intent_management_function_reg_info(imfr_info_id, imfr_info_description, support_area, support_model, support_interfaces, handle_name, intent_function_type) select 'CLLDeliveryId','CLLDelivery','CLLBUSINESS,DELIVERY',null,'CREATE,DELETE,UPDATE,SEARCH','CLLDeliveryIntentManagementFunction','INTERNALFUNCTION' where not exists(select * from intent_management_function_reg_info where imfr_info_id='CLLDeliveryId' ) +insert into intent_management_function_reg_info(imfr_info_id, imfr_info_description, support_area, support_model, support_interfaces, handle_name, intent_function_type) select 'CLLAssuranceId','CLLAssurance','CLLBUSINESS,ASSURANCE',null,'CREATE,DELETE,UPDATE,SEARCH','CLLAssuranceIntentManagementFunction','INTERNALFUNCTION' where not exists(select * from intent_management_function_reg_info where imfr_info_id='CLLAssuranceId' ) + |