X-Git-Url: https://git.openstreetmap.org/rails.git/blobdiff_plain/e78859aeaf40fd7c3d9f1ef1c0c8d1fd14bf41b0..9299f8ca23d7cd7a1cb2f080bf6bd440140d3637:/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'),