...
Sample Output
drools-db-migration | .Connection to mariadb 3306 port [tcp/mysql] succeeded!
mariadb | 2021-07-13 8:53:32 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '172.22.0.3' (This connection closed normally without authentication)
drools-db-migration | 260 blocks
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 0100-jpapdpgroup_properties.sql
drools-db-migration | --------------
drools-db-migration | CREATE 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 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(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 | CREATE 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 0130-jpapdpsubgroup_properties.sql
drools-db-migration | --------------
drools-db-migration | CREATE 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 jpapdpsubgroup_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 | CREATE 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 0160-jpatoscacapabilityassignment_metadata.sql
drools-db-migration | --------------
drools-db-migration | CREATE 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 jpatoscacapabilityassignment_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 0180-jpatoscacapabilityassignment_properties.sql
drools-db-migration | --------------
drools-db-migration | CREATE 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 0190-jpatoscacapabilitytype_metadata.sql
drools-db-migration | --------------
drools-db-migration | CREATE 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 jpatoscacapabilitytype_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 0210-jpatoscadatatype_constraints.sql
drools-db-migration | --------------
drools-db-migration | CREATE 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 0220-jpatoscadatatype_metadata.sql
drools-db-migration | --------------
drools-db-migration | CREATE 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-migration | CREATE TABLE IF NOT EXISTS jpatoscadatatype_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 0240-jpatoscanodetemplate_metadata.sql
drools-db-migration | --------------
drools-db-migration | CREATE 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 |
drools-db-migration |
drools-db-migration | > upgrade 0250-jpatoscanodetemplate_properties.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscanodetemplate_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 0260-jpatoscanodetype_metadata.sql
drools-db-migration | --------------
drools-db-migration | CREATE 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 0270-jpatoscanodetype_properties.sql
drools-db-migration | --------------
drools-db-migration | CREATE 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 jpatoscapolicy_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 0290-jpatoscapolicy_properties.sql
drools-db-migration | --------------
drools-db-migration | CREATE 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 |
drools-db-migration |
drools-db-migration | > upgrade 0300-jpatoscapolicy_targets.sql
drools-db-migration | --------------
drools-db-migration | CREATE TABLE IF NOT EXISTS jpatoscapolicy_targets (name VARCHAR(120) NULL, version VARCHAR(20) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0310-jpatoscapolicytype_metadata.sql
drools-db-migration | --------------
drools-db-migration | CREATE 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 0320-jpatoscapolicytype_properties.sql
drools-db-migration | --------------
drools-db-migration | CREATE 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 jpatoscapolicytype_targets (name VARCHAR(120) NULL, version VARCHAR(20) NULL)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0340-jpatoscapolicytype_triggers.sql
drools-db-migration | --------------
drools-db-migration | CREATE 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 0350-jpatoscaproperty_constraints.sql
drools-db-migration | --------------
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 jpatoscaproperty_metadata (parentLocalName VARCHAR(120) NULL, localName VARCHAR(120) NULL, parentKeyVersion VARCHAR(15) NULL, parentKeyName VARCHAR(120) 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 | CREATE 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 0380-jpatoscarelationshiptype_properties.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)
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 jpatoscarequirement_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 0400-jpatoscarequirement_occurrences.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)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0410-jpatoscarequirement_properties.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) 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 jpatoscaservicetemplate_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 0430-jpatoscatopologytemplate_inputs.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)
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0440-pdpgroup_pdpsubgroup.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 | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0450-pdpgroup.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))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0460-pdppolicystatus.sql
drools-db-migration | --------------
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 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))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0480-pdpstatistics.sql
drools-db-migration | --------------
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))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0490-pdpsubgroup_pdp.sql
drools-db-migration | --------------
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 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))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0510-toscacapabilityassignment.sql
drools-db-migration | --------------
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))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0520-toscacapabilityassignments.sql
drools-db-migration | --------------
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))
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 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))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0540-toscacapabilitytype.sql
drools-db-migration | --------------
drools-db-migration | CREATE 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 0550-toscacapabilitytypes.sql
drools-db-migration | --------------
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))
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 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))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0570-toscadatatype.sql
drools-db-migration | --------------
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))
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 toscadatatypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCADATATYPES PRIMARY KEY (name, version))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0590-toscadatatypes_toscadatatype.sql
drools-db-migration | --------------
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))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0600-toscanodetemplate.sql
drools-db-migration | --------------
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))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0610-toscanodetemplates.sql
drools-db-migration | --------------
drools-db-migration | CREATE 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 0620-toscanodetemplates_toscanodetemplate.sql
drools-db-migration | --------------
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 | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0630-toscanodetype.sql
drools-db-migration | --------------
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))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0640-toscanodetypes.sql
drools-db-migration | --------------
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))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0650-toscanodetypes_toscanodetype.sql
drools-db-migration | --------------
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))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0660-toscaparameter.sql
drools-db-migration | --------------
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))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0670-toscapolicies.sql
drools-db-migration | --------------
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))
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 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))
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0690-toscapolicy.sql
drools-db-migration | --------------
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 | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0700-toscapolicytype.sql
drools-db-migration | --------------
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 | --------------
drools-db-migration |
drools-db-migration |
drools-db-migration | > upgrade 0710-toscapolicytypes.sql
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 | > upgrade 0720-toscapolicytypes_toscapolicytype.sql
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 | > upgrade 0730-toscaproperty.sql
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 | > upgrade 0740-toscarelationshiptype.sql
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 | > upgrade 0750-toscarelationshiptypes.sql
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 | > upgrade 0760-toscarelationshiptypes_toscarelationshiptype.sql
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 | > upgrade 0770-toscarequirement.sql
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 | > upgrade 0780-toscarequirements.sql
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 | > upgrade 0790-toscarequirements_toscarequirement.sql
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 | > upgrade 0800-toscaservicetemplate.sql
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 | > upgrade 0810-toscatopologytemplate.sql
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 | > upgrade 0820-toscatrigger.sql
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 | > upgrade 0830-FK_ToscaNodeTemplate_capabilitiesName.sql
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 | > upgrade 0840-FK_ToscaNodeTemplate_requirementsName.sql
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 | > upgrade 0850-FK_ToscaNodeType_requirementsName.sql
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 | > upgrade 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql
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 | > upgrade 0870-FK_ToscaServiceTemplate_dataTypesName.sql
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 | > upgrade 0880-FK_ToscaServiceTemplate_nodeTypesName.sql
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 | > upgrade 0890-FK_ToscaServiceTemplate_policyTypesName.sql
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 | > upgrade 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql
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 | > upgrade 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql
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 | > upgrade 0920-FK_ToscaTopologyTemplate_policyName.sql
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 | > upgrade 0930-TscaServiceTemplatetopologyTemplateParentLocalName.sql
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 | > upgrade 0940-FK_ToscaNodeTemplate_capabilitiesName.sql
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 | > upgrade 0950-FK_ToscaNodeTemplate_requirementsName.sql
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 | > upgrade 0960-FK_ToscaNodeType_requirementsName.sql
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 | > upgrade 0970-FK_ToscaServiceTemplate_capabilityTypesName.sql
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 | > upgrade 0980-FK_ToscaServiceTemplate_dataTypesName.sql
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 | > upgrade 0990-FK_ToscaServiceTemplate_nodeTypesName.sql
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 | > upgrade 1000-FK_ToscaServiceTemplate_policyTypesName.sql
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 | > upgrade 1010-FK_ToscaServiceTemplate_relationshipTypesName.sql
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 | > upgrade 1020-FK_ToscaTopologyTemplate_nodeTemplatesName.sql
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 | > upgrade 1030-FK_ToscaTopologyTemplate_policyName.sql
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 | > upgrade 1040-IDX_TSIDX1.sql
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 | > upgrade 1050-PdpPolicyStatus_PdpGroup.sql
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 | > upgrade 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql
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 | > upgrade 0100-jpapolicyaudit.sql
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 | > upgrade 0110-sequence.sql
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 | > upgrade 0120-JpaPolicyAuditIndex_timestamp.sql
drools-db-migration | --------------
drools-db-migration | CREATE INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit(TIMESTAMP)
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 | ID script operation from_version to_version tag success atTime
drools-db-migration | 04201 0100-jpatoscaservicetemplatejpapdpgroup_metadataproperties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 02802 0110-jpatoscapolicyjpapdpstatistics_metadataenginestats.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 02903 0120-jpatoscapolicyjpapdpsubgroup_propertiespolicies.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 03004 0130-jpatoscapolicyjpapdpsubgroup_targetsproperties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 03105 0140-jpatoscapolicytypejpapdpsubgroup_metadatasupportedpolicytypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 03206 0150-jpatoscapolicytypejpatoscacapabilityassignment_propertiesattributes.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3320
drools-db-migration | 03307 0160-jpatoscapolicytypejpatoscacapabilityassignment_targetsmetadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 03408 0170-jpatoscapolicytypejpatoscacapabilityassignment_triggersoccurrences.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3320
drools-db-migration | 03509 0180-jpatoscapropertyjpatoscacapabilityassignment_constraintsproperties.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3320
drools-db-migration | 036010 0190-jpatoscapropertyjpatoscacapabilitytype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 037011 0200-jpatoscarelationshiptypejpatoscacapabilitytype_metadataproperties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 038012 0210-jpatoscarelationshiptypejpatoscadatatype_propertiesconstraints.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 039013 0220-jpatoscarequirementjpatoscadatatype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 040014 0230-jpatoscarequirementjpatoscadatatype_occurrencesproperties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 041015 0240-jpatoscarequirementjpatoscanodetemplate_propertiesmetadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 027016 0250-jpatoscanodetypejpatoscanodetemplate_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 17 0260-jpatoscanodetype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 025018 0270-jpatoscanodetemplatejpatoscanodetype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 010019 0280-jpapdpgroupjpatoscapolicy_propertiesmetadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 011020 0290-jpapdpstatisticsjpatoscapolicy_enginestatsproperties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 012021 0300-jpapdpsubgroupjpatoscapolicy_policiestargets.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 013022 0310-jpapdpsubgroupjpatoscapolicytype_propertiesmetadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 014023 0320-jpapdpsubgroupjpatoscapolicytype_supportedpolicytypesproperties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 015024 0330-jpatoscacapabilityassignmentjpatoscapolicytype_attributestargets.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 016025 0340-jpatoscacapabilityassignmentjpatoscapolicytype_metadatatriggers.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 017026 0350-jpatoscacapabilityassignmentjpatoscaproperty_occurrencesconstraints.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 018027 0360-jpatoscacapabilityassignmentjpatoscaproperty_propertiesmetadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 024028 0370-jpatoscanodetemplatejpatoscarelationshiptype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 023029 0380-jpatoscadatatypejpatoscarelationshiptype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 022030 0390-jpatoscadatatypejpatoscarequirement_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 021031 0400-jpatoscadatatypejpatoscarequirement_constraintsoccurrences.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 020032 0410-jpatoscacapabilitytypejpatoscarequirement_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 019033 0420-jpatoscacapabilitytypejpatoscaservicetemplate_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 065034 0430-toscanodetypesjpatoscatopologytemplate_toscanodetypeinputs.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0640-toscanodetypes35 0440-pdpgroup_pdpsubgroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 063036 0450-toscanodetypepdpgroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0620-toscanodetemplates_toscanodetemplate37 0460-pdppolicystatus.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 061038 0470-toscanodetemplatespdp.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 060039 0480-toscanodetemplatepdpstatistics.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0660-toscaparameter40 0490-pdpsubgroup_pdp.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 067041 0500-toscapoliciespdpsubgroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0680-toscapolicies_toscapolicy42 0510-toscacapabilityassignment.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 069043 0520-toscapolicytoscacapabilityassignments.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0700-toscapolicytype44 0530-toscacapabilityassignments_toscacapabilityassignment.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 071045 0540-toscapolicytypestoscacapabilitytype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0720-toscapolicytypes_toscapolicytype46 0550-toscacapabilitytypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0730-toscaproperty47 0560-toscacapabilitytypes_toscacapabilitytype.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3421
drools-db-migration | 074048 0570-toscarelationshiptypetoscadatatype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 059049 0580-toscadatatypes_toscadatatype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 058050 0590-toscadatatypes_toscadatatype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0430-jpatoscatopologytemplate_inputs51 0600-toscanodetemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0440-pdpgroup_pdpsubgroup52 0610-toscanodetemplates.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0450-pdpgroup53 0620-toscanodetemplates_toscanodetemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 046054 0630-pdppolicystatustoscanodetype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 047055 0640-pdptoscanodetypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 0480-pdpstatistics56 0650-toscanodetypes_toscanodetype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 0490-pdpsubgroup_pdp57 0660-toscaparameter.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 050058 0670-pdpsubgrouptoscapolicies.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 0510-toscacapabilityassignment59 0680-toscapolicies_toscapolicy.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 057060 0690-toscadatatypetoscapolicy.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 0560-toscacapabilitytypes_toscacapabilitytype61 0700-toscapolicytype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 055062 0710-toscacapabilitytypestoscapolicytypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 0540-toscacapabilitytype63 0720-toscapolicytypes_toscapolicytype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 0530-toscacapabilityassignments_toscacapabilityassignment64 0730-toscaproperty.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 052065 0740-toscacapabilityassignmentstoscarelationshiptype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 0880-FK_ToscaServiceTemplate_nodeTypesName66 0750-toscarelationshiptypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 089067 0760-FKtoscarelationshiptypes_ToscaServiceTemplate_policyTypesNametoscarelationshiptype.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3522
drools-db-migration | 0900-FK_ToscaServiceTemplate_relationshipTypesName68 0770-toscarequirement.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 0910-FK_ToscaTopologyTemplate_nodeTemplatesName69 0780-toscarequirements.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 092070 0790-FKtoscarequirements_ToscaTopologyTemplate_policyNametoscarequirement.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 093071 0800-TscaServiceTemplatetopologyTemplateParentLocalNametoscaservicetemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 0940-FK_ToscaNodeTemplate_capabilitiesName72 0810-toscatopologytemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 0950-FK_ToscaNodeTemplate_requirementsName73 0820-toscatrigger.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 096074 0830-FK_ToscaNodeTypeToscaNodeTemplate_requirementsNamecapabilitiesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 097075 0840-FK_ToscaServiceTemplateToscaNodeTemplate_capabilityTypesNamerequirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 098076 0850-FK_ToscaServiceTemplateToscaNodeType_dataTypesNamerequirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 087077 0860-FK_ToscaServiceTemplate_dataTypesNamecapabilityTypesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3522
drools-db-migration | 086078 0870-FK_ToscaServiceTemplate_capabilityTypesNamedataTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 0750-toscarelationshiptypes79 0880-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 076080 0890-toscarelationshiptypesFK_toscarelationshiptypeToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3522
drools-db-migration | 0770-toscarequirement81 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3523
drools-db-migration | 0780-toscarequirements82 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3523
drools-db-migration | 0790-toscarequirements_toscarequirement83 0920-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 080084 0930-toscaservicetemplateTscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 0810-toscatopologytemplate85 0940-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 0820-toscatrigger86 0950-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 083087 0960-FK_ToscaNodeTemplateToscaNodeType_capabilitiesNamerequirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 084088 0970-FK_ToscaNodeTemplateToscaServiceTemplate_requirementsNamecapabilityTypesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3523
drools-db-migration | 085089 0980-FK_ToscaNodeTypeToscaServiceTemplate_requirementsNamedataTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 1050-PdpPolicyStatus_PdpGroup90 0990-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 1060-TscaServiceTemplatetopologyTemplateParentLocalName91 1000-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3623
drools-db-migration | 0100-jpapolicyaudit92 1010-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0900 1 0800 1907211503200800u 2021-07-13 0819 15:5303:3623
drools-db-migration | 0110-sequence93 1020-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0900 1 0800 1907211503200800u 2021-07-13 0819 15:5303:3623
drools-db-migration | 1040-IDX_TSIDX194 1030-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 103095 1040-FKIDX_ToscaTopologyTemplate_policyNameTSIDX1.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 102096 1050-FKPdpPolicyStatus_ToscaTopologyTemplate_nodeTemplatesNamePdpGroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 1010-FK_ToscaServiceTemplate_relationshipTypesName97 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 1000-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 98 0100-jpapolicyaudit.sql upgrade 0800 0900 1907211503200900u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 0990-FK_ToscaServiceTemplate_nodeTypesName99 0110-sequence.sql upgrade 0 0800 0900 1907211503200900u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 100 0120-JpaPolicyAuditIndex_timestamp.sql upgrade 0 0800 0900 1907211503200900u 1 2021-07-13 0819 15:5303:3623
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 | > downgrade 0120-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 0110-sequence.sql
drools-db-migration | --------------
drools-db-migration | DROP 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 | DROP TABLE IF EXISTS `jpapolicyaudit`
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 | ID script operation from_version to_version tag success atTime
drools-db-migration | 04201 0100-jpatoscaservicetemplatejpapdpgroup_metadataproperties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 02602 0110-jpatoscanodetypejpapdpstatistics_metadataenginestats.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 02703 0120-jpatoscanodetypejpapdpsubgroup_propertiespolicies.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 02804 0130-jpatoscapolicyjpapdpsubgroup_metadataproperties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 02905 0140-jpatoscapolicyjpapdpsubgroup_propertiessupportedpolicytypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 03006 0150-jpatoscapolicyjpatoscacapabilityassignment_targetsattributes.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3320
drools-db-migration | 03107 0160-jpatoscapolicytypejpatoscacapabilityassignment_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 03208 0170-jpatoscapolicytypejpatoscacapabilityassignment_propertiesoccurrences.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3320
drools-db-migration | 03309 0180-jpatoscapolicytypejpatoscacapabilityassignment_targetsproperties.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3320
drools-db-migration | 034010 0190-jpatoscapolicytypejpatoscacapabilitytype_triggersmetadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 035011 0200-jpatoscapropertyjpatoscacapabilitytype_constraintsproperties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 036012 0210-jpatoscapropertyjpatoscadatatype_metadataconstraints.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 037013 0220-jpatoscarelationshiptypejpatoscadatatype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 038014 0230-jpatoscarelationshiptypejpatoscadatatype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 039015 0240-jpatoscarequirementjpatoscanodetemplate_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 040016 0250-jpatoscarequirementjpatoscanodetemplate_occurrencesproperties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 041017 0260-jpatoscarequirementjpatoscanodetype_propertiesmetadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 025018 0270-jpatoscanodetemplatejpatoscanodetype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 024019 0280-jpatoscanodetemplatejpatoscapolicy_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 010020 0290-jpapdpgroupjpatoscapolicy_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 011021 0300-jpapdpstatisticsjpatoscapolicy_enginestatstargets.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 012022 0310-jpapdpsubgroupjpatoscapolicytype_policiesmetadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 013023 0320-jpapdpsubgroupjpatoscapolicytype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 014024 0330-jpapdpsubgroupjpatoscapolicytype_supportedpolicytypestargets.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 015025 0340-jpatoscacapabilityassignmentjpatoscapolicytype_attributestriggers.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 016026 0350-jpatoscacapabilityassignmentjpatoscaproperty_metadataconstraints.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 017027 0360-jpatoscacapabilityassignmentjpatoscaproperty_occurrencesmetadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 023028 0370-jpatoscadatatypejpatoscarelationshiptype_propertiesmetadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 022029 0380-jpatoscadatatypejpatoscarelationshiptype_metadataproperties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 021030 0390-jpatoscadatatypejpatoscarequirement_constraintsmetadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 018031 0400-jpatoscacapabilityassignmentjpatoscarequirement_propertiesoccurrences.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 020032 0410-jpatoscacapabilitytypejpatoscarequirement_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 019033 0420-jpatoscacapabilitytypejpatoscaservicetemplate_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 065034 0430-toscanodetypesjpatoscatopologytemplate_toscanodetypeinputs.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0640-toscanodetypes35 0440-pdpgroup_pdpsubgroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 063036 0450-toscanodetypepdpgroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0620-toscanodetemplates_toscanodetemplate37 0460-pdppolicystatus.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0590-toscadatatypes_toscadatatype38 0470-pdp.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 061039 0480-toscanodetemplatespdpstatistics.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0600-toscanodetemplate40 0490-pdpsubgroup_pdp.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 066041 0500-toscaparameterpdpsubgroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 067042 0510-toscapoliciestoscacapabilityassignment.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0680-toscapolicies_toscapolicy43 0520-toscacapabilityassignments.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0690-toscapolicy44 0530-toscacapabilityassignments_toscacapabilityassignment.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 070045 0540-toscapolicytypetoscacapabilitytype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 071046 0550-toscapolicytypestoscacapabilitytypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0740-toscarelationshiptype47 0560-toscacapabilitytypes_toscacapabilitytype.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3421
drools-db-migration | 073048 0570-toscapropertytoscadatatype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0720-toscapolicytypes_toscapolicytype49 0580-toscadatatypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 058050 0590-toscadatatypes_toscadatatype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 057051 0600-toscadatatypetoscanodetemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0560-toscacapabilitytypes_toscacapabilitytype52 0610-toscanodetemplates.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 043053 0620-jpatoscatopologytemplatetoscanodetemplates_inputstoscanodetemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0440-pdpgroup_pdpsubgroup54 0630-toscanodetype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 045055 0640-pdpgrouptoscanodetypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 0460-pdppolicystatus56 0650-toscanodetypes_toscanodetype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 047057 0660-pdptoscaparameter.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 048058 0670-pdpstatisticstoscapolicies.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 049059 0680-pdpsubgrouptoscapolicies_pdptoscapolicy.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 050060 0690-pdpsubgrouptoscapolicy.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 051061 0700-toscacapabilityassignmenttoscapolicytype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 052062 0710-toscacapabilityassignmentstoscapolicytypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 053063 0720-toscacapabilityassignmentstoscapolicytypes_toscacapabilityassignmenttoscapolicytype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 054064 0730-toscacapabilitytypetoscaproperty.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 055065 0740-toscacapabilitytypestoscarelationshiptype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 0910-FK_ToscaTopologyTemplate_nodeTemplatesName66 0750-toscarelationshiptypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 090067 0760-FKtoscarelationshiptypes_ToscaServiceTemplate_relationshipTypesNametoscarelationshiptype.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3522
drools-db-migration | 0890-FK_ToscaServiceTemplate_policyTypesName68 0770-toscarequirement.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 0880-FK_ToscaServiceTemplate_nodeTypesName69 0780-toscarequirements.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 087070 0790-FKtoscarequirements_ToscaServiceTemplate_dataTypesNametoscarequirement.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 0920-FK_ToscaTopologyTemplate_policyName71 0800-toscaservicetemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 093072 0810-TscaServiceTemplatetopologyTemplateParentLocalNametoscatopologytemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 0940-FK_ToscaNodeTemplate_capabilitiesName73 0820-toscatrigger.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 095074 0830-FK_ToscaNodeTemplate_requirementsNamecapabilitiesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 096075 0840-FK_ToscaNodeTypeToscaNodeTemplate_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 097076 0850-FK_ToscaServiceTemplateToscaNodeType_capabilityTypesNamerequirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 098077 0860-FK_ToscaServiceTemplate_dataTypesNamecapabilityTypesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3522
drools-db-migration | 086078 0870-FK_ToscaServiceTemplate_capabilityTypesNamedataTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 085079 0880-FK_ToscaNodeTypeToscaServiceTemplate_requirementsNamenodeTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 084080 0890-FK_ToscaNodeTemplateToscaServiceTemplate_requirementsNamepolicyTypesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3522
drools-db-migration | 0750-toscarelationshiptypes81 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3523
drools-db-migration | 076082 0910-toscarelationshiptypesFK_toscarelationshiptypeToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3523
drools-db-migration | 0770-toscarequirement83 0920-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 078084 0930-toscarequirementsTscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 0790-toscarequirements_toscarequirement85 0940-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 0800-toscaservicetemplate86 0950-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 0810-toscatopologytemplate87 0960-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 0820-toscatrigger88 0970-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3523
drools-db-migration | 083089 0980-FK_ToscaNodeTemplateToscaServiceTemplate_capabilitiesNamedataTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 1040-IDX_TSIDX190 0990-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 1050-PdpPolicyStatus_PdpGroup91 1000-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3623
drools-db-migration | 1060-TscaServiceTemplatetopologyTemplateParentLocalName92 1010-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3623
drools-db-migration | 0100-jpapolicyaudit93 1020-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0900 1 0800 1907211503200800u 2021-07-13 0819 15:5303:3623
drools-db-migration | 0110-sequence94 1030-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0900 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 103095 1040-FKIDX_ToscaTopologyTemplate_policyNameTSIDX1.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 102096 1050-FKPdpPolicyStatus_ToscaTopologyTemplate_nodeTemplatesNamePdpGroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 1010-FK_ToscaServiceTemplate_relationshipTypesName97 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 1000-FK_ToscaServiceTemplate_policyTypesName98 0100-jpapolicyaudit.sql upgrade 0 0800 0900 1907211503200900u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 0990-FK_ToscaServiceTemplate_nodeTypesName99 0110-sequence.sql upgrade 0 0800 0900 1907211503200900u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 100 0120-JpaPolicyAuditIndex_timestamp.sql upgrade 0 0800 0900 1907211503200900u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 0110-sequence101 0120-JpaPolicyAuditIndex_timestamp.sql downgrade 0900 0800 1907211503280900d 1 2021-07-13 0819 15:5303:4128
drools-db-migration | 0100102 0110-jpapolicyauditsequence.sql downgrade 0900 0800 1907211503280900d 1 2021-07-13 0819 15:5303:4129
drools-db-migration | 0120-JpaPolicyAuditIndex_timestamp103 0100-jpapolicyaudit.sql downgrade 0900 0800 1907211503280900d 1 2021-07-13 0819 15:5303:4129
drools-db-migration | policyadmin: downgrade available: 0800 -> 0
drools-db-migration | 260 482 blocks
drools-db-migration | Preparing upgrade release version: 0800
drools-db-migration | Preparing upgrade release version: 0900
drools-db-migration | Done
drools-db-migration | upgrade: 0800 -> 0900
drools-db-migration |
drools-db-migration | > upgrade 0100-jpapolicyaudit.sql
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 | > upgrade 0110-sequence.sql
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 | > upgrade 0120-JpaPolicyAuditIndex_timestamp.sql
drools-db-migration | --------------
drools-db-migration | CREATE INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit(TIMESTAMP)
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 | ID script operation from_version to_version tag success atTime
drools-db-migration | 04201 0100-jpatoscaservicetemplatejpapdpgroup_metadataproperties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 02602 0110-jpatoscanodetypejpapdpstatistics_metadataenginestats.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 02703 0120-jpatoscanodetypejpapdpsubgroup_propertiespolicies.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 02804 0130-jpatoscapolicyjpapdpsubgroup_metadataproperties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 02905 0140-jpatoscapolicyjpapdpsubgroup_propertiessupportedpolicytypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 03006 0150-jpatoscapolicyjpatoscacapabilityassignment_targetsattributes.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3320
drools-db-migration | 03107 0160-jpatoscapolicytypejpatoscacapabilityassignment_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 03208 0170-jpatoscapolicytypejpatoscacapabilityassignment_propertiesoccurrences.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3320
drools-db-migration | 03309 0180-jpatoscapolicytypejpatoscacapabilityassignment_targetsproperties.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3320
drools-db-migration | 034010 0190-jpatoscapolicytypejpatoscacapabilitytype_triggersmetadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 035011 0200-jpatoscapropertyjpatoscacapabilitytype_constraintsproperties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 036012 0210-jpatoscapropertyjpatoscadatatype_metadataconstraints.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 037013 0220-jpatoscarelationshiptypejpatoscadatatype_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 038014 0230-jpatoscarelationshiptypejpatoscadatatype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 039015 0240-jpatoscarequirementjpatoscanodetemplate_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 040016 0250-jpatoscarequirementjpatoscanodetemplate_occurrencesproperties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 041017 0260-jpatoscarequirementjpatoscanodetype_propertiesmetadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 025018 0270-jpatoscanodetemplatejpatoscanodetype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 024019 0280-jpatoscanodetemplatejpatoscapolicy_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 010020 0290-jpapdpgroupjpatoscapolicy_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 011021 0300-jpapdpstatisticsjpatoscapolicy_enginestatstargets.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 012022 0310-jpapdpsubgroupjpatoscapolicytype_policiesmetadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 013023 0320-jpapdpsubgroupjpatoscapolicytype_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3320
drools-db-migration | 014024 0330-jpapdpsubgroupjpatoscapolicytype_supportedpolicytypestargets.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 015025 0340-jpatoscacapabilityassignmentjpatoscapolicytype_attributestriggers.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 016026 0350-jpatoscacapabilityassignmentjpatoscaproperty_metadataconstraints.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 017027 0360-jpatoscacapabilityassignmentjpatoscaproperty_occurrencesmetadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 023028 0370-jpatoscadatatypejpatoscarelationshiptype_propertiesmetadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 022029 0380-jpatoscadatatypejpatoscarelationshiptype_metadataproperties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 021030 0390-jpatoscadatatypejpatoscarequirement_constraintsmetadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 018031 0400-jpatoscacapabilityassignmentjpatoscarequirement_propertiesoccurrences.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 020032 0410-jpatoscacapabilitytypejpatoscarequirement_properties.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 019033 0420-jpatoscacapabilitytypejpatoscaservicetemplate_metadata.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3321
drools-db-migration | 065034 0430-toscanodetypesjpatoscatopologytemplate_toscanodetypeinputs.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0640-toscanodetypes35 0440-pdpgroup_pdpsubgroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 063036 0450-toscanodetypepdpgroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0620-toscanodetemplates_toscanodetemplate37 0460-pdppolicystatus.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0590-toscadatatypes_toscadatatype38 0470-pdp.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 061039 0480-toscanodetemplatespdpstatistics.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0600-toscanodetemplate40 0490-pdpsubgroup_pdp.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 066041 0500-toscaparameterpdpsubgroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 067042 0510-toscapoliciestoscacapabilityassignment.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0680-toscapolicies_toscapolicy43 0520-toscacapabilityassignments.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0690-toscapolicy44 0530-toscacapabilityassignments_toscacapabilityassignment.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 070045 0540-toscapolicytypetoscacapabilitytype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 071046 0550-toscapolicytypestoscacapabilitytypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0740-toscarelationshiptype47 0560-toscacapabilitytypes_toscacapabilitytype.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3421
drools-db-migration | 073048 0570-toscapropertytoscadatatype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0720-toscapolicytypes_toscapolicytype49 0580-toscadatatypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 058050 0590-toscadatatypes_toscadatatype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 057051 0600-toscadatatypetoscanodetemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0560-toscacapabilitytypes_toscacapabilitytype52 0610-toscanodetemplates.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 043053 0620-jpatoscatopologytemplatetoscanodetemplates_inputstoscanodetemplate.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 0440-pdpgroup_pdpsubgroup54 0630-toscanodetype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3421
drools-db-migration | 045055 0640-pdpgrouptoscanodetypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 0460-pdppolicystatus56 0650-toscanodetypes_toscanodetype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 047057 0660-pdptoscaparameter.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 048058 0670-pdpstatisticstoscapolicies.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 049059 0680-pdpsubgrouptoscapolicies_pdptoscapolicy.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 050060 0690-pdpsubgrouptoscapolicy.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 051061 0700-toscacapabilityassignmenttoscapolicytype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 052062 0710-toscacapabilityassignmentstoscapolicytypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 053063 0720-toscacapabilityassignmentstoscapolicytypes_toscacapabilityassignmenttoscapolicytype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 054064 0730-toscacapabilitytypetoscaproperty.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 055065 0740-toscacapabilitytypestoscarelationshiptype.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3422
drools-db-migration | 0910-FK_ToscaTopologyTemplate_nodeTemplatesName66 0750-toscarelationshiptypes.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 090067 0760-FKtoscarelationshiptypes_ToscaServiceTemplate_relationshipTypesNametoscarelationshiptype.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3522
drools-db-migration | 0890-FK_ToscaServiceTemplate_policyTypesName68 0770-toscarequirement.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 0880-FK_ToscaServiceTemplate_nodeTypesName69 0780-toscarequirements.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 087070 0790-FKtoscarequirements_ToscaServiceTemplate_dataTypesNametoscarequirement.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 0920-FK_ToscaTopologyTemplate_policyName71 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-13 0819 15:5303:3522
drools-db-migration | 093073 0820-TscaServiceTemplatetopologyTemplateParentLocalNametoscatrigger.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 094074 0830-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 095075 0840-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 096076 0850-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 097077 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3522
drools-db-migration | 098078 0870-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 086079 0880-FK_ToscaServiceTemplate_capabilityTypesNamenodeTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3522
drools-db-migration | 085080 0890-FK_ToscaNodeTypeToscaServiceTemplate_requirementsNamepolicyTypesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3522
drools-db-migration | 084081 0900-FK_ToscaNodeTemplateToscaServiceTemplate_requirementsNamerelationshipTypesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3523
drools-db-migration | 0750-toscarelationshiptypes82 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3523
drools-db-migration | 0760-toscarelationshiptypes_toscarelationshiptype83 0920-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 077084 0930-toscarequirementTscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 0780-toscarequirements85 0940-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 0790-toscarequirements_toscarequirement86 0950-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 0800-toscaservicetemplate87 0960-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 0810-toscatopologytemplate88 0970-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3523
drools-db-migration | 0820-toscatrigger89 0980-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 083090 0990-FK_ToscaNodeTemplateToscaServiceTemplate_capabilitiesNamenodeTypesName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3523
drools-db-migration | 102091 1000-FK_ToscaTopologyTemplateToscaServiceTemplate_nodeTemplatesNamepolicyTypesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3623
drools-db-migration | 92 1010-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3623
drools-db-migration | 100093 1020-FK_ToscaServiceTemplateToscaTopologyTemplate_policyTypesNamenodeTemplatesName.sql upgrade 0 0800 1 1907211503200800u 2021-07-13 0819 15:5303:3623
drools-db-migration | 099094 1030-FK_ToscaServiceTemplateToscaTopologyTemplate_nodeTypesNamepolicyName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 95 1040-IDX_TSIDX1.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 96 1050-PdpPolicyStatus_PdpGroup.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 97 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1907211503200800u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 1030-FK_ToscaTopologyTemplate_policyName98 0100-jpapolicyaudit.sql upgrade 0 0800 0900 1907211503200900u 1 2021-07-13 0819 15:5303:3623
drools-db-migration | 0120-JpaPolicyAuditIndex_timestamp99 0110-sequence.sql downgrade upgrade 0800 0900 0800 1907211503200900u 1 2021-07-13 0819 15:5303:4123
drools-db-migration | 0110-sequence100 0120-JpaPolicyAuditIndex_timestamp.sql downgrade upgrade 0800 0900 0800 1907211503200900u 1 2021-07-13 0819 15:5303:4123
drools-db-migration | 0100-jpapolicyaudit101 0120-JpaPolicyAuditIndex_timestamp.sql downgrade 0900 0800 1907211503280900d 1 2021-07-13 0819 15:5303:4128
drools-db-migration | 0100102 0110-jpapolicyaudit.sql 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-13 0819 15:5304:5224
drools-db-migration | 105 0110-sequence.sql upgrade 0800 0900 1907211504240900u 1 2021-07-13 0819 15:5304:5224
drools-db-migration | 106 0120-JpaPolicyAuditIndex_timestamp.sql upgrade 0800 0900 1907211504240900u 1 2021-07-13 0819 15:5304:5224
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
...
MariaDB [migration]> select * from policyadmin_change_history order by atTime asc;
+-----+---------------------------------------------------------------+-----------+--------------+------------+-------------------+---------+---------------------+
| ID | script | operation | from_version | to_version | tag | success | atTime
|
+-----+---------------------------------------------------------------+-----------+--------------+------------+------------+-------+---------+-------+
| 0100-jpapdpgroup--------------+
| 1 | 0100-jpapdpgroup_properties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 12:52:23 |
| 0200-jpatoscacapabilitytype19 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-13 12:52:23 |
| 0210-jpatoscadatatype_constraints-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-13 1219 15:5203:23 20 |
| 02207 | 0160-jpatoscadatatypejpatoscacapabilityassignment_metadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:23 20 |
| 8 | 02300170-jpatoscadatatypejpatoscacapabilityassignment_propertiesoccurrences.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:23 20 |
| 9 | 02400180-jpatoscanodetemplatejpatoscacapabilityassignment_metadataproperties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:23 20 |
| 10 | 02500190-jpatoscanodetemplatejpatoscacapabilitytype_propertiesmetadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:23 20 |
| 026011 | 0200-jpatoscanodetypejpatoscacapabilitytype_metadataproperties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:23 20 |
| 12 | 02700210-jpatoscanodetypejpatoscadatatype_propertiesconstraints.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:23 20 |
| 028013 | 0220-jpatoscapolicyjpatoscadatatype_metadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:23 20 |
| 029014 | 0230-jpatoscapolicyjpatoscadatatype_properties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:23 20 |
| 019015 | 0240-jpatoscacapabilitytypejpatoscanodetemplate_metadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:23 20 |
| 018016 | 0250-jpatoscacapabilityassignmentjpatoscanodetemplate_properties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:23 20 |
| 17 | 01100260-jpapdpstatisticsjpatoscanodetype_enginestatsmetadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:23 20 |
| 012018 | 0270-jpapdpsubgroupjpatoscanodetype_policiesproperties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:23 20 |
| 19 | 01300280-jpapdpsubgroupjpatoscapolicy_propertiesmetadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:23 20 |
| 20 | 01400290-jpapdpsubgroupjpatoscapolicy_supportedpolicytypesproperties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:23 20 |
| 015021 | 0300-jpatoscacapabilityassignmentjpatoscapolicy_attributestargets.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:23 20 |
| 016022 | 0310-jpatoscacapabilityassignmentjpatoscapolicytype_metadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:23 20 |
| 017023 | 0320-jpatoscacapabilityassignmentjpatoscapolicytype_occurrencesproperties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:23 20 |
| 24 | 05200330-toscacapabilityassignmentsjpatoscapolicytype_targets.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 0510-toscacapabilityassignment25 | 0340-jpatoscapolicytype_triggers.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 26 | 05000350-pdpsubgroupjpatoscaproperty_constraints.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 27 | 04900360-pdpsubgroupjpatoscaproperty_pdpmetadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 0480-pdpstatistics28 | 0370-jpatoscarelationshiptype_metadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 0470-pdp29 | 0380-jpatoscarelationshiptype_properties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 30 | 04600390-pdppolicystatusjpatoscarequirement_metadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 053031 | 0400-toscacapabilityassignmentsjpatoscarequirement_toscacapabilityassignmentoccurrences.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 0540-toscacapabilitytype32 | 0410-jpatoscarequirement_properties.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 0550-toscacapabilitytypes33 | 0420-jpatoscaservicetemplate_metadata.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 056034 | 0430-toscacapabilitytypesjpatoscatopologytemplate_toscacapabilitytypeinputs.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 0570-toscadatatype35 | 0440-pdpgroup_pdpsubgroup.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 36 | 05800450-toscadatatypespdpgroup.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 37 | 05900460-toscadatatypes_toscadatatypepdppolicystatus.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 38 | 06200470-toscanodetemplates_toscanodetemplatepdp.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 061039 | 0480-toscanodetemplatespdpstatistics.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 0600-toscanodetemplate40 | 0490-pdpsubgroup_pdp.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 045041 | 0500-pdpgrouppdpsubgroup.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 0440-pdpgroup_pdpsubgroup42 | 0510-toscacapabilityassignment.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 0300-jpatoscapolicy_targets43 | 0520-toscacapabilityassignments.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 44 | 03100530-jpatoscapolicytypetoscacapabilityassignments_metadatatoscacapabilityassignment.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 0320-jpatoscapolicytype_properties45 | 0540-toscacapabilitytype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 0330-jpatoscapolicytype_targets46 | 0550-toscacapabilitytypes.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 034047 | 0560-jpatoscapolicytypetoscacapabilitytypes_triggerstoscacapabilitytype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 0350-jpatoscaproperty_constraints48 | 0570-toscadatatype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 0360-jpatoscaproperty_metadata49 | 0580-toscadatatypes.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 50 | 03700590-jpatoscarelationshiptypetoscadatatypes_metadatatoscadatatype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 0430-jpatoscatopologytemplate_inputs51 | 0600-toscanodetemplate.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 52 | 04200610-jpatoscaservicetemplate_metadatatoscanodetemplates.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 041053 | 0620-jpatoscarequirementtoscanodetemplates_propertiestoscanodetemplate.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 54 | 04000630-jpatoscarequirement_occurrencestoscanodetype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 21 |
| 0390-jpatoscarequirement_metadata55 | 0640-toscanodetypes.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 22 |
| 56 | 03800650-jpatoscarelationshiptypetoscanodetypes_propertiestoscanodetype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:24 22 |
| 57 | 08100660-toscatopologytemplatetoscaparameter.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 080058 | 0670-toscaservicetemplatetoscapolicies.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 59 | 07900680-toscarequirementstoscapolicies_toscarequirementtoscapolicy.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 078060 | 0690-toscarequirementstoscapolicy.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 077061 | 0700-toscarequirementtoscapolicytype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 62 | 07600710-toscarelationshiptypes_toscarelationshiptypetoscapolicytypes.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 0820-toscatrigger63 | 0720-toscapolicytypes_toscapolicytype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 64 | 0830-FK_ToscaNodeTemplate_capabilitiesName0730-toscaproperty.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 0840-FK_ToscaNodeTemplate_requirementsName65 | 0740-toscarelationshiptype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 0850-FK_ToscaNodeType_requirementsName66 | 0750-toscarelationshiptypes.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 086067 | 0760-FKtoscarelationshiptypes_ToscaServiceTemplate_capabilityTypesNametoscarelationshiptype.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 0870-FK_ToscaServiceTemplate_dataTypesName68 | 0770-toscarequirement.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 69 | 0880-FK_ToscaServiceTemplate_nodeTypesName0780-toscarequirements.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 70 | 08900790-FKtoscarequirements_ToscaServiceTemplate_policyTypesNametoscarequirement.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 71 | 07500800-toscarelationshiptypestoscaservicetemplate.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 72 | 07400810-toscarelationshiptypetoscatopologytemplate.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 063073 | 0820-toscanodetypetoscatrigger.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 0640-toscanodetypes74 | 0830-FK_ToscaNodeTemplate_capabilitiesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 75 | 06500840-toscanodetypesFK_ToscaNodeTemplate_toscanodetyperequirementsName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 0660-toscaparameter76 | 0850-FK_ToscaNodeType_requirementsName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 77 | 0670-toscapolicies0860-FK_ToscaServiceTemplate_capabilityTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 0680-toscapolicies_toscapolicy78 | 0870-FK_ToscaServiceTemplate_dataTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 79 | 0690-toscapolicy0880-FK_ToscaServiceTemplate_nodeTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 0700-toscapolicytype80 | 0890-FK_ToscaServiceTemplate_policyTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 22 |
| 81 | 0710-toscapolicytypes0900-FK_ToscaServiceTemplate_relationshipTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 23 |
| 0720-toscapolicytypes_toscapolicytype82 | 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 23 |
| 0730-toscaproperty83 | 0920-FK_ToscaTopologyTemplate_policyName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:25 23 |
| 0980-FK_ToscaServiceTemplate_dataTypesName84 | 0930-TscaServiceTemplatetopologyTemplateParentLocalName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:26 23 |
| 099085 | 0940-FK_ToscaServiceTemplateToscaNodeTemplate_nodeTypesNamecapabilitiesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:26 23 |
| 86 | 10000950-FK_ToscaServiceTemplateToscaNodeTemplate_policyTypesNamerequirementsName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:26 23 |
| 101087 | 0960-FK_ToscaServiceTemplateToscaNodeType_relationshipTypesNamerequirementsName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:26 23 |
| 102088 | 0970-FK_ToscaTopologyTemplateToscaServiceTemplate_nodeTemplatesNamecapabilityTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:26 23 |
| 103089 | 0980-FK_ToscaTopologyTemplateToscaServiceTemplate_policyNamedataTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:26 23 |
| 1040-IDX_TSIDX190 | 0990-FK_ToscaServiceTemplate_nodeTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:26 23 |
| 91 | 10501000-PdpPolicyStatusFK_ToscaServiceTemplate_PdpGrouppolicyTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:26 23 |
| 92 | 1060-TscaServiceTemplatetopologyTemplateParentLocalName1010-FK_ToscaServiceTemplate_relationshipTypesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:26 23 |
| 097093 | 1020-FK_ToscaServiceTemplateToscaTopologyTemplate_capabilityTypesNamenodeTemplatesName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:26 23 |
| 94 | 09601030-FK_ToscaNodeTypeToscaTopologyTemplate_requirementsNamepolicyName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:26 23 |
| 090095 | 1040-FKIDX_ToscaServiceTemplate_relationshipTypesNameTSIDX1.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:26 23 |
| 091096 | 1050-FKPdpPolicyStatus_ToscaTopologyTemplate_nodeTemplatesNamePdpGroup.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:26 23 |
| 0920-FK_ToscaTopologyTemplate_policyName97 | 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql | upgrade | 0 | 0800 | 1907211503200800u | 1 | 2021-07-13 1219 15:5203:26 23 |
| 093098 | 0100-TscaServiceTemplatetopologyTemplateParentLocalNamejpapolicyaudit.sql | upgrade | 0800 | 0 0900 | 0800 1907211503200900u | 1 | 2021-07-13 1219 15:5203:26 23 |
| 99 | 0940-FK_ToscaNodeTemplate_capabilitiesName0110-sequence.sql | upgrade | 0800 | 0 0900 | 0800 1907211503200900u | 1 | 2021-07-13 1219 15:5203:26 23 |
| 100 | 09500120-FKJpaPolicyAuditIndex_ToscaNodeTemplate_requirementsNametimestamp.sql | upgrade | 0 0800 | 0900 | 0800 1907211503200900u | 1 | 2021-07-13 1219 15:5203:26 23 |
| 101 | 0120-JpaPolicyAuditIndex_timestamp.sql | downgrade | 0900 | 0800 | 1907211503280900d | 1 | 2021-07-13 1219 15:5203:31 28 |
| 102 | 0110-sequence.sql | downgrade | 0900 | 0800 | 1907211503280900d | 1 | 2021-07-13 1219 15:5203:31 29 |
| 103 | 0100-jpapolicyaudit.sql | downgrade | 0900 | 0800 | 1907211503280900d | 1 | 2021-07-13 1219 15:5203:31 29 |
| 104 | 0100-jpapolicyaudit.sql | upgrade | 0800 | 0900 | 1907211504240900u | 1 | 2021-07-13 1219 15:5204:42 24 |
| 105 | 0110-sequence.sql | upgrade | 0800 | 0900 | 1907211504240900u | 1 | 2021-07-13 1219 15:5204:42 24 |
| 106 | 0120-JpaPolicyAuditIndex_timestamp.sql | upgrade | 0800 | 0900 | 1907211504240900u | 1 | 2021-07-13 1219 15:5204:42 24 |
+-----+---------------------------------------------------------------+-----------+--------------+------------+-------------------+---------+---------------------+
103 106 rows in set (0.001 sec)