From cd4ac6ac2dfaea3f2c7419d8b6d5e0a9490e286a Mon Sep 17 00:00:00 2001
From: Tom Hughes <tom@compton.nu>
Date: Mon, 15 Jul 2019 09:27:52 +0100
Subject: [PATCH 1/1] Revert accidental schema changes

---
 db/structure.sql | 23 ++++++++++++++++++-----
 1 file changed, 18 insertions(+), 5 deletions(-)

diff --git a/db/structure.sql b/db/structure.sql
index 82596c0ce..8f4fe3e79 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
 );
 
-- 
2.39.5