postgres: minor schema fixes

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
 );