A desktop coding agent with free access to frontier models.
TypeScript
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