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.
1.0 kB · 20 lines
SQL
at main
123456789101112131415161718192021CREATE TABLE `maintenance_update` ( `id` integer PRIMARY KEY NOT NULL, `message` text NOT NULL, `date` integer NOT NULL, `maintenance_id` integer NOT NULL, `created_by` integer, `updated_by` integer, `created_at` integer DEFAULT (strftime('%s', 'now')), `updated_at` integer DEFAULT (strftime('%s', 'now')), FOREIGN KEY (`maintenance_id`) REFERENCES `maintenance`(`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);--> statement-breakpointCREATE INDEX `maintenance_update_maintenance_id_idx` ON `maintenance_update` (`maintenance_id`);--> statement-breakpointINSERT INTO `maintenance_update` (`maintenance_id`, `message`, `date`, `created_by`, `updated_by`)SELECT `id`, `message`, COALESCE(`created_at`, `from`), `created_by`, COALESCE(`updated_by`, `created_by`)FROM `maintenance`WHERE `message` <> '';