DROP TABLE IF EXISTS `customer_and_dealers`;
CREATE TABLE `customer_and_dealers` (
                                        `id` int NOT NULL AUTO_INCREMENT,
                                        `username` varchar(155) NOT NULL,
                                        `password` varchar(255) NOT NULL,
                                        `customer_and_dealer_group_id` int NOT NULL,
                                        `roles` text NOT NULL,
                                        `status` tinyint(1) NOT NULL,
                                        `readed` tinyint(1) NOT NULL DEFAULT '0',
                                        `date_added` datetime NOT NULL,
                                        PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;