diff options
author | waynedunican <wayne.dunican@est.tech> | 2022-01-07 09:33:06 +0000 |
---|---|---|
committer | Wayne Dunican <wayne.dunican@est.tech> | 2022-01-20 08:36:14 +0000 |
commit | cc6bd6f2287c9681d2f8cbdec7ec621a7f261c3c (patch) | |
tree | bd9145c51b8e560969a805157340d814b55bec45 /policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0510-toscacapabilityassignment.sql | |
parent | 794b0c933f409a8cdba8216072103a2abf7207fe (diff) |
Add upgrade/downgrade scripts for postgres in db-migrator
- Honolulu upgrade scripts
Issue-ID: POLICY-2715
Change-Id: I1cec6f16c4797bd1ce34d506173d28ae48e36801
Signed-off-by: Wayne Dunican <wayne.dunican@est.tech>
Diffstat (limited to 'policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0510-toscacapabilityassignment.sql')
-rw-r--r-- | policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0510-toscacapabilityassignment.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0510-toscacapabilityassignment.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0510-toscacapabilityassignment.sql new file mode 100644 index 00000000..d7d91c2d --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/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========================================================= + */ + +CREATE TABLE IF NOT EXISTS toscacapabilityassignment (DESCRIPTION VARCHAR(255) NULL, derived_from_name VARCHAR(255) NULL, derived_from_version VARCHAR(255) NULL, name VARCHAR(120) NOT NULL, version VARCHAR(20) NOT NULL, type_name VARCHAR(255) NULL, type_version VARCHAR(255) NULL, CONSTRAINT PK_TOSCACAPABILITYASSIGNMENT PRIMARY KEY (name, version)); |