Something went wrong. Try again.
[READ-ONLY] Mirror of https://github.com/openstatusHQ/openstatus. 🫖 Status page with uptime monitoring & API monitoring as code 🫖 openstatus.dev
bun drizzle-orm monitoring monitoring-as-code nextjs observability on-call open-source shadcn-ui status-page statuspage synthetic-monitoring tinybird turso uptime uptime-checker uptime-monitor
Something went wrong. Try again.
995 B · 21 lines
SQL
at main
123456789101112131415161718192021CREATE TABLE `incident_postmortem` ( `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL, `incident_id` integer NOT NULL, `status` text DEFAULT 'draft' NOT NULL, `content` text NOT NULL, `source_transcript` text, `drafted_by` text NOT NULL, `created_by` integer, `updated_by` integer, `approved_by` integer, `approved_at` integer, `published_at` integer, `created_at` integer DEFAULT (strftime('%s', 'now')) NOT NULL, `updated_at` integer DEFAULT (strftime('%s', 'now')) NOT NULL, FOREIGN KEY (`incident_id`) REFERENCES `incident`(`id`) ON UPDATE no action ON DELETE cascade, FOREIGN KEY (`created_by`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE no action, FOREIGN KEY (`updated_by`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE no action, FOREIGN KEY (`approved_by`) REFERENCES `user`(`id`) ON UPDATE no action ON DELETE no action);--> statement-breakpointCREATE UNIQUE INDEX `incident_postmortem_incident_id_unique` ON `incident_postmortem` (`incident_id`);