-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 15, 2014 at 02:39 PM
-- Server version: 5.1.57
-- PHP Version: 5.2.17

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `a9542853_pn`
--

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

--
-- Table structure for table `provincias`
--

CREATE TABLE `provincias` (
  `codigo` int(11) NOT NULL DEFAULT '0',
  `idprovincia` varchar(2) DEFAULT NULL,
  `descripcion` varchar(30) NOT NULL DEFAULT '',
  `id_dep` varchar(4) DEFAULT NULL,
  `det_dep` varchar(30) DEFAULT NULL,
  `nombdirecadj` varchar(30) DEFAULT NULL,
  `apelldirecadj` varchar(30) DEFAULT NULL,
  `ceduladirecadj` varchar(15) DEFAULT NULL,
  `celuladirecadj` varchar(15) DEFAULT NULL,
  `rangodirecadj` varchar(20) DEFAULT NULL,
  `nombencrecep` varchar(30) DEFAULT NULL,
  `apellencrecep` varchar(30) DEFAULT NULL,
  `cedulaencrecep` varchar(30) DEFAULT NULL,
  `rangoencrecep` varchar(15) DEFAULT NULL,
  `celulaencrecep` varchar(15) DEFAULT NULL,
  `regional` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`codigo`,`descripcion`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `provincias`
--

INSERT INTO `provincias` VALUES(1, '1', 'Azua', '1', 'Azua', 'Marcial Miguel', 'Perez Garo', '001-0875322-5', '809-342-2453', '809-598-34530', NULL, NULL, NULL, NULL, NULL, 'REGIONAL CENTRAL DEL ESTE');
INSERT INTO `provincias` VALUES(2, '2', 'Bahoruco', '2', 'Bahoruco', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(3, '3', 'Barahona', '3', 'Barahona', 'Luis Alberto ', 'Sanchez Garo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(4, '4', 'Dajabon', '4', 'Dajabon', 'Nicaragua gran ', 'Saludo Mutuo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(5, '5', 'Duarte', '5', 'Duarte', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(6, '6', 'Elias Piña', '6', 'Elias Piña', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(7, '7', 'El Seibo', '7', 'El Seibo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(8, '8', 'Espaillat', '8', 'Espaillat', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(9, '9', 'Hato Mayor', '9', 'Hato Mayor', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(10, '10', 'Hermanas Mirabal', '10', 'Hermanas Mirabal', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(11, '11', 'Independencia', '11', 'Independencia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(12, '12', 'La Altagracia', '12', 'La Altagracia', 'Juan Thomas ', 'Villa Arrendel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(13, '13', 'La Romana', '13', 'La Romana', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(14, '14', 'La Vega', '14', 'La Vega', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(15, '15', 'Maria Trinidad Sanchez', '15', 'Maria Trinidad Sanchez', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(16, '16', 'Monseñol Nouel', '16', 'Monseñol Nouel', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(17, '17', 'Monte Cristi', '17', 'Monte Cristi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(18, '18', 'Monte Plata', '18', 'Monte Plata', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(19, '19', 'Pedernales', '19', 'Pedernales', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(20, '20', 'Peravia', '20', 'Peravia', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(21, '21', 'Pureto Plata', '21', 'Pureto Plata', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(22, '22', 'Samana', '22', 'Samana', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(23, '23', 'Sanchez Ramirez', '23', 'Sanchez Ramirez', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(24, '24', 'San Cristobal', '24', 'San Cristobal', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(25, '25', 'San Jose de Ocoa', '25', 'San Jose de Ocoa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(26, '26', 'San Juan', '26', 'San Juan', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(27, '27', 'San Pedro de Macoris', '27', 'San Pedro de Macoris', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(28, '28', 'Santiago', '28', 'Santiago', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(29, '29', 'Santiago Rodriguez', '29', 'Santiago Rodriguez', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(30, '30', 'Santo Domingo', '30', 'Santo Domingo', 'Carlos De Los Santos', 'Jimenez Peralta', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(31, '31', 'Dajabon', '31', 'Dajabon', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(32, '32', 'Valderde', '32', 'Valderde', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `provincias` VALUES(34, '34', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);