X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/81c3ebe03c229c980908502f3735cdf1636dd5cc..1f8df781be6788a43e0a76a9874366930473f64c:/db/structure.sql?ds=sidebyside diff --git a/db/structure.sql b/db/structure.sql index ccef53e17..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: - -- @@ -147,6 +140,10 @@ END; $$; +SET default_tablespace = ''; + +SET default_table_access_method = heap; + -- -- Name: acls; Type: TABLE; Schema: public; Owner: - -- @@ -224,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 ); @@ -2511,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: - -- @@ -3421,6 +3425,8 @@ INSERT INTO "schema_migrations" (version) VALUES ('20210510083027'), ('20210510083028'), ('20210511104518'), +('20211216185316'), +('20220201183346'), ('21'), ('22'), ('23'),