DROP TABLE IF EXISTS `customer_code`;
CREATE TABLE `customer_code` (
                                 `id` int NOT NULL AUTO_INCREMENT,
                                 `user_id` int NOT NULL,
                                 `insert_user_id` int NOT NULL,
                                 `code` varchar(150) NOT NULL,
                                 `country_id` int NOT NULL,
                                 `zone_id` int NOT NULL,
                                 `district_id` int NOT NULL,
                                 `quarter_id` int NOT NULL,
                                 `schooll_id` int NOT NULL,
                                 `class_id` int NOT NULL,
                                 `lesson_id` int NOT NULL,
                                 `status` tinyint(1) NOT NULL DEFAULT '0',
                                 `insert_date` datetime NOT NULL,
                                 PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;