DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
                            `id` int NOT NULL AUTO_INCREMENT,
                            `user_id` int NOT NULL,
                            `group_id` int NOT NULL,
                            `firstname` varchar(150) NOT NULL,
                            `lastname` varchar(150) NOT NULL,
                            `address` text NOT NULL,
                            `telephone` varchar(15) NOT NULL,
                            `email` varchar(150) NOT NULL,
                            `tax_number` varchar(12) NOT NULL,
                            `country_id` int NOT NULL,
                            `zone_id` int NOT NULL,
                            `district_id` int NOT NULL,
                            `quarter_id` int NOT NULL,
                            `status` tinyint(1) NOT NULL DEFAULT '0',
                            `schooll_id` int NOT NULL,
                            `class_id` int NOT NULL,
                            `password` varchar(250) NOT NULL,
                            `insert_date` datetime NOT NULL,
                            PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;