ALTER TABLE "posts" ADD COLUMN "stats" jsonb DEFAULT '{"views":0,"viewsDay":0,"viewsYear":0,"shares":0,"sharesDay":0,"sharesYear":0}'::jsonb NOT NULL;--> statement-breakpoint
CREATE INDEX "posts_stats_views_index" ON "posts" USING btree ((("stats"->>'views')::int));--> statement-breakpoint
CREATE INDEX "posts_stats_views_day_index" ON "posts" USING btree ((("stats"->>'viewsDay')::int));--> statement-breakpoint
CREATE INDEX "posts_stats_views_year_index" ON "posts" USING btree ((("stats"->>'viewsYear')::int));--> statement-breakpoint
CREATE INDEX "posts_stats_shares_index" ON "posts" USING btree ((("stats"->>'shares')::int));--> statement-breakpoint
CREATE INDEX "posts_stats_shares_day_index" ON "posts" USING btree ((("stats"->>'sharesDay')::int));--> statement-breakpoint
CREATE INDEX "posts_stats_shares_year_index" ON "posts" USING btree ((("stats"->>'sharesYear')::int));