CREATE TABLE IF NOT EXISTS fuel_station_prices (
  id TEXT PRIMARY KEY,
  effective_date TEXT NOT NULL UNIQUE,
  station_price_milli INTEGER NOT NULL,
  source TEXT NOT NULL DEFAULT 'Saisie Moventra',
  created_by TEXT NOT NULL DEFAULT '',
  created_at TEXT NOT NULL
);

CREATE INDEX IF NOT EXISTS idx_fuel_station_prices_effective_date
  ON fuel_station_prices(effective_date DESC);