Quasar Store

https://docs.quasar-store.com
Admin
Quasar Store provides a comprehensive collection of scripts and resources, primarily for the FiveM...
Tokens:642,878
Snippets:3,155
Trust Score:8.7
Update:8 months ago
Show doc for...
Tokens:
Raw
### Database Setup Scripts for QBCORE Framework

Source: https://docs.quasar-store.com/scripts/advanced-inventory/installation

SQL commands to set up the database schema for the QBCORE framework. This includes adding a new column for inventory skills and creating/modifying tables for inventory management (glovebox, stash, trunk) and metadata. Ensure these are executed before starting the server.

```sql
ALTER TABLE `players` ADD IF NOT EXISTS `inventory_skill` TEXT NULL DEFAULT NULL;

DROP TABLE IF EXISTS `inventory_glovebox`;
CREATE TABLE IF NOT EXISTS `inventory_glovebox` (
  `id` int(11) NOT NULL AUTO_INCREMENT, 
  `plate` varchar(255) DEFAULT NULL, 
  `items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, 
  PRIMARY KEY (`plate`), 
  KEY `id` (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = latin1;

DROP TABLE IF EXISTS `inventory_stash`;
CREATE TABLE IF NOT EXISTS `inventory_stash` (
  `id` int(11) NOT NULL AUTO_INCREMENT, 
  `stash` varchar(255) DEFAULT NULL, 
  `items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, 
  PRIMARY KEY (`stash`), 
  KEY `id` (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = latin1;

DROP TABLE IF EXISTS `inventory_trunk`;
CREATE TABLE IF NOT EXISTS `inventory_trunk` (
  `id` int(11) NOT NULL AUTO_INCREMENT, 
  `plate` varchar(255) DEFAULT NULL, 
  `items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, 
  PRIMARY KEY (`plate`), 
  KEY `id` (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = latin1;

DROP TABLE IF EXISTS `inventory_metadata`;
CREATE TABLE IF NOT EXISTS `inventory_metadata` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `identifier` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
  `data` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
  PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB;

DROP TABLE IF EXISTS `inventory_clothes`;
CREATE TABLE IF NOT EXISTS `inventory_clothes`;
```

--------------------------------

### Start Quasar Tutorial Client Export (Lua)

Source: https://docs.quasar-store.com/scripts/intro-tutorial/commands-and-exports

This client-side export initiates the Quasar Tutorial for players. It requires no additional setup and can be called directly from your client-side script to display text instructions and images for guided player experiences.

```lua
-- Place this on top of your client-side script, no additional setup needed!
exports['qs-tutorial']:StartTutorial()
```

--------------------------------

### Database Setup for QBCore Framework

Source: https://docs.quasar-store.com/scripts/diamond-casino/installation

SQL commands to set up the database tables for the casino script when using the QBCore framework. This focuses on defining tables for memberships and blocked players, assuming other necessary entries are handled by QBCore itself.

```sql
DROP TABLE IF EXISTS `casino_memberships`;

CREATE TABLE `casino_memberships` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`identifier` VARCHAR(90) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
	`chips` INT(11) NOT NULL DEFAULT '0',
	`vip` TINYINT(1) NULL DEFAULT '0',
	`luckywheel_date` TIMESTAMP NULL DEFAULT current_timestamp(),
	`chip_buy_date` TIMESTAMP NULL DEFAULT current_timestamp(),
	PRIMARY KEY (`id`) USING BTREE,
	UNIQUE INDEX `identifier` (`identifier`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;

DROP TABLE IF EXISTS `casino_blocked_players`;

CREATE TABLE `casino_blocked_players` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`identifier` VARCHAR(90) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
	`reason` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
;

```

--------------------------------

### Database Setup for QBCORE Framework

Source: https://docs.quasar-store.com/scripts/yacht-creator/installation

This SQL script outlines the database setup for the Quasar Store project using the QBCORE framework. It includes altering the 'players' table and creating the 'qs_yachts' table, similar to the ESX setup but tailored for QBCORE compatibility. This should be imported before server startup.

```sql
ALTER TABLE `players` ADD COLUMN IF NOT EXISTS `yacht_inside` VARCHAR(40) NULL DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `qs_yachts` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`yacht_id` INT(11) NOT NULL,
	`owner` VARCHAR(60) NOT NULL COLLATE 'utf8mb4_unicode_ci',
	`owner_name` VARCHAR(100) NOT NULL COLLATE 'utf8mb4_unicode_ci',
	`name` VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
	`modifications` LONGTEXT NOT NULL COLLATE 'utf8mb4_unicode_ci',

```

--------------------------------

### Database Setup for ESX Framework

Source: https://docs.quasar-store.com/scripts/motels-creator/installation

This SQL script sets up the database for the Quasar Store project using the ESX framework. It includes adding a new column to the 'users' table and creating several new tables: 'motels', 'motels_bills', 'motels_items', 'motels_owners', 'motels_storages', and 'motels_workers'. Ensure this script is imported before starting your server.

```sql
ALTER TABLE
    `users`
ADD
    COLUMN IF NOT EXISTS `currentRoom` VARCHAR(90) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci';
    
DROP TABLE IF EXISTS `motels`;

CREATE TABLE `motels` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`owner` VARCHAR(90) NOT NULL COLLATE 'utf8mb4_general_ci',
	`pay` INT(11) NOT NULL DEFAULT '0',
	`motel` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	`roomId` INT(5) NOT NULL,
	`uniq` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
	`requests` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
	`suspended` INT(2) NOT NULL DEFAULT '0',
	`shared` TEXT NOT NULL COLLATE 'utf8mb4_general_ci',
	`startTime` INT(12) NULL DEFAULT NULL,
	`endTime` INT(12) NULL DEFAULT NULL,
	`warn` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
	PRIMARY KEY (`id`) USING BTREE,
	UNIQUE INDEX `owner` (`owner`) USING BTREE
)
COLLATE='utf8mb4_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;

DROP TABLE IF EXISTS `motels_bills`;

CREATE TABLE `motels_bills` (
    `owner` VARCHAR(50) NOT NULL COLLATE 'armscii8_bin',
    `data` TEXT NOT NULL COLLATE 'armscii8_bin',
    PRIMARY KEY (`owner`) USING BTREE,
    INDEX `owner` (`owner`) USING BTREE
) COLLATE = 'armscii8_bin' ENGINE = InnoDB;

DROP TABLE IF EXISTS `motels_items`;

CREATE TABLE `motels_items` (
    `id` VARCHAR(50) NOT NULL DEFAULT 'AUTO_INCREMENT' COLLATE 'utf8mb4_general_ci',
    `items` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `limit` INT(11) NOT NULL,
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB;

DROP TABLE IF EXISTS `motels_owners`;

CREATE TABLE `motels_owners` (
    `owner` VARCHAR(50) NOT NULL COLLATE 'armscii8_bin',
    `motel` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'armscii8_bin',
    PRIMARY KEY (`motel`) USING BTREE
) COLLATE = 'armscii8_bin' ENGINE = InnoDB;

DROP TABLE IF EXISTS `motels_storages`;

CREATE TABLE `motels_storages` (
    `motel` VARCHAR(50) NOT NULL COLLATE 'armscii8_bin',
    `money` INT(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`motel`) USING BTREE
) COLLATE = 'armscii8_bin' ENGINE = InnoDB;

DROP TABLE IF EXISTS `motels_workers`;

CREATE TABLE `motels_workers` (
    `employee` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'armscii8_bin',
    `motel` VARCHAR(50) NOT NULL COLLATE 'armscii8_bin',
    `salary` INT(11) NOT NULL,
    `pay` INT(11) NOT NULL,
    `permissions` TEXT NOT NULL COLLATE 'armscii8_bin',
    PRIMARY KEY (`employee`) USING BTREE
) COLLATE = 'armscii8_bin' ENGINE = InnoDB;

```

--------------------------------

### Database Setup for ESX Framework

Source: https://docs.quasar-store.com/scripts/diamond-casino/installation

SQL commands to set up the database tables and initial data for the casino script when using the ESX framework. This includes creating inventory and datastore entries, and defining tables for memberships and blocked players.

```sql
INSERT INTO
    `addon_inventory` (name, label, shared)
VALUES
    ('casino', 'Casino', 0);

INSERT INTO
    `datastore` (name, label, shared)
VALUES
    ('casino', 'Casino', 0);
    
DROP TABLE IF EXISTS `casino_memberships`;

CREATE TABLE `casino_memberships` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`identifier` VARCHAR(90) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
	`chips` INT(11) NOT NULL DEFAULT '0',
	`vip` TINYINT(1) NULL DEFAULT '0',
	`luckywheel_date` TIMESTAMP NULL DEFAULT current_timestamp(),
	`chip_buy_date` TIMESTAMP NULL DEFAULT current_timestamp(),
	PRIMARY KEY (`id`) USING BTREE,
	UNIQUE INDEX `identifier` (`identifier`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;

DROP TABLE IF EXISTS `casino_blocked_players`;

CREATE TABLE `casino_blocked_players` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`identifier` VARCHAR(90) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
	`reason` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
;

```

--------------------------------

### Database Setup Scripts for ESX Framework

Source: https://docs.quasar-store.com/scripts/advanced-inventory/installation

SQL commands to set up the database schema for the ESX framework. This includes updating user data, adding new columns, and creating/modifying tables for inventory management (glovebox, stash, trunk), metadata, clothes, and quests. Ensure these are executed before starting the server.

```sql
UPDATE `users` SET `inventory` = '[]' WHERE identifier IS NOT NULL;
ALTER TABLE `users` ADD IF NOT EXISTS `metadata` mediumtext DEFAULT NULL;
ALTER TABLE `users` ADD IF NOT EXISTS `inventory_skill` TEXT NULL DEFAULT NULL;

DROP TABLE IF EXISTS `inventory_glovebox`;
CREATE TABLE IF NOT EXISTS `inventory_glovebox` (
  `id` int(11) NOT NULL AUTO_INCREMENT, 
  `plate` varchar(255) DEFAULT NULL, 
  `items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, 
  PRIMARY KEY (`plate`), 
  KEY `id` (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = latin1;

DROP TABLE IF EXISTS `inventory_stash`;
CREATE TABLE IF NOT EXISTS `inventory_stash` (
  `id` int(11) NOT NULL AUTO_INCREMENT, 
  `stash` varchar(255) DEFAULT NULL, 
  `items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, 
  PRIMARY KEY (`stash`), 
  KEY `id` (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = latin1;

DROP TABLE IF EXISTS `inventory_trunk`;
CREATE TABLE IF NOT EXISTS `inventory_trunk` (
  `id` int(11) NOT NULL AUTO_INCREMENT, 
  `plate` varchar(255) DEFAULT NULL, 
  `items` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, 
  PRIMARY KEY (`plate`), 
  KEY `id` (`id`)
) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = latin1;

DROP TABLE IF EXISTS `inventory_metadata`;
CREATE TABLE IF NOT EXISTS `inventory_metadata` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `identifier` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
  `data` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
  PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB;

DROP TABLE IF EXISTS `inventory_clothes`;
CREATE TABLE IF NOT EXISTS `inventory_clothes` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `identifier` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
  `items` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
  PRIMARY KEY (`identifier`) USING BTREE,
  INDEX `id` (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 6;

DROP TABLE IF EXISTS `inventory_quests`;
CREATE TABLE `inventory_quests` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
	`owner` VARCHAR(80) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
	`title` VARCHAR(80) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
	`description` MEDIUMTEXT NOT NULL COLLATE 'utf8mb3_general_ci',
	`reward` INT(11) NOT NULL DEFAULT '0',
	`requiredLevel` INT(11) NOT NULL DEFAULT '0',
	`default` TINYINT(1) NOT NULL DEFAULT '0',
	`status` VARCHAR(50) NOT NULL DEFAULT 'active' COLLATE 'utf8mb3_general_ci',
	`progress` INT(11) NOT NULL DEFAULT '0',
	PRIMARY KEY (`id`) USING BTREE,
	UNIQUE INDEX `name_owner` (`name`, `owner`) USING BTREE
)
COLLATE='utf8mb3_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=1
;

ALTER TABLE users ADD COLUMN IF NOT EXISTS unlocked_skills LONGTEXT NULL;
```

--------------------------------

### Database Setup Scripts for Quasar Store (SQL)

Source: https://docs.quasar-store.com/scripts/fishing-job/installation

These SQL scripts are essential for setting up the database required by the Quasar Store project. They include table creations and initial data insertions for job and job grades. It is recommended to import these scripts using a compatible MariaDB/MySQL manager before starting the server. Avoid using non-optimized local servers like XAMPP to prevent connection errors.

```sql
INSERT INTO `jobs` (name, label) VALUES
    ('fisher','Fisher')
;

INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
    ('fisher',0,'novice','Novice',10,'{}','{}')
;

CREATE TABLE IF NOT EXISTS `qs_fisher` (
    `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
    `level` INT(10) UNSIGNED NOT NULL DEFAULT '1',
    `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `total_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `total_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `season_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `season_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `daily_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `daily_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (`identifier`) USING BTREE
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;

CREATE TABLE IF NOT EXISTS `qs_fisher_resets` (
    `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
    `last_daily_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `last_season_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`identifier`) USING BTREE
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;

CREATE TABLE IF NOT EXISTS `qs_fisher_rewards` (
    id INT AUTO_INCREMENT PRIMARY KEY,
    identifier VARCHAR(255) NOT NULL,
    reward_type VARCHAR(50) NOT NULL,
    reward_amount INT NOT NULL
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;

CREATE TABLE IF NOT EXISTS `qs_fisher_leaderboard_winners` (
    id INT AUTO_INCREMENT PRIMARY KEY,
    position INT NOT NULL,
    identifier VARCHAR(255) NOT NULL,
    reward_amount INT NOT NULL,
    reward_type VARCHAR(10) NOT NULL,
    UNIQUE KEY (position, reward_type)
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;
```

```sql
CREATE TABLE IF NOT EXISTS `qs_fisher` (
    `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
    `level` INT(10) UNSIGNED NOT NULL DEFAULT '1',
    `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `total_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `total_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `season_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `season_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `daily_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `daily_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (`identifier`) USING BTREE
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;

CREATE TABLE IF NOT EXISTS `qs_fisher_resets` (
    `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
    `last_daily_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `last_season_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`identifier`) USING BTREE
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;

CREATE TABLE IF NOT EXISTS `qs_fisher_rewards` (
    id INT AUTO_INCREMENT PRIMARY KEY,
    identifier VARCHAR(255) NOT NULL,
    reward_type VARCHAR(50) NOT NULL,
    reward_amount INT NOT NULL
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;

CREATE TABLE IF NOT EXISTS `qs_fisher_leaderboard_winners` (
    id INT AUTO_INCREMENT PRIMARY KEY,
    position INT NOT NULL,
    identifier VARCHAR(255) NOT NULL,
    reward_amount INT NOT NULL,
    reward_type VARCHAR(10) NOT NULL,
    UNIQUE KEY (position, reward_type)
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;
```

--------------------------------

### Database Setup for ESX Framework

Source: https://docs.quasar-store.com/scripts/yacht-creator/installation

This SQL script sets up the necessary database tables and columns for the Quasar Store project when using the ESX framework. It includes creating tables for yachts, Tebex transactions, keys, decorations, and vault codes, as well as altering the 'users' table. Ensure this script is imported before starting the server.

```sql
ALTER TABLE `users` ADD COLUMN IF NOT EXISTS `yacht_inside` VARCHAR(40) NULL DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `qs_yachts` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`yacht_id` INT(11) NOT NULL,
	`owner` VARCHAR(60) NOT NULL COLLATE 'utf8mb4_unicode_ci',
	`owner_name` VARCHAR(100) NOT NULL COLLATE 'utf8mb4_unicode_ci',
	`name` VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
	`modifications` LONGTEXT NOT NULL COLLATE 'utf8mb4_unicode_ci',
	`upgrades` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`locations` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_unicode_ci',
	`created_at` TIMESTAMP NULL DEFAULT current_timestamp(),
	`updated_at` TIMESTAMP NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
	PRIMARY KEY (`id`) USING BTREE,
	UNIQUE INDEX `yacht_id` (`yacht_id`) USING BTREE,
	INDEX `owner` (`owner`) USING BTREE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
;

CREATE TABLE IF NOT EXISTS `qs_yacht_tebex_transactions` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`transaction_id` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_unicode_ci',
	`yacht_id` INT(11) NOT NULL,
	`owner` VARCHAR(60) NOT NULL COLLATE 'utf8mb4_unicode_ci',
	`created_at` TIMESTAMP NULL DEFAULT current_timestamp(),
	PRIMARY KEY (`id`) USING BTREE,
	INDEX `transaction_id` (`transaction_id`) USING BTREE,
	INDEX `yacht_id` (`yacht_id`) USING BTREE,
	INDEX `owner` (`owner`) USING BTREE,
	UNIQUE INDEX `unique_transaction_yacht` (`transaction_id`, `yacht_id`) USING BTREE,
	FOREIGN KEY (`yacht_id`) REFERENCES `qs_yachts`(`yacht_id`) ON DELETE CASCADE
)
COLLATE='utf8mb4_unicode_ci'
ENGINE=InnoDB
;

CREATE TABLE IF NOT EXISTS `qs_yacht_keys` (
    `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `yacht_id` INT(11) NOT NULL,
    `identifier` VARCHAR(60) NOT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    UNIQUE KEY `unique_yacht_key` (`yacht_id`, `identifier`),
    INDEX `yacht_id` (`yacht_id`),
    INDEX `identifier` (`identifier`),
    FOREIGN KEY (`yacht_id`) REFERENCES `qs_yachts`(`yacht_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_yacht_decorations` (
    `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `creator` VARCHAR(60) NOT NULL,
    `yacht_id` INT(11) NOT NULL,
    `modelName` VARCHAR(255) NOT NULL,
    `coords` LONGTEXT NOT NULL,
    `rotation` LONGTEXT NOT NULL,
    `inStash` TINYINT(1) DEFAULT 0,
    `inHouse` TINYINT(1) DEFAULT 0,
    `created` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    `uniq` VARCHAR(255) DEFAULT NULL,
    `lightData` LONGTEXT DEFAULT NULL,
    INDEX `yacht_id` (`yacht_id`),
    INDEX `creator` (`creator`),
    FOREIGN KEY (`yacht_id`) REFERENCES `qs_yachts`(`yacht_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `qs_yachts` ADD COLUMN IF NOT EXISTS `locations` LONGTEXT NULL DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `qs_yacht_vault_codes` (
    `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `yacht_id` INT(11) NOT NULL,
    `code` VARCHAR(10) NOT NULL,
    `uniq` VARCHAR(255) NOT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    UNIQUE KEY `unique_yacht_vault` (`yacht_id`, `uniq`),
    INDEX `yacht_id` (`yacht_id`),
    FOREIGN KEY (`yacht_id`) REFERENCES `qs_yachts`(`yacht_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE IF NOT EXISTS `qs_yacht_vault_codes` (
    `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    `yacht_id` INT(11) NOT NULL,
    `code` VARCHAR(10) NOT NULL,
    `uniq` VARCHAR(255) NOT NULL,
    `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    UNIQUE KEY `unique_yacht_vault` (`yacht_id`, `uniq`),
    INDEX `yacht_id` (`yacht_id`),
    FOREIGN KEY (`yacht_id`) REFERENCES `qs_yachts`(`yacht_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO
    `datastore` (name, label, shared)
VALUES
    ('yacht', 'Yacht', 0);

```

--------------------------------

### Database Setup for QBCORE Framework

Source: https://docs.quasar-store.com/scripts/trucker-job/installation

This SQL script sets up the necessary tables for the truck driver job within the QBCORE framework. It includes creating tables to manage player progress, resets, rewards, and leaderboard winners. Ensure this script is imported before starting your server.

```sql
CREATE TABLE IF NOT EXISTS `qs_truckdriverjob` (
    `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
    `level` INT(10) UNSIGNED NOT NULL DEFAULT '1',
    `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `total_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `total_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `season_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `season_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `daily_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `daily_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (`identifier`) USING BTREE
)
;

CREATE TABLE IF NOT EXISTS `qs_truckdriverjob_resets` (
    `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
    `last_daily_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `last_season_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`identifier`) USING BTREE
)
;

CREATE TABLE IF NOT EXISTS `qs_truckdriverjob_rewards` (
    id INT AUTO_INCREMENT PRIMARY KEY,
    identifier VARCHAR(255) NOT NULL,
    reward_type VARCHAR(50) NOT NULL,
    reward_amount INT NOT NULL
)
;

CREATE TABLE IF NOT EXISTS `qs_truckdriverjob_leaderboard_winners` (
    id INT AUTO_INCREMENT PRIMARY KEY,
    position INT NOT NULL,
    identifier VARCHAR(255) NOT NULL,
    reward_amount INT NOT NULL,
    reward_type VARCHAR(10) NOT NULL,
    UNIQUE KEY (position, reward_type)
)
;


```

--------------------------------

### Database Setup for ESX Framework

Source: https://docs.quasar-store.com/scripts/garbage-job/installation

This SQL script sets up the 'garbage_collector' job and its grades within the ESX framework. It also creates several tables for managing garbage job-related data, including player experience, earnings, and leaderboards. Ensure this script is imported before starting your server.

```sql
INSERT INTO `jobs` (name, label) VALUES
    ('garbage_collector','Garbage Collector')
;

INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
    ('garbage_collector',0,'novice','Novice',10,'{}','{}')
;

CREATE TABLE IF NOT EXISTS `qs_garbagejob` (
    `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
    `level` INT(10) UNSIGNED NOT NULL DEFAULT '1',
    `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `total_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `total_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `season_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `season_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `daily_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `daily_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (`identifier`) USING BTREE
)
;


CREATE TABLE IF NOT EXISTS `qs_garbagejob_resets` (
    `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
    `last_daily_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `last_season_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`identifier`) USING BTREE
)
;

CREATE TABLE IF NOT EXISTS `qs_garbagejob_rewards` (
    id INT AUTO_INCREMENT PRIMARY KEY,
    identifier VARCHAR(255) NOT NULL,
    reward_type VARCHAR(50) NOT NULL,
    reward_amount INT NOT NULL
)
;

CREATE TABLE IF NOT EXISTS `qs_garbagejob_leaderboard_winners` (
    id INT AUTO_INCREMENT PRIMARY KEY,
    position INT NOT NULL,
    identifier VARCHAR(255) NOT NULL,
    reward_amount INT NOT NULL,
    reward_type VARCHAR(10) NOT NULL,
    UNIQUE KEY (position, reward_type)
)
;
```

--------------------------------

### Database Setup for Quasar Spooky Missions (SQL)

Source: https://docs.quasar-store.com/scripts/spooky-missions/installation

This SQL script defines the necessary tables for the Quasar Spooky Missions script, including 'qs-halloween_objects' for placed objects and 'qs-halloween_rewards' for player rewards. It ensures proper database structure for storing mission-related data. Ensure you import this into your MariaDB/MySQL database before starting the server.

```sql
CREATE TABLE `qs-halloween_objects` (
  `id` int(11) NOT NULL,
  `model` varchar(50) NOT NULL,
  `position` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`position`)),
  `placed` date NOT NULL DEFAULT current_timestamp(),
  `player` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

ALTER TABLE `qs-halloween_objects`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `qs-halloween_objects`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

CREATE TABLE `qs-halloween_rewards` (
  `id` int(11) NOT NULL,
  `identifier` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

ALTER TABLE `qs-halloween_rewards`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `qs-halloween_rewards`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;
```

--------------------------------

### Database Setup for QBCore Framework

Source: https://docs.quasar-store.com/scripts/crafting-creator/installation

This SQL script sets up the database for the Quasar Store project using the QBCore framework. It includes creating the 'crafting_queue' and 'crafting_tables' tables, adding a 'crafting_skill' column to the 'players' table, and a stored procedure to migrate existing crafting table structures.

```sql
DROP TABLE IF EXISTS `crafting_queue`;
DROP TABLE IF EXISTS `crafting_tables`;

CREATE TABLE IF NOT EXISTS `crafting_queue` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`owner` VARCHAR(80) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
	`tableId` VARCHAR(30) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`item` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`amount` INT(11) NOT NULL DEFAULT '1',
	`startDate` TIMESTAMP NULL DEFAULT NULL,
	`duration` INT(11) NULL DEFAULT NULL,
	`earn` INT(11) NULL DEFAULT '0',
	PRIMARY KEY (`id`) USING BTREE,
	INDEX `owner_tableId` (`owner`, `tableId`) USING BTREE
)
COLLATE='utf8mb3_general_ci';

CREATE TABLE IF NOT EXISTS `crafting_tables` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`creator` VARCHAR(80) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
	`label` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
	`size` SMALLINT(6) NOT NULL DEFAULT '0',
	`job` VARCHAR(30) NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
	`grades` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`gang` VARCHAR(30) NULL DEFAULT NULL,
	`gangGrades` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`object` VARCHAR(50) NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci',
	`coords` LONGTEXT NOT NULL COLLATE 'utf8mb3_general_ci',
	`recipes` LONGTEXT NOT NULL COLLATE 'utf8mb4_bin',
	`blip` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci',
	`global` TINYINT(1) NULL DEFAULT NULL,
	PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8mb3_general_ci';


ALTER TABLE `players` ADD IF NOT EXISTS `crafting_skill` LONGTEXT NULL DEFAULT NULL;

DELIMITER $$

CREATE PROCEDURE migrate_crafting_tables()
BEGIN
    IF EXISTS (
        SELECT * FROM INFORMATION_SCHEMA.COLUMNS 
        WHERE TABLE_NAME = 'crafting_tables' 
        AND COLUMN_NAME = 'job'
        AND TABLE_SCHEMA = DATABASE()
    ) THEN
        ALTER TABLE `crafting_tables` 
            DROP COLUMN `job`,
            DROP COLUMN `grades`,
            DROP COLUMN `gang`,
            DROP COLUMN `gangGrades`;
        
        ALTER TABLE `crafting_tables`

```

--------------------------------

### Webhook Token Setup for Photo System (Lua)

Source: https://docs.quasar-store.com/scripts/shell-creator/installation

This Lua code snippet demonstrates where to insert the Fivemanage API token within the `qs-shellcreator/server/webhook.lua` file. This token is necessary for the phone's photo system to correctly store images and videos via Fivemanage.

```lua
-- Paste your Fivemanage token here
local token = "YOUR_FIVE MANAGE_TOKEN"

```

--------------------------------

### Database Setup for ESX

Source: https://docs.quasar-store.com/scripts/taxi-job/installation

SQL commands to set up the 'taxi' job and its grades for the ESX framework. It also creates the 'qs_taxijob' table to store player taxi job data, including level and experience. This setup is crucial for the script's functionality within an ESX environment.

```sql
INSERT INTO `jobs` (name, label) VALUES
    ('taxi','Taxi')
;

INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
    ('taxi',0,'novice','Novice',10,'{}','{}')
;

CREATE TABLE IF NOT EXISTS `qs_taxijob` (
    `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
    `level` INT(10) UNSIGNED NOT NULL DEFAULT '1',
    `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (`identifier`) USING BTREE
)
;
```

--------------------------------

### Database Setup for QBCORE Framework

Source: https://docs.quasar-store.com/scripts/garbage-job/installation

This SQL script creates the necessary tables for the garbage job functionality within the QBCORE framework. It includes structures for tracking player experience, earnings, and seasonal/daily resets, as well as reward and leaderboard winner information. This script should be imported before server startup.

```sql
CREATE TABLE IF NOT EXISTS `qs_garbagejob` (
    `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
    `level` INT(10) UNSIGNED NOT NULL DEFAULT '1',
    `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `total_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `total_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `season_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `season_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `daily_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `daily_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (`identifier`) USING BTREE
)
;

CREATE TABLE IF NOT EXISTS `qs_garbagejob_resets` (
    `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
    `last_daily_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `last_season_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`identifier`) USING BTREE
)
;

CREATE TABLE IF NOT EXISTS `qs_garbagejob_rewards` (
    id INT AUTO_INCREMENT PRIMARY KEY,
    identifier VARCHAR(255) NOT NULL,
    reward_type VARCHAR(50) NOT NULL,
    reward_amount INT NOT NULL
)
;

CREATE TABLE IF NOT EXISTS `qs_garbagejob_leaderboard_winners` (
    id INT AUTO_INCREMENT PRIMARY KEY,
    position INT NOT NULL,
    identifier VARCHAR(255) NOT NULL,
    reward_amount INT NOT NULL,
    reward_type VARCHAR(10) NOT NULL,
    UNIQUE KEY (position, reward_type)
)
;
```

--------------------------------

### Database Setup for ESX - Quasar Dog Walker

Source: https://docs.quasar-store.com/scripts/dog-walker-job/installation

SQL commands to set up the 'dog_walker' job and its grades within the ESX framework, along with the creation of the 'qs_dog_walker' table for player progression.

```sql
INSERT INTO `jobs` (name, label) VALUES
    ('dog_walker','Dog Walker')
;

INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
    ('dog_walker',0,'novice','Novice',10,'{}','{}')
;

CREATE TABLE IF NOT EXISTS `qs_dog_walker` (
    `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
    `level` INT(10) UNSIGNED NOT NULL DEFAULT '1',
    `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (`identifier`) USING BTREE
)
```

--------------------------------

### Database Setup for QBCORE Framework

Source: https://docs.quasar-store.com/scripts/miner-job/installation

SQL script to set up the necessary tables for player data, reset times, rewards, and leaderboard winners for the QBCORE framework. This script should be imported before running the server. Note that job and grade insertions are handled separately in QBCORE.

```sql
CREATE TABLE IF NOT EXISTS `qs_miner` (
    `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
    `level` INT(10) UNSIGNED NOT NULL DEFAULT '1',
    `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `total_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `total_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `season_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `season_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `daily_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    `daily_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (`identifier`) USING BTREE
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;

CREATE TABLE IF NOT EXISTS `qs_miner_resets` (
    `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
    `last_daily_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `last_season_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`identifier`) USING BTREE
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;

CREATE TABLE IF NOT EXISTS `qs_miner_rewards` (
    id INT AUTO_INCREMENT PRIMARY KEY,
    identifier VARCHAR(255) NOT NULL,
    reward_type VARCHAR(50) NOT NULL,
    reward_amount INT NOT NULL
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;

CREATE TABLE IF NOT EXISTS `qs_miner_leaderboard_winners` (
    id INT AUTO_INCREMENT PRIMARY KEY,
    position INT NOT NULL,
    identifier VARCHAR(255) NOT NULL,
    reward_amount INT NOT NULL,
    reward_type VARCHAR(10) NOT NULL,
    UNIQUE KEY (position, reward_type)
)
ENGINE=InnoDB
COLLATE='utf8mb4_general_ci'
;

```

--------------------------------

### Database Setup for QBCORE Framework

Source: https://docs.quasar-store.com/scripts/newspaper-job/installation

SQL command to create the 'qs_newspaper' table for player progression data when using the QBCORE framework. This table stores player level and experience for the newspaper job.

```sql
CREATE TABLE IF NOT EXISTS `qs_newspaper` (
    `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
    `level` INT(10) UNSIGNED NOT NULL DEFAULT '1',
    `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (`identifier`) USING BTREE
)
;
```

--------------------------------

### Database Setup for QBCORE Framework

Source: https://docs.quasar-store.com/scripts/banking-and-cards/installation

SQL script to create and populate database tables for the QBCORE framework. This includes definitions for bank_process, bank_cards, bank_history, bank_accounts, and bank_statements tables. Ensure these tables are imported before running the server.

```sql
DROP TABLE IF EXISTS `bank_process`;
CREATE TABLE `bank_process` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `owner` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
    `type` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
    `icon` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
    `text` TEXT NOT NULL COLLATE 'utf8mb4_unicode_ci',
    `created` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci',
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_unicode_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;

DROP TABLE IF EXISTS `bank_cards`;
CREATE TABLE `bank_cards` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `identifier` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
    `cardNumber` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
    `ownerName` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
    `valid` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
    `cardType` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
    `active` INT(11) NOT NULL DEFAULT '0',
    `passCode` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_general_ci',
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 1;

DROP TABLE IF EXISTS `bank_history`;
CREATE TABLE `bank_history` (
    `id` INT(11) NOT NULL AUTO_INCREMENT,
    `identifier` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_general_ci',
    `amount` INT(11) NOT NULL DEFAULT '0',
    `type` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci',
    `date` TIMESTAMP NOT NULL DEFAULT current_timestamp(),
    PRIMARY KEY (`id`) USING BTREE
) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB;

DROP TABLE IF EXISTS `bank_accounts`;
CREATE TABLE IF NOT EXISTS `bank_accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(11) DEFAULT NULL,
  `account_name` varchar(50) DEFAULT NULL,
  `account_balance` int(11) NOT NULL DEFAULT 0,
  `account_type` enum('shared','job','gang') NOT NULL,
  `users` longtext DEFAULT '[]',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `account_name` (`account_name`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

DROP TABLE IF EXISTS `bank_statements`;
CREATE TABLE IF NOT EXISTS `bank_statements` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `citizenid` varchar(11) DEFAULT NULL,
  `account_name` varchar(50) DEFAULT 'checking',
  `amount` int(11) DEFAULT NULL,
  `reason` varchar(50) DEFAULT NULL,
  `statement_type` enum('deposit','withdraw') DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`) USING BTREE,
  KEY `citizenid` (`citizenid`)
)
```

--------------------------------

### Database Setup for QBCORE

Source: https://docs.quasar-store.com/scripts/taxi-job/installation

SQL command to create the 'qs_taxijob' table for the QBCORE framework. This table stores player-specific data for the taxi job, such as their current level and accumulated experience. This is a prerequisite for the script to function correctly with QBCORE.

```sql
CREATE TABLE IF NOT EXISTS `qs_taxijob` (
    `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci',
    `level` INT(10) UNSIGNED NOT NULL DEFAULT '1',
    `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0',
    PRIMARY KEY (`identifier`) USING BTREE
);

```
Tokens:
Raw