π§°Installation
Data Base
CREATE TABLE IF NOT EXISTS `yt_reputation_jobs` (
`job_id` int(11) NOT NULL AUTO_INCREMENT,
`job_label` varchar(255) NOT NULL,
`job_name` varchar(255) NOT NULL,
`max_points` int(11) NOT NULL,
`level_thresholds` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`level_thresholds`)),
PRIMARY KEY (`job_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
CREATE TABLE IF NOT EXISTS `yt_user_reputation` (
`user_id` varchar(255) NOT NULL,
`job_id` int(11) NOT NULL,
`points` int(11) DEFAULT 0,
`level` int(11) DEFAULT 0,
PRIMARY KEY (`user_id`, `job_id`),
CONSTRAINT `yt_user_reputation_ibfk_1` FOREIGN KEY (`job_id`) REFERENCES `yt_reputation_jobs` (`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
CREATE TABLE IF NOT EXISTS `yt_user_rewards` (
`user_id` varchar(255) NOT NULL,
`job_id` int(11) NOT NULL,
`reward_level` int(11) NOT NULL,
PRIMARY KEY (`user_id`, `job_id`, `reward_level`),
CONSTRAINT `yt_user_rewards_ibfk_1` FOREIGN KEY (`job_id`) REFERENCES `yt_reputation_jobs` (`job_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
Download
Dependencies
Dependencies
Link
Ensure/Start Order
Last updated