base_desafiomelhorenvio.sql

-- --------------------------------------------------------
-- Servidor:                     127.0.0.1
-- Versão do servidor:           10.1.25-MariaDB - mariadb.org binary distribution
-- OS do Servidor:               Win32
-- HeidiSQL Versão:              9.4.0.5125
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


-- Copiando estrutura do banco de dados para desafiomelhorenvio
CREATE DATABASE IF NOT EXISTS `desafiomelhorenvio` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `desafiomelhorenvio`;

-- Copiando estrutura para tabela desafiomelhorenvio.origem_destino
CREATE TABLE IF NOT EXISTS `origem_destino` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `origem` varchar(2) DEFAULT NULL,
  `destino` varchar(2) DEFAULT NULL,
  `indicador` int(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=730 DEFAULT CHARSET=latin1;

-- Copiando dados para a tabela desafiomelhorenvio.origem_destino: ~729 rows (aproximadamente)
/*!40000 ALTER TABLE `origem_destino` DISABLE KEYS */;
INSERT INTO `origem_destino` (`id`, `origem`, `destino`, `indicador`) VALUES
	(1, 'AC', 'AC', 4),
	(2, 'AC', 'AL', 6),
	(3, 'AC', 'AM', 3),
	(4, 'AC', 'AP', 5),
	(5, 'AC', 'BA', 6),
	(6, 'AC', 'CE', 6),
	(7, 'AC', 'DF', 5),
	(8, 'AC', 'ES', 6),
	(9, 'AC', 'GO', 5),
	(10, 'AC', 'MA', 5),
	(11, 'AC', 'MG', 5),
	(12, 'AC', 'MS', 3),
	(13, 'AC', 'MT', 4),
	(14, 'AC', 'PA', 5),
	(15, 'AC', 'PB', 6),
	(16, 'AC', 'PE', 6),
	(17, 'AC', 'PI', 5),
	(18, 'AC', 'PR', 5),
	(19, 'AC', 'RJ', 6),
	(20, 'AC', 'RN', 6),
	(21, 'AC', 'RO', 1),
	(22, 'AC', 'RR', 4),
	(23, 'AC', 'RS', 5),
	(24, 'AC', 'SC', 5),
	(25, 'AC', 'SE', 6),
	(26, 'AC', 'SP', 5),
	(27, 'AC', 'TO', 5),
	(28, 'AL', 'AC', 6),
	(29, 'AL', 'AL', 4),
	(30, 'AL', 'AM', 6),
	(31, 'AL', 'AP', 5),
	(32, 'AL', 'BA', 1),
	(33, 'AL', 'CE', 2),
	(34, 'AL', 'DF', 4),
	(35, 'AL', 'ES', 3),
	(36, 'AL', 'GO', 4),
	(37, 'AL', 'MA', 3),
	(38, 'AL', 'MG', 4),
	(39, 'AL', 'MS', 4),
	(40, 'AL', 'MT', 5),
	(41, 'AL', 'PA', 4),
	(42, 'AL', 'PB', 1),
	(43, 'AL', 'PE', 1),
	(44, 'AL', 'PI', 2),
	(45, 'AL', 'PR', 5),
	(46, 'AL', 'RJ', 4),
	(47, 'AL', 'RN', 1),
	(48, 'AL', 'RO', 6),
	(49, 'AL', 'RR', 6),
	(50, 'AL', 'RS', 5),
	(51, 'AL', 'SC', 5),
	(52, 'AL', 'SE', 1),
	(53, 'AL', 'SP', 4),
	(54, 'AL', 'TO', 5),
	(55, 'AM', 'AC', 3),
	(56, 'AM', 'AL', 6),
	(57, 'AM', 'AM', 4),
	(58, 'AM', 'AP', 4),
	(59, 'AM', 'BA', 5),
	(60, 'AM', 'CE', 5),
	(61, 'AM', 'DF', 4),
	(62, 'AM', 'ES', 5),
	(63, 'AM', 'GO', 5),
	(64, 'AM', 'MA', 4),
	(65, 'AM', 'MG', 5),
	(66, 'AM', 'MS', 4),
	(67, 'AM', 'MT', 4),
	(68, 'AM', 'PA', 3),
	(69, 'AM', 'PB', 5),
	(70, 'AM', 'PE', 5),
	(71, 'AM', 'PI', 4),
	(72, 'AM', 'PR', 5),
	(73, 'AM', 'RJ', 5),
	(74, 'AM', 'RN', 5),
	(75, 'AM', 'RO', 2),
	(76, 'AM', 'RR', 2),
	(77, 'AM', 'RS', 6),
	(78, 'AM', 'SC', 6),
	(79, 'AM', 'SE', 5),
	(80, 'AM', 'SP', 5),
	(81, 'AM', 'TO', 4),
	(82, 'AP', 'AC', 5),
	(83, 'AP', 'AL', 5),
	(84, 'AP', 'AM', 4),
	(85, 'AP', 'AP', 4),
	(86, 'AP', 'BA', 5),
	(87, 'AP', 'CE', 4),
	(88, 'AP', 'DF', 4),
	(89, 'AP', 'ES', 5),
	(90, 'AP', 'GO', 5),
	(91, 'AP', 'MA', 3),
	(92, 'AP', 'MG', 5),
	(93, 'AP', 'MS', 5),
	(94, 'AP', 'MT', 5),
	(95, 'AP', 'PA', 1),
	(96, 'AP', 'PB', 5),
	(97, 'AP', 'PE', 5),
	(98, 'AP', 'PI', 3),
	(99, 'AP', 'PR', 6),
	(100, 'AP', 'RJ', 5),
	(101, 'AP', 'RN', 4),
	(102, 'AP', 'RO', 5),
	(103, 'AP', 'RR', 4),
	(104, 'AP', 'RS', 6),
	(105, 'AP', 'SC', 6),
	(106, 'AP', 'SE', 5),
	(107, 'AP', 'SP', 5),
	(108, 'AP', 'TO', 3),
	(109, 'BA', 'AC', 6),
	(110, 'BA', 'AL', 1),
	(111, 'BA', 'AM', 5),
	(112, 'BA', 'AP', 5),
	(113, 'BA', 'BA', 4),
	(114, 'BA', 'CE', 3),
	(115, 'BA', 'DF', 3),
	(116, 'BA', 'ES', 2),
	(117, 'BA', 'GO', 4),
	(118, 'BA', 'MA', 3),
	(119, 'BA', 'MG', 3),
	(120, 'BA', 'MS', 4),
	(121, 'BA', 'MT', 4),
	(122, 'BA', 'PA', 4),
	(123, 'BA', 'PB', 2),
	(124, 'BA', 'PE', 2),
	(125, 'BA', 'PI', 3),
	(126, 'BA', 'PR', 4),
	(127, 'BA', 'RJ', 3),
	(128, 'BA', 'RN', 2),
	(129, 'BA', 'RO', 5),
	(130, 'BA', 'RR', 6),
	(131, 'BA', 'RS', 5),
	(132, 'BA', 'SC', 4),
	(133, 'BA', 'SE', 1),
	(134, 'BA', 'SP', 4),
	(135, 'BA', 'TO', 4),
	(136, 'CE', 'AC', 6),
	(137, 'CE', 'AL', 2),
	(138, 'CE', 'AM', 5),
	(139, 'CE', 'AP', 4),
	(140, 'CE', 'BA', 3),
	(141, 'CE', 'CE', 4),
	(142, 'CE', 'DF', 4),
	(143, 'CE', 'ES', 4),
	(144, 'CE', 'GO', 4),
	(145, 'CE', 'MA', 1),
	(146, 'CE', 'MG', 4),
	(147, 'CE', 'MS', 5),
	(148, 'CE', 'MT', 5),
	(149, 'CE', 'PA', 3),
	(150, 'CE', 'PB', 1),
	(151, 'CE', 'PE', 1),
	(152, 'CE', 'PI', 1),
	(153, 'CE', 'PR', 5),
	(154, 'CE', 'RJ', 5),
	(155, 'CE', 'RN', 1),
	(156, 'CE', 'RO', 5),
	(157, 'CE', 'RR', 5),
	(158, 'CE', 'RS', 6),
	(159, 'CE', 'SC', 6),
	(160, 'CE', 'SE', 2),
	(161, 'CE', 'SP', 5),
	(162, 'CE', 'TO', 5),
	(163, 'DF', 'AC', 5),
	(164, 'DF', 'AL', 4),
	(165, 'DF', 'AM', 4),
	(166, 'DF', 'AP', 4),
	(167, 'DF', 'BA', 3),
	(168, 'DF', 'CE', 4),
	(169, 'DF', 'DF', 3),
	(170, 'DF', 'ES', 3),
	(171, 'DF', 'GO', 1),
	(172, 'DF', 'MA', 4),
	(173, 'DF', 'MG', 1),
	(174, 'DF', 'MS', 2),
	(175, 'DF', 'MT', 2),
	(176, 'DF', 'PA', 4),
	(177, 'DF', 'PB', 4),
	(178, 'DF', 'PE', 4),
	(179, 'DF', 'PI', 3),
	(180, 'DF', 'PR', 3),
	(181, 'DF', 'RJ', 2),
	(182, 'DF', 'RN', 4),
	(183, 'DF', 'RO', 4),
	(184, 'DF', 'RR', 5),
	(185, 'DF', 'RS', 4),
	(186, 'DF', 'SC', 3),
	(187, 'DF', 'SE', 3),
	(188, 'DF', 'SP', 2),
	(189, 'DF', 'TO', 1),
	(190, 'ES', 'AC', 6),
	(191, 'ES', 'AL', 3),
	(192, 'ES', 'AM', 5),
	(193, 'ES', 'AP', 5),
	(194, 'ES', 'BA', 2),
	(195, 'ES', 'CE', 4),
	(196, 'ES', 'DF', 3),
	(197, 'ES', 'ES', 4),
	(198, 'ES', 'GO', 4),
	(199, 'ES', 'MA', 4),
	(200, 'ES', 'MG', 1),
	(201, 'ES', 'MS', 3),
	(202, 'ES', 'MT', 4),
	(203, 'ES', 'PA', 5),
	(204, 'ES', 'PB', 4),
	(205, 'ES', 'PE', 4),
	(206, 'ES', 'PI', 4),
	(207, 'ES', 'PR', 3),
	(208, 'ES', 'RJ', 1),
	(209, 'ES', 'RN', 4),
	(210, 'ES', 'RO', 5),
	(211, 'ES', 'RR', 6),
	(212, 'ES', 'RS', 4),
	(213, 'ES', 'SC', 3),
	(214, 'ES', 'SE', 3),
	(215, 'ES', 'SP', 2),
	(216, 'ES', 'TO', 4),
	(217, 'GO', 'AC', 5),
	(218, 'GO', 'AL', 4),
	(219, 'GO', 'AM', 5),
	(220, 'GO', 'AP', 5),
	(221, 'GO', 'BA', 4),
	(222, 'GO', 'CE', 4),
	(223, 'GO', 'DF', 1),
	(224, 'GO', 'ES', 4),
	(225, 'GO', 'GO', 4),
	(226, 'GO', 'MA', 4),
	(227, 'GO', 'MG', 2),
	(228, 'GO', 'MS', 2),
	(229, 'GO', 'MT', 2),
	(230, 'GO', 'PA', 4),
	(231, 'GO', 'PB', 4),
	(232, 'GO', 'PE', 4),
	(233, 'GO', 'PI', 4),
	(234, 'GO', 'PR', 4),
	(235, 'GO', 'RJ', 3),
	(236, 'GO', 'RN', 5),
	(237, 'GO', 'RO', 4),
	(238, 'GO', 'RR', 5),
	(239, 'GO', 'RS', 4),
	(240, 'GO', 'SC', 4),
	(241, 'GO', 'SE', 4),
	(242, 'GO', 'SP', 3),
	(243, 'GO', 'TO', 1),
	(244, 'MA', 'AC', 5),
	(245, 'MA', 'AL', 3),
	(246, 'MA', 'AM', 4),
	(247, 'MA', 'AP', 3),
	(248, 'MA', 'BA', 3),
	(249, 'MA', 'CE', 1),
	(250, 'MA', 'DF', 4),
	(251, 'MA', 'ES', 4),
	(252, 'MA', 'GO', 4),
	(253, 'MA', 'MA', 4),
	(254, 'MA', 'MG', 4),
	(255, 'MA', 'MS', 5),
	(256, 'MA', 'MT', 4),
	(257, 'MA', 'PA', 1),
	(258, 'MA', 'PB', 3),
	(259, 'MA', 'PE', 3),
	(260, 'MA', 'PI', 1),
	(261, 'MA', 'PR', 5),
	(262, 'MA', 'RJ', 5),
	(263, 'MA', 'RN', 3),
	(264, 'MA', 'RO', 5),
	(265, 'MA', 'RR', 4),
	(266, 'MA', 'RS', 6),
	(267, 'MA', 'SC', 5),
	(268, 'MA', 'SE', 3),
	(269, 'MA', 'SP', 5),
	(270, 'MA', 'TO', 5),
	(271, 'MG', 'AC', 6),
	(272, 'MG', 'AL', 4),
	(273, 'MG', 'AM', 5),
	(274, 'MG', 'AP', 6),
	(275, 'MG', 'BA', 2),
	(276, 'MG', 'CE', 4),
	(277, 'MG', 'DF', 1),
	(278, 'MG', 'ES', 2),
	(279, 'MG', 'GO', 2),
	(280, 'MG', 'MA', 4),
	(281, 'MG', 'MG', 3),
	(282, 'MG', 'MS', 2),
	(283, 'MG', 'MT', 3),
	(284, 'MG', 'PA', 4),
	(285, 'MG', 'PB', 4),
	(286, 'MG', 'PE', 4),
	(287, 'MG', 'PI', 5),
	(288, 'MG', 'PR', 2),
	(289, 'MG', 'RJ', 1),
	(290, 'MG', 'RN', 5),
	(291, 'MG', 'RO', 5),
	(292, 'MG', 'RR', 6),
	(293, 'MG', 'RS', 3),
	(294, 'MG', 'SC', 2),
	(295, 'MG', 'SE', 4),
	(296, 'MG', 'SP', 1),
	(297, 'MG', 'TO', 4),
	(298, 'MS', 'AC', 3),
	(299, 'MS', 'AL', 4),
	(300, 'MS', 'AM', 4),
	(301, 'MS', 'AP', 5),
	(302, 'MS', 'BA', 4),
	(303, 'MS', 'CE', 5),
	(304, 'MS', 'DF', 2),
	(305, 'MS', 'ES', 3),
	(306, 'MS', 'GO', 2),
	(307, 'MS', 'MA', 5),
	(308, 'MS', 'MG', 2),
	(309, 'MS', 'MS', 4),
	(310, 'MS', 'MT', 1),
	(311, 'MS', 'PA', 5),
	(312, 'MS', 'PB', 5),
	(313, 'MS', 'PE', 5),
	(314, 'MS', 'PI', 5),
	(315, 'MS', 'PR', 2),
	(316, 'MS', 'RJ', 2),
	(317, 'MS', 'RN', 5),
	(318, 'MS', 'RO', 3),
	(319, 'MS', 'RR', 5),
	(320, 'MS', 'RS', 3),
	(321, 'MS', 'SC', 2),
	(322, 'MS', 'SE', 4),
	(323, 'MS', 'SP', 2),
	(324, 'MS', 'TO', 3),
	(325, 'MT', 'AC', 4),
	(326, 'MT', 'AL', 5),
	(327, 'MT', 'AM', 4),
	(328, 'MT', 'AP', 5),
	(329, 'MT', 'BA', 4),
	(330, 'MT', 'CE', 5),
	(331, 'MT', 'DF', 2),
	(332, 'MT', 'ES', 4),
	(333, 'MT', 'GO', 2),
	(334, 'MT', 'MA', 4),
	(335, 'MT', 'MG', 4),
	(336, 'MT', 'MS', 1),
	(337, 'MT', 'MT', 4),
	(338, 'MT', 'PA', 4),
	(339, 'MT', 'PB', 5),
	(340, 'MT', 'PE', 5),
	(341, 'MT', 'PI', 4),
	(342, 'MT', 'PR', 3),
	(343, 'MT', 'RJ', 4),
	(344, 'MT', 'RN', 5),
	(345, 'MT', 'RO', 3),
	(346, 'MT', 'RR', 5),
	(347, 'MT', 'RS', 4),
	(348, 'MT', 'SC', 4),
	(349, 'MT', 'SE', 5),
	(350, 'MT', 'SP', 4),
	(351, 'MT', 'TO', 3),
	(352, 'PA', 'AC', 5),
	(353, 'PA', 'AL', 4),
	(354, 'PA', 'AM', 3),
	(355, 'PA', 'AP', 1),
	(356, 'PA', 'BA', 4),
	(357, 'PA', 'CE', 3),
	(358, 'PA', 'DF', 4),
	(359, 'PA', 'ES', 5),
	(360, 'PA', 'GO', 4),
	(361, 'PA', 'MA', 1),
	(362, 'PA', 'MG', 5),
	(363, 'PA', 'MS', 5),
	(364, 'PA', 'MT', 4),
	(365, 'PA', 'PA', 4),
	(366, 'PA', 'PB', 4),
	(367, 'PA', 'PE', 4),
	(368, 'PA', 'PI', 2),
	(369, 'PA', 'PR', 5),
	(370, 'PA', 'RJ', 5),
	(371, 'PA', 'RN', 4),
	(372, 'PA', 'RO', 4),
	(373, 'PA', 'RR', 4),
	(374, 'PA', 'RS', 6),
	(375, 'PA', 'SC', 6),
	(376, 'PA', 'SE', 4),
	(377, 'PA', 'SP', 5),
	(378, 'PA', 'TO', 2),
	(379, 'PB', 'AC', 6),
	(380, 'PB', 'AL', 1),
	(381, 'PB', 'AM', 5),
	(382, 'PB', 'AP', 5),
	(383, 'PB', 'BA', 2),
	(384, 'PB', 'CE', 1),
	(385, 'PB', 'DF', 4),
	(386, 'PB', 'ES', 4),
	(387, 'PB', 'GO', 4),
	(388, 'PB', 'MA', 3),
	(389, 'PB', 'MG', 4),
	(390, 'PB', 'MS', 5),
	(391, 'PB', 'MT', 5),
	(392, 'PB', 'PA', 4),
	(393, 'PB', 'PB', 4),
	(394, 'PB', 'PE', 1),
	(395, 'PB', 'PI', 2),
	(396, 'PB', 'PR', 5),
	(397, 'PB', 'RJ', 4),
	(398, 'PB', 'RN', 1),
	(399, 'PB', 'RO', 6),
	(400, 'PB', 'RR', 6),
	(401, 'PB', 'RS', 6),
	(402, 'PB', 'SC', 5),
	(403, 'PB', 'SE', 1),
	(404, 'PB', 'SP', 5),
	(405, 'PB', 'TO', 5),
	(406, 'PE', 'AC', 6),
	(407, 'PE', 'AL', 1),
	(408, 'PE', 'AM', 5),
	(409, 'PE', 'AP', 5),
	(410, 'PE', 'BA', 2),
	(411, 'PE', 'CE', 1),
	(412, 'PE', 'DF', 4),
	(413, 'PE', 'ES', 4),
	(414, 'PE', 'GO', 4),
	(415, 'PE', 'MA', 3),
	(416, 'PE', 'MG', 4),
	(417, 'PE', 'MS', 5),
	(418, 'PE', 'MT', 5),
	(419, 'PE', 'PA', 4),
	(420, 'PE', 'PB', 1),
	(421, 'PE', 'PE', 4),
	(422, 'PE', 'PI', 2),
	(423, 'PE', 'PR', 5),
	(424, 'PE', 'RJ', 4),
	(425, 'PE', 'RN', 1),
	(426, 'PE', 'RO', 6),
	(427, 'PE', 'RR', 6),
	(428, 'PE', 'RS', 6),
	(429, 'PE', 'SC', 5),
	(430, 'PE', 'SE', 1),
	(431, 'PE', 'SP', 5),
	(432, 'PE', 'TO', 4),
	(433, 'PI', 'AC', 5),
	(434, 'PI', 'AL', 2),
	(435, 'PI', 'AM', 4),
	(436, 'PI', 'AP', 3),
	(437, 'PI', 'BA', 3),
	(438, 'PI', 'CE', 1),
	(439, 'PI', 'DF', 3),
	(440, 'PI', 'ES', 4),
	(441, 'PI', 'GO', 4),
	(442, 'PI', 'MA', 1),
	(443, 'PI', 'MG', 4),
	(444, 'PI', 'MS', 5),
	(445, 'PI', 'MT', 4),
	(446, 'PI', 'PA', 2),
	(447, 'PI', 'PB', 2),
	(448, 'PI', 'PE', 2),
	(449, 'PI', 'PI', 4),
	(450, 'PI', 'PR', 5),
	(451, 'PI', 'RJ', 4),
	(452, 'PI', 'RN', 2),
	(453, 'PI', 'RO', 5),
	(454, 'PI', 'RR', 5),
	(455, 'PI', 'RS', 6),
	(456, 'PI', 'SC', 5),
	(457, 'PI', 'SE', 4),
	(458, 'PI', 'SP', 5),
	(459, 'PI', 'TO', 5),
	(460, 'PR', 'AC', 5),
	(461, 'PR', 'AL', 5),
	(462, 'PR', 'AM', 5),
	(463, 'PR', 'AP', 6),
	(464, 'PR', 'BA', 4),
	(465, 'PR', 'CE', 5),
	(466, 'PR', 'DF', 3),
	(467, 'PR', 'ES', 3),
	(468, 'PR', 'GO', 4),
	(469, 'PR', 'MA', 5),
	(470, 'PR', 'MG', 2),
	(471, 'PR', 'MS', 2),
	(472, 'PR', 'MT', 3),
	(473, 'PR', 'PA', 5),
	(474, 'PR', 'PB', 5),
	(475, 'PR', 'PE', 5),
	(476, 'PR', 'PI', 5),
	(477, 'PR', 'PR', 3),
	(478, 'PR', 'RJ', 2),
	(479, 'PR', 'RN', 5),
	(480, 'PR', 'RO', 5),
	(481, 'PR', 'RR', 6),
	(482, 'PR', 'RS', 1),
	(483, 'PR', 'SC', 1),
	(484, 'PR', 'SE', 5),
	(485, 'PR', 'SP', 1),
	(486, 'PR', 'TO', 4),
	(487, 'RJ', 'AC', 6),
	(488, 'RJ', 'AL', 4),
	(489, 'RJ', 'AM', 5),
	(490, 'RJ', 'AP', 5),
	(491, 'RJ', 'BA', 3),
	(492, 'RJ', 'CE', 4),
	(493, 'RJ', 'DF', 1),
	(494, 'RJ', 'ES', 1),
	(495, 'RJ', 'GO', 2),
	(496, 'RJ', 'MA', 4),
	(497, 'RJ', 'MG', 1),
	(498, 'RJ', 'MS', 2),
	(499, 'RJ', 'MT', 3),
	(500, 'RJ', 'PA', 5),
	(501, 'RJ', 'PB', 4),
	(502, 'RJ', 'PE', 4),
	(503, 'RJ', 'PI', 4),
	(504, 'RJ', 'PR', 1),
	(505, 'RJ', 'RJ', 2),
	(506, 'RJ', 'RN', 4),
	(507, 'RJ', 'RO', 4),
	(508, 'RJ', 'RR', 6),
	(509, 'RJ', 'RS', 2),
	(510, 'RJ', 'SC', 2),
	(511, 'RJ', 'SE', 3),
	(512, 'RJ', 'SP', 1),
	(513, 'RJ', 'TO', 3),
	(514, 'RN', 'AC', 6),
	(515, 'RN', 'AL', 1),
	(516, 'RN', 'AM', 5),
	(517, 'RN', 'AP', 4),
	(518, 'RN', 'BA', 2),
	(519, 'RN', 'CE', 1),
	(520, 'RN', 'DF', 4),
	(521, 'RN', 'ES', 4),
	(522, 'RN', 'GO', 5),
	(523, 'RN', 'MA', 3),
	(524, 'RN', 'MG', 4),
	(525, 'RN', 'MS', 5),
	(526, 'RN', 'MT', 5),
	(527, 'RN', 'PA', 4),
	(528, 'RN', 'PB', 1),
	(529, 'RN', 'PE', 1),
	(530, 'RN', 'PI', 2),
	(531, 'RN', 'PR', 5),
	(532, 'RN', 'RJ', 5),
	(533, 'RN', 'RN', 4),
	(534, 'RN', 'RO', 6),
	(535, 'RN', 'RR', 6),
	(536, 'RN', 'RS', 6),
	(537, 'RN', 'SC', 5),
	(538, 'RN', 'SE', 2),
	(539, 'RN', 'SP', 5),
	(540, 'RN', 'TO', 5),
	(541, 'RO', 'AC', 1),
	(542, 'RO', 'AL', 6),
	(543, 'RO', 'AM', 2),
	(544, 'RO', 'AP', 5),
	(545, 'RO', 'BA', 5),
	(546, 'RO', 'CE', 5),
	(547, 'RO', 'DF', 4),
	(548, 'RO', 'ES', 5),
	(549, 'RO', 'GO', 4),
	(550, 'RO', 'MA', 5),
	(551, 'RO', 'MG', 5),
	(552, 'RO', 'MS', 3),
	(553, 'RO', 'MT', 3),
	(554, 'RO', 'PA', 4),
	(555, 'RO', 'PB', 6),
	(556, 'RO', 'PE', 6),
	(557, 'RO', 'PI', 5),
	(558, 'RO', 'PR', 5),
	(559, 'RO', 'RJ', 5),
	(560, 'RO', 'RN', 6),
	(561, 'RO', 'RO', 4),
	(562, 'RO', 'RR', 3),
	(563, 'RO', 'RS', 5),
	(564, 'RO', 'SC', 5),
	(565, 'RO', 'SE', 6),
	(566, 'RO', 'SP', 5),
	(567, 'RO', 'TO', 5),
	(568, 'RR', 'AC', 4),
	(569, 'RR', 'AL', 6),
	(570, 'RR', 'AM', 2),
	(571, 'RR', 'AP', 4),
	(572, 'RR', 'BA', 6),
	(573, 'RR', 'CE', 5),
	(574, 'RR', 'DF', 5),
	(575, 'RR', 'ES', 6),
	(576, 'RR', 'GO', 5),
	(577, 'RR', 'MA', 4),
	(578, 'RR', 'MG', 6),
	(579, 'RR', 'MS', 5),
	(580, 'RR', 'MT', 5),
	(581, 'RR', 'PA', 4),
	(582, 'RR', 'PB', 6),
	(583, 'RR', 'PE', 6),
	(584, 'RR', 'PI', 5),
	(585, 'RR', 'PR', 6),
	(586, 'RR', 'RJ', 6),
	(587, 'RR', 'RN', 6),
	(588, 'RR', 'RO', 3),
	(589, 'RR', 'RR', 4),
	(590, 'RR', 'RS', 6),
	(591, 'RR', 'SC', 6),
	(592, 'RR', 'SE', 6),
	(593, 'RR', 'SP', 6),
	(594, 'RR', 'TO', 4),
	(595, 'RS', 'AC', 5),
	(596, 'RS', 'AL', 5),
	(597, 'RS', 'AM', 6),
	(598, 'RS', 'AP', 6),
	(599, 'RS', 'BA', 5),
	(600, 'RS', 'CE', 6),
	(601, 'RS', 'DF', 4),
	(602, 'RS', 'ES', 4),
	(603, 'RS', 'GO', 4),
	(604, 'RS', 'MA', 6),
	(605, 'RS', 'MG', 4),
	(606, 'RS', 'MS', 3),
	(607, 'RS', 'MT', 4),
	(608, 'RS', 'PA', 6),
	(609, 'RS', 'PB', 6),
	(610, 'RS', 'PE', 6),
	(611, 'RS', 'PI', 6),
	(612, 'RS', 'PR', 1),
	(613, 'RS', 'RJ', 3),
	(614, 'RS', 'RN', 6),
	(615, 'RS', 'RO', 5),
	(616, 'RS', 'RR', 6),
	(617, 'RS', 'RS', 3),
	(618, 'RS', 'SC', 1),
	(619, 'RS', 'SE', 5),
	(620, 'RS', 'SP', 2),
	(621, 'RS', 'TO', 5),
	(622, 'SC', 'AC', 5),
	(623, 'SC', 'AL', 5),
	(624, 'SC', 'AM', 6),
	(625, 'SC', 'AP', 6),
	(626, 'SC', 'BA', 4),
	(627, 'SC', 'CE', 6),
	(628, 'SC', 'DF', 3),
	(629, 'SC', 'ES', 3),
	(630, 'SC', 'GO', 4),
	(631, 'SC', 'MA', 5),
	(632, 'SC', 'MG', 3),
	(633, 'SC', 'MS', 2),
	(634, 'SC', 'MT', 4),
	(635, 'SC', 'PA', 6),
	(636, 'SC', 'PB', 5),
	(637, 'SC', 'PE', 5),
	(638, 'SC', 'PI', 5),
	(639, 'SC', 'PR', 1),
	(640, 'SC', 'RJ', 2),
	(641, 'SC', 'RN', 5),
	(642, 'SC', 'RO', 5),
	(643, 'SC', 'RR', 6),
	(644, 'SC', 'RS', 1),
	(645, 'SC', 'SC', 4),
	(646, 'SC', 'SE', 5),
	(647, 'SC', 'SP', 1),
	(648, 'SC', 'TO', 4),
	(649, 'SE', 'AC', 6),
	(650, 'SE', 'AL', 1),
	(651, 'SE', 'AM', 5),
	(652, 'SE', 'AP', 5),
	(653, 'SE', 'BA', 1),
	(654, 'SE', 'CE', 2),
	(655, 'SE', 'DF', 3),
	(656, 'SE', 'ES', 3),
	(657, 'SE', 'GO', 4),
	(658, 'SE', 'MA', 3),
	(659, 'SE', 'MG', 3),
	(660, 'SE', 'MS', 4),
	(661, 'SE', 'MT', 5),
	(662, 'SE', 'PA', 4),
	(663, 'SE', 'PB', 1),
	(664, 'SE', 'PE', 1),
	(665, 'SE', 'PI', 4),
	(666, 'SE', 'PR', 5),
	(667, 'SE', 'RJ', 4),
	(668, 'SE', 'RN', 2),
	(669, 'SE', 'RO', 6),
	(670, 'SE', 'RR', 6),
	(671, 'SE', 'RS', 5),
	(672, 'SE', 'SC', 5),
	(673, 'SE', 'SE', 4),
	(674, 'SE', 'SP', 4),
	(675, 'SE', 'TO', 5),
	(676, 'SP', 'AC', 5),
	(677, 'SP', 'AL', 4),
	(678, 'SP', 'AM', 4),
	(679, 'SP', 'AP', 4),
	(680, 'SP', 'BA', 2),
	(681, 'SP', 'CE', 3),
	(682, 'SP', 'DF', 1),
	(683, 'SP', 'ES', 1),
	(684, 'SP', 'GO', 1),
	(685, 'SP', 'MA', 4),
	(686, 'SP', 'MG', 1),
	(687, 'SP', 'MS', 1),
	(688, 'SP', 'MT', 2),
	(689, 'SP', 'PA', 3),
	(690, 'SP', 'PB', 4),
	(691, 'SP', 'PE', 3),
	(692, 'SP', 'PI', 4),
	(693, 'SP', 'PR', 1),
	(694, 'SP', 'RJ', 1),
	(695, 'SP', 'RN', 4),
	(696, 'SP', 'RO', 4),
	(697, 'SP', 'RR', 5),
	(698, 'SP', 'RS', 1),
	(699, 'SP', 'SC', 1),
	(700, 'SP', 'SE', 4),
	(701, 'SP', 'SP', 1),
	(702, 'SP', 'TO', 3),
	(703, 'TO', 'AC', 5),
	(704, 'TO', 'AL', 5),
	(705, 'TO', 'AM', 4),
	(706, 'TO', 'AP', 3),
	(707, 'TO', 'BA', 4),
	(708, 'TO', 'CE', 5),
	(709, 'TO', 'DF', 1),
	(710, 'TO', 'ES', 4),
	(711, 'TO', 'GO', 1),
	(712, 'TO', 'MA', 5),
	(713, 'TO', 'MG', 3),
	(714, 'TO', 'MS', 3),
	(715, 'TO', 'MT', 3),
	(716, 'TO', 'PA', 2),
	(717, 'TO', 'PB', 5),
	(718, 'TO', 'PE', 4),
	(719, 'TO', 'PI', 5),
	(720, 'TO', 'PR', 4),
	(721, 'TO', 'RJ', 3),
	(722, 'TO', 'RN', 5),
	(723, 'TO', 'RO', 5),
	(724, 'TO', 'RR', 4),
	(725, 'TO', 'RS', 5),
	(726, 'TO', 'SC', 4),
	(727, 'TO', 'SE', 5),
	(728, 'TO', 'SP', 3),
	(729, 'TO', 'TO', 4);
/*!40000 ALTER TABLE `origem_destino` ENABLE KEYS */;

-- Copiando estrutura para tabela desafiomelhorenvio.servicos
CREATE TABLE IF NOT EXISTS `servicos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transportadora_id` int(11) DEFAULT '0',
  `tipo` varchar(25) DEFAULT NULL,
  `altu_min` int(11) DEFAULT '0',
  `altu_max` int(11) DEFAULT '0',
  `larg_min` int(11) DEFAULT '0',
  `larg_max` int(11) DEFAULT '0',
  `comp_min` int(11) DEFAULT '0',
  `comp_max` int(11) DEFAULT '0',
  `peso_min` int(11) DEFAULT '0',
  `peso_max` int(11) DEFAULT '0',
  `segu_min` decimal(9,2) DEFAULT '0.00',
  `segu_max` decimal(9,2) DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

-- Copiando dados para a tabela desafiomelhorenvio.servicos: ~2 rows (aproximadamente)
/*!40000 ALTER TABLE `servicos` DISABLE KEYS */;
INSERT INTO `servicos` (`id`, `transportadora_id`, `tipo`, `altu_min`, `altu_max`, `larg_min`, `larg_max`, `comp_min`, `comp_max`, `peso_min`, `peso_max`, `segu_min`, `segu_max`) VALUES
	(1, 1, 'economico', 2, 105, 11, 105, 16, 105, 1000, 30000, 17.00, 3000.00),
	(2, 1, 'expresso', 2, 105, 11, 105, 16, 105, 1000, 30000, 17.00, 10000.00);
/*!40000 ALTER TABLE `servicos` ENABLE KEYS */;

-- Copiando estrutura para tabela desafiomelhorenvio.servicos_adicionais
CREATE TABLE IF NOT EXISTS `servicos_adicionais` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transportadora_id` int(11) DEFAULT '0',
  `nome` varchar(255) DEFAULT NULL,
  `aplicacao` varchar(25) DEFAULT NULL,
  `valor` decimal(9,2) DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- Copiando dados para a tabela desafiomelhorenvio.servicos_adicionais: ~4 rows (aproximadamente)
/*!40000 ALTER TABLE `servicos_adicionais` DISABLE KEYS */;
INSERT INTO `servicos_adicionais` (`id`, `transportadora_id`, `nome`, `aplicacao`, `valor`) VALUES
	(1, 1, 'Aviso de Recebimento (AR)', 'frete', 1.05),
	(2, 1, 'Mão Própria (MP)', 'total', 3.00),
	(3, 1, 'Seguro', 'mercadoria', 1.01),
	(4, 1, 'Carga valiosa', 'mercadoria', 1.01);
/*!40000 ALTER TABLE `servicos_adicionais` ENABLE KEYS */;

-- Copiando estrutura para tabela desafiomelhorenvio.transportadoras
CREATE TABLE IF NOT EXISTS `transportadoras` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nome` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- Copiando dados para a tabela desafiomelhorenvio.transportadoras: ~0 rows (aproximadamente)
/*!40000 ALTER TABLE `transportadoras` DISABLE KEYS */;
INSERT INTO `transportadoras` (`id`, `nome`) VALUES
	(1, 'MELHOR TRANSPORTADORA LTDA');
/*!40000 ALTER TABLE `transportadoras` ENABLE KEYS */;

-- Copiando estrutura para tabela desafiomelhorenvio.valores
CREATE TABLE IF NOT EXISTS `valores` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transportadora_id` int(11) NOT NULL DEFAULT '0',
  `tipo` varchar(25) DEFAULT NULL,
  `kg_adicional` int(1) DEFAULT '0',
  `peso_min` int(11) DEFAULT '0',
  `peso_max` int(11) DEFAULT '0',
  `l1` decimal(9,2) DEFAULT '0.00',
  `l2` decimal(9,2) DEFAULT '0.00',
  `l3` decimal(9,2) DEFAULT '0.00',
  `l4` decimal(9,2) DEFAULT '0.00',
  `e1` decimal(9,2) DEFAULT '0.00',
  `e2` decimal(9,2) DEFAULT '0.00',
  `e3` decimal(9,2) DEFAULT '0.00',
  `e4` decimal(9,2) DEFAULT '0.00',
  `n1` decimal(9,2) DEFAULT '0.00',
  `n2` decimal(9,2) DEFAULT '0.00',
  `n3` decimal(9,2) DEFAULT '0.00',
  `n4` decimal(9,2) DEFAULT '0.00',
  `n5` decimal(9,2) DEFAULT '0.00',
  `n6` decimal(9,2) DEFAULT '0.00',
  `i1` decimal(9,2) DEFAULT '0.00',
  `i2` decimal(9,2) DEFAULT '0.00',
  `i3` decimal(9,2) DEFAULT '0.00',
  `i4` decimal(9,2) DEFAULT '0.00',
  `i5` decimal(9,2) DEFAULT '0.00',
  `i6` decimal(9,2) DEFAULT '0.00',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;

-- Copiando dados para a tabela desafiomelhorenvio.valores: ~25 rows (aproximadamente)
/*!40000 ALTER TABLE `valores` DISABLE KEYS */;
INSERT INTO `valores` (`id`, `transportadora_id`, `tipo`, `kg_adicional`, `peso_min`, `peso_max`, `l1`, `l2`, `l3`, `l4`, `e1`, `e2`, `e3`, `e4`, `n1`, `n2`, `n3`, `n4`, `n5`, `n6`, `i1`, `i2`, `i3`, `i4`, `i5`, `i6`) VALUES
	(1, 1, 'expresso', 1, 0, 0, 1.58, 1.62, 1.65, 1.68, 2.98, 3.01, 3.04, 3.08, 5.85, 7.90, 11.12, 13.46, 16.97, 21.07, 8.31, 10.40, 13.62, 16.00, 19.59, 23.77),
	(2, 1, 'expresso', 0, 0, 300, 6.38, 6.51, 6.65, 6.78, 12.83, 13.11, 13.40, 14.25, 19.48, 27.27, 35.06, 40.90, 48.69, 58.43, 28.50, 36.70, 44.49, 50.74, 59.35, 69.91),
	(3, 1, 'expresso', 0, 301, 500, 7.15, 7.30, 7.45, 7.60, 13.29, 13.59, 13.88, 14.77, 20.30, 28.40, 36.52, 42.61, 50.73, 60.88, 29.32, 37.83, 45.95, 52.45, 61.39, 72.36),
	(4, 1, 'expresso', 0, 501, 1000, 7.66, 7.82, 7.99, 8.15, 14.82, 14.97, 15.12, 15.28, 21.11, 29.55, 37.99, 44.32, 52.77, 63.32, 30.13, 38.98, 47.42, 54.16, 63.43, 74.80),
	(5, 1, 'expresso', 0, 1001, 2000, 9.62, 9.82, 10.03, 10.23, 16.35, 16.51, 16.69, 16.85, 25.45, 35.64, 45.81, 53.45, 63.63, 76.36, 37.75, 48.35, 58.52, 66.57, 77.57, 91.12),
	(6, 1, 'expresso', 0, 2001, 3000, 10.73, 10.96, 11.18, 11.41, 17.87, 18.05, 18.24, 18.42, 29.71, 40.11, 56.45, 68.33, 86.16, 106.95, 44.47, 55.28, 71.62, 83.91, 102.56, 124.17),
	(7, 1, 'expresso', 0, 3001, 4000, 11.59, 11.83, 12.08, 12.32, 19.66, 19.87, 20.07, 20.27, 34.06, 45.99, 64.72, 78.34, 98.79, 122.62, 48.82, 61.16, 79.89, 93.92, 115.19, 139.84),
	(8, 1, 'expresso', 0, 4001, 5000, 12.53, 12.79, 13.06, 13.33, 21.19, 21.41, 21.63, 21.84, 37.59, 50.74, 71.42, 86.45, 109.01, 135.32, 60.55, 74.11, 94.79, 110.23, 133.61, 160.74),
	(9, 1, 'expresso', 0, 5001, 6000, 13.31, 13.59, 13.87, 14.15, 22.90, 23.13, 23.37, 23.61, 41.21, 55.64, 78.30, 94.79, 119.52, 148.37, 64.17, 79.01, 101.67, 118.57, 144.12, 173.79),
	(10, 1, 'expresso', 0, 6001, 7000, 14.15, 14.46, 14.76, 15.06, 24.52, 24.77, 25.03, 25.27, 45.48, 61.39, 86.40, 104.60, 131.88, 163.72, 68.44, 84.76, 109.77, 128.38, 156.48, 189.14),
	(11, 1, 'expresso', 0, 7001, 8000, 14.96, 15.28, 15.60, 15.92, 26.22, 26.49, 26.76, 27.04, 49.82, 67.26, 94.66, 114.60, 144.48, 179.37, 74.42, 92.27, 119.67, 140.02, 170.72, 206.43),
	(12, 1, 'expresso', 0, 8001, 9000, 15.44, 15.77, 16.10, 16.42, 27.93, 28.22, 28.50, 28.80, 54.17, 73.13, 102.92, 124.59, 157.09, 195.01, 78.77, 98.14, 127.93, 150.01, 183.33, 222.07),
	(13, 1, 'expresso', 0, 9001, 10000, 15.79, 16.12, 16.46, 16.79, 29.82, 30.13, 30.43, 30.74, 58.52, 79.00, 111.18, 134.59, 169.69, 210.66, 83.12, 104.01, 136.19, 160.01, 195.93, 237.72),
	(14, 1, 'economico', 1, 0, 0, 0.00, 0.00, 0.00, 0.00, 2.24, 2.34, 2.36, 2.39, 3.27, 3.77, 4.30, 5.32, 6.55, 8.19, 4.07, 4.57, 5.80, 7.32, 8.95, 11.19),
	(15, 1, 'economico', 0, 0, 500, 0.00, 0.00, 0.00, 0.00, 11.85, 12.35, 12.48, 12.60, 14.10, 15.79, 17.63, 21.15, 25.38, 31.02, 15.10, 16.79, 25.63, 34.15, 42.38, 54.02),
	(16, 1, 'economico', 0, 501, 1000, 0.00, 0.00, 0.00, 0.00, 12.69, 13.23, 13.37, 13.50, 15.11, 16.92, 18.89, 22.67, 27.20, 33.24, 16.11, 17.92, 26.89, 35.67, 44.20, 56.24),
	(17, 1, 'economico', 0, 1001, 2000, 0.00, 0.00, 0.00, 0.00, 13.37, 13.94, 14.08, 14.22, 16.60, 18.59, 20.75, 24.90, 29.88, 36.52, 17.60, 19.59, 28.75, 37.90, 46.88, 59.52),
	(18, 1, 'economico', 0, 2001, 3000, 0.00, 0.00, 0.00, 0.00, 15.98, 16.66, 16.83, 17.00, 19.84, 22.22, 24.80, 29.76, 35.71, 43.65, 20.84, 23.22, 32.80, 42.76, 52.71, 66.65),
	(19, 1, 'economico', 0, 3001, 4000, 0.00, 0.00, 0.00, 0.00, 17.06, 17.79, 17.97, 18.15, 21.19, 23.73, 26.49, 31.79, 38.14, 46.62, 25.19, 27.73, 37.49, 47.79, 58.14, 72.62),
	(20, 1, 'economico', 0, 4001, 5000, 0.00, 0.00, 0.00, 0.00, 18.24, 19.01, 19.21, 19.40, 22.67, 25.39, 28.34, 34.01, 40.81, 49.87, 26.67, 29.39, 39.34, 50.01, 60.81, 75.87),
	(21, 1, 'economico', 0, 5001, 6000, 0.00, 0.00, 0.00, 0.00, 19.23, 20.05, 20.26, 20.46, 25.10, 28.87, 32.94, 40.79, 50.20, 62.75, 31.10, 34.87, 45.94, 58.79, 72.20, 90.75),
	(22, 1, 'economico', 0, 6001, 7000, 0.00, 0.00, 0.00, 0.00, 20.32, 21.19, 21.40, 21.62, 27.71, 31.87, 36.37, 45.03, 55.42, 69.28, 33.71, 37.87, 49.37, 63.03, 77.42, 97.28),
	(23, 1, 'economico', 0, 7001, 8000, 0.00, 0.00, 0.00, 0.00, 21.36, 22.27, 22.49, 22.72, 30.19, 34.72, 39.62, 49.06, 60.38, 75.48, 38.19, 42.72, 54.62, 69.06, 84.38, 105.48),
	(24, 1, 'economico', 0, 8001, 9000, 0.00, 0.00, 0.00, 0.00, 21.98, 22.91, 23.15, 23.38, 31.68, 36.43, 41.58, 51.48, 63.36, 79.20, 39.68, 44.43, 56.58, 71.48, 87.36, 109.20),
	(25, 1, 'economico', 0, 9001, 10000, 0.00, 0.00, 0.00, 0.00, 22.42, 23.37, 23.61, 23.85, 32.74, 37.65, 42.97, 53.20, 65.48, 81.85, 40.74, 45.65, 57.97, 73.20, 89.48, 111.85);
/*!40000 ALTER TABLE `valores` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;