Versions Compared

Old Version 4

changes.mady.by.user Kevin Timoney

Saved on

compared with

New Version Current

changes.mady.by.user Kevin Timoney

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...


drools-db-migration | Preparing upgrade release version: 0800
drools-db-migration | Preparing upgrade release version: 0900
drools-db-migration | Done
drools-db-migration | name version
drools-db-migration | policyadmin 0
drools-db-migration | policyadmin: upgrade available: 0 -> 0900
drools-db-migration | upgrade: 0 -> 0900
drools-db-migration |
drools-db-migration | > upgrade 1000100-jpapdpgroup_properties.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE TABLE IF NOT EXISTS jpapdpgroup_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES VARCHAR(255) NULL, PROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0110-jpapdpstatistics_enginestats.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpapdpgroupjpapdpstatistics_properties (name enginestats (AVERAGEEXECUTIONTIME DOUBLE DEFAULT NULL NULL, ENGINEID VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES VARCHAR(255) NULL, PROPERTIES_KEY VARCHAR(255255) NULL, ENGINETIMESTAMP BIGINT DEFAULT NULL NULL, ENGINEWORKERSTATE INT DEFAULT NULL NULL, EVENTCOUNT BIGINT DEFAULT NULL NULL, LASTENTERTIME BIGINT DEFAULT NULL NULL, LASTEXECUTIONTIME BIGINT DEFAULT NULL NULL, LASTSTART BIGINT DEFAULT NULL NULL, UPTIME BIGINT DEFAULT NULL NULL, ID BIGINT DEFAULT NULL NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0120-jpapdpsubgroup_policies.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS jpapdpsubgroup_policies (name VARCHAR(120) NULL, version VARCHAR(20) NULL, parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1100130-jpapdpstatisticsjpapdpsubgroup_enginestatsproperties.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE TABLE IF NOT EXISTS jpapdpsubgroup_properties (parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, PROPERTIES VARCHAR(255) NULL, PROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0140-jpapdpsubgroup_supportedpolicytypes.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpapdpstatistics_enginestats (AVERAGEEXECUTIONTIME DOUBLE DEFAULT NULL NULL, ENGINEID VARCHAR(255) NULL, ENGINETIMESTAMP BIGINT DEFAULT NULL NULL, ENGINEWORKERSTATE INT DEFAULT NULL NULL, EVENTCOUNT BIGINT DEFAULT NULL NULL, LASTENTERTIME BIGINT DEFAULT NULL NULL, LASTEXECUTIONTIME BIGINT DEFAULT NULL NULL, LASTSTART BIGINT DEFAULT NULL NULL, UPTIME BIGINT DEFAULT NULL NULL, ID BIGINT DEFAULT NULL NULL, name VARCHAR(120) NULL, version VARCHAR(20jpapdpsubgroup_supportedpolicytypes (name VARCHAR(120) NULL, version VARCHAR(20) NULL, parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0150-jpatoscacapabilityassignment_attributes.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_attributes (name VARCHAR(120) NULL, version VARCHAR(20) NULL, ATTRIBUTES LONGTEXT NULL, ATTRIBUTES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1200160-jpapdpsubgroupjpatoscacapabilityassignment_policiesmetadata.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db----migration | > upgrade 0170-jpatoscacapabilityassignment_occurrences.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpapdpsubgroupjpatoscacapabilityassignment_policies occurrences (name VARCHAR(120) NULL, version VARCHAR(20) NULL, parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) OCCURRENCES INT DEFAULT NULL NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0180-jpatoscacapabilityassignment_properties.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1300190-jpapdpsubgroupjpatoscacapabilitytype_propertiesmetadata.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE TABLE IF NOT EXISTS jpatoscacapabilitytype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db----migration | > upgrade 0200-jpatoscacapabilitytype_properties.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpapdpsubgroupjpatoscacapabilitytype_properties (parentLocalName name VARCHAR(120) NULL, localName version VARCHAR(12020) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, PROPERTIES VARCHAR(255) PROPERTIES LONGBLOB DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0210-jpatoscadatatype_constraints.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS jpatoscadatatype_constraints (name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINTS VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1400220-jpapdpsubgroupjpatoscadatatype_supportedpolicytypesmetadata.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE TABLE IF NOT EXISTS jpatoscadatatype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0230-jpatoscadatatype_properties.sql
drools-db-migration | ---------
drools-db-----
drools-db-migration | CREATE TABLE IF NOT EXISTS jpapdpsubgroupjpatoscadatatype_supportedpolicytypes properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULLPROPERTIES LONGBLOB DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1> upgrade 0240-jpatoscanodetemplate_metadata.sql
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 150-jpatoscacapabilityassignment_attributes.sqlCREATE TABLE IF NOT EXISTS jpatoscanodetemplate_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration | > upgrade 0250-jpatoscanodetemplate_properties.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignmentjpatoscanodetemplate_attributes properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, ATTRIBUTES PROPERTIES LONGTEXT NULL, ATTRIBUTESPROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools----db-migration | > upgrade 0260-jpatoscanodetype_metadata.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS jpatoscanodetype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1600270-jpatoscacapabilityassignmentjpatoscanodetype_metadataproperties.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE TABLE IF NOT EXISTS jpatoscanodetype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0280-jpatoscapolicy_metadata.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignmentjpatoscapolicy_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1> upgrade 0290-jpatoscapolicy_properties.sql
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 170-jpatoscacapabilityassignment_occurrences.sqlCREATE TABLE IF NOT EXISTS jpatoscapolicy_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration | > upgrade 0300-jpatoscapolicy_targets.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignmentjpatoscapolicy_occurrences targets (name VARCHAR(120) NULL, version VARCHAR(20) NULL, OCCURRENCES INT DEFAULT NULL NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0310-jpatoscapolicytype_metadata.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS jpatoscapolicytype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1800320-jpatoscacapabilityassignmentjpatoscapolicytype_properties.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE TABLE IF NOT EXISTS jpatoscapolicytype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0330-jpatoscapolicytype_targets.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignmentjpatoscapolicytype_properties targets (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0340-jpatoscapolicytype_triggers.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS jpatoscapolicytype_triggers (name VARCHAR(120) NULL, version VARCHAR(20) NULL, TRIGGERS VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1900350-jpatoscacapabilitytypejpatoscaproperty_metadataconstraints.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | ----CREATE TABLE IF NOT EXISTS jpatoscaproperty_constraints (parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, CONSTRAINTS VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0360-jpatoscaproperty_metadata.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscacapabilitytypejpatoscaproperty_metadata (name parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, version parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(20120) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0370-jpatoscarelationshiptype_metadata.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS jpatoscarelationshiptype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 2000380-jpatoscacapabilitytypejpatoscarelationshiptype_properties.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-CREATE TABLE IF NOT EXISTS jpatoscarelationshiptype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0390-jpatoscarequirement_metadata.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscacapabilitytypejpatoscarequirement_properties metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL NULL, PROPERTIESMETADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0400-jpatoscarequirement_occurrences.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS jpatoscarequirement_occurrences (name VARCHAR(120) NULL, version VARCHAR(20) NULL, OCCURRENCES INT DEFAULT NULL NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 2100410-jpatoscadatatypejpatoscarequirement_constraintsproperties.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE TABLE IF NOT EXISTS jpatoscarequirement_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools----db-migration | > upgrade 0420-jpatoscaservicetemplate_metadata.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscadatatypejpatoscaservicetemplate_constraints metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINTS METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1> upgrade 0430-jpatoscatopologytemplate_inputs.sql
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 220-jpatoscadatatype_metadata.sqlCREATE TABLE IF NOT EXISTS jpatoscatopologytemplate_inputs (parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, INPUTS LONGBLOB DEFAULT NULL NULL, INPUTS_KEY VARCHAR(255) NULL)
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration | > upgrade 0440-pdpgroup_pdpsubgroup.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscadatatypepdpgroup_metadata pdpsubgroup (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, METADATA parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(255120) NOT NULL, METADATA_KEY VARCHAR(255) NULLCONSTRAINT PK_PDPGROUP_PDPSUBGROUP PRIMARY KEY (name, version, parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0450-pdpgroup.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS pdpgroup (`DESCRIPTION` VARCHAR(255) NULL, PDPGROUPSTATE INT DEFAULT NULL NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_PDPGROUP PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 2300460-jpatoscadatatype_propertiespdppolicystatus.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | -----CREATE TABLE IF NOT EXISTS pdppolicystatus (DEPLOY BIT DEFAULT 0 NULL, PDPGROUP VARCHAR(255) NULL, PDPTYPE VARCHAR(255) NULL, STATE INT DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_PDPPOLICYSTATUS PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0470-pdp.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscadatatype_properties (name pdp (HEALTHY INT DEFAULT NULL NULL, MESSAGE VARCHAR(255) NULL, PDPSTATE INT DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, version localName VARCHAR(20120) NOT NULL, PROPERTIES LONGBLOB DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULLparentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, CONSTRAINT PK_PDP PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools---db-migration | > upgrade 0480-pdpstatistics.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS pdpstatistics (PDPGROUPNAME VARCHAR(120) NULL, PDPSUBGROUPNAME VARCHAR(120) NULL, POLICYDEPLOYCOUNT BIGINT DEFAULT NULL NULL, POLICYDEPLOYFAILCOUNT BIGINT DEFAULT NULL NULL, POLICYDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL NULL, POLICYEXECUTEDCOUNT BIGINT DEFAULT NULL NULL, POLICYEXECUTEDFAILCOUNT BIGINT DEFAULT NULL NULL, POLICYEXECUTEDSUCCESSCOUNT BIGINT DEFAULT NULL NULL, TIMESTAMP datetime DEFAULT NULL NULL, ID BIGINT NOT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 2400490-jpatoscanodetemplatepdpsubgroup_metadatapdp.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------CREATE TABLE IF NOT EXISTS pdpsubgroup_pdp (pdpParentKeyName VARCHAR(120) NOT NULL, pdpParentKeyVersion VARCHAR(15) NOT NULL, pdpParentLocalName VARCHAR(120) NOT NULL, pdpLocalName VARCHAR(120) NOT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, CONSTRAINT PK_PDPSUBGROUP_PDP PRIMARY KEY (pdpParentKeyName, pdpParentKeyVersion, pdpParentLocalName, pdpLocalName, parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0500-pdpsubgroup.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscanodetemplate_metadata (name pdpsubgroup (CURRENTINSTANCECOUNT INT DEFAULT NULL NULL, DESIREDINSTANCECOUNT INT DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, version parentKeyVersion VARCHAR(2015) NOT NULL, METADATA parentKeyName VARCHAR(255120) NOT NULL, METADATACONSTRAINT PK_PDPSUBGROUP PRIMARY KEY VARCHAR(255) NULL(parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db----migration | > upgrade 0510-toscacapabilityassignment.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS toscacapabilityassignment (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, CONSTRAINT PK_TOSCACAPABILITYASSIGNMENT PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 2500520-jpatoscanodetemplate_propertiestoscacapabilityassignments.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE TABLE IF NOT EXISTS toscacapabilityassignments (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCACAPABILITYASSIGNMENTS PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0530-toscacapabilityassignments_toscacapabilityassignment.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscanodetemplatetoscacapabilityassignments_properties (toscacapabilityassignment (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULLCONSTRAINT PK_TOSCACAPABILITYASSIGNMENTS_TOSCACAPABILITYASSIGNMENT PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0540-toscacapabilitytype.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS toscacapabilitytype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCACAPABILITYTYPE PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 2600550-jpatoscanodetype_metadatatoscacapabilitytypes.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-dbCREATE TABLE IF NOT EXISTS toscacapabilitytypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCACAPABILITYTYPES PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0560-toscacapabilitytypes_toscacapabilitytype.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscanodetypetoscacapabilitytypes_metadata toscacapabilitytype (name conceptContainerMapName VARCHAR(120) NOT NULL, version concpetContainerMapVersion VARCHAR(20) NOT NULL, METADATA conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(25520) NOT NULL, METADATA_KEY name VARCHAR(255120) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCACAPABILITYTYPES_TOSCACAPABILITYTYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 2700570-jpatoscanodetype_propertiestoscadatatype.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE TABLE IF NOT EXISTS toscadatatype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCADATATYPE PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0580-toscadatatypes.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscanodetype_properties toscadatatypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PROPERTIES LONGBLOB DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULLCONSTRAINT PK_TOSCADATATYPES PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1> upgrade 0590-toscadatatypes_toscadatatype.sql
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 280-jpatoscapolicy_metadata.sql
CREATE TABLE IF NOT EXISTS toscadatatypes_toscadatatype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCADATATYPES_TOSCADATATYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration | > upgrade 0600-toscanodetemplate.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicy_metadata (toscanodetemplate (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, METADATA type_name VARCHAR(255) NULL, METADATAtype_KEY version VARCHAR(255) NULL, capabilitiesName VARCHAR(120) NULL, capabilitiesVersion VARCHAR(20) NULL, requirementsVersion VARCHAR(20) NULL, requirementsName VARCHAR(120) NULL, CONSTRAINT PK_TOSCANODETEMPLATE PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0610-toscanodetemplates.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS toscanodetemplates (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCANODETEMPLATES PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 2900620-jpatoscapolicytoscanodetemplates_propertiestoscanodetemplate.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE TABLE IF NOT EXISTS toscanodetemplates_toscanodetemplate (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCANODETEMPLATES_TOSCANODETEMPLATE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0630-toscanodetype.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicy_properties toscanodetype (name `DESCRIPTION` VARCHAR(120255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PROPERTIES LONGTEXT requirementsVersion VARCHAR(20) NULL, requirementsName VARCHAR(120) NULL, PROPERTIESCONSTRAINT PK_TOSCANODETYPE PRIMARY KEY VARCHAR (255name, version) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1> upgrade 0640-toscanodetypes.sql
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 300-jpatoscapolicy_targets.sqlCREATE TABLE IF NOT EXISTS toscanodetypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCANODETYPES PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration | > upgrade 0650-toscanodetypes_toscanodetype.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicy_targets (toscanodetypes_toscanodetype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCANODETYPES_TOSCANODETYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0660-toscaparameter.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS toscaparameter (VALUE VARCHAR(255) NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAPARAMETER PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 3100670-jpatoscapolicytype_metadatatoscapolicies.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE TABLE IF NOT EXISTS toscapolicies (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAPOLICIES PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0680-toscapolicies_toscapolicy.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicytype_metadata (name toscapolicies_toscapolicy (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, version conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, METADATA version VARCHAR(25520) NULL, METADATA_KEY VARCHAR(255) NULLCONSTRAINT PK_TOSCAPOLICIES_TOSCAPOLICY PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1> upgrade 0690-toscapolicy.sql
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 320-jpatoscapolicytype_properties.sqlCREATE TABLE IF NOT EXISTS toscapolicy (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, CONSTRAINT PK_TOSCAPOLICY PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration | > upgrade 0700-toscapolicytype.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicytype_properties (toscapolicytype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PROPERTIES LONGBLOB DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULLCONSTRAINT PK_TOSCAPOLICYTYPE PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0710-toscapolicytypes.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS toscapolicytypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAPOLICYTYPES PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 3300720-jpatoscapolicytypetoscapolicytypes_targetstoscapolicytype.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE TABLE IF NOT EXISTS toscapolicytypes_toscapolicytype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAPOLICYTYPES_TOSCAPOLICYTYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0730-toscaproperty.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicytype_targets toscaproperty (name DEFAULTVALUE VARCHAR(120255) NULL, version `DESCRIPTION` VARCHAR(20255) NULL)
drools-db-migration | ----NULL, ENTRYSCHEMA LONGBLOB DEFAULT NULL NULL, REQUIRED BIT DEFAULT 0 NULL, STATUS INT DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAPROPERTY PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0740-toscarelationshiptype.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS toscarelationshiptype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCARELATIONSHIPTYPE PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 3400750-jpatoscapolicytype_triggerstoscarelationshiptypes.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE TABLE IF NOT EXISTS toscarelationshiptypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCARELATIONSHIPTYPES PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0760-toscarelationshiptypes_toscarelationshiptype.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicytype_triggers (toscarelationshiptypes_toscarelationshiptype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, TRIGGERS VARCHAR(255) NULLCONSTRAINT PK_TOSCARELATIONSHIPTYPES_TOSCARELATIONSHIPTYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1> upgrade 0770-toscarequirement.sql
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 350-jpatoscaproperty_constraints.sqlCREATE TABLE IF NOT EXISTS toscarequirement (CAPABILITY VARCHAR(255) NULL, `DESCRIPTION` VARCHAR(255) NULL, NODE VARCHAR(255) NULL, RELATIONSHIP VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, CONSTRAINT PK_TOSCAREQUIREMENT PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration | > upgrade 0780-toscarequirements.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscaproperty_constraints toscarequirements (parentLocalName name VARCHAR(120) NOT NULL, localName version VARCHAR(12020) NOT NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, CONSTRAINTS VARCHAR(255) NULLCONSTRAINT PK_TOSCAREQUIREMENTS PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1migration | > upgrade 0790-toscarequirements_toscarequirement.sql
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 360-jpatoscaproperty_metadata.sqlCREATE TABLE IF NOT EXISTS toscarequirements_toscarequirement (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAREQUIREMENTS_TOSCAREQUIREMENT PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration | > upgrade 0800-toscaservicetemplate.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscaproperty_metadata toscaservicetemplate (parentLocalName `DESCRIPTION` VARCHAR(120255) NULL, localName TOSCADEFINITIONSVERSION VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName 255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, capabilityTypesVersion VARCHAR(20) NULL, capabilityTypesName VARCHAR(120) NULL, dataTypesName VARCHAR(120) NULL, dataTypesVersion VARCHAR(20) NULL, nodeTypesVersion VARCHAR(20) NULL, nodeTypesName VARCHAR(120) NULL, policyTypesName VARCHAR(120) NULL, policyTypesVersion VARCHAR(20) NULL, relationshipTypesVersion VARCHAR(20) NULL, relationshipTypesName VARCHAR(120) NULL, topologyTemplateLocalName VARCHAR(120) NULL, topologyTemplateParentKeyName VARCHAR(120) NULL, METADATA topologyTemplateParentKeyVersion VARCHAR(15) NULL, topologyTemplateParentLocalName VARCHAR(255120) NULL, METADATACONSTRAINT PK_TOSCASERVICETEMPLATE PRIMARY KEY VARCHAR (255name, version) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1> upgrade 0810-toscatopologytemplate.sql
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 370-jpatoscarelationshiptype_metadata.sqlCREATE TABLE IF NOT EXISTS toscatopologytemplate (`description` VARCHAR(255) NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, nodeTemplatessVersion VARCHAR(20) NULL, nodeTemplatesName VARCHAR(120) NULL, policyVersion VARCHAR(20) NULL, policyName VARCHAR(120) NULL, CONSTRAINT PK_TOSCATOPOLOGYTEMPLATE PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration | > upgrade 0820-toscatrigger.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscarelationshiptype_metadata toscatrigger (name ACTION VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA 255) NULL, toscaCondition LONGBLOB DEFAULT NULL NULL, toscaConstraint LONGBLOB DEFAULT NULL NULL, `DESCRIPTION` VARCHAR(255) NULL, EVALUATIONS INT DEFAULT NULL NULL, EVENTTYPE VARCHAR(255) NULL, METADATA_KEY METHOD VARCHAR(255) NULL)
drools, `PERIOD` LONGBLOB DEFAULT NULL NULL, SCHEDULE LONGBLOB DEFAULT NULL NULL, TARGETFILTER LONGBLOB DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, CONSTRAINT PK_TOSCATRIGGER PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0830-FK_ToscaNodeTemplate_capabilitiesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1ALTER TABLE toscanodetemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES toscacapabilityassignments (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 3800840-jpatoscarelationshiptypeFK_ToscaNodeTemplate_propertiesrequirementsName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0ALTER TABLE toscanodetemplate ADD CONSTRAINT FK_ToscaNodeTemplate_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES toscarequirements (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-----db-migration | > upgrade 0850-FK_ToscaNodeType_requirementsName.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscarelationshiptype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGBLOB DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL)ALTER TABLE toscanodetype ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES toscarequirements (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_capabilityTypesName FOREIGN KEY (capabilityTypesName, capabilityTypesVersion) REFERENCES toscacapabilitytypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 3900870-jpatoscarequirementFK_ToscaServiceTemplate_metadatadataTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES toscadatatypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0880-FK_ToscaServiceTemplate_nodeTypesName.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscarequirement_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL)ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_nodeTypesName FOREIGN KEY (nodeTypesName, nodeTypesVersion) REFERENCES toscanodetypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0890-FK_ToscaServiceTemplate_policyTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_policyTypesName FOREIGN KEY (policyTypesName, policyTypesVersion) REFERENCES toscapolicytypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 4000900-jpatoscarequirementFK_ToscaServiceTemplate_occurrencesrelationshipTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_relationshipTypesName FOREIGN KEY (relationshipTypesName, relationshipTypesVersion) REFERENCES toscarelationshiptypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscarequirement_occurrences (name VARCHAR(120) NULL, version VARCHAR(20) NULL, OCCURRENCES INT DEFAULT NULL NULL)ALTER TABLE toscatopologytemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_nodeTemplatesName FOREIGN KEY (nodeTemplatesName, nodeTemplatessVersion) REFERENCES toscanodetemplates (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0920-FK_ToscaTopologyTemplate_policyName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1ALTER TABLE toscatopologytemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES toscapolicies (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 4100930-jpatoscarequirement_propertiesTscaServiceTemplatetopologyTemplateParentLocalName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0ALTER TABLE toscaservicetemplate ADD CONSTRAINT TscaServiceTemplatetopologyTemplateParentLocalName FOREIGN KEY (topologyTemplateParentLocalName, topologyTemplateLocalName, topologyTemplateParentKeyVersion, topologyTemplateParentKeyName) REFERENCES toscatopologytemplate (parentLocalName, localName, parentKeyVersion, parentKeyName) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0940-FK_ToscaNodeTemplate_capabilitiesName.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscarequirement_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULLINDEX FK_ToscaNodeTemplate_capabilitiesName ON toscanodetemplate(capabilitiesName, capabilitiesVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0950-FK_ToscaNodeTemplate_requirementsName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE INDEX FK_ToscaNodeTemplate_requirementsName ON toscanodetemplate(requirementsName, requirementsVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 4200960-jpatoscaservicetemplateFK_ToscaNodeType_metadatarequirementsName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE INDEX FK_ToscaNodeType_requirementsName ON toscanodetype(requirementsName, requirementsVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db----migration | > upgrade 0970-FK_ToscaServiceTemplate_capabilityTypesName.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscaservicetemplate_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULLINDEX FK_ToscaServiceTemplate_capabilityTypesName ON toscaservicetemplate(capabilityTypesName, capabilityTypesVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0980-FK_ToscaServiceTemplate_dataTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE INDEX FK_ToscaServiceTemplate_dataTypesName ON toscaservicetemplate(dataTypesName, dataTypesVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 4300990-jpatoscatopologytemplateFK_ToscaServiceTemplate_inputsnodeTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE INDEX FK_ToscaServiceTemplate_nodeTypesName ON toscaservicetemplate(nodeTypesName, nodeTypesVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1000-FK_ToscaServiceTemplate_policyTypesName.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscatopologytemplate_inputs (parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) NULL, INPUTS LONGBLOB DEFAULT NULL NULL, INPUTS_KEY VARCHAR(255) NULL)INDEX FK_ToscaServiceTemplate_policyTypesName ON toscaservicetemplate(policyTypesName, policyTypesVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1010-FK_ToscaServiceTemplate_relationshipTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE INDEX FK_ToscaServiceTemplate_relationshipTypesName ON toscaservicetemplate(relationshipTypesName, relationshipTypesVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 4401020-pdpgroupFK_ToscaTopologyTemplate_pdpsubgroupnodeTemplatesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE INDEX FK_ToscaTopologyTemplate_nodeTemplatesName ON toscatopologytemplate(nodeTemplatesName, nodeTemplatessVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1030-FK_ToscaTopologyTemplate_policyName.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS pdpgroup_pdpsubgroup (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, CONSTRAINT PK_PDPGROUP_PDPSUBGROUP PRIMARY KEY (name, version, parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | INDEX FK_ToscaTopologyTemplate_policyName ON toscatopologytemplate(policyName, policyVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1040-IDX_TSIDX1.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE INDEX IDX_TSIDX1 ON pdpstatistics(TIMESTAMP, name, version)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 4501050-pdpgroupPdpPolicyStatus_PdpGroup.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE INDEX PdpPolicyStatus_PdpGroup ON pdppolicystatus(PDPGROUP)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS pdpgroup (`DESCRIPTION` VARCHAR(255) NULL, PDPGROUPSTATE INT DEFAULT NULL NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_PDPGROUP PRIMARY KEY (name, version))
INDEX TscaServiceTemplatetopologyTemplateParentLocalName ON toscaservicetemplate(topologyTemplateParentLocalName, topologyTemplateLocalName, topologyTemplateParentKeyVersion, topologyTemplateParentKeyName)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0100-jpapolicyaudit.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS jpapolicyaudit (ACTION INT DEFAULT NULL NULL, PDPGROUP VARCHAR(255) NULL, PDPTYPE VARCHAR(255) NULL, TIMESTAMP datetime DEFAULT NULL NULL, USER VARCHAR(255) NULL, ID BIGINT NOT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_JPAPOLICYAUDIT PRIMARY KEY (ID, name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 4600110-pdppolicystatussequence.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE TABLE IF NOT EXISTS sequence (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38) DEFAULT NULL NULL, CONSTRAINT PK_SEQUENCE PRIMARY KEY (SEQ_NAME))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-------------
drools-db-migration | CREATE TABLE IF NOT EXISTS pdppolicystatus (DEPLOY BIT DEFAULT 0 NULL, PDPGROUP VARCHAR(255) NULL, PDPTYPE VARCHAR(255) NULL, STATE INT DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_PDPPOLICYSTATUS PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))migration | > upgrade 0120-JpaPolicyAuditIndex_timestamp.sql
drools-db-migration | --------------
drools-db-migration | CREATE INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit(TIMESTAMP)
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------policyadmin: OK: upgrade (0900)
drools-db-migration | name version
drools-db-migration | policyadmin 0900
drools-db-migration | > upgrade 470-pdp.sqlID script operation from_version to_version tag success atTime
drools-db-migration | 1 0100-jpapdpgroup_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 2 0110-jpapdpstatistics_enginestats.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 3 0120-jpapdpsubgroup_policies.sql upgrade 0 0800 1907211503200800u 1 2021---07-19 15:03:20
drools-db-migration | SET FOREIGN_KEY_CHECKS = 04 0130-jpapdpsubgroup_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 5 0140-jpapdpsubgroup_supportedpolicytypes.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:20
drools-db-migration | 6 0150-jpatoscacapabilityassignment_attributes.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:20
drools-db-migration | --------------7 0160-jpatoscacapabilityassignment_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | CREATE TABLE IF NOT EXISTS pdp (HEALTHY INT DEFAULT NULL NULL, MESSAGE VARCHAR(255) NULL, PDPSTATE INT DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, CONSTRAINT PK_PDP PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))8 0170-jpatoscacapabilityassignment_occurrences.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:20
drools-db-migration | 9 0180-jpatoscacapabilityassignment_properties.sql upgrade 0 0800 1907211503200800u 2021-------------07-19 15:03:20
drools-db-migration | 10 0190-jpatoscacapabilitytype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | --------------11 0200-jpatoscacapabilitytype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | SET FOREIGN_KEY_CHECKS = 112 0210-jpatoscadatatype_constraints.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 13 0220-jpatoscadatatype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:20
drools-db-migration |
drools-db-migration |14 0230-jpatoscadatatype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | > upgrade 480-pdpstatistics.sql15 0240-jpatoscanodetemplate_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 16 0250-jpatoscanodetemplate_properties.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:20
drools-db-migration | SET FOREIGN_KEY_CHECKS = 017 0260-jpatoscanodetype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 18 0270-jpatoscanodetype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 19 0280-jpatoscapolicy_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 20 0290-jpatoscapolicy_properties.sql upgrade 0 0800 1907211503200800u 1 2021---07-19 15:03:20
drools-db-migration | 21 0300-jpatoscapolicy_targets.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 22 0310-jpatoscapolicytype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 23 0320-jpatoscapolicytype_properties.sql upgrade 0 0800 1907211503200800u 1 2021--------07-19 15:03:20
drools-db-migration | CREATE TABLE IF NOT EXISTS pdpstatistics (PDPGROUPNAME VARCHAR(120) NULL, PDPSUBGROUPNAME VARCHAR(120) NULL, POLICYDEPLOYCOUNT BIGINT DEFAULT NULL NULL, POLICYDEPLOYFAILCOUNT BIGINT DEFAULT NULL NULL, POLICYDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL NULL, POLICYEXECUTEDCOUNT BIGINT DEFAULT NULL NULL, POLICYEXECUTEDFAILCOUNT BIGINT DEFAULT NULL NULL, POLICYEXECUTEDSUCCESSCOUNT BIGINT DEFAULT NULL NULL, TIMESTAMP datetime DEFAULT NULL NULL, ID BIGINT NOT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version))24 0330-jpatoscapolicytype_targets.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 25 0340-jpatoscapolicytype_triggers.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration | 26 0350-jpatoscaproperty_constraints.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | --------------27 0360-jpatoscaproperty_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | SET FOREIGN_KEY_CHECKS = 128 0370-jpatoscarelationshiptype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 29 0380-jpatoscarelationshiptype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration |
drools-db-migration |30 0390-jpatoscarequirement_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | > upgrade 490-pdpsubgroup_pdp.sql31 0400-jpatoscarequirement_occurrences.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 32 0410-jpatoscarequirement_properties.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration | SET FOREIGN_KEY_CHECKS = 033 0420-jpatoscaservicetemplate_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 34 0430-jpatoscatopologytemplate_inputs.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 35 0440-pdpgroup_pdpsubgroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 36 0450-pdpgroup.sql upgrade 0 0800 1907211503200800u 1 2021---07-19 15:03:21
drools-db-migration | 37 0460-pdppolicystatus.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 38 0470-pdp.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 39 0480-pdpstatistics.sql upgrade 0 0800 1907211503200800u 1 2021--------07-19 15:03:21
drools-db-migration | CREATE TABLE IF NOT EXISTS pdpsubgroup_pdp (pdpParentKeyName VARCHAR(120) NOT NULL, pdpParentKeyVersion VARCHAR(15) NOT NULL, pdpParentLocalName VARCHAR(120) NOT NULL, pdpLocalName VARCHAR(120) NOT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, CONSTRAINT PK_PDPSUBGROUP_PDP PRIMARY KEY (pdpParentKeyName, pdpParentKeyVersion, pdpParentLocalName, pdpLocalName, parentLocalName, localName, parentKeyVersion, parentKeyName))40 0490-pdpsubgroup_pdp.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 41 0500-pdpsubgroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 42 0510-toscacapabilityassignment.sql upgrade 0 0800 1907211503200800u 1 2021--------07-19 15:03:21
drools-db-migration | 43 0520-toscacapabilityassignments.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | --------------44 0530-toscacapabilityassignments_toscacapabilityassignment.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | SET FOREIGN_KEY_CHECKS = 145 0540-toscacapabilitytype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 46 0550-toscacapabilitytypes.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration |
drools-db-migration |47 0560-toscacapabilitytypes_toscacapabilitytype.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:21
drools-db-migration | > upgrade 500-pdpsubgroup.sql48 0570-toscadatatype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 49 0580-toscadatatypes.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration | SET FOREIGN_KEY_CHECKS = 050 0590-toscadatatypes_toscadatatype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 51 0600-toscanodetemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 52 0610-toscanodetemplates.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 53 0620-toscanodetemplates_toscanodetemplate.sql upgrade 0 0800 1907211503200800u 1 2021---07-19 15:03:21
drools-db-migration | 54 0630-toscanodetype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 55 0640-toscanodetypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 56 0650-toscanodetypes_toscanodetype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 57 0660-toscaparameter.sql upgrade 0 0800 1907211503200800u 1 2021---07-19 15:03:22
drools-db-migration | CREATE TABLE IF NOT EXISTS pdpsubgroup (CURRENTINSTANCECOUNT INT DEFAULT NULL NULL, DESIREDINSTANCECOUNT INT DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, CONSTRAINT PK_PDPSUBGROUP PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))58 0670-toscapolicies.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 59 0680-toscapolicies_toscapolicy.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 60 0690-toscapolicy.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 61 0700-toscapolicytype.sql upgrade 0 0800 1907211503200800u 1 2021---07-19 15:03:22
drools-db-migration | 62 0710-toscapolicytypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 63 0720-toscapolicytypes_toscapolicytype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 64 0730-toscaproperty.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 65 0740-toscarelationshiptype.sql upgrade 0 0800 1907211503200800u 1 2021---07-19 15:03:22
drools-db-migration | SET FOREIGN_KEY_CHECKS = 166 0750-toscarelationshiptypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 67 0760-toscarelationshiptypes_toscarelationshiptype.sql upgrade 0 0800 1907211503200800u 2021-------------07-19 15:03:22
drools-db-migration |
drools-db-migration |68 0770-toscarequirement.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | > upgrade 510-toscacapabilityassignment.sql69 0780-toscarequirements.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | --------------70 0790-toscarequirements_toscarequirement.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 71 0800-toscaservicetemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 72 0810-toscatopologytemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | SET FOREIGN_KEY_CHECKS = 073 0820-toscatrigger.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 74 0830-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 75 0840-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021--------07-19 15:03:22
drools-db-migration | 76 0850-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 77 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 1907211503200800u 2021-------------07-19 15:03:22
drools-db-migration | CREATE TABLE IF NOT EXISTS toscacapabilityassignment (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, CONSTRAINT PK_TOSCACAPABILITYASSIGNMENT PRIMARY KEY (name, version))78 0870-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 79 0880-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:22
drools-db-migration |
drools-db-migration | --------------80 0890-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:22
drools-db-migration | 81 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:23
drools-db-migration | SET FOREIGN_KEY_CHECKS = 182 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:23
drools-db-migration | 83 0920-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:23
drools-db-migration |
drools-db-migration |84 0930-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | > upgrade 520-toscacapabilityassignments.sql85 0940-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | --------------86 0950-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 87 0960-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | SET FOREIGN_KEY_CHECKS = 088 0970-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:23
drools-db-migration | 89 0980-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:23
drools-db-migration | 90 0990-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 91 1000-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 1907211503200800u 2021-------------07-19 15:03:23
drools-db-migration | CREATE TABLE IF NOT EXISTS toscacapabilityassignments (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCACAPABILITYASSIGNMENTS PRIMARY KEY (name, version))92 1010-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:23
drools-db-migration | 93 1020-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 1907211503200800u 2021-------------07-19 15:03:23
drools-db-migration | 94 1030-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 95 1040-IDX_TSIDX1.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:23
drools-db-migration | SET FOREIGN_KEY_CHECKS = 196 1050-PdpPolicyStatus_PdpGroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | --------------97 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 98 0100-jpapolicyaudit.sql upgrade 0800 0900 1907211503200900u 1 2021-07-19 15:03:23
drools-db-migration | 99 0110-sequence.sql upgrade 0800 0900 1907211503200900u 1 2021-07-19 15:03:23
drools-db-migration | 100 0120-JpaPolicyAuditIndex_timestamp.sql upgrade 0800 0900 1907211503200900u 1 2021-07-19 15:03:23
drools-db-migration | policyadmin: OK @ 0900
drools-db-migration | 223 blocks
drools-db-migration | Preparing downgrade release version: 0800
drools-db-migration | Preparing downgrade release version: 0900
drools-db-migration | Done
drools-db-migration | downgrade: 0900 -> 0800
drools-db-migration |
drools-db-migration | > upgrade 530downgrade 0120-toscacapabilityassignmentsJpaPolicyAuditIndex_toscacapabilityassignmenttimestamp.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscacapabilityassignments_toscacapabilityassignment (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCACAPABILITYASSIGNMENTS_TOSCACAPABILITYASSIGNMENT PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))DROP INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 540downgrade 0110-toscacapabilitytypesequence.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0DROP TABLE IF EXISTS `sequence`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > downgrade 0100-jpapolicyaudit.sql
drools-db-migration | --------------
drools-db-migration | CREATE DROP TABLE IF NOT EXISTS toscacapabilitytype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCACAPABILITYTYPE PRIMARY KEY (name, version))EXISTS `jpapolicyaudit`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------policyadmin: OK: downgrade (0800)
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1name version
drools-db-migration | --------------policyadmin 0800
drools-db-migration | ID script operation from_version to_version tag success atTime
drools-db-migration | 1 0100-jpapdpgroup_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | > upgrade 550-toscacapabilitytypes.sql2 0110-jpapdpstatistics_enginestats.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 3 0120-jpapdpsubgroup_policies.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:20
drools-db-migration | SET FOREIGN_KEY_CHECKS = 04 0130-jpapdpsubgroup_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | --------------5 0140-jpapdpsubgroup_supportedpolicytypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 6 0150-jpatoscacapabilityassignment_attributes.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:20
drools-db-migration | 7 0160-jpatoscacapabilityassignment_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:20
drools-db-migration | CREATE TABLE IF NOT EXISTS toscacapabilitytypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCACAPABILITYTYPES PRIMARY KEY (name, version))8 0170-jpatoscacapabilityassignment_occurrences.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:20
drools-db-migration | 9 0180-jpatoscacapabilityassignment_properties.sql upgrade 0 0800 1907211503200800u 2021-------------07-19 15:03:20
drools-db-migration |
drools-db-migration | --------------10 0190-jpatoscacapabilitytype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | SET FOREIGN_KEY_CHECKS = 111 0200-jpatoscacapabilitytype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 12 0210-jpatoscadatatype_constraints.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:20
drools-db-migration |
drools-db-migration |13 0220-jpatoscadatatype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | > upgrade 560-toscacapabilitytypes_toscacapabilitytype.sql14 0230-jpatoscadatatype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 15 0240-jpatoscanodetemplate_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:20
drools-db-migration | SET FOREIGN_KEY_CHECKS = 016 0250-jpatoscanodetemplate_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 17 0260-jpatoscanodetype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 18 0270-jpatoscanodetype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 19 0280-jpatoscapolicy_metadata.sql upgrade 0 0800 1907211503200800u 1 2021---07-19 15:03:20
drools-db-migration | 20 0290-jpatoscapolicy_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 21 0300-jpatoscapolicy_targets.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 22 0310-jpatoscapolicytype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021--------07-19 15:03:20
drools-db-migration | CREATE TABLE IF NOT EXISTS toscacapabilitytypes_toscacapabilitytype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCACAPABILITYTYPES_TOSCACAPABILITYTYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))23 0320-jpatoscapolicytype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 24 0330-jpatoscapolicytype_targets.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration | 25 0340-jpatoscapolicytype_triggers.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 26 0350-jpatoscaproperty_constraints.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration | SET FOREIGN_KEY_CHECKS = 127 0360-jpatoscaproperty_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 28 0370-jpatoscarelationshiptype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration |
drools-db-migration |29 0380-jpatoscarelationshiptype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | > upgrade 570-toscadatatype.sql30 0390-jpatoscarequirement_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 31 0400-jpatoscarequirement_occurrences.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration | SET FOREIGN_KEY_CHECKS = 032 0410-jpatoscarequirement_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | --------------33 0420-jpatoscaservicetemplate_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 34 0430-jpatoscatopologytemplate_inputs.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 35 0440-pdpgroup_pdpsubgroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 36 0450-pdpgroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 37 0460-pdppolicystatus.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 38 0470-pdp.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 39 0480-pdpstatistics.sql upgrade 0 0800 1907211503200800u 1 2021---07-19 15:03:21
drools-db-migration | CREATE TABLE IF NOT EXISTS toscadatatype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCADATATYPE PRIMARY KEY (name, version))40 0490-pdpsubgroup_pdp.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 41 0500-pdpsubgroup.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration | 42 0510-toscacapabilityassignment.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 43 0520-toscacapabilityassignments.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration | SET FOREIGN_KEY_CHECKS = 144 0530-toscacapabilityassignments_toscacapabilityassignment.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 45 0540-toscacapabilitytype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 46 0550-toscacapabilitytypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 47 0560-toscacapabilitytypes_toscacapabilitytype.sql upgrade 0 0800 1907211503200800u 2021---07-19 15:03:21
drools-db-migration |
drools-db-migration |48 0570-toscadatatype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | > upgrade 58049 0580-toscadatatypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 50 0590-toscadatatypes_toscadatatype.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration | SET FOREIGN_KEY_CHECKS = 051 0600-toscanodetemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | --------------52 0610-toscanodetemplates.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 53 0620-toscanodetemplates_toscanodetemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 54 0630-toscanodetype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 55 0640-toscanodetypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 56 0650-toscanodetypes_toscanodetype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 57 0660-toscaparameter.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 58 0670-toscapolicies.sql upgrade 0 0800 1907211503200800u 1 2021---07-19 15:03:22
drools-db-migration | CREATE TABLE IF NOT EXISTS toscadatatypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCADATATYPES PRIMARY KEY (name, version))59 0680-toscapolicies_toscapolicy.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 60 0690-toscapolicy.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:22
drools-db-migration | 61 0700-toscapolicytype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 62 0710-toscapolicytypes.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:22
drools-db-migration | SET FOREIGN_KEY_CHECKS = 163 0720-toscapolicytypes_toscapolicytype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 64 0730-toscaproperty.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:22
drools-db-migration | 65 0740-toscarelationshiptype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 66 0750-toscarelationshiptypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | > upgrade 590-toscadatatypes_toscadatatype.sql67 0760-toscarelationshiptypes_toscarelationshiptype.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:22
drools-db-migration | 68 0770-toscarequirement.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 69 0780-toscarequirements.sql upgrade 0 0800 1907211503200800u 1 2021--------07-19 15:03:22
drools-db-migration | SET FOREIGN_KEY_CHECKS = 070 0790-toscarequirements_toscarequirement.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 71 0800-toscaservicetemplate.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:22
drools-db-migration |
drools-db-migration | --------------72 0810-toscatopologytemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 73 0820-toscatrigger.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 74 0830-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | CREATE TABLE IF NOT EXISTS toscadatatypes_toscadatatype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCADATATYPES_TOSCADATATYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))75 0840-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | --------------76 0850-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 77 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:22
drools-db-migration | 78 0870-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:22
drools-db-migration | SET FOREIGN_KEY_CHECKS = 179 0880-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 80 0890-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 1907211503200800u 2021-------------07-19 15:03:22
drools-db-migration |
drools-db-migration |81 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:23
drools-db-migration | > upgrade 600-toscanodetemplate.sql82 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:23
drools-db-migration | 83 0920-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 84 0930-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1907211503200800u 1 2021--------07-19 15:03:23
drools-db-migration | SET FOREIGN_KEY_CHECKS = 085 0940-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 86 0950-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:23
drools-db-migration | 87 0960-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 88 0970-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:23
drools-db-migration | 89 0980-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 90 0990-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 91 1000-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:23
drools-db-migration | CREATE TABLE IF NOT EXISTS toscanodetemplate (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, capabilitiesName VARCHAR(120) NULL, capabilitiesVersion VARCHAR(20) NULL, requirementsVersion VARCHAR(20) NULL, requirementsName VARCHAR(120) NULL, CONSTRAINT PK_TOSCANODETEMPLATE PRIMARY KEY (name, version))92 1010-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:23
drools-db-migration | 93 1020-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:23
drools-db-migration | 94 1030-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 95 1040-IDX_TSIDX1.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 96 1050-PdpPolicyStatus_PdpGroup.sql upgrade 0 0800 1907211503200800u 1 2021---07-19 15:03:23
drools-db-migration | 97 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 98 0100-jpapolicyaudit.sql upgrade 0800 0900 1907211503200900u 1 2021-07-19 15:03:23
drools-db-migration | 99 0110-sequence.sql upgrade 0800 0900 1907211503200900u 1 2021-07-19 15:03:23
drools-db-migration | 100 0120-JpaPolicyAuditIndex_timestamp.sql upgrade 0800 0900 1907211503200900u 1 2021---07-19 15:03:23
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1101 0120-JpaPolicyAuditIndex_timestamp.sql downgrade 0900 0800 1907211503280900d 1 2021-07-19 15:03:28
drools-db-migration | 102 0110-sequence.sql downgrade 0900 0800 1907211503280900d 1 2021-07-19 15:03:29
drools-db-migration | 103 0100-jpapolicyaudit.sql downgrade 0900 0800 1907211503280900d 1 2021-07-19 15:03:29
drools-db-----migration | policyadmin: downgrade available: 0800 -> 0
drools-db-migration | 482 blocks
drools-db-migration | Preparing upgrade release version: 0800
drools-db-migration | > upgrade 610-toscanodetemplates.sqlPreparing upgrade release version: 0900
drools-db-migration | Done
drools-db-------------migration | upgrade: 0800 -> 0900
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------> upgrade 0100-jpapolicyaudit.sql
drools-db-migration |
drools -db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscanodetemplates (jpapolicyaudit (ACTION INT DEFAULT NULL NULL, PDPGROUP VARCHAR(255) NULL, PDPTYPE VARCHAR(255) NULL, TIMESTAMP datetime DEFAULT NULL NULL, USER VARCHAR(255) NULL, ID BIGINT NOT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCANODETEMPLATES JPAPOLICYAUDIT PRIMARY KEY (ID, name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0110-sequence.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1CREATE TABLE IF NOT EXISTS sequence (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38) DEFAULT NULL NULL, CONSTRAINT PK_SEQUENCE PRIMARY KEY (SEQ_NAME))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 6200120-toscanodetemplatesJpaPolicyAuditIndex_toscanodetemplatetimestamp.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0CREATE INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit(TIMESTAMP)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------policyadmin: OK: upgrade (0900)
drools-db-migration | CREATE TABLE IF NOT EXISTS toscanodetemplates_toscanodetemplate (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCANODETEMPLATES_TOSCANODETEMPLATE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------policyadmin 0900
drools-db-migration | ID script operation from_version to_version tag success atTime
drools-db-migration | 1 0100-jpapdpgroup_properties.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:20
drools-db-migration | SET FOREIGN_KEY_CHECKS = 12 0110-jpapdpstatistics_enginestats.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 3 0120-jpapdpsubgroup_policies.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:20
drools-db-migration |
drools-db-migration |4 0130-jpapdpsubgroup_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | > upgrade 630-toscanodetype.sql5 0140-jpapdpsubgroup_supportedpolicytypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 6 0150-jpatoscacapabilityassignment_attributes.sql upgrade 0 0800 1907211503200800u 2021-------------07-19 15:03:20
drools-db-migration | SET FOREIGN_KEY_CHECKS = 07 0160-jpatoscacapabilityassignment_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 8 0170-jpatoscacapabilityassignment_occurrences.sql upgrade 0 0800 1907211503200800u 2021-------------07-19 15:03:20
drools-db-migration | 9 0180-jpatoscacapabilityassignment_properties.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:20
drools-db-migration | 10 0190-jpatoscacapabilitytype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 11 0200-jpatoscacapabilitytype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 12 0210-jpatoscadatatype_constraints.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 13 0220-jpatoscadatatype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 14 0230-jpatoscadatatype_properties.sql upgrade 0 0800 1907211503200800u 1 2021---07-19 15:03:20
drools-db-migration | CREATE TABLE IF NOT EXISTS toscanodetype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, requirementsVersion VARCHAR(20) NULL, requirementsName VARCHAR(120) NULL, CONSTRAINT PK_TOSCANODETYPE PRIMARY KEY (name, version))15 0240-jpatoscanodetemplate_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 16 0250-jpatoscanodetemplate_properties.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:20
drools-db-migration |
drools-db-migration | --------------17 0260-jpatoscanodetype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | SET FOREIGN_KEY_CHECKS = 118 0270-jpatoscanodetype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | --------------19 0280-jpatoscapolicy_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration |
drools-db-migration |20 0290-jpatoscapolicy_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | > upgrade 640-toscanodetypes.sql21 0300-jpatoscapolicy_targets.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 22 0310-jpatoscapolicytype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:20
drools-db-migration | SET FOREIGN_KEY_CHECKS = 023 0320-jpatoscapolicytype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:20
drools-db-migration | 24 0330-jpatoscapolicytype_targets.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration |
drools-db-migration | --------------25 0340-jpatoscapolicytype_triggers.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 26 0350-jpatoscaproperty_constraints.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | CREATE TABLE IF NOT EXISTS toscanodetypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCANODETYPES PRIMARY KEY (name, version))27 0360-jpatoscaproperty_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 28 0370-jpatoscarelationshiptype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration | 29 0380-jpatoscarelationshiptype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | --------------30 0390-jpatoscarequirement_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | SET FOREIGN_KEY_CHECKS = 131 0400-jpatoscarequirement_occurrences.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 32 0410-jpatoscarequirement_properties.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration |
drools-db-migration |33 0420-jpatoscaservicetemplate_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | > upgrade 650-toscanodetypes_toscanodetype.sql34 0430-jpatoscatopologytemplate_inputs.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 35 0440-pdpgroup_pdpsubgroup.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-36 0450-pdpgroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 37 0460-pdppolicystatus.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 38 0470-pdp.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 39 0480-pdpstatistics.sql upgrade 0 0800 1907211503200800u 1 2021---07-19 15:03:21
drools-db-migration | 40 0490-pdpsubgroup_pdp.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 41 0500-pdpsubgroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 42 0510-toscacapabilityassignment.sql upgrade 0 0800 1907211503200800u 1 2021--------07-19 15:03:21
drools-db-migration | CREATE TABLE IF NOT EXISTS toscanodetypes_toscanodetype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCANODETYPES_TOSCANODETYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))43 0520-toscacapabilityassignments.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 44 0530-toscacapabilityassignments_toscacapabilityassignment.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration | 45 0540-toscacapabilitytype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 46 0550-toscacapabilitytypes.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration | SET FOREIGN_KEY_CHECKS = 147 0560-toscacapabilitytypes_toscacapabilitytype.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:21
drools-db-migration | 48 0570-toscadatatype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 49 0580-toscadatatypes.sql upgrade 0 0800 1907211503200800u 1 2021--------07-19 15:03:21
drools-db-migration |
drools-db-migration |50 0590-toscadatatypes_toscadatatype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | > upgrade 660-toscaparameter.sql51 0600-toscanodetemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 52 0610-toscanodetemplates.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:21
drools-db-migration | SET FOREIGN_KEY_CHECKS = 053 0620-toscanodetemplates_toscanodetemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | --------------54 0630-toscanodetype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:21
drools-db-migration | 55 0640-toscanodetypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 56 0650-toscanodetypes_toscanodetype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 57 0660-toscaparameter.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 58 0670-toscapolicies.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 59 0680-toscapolicies_toscapolicy.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 60 0690-toscapolicy.sql upgrade 0 0800 1907211503200800u 1 2021---07-19 15:03:22
drools-db-migration | CREATE TABLE IF NOT EXISTS toscaparameter (VALUE VARCHAR(255) NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAPARAMETER PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))61 0700-toscapolicytype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 62 0710-toscapolicytypes.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:22
drools-db-migration |
drools-db-migration | --------------63 0720-toscapolicytypes_toscapolicytype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | SET FOREIGN_KEY_CHECKS = 164 0730-toscaproperty.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | --------------65 0740-toscarelationshiptype.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 66 0750-toscarelationshiptypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration |
drools-db-migration |67 0760-toscarelationshiptypes_toscarelationshiptype.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:22
drools-db-migration | > upgrade 670-toscapolicies.sql68 0770-toscarequirement.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 69 0780-toscarequirements.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:22
drools-db-migration | SET FOREIGN_KEY_CHECKS = 070 0790-toscarequirements_toscarequirement.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 71 0800-toscaservicetemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 72 0810-toscatopologytemplate.sql upgrade 0 0800 1907211503200800u 1 2021--------07-19 15:03:22
drools-db-migration | 73 0820-toscatrigger.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 74 0830-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:22
drools-db-migration | CREATE TABLE IF NOT EXISTS toscapolicies (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAPOLICIES PRIMARY KEY (name, version))75 0840-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 76 0850-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:22
drools-db-migration |
drools-db-migration | --------------77 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:22
drools-db-migration | 78 0870-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | SET FOREIGN_KEY_CHECKS = 179 0880-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:22
drools-db-migration | 80 0890-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 1907211503200800u 2021-------------07-19 15:03:22
drools-db-migration |
drools-db-migration |81 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:23
drools-db-migration | > upgrade 680-toscapolicies_toscapolicy.sql82 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:23
drools-db-migration | --------------83 0920-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 84 0930-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | SET FOREIGN_KEY_CHECKS = 085 0940-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 86 0950-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-------------07-19 15:03:23
drools-db-migration | 87 0960-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 88 0970-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 1907211503200800u 2021-------------07-19 15:03:23
drools-db-migration | CREATE TABLE IF NOT EXISTS toscapolicies_toscapolicy (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAPOLICIES_TOSCAPOLICY PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))89 0980-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 90 0990-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 91 1000-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 1907211503200800u 2021--------07-19 15:03:23
drools-db-migration | 92 1010-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:23
drools-db-migration | --------------93 1020-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 1907211503200800u 2021-07-19 15:03:23
drools-db-migration | SET FOREIGN_KEY_CHECKS = 194 1030-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 95 1040-IDX_TSIDX1.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 96 1050-PdpPolicyStatus_PdpGroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-19 15:03:23
drools-db-migration | 97 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1907211503200800u 1 2021---07-19 15:03:23
drools-db-migration |
drools-db-migration |98 0100-jpapolicyaudit.sql upgrade 0800 0900 1907211503200900u 1 2021-07-19 15:03:23
drools-db-migration | > upgrade 690-toscapolicy.sql99 0110-sequence.sql upgrade 0800 0900 1907211503200900u 1 2021-07-19 15:03:23
drools-db-migration | --------------100 0120-JpaPolicyAuditIndex_timestamp.sql upgrade 0800 0900 1907211503200900u 1 2021-07-19 15:03:23
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0101 0120-JpaPolicyAuditIndex_timestamp.sql downgrade 0900 0800 1907211503280900d 1 2021-07-19 15:03:28
drools-db-migration | 102 0110-sequence.sql downgrade 0900 0800 1907211503280900d 1 2021-07-19 15:03:29
drools-db-migration | 103 0100-jpapolicyaudit.sql downgrade 0900 0800 1907211503280900d 1 2021-07-19 15:03:29
drools-db-migration | 104 0100-jpapolicyaudit.sql upgrade 0800 0900 1907211504240900u 1 2021---07-19 15:04:24
drools-db-migration | 105 0110-sequence.sql upgrade 0800 0900 1907211504240900u 1 2021-07-19 15:04:24
drools-db-migration | 106 0120-JpaPolicyAuditIndex_timestamp.sql upgrade 0800 0900 1907211504240900u 1 2021-------------07-19 15:04:24
drools-db-migration | CREATE TABLE IF NOT EXISTS toscapolicy (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, CONSTRAINT PK_TOSCAPOLICY PRIMARY KEY (name, version))
drools-db-migration | policyadmin: OK @ 0900

This a a full install from version 0 → 0900

Followed by a downgrade from 0900 → 0800

Followed by an upgrade from 0800 → 0900 


Migration Schema


MariaDB [(none)]> use migration;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [migration]> show tables;
+--------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | +
| Tables_in_migration |
+----------------------------+
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 700-toscapolicytype.sql
drools-db-migration | | db_metadata_versions |
| policyadmin_change_history |
+--------------------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | -+
2 rows in set (0.000 sec)

MariaDB [migration]> select * from db_metadata_versions;
+-------------+------
drools--db-migration |
drools-db-migration | -+
| name | version |
+-------------+---------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscapolicytype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAPOLICYTYPE PRIMARY KEY (name, version))
drools-db-migration | ---+
| policyadmin | 0900 |
+-------------+-----------
drools-db-migration |
drools-db-migration | ---+
1 row in set (0.000 sec)


MariaDB [migration]> select * from policyadmin_change_history;
+-----+-----------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 710-toscapolicytypes.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | -------+-------
drools-db-migration |
drools-db-migration | +--------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscapolicytypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAPOLICYTYPES PRIMARY KEY (name, version))
drools-db-migration | ---+------------+-----------
drools-db-migration |
drools-db-migration | ----+---------+-
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 720-toscapolicytypes_toscapolicytype.sql
drools-db-migration | -+
| ID | script | operation | from_version | to_version | tag | success | atTime |
+-----+-------------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscapolicytypes_toscapolicytype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAPOLICYTYPES_TOSCAPOLICYTYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | ----+----------
drools-db-migration |
drools-db-migration | -+--------------+--
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | ------+--------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 730-toscaproperty.sql
drools-db-migration | --+---------+---
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------+
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscaproperty (DEFAULTVALUE VARCHAR(255) NULL, `DESCRIPTION` VARCHAR(255) NULL, ENTRYSCHEMA LONGBLOB DEFAULT NULL NULL, REQUIRED BIT DEFAULT 0 NULL, STATUS INT DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAPROPERTY PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 740-toscarelationshiptype.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscarelationshiptype (`DESCRIPTION` VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCARELATIONSHIPTYPE PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 750-toscarelationshiptypes.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscarelationshiptypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCARELATIONSHIPTYPES PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 760-toscarelationshiptypes_toscarelationshiptype.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscarelationshiptypes_toscarelationshiptype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCARELATIONSHIPTYPES_TOSCARELATIONSHIPTYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 770-toscarequirement.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscarequirement (CAPABILITY VARCHAR(255) NULL, `DESCRIPTION` VARCHAR(255) NULL, NODE VARCHAR(255) NULL, RELATIONSHIP VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, CONSTRAINT PK_TOSCAREQUIREMENT PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 780-toscarequirements.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscarequirements (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAREQUIREMENTS PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 790-toscarequirements_toscarequirement.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscarequirements_toscarequirement (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCAREQUIREMENTS_TOSCAREQUIREMENT PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 800-toscaservicetemplate.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscaservicetemplate (`DESCRIPTION` VARCHAR(255) NULL, TOSCADEFINITIONSVERSION VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, capabilityTypesVersion VARCHAR(20) NULL, capabilityTypesName VARCHAR(120) NULL, dataTypesName VARCHAR(120) NULL, dataTypesVersion VARCHAR(20) NULL, nodeTypesVersion VARCHAR(20) NULL, nodeTypesName VARCHAR(120) NULL, policyTypesName VARCHAR(120) NULL, policyTypesVersion VARCHAR(20) NULL, relationshipTypesVersion VARCHAR(20) NULL, relationshipTypesName VARCHAR(120) NULL, topologyTemplateLocalName VARCHAR(120) NULL, topologyTemplateParentKeyName VARCHAR(120) NULL, topologyTemplateParentKeyVersion VARCHAR(15) NULL, topologyTemplateParentLocalName VARCHAR(120) NULL, CONSTRAINT PK_TOSCASERVICETEMPLATE PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 810-toscatopologytemplate.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscatopologytemplate (`description` VARCHAR(255) NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, nodeTemplatessVersion VARCHAR(20) NULL, nodeTemplatesName VARCHAR(120) NULL, policyVersion VARCHAR(20) NULL, policyName VARCHAR(120) NULL, CONSTRAINT PK_TOSCATOPOLOGYTEMPLATE PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 820-toscatrigger.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS toscatrigger (ACTION VARCHAR(255) NULL, toscaCondition LONGBLOB DEFAULT NULL NULL, toscaConstraint LONGBLOB DEFAULT NULL NULL, `DESCRIPTION` VARCHAR(255) NULL, EVALUATIONS INT DEFAULT NULL NULL, EVENTTYPE VARCHAR(255) NULL, METHOD VARCHAR(255) NULL, `PERIOD` LONGBLOB DEFAULT NULL NULL, SCHEDULE LONGBLOB DEFAULT NULL NULL, TARGETFILTER LONGBLOB DEFAULT NULL NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, CONSTRAINT PK_TOSCATRIGGER PRIMARY KEY (parentLocalName, localName, parentKeyVersion, parentKeyName))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 830-FK_ToscaNodeTemplate_capabilitiesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscanodetemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES toscacapabilityassignments (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 840-FK_ToscaNodeTemplate_requirementsName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscanodetemplate ADD CONSTRAINT FK_ToscaNodeTemplate_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES toscarequirements (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 850-FK_ToscaNodeType_requirementsName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscanodetype ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES toscarequirements (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 860-FK_ToscaServiceTemplate_capabilityTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_capabilityTypesName FOREIGN KEY (capabilityTypesName, capabilityTypesVersion) REFERENCES toscacapabilitytypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 870-FK_ToscaServiceTemplate_dataTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES toscadatatypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 880-FK_ToscaServiceTemplate_nodeTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_nodeTypesName FOREIGN KEY (nodeTypesName, nodeTypesVersion) REFERENCES toscanodetypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 890-FK_ToscaServiceTemplate_policyTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_policyTypesName FOREIGN KEY (policyTypesName, policyTypesVersion) REFERENCES toscapolicytypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 900-FK_ToscaServiceTemplate_relationshipTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_relationshipTypesName FOREIGN KEY (relationshipTypesName, relationshipTypesVersion) REFERENCES toscarelationshiptypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscatopologytemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_nodeTemplatesName FOREIGN KEY (nodeTemplatesName, nodeTemplatessVersion) REFERENCES toscanodetemplates (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 920-FK_ToscaTopologyTemplate_policyName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscatopologytemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES toscapolicies (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 930-TscaServiceTemplatetopologyTemplateParentLocalName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | ALTER TABLE toscaservicetemplate ADD CONSTRAINT TscaServiceTemplatetopologyTemplateParentLocalName FOREIGN KEY (topologyTemplateParentLocalName, topologyTemplateLocalName, topologyTemplateParentKeyVersion, topologyTemplateParentKeyName) REFERENCES toscatopologytemplate (parentLocalName, localName, parentKeyVersion, parentKeyName) ON UPDATE RESTRICT ON DELETE RESTRICT
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 940-FK_ToscaNodeTemplate_capabilitiesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaNodeTemplate_capabilitiesName ON toscanodetemplate(capabilitiesName, capabilitiesVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 950-FK_ToscaNodeTemplate_requirementsName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaNodeTemplate_requirementsName ON toscanodetemplate(requirementsName, requirementsVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 960-FK_ToscaNodeType_requirementsName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaNodeType_requirementsName ON toscanodetype(requirementsName, requirementsVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 970-FK_ToscaServiceTemplate_capabilityTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaServiceTemplate_capabilityTypesName ON toscaservicetemplate(capabilityTypesName, capabilityTypesVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 980-FK_ToscaServiceTemplate_dataTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaServiceTemplate_dataTypesName ON toscaservicetemplate(dataTypesName, dataTypesVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 990-FK_ToscaServiceTemplate_nodeTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaServiceTemplate_nodeTypesName ON toscaservicetemplate(nodeTypesName, nodeTypesVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1000-FK_ToscaServiceTemplate_policyTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaServiceTemplate_policyTypesName ON toscaservicetemplate(policyTypesName, policyTypesVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1010-FK_ToscaServiceTemplate_relationshipTypesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaServiceTemplate_relationshipTypesName ON toscaservicetemplate(relationshipTypesName, relationshipTypesVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1020-FK_ToscaTopologyTemplate_nodeTemplatesName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaTopologyTemplate_nodeTemplatesName ON toscatopologytemplate(nodeTemplatesName, nodeTemplatessVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1030-FK_ToscaTopologyTemplate_policyName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX FK_ToscaTopologyTemplate_policyName ON toscatopologytemplate(policyName, policyVersion)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1040-IDX_TSIDX1.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX IDX_TSIDX1 ON pdpstatistics(TIMESTAMP, name, version)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1050-PdpPolicyStatus_PdpGroup.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX PdpPolicyStatus_PdpGroup ON pdppolicystatus(PDPGROUP)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX TscaServiceTemplatetopologyTemplateParentLocalName ON toscaservicetemplate(topologyTemplateParentLocalName, topologyTemplateLocalName, topologyTemplateParentKeyVersion, topologyTemplateParentKeyName)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 100-jpapolicyaudit.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpapolicyaudit (ACTION INT DEFAULT NULL NULL, PDPGROUP VARCHAR(255) NULL, PDPTYPE VARCHAR(255) NULL, TIMESTAMP datetime DEFAULT NULL NULL, USER VARCHAR(255) NULL, ID BIGINT NOT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_JPAPOLICYAUDIT PRIMARY KEY (ID, name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 110-sequence.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS sequence (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38) DEFAULT NULL NULL, CONSTRAINT PK_SEQUENCE PRIMARY KEY (SEQ_NAME))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 120-JpaPolicyAuditIndex_timestamp.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | CREATE INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit(TIMESTAMP)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | policyadmin: OK: upgrade (0900)
drools-db-migration | name version
drools-db-migration | policyadmin 0900
drools-db-migration | script operation success atTime
drools-db-migration | 100-jpapdpgroup_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 140-jpapdpsubgroup_supportedpolicytypes.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 150-jpatoscacapabilityassignment_attributes.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 160-jpatoscacapabilityassignment_metadata.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 170-jpatoscacapabilityassignment_occurrences.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 180-jpatoscacapabilityassignment_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 190-jpatoscacapabilitytype_metadata.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 200-jpatoscacapabilitytype_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 210-jpatoscadatatype_constraints.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 220-jpatoscadatatype_metadata.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 230-jpatoscadatatype_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 130-jpapdpsubgroup_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 240-jpatoscanodetemplate_metadata.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 120-jpapdpsubgroup_policies.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 110-jpapdpstatistics_enginestats.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 450-pdpgroup.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 440-pdpgroup_pdpsubgroup.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 430-jpatoscatopologytemplate_inputs.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 420-jpatoscaservicetemplate_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 410-jpatoscarequirement_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 400-jpatoscarequirement_occurrences.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 390-jpatoscarequirement_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 380-jpatoscarelationshiptype_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 370-jpatoscarelationshiptype_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 460-pdppolicystatus.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 470-pdp.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 480-pdpstatistics.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 490-pdpsubgroup_pdp.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 500-pdpsubgroup.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 510-toscacapabilityassignment.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 520-toscacapabilityassignments.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 530-toscacapabilityassignments_toscacapabilityassignment.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 540-toscacapabilitytype.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 550-toscacapabilitytypes.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 560-toscacapabilitytypes_toscacapabilitytype.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 360-jpatoscaproperty_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 350-jpatoscaproperty_constraints.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 250-jpatoscanodetemplate_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 260-jpatoscanodetype_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 270-jpatoscanodetype_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 280-jpatoscapolicy_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 290-jpatoscapolicy_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 300-jpatoscapolicy_targets.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 310-jpatoscapolicytype_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 320-jpatoscapolicytype_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 330-jpatoscapolicytype_targets.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 340-jpatoscapolicytype_triggers.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 770-toscarequirement.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 760-toscarelationshiptypes_toscarelationshiptype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 750-toscarelationshiptypes.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 740-toscarelationshiptype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 730-toscaproperty.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 720-toscapolicytypes_toscapolicytype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 710-toscapolicytypes.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 700-toscapolicytype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 690-toscapolicy.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 780-toscarequirements.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 790-toscarequirements_toscarequirement.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 880-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 870-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 860-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 850-FK_ToscaNodeType_requirementsName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 840-FK_ToscaNodeTemplate_requirementsName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 830-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 820-toscatrigger.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 810-toscatopologytemplate.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 800-toscaservicetemplate.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 680-toscapolicies_toscapolicy.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 670-toscapolicies.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 570-toscadatatype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 580-toscadatatypes.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 590-toscadatatypes_toscadatatype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 600-toscanodetemplate.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 610-toscanodetemplates.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 620-toscanodetemplates_toscanodetemplate.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 630-toscanodetype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 640-toscanodetypes.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 650-toscanodetypes_toscanodetype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 660-toscaparameter.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 900-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 920-FK_ToscaTopologyTemplate_policyName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 930-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 940-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 950-FK_ToscaNodeTemplate_requirementsName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 960-FK_ToscaNodeType_requirementsName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 970-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 980-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 890-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 120-JpaPolicyAuditIndex_timestamp.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 100-jpapolicyaudit.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1000-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1010-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1020-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1030-FK_ToscaTopologyTemplate_policyName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1040-IDX_TSIDX1.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1050-PdpPolicyStatus_PdpGroup.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 110-sequence.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 990-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | policyadmin: OK @ 0900
drools-db-migration | Preparing downgrade version: 0800
drools-db-migration | Preparing downgrade version: 0900
drools-db-migration | Done
drools-db-migration | downgrade: 0900 -> 0800
drools-db-migration |
drools-db-migration | > downgrade 120-JpaPolicyAuditIndex_timestamp.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > downgrade 110-sequence.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `sequence`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > downgrade 100-jpapolicyaudit.sql
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | DROP TABLE IF EXISTS `jpapolicyaudit`
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | --------------
drools-db-migration | SET FOREIGN_KEY_CHECKS = 1
drools-db-migration | --------------
drools-db-migration |
drools-db-migration | policyadmin: OK: downgrade (0800)
drools-db-migration | name version
drools-db-migration | policyadmin 0800
drools-db-migration | script operation success atTime
drools-db-migration | 100-jpapdpgroup_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 140-jpapdpsubgroup_supportedpolicytypes.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 150-jpatoscacapabilityassignment_attributes.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 160-jpatoscacapabilityassignment_metadata.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 170-jpatoscacapabilityassignment_occurrences.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 180-jpatoscacapabilityassignment_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 190-jpatoscacapabilitytype_metadata.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 200-jpatoscacapabilitytype_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 210-jpatoscadatatype_constraints.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 220-jpatoscadatatype_metadata.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 230-jpatoscadatatype_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 130-jpapdpsubgroup_properties.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 240-jpatoscanodetemplate_metadata.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 120-jpapdpsubgroup_policies.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 110-jpapdpstatistics_enginestats.sql upgrade 1 2021-07-08 14:50:11
drools-db-migration | 450-pdpgroup.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 440-pdpgroup_pdpsubgroup.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 430-jpatoscatopologytemplate_inputs.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 420-jpatoscaservicetemplate_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 410-jpatoscarequirement_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 400-jpatoscarequirement_occurrences.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 390-jpatoscarequirement_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 380-jpatoscarelationshiptype_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 370-jpatoscarelationshiptype_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 460-pdppolicystatus.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 470-pdp.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 480-pdpstatistics.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 490-pdpsubgroup_pdp.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 500-pdpsubgroup.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 510-toscacapabilityassignment.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 520-toscacapabilityassignments.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 530-toscacapabilityassignments_toscacapabilityassignment.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 540-toscacapabilitytype.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 550-toscacapabilitytypes.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 560-toscacapabilitytypes_toscacapabilitytype.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 360-jpatoscaproperty_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 350-jpatoscaproperty_constraints.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 250-jpatoscanodetemplate_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 260-jpatoscanodetype_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 270-jpatoscanodetype_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 280-jpatoscapolicy_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 290-jpatoscapolicy_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 300-jpatoscapolicy_targets.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 310-jpatoscapolicytype_metadata.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 320-jpatoscapolicytype_properties.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 330-jpatoscapolicytype_targets.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 340-jpatoscapolicytype_triggers.sql upgrade 1 2021-07-08 14:50:12
drools-db-migration | 770-toscarequirement.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 760-toscarelationshiptypes_toscarelationshiptype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 750-toscarelationshiptypes.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 740-toscarelationshiptype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 730-toscaproperty.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 720-toscapolicytypes_toscapolicytype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 710-toscapolicytypes.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 700-toscapolicytype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 690-toscapolicy.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 780-toscarequirements.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 790-toscarequirements_toscarequirement.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 880-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 870-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 860-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 850-FK_ToscaNodeType_requirementsName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 840-FK_ToscaNodeTemplate_requirementsName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 830-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 820-toscatrigger.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 810-toscatopologytemplate.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 800-toscaservicetemplate.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 680-toscapolicies_toscapolicy.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 670-toscapolicies.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 570-toscadatatype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 580-toscadatatypes.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 590-toscadatatypes_toscadatatype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 600-toscanodetemplate.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 610-toscanodetemplates.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 620-toscanodetemplates_toscanodetemplate.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 630-toscanodetype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 640-toscanodetypes.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 650-toscanodetypes_toscanodetype.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 660-toscaparameter.sql upgrade 1 2021-07-08 14:50:13
drools-db-migration | 900-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 920-FK_ToscaTopologyTemplate_policyName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 930-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 940-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 950-FK_ToscaNodeTemplate_requirementsName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 960-FK_ToscaNodeType_requirementsName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 970-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 980-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 890-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 990-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1000-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1010-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1020-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1030-FK_ToscaTopologyTemplate_policyName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1040-IDX_TSIDX1.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1050-PdpPolicyStatus_PdpGroup.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 1 2021-07-08 14:50:14
drools-db-migration | 110-sequence.sql downgrade 1 2021-07-08 14:50:20
drools-db-migration | 100-jpapolicyaudit.sql downgrade 1 2021-07-08 14:50:20
drools-db-migration | 120-JpaPolicyAuditIndex_timestamp.sql downgrade 1 2021-07-08 14:50:20
drools-db-migration | policyadmin: downgrade available: 0800 -> 0| 1 | 0100-jpapdpgroup_properties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 2 | 0110-jpapdpstatistics_enginestats.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 3 | 0120-jpapdpsubgroup_policies.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 4 | 0130-jpapdpsubgroup_properties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 5 | 0140-jpapdpsubgroup_supportedpolicytypes.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 6 | 0150-jpatoscacapabilityassignment_attributes.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 7 | 0160-jpatoscacapabilityassignment_metadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 8 | 0170-jpatoscacapabilityassignment_occurrences.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 9 | 0180-jpatoscacapabilityassignment_properties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 10 | 0190-jpatoscacapabilitytype_metadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 11 | 0200-jpatoscacapabilitytype_properties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 12 | 0210-jpatoscadatatype_constraints.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 13 | 0220-jpatoscadatatype_metadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 14 | 0230-jpatoscadatatype_properties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 15 | 0240-jpatoscanodetemplate_metadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 16 | 0250-jpatoscanodetemplate_properties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 17 | 0260-jpatoscanodetype_metadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 18 | 0270-jpatoscanodetype_properties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 19 | 0280-jpatoscapolicy_metadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 20 | 0290-jpatoscapolicy_properties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 21 | 0300-jpatoscapolicy_targets.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 22 | 0310-jpatoscapolicytype_metadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 23 | 0320-jpatoscapolicytype_properties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:20 |
| 24 | 0330-jpatoscapolicytype_targets.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 25 | 0340-jpatoscapolicytype_triggers.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 26 | 0350-jpatoscaproperty_constraints.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 27 | 0360-jpatoscaproperty_metadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 28 | 0370-jpatoscarelationshiptype_metadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 29 | 0380-jpatoscarelationshiptype_properties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 30 | 0390-jpatoscarequirement_metadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 31 | 0400-jpatoscarequirement_occurrences.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 32 | 0410-jpatoscarequirement_properties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 33 | 0420-jpatoscaservicetemplate_metadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 34 | 0430-jpatoscatopologytemplate_inputs.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 35 | 0440-pdpgroup_pdpsubgroup.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 36 | 0450-pdpgroup.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 37 | 0460-pdppolicystatus.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 38 | 0470-pdp.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 39 | 0480-pdpstatistics.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 40 | 0490-pdpsubgroup_pdp.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 41 | 0500-pdpsubgroup.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 42 | 0510-toscacapabilityassignment.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 43 | 0520-toscacapabilityassignments.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 44 | 0530-toscacapabilityassignments_toscacapabilityassignment.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 45 | 0540-toscacapabilitytype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 46 | 0550-toscacapabilitytypes.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 47 | 0560-toscacapabilitytypes_toscacapabilitytype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 48 | 0570-toscadatatype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 49 | 0580-toscadatatypes.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 50 | 0590-toscadatatypes_toscadatatype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 51 | 0600-toscanodetemplate.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 52 | 0610-toscanodetemplates.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 53 | 0620-toscanodetemplates_toscanodetemplate.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 54 | 0630-toscanodetype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:21 |
| 55 | 0640-toscanodetypes.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 56 | 0650-toscanodetypes_toscanodetype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 57 | 0660-toscaparameter.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 58 | 0670-toscapolicies.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 59 | 0680-toscapolicies_toscapolicy.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 60 | 0690-toscapolicy.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 61 | 0700-toscapolicytype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 62 | 0710-toscapolicytypes.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 63 | 0720-toscapolicytypes_toscapolicytype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 64 | 0730-toscaproperty.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 65 | 0740-toscarelationshiptype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 66 | 0750-toscarelationshiptypes.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 67 | 0760-toscarelationshiptypes_toscarelationshiptype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 68 | 0770-toscarequirement.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 69 | 0780-toscarequirements.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 70 | 0790-toscarequirements_toscarequirement.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 71 | 0800-toscaservicetemplate.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 72 | 0810-toscatopologytemplate.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 73 | 0820-toscatrigger.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 74 | 0830-FK_ToscaNodeTemplate_capabilitiesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 75 | 0840-FK_ToscaNodeTemplate_requirementsName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 76 | 0850-FK_ToscaNodeType_requirementsName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 77 | 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 78 | 0870-FK_ToscaServiceTemplate_dataTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 79 | 0880-FK_ToscaServiceTemplate_nodeTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 80 | 0890-FK_ToscaServiceTemplate_policyTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:22 |
| 81 | 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:23 |
| 82 | 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:23 |
| 83 | 0920-FK_ToscaTopologyTemplate_policyName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:23 |
| 84 | 0930-TscaServiceTemplatetopologyTemplateParentLocalName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:23 |
| 85 | 0940-FK_ToscaNodeTemplate_capabilitiesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:23 |
| 86 | 0950-FK_ToscaNodeTemplate_requirementsName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:23 |
| 87 | 0960-FK_ToscaNodeType_requirementsName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:23 |
| 88 | 0970-FK_ToscaServiceTemplate_capabilityTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:23 |
| 89 | 0980-FK_ToscaServiceTemplate_dataTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:23 |
| 90 | 0990-FK_ToscaServiceTemplate_nodeTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:23 |
| 91 | 1000-FK_ToscaServiceTemplate_policyTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:23 |
| 92 | 1010-FK_ToscaServiceTemplate_relationshipTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:23 |
| 93 | 1020-FK_ToscaTopologyTemplate_nodeTemplatesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:23 |
| 94 | 1030-FK_ToscaTopologyTemplate_policyName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:23 |
| 95 | 1040-IDX_TSIDX1.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:23 |
| 96 | 1050-PdpPolicyStatus_PdpGroup.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:23 |
| 97 | 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-19 15:03:23 |
| 98 | 0100-jpapolicyaudit.sql | upgrade | 0800 | 0900 | 1907211503200900u | 1 | 2021-07-19 15:03:23 |
| 99 | 0110-sequence.sql | upgrade | 0800 | 0900 | 1907211503200900u | 1 | 2021-07-19 15:03:23 |
| 100 | 0120-JpaPolicyAuditIndex_timestamp.sql | upgrade | 0800 | 0900 | 1907211503200900u | 1 | 2021-07-19 15:03:23 |
| 101 | 0120-JpaPolicyAuditIndex_timestamp.sql | downgrade | 0900 | 0800 | 1907211503280900d | 1 | 2021-07-19 15:03:28 |
| 102 | 0110-sequence.sql | downgrade | 0900 | 0800 | 1907211503280900d | 1 | 2021-07-19 15:03:29 |
| 103 | 0100-jpapolicyaudit.sql | downgrade | 0900 | 0800 | 1907211503280900d | 1 | 2021-07-19 15:03:29 |
| 104 | 0100-jpapolicyaudit.sql | upgrade | 0800 | 0900 | 1907211504240900u | 1 | 2021-07-19 15:04:24 |
| 105 | 0110-sequence.sql | upgrade | 0800 | 0900 | 1907211504240900u | 1 | 2021-07-19 15:04:24 |
| 106 | 0120-JpaPolicyAuditIndex_timestamp.sql | upgrade | 0800 | 0900 | 1907211504240900u | 1 | 2021-07-19 15:04:24 |
+-----+---------------------------------------------------------------+-----------+--------------+------------+-------------------+---------+---------------------+
106 rows in set (0.001 sec)