diff options
| author |  Vitaly Takmazov | 2022-12-17 21:19:46 +0300 |
|---|---|---|
| committer | Vitaly Takmazov | 2022-12-17 21:19:46 +0300 |
| commit | a6e17eb7aa1366a29a1c23b4bd40a3eb253f8ca9 (patch) | |
| tree | 06a3459016fcb2949fb75086720f3d7fb0f937d4 /src/test/resources/db/specific/postgresql | |
| parent | 32f09ccf94c8ee50444dafa7f468c6e53a1d75df (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.sql | 4 |
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 -- |