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

# Sql File

{% code overflow="wrap" %}

```sql
CREATE TABLE IF NOT EXISTS `tgiann_job` (
  `citizenid` varchar(50) DEFAULT NULL,
  `farmer` int(11) DEFAULT 0,
  `construction` int(11) DEFAULT 0,
  `diver` int(11) DEFAULT 0,
  `truck` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
```

{% endcode %}