Installation
Simple explanation on how to install this resource.
1
Download resource from your CFX key
Head to CFX Portal and download the resource.
2
Run the SQL query in your DB Server
You will find the query file in the[SQL]
folder, or if you lost it you can copy it from here:
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `player_skills`;
CREATE TABLE `player_skills` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`identifier` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`job` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
`skills` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL,
`skill_points` int(11) NULL DEFAULT 0,
`level` int(4) NOT NULL DEFAULT 0,
`xp` int(16) NOT NULL DEFAULT 0,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `citizen_id`(`identifier`, `job`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 619 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
3
Last updated