import { pgTable, varchar, text, boolean, timestamp } from 'drizzle-orm/pg-core'

export const appSettings = pgTable('app_settings', {
  key: varchar('key', { length: 100 }).primaryKey(),
  value: text('value'),
  isEncrypted: boolean('is_encrypted').notNull().default(false),
  iv: text('iv'),
  createdAt: timestamp('created_at', { withTimezone: true }).notNull().defaultNow(),
  updatedAt: timestamp('updated_at', { withTimezone: true }).notNull().defaultNow(),
})

export type AppSetting = typeof appSettings.$inferSelect
export type AppSettingInsert = typeof appSettings.$inferInsert
