By type
+ /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
Partial upgrade detected
Upgrade will attempt to resume at 0480-pdpstatistics.sql
upgrade: 0 -> 1200
> 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
--------------
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 0104230000520800u 1 2023-04-01 00:00:52
2 0110-jpapdpstatistics_enginestats.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:52
3 0120-jpapdpsubgroup_policies.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:53
4 0130-jpapdpsubgroup_properties.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:53
5 0140-jpapdpsubgroup_supportedpolicytypes.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:53
6 0150-jpatoscacapabilityassignment_attributes.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:53
7 0160-jpatoscacapabilityassignment_metadata.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:53
8 0170-jpatoscacapabilityassignment_occurrences.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:53
9 0180-jpatoscacapabilityassignment_properties.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:54
10 0190-jpatoscacapabilitytype_metadata.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:54
11 0200-jpatoscacapabilitytype_properties.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:54
12 0210-jpatoscadatatype_constraints.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:54
13 0220-jpatoscadatatype_metadata.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:55
14 0230-jpatoscadatatype_properties.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:56
15 0240-jpatoscanodetemplate_metadata.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:56
16 0250-jpatoscanodetemplate_properties.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:57
17 0260-jpatoscanodetype_metadata.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:57
18 0270-jpatoscanodetype_properties.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:57
19 0280-jpatoscapolicy_metadata.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:58
20 0290-jpatoscapolicy_properties.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:58
21 0300-jpatoscapolicy_targets.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:58
22 0310-jpatoscapolicytype_metadata.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:59
23 0320-jpatoscapolicytype_properties.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:59
24 0330-jpatoscapolicytype_targets.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:00:59
25 0340-jpatoscapolicytype_triggers.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:01:00
26 0350-jpatoscaproperty_constraints.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:01:00
27 0360-jpatoscaproperty_metadata.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:01:00
28 0370-jpatoscarelationshiptype_metadata.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:01:00
29 0380-jpatoscarelationshiptype_properties.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:01:01
30 0390-jpatoscarequirement_metadata.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:01:01
31 0400-jpatoscarequirement_occurrences.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:01:01
32 0410-jpatoscarequirement_properties.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:01:01
33 0420-jpatoscaservicetemplate_metadata.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:01:02
34 0430-jpatoscatopologytemplate_inputs.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:01:02
35 0440-pdpgroup_pdpsubgroup.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:01:02
36 0450-pdpgroup.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:01:02
37 0460-pdppolicystatus.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:01:02
38 0470-pdp.sql upgrade 0 0800 0104230000520800u 1 2023-04-01 00:01:32
39 0480-pdpstatistics.sql upgrade 0 0800 0104230000520800u 0 2023-04-01 00:03:44
40 0480-pdpstatistics.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:07
41 0490-pdpsubgroup_pdp.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:07
42 0500-pdpsubgroup.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:07
43 0510-toscacapabilityassignment.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:08
44 0520-toscacapabilityassignments.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:08
45 0530-toscacapabilityassignments_toscacapabilityassignment.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:08
46 0540-toscacapabilitytype.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:08
47 0550-toscacapabilitytypes.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:08
48 0560-toscacapabilitytypes_toscacapabilitytype.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:08
49 0570-toscadatatype.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:09
50 0580-toscadatatypes.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:09
51 0590-toscadatatypes_toscadatatype.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:09
52 0600-toscanodetemplate.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:09
53 0610-toscanodetemplates.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:09
54 0620-toscanodetemplates_toscanodetemplate.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:09
55 0630-toscanodetype.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:10
56 0640-toscanodetypes.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:10
57 0650-toscanodetypes_toscanodetype.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:10
58 0660-toscaparameter.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:10
59 0670-toscapolicies.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:10
60 0680-toscapolicies_toscapolicy.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:11
61 0690-toscapolicy.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:12
62 0700-toscapolicytype.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:13
63 0710-toscapolicytypes.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:14
64 0720-toscapolicytypes_toscapolicytype.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:15
65 0730-toscaproperty.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:15
66 0740-toscarelationshiptype.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:16
67 0750-toscarelationshiptypes.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:16
68 0760-toscarelationshiptypes_toscarelationshiptype.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:17
69 0770-toscarequirement.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:17
70 0780-toscarequirements.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:18
71 0790-toscarequirements_toscarequirement.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:18
72 0800-toscaservicetemplate.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:18
73 0810-toscatopologytemplate.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:18
74 0820-toscatrigger.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:19
75 0830-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:19
76 0840-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:19
77 0850-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:20
78 0860-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:20
79 0870-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:20
80 0880-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:20
81 0890-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:21
82 0900-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:21
83 0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:21
84 0920-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:21
85 0940-PdpPolicyStatus_PdpGroup.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:22
86 0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:22
87 0960-FK_ToscaNodeTemplate_capabilitiesName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:22
88 0970-FK_ToscaNodeTemplate_requirementsName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:23
89 0980-FK_ToscaNodeType_requirementsName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:23
90 0990-FK_ToscaServiceTemplate_capabilityTypesName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:23
91 1000-FK_ToscaServiceTemplate_dataTypesName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:24
92 1010-FK_ToscaServiceTemplate_nodeTypesName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:24
93 1020-FK_ToscaServiceTemplate_policyTypesName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:24
94 1030-FK_ToscaServiceTemplate_relationshipTypesName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:25
95 1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:25
96 1050-FK_ToscaTopologyTemplate_policyName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:25
97 1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql upgrade 0 0800 0104230004060800u 1 2023-04-01 00:04:26
policyadmin: OK @ 1200