CREATE TABLE IF NOT EXISTS pools (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    slug TEXT NOT NULL UNIQUE,
    name TEXT NOT NULL,
    cidr TEXT NOT NULL UNIQUE,
    kind TEXT NOT NULL,
    allowed_prefixes_json TEXT NOT NULL,
    enabled BOOLEAN NOT NULL DEFAULT true,
    created_at TEXT NOT NULL
);

CREATE INDEX IF NOT EXISTS idx_pools_slug ON pools(slug);
CREATE INDEX IF NOT EXISTS idx_pools_enabled ON pools(enabled);