X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/8e258d810c8db6e5dccc84fb3292af0e5dd19642..8c1a5d62f8b2f5491f7d476cdcbd0d4121903079:/db/structure.sql diff --git a/db/structure.sql b/db/structure.sql index f77c3831c..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 ); @@ -2077,6 +2079,13 @@ CREATE INDEX index_acls_on_address ON public.acls USING gist (address inet_ops); 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: - -- @@ -2945,8 +2954,10 @@ INSERT INTO "schema_migrations" (version) VALUES ('20161011010929'), ('20170222134109'), ('20180204153242'), +('20181020114000'), ('20181031113522'), ('20190518115041'), +('20190623093642'), ('21'), ('22'), ('23'),