Installation

A powerful system that lets you create safe zones where players cannot shoot, die, or fight. Zones can optionally heal players on entry and display custom notifications. With a simple in-game creator, zones are easy to place, edit, and manage, making it perfect for hospitals, spawn areas, events, or social hubs.

---

Download Script

To download the assets needed for this script, you must access the official Cfx.re portal, where all assets purchased through Tebex are managed.

1. Go to the following link: 🔗 https://portal.cfx.re/assets/granted-assets

2. Log in with the same Cfx.re account you used to make the purchase.

3. In the list of granted assets, find and download the following:

   • Crime Creator

---

Server.cfg Placement

This script must always start after es_extended or qb-core, never before. We recommend placing it below in your server.cfg, ensuring that all its dependencies are started first to prevent errors or unexpected behavior.

---

Database Setup

Avoid using tools like XAMPP or other non-optimized local servers, as they may cause connection errors.

This script includes an essential database required for its operation. You must import it before starting your server, preferably using HeidiSQL or any other manager compatible with MariaDB/MySQL.

ESX

ALTER TABLE `users` ADD IF NOT EXISTS `crime_house_inside` INT(5) NULL;

INSERT INTO
    `datastore` (name, label, shared)
VALUES
    ('crime_house', 'Crime House', 0);
    
