Waiting for mariadb port 3306... .......Start of test 2022-03-23-10:10:48 ############################################################################################################ Starting test 1 error: no databases available Done upgrade: 0 -> 0900 > upgrade 0100-jpapdpgroup_properties.sql -------------- CREATE TABLE IF NOT EXISTS jpapdpgroup_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES VARCHAR(255) NULL, PROPERTIES_KEY VARCHAR(255) NULL) -------------- > upgrade 0110-jpapdpstatistics_enginestats.sql -------------- 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, timeStamp datetime DEFAULT NULL NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL) -------------- > upgrade 0120-jpapdpsubgroup_policies.sql -------------- 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) -------------- > upgrade 0130-jpapdpsubgroup_properties.sql -------------- 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) -------------- > upgrade 0140-jpapdpsubgroup_supportedpolicytypes.sql -------------- 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) -------------- > upgrade 0150-jpatoscacapabilityassignment_attributes.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_attributes (name VARCHAR(120) NULL, version VARCHAR(20) NULL, ATTRIBUTES LONGTEXT NULL, ATTRIBUTES_KEY VARCHAR(255) NULL) -------------- > upgrade 0160-jpatoscacapabilityassignment_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0170-jpatoscacapabilityassignment_occurrences.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_occurrences (name VARCHAR(120) NULL, version VARCHAR(20) NULL, OCCURRENCES INT DEFAULT NULL NULL) -------------- > upgrade 0180-jpatoscacapabilityassignment_properties.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL) -------------- > upgrade 0190-jpatoscacapabilitytype_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscacapabilitytype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0200-jpatoscacapabilitytype_properties.sql -------------- 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) -------------- > upgrade 0210-jpatoscadatatype_constraints.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscadatatype_constraints (name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINTS VARCHAR(255) NULL) -------------- > upgrade 0220-jpatoscadatatype_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscadatatype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0230-jpatoscadatatype_properties.sql -------------- 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) -------------- > upgrade 0240-jpatoscanodetemplate_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscanodetemplate_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0250-jpatoscanodetemplate_properties.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscanodetemplate_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL) -------------- > upgrade 0260-jpatoscanodetype_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscanodetype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0270-jpatoscanodetype_properties.sql -------------- 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) -------------- > upgrade 0280-jpatoscapolicy_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscapolicy_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0290-jpatoscapolicy_properties.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscapolicy_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL) -------------- > upgrade 0300-jpatoscapolicy_targets.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscapolicy_targets (name VARCHAR(120) NULL, version VARCHAR(20) NULL) -------------- > upgrade 0310-jpatoscapolicytype_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscapolicytype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0320-jpatoscapolicytype_properties.sql -------------- 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) -------------- > upgrade 0330-jpatoscapolicytype_targets.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscapolicytype_targets (name VARCHAR(120) NULL, version VARCHAR(20) NULL) -------------- > upgrade 0340-jpatoscapolicytype_triggers.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscapolicytype_triggers (name VARCHAR(120) NULL, version VARCHAR(20) NULL, TRIGGERS VARCHAR(255) NULL) -------------- > upgrade 0350-jpatoscaproperty_constraints.sql -------------- 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) -------------- > upgrade 0360-jpatoscaproperty_metadata.sql -------------- 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) -------------- > upgrade 0370-jpatoscarelationshiptype_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscarelationshiptype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0380-jpatoscarelationshiptype_properties.sql -------------- 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) -------------- > upgrade 0390-jpatoscarequirement_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscarequirement_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0400-jpatoscarequirement_occurrences.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscarequirement_occurrences (name VARCHAR(120) NULL, version VARCHAR(20) NULL, OCCURRENCES INT DEFAULT NULL NULL) -------------- > upgrade 0410-jpatoscarequirement_properties.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscarequirement_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL) -------------- > upgrade 0420-jpatoscaservicetemplate_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscaservicetemplate_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0430-jpatoscatopologytemplate_inputs.sql -------------- 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) -------------- > upgrade 0440-pdpgroup_pdpsubgroup.sql -------------- 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)) -------------- > upgrade 0450-pdpgroup.sql -------------- 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)) -------------- > upgrade 0460-pdppolicystatus.sql -------------- 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)) -------------- > upgrade 0470-pdp.sql -------------- 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)) -------------- > upgrade 0480-pdpstatistics.sql -------------- 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 NOT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (timeStamp, name, version)) -------------- > upgrade 0490-pdpsubgroup_pdp.sql -------------- 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)) -------------- > upgrade 0500-pdpsubgroup.sql -------------- 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)) -------------- > upgrade 0510-toscacapabilityassignment.sql -------------- 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)) -------------- > upgrade 0520-toscacapabilityassignments.sql -------------- CREATE TABLE IF NOT EXISTS toscacapabilityassignments (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCACAPABILITYASSIGNMENTS PRIMARY KEY (name, version)) -------------- > upgrade 0530-toscacapabilityassignments_toscacapabilityassignment.sql -------------- 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)) -------------- > upgrade 0540-toscacapabilitytype.sql -------------- 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)) -------------- > upgrade 0550-toscacapabilitytypes.sql -------------- CREATE TABLE IF NOT EXISTS toscacapabilitytypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCACAPABILITYTYPES PRIMARY KEY (name, version)) -------------- > upgrade 0560-toscacapabilitytypes_toscacapabilitytype.sql -------------- 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)) -------------- > upgrade 0570-toscadatatype.sql -------------- 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)) -------------- > upgrade 0580-toscadatatypes.sql -------------- CREATE TABLE IF NOT EXISTS toscadatatypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCADATATYPES PRIMARY KEY (name, version)) -------------- > upgrade 0590-toscadatatypes_toscadatatype.sql -------------- CREATE TABLE IF NOT EXISTS toscadatatypes_toscadatatype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCADATATYPES_TOSCADATATYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion)) -------------- > upgrade 0600-toscanodetemplate.sql -------------- 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)) -------------- > upgrade 0610-toscanodetemplates.sql -------------- CREATE TABLE IF NOT EXISTS toscanodetemplates (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCANODETEMPLATES PRIMARY KEY (name, version)) -------------- > upgrade 0620-toscanodetemplates_toscanodetemplate.sql -------------- 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)) -------------- > upgrade 0630-toscanodetype.sql -------------- 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)) -------------- > upgrade 0640-toscanodetypes.sql -------------- CREATE TABLE IF NOT EXISTS toscanodetypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCANODETYPES PRIMARY KEY (name, version)) -------------- > upgrade 0650-toscanodetypes_toscanodetype.sql -------------- 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)) -------------- > upgrade 0660-toscaparameter.sql -------------- 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)) -------------- > upgrade 0670-toscapolicies.sql -------------- CREATE TABLE IF NOT EXISTS toscapolicies (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAPOLICIES PRIMARY KEY (name, version)) -------------- > upgrade 0680-toscapolicies_toscapolicy.sql -------------- 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)) -------------- > upgrade 0690-toscapolicy.sql -------------- 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)) -------------- > upgrade 0700-toscapolicytype.sql -------------- 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)) -------------- > upgrade 0710-toscapolicytypes.sql -------------- CREATE TABLE IF NOT EXISTS toscapolicytypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAPOLICYTYPES PRIMARY KEY (name, version)) -------------- > upgrade 0720-toscapolicytypes_toscapolicytype.sql -------------- 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)) -------------- > upgrade 0730-toscaproperty.sql -------------- 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)) -------------- > upgrade 0740-toscarelationshiptype.sql -------------- 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)) -------------- > upgrade 0750-toscarelationshiptypes.sql -------------- CREATE TABLE IF NOT EXISTS toscarelationshiptypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCARELATIONSHIPTYPES PRIMARY KEY (name, version)) -------------- > upgrade 0760-toscarelationshiptypes_toscarelationshiptype.sql -------------- 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)) -------------- > upgrade 0770-toscarequirement.sql -------------- 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)) -------------- > upgrade 0780-toscarequirements.sql -------------- CREATE TABLE IF NOT EXISTS toscarequirements (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAREQUIREMENTS PRIMARY KEY (name, version)) -------------- > upgrade 0790-toscarequirements_toscarequirement.sql -------------- 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)) -------------- > upgrade 0800-toscaservicetemplate.sql -------------- 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)) -------------- > upgrade 0810-toscatopologytemplate.sql -------------- 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)) -------------- > upgrade 0820-toscatrigger.sql -------------- 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)) -------------- > upgrade 0830-FK_ToscaNodeTemplate_capabilitiesName.sql -------------- CREATE INDEX FK_ToscaNodeTemplate_capabilitiesName ON toscanodetemplate(capabilitiesName, capabilitiesVersion) -------------- > upgrade 0840-FK_ToscaNodeTemplate_requirementsName.sql -------------- CREATE INDEX FK_ToscaNodeTemplate_requirementsName ON toscanodetemplate(requirementsName, requirementsVersion) -------------- > upgrade 0850-FK_ToscaNodeType_requirementsName.sql -------------- CREATE INDEX FK_ToscaNodeType_requirementsName ON toscanodetype(requirementsName, requirementsVersion) -------------- > upgrade 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql -------------- CREATE INDEX FK_ToscaServiceTemplate_capabilityTypesName ON toscaservicetemplate(capabilityTypesName, capabilityTypesVersion) -------------- > upgrade 0870-FK_ToscaServiceTemplate_dataTypesName.sql -------------- CREATE INDEX FK_ToscaServiceTemplate_dataTypesName ON toscaservicetemplate(dataTypesName, dataTypesVersion) -------------- > upgrade 0880-FK_ToscaServiceTemplate_nodeTypesName.sql -------------- CREATE INDEX FK_ToscaServiceTemplate_nodeTypesName ON toscaservicetemplate(nodeTypesName, nodeTypesVersion) -------------- > upgrade 0890-FK_ToscaServiceTemplate_policyTypesName.sql -------------- CREATE INDEX FK_ToscaServiceTemplate_policyTypesName ON toscaservicetemplate(policyTypesName, policyTypesVersion) -------------- > upgrade 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql -------------- CREATE INDEX FK_ToscaServiceTemplate_relationshipTypesName ON toscaservicetemplate(relationshipTypesName, relationshipTypesVersion) -------------- > upgrade 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql -------------- CREATE INDEX FK_ToscaTopologyTemplate_nodeTemplatesName ON toscatopologytemplate(nodeTemplatesName, nodeTemplatessVersion) -------------- > upgrade 0920-FK_ToscaTopologyTemplate_policyName.sql -------------- CREATE INDEX FK_ToscaTopologyTemplate_policyName ON toscatopologytemplate(policyName, policyVersion) -------------- > upgrade 0940-PdpPolicyStatus_PdpGroup.sql -------------- CREATE INDEX PdpPolicyStatus_PdpGroup ON pdppolicystatus(PDPGROUP) -------------- > upgrade 0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql -------------- CREATE INDEX TscaServiceTemplatetopologyTemplateParentLocalName ON toscaservicetemplate(topologyTemplateParentLocalName, topologyTemplateLocalName, topologyTemplateParentKeyVersion, topologyTemplateParentKeyName) -------------- > upgrade 0960-FK_ToscaNodeTemplate_capabilitiesName.sql -------------- ALTER TABLE toscanodetemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES toscacapabilityassignments (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 0970-FK_ToscaNodeTemplate_requirementsName.sql -------------- ALTER TABLE toscanodetemplate ADD CONSTRAINT FK_ToscaNodeTemplate_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES toscarequirements (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 0980-FK_ToscaNodeType_requirementsName.sql -------------- ALTER TABLE toscanodetype ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES toscarequirements (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 0990-FK_ToscaServiceTemplate_capabilityTypesName.sql -------------- ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_capabilityTypesName FOREIGN KEY (capabilityTypesName, capabilityTypesVersion) REFERENCES toscacapabilitytypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 1000-FK_ToscaServiceTemplate_dataTypesName.sql -------------- ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES toscadatatypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 1010-FK_ToscaServiceTemplate_nodeTypesName.sql -------------- ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_nodeTypesName FOREIGN KEY (nodeTypesName, nodeTypesVersion) REFERENCES toscanodetypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 1020-FK_ToscaServiceTemplate_policyTypesName.sql -------------- ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_policyTypesName FOREIGN KEY (policyTypesName, policyTypesVersion) REFERENCES toscapolicytypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 1030-FK_ToscaServiceTemplate_relationshipTypesName.sql -------------- ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_relationshipTypesName FOREIGN KEY (relationshipTypesName, relationshipTypesVersion) REFERENCES toscarelationshiptypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql -------------- ALTER TABLE toscatopologytemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_nodeTemplatesName FOREIGN KEY (nodeTemplatesName, nodeTemplatessVersion) REFERENCES toscanodetemplates (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 1050-FK_ToscaTopologyTemplate_policyName.sql -------------- ALTER TABLE toscatopologytemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES toscapolicies (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql -------------- ALTER TABLE toscaservicetemplate ADD CONSTRAINT TscaServiceTemplatetopologyTemplateParentLocalName FOREIGN KEY (topologyTemplateParentLocalName, topologyTemplateLocalName, topologyTemplateParentKeyVersion, topologyTemplateParentKeyName) REFERENCES toscatopologytemplate (parentLocalName, localName, parentKeyVersion, parentKeyName) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 0100-pdp.sql -------------- ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER HEALTHY -------------- > upgrade 0110-idx_tsidx1.sql -------------- CREATE INDEX IDX_TSIDX1 ON pdpstatistics(timeStamp, name, version) -------------- > upgrade 0120-pk_pdpstatistics.sql -------------- ALTER TABLE pdpstatistics DROP PRIMARY KEY -------------- > upgrade 0130-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics ADD COLUMN POLICYUNDEPLOYCOUNT BIGINT DEFAULT NULL NULL AFTER POLICYEXECUTEDSUCCESSCOUNT, ADD COLUMN POLICYUNDEPLOYFAILCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN POLICYUNDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN ID BIGINT NOT NULL -------------- > upgrade 0140-pk_pdpstatistics.sql -------------- UPDATE pdpstatistics as p JOIN (SELECT name, version, timeStamp, ROW_NUMBER() OVER (ORDER BY timeStamp ASC) AS row_num FROM pdpstatistics GROUP BY name, version, timeStamp) AS t ON (p.name=t.name AND p.version=t.version AND p.timeStamp = t.timeStamp) SET p.id=t.row_num -------------- -------------- ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version) -------------- > upgrade 0150-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime(6) NULL -------------- > upgrade 0160-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN ID BIGINT DEFAULT NULL NULL AFTER UPTIME -------------- > upgrade 0170-jpapdpstatistics_enginestats.sql -------------- UPDATE jpapdpstatistics_enginestats a JOIN pdpstatistics b ON a.name = b.name AND a.version = b.version AND a.timeStamp = b.timeStamp SET a.id = b.id -------------- > upgrade 0180-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN timeStamp -------------- > upgrade 0190-jpapolicyaudit.sql -------------- 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)) -------------- > upgrade 0200-JpaPolicyAuditIndex_timestamp.sql -------------- CREATE INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit(TIMESTAMP) -------------- > upgrade 0210-sequence.sql -------------- 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)) -------------- > upgrade 0220-sequence.sql -------------- INSERT INTO sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', (SELECT IFNULL(max(id),0) FROM pdpstatistics)) -------------- policyadmin: OK: upgrade (0900) Ending test 1 109 0220-sequence.sql upgrade 0800 0900 2303221010480900u 1 2022-03-23 10:10:54 policyadmin: upgrade available: 0900 -> 1000 Test summary: status:1, operation:upgrade, from:0, to:0900, new executions:109, sqlFiles:109 *** Test 1: PASS , Successful upgrade, current version: 0900 *** ############################################################################################################ Starting test 2 109 0220-sequence.sql upgrade 0800 0900 2303221010480900u 1 2022-03-23 10:10:54 policyadmin: upgrade available: 0900 -> 1000 Done downgrade: 0900 -> 0800 > downgrade 0220-sequence.sql -------------- DELETE from sequence -------------- > downgrade 0210-sequence.sql -------------- DROP TABLE IF EXISTS `sequence` -------------- > downgrade 0200-JpaPolicyAuditIndex_timestamp.sql -------------- ALTER TABLE jpapolicyaudit DROP INDEX JpaPolicyAuditIndex_timestamp -------------- > downgrade 0190-jpapolicyaudit.sql -------------- DROP TABLE IF EXISTS `jpapolicyaudit` -------------- > downgrade 0180-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN timeStamp datetime(6) DEFAULT NULL NULL AFTER UPTIME -------------- > downgrade 0170-jpapdpstatistics_enginestats.sql -------------- UPDATE jpapdpstatistics_enginestats a JOIN pdpstatistics b ON a.name = b.name AND a.version = b.version AND a.id = b.id SET a.timeStamp = b.timeStamp -------------- > downgrade 0160-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN ID -------------- > downgrade 0150-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime(6) NOT NULL -------------- > downgrade 0140-pk_pdpstatistics.sql -------------- ALTER TABLE pdpstatistics DROP CONSTRAINT PRIMARY KEY -------------- -------------- UPDATE pdpstatistics set ID = 0 -------------- > downgrade 0130-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics DROP COLUMN POLICYUNDEPLOYCOUNT, DROP COLUMN POLICYUNDEPLOYFAILCOUNT, DROP COLUMN POLICYUNDEPLOYSUCCESSCOUNT, DROP COLUMN ID -------------- > downgrade 0120-pk_pdpstatistics.sql -------------- ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (timeStamp, name, version) -------------- > downgrade 0110-idx_tsidx1.sql -------------- DROP INDEX IDX_TSIDX1 ON pdpstatistics -------------- > downgrade 0100-pdp.sql -------------- ALTER TABLE pdp DROP COLUMN LASTUPDATE -------------- policyadmin: OK: downgrade (0800) Ending test 2 122 0100-pdp.sql downgrade 0900 0800 2303221011000900d 1 2022-03-23 10:11:00 policyadmin: downgrade available: 0800 -> 0 Test summary: status:1, operation:downgrade, from:0900, to:0800, new executions:13, sqlFiles:13 *** Test 2: PASS , Successful downgrade, current version: 0800 *** ############################################################################################################ Starting test 3 122 0100-pdp.sql downgrade 0900 0800 2303221011000900d 1 2022-03-23 10:11:00 policyadmin: downgrade available: 0800 -> 0 Done upgrade: 0800 -> 0900 > upgrade 0100-pdp.sql -------------- ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER HEALTHY -------------- > upgrade 0110-idx_tsidx1.sql -------------- CREATE INDEX IDX_TSIDX1 ON pdpstatistics(timeStamp, name, version) -------------- > upgrade 0120-pk_pdpstatistics.sql -------------- ALTER TABLE pdpstatistics DROP PRIMARY KEY -------------- > upgrade 0130-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics ADD COLUMN POLICYUNDEPLOYCOUNT BIGINT DEFAULT NULL NULL AFTER POLICYEXECUTEDSUCCESSCOUNT, ADD COLUMN POLICYUNDEPLOYFAILCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN POLICYUNDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN ID BIGINT NOT NULL -------------- > upgrade 0140-pk_pdpstatistics.sql -------------- UPDATE pdpstatistics as p JOIN (SELECT name, version, timeStamp, ROW_NUMBER() OVER (ORDER BY timeStamp ASC) AS row_num FROM pdpstatistics GROUP BY name, version, timeStamp) AS t ON (p.name=t.name AND p.version=t.version AND p.timeStamp = t.timeStamp) SET p.id=t.row_num -------------- -------------- ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version) -------------- > upgrade 0150-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime(6) NULL -------------- > upgrade 0160-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN ID BIGINT DEFAULT NULL NULL AFTER UPTIME -------------- > upgrade 0170-jpapdpstatistics_enginestats.sql -------------- UPDATE jpapdpstatistics_enginestats a JOIN pdpstatistics b ON a.name = b.name AND a.version = b.version AND a.timeStamp = b.timeStamp SET a.id = b.id -------------- > upgrade 0180-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN timeStamp -------------- > upgrade 0190-jpapolicyaudit.sql -------------- 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)) -------------- > upgrade 0200-JpaPolicyAuditIndex_timestamp.sql -------------- CREATE INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit(TIMESTAMP) -------------- > upgrade 0210-sequence.sql -------------- 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)) -------------- > upgrade 0220-sequence.sql -------------- INSERT INTO sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', (SELECT IFNULL(max(id),0) FROM pdpstatistics)) -------------- policyadmin: OK: upgrade (0900) Ending test 3 135 0220-sequence.sql upgrade 0800 0900 2303221011060900u 1 2022-03-23 10:11:07 policyadmin: upgrade available: 0900 -> 1000 Test summary: status:1, operation:upgrade, from:0800, to:0900, new executions:13, sqlFiles:13 *** Test 3: PASS , Successful upgrade, current version: 0900 *** ############################################################################################################ Starting test 4 135 0220-sequence.sql upgrade 0800 0900 2303221011060900u 1 2022-03-23 10:11:07 policyadmin: upgrade available: 0900 -> 1000 Done downgrade: 0900 -> 0800 > downgrade 0220-sequence.sql -------------- DELETE from sequence -------------- > downgrade 0210-sequence.sql -------------- DROP TABLE IF EXISTS `sequence` -------------- > downgrade 0200-JpaPolicyAuditIndex_timestamp.sql -------------- ALTER TABLE jpapolicyaudit DROP INDEX JpaPolicyAuditIndex_timestamp -------------- > downgrade 0190-jpapolicyaudit.sql -------------- DROP TABLE IF EXISTS `jpapolicyaudit` -------------- > downgrade 0180-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN timeStamp datetime(6) DEFAULT NULL NULL AFTER UPTIME -------------- > downgrade 0170-jpapdpstatistics_enginestats.sql -------------- UPDATE jpapdpstatistics_enginestats a JOIN pdpstatistics b ON a.name = b.name AND a.version = b.version AND a.id = b.id SET a.timeStamp = b.timeStamp -------------- > downgrade 0160-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN ID -------------- > downgrade 0150-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime(6) NOT NULL -------------- > downgrade 0140-pk_pdpstatistics.sql -------------- ALTER TABLE pdpstatistics DROP CONSTRAINT PRIMARY KEY -------------- -------------- UPDATE pdpstatistics set ID = 0 -------------- > downgrade 0130-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics DROP COLUMN POLICYUNDEPLOYCOUNT, DROP COLUMN POLICYUNDEPLOYFAILCOUNT, DROP COLUMN POLICYUNDEPLOYSUCCESSCOUNT, DROP COLUMN ID -------------- > downgrade 0120-pk_pdpstatistics.sql -------------- ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (timeStamp, name, version) -------------- > downgrade 0110-idx_tsidx1.sql -------------- DROP INDEX IDX_TSIDX1 ON pdpstatistics -------------- > downgrade 0100-pdp.sql -------------- ALTER TABLE pdp DROP COLUMN LASTUPDATE -------------- policyadmin: OK: downgrade (0800) Done upgrade: 0800 -> 0900 > upgrade 0100-pdp.sql -------------- ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER HEALTHY -------------- > upgrade 0110-idx_tsidx1.sql -------------- CREATE INDEX IDX_TSIDX1 ON pdpstatistics(timeStamp, name, version) -------------- > upgrade 0120-pk_pdpstatistics.sql -------------- ALTER TABLE pdpstatistics DROP PRIMARY KEY -------------- > upgrade 0130-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics ADD COLUMN POLICYUNDEPLOYCOUNT BIGINT DEFAULT NULL NULL AFTER POLICYEXECUTEDSUCCESSCOUNT, ADD COLUMN POLICYUNDEPLOYFAILCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN POLICYUNDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN ID BIGINT NOT NULL -------------- > upgrade 0140-pk_pdpstatistics.sql -------------- UPDATE pdpstatistics as p JOIN (SELECT name, version, timeStamp, ROW_NUMBER() OVER (ORDER BY timeStamp ASC) AS row_num FROM pdpstatistics GROUP BY name, version, timeStamp) AS t ON (p.name=t.name AND p.version=t.version AND p.timeStamp = t.timeStamp) SET p.id=t.row_num -------------- -------------- ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version) -------------- > upgrade 0150-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime(6) NULL -------------- > upgrade 0160-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN ID BIGINT DEFAULT NULL NULL AFTER UPTIME -------------- > upgrade 0170-jpapdpstatistics_enginestats.sql -------------- UPDATE jpapdpstatistics_enginestats a JOIN pdpstatistics b ON a.name = b.name AND a.version = b.version AND a.timeStamp = b.timeStamp SET a.id = b.id -------------- > upgrade 0180-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN timeStamp -------------- > upgrade 0190-jpapolicyaudit.sql -------------- 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)) -------------- > upgrade 0200-JpaPolicyAuditIndex_timestamp.sql -------------- CREATE INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit(TIMESTAMP) -------------- > upgrade 0210-sequence.sql -------------- 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)) -------------- > upgrade 0220-sequence.sql -------------- INSERT INTO sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', (SELECT IFNULL(max(id),0) FROM pdpstatistics)) -------------- policyadmin: OK: upgrade (0900) Ending test 4 13 0220-sequence.sql upgrade 0800 0900 2303221011130900u 1 2022-03-23 10:11:14 policyadmin: upgrade available: 0900 -> 1000 Test summary: status:1, operation:upgrade, from:0800, to:0900, new executions:13, sqlFiles:13 *** Test 4: PASS , Successful upgrade, current version: 0900 *** ############################################################################################################ Starting test 5 13 0220-sequence.sql upgrade 0800 0900 2303221011130900u 1 2022-03-23 10:11:14 policyadmin: upgrade available: 0900 -> 1000 Done downgrade: 0900 -> 0800 > downgrade 0220-sequence.sql -------------- DELETE from sequence -------------- > downgrade 0210-sequence.sql -------------- DROP TABLE IF EXISTS `sequence` -------------- > downgrade 0200-JpaPolicyAuditIndex_timestamp.sql -------------- ALTER TABLE jpapolicyaudit DROP INDEX JpaPolicyAuditIndex_timestamp -------------- > downgrade 0190-jpapolicyaudit.sql -------------- DROP TABLE IF EXISTS `jpapolicyaudit` -------------- > downgrade 0180-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN timeStamp datetime(6) DEFAULT NULL NULL AFTER UPTIME -------------- > downgrade 0170-jpapdpstatistics_enginestats.sql -------------- UPDATE jpapdpstatistics_enginestats a JOIN pdpstatistics b ON a.name = b.name AND a.version = b.version AND a.id = b.id SET a.timeStamp = b.timeStamp -------------- policyadmin: downgrade aborted at 0900 by script 0170-jpapdpstatistics_enginestats.sql policyadmin: failure: downgrade to release 0800 (0900) Done Partial downgrade detected Upgrade will attempt to resume after 0170-jpapdpstatistics_enginestats.sql upgrade: 0800 -> 0900 > upgrade 0180-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN timeStamp -------------- > upgrade 0190-jpapolicyaudit.sql -------------- 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)) -------------- > upgrade 0200-JpaPolicyAuditIndex_timestamp.sql -------------- CREATE INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit(TIMESTAMP) -------------- > upgrade 0210-sequence.sql -------------- 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)) -------------- > upgrade 0220-sequence.sql -------------- INSERT INTO sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', (SELECT IFNULL(max(id),0) FROM pdpstatistics)) -------------- policyadmin: OK: upgrade (0900) Ending test 5 24 0220-sequence.sql upgrade 0800 0900 2303221011200900u 1 2022-03-23 10:11:20 policyadmin: upgrade available: 0900 -> 1000 Test summary: status:1, operation:upgrade, from:0800, to:0900, new executions:11, sqlFiles:11 *** Test 5: PASS , Successful upgrade, current version: 0900 *** ############################################################################################################ Starting test 6 24 0220-sequence.sql upgrade 0800 0900 2303221011200900u 1 2022-03-23 10:11:20 policyadmin: upgrade available: 0900 -> 1000 Done downgrade: 0900 -> 0800 > downgrade 0220-sequence.sql -------------- DELETE from sequence -------------- > downgrade 0210-sequence.sql -------------- DROP TABLE IF EXISTS `sequence` -------------- > downgrade 0200-JpaPolicyAuditIndex_timestamp.sql -------------- ALTER TABLE jpapolicyaudit DROP INDEX JpaPolicyAuditIndex_timestamp -------------- > downgrade 0190-jpapolicyaudit.sql -------------- DROP TABLE IF EXISTS `jpapolicyaudit` -------------- > downgrade 0180-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN timeStamp datetime(6) DEFAULT NULL NULL AFTER UPTIME -------------- > downgrade 0170-jpapdpstatistics_enginestats.sql -------------- UPDATE jpapdpstatistics_enginestats a JOIN pdpstatistics b ON a.name = b.name AND a.version = b.version AND a.id = b.id SET a.timeStamp = b.timeStamp -------------- policyadmin: downgrade aborted at 0900 by script 0170-jpapdpstatistics_enginestats.sql policyadmin: failure: downgrade to release 0800 (0900) Partial downgrade detected Downgrade will attempt to resume at 0170-jpapdpstatistics_enginestats.sql downgrade: 0900 -> 0800 > downgrade 0170-jpapdpstatistics_enginestats.sql -------------- UPDATE jpapdpstatistics_enginestats a JOIN pdpstatistics b ON a.name = b.name AND a.version = b.version AND a.id = b.id SET a.timeStamp = b.timeStamp -------------- > downgrade 0160-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN ID -------------- > downgrade 0150-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime(6) NOT NULL -------------- > downgrade 0140-pk_pdpstatistics.sql -------------- ALTER TABLE pdpstatistics DROP CONSTRAINT PRIMARY KEY -------------- -------------- UPDATE pdpstatistics set ID = 0 -------------- > downgrade 0130-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics DROP COLUMN POLICYUNDEPLOYCOUNT, DROP COLUMN POLICYUNDEPLOYFAILCOUNT, DROP COLUMN POLICYUNDEPLOYSUCCESSCOUNT, DROP COLUMN ID -------------- > downgrade 0120-pk_pdpstatistics.sql -------------- ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (timeStamp, name, version) -------------- > downgrade 0110-idx_tsidx1.sql -------------- DROP INDEX IDX_TSIDX1 ON pdpstatistics -------------- > downgrade 0100-pdp.sql -------------- ALTER TABLE pdp DROP COLUMN LASTUPDATE -------------- policyadmin: OK: downgrade (0800) Ending test 6 38 0100-pdp.sql downgrade 0900 0800 2303221011260900d 1 2022-03-23 10:11:27 policyadmin: downgrade available: 0800 -> 0 Test summary: status:1, operation:downgrade, from:0900, to:0800, new executions:14, sqlFiles:14 *** Test 6: PASS , Successful downgrade, current version: 0800 *** ############################################################################################################ Starting test 7 38 0100-pdp.sql downgrade 0900 0800 2303221011260900d 1 2022-03-23 10:11:27 policyadmin: downgrade available: 0800 -> 0 Done upgrade: 0800 -> 0900 > upgrade 0100-pdp.sql -------------- ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER HEALTHY -------------- > upgrade 0110-idx_tsidx1.sql -------------- CREATE INDEX IDX_TSIDX1 ON pdpstatistics(timeStamp, name, version) -------------- policyadmin: upgrade aborted at 0900 by script 0110-idx_tsidx1.sql policyadmin: failure: upgrade to release 0900 (0900) Done Partial upgrade detected Downgrade will attempt to resume before 0110-idx_tsidx1.sql downgrade: 0900 -> 0800 > downgrade 0100-pdp.sql -------------- ALTER TABLE pdp DROP COLUMN LASTUPDATE -------------- policyadmin: OK: downgrade (0800) Ending test 7 41 0100-pdp.sql downgrade 0900 0800 2303221011330900d 1 2022-03-23 10:11:33 policyadmin: downgrade available: 0800 -> 0 Test summary: status:1, operation:downgrade, from:0800, to:0800, new executions:3, sqlFiles:3 *** Test 7: PASS , Successful downgrade, current version: 0800 *** ############################################################################################################ Starting test 8 41 0100-pdp.sql downgrade 0900 0800 2303221011330900d 1 2022-03-23 10:11:33 policyadmin: downgrade available: 0800 -> 0 Done upgrade: 0800 -> 0900 > upgrade 0100-pdp.sql -------------- ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER HEALTHY -------------- > upgrade 0110-idx_tsidx1.sql -------------- CREATE INDEX IDX_TSIDX1 ON pdpstatistics(timeStamp, name, version) -------------- policyadmin: upgrade aborted at 0900 by script 0110-idx_tsidx1.sql policyadmin: failure: upgrade to release 0900 (0900) Partial upgrade detected Upgrade will attempt to resume at 0110-idx_tsidx1.sql upgrade: 0800 -> 0900 > upgrade 0110-idx_tsidx1.sql -------------- CREATE INDEX IDX_TSIDX1 ON pdpstatistics(timeStamp, name, version) -------------- > upgrade 0120-pk_pdpstatistics.sql -------------- ALTER TABLE pdpstatistics DROP PRIMARY KEY -------------- > upgrade 0130-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics ADD COLUMN POLICYUNDEPLOYCOUNT BIGINT DEFAULT NULL NULL AFTER POLICYEXECUTEDSUCCESSCOUNT, ADD COLUMN POLICYUNDEPLOYFAILCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN POLICYUNDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN ID BIGINT NOT NULL -------------- > upgrade 0140-pk_pdpstatistics.sql -------------- UPDATE pdpstatistics as p JOIN (SELECT name, version, timeStamp, ROW_NUMBER() OVER (ORDER BY timeStamp ASC) AS row_num FROM pdpstatistics GROUP BY name, version, timeStamp) AS t ON (p.name=t.name AND p.version=t.version AND p.timeStamp = t.timeStamp) SET p.id=t.row_num -------------- -------------- ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version) -------------- > upgrade 0150-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime(6) NULL -------------- > upgrade 0160-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN ID BIGINT DEFAULT NULL NULL AFTER UPTIME -------------- > upgrade 0170-jpapdpstatistics_enginestats.sql -------------- UPDATE jpapdpstatistics_enginestats a JOIN pdpstatistics b ON a.name = b.name AND a.version = b.version AND a.timeStamp = b.timeStamp SET a.id = b.id -------------- > upgrade 0180-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN timeStamp -------------- > upgrade 0190-jpapolicyaudit.sql -------------- 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)) -------------- > upgrade 0200-JpaPolicyAuditIndex_timestamp.sql -------------- CREATE INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit(TIMESTAMP) -------------- > upgrade 0210-sequence.sql -------------- 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)) -------------- > upgrade 0220-sequence.sql -------------- INSERT INTO sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', (SELECT IFNULL(max(id),0) FROM pdpstatistics)) -------------- policyadmin: OK: upgrade (0900) Ending test 8 55 0220-sequence.sql upgrade 0800 0900 2303221011390900u 1 2022-03-23 10:11:40 policyadmin: upgrade available: 0900 -> 1000 Test summary: status:1, operation:upgrade, from:0800, to:0900, new executions:14, sqlFiles:14 *** Test 8: PASS , Successful upgrade, current version: 0900 *** Done downgrade: 0900 -> 0800 > downgrade 0220-sequence.sql -------------- DELETE from sequence -------------- > downgrade 0210-sequence.sql -------------- DROP TABLE IF EXISTS `sequence` -------------- > downgrade 0200-JpaPolicyAuditIndex_timestamp.sql -------------- ALTER TABLE jpapolicyaudit DROP INDEX JpaPolicyAuditIndex_timestamp -------------- > downgrade 0190-jpapolicyaudit.sql -------------- DROP TABLE IF EXISTS `jpapolicyaudit` -------------- > downgrade 0180-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN timeStamp datetime(6) DEFAULT NULL NULL AFTER UPTIME -------------- > downgrade 0170-jpapdpstatistics_enginestats.sql -------------- UPDATE jpapdpstatistics_enginestats a JOIN pdpstatistics b ON a.name = b.name AND a.version = b.version AND a.id = b.id SET a.timeStamp = b.timeStamp -------------- > downgrade 0160-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN ID -------------- > downgrade 0150-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime(6) NOT NULL -------------- > downgrade 0140-pk_pdpstatistics.sql -------------- ALTER TABLE pdpstatistics DROP CONSTRAINT PRIMARY KEY -------------- -------------- UPDATE pdpstatistics set ID = 0 -------------- > downgrade 0130-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics DROP COLUMN POLICYUNDEPLOYCOUNT, DROP COLUMN POLICYUNDEPLOYFAILCOUNT, DROP COLUMN POLICYUNDEPLOYSUCCESSCOUNT, DROP COLUMN ID -------------- > downgrade 0120-pk_pdpstatistics.sql -------------- ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (timeStamp, name, version) -------------- > downgrade 0110-idx_tsidx1.sql -------------- DROP INDEX IDX_TSIDX1 ON pdpstatistics -------------- > downgrade 0100-pdp.sql -------------- ALTER TABLE pdp DROP COLUMN LASTUPDATE -------------- policyadmin: OK: downgrade (0800) ############################################################################################################ Starting test 9 68 0100-pdp.sql downgrade 0900 0800 2303221011450900d 1 2022-03-23 10:11:46 policyadmin: downgrade available: 0800 -> 0 Done upgrade: 0800 -> 0900 > upgrade 0100-pdp.sql -------------- ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER HEALTHY -------------- > upgrade 0110-idx_tsidx1.sql -------------- CREATE INDEX IDX_TSIDX1 ON pdpstatistics(timeStamp, name, version) -------------- > upgrade 0120-pk_pdpstatistics.sql -------------- ALTER TABLE pdpstatistics DROP PRIMARY KEY -------------- > upgrade 0130-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics ADD COLUMN POLICYUNDEPLOYCOUNT BIGINT DEFAULT NULL NULL AFTER POLICYEXECUTEDSUCCESSCOUNT, ADD COLUMN POLICYUNDEPLOYFAILCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN POLICYUNDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN ID BIGINT NOT NULL -------------- > upgrade 0140-pk_pdpstatistics.sql -------------- UPDATE pdpstatistics as p JOIN (SELECT name, version, timeStamp, ROW_NUMBER() OVER (ORDER BY timeStamp ASC) AS row_num FROM pdpstatistics GROUP BY name, version, timeStamp) AS t ON (p.name=t.name AND p.version=t.version AND p.timeStamp = t.timeStamp) SET p.id=t.row_num -------------- -------------- ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version) -------------- > upgrade 0150-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime(6) NULL -------------- > upgrade 0160-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN ID BIGINT DEFAULT NULL NULL AFTER UPTIME -------------- > upgrade 0170-jpapdpstatistics_enginestats.sql -------------- UPDATE jpapdpstatistics_enginestats a JOIN pdpstatistics b ON a.name = b.name AND a.version = b.version AND a.timeStamp = b.timeStamp SET a.id = b.id -------------- > upgrade 0180-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN timeStamp -------------- > upgrade 0190-jpapolicyaudit.sql -------------- 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)) -------------- > upgrade 0200-JpaPolicyAuditIndex_timestamp.sql -------------- CREATE INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit(TIMESTAMP) -------------- > upgrade 0210-sequence.sql -------------- 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)) -------------- > upgrade 0220-sequence.sql -------------- INSERT INTO sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', (SELECT IFNULL(max(id),0) FROM pdpstatistics)) -------------- policyadmin: OK: upgrade (0900) Ending test 9 81 0220-sequence.sql upgrade 0800 0900 2303221011490900u 1 2022-03-23 10:11:49 policyadmin: upgrade available: 0900 -> 1000 Test summary: status:1, operation:upgrade, from:0800, to:0900, new executions:13, sqlFiles:13 *** Test 9: PASS , Successful upgrade, current version: 0900 *** ############################################################################################################ Starting test 10 81 0220-sequence.sql upgrade 0800 0900 2303221011490900u 1 2022-03-23 10:11:49 policyadmin: upgrade available: 0900 -> 1000 Done downgrade: 0900 -> 0800 > downgrade 0220-sequence.sql -------------- DELETE from sequence -------------- > downgrade 0210-sequence.sql -------------- DROP TABLE IF EXISTS `sequence` -------------- > downgrade 0200-JpaPolicyAuditIndex_timestamp.sql -------------- ALTER TABLE jpapolicyaudit DROP INDEX JpaPolicyAuditIndex_timestamp -------------- > downgrade 0190-jpapolicyaudit.sql -------------- DROP TABLE IF EXISTS `jpapolicyaudit` -------------- > downgrade 0180-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN timeStamp datetime(6) DEFAULT NULL NULL AFTER UPTIME -------------- > downgrade 0170-jpapdpstatistics_enginestats.sql -------------- UPDATE jpapdpstatistics_enginestats a JOIN pdpstatistics b ON a.name = b.name AND a.version = b.version AND a.id = b.id SET a.timeStamp = b.timeStamp -------------- > downgrade 0160-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN ID -------------- > downgrade 0150-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime(6) NOT NULL -------------- > downgrade 0140-pk_pdpstatistics.sql -------------- ALTER TABLE pdpstatistics DROP CONSTRAINT PRIMARY KEY -------------- -------------- UPDATE pdpstatistics set ID = 0 -------------- > downgrade 0130-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics DROP COLUMN POLICYUNDEPLOYCOUNT, DROP COLUMN POLICYUNDEPLOYFAILCOUNT, DROP COLUMN POLICYUNDEPLOYSUCCESSCOUNT, DROP COLUMN ID -------------- > downgrade 0120-pk_pdpstatistics.sql -------------- ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (timeStamp, name, version) -------------- > downgrade 0110-idx_tsidx1.sql -------------- DROP INDEX IDX_TSIDX1 ON pdpstatistics -------------- > downgrade 0100-pdp.sql -------------- ALTER TABLE pdp DROP COLUMN LASTUPDATE -------------- policyadmin: OK: downgrade (0800) Ending test 10 94 0100-pdp.sql downgrade 0900 0800 2303221011560900d 1 2022-03-23 10:11:56 policyadmin: downgrade available: 0800 -> 0 Test summary: status:1, operation:downgrade, from:0900, to:0800, new executions:13, sqlFiles:13 *** Test 10: PASS , Successful downgrade, current version: 0800 *** ############################################################################################################ Starting test 11 94 0100-pdp.sql downgrade 0900 0800 2303221011560900d 1 2022-03-23 10:11:56 policyadmin: downgrade available: 0800 -> 0 Done downgrade: 0800 -> 0 > downgrade 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql -------------- ALTER TABLE toscaservicetemplate DROP CONSTRAINT TscaServiceTemplatetopologyTemplateParentLocalName -------------- > downgrade 1050-FK_ToscaTopologyTemplate_policyName.sql -------------- ALTER TABLE toscatopologytemplate DROP CONSTRAINT FK_ToscaTopologyTemplate_policyName -------------- > downgrade 1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql -------------- ALTER TABLE toscatopologytemplate DROP CONSTRAINT FK_ToscaTopologyTemplate_nodeTemplatesName -------------- > downgrade 1030-FK_ToscaServiceTemplate_relationshipTypesName.sql -------------- ALTER TABLE toscaservicetemplate DROP CONSTRAINT FK_ToscaServiceTemplate_relationshipTypesName -------------- > downgrade 1020-FK_ToscaServiceTemplate_policyTypesName.sql -------------- ALTER TABLE toscaservicetemplate DROP CONSTRAINT FK_ToscaServiceTemplate_policyTypesName -------------- > downgrade 1010-FK_ToscaServiceTemplate_nodeTypesName.sql -------------- ALTER TABLE toscaservicetemplate DROP CONSTRAINT FK_ToscaServiceTemplate_nodeTypesName -------------- > downgrade 1000-FK_ToscaServiceTemplate_dataTypesName.sql -------------- ALTER TABLE toscaservicetemplate DROP CONSTRAINT FK_ToscaServiceTemplate_dataTypesName -------------- > downgrade 0990-FK_ToscaServiceTemplate_capabilityTypesName.sql -------------- ALTER TABLE toscaservicetemplate DROP CONSTRAINT FK_ToscaServiceTemplate_capabilityTypesName -------------- > downgrade 0980-FK_ToscaNodeType_requirementsName.sql -------------- ALTER TABLE toscanodetype DROP CONSTRAINT FK_ToscaNodeType_requirementsName -------------- > downgrade 0970-FK_ToscaNodeTemplate_requirementsName.sql -------------- ALTER TABLE toscanodetemplate DROP CONSTRAINT FK_ToscaNodeTemplate_requirementsName -------------- > downgrade 0960-FK_ToscaNodeTemplate_capabilitiesName.sql -------------- ALTER TABLE toscanodetemplate DROP CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName -------------- > downgrade 0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql -------------- DROP INDEX TscaServiceTemplatetopologyTemplateParentLocalName ON toscaservicetemplate -------------- > downgrade 0940-PdpPolicyStatus_PdpGroup.sql -------------- DROP INDEX PdpPolicyStatus_PdpGroup ON pdppolicystatus -------------- > downgrade 0920-FK_ToscaTopologyTemplate_policyName.sql -------------- DROP INDEX FK_ToscaTopologyTemplate_policyName ON toscatopologytemplate -------------- > downgrade 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql -------------- DROP INDEX FK_ToscaTopologyTemplate_nodeTemplatesName ON toscatopologytemplate -------------- > downgrade 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql -------------- DROP INDEX FK_ToscaServiceTemplate_relationshipTypesName ON toscaservicetemplate -------------- > downgrade 0890-FK_ToscaServiceTemplate_policyTypesName.sql -------------- DROP INDEX FK_ToscaServiceTemplate_policyTypesName ON toscaservicetemplate -------------- > downgrade 0880-FK_ToscaServiceTemplate_nodeTypesName.sql -------------- DROP INDEX FK_ToscaServiceTemplate_nodeTypesName ON toscaservicetemplate -------------- > downgrade 0870-FK_ToscaServiceTemplate_dataTypesName.sql -------------- DROP INDEX FK_ToscaServiceTemplate_dataTypesName ON toscaservicetemplate -------------- > downgrade 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql -------------- DROP INDEX FK_ToscaServiceTemplate_capabilityTypesName ON toscaservicetemplate -------------- > downgrade 0850-FK_ToscaNodeType_requirementsName.sql -------------- DROP INDEX FK_ToscaNodeType_requirementsName ON toscanodetype -------------- > downgrade 0840-FK_ToscaNodeTemplate_requirementsName.sql -------------- DROP INDEX FK_ToscaNodeTemplate_requirementsName ON toscanodetemplate -------------- > downgrade 0830-FK_ToscaNodeTemplate_capabilitiesName.sql -------------- DROP INDEX FK_ToscaNodeTemplate_capabilitiesName ON toscanodetemplate -------------- > downgrade 0820-toscatrigger.sql -------------- DROP TABLE IF EXISTS `toscatrigger` -------------- > downgrade 0810-toscatopologytemplate.sql -------------- DROP TABLE IF EXISTS `toscatopologytemplate` -------------- > downgrade 0800-toscaservicetemplate.sql -------------- DROP TABLE IF EXISTS `toscaservicetemplate` -------------- > downgrade 0790-toscarequirements_toscarequirement.sql -------------- DROP TABLE IF EXISTS `toscarequirements_toscarequirement` -------------- > downgrade 0780-toscarequirements.sql -------------- DROP TABLE IF EXISTS `toscarequirements` -------------- > downgrade 0770-toscarequirement.sql -------------- DROP TABLE IF EXISTS `toscarequirement` -------------- > downgrade 0760-toscarelationshiptypes_toscarelationshiptype.sql -------------- DROP TABLE IF EXISTS `toscarelationshiptypes_toscarelationshiptype` -------------- > downgrade 0750-toscarelationshiptypes.sql -------------- DROP TABLE IF EXISTS `toscarelationshiptypes` -------------- > downgrade 0740-toscarelationshiptype.sql -------------- DROP TABLE IF EXISTS `toscarelationshiptype` -------------- > downgrade 0730-toscaproperty.sql -------------- DROP TABLE IF EXISTS `toscaproperty` -------------- > downgrade 0720-toscapolicytypes_toscapolicytype.sql -------------- DROP TABLE IF EXISTS `toscapolicytypes_toscapolicytype` -------------- > downgrade 0710-toscapolicytypes.sql -------------- DROP TABLE IF EXISTS `toscapolicytypes` -------------- > downgrade 0700-toscapolicytype.sql -------------- DROP TABLE IF EXISTS `toscapolicytype` -------------- > downgrade 0690-toscapolicy.sql -------------- DROP TABLE IF EXISTS `toscapolicy` -------------- > downgrade 0680-toscapolicies_toscapolicy.sql -------------- DROP TABLE IF EXISTS `toscapolicies_toscapolicy` -------------- > downgrade 0670-toscapolicies.sql -------------- DROP TABLE IF EXISTS `toscapolicies` -------------- > downgrade 0660-toscaparameter.sql -------------- DROP TABLE IF EXISTS `toscaparameter` -------------- > downgrade 0650-toscanodetypes_toscanodetype.sql -------------- DROP TABLE IF EXISTS `toscanodetypes_toscanodetype` -------------- > downgrade 0640-toscanodetypes.sql -------------- DROP TABLE IF EXISTS `toscanodetypes` -------------- > downgrade 0630-toscanodetype.sql -------------- DROP TABLE IF EXISTS `toscanodetype` -------------- > downgrade 0620-toscanodetemplates_toscanodetemplate.sql -------------- DROP TABLE IF EXISTS `toscanodetemplates_toscanodetemplate` -------------- > downgrade 0610-toscanodetemplates.sql -------------- DROP TABLE IF EXISTS `toscanodetemplates` -------------- > downgrade 0600-toscanodetemplate.sql -------------- DROP TABLE IF EXISTS `toscanodetemplate` -------------- > downgrade 0590-toscadatatypes_toscadatatype.sql -------------- DROP TABLE IF EXISTS `toscadatatypes_toscadatatype` -------------- > downgrade 0580-toscadatatypes.sql -------------- DROP TABLE IF EXISTS `toscadatatypes` -------------- > downgrade 0570-toscadatatype.sql -------------- DROP TABLE IF EXISTS `toscadatatype` -------------- > downgrade 0560-toscacapabilitytypes_toscacapabilitytype.sql -------------- DROP TABLE IF EXISTS `toscacapabilitytypes_toscacapabilitytype` -------------- > downgrade 0550-toscacapabilitytypes.sql -------------- DROP TABLE IF EXISTS `toscacapabilitytypes` -------------- > downgrade 0540-toscacapabilitytype.sql -------------- DROP TABLE IF EXISTS `toscacapabilitytype` -------------- > downgrade 0530-toscacapabilityassignments_toscacapabilityassignment.sql -------------- DROP TABLE IF EXISTS `toscacapabilityassignments_toscacapabilityassignment` -------------- > downgrade 0520-toscacapabilityassignments.sql -------------- DROP TABLE IF EXISTS `toscacapabilityassignments` -------------- > downgrade 0510-toscacapabilityassignment.sql -------------- DROP TABLE IF EXISTS `toscacapabilityassignment` -------------- > downgrade 0500-pdpsubgroup.sql -------------- DROP TABLE IF EXISTS `pdpsubgroup` -------------- > downgrade 0490-pdpsubgroup_pdp.sql -------------- DROP TABLE IF EXISTS `pdpsubgroup_pdp` -------------- > downgrade 0480-pdpstatistics.sql -------------- DROP TABLE IF EXISTS `pdpstatistics` -------------- > downgrade 0470-pdp.sql -------------- DROP TABLE IF EXISTS `pdp` -------------- > downgrade 0460-pdppolicystatus.sql -------------- DROP TABLE IF EXISTS `pdppolicystatus` -------------- > downgrade 0450-pdpgroup.sql -------------- DROP TABLE IF EXISTS `pdpgroup` -------------- > downgrade 0440-pdpgroup_pdpsubgroup.sql -------------- DROP TABLE IF EXISTS `pdpgroup_pdpsubgroup` -------------- > downgrade 0430-jpatoscatopologytemplate_inputs.sql -------------- DROP TABLE IF EXISTS `jpatoscatopologytemplate_inputs` -------------- > downgrade 0420-jpatoscaservicetemplate_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscaservicetemplate_metadata` -------------- > downgrade 0410-jpatoscarequirement_properties.sql -------------- DROP TABLE IF EXISTS `jpatoscarequirement_properties` -------------- > downgrade 0400-jpatoscarequirement_occurrences.sql -------------- DROP TABLE IF EXISTS `jpatoscarequirement_occurrences` -------------- > downgrade 0390-jpatoscarequirement_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscarequirement_metadata` -------------- > downgrade 0380-jpatoscarelationshiptype_properties.sql -------------- DROP TABLE IF EXISTS `jpatoscarelationshiptype_properties` -------------- > downgrade 0370-jpatoscarelationshiptype_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscarelationshiptype_metadata` -------------- > downgrade 0360-jpatoscaproperty_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscaproperty_metadata` -------------- > downgrade 0350-jpatoscaproperty_constraints.sql -------------- DROP TABLE IF EXISTS `jpatoscaproperty_constraints` -------------- > downgrade 0340-jpatoscapolicytype_triggers.sql -------------- DROP TABLE IF EXISTS `jpatoscapolicytype_triggers` -------------- > downgrade 0330-jpatoscapolicytype_targets.sql -------------- DROP TABLE IF EXISTS `jpatoscapolicytype_targets` -------------- > downgrade 0320-jpatoscapolicytype_properties.sql -------------- DROP TABLE IF EXISTS `jpatoscapolicytype_properties` -------------- > downgrade 0310-jpatoscapolicytype_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscapolicytype_metadata` -------------- > downgrade 0300-jpatoscapolicy_targets.sql -------------- DROP TABLE IF EXISTS `jpatoscapolicy_targets` -------------- > downgrade 0290-jpatoscapolicy_properties.sql -------------- DROP TABLE IF EXISTS `jpatoscapolicy_properties` -------------- > downgrade 0280-jpatoscapolicy_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscapolicy_metadata` -------------- > downgrade 0270-jpatoscanodetype_properties.sql -------------- DROP TABLE IF EXISTS `jpatoscanodetype_properties` -------------- > downgrade 0260-jpatoscanodetype_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscanodetype_metadata` -------------- > downgrade 0250-jpatoscanodetemplate_properties.sql -------------- DROP TABLE IF EXISTS `jpatoscanodetemplate_properties` -------------- > downgrade 0240-jpatoscanodetemplate_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscanodetemplate_metadata` -------------- > downgrade 0230-jpatoscadatatype_properties.sql -------------- DROP TABLE IF EXISTS `jpatoscadatatype_properties` -------------- > downgrade 0220-jpatoscadatatype_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscadatatype_metadata` -------------- > downgrade 0210-jpatoscadatatype_constraints.sql -------------- DROP TABLE IF EXISTS `jpatoscadatatype_constraints` -------------- > downgrade 0200-jpatoscacapabilitytype_properties.sql -------------- DROP TABLE IF EXISTS `jpatoscacapabilitytype_properties` -------------- > downgrade 0190-jpatoscacapabilitytype_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscacapabilitytype_metadata` -------------- > downgrade 0180-jpatoscacapabilityassignment_properties.sql -------------- DROP TABLE IF EXISTS `jpatoscacapabilityassignment_properties` -------------- > downgrade 0170-jpatoscacapabilityassignment_occurrences.sql -------------- DROP TABLE IF EXISTS `jpatoscacapabilityassignment_occurrences` -------------- > downgrade 0160-jpatoscacapabilityassignment_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscacapabilityassignment_metadata` -------------- > downgrade 0150-jpatoscacapabilityassignment_attributes.sql -------------- DROP TABLE IF EXISTS `jpatoscacapabilityassignment_attributes` -------------- > downgrade 0140-jpapdpsubgroup_supportedpolicytypes.sql -------------- DROP TABLE IF EXISTS `jpapdpsubgroup_supportedpolicytypes` -------------- > downgrade 0130-jpapdpsubgroup_properties.sql -------------- DROP TABLE IF EXISTS `jpapdpsubgroup_properties` -------------- > downgrade 0120-jpapdpsubgroup_policies.sql -------------- DROP TABLE IF EXISTS `jpapdpsubgroup_policies` -------------- > downgrade 0110-jpapdpstatistics_enginestats.sql -------------- DROP TABLE IF EXISTS `jpapdpstatistics_enginestats` -------------- > downgrade 0100-jpapdpgroup_properties.sql -------------- DROP TABLE IF EXISTS `jpapdpgroup_properties` -------------- policyadmin: OK: downgrade (0) Ending test 11 190 0100-jpapdpgroup_properties.sql downgrade 0800 0 2303221012030800d 1 2022-03-23 10:12:06 policyadmin: OK @ 0 Test summary: status:1, operation:downgrade, from:0800, to:0, new executions:96, sqlFiles:96 *** Test 11: PASS , Successful downgrade, current version: 0 *** ############################################################################################################ Starting test 12 190 0100-jpapdpgroup_properties.sql downgrade 0800 0 2303221012030800d 1 2022-03-23 10:12:06 policyadmin: OK @ 0 Done upgrade: 0 -> 1000 > upgrade 0100-jpapdpgroup_properties.sql -------------- CREATE TABLE IF NOT EXISTS jpapdpgroup_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES VARCHAR(255) NULL, PROPERTIES_KEY VARCHAR(255) NULL) -------------- > upgrade 0110-jpapdpstatistics_enginestats.sql -------------- 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, timeStamp datetime DEFAULT NULL NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL) -------------- > upgrade 0120-jpapdpsubgroup_policies.sql -------------- 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) -------------- > upgrade 0130-jpapdpsubgroup_properties.sql -------------- 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) -------------- > upgrade 0140-jpapdpsubgroup_supportedpolicytypes.sql -------------- 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) -------------- > upgrade 0150-jpatoscacapabilityassignment_attributes.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_attributes (name VARCHAR(120) NULL, version VARCHAR(20) NULL, ATTRIBUTES LONGTEXT NULL, ATTRIBUTES_KEY VARCHAR(255) NULL) -------------- > upgrade 0160-jpatoscacapabilityassignment_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0170-jpatoscacapabilityassignment_occurrences.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_occurrences (name VARCHAR(120) NULL, version VARCHAR(20) NULL, OCCURRENCES INT DEFAULT NULL NULL) -------------- > upgrade 0180-jpatoscacapabilityassignment_properties.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL) -------------- > upgrade 0190-jpatoscacapabilitytype_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscacapabilitytype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0200-jpatoscacapabilitytype_properties.sql -------------- 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) -------------- > upgrade 0210-jpatoscadatatype_constraints.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscadatatype_constraints (name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINTS VARCHAR(255) NULL) -------------- > upgrade 0220-jpatoscadatatype_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscadatatype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0230-jpatoscadatatype_properties.sql -------------- 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) -------------- > upgrade 0240-jpatoscanodetemplate_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscanodetemplate_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0250-jpatoscanodetemplate_properties.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscanodetemplate_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL) -------------- > upgrade 0260-jpatoscanodetype_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscanodetype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0270-jpatoscanodetype_properties.sql -------------- 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) -------------- > upgrade 0280-jpatoscapolicy_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscapolicy_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0290-jpatoscapolicy_properties.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscapolicy_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL) -------------- > upgrade 0300-jpatoscapolicy_targets.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscapolicy_targets (name VARCHAR(120) NULL, version VARCHAR(20) NULL) -------------- > upgrade 0310-jpatoscapolicytype_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscapolicytype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0320-jpatoscapolicytype_properties.sql -------------- 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) -------------- > upgrade 0330-jpatoscapolicytype_targets.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscapolicytype_targets (name VARCHAR(120) NULL, version VARCHAR(20) NULL) -------------- > upgrade 0340-jpatoscapolicytype_triggers.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscapolicytype_triggers (name VARCHAR(120) NULL, version VARCHAR(20) NULL, TRIGGERS VARCHAR(255) NULL) -------------- > upgrade 0350-jpatoscaproperty_constraints.sql -------------- 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) -------------- > upgrade 0360-jpatoscaproperty_metadata.sql -------------- 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) -------------- > upgrade 0370-jpatoscarelationshiptype_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscarelationshiptype_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0380-jpatoscarelationshiptype_properties.sql -------------- 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) -------------- > upgrade 0390-jpatoscarequirement_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscarequirement_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0400-jpatoscarequirement_occurrences.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscarequirement_occurrences (name VARCHAR(120) NULL, version VARCHAR(20) NULL, OCCURRENCES INT DEFAULT NULL NULL) -------------- > upgrade 0410-jpatoscarequirement_properties.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscarequirement_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES LONGTEXT NULL, PROPERTIES_KEY VARCHAR(255) NULL) -------------- > upgrade 0420-jpatoscaservicetemplate_metadata.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscaservicetemplate_metadata (name VARCHAR(120) NULL, version VARCHAR(20) NULL, METADATA VARCHAR(255) NULL, METADATA_KEY VARCHAR(255) NULL) -------------- > upgrade 0430-jpatoscatopologytemplate_inputs.sql -------------- 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) -------------- > upgrade 0440-pdpgroup_pdpsubgroup.sql -------------- 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)) -------------- > upgrade 0450-pdpgroup.sql -------------- 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)) -------------- > upgrade 0460-pdppolicystatus.sql -------------- 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)) -------------- > upgrade 0470-pdp.sql -------------- 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)) -------------- > upgrade 0480-pdpstatistics.sql -------------- 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 NOT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (timeStamp, name, version)) -------------- > upgrade 0490-pdpsubgroup_pdp.sql -------------- 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)) -------------- > upgrade 0500-pdpsubgroup.sql -------------- 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)) -------------- > upgrade 0510-toscacapabilityassignment.sql -------------- 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)) -------------- > upgrade 0520-toscacapabilityassignments.sql -------------- CREATE TABLE IF NOT EXISTS toscacapabilityassignments (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCACAPABILITYASSIGNMENTS PRIMARY KEY (name, version)) -------------- > upgrade 0530-toscacapabilityassignments_toscacapabilityassignment.sql -------------- 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)) -------------- > upgrade 0540-toscacapabilitytype.sql -------------- 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)) -------------- > upgrade 0550-toscacapabilitytypes.sql -------------- CREATE TABLE IF NOT EXISTS toscacapabilitytypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCACAPABILITYTYPES PRIMARY KEY (name, version)) -------------- > upgrade 0560-toscacapabilitytypes_toscacapabilitytype.sql -------------- 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)) -------------- > upgrade 0570-toscadatatype.sql -------------- 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)) -------------- > upgrade 0580-toscadatatypes.sql -------------- CREATE TABLE IF NOT EXISTS toscadatatypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCADATATYPES PRIMARY KEY (name, version)) -------------- > upgrade 0590-toscadatatypes_toscadatatype.sql -------------- CREATE TABLE IF NOT EXISTS toscadatatypes_toscadatatype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCADATATYPES_TOSCADATATYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion)) -------------- > upgrade 0600-toscanodetemplate.sql -------------- 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)) -------------- > upgrade 0610-toscanodetemplates.sql -------------- CREATE TABLE IF NOT EXISTS toscanodetemplates (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCANODETEMPLATES PRIMARY KEY (name, version)) -------------- > upgrade 0620-toscanodetemplates_toscanodetemplate.sql -------------- 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)) -------------- > upgrade 0630-toscanodetype.sql -------------- 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)) -------------- > upgrade 0640-toscanodetypes.sql -------------- CREATE TABLE IF NOT EXISTS toscanodetypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCANODETYPES PRIMARY KEY (name, version)) -------------- > upgrade 0650-toscanodetypes_toscanodetype.sql -------------- 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)) -------------- > upgrade 0660-toscaparameter.sql -------------- 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)) -------------- > upgrade 0670-toscapolicies.sql -------------- CREATE TABLE IF NOT EXISTS toscapolicies (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAPOLICIES PRIMARY KEY (name, version)) -------------- > upgrade 0680-toscapolicies_toscapolicy.sql -------------- 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)) -------------- > upgrade 0690-toscapolicy.sql -------------- 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)) -------------- > upgrade 0700-toscapolicytype.sql -------------- 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)) -------------- > upgrade 0710-toscapolicytypes.sql -------------- CREATE TABLE IF NOT EXISTS toscapolicytypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAPOLICYTYPES PRIMARY KEY (name, version)) -------------- > upgrade 0720-toscapolicytypes_toscapolicytype.sql -------------- 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)) -------------- > upgrade 0730-toscaproperty.sql -------------- 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)) -------------- > upgrade 0740-toscarelationshiptype.sql -------------- 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)) -------------- > upgrade 0750-toscarelationshiptypes.sql -------------- CREATE TABLE IF NOT EXISTS toscarelationshiptypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCARELATIONSHIPTYPES PRIMARY KEY (name, version)) -------------- > upgrade 0760-toscarelationshiptypes_toscarelationshiptype.sql -------------- 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)) -------------- > upgrade 0770-toscarequirement.sql -------------- 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)) -------------- > upgrade 0780-toscarequirements.sql -------------- CREATE TABLE IF NOT EXISTS toscarequirements (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, CONSTRAINT PK_TOSCAREQUIREMENTS PRIMARY KEY (name, version)) -------------- > upgrade 0790-toscarequirements_toscarequirement.sql -------------- 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)) -------------- > upgrade 0800-toscaservicetemplate.sql -------------- 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)) -------------- > upgrade 0810-toscatopologytemplate.sql -------------- 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)) -------------- > upgrade 0820-toscatrigger.sql -------------- 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)) -------------- > upgrade 0830-FK_ToscaNodeTemplate_capabilitiesName.sql -------------- CREATE INDEX FK_ToscaNodeTemplate_capabilitiesName ON toscanodetemplate(capabilitiesName, capabilitiesVersion) -------------- > upgrade 0840-FK_ToscaNodeTemplate_requirementsName.sql -------------- CREATE INDEX FK_ToscaNodeTemplate_requirementsName ON toscanodetemplate(requirementsName, requirementsVersion) -------------- > upgrade 0850-FK_ToscaNodeType_requirementsName.sql -------------- CREATE INDEX FK_ToscaNodeType_requirementsName ON toscanodetype(requirementsName, requirementsVersion) -------------- > upgrade 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql -------------- CREATE INDEX FK_ToscaServiceTemplate_capabilityTypesName ON toscaservicetemplate(capabilityTypesName, capabilityTypesVersion) -------------- > upgrade 0870-FK_ToscaServiceTemplate_dataTypesName.sql -------------- CREATE INDEX FK_ToscaServiceTemplate_dataTypesName ON toscaservicetemplate(dataTypesName, dataTypesVersion) -------------- > upgrade 0880-FK_ToscaServiceTemplate_nodeTypesName.sql -------------- CREATE INDEX FK_ToscaServiceTemplate_nodeTypesName ON toscaservicetemplate(nodeTypesName, nodeTypesVersion) -------------- > upgrade 0890-FK_ToscaServiceTemplate_policyTypesName.sql -------------- CREATE INDEX FK_ToscaServiceTemplate_policyTypesName ON toscaservicetemplate(policyTypesName, policyTypesVersion) -------------- > upgrade 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql -------------- CREATE INDEX FK_ToscaServiceTemplate_relationshipTypesName ON toscaservicetemplate(relationshipTypesName, relationshipTypesVersion) -------------- > upgrade 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql -------------- CREATE INDEX FK_ToscaTopologyTemplate_nodeTemplatesName ON toscatopologytemplate(nodeTemplatesName, nodeTemplatessVersion) -------------- > upgrade 0920-FK_ToscaTopologyTemplate_policyName.sql -------------- CREATE INDEX FK_ToscaTopologyTemplate_policyName ON toscatopologytemplate(policyName, policyVersion) -------------- > upgrade 0940-PdpPolicyStatus_PdpGroup.sql -------------- CREATE INDEX PdpPolicyStatus_PdpGroup ON pdppolicystatus(PDPGROUP) -------------- > upgrade 0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql -------------- CREATE INDEX TscaServiceTemplatetopologyTemplateParentLocalName ON toscaservicetemplate(topologyTemplateParentLocalName, topologyTemplateLocalName, topologyTemplateParentKeyVersion, topologyTemplateParentKeyName) -------------- > upgrade 0960-FK_ToscaNodeTemplate_capabilitiesName.sql -------------- ALTER TABLE toscanodetemplate ADD CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName FOREIGN KEY (capabilitiesName, capabilitiesVersion) REFERENCES toscacapabilityassignments (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 0970-FK_ToscaNodeTemplate_requirementsName.sql -------------- ALTER TABLE toscanodetemplate ADD CONSTRAINT FK_ToscaNodeTemplate_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES toscarequirements (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 0980-FK_ToscaNodeType_requirementsName.sql -------------- ALTER TABLE toscanodetype ADD CONSTRAINT FK_ToscaNodeType_requirementsName FOREIGN KEY (requirementsName, requirementsVersion) REFERENCES toscarequirements (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 0990-FK_ToscaServiceTemplate_capabilityTypesName.sql -------------- ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_capabilityTypesName FOREIGN KEY (capabilityTypesName, capabilityTypesVersion) REFERENCES toscacapabilitytypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 1000-FK_ToscaServiceTemplate_dataTypesName.sql -------------- ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_dataTypesName FOREIGN KEY (dataTypesName, dataTypesVersion) REFERENCES toscadatatypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 1010-FK_ToscaServiceTemplate_nodeTypesName.sql -------------- ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_nodeTypesName FOREIGN KEY (nodeTypesName, nodeTypesVersion) REFERENCES toscanodetypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 1020-FK_ToscaServiceTemplate_policyTypesName.sql -------------- ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_policyTypesName FOREIGN KEY (policyTypesName, policyTypesVersion) REFERENCES toscapolicytypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 1030-FK_ToscaServiceTemplate_relationshipTypesName.sql -------------- ALTER TABLE toscaservicetemplate ADD CONSTRAINT FK_ToscaServiceTemplate_relationshipTypesName FOREIGN KEY (relationshipTypesName, relationshipTypesVersion) REFERENCES toscarelationshiptypes (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql -------------- ALTER TABLE toscatopologytemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_nodeTemplatesName FOREIGN KEY (nodeTemplatesName, nodeTemplatessVersion) REFERENCES toscanodetemplates (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 1050-FK_ToscaTopologyTemplate_policyName.sql -------------- ALTER TABLE toscatopologytemplate ADD CONSTRAINT FK_ToscaTopologyTemplate_policyName FOREIGN KEY (policyName, policyVersion) REFERENCES toscapolicies (name, version) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql -------------- ALTER TABLE toscaservicetemplate ADD CONSTRAINT TscaServiceTemplatetopologyTemplateParentLocalName FOREIGN KEY (topologyTemplateParentLocalName, topologyTemplateLocalName, topologyTemplateParentKeyVersion, topologyTemplateParentKeyName) REFERENCES toscatopologytemplate (parentLocalName, localName, parentKeyVersion, parentKeyName) ON UPDATE RESTRICT ON DELETE RESTRICT -------------- > upgrade 0100-pdp.sql -------------- ALTER TABLE pdp ADD COLUMN LASTUPDATE datetime NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER HEALTHY -------------- > upgrade 0110-idx_tsidx1.sql -------------- CREATE INDEX IDX_TSIDX1 ON pdpstatistics(timeStamp, name, version) -------------- > upgrade 0120-pk_pdpstatistics.sql -------------- ALTER TABLE pdpstatistics DROP PRIMARY KEY -------------- > upgrade 0130-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics ADD COLUMN POLICYUNDEPLOYCOUNT BIGINT DEFAULT NULL NULL AFTER POLICYEXECUTEDSUCCESSCOUNT, ADD COLUMN POLICYUNDEPLOYFAILCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN POLICYUNDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL NULL, ADD COLUMN ID BIGINT NOT NULL -------------- > upgrade 0140-pk_pdpstatistics.sql -------------- UPDATE pdpstatistics as p JOIN (SELECT name, version, timeStamp, ROW_NUMBER() OVER (ORDER BY timeStamp ASC) AS row_num FROM pdpstatistics GROUP BY name, version, timeStamp) AS t ON (p.name=t.name AND p.version=t.version AND p.timeStamp = t.timeStamp) SET p.id=t.row_num -------------- -------------- ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version) -------------- > upgrade 0150-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime(6) NULL -------------- > upgrade 0160-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN ID BIGINT DEFAULT NULL NULL AFTER UPTIME -------------- > upgrade 0170-jpapdpstatistics_enginestats.sql -------------- UPDATE jpapdpstatistics_enginestats a JOIN pdpstatistics b ON a.name = b.name AND a.version = b.version AND a.timeStamp = b.timeStamp SET a.id = b.id -------------- > upgrade 0180-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN timeStamp -------------- > upgrade 0190-jpapolicyaudit.sql -------------- 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)) -------------- > upgrade 0200-JpaPolicyAuditIndex_timestamp.sql -------------- CREATE INDEX JpaPolicyAuditIndex_timestamp ON jpapolicyaudit(TIMESTAMP) -------------- > upgrade 0210-sequence.sql -------------- 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)) -------------- > upgrade 0220-sequence.sql -------------- INSERT INTO sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', (SELECT IFNULL(max(id),0) FROM pdpstatistics)) -------------- > upgrade 0100-jpatoscapolicy_targets.sql -------------- ALTER TABLE jpatoscapolicy_targets ADD COLUMN toscaPolicyName VARCHAR(120) NOT NULL, ADD COLUMN toscaPolicyVersion VARCHAR(20) NOT NULL, ADD CONSTRAINT PK_JPATOSCAPOLICY_TARGETS PRIMARY KEY (toscaPolicyName, toscaPolicyVersion) -------------- > upgrade 0110-jpatoscapolicytype_targets.sql -------------- ALTER TABLE jpatoscapolicytype_targets ADD COLUMN toscaPolicyTypeName VARCHAR(120) NOT NULL, ADD COLUMN toscaPolicyTypeVersion VARCHAR(20) NOT NULL, ADD CONSTRAINT PK_JPATOSCAPOLICYTYPE_TARGETS PRIMARY KEY (toscaPolicyTypeName, toscaPolicyTypeVersion) -------------- > upgrade 0120-toscatrigger.sql -------------- DROP TABLE IF EXISTS toscatrigger -------------- > upgrade 0130-jpatoscapolicytype_triggers.sql -------------- ALTER TABLE jpatoscapolicytype_triggers MODIFY COLUMN triggers LONGBLOB -------------- > upgrade 0140-toscaparameter.sql -------------- DROP TABLE IF EXISTS toscaparameter -------------- > upgrade 0150-toscaproperty.sql -------------- DROP TABLE IF EXISTS jpatoscaproperty_constraints -------------- -------------- DROP TABLE IF EXISTS jpatoscaproperty_metadata -------------- -------------- DROP TABLE IF EXISTS toscaproperty -------------- > upgrade 0160-jpapolicyaudit_pk.sql -------------- ALTER TABLE jpapolicyaudit DROP CONSTRAINT PRIMARY KEY -------------- -------------- ALTER TABLE jpapolicyaudit ADD CONSTRAINT PK_JPAPOLICYAUDIT PRIMARY KEY (ID) -------------- > upgrade 0170-pdpstatistics_pk.sql -------------- ALTER TABLE pdpstatistics DROP CONSTRAINT PRIMARY KEY -------------- -------------- ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID) -------------- policyadmin: OK: upgrade (1000) Ending test 12 307 0170-pdpstatistics_pk.sql upgrade 0900 1000 2303221012121000u 1 2022-03-23 10:12:19 policyadmin: OK @ 1000 Test summary: status:1, operation:upgrade, from:0, to:1000, new executions:117, sqlFiles:117 *** Test 12: PASS , Successful upgrade, current version: 1000 *** ############################################################################################################ Starting test 13 307 0170-pdpstatistics_pk.sql upgrade 0900 1000 2303221012121000u 1 2022-03-23 10:12:19 policyadmin: OK @ 1000 Done downgrade: 1000 -> 0 > downgrade 0170-pdpstatistics_pk.sql -------------- ALTER TABLE pdpstatistics DROP CONSTRAINT PRIMARY KEY -------------- -------------- ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID, name, version) -------------- > downgrade 0160-jpapolicyaudit_pk.sql -------------- ALTER TABLE jpapolicyaudit DROP CONSTRAINT PRIMARY KEY -------------- -------------- ALTER TABLE jpapolicyaudit ADD CONSTRAINT PK_JPAPOLICYAUDIT PRIMARY KEY (ID, name, version) -------------- > downgrade 0150-toscaproperty.sql -------------- 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) -------------- -------------- 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) -------------- -------------- 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)) -------------- > downgrade 0140-toscaparameter.sql -------------- 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)) -------------- > downgrade 0130-jpatoscapolicytype_triggers.sql -------------- ALTER TABLE jpatoscapolicytype_triggers MODIFY COLUMN triggers VARCHAR(255) -------------- > downgrade 0120-toscatrigger.sql -------------- 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)) -------------- > downgrade 0110-jpatoscapolicytype_targets.sql -------------- ALTER TABLE jpatoscapolicytype_targets DROP COLUMN toscaPolicyTypeName, DROP COLUMN toscaPolicyTypeVersion -------------- > downgrade 0100-jpatoscapolicy_targets.sql -------------- ALTER TABLE jpatoscapolicy_targets DROP COLUMN toscaPolicyName, DROP COLUMN toscaPolicyVersion -------------- > downgrade 0220-sequence.sql -------------- DELETE from sequence -------------- > downgrade 0210-sequence.sql -------------- DROP TABLE IF EXISTS `sequence` -------------- > downgrade 0200-JpaPolicyAuditIndex_timestamp.sql -------------- ALTER TABLE jpapolicyaudit DROP INDEX JpaPolicyAuditIndex_timestamp -------------- > downgrade 0190-jpapolicyaudit.sql -------------- DROP TABLE IF EXISTS `jpapolicyaudit` -------------- > downgrade 0180-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats ADD COLUMN timeStamp datetime(6) DEFAULT NULL NULL AFTER UPTIME -------------- > downgrade 0170-jpapdpstatistics_enginestats.sql -------------- UPDATE jpapdpstatistics_enginestats a JOIN pdpstatistics b ON a.name = b.name AND a.version = b.version AND a.id = b.id SET a.timeStamp = b.timeStamp -------------- > downgrade 0160-jpapdpstatistics_enginestats.sql -------------- ALTER TABLE jpapdpstatistics_enginestats DROP COLUMN ID -------------- > downgrade 0150-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics MODIFY COLUMN timeStamp datetime(6) NOT NULL -------------- > downgrade 0140-pk_pdpstatistics.sql -------------- ALTER TABLE pdpstatistics DROP CONSTRAINT PRIMARY KEY -------------- -------------- UPDATE pdpstatistics set ID = 0 -------------- > downgrade 0130-pdpstatistics.sql -------------- ALTER TABLE pdpstatistics DROP COLUMN POLICYUNDEPLOYCOUNT, DROP COLUMN POLICYUNDEPLOYFAILCOUNT, DROP COLUMN POLICYUNDEPLOYSUCCESSCOUNT, DROP COLUMN ID -------------- > downgrade 0120-pk_pdpstatistics.sql -------------- ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (timeStamp, name, version) -------------- > downgrade 0110-idx_tsidx1.sql -------------- DROP INDEX IDX_TSIDX1 ON pdpstatistics -------------- > downgrade 0100-pdp.sql -------------- ALTER TABLE pdp DROP COLUMN LASTUPDATE -------------- > downgrade 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql -------------- ALTER TABLE toscaservicetemplate DROP CONSTRAINT TscaServiceTemplatetopologyTemplateParentLocalName -------------- > downgrade 1050-FK_ToscaTopologyTemplate_policyName.sql -------------- ALTER TABLE toscatopologytemplate DROP CONSTRAINT FK_ToscaTopologyTemplate_policyName -------------- > downgrade 1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql -------------- ALTER TABLE toscatopologytemplate DROP CONSTRAINT FK_ToscaTopologyTemplate_nodeTemplatesName -------------- > downgrade 1030-FK_ToscaServiceTemplate_relationshipTypesName.sql -------------- ALTER TABLE toscaservicetemplate DROP CONSTRAINT FK_ToscaServiceTemplate_relationshipTypesName -------------- > downgrade 1020-FK_ToscaServiceTemplate_policyTypesName.sql -------------- ALTER TABLE toscaservicetemplate DROP CONSTRAINT FK_ToscaServiceTemplate_policyTypesName -------------- > downgrade 1010-FK_ToscaServiceTemplate_nodeTypesName.sql -------------- ALTER TABLE toscaservicetemplate DROP CONSTRAINT FK_ToscaServiceTemplate_nodeTypesName -------------- > downgrade 1000-FK_ToscaServiceTemplate_dataTypesName.sql -------------- ALTER TABLE toscaservicetemplate DROP CONSTRAINT FK_ToscaServiceTemplate_dataTypesName -------------- > downgrade 0990-FK_ToscaServiceTemplate_capabilityTypesName.sql -------------- ALTER TABLE toscaservicetemplate DROP CONSTRAINT FK_ToscaServiceTemplate_capabilityTypesName -------------- > downgrade 0980-FK_ToscaNodeType_requirementsName.sql -------------- ALTER TABLE toscanodetype DROP CONSTRAINT FK_ToscaNodeType_requirementsName -------------- > downgrade 0970-FK_ToscaNodeTemplate_requirementsName.sql -------------- ALTER TABLE toscanodetemplate DROP CONSTRAINT FK_ToscaNodeTemplate_requirementsName -------------- > downgrade 0960-FK_ToscaNodeTemplate_capabilitiesName.sql -------------- ALTER TABLE toscanodetemplate DROP CONSTRAINT FK_ToscaNodeTemplate_capabilitiesName -------------- > downgrade 0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql -------------- DROP INDEX TscaServiceTemplatetopologyTemplateParentLocalName ON toscaservicetemplate -------------- > downgrade 0940-PdpPolicyStatus_PdpGroup.sql -------------- DROP INDEX PdpPolicyStatus_PdpGroup ON pdppolicystatus -------------- > downgrade 0920-FK_ToscaTopologyTemplate_policyName.sql -------------- DROP INDEX FK_ToscaTopologyTemplate_policyName ON toscatopologytemplate -------------- > downgrade 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql -------------- DROP INDEX FK_ToscaTopologyTemplate_nodeTemplatesName ON toscatopologytemplate -------------- > downgrade 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql -------------- DROP INDEX FK_ToscaServiceTemplate_relationshipTypesName ON toscaservicetemplate -------------- > downgrade 0890-FK_ToscaServiceTemplate_policyTypesName.sql -------------- DROP INDEX FK_ToscaServiceTemplate_policyTypesName ON toscaservicetemplate -------------- > downgrade 0880-FK_ToscaServiceTemplate_nodeTypesName.sql -------------- DROP INDEX FK_ToscaServiceTemplate_nodeTypesName ON toscaservicetemplate -------------- > downgrade 0870-FK_ToscaServiceTemplate_dataTypesName.sql -------------- DROP INDEX FK_ToscaServiceTemplate_dataTypesName ON toscaservicetemplate -------------- > downgrade 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql -------------- DROP INDEX FK_ToscaServiceTemplate_capabilityTypesName ON toscaservicetemplate -------------- > downgrade 0850-FK_ToscaNodeType_requirementsName.sql -------------- DROP INDEX FK_ToscaNodeType_requirementsName ON toscanodetype -------------- > downgrade 0840-FK_ToscaNodeTemplate_requirementsName.sql -------------- DROP INDEX FK_ToscaNodeTemplate_requirementsName ON toscanodetemplate -------------- > downgrade 0830-FK_ToscaNodeTemplate_capabilitiesName.sql -------------- DROP INDEX FK_ToscaNodeTemplate_capabilitiesName ON toscanodetemplate -------------- > downgrade 0820-toscatrigger.sql -------------- DROP TABLE IF EXISTS `toscatrigger` -------------- > downgrade 0810-toscatopologytemplate.sql -------------- DROP TABLE IF EXISTS `toscatopologytemplate` -------------- > downgrade 0800-toscaservicetemplate.sql -------------- DROP TABLE IF EXISTS `toscaservicetemplate` -------------- > downgrade 0790-toscarequirements_toscarequirement.sql -------------- DROP TABLE IF EXISTS `toscarequirements_toscarequirement` -------------- > downgrade 0780-toscarequirements.sql -------------- DROP TABLE IF EXISTS `toscarequirements` -------------- > downgrade 0770-toscarequirement.sql -------------- DROP TABLE IF EXISTS `toscarequirement` -------------- > downgrade 0760-toscarelationshiptypes_toscarelationshiptype.sql -------------- DROP TABLE IF EXISTS `toscarelationshiptypes_toscarelationshiptype` -------------- > downgrade 0750-toscarelationshiptypes.sql -------------- DROP TABLE IF EXISTS `toscarelationshiptypes` -------------- > downgrade 0740-toscarelationshiptype.sql -------------- DROP TABLE IF EXISTS `toscarelationshiptype` -------------- > downgrade 0730-toscaproperty.sql -------------- DROP TABLE IF EXISTS `toscaproperty` -------------- > downgrade 0720-toscapolicytypes_toscapolicytype.sql -------------- DROP TABLE IF EXISTS `toscapolicytypes_toscapolicytype` -------------- > downgrade 0710-toscapolicytypes.sql -------------- DROP TABLE IF EXISTS `toscapolicytypes` -------------- > downgrade 0700-toscapolicytype.sql -------------- DROP TABLE IF EXISTS `toscapolicytype` -------------- > downgrade 0690-toscapolicy.sql -------------- DROP TABLE IF EXISTS `toscapolicy` -------------- > downgrade 0680-toscapolicies_toscapolicy.sql -------------- DROP TABLE IF EXISTS `toscapolicies_toscapolicy` -------------- > downgrade 0670-toscapolicies.sql -------------- DROP TABLE IF EXISTS `toscapolicies` -------------- > downgrade 0660-toscaparameter.sql -------------- DROP TABLE IF EXISTS `toscaparameter` -------------- > downgrade 0650-toscanodetypes_toscanodetype.sql -------------- DROP TABLE IF EXISTS `toscanodetypes_toscanodetype` -------------- > downgrade 0640-toscanodetypes.sql -------------- DROP TABLE IF EXISTS `toscanodetypes` -------------- > downgrade 0630-toscanodetype.sql -------------- DROP TABLE IF EXISTS `toscanodetype` -------------- > downgrade 0620-toscanodetemplates_toscanodetemplate.sql -------------- DROP TABLE IF EXISTS `toscanodetemplates_toscanodetemplate` -------------- > downgrade 0610-toscanodetemplates.sql -------------- DROP TABLE IF EXISTS `toscanodetemplates` -------------- > downgrade 0600-toscanodetemplate.sql -------------- DROP TABLE IF EXISTS `toscanodetemplate` -------------- > downgrade 0590-toscadatatypes_toscadatatype.sql -------------- DROP TABLE IF EXISTS `toscadatatypes_toscadatatype` -------------- > downgrade 0580-toscadatatypes.sql -------------- DROP TABLE IF EXISTS `toscadatatypes` -------------- > downgrade 0570-toscadatatype.sql -------------- DROP TABLE IF EXISTS `toscadatatype` -------------- > downgrade 0560-toscacapabilitytypes_toscacapabilitytype.sql -------------- DROP TABLE IF EXISTS `toscacapabilitytypes_toscacapabilitytype` -------------- > downgrade 0550-toscacapabilitytypes.sql -------------- DROP TABLE IF EXISTS `toscacapabilitytypes` -------------- > downgrade 0540-toscacapabilitytype.sql -------------- DROP TABLE IF EXISTS `toscacapabilitytype` -------------- > downgrade 0530-toscacapabilityassignments_toscacapabilityassignment.sql -------------- DROP TABLE IF EXISTS `toscacapabilityassignments_toscacapabilityassignment` -------------- > downgrade 0520-toscacapabilityassignments.sql -------------- DROP TABLE IF EXISTS `toscacapabilityassignments` -------------- > downgrade 0510-toscacapabilityassignment.sql -------------- DROP TABLE IF EXISTS `toscacapabilityassignment` -------------- > downgrade 0500-pdpsubgroup.sql -------------- DROP TABLE IF EXISTS `pdpsubgroup` -------------- > downgrade 0490-pdpsubgroup_pdp.sql -------------- DROP TABLE IF EXISTS `pdpsubgroup_pdp` -------------- > downgrade 0480-pdpstatistics.sql -------------- DROP TABLE IF EXISTS `pdpstatistics` -------------- > downgrade 0470-pdp.sql -------------- DROP TABLE IF EXISTS `pdp` -------------- > downgrade 0460-pdppolicystatus.sql -------------- DROP TABLE IF EXISTS `pdppolicystatus` -------------- > downgrade 0450-pdpgroup.sql -------------- DROP TABLE IF EXISTS `pdpgroup` -------------- > downgrade 0440-pdpgroup_pdpsubgroup.sql -------------- DROP TABLE IF EXISTS `pdpgroup_pdpsubgroup` -------------- > downgrade 0430-jpatoscatopologytemplate_inputs.sql -------------- DROP TABLE IF EXISTS `jpatoscatopologytemplate_inputs` -------------- > downgrade 0420-jpatoscaservicetemplate_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscaservicetemplate_metadata` -------------- > downgrade 0410-jpatoscarequirement_properties.sql -------------- DROP TABLE IF EXISTS `jpatoscarequirement_properties` -------------- > downgrade 0400-jpatoscarequirement_occurrences.sql -------------- DROP TABLE IF EXISTS `jpatoscarequirement_occurrences` -------------- > downgrade 0390-jpatoscarequirement_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscarequirement_metadata` -------------- > downgrade 0380-jpatoscarelationshiptype_properties.sql -------------- DROP TABLE IF EXISTS `jpatoscarelationshiptype_properties` -------------- > downgrade 0370-jpatoscarelationshiptype_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscarelationshiptype_metadata` -------------- > downgrade 0360-jpatoscaproperty_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscaproperty_metadata` -------------- > downgrade 0350-jpatoscaproperty_constraints.sql -------------- DROP TABLE IF EXISTS `jpatoscaproperty_constraints` -------------- > downgrade 0340-jpatoscapolicytype_triggers.sql -------------- DROP TABLE IF EXISTS `jpatoscapolicytype_triggers` -------------- > downgrade 0330-jpatoscapolicytype_targets.sql -------------- DROP TABLE IF EXISTS `jpatoscapolicytype_targets` -------------- > downgrade 0320-jpatoscapolicytype_properties.sql -------------- DROP TABLE IF EXISTS `jpatoscapolicytype_properties` -------------- > downgrade 0310-jpatoscapolicytype_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscapolicytype_metadata` -------------- > downgrade 0300-jpatoscapolicy_targets.sql -------------- DROP TABLE IF EXISTS `jpatoscapolicy_targets` -------------- > downgrade 0290-jpatoscapolicy_properties.sql -------------- DROP TABLE IF EXISTS `jpatoscapolicy_properties` -------------- > downgrade 0280-jpatoscapolicy_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscapolicy_metadata` -------------- > downgrade 0270-jpatoscanodetype_properties.sql -------------- DROP TABLE IF EXISTS `jpatoscanodetype_properties` -------------- > downgrade 0260-jpatoscanodetype_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscanodetype_metadata` -------------- > downgrade 0250-jpatoscanodetemplate_properties.sql -------------- DROP TABLE IF EXISTS `jpatoscanodetemplate_properties` -------------- > downgrade 0240-jpatoscanodetemplate_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscanodetemplate_metadata` -------------- > downgrade 0230-jpatoscadatatype_properties.sql -------------- DROP TABLE IF EXISTS `jpatoscadatatype_properties` -------------- > downgrade 0220-jpatoscadatatype_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscadatatype_metadata` -------------- > downgrade 0210-jpatoscadatatype_constraints.sql -------------- DROP TABLE IF EXISTS `jpatoscadatatype_constraints` -------------- > downgrade 0200-jpatoscacapabilitytype_properties.sql -------------- DROP TABLE IF EXISTS `jpatoscacapabilitytype_properties` -------------- > downgrade 0190-jpatoscacapabilitytype_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscacapabilitytype_metadata` -------------- > downgrade 0180-jpatoscacapabilityassignment_properties.sql -------------- DROP TABLE IF EXISTS `jpatoscacapabilityassignment_properties` -------------- > downgrade 0170-jpatoscacapabilityassignment_occurrences.sql -------------- DROP TABLE IF EXISTS `jpatoscacapabilityassignment_occurrences` -------------- > downgrade 0160-jpatoscacapabilityassignment_metadata.sql -------------- DROP TABLE IF EXISTS `jpatoscacapabilityassignment_metadata` -------------- > downgrade 0150-jpatoscacapabilityassignment_attributes.sql -------------- DROP TABLE IF EXISTS `jpatoscacapabilityassignment_attributes` -------------- > downgrade 0140-jpapdpsubgroup_supportedpolicytypes.sql -------------- DROP TABLE IF EXISTS `jpapdpsubgroup_supportedpolicytypes` -------------- > downgrade 0130-jpapdpsubgroup_properties.sql -------------- DROP TABLE IF EXISTS `jpapdpsubgroup_properties` -------------- > downgrade 0120-jpapdpsubgroup_policies.sql -------------- DROP TABLE IF EXISTS `jpapdpsubgroup_policies` -------------- > downgrade 0110-jpapdpstatistics_enginestats.sql -------------- DROP TABLE IF EXISTS `jpapdpstatistics_enginestats` -------------- > downgrade 0100-jpapdpgroup_properties.sql -------------- DROP TABLE IF EXISTS `jpapdpgroup_properties` -------------- policyadmin: OK: downgrade (0) Ending test 13 424 0100-jpapdpgroup_properties.sql downgrade 0800 0 2303221012240800d 1 2022-03-23 10:12:29 policyadmin: OK @ 0 Test summary: status:1, operation:downgrade, from:1000, to:0, new executions:117, sqlFiles:117 *** Test 13: PASS , Successful downgrade, current version: 0 *** ----------------------------------------------------------------------- Number of Tests: 13, Tests Passed: 13, Tests Failed: 0 Date: 2022-03-23-10:10:48 ----------------------------------------------------------------------- End of test 2022-03-23-10:12:29