Sql File

CREATE TABLE IF NOT EXISTS `tgiann_market` (
  `id` int(11) DEFAULT NULL,
  `citizenid` varchar(255) DEFAULT NULL,
  `cash` bigint(20) DEFAULT 0,
  `time` int(11) DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

CREATE TABLE IF NOT EXISTS `tgiann_market_buy` (
  `id` int(11) DEFAULT NULL,
  `item` varchar(255) DEFAULT NULL,
  `price` bigint(20) DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `itemid` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`itemid`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3;

CREATE TABLE IF NOT EXISTS `tgiann_market_item_storage` (
  `id` int(11) DEFAULT NULL,
  `item` varchar(50) DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `metadata` longtext DEFAULT NULL,
  `itemid` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`itemid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

CREATE TABLE IF NOT EXISTS `tgiann_market_sell` (
  `id` int(11) DEFAULT NULL,
  `item` varchar(255) DEFAULT NULL,
  `price` bigint(20) DEFAULT NULL,
  `amount` bigint(20) DEFAULT NULL,
  `metadata` longtext DEFAULT NULL,
  `itemid` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`itemid`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb3;