CREATE TABLE IF NOT EXISTS services (
    id                SERIAL PRIMARY KEY,
    name              VARCHAR(255) NOT NULL,
    url               TEXT NOT NULL,
    group_name        VARCHAR(255) NOT NULL DEFAULT 'Geral',
    interval_seconds  INTEGER NOT NULL DEFAULT 60,
    is_active         BOOLEAN NOT NULL DEFAULT true,
    discord_webhook_url TEXT NOT NULL DEFAULT '',
    alert_email       TEXT NOT NULL DEFAULT '',
    keyword_to_find   TEXT NOT NULL DEFAULT '',
    created_at        TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE TABLE IF NOT EXISTS heartbeats (
    id              SERIAL PRIMARY KEY,
    service_id      INTEGER NOT NULL REFERENCES services(id) ON DELETE CASCADE,
    status_code     INTEGER NOT NULL DEFAULT 0,
    response_time_ms BIGINT NOT NULL DEFAULT 0,
    is_up           BOOLEAN NOT NULL DEFAULT false,
    error_message   TEXT NOT NULL DEFAULT '',
    tested_at       TIMESTAMPTZ NOT NULL DEFAULT NOW()
);

CREATE INDEX IF NOT EXISTS idx_heartbeats_service_id ON heartbeats(service_id);
CREATE INDEX IF NOT EXISTS idx_heartbeats_tested_at ON heartbeats(tested_at DESC);
CREATE INDEX IF NOT EXISTS idx_services_is_active ON services(is_active);

CREATE TABLE IF NOT EXISTS maintenances (
    id          SERIAL PRIMARY KEY,
    title       TEXT NOT NULL,
    start_time  TIMESTAMPTZ NOT NULL,
    end_time    TIMESTAMPTZ NOT NULL,
    is_active   BOOLEAN NOT NULL DEFAULT true
);