ALTER TABLE `players` ADD `farming_level` TEXT NOT NULL DEFAULT 0;
CREATE TABLE IF NOT EXISTS `farming_shop` (
`owner` varchar(50) DEFAULT NULL,
`owned_farms` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `osp_plants` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`coords` text DEFAULT NULL,
`type` varchar(50) NOT NULL,
`process` float NOT NULL DEFAULT 0,
`multiplier` int(11) NOT NULL DEFAULT 0,
`water` float NOT NULL DEFAULT 0,
`fertilizer` float NOT NULL DEFAULT 0,
`owner` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=215 DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `farming_order` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Totalcost` int(11) DEFAULT 0,
`FirstName` varchar(50) DEFAULT NULL,
`LastName` varchar(50) DEFAULT NULL,
`Phonenumber` varchar(50) DEFAULT NULL,
`Alias` varchar(50) DEFAULT NULL,
`apples` int(11) DEFAULT 0,
`oranges` int(11) DEFAULT 0,
`chickens` int(11) DEFAULT 0,
`pigs` int(11) DEFAULT 0,
`mushrooms` int(11) DEFAULT 0,
`cows` int(11) DEFAULT 0,
`wheats` int(11) DEFAULT 0,
`tomatos` int(11) DEFAULT 0,
`cabbages` int(11) DEFAULT 0,
`pumpkins` int(11) DEFAULT 0,
`milks` int(11) DEFAULT 0,
`owner` varchar(50) DEFAULT NULL,
KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='\r\n\r\n';