CREATE TABLE `player_crops` ( `id` int(11) NOT NULL, `coords` longtext, `seed` varchar(100) NOT NULL, `water` double NOT NULL, `food` double NOT NULL, `stage` double NOT NULL, `rate` double NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; ALTER TABLE `player_crops` ADD PRIMARY KEY (`id`); ALTER TABLE `player_crops` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;