
π SQL
CREATE TABLE IF NOT EXISTS `diving_rep` (
`citizenid` varchar(50) NOT NULL,
`rep` int(11) DEFAULT 0,
`crates_searched` int(11) DEFAULT 0,
`salvagedCrates_opened` int(11) DEFAULT 0,
`claimed_quests` text DEFAULT NULL,
PRIMARY KEY (`citizenid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;Last updated