From a6e17eb7aa1366a29a1c23b4bd40a3eb253f8ca9 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Sat, 17 Dec 2022 21:19:46 +0300
Subject: postgres: search service

---
 src/test/resources/db/specific/postgresql/V1.22__schema.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'src/test/resources/db/specific/postgresql/V1.22__schema.sql')

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
 --
-- 
cgit v1.2.3

