aboutsummaryrefslogtreecommitdiff
path: root/src/test/resources/db/specific/postgresql
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2022-12-15 15:43:41 +0300
committerGravatar Vitaly Takmazov2022-12-15 15:43:41 +0300
commitea4910a937f2e9310ad328bc47237662f8bcbd2c (patch)
tree8ae6c89a69a61c35ae9eb333e56814372c72510e /src/test/resources/db/specific/postgresql
parentde3834478f722a1790f0b65cc86a6e5b29fbf16a (diff)
postgres: pass tests without implicit string types casts
Diffstat (limited to 'src/test/resources/db/specific/postgresql')
-rw-r--r--src/test/resources/db/specific/postgresql/V1.00__schema.sql16
1 files changed, 2 insertions, 14 deletions
diff --git a/src/test/resources/db/specific/postgresql/V1.00__schema.sql b/src/test/resources/db/specific/postgresql/V1.00__schema.sql
index 4909000a..f400ddfa 100644
--- a/src/test/resources/db/specific/postgresql/V1.00__schema.sql
+++ b/src/test/resources/db/specific/postgresql/V1.00__schema.sql
@@ -36,6 +36,7 @@ CREATE TYPE messages_attach AS ENUM (
'png'
);
+CREATE CAST (character varying AS messages_attach) WITH INOUT AS ASSIGNMENT;
ALTER TYPE messages_attach OWNER TO juick;
@@ -55,19 +56,6 @@ CREATE TYPE messages_lang AS ENUM (
ALTER TYPE messages_lang OWNER TO juick;
--
--- Name: replies_attach; Type: TYPE; Schema: public; Owner: juick
---
-
-CREATE TYPE replies_attach AS ENUM (
- 'jpg',
- 'mp4',
- 'png'
-);
-
-
-ALTER TYPE replies_attach OWNER TO juick;
-
---
-- Name: users_lang; Type: TYPE; Schema: public; Owner: juick
--
@@ -640,7 +628,7 @@ CREATE TABLE replies (
user_id bigint NOT NULL,
replyto smallint DEFAULT 0::smallint NOT NULL,
ts timestamp with time zone DEFAULT now() NOT NULL,
- attach replies_attach,
+ attach messages_attach,
txt text NOT NULL
);