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

## Related pages

- [Changing Language](/new/shops/configuration/changing-language) — Explanation of the locale configuration in the script
- [Target](/new/shops/configuration/target) — Target Configuration
- [Adding a Shop](/new/shops/configuration/adding-a-shop) — How to Add New Shops
- [Server Exports](/new/shops/configuration/server-exports) — Exports implemented in the script
- [Configuration](/new/shops/configuration) — back to the section overview