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.
3.2 kB · 35 lines
SQL
at incident-api
1234567891011121314151617181920212223242526272829303132333435DROP INDEX "workspace_slug_unique";--> statement-breakpointDROP INDEX "workspace_stripe_id_unique";--> statement-breakpointDROP INDEX "workspace_id_dsn_unique";--> statement-breakpointDROP INDEX "user_tenant_id_unique";--> statement-breakpointDROP INDEX "page_slug_unique";--> statement-breakpointDROP INDEX "idx_page_subscriber_email_page_active";--> statement-breakpointDROP INDEX "idx_page_subscriber_webhook_page_active";--> statement-breakpointDROP INDEX "notification_id_monitor_id_crontimestampe";--> statement-breakpointDROP INDEX "monitor_status_idx";--> statement-breakpointDROP INDEX "incident_monitor_id_started_at_unique";--> statement-breakpointDROP INDEX "application_dsn_unique";--> statement-breakpointDROP INDEX "viewer_email_unique";--> statement-breakpointDROP INDEX "api_key_prefix_unique";--> statement-breakpointDROP INDEX "api_key_hashed_token_unique";--> statement-breakpointDROP INDEX "api_key_prefix_idx";--> statement-breakpointDROP INDEX "page_component_page_id_monitor_id_unique";--> statement-breakpointALTER TABLE `page_subscriber` ALTER COLUMN "email" TO "email" text;--> statement-breakpointCREATE UNIQUE INDEX `workspace_slug_unique` ON `workspace` (`slug`);--> statement-breakpointCREATE UNIQUE INDEX `workspace_stripe_id_unique` ON `workspace` (`stripe_id`);--> statement-breakpointCREATE UNIQUE INDEX `workspace_id_dsn_unique` ON `workspace` (`id`,`dsn`);--> statement-breakpointCREATE UNIQUE INDEX `user_tenant_id_unique` ON `user` (`tenant_id`);--> statement-breakpointCREATE UNIQUE INDEX `page_slug_unique` ON `page` (`slug`);--> 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` (LOWER("webhook_url"),`page_id`) WHERE "page_subscriber"."unsubscribed_at" IS NULL AND "page_subscriber"."channel_type" = 'webhook';--> statement-breakpointCREATE UNIQUE INDEX `notification_id_monitor_id_crontimestampe` ON `notification_trigger` (`notification_id`,`monitor_id`,`cron_timestamp`);--> statement-breakpointCREATE INDEX `monitor_status_idx` ON `monitor_status` (`monitor_id`,`region`);--> statement-breakpointCREATE UNIQUE INDEX `incident_monitor_id_started_at_unique` ON `incident` (`monitor_id`,`started_at`);--> statement-breakpointCREATE UNIQUE INDEX `application_dsn_unique` ON `application` (`dsn`);--> statement-breakpointCREATE UNIQUE INDEX `viewer_email_unique` ON `viewer` (`email`);--> statement-breakpointCREATE UNIQUE INDEX `api_key_prefix_unique` ON `api_key` (`prefix`);--> statement-breakpointCREATE UNIQUE INDEX `api_key_hashed_token_unique` ON `api_key` (`hashed_token`);--> statement-breakpointCREATE INDEX `api_key_prefix_idx` ON `api_key` (`prefix`);--> statement-breakpointCREATE UNIQUE INDEX `page_component_page_id_monitor_id_unique` ON `page_component` (`page_id`,`monitor_id`);--> statement-breakpointALTER TABLE `page_subscriber` ADD `source` text DEFAULT 'self_signup' NOT NULL;--> statement-breakpointALTER TABLE `page_subscriber` ADD `name` text;