💾 SQL

Database table structure for BIT-Drivingschool.

bit_driverschool Table

This table stores the progress of players' driving school tests.

CREATE TABLE IF NOT EXISTS `bit_driverschool` (
  `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`)
);

Column Descriptions

| Column | Type | Description | |--------|------|-------------| | id | int(11) | Auto-incrementing primary key | | userIdentifier | varchar(50) | Player identifier (ESX) or citizenid (QBCore) | | licenseType | varchar(10) | License type: A, B, or C | | theorical | int(11) | Theoretical test status (0 = not passed, 1 = passed) | | practice | int(11) | Practical test status (0 = not passed, 1 = passed) |

License Types

• A: Motorcycle license
• B: Car license
• C: Truck license

Usage

The table tracks each player's progress through the theoretical and practical tests for each license type. Players must pass the theoretical test before attempting the practical test.