SQL Query

Use the following SQL query in your database:

CREATE TABLE IF NOT EXISTS `bit_boatschool` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userIdentifier` varchar(50) NOT NULL,
  `licenseType` varchar(10) NOT NULL,
  `theorical` int(11) NOT NULL DEFAULT 0,
  `practice` int(11) NOT NULL DEFAULT 0,
  KEY `id` (`id`)
);

Table Structure

The bit_boatschool table stores:

• id: Auto-incremented unique identifier
• userIdentifier: Player identifier from ESX/QB
• licenseType: Type of license (boat/yacht)
• theorical: Theoretical test status (0 = not passed, 1 = passed)
• practice: Practical test status (0 = not passed, 1 = passed)