Skip to content

A desktop coding agent with free access to frontier models.

TypeScript
5.1 KB
Raw Blame
import { boolean, index, mysqlTable, timestamp, uniqueIndex, varchar } from "drizzle-orm/mysql-core"
import { denTypeIdColumn } from "../columns"

export const ScimGroupTable = mysqlTable(
  "scim_group",
  {
    id: denTypeIdColumn("scimGroup", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    providerId: varchar("provider_id", { length: 255 }).notNull(),
    scimGroupId: varchar("scim_group_id", { length: 64 }).notNull(),
    externalId: varchar("external_id", { length: 191 }),
    externalIdKey: varchar("external_id_key", { length: 768 }),
    displayName: varchar("display_name", { length: 255 }).notNull(),
    teamId: denTypeIdColumn("team", "team_id"),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    updatedAt: timestamp("updated_at", { fsp: 3 }).notNull().defaultNow(),
  },
  (table) => [
    uniqueIndex("scim_group_scim_group_id").on(table.scimGroupId),
    uniqueIndex("scim_group_provider_external_id").on(table.providerId, table.externalId),
    uniqueIndex("scim_group_external_id_key").on(table.externalIdKey),
    uniqueIndex("scim_group_team_id").on(table.teamId),
    index("scim_group_organization_id").on(table.organizationId),
  ],
)

export const ScimGroupMemberTable = mysqlTable(
  "scim_group_member",
  {
    id: denTypeIdColumn("scimGroupMember", "id").notNull().primaryKey(),
    groupId: denTypeIdColumn("scimGroup", "group_id").notNull(),
    organizationId: denTypeIdColumn("organization", "organization_id"),
    providerId: varchar("provider_id", { length: 255 }),
    remoteUserId: varchar("remote_user_id", { length: 191 }),
    membershipKey: varchar("membership_key", { length: 768 }),
    userId: denTypeIdColumn("user", "user_id"),
    orgMembershipId: denTypeIdColumn("member", "org_membership_id"),
    teamMemberId: denTypeIdColumn("teamMember", "team_member_id"),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
    updatedAt: timestamp("updated_at", { fsp: 3 }).notNull().defaultNow(),
  },
  (table) => [
    uniqueIndex("scim_group_member_group_remote_user").on(table.groupId, table.remoteUserId),
    uniqueIndex("scim_group_member_membership_key").on(table.membershipKey),
    index("scim_group_member_user_id").on(table.userId),
    index("scim_group_member_org_membership_id").on(table.orgMembershipId),
    index("scim_group_member_team_member_id").on(table.teamMemberId),
    index("scim_group_member_provider_org").on(table.providerId, table.organizationId),
  ],
)

export const ScimGroupRoleTable = mysqlTable(
  "scim_group_role",
  {
    id: denTypeIdColumn("scimGroupRole", "id").notNull().primaryKey(),
    groupId: denTypeIdColumn("scimGroup", "group_id").notNull(),
    role: varchar("role", { length: 255 }).notNull(),
    roleKey: varchar("role_key", { length: 768 }).notNull(),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
  },
  (table) => [uniqueIndex("scim_group_role_role_key").on(table.roleKey), index("scim_group_role_group_id").on(table.groupId)],
)

export const ScimGroupRoleGrantTable = mysqlTable(
  "scim_group_role_grant",
  {
    id: denTypeIdColumn("scimGroupRoleGrant", "id").notNull().primaryKey(),
    groupId: denTypeIdColumn("scimGroup", "group_id").notNull(),
    providerId: varchar("provider_id", { length: 255 }).notNull(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    userId: denTypeIdColumn("user", "user_id").notNull(),
    role: varchar("role", { length: 255 }).notNull(),
    roleGrantKey: varchar("role_grant_key", { length: 768 }).notNull(),
    isRoleProjected: boolean("is_role_projected").notNull(),
    createdAt: timestamp("created_at", { fsp: 3 }).notNull().defaultNow(),
  },
  (table) => [
    uniqueIndex("scim_group_role_grant_role_grant_key").on(table.roleGrantKey),
    index("scim_group_role_grant_group_id").on(table.groupId),
    index("scim_group_role_grant_provider_org").on(table.providerId, table.organizationId),
    index("scim_group_role_grant_user_id").on(table.userId),
  ],
)

export const ScimUserTombstoneTable = mysqlTable(
  "scim_user_tombstone",
  {
    id: denTypeIdColumn("scimUserTombstone", "id").notNull().primaryKey(),
    organizationId: denTypeIdColumn("organization", "organization_id").notNull(),
    providerId: varchar("provider_id", { length: 255 }).notNull(),
    deprovisionedUserId: denTypeIdColumn("user", "deprovisioned_user_id"),
    externalId: varchar("external_id", { length: 191 }),
    email: varchar("email", { length: 191 }),
    deprovisionedAt: timestamp("deprovisioned_at", { fsp: 3 }).notNull().defaultNow(),
  },
  (table) => [
    uniqueIndex("scim_user_tombstone_org_user").on(table.organizationId, table.deprovisionedUserId),
    index("scim_user_tombstone_org_external_id").on(table.organizationId, table.externalId),
    index("scim_user_tombstone_org_email").on(table.organizationId, table.email),
  ],
)

// Lowercase aliases match the better-auth SCIM model names.
export const scimGroup = ScimGroupTable
export const scimGroupMember = ScimGroupMemberTable
export const scimGroupRole = ScimGroupRoleTable
export const scimGroupRoleGrant = ScimGroupRoleGrantTable