CREATE TABLE daily_fuel_consumption (
  id TEXT PRIMARY KEY,
  consumption_date TEXT NOT NULL,
  asset_id TEXT NOT NULL,
  opening_meter INTEGER NOT NULL,
  closing_meter INTEGER NOT NULL,
  distance_km INTEGER NOT NULL,
  fuel_milliliters INTEGER NOT NULL,
  driver_name TEXT NOT NULL DEFAULT '',
  route_note TEXT NOT NULL DEFAULT '',
  created_by TEXT NOT NULL,
  created_at TEXT NOT NULL,
  updated_at TEXT NOT NULL
);

CREATE UNIQUE INDEX idx_daily_fuel_consumption_asset_date
ON daily_fuel_consumption(asset_id,consumption_date);

CREATE INDEX idx_daily_fuel_consumption_date_asset
ON daily_fuel_consumption(consumption_date,asset_id);

PRAGMA optimize;