> For the complete documentation index, see [llms.txt](https://tgiann.gitbook.io/tgiann/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://tgiann.gitbook.io/tgiann/scripts/tgiann-market/sql-file.md).

# Sql File

{% code overflow="wrap" %}

```sql
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;
```

{% endcode %}