Files
famapp/drizzle/0022_multiple_reminders.sql
ginnoir e1c2a090fb feat: p2 batch 28-31 reminders lists comments bang stats
Calendar events support multiple reminder offsets with presets and per-user defaults.

Lists index adds inline task entry and list property editing.

Generic entity comments on list detail. New bangs.stats dashboard widget.

Closes Gitea #28, #29, #30, #31. Migrations 0022 and 0023.
2026-07-04 22:17:35 -05:00

8 lines
378 B
SQL

DROP INDEX IF EXISTS "reminders_entity_unique";
--> statement-breakpoint
ALTER TABLE "reminders" ADD COLUMN "offset_minutes" integer;
--> statement-breakpoint
CREATE INDEX "reminders_entity_idx" ON "reminders" USING btree ("entity_type","entity_id");
--> statement-breakpoint
ALTER TABLE "users" ADD COLUMN "default_event_reminder_offsets" jsonb DEFAULT '[30]'::jsonb NOT NULL;