diff options
| -rw-r--r-- | src/test/resources/db/specific/postgresql/V1.22__schema.sql | 28 |
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, |