> 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-house/sql-file.md).

# Sql File

{% code overflow="wrap" %}

```sql
CREATE TABLE IF NOT EXISTS `tgiann_house` (
  `name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `owner` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `houseKeys` longtext CHARACTER SET utf8 DEFAULT NULL,
  `garage` longtext DEFAULT NULL,
  `interior` longtext DEFAULT NULL
);

CREATE TABLE IF NOT EXISTS `tgiann_player_last_house` (
  `citizenid` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `house` varchar(255) CHARACTER SET utf8 DEFAULT NULL
);
```

{% endcode %}