adapters/mso-catalog-db-adapter/src/main/resources/db/migration/R__WorkflowDesignerData.sql

   1 use catalogdb;
   2
   3 DELETE FROM activity_spec_to_activity_spec_parameters;
   4 DELETE FROM activity_spec_to_activity_spec_categories;
   5 DELETE FROM activity_spec;
   6 DELETE FROM activity_spec_categories;
   7 DELETE FROM activity_spec_parameters;
   8
   9 INSERT INTO activity_spec (NAME, DESCRIPTION, VERSION)
  10 VALUES ('VNFSetInMaintFlagActivity','Activity to Set InMaint Flag in A&AI',1.0);
  11
  12 INSERT INTO activity_spec_categories (NAME)
  13 VALUES ('VNF');
  14
  15 INSERT INTO activity_spec_parameters (NAME, TYPE, DIRECTION, DESCRIPTION)
  16 VALUES('WorkflowException','WorkflowException','outputParameters','Description');
  17
  18 INSERT INTO activity_spec_to_activity_spec_categories(ACTIVITY_SPEC_ID, ACTIVITY_SPEC_CATEGORIES_ID)
  19 VALUES
  20 (
  21 (select ID from ACTIVITY_SPEC where NAME='VNFSetInMaintFlagActivity' and VERSION=1.0),
  22 (select ID from activity_spec_categories where NAME='VNF'));
  23
  24 INSERT INTO activity_spec_to_activity_spec_parameters( ACTIVITY_SPEC_ID, ACTIVITY_SPEC_PARAMETERS_ID)
  25 VALUES(
  26 (select ID from ACTIVITY_SPEC where NAME='VNFSetInMaintFlagActivity' and VERSION=1.0),
  27 (select ID from activity_spec_parameters where NAME='WorkflowException' and DIRECTION='outputParameters'));