CREATE TABLE public.redactions (
id integer NOT NULL,
- title character varying,
- description text,
+ title character varying NOT NULL,
+ description text NOT NULL,
created_at timestamp without time zone,
updated_at timestamp without time zone,
user_id bigint NOT NULL,
image_use_gravatar boolean DEFAULT false NOT NULL,
auth_provider character varying,
home_tile bigint,
- tou_agreed timestamp without time zone
+ tou_agreed timestamp without time zone,
+ diary_comments_count integer DEFAULT 0,
+ note_comments_count integer DEFAULT 0
);
CREATE INDEX index_reports_on_user_id ON public.reports USING btree (user_id);
+--
+-- Name: index_user_blocks_on_creator_id_and_id; Type: INDEX; Schema: public; Owner: -
+--
+
+CREATE INDEX index_user_blocks_on_creator_id_and_id ON public.user_blocks USING btree (creator_id, id);
+
+
--
-- Name: index_user_blocks_on_user_id; Type: INDEX; Schema: public; Owner: -
--
('23'),
('22'),
('21'),
+('20240605134916'),
+('20240405083825'),
+('20240307181018'),
+('20240307180830'),
('20240228205723'),
('20240117185445'),
('20231213182102'),
('11'),
('10'),
('1');
+