From 0d5da012af002296a02eb4de542e2c7567265c21 Mon Sep 17 00:00:00 2001 From: "adheli.tavares" Date: Wed, 7 Sep 2022 13:02:06 +0100 Subject: Fix casting of lob type on db-migrator for postgres installation Issue-ID: POLICY-4352 Change-Id: Ib3aa68a512c1278920a8bdf1ed29914195d0e371 Signed-off-by: adheli.tavares --- .../postgres/0800/upgrade/0200-jpatoscacapabilitytype_properties.sql | 2 +- .../postgres/0800/upgrade/0230-jpatoscadatatype_properties.sql | 2 +- .../postgres/0800/upgrade/0270-jpatoscanodetype_properties.sql | 2 +- .../postgres/0800/upgrade/0320-jpatoscapolicytype_properties.sql | 2 +- .../postgres/0800/upgrade/0380-jpatoscarelationshiptype_properties.sql | 2 +- 5 files changed, 5 insertions(+), 5 deletions(-) (limited to 'policy-db-migrator/src') diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0200-jpatoscacapabilitytype_properties.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0200-jpatoscacapabilitytype_properties.sql index 4720a4bf..38606a3e 100644 --- a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0200-jpatoscacapabilitytype_properties.sql +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0200-jpatoscacapabilitytype_properties.sql @@ -17,4 +17,4 @@ * ============LICENSE_END========================================================= */ -CREATE TABLE IF NOT EXISTS jpatoscacapabilitytype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES BYTEA DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL); +CREATE TABLE IF NOT EXISTS jpatoscacapabilitytype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES BYTEA USING PROPERTIES::bytea DEFAULT NULL NULL , PROPERTIES_KEY VARCHAR(255) NULL); diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0230-jpatoscadatatype_properties.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0230-jpatoscadatatype_properties.sql index 2268779e..a459d3fa 100644 --- a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0230-jpatoscadatatype_properties.sql +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0230-jpatoscadatatype_properties.sql @@ -17,4 +17,4 @@ * ============LICENSE_END========================================================= */ -CREATE TABLE IF NOT EXISTS jpatoscadatatype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES BYTEA DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL); +CREATE TABLE IF NOT EXISTS jpatoscadatatype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES BYTEA USING PROPERTIES::bytea DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL); diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0270-jpatoscanodetype_properties.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0270-jpatoscanodetype_properties.sql index a48e3aa3..88c48264 100644 --- a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0270-jpatoscanodetype_properties.sql +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0270-jpatoscanodetype_properties.sql @@ -17,4 +17,4 @@ * ============LICENSE_END========================================================= */ -CREATE TABLE IF NOT EXISTS jpatoscanodetype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES BYTEA DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL); +CREATE TABLE IF NOT EXISTS jpatoscanodetype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES BYTEA USING PROPERTIES::bytea DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL); diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0320-jpatoscapolicytype_properties.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0320-jpatoscapolicytype_properties.sql index 32fbde5c..bf01cc7b 100644 --- a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0320-jpatoscapolicytype_properties.sql +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0320-jpatoscapolicytype_properties.sql @@ -17,4 +17,4 @@ * ============LICENSE_END========================================================= */ -CREATE TABLE IF NOT EXISTS jpatoscapolicytype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES BYTEA DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL); +CREATE TABLE IF NOT EXISTS jpatoscapolicytype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES BYTEA USING PROPERTIES::bytea DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL); diff --git a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0380-jpatoscarelationshiptype_properties.sql b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0380-jpatoscarelationshiptype_properties.sql index e4ac7384..0d9e75d6 100644 --- a/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0380-jpatoscarelationshiptype_properties.sql +++ b/policy-db-migrator/src/main/docker/config/policyadmin/postgres/0800/upgrade/0380-jpatoscarelationshiptype_properties.sql @@ -17,4 +17,4 @@ * ============LICENSE_END========================================================= */ -CREATE TABLE IF NOT EXISTS jpatoscarelationshiptype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES BYTEA DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL); +CREATE TABLE IF NOT EXISTS jpatoscarelationshiptype_properties (name VARCHAR(120) NULL, version VARCHAR(20) NULL, PROPERTIES BYTEA USING PROPERTIES::bytea DEFAULT NULL NULL, PROPERTIES_KEY VARCHAR(255) NULL); -- cgit 1.2.3-korg