diff options
Diffstat (limited to 'src/test/resources/db/specific/postgresql')
-rw-r--r-- | src/test/resources/db/specific/postgresql/V1.00__schema.sql | 16 |
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 ); |