Skip to content

A desktop coding agent with free access to frontier models.

TypeScript
9.9 KB
Raw Blame
import { relations, sql } from "drizzle-orm"
import { index, json, mysqlTable, text, timestamp, uniqueIndex, varchar } from "drizzle-orm/mysql-core"
import type { DesktopAppRestrictions } from "@omnirush/types/den/desktop-app-restrictions"
import type { ConnectLinkClaims } from "@omnirush/types/connect-link"
import { denTypeIdColumn, mediumBlobColumn } from "../columns"

export const DesktopHandoffGrantTable = mysqlTable(
  "desktop_handoff_grant",
  {
    id: varchar("id", { length: 64 }).notNull().primaryKey(),
    user_id: denTypeIdColumn("user", "user_id").notNull(),
    session_token: text("session_token").notNull(),
    expires_at: timestamp("expires_at", { fsp: 3 }).notNull(),
    consumed_at: timestamp("consumed_at", { fsp: 3 }),
    created_at: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
  },
  (table) => [
    index("desktop_handoff_grant_user_id").on(table.user_id),
    index("desktop_handoff_grant_expires_at").on(table.expires_at),
  ],
)

export const DesktopConnectGrantTable = mysqlTable(
  "desktop_connect_grant",
  {
    codeHash: varchar("code_hash", { length: 64 }).notNull().primaryKey(),
    installLinkId: denTypeIdColumn("installLink", "install_link_id").notNull(),
    claims: json("claims").$type<ConnectLinkClaims>().notNull(),
    expiresAt: timestamp("expires_at", { fsp: 3 }).notNull(),
    consumedAt: timestamp("consumed_at", { fsp: 3 }),
    consumedNonce: varchar("consumed_nonce", { length: 64 }),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
  },
  (table) => [
    index("desktop_connect_grant_install_link_id").on(table.installLinkId),
    index("desktop_connect_grant_expires_at").on(table.expiresAt),
  ],
)

export const OrganizationTable = mysqlTable(
  "organization",
  {
    id: denTypeIdColumn("organization", "id").notNull().primaryKey(),
    name: varchar("name", { length: 255 }).notNull(),
    slug: varchar("slug", { length: 255 }).notNull(),
    logo: varchar("logo", { length: 2048 }),
    allowedEmailDomains: json("allowed_email_domains").$type<string[] | null>(),
    desktopAppRestrictions: json("desktop_app_restrictions").$type<DesktopAppRestrictions>().notNull().default(sql`(json_object())`),
    metadata: json("metadata").$type<Record<string, unknown> | null>(),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    updatedAt: timestamp("updated_at", { fsp: 3 })
      .notNull()
      .default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
  },
  (table) => [uniqueIndex("organization_slug").on(table.slug), index("organization_created_at_id").on(table.createdAt, table.id)],
)

export const OrganizationBrandAssetTable = mysqlTable(
  "organization_brand_asset",
  {
    id: varchar("id", { length: 64 }).notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    kind: varchar("kind", { length: 16 }).notNull(),
    version: varchar("version", { length: 64 }).notNull(),
    extension: varchar("extension", { length: 3 }).notNull(),
    bytes: mediumBlobColumn("bytes").notNull(),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
  },
  (table) => [
    uniqueIndex("organization_brand_asset_version").on(
      table.organizationId,
      table.kind,
      table.version,
      table.extension,
    ),
  ],
)

