X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/550fa0c8e46c9d4e09e30f7940bcb63f84f0ac41..4b8f0a73890e848f6ff46ad295bc91c2363e7c1b:/db/structure.sql

diff --git a/db/structure.sql b/db/structure.sql
index 82596c0ce..47f3cf7a0 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -5,10 +5,23 @@ 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: plpgsql; Type: EXTENSION; Schema: -; Owner: -
+--
+
+CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
+
+
+--
+-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -
+--
+
+COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
+
+
 --
 -- Name: btree_gist; Type: EXTENSION; Schema: -; Owner: -
 --
@@ -121,7 +134,7 @@ CREATE TYPE public.user_status_enum AS ENUM (
 
 CREATE FUNCTION public.maptile_for_point(bigint, bigint, integer) RETURNS integer
     LANGUAGE c STRICT
-    AS '$libdir/libpgosm', 'maptile_for_point';
+    AS '$libdir/libpgosm.so', 'maptile_for_point';
 
 
 --
@@ -130,7 +143,7 @@ CREATE FUNCTION public.maptile_for_point(bigint, bigint, integer) RETURNS intege
 
 CREATE FUNCTION public.tile_for_point(integer, integer) RETURNS bigint
     LANGUAGE c STRICT
-    AS '$libdir/libpgosm', 'tile_for_point';
+    AS '$libdir/libpgosm.so', 'tile_for_point';
 
 
 --
@@ -139,7 +152,7 @@ CREATE FUNCTION public.tile_for_point(integer, integer) RETURNS bigint
 
 CREATE FUNCTION public.xid_to_int4(xid) RETURNS integer
     LANGUAGE c IMMUTABLE STRICT
-    AS '$libdir/libpgosm', 'xid_to_int4';
+    AS '$libdir/libpgosm.so', 'xid_to_int4';
 
 
 SET default_tablespace = '';
@@ -1255,9 +1268,9 @@ CREATE TABLE public.user_preferences (
 CREATE TABLE public.user_roles (
     id integer NOT NULL,
     user_id bigint NOT NULL,
+    role public.user_role_enum NOT NULL,
     created_at timestamp without time zone,
     updated_at timestamp without time zone,
-    role public.user_role_enum NOT NULL,
     granter_id bigint NOT NULL
 );
 
@@ -1330,7 +1343,6 @@ CREATE TABLE public.users (
     home_zoom smallint DEFAULT 3,
     nearby integer DEFAULT 50,
     pass_salt character varying,
-    image_file_name text,
     email_valid boolean DEFAULT false NOT NULL,
     new_email character varying,
     creation_ip character varying,
@@ -1342,12 +1354,10 @@ CREATE TABLE public.users (
     preferred_editor character varying,
     terms_seen boolean DEFAULT false NOT NULL,
     description_format public.format_enum DEFAULT 'markdown'::public.format_enum NOT NULL,
-    image_fingerprint character varying,
     changesets_count integer DEFAULT 0 NOT NULL,
     traces_count integer DEFAULT 0 NOT NULL,
     diary_entries_count integer DEFAULT 0 NOT NULL,
     image_use_gravatar boolean DEFAULT false NOT NULL,
-    image_content_type character varying,
     auth_provider character varying,
     home_tile bigint,
     tou_agreed timestamp without time zone
@@ -3073,6 +3083,7 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('20190518115041'),
 ('20190623093642'),
 ('20190702193519'),
+('20190716173946'),
 ('21'),
 ('22'),
 ('23'),