/
Alex_Ural
/
opencode
Обзор
Документация
Войти
/
Alex_Ural
/
opencode
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
dev
packages/console/core/src/schema/referral.sql.ts
35 строк
1 KB
Victor Navarro
chore: simplify referral codes (#28491)
20 май 2026, 20:15
Не верифицирован
20 май 2026, 20:15
b67b03e
Код
Авторство
О чём код?
import { bigint, mysqlTable, primaryKey, uniqueIndex, varchar } from "drizzle-orm/mysql-core" import { timestamps, ulid, utc, workspaceColumns } from "../drizzle/types" import { workspaceIndexes } from "./workspace.sql" export const ReferralCodeTable = mysqlTable( "referral_code", { workspaceID: ulid("workspace_id").notNull(), code: varchar("code", { length: 10 }).notNull(), ...timestamps, }, (table) => [primaryKey({ columns: [table.workspaceID] }), uniqueIndex("code").on(table.code)], ) export const ReferralTable = mysqlTable( "referral", { ...workspaceColumns, ...timestamps, inviteeAccountID: ulid("invitee_account_id").notNull(), }, (table) => [...workspaceIndexes(table), uniqueIndex("invitee_account_id").on(table.inviteeAccountID)], ) export const ReferralRewardTable = mysqlTable( "referral_reward", { workspaceID: ulid("workspace_id").notNull(), referralID: ulid("referral_id").notNull(), ...timestamps, amount: bigint("amount", { mode: "number" }).notNull(), timeApplied: utc("time_applied"), }, (table) => [primaryKey({ columns: [table.workspaceID, table.referralID] })], )