CREATE TABLE IF NOT EXISTS `torre_pedidos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_usuario` int(11) NOT NULL,
  `sucursal_code` varchar(10) NOT NULL,
  `destinatario` varchar(255) NOT NULL,
  `endereco` varchar(255) NOT NULL,
  `number_client` varchar(50) NOT NULL,
  `zip_code_client` varchar(20) NOT NULL,
  `district_client` varchar(100) NOT NULL,
  `city_client` varchar(100) NOT NULL,
  `state_client` varchar(50) NOT NULL,
  `country_client` varchar(50) DEFAULT 'Brasil',
  `telefone` varchar(20) NOT NULL,
  `email_cliente` varchar(150) DEFAULT NULL,
  `complement_client` varchar(255) DEFAULT '',
  `total_order` int(11) DEFAULT 0,
  `order_details` varchar(255) DEFAULT '',
  `status` varchar(50) DEFAULT 'Pendente',
  `data_importacao` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;