export interface ReportSchedule {
  id?: number
  name: string
  frequency: 'weekly' | 'monthly'
  recipients: string // Comma-separated emails
  enabled: boolean
  lastRun?: Date
  nextRun?: Date
  createdAt?: Date
}

export function createReportScheduleTable(db: any) {
  db.exec(`
    CREATE TABLE IF NOT EXISTS report_schedules (
      id INTEGER PRIMARY KEY AUTOINCREMENT,
      name TEXT NOT NULL,
      frequency TEXT NOT NULL CHECK(frequency IN ('weekly', 'monthly')),
      recipients TEXT NOT NULL,
      enabled INTEGER DEFAULT 1,
      last_run TEXT,
      next_run TEXT,
      created_at TEXT DEFAULT CURRENT_TIMESTAMP
    );
  `)
}