diff options
Diffstat (limited to 'src/test/resources/db/specific')
| -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 -- |