X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/a8aed64eb757d8c25823e12c0ca7648a4c97ae13..8c1a5d62f8b2f5491f7d476cdcbd0d4121903079:/db/structure.sql

diff --git a/db/structure.sql b/db/structure.sql
index 71cc60baa..d115140d1 100644
--- a/db/structure.sql
+++ b/db/structure.sql
@@ -168,7 +168,8 @@ CREATE TABLE public.acls (
     address inet,
     k character varying NOT NULL,
     v character varying,
-    domain character varying
+    domain character varying,
+    mx character varying
 );
 
 
@@ -1293,7 +1294,8 @@ CREATE TABLE public.users (
     image_use_gravatar boolean DEFAULT false NOT NULL,
     image_content_type character varying,
     auth_provider character varying,
-    home_tile bigint
+    home_tile bigint,
+    tou_agreed timestamp without time zone
 );
 
 
@@ -2063,6 +2065,27 @@ CREATE INDEX gpx_files_user_id_idx ON public.gpx_files USING btree (user_id);
 CREATE INDEX gpx_files_visible_visibility_idx ON public.gpx_files USING btree (visible, visibility);
 
 
+--
+-- Name: index_acls_on_address; Type: INDEX; Schema: public; Owner: -
+--
+
+CREATE INDEX index_acls_on_address ON public.acls USING gist (address inet_ops);
+
+
+--
+-- Name: index_acls_on_domain; Type: INDEX; Schema: public; Owner: -
+--
+
+CREATE INDEX index_acls_on_domain ON public.acls USING btree (domain);
+
+
+--
+-- Name: index_acls_on_mx; Type: INDEX; Schema: public; Owner: -
+--
+
+CREATE INDEX index_acls_on_mx ON public.acls USING btree (mx);
+
+
 --
 -- Name: index_changeset_comments_on_created_at; Type: INDEX; Schema: public; Owner: -
 --
@@ -2931,7 +2954,10 @@ INSERT INTO "schema_migrations" (version) VALUES
 ('20161011010929'),
 ('20170222134109'),
 ('20180204153242'),
+('20181020114000'),
 ('20181031113522'),
+('20190518115041'),
+('20190623093642'),
 ('21'),
 ('22'),
 ('23'),
