aboutsummaryrefslogtreecommitdiff
path: root/src/test/resources/db/specific/postgresql
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2022-12-17 21:19:46 +0300
committerGravatar Vitaly Takmazov2022-12-17 21:19:46 +0300
commita6e17eb7aa1366a29a1c23b4bd40a3eb253f8ca9 (patch)
tree06a3459016fcb2949fb75086720f3d7fb0f937d4 /src/test/resources/db/specific/postgresql
parent32f09ccf94c8ee50444dafa7f468c6e53a1d75df (diff)
postgres: search service
Diffstat (limited to 'src/test/resources/db/specific/postgresql')
-rw-r--r--src/test/resources/db/specific/postgresql/V1.22__schema.sql4
1 files changed, 3 insertions, 1 deletions
diff --git a/src/test/resources/db/specific/postgresql/V1.22__schema.sql b/src/test/resources/db/specific/postgresql/V1.22__schema.sql
index fbd50408..aab050a6 100644
--- a/src/test/resources/db/specific/postgresql/V1.22__schema.sql
+++ b/src/test/resources/db/specific/postgresql/V1.22__schema.sql
@@ -199,7 +199,7 @@ CREATE TABLE public.favorites (
message_id bigint NOT NULL,
ts timestamp with time zone,
like_id smallint DEFAULT 1 NOT NULL,
- user_uri character varying(255) DEFAULT ''::character varying
+ user_uri character varying(255) NOT NULL DEFAULT ''::character varying
);
@@ -423,6 +423,8 @@ CREATE TABLE public.messages_txt (
ALTER TABLE public.messages_txt OWNER TO juick;
+CREATE INDEX messages_idx ON messages_txt USING GIN (to_tsvector('russian', txt));
+
--
-- Name: places; Type: TABLE; Schema: public; Owner: juick
--