Adjusting Required Licenses

Defaultly, vehicles in vms_vehicleshopV2 have been set to require licenses under the names used in VMS Schools V2. If you do not use our schools or want to remove the license requirement in a very easy way using one line to the database, read the following guide along with ready-made queries.

---

Rename required licenses

// The following SQL code will change the license.
// Change 'NEW_LICENSE_NAME' to your license name that you are using.
// Change 'drive_b' to the license you want to remove, e.g. 'drive_b', 'practical_plane'.

UPDATE vehicles SET `requiredLicense` = 'NEW_LICENSE_NAME' WHERE `requiredLicense` = 'drive_b';

Remove all required licenses

// The following SQL code will remove all required licenses.

UPDATE vehicles SET `requiredLicense` = NULL WHERE `requiredLicense` IS NOT NULL;

Remove for specific license

// The following SQL code will remove the specific license.
// Change 'drive_b' to the license you want to remove, e.g. 'drive_b', 'practical_plane'.

UPDATE vehicles SET `requiredLicense` = NULL WHERE `requiredLicense` = 'drive_b';