diff options
Diffstat (limited to 'src/test/resources/db/specific/postgresql')
| -rw-r--r-- | src/test/resources/db/specific/postgresql/V1.22__schema.sql | 6 |
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 ); |