From a428e7043ba544adda4b15b557193079c4e57444 Mon Sep 17 00:00:00 2001 From: "adheli.tavares" Date: Wed, 14 Sep 2022 20:34:03 +0100 Subject: Change the properties column type to hibernate/postgres match. - changing the type to bigint because pap was having side effects errors with the bytea forced cast Issue-ID: POLICY-4352 Change-Id: I368c3ba80fce0c10d9417deee8f9ac25c467d4e3 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(-) 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 38606a3e..7a926102 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 USING 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 BIGINT NULL DEFAULT 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 a459d3fa..76a4a50d 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 USING 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 BIGINT NULL DEFAULT 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 88c48264..ec3f499e 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 USING 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 BIGINT NULL DEFAULT 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 bf01cc7b..43e9bb40 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 USING 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 BIGINT NULL DEFAULT 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 0d9e75d6..8c4c07c1 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 USING 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 BIGINT NULL DEFAULT NULL, PROPERTIES_KEY VARCHAR(255) NULL); -- cgit 1.2.3-korg