DROP TABLE IF EXISTS `user_group`;
CREATE TABLE `user_group` (
                              `id` int NOT NULL AUTO_INCREMENT,
                              `name` text NOT NULL,
                              `date_add` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP,
                              `status` tinyint(1) NOT NULL DEFAULT '1',
                              `shop_id` int NOT NULL DEFAULT '1',
                              `delete_status` tinyint(1) NOT NULL DEFAULT '0',
                              `add_product` varchar(10) NOT NULL DEFAULT '0',
                              `add_sale` varchar(10) NOT NULL DEFAULT '0',
                              `add_bid` varchar(10) NOT NULL DEFAULT '0',
                              `add_message` varchar(10) NOT NULL DEFAULT '0',
                              `product_sale` tinyint(1) NOT NULL DEFAULT '1',
                              `commission` decimal(15,2) NOT NULL DEFAULT '0.00',
                              `group_code` varchar(50) NOT NULL,
                              `is_brands` tinyint(1) NOT NULL DEFAULT '1',
                              PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;