-- phpMyAdmin SQL Dump
-- version 2.11.9.6
-- http://www.phpmyadmin.net
--
-- Máquina: localhost:3306
-- Data de Criação: 26-Fev-2011 às 12:46
-- Versão do servidor: 5.0.51
-- versão do PHP: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- --------------------------------------------------------

--
-- Estrutura da tabela `zones`
--

CREATE TABLE IF NOT EXISTS `zones` (
  `id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=178 ;

--
-- Extraindo dados da tabela `zones`
--

INSERT INTO `zones` (`id`, `parent_id`, `name`) VALUES
(1, 0, 'Santarém'),
(2, 1, 'Abrantes'),
(3, 0, 'Lisboa'),
(4, 3, 'Agualva-Cacém'),
(5, 0, 'Aveiro'),
(6, 5, 'Águeda'),
(7, 0, 'Faro'),
(8, 7, 'Albufeira'),
(9, 0, 'Setúbal'),
(10, 9, 'Alcácer do Sal'),
(11, 0, 'Leiria'),
(12, 11, 'Alcobaça'),
(13, 9, 'Almada'),
(14, 1, 'Almeirim'),
(15, 3, 'Alverca do Ribatejo'),
(16, 3, 'Amadora'),
(17, 0, 'Porto'),
(18, 17, 'Amarante'),
(19, 9, 'Amora'),
(20, 5, 'Anadia'),
(21, 0, 'Açores'),
(22, 21, 'Angra do Heroísmo'),
(23, 5, 'Aveiro'),
(24, 0, 'Braga'),
(25, 24, 'Barcelos'),
(26, 9, 'Barreiro'),
(27, 0, 'Beja'),
(28, 27, 'Beja'),
(29, 0, 'Évora'),
(30, 29, 'Borba'),
(31, 24, 'Braga'),
(32, 0, 'Bragança'),
(33, 32, 'Bragança'),
(34, 11, 'Caldas da Rainha'),
(35, 0, 'Madeira'),
(36, 35, 'Câmara de Lobos'),
(37, 35, 'Caniço'),
(38, 0, 'Coimbra'),
(39, 38, 'Cantanhede'),
(40, 1, 'Cartaxo'),
(41, 0, 'Castelo Branco'),
(42, 41, 'Castelo Branco'),
(43, 0, 'Vila Real'),
(44, 43, 'Chaves'),
(45, 38, 'Coimbra'),
(46, 9, 'Costa da Caparica'),
(47, 41, 'Covilhã'),
(48, 0, 'Portalegre'),
(49, 48, 'Elvas'),
(50, 1, 'Entroncamento'),
(51, 17, 'Ermesinde'),
(52, 5, 'Esmoriz'),
(53, 5, 'Espinho'),
(54, 24, 'Esposende'),
(55, 5, 'Estarreja'),
(56, 29, 'Estremoz'),
(57, 29, 'Évora'),
(58, 24, 'Fafe'),
(59, 7, 'Faro'),
(60, 1, 'Fátima'),
(61, 17, 'Felgueiras'),
(62, 38, 'Figueira da Foz'),
(63, 5, 'Fiães'),
(64, 17, 'Freamunde'),
(65, 35, 'Funchal'),
(66, 41, 'Fundão'),
(67, 5, 'Gafanha da Nazaré'),
(68, 17, 'Gandra'),
(69, 17, 'Gondomar'),
(70, 0, 'Guarda'),
(71, 70, 'Gouveia'),
(72, 70, 'Guarda'),
(73, 24, 'Guimarães'),
(74, 21, 'Horta'),
(75, 5, 'Ílhavo'),
(76, 7, 'Lagoa'),
(77, 7, 'Lagos'),
(78, 0, 'Viseu'),
(79, 78, 'Lamego'),
(80, 11, 'Leiria'),
(81, 3, 'Lisboa'),
(82, 17, 'Lixa'),
(83, 7, 'Loulé'),
(84, 3, 'Loures'),
(85, 5, 'Lourosa'),
(86, 32, 'Macedo de Cavaleiros'),
(87, 35, 'Machico'),
(88, 17, 'Maia'),
(89, 0, 'VIseu'),
(90, 89, 'Mangualde'),
(91, 17, 'Marco de Canaveses'),
(92, 11, 'Marinha Grande'),
(93, 17, 'Matosinhos'),
(94, 5, 'Mealhada'),
(95, 70, 'Mêda'),
(96, 32, 'Miranda do Douro'),
(97, 32, 'Mirandela'),
(98, 29, 'Montemor-o-Novo'),
(99, 9, 'Montijo'),
(100, 27, 'Moura'),
(101, 3, 'Odivelas'),
(102, 7, 'Olhão da Restauração'),
(103, 5, 'Oliveira de Azeméis'),
(104, 5, 'Oliveira do Bairro'),
(105, 38, 'Oliveira do Hospital'),
(106, 1, 'Ourém'),
(107, 5, 'Ovar'),
(108, 17, 'Paços de Ferreira'),
(109, 17, 'Paredes'),
(110, 17, 'Penafiel'),
(111, 11, 'Peniche'),
(112, 43, 'Peso da Régua'),
(113, 70, 'Pinhel'),
(114, 38, 'Pombal'),
(115, 21, 'Ponta Delgada'),
(116, 48, 'Ponte de Sor'),
(117, 48, 'Portalegre'),
(118, 7, 'Portimão'),
(119, 17, 'Porto'),
(120, 3, 'Póvoa de Santa Iria'),
(121, 17, 'Póvoa de Varzim'),
(122, 21, 'Praia da Vitória'),
(123, 7, 'Quarteira'),
(124, 3, 'Queluz'),
(125, 17, 'Rebordosa'),
(126, 29, 'Reguengos de Monsaraz'),
(127, 21, 'Ribeira Grande'),
(128, 1, 'Rio Maior'),
(129, 17, 'Rio Tinto'),
(130, 70, 'Sabugal'),
(131, 3, 'Sacavém'),
(132, 1, 'Samora Correia'),
(133, 78, 'Santa Comba Dão'),
(134, 35, 'Santa Cruz'),
(135, 5, 'Santa Maria da Feira'),
(136, 35, 'Santana'),
(137, 1, 'Santarém'),
(138, 9, 'Santiago do Cacém'),
(139, 17, 'Santo Tirso'),
(140, 5, 'São João da Madeira'),
(141, 17, 'São Mamede de Infesta'),
(142, 78, 'São Pedro do Sul'),
(143, 17, 'São Salvador de Lordelo'),
(144, 70, 'Seia'),
(145, 9, 'Seixal'),
(146, 17, 'Senhora da Hora'),
(147, 27, 'Serpa'),
(148, 9, 'Setúbal'),
(149, 7, 'Silves'),
(150, 9, 'Sines'),
(151, 78, 'Tarouca'),
(152, 7, 'Tavira'),
(153, 1, 'Tomar'),
(154, 78, 'Tondela'),
(155, 1, 'Torres Novas'),
(156, 3, 'Torres Vedras'),
(157, 70, 'Trancoso'),
(158, 17, 'Trofa'),
(159, 17, 'Valbom'),
(160, 5, 'Vale de Cambra'),
(161, 0, 'Viana do Castelo'),
(162, 161, 'Valença'),
(163, 17, 'Valongo'),
(164, 43, 'Valpaços'),
(165, 29, 'Vendas Novas'),
(166, 161, 'Viana do Castelo'),
(167, 35, 'Vila Baleira'),
(168, 17, 'Vila do Conde'),
(169, 3, 'Vila Franca de Xira'),
(170, 24, 'Vila Nova de Famalicão'),
(171, 70, 'Vila Nova de Foz Côa'),
(172, 17, 'Vila Nova de Gaia'),
(173, 9, 'Vila Nova de Santo André'),
(174, 43, 'Vila Real'),
(175, 7, 'Vila Real de Santo António'),
(176, 78, 'Viseu'),
(177, 24, 'Vizela');