From 8dcf4801a0f5cb99c6485c37871e50ec6c83905e Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Fri, 16 Dec 2022 23:04:10 +0300
Subject: postgres: schema fixes

---
 .../db/specific/postgresql/V1.22__schema.sql       | 28 +++++++++++-----------
 1 file changed, 14 insertions(+), 14 deletions(-)

(limited to 'src/test')

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 56c2a506..fbd50408 100644
--- a/src/test/resources/db/specific/postgresql/V1.22__schema.sql
+++ b/src/test/resources/db/specific/postgresql/V1.22__schema.sql
@@ -714,16 +714,16 @@ ALTER TABLE public.twitter OWNER TO juick;
 
 CREATE TABLE public.useroptions (
     user_id bigint NOT NULL,
-    jnotify boolean DEFAULT true NOT NULL,
-    subscr_active boolean DEFAULT true NOT NULL,
+    jnotify smallint DEFAULT 1 NOT NULL,
+    subscr_active smallint DEFAULT 1 NOT NULL,
     off_ts timestamp with time zone,
-    xmppxhtml boolean DEFAULT false NOT NULL,
-    subscr_notify boolean DEFAULT true NOT NULL,
-    recommendations boolean DEFAULT true NOT NULL,
-    privacy_view boolean DEFAULT true NOT NULL,
-    privacy_reply boolean DEFAULT true NOT NULL,
-    privacy_pm boolean DEFAULT true NOT NULL,
-    repliesview boolean DEFAULT false NOT NULL
+    xmppxhtml smallint DEFAULT 0 NOT NULL,
+    subscr_notify smallint DEFAULT 1 NOT NULL,
+    recommendations smallint DEFAULT 1 NOT NULL,
+    privacy_view smallint DEFAULT 1 NOT NULL,
+    privacy_reply smallint DEFAULT 1 NOT NULL,
+    privacy_pm smallint DEFAULT 1 NOT NULL,
+    repliesview smallint DEFAULT 0 NOT NULL
 );
 
 
@@ -788,12 +788,12 @@ ALTER TABLE public.users_subscr OWNER TO juick;
 
 CREATE TABLE public.usersinfo (
     user_id bigint NOT NULL,
-    jid character varying(32),
-    fullname character varying(32),
+    jid character varying(64),
+    fullname character varying(64),
     country character varying(32),
-    url character varying(64),
+    url character varying(128),
     gender character varying(32),
-    bday character varying(10),
+    bday character varying(32),
     descr text
 );
 
@@ -817,7 +817,7 @@ ALTER TABLE public.version OWNER TO juick;
 
 CREATE TABLE public.vk (
     user_id bigint,
-    vk_id numeric NOT NULL,
+    vk_id numeric NULL,
     loginhash character varying(36),
     access_token character varying(128) NOT NULL,
     ts timestamp with time zone DEFAULT now() NOT NULL,
-- 
cgit v1.2.3