DROP TABLE IF EXISTS `request`;
CREATE TABLE `request` (
                           `id` int NOT NULL AUTO_INCREMENT,
                           `customer_id` int NOT NULL,
                           `firstname` varchar(50) NOT NULL,
                           `lastname` varchar(50) NOT NULL,
                           `telephone` varchar(15) NOT NULL,
                           `email` varchar(50) NOT NULL,
                           `invoice_firstname` varchar(50) NOT NULL,
                           `invoice_lastname` varchar(50) NOT NULL,
                           `invoice_company` varchar(100) NOT NULL,
                           `invoice_tax_office` varchar(50) NOT NULL,
                           `invoice_tax_number` int NOT NULL,
                           `invoice_tc_number` int NOT NULL,
                           `invoice_country_id` int NOT NULL,
                           `invoice_district_id` int NOT NULL,
                           `invoice_zone_id` int NOT NULL,
                           `invoice_quarter_id` int NOT NULL,
                           `invoice_address` text NOT NULL,
                           `note` text NOT NULL,
                           `date_added` datetime NOT NULL,
                           `date_edit` datetime NOT NULL,
                           `readed` tinyint(1) NOT NULL DEFAULT '0',
                           `shop_id` int NOT NULL DEFAULT '1',
                           PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;