diff options
| author |   waynedunican <wayne.dunican@est.tech> | 2022-01-06 14:22:57 +0000 |
|---|---|---|
| committer | Wayne Dunican <wayne.dunican@est.tech> | 2022-01-20 08:35:43 +0000 |
| commit | 13541aa7cf430778370bd3571ef42457562a41cd (patch) | |
| tree | 16aa61f0d3a5bb5b9b372a7579393207966080c0 | |
| parent | 794b0c933f409a8cdba8216072103a2abf7207fe (diff) | |
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, 1920 insertions, 0 deletions
diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0100-jpapdpgroup_properties.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0100-jpapdpgroup_properties.sql new file mode 100644 index 00000000..742c3c39 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0100-jpapdpgroup_properties.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpapdpgroup_properties; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0110-jpapdpstatistics_enginestats.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0110-jpapdpstatistics_enginestats.sql new file mode 100644 index 00000000..cdd6f888 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0110-jpapdpstatistics_enginestats.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpapdpstatistics_enginestats; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0120-jpapdpsubgroup_policies.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0120-jpapdpsubgroup_policies.sql new file mode 100644 index 00000000..d1daac4f --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0120-jpapdpsubgroup_policies.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpapdpsubgroup_policies; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0130-jpapdpsubgroup_properties.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0130-jpapdpsubgroup_properties.sql new file mode 100644 index 00000000..5e2282ff --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0130-jpapdpsubgroup_properties.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpapdpsubgroup_properties; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0140-jpapdpsubgroup_supportedpolicytypes.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0140-jpapdpsubgroup_supportedpolicytypes.sql new file mode 100644 index 00000000..6fa8f4b4 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0140-jpapdpsubgroup_supportedpolicytypes.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpapdpsubgroup_supportedpolicytypes; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0150-jpatoscacapabilityassignment_attributes.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0150-jpatoscacapabilityassignment_attributes.sql new file mode 100644 index 00000000..c8f9802c --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0150-jpatoscacapabilityassignment_attributes.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscacapabilityassignment_attributes; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0160-jpatoscacapabilityassignment_metadata.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0160-jpatoscacapabilityassignment_metadata.sql new file mode 100644 index 00000000..28cc0372 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0160-jpatoscacapabilityassignment_metadata.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscacapabilityassignment_metadata; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0170-jpatoscacapabilityassignment_occurrences.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0170-jpatoscacapabilityassignment_occurrences.sql new file mode 100644 index 00000000..9d2dbd59 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0170-jpatoscacapabilityassignment_occurrences.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscacapabilityassignment_occurrences; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0180-jpatoscacapabilityassignment_properties.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0180-jpatoscacapabilityassignment_properties.sql new file mode 100644 index 00000000..c52de8bc --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0180-jpatoscacapabilityassignment_properties.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscacapabilityassignment_properties; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0190-jpatoscacapabilitytype_metadata.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0190-jpatoscacapabilitytype_metadata.sql new file mode 100644 index 00000000..b5e1bf67 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0190-jpatoscacapabilitytype_metadata.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscacapabilitytype_metadata; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0200-jpatoscacapabilitytype_properties.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0200-jpatoscacapabilitytype_properties.sql new file mode 100644 index 00000000..967b7cf3 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0200-jpatoscacapabilitytype_properties.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscacapabilitytype_properties; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0210-jpatoscadatatype_constraints.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0210-jpatoscadatatype_constraints.sql new file mode 100644 index 00000000..10164a81 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0210-jpatoscadatatype_constraints.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscadatatype_constraints; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0220-jpatoscadatatype_metadata.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0220-jpatoscadatatype_metadata.sql new file mode 100644 index 00000000..0c2ffa85 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0220-jpatoscadatatype_metadata.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscadatatype_metadata; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0230-jpatoscadatatype_properties.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0230-jpatoscadatatype_properties.sql new file mode 100644 index 00000000..dd47d306 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0230-jpatoscadatatype_properties.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscadatatype_properties; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0240-jpatoscanodetemplate_metadata.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0240-jpatoscanodetemplate_metadata.sql new file mode 100644 index 00000000..f77c8184 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0240-jpatoscanodetemplate_metadata.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscanodetemplate_metadata; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0250-jpatoscanodetemplate_properties.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0250-jpatoscanodetemplate_properties.sql new file mode 100644 index 00000000..65ea2665 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0250-jpatoscanodetemplate_properties.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscanodetemplate_properties; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0260-jpatoscanodetype_metadata.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0260-jpatoscanodetype_metadata.sql new file mode 100644 index 00000000..547fd5b8 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0260-jpatoscanodetype_metadata.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscanodetype_metadata; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0270-jpatoscanodetype_properties.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0270-jpatoscanodetype_properties.sql new file mode 100644 index 00000000..4e6d09c6 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0270-jpatoscanodetype_properties.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscanodetype_properties; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0280-jpatoscapolicy_metadata.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0280-jpatoscapolicy_metadata.sql new file mode 100644 index 00000000..b5a14c42 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0280-jpatoscapolicy_metadata.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscapolicy_metadata; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0290-jpatoscapolicy_properties.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0290-jpatoscapolicy_properties.sql new file mode 100644 index 00000000..7ec88c11 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0290-jpatoscapolicy_properties.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscapolicy_properties; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0300-jpatoscapolicy_targets.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0300-jpatoscapolicy_targets.sql new file mode 100644 index 00000000..ccd93e99 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0300-jpatoscapolicy_targets.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscapolicy_targets; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0310-jpatoscapolicytype_metadata.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0310-jpatoscapolicytype_metadata.sql new file mode 100644 index 00000000..7978620f --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0310-jpatoscapolicytype_metadata.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscapolicytype_metadata; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0320-jpatoscapolicytype_properties.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0320-jpatoscapolicytype_properties.sql new file mode 100644 index 00000000..f9bd2a21 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0320-jpatoscapolicytype_properties.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscapolicytype_properties; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0330-jpatoscapolicytype_targets.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0330-jpatoscapolicytype_targets.sql new file mode 100644 index 00000000..feced0fd --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0330-jpatoscapolicytype_targets.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscapolicytype_targets; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0340-jpatoscapolicytype_triggers.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0340-jpatoscapolicytype_triggers.sql new file mode 100644 index 00000000..cb01ee7f --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0340-jpatoscapolicytype_triggers.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscapolicytype_triggers; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0350-jpatoscaproperty_constraints.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0350-jpatoscaproperty_constraints.sql new file mode 100644 index 00000000..75f2e40a --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0350-jpatoscaproperty_constraints.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscaproperty_constraints; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0360-jpatoscaproperty_metadata.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0360-jpatoscaproperty_metadata.sql new file mode 100644 index 00000000..3321330e --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0360-jpatoscaproperty_metadata.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscaproperty_metadata; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0370-jpatoscarelationshiptype_metadata.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0370-jpatoscarelationshiptype_metadata.sql new file mode 100644 index 00000000..546a5810 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0370-jpatoscarelationshiptype_metadata.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscarelationshiptype_metadata; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0380-jpatoscarelationshiptype_properties.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0380-jpatoscarelationshiptype_properties.sql new file mode 100644 index 00000000..babb6014 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0380-jpatoscarelationshiptype_properties.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscarelationshiptype_properties; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0390-jpatoscarequirement_metadata.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0390-jpatoscarequirement_metadata.sql new file mode 100644 index 00000000..611e7752 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0390-jpatoscarequirement_metadata.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscarequirement_metadata; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0400-jpatoscarequirement_occurrences.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0400-jpatoscarequirement_occurrences.sql new file mode 100644 index 00000000..aa73cfff --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0400-jpatoscarequirement_occurrences.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscarequirement_occurrences; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0410-jpatoscarequirement_properties.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0410-jpatoscarequirement_properties.sql new file mode 100644 index 00000000..bb193bd1 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0410-jpatoscarequirement_properties.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscarequirement_properties; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0420-jpatoscaservicetemplate_metadata.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0420-jpatoscaservicetemplate_metadata.sql new file mode 100644 index 00000000..61495dae --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0420-jpatoscaservicetemplate_metadata.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscaservicetemplate_metadata; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0430-jpatoscatopologytemplate_inputs.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0430-jpatoscatopologytemplate_inputs.sql new file mode 100644 index 00000000..0703e927 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0430-jpatoscatopologytemplate_inputs.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS jpatoscatopologytemplate_inputs; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0440-pdpgroup_pdpsubgroup.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0440-pdpgroup_pdpsubgroup.sql new file mode 100644 index 00000000..ff65b1cb --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0440-pdpgroup_pdpsubgroup.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS pdpgroup_pdpsubgroup; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0450-pdpgroup.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0450-pdpgroup.sql new file mode 100644 index 00000000..88372350 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0450-pdpgroup.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS pdpgroup; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0460-pdppolicystatus.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0460-pdppolicystatus.sql new file mode 100644 index 00000000..b9ceafb8 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0460-pdppolicystatus.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS pdppolicystatus; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0470-pdp.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0470-pdp.sql new file mode 100644 index 00000000..7b127b7a --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0470-pdp.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS pdp; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0480-pdpstatistics.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0480-pdpstatistics.sql new file mode 100644 index 00000000..e9bf185c --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0480-pdpstatistics.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS pdpstatistics; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0490-pdpsubgroup_pdp.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0490-pdpsubgroup_pdp.sql new file mode 100644 index 00000000..6dfb80f9 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0490-pdpsubgroup_pdp.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS pdpsubgroup_pdp; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0500-pdpsubgroup.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0500-pdpsubgroup.sql new file mode 100644 index 00000000..7cfa14c8 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0500-pdpsubgroup.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS pdpsubgroup; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0510-toscacapabilityassignment.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0510-toscacapabilityassignment.sql new file mode 100644 index 00000000..86552a1b --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0510-toscacapabilityassignment.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscacapabilityassignment; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0520-toscacapabilityassignments.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0520-toscacapabilityassignments.sql new file mode 100644 index 00000000..e29d798a --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0520-toscacapabilityassignments.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscacapabilityassignments; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0530-toscacapabilityassignments_toscacapabilityassignment.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0530-toscacapabilityassignments_toscacapabilityassignment.sql new file mode 100644 index 00000000..6a95ade1 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0530-toscacapabilityassignments_toscacapabilityassignment.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscacapabilityassignments_toscacapabilityassignment; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0540-toscacapabilitytype.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0540-toscacapabilitytype.sql new file mode 100644 index 00000000..62fe7955 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0540-toscacapabilitytype.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscacapabilitytype; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0550-toscacapabilitytypes.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0550-toscacapabilitytypes.sql new file mode 100644 index 00000000..2da7e0aa --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0550-toscacapabilitytypes.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscacapabilitytypes; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0560-toscacapabilitytypes_toscacapabilitytype.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0560-toscacapabilitytypes_toscacapabilitytype.sql new file mode 100644 index 00000000..385652e8 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0560-toscacapabilitytypes_toscacapabilitytype.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscacapabilitytypes_toscacapabilitytype; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0570-toscadatatype.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0570-toscadatatype.sql new file mode 100644 index 00000000..36e4926a --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0570-toscadatatype.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscadatatype; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0580-toscadatatypes.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0580-toscadatatypes.sql new file mode 100644 index 00000000..57c3115c --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0580-toscadatatypes.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscadatatypes; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0590-toscadatatypes_toscadatatype.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0590-toscadatatypes_toscadatatype.sql new file mode 100644 index 00000000..8586ea66 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0590-toscadatatypes_toscadatatype.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscadatatypes_toscadatatype; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0600-toscanodetemplate.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0600-toscanodetemplate.sql new file mode 100644 index 00000000..3e8ef517 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0600-toscanodetemplate.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscanodetemplate; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0610-toscanodetemplates.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0610-toscanodetemplates.sql new file mode 100644 index 00000000..ca531420 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0610-toscanodetemplates.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscanodetemplates; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0620-toscanodetemplates_toscanodetemplate.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0620-toscanodetemplates_toscanodetemplate.sql new file mode 100644 index 00000000..a2f3ce32 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0620-toscanodetemplates_toscanodetemplate.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscanodetemplates_toscanodetemplate; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0630-toscanodetype.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0630-toscanodetype.sql new file mode 100644 index 00000000..8677afa3 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0630-toscanodetype.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscanodetype; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0640-toscanodetypes.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0640-toscanodetypes.sql new file mode 100644 index 00000000..b3941198 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0640-toscanodetypes.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscanodetypes; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0650-toscanodetypes_toscanodetype.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0650-toscanodetypes_toscanodetype.sql new file mode 100644 index 00000000..2cd8607c --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0650-toscanodetypes_toscanodetype.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscanodetypes_toscanodetype; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0660-toscaparameter.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0660-toscaparameter.sql new file mode 100644 index 00000000..02c7a738 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0660-toscaparameter.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscaparameter; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0670-toscapolicies.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0670-toscapolicies.sql new file mode 100644 index 00000000..e53908e8 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0670-toscapolicies.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscapolicies; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0680-toscapolicies_toscapolicy.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0680-toscapolicies_toscapolicy.sql new file mode 100644 index 00000000..88f7fad6 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0680-toscapolicies_toscapolicy.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscapolicies_toscapolicy; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0690-toscapolicy.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0690-toscapolicy.sql new file mode 100644 index 00000000..a81f925f --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0690-toscapolicy.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscapolicy; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0700-toscapolicytype.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0700-toscapolicytype.sql new file mode 100644 index 00000000..7a526e61 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0700-toscapolicytype.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscapolicytype; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0710-toscapolicytypes.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0710-toscapolicytypes.sql new file mode 100644 index 00000000..afd60829 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0710-toscapolicytypes.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscapolicytypes; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0720-toscapolicytypes_toscapolicytype.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0720-toscapolicytypes_toscapolicytype.sql new file mode 100644 index 00000000..3ae1ca27 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0720-toscapolicytypes_toscapolicytype.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscapolicytypes_toscapolicytype; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0730-toscaproperty.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0730-toscaproperty.sql new file mode 100644 index 00000000..e5e7ebf5 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0730-toscaproperty.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscaproperty; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0740-toscarelationshiptype.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0740-toscarelationshiptype.sql new file mode 100644 index 00000000..ba596f0d --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0740-toscarelationshiptype.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscarelationshiptype; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0750-toscarelationshiptypes.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0750-toscarelationshiptypes.sql new file mode 100644 index 00000000..417922a8 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0750-toscarelationshiptypes.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscarelationshiptypes; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0760-toscarelationshiptypes_toscarelationshiptype.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0760-toscarelationshiptypes_toscarelationshiptype.sql new file mode 100644 index 00000000..dc40af52 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0760-toscarelationshiptypes_toscarelationshiptype.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscarelationshiptypes_toscarelationshiptype; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0770-toscarequirement.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0770-toscarequirement.sql new file mode 100644 index 00000000..0b674d56 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0770-toscarequirement.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscarequirement; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0780-toscarequirements.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0780-toscarequirements.sql new file mode 100644 index 00000000..02af777b --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0780-toscarequirements.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscarequirements; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0790-toscarequirements_toscarequirement.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0790-toscarequirements_toscarequirement.sql new file mode 100644 index 00000000..2680d447 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0790-toscarequirements_toscarequirement.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscarequirements_toscarequirement; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0800-toscaservicetemplate.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0800-toscaservicetemplate.sql new file mode 100644 index 00000000..4ab34491 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0800-toscaservicetemplate.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscaservicetemplate; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0810-toscatopologytemplate.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0810-toscatopologytemplate.sql new file mode 100644 index 00000000..82f38618 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0810-toscatopologytemplate.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscatopologytemplate; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0820-toscatrigger.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0820-toscatrigger.sql new file mode 100644 index 00000000..d9af7cb8 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0820-toscatrigger.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0;the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP TABLE IF EXISTS toscatrigger; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0830-FK_ToscaNodeTemplate_capabilitiesName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0830-FK_ToscaNodeTemplate_capabilitiesName.sql new file mode 100644 index 00000000..f1810488 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0830-FK_ToscaNodeTemplate_capabilitiesName.sql @@ -0,0 +1,20 @@ + /* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP INDEX IF EXISTS FK_ToscaNodeTemplate_capabilitiesName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0840-FK_ToscaNodeTemplate_requirementsName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0840-FK_ToscaNodeTemplate_requirementsName.sql new file mode 100644 index 00000000..659400e5 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0840-FK_ToscaNodeTemplate_requirementsName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP INDEX IF EXISTS FK_ToscaNodeTemplate_requirementsName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0850-FK_ToscaNodeType_requirementsName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0850-FK_ToscaNodeType_requirementsName.sql new file mode 100644 index 00000000..96cdd543 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0850-FK_ToscaNodeType_requirementsName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP INDEX IF EXISTS FK_ToscaNodeType_requirementsName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0860-FK_ToscaServiceTemplate_capabilityTypesName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0860-FK_ToscaServiceTemplate_capabilityTypesName.sql new file mode 100644 index 00000000..0cf68728 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0860-FK_ToscaServiceTemplate_capabilityTypesName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP INDEX IF EXISTS FK_ToscaServiceTemplate_capabilityTypesName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0870-FK_ToscaServiceTemplate_dataTypesName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0870-FK_ToscaServiceTemplate_dataTypesName.sql new file mode 100644 index 00000000..13a32b57 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0870-FK_ToscaServiceTemplate_dataTypesName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP INDEX IF EXISTS FK_ToscaServiceTemplate_dataTypesName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0880-FK_ToscaServiceTemplate_nodeTypesName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0880-FK_ToscaServiceTemplate_nodeTypesName.sql new file mode 100644 index 00000000..fb18805c --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0880-FK_ToscaServiceTemplate_nodeTypesName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP INDEX IF EXISTS FK_ToscaServiceTemplate_nodeTypesName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0890-FK_ToscaServiceTemplate_policyTypesName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0890-FK_ToscaServiceTemplate_policyTypesName.sql new file mode 100644 index 00000000..ae6cad90 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0890-FK_ToscaServiceTemplate_policyTypesName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP INDEX IF EXISTS FK_ToscaServiceTemplate_policyTypesName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0900-FK_ToscaServiceTemplate_relationshipTypesName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0900-FK_ToscaServiceTemplate_relationshipTypesName.sql new file mode 100644 index 00000000..ca86eacb --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0900-FK_ToscaServiceTemplate_relationshipTypesName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP INDEX IF EXISTS FK_ToscaServiceTemplate_relationshipTypesName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql new file mode 100644 index 00000000..f1035bb3 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0910-FK_ToscaTopologyTemplate_nodeTemplatesName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP INDEX IF EXISTS FK_ToscaTopologyTemplate_nodeTemplatesName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0920-FK_ToscaTopologyTemplate_policyName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0920-FK_ToscaTopologyTemplate_policyName.sql new file mode 100644 index 00000000..04392ede --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0920-FK_ToscaTopologyTemplate_policyName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP INDEX IF EXISTS FK_ToscaTopologyTemplate_policyName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0940-PdpPolicyStatus_PdpGroup.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0940-PdpPolicyStatus_PdpGroup.sql new file mode 100644 index 00000000..99a9d067 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0940-PdpPolicyStatus_PdpGroup.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP INDEX IF EXISTS PdpPolicyStatus_PdpGroup; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql new file mode 100644 index 00000000..17606302 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0950-TscaServiceTemplatetopologyTemplateParentLocalName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +DROP INDEX IF EXISTS TscaServiceTemplatetopologyTemplateParentLocalName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0960-FK_ToscaNodeTemplate_capabilitiesName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0960-FK_ToscaNodeTemplate_capabilitiesName.sql new file mode 100644 index 00000000..4dccc452 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0960-FK_ToscaNodeTemplate_capabilitiesName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +ALTER TABLE toscanodetemplate DROP CONSTRAINT IF EXISTS FK_ToscaNodeTemplate_capabilitiesName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0970-FK_ToscaNodeTemplate_requirementsName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0970-FK_ToscaNodeTemplate_requirementsName.sql new file mode 100644 index 00000000..a079be09 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0970-FK_ToscaNodeTemplate_requirementsName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +ALTER TABLE toscanodetemplate DROP CONSTRAINT IF EXISTS FK_ToscaNodeTemplate_requirementsName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0980-FK_ToscaNodeType_requirementsName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0980-FK_ToscaNodeType_requirementsName.sql new file mode 100644 index 00000000..59f43c02 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0980-FK_ToscaNodeType_requirementsName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +ALTER TABLE toscanodetype DROP CONSTRAINT IF EXISTS FK_ToscaNodeType_requirementsName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0990-FK_ToscaServiceTemplate_capabilityTypesName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0990-FK_ToscaServiceTemplate_capabilityTypesName.sql new file mode 100644 index 00000000..1372b622 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/0990-FK_ToscaServiceTemplate_capabilityTypesName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +ALTER TABLE toscaservicetemplate DROP CONSTRAINT IF EXISTS FK_ToscaServiceTemplate_capabilityTypesName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1000-FK_ToscaServiceTemplate_dataTypesName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1000-FK_ToscaServiceTemplate_dataTypesName.sql new file mode 100644 index 00000000..84d9aa3b --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1000-FK_ToscaServiceTemplate_dataTypesName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +ALTER TABLE toscaservicetemplate DROP CONSTRAINT IF EXISTS FK_ToscaServiceTemplate_dataTypesName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1010-FK_ToscaServiceTemplate_nodeTypesName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1010-FK_ToscaServiceTemplate_nodeTypesName.sql new file mode 100644 index 00000000..0bafbb5d --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1010-FK_ToscaServiceTemplate_nodeTypesName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +ALTER TABLE toscaservicetemplate DROP CONSTRAINT IF EXISTS FK_ToscaServiceTemplate_nodeTypesName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1020-FK_ToscaServiceTemplate_policyTypesName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1020-FK_ToscaServiceTemplate_policyTypesName.sql new file mode 100644 index 00000000..3ab89248 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1020-FK_ToscaServiceTemplate_policyTypesName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +ALTER TABLE toscaservicetemplate DROP CONSTRAINT IF EXISTS FK_ToscaServiceTemplate_policyTypesName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1030-FK_ToscaServiceTemplate_relationshipTypesName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1030-FK_ToscaServiceTemplate_relationshipTypesName.sql new file mode 100644 index 00000000..01595abf --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1030-FK_ToscaServiceTemplate_relationshipTypesName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +ALTER TABLE toscaservicetemplate DROP CONSTRAINT IF EXISTS FK_ToscaServiceTemplate_relationshipTypesName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql new file mode 100644 index 00000000..e96f0a45 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1040-FK_ToscaTopologyTemplate_nodeTemplatesName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +ALTER TABLE toscatopologytemplate DROP CONSTRAINT IF EXISTS FK_ToscaTopologyTemplate_nodeTemplatesName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1050-FK_ToscaTopologyTemplate_policyName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1050-FK_ToscaTopologyTemplate_policyName.sql new file mode 100644 index 00000000..07b6bb18 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1050-FK_ToscaTopologyTemplate_policyName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +ALTER TABLE toscatopologytemplate DROP CONSTRAINT IF EXISTS FK_ToscaTopologyTemplate_policyName; diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql new file mode 100644 index 00000000..de620a43 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/downgrade/1060-TscaServiceTemplatetopologyTemplateParentLocalName.sql @@ -0,0 +1,20 @@ +/* + * ============LICENSE_START======================================================= + * Copyright (C) 2022 Nordix Foundation + * ================================================================================ + * Licensed under the Apache License, Version 2.0 (the "License"); + * you may not use this file except in compliance with the License. + * You may obtain a copy of the License at + * + * http://www.apache.org/licenses/LICENSE-2.0 + * Unless required by applicable law or agreed to in writing, software + * distributed under the License is distributed on an "AS IS" BASIS, + * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + * See the License for the specific language governing permissions and + * limitations under the License. + * + * SPDX-License-Identifier: Apache-2.0 + * ============LICENSE_END========================================================= + */ + +ALTER TABLE toscaservicetemplate DROP CONSTRAINT IF EXISTS TscaServiceTemplatetopologyTemplateParentLocalName; |