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

export const channelPermissionLinks = sqliteTable('channel_permission_links', {
  id: text('id').primaryKey(),
  channelId: text('channel_id').notNull(),
  chatId: text('chat_id').notNull(),
  agentId: text('agent_id'),
  permissionMode: text('permission_mode').notNull().default('confirm'),
  createdAt: text('created_at').notNull().default(sql`(datetime('now'))`),
})

export type ChannelPermissionLink = typeof channelPermissionLinks.$inferSelect
export type NewChannelPermissionLink = typeof channelPermissionLinks.$inferInsert