X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/cf54b68f84649c327432ddb48ac181498433a499..172a71e3f242f74a6eb1f7bb45fb4d5f3ddff5e7:/db/structure.sql diff --git a/db/structure.sql b/db/structure.sql index e50e50278..63aa17353 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -16,13 +16,6 @@ SET row_security = off; CREATE EXTENSION IF NOT EXISTS btree_gist WITH SCHEMA public; --- --- Name: EXTENSION btree_gist; Type: COMMENT; Schema: -; Owner: - --- - -COMMENT ON EXTENSION btree_gist IS 'support for indexing common datatypes in GiST'; - - -- -- Name: format_enum; Type: TYPE; Schema: public; Owner: - -- @@ -228,7 +221,7 @@ CREATE TABLE public.active_storage_blobs ( content_type character varying, metadata text, byte_size bigint NOT NULL, - checksum character varying NOT NULL, + checksum character varying, created_at timestamp without time zone NOT NULL, service_name character varying NOT NULL ); @@ -2515,6 +2508,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: - -- @@ -3425,6 +3425,8 @@ INSERT INTO "schema_migrations" (version) VALUES ('20210510083027'), ('20210510083028'), ('20210511104518'), +('20211216185316'), +('20220201183346'), ('21'), ('22'), ('23'),