-- Cache para meteo
CREATE TABLE IF NOT EXISTS weather_cache (
  cache_key VARCHAR(100) PRIMARY KEY,
  payload JSON NOT NULL,
  expires_at DATETIME NOT NULL
);

-- Tokens OAuth Google
CREATE TABLE IF NOT EXISTS google_tokens (
  id INT PRIMARY KEY CHECK (id=1),
  access_token TEXT,
  refresh_token TEXT,
  scope TEXT,
  token_type VARCHAR(50),
  expiry DATETIME
);
