X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/8d76be71bbb8a799cbf0627dee170f26ade5a11f..6ede9e3ec74e89dc61b48c52b439a6581dfde80e:/db/structure.sql diff --git a/db/structure.sql b/db/structure.sql index a45bb0a70..7c182189c 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -147,30 +147,6 @@ END; $$; --- --- Name: xid_to_int4(xid); Type: FUNCTION; Schema: public; Owner: - --- - -CREATE FUNCTION public.xid_to_int4(t xid) RETURNS integer - LANGUAGE plpgsql IMMUTABLE STRICT - AS $$ -DECLARE - tl bigint; - ti int; -BEGIN - tl := t; - - IF tl >= 2147483648 THEN - tl := tl - 4294967296; - END IF; - - ti := tl; - - RETURN ti; -END; -$$; - - SET default_tablespace = ''; SET default_table_access_method = heap; @@ -2539,6 +2515,13 @@ CREATE INDEX index_issues_on_status ON public.issues USING btree (status); CREATE INDEX index_issues_on_updated_by ON public.issues USING btree (updated_by); +-- +-- Name: index_note_comments_on_author_id_and_created_at; Type: INDEX; Schema: public; Owner: - +-- + +CREATE INDEX index_note_comments_on_author_id_and_created_at ON public.note_comments USING btree (author_id, created_at); + + -- -- Name: index_note_comments_on_body; Type: INDEX; Schema: public; Owner: - -- @@ -3449,6 +3432,7 @@ INSERT INTO "schema_migrations" (version) VALUES ('20210510083027'), ('20210510083028'), ('20210511104518'), +('20220201183346'), ('21'), ('22'), ('23'),