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