CREATE TABLE IF NOT EXISTS `qs_crime_organizations` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `label` VARCHAR(255) NOT NULL,
    `color` VARCHAR(7) DEFAULT '#000000',
    `entry_coords` LONGTEXT DEFAULT NULL,
    `garage_coords` LONGTEXT DEFAULT NULL,
    `locations_coords` LONGTEXT DEFAULT NULL,
    `zone_points` LONGTEXT DEFAULT NULL,
    `interior_type` VARCHAR(10) DEFAULT '',
    `interior_data` LONGTEXT DEFAULT NULL,
    `mlo_data` LONGTEXT DEFAULT NULL,
    `ipl_data` LONGTEXT DEFAULT NULL,
    `blip_data` LONGTEXT DEFAULT NULL,
    `vault_codes` LONGTEXT DEFAULT NULL,
    `creator` VARCHAR(50) DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `creator` (`creator`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organization_ranks` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `label` VARCHAR(255) NOT NULL,
    `permissions` LONGTEXT DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `organization_id` (`organization_id`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organization_members` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `identifier` VARCHAR(50) NOT NULL,
    `name` VARCHAR(255) NOT NULL,
    `rank_id` INT(11) DEFAULT NULL,
    `is_boss` BOOLEAN NOT NULL DEFAULT FALSE,
    `joined_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `org_identifier` (`organization_id`, `identifier`),
    INDEX `organization_id` (`organization_id`),
    INDEX `identifier` (`identifier`),
    INDEX `rank_id` (`rank_id`),
    INDEX `is_boss` (`is_boss`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`rank_id`) REFERENCES `qs_crime_organization_ranks`(`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organization_finance` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `clean_money` INT(11) NOT NULL DEFAULT 0,
    `dirty_money` INT(11) NOT NULL DEFAULT 0,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `organization_id` (`organization_id`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organization_transactions` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `type` ENUM('deposit', 'withdraw', 'sale', 'expense') NOT NULL,
    `amount` INT(11) NOT NULL,
    `money_type` VARCHAR(20) NOT NULL DEFAULT 'money',
    `description` TEXT DEFAULT NULL,
    `reference` VARCHAR(255) DEFAULT NULL,
    `identifier` VARCHAR(50) DEFAULT NULL,
    `name` VARCHAR(255) DEFAULT NULL,
    `status` ENUM('completed', 'pending', 'failed', 'cancelled') NOT NULL DEFAULT 'completed',
    `metadata` LONGTEXT DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `type` (`type`),
    INDEX `status` (`status`),
    INDEX `created_at` (`created_at`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE IF NOT EXISTS `qs_crime_territories` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `label` VARCHAR(255) NOT NULL,
    `organization_id` INT(11) DEFAULT NULL,
    `zone_data` LONGTEXT NOT NULL,
    `color` VARCHAR(7) DEFAULT '#eab308',
    `creator` VARCHAR(50) DEFAULT NULL,
    `war_protection_until` DATETIME DEFAULT NULL,
    `last_war_at` DATETIME DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `creator` (`creator`),
    INDEX `war_protection_until` (`war_protection_until`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_taxing` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `label` VARCHAR(255) NOT NULL,
    `payment_count_min` INT(11) NOT NULL DEFAULT 1,
    `payment_count_max` INT(11) NOT NULL DEFAULT 1,
    `location` LONGTEXT DEFAULT NULL,
    `territory_id` INT(11) DEFAULT NULL,
    `time_type` VARCHAR(20) DEFAULT 'daily',
    `time_value` INT(11) DEFAULT 1,
    `creator` VARCHAR(50) DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `creator` (`creator`),
    INDEX `territory_id` (`territory_id`),
    FOREIGN KEY (`territory_id`) REFERENCES `qs_crime_territories`(`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_taxing_collections` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `taxing_id` INT(11) NOT NULL,
    `territory_id` INT(11) DEFAULT NULL,
    `organization_id` INT(11) NOT NULL,
    `collector_identifier` VARCHAR(50) NOT NULL,
    `collector_name` VARCHAR(255) NOT NULL,
    `amount` INT(11) NOT NULL,
    `next_collectable_at` DATETIME NOT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `taxing_id` (`taxing_id`),
    INDEX `territory_id` (`territory_id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `next_collectable_at` (`next_collectable_at`),
    FOREIGN KEY (`taxing_id`) REFERENCES `qs_crime_taxing`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`territory_id`) REFERENCES `qs_crime_territories`(`id`) ON DELETE SET NULL,
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_season_pass` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `price` INT(11) NOT NULL DEFAULT 0,
    `end_date` DATETIME NOT NULL,
    `rewards` LONGTEXT NOT NULL,
    `creator` VARCHAR(50) DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `creator` (`creator`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_graffiti` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `label` VARCHAR(255) NOT NULL,
    `font` VARCHAR(100) NOT NULL DEFAULT 'SignPainter-HouseScript',
    `coords` LONGTEXT NOT NULL,
    `rotation` LONGTEXT NOT NULL,
    `scale` FLOAT NOT NULL DEFAULT 1.0,
    `color` VARCHAR(9) DEFAULT 'FFFFFFFF',
    `owner_identifier` VARCHAR(50) DEFAULT NULL,
    `owner_name` VARCHAR(255) DEFAULT NULL,
    `organization_id` INT(11) DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `owner_identifier` (`owner_identifier`),
    INDEX `organization_id` (`organization_id`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organization_upgrades` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `upgrade_name` VARCHAR(100) NOT NULL,
    `level` INT(11) NOT NULL DEFAULT 0,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `org_upgrade` (`organization_id`, `upgrade_name`),
    INDEX `organization_id` (`organization_id`),
    INDEX `upgrade_name` (`upgrade_name`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organization_vehicles` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `vehicle_model` VARCHAR(50) NOT NULL,
    `vehicle_label` VARCHAR(255) NOT NULL,
    `plate` VARCHAR(10) NOT NULL,
    `vehicle_props` LONGTEXT DEFAULT NULL,
    `stored` BOOLEAN NOT NULL DEFAULT TRUE,
    `state` ENUM('garage', 'out', 'impound') NOT NULL DEFAULT 'garage',
    `metadata` LONGTEXT DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `plate` (`plate`),
    INDEX `organization_id` (`organization_id`),
    INDEX `state` (`state`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_vehicle_activities` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `vehicle_id` INT(11) NOT NULL,
    `vehicle_label` VARCHAR(255) NOT NULL,
    `plate` VARCHAR(10) NOT NULL,
    `action` ENUM('spawn', 'store', 'sell', 'retrieve_impound') NOT NULL,
    `player_name` VARCHAR(255) NOT NULL,
    `identifier` VARCHAR(50) DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `vehicle_id` (`vehicle_id`),
    INDEX `created_at` (`created_at`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`vehicle_id`) REFERENCES `qs_crime_organization_vehicles`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_vehicle_store` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `vehicle_model` VARCHAR(50) NOT NULL,
    `vehicle_label` VARCHAR(255) NOT NULL,
    `description` TEXT DEFAULT NULL,
    `image` VARCHAR(500) DEFAULT NULL,
    `price` INT(11) NOT NULL DEFAULT 0,
    `limited` BOOLEAN NOT NULL DEFAULT FALSE,
    `limited_end_date` DATETIME DEFAULT NULL,
    `limited_quantity` INT(11) DEFAULT NULL,
    `creator` VARCHAR(50) DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `vehicle_model` (`vehicle_model`),
    INDEX `limited` (`limited`),
    INDEX `creator` (`creator`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organizations_stats` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `level` INT(11) NOT NULL DEFAULT 1,
    `xp` INT(11) NOT NULL DEFAULT 0,
    `total_missions` INT(11) NOT NULL DEFAULT 0,
    `total_territory_wars_won` INT(11) NOT NULL DEFAULT 0,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `organization_id` (`organization_id`),
    INDEX `level` (`level`),
    INDEX `xp` (`xp`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organization_seasonpass_progress` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `season_pass_id` INT(11) NOT NULL,
    `level` INT(11) NOT NULL DEFAULT 1,
    `xp` INT(11) NOT NULL DEFAULT 0,
    `has_premium` TINYINT(1) NOT NULL DEFAULT 0,
    `claimed_rewards` LONGTEXT DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `org_seasonpass` (`organization_id`, `season_pass_id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `season_pass_id` (`season_pass_id`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`season_pass_id`) REFERENCES `qs_crime_season_pass`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_territory_wars` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `territory_id` INT(11) NOT NULL,
    `status` ENUM('pending', 'active', 'finished') NOT NULL DEFAULT 'pending',
    `started_by_org_id` INT(11) NOT NULL,
    `started_at` DATETIME NOT NULL,
    `ends_at` DATETIME NOT NULL,
    `winner_org_id` INT(11) DEFAULT NULL,
    `start_cost` INT(11) NOT NULL DEFAULT 0,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `territory_id` (`territory_id`),
    INDEX `status` (`status`),
    INDEX `started_by_org_id` (`started_by_org_id`),
    INDEX `winner_org_id` (`winner_org_id`),
    INDEX `ends_at` (`ends_at`),
    FOREIGN KEY (`territory_id`) REFERENCES `qs_crime_territories`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`started_by_org_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`winner_org_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_territory_war_scores` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `war_id` INT(11) NOT NULL,
    `organization_id` INT(11) NOT NULL,
    `score` INT(11) NOT NULL DEFAULT 0,
    `tax_stolen` INT(11) NOT NULL DEFAULT 0,
    `drugs_sold` INT(11) NOT NULL DEFAULT 0,
    `graffiti_sprayed` INT(11) NOT NULL DEFAULT 0,
    `graffiti_removed` INT(11) NOT NULL DEFAULT 0,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `war_org` (`war_id`, `organization_id`),
    INDEX `war_id` (`war_id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `score` (`score`),
    FOREIGN KEY (`war_id`) REFERENCES `qs_crime_territory_wars`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organization_missions` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `mission_id` VARCHAR(100) NOT NULL,
    `progress` INT(11) NOT NULL DEFAULT 0,
    `target_value` INT(11) NOT NULL,
    `completed_at` DATETIME DEFAULT NULL,
    `pending_rewards` LONGTEXT DEFAULT NULL,
    `status` ENUM('active', 'completed') NOT NULL DEFAULT 'active',
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `mission_id` (`mission_id`),
    INDEX `status` (`status`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_mission_history` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `mission_id` VARCHAR(100) NOT NULL,
    `identifier` VARCHAR(50) NOT NULL,
    `completed_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `mission_id` (`mission_id`),
    INDEX `identifier` (`identifier`),
    INDEX `completed_at` (`completed_at`),
    INDEX `org_mission_date` (`organization_id`, `mission_id`, `completed_at`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organization_member_stats` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `identifier` VARCHAR(50) NOT NULL,
    `total_xp_earned` INT(11) NOT NULL DEFAULT 0,
    `total_missions_completed` INT(11) NOT NULL DEFAULT 0,
    `total_territory_wars_participated` INT(11) NOT NULL DEFAULT 0,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `org_identifier` (`organization_id`, `identifier`),
    INDEX `organization_id` (`organization_id`),
    INDEX `identifier` (`identifier`),
    INDEX `total_xp_earned` (`total_xp_earned`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_house_junks` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`house` VARCHAR(255) NOT NULL,
	`model` VARCHAR(255) NOT NULL,
	`coords` LONGTEXT NULL DEFAULT NULL,
	`created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP(),
	PRIMARY KEY (`id`) USING BTREE,
	INDEX `idx_house` (`house`) USING BTREE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `qs_crime_house_decorations` (
	`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`house` VARCHAR(50) NULL DEFAULT NULL,
	`creator` VARCHAR(70) NOT NULL DEFAULT '0',
	`modelName` VARCHAR(50) NOT NULL DEFAULT '0',
	`coords` TEXT NULL DEFAULT NULL,
	`rotation` TEXT NOT NULL DEFAULT '',
	`inStash` TINYINT(1) NOT NULL DEFAULT '0',
	`inHouse` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
	`uniq` VARCHAR(50) NULL DEFAULT NULL,
	`created` TIMESTAMP NULL DEFAULT NULL,
	`lightData` TEXT NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE,
	INDEX `id` (`id`, `house`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;

CREATE TABLE IF NOT EXISTS `qs_crime_pvp_battles` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `label` VARCHAR(255) NOT NULL,
    `start_date` DATETIME NOT NULL,
    `duration` INT(11) NOT NULL,
    `zone_points` LONGTEXT DEFAULT NULL,
    `center_coords` LONGTEXT DEFAULT NULL,
    `rewards` LONGTEXT DEFAULT NULL,
    `allowed_organizations` LONGTEXT DEFAULT NULL,
    `status` ENUM('pending', 'active', 'finished') NOT NULL DEFAULT 'pending',
    `creator` VARCHAR(50) DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `status` (`status`),
    INDEX `start_date` (`start_date`),
    INDEX `creator` (`creator`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_pvp_participants` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `pvp_battle_id` INT(11) NOT NULL,
    `organization_id` INT(11) NOT NULL,
    `status` ENUM('invited', 'accepted', 'cancelled') NOT NULL DEFAULT 'invited',
    `accepted_by` VARCHAR(50) DEFAULT NULL,
    `accepted_at` DATETIME DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `pvp_org` (`pvp_battle_id`, `organization_id`),
    INDEX `pvp_battle_id` (`pvp_battle_id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `status` (`status`),
    FOREIGN KEY (`pvp_battle_id`) REFERENCES `qs_crime_pvp_battles`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_pvp_scores` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `pvp_battle_id` INT(11) NOT NULL,
    `organization_id` INT(11) NOT NULL,
    `score` INT(11) NOT NULL DEFAULT 0,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `pvp_org_score` (`pvp_battle_id`, `organization_id`),
    INDEX `pvp_battle_id` (`pvp_battle_id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `score` (`score`),
    FOREIGN KEY (`pvp_battle_id`) REFERENCES `qs_crime_pvp_battles`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_money_laundering_daily` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `identifier` VARCHAR(50) NOT NULL,
    `completed_count` INT(11) NOT NULL DEFAULT 0,
    `total_laundered` INT(11) NOT NULL DEFAULT 0,
    `last_reset_date` DATE NOT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `org_player_date` (`organization_id`, `identifier`, `last_reset_date`),
    INDEX `organization_id` (`organization_id`),
    INDEX `identifier` (`identifier`),
    INDEX `last_reset_date` (`last_reset_date`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

QB

ALTER TABLE `players` ADD IF NOT EXISTS `crime_house_inside` INT(5) NULL;

CREATE TABLE IF NOT EXISTS `qs_crime_organizations` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `label` VARCHAR(255) NOT NULL,
    `color` VARCHAR(7) DEFAULT '#000000',
    `entry_coords` LONGTEXT DEFAULT NULL,
    `garage_coords` LONGTEXT DEFAULT NULL,
    `locations_coords` LONGTEXT DEFAULT NULL,
    `zone_points` LONGTEXT DEFAULT NULL,
    `interior_type` VARCHAR(10) DEFAULT '',
    `interior_data` LONGTEXT DEFAULT NULL,
    `mlo_data` LONGTEXT DEFAULT NULL,
    `ipl_data` LONGTEXT DEFAULT NULL,
    `blip_data` LONGTEXT DEFAULT NULL,
    `vault_codes` LONGTEXT DEFAULT NULL,
    `creator` VARCHAR(50) DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `creator` (`creator`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organization_ranks` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `label` VARCHAR(255) NOT NULL,
    `permissions` LONGTEXT DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `organization_id` (`organization_id`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organization_members` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `identifier` VARCHAR(50) NOT NULL,
    `name` VARCHAR(255) NOT NULL,
    `rank_id` INT(11) DEFAULT NULL,
    `is_boss` BOOLEAN NOT NULL DEFAULT FALSE,
    `joined_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `org_identifier` (`organization_id`, `identifier`),
    INDEX `organization_id` (`organization_id`),
    INDEX `identifier` (`identifier`),
    INDEX `rank_id` (`rank_id`),
    INDEX `is_boss` (`is_boss`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`rank_id`) REFERENCES `qs_crime_organization_ranks`(`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organization_finance` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `clean_money` INT(11) NOT NULL DEFAULT 0,
    `dirty_money` INT(11) NOT NULL DEFAULT 0,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `organization_id` (`organization_id`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organization_transactions` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `type` ENUM('deposit', 'withdraw', 'sale', 'expense') NOT NULL,
    `amount` INT(11) NOT NULL,
    `money_type` VARCHAR(20) NOT NULL DEFAULT 'money',
    `description` TEXT DEFAULT NULL,
    `reference` VARCHAR(255) DEFAULT NULL,
    `identifier` VARCHAR(50) DEFAULT NULL,
    `name` VARCHAR(255) DEFAULT NULL,
    `status` ENUM('completed', 'pending', 'failed', 'cancelled') NOT NULL DEFAULT 'completed',
    `metadata` LONGTEXT DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `type` (`type`),
    INDEX `status` (`status`),
    INDEX `created_at` (`created_at`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE IF NOT EXISTS `qs_crime_territories` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `label` VARCHAR(255) NOT NULL,
    `organization_id` INT(11) DEFAULT NULL,
    `zone_data` LONGTEXT NOT NULL,
    `color` VARCHAR(7) DEFAULT '#eab308',
    `creator` VARCHAR(50) DEFAULT NULL,
    `war_protection_until` DATETIME DEFAULT NULL,
    `last_war_at` DATETIME DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `creator` (`creator`),
    INDEX `war_protection_until` (`war_protection_until`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_taxing` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `label` VARCHAR(255) NOT NULL,
    `payment_count_min` INT(11) NOT NULL DEFAULT 1,
    `payment_count_max` INT(11) NOT NULL DEFAULT 1,
    `location` LONGTEXT DEFAULT NULL,
    `territory_id` INT(11) DEFAULT NULL,
    `time_type` VARCHAR(20) DEFAULT 'daily',
    `time_value` INT(11) DEFAULT 1,
    `creator` VARCHAR(50) DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `creator` (`creator`),
    INDEX `territory_id` (`territory_id`),
    FOREIGN KEY (`territory_id`) REFERENCES `qs_crime_territories`(`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_taxing_collections` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `taxing_id` INT(11) NOT NULL,
    `territory_id` INT(11) DEFAULT NULL,
    `organization_id` INT(11) NOT NULL,
    `collector_identifier` VARCHAR(50) NOT NULL,
    `collector_name` VARCHAR(255) NOT NULL,
    `amount` INT(11) NOT NULL,
    `next_collectable_at` DATETIME NOT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `taxing_id` (`taxing_id`),
    INDEX `territory_id` (`territory_id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `next_collectable_at` (`next_collectable_at`),
    FOREIGN KEY (`taxing_id`) REFERENCES `qs_crime_taxing`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`territory_id`) REFERENCES `qs_crime_territories`(`id`) ON DELETE SET NULL,
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_season_pass` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `price` INT(11) NOT NULL DEFAULT 0,
    `end_date` DATETIME NOT NULL,
    `rewards` LONGTEXT NOT NULL,
    `creator` VARCHAR(50) DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `creator` (`creator`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_graffiti` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `label` VARCHAR(255) NOT NULL,
    `font` VARCHAR(100) NOT NULL DEFAULT 'SignPainter-HouseScript',
    `coords` LONGTEXT NOT NULL,
    `rotation` LONGTEXT NOT NULL,
    `scale` FLOAT NOT NULL DEFAULT 1.0,
    `color` VARCHAR(9) DEFAULT 'FFFFFFFF',
    `owner_identifier` VARCHAR(50) DEFAULT NULL,
    `owner_name` VARCHAR(255) DEFAULT NULL,
    `organization_id` INT(11) DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `owner_identifier` (`owner_identifier`),
    INDEX `organization_id` (`organization_id`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organization_upgrades` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `upgrade_name` VARCHAR(100) NOT NULL,
    `level` INT(11) NOT NULL DEFAULT 0,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `org_upgrade` (`organization_id`, `upgrade_name`),
    INDEX `organization_id` (`organization_id`),
    INDEX `upgrade_name` (`upgrade_name`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organization_vehicles` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `vehicle_model` VARCHAR(50) NOT NULL,
    `vehicle_label` VARCHAR(255) NOT NULL,
    `plate` VARCHAR(10) NOT NULL,
    `vehicle_props` LONGTEXT DEFAULT NULL,
    `stored` BOOLEAN NOT NULL DEFAULT TRUE,
    `state` ENUM('garage', 'out', 'impound') NOT NULL DEFAULT 'garage',
    `metadata` LONGTEXT DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `plate` (`plate`),
    INDEX `organization_id` (`organization_id`),
    INDEX `state` (`state`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_vehicle_activities` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `vehicle_id` INT(11) NOT NULL,
    `vehicle_label` VARCHAR(255) NOT NULL,
    `plate` VARCHAR(10) NOT NULL,
    `action` ENUM('spawn', 'store', 'sell', 'retrieve_impound') NOT NULL,
    `player_name` VARCHAR(255) NOT NULL,
    `identifier` VARCHAR(50) DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `vehicle_id` (`vehicle_id`),
    INDEX `created_at` (`created_at`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`vehicle_id`) REFERENCES `qs_crime_organization_vehicles`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_vehicle_store` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `vehicle_model` VARCHAR(50) NOT NULL,
    `vehicle_label` VARCHAR(255) NOT NULL,
    `description` TEXT DEFAULT NULL,
    `image` VARCHAR(500) DEFAULT NULL,
    `price` INT(11) NOT NULL DEFAULT 0,
    `limited` BOOLEAN NOT NULL DEFAULT FALSE,
    `limited_end_date` DATETIME DEFAULT NULL,
    `limited_quantity` INT(11) DEFAULT NULL,
    `creator` VARCHAR(50) DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `vehicle_model` (`vehicle_model`),
    INDEX `limited` (`limited`),
    INDEX `creator` (`creator`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organizations_stats` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `level` INT(11) NOT NULL DEFAULT 1,
    `xp` INT(11) NOT NULL DEFAULT 0,
    `total_missions` INT(11) NOT NULL DEFAULT 0,
    `total_territory_wars_won` INT(11) NOT NULL DEFAULT 0,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `organization_id` (`organization_id`),
    INDEX `level` (`level`),
    INDEX `xp` (`xp`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organization_seasonpass_progress` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `season_pass_id` INT(11) NOT NULL,
    `level` INT(11) NOT NULL DEFAULT 1,
    `xp` INT(11) NOT NULL DEFAULT 0,
    `has_premium` TINYINT(1) NOT NULL DEFAULT 0,
    `claimed_rewards` LONGTEXT DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `org_seasonpass` (`organization_id`, `season_pass_id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `season_pass_id` (`season_pass_id`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`season_pass_id`) REFERENCES `qs_crime_season_pass`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_territory_wars` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `territory_id` INT(11) NOT NULL,
    `status` ENUM('pending', 'active', 'finished') NOT NULL DEFAULT 'pending',
    `started_by_org_id` INT(11) NOT NULL,
    `started_at` DATETIME NOT NULL,
    `ends_at` DATETIME NOT NULL,
    `winner_org_id` INT(11) DEFAULT NULL,
    `start_cost` INT(11) NOT NULL DEFAULT 0,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `territory_id` (`territory_id`),
    INDEX `status` (`status`),
    INDEX `started_by_org_id` (`started_by_org_id`),
    INDEX `winner_org_id` (`winner_org_id`),
    INDEX `ends_at` (`ends_at`),
    FOREIGN KEY (`territory_id`) REFERENCES `qs_crime_territories`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`started_by_org_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`winner_org_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_territory_war_scores` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `war_id` INT(11) NOT NULL,
    `organization_id` INT(11) NOT NULL,
    `score` INT(11) NOT NULL DEFAULT 0,
    `tax_stolen` INT(11) NOT NULL DEFAULT 0,
    `drugs_sold` INT(11) NOT NULL DEFAULT 0,
    `graffiti_sprayed` INT(11) NOT NULL DEFAULT 0,
    `graffiti_removed` INT(11) NOT NULL DEFAULT 0,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `war_org` (`war_id`, `organization_id`),
    INDEX `war_id` (`war_id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `score` (`score`),
    FOREIGN KEY (`war_id`) REFERENCES `qs_crime_territory_wars`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organization_missions` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `mission_id` VARCHAR(100) NOT NULL,
    `progress` INT(11) NOT NULL DEFAULT 0,
    `target_value` INT(11) NOT NULL,
    `completed_at` DATETIME DEFAULT NULL,
    `pending_rewards` LONGTEXT DEFAULT NULL,
    `status` ENUM('active', 'completed') NOT NULL DEFAULT 'active',
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `mission_id` (`mission_id`),
    INDEX `status` (`status`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_mission_history` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `mission_id` VARCHAR(100) NOT NULL,
    `identifier` VARCHAR(50) NOT NULL,
    `completed_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `mission_id` (`mission_id`),
    INDEX `identifier` (`identifier`),
    INDEX `completed_at` (`completed_at`),
    INDEX `org_mission_date` (`organization_id`, `mission_id`, `completed_at`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_organization_member_stats` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `identifier` VARCHAR(50) NOT NULL,
    `total_xp_earned` INT(11) NOT NULL DEFAULT 0,
    `total_missions_completed` INT(11) NOT NULL DEFAULT 0,
    `total_territory_wars_participated` INT(11) NOT NULL DEFAULT 0,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `org_identifier` (`organization_id`, `identifier`),
    INDEX `organization_id` (`organization_id`),
    INDEX `identifier` (`identifier`),
    INDEX `total_xp_earned` (`total_xp_earned`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_house_junks` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`house` VARCHAR(255) NOT NULL,
	`model` VARCHAR(255) NOT NULL,
	`coords` LONGTEXT NULL DEFAULT NULL,
	`created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP(),
	PRIMARY KEY (`id`) USING BTREE,
	INDEX `idx_house` (`house`) USING BTREE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `qs_crime_house_decorations` (
	`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`house` VARCHAR(50) NULL DEFAULT NULL,
	`creator` VARCHAR(70) NOT NULL DEFAULT '0',
	`modelName` VARCHAR(50) NOT NULL DEFAULT '0',
	`coords` TEXT NULL DEFAULT NULL,
	`rotation` TEXT NOT NULL DEFAULT '',
	`inStash` TINYINT(1) NOT NULL DEFAULT '0',
	`inHouse` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
	`uniq` VARCHAR(50) NULL DEFAULT NULL,
	`created` TIMESTAMP NULL DEFAULT NULL,
	`lightData` TEXT NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE,
	INDEX `id` (`id`, `house`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
;

CREATE TABLE IF NOT EXISTS `qs_crime_pvp_battles` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `label` VARCHAR(255) NOT NULL,
    `start_date` DATETIME NOT NULL,
    `duration` INT(11) NOT NULL,
    `zone_points` LONGTEXT DEFAULT NULL,
    `center_coords` LONGTEXT DEFAULT NULL,
    `rewards` LONGTEXT DEFAULT NULL,
    `allowed_organizations` LONGTEXT DEFAULT NULL,
    `status` ENUM('pending', 'active', 'finished') NOT NULL DEFAULT 'pending',
    `creator` VARCHAR(50) DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `status` (`status`),
    INDEX `start_date` (`start_date`),
    INDEX `creator` (`creator`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_pvp_participants` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `pvp_battle_id` INT(11) NOT NULL,
    `organization_id` INT(11) NOT NULL,
    `status` ENUM('invited', 'accepted', 'cancelled') NOT NULL DEFAULT 'invited',
    `accepted_by` VARCHAR(50) DEFAULT NULL,
    `accepted_at` DATETIME DEFAULT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `pvp_org` (`pvp_battle_id`, `organization_id`),
    INDEX `pvp_battle_id` (`pvp_battle_id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `status` (`status`),
    FOREIGN KEY (`pvp_battle_id`) REFERENCES `qs_crime_pvp_battles`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_pvp_scores` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `pvp_battle_id` INT(11) NOT NULL,
    `organization_id` INT(11) NOT NULL,
    `score` INT(11) NOT NULL DEFAULT 0,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `pvp_org_score` (`pvp_battle_id`, `organization_id`),
    INDEX `pvp_battle_id` (`pvp_battle_id`),
    INDEX `organization_id` (`organization_id`),
    INDEX `score` (`score`),
    FOREIGN KEY (`pvp_battle_id`) REFERENCES `qs_crime_pvp_battles`(`id`) ON DELETE CASCADE,
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_crime_money_laundering_daily` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `organization_id` INT(11) NOT NULL,
    `identifier` VARCHAR(50) NOT NULL,
    `completed_count` INT(11) NOT NULL DEFAULT 0,
    `total_laundered` INT(11) NOT NULL DEFAULT 0,
    `last_reset_date` DATE NOT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `org_player_date` (`organization_id`, `identifier`, `last_reset_date`),
    INDEX `organization_id` (`organization_id`),
    INDEX `identifier` (`identifier`),
    INDEX `last_reset_date` (`last_reset_date`),
    FOREIGN KEY (`organization_id`) REFERENCES `qs_crime_organizations`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;