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.3 kB · 35 lines
TypeScript
123456789101112131415161718192021222324252627282930313233343536import { sql } from "drizzle-orm";import { index, integer, sqliteTable, text } from "drizzle-orm/sqlite-core";
import { type ApiConfig, type Industry, STATUS_PAGE_PROVIDERS,} from "./constants";
export const externalService = sqliteTable( "external_service", { id: integer("id").primaryKey(), slug: text("slug", { length: 64 }).notNull().unique(), aliases: text("aliases", { mode: "json" }) .$type<string[]>() .default(sql`(json_array())`) .notNull(), name: text("name", { length: 256 }).notNull(), url: text("url").notNull(), statusPageUrl: text("status_page_url").notNull(), provider: text("provider", { enum: STATUS_PAGE_PROVIDERS }).notNull(), industry: text("industry", { mode: "json" }).$type<Industry[]>().notNull(), description: text("description"), apiConfig: text("api_config", { mode: "json" }).$type<ApiConfig>(), deletedAt: integer("deleted_at", { mode: "timestamp" }), createdAt: integer("created_at", { mode: "timestamp" }).default( sql`(strftime('%s', 'now'))`, ), updatedAt: integer("updated_at", { mode: "timestamp" }).default( sql`(strftime('%s', 'now'))`, ), }, (t) => [index("external_service_deleted_at_idx").on(t.deletedAt)],);