DROP TABLE IF EXISTS `expense_group`;
CREATE TABLE `expense_group` (
                                 `id` int NOT NULL AUTO_INCREMENT,
                                 `shop_id` int NOT NULL,
                                 `name` varchar(100) NOT NULL,
                                 `color` varchar(50) NOT NULL,
                                 `user_id` int NOT NULL,
                                 UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;