Page Comparison

...

drools-db-migration | .Connection to mariadb 3306 port [tcp/mysql] succeeded!
mariadb | 2021-07-12 1113 8:4453:47 32 3 [Warning] Aborted connection 3 to db: 'unconnected' user: 'unauthenticated' host: '192172.16822.1280.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 1000100-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 1100110-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 1200120-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 1300130-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 1400140-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 1500150-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 1600160-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 1700170-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 1800180-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 1900190-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 2000200-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 2100210-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 2200220-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 2300230-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 2400240-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 2500250-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 2600260-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 2700270-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 2800280-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 2900290-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 3000300-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 3100310-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 3200320-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 3300330-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 3400340-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 3500350-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 3600360-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 3700370-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 3800380-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 3900390-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 4000400-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 4100410-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 4200420-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 4300430-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 4400440-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 4500450-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 4600460-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 4700470-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 4800480-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 4900490-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 5000500-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 5100510-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 5200520-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 5300530-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 5400540-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 5500550-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 5600560-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 5700570-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 5800580-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 5900590-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 6000600-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 6100610-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 6200620-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 6300630-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 6400640-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 6500650-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 6600660-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 6700670-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 6800680-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 6900690-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 7000700-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 7100710-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 7200720-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 7300730-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 7400740-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 7500750-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 7600760-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 7700770-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 7800780-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 7900790-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 8000800-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 8100810-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 8200820-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 8300830-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 8400840-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 8500850-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 8600860-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 8700870-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 8800880-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 8900890-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 9000900-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 9100910-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 9200920-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 9300930-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 9400940-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 9500950-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 9600960-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 9700970-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 9800980-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 9900990-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 1000100-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 1100110-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 1200120-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 | script operation from_version to_version success atTime
drools-db-migration | 1000420-jpapdpgroupjpatoscaservicetemplate_propertiesmetadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 1400280-jpapdpsubgroupjpatoscapolicy_supportedpolicytypesmetadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 1500290-jpatoscacapabilityassignmentjpatoscapolicy_attributesproperties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 1600300-jpatoscacapabilityassignmentjpatoscapolicy_metadatatargets.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 1700310-jpatoscacapabilityassignmentjpatoscapolicytype_occurrencesmetadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 1800320-jpatoscacapabilityassignmentjpatoscapolicytype_properties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 1900330-jpatoscacapabilitytypejpatoscapolicytype_metadatatargets.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 2000340-jpatoscacapabilitytypejpatoscapolicytype_propertiestriggers.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 2100350-jpatoscadatatypejpatoscaproperty_constraints.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 2200360-jpatoscadatatypejpatoscaproperty_metadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 2300370-jpatoscadatatypejpatoscarelationshiptype_propertiesmetadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 2500380-jpatoscanodetemplatejpatoscarelationshiptype_properties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 1300390-jpapdpsubgroupjpatoscarequirement_propertiesmetadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 2400400-jpatoscanodetemplatejpatoscarequirement_metadataoccurrences.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 1200410-jpapdpsubgroupjpatoscarequirement_policiesproperties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 1100270-jpapdpstatisticsjpatoscanodetype_enginestatsproperties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 4500260-pdpgroupjpatoscanodetype_metadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 4400250-pdpgroupjpatoscanodetemplate_pdpsubgroupproperties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 4300100-jpatoscatopologytemplatejpapdpgroup_inputsproperties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 4200110-jpatoscaservicetemplatejpapdpstatistics_metadataenginestats.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 4100120-jpatoscarequirementjpapdpsubgroup_propertiespolicies.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 4000130-jpatoscarequirementjpapdpsubgroup_occurrencesproperties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 3900140-jpatoscarequirementjpapdpsubgroup_metadatasupportedpolicytypes.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 3800150-jpatoscarelationshiptypejpatoscacapabilityassignment_propertiesattributes.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 4600160-pdppolicystatusjpatoscacapabilityassignment_metadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 5600170-toscacapabilitytypesjpatoscacapabilityassignment_toscacapabilitytypeoccurrences.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 4700180-pdpjpatoscacapabilityassignment_properties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 4800240-pdpstatisticsjpatoscanodetemplate_metadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 4900230-pdpsubgroupjpatoscadatatype_pdpproperties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 5000220-pdpsubgroupjpatoscadatatype_metadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 5100210-toscacapabilityassignmentjpatoscadatatype_constraints.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 5200200-toscacapabilityassignmentsjpatoscacapabilitytype_properties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 5300190-toscacapabilityassignmentsjpatoscacapabilitytype_toscacapabilityassignmentmetadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 5400650-toscacapabilitytypetoscanodetypes_toscanodetype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 5500640-toscacapabilitytypestoscanodetypes.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 3700630-jpatoscarelationshiptype_metadatatoscanodetype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 3600620-jpatoscapropertytoscanodetemplates_metadatatoscanodetemplate.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 3500610-jpatoscaproperty_constraintstoscanodetemplates.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 2600600-jpatoscanodetype_metadatatoscanodetemplate.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 2700660-jpatoscanodetype_propertiestoscaparameter.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 2800670-jpatoscapolicy_metadatatoscapolicies.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 2900680-jpatoscapolicytoscapolicies_propertiestoscapolicy.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 3000690-jpatoscapolicy_targetstoscapolicy.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 3100700-jpatoscapolicytype_metadatatoscapolicytype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 3200710-jpatoscapolicytype_propertiestoscapolicytypes.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 3300720-jpatoscapolicytypetoscapolicytypes_targetstoscapolicytype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 3400730-jpatoscapolicytype_triggerstoscaproperty.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 7500740-toscarelationshiptypestoscarelationshiptype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 7400590-toscarelationshiptypetoscadatatypes_toscadatatype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 7300580-toscapropertytoscadatatypes.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 7200430-toscapolicytypesjpatoscatopologytemplate_toscapolicytypeinputs.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 7100440-toscapolicytypespdpgroup_pdpsubgroup.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 7000450-toscapolicytypepdpgroup.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 6900460-toscapolicypdppolicystatus.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 6800470-toscapolicies_toscapolicypdp.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 7600480-toscarelationshiptypes_toscarelationshiptypepdpstatistics.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 7700490-toscarequirementpdpsubgroup_pdp.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 850-FK_ToscaNodeType_requirementsName0500-pdpsubgroup.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 840-FK_ToscaNodeTemplate_requirementsName0510-toscacapabilityassignment.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 830-FK_ToscaNodeTemplate_capabilitiesName0570-toscadatatype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 8200560-toscatriggertoscacapabilitytypes_toscacapabilitytype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 8100550-toscatopologytemplatetoscacapabilitytypes.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 8000540-toscaservicetemplatetoscacapabilitytype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 7900530-toscarequirementstoscacapabilityassignments_toscarequirementtoscacapabilityassignment.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 7800520-toscarequirementstoscacapabilityassignments.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 670-toscapolicies0880-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 660-toscaparameter0890-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 6500900-toscanodetypesFK_ToscaServiceTemplate_toscanodetyperelationshipTypesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 570-toscadatatype0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 580-toscadatatypes0920-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 5900930-toscadatatypes_toscadatatypeTscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 600-toscanodetemplate0940-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 610-toscanodetemplates0950-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 6200960-toscanodetemplatesFK_ToscaNodeType_toscanodetemplaterequirementsName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 630-toscanodetype.0970-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 640-toscanodetypes0980-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 8900870-FK_ToscaServiceTemplate_policyTypesNamedataTypesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 9000860-FK_ToscaServiceTemplate_relationshipTypesNamecapabilityTypesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 910-FK_ToscaTopologyTemplate_nodeTemplatesName0750-toscarelationshiptypes.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 9200760-FKtoscarelationshiptypes_ToscaTopologyTemplate_policyNametoscarelationshiptype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 9300770-TscaServiceTemplatetopologyTemplateParentLocalNametoscarequirement.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 940-FK_ToscaNodeTemplate_capabilitiesName0780-toscarequirements.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 9500790-FKtoscarequirements_ToscaNodeTemplate_requirementsNametoscarequirement.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 960-FK_ToscaNodeType_requirementsName0800-toscaservicetemplate.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 970-FK_ToscaServiceTemplate_capabilityTypesName0810-toscatopologytemplate.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 980-FK_ToscaServiceTemplate_dataTypesName0820-toscatrigger.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 8800830-FK_ToscaServiceTemplateToscaNodeTemplate_nodeTypesNamecapabilitiesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 8700840-FK_ToscaServiceTemplateToscaNodeTemplate_dataTypesNamerequirementsName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 8600850-FK_ToscaServiceTemplateToscaNodeType_capabilityTypesNamerequirementsName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 1001050-jpapolicyauditPdpPolicyStatus_PdpGroup.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5036
drools-db-migration | 1000-FK_ToscaServiceTemplate_policyTypesName1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5036
drools-db-migration | 1010-FK_ToscaServiceTemplate_relationshipTypesName0100-jpapolicyaudit.sql upgrade 0 0900 1 2021-07-12 1113 08:4453:5036
drools-db-migration | 1020-FK_ToscaTopologyTemplate_nodeTemplatesName0110-sequence.sql upgrade 0 0900 1 2021-07-12 1113 08:4453:5036
drools-db-migration | 10301040-FKIDX_ToscaTopologyTemplate_policyNameTSIDX1.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5036
drools-db-migration | 10401030-IDXFK_ToscaTopologyTemplate_TSIDX1policyName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5036
drools-db-migration | 10501020-PdpPolicyStatusFK_ToscaTopologyTemplate_PdpGroupnodeTemplatesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5036
drools-db-migration | 1060-TscaServiceTemplatetopologyTemplateParentLocalName1010-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5036
drools-db-migration | 110-sequence1000-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5036
drools-db-migration | 1200990-JpaPolicyAuditIndexFK_ToscaServiceTemplate_timestampnodeTypesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5036
drools-db-migration | 9900120-FKJpaPolicyAuditIndex_ToscaServiceTemplate_nodeTypesNametimestamp.sql upgrade 0 0900 1 2021-07-12 1113 08:4453:5036
drools-db-migration | policyadmin: OK @ 0900
drools-db-migration | 206 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 1200120-JpaPolicyAuditIndex_timestamp.sql
drools-db-migration | --------------
drools-db-migration | DROP INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyauditSET FOREIGN_KEY_CHECKS = 0
drools-db-migration | --------------
drools-db-migration |
drools-db-migration |
drools--db-migration | > downgrade 110------------
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 1000100-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 | script operation from_version to_version success atTime
drools-db-migration | 1000420-jpapdpgroupjpatoscaservicetemplate_propertiesmetadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 1400260-jpapdpsubgroupjpatoscanodetype_supportedpolicytypesmetadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 1500270-jpatoscacapabilityassignmentjpatoscanodetype_attributesproperties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 1600280-jpatoscacapabilityassignmentjpatoscapolicy_metadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 1700290-jpatoscacapabilityassignmentjpatoscapolicy_occurrencesproperties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 1800300-jpatoscacapabilityassignmentjpatoscapolicy_propertiestargets.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 1900310-jpatoscacapabilitytypejpatoscapolicytype_metadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 2000320-jpatoscacapabilitytypejpatoscapolicytype_properties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 2100330-jpatoscadatatypejpatoscapolicytype_constraintstargets.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 2200340-jpatoscadatatypejpatoscapolicytype_metadatatriggers.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 2300350-jpatoscadatatypejpatoscaproperty_propertiesconstraints.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 2500360-jpatoscanodetemplatejpatoscaproperty_propertiesmetadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 1300370-jpapdpsubgroupjpatoscarelationshiptype_propertiesmetadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 2400380-jpatoscanodetemplatejpatoscarelationshiptype_metadataproperties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 1200390-jpapdpsubgroupjpatoscarequirement_policiesmetadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 1100400-jpapdpstatisticsjpatoscarequirement_enginestatsoccurrences.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4733
drools-db-migration | 4500410-pdpgroupjpatoscarequirement_properties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 4400250-pdpgroupjpatoscanodetemplate_pdpsubgroupproperties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 4300240-jpatoscatopologytemplatejpatoscanodetemplate_inputsmetadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 4200100-jpatoscaservicetemplatejpapdpgroup_metadataproperties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 4100110-jpatoscarequirementjpapdpstatistics_propertiesenginestats.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 4000120-jpatoscarequirementjpapdpsubgroup_occurrencespolicies.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 3900130-jpatoscarequirementjpapdpsubgroup_metadataproperties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 3800140-jpatoscarelationshiptypejpapdpsubgroup_propertiessupportedpolicytypes.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 4600150-pdppolicystatusjpatoscacapabilityassignment_attributes.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 5600160-toscacapabilitytypesjpatoscacapabilityassignment_toscacapabilitytypemetadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 4700170-pdpjpatoscacapabilityassignment_occurrences.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 4800230-pdpstatisticsjpatoscadatatype_properties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 4900220-pdpsubgroupjpatoscadatatype_pdpmetadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 5000210-pdpsubgroupjpatoscadatatype_constraints.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 5100180-toscacapabilityassignmentjpatoscacapabilityassignment_properties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 5200200-toscacapabilityassignmentsjpatoscacapabilitytype_properties.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 5300190-toscacapabilityassignmentsjpatoscacapabilitytype_toscacapabilityassignmentmetadata.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4833
drools-db-migration | 5400650-toscacapabilitytypetoscanodetypes_toscanodetype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 5500640-toscacapabilitytypestoscanodetypes.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 3700630-jpatoscarelationshiptype_metadatatoscanodetype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 3600620-jpatoscapropertytoscanodetemplates_metadatatoscanodetemplate.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 3500590-jpatoscapropertytoscadatatypes_constraintstoscadatatype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 2600610-jpatoscanodetype_metadatatoscanodetemplates.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 2700600-jpatoscanodetype_propertiestoscanodetemplate.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 2800660-jpatoscapolicy_metadatatoscaparameter.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 2900670-jpatoscapolicy_propertiestoscapolicies.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 3000680-jpatoscapolicytoscapolicies_targetstoscapolicy.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 3100690-jpatoscapolicytype_metadatatoscapolicy.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 3200700-jpatoscapolicytype_propertiestoscapolicytype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 3300710-jpatoscapolicytype_targetstoscapolicytypes.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 3400740-jpatoscapolicytype_triggerstoscarelationshiptype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4834
drools-db-migration | 7500730-toscarelationshiptypestoscaproperty.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 7400720-toscarelationshiptypetoscapolicytypes_toscapolicytype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 7300580-toscapropertytoscadatatypes.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 7200570-toscapolicytypes_toscapolicytypetoscadatatype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 7100560-toscapolicytypestoscacapabilitytypes_toscacapabilitytype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 7000430-toscapolicytypejpatoscatopologytemplate_inputs.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 6900440-toscapolicypdpgroup_pdpsubgroup.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 6800450-toscapolicies_toscapolicypdpgroup.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 7600460-toscarelationshiptypes_toscarelationshiptypepdppolicystatus.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 7700470-toscarequirementpdp.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 850-FK_ToscaNodeType_requirementsName0480-pdpstatistics.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 8400490-FKpdpsubgroup_ToscaNodeTemplate_requirementsNamepdp.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 830-FK_ToscaNodeTemplate_capabilitiesName0500-pdpsubgroup.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 8200510-toscatriggertoscacapabilityassignment.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 8100520-toscatopologytemplatetoscacapabilityassignments.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 8000530-toscaservicetemplatetoscacapabilityassignments_toscacapabilityassignment.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 7900540-toscarequirements_toscarequirementtoscacapabilitytype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 7800550-toscarequirementstoscacapabilitytypes.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4934
drools-db-migration | 670-toscapolicies0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 660-toscaparameter0900-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 6500890-toscanodetypesFK_ToscaServiceTemplate_toscanodetypepolicyTypesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 570-toscadatatype0880-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 580-toscadatatypes0870-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 5900920-toscadatatypesFK_ToscaTopologyTemplate_toscadatatypepolicyName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 6000930-toscanodetemplateTscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 610-toscanodetemplates0940-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 6200950-toscanodetemplatesFK_ToscaNodeTemplate_toscanodetemplaterequirementsName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 630-toscanodetype0960-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 640-toscanodetypes0970-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:4935
drools-db-migration | 8900980-FK_ToscaServiceTemplate_policyTypesNamedataTypesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 9000860-FK_ToscaServiceTemplate_relationshipTypesNamecapabilityTypesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 9100850-FK_ToscaTopologyTemplateToscaNodeType_nodeTemplatesNamerequirementsName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 9200840-FK_ToscaTopologyTemplateToscaNodeTemplate_policyNamerequirementsName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 9300750-TscaServiceTemplatetopologyTemplateParentLocalNametoscarelationshiptypes.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 9400760-FKtoscarelationshiptypes_ToscaNodeTemplate_capabilitiesNametoscarelationshiptype.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 950-FK_ToscaNodeTemplate_requirementsName0770-toscarequirement.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 960-FK_ToscaNodeType_requirementsName0780-toscarequirements.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 9700790-FKtoscarequirements_ToscaServiceTemplate_capabilityTypesNametoscarequirement.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 980-FK_ToscaServiceTemplate_dataTypesName0800-toscaservicetemplate.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 880-FK_ToscaServiceTemplate_nodeTypesName0810-toscatopologytemplate.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 870-FK_ToscaServiceTemplate_dataTypesName0820-toscatrigger.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 8600830-FK_ToscaServiceTemplateToscaNodeTemplate_capabilityTypesNamecapabilitiesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5035
drools-db-migration | 10001040-FKIDX_ToscaServiceTemplate_policyTypesNameTSIDX1.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5036
drools-db-migration | 10101050-FKPdpPolicyStatus_ToscaServiceTemplate_relationshipTypesNamePdpGroup.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5036
drools-db-migration | 1020-FK_ToscaTopologyTemplate_nodeTemplatesName1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5036
drools-db-migration | 1030-FK_ToscaTopologyTemplate_policyName0100-jpapolicyaudit.sql upgrade 0 0900 1 2021-07-12 1113 08:4453:5036
drools-db-migration | 10400110-IDX_TSIDX1sequence.sql upgrade 0 0900 1 2021-07-12 1113 08:4453:5036
drools-db-migration | 10501030-PdpPolicyStatusFK_ToscaTopologyTemplate_PdpGrouppolicyName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5036
drools-db-migration | 1060-TscaServiceTemplatetopologyTemplateParentLocalName1020-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 1 2021-07-12 1113 08:4453:5036
drools-db-migration | 9901010-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 1 2021-07-12 11:44:50relationshipTypesName.sql upgrade 0 0800 1 2021-07-13 08:53:36
drools-db-migration | 1000-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 1 2021-07-13 08:53:36
drools-db-migration | 0990-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 1 2021-07-13 08:53:36
drools-db-migration | 0120-JpaPolicyAuditIndex_timestamp.sql upgrade 0 0900 1 2021-07-13 08:53:36
drools-db-migration | 0110-sequence.sql downgrade 0900 0800 1 2021-07-13 08:53:41
drools-db-migration | 0100-jpapolicyaudit.sql downgrade 0900 0800 1 2021-07-13 08:53:41
drools-db-migration | 0120-JpaPolicyAuditIndex_timestamp.sql downgrade 0900 0800 1 2021-07-13 08:53:41
drools-db-migration | policyadmin: downgrade available: 0800 -> 0
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 | 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 | script operation from_version to_version success atTime
drools-db-migration | 0420-jpatoscaservicetemplate_metadata.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0260-jpatoscanodetype_metadata.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0270-jpatoscanodetype_properties.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0280-jpatoscapolicy_metadata.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0290-jpatoscapolicy_properties.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0300-jpatoscapolicy_targets.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0310-jpatoscapolicytype_metadata.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0320-jpatoscapolicytype_properties.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0330-jpatoscapolicytype_targets.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0340-jpatoscapolicytype_triggers.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0350-jpatoscaproperty_constraints.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0360-jpatoscaproperty_metadata.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0370-jpatoscarelationshiptype_metadata.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0380-jpatoscarelationshiptype_properties.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0390-jpatoscarequirement_metadata.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0400-jpatoscarequirement_occurrences.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0410-jpatoscarequirement_properties.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0250-jpatoscanodetemplate_properties.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0240-jpatoscanodetemplate_metadata.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0100-jpapdpgroup_properties.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0110-jpapdpstatistics_enginestats.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0120-jpapdpsubgroup_policies.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0130-jpapdpsubgroup_properties.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0140-jpapdpsubgroup_supportedpolicytypes.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0150-jpatoscacapabilityassignment_attributes.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0160-jpatoscacapabilityassignment_metadata.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0170-jpatoscacapabilityassignment_occurrences.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0230-jpatoscadatatype_properties.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0220-jpatoscadatatype_metadata.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0210-jpatoscadatatype_constraints.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0180-jpatoscacapabilityassignment_properties.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0200-jpatoscacapabilitytype_properties.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0190-jpatoscacapabilitytype_metadata.sql upgrade 0 0800 1 2021-07-13 08:53:33
drools-db-migration | 0650-toscanodetypes_toscanodetype.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0640-toscanodetypes.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0630-toscanodetype.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0620-toscanodetemplates_toscanodetemplate.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0590-toscadatatypes_toscadatatype.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0610-toscanodetemplates.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0600-toscanodetemplate.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0660-toscaparameter.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0670-toscapolicies.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0680-toscapolicies_toscapolicy.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0690-toscapolicy.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0700-toscapolicytype.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0710-toscapolicytypes.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0740-toscarelationshiptype.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0730-toscaproperty.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0720-toscapolicytypes_toscapolicytype.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0580-toscadatatypes.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0570-toscadatatype.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0560-toscacapabilitytypes_toscacapabilitytype.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0430-jpatoscatopologytemplate_inputs.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0440-pdpgroup_pdpsubgroup.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0450-pdpgroup.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0460-pdppolicystatus.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0470-pdp.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0480-pdpstatistics.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0490-pdpsubgroup_pdp.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0500-pdpsubgroup.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0510-toscacapabilityassignment.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0520-toscacapabilityassignments.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0530-toscacapabilityassignments_toscacapabilityassignment.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0540-toscacapabilitytype.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0550-toscacapabilitytypes.sql upgrade 0 0800 1 2021-07-13 08:53:34
drools-db-migration | 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0890-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0880-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0870-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0920-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0930-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0940-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0950-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0960-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0970-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0980-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0850-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0840-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0750-toscarelationshiptypes.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0760-toscarelationshiptypes_toscarelationshiptype.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0770-toscarequirement.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0780-toscarequirements.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0790-toscarequirements_toscarequirement.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0800-toscaservicetemplate.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0810-toscatopologytemplate.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0820-toscatrigger.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 0830-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 1 2021-07-13 08:53:35
drools-db-migration | 1020-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 1 2021-07-13 08:53:36
drools-db-migration | 1010-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 1 2021-07-13 08:53:36
drools-db-migration | 1000-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 1 2021-07-13 08:53:36
drools-db-migration | 0990-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 1 2021-07-13 08:53:36
drools-db-migration | 1040-IDX_TSIDX1.sql upgrade 0 0800 1 2021-07-13 08:53:36
drools-db-migration | 1050-PdpPolicyStatus_PdpGroup.sql upgrade 0 0800 1 2021-07-13 08:53:36
drools-db-migration | 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 1 2021-07-13 08:53:36
drools-db-migration | 1030-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 1 2021-07-13 08:53:36
drools-db-migration | 0120-JpaPolicyAuditIndex_timestamp.sql downgrade 0900 0800 1 2021-07-13 08:53:41
drools-db-migration | 1100110-sequence.sql downgrade 0900 0800 1 2021-07-12 1113 08:4453:5641
drools-db-migration | 1200100-JpaPolicyAuditIndex_timestampjpapolicyaudit.sql downgrade 0900 0800 1 2021-07-12 1113 08:4453:5641
drools-db-migration | 1000100-jpapolicyaudit.sql downgrade upgrade 0800 0900 1 2021-07-12 1113 08:4453:5652
drools-db-migration | policyadmin: downgrade available: 0800 -> 00110-sequence.sql upgrade 0800 0900 1 2021-07-13 08:53:52
drools-db-migration | 0120-JpaPolicyAuditIndex_timestamp.sql upgrade 0800 0900 1 2021-07-13 08:53:52
drools-db-migration | policyadmin: OK @ 0900

