Page cover

πŸ“…SQL

To ensure the quest and XP system works as intended you must run or import the SQL file provided in the folder [SQL] to your database. Failure to do so will result in errors when mining


CREATE TABLE IF NOT EXISTS `mining_rep` (
  `citizenid` VARCHAR(50) NOT NULL,
  `rep` INT(11) DEFAULT 0,
  `ores_mined` INT(11) DEFAULT 0,
  `claimed_quests` TEXT DEFAULT NULL,
  PRIMARY KEY (`citizenid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

Last updated