-- Run if job_cards already exists (after migration_vehicle_brands.sql)
-- Step 1: import vehicle_models_schema.sql first
-- Step 2: run ALTER below

USE fiac_db;

ALTER TABLE job_cards
  ADD COLUMN vehicle_model_id SMALLINT UNSIGNED DEFAULT NULL AFTER vehicle_brand_id,
  ADD KEY idx_job_cards_vehicle_model (vehicle_model_id),
  ADD CONSTRAINT fk_job_cards_vehicle_model
    FOREIGN KEY (vehicle_model_id) REFERENCES vehicle_models (id);