DROP TABLE IF EXISTS `user_roles`;
CREATE TABLE `user_roles` (
                              `id` int NOT NULL AUTO_INCREMENT,
                              `code` varchar(50) NOT NULL,
                              `name` text NOT NULL,
                              `status` tinyint(1) NOT NULL DEFAULT '1',
                              `sort` int NOT NULL,
                              `shop_id` int NOT NULL DEFAULT '1',
                              PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;