SET statement_timeout = 0;
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);
SET check_function_bodies = false;
-SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
$$;
+--
+-- Name: xid_to_int4(xid); Type: FUNCTION; Schema: public; Owner: -
+--
+
+CREATE FUNCTION public.xid_to_int4(t xid) RETURNS integer
+ LANGUAGE plpgsql STRICT
+ AS $$
+DECLARE
+ tl bigint;
+ ti int;
+BEGIN
+ tl := t;
+
+ IF tl >= 2147483648 THEN
+ tl := tl - 4294967296;
+ END IF;
+
+ ti := tl;
+
+ RETURN ti;
+END;
+$$;
+
+
SET default_tablespace = '';
SET default_with_oids = false;
CREATE TABLE public.ar_internal_metadata (
key character varying NOT NULL,
value character varying,
- created_at timestamp without time zone NOT NULL,
- updated_at timestamp without time zone NOT NULL
+ created_at timestamp(6) without time zone NOT NULL,
+ updated_at timestamp(6) without time zone NOT NULL
);
--
CREATE SEQUENCE public.changeset_comments_id_seq
- AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
--
CREATE SEQUENCE public.client_applications_id_seq
- AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
--
CREATE SEQUENCE public.issue_comments_id_seq
- AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
--
CREATE SEQUENCE public.issues_id_seq
- AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
--
CREATE SEQUENCE public.note_comments_id_seq
- AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
--
CREATE SEQUENCE public.notes_id_seq
- AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
--
CREATE SEQUENCE public.oauth_nonces_id_seq
- AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
--
CREATE SEQUENCE public.oauth_tokens_id_seq
- AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
--
CREATE SEQUENCE public.redactions_id_seq
- AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
--
CREATE SEQUENCE public.reports_id_seq
- AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
--
CREATE SEQUENCE public.user_blocks_id_seq
- AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
--
CREATE SEQUENCE public.user_roles_id_seq
- AS integer
START WITH 1
INCREMENT BY 1
NO MINVALUE
home_lat double precision,
home_lon double precision,
home_zoom smallint DEFAULT 3,
- nearby integer DEFAULT 50,
pass_salt character varying,
email_valid boolean DEFAULT false NOT NULL,
new_email character varying,
('20190623093642'),
('20190702193519'),
('20190716173946'),
+('20191120140058'),
('21'),
('22'),
('23'),