SQL

CREATE TABLE IF NOT EXISTS `bit_business` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '0',
  `price` int(50) NOT NULL DEFAULT 0,
  `income` float NOT NULL DEFAULT 0,
  `stockprice` int(50) NOT NULL DEFAULT 0,
  `defaultstock` int(50) NOT NULL DEFAULT 0,
  `available` int(2) NOT NULL DEFAULT 1,
  `owneridentifier` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '0',
  `ownername` varchar(100) DEFAULT '0',
  `currentstock` int(100) DEFAULT 0,
  `sellprice` int(100) DEFAULT 0,
  `coordx` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '0',
  `coordy` varchar(100) NOT NULL DEFAULT '0',
  `coordz` varchar(100) NOT NULL DEFAULT '0',
  `workers` varchar(200) NOT NULL DEFAULT '{}',
  `totalpaid` int(11) DEFAULT 0,
  `totalprofit` int(11) DEFAULT 0,
  `totalearned` int(11) DEFAULT 0,
  KEY `id` (`id`)
);