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: -
--
$$;
---
--- 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;
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
);
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: -
--
('20210510083027'),
('20210510083028'),
('20210511104518'),
+('20211216185316'),
+('20220201183346'),
('21'),
('22'),
('23'),