Install guide
id_card_r = { name = 'id_card', label = 'ID Card', weight = 0, type = 'item', image = 'id_card_r.png', unique = true, useable = true, shouldClose = false, description = 'A card containing all your information to identify yourself' }, driver_license_r = { name = 'driver_license', label = 'Drivers License', weight = 0, type = 'item', image = 'driver_license_r.png', unique = true, useable = true, shouldClose = false, description = 'Permit to show you can drive a vehicle' }, selfie = { name = 'selfie', label = 'Selfie', weight = 0, type = 'item', image = 'selfie.png', unique = true, useable = true, shouldClose = false, description = 'A selfie' },
CREATE TABLE `rrp_licenses` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`dd` VARCHAR(36) NOT NULL COLLATE 'utf8_general_ci',
`owner` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
`type` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
`sId` INT(11) NOT NULL DEFAULT '0',
`pId` INT(11) NOT NULL DEFAULT '0',
`info` LONGTEXT NOT NULL COLLATE 'utf8mb4_bin',
`iss` DATE NULL DEFAULT curdate(),
`exp` DATE NULL DEFAULT (curdate() + interval 5 year),
`status` VARCHAR(50) NULL DEFAULT 'valid' COLLATE 'utf8_general_ci',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `dd` (`dd`) USING BTREE,
INDEX `owner` (`owner`) USING BTREE,
CONSTRAINT `info` CHECK (json_valid(`info`))
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=6;Last updated
