DROP TABLE IF EXISTS `authorization_list`;
CREATE TABLE `authorization_list` (
                                      `id` int NOT NULL AUTO_INCREMENT,
                                      `user_id` int DEFAULT NULL,
                                      `user_group_id` int DEFAULT NULL,
                                      `publisher` tinyint(1) DEFAULT '1',
                                      `customer` tinyint(1) NOT NULL DEFAULT '1',
                                      `shop_id` int DEFAULT NULL,
                                      `name` varchar(150) NOT NULL,
                                      `type` varchar(20) NOT NULL,
                                      `code` varchar(20) NOT NULL,
                                      `status` tinyint(1) NOT NULL DEFAULT '1',
                                      `insert_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
                                      PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;