aboutsummaryrefslogtreecommitdiff
path: root/src/test/resources/db/specific/postgresql/V1.22__schema.sql
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2022-12-16 20:00:17 +0300
committerGravatar Vitaly Takmazov2022-12-16 20:00:17 +0300
commiteb473d33a1459fecfa1e7194df0572560dabf6ad (patch)
treed635a88dc7a8b9ecf341f1702c0c0e71ae34bab9 /src/test/resources/db/specific/postgresql/V1.22__schema.sql
parent546e013453ef449f0c0d3670cde4076eda8f7a5c (diff)
postgres: minor schema fixes
Diffstat (limited to 'src/test/resources/db/specific/postgresql/V1.22__schema.sql')
-rw-r--r--src/test/resources/db/specific/postgresql/V1.22__schema.sql6
1 files changed, 3 insertions, 3 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 dfc9b275..6e8a4c3a 100644
--- a/src/test/resources/db/specific/postgresql/V1.22__schema.sql
+++ b/src/test/resources/db/specific/postgresql/V1.22__schema.sql
@@ -10,7 +10,7 @@ SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
-SELECT pg_catalog.set_config('search_path', '', false);
+SELECT pg_catalog.set_config('search_path', 'public', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
@@ -739,11 +739,11 @@ CREATE TABLE public.users (
passw character varying(32) NOT NULL,
lang public.users_lang DEFAULT '__'::public.users_lang NOT NULL,
banned smallint DEFAULT (0)::smallint NOT NULL,
+ lastmessage timestamp with time zone,
lastpm bigint DEFAULT (0)::bigint NOT NULL,
lastphoto bigint DEFAULT (0)::bigint NOT NULL,
karma smallint DEFAULT (0)::smallint NOT NULL,
- last_seen timestamp with time zone,
- lastmessage timestamp with time zone
+ last_seen timestamp with time zone
);