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/0590-toscadatatypes_toscadatatype.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/0590-toscadatatypes_toscadatatype.sql')
-rw-r--r-- | policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0590-toscadatatypes_toscadatatype.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0590-toscadatatypes_toscadatatype.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0590-toscadatatypes_toscadatatype.sql new file mode 100644 index 00000000..c3461792 --- /dev/null +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/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========================================================= + */ + +CREATE TABLE IF NOT EXISTS toscadatatypes_toscadatatype (conceptContainerMapName VARCHAR(120) NOT NULL, concpetContainerMapVersion VARCHAR(20) NOT NULL, conceptContainerName VARCHAR(120) NOT NULL, conceptContainerVersion VARCHAR(20) NOT NULL, name VARCHAR(120) NULL, version VARCHAR(20) NULL, CONSTRAINT PK_TOSCADATATYPES_TOSCADATATYPE PRIMARY KEY (conceptContainerMapName, concpetContainerMapVersion, conceptContainerName, conceptContainerVersion)); |