📃SQL

SQL file needed when automatic database creation does not work properly

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;

Last updated