# Host: 127.0.0.1  (Version 5.7.24-log)
# Date: 2018-11-13 12:01:16
# Generator: MySQL-Front 6.1  (Build 1.26)


#
# Structure for table "passeios_atacama"
#

DROP TABLE IF EXISTS `passeios_atacama`;
CREATE TABLE `passeios_atacama` (
  `id` int(11) NOT NULL,
  `codigo` varchar(11) NOT NULL,
  `descricao` varchar(40) NOT NULL,
  `estilo` varchar(40) NOT NULL,
  `horario` varchar(20) NOT NULL,
  `entrada_clp` varchar(40) NOT NULL,
  `entrada_bob` varchar(40) NOT NULL,
  `tabela_clp` varchar(40) NOT NULL,
  `tabela_usd` varchar(40) NOT NULL,
  `desconto_clp` varchar(40) NOT NULL,
  `desconto_usd` varchar(40) NOT NULL,
  `transpaso_clp` varchar(40) NOT NULL,
  `transpaso_usd` varchar(40) NOT NULL,
  `lucro` varchar(40) NOT NULL,
  `margem` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Data for table "passeios_atacama"
#

INSERT INTO `passeios_atacama` VALUES (77,'codigo','descricao','estilo','horario','entrada_clp','entrada_bob','tabela_clp','tabela_usd','desconto_clp','desconto_usd','transpaso_clp','transpaso_usd','lucro','margem'),(78,'AS 21 ML','Astronômico 21h','Experiência Clássica','21:00 - 23:00','0','22000','21000','13000','#N/A','0.61538461538461542','','','',''),(79,'AS 23 ML','Astronômico 23h','Experiência Clássica','23:00 - 01:00','0','22000','21000','13000','#N/A','0.61538461538461542','','','',''),(80,'GT AM ML','Geyser el Tatio','Experiência Clássica','04:30 - 12:00','10000','25000','24000','14000','#N/A','0.7142857142857143','','','',''),(81,'LC PM ML','Lagoa Cejar','Experiência Clássica','16:00 - 20:00','17000','20000','19000','10000','#N/A','0.9','','','',''),(82,'LE PM ML','Lagoas Escondidas de Baltinache','Experiência Clássica','15:00 - 20:00','5000','22000','21000','12000','#N/A','0.75','','','',''),(83,'PR FD ML','Piedras Rojas e Lagunas Altiplânicas','Experiência Clássica','07:00 - 17:00','5500','45000','43000','25000','#N/A','0.72','','','',''),(84,'LA AM ML','Lagunas Altiplânicas','Experiência Clássica','06:30 - 14:00','5500','32000','31000','20000','#N/A','0.55000000000000004','','','',''),(85,'ST FD ML','Salar de Tara','Experiência Clássica','08:00 - 17:00','0','55000','53000','30000','#N/A','0.76666666666666672','','','',''),(86,'TP AM ML','Termas de Puritama','Experiência Clássica','09:00 - 13:00','15000','20000','19000','8000','#N/A','1.375','','','',''),(87,'TP PM ML','Termas de Puritama','Experiência Clássica','14:00 - 18:00','9000','20000','19000','8000','#N/A','1.375','','','',''),(88,'VA AM ML','Vale do Arco-Íris','Experiência Clássica','08:00 - 13:00','3000','25000','24000','15000','#N/A','0.6','','','',''),(89,'VL PM ML','Vale da Lua','Experiência Clássica','16:00 - 20:00','3000','20000','19000','10000','#N/A','0.9','','','',''),(90,'SB AM ML','Sandboard','Aventura','09:00 - 12:30','3000','22000','22000','17000','#N/A','0.29411764705882354','','','',''),(91,'QC BK AM  ','Quebrada de Chulacao','Aventura','08:00 - 13:00','2500','30000','30000','15000','#N/A','1','','','',''),(92,'QC BK NT  ','Quebrada de Chulacao','Aventura','22:00 - 02:00','0','35000','35000','15000','#N/A','1.3333333333333333','','','',''),(93,'LK FD TV','Vulcão Laskar','Trekking e Vulcões','05:00 - 17:00','0','95000','92000','65000','#N/A','0.41538461538461541','','','',''),(94,'CT FD TV','Cerro Toco','Trekking e Vulcões','08:00 - 16:00','0','70000','68000','45000','#N/A','0.51111111111111107','','','',''),(95,'CA AM VB','Caravana Ancestral Coyo','Vip que Cabe no seu Bolso','08:30 - 10:30','0','35000','35000','31500','#N/A','0.1111111111111111','','','',''),(96,'VN PM VB','Salar do Atacama e Tour do Vinho','Vip que Cabe no seu Bolso','15:00 - 20:00','2500','45000','45000','31500','#N/A','0.42857142857142855','','','',''),(97,'LM PM VB','Vale da Lua e da Morte','Vip que Cabe no seu Bolso','15:00 - 20:30','4000','35000','35000','22500','#N/A','0.55555555555555558','','','',''),(98,'TQ AM VB','Arqueológico Tulor e Pukara de Quitor','Vip que Cabe no seu Bolso','08:00 - 12:00','8000','35000','35000','22500','#N/A','0.55555555555555558','','','',''),(99,'TQ PM VB','Arqueológico Tulor e Pukara de Quitor','Vip que Cabe no seu Bolso','15:00 - 19:00','8000','35000','35000','22500','#N/A','0.55555555555555558','','','',''),(100,'PR FD VB','Piedras Rojas e Lagunas Altiplânicas','Vip que Cabe no seu Bolso','07:00 - 16:00','3000','75000','75000','58500','#N/A','0.28205128205128205','','','',''),(101,'GT AM VB','Geyser el Tatio','Vip que Cabe no seu Bolso','05:30 - 12:30','10000','55000','55000','40500','#N/A','0.35802469135802467','','','',''),(102,'LE AM VB','Lagoas Escondidas de Baltinache','Vip que Cabe no seu Bolso','08:00 - 12:00','5000','40000','40000','27000','#N/A','0.48148148148148145','','','',''),(103,'LE PM VB','Lagoas Escondidas de Baltinache','Vip que Cabe no seu Bolso','15:00 - 19:00','5000','40000','40000','27000','#N/A','0.48148148148148145','','','',''),(104,'TP AM VB','Termas de Puritama','Vip que Cabe no seu Bolso','08:30 - 12:00','15000','40000','40000','31500','#N/A','0.26984126984126983','','','',''),(105,'ST FD VB','Salar de Tara','Vip que Cabe no seu Bolso','07:00 - 14:00','0','75000','75000','58500','#N/A','0.28205128205128205','','','',''),(106,'LC PM VB','Lagoa Cejar','Vip que Cabe no seu Bolso','15:00 - 20:30','17000','40000','40000','27000','#N/A','0.48148148148148145','','','',''),(107,'GP AM VB','Trekking de Guatin e Termas de Puritama','Vip que Cabe no seu Bolso','08:30 - 12:00','15000','60000','60000','45000','#N/A','0.33333333333333331','','','',''),(108,'VA AM VB','Vale do Arco-Íris','Vip que Cabe no seu Bolso','08:00 - 13:00','3000','45000','45000','31500','#N/A','0.42857142857142855','','','',''),(109,'VA PM VB','Vale do Arco-Íris','Vip que Cabe no seu Bolso','15:00 - 19:00','3000','45000','45000','31500','#N/A','0.42857142857142855','','','',''),(110,'AA NT VB','Astronômico Ancestral','Vip que Cabe no seu Bolso','21:30 - 23:00','0','35000','35000','22500','#N/A','0.55555555555555558','','','',''),(111,'CA PM VB','Caravana Ancestral Coyo','Vip que Cabe no seu Bolso','18:30 - 20:30','0','35000','35000','22500','#N/A','0.55555555555555558','','','',''),(112,'SB PM ML','Sandboard','Aventura','15:00 - 19:00','3000','22000','22000','17000','#N/A','0.29411764705882354','','','',''),(113,'QC BK AM x1','Quebrada de Chulacao','Aventura','08:00 - 13:00','2500','40000','30000','15000','#N/A','1','','','','');

#
# Structure for table "tbl_clientes"
#

DROP TABLE IF EXISTS `tbl_clientes`;
CREATE TABLE `tbl_clientes` (
  `id_cliente` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(50) NOT NULL,
  `ultimo_sobrenome` varchar(60) NOT NULL,
  `email` varchar(60) NOT NULL,
  `whatsapp` varchar(13) NOT NULL,
  `como_chegou` varchar(60) NOT NULL,
  `destino` varchar(60) NOT NULL DEFAULT 'Padrao',
  `data_cadastro` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_cliente`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

#
# Data for table "tbl_clientes"
#

INSERT INTO `tbl_clientes` VALUES (1,'Jean','Carlo Ferreira Salim','jc.salim@yahoo.com.br','28999328700','De barco','Santiago','11/11/2018'),(2,'Juca','Chaves','juca@gmail.com','28999629752','De barco','Atacama','03/11/2018'),(3,'Simone Machado','Alves','simone@gmail.com','28999887766','De Avião','Santiago','06/11/2018');

#
# Structure for table "tbl_cupom"
#

DROP TABLE IF EXISTS `tbl_cupom`;
CREATE TABLE `tbl_cupom` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo_cupom` varchar(255) NOT NULL,
  `regras_cupom` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

#
# Data for table "tbl_cupom"
#

INSERT INTO `tbl_cupom` VALUES (1,'Cupom Atacama 1000','Cupom teste da direito a 10% de desconto em todos os passeios clássicos no Atacama, entre os dias 30 de outubro 2018 e 27 de novembro de 2018 válido até 31 de novembro de 2018.');

#
# Structure for table "tbl_detal_passeio"
#

DROP TABLE IF EXISTS `tbl_detal_passeio`;
CREATE TABLE `tbl_detal_passeio` (
  `id_detal` int(11) NOT NULL AUTO_INCREMENT,
  `passeio_id` int(11) NOT NULL,
  `regiao_id` int(11) NOT NULL,
  `destino` varchar(40) CHARACTER SET utf8 NOT NULL,
  `estilo` varchar(40) CHARACTER SET utf8 NOT NULL,
  `horario` varchar(22) CHARACTER SET utf8 NOT NULL,
  `preco_clp` varchar(40) CHARACTER SET utf8 NOT NULL,
  `preco_usd` varchar(40) CHARACTER SET utf8 NOT NULL,
  `transpaso_clp` varchar(255) DEFAULT NULL,
  `transpaso_usd` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_detal`)
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=latin1;

#
# Data for table "tbl_detal_passeio"
#

INSERT INTO `tbl_detal_passeio` VALUES (78,1,1,'Astronômico 21h','Experiência Clássica','21002300','21000','','13000',NULL),(79,2,1,'Astronômico 23h','Experiência Clássica','23000100','21000','','13000',NULL),(80,3,1,'Geyser el Tatio','Experiência Clássica','04301200','24000','','14000',NULL),(81,4,1,'Lagoa Cejar','Experiência Clássica','16002000','19000','','10000',NULL),(82,5,1,'Lagoas Escondidas de Baltinache','Experiência Clássica','15002000','21000','','12000',NULL),(83,6,1,'Piedras Rojas e Lagunas Altiplânicas','Experiência Clássica','07001700','43000','','25000',NULL),(84,7,1,'Lagunas Altiplânicas','Experiência Clássica','06301400','31000','','20000',NULL),(85,8,1,'Salar de Tara','Experiência Clássica','08001700','53000','','30000',NULL),(86,9,1,'Termas de Puritama','Experiência Clássica','09001300','19000','','8000',NULL),(87,10,1,'Termas de Puritama','Experiência Clássica','14001800','19000','','8000',NULL),(88,11,1,'Vale do Arco-Íris','Experiência Clássica','08001300','24000','','15000',NULL),(89,12,1,'Vale da Lua','Experiência Clássica','16002000','19000','','10000',NULL),(90,13,1,'Sandboard','Aventura','09001230','22000','','17000',NULL),(91,14,1,'Quebrada de Chulacao','Aventura','08001300','30000','','15000',NULL),(92,15,1,'Quebrada de Chulacao','Aventura','22000200','35000','','15000',NULL),(93,16,1,'Vulcão Laskar','Trekking e Vulcões','08001600','92000','','65.000',NULL),(94,17,1,'Cerro Toco','Trekking e Vulcões','08001600','68000','','45000',NULL),(95,18,1,'Caravana Ancestral Coyo','Vip que Cabe no seu Bolso','08301030','35000','','31500',NULL),(96,19,1,'Salar do Atacama e Tour do Vinho','Vip que Cabe no seu Bolso','15002000','45000','','31500',NULL),(97,20,1,'Vale da Lua e da Morte','','15002030','35000','','22500',NULL),(98,21,1,'Arqueológico Tulor e Pukara de Quitor','Vip que Cabe no seu Bolso','08001200','35000','','22500',NULL),(99,22,1,'Arqueológico Tulor e Pukara de Quitor','Vip que Cabe no seu Bolso','15001900','35000','','22500',NULL),(100,23,1,'Piedras Rojas e Lagunas Altiplânicas','Vip que Cabe no seu Bolso','07001600','75000','','58500',NULL),(101,24,1,'Geyser el Tatio','Vip que Cabe no seu Bolso','05301230','55000','','40500',NULL),(102,25,1,'Lagoas Escondidas de Baltinache','Vip que Cabe no seu Bolso','08001200','40000','','27000',NULL),(103,25,1,'Lagoas Escondidas de Baltinache','Vip que Cabe no seu Bolso','15001900','40000','','27000',NULL),(104,27,1,'Termas de Puritama','Vip que Cabe no seu Bolso','08301200','40000','','31500',NULL),(105,28,1,'Salar de Tara','Vip que Cabe no seu Bolso','07001400','75000','','58500',NULL),(106,29,1,'Lagoa Cejar','Vip que Cabe no seu Bolso','15002030','40000','','27000',NULL),(107,30,1,'Trekking de Guatin e Termas de Puritama','Vip que Cabe no seu Bolso','08301200','60000','','45000',NULL),(108,31,1,'Vale do Arco-Íris','Vip que Cabe no seu Bolso','08001300','45000','','31500',NULL),(109,32,1,'Vale do Arco-Íris','Vip que Cabe no seu Bolso','15001900','45000','','31500',NULL),(110,33,1,'Astronômico Ancestral','Vip que Cabe no seu Bolso','21302300','35000','','22500',NULL),(111,34,1,'Caravana Ancestral Coyo','Vip que Cabe no seu Bolso','18302030','35000','','22500',NULL),(112,35,1,'Sandboard','Aventura','15001900','22000','','17000',NULL),(113,36,1,'Quebrada de Chulacao','Aventura','08001300','30000','','15000',NULL);

#
# Structure for table "tbl_nivel_vendedor"
#

DROP TABLE IF EXISTS `tbl_nivel_vendedor`;
CREATE TABLE `tbl_nivel_vendedor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nome_nivel` varchar(40) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

#
# Data for table "tbl_nivel_vendedor"
#

INSERT INTO `tbl_nivel_vendedor` VALUES (1,'Nível A'),(2,'Nível B');

#
# Structure for table "tbl_orcamentos"
#

DROP TABLE IF EXISTS `tbl_orcamentos`;
CREATE TABLE `tbl_orcamentos` (
  `id_orca` int(11) NOT NULL AUTO_INCREMENT,
  `cliente_id` int(11) NOT NULL,
  `data` varchar(11) NOT NULL,
  `conteudo` text NOT NULL,
  `orc_destino` varchar(60) NOT NULL,
  `estilo` varchar(60) NOT NULL,
  `horario` varchar(22) NOT NULL,
  `preco_clp` varchar(11) NOT NULL,
  `preco_usd` varchar(11) NOT NULL,
  PRIMARY KEY (`id_orca`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

#
# Data for table "tbl_orcamentos"
#

INSERT INTO `tbl_orcamentos` VALUES (23,1,'23/10/2018','[{\"id_regiao\":1,\"nome_regiao\":\"Atacama\",\"nome\":\"Atacama\",\"data_chegada\":\"09/11/2018\",\"hora_chegada\":\"12:00\",\"data_saida\":\"20/11/2018\",\"hora_saida\":\"12:00\",\"dias_livre\":\"3\",\"passeios\":[{\"id\":1,\"data\":\"09/11/2018\"},{\"id\":2,\"data\":\"10/11/2018\"},{\"id\":1,\"data\":\"11/11/2018\"}]}]','Atacama','Vip que Cabe no seu Bolso','21302300','35000','22500');

#
# Structure for table "tbl_passeios"
#

DROP TABLE IF EXISTS `tbl_passeios`;
CREATE TABLE `tbl_passeios` (
  `id_passeio` int(11) NOT NULL AUTO_INCREMENT,
  `regiao_id` int(11) NOT NULL,
  `nome_passeio` varchar(60) NOT NULL,
  PRIMARY KEY (`id_passeio`)
) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8;

#
# Data for table "tbl_passeios"
#

INSERT INTO `tbl_passeios` VALUES (1,1,'AS 21 ML'),(2,1,'AS 23 ML'),(3,1,'GT AM ML'),(4,1,'LC PM ML'),(5,1,'LE PM ML'),(6,1,'PR FD ML'),(7,1,'LA AM ML'),(8,1,'ST FD ML'),(9,1,'TP AM ML'),(10,1,'TP PM ML'),(11,1,'VA AM ML'),(12,1,'VL PM ML'),(13,1,'SB AM ML'),(14,1,'QC BK AM '),(15,1,'QC BK NT'),(16,1,'LK FD TV'),(17,1,'CT FD TV'),(18,1,'CA AM VB'),(19,1,'VN PM VB'),(20,1,'LM PM VB'),(21,1,'TQ AM VB'),(22,1,'TQ PM VB'),(23,1,'PR FD VB'),(24,1,'GT AM VB'),(25,1,'LE AM VB'),(26,1,'LE PM VB'),(27,1,'TP AM VB'),(28,1,'ST FD VB'),(29,1,'LC PM VB'),(30,1,'GP AM VB'),(31,1,'VA AM VB'),(32,1,'VA PM VB'),(33,1,'AA NT VB'),(34,1,'CA PM VB'),(35,1,'SB PM ML'),(36,1,'QC BK AM x1'),(37,2,'EY FD ML'),(38,2,'YT FD ML'),(39,2,'VV FD ML'),(40,2,'UN AM ML'),(41,2,'UN PM ML'),(42,2,'CO AM ML'),(43,2,'CO PM ML'),(44,2,'SR AM ML'),(45,2,'SR PM ML'),(46,2,'IN FD ML'),(47,2,'CY AM ML'),(48,2,'CY PM ML'),(49,2,'NV FD ML'),(50,3,' UY BA 4D CH'),(51,3,'UY BA 3D CH'),(52,3,'UY QP 4D CH x1'),(53,3,'UY QP 3D CH x1'),(54,3,'UY QP 4D CH'),(55,3,'UY QP 3D CH'),(56,3,'UY BA 3D BO'),(57,3,'UY BA 3DV BO'),(58,3,'UY QP 3D BO'),(59,3,'UY QP 3DV BO'),(60,3,'UY QP 3DV BO x1'),(61,3,'UY SV 3D BO x1'),(62,3,'UY SV 3D BO x2'),(63,3,'UY SV 3D BO x3'),(64,3,'UY SV 3D BO x4'),(65,3,'UY SV 3D BO x5'),(66,3,'UY SV 3D BO x6'),(67,3,'UY SV 3D CH x1'),(68,3,'UY SV 3D CH x2'),(69,3,'UY SV 3D CH x3'),(70,3,'UY SV 3D CH x4'),(71,3,'UY SV 3D CH x5'),(72,3,'UY SV 3D CH x6'),(73,3,'UY SV 3DE BO x1'),(74,3,'UY SV 3DE BO x2'),(75,3,'UY SV 3DE BO x3'),(76,3,'UY SV 3DE BO x4'),(77,3,'UY SV 3DE BO x5'),(78,3,'UY SV 3DE BO x6'),(79,3,'UY SV 3DE CH x1'),(80,3,'UY SV 3DE CH x2'),(81,3,'UY SV 3DE CH x3'),(82,3,'UY SV 3DE CH x4'),(83,3,'UY SV 3DE CH x5'),(84,3,'UY SV 3DE CH x6'),(85,3,'UY SV 4D BO x1'),(86,3,'UY SV 4D BO x2'),(87,3,'UY SV 4D BO x3'),(88,3,'UY SV 4D BO x4'),(89,3,'UY SV 4D BO x5'),(90,3,'UY SV 4D BO x6'),(91,3,'UY SV 4D CH x2'),(92,3,'UY SV 4D CH x3'),(93,3,'UY SV 4D CH x4'),(94,3,'UY SV 4D CH x5'),(95,3,'UY SV 4D CH x6'),(96,3,'UY VP 3D BO x1'),(97,3,'UY VP 3D BO x2'),(98,3,'UY VP 3D BO x3'),(99,3,'UY VP 3D BO x4'),(100,3,'UY VP 3D BO x5'),(101,3,'UY VP 3D BO x6'),(102,3,'UY VP 3D CH x1'),(103,3,'UY VP 3D CH x2'),(104,3,'UY VP 3D CH x3'),(105,3,'UY VP 3D CH x4'),(106,3,'UY VP 3D CH x5'),(107,3,'UY VP 3D CH x6'),(108,3,'UY VP 3DE BO x1'),(109,3,'UY VP 3DE BO x2'),(110,3,'UY VP 3DE BO x3'),(111,3,'UY VP 3DE BO x4'),(112,3,'UY VP 3DE BO x5'),(113,3,'UY VP 3DE BO x6'),(114,3,'UY VP 3DE CH x1'),(115,3,'UY VP 3DE CH x2'),(116,3,'UY VP 3DE CH x3'),(117,3,'UY VP 3DE CH x4'),(118,3,'UY VP 3DE CH x5'),(119,3,'UY VP 3DE CH x6'),(120,3,'UY VP 4D BO x1'),(121,3,'UY VP 4D BO x2'),(122,3,'UY VP 4D BO x3'),(123,3,'UY VP 4D BO x4'),(124,3,'UY VP 4D BO x5'),(125,3,'UY VP 4D BO x6'),(126,3,'UY VP 4D CH x1'),(127,3,'UY VP 4D CH x2'),(128,3,'UY VP 4D CH x3'),(129,3,'UY VP 4D CH x4'),(130,3,'UY VP 4D CH x5'),(131,3,'UY VP 4D CH x6');

#
# Structure for table "tbl_pedidos"
#

DROP TABLE IF EXISTS `tbl_pedidos`;
CREATE TABLE `tbl_pedidos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `id_cliente` varchar(255) DEFAULT NULL,
  `data_pedido` varchar(255) DEFAULT NULL,
  `conteudo` text,
  `id_vendedor` int(11) DEFAULT NULL,
  `qtd_pessoas` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

#
# Data for table "tbl_pedidos"
#

INSERT INTO `tbl_pedidos` VALUES (1,'1','09/11/2018','[{\"id_regiao\":1,\"nome_regiao\":\"Atacama\",\"nome\":\"Atacama\",\"data_chegada\":\"09/11/2018\",\"hora_chegada\":\"12:00\",\"data_saida\":\"20/11/2018\",\"hora_saida\":\"12:00\",\"dias_livre\":\"3\",\"passeios\":[\"Valle de La Luna\",\"Piedras Rojas + Lagunas Altiplanicas\"]}]',1,'11');

#
# Structure for table "tbl_regiao"
#

DROP TABLE IF EXISTS `tbl_regiao`;
CREATE TABLE `tbl_regiao` (
  `id_regiao` int(11) NOT NULL AUTO_INCREMENT,
  `regiao` varchar(40) NOT NULL,
  PRIMARY KEY (`id_regiao`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

#
# Data for table "tbl_regiao"
#

INSERT INTO `tbl_regiao` VALUES (1,'Atacama'),(2,'Santiago');

#
# Structure for table "tbl_vendedores"
#

DROP TABLE IF EXISTS `tbl_vendedores`;
CREATE TABLE `tbl_vendedores` (
  `id_vendedor` int(11) NOT NULL AUTO_INCREMENT,
  `nome_vendedor` varchar(100) NOT NULL,
  `regiao_trabalho` varchar(40) NOT NULL,
  `nivel` varchar(11) NOT NULL,
  `data_cadastro` varchar(255) NOT NULL DEFAULT '0000-00-00',
  `foto_vendedor` varchar(255) NOT NULL,
  `situacao_vend` varchar(11) NOT NULL,
  `obs` text NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `senha` varchar(255) DEFAULT NULL,
  `usuario` varchar(255) DEFAULT NULL,
  `whatsapp` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_vendedor`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

#
# Data for table "tbl_vendedores"
#

INSERT INTO `tbl_vendedores` VALUES (1,'Ana Luisa','2','1','2018-10-26','Ana Luiza.jpeg','ativo','',NULL,NULL,NULL,NULL),(2,'Luka','2','1','2018-10-26','Luka.jpeg','ativo','',NULL,NULL,NULL,NULL),(3,'Luisa Guimarães','1','1','2018-11-07','Luka(1).jpeg','ativo','',NULL,NULL,NULL,NULL),(4,'LUCAS','1','A','12/11/2018','./assets/uploads/1541995198.png','ativo','Nada','oi@oi.com','input-image@a123aDEF','bspsk1234','31997040885'),(5,'LUCAS PAIXAO','1','A','12/11/2018','./assets/uploads/1541995361.png','ativo','Nada','oi@oi.com','input-image@a123aDEF','bspsk1234','31997040885'),(6,'LUCAS PAIXAO','1','A','12/11/2018','./assets/uploads/1541995515.png','ativo','Nada','oi@oi.com','input-image@a123aDEF','bspsk1234','31997040885');