CREATE TABLE `minecraft`.`betterfishing` (`id` INT(11) NOT NULL AUTO_INCREMENT , `uuid` VARCHAR(36) NOT NULL , `rank` VARCHAR(16) NOT NULL , `level` INT(5) NOT NULL , `xp_level` INT NOT NULL , `total_fish_caught` INT NOT NULL , `week_fish_caught` INT NOT NULL , `daily_fish_caught` INT NOT NULL , `total_longest_fish` DECIMAL(8,2) NOT NULL , `week_longest_fish` DECIMAL(8,2) NOT NULL , `daily_longest_fish` DECIMAL(8,2) NOT NULL , `total_money_earned` DOUBLE NOT NULL , `updated_at` TIMESTAMP on update CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`id`)) ENGINE = InnoDB;