Add upgrade/downgrade scripts for postgres in db-migrator 53/126853/1
authorwaynedunican <wayne.dunican@est.tech>
Fri, 7 Jan 2022 09:33:06 +0000 (09:33 +0000)
committerWayne Dunican <wayne.dunican@est.tech>
Thu, 20 Jan 2022 08:36:14 +0000 (08:36 +0000)
commitcc6bd6f2287c9681d2f8cbdec7ec621a7f261c3c
treebd9145c51b8e560969a805157340d814b55bec45
parent794b0c933f409a8cdba8216072103a2abf7207fe
Add upgrade/downgrade scripts for postgres in db-migrator

- Honolulu upgrade scripts

Issue-ID: POLICY-2715
Change-Id: I1cec6f16c4797bd1ce34d506173d28ae48e36801
Signed-off-by: Wayne Dunican <wayne.dunican@est.tech>
96 files changed:
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0100-jpapdpgroup_properties.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0110-jpapdpstatistics_enginestats.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0120-jpapdpsubgroup_policies.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0130-jpapdpsubgroup_properties.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0140-jpapdpsubgroup_supportedpolicytypes.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0150-jpatoscacapabilityassignment_attributes.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0160-jpatoscacapabilityassignment_metadata.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0170-jpatoscacapabilityassignment_occurrences.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0180-jpatoscacapabilityassignment_properties.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0190-jpatoscacapabilitytype_metadata.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0200-jpatoscacapabilitytype_properties.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0210-jpatoscadatatype_constraints.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0220-jpatoscadatatype_metadata.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0230-jpatoscadatatype_properties.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0240-jpatoscanodetemplate_metadata.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0250-jpatoscanodetemplate_properties.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0260-jpatoscanodetype_metadata.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0270-jpatoscanodetype_properties.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0280-jpatoscapolicy_metadata.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0290-jpatoscapolicy_properties.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0300-jpatoscapolicy_targets.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0310-jpatoscapolicytype_metadata.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0320-jpatoscapolicytype_properties.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0330-jpatoscapolicytype_targets.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0340-jpatoscapolicytype_triggers.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0350-jpatoscaproperty_constraints.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0360-jpatoscaproperty_metadata.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0370-jpatoscarelationshiptype_metadata.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0380-jpatoscarelationshiptype_properties.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0390-jpatoscarequirement_metadata.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0400-jpatoscarequirement_occurrences.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0410-jpatoscarequirement_properties.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0420-jpatoscaservicetemplate_metadata.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0430-jpatoscatopologytemplate_inputs.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0440-pdpgroup_pdpsubgroup.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0450-pdpgroup.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0460-pdppolicystatus.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0470-pdp.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0480-pdpstatistics.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0490-pdpsubgroup_pdp.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0500-pdpsubgroup.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0510-toscacapabilityassignment.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0520-toscacapabilityassignments.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0530-toscacapabilityassignments_toscacapabilityassignment.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0540-toscacapabilitytype.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0550-toscacapabilitytypes.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0560-toscacapabilitytypes_toscacapabilitytype.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0570-toscadatatype.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0580-toscadatatypes.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0590-toscadatatypes_toscadatatype.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0600-toscanodetemplate.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0610-toscanodetemplates.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0620-toscanodetemplates_toscanodetemplate.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0630-toscanodetype.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0640-toscanodetypes.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0650-toscanodetypes_toscanodetype.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0660-toscaparameter.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0670-toscapolicies.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0680-toscapolicies_toscapolicy.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0690-toscapolicy.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0700-toscapolicytype.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0710-toscapolicytypes.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0720-toscapolicytypes_toscapolicytype.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0730-toscaproperty.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0740-toscarelationshiptype.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0750-toscarelationshiptypes.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0760-toscarelationshiptypes_toscarelationshiptype.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0770-toscarequirement.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0780-toscarequirements.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0790-toscarequirements_toscarequirement.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0800-toscaservicetemplate.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0810-toscatopologytemplate.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0820-toscatrigger.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0830-FK_ToscaNodeTemplate_capabilitiesName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0840-FK_ToscaNodeTemplate_requirementsName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0850-FK_ToscaNodeType_requirementsName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0860-FK_ToscaServiceTemplate_capabilityTypesName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0870-FK_ToscaServiceTemplate_dataTypesName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0880-FK_ToscaServiceTemplate_nodeTypesName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0890-FK_ToscaServiceTemplate_policyTypesName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0900-FK_ToscaServiceTemplate_relationshipTypesName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0920-FK_ToscaTopologyTemplate_policyName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0940-PdpPolicyStatus_PdpGroup.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0960-FK_ToscaNodeTemplate_capabilitiesName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0970-FK_ToscaNodeTemplate_requirementsName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0980-FK_ToscaNodeType_requirementsName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0990-FK_ToscaServiceTemplate_capabilityTypesName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/1000-FK_ToscaServiceTemplate_dataTypesName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/1010-FK_ToscaServiceTemplate_nodeTypesName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/1020-FK_ToscaServiceTemplate_policyTypesName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/1030-FK_ToscaServiceTemplate_relationshipTypesName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/1050-FK_ToscaTopologyTemplate_policyName.sql [new file with mode: 0644]
policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql [new file with mode: 0644]