Add upgrade/downgrade scripts for postgres in db-migrator 54/126854/1
authorwaynedunican <wayne.dunican@est.tech>
Thu, 6 Jan 2022 14:22:57 +0000 (14:22 +0000)
committerWayne Dunican <wayne.dunican@est.tech>
Thu, 20 Jan 2022 08:35:43 +0000 (08:35 +0000)
commit13541aa7cf430778370bd3571ef42457562a41cd
tree16aa61f0d3a5bb5b9b372a7579393207966080c0
parent794b0c933f409a8cdba8216072103a2abf7207fe
Add upgrade/downgrade scripts for postgres in db-migrator

- Honolulu downgrade scripts

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