export const MemberTable = mysqlTable(
  "member",
  {
    id: denTypeIdColumn("member", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    userId: denTypeIdColumn("user", "user_id"),
    inviteId: denTypeIdColumn("invitation", "invite_id"),
    invitedByOrgMember: denTypeIdColumn("member", "invited_by_org_member"),
    role: varchar("role", { length: 255 }).notNull().default("member"),
    joinedAt: timestamp("joined_at", { fsp: 3 }).defaultNow(),
    removedAt: timestamp("removed_at", { fsp: 3 }),
    removedByOrgMember: denTypeIdColumn("member", "removed_by_org_member"),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
  },
  (table) => [
    index("member_user_id").on(table.userId),
    index("member_invite_id").on(table.inviteId),
    index("member_invited_by_org_member").on(table.invitedByOrgMember),
    index("member_removed_at").on(table.removedAt),
    index("member_removed_by_org_member").on(table.removedByOrgMember),
    uniqueIndex("member_organization_user").on(table.organizationId, table.userId),
  ],
)

export const InvitationTable = mysqlTable(
  "invitation",
  {
    id: denTypeIdColumn("invitation", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    email: varchar("email", { length: 255 }).notNull(),
    role: varchar("role", { length: 255 }).notNull(),
    status: varchar("status", { length: 32 }).notNull().default("pending"),
    teamId: denTypeIdColumn("team", "team_id"),
    inviterId: denTypeIdColumn("user", "inviter_id").notNull(),
    orgMemberId: denTypeIdColumn("member", "org_member_id"),
    inviteToken: varchar("invite_token", { length: 64 }),
    expiresAt: timestamp("expires_at", { fsp: 3 }).notNull(),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
  },
  (table) => [
    index("invitation_organization_id").on(table.organizationId),
    index("invitation_email").on(table.email),
    index("invitation_status").on(table.status),
    index("invitation_team_id").on(table.teamId),
    index("invitation_inviter_id").on(table.inviterId),
    index("invitation_org_member_id").on(table.orgMemberId),
    uniqueIndex("invitation_invite_token").on(table.inviteToken),
  ],
)

export const WorkspaceBootstrapTable = mysqlTable(
  "workspace_bootstrap",
  {
    id: denTypeIdColumn("workspaceBootstrap", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    setupMemberId: denTypeIdColumn("member", "setup_member_id").notNull(),
    devicePublicKey: text("device_public_key"),
    deviceKeyFingerprint: varchar("device_key_fingerprint", { length: 128 }),
    status: varchar("status", { length: 32 }).notNull().default("provisional"),
    expiresAt: timestamp("expires_at", { fsp: 3 }).notNull(),
    claimedAt: timestamp("claimed_at", { fsp: 3 }),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
  },
  (table) => [
    index("workspace_bootstrap_organization_id").on(table.organizationId),
    index("workspace_bootstrap_status").on(table.status),
    index("workspace_bootstrap_expires_at").on(table.expiresAt),
  ],
)

export const WorkspaceClaimTable = mysqlTable(
  "workspace_claim",
  {
    id: denTypeIdColumn("workspaceClaim", "id").notNull().primaryKey(),
    bootstrapId: denTypeIdColumn("workspaceBootstrap", "bootstrap_id").notNull(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    tokenHash: varchar("token_hash", { length: 128 }).notNull(),
    role: varchar("role", { length: 255 }).notNull(),
    status: varchar("status", { length: 32 }).notNull().default("pending"),
    expiresAt: timestamp("expires_at", { fsp: 3 }).notNull(),
    claimedByUserId: denTypeIdColumn("user", "claimed_by_user_id"),
    claimedAt: timestamp("claimed_at", { fsp: 3 }),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
  },
  (table) => [
    uniqueIndex("workspace_claim_token_hash").on(table.tokenHash),
    index("workspace_claim_bootstrap_id").on(table.bootstrapId),
    index("workspace_claim_organization_id").on(table.organizationId),
    index("workspace_claim_status").on(table.status),
    index("workspace_claim_expires_at").on(table.expiresAt),
  ],
)

export const InstallLinkTable = mysqlTable(
  "install_link",
  {
    id: denTypeIdColumn("installLink", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    tokenHash: varchar("token_hash", { length: 128 }).notNull(),
    createdByUserId: denTypeIdColumn("user", "created_by_user_id").notNull(),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    revokedAt: timestamp("revoked_at", { fsp: 3 }),
    expiresAt: timestamp("expires_at", { fsp: 3 }),
  },
  (table) => [
    uniqueIndex("install_link_token_hash").on(table.tokenHash),
    index("install_link_organization_id").on(table.organizationId),
    index("install_link_created_by_user_id").on(table.createdByUserId),
    index("install_link_revoked_at").on(table.revokedAt),
    index("install_link_expires_at").on(table.expiresAt),
  ],
)

export const OrganizationRoleTable = mysqlTable(
  "organization_role",
  {
    id: denTypeIdColumn("organizationRole", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    role: varchar("role", { length: 255 }).notNull(),
    permission: text("permission").notNull(),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    updatedAt: timestamp("updated_at", { fsp: 3 })
      .notNull()
      .default(sql`CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3)`),
  },
  (table) => [
    uniqueIndex("organization_role_name").on(table.organizationId, table.role),
  ],
)

export const organizationRelations = relations(OrganizationTable, ({ many }) => ({
  members: many(MemberTable),
  roles: many(OrganizationRoleTable),
}))

export const memberRelations = relations(MemberTable, ({ many, one }) => ({
  organization: one(OrganizationTable, {
    fields: [MemberTable.organizationId],
    references: [OrganizationTable.id],
  }),
}))

export const organizationRoleRelations = relations(OrganizationRoleTable, ({ one }) => ({
  organization: one(OrganizationTable, {
    fields: [OrganizationRoleTable.organizationId],
    references: [OrganizationTable.id],
  }),
}))

export const organization = OrganizationTable
export const member = MemberTable
export const invitation = InvitationTable
export const workspaceBootstrap = WorkspaceBootstrapTable
export const workspaceClaim = WorkspaceClaimTable
export const installLink = InstallLinkTable
export const organizationRole = OrganizationRoleTable