X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/d67efc31681cec4724d922f63f0c666c47c1cfb0..34e06204636f4390b8b99fdce71af87d9a00663b:/db/structure.sql diff --git a/db/structure.sql b/db/structure.sql index f9e588b3c..25b2f173f 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -1482,7 +1482,6 @@ CREATE TABLE public.users ( pass_salt character varying, email_valid boolean DEFAULT false NOT NULL, new_email character varying, - creation_ip character varying, languages character varying, status public.user_status_enum DEFAULT 'pending'::public.user_status_enum NOT NULL, terms_agreed timestamp without time zone, @@ -1499,7 +1498,8 @@ CREATE TABLE public.users ( home_tile bigint, tou_agreed timestamp without time zone, diary_comments_count integer DEFAULT 0, - note_comments_count integer DEFAULT 0 + note_comments_count integer DEFAULT 0, + creation_address inet ); @@ -2603,6 +2603,13 @@ CREATE INDEX index_user_blocks_on_user_id ON public.user_blocks USING btree (use CREATE UNIQUE INDEX index_user_mutes_on_owner_id_and_subject_id ON public.user_mutes USING btree (owner_id, subject_id); +-- +-- Name: index_users_on_creation_address; Type: INDEX; Schema: public; Owner: - +-- + +CREATE INDEX index_users_on_creation_address ON public.users USING gist (creation_address inet_ops); + + -- -- Name: messages_from_user_id_idx; Type: INDEX; Schema: public; Owner: - -- @@ -3349,6 +3356,9 @@ INSERT INTO "schema_migrations" (version) VALUES ('23'), ('22'), ('21'), +('20240913171951'), +('20240912181413'), +('20240910175616'), ('20240822121603'), ('20240813070506'), ('20240724194738'),