DROP TABLE IF EXISTS `customer_address`;
CREATE TABLE `customer_address` (
                                    `id` int NOT NULL AUTO_INCREMENT,
                                    `customer_id` int NOT NULL,
                                    `address_name` varchar(100) NOT NULL,
                                    `type` varchar(50) NOT NULL,
                                    `firstname` varchar(50) NOT NULL,
                                    `lastname` varchar(50) NOT NULL,
                                    `email` varchar(100) NOT NULL,
                                    `telephone` varchar(50) NOT NULL,
                                    `country_id` int NOT NULL,
                                    `district_id` int NOT NULL,
                                    `zone_id` int NOT NULL,
                                    `quarter_id` int NOT NULL,
                                    `address` text NOT NULL,
                                    `note` int NOT NULL,
                                    `date_added` datetime NOT NULL,
                                    `shop_id` int NOT NULL DEFAULT '1',
                                    PRIMARY KEY (`id`),
                                    KEY `customer_id` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;