DROP TABLE IF EXISTS `customer_and_dealer_group`;
CREATE TABLE `customer_and_dealer_group` (
                                             `id` int NOT NULL AUTO_INCREMENT,
                                             `name` text NOT NULL,
                                             `date_add` datetime NOT NULL,
                                             `status` tinyint(1) NOT NULL,
                                             `shop_id` int DEFAULT '1',
                                             PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;