<p></p>
<p dir="auto">I have loads of differences for things like that (which I think is probably down to postgres version) or field ordering (which is mostly down to me having applied and reverted migrations at various times and in various orders) and I generally figure that trying to "fix" them is as likely to break them for other people as it is to fix them for me... My current diff is:</p>
<div class="highlight highlight-source-diff" dir="auto"><pre class="notranslate"><span class="pl-c1">diff --git a/db/structure.sql b/db/structure.sql</span>
index 939799c0a..78eef205f 100644
<span class="pl-md">--- a/db/structure.sql</span>
<span class="pl-mi1">+++ b/db/structure.sql</span>
<span class="pl-mdr">@@ -9,6 +9,13 @@</span> SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
<span class="pl-mi1"><span class="pl-mi1">+</span>--</span>
<span class="pl-mi1"><span class="pl-mi1">+</span>-- Name: public; Type: SCHEMA; Schema: -; Owner: -</span>
<span class="pl-mi1"><span class="pl-mi1">+</span>--</span>
<span class="pl-mi1"><span class="pl-mi1">+</span></span>
<span class="pl-mi1"><span class="pl-mi1">+</span>-- *not* creating schema, since initdb creates it</span>
<span class="pl-mi1"><span class="pl-mi1">+</span></span>
<span class="pl-mi1"><span class="pl-mi1">+</span></span>
--
-- Name: btree_gist; Type: EXTENSION; Schema: -; Owner: -
--
<span class="pl-mdr">@@ -16,6 +23,13 @@</span> SET row_security = off;
CREATE EXTENSION IF NOT EXISTS btree_gist WITH SCHEMA public;
<span class="pl-mi1"><span class="pl-mi1">+</span>--</span>
<span class="pl-mi1"><span class="pl-mi1">+</span>-- Name: EXTENSION btree_gist; Type: COMMENT; Schema: -; Owner: -</span>
<span class="pl-mi1"><span class="pl-mi1">+</span>--</span>
<span class="pl-mi1"><span class="pl-mi1">+</span></span>
<span class="pl-mi1"><span class="pl-mi1">+</span>COMMENT ON EXTENSION btree_gist IS 'support for indexing common datatypes in GiST';</span>
<span class="pl-mi1"><span class="pl-mi1">+</span></span>
<span class="pl-mi1"><span class="pl-mi1">+</span></span>
--
-- Name: format_enum; Type: TYPE; Schema: public; Owner: -
--
<span class="pl-mdr">@@ -107,6 +121,39 @@</span> CREATE TYPE public.user_status_enum AS ENUM (
'deleted'
);
<span class="pl-mi1"><span class="pl-mi1">+</span></span>
<span class="pl-mi1"><span class="pl-mi1">+</span>--</span>
<span class="pl-mi1"><span class="pl-mi1">+</span>-- Name: tile_for_point(integer, integer); Type: FUNCTION; Schema: public; Owner: -</span>
<span class="pl-mi1"><span class="pl-mi1">+</span>--</span>
<span class="pl-mi1"><span class="pl-mi1">+</span></span>
<span class="pl-mi1"><span class="pl-mi1">+</span>CREATE FUNCTION public.tile_for_point(scaled_lat integer, scaled_lon integer) RETURNS bigint</span>
<span class="pl-mi1"><span class="pl-mi1">+</span> LANGUAGE plpgsql IMMUTABLE</span>
<span class="pl-mi1"><span class="pl-mi1">+</span> AS $$</span>
<span class="pl-mi1"><span class="pl-mi1">+</span>DECLARE</span>
<span class="pl-mi1"><span class="pl-mi1">+</span> x int8; -- quantized x from lon,</span>
<span class="pl-mi1"><span class="pl-mi1">+</span> y int8; -- quantized y from lat,</span>
<span class="pl-mi1"><span class="pl-mi1">+</span>BEGIN</span>
<span class="pl-mi1"><span class="pl-mi1">+</span> x := round(((scaled_lon / 10000000.0) + 180.0) * 65535.0 / 360.0);</span>
<span class="pl-mi1"><span class="pl-mi1">+</span> y := round(((scaled_lat / 10000000.0) + 90.0) * 65535.0 / 180.0);</span>
<span class="pl-mi1"><span class="pl-mi1">+</span></span>
<span class="pl-mi1"><span class="pl-mi1">+</span> -- these bit-masks are special numbers used in the bit interleaving algorithm.</span>
<span class="pl-mi1"><span class="pl-mi1">+</span> -- see https://graphics.stanford.edu/~seander/bithacks.html#InterleaveBMN</span>
<span class="pl-mi1"><span class="pl-mi1">+</span> -- for the original algorithm and more details.</span>
<span class="pl-mi1"><span class="pl-mi1">+</span> x := (x | (x << 8)) & 16711935; -- 0x00FF00FF</span>
<span class="pl-mi1"><span class="pl-mi1">+</span> x := (x | (x << 4)) & 252645135; -- 0x0F0F0F0F</span>
<span class="pl-mi1"><span class="pl-mi1">+</span> x := (x | (x << 2)) & 858993459; -- 0x33333333</span>
<span class="pl-mi1"><span class="pl-mi1">+</span> x := (x | (x << 1)) & 1431655765; -- 0x55555555</span>
<span class="pl-mi1"><span class="pl-mi1">+</span></span>
<span class="pl-mi1"><span class="pl-mi1">+</span> y := (y | (y << 8)) & 16711935; -- 0x00FF00FF</span>
<span class="pl-mi1"><span class="pl-mi1">+</span> y := (y | (y << 4)) & 252645135; -- 0x0F0F0F0F</span>
<span class="pl-mi1"><span class="pl-mi1">+</span> y := (y | (y << 2)) & 858993459; -- 0x33333333</span>
<span class="pl-mi1"><span class="pl-mi1">+</span> y := (y | (y << 1)) & 1431655765; -- 0x55555555</span>
<span class="pl-mi1"><span class="pl-mi1">+</span></span>
<span class="pl-mi1"><span class="pl-mi1">+</span> RETURN (x << 1) | y;</span>
<span class="pl-mi1"><span class="pl-mi1">+</span>END;</span>
<span class="pl-mi1"><span class="pl-mi1">+</span>$$;</span>
<span class="pl-mi1"><span class="pl-mi1">+</span></span>
<span class="pl-mi1"><span class="pl-mi1">+</span></span>
SET default_tablespace = '';
SET default_table_access_method = heap;
<span class="pl-mdr">@@ -250,8 +297,8 @@</span> ALTER SEQUENCE public.active_storage_variant_records_id_seq OWNED BY public.acti
CREATE TABLE public.ar_internal_metadata (
key character varying NOT NULL,
value character varying,
<span class="pl-md"><span class="pl-md">-</span> created_at timestamp(6) without time zone NOT NULL,</span>
<span class="pl-md"><span class="pl-md">-</span> updated_at timestamp(6) without time zone NOT NULL</span>
<span class="pl-mi1"><span class="pl-mi1">+</span> created_at timestamp without time zone NOT NULL,</span>
<span class="pl-mi1"><span class="pl-mi1">+</span> updated_at timestamp without time zone NOT NULL</span>
);
<span class="pl-mdr">@@ -274,7 +321,6 @@</span> CREATE TABLE public.changeset_comments (
--
CREATE SEQUENCE public.changeset_comments_id_seq
<span class="pl-md"><span class="pl-md">-</span> AS integer</span>
START WITH 1
INCREMENT BY 1
NO MINVALUE
<span class="pl-mdr">@@ -376,7 +422,6 @@</span> CREATE TABLE public.client_applications (
--
CREATE SEQUENCE public.client_applications_id_seq
<span class="pl-md"><span class="pl-md">-</span> AS integer</span>
START WITH 1
INCREMENT BY 1
NO MINVALUE
<span class="pl-mdr">@@ -802,7 +847,6 @@</span> CREATE TABLE public.issue_comments (
--
CREATE SEQUENCE public.issue_comments_id_seq
<span class="pl-md"><span class="pl-md">-</span> AS integer</span>
START WITH 1
INCREMENT BY 1
NO MINVALUE
<span class="pl-mdr">@@ -842,7 +886,6 @@</span> CREATE TABLE public.issues (
--
CREATE SEQUENCE public.issues_id_seq
<span class="pl-md"><span class="pl-md">-</span> AS integer</span>
START WITH 1
INCREMENT BY 1
NO MINVALUE
<span class="pl-mdr">@@ -955,7 +998,6 @@</span> CREATE TABLE public.note_comments (
--
CREATE SEQUENCE public.note_comments_id_seq
<span class="pl-md"><span class="pl-md">-</span> AS integer</span>
START WITH 1
INCREMENT BY 1
NO MINVALUE
<span class="pl-mdr">@@ -991,7 +1033,6 @@</span> CREATE TABLE public.notes (
--
CREATE SEQUENCE public.notes_id_seq
<span class="pl-md"><span class="pl-md">-</span> AS integer</span>
START WITH 1
INCREMENT BY 1
NO MINVALUE
<span class="pl-mdr">@@ -1137,7 +1178,6 @@</span> CREATE TABLE public.oauth_nonces (
--
CREATE SEQUENCE public.oauth_nonces_id_seq
<span class="pl-md"><span class="pl-md">-</span> AS integer</span>
START WITH 1
INCREMENT BY 1
NO MINVALUE
<span class="pl-mdr">@@ -1216,7 +1256,6 @@</span> CREATE TABLE public.oauth_tokens (
--
CREATE SEQUENCE public.oauth_tokens_id_seq
<span class="pl-md"><span class="pl-md">-</span> AS integer</span>
START WITH 1
INCREMENT BY 1
NO MINVALUE
<span class="pl-mdr">@@ -1251,7 +1290,6 @@</span> CREATE TABLE public.redactions (
--
CREATE SEQUENCE public.redactions_id_seq
<span class="pl-md"><span class="pl-md">-</span> AS integer</span>
START WITH 1
INCREMENT BY 1
NO MINVALUE
<span class="pl-mdr">@@ -1326,7 +1364,6 @@</span> CREATE TABLE public.reports (
--
CREATE SEQUENCE public.reports_id_seq
<span class="pl-md"><span class="pl-md">-</span> AS integer</span>
START WITH 1
INCREMENT BY 1
NO MINVALUE
<span class="pl-mdr">@@ -1373,7 +1410,6 @@</span> CREATE TABLE public.user_blocks (
--
CREATE SEQUENCE public.user_blocks_id_seq
<span class="pl-md"><span class="pl-md">-</span> AS integer</span>
START WITH 1
INCREMENT BY 1
NO MINVALUE
<span class="pl-mdr">@@ -1406,9 +1442,9 @@</span> CREATE TABLE public.user_preferences (
CREATE TABLE public.user_roles (
id integer NOT NULL,
user_id bigint NOT NULL,
<span class="pl-md"><span class="pl-md">-</span> role public.user_role_enum NOT NULL,</span>
created_at timestamp without time zone,
updated_at timestamp without time zone,
<span class="pl-mi1"><span class="pl-mi1">+</span> role public.user_role_enum NOT NULL,</span>
granter_id bigint NOT NULL
);
<span class="pl-mdr">@@ -1418,7 +1454,6 @@</span> CREATE TABLE public.user_roles (
--
CREATE SEQUENCE public.user_roles_id_seq
<span class="pl-md"><span class="pl-md">-</span> AS integer</span>
START WITH 1
INCREMENT BY 1
NO MINVALUE
<span class="pl-mdr">@@ -3512,3 +3547,5 @@</span> INSERT INTO "schema_migrations" (version) VALUES
('7'),
('8'),
('9');
<span class="pl-mi1"><span class="pl-mi1">+</span></span>
<span class="pl-mi1"><span class="pl-mi1">+</span></span></pre></div>
<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />Reply to this email directly, <a href="https://github.com/openstreetmap/openstreetmap-website/issues/4298#issuecomment-1768784767">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AAK2OLMI7KZVRWOVHCE35WLX773U3AVCNFSM6AAAAAA6FVRJH6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONRYG44DINZWG4">unsubscribe</a>.<br />You are receiving this because you are subscribed to this thread.<img src="https://github.com/notifications/beacon/AAK2OLNCNNVY2V3S67EAPDTX773U3A5CNFSM6AAAAAA6FVRJH6WGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTTJNWBX6.gif" height="1" width="1" alt="" /><span style="color: transparent; font-size: 0; display: none; visibility: hidden; overflow: hidden; opacity: 0; width: 0; height: 0; max-width: 0; max-height: 0; mso-hide: all">Message ID: <span><openstreetmap/openstreetmap-website/issues/4298/1768784767</span><span>@</span><span>github</span><span>.</span><span>com></span></span></p>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/openstreetmap/openstreetmap-website/issues/4298#issuecomment-1768784767",
"url": "https://github.com/openstreetmap/openstreetmap-website/issues/4298#issuecomment-1768784767",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>