-- FIAC Vehicle Brands (luxury cars FIAC works on)

USE fiac_db;

CREATE TABLE IF NOT EXISTS vehicle_brands (
  id TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
  name VARCHAR(60) NOT NULL,
  slug VARCHAR(60) NOT NULL,
  sort_order TINYINT UNSIGNED NOT NULL DEFAULT 0,
  is_active TINYINT(1) NOT NULL DEFAULT 1,
  created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (id),
  UNIQUE KEY uq_vehicle_brands_slug (slug),
  UNIQUE KEY uq_vehicle_brands_name (name)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO vehicle_brands (name, slug, sort_order) VALUES
  ('Audi',         'audi',         1),
  ('Bentley',      'bentley',      2),
  ('Ferrari',      'ferrari',      3),
  ('BMW',          'bmw',          4),
  ('Jaguar',       'jaguar',       5),
  ('Lamborghini',  'lamborghini',  6),
  ('Land Rover',   'land_rover',   7),
  ('Maybach',      'maybach',      8),
  ('Mercedes',     'mercedes',     9),
  ('MG',           'mg',          10),
  ('Mini Cooper',  'mini_cooper', 11),
  ('Jeep',         'jeep',        12),
  ('Volkswagen',   'volkswagen',  13),
  ('Porsche',      'porsche',     14),
  ('Volvo',        'volvo',       15)
ON DUPLICATE KEY UPDATE name = VALUES(name), sort_order = VALUES(sort_order);