-- hostnames holds the PTR names of addresses. names has the names separated by
-- spaces, and is empty for an address with no PTR names. expires_at is in
-- seconds since 1970.
CREATE TABLE IF NOT EXISTS hostnames (
    address TEXT PRIMARY KEY,
    names TEXT NOT NULL,
    expires_at INTEGER NOT NULL
);

-- geolocations holds the answers of geojs. A part geojs does not know is NULL.
-- fetched_at is in seconds since 1970.
CREATE TABLE IF NOT EXISTS geolocations (
    address TEXT PRIMARY KEY,
    country_code TEXT,
    country TEXT,
    continent_code TEXT,
    region TEXT,
    city TEXT,
    latitude REAL,
    longitude REAL,
    accuracy_radius_km INTEGER,
    time_zone TEXT,
    fetched_at INTEGER NOT NULL
);