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.
2.4 kB · 33 lines
SQL
at incident-api
123456789101112131415161718192021222324252627282930313233CREATE TABLE `page_subscriber_to_page_component` ( `page_subscriber_id` integer NOT NULL, `page_component_id` integer NOT NULL, `created_at` integer DEFAULT (strftime('%s', 'now')), PRIMARY KEY(`page_subscriber_id`, `page_component_id`), FOREIGN KEY (`page_subscriber_id`) REFERENCES `page_subscriber`(`id`) ON UPDATE no action ON DELETE cascade, FOREIGN KEY (`page_component_id`) REFERENCES `page_component`(`id`) ON UPDATE no action ON DELETE cascade);--> statement-breakpointPRAGMA foreign_keys=OFF;--> statement-breakpointCREATE TABLE `__new_page_subscriber` ( `id` integer PRIMARY KEY NOT NULL, `email` text NOT NULL, `page_id` integer NOT NULL, `channel_type` text DEFAULT 'email' NOT NULL, `webhook_url` text, `channel_config` text, `token` text, `accepted_at` integer, `expires_at` integer, `unsubscribed_at` integer, `created_at` integer DEFAULT (strftime('%s', 'now')), `updated_at` integer DEFAULT (strftime('%s', 'now')), FOREIGN KEY (`page_id`) REFERENCES `page`(`id`) ON UPDATE no action ON DELETE cascade, CONSTRAINT "page_subscriber_channel_check" CHECK(("__new_page_subscriber"."channel_type" = 'email' AND "__new_page_subscriber"."email" IS NOT NULL AND "__new_page_subscriber"."webhook_url" IS NULL) OR ("__new_page_subscriber"."channel_type" = 'webhook' AND "__new_page_subscriber"."webhook_url" IS NOT NULL AND "__new_page_subscriber"."email" IS NULL)));--> statement-breakpointINSERT INTO `__new_page_subscriber`("id", "email", "page_id", "channel_type", "webhook_url", "channel_config", "token", "accepted_at", "expires_at", "unsubscribed_at", "created_at", "updated_at") SELECT "id", "email", "page_id", 'email', NULL, NULL, "token", "accepted_at", "expires_at", "unsubscribed_at", "created_at", "updated_at" FROM `page_subscriber`;--> statement-breakpointDROP TABLE `page_subscriber`;--> statement-breakpointALTER TABLE `__new_page_subscriber` RENAME TO `page_subscriber`;--> statement-breakpointPRAGMA foreign_keys=ON;--> statement-breakpointCREATE UNIQUE INDEX `idx_page_subscriber_email_page_active` ON `page_subscriber` (LOWER("email"),`page_id`) WHERE "page_subscriber"."unsubscribed_at" IS NULL AND "page_subscriber"."channel_type" = 'email';--> statement-breakpointCREATE UNIQUE INDEX `idx_page_subscriber_webhook_page_active` ON `page_subscriber` (`webhook_url`,`page_id`) WHERE "page_subscriber"."unsubscribed_at" IS NULL AND "page_subscriber"."channel_type" = 'webhook';