· 7 years ago · Nov 13, 2018, 02:04 PM
1# Host: 127.0.0.1 (Version 5.7.24-log)
2# Date: 2018-11-13 12:01:16
3# Generator: MySQL-Front 6.1 (Build 1.26)
4
5
6#
7# Structure for table "passeios_atacama"
8#
9
10DROP TABLE IF EXISTS `passeios_atacama`;
11CREATE TABLE `passeios_atacama` (
12 `id` int(11) NOT NULL,
13 `codigo` varchar(11) NOT NULL,
14 `descricao` varchar(40) NOT NULL,
15 `estilo` varchar(40) NOT NULL,
16 `horario` varchar(20) NOT NULL,
17 `entrada_clp` varchar(40) NOT NULL,
18 `entrada_bob` varchar(40) NOT NULL,
19 `tabela_clp` varchar(40) NOT NULL,
20 `tabela_usd` varchar(40) NOT NULL,
21 `desconto_clp` varchar(40) NOT NULL,
22 `desconto_usd` varchar(40) NOT NULL,
23 `transpaso_clp` varchar(40) NOT NULL,
24 `transpaso_usd` varchar(40) NOT NULL,
25 `lucro` varchar(40) NOT NULL,
26 `margem` varchar(40) NOT NULL,
27 PRIMARY KEY (`id`)
28) ENGINE=InnoDB DEFAULT CHARSET=latin1;
29
30#
31# Data for table "passeios_atacama"
32#
33
34INSERT 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','','','','');
35
36#
37# Structure for table "tbl_clientes"
38#
39
40DROP TABLE IF EXISTS `tbl_clientes`;
41CREATE TABLE `tbl_clientes` (
42 `id_cliente` int(11) NOT NULL AUTO_INCREMENT,
43 `nome` varchar(50) NOT NULL,
44 `ultimo_sobrenome` varchar(60) NOT NULL,
45 `email` varchar(60) NOT NULL,
46 `whatsapp` varchar(13) NOT NULL,
47 `como_chegou` varchar(60) NOT NULL,
48 `destino` varchar(60) NOT NULL DEFAULT 'Padrao',
49 `data_cadastro` varchar(255) DEFAULT NULL,
50 PRIMARY KEY (`id_cliente`)
51) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
52
53#
54# Data for table "tbl_clientes"
55#
56
57INSERT 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');
58
59#
60# Structure for table "tbl_cupom"
61#
62
63DROP TABLE IF EXISTS `tbl_cupom`;
64CREATE TABLE `tbl_cupom` (
65 `id` int(11) NOT NULL AUTO_INCREMENT,
66 `codigo_cupom` varchar(255) NOT NULL,
67 `regras_cupom` text NOT NULL,
68 PRIMARY KEY (`id`)
69) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
70
71#
72# Data for table "tbl_cupom"
73#
74
75INSERT 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.');
76
77#
78# Structure for table "tbl_detal_passeio"
79#
80
81DROP TABLE IF EXISTS `tbl_detal_passeio`;
82CREATE TABLE `tbl_detal_passeio` (
83 `id_detal` int(11) NOT NULL AUTO_INCREMENT,
84 `passeio_id` int(11) NOT NULL,
85 `regiao_id` int(11) NOT NULL,
86 `destino` varchar(40) CHARACTER SET utf8 NOT NULL,
87 `estilo` varchar(40) CHARACTER SET utf8 NOT NULL,
88 `horario` varchar(22) CHARACTER SET utf8 NOT NULL,
89 `preco_clp` varchar(40) CHARACTER SET utf8 NOT NULL,
90 `preco_usd` varchar(40) CHARACTER SET utf8 NOT NULL,
91 `transpaso_clp` varchar(255) DEFAULT NULL,
92 `transpaso_usd` varchar(255) DEFAULT NULL,
93 PRIMARY KEY (`id_detal`)
94) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=latin1;
95
96#
97# Data for table "tbl_detal_passeio"
98#
99
100INSERT 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);
101
102#
103# Structure for table "tbl_nivel_vendedor"
104#
105
106DROP TABLE IF EXISTS `tbl_nivel_vendedor`;
107CREATE TABLE `tbl_nivel_vendedor` (
108 `id` int(11) NOT NULL AUTO_INCREMENT,
109 `nome_nivel` varchar(40) NOT NULL,
110 PRIMARY KEY (`id`)
111) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
112
113#
114# Data for table "tbl_nivel_vendedor"
115#
116
117INSERT INTO `tbl_nivel_vendedor` VALUES (1,'NÃvel A'),(2,'NÃvel B');
118
119#
120# Structure for table "tbl_orcamentos"
121#
122
123DROP TABLE IF EXISTS `tbl_orcamentos`;
124CREATE TABLE `tbl_orcamentos` (
125 `id_orca` int(11) NOT NULL AUTO_INCREMENT,
126 `cliente_id` int(11) NOT NULL,
127 `data` varchar(11) NOT NULL,
128 `conteudo` text NOT NULL,
129 `orc_destino` varchar(60) NOT NULL,
130 `estilo` varchar(60) NOT NULL,
131 `horario` varchar(22) NOT NULL,
132 `preco_clp` varchar(11) NOT NULL,
133 `preco_usd` varchar(11) NOT NULL,
134 PRIMARY KEY (`id_orca`)
135) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;
136
137#
138# Data for table "tbl_orcamentos"
139#
140
141INSERT 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');
142
143#
144# Structure for table "tbl_passeios"
145#
146
147DROP TABLE IF EXISTS `tbl_passeios`;
148CREATE TABLE `tbl_passeios` (
149 `id_passeio` int(11) NOT NULL AUTO_INCREMENT,
150 `regiao_id` int(11) NOT NULL,
151 `nome_passeio` varchar(60) NOT NULL,
152 PRIMARY KEY (`id_passeio`)
153) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8;
154
155#
156# Data for table "tbl_passeios"
157#
158
159INSERT 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');
160
161#
162# Structure for table "tbl_pedidos"
163#
164
165DROP TABLE IF EXISTS `tbl_pedidos`;
166CREATE TABLE `tbl_pedidos` (
167 `id` int(11) NOT NULL AUTO_INCREMENT,
168 `id_cliente` varchar(255) DEFAULT NULL,
169 `data_pedido` varchar(255) DEFAULT NULL,
170 `conteudo` text,
171 `id_vendedor` int(11) DEFAULT NULL,
172 `qtd_pessoas` varchar(255) DEFAULT NULL,
173 PRIMARY KEY (`id`)
174) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
175
176#
177# Data for table "tbl_pedidos"
178#
179
180INSERT 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');
181
182#
183# Structure for table "tbl_regiao"
184#
185
186DROP TABLE IF EXISTS `tbl_regiao`;
187CREATE TABLE `tbl_regiao` (
188 `id_regiao` int(11) NOT NULL AUTO_INCREMENT,
189 `regiao` varchar(40) NOT NULL,
190 PRIMARY KEY (`id_regiao`)
191) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
192
193#
194# Data for table "tbl_regiao"
195#
196
197INSERT INTO `tbl_regiao` VALUES (1,'Atacama'),(2,'Santiago');
198
199#
200# Structure for table "tbl_vendedores"
201#
202
203DROP TABLE IF EXISTS `tbl_vendedores`;
204CREATE TABLE `tbl_vendedores` (
205 `id_vendedor` int(11) NOT NULL AUTO_INCREMENT,
206 `nome_vendedor` varchar(100) NOT NULL,
207 `regiao_trabalho` varchar(40) NOT NULL,
208 `nivel` varchar(11) NOT NULL,
209 `data_cadastro` varchar(255) NOT NULL DEFAULT '0000-00-00',
210 `foto_vendedor` varchar(255) NOT NULL,
211 `situacao_vend` varchar(11) NOT NULL,
212 `obs` text NOT NULL,
213 `email` varchar(255) DEFAULT NULL,
214 `senha` varchar(255) DEFAULT NULL,
215 `usuario` varchar(255) DEFAULT NULL,
216 `whatsapp` varchar(255) DEFAULT NULL,
217 PRIMARY KEY (`id_vendedor`)
218) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
219
220#
221# Data for table "tbl_vendedores"
222#
223
224INSERT 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');