CREATE TABLE IF NOT EXISTS `fleet_assets` (
  `id` text PRIMARY KEY NOT NULL,
  `plate` text NOT NULL,
  `vin` text NOT NULL DEFAULT '',
  `asset_type` text NOT NULL,
  `brand` text NOT NULL DEFAULT '',
  `model` text NOT NULL,
  `variant` text NOT NULL DEFAULT '',
  `fiscal_power` text NOT NULL DEFAULT '',
  `fuel` text NOT NULL DEFAULT '',
  `first_registration` text NOT NULL DEFAULT '',
  `category` text NOT NULL DEFAULT '',
  `ptac` text NOT NULL DEFAULT '',
  `empty_weight` text NOT NULL DEFAULT '',
  `current_meter` integer NOT NULL DEFAULT 0,
  `year_start_km` integer NOT NULL DEFAULT 0,
  `status` text NOT NULL DEFAULT 'À planifier',
  `health` integer NOT NULL DEFAULT 100,
  `next_action` text NOT NULL DEFAULT 'Plan initial à définir',
  `notes` text NOT NULL DEFAULT '',
  `created_by` text NOT NULL,
  `created_at` text NOT NULL,
  `updated_at` text NOT NULL
);
CREATE UNIQUE INDEX IF NOT EXISTS `idx_fleet_assets_plate` ON `fleet_assets` (`plate`);
CREATE UNIQUE INDEX IF NOT EXISTS `idx_fleet_assets_vin` ON `fleet_assets` (`vin`) WHERE `vin` <> '';
CREATE INDEX IF NOT EXISTS `idx_fleet_assets_type_status` ON `fleet_assets` (`asset_type`,`status`);