X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/afe679349fb7139f5cff5830f45e4b8214732812..0fa09de8f82bdd77410e3330079c13bf6a3c6517:/db/structure.sql?ds=sidebyside diff --git a/db/structure.sql b/db/structure.sql index 03950502c..b5c4ec01d 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -4,6 +4,7 @@ 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; @@ -184,6 +185,30 @@ END; $$; +-- +-- 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; @@ -296,8 +321,8 @@ ALTER SEQUENCE public.active_storage_blobs_id_seq OWNED BY public.active_storage 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 ); @@ -1050,7 +1075,7 @@ ALTER SEQUENCE public.notes_id_seq OWNED BY public.notes.id; -- CREATE TABLE public.oauth_nonces ( - id integer NOT NULL, + id bigint NOT NULL, nonce character varying, "timestamp" integer, created_at timestamp without time zone, @@ -1370,7 +1395,6 @@ CREATE TABLE public.users ( 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, @@ -2231,6 +2255,13 @@ CREATE UNIQUE INDEX index_active_storage_attachments_uniqueness ON public.active CREATE UNIQUE INDEX index_active_storage_blobs_on_key ON public.active_storage_blobs USING btree (key); +-- +-- Name: index_changeset_comments_on_changeset_id_and_created_at; Type: INDEX; Schema: public; Owner: - +-- + +CREATE INDEX index_changeset_comments_on_changeset_id_and_created_at ON public.changeset_comments USING btree (changeset_id, created_at); + + -- -- Name: index_changeset_comments_on_created_at; Type: INDEX; Schema: public; Owner: - -- @@ -3113,6 +3144,10 @@ INSERT INTO "schema_migrations" (version) VALUES ('20190623093642'), ('20190702193519'), ('20190716173946'), +('20191120140058'), +('20201006213836'), +('20201006220807'), +('20201214144017'), ('21'), ('22'), ('23'),