+ /dbcmd-config/db_migrator_policy_init.sh 314 blocks Preparing upgrade release version: 0800 Preparing upgrade release version: 0900 Preparing upgrade release version: 1000 Preparing upgrade release version: 1100 Preparing upgrade release version: 1200 Done upgrade: 0 -> 1200 > upgrade 0100-jpapdpgroup_properties.sql -------------- CREATE TABLE IF NOT EXISTS jpapdpgroup_properties (name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL, PROPERTIES VARCHAR(255) DEFAULT NULL, PROPERTIES_KEY VARCHAR(255) DEFAULT NULL) -------------- > upgrade 0110-jpapdpstatistics_enginestats.sql -------------- CREATE TABLE IF NOT EXISTS jpapdpstatistics_enginestats (AVERAGEEXECUTIONTIME DOUBLE DEFAULT NULL, ENGINEID VARCHAR(255) DEFAULT NULL, ENGINETIMESTAMP BIGINT DEFAULT NULL, ENGINEWORKERSTATE INT DEFAULT NULL, EVENTCOUNT BIGINT DEFAULT NULL, LASTENTERTIME BIGINT DEFAULT NULL, LASTEXECUTIONTIME BIGINT DEFAULT NULL, LASTSTART BIGINT DEFAULT NULL, UPTIME BIGINT DEFAULT NULL, timeStamp datetime DEFAULT NULL, name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL) -------------- > upgrade 0120-jpapdpsubgroup_policies.sql -------------- CREATE TABLE IF NOT EXISTS jpapdpsubgroup_policies (name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL, parentLocalName VARCHAR(120) DEFAULT NULL, localName VARCHAR(120) DEFAULT NULL, parentKeyVersion VARCHAR(15) DEFAULT NULL, parentKeyName VARCHAR(120) DEFAULT NULL) -------------- > upgrade 0130-jpapdpsubgroup_properties.sql -------------- CREATE TABLE IF NOT EXISTS jpapdpsubgroup_properties (parentLocalName VARCHAR(120) DEFAULT NULL, localName VARCHAR(120) DEFAULT NULL, parentKeyVersion VARCHAR(15) DEFAULT NULL, parentKeyName VARCHAR(120) DEFAULT NULL, PROPERTIES VARCHAR(255) DEFAULT NULL, PROPERTIES_KEY VARCHAR(255) DEFAULT NULL) -------------- > upgrade 0140-jpapdpsubgroup_supportedpolicytypes.sql -------------- CREATE TABLE IF NOT EXISTS jpapdpsubgroup_supportedpolicytypes (name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL, parentLocalName VARCHAR(120) DEFAULT NULL, localName VARCHAR(120) DEFAULT NULL, parentKeyVersion VARCHAR(15) DEFAULT NULL, parentKeyName VARCHAR(120) DEFAULT NULL) -------------- > upgrade 0150-jpatoscacapabilityassignment_attributes.sql -------------- CREATE TABLE IF NOT EXISTS jpatoscacapabilityassignment_attributes (name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL, ATTRIBUTES LONGTEXT DEFAULT NULL, ATTRIBUTES_KEY VARCHAR(255) DEFAULT 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) -------------- > 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, 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, 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, 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, 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, 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) -------------- > 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, 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, PRIMARY KEY PK_PDPGROUP_PDPSUBGROUP (name, version, parentLocalName, localName, parentKeyVersion, parentKeyName)) -------------- > upgrade 0450-pdpgroup.sql -------------- CREATE TABLE IF NOT EXISTS pdpgroup (`DESCRIPTION` VARCHAR(255) NULL, PDPGROUPSTATE INT DEFAULT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_PDPGROUP (name, version)) -------------- > upgrade 0460-pdppolicystatus.sql -------------- CREATE TABLE IF NOT EXISTS pdppolicystatus (DEPLOY BOOLEAN DEFAULT 0, PDPGROUP VARCHAR(255) DEFAULT NULL, PDPTYPE VARCHAR(255) DEFAULT NULL, STATE INT DEFAULT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL, PRIMARY KEY PK_PDPPOLICYSTATUS (parentLocalName, localName, parentKeyVersion, parentKeyName)) -------------- > upgrade 0470-pdp.sql -------------- CREATE TABLE IF NOT EXISTS pdp (HEALTHY INT DEFAULT NULL, MESSAGE VARCHAR(255) DEFAULT NULL, PDPSTATE INT DEFAULT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, PRIMARY KEY PK_PDP (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, POLICYDEPLOYFAILCOUNT BIGINT DEFAULT NULL, POLICYDEPLOYSUCCESSCOUNT BIGINT DEFAULT NULL, POLICYEXECUTEDCOUNT BIGINT DEFAULT NULL, POLICYEXECUTEDFAILCOUNT BIGINT DEFAULT NULL, POLICYEXECUTEDSUCCESSCOUNT BIGINT DEFAULT NULL, timeStamp datetime NOT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_PDPSTATISTICS (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, PRIMARY KEY PK_PDPSUBGROUP_PDP (pdpParentKeyName, pdpParentKeyVersion, pdpParentLocalName, pdpLocalName, parentLocalName, localName, parentKeyVersion, parentKeyName)) -------------- > upgrade 0500-pdpsubgroup.sql -------------- CREATE TABLE IF NOT EXISTS pdpsubgroup (CURRENTINSTANCECOUNT INT DEFAULT NULL, DESIREDINSTANCECOUNT INT DEFAULT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, PRIMARY KEY PK_PDPSUBGROUP (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, PRIMARY KEY PK_TOSCACAPABILITYASSIGNMENT(name, version)) -------------- > upgrade 0520-toscacapabilityassignments.sql -------------- CREATE TABLE IF NOT EXISTS toscacapabilityassignments (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCACAPABILITYASSIGNMENTS (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, PRIMARY KEY PK_TOSCACAPABILITYASSIGNMENTS_TOSCACAPABILITYASSIGNMENT (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, PRIMARY KEY PK_TOSCACAPABILITYTYPE (name, version)) -------------- > upgrade 0550-toscacapabilitytypes.sql -------------- CREATE TABLE IF NOT EXISTS toscacapabilitytypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCACAPABILITYTYPES (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, PRIMARY KEY PK_TOSCACAPABILITYTYPES_TOSCACAPABILITYTYPE (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, PRIMARY KEY PK_TOSCADATATYPE (name, version)) -------------- > upgrade 0580-toscadatatypes.sql -------------- CREATE TABLE IF NOT EXISTS toscadatatypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCADATATYPES (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, PRIMARY KEY PK_TOSCADATATYPES_TOSCADATATYPE (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, PRIMARY KEY PK_TOSCANODETEMPLATE (name, version)) -------------- > upgrade 0610-toscanodetemplates.sql -------------- CREATE TABLE IF NOT EXISTS toscanodetemplates (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCANODETEMPLATES (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, PRIMARY KEY PK_TOSCANODETEMPLATES_TOSCANODETEMPLATE (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, PRIMARY KEY PK_TOSCANODETYPE (name, version)) -------------- > upgrade 0640-toscanodetypes.sql -------------- CREATE TABLE IF NOT EXISTS toscanodetypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCANODETYPES (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, PRIMARY KEY PK_TOSCANODETYPES_TOSCANODETYPE (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, PRIMARY KEY PK_TOSCAPARAMETER (parentLocalName, localName, parentKeyVersion, parentKeyName)) -------------- > upgrade 0670-toscapolicies.sql -------------- CREATE TABLE IF NOT EXISTS toscapolicies (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCAPOLICIES (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, PRIMARY KEY PK_TOSCAPOLICIES_TOSCAPOLICY (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, PRIMARY KEY PK_TOSCAPOLICY (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, PRIMARY KEY PK_TOSCAPOLICYTYPE (name, version)) -------------- > upgrade 0710-toscapolicytypes.sql -------------- CREATE TABLE IF NOT EXISTS toscapolicytypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCAPOLICYTYPES (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, PRIMARY KEY PK_TOSCAPOLICYTYPES_TOSCAPOLICYTYPE (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion)) -------------- > upgrade 0730-toscaproperty.sql -------------- CREATE TABLE IF NOT EXISTS toscaproperty (DEFAULTVALUE VARCHAR(255) DEFAULT NULL, `DESCRIPTION` VARCHAR(255) DEFAULT NULL, ENTRYSCHEMA LONGBLOB DEFAULT NULL, REQUIRED BOOLEAN DEFAULT 0, STATUS INT DEFAULT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, name VARCHAR(120) DEFAULT NULL, version VARCHAR(20) DEFAULT NULL, PRIMARY KEY PK_TOSCAPROPERTY (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, PRIMARY KEY PK_TOSCARELATIONSHIPTYPE (name, version)) -------------- > upgrade 0750-toscarelationshiptypes.sql -------------- CREATE TABLE IF NOT EXISTS toscarelationshiptypes (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCARELATIONSHIPTYPES (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, PRIMARY KEY PK_TOSCARELATIONSHIPTYPES_TOSCARELATIONSHIPTYPE (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, PRIMARY KEY PK_TOSCAREQUIREMENT (name, version)) -------------- > upgrade 0780-toscarequirements.sql -------------- CREATE TABLE IF NOT EXISTS toscarequirements (name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_TOSCAREQUIREMENTS (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, PRIMARY KEY PK_TOSCAREQUIREMENTS_TOSCAREQUIREMENT (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, PRIMARY KEY PK_TOSCASERVICETEMPLATE (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, PRIMARY KEY PK_TOSCATOPOLOGYTEMPLATE (parentLocalName, localName, parentKeyVersion, parentKeyName)) -------------- > upgrade 0820-toscatrigger.sql -------------- CREATE TABLE IF NOT EXISTS toscatrigger (ACTION VARCHAR(255) NULL, toscaCondition LONGBLOB DEFAULT NULL, toscaConstraint LONGBLOB DEFAULT NULL, `DESCRIPTION` VARCHAR(255) NULL, EVALUATIONS INT DEFAULT NULL, EVENTTYPE VARCHAR(255) NULL, METHOD VARCHAR(255) NULL, `PERIOD` LONGBLOB DEFAULT NULL, SCHEDULE LONGBLOB DEFAULT NULL, TARGETFILTER LONGBLOB DEFAULT NULL, parentLocalName VARCHAR(120) NOT NULL, localName VARCHAR(120) NOT NULL, parentKeyVersion VARCHAR(15) NOT NULL, parentKeyName VARCHAR(120) NOT NULL, PRIMARY KEY PK_TOSCATRIGGER (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 AFTER POLICYEXECUTEDSUCCESSCOUNT, ADD COLUMN POLICYUNDEPLOYFAILCOUNT BIGINT DEFAULT NULL, ADD COLUMN POLICYUNDEPLOYSUCCESSCOUNT BIGINT DEFAULT 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 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, PDPGROUP VARCHAR(255) NULL, PDPTYPE VARCHAR(255) NULL, TIMESTAMP datetime DEFAULT NULL, USER VARCHAR(255) NULL, ID BIGINT NOT NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, PRIMARY KEY PK_JPAPOLICYAUDIT (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, PRIMARY KEY PK_SEQUENCE (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 PRIMARY KEY -------------- -------------- ALTER TABLE jpapolicyaudit ADD CONSTRAINT PK_JPAPOLICYAUDIT PRIMARY KEY (ID) -------------- > upgrade 0170-pdpstatistics_pk.sql -------------- ALTER TABLE pdpstatistics DROP PRIMARY KEY -------------- -------------- ALTER TABLE pdpstatistics ADD CONSTRAINT PK_PDPSTATISTICS PRIMARY KEY (ID) -------------- > upgrade 0180-jpatoscanodetemplate_metadata.sql -------------- ALTER TABLE jpatoscanodetemplate_metadata MODIFY COLUMN METADATA LONGTEXT -------------- > upgrade 0100-upgrade.sql -------------- select 'upgrade to 1100 completed' as msg -------------- msg upgrade to 1100 completed > upgrade 0100-jpapolicyaudit_renameuser.sql -------------- ALTER TABLE jpapolicyaudit RENAME COLUMN USER TO USERNAME -------------- > upgrade 0110-idx_tsidx1.sql -------------- DROP INDEX IDX_TSIDX1 ON pdpstatistics -------------- -------------- CREATE INDEX IDXTSIDX1 ON pdpstatistics(timeStamp, name, version) -------------- > upgrade 0120-audit_sequence.sql -------------- CREATE TABLE IF NOT EXISTS audit_sequence (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38) DEFAULT NULL, PRIMARY KEY PK_SEQUENCE (SEQ_NAME)) -------------- -------------- INSERT INTO audit_sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', (SELECT IFNULL(max(id),0) FROM jpapolicyaudit)) -------------- > upgrade 0130-statistics_sequence.sql -------------- CREATE TABLE IF NOT EXISTS statistics_sequence (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38) DEFAULT NULL, PRIMARY KEY PK_SEQUENCE (SEQ_NAME)) -------------- -------------- INSERT INTO statistics_sequence(SEQ_NAME, SEQ_COUNT) VALUES('SEQ_GEN', (SELECT IFNULL(max(id),0) FROM pdpstatistics)) -------------- policyadmin: OK: upgrade (1200) name version policyadmin 1200 ID script operation from_version to_version tag success atTime 1 0100-jpapdpgroup_properties.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:32 2 0110-jpapdpstatistics_enginestats.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:32 3 0120-jpapdpsubgroup_policies.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:32 4 0130-jpapdpsubgroup_properties.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:32 5 0140-jpapdpsubgroup_supportedpolicytypes.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:32 6 0150-jpatoscacapabilityassignment_attributes.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:34 7 0160-jpatoscacapabilityassignment_metadata.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:35 8 0170-jpatoscacapabilityassignment_occurrences.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:36 9 0180-jpatoscacapabilityassignment_properties.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:36 10 0190-jpatoscacapabilitytype_metadata.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:37 11 0200-jpatoscacapabilitytype_properties.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:37 12 0210-jpatoscadatatype_constraints.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:38 13 0220-jpatoscadatatype_metadata.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:38 14 0230-jpatoscadatatype_properties.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:39 15 0240-jpatoscanodetemplate_metadata.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:39 16 0250-jpatoscanodetemplate_properties.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:39 17 0260-jpatoscanodetype_metadata.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:40 18 0270-jpatoscanodetype_properties.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:40 19 0280-jpatoscapolicy_metadata.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:40 20 0290-jpatoscapolicy_properties.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:40 21 0300-jpatoscapolicy_targets.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:41 22 0310-jpatoscapolicytype_metadata.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:41 23 0320-jpatoscapolicytype_properties.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:41 24 0330-jpatoscapolicytype_targets.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:41 25 0340-jpatoscapolicytype_triggers.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:41 26 0350-jpatoscaproperty_constraints.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:42 27 0360-jpatoscaproperty_metadata.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:42 28 0370-jpatoscarelationshiptype_metadata.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:42 29 0380-jpatoscarelationshiptype_properties.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:42 30 0390-jpatoscarequirement_metadata.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:42 31 0400-jpatoscarequirement_occurrences.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:43 32 0410-jpatoscarequirement_properties.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:43 33 0420-jpatoscaservicetemplate_metadata.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:43 34 0430-jpatoscatopologytemplate_inputs.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:43 35 0440-pdpgroup_pdpsubgroup.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:43 36 0450-pdpgroup.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:44 37 0460-pdppolicystatus.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:34:44 38 0470-pdp.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:09 39 0480-pdpstatistics.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:11 40 0490-pdpsubgroup_pdp.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:12 41 0500-pdpsubgroup.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:13 42 0510-toscacapabilityassignment.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:14 43 0520-toscacapabilityassignments.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:14 44 0530-toscacapabilityassignments_toscacapabilityassignment.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:15 45 0540-toscacapabilitytype.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:15 46 0550-toscacapabilitytypes.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:16 47 0560-toscacapabilitytypes_toscacapabilitytype.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:16 48 0570-toscadatatype.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:17 49 0580-toscadatatypes.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:17 50 0590-toscadatatypes_toscadatatype.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:17 51 0600-toscanodetemplate.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:18 52 0610-toscanodetemplates.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:18 53 0620-toscanodetemplates_toscanodetemplate.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:18 54 0630-toscanodetype.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:18 55 0640-toscanodetypes.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:19 56 0650-toscanodetypes_toscanodetype.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:19 57 0660-toscaparameter.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:19 58 0670-toscapolicies.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:19 59 0680-toscapolicies_toscapolicy.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:19 60 0690-toscapolicy.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:20 61 0700-toscapolicytype.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:20 62 0710-toscapolicytypes.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:20 63 0720-toscapolicytypes_toscapolicytype.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:20 64 0730-toscaproperty.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:21 65 0740-toscarelationshiptype.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:21 66 0750-toscarelationshiptypes.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:21 67 0760-toscarelationshiptypes_toscarelationshiptype.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:21 68 0770-toscarequirement.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:21 69 0780-toscarequirements.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:21 70 0790-toscarequirements_toscarequirement.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:22 71 0800-toscaservicetemplate.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:22 72 0810-toscatopologytemplate.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:22 73 0820-toscatrigger.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:22 74 0830-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:22 75 0840-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:22 76 0850-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:22 77 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:23 78 0870-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:23 79 0880-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:23 80 0890-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:23 81 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:23 82 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:23 83 0920-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:23 84 0940-PdpPolicyStatus_PdpGroup.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:23 85 0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:23 86 0960-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:24 87 0970-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:24 88 0980-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:24 89 0990-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:24 90 1000-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:25 91 1010-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:26 92 1020-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:27 93 1030-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:28 94 1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:29 95 1050-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:29 96 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 2004231234310800u 1 2023-04-20 12:35:30 97 0100-pdp.sql upgrade 0800 0900 2004231234310900u 1 2023-04-20 12:35:30 98 0110-idx_tsidx1.sql upgrade 0800 0900 2004231234310900u 1 2023-04-20 12:35:30 99 0120-pk_pdpstatistics.sql upgrade 0800 0900 2004231234310900u 1 2023-04-20 12:35:31 100 0130-pdpstatistics.sql upgrade 0800 0900 2004231234310900u 1 2023-04-20 12:35:31 101 0140-pk_pdpstatistics.sql upgrade 0800 0900 2004231234310900u 1 2023-04-20 12:35:32 102 0150-pdpstatistics.sql upgrade 0800 0900 2004231234310900u 1 2023-04-20 12:35:32 103 0160-jpapdpstatistics_enginestats.sql upgrade 0800 0900 2004231234310900u 1 2023-04-20 12:35:32 104 0170-jpapdpstatistics_enginestats.sql upgrade 0800 0900 2004231234310900u 1 2023-04-20 12:35:32 105 0180-jpapdpstatistics_enginestats.sql upgrade 0800 0900 2004231234310900u 1 2023-04-20 12:35:32 106 0190-jpapolicyaudit.sql upgrade 0800 0900 2004231234310900u 1 2023-04-20 12:35:33 107 0200-JpaPolicyAuditIndex_timestamp.sql upgrade 0800 0900 2004231234310900u 1 2023-04-20 12:35:33 108 0210-sequence.sql upgrade 0800 0900 2004231234310900u 1 2023-04-20 12:35:33 109 0220-sequence.sql upgrade 0800 0900 2004231234310900u 1 2023-04-20 12:35:33 110 0100-jpatoscapolicy_targets.sql upgrade 0900 1000 2004231234311000u 1 2023-04-20 12:35:33 111 0110-jpatoscapolicytype_targets.sql upgrade 0900 1000 2004231234311000u 1 2023-04-20 12:35:33 112 0120-toscatrigger.sql upgrade 0900 1000 2004231234311000u 1 2023-04-20 12:35:34 113 0130-jpatoscapolicytype_triggers.sql upgrade 0900 1000 2004231234311000u 1 2023-04-20 12:35:34 114 0140-toscaparameter.sql upgrade 0900 1000 2004231234311000u 1 2023-04-20 12:35:34 115 0150-toscaproperty.sql upgrade 0900 1000 2004231234311000u 1 2023-04-20 12:35:34 116 0160-jpapolicyaudit_pk.sql upgrade 0900 1000 2004231234311000u 1 2023-04-20 12:35:34 117 0170-pdpstatistics_pk.sql upgrade 0900 1000 2004231234311000u 1 2023-04-20 12:35:35 118 0180-jpatoscanodetemplate_metadata.sql upgrade 0900 1000 2004231234311000u 1 2023-04-20 12:35:35 119 0100-upgrade.sql upgrade 1000 1100 2004231234311100u 1 2023-04-20 12:35:36 120 0100-jpapolicyaudit_renameuser.sql upgrade 1100 1200 2004231234311200u 1 2023-04-20 12:35:37 121 0110-idx_tsidx1.sql upgrade 1100 1200 2004231234311200u 1 2023-04-20 12:35:38 122 0120-audit_sequence.sql upgrade 1100 1200 2004231234311200u 1 2023-04-20 12:35:38 123 0130-statistics_sequence.sql upgrade 1100 1200 2004231234311200u 1 2023-04-20 12:35:39 policyadmin: OK @ 1200