From eb473d33a1459fecfa1e7194df0572560dabf6ad Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Fri, 16 Dec 2022 20:00:17 +0300
Subject: postgres: minor schema fixes

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

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

