License/backend/migrations/005_fetch_log.sql

-- ============================================================
-- 域名爬取日志表
-- ============================================================

CREATE TABLE domain_monitor.fetch_logs (
    id SERIAL PRIMARY KEY,
    domain VARCHAR NOT NULL,
    status VARCHAR NOT NULL,
    message TEXT,
    created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
);

CREATE INDEX idx_fetch_logs_domain ON domain_monitor.fetch_logs(domain);
CREATE INDEX idx_fetch_logs_created_at ON domain_monitor.fetch_logs(created_at);