DROP TABLE IF EXISTS `address`;
CREATE TABLE `address` (
                           `id` int NOT NULL AUTO_INCREMENT,
                           `user_id` int NOT NULL,
                           `firstname` varchar(50) NOT NULL,
                           `lastname` varchar(50) NOT NULL,
                           `telephone` varchar(11) NOT NULL,
                           `company` varchar(155) NOT NULL,
                           `tax_office` varchar(100) NOT NULL,
                           `tc_number` varchar(20) NOT NULL,
                           `definition` varchar(50) NOT NULL,
                           `address_name` varchar(50) NOT NULL,
                           `country_id` int NOT NULL,
                           `country` varchar(100) NOT NULL,
                           `zone_id` int NOT NULL,
                           `zone` varchar(100) NOT NULL,
                           `district_id` int NOT NULL,
                           `district` varchar(100) NOT NULL,
                           `quarter_id` int NOT NULL,
                           `quarter` varchar(100) NOT NULL,
                           `address` varchar(150) NOT NULL,
                           `post_code` int NOT NULL,
                           `default` tinyint(1) NOT NULL,
                           `date_add` datetime NOT NULL,
                           `date_edit` datetime NOT NULL,
                           `shop_id` int NOT NULL DEFAULT '1',
                           `status` tinyint(1) NOT NULL DEFAULT '0',
                           PRIMARY KEY (`id`),
                           KEY `country_id` (`country_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3;