mk6i-open-oscar-server/state/migrations/0043_drop_web_api_keys.down.sql

-- Rollback: recreate the Web API key table as 0023 defined it, less the
-- last_used column 0042 dropped.

CREATE TABLE IF NOT EXISTS web_api_keys (
    dev_id VARCHAR(255) PRIMARY KEY,
    dev_key VARCHAR(255) UNIQUE NOT NULL,
    app_name VARCHAR(255) NOT NULL,
    created_at INTEGER NOT NULL,
    is_active BOOLEAN DEFAULT 1,
    rate_limit INTEGER DEFAULT 60,
    allowed_origins TEXT, -- JSON array of allowed CORS origins
    capabilities TEXT     -- JSON array of enabled features/endpoints
);

CREATE INDEX IF NOT EXISTS idx_web_api_keys_dev_key ON web_api_keys(dev_key);
CREATE INDEX IF NOT EXISTS idx_web_api_keys_is_active ON web_api_keys(is_active);