> For the complete documentation index, see [llms.txt](https://docs.kojascripts.eu/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.kojascripts.eu/new/shops/configuration/sql.md).

# SQL

```sql
CREATE TABLE IF NOT EXISTS `koja_shops_sales` (
    `shop_id` VARCHAR(50) NOT NULL,
    `category_id` VARCHAR(50) NOT NULL,
    `sold_count` INT DEFAULT 0,
    PRIMARY KEY (`shop_id`, `category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
```