ALTER TABLE maintenance_orders ADD COLUMN tire_operation TEXT;
ALTER TABLE maintenance_orders ADD COLUMN tire_position TEXT;
ALTER TABLE maintenance_orders ADD COLUMN tire_reference TEXT;
ALTER TABLE maintenance_orders ADD COLUMN tire_serial TEXT;
ALTER TABLE maintenance_orders ADD COLUMN tire_brand TEXT;
ALTER TABLE maintenance_orders ADD COLUMN tire_size TEXT;
ALTER TABLE maintenance_orders ADD COLUMN installation_km INTEGER;
ALTER TABLE maintenance_orders ADD COLUMN installation_date TEXT;
ALTER TABLE maintenance_orders ADD COLUMN tread_depth_tenths INTEGER;
ALTER TABLE maintenance_orders ADD COLUMN tire_cost_cents INTEGER NOT NULL DEFAULT 0;

CREATE TABLE fleet_tires (
  id TEXT PRIMARY KEY,
  asset_id TEXT NOT NULL,
  position TEXT NOT NULL,
  reference TEXT NOT NULL,
  serial TEXT NOT NULL,
  brand TEXT NOT NULL DEFAULT '',
  size TEXT NOT NULL DEFAULT '',
  installed_km INTEGER NOT NULL DEFAULT 0,
  installed_date TEXT NOT NULL DEFAULT '',
  tread_depth_tenths INTEGER NOT NULL DEFAULT 0,
  cost_cents INTEGER NOT NULL DEFAULT 0,
  status TEXT NOT NULL DEFAULT 'Monté',
  source_order_id TEXT NOT NULL DEFAULT '',
  updated_at TEXT NOT NULL
);
CREATE UNIQUE INDEX idx_fleet_tires_asset_position ON fleet_tires(asset_id, position);
CREATE UNIQUE INDEX idx_fleet_tires_serial ON fleet_tires(serial) WHERE serial <> '';
CREATE INDEX idx_fleet_tires_asset_status ON fleet_tires(asset_id, status);