import { sqliteTable, text, primaryKey } from 'drizzle-orm/sqlite-core'

/** Agent-Skill 关联表。无 FK，级联删除由 agentRepo/skillRepo 在事务中处理。 */
export const agentSkills = sqliteTable(
  'agent_skills',
  {
    agentId: text('agent_id').notNull(),
    skillId: text('skill_id').notNull(),
  },
  (t) => ({
    pk: primaryKey({ columns: [t.agentId, t.skillId] }),
  }),
)

export type AgentSkill = typeof agentSkills.$inferSelect
export type NewAgentSkill = typeof agentSkills.$inferInsert