Gangbuilder

CREATE TABLE IF NOT EXISTS gangs (
    name VARCHAR(50) PRIMARY KEY,
    label VARCHAR(50),
    coffre_pos TEXT,
    boss_pos TEXT,
    garage_pos TEXT,
    spawn_pos TEXT,
    delete_pos TEXT,
    vestiaire_pos TEXT,
    weapons_enabled BOOLEAN
);

CREATE TABLE IF NOT EXISTS gang_outfits (
    id INT AUTO_INCREMENT PRIMARY KEY,
    gang_name VARCHAR(50),
    label VARCHAR(50),
    skin LONGTEXT
);

CREATE TABLE IF NOT EXISTS gang_coffres (
  id INT NOT NULL AUTO_INCREMENT,
  gang VARCHAR(50) NOT NULL,
  item VARCHAR(100) NOT NULL,
  label VARCHAR(150) NOT NULL,
  count INT NOT NULL DEFAULT 0,
  PRIMARY KEY (id),
  UNIQUE KEY gang_item_unique (gang, item)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS gang_garage (
  id INT NOT NULL AUTO_INCREMENT,
  gang VARCHAR(50) NOT NULL,
  model VARCHAR(50) NOT NULL,
  label VARCHAR(150) NOT NULL,
  vehicle_props TEXT NOT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;