aboutsummaryrefslogtreecommitdiff
path: root/src/test/resources/db/specific/postgresql
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2022-12-16 23:04:10 +0300
committerGravatar Vitaly Takmazov2022-12-16 23:04:10 +0300
commit8dcf4801a0f5cb99c6485c37871e50ec6c83905e (patch)
treee17f9f922f1435e7f424510e1b3cfb49fca1faa9 /src/test/resources/db/specific/postgresql
parent528bc9cfd98489d59ed2cf4764c84c1805215c54 (diff)
postgres: schema fixes
Diffstat (limited to 'src/test/resources/db/specific/postgresql')
-rw-r--r--src/test/resources/db/specific/postgresql/V1.22__schema.sql28
1 files changed, 14 insertions, 14 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 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,