Migration Schema

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

Database changed
MariaDB [migration]> show tables;
+----------------------------+
| Tables_in_migration |
+----------------------------+
| db_metadata_versions |
| policyadmin_change_history |
+----------------------------+
2 rows in set (0.000 sec)

MariaDB [migration]> select * from db_metadata_versions;
+-------------+---------+
| name | version |
+-------------+---------+
| policyadmin | 0800 0900 |
+-------------+---------+
1 row in set (0.000 sec)

...

MariaDB [migration]> select * from policyadmin_change_history order by atTime asc;
+---------------------------------------------------------------+-----------+--------------+------------+---------+---------------------+
| script | operation | from_version | to_version | success | atTime
|
+---------------------------------------------------------------+-----------+--------------+------------+---------+---------------------+
| 0100-jpapdpgroup_properties.sql | upgrade | 0 | 0800 | 1 | 2021-07-13 12:52:23 |
| 0200-jpatoscacapabilitytype_properties.sql | upgrade | 0 | 0800 | 1 | 2021-07-13 12:52:23 |
| 0210-jpatoscadatatype_constraints.sql | upgrade | 0 | 0800 | 1 | 2021-07-13 12:52:23 |
| 0220-jpatoscadatatype_metadata.sql | upgrade | 0 | 0800 | 1 | 2021----+07-13 12:52:23 |
| 1000230-jpapdpgroupjpatoscadatatype_properties.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:46 23 |
| 1300240-jpapdpsubgroupjpatoscanodetemplate_propertiesmetadata.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:46 23 |
| 1400250-jpapdpsubgroupjpatoscanodetemplate_supportedpolicytypesproperties.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:46 23 |
| 1500260-jpatoscacapabilityassignmentjpatoscanodetype_attributesmetadata.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:46 23 |
| 1600270-jpatoscacapabilityassignmentjpatoscanodetype_metadataproperties.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:46 23 |
| 1700280-jpatoscacapabilityassignmentjpatoscapolicy_occurrencesmetadata.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:46 23 |
| 1800290-jpatoscacapabilityassignmentjpatoscapolicy_properties.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:46 23 |
| 1900190-jpatoscacapabilitytype_metadata.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:46 23 |
| 2000180-jpatoscacapabilitytypejpatoscacapabilityassignment_properties.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:46 23 |
| 2100110-jpatoscadatatypejpapdpstatistics_constraintsenginestats.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:46 23 |
| 1200120-jpapdpsubgroup_policies.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:46 23 |
| 1100130-jpapdpstatisticsjpapdpsubgroup_enginestatsproperties.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:46 23 |
| 4300140-jpatoscatopologytemplatejpapdpsubgroup_inputssupportedpolicytypes.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 23 |
| 4000150-jpatoscarequirementjpatoscacapabilityassignment_occurrencesattributes.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 23 |
| 3900160-jpatoscarequirementjpatoscacapabilityassignment_metadata.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 23 |
| 3800170-jpatoscarelationshiptypejpatoscacapabilityassignment_propertiesoccurrences.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 23 |
| 3700520-jpatoscarelationshiptype_metadatatoscacapabilityassignments.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 3600510-jpatoscaproperty_metadatatoscacapabilityassignment.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 3500500-jpatoscaproperty_constraintspdpsubgroup.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 3400490-jpatoscapolicytypepdpsubgroup_triggerspdp.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 3300480-jpatoscapolicytype_targetspdpstatistics.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 4100470-jpatoscarequirement_propertiespdp.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 5100460-toscacapabilityassignmentpdppolicystatus.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 4200530-jpatoscaservicetemplatetoscacapabilityassignments_metadatatoscacapabilityassignment.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 4400540-pdpgroup_pdpsubgrouptoscacapabilitytype.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 4500550-pdpgrouptoscacapabilitytypes.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 4600560-pdppolicystatustoscacapabilitytypes_toscacapabilitytype.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 4700570-pdptoscadatatype.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 4800580-pdpstatisticstoscadatatypes.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 4900590-pdpsubgrouptoscadatatypes_pdptoscadatatype.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 5000620-pdpsubgrouptoscanodetemplates_toscanodetemplate.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 3200610-jpatoscapolicytype_propertiestoscanodetemplates.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 3100600-jpatoscapolicytype_metadatatoscanodetemplate.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 2400450-jpatoscanodetemplate_metadatapdpgroup.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 2200440-jpatoscadatatypepdpgroup_metadatapdpsubgroup.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 2300300-jpatoscadatatypejpatoscapolicy_propertiestargets.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 2500310-jpatoscanodetemplatejpatoscapolicytype_propertiesmetadata.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 2600320-jpatoscanodetypejpatoscapolicytype_metadataproperties.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 2700330-jpatoscanodetypejpatoscapolicytype_propertiestargets.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 2800340-jpatoscapolicyjpatoscapolicytype_metadatatriggers.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 2900350-jpatoscapolicyjpatoscaproperty_propertiesconstraints.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 3000360-jpatoscapolicyjpatoscaproperty_targetsmetadata.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:47 24 |
| 7200370-toscapolicytypesjpatoscarelationshiptype_toscapolicytypemetadata.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 24 |
| 7100430-toscapolicytypesjpatoscatopologytemplate_inputs.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 24 |
| 7000420-toscapolicytypejpatoscaservicetemplate_metadata.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 24 |
| 6900410-toscapolicyjpatoscarequirement_properties.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 24 |
| 6800400-toscapoliciesjpatoscarequirement_toscapolicyoccurrences.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 24 |
| 6700390-toscapoliciesjpatoscarequirement_metadata.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 24 |
| 6600380-toscaparameterjpatoscarelationshiptype_properties.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 24 |
| 6500810-toscanodetypes_toscanodetypetoscatopologytemplate.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 6400800-toscanodetypestoscaservicetemplate.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 7300790-toscapropertytoscarequirements_toscarequirement.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 7400780-toscarelationshiptypetoscarequirements.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 830-FK_ToscaNodeTemplate_capabilitiesName0770-toscarequirement.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 8200760-toscatriggertoscarelationshiptypes_toscarelationshiptype.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 8100820-toscatopologytemplatetoscatrigger.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 800-toscaservicetemplate0830-FK_ToscaNodeTemplate_capabilitiesName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 7900840-toscarequirementsFK_ToscaNodeTemplate_toscarequirementrequirementsName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 780-toscarequirements0850-FK_ToscaNodeType_requirementsName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 770-toscarequirement0860-FK_ToscaServiceTemplate_capabilityTypesName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 7600870-toscarelationshiptypesFK_ToscaServiceTemplate_toscarelationshiptypedataTypesName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 750-toscarelationshiptypes0880-FK_ToscaServiceTemplate_nodeTypesName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 630-toscanodetype0890-FK_ToscaServiceTemplate_policyTypesName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 6200750-toscanodetemplates_toscanodetemplatetoscarelationshiptypes.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 5200740-toscacapabilityassignmentstoscarelationshiptype.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 5300630-toscacapabilityassignments_toscacapabilityassignmenttoscanodetype.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 5400640-toscacapabilitytypetoscanodetypes.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 5500650-toscacapabilitytypestoscanodetypes_toscanodetype.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 5600660-toscacapabilitytypes_toscacapabilitytypetoscaparameter.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 5700670-toscadatatypetoscapolicies.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 5800680-toscadatatypestoscapolicies_toscapolicy.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 5900690-toscadatatypes_toscadatatypetoscapolicy.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 6000700-toscanodetemplatetoscapolicytype.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 6100710-toscanodetemplatestoscapolicytypes.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:48 25 |
| 9100720-FKtoscapolicytypes_ToscaTopologyTemplate_nodeTemplatesNametoscapolicytype.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 25 |
| 900-FK_ToscaServiceTemplate_relationshipTypesName0730-toscaproperty.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 25 |
| 8900980-FK_ToscaServiceTemplate_policyTypesNamedataTypesName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 26 |
| 8800990-FK_ToscaServiceTemplate_nodeTypesName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 26 |
| 9201000-FK_ToscaTopologyTemplateToscaServiceTemplate_policyNamepolicyTypesName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 26 |
| 930-TscaServiceTemplatetopologyTemplateParentLocalName1010-FK_ToscaServiceTemplate_relationshipTypesName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 26 |
| 9401020-FK_ToscaNodeTemplateToscaTopologyTemplate_capabilitiesNamenodeTemplatesName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 26 |
| 9501030-FK_ToscaNodeTemplateToscaTopologyTemplate_requirementsNamepolicyName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 26 |
| 9601040-FKIDX_ToscaNodeType_requirementsNameTSIDX1.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 26 |
| 9701050-FKPdpPolicyStatus_ToscaServiceTemplate_capabilityTypesNamePdpGroup.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 26 |
| 980-FK_ToscaServiceTemplate_dataTypesName1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 26 |
| 8700970-FK_ToscaServiceTemplate_dataTypesNamecapabilityTypesName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 26 |
| 8600960-FK_ToscaServiceTemplateToscaNodeType_capabilityTypesNamerequirementsName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 26 |
| 8500900-FK_ToscaNodeTypeToscaServiceTemplate_requirementsNamerelationshipTypesName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 26 |
| 10000910-FK_ToscaServiceTemplateToscaTopologyTemplate_policyTypesNamenodeTemplatesName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 26 |
| 10100920-FK_ToscaServiceTemplateToscaTopologyTemplate_relationshipTypesNamepolicyName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 26 |
| 1020-FK_ToscaTopologyTemplate_nodeTemplatesName0930-TscaServiceTemplatetopologyTemplateParentLocalName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 26 |
| 10300940-FK_ToscaTopologyTemplateToscaNodeTemplate_policyNamecapabilitiesName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 26 |
| 10400950-IDXFK_ToscaNodeTemplate_TSIDX1requirementsName.sql | upgrade | 0 | 0800 | 1 | 2021-07-08 1513 12:3352:49 26 |
| 10500120-PdpPolicyStatusJpaPolicyAuditIndex_PdpGroup.sql | upgrade timestamp.sql | downgrade | 0900 | 0800 | 1 | 2021-07-08 1513 12:3352:49 31 |
| 10600110-TscaServiceTemplatetopologyTemplateParentLocalNamesequence.sql | upgrade downgrade | 0900 | 0800 | 1 | 2021-07-08 1513 12:3352:49 31 |
| 840-FK_ToscaNodeTemplate_requirementsName0100-jpapolicyaudit.sql | downgrade | upgrade 0900 | 0800 | 1 | 2021-07-08 1513 12:3352:49 31 |
| 990-FK_ToscaServiceTemplate_nodeTypesName0100-jpapolicyaudit.sql | upgrade | 0800 | 0900 | 1 | 2021-07-08 1513 12:3352:49 42 |
| 1100110-sequence.sql | upgrade | downgrade 0800 | 0900 | 1 | 2021-07-08 1513 12:3352:55 42 |
| 1200120-JpaPolicyAuditIndex_timestamp.sql | upgrade | 0800 | downgrade 0900 | 1 | 2021-07-08 1513 12:3352:55 |
| 100-jpapolicyaudit.sql | downgrade | 1 | 2021-07-08 15:33:55 |
+42 |
+---------------------------------------------------------------+-----------+--------------+------------+---------+---------------------+
100 103 rows in set (0.001 sec)