-- Migration 011: Webhooks for event subscriptions
-- Part of API Endpoints dashboard (#563)

CREATE TABLE IF NOT EXISTS webhooks (
  id TEXT PRIMARY KEY,
  url TEXT NOT NULL,
  events TEXT NOT NULL DEFAULT '["*"]',
  secret TEXT,
  enabled INTEGER DEFAULT 1,
  description TEXT DEFAULT '',
  created_at TEXT DEFAULT (datetime('now')),
  last_triggered_at TEXT,
  last_status INTEGER,
  failure_count INTEGER DEFAULT 0
);