CREATE DATABASE  IF NOT EXISTS `dyv-an` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `dyv-an`;
-- MySQL dump 10.13  Distrib 5.5.43, for debian-linux-gnu (x86_64)
--
-- Host: 127.0.0.1    Database: dyv-an
-- ------------------------------------------------------
-- Server version	5.5.39

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `bancos`
--

DROP TABLE IF EXISTS `bancos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bancos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `banco` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `num_cuenta` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  `tipo` varchar(45) CHARACTER SET latin1 DEFAULT NULL,
  `imagen` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `bancos`
--

LOCK TABLES `bancos` WRITE;
/*!40000 ALTER TABLE `bancos` DISABLE KEYS */;
INSERT INTO `bancos` VALUES (1,'fasfsaf','r3r33qr',1,'qrqwrwqr','banda-01.png','2015-05-23','2015-05-23'),(2,'banco pepito','342343243243',0,'ahorro','maxresdefault.jpg','2015-06-01','2015-06-01');
/*!40000 ALTER TABLE `bancos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `categorias`
--

DROP TABLE IF EXISTS `categorias`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categorias` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_nomb` varchar(50) NOT NULL,
  `cat_desc` varchar(50) NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  `deleted` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `categorias`
--

LOCK TABLES `categorias` WRITE;
/*!40000 ALTER TABLE `categorias` DISABLE KEYS */;
INSERT INTO `categorias` VALUES (1,'Trajes de baños','Trajes de baños','2015-04-25','2015-05-03',1),(2,'zapatos','zapatos','2015-04-25','2015-04-25',1),(3,'Trajes de baño','Trajes de baño','2015-05-03','2015-05-03',0),(4,'ropa','ropa','2015-06-01','2015-06-01',0),(5,'ropa2','ropa2','2015-06-01','2015-06-01',0),(6,'ropa3','ropa3','2015-06-01','2015-06-01',0),(7,'ropa4','ropa4','2015-06-01','2015-06-01',0),(8,'ropa5','ropa5','2015-06-01','2015-06-01',0);
/*!40000 ALTER TABLE `categorias` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `colores`
--

DROP TABLE IF EXISTS `colores`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `colores` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `color_nomb` varchar(20) DEFAULT NULL,
  `color_desc` varchar(20) DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `colores`
--

LOCK TABLES `colores` WRITE;
/*!40000 ALTER TABLE `colores` DISABLE KEYS */;
INSERT INTO `colores` VALUES (1,'amarillo','Amarillos','2015-03-08','2015-04-25',0),(2,'azul','Azul','2015-03-08','2015-03-08',0),(3,'rojo','Rojo','2015-03-08','2015-04-25',1),(4,'safasf','asffsas','2015-03-13','2015-03-13',1);
/*!40000 ALTER TABLE `colores` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `departamento`
--

DROP TABLE IF EXISTS `departamento`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `departamento` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `departamento`
--

LOCK TABLES `departamento` WRITE;
/*!40000 ALTER TABLE `departamento` DISABLE KEYS */;
INSERT INTO `departamento` VALUES (1,'la paz'),(2,'santa cruz'),(3,'cochabamba'),(4,'beni'),(5,'potosi'),(6,'tarija'),(7,'chuquisaca'),(8,'oruro'),(9,'pando');
/*!40000 ALTER TABLE `departamento` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `direcciones`
--

DROP TABLE IF EXISTS `direcciones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `direcciones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `dir` varchar(500) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  `user_dir` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `direcciones`
--

LOCK TABLES `direcciones` WRITE;
/*!40000 ALTER TABLE `direcciones` DISABLE KEYS */;
INSERT INTO `direcciones` VALUES (1,9,'esta es la direccion nueva','<EMAIL>',0,'2015-06-11','2015-06-11',NULL),(2,2,'caguafadf daf daf daf daf adf adf ','<EMAIL>',0,'2015-05-12','2015-06-09',1),(3,9,' dfadfdfadf','<EMAIL>',0,'2015-06-16','2015-06-16',1);
/*!40000 ALTER TABLE `direcciones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `estado`
--

DROP TABLE IF EXISTS `estado`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `estado` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Identificador de la tabla Estado',
  `nombre` varchar(100) NOT NULL COMMENT 'Indica el nombre del estado almacenado',
  `pais_id` int(11) NOT NULL COMMENT 'Campo que relaciona el estado con el pais',
  `deleted` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fk_estado_pais` (`pais_id`),
  CONSTRAINT `fk_estado_pais` FOREIGN KEY (`pais_id`) REFERENCES `pais` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COMMENT='Entidad que contiene informacion sobre estados. Desarrollado por <NAME> <<EMAIL>> @josearodrigueze';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `estado`
--

LOCK TABLES `estado` WRITE;
/*!40000 ALTER TABLE `estado` DISABLE KEYS */;
INSERT INTO `estado` VALUES (1,'DTTO. CAPITAL',1,0),(2,'ANZOATEGUI',1,0),(3,'APURE',1,0),(4,'ARAGUA',1,0),(5,'BARINAS',1,0),(6,'BOLIVAR',1,0),(7,'CARABOBO',1,0),(8,'COJEDES',1,0),(9,'FALCON',1,0),(10,'GUARICO',1,0),(11,'LARA',1,0),(12,'MERIDA',1,0),(13,'MIRANDA',1,0),(14,'MONAGAS',1,0),(15,'NUEVA ESPARTA',1,0),(16,'PORTUGUESA',1,0),(17,'SUCRE',1,0),(18,'TACHIRA',1,0),(19,'TRUJILLO',1,0),(20,'YARACUY',1,0),(21,'ZULIA',1,0),(22,'AMAZONAS',1,0),(23,'DELTA AMACURO',1,0),(24,'VARGAS',1,0);
/*!40000 ALTER TABLE `estado` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `factura_item`
--

DROP TABLE IF EXISTS `factura_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `factura_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `factura_id` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `item_qty` int(11) DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  `item_talla` int(11) DEFAULT NULL,
  `item_color` int(11) DEFAULT NULL,
  `item_precio` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `factura_item`
--

LOCK TABLES `factura_item` WRITE;
/*!40000 ALTER TABLE `factura_item` DISABLE KEYS */;
INSERT INTO `factura_item` VALUES (1,3,1,20,'2015-05-12','2015-05-12',1,1,1000),(2,4,1,1,'2015-05-15','2015-05-15',1,1,1000),(3,5,1,1,'2015-06-01','2015-06-01',1,1,1000),(4,6,1,2,'2015-06-11','2015-06-11',1,1,1000),(5,7,1,4,'2015-06-11','2015-06-11',1,1,1000),(6,8,4,1,'2015-06-16','2015-06-16',1,1,134123),(7,8,1,1,'2015-06-16','2015-06-16',1,1,1000);
/*!40000 ALTER TABLE `factura_item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `facturas`
--

DROP TABLE IF EXISTS `facturas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `facturas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `pagada` int(11) DEFAULT '0',
  `num_trans` int(11) DEFAULT NULL,
  `dir` varchar(500) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `estado` varchar(45) DEFAULT NULL,
  `fech_trans` varchar(45) DEFAULT NULL,
  `banco` int(11) DEFAULT NULL,
  `banco_ext` varchar(45) DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `facturas`
--

LOCK TABLES `facturas` WRITE;
/*!40000 ALTER TABLE `facturas` DISABLE KEYS */;
INSERT INTO `facturas` VALUES (1,2,0,NULL,'1','2015-05-12 23:35:08','2015-05-12 23:35:08',NULL,NULL,NULL,NULL,0),(2,2,0,NULL,'1','2015-05-12 23:35:53','2015-05-12 23:35:53',NULL,NULL,NULL,NULL,0),(3,2,0,NULL,'1','2015-05-12 23:36:25','2015-05-12 23:36:25',NULL,NULL,NULL,NULL,0),(4,2,0,NULL,'1','2015-05-15 23:27:02','2015-05-15 23:27:02',NULL,NULL,NULL,NULL,0),(5,2,1,2147483647,'1','2015-06-01 22:08:09','2015-06-12 19:43:42',NULL,'12/11/2015',2,NULL,0),(6,9,0,NULL,'0','2015-06-11 02:45:07','2015-06-11 02:45:07',NULL,NULL,NULL,NULL,0),(7,9,1,2147483647,'0','2015-06-11 22:54:32','2015-06-12 19:43:19',NULL,'03-06-2015',2,'asafsf',0),(8,9,-1,12314,'3','2015-06-16 19:25:08','2015-06-16 19:28:19',NULL,'19-06-2015',2,NULL,0);
/*!40000 ALTER TABLE `facturas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `images`
--

DROP TABLE IF EXISTS `images`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `images` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `misc_id` int(11) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  `order` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `images`
--

LOCK TABLES `images` WRITE;
/*!40000 ALTER TABLE `images` DISABLE KEYS */;
INSERT INTO `images` VALUES (1,1,'1/banda-01.png','2015-05-03','2015-06-12',0,0),(2,1,'1/maxresdefault1.jpg','2015-06-01','2015-06-12',0,0),(3,3,'2/sol1.jpg','2015-06-12','2015-06-12',0,0),(4,3,'2/banco-economico.gif','2015-06-12','2015-06-12',0,0),(5,3,'2/bancocredito.gif','2015-06-12','2015-06-12',0,0),(6,5,'3/bancoCredito.png','2015-06-12','2015-06-12',0,0),(7,6,'4/ADEA.jpeg','2015-06-15','2015-06-15',0,0),(8,7,'4/entidades.png','2015-06-15','2015-06-15',0,0),(9,8,'5/maqueta.png','2015-06-16','2015-06-19',0,6),(10,8,'5/ponto.png','2015-06-16','2015-06-19',0,1),(11,9,'5/ciades.jpg','2015-06-16','2015-06-19',0,2),(12,9,'5/35235.jpg','2015-06-16','2015-06-19',0,4),(13,10,'5/12.png','2015-06-18','2015-06-19',0,3),(14,11,'5/3.png','2015-06-18','2015-06-19',0,7),(15,8,'5/35235(1).jpg','2015-06-18','2015-06-19',0,8),(16,8,'5/ADEA.jpg','2015-06-18','2015-06-19',0,5);
/*!40000 ALTER TABLE `images` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `item`
--

DROP TABLE IF EXISTS `item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_cod` varchar(10) NOT NULL,
  `item_nomb` varchar(100) NOT NULL,
  `item_desc` text NOT NULL,
  `item_prov` int(11) NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  `deleted` int(11) DEFAULT '0',
  `item_cat` int(11) DEFAULT NULL,
  `item_subcat` int(11) DEFAULT NULL,
  `item_precio` float DEFAULT NULL,
  `item_stock` varchar(45) DEFAULT NULL,
  `item_prom` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `item_cod` (`item_cod`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `item`
--

LOCK TABLES `item` WRITE;
/*!40000 ALTER TABLE `item` DISABLE KEYS */;
INSERT INTO `item` VALUES (1,'00012','Articulo seg','<p>xxxxxxxxxxxxxxxx</p>\r\n',0,'2015-05-03','2015-06-12',0,3,3,1000,NULL,NULL),(2,'1111','peperoni','<p>adfdafadfdfdafdafdaf</p>\r\n',0,'2015-06-12','2015-06-12',0,3,NULL,12000,NULL,NULL),(3,'0002z1','articulo 5555','<p>afdafdafadf</p>\r\n',0,'2015-06-12','2015-06-12',0,4,NULL,500,NULL,NULL),(4,'111','bebbeebe','<p>dfadfadfadfadf</p>\r\n',0,'2015-06-15','2015-06-15',0,3,NULL,134123,NULL,NULL),(5,'a4a4','asfasf','<p>dgadgdagdgadgdagadgadgadgg</p>\r\n',0,'2015-06-16','2015-06-16',0,3,3,134123,NULL,NULL);
/*!40000 ALTER TABLE `item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `miscelanias`
--

DROP TABLE IF EXISTS `miscelanias`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `miscelanias` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) DEFAULT NULL,
  `item_talla` varchar(20) DEFAULT NULL,
  `item_color` varchar(20) DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  `item_stock` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `miscelanias`
--

LOCK TABLES `miscelanias` WRITE;
/*!40000 ALTER TABLE `miscelanias` DISABLE KEYS */;
INSERT INTO `miscelanias` VALUES (1,1,'1','1','2015-06-16','2015-05-03',0,'92'),(2,1,'1','1','2015-06-01','2015-06-01',0,'5'),(3,0,NULL,NULL,'2015-06-12','2015-06-12',0,NULL),(4,2,'1','1','2015-06-12','2015-06-12',0,'100'),(5,3,NULL,NULL,'2015-06-12','2015-06-12',0,NULL),(6,4,'1','1','2015-06-16','2015-06-15',0,'11'),(7,4,'2','2','2015-06-15','2015-06-15',0,'12'),(8,5,'1','1','2015-06-16','2015-06-16',0,'12'),(9,5,'2','2','2015-06-16','2015-06-16',0,'12'),(10,5,'1','2','2015-06-18','2015-06-18',0,'12'),(11,5,'3','1','2015-06-18','2015-06-18',0,'122'),(12,5,'2','2','2015-06-18','2015-06-18',0,'1111111111111');
/*!40000 ALTER TABLE `miscelanias` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `municipio`
--

DROP TABLE IF EXISTS `municipio`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `municipio` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Identificador de Munucipio',
  `nombre` varchar(100) NOT NULL,
  `estado_id` int(11) NOT NULL COMMENT 'Identificador del estado al que pertenece la parroquia',
  `deleted` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fk_municipio_estado1` (`estado_id`),
  CONSTRAINT `fk_municipio_estado1` FOREIGN KEY (`estado_id`) REFERENCES `estado` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=336 DEFAULT CHARSET=utf8 COMMENT='Entidad que contiene la informacion de municipios. Desarrollado por <NAME> <<EMAIL>> @josearodrigueze';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `municipio`
--

LOCK TABLES `municipio` WRITE;
/*!40000 ALTER TABLE `municipio` DISABLE KEYS */;
INSERT INTO `municipio` VALUES (1,'LIBERTADOR',1,0),(2,'ANACO',2,0),(3,'ARAGUA',2,0),(4,'BOLIVAR',2,0),(5,'BRUZUAL',2,0),(6,'CAJIGAL',2,0),(7,'FREITES',2,0),(8,'INDEPENDENCIA',2,0),(9,'LIBERTAD',2,0),(10,'MIRANDA',2,0),(11,'MONAGAS',2,0),(12,'PEÑALVER',2,0),(13,'<NAME>',2,0),(14,'SOTILLO',2,0),(15,'GUANIPA',2,0),(16,'GUANTA',2,0),(17,'PIRITU',2,0),(18,'M.L/DIEGO BAUTISTA U',2,0),(19,'CARVAJAL',2,0),(20,'<NAME>',2,0),(21,'<NAME>',2,0),(22,'<NAME>',2,0),(23,'ACHAGUAS',3,0),(24,'MUÑOZ',3,0),(25,'PAEZ',3,0),(26,'<NAME>',3,0),(27,'<NAME>',3,0),(28,'<NAME>',3,0),(29,'BIRUACA',3,0),(30,'GIRARDOT',4,0),(31,'<NAME>',4,0),(32,'<NAME>',4,0),(33,'<NAME>',4,0),(34,'<NAME>',4,0),(35,'SUCRE',4,0),(36,'URDANETA',4,0),(37,'ZAMORA',4,0),(38,'LIBERTADOR',4,0),(39,'<NAME>',4,0),(40,'BOLIVAR',4,0),(41,'<NAME>',4,0),(42,'MARIO <NAME>',4,0),(43,'TOVAR',4,0),(44,'CAMATAGUA',4,0),(45,'<NAME>',4,0),(46,'<NAME>.',4,0),(47,'<NAME>',4,0),(48,'ARISMENDI',5,0),(49,'BARINAS',5,0),(50,'BOLIVAR',5,0),(51,'<NAME>',5,0),(52,'OBISPOS',5,0),(53,'PEDRAZA',5,0),(54,'ROJAS',5,0),(55,'SOSA',5,0),(56,'<NAME>',5,0),(57,'<NAME>',5,0),(58,'<NAME>',5,0),(59,'<NAME>',5,0),(60,'CARONI',6,0),(61,'CEDEÑO',6,0),(62,'HERES',6,0),(63,'PIAR',6,0),(64,'ROSCIO',6,0),(65,'SUCRE',6,0),(66,'SIFONTES',6,0),(67,'<NAME>',6,0),(68,'<NAME>',6,0),(69,'<NAME>',6,0),(70,'<NAME>',6,0),(71,'BEJUMA',7,0),(72,'<NAME>',7,0),(73,'<NAME>',7,0),(74,'GUACARA',7,0),(75,'MONTALBAN',7,0),(76,'<NAME>',7,0),(77,'<NAME>',7,0),(78,'<NAME>',7,0),(79,'VALENCIA',7,0),(80,'MIRANDA',7,0),(81,'<NAME>',7,0),(82,'NAGUANAGUA',7,0),(83,'<NAME>',7,0),(84,'LIBERTADOR',7,0),(85,'ANZOATEGUI',8,0),(86,'FALCON',8,0),(87,'GIRARDOT',8,0),(88,'MP PAO SN J BAUTISTA',8,0),(89,'RICAURTE',8,0),(90,'<NAME>',8,0),(91,'TINACO',8,0),(92,'<NAME>',8,0),(93,'<NAME>',8,0),(94,'ACOSTA',9,0),(95,'BOLIVAR',9,0),(96,'BUCHIVACOA',9,0),(97,'CARIRUBANA',9,0),(98,'COLINA',9,0),(99,'DEMOCRACIA',9,0),(100,'FALCON',9,0),(101,'FEDERACION',9,0),(102,'MAUROA',9,0),(103,'MIRANDA',9,0),(104,'PETIT',9,0),(105,'SILVA',9,0),(106,'ZAMORA',9,0),(107,'DABAJURO',9,0),(108,'<NAME>',9,0),(109,'<NAME>',9,0),(110,'PIRITU',9,0),(111,'UNION',9,0),(112,'<NAME>',9,0),(113,'JACURA',9,0),(114,'<NAME>',9,0),(115,'<NAME>',9,0),(116,'SUCRE',9,0),(117,'URUMACO',9,0),(118,'TOCOPERO',9,0),(119,'INFANTE',10,0),(120,'MELLADO',10,0),(121,'MIRANDA',10,0),(122,'MONAGAS',10,0),(123,'RIBAS',10,0),(124,'ROSCIO',10,0),(125,'ZARAZA',10,0),(126,'CAMAGUAN',10,0),(127,'S <NAME>',10,0),(128,'<NAME>',10,0),(129,'<NAME>',10,0),(130,'ORTIZ',10,0),(131,'<NAME>',10,0),(132,'CHAGUARAMAS',10,0),(133,'<NAME>',10,0),(134,'CRESPO',11,0),(135,'IRIBARREN',11,0),(136,'JIMENEZ',11,0),(137,'MORAN',11,0),(138,'PALAVECINO',11,0),(139,'TORRES',11,0),(140,'URDANETA',11,0),(141,'<NAME>',11,0),(142,'<NAME>',11,0),(143,'<NAME>',12,0),(144,'<NAME>',12,0),(145,'<NAME>',12,0),(146,'<NAME>',12,0),(147,'GUARAQUE',12,0),(148,'<NAME>',12,0),(149,'<NAME>',12,0),(150,'LIBERTADOR',12,0),(151,'<NAME>',12,0),(152,'MIRANDA',12,0),(153,'<NAME>.',12,0),(154,'OB. <NAME>',12,0),(155,'<NAME>',12,0),(156,'<NAME>',12,0),(157,'<NAME>',12,0),(158,'RANGEL',12,0),(159,'<NAME>',12,0),(160,'SUCRE',12,0),(161,'TOVAR',12,0),(162,'<NAME>',12,0),(163,'<NAME>',12,0),(164,'ARICAGUA',12,0),(165,'ZEA',12,0),(166,'ACEVEDO',13,0),(167,'BRION',13,0),(168,'GUAICAIPURO',13,0),(169,'INDEPENDENCIA',13,0),(170,'LANDER',13,0),(171,'PAEZ',13,0),(172,'<NAME>',13,0),(173,'PLAZA',13,0),(174,'SUCRE',13,0),(175,'URDANETA',13,0),(176,'ZAMORA',13,0),(177,'<NAME>',13,0),(178,'<NAME>',13,0),(179,'<NAME>',13,0),(180,'<NAME>',13,0),(181,'BARUTA',13,0),(182,'CARRIZAL',13,0),(183,'CHACAO',13,0),(184,'<NAME>',13,0),(185,'BUROZ',13,0),(186,'<NAME>',13,0),(187,'ACOSTA',14,0),(188,'BOLIVAR',14,0),(189,'CARIPE',14,0),(190,'CEDEÑO',14,0),(191,'<NAME>',14,0),(192,'LIBERTADOR',14,0),(193,'MATURIN',14,0),(194,'PIAR',14,0),(195,'PUNCERES',14,0),(196,'SOTILLO',14,0),(197,'AGUASAY',14,0),(198,'<NAME>',14,0),(199,'URACOA',14,0),(200,'ARISMENDI',15,0),(201,'DIAZ',15,0),(202,'GOMEZ',15,0),(203,'MANEIRO',15,0),(204,'MARCANO',15,0),(205,'MARIÑO',15,0),(206,'<NAME>',15,0),(207,'VILLALBA(I.COCHE)',15,0),(208,'TUBORES',15,0),(209,'<NAME>',15,0),(210,'GARCIA',15,0),(211,'ARAURE',16,0),(212,'ESTELLER',16,0),(213,'GUANARE',16,0),(214,'GUANARITO',16,0),(215,'OSPINO',16,0),(216,'PAEZ',16,0),(217,'SUCRE',16,0),(218,'TUREN',16,0),(219,'<NAME>',16,0),(220,'<NAME>',16,0),(221,'PAPELON',16,0),(222,'<NAME>',16,0),(223,'<NAME>',16,0),(224,'<NAME>',16,0),(225,'ARISMENDI',17,0),(226,'BENITEZ',17,0),(227,'BERMUDEZ',17,0),(228,'CAJIGAL',17,0),(229,'MARIÑO',17,0),(230,'MEJIA',17,0),(231,'MONTES',17,0),(232,'RIBERO',17,0),(233,'SUCRE',17,0),(234,'VALDEZ',17,0),(235,'<NAME>',17,0),(236,'LIBERTADOR',17,0),(237,'<NAME>',17,0),(238,'BOLIVAR',17,0),(239,'<NAME>',17,0),(240,'AYACUCHO',18,0),(241,'BOLIVAR',18,0),(242,'INDEPENDENCIA',18,0),(243,'CARDENAS',18,0),(244,'JAUREGUI',18,0),(245,'JUNIN',18,0),(246,'LOBATERA',18,0),(247,'<NAME>',18,0),(248,'URIBANTE',18,0),(249,'CORDOBA',18,0),(250,'<NAME>',18,0),(251,'GUASIMOS',18,0),(252,'MICHELENA',18,0),(253,'LIBERTADOR',18,0),(254,'PANAMERICANO',18,0),(255,'<NAME>',18,0),(256,'SUCRE',18,0),(257,'<NAME>',18,0),(258,'<NAME>',18,0),(259,'LIBERTAD',18,0),(260,'<NAME>',18,0),(261,'SEBORUCO',18,0),(262,'<NAME>',18,0),(263,'<NAME>',18,0),(264,'<NAME>',18,0),(265,'<NAME>',18,0),(266,'<NAME>',18,0),(267,'TORBES',18,0),(268,'<NAME>',18,0),(269,'<NAME>',19,0),(270,'BOCONO',19,0),(271,'CARACHE',19,0),(272,'ESCUQUE',19,0),(273,'TRUJILLO',19,0),(274,'URDANETA',19,0),(275,'VALERA',19,0),(276,'CANDELARIA',19,0),(277,'MIRANDA',19,0),(278,'<NAME>',19,0),(279,'MOTATAN',19,0),(280,'PAMPAN',19,0),(281,'<NAME>',19,0),(282,'SUCRE',19,0),(283,'<NAME>',19,0),(284,'BOLIVAR',19,0),(285,'<NAME>',19,0),(286,'<NAME>',19,0),(287,'<NAME>',19,0),(288,'PAMPANITO',19,0),(289,'BOLIVAR',20,0),(290,'BRUZUAL',20,0),(291,'NIRGUA',20,0),(292,'<NAME>',20,0),(293,'SUCRE',20,0),(294,'URACHICHE',20,0),(295,'PEÑA',20,0),(296,'<NAME>',20,0),(297,'LA TRINIDAD',20,0),(298,'COCOROTE',20,0),(299,'INDEPENDENCIA',20,0),(300,'ARISTIDES BASTID',20,0),(301,'<NAME>',20,0),(302,'VEROES',20,0),(303,'BARALT',21,0),(304,'<NAME>',21,0),(305,'COLON',21,0),(306,'MARA',21,0),(307,'MARACAIBO',21,0),(308,'MIRANDA',21,0),(309,'PAEZ',21,0),(310,'<NAME>',21,0),(311,'SUCRE',21,0),(312,'LA CAÑADA DE U.',21,0),(313,'LAGUNILLAS',21,0),(314,'CATATUMBO',21,0),(315,'<NAME>',21,0),(316,'CABIMAS',21,0),(317,'<NAME>',21,0),(318,'<NAME>',21,0),(319,'<NAME>',21,0),(320,'<NAME>',21,0),(321,'<NAME>',21,0),(322,'<NAME>',21,0),(323,'<NAME>',21,0),(324,'ATURES',22,0),(325,'ATABAPO',22,0),(326,'MAROA',22,0),(327,'<NAME>',22,0),(328,'AUTANA',22,0),(329,'MANAPIARE',22,0),(330,'<NAME>',22,0),(331,'TUCUPITA',23,0),(332,'PEDERNALES',23,0),(333,'<NAME>',23,0),(334,'CASACOIMA',23,0),(335,'VARGAS',24,0);
/*!40000 ALTER TABLE `municipio` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pais`
--

DROP TABLE IF EXISTS `pais`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pais` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cod` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=256 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pais`
--

LOCK TABLES `pais` WRITE;
/*!40000 ALTER TABLE `pais` DISABLE KEYS */;
INSERT INTO `pais` VALUES (1,'AC','Isla de la Ascensión'),(2,'AD','Andorra'),(3,'AE','Emiratos Árabes Unidos'),(4,'AF','Afganistán'),(5,'AG','Antigua y Barbuda'),(6,'AI','Anguila'),(7,'AL','Albania'),(8,'AM','Armenia'),(9,'AN','Antillas Neerlandesas'),(10,'AO','Angola'),(11,'AQ','Antártida'),(12,'AR','Argentina'),(13,'AS','Samoa Americana'),(14,'AT','Austria'),(15,'AU','Australia'),(16,'AW','Aruba'),(17,'AX','Islas Åland'),(18,'AZ','Azerbaiyán'),(19,'BA','Bosnia-Herzegovina'),(20,'BB','Barbados'),(21,'BD','Bangladesh'),(22,'BE','Bélgica'),(23,'BF','Burkina Faso'),(24,'BG','Bulgaria'),(25,'BH','Bahréin'),(26,'BI','Burundi'),(27,'BJ','Benín'),(28,'BL','San Bartolomé'),(29,'BM','Bermudas'),(30,'BN','Brunéi'),(31,'BO','Bolivia'),(32,'BR','Brasil'),(33,'BS','Bahamas'),(34,'BT','Bután'),(35,'BV','Isla Bouvet'),(36,'BW','Botsuana'),(37,'BY','Bielorrusia'),(38,'BZ','Belice'),(39,'CA','Canadá'),(40,'CC','Islas Cocos'),(41,'CD','República Democrática del Congo'),(42,'CF','República Centroafricana'),(43,'CG','Congo - Brazzaville'),(44,'CH','Suiza'),(45,'CI','Costa de Marfil'),(46,'CK','Islas Cook'),(47,'CL','Chile'),(48,'CM','Camerún'),(49,'CN','China'),(50,'CO','Colombia'),(51,'CP','Isla Clipperton'),(52,'CR','Costa Rica'),(53,'CS','Serbia y Montenegro'),(54,'CU','Cuba'),(55,'CV','Cabo Verde'),(56,'CX','Isla Christmas'),(57,'CY','Chipre'),(58,'CZ','República Checa'),(59,'DE','Alemania'),(60,'DG','Diego García'),(61,'DJ','Yibuti'),(62,'DK','Dinamarca'),(63,'DM','Dominica'),(64,'DO','República Dominicana'),(65,'DZ','Argelia'),(66,'EA','Ceuta y Melilla'),(67,'EC','Ecuador'),(68,'EE','Estonia'),(69,'EG','Egipto'),(70,'EH','Sáhara Occidental'),(71,'ER','Eritrea'),(72,'ES','España'),(73,'ET','Etiopía'),(74,'EU','Unión Europea'),(75,'FI','Finlandia'),(76,'FJ','Fiyi'),(77,'FK','Islas Malvinas'),(78,'FM','Micronesia'),(79,'FO','Islas Feroe'),(80,'FR','Francia'),(81,'GA','Gabón'),(82,'GB','Reino Unido'),(83,'GD','Granada'),(84,'GE','Georgia'),(85,'GF','Guayana Francesa'),(86,'GG','Guernsey'),(87,'GH','Ghana'),(88,'GI','Gibraltar'),(89,'GL','Groenlandia'),(90,'GM','Gambia'),(91,'GN','Guinea'),(92,'GP','Guadalupe'),(93,'GQ','Guinea Ecuatorial'),(94,'GR','Grecia'),(95,'GS','Islas Georgia del Sur y Sandwich del Sur'),(96,'GT','Guatemala'),(97,'GU','Guam'),(98,'GW','Guinea-Bissau'),(99,'GY','Guyana'),(100,'HK','Región Administrativa Especial de Hong Kong de la República Popu'),(101,'HM','Islas Heard y McDonald'),(102,'HN','Honduras'),(103,'HR','Croacia'),(104,'HT','Haití'),(105,'HU','Hungría'),(106,'IC','Islas Canarias'),(107,'ID','Indonesia'),(108,'IE','Irlanda'),(109,'IL','Israel'),(110,'IM','Isla de Man'),(111,'IN','India'),(112,'IO','Territorio Británico del Océano Índico'),(113,'IQ','Iraq'),(114,'IR','Irán'),(115,'IS','Islandia'),(116,'IT','Italia'),(117,'JE','Jersey'),(118,'JM','Jamaica'),(119,'JO','Jordania'),(120,'JP','Japón'),(121,'KE','Kenia'),(122,'KG','Kirguistán'),(123,'KH','Camboya'),(124,'KI','Kiribati'),(125,'KM','Comoras'),(126,'KN','San Cristóbal y Nieves'),(127,'KP','Corea del Norte'),(128,'KR','Corea del Sur'),(129,'KW','Kuwait'),(130,'KY','Islas Caimán'),(131,'KZ','Kazajistán'),(132,'LA','Laos'),(133,'LB','Líbano'),(134,'LC','Santa Lucía'),(135,'LI','Liechtenstein'),(136,'LK','Sri Lanka'),(137,'LR','Liberia'),(138,'LS','Lesoto'),(139,'LT','Lituania'),(140,'LU','Luxemburgo'),(141,'LV','Letonia'),(142,'LY','Libia'),(143,'MA','Marruecos'),(144,'MC','Mónaco'),(145,'MD','Moldavia'),(146,'ME','Montenegro'),(147,'MF','San Martín'),(148,'MG','Madagascar'),(149,'MH','Islas Marshall'),(150,'MK','Macedonia'),(151,'ML','Mali'),(152,'MM','Myanmar [Birmania]'),(153,'MN','Mongolia'),(154,'MO','Región Administrativa Especial de Macao de la República Popular '),(155,'MP','Islas Marianas del Norte'),(156,'MQ','Martinica'),(157,'MR','Mauritania'),(158,'MS','Montserrat'),(159,'MT','Malta'),(160,'MU','Mauricio'),(161,'MV','Maldivas'),(162,'MW','Malaui'),(163,'MX','México'),(164,'MY','Malasia'),(165,'MZ','Mozambique'),(166,'NA','Namibia'),(167,'NC','Nueva Caledonia'),(168,'NE','Níger'),(169,'NF','Isla Norfolk'),(170,'NG','Nigeria'),(171,'NI','Nicaragua'),(172,'NL','Países Bajos'),(173,'NO','Noruega'),(174,'NP','Nepal'),(175,'NR','Nauru'),(176,'NU','Isla Niue'),(177,'NZ','Nueva Zelanda'),(178,'OM','Omán'),(179,'PA','Panamá'),(180,'PE','Perú'),(181,'PF','Polinesia Francesa'),(182,'PG','Papúa Nueva Guinea'),(183,'PH','Filipinas'),(184,'PK','Pakistán'),(185,'PL','Polonia'),(186,'PM','San Pedro y Miquelón'),(187,'PN','Islas Pitcairn'),(188,'PR','Puerto Rico'),(189,'PS','Territorios Palestinos'),(190,'PT','Portugal'),(191,'PW','Palau'),(192,'PY','Paraguay'),(193,'QA','Qatar'),(194,'QO','Territorios alejados de Oceanía'),(195,'RE','Reunión'),(196,'RO','Rumanía'),(197,'RS','Serbia'),(198,'RU','Rusia'),(199,'RW','Ruanda'),(200,'SA','Arabia Saudí'),(201,'SB','Islas Salomón'),(202,'SC','Seychelles'),(203,'SD','Sudán'),(204,'SE','Suecia'),(205,'SG','Singapur'),(206,'SH','Santa Elena'),(207,'SI','Eslovenia'),(208,'SJ','Svalbard y Jan Mayen'),(209,'SK','Eslovaquia'),(210,'SL','Sierra Leona'),(211,'SM','San Marino'),(212,'SN','Senegal'),(213,'SO','Somalia'),(214,'SR','Surinam'),(215,'ST','Santo Tomé y Príncipe'),(216,'SV','El Salvador'),(217,'SY','Siria'),(218,'SZ','Suazilandia'),(219,'TA','Tristán da Cunha'),(220,'TC','Islas Turcas y Caicos'),(221,'TD','Chad'),(222,'TF','Territorios Australes Franceses'),(223,'TG','Togo'),(224,'TH','Tailandia'),(225,'TJ','Tayikistán'),(226,'TK','Tokelau'),(227,'TL','Timor Oriental'),(228,'TM','Turkmenistán'),(229,'TN','Túnez'),(230,'TO','Tonga'),(231,'TR','Turquía'),(232,'TT','Trinidad y Tobago'),(233,'TV','Tuvalu'),(234,'TW','Taiwán'),(235,'TZ','Tanzania'),(236,'UA','Ucrania'),(237,'UG','Uganda'),(238,'UM','Islas menores alejadas de los Estados Unidos'),(239,'US','Estados Unidos'),(240,'UY','Uruguay'),(241,'UZ','Uzbekistán'),(242,'VA','Ciudad del Vaticano'),(243,'VC','San Vicente y las Granadinas'),(244,'VE','Venezuela'),(245,'VG','Islas Vírgenes Británicas'),(246,'VI','Islas Vírgenes de los Estados Unidos'),(247,'VN','Vietnam'),(248,'VU','Vanuatu'),(249,'WF','Wallis y Futuna'),(250,'WS','Samoa'),(251,'YE','Yemen'),(252,'YT','Mayotte'),(253,'ZA','Sudáfrica'),(254,'ZM','Zambia'),(255,'ZW','Zimbabue');
/*!40000 ALTER TABLE `pais` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `parroquia`
--

DROP TABLE IF EXISTS `parroquia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `parroquia` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Identificador de la parroquia',
  `nombre` varchar(100) NOT NULL COMMENT 'Nombre de la parroquia',
  `municipio_id` int(11) NOT NULL COMMENT 'Identificador del municipio al que pertenece la parroquia',
  `deleted` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `fk_parroquia_municipio1` (`municipio_id`),
  CONSTRAINT `fk_parroquia_municipio1` FOREIGN KEY (`municipio_id`) REFERENCES `municipio` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1135 DEFAULT CHARSET=utf8 COMMENT='Entidad que contiene informacion sobre parroquias. Desarrollado por <NAME> <<EMAIL>> @josearodrigueze';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `parroquia`
--

LOCK TABLES `parroquia` WRITE;
/*!40000 ALTER TABLE `parroquia` DISABLE KEYS */;
INSERT INTO `parroquia` VALUES (1,'ALTAGRACIA',1,0),(2,'CANDELARIA',1,0),(3,'CATEDRAL',1,0),(4,'LA PASTORA',1,0),(5,'<NAME>',1,0),(6,'<NAME>',1,0),(7,'<NAME>',1,0),(8,'SANTA ROSALIA',1,0),(9,'SANTA TERESA',1,0),(10,'SUCRE',1,0),(11,'23 DE ENERO',1,0),(12,'ANTIMANO',1,0),(13,'EL RECREO',1,0),(14,'EL VALLE',1,0),(15,'LA VEGA',1,0),(16,'MACARAO',1,0),(17,'CARICUAO',1,0),(18,'EL JUNQUITO',1,0),(19,'COCHE',1,0),(20,'<NAME>',1,0),(21,'<NAME>',1,0),(22,'<NAME>',1,0),(23,'ANACO',2,0),(24,'<NAME>',2,0),(25,'<NAME>',3,0),(26,'CACHIPO',3,0),(27,'<NAME>',4,0),(28,'<NAME>',4,0),(29,'BERGANTIN',4,0),(30,'CAIGUA',4,0),(31,'<NAME>',4,0),(32,'NARICUAL',4,0),(33,'<NAME>',5,0),(34,'GUANAPE',5,0),(35,'<NAME>',5,0),(36,'<NAME>',6,0),(37,'<NAME>',6,0),(38,'<NAME>',7,0),(39,'LIBERTADOR',7,0),(40,'<NAME>',7,0),(41,'URICA',7,0),(42,'<NAME>',8,0),(43,'MAMO',8,0),(44,'CM. <NAME>',9,0),(45,'<NAME>',9,0),(46,'<NAME>',9,0),(47,'<NAME>',10,0),(48,'ATAPIRIRE',10,0),(49,'<NAME>',10,0),(50,'<NAME>',10,0),(51,'<NAME>',11,0),(52,'PIAR',11,0),(53,'<NAME>',11,0),(54,'<NAME>',11,0),(55,'UVERITO',11,0),(56,'ZUATA',11,0),(57,'<NAME>',12,0),(58,'<NAME>',12,0),(59,'SUCRE',12,0),(60,'<NAME>',13,0),(61,'POZUELOS',14,0),(62,'CM PTO. <NAME>',14,0),(63,'CM. <NAME>',15,0),(64,'GUANTA',16,0),(65,'CHORRERON',16,0),(66,'PIRITU',17,0),(67,'<NAME>',17,0),(68,'LECHERIAS',18,0),(69,'<NAME>',18,0),(70,'<NAME>',19,0),(71,'<NAME>',19,0),(72,'<NAME>',20,0),(73,'<NAME>',20,0),(74,'<NAME>',21,0),(75,'<NAME>',21,0),(76,'<NAME>',22,0),(77,'<NAME>',22,0),(78,'ACHAGUAS',23,0),(79,'APURITO',23,0),(80,'<NAME>',23,0),(81,'GUACHARA',23,0),(82,'MUCURITAS',23,0),(83,'<NAME>',23,0),(84,'BRUZUAL',24,0),(85,'MANTECAL',24,0),(86,'QUINTERO',24,0),(87,'<NAME>',24,0),(88,'<NAME>',24,0),(89,'GUASDUALITO',25,0),(90,'ARAMENDI',25,0),(91,'<NAME>',25,0),(92,'<NAME>',25,0),(93,'URDANETA',25,0),(94,'<NAME>',26,0),(95,'CODAZZI',26,0),(96,'CUNAVICHE',26,0),(97,'ELORZA',27,0),(98,'LA TRINIDAD',27,0),(99,'<NAME>',28,0),(100,'PEÑALVER',28,0),(101,'<NAME>',28,0),(102,'<NAME>',28,0),(103,'BIRUACA',29,0),(104,'CM. <NAME>',30,0),(105,'CHORONI',30,0),(106,'<NAME>',30,0),(107,'<NAME>',30,0),(108,'<NAME>',30,0),(109,'<NAME>',30,0),(110,'<NAME>',30,0),(111,'<NAME>',30,0),(112,'<NAME>',31,0),(113,'<NAME>',31,0),(114,'<NAME>',31,0),(115,'CHUAO',31,0),(116,'<NAME>',31,0),(117,'CM. LA VICTORIA',32,0),(118,'ZUATA',32,0),(119,'<NAME>',32,0),(120,'<NAME>',32,0),(121,'<NAME>',32,0),(122,'CM. <NAME>',33,0),(123,'<NAME>',33,0),(124,'GUIRIPA',33,0),(125,'<NAME>',33,0),(126,'CM. <NAME>',34,0),(127,'CM. CAGUA',35,0),(128,'<NAME>',35,0),(129,'CM. BARBACOAS',36,0),(130,'<NAME>',36,0),(131,'TAGUAY',36,0),(132,'<NAME>',36,0),(133,'CM. V<NAME>',37,0),(134,'MAGDALENO',37,0),(135,'<NAME>',37,0),(136,'<NAME>',37,0),(137,'<NAME>',37,0),(138,'<NAME>',38,0),(139,'<NAME>',38,0),(140,'<NAME>',39,0),(141,'<NAME>',40,0),(142,'CM. <NAME>',41,0),(143,'TIARA',41,0),(144,'<NAME>',42,0),(145,'<NAME>',42,0),(146,'CM. <NAME>',43,0),(147,'<NAME>',44,0),(148,'<NAME>',44,0),(149,'CM. <NAME>',45,0),(150,'<NAME>',46,0),(151,'<NAME>',46,0),(152,'<NAME>',46,0),(153,'OCUMARE DE LA COSTA',47,0),(154,'ARISMENDI',48,0),(155,'GUADARRAMA',48,0),(156,'LA UNION',48,0),(157,'<NAME>',48,0),(158,'<NAME>',49,0),(159,'BARINAS',49,0),(160,'<NAME>',49,0),(161,'<NAME>',49,0),(162,'<NAME>',49,0),(163,'TORUNOS',49,0),(164,'<NAME>',49,0),(165,'<NAME>',49,0),(166,'<NAME>',49,0),(167,'<NAME>',49,0),(168,'<NAME>',49,0),(169,'<NAME>',49,0),(170,'<NAME>',49,0),(171,'<NAME>',49,0),(172,'ALTAMIRA',50,0),(173,'BARINITAS',50,0),(174,'CALDERAS',50,0),(175,'<NAME>',51,0),(176,'<NAME>',51,0),(177,'<NAME>',51,0),(178,'<NAME>',51,0),(179,'<NAME>',52,0),(180,'<NAME>',52,0),(181,'OBISPOS',52,0),(182,'<NAME>',52,0),(183,'<NAME>',53,0),(184,'<NAME>',53,0),(185,'PAEZ',53,0),(186,'<NAME>',53,0),(187,'DOLORES',54,0),(188,'LIBERTAD',54,0),(189,'<NAME>',54,0),(190,'<NAME>',54,0),(191,'CIUDAD DE NUTRIAS',55,0),(192,'EL REGALO',55,0),(193,'PUERTO DE NUTRIAS',55,0),(194,'<NAME>',55,0),(195,'<NAME>',56,0),(196,'SABANETA',56,0),(197,'TICOPORO',57,0),(198,'<NAME>',57,0),(199,'<NAME>',57,0),(200,'BARRANCAS',58,0),(201,'<NAME>',58,0),(202,'MASPARRITO',58,0),(203,'<NAME>',59,0),(204,'<NAME>',59,0),(205,'<NAME>',59,0),(206,'<NAME>',60,0),(207,'<NAME>',60,0),(208,'<NAME>',60,0),(209,'CHIRICA',60,0),(210,'<NAME>',60,0),(211,'CACHAMAY',60,0),(212,'UNIVERSIDAD',60,0),(213,'UNARE',60,0),(214,'YOCOIMA',60,0),(215,'<NAME>',60,0),(216,'<NAME>',61,0),(217,'<NAME>',61,0),(218,'ALTAGRACIA',61,0),(219,'<NAME>',61,0),(220,'GUANIAMO',61,0),(221,'PIJIGUAOS',61,0),(222,'CATEDRAL',62,0),(223,'<NAME>',62,0),(224,'<NAME>',62,0),(225,'<NAME>',62,0),(226,'MARHUANTA',62,0),(227,'<NAME>',62,0),(228,'ORINOCO',62,0),(229,'PANAPANA',62,0),(230,'ZEA',62,0),(231,'<NAME>',63,0),(232,'<NAME>',63,0),(233,'<NAME>',63,0),(234,'<NAME>',64,0),(235,'SALOM',64,0),(236,'<NAME>',65,0),(237,'ARIPAO',65,0),(238,'<NAME>',65,0),(239,'MOITACO',65,0),(240,'GUARATARO',65,0),(241,'<NAME>',66,0),(242,'<NAME>',66,0),(243,'<NAME>',66,0),(244,'<NAME>',67,0),(245,'<NAME>',67,0),(246,'BARCELONETA',67,0),(247,'<NAME>',67,0),(248,'<NAME>',68,0),(249,'IKABARU',68,0),(250,'<NAME>',69,0),(251,'<NAME>',70,0),(252,'BEJUMA',71,0),(253,'CANOABO',71,0),(254,'<NAME>',71,0),(255,'GUIGUE',72,0),(256,'BELEN',72,0),(257,'TACARIGUA',72,0),(258,'MARIARA',73,0),(259,'<NAME>',73,0),(260,'GUACARA',74,0),(261,'<NAME>',74,0),(262,'YAGUA',74,0),(263,'MONTALBAN',75,0),(264,'MORON',76,0),(265,'URAMA',76,0),(266,'DEMOCRACIA',77,0),(267,'FRATERNIDAD',77,0),(268,'GOAIGOAZA',77,0),(269,'<NAME>',77,0),(270,'<NAME>',77,0),(271,'UNION',77,0),(272,'BORBURATA',77,0),(273,'PATANEMO',77,0),(274,'<NAME>',78,0),(275,'CANDELARIA',79,0),(276,'CATEDRAL',79,0),(277,'<NAME>',79,0),(278,'<NAME>',79,0),(279,'<NAME>',79,0),(280,'<NAME>',79,0),(281,'<NAME>',79,0),(282,'<NAME>',79,0),(283,'<NAME>',79,0),(284,'MIRANDA',80,0),(285,'U LOS GUAYOS',81,0),(286,'NAGUANAGUA',82,0),(287,'URB SAN DIEGO',83,0),(288,'U TOCUYITO',84,0),(289,'U INDEPENDENCIA',84,0),(290,'COJEDES',85,0),(291,'<NAME>',85,0),(292,'TINAQUILLO',86,0),(293,'<NAME>',87,0),(294,'SUCRE',87,0),(295,'<NAME>',88,0),(296,'LIBERTAD DE COJEDES',89,0),(297,'<NAME>',89,0),(298,'<NAME>',90,0),(299,'<NAME>',90,0),(300,'<NAME>',90,0),(301,'GRL/JEFE <NAME>',91,0),(302,'MACAPO',92,0),(303,'<NAME>',92,0),(304,'<NAME>',93,0),(305,'<NAME>',94,0),(306,'CAPADARE',94,0),(307,'<NAME>',94,0),(308,'LIBERTADOR',94,0),(309,'<NAME>',95,0),(310,'ARACUA',95,0),(311,'<NAME>',95,0),(312,'CAPATARIDA',96,0),(313,'BOROJO',96,0),(314,'SEQUE',96,0),(315,'ZAZARIDA',96,0),(316,'BARIRO',96,0),(317,'GUAJIRO',96,0),(318,'NORTE',97,0),(319,'CARIRUBANA',97,0),(320,'<NAME>',97,0),(321,'<NAME>',97,0),(322,'<NAME>',98,0),(323,'ACURIGUA',98,0),(324,'GUAIBACOA',98,0),(325,'MACORUCA',98,0),(326,'<NAME>',98,0),(327,'PEDREGAL',99,0),(328,'<NAME>',99,0),(329,'AVARIA',99,0),(330,'<NAME>',99,0),(331,'PURURECHE',99,0),(332,'<NAME>',100,0),(333,'ADICORA',100,0),(334,'BARAIVED',100,0),(335,'<NAME>',100,0),(336,'JADACAQUIVA',100,0),(337,'MORUY',100,0),(338,'EL VINCULO',100,0),(339,'<NAME>',100,0),(340,'ADAURE',100,0),(341,'CHURUGUARA',101,0),(342,'<NAME>',101,0),(343,'INDEPENDENCIA',101,0),(344,'MAPARARI',101,0),(345,'<NAME>',101,0),(346,'<NAME>',102,0),(347,'CASIGUA',102,0),(348,'<NAME>',102,0),(349,'<NAME>',103,0),(350,'<NAME>',103,0),(351,'<NAME>',103,0),(352,'<NAME>',103,0),(353,'MITARE',103,0),(354,'SABANETA',103,0),(355,'<NAME>',103,0),(356,'CABURE',104,0),(357,'CURIMAGUA',104,0),(358,'COLINA',104,0),(359,'TUCACAS',105,0),(360,'<NAME>',105,0),(361,'<NAME>',106,0),(362,'<NAME>',106,0),(363,'<NAME>',106,0),(364,'<NAME>',106,0),(365,'ZAZARIDA',106,0),(366,'<NAME>',107,0),(367,'CHICHIRIVICHE',108,0),(368,'<NAME>',108,0),(369,'<NAME> LA COSTA',108,0),(370,'<NAME>',109,0),(371,'JUDIBANA',109,0),(372,'PIRITU',110,0),(373,'<NAME>',110,0),(374,'<NAME>',111,0),(375,'<NAME>',111,0),(376,'<NAME>',111,0),(377,'<NAME>',112,0),(378,'JACURA',113,0),(379,'<NAME>',113,0),(380,'ARAURIMA',113,0),(381,'<NAME>',114,0),(382,'<NAME>',115,0),(383,'SUCRE',116,0),(384,'PECAYA',116,0),(385,'URUMACO',117,0),(386,'BRUZUAL',117,0),(387,'<NAME>',118,0),(388,'<NAME>',119,0),(389,'ESPINO',119,0),(390,'<NAME>',120,0),(391,'SOSA',120,0),(392,'CALABOZO',121,0),(393,'EL CALVARIO',121,0),(394,'<NAME>',121,0),(395,'GUARDATINAJAS',121,0),(396,'ALTAGRACIA DE ORITUCO',122,0),(397,'LEZAMA',122,0),(398,'LIBERTAD <NAME>',122,0),(399,'<NAME>',122,0),(400,'<NAME>',122,0),(401,'SOUBLETTE',122,0),(402,'<NAME>',122,0),(403,'TUCUPIDO',123,0),(404,'<NAME>',123,0),(405,'<NAME>',124,0),(406,'PARAPARA',124,0),(407,'CANTAGALLO',124,0),(408,'ZARAZA',125,0),(409,'<NAME>',125,0),(410,'CAMAGUAN',126,0),(411,'<NAME>',126,0),(412,'UVERITO',126,0),(413,'<NAME>',127,0),(414,'<NAME>',128,0),(415,'<NAME>',128,0),(416,'CABRUTA',128,0),(417,'<NAME>',129,0),(418,'ORTIZ',130,0),(419,'<NAME>',130,0),(420,'<NAME>',130,0),(421,'<NAME> DE TIZNADOS',130,0),(422,'<NAME>',131,0),(423,'ALTAMIRA',131,0),(424,'CHAGUARAMAS',132,0),(425,'GUAYABAL',133,0),(426,'CAZORLA',133,0),(427,'FREITEZ',134,0),(428,'<NAME>',134,0),(429,'CATEDRAL',135,0),(430,'LA CONCEPCION',135,0),(431,'<NAME>',135,0),(432,'UNION',135,0),(433,'<NAME>',135,0),(434,'TAMACA',135,0),(435,'<NAME>',135,0),(436,'<NAME>',135,0),(437,'<NAME>',135,0),(438,'JUAREZ',135,0),(439,'<NAME>',136,0),(440,'<NAME>',136,0),(441,'<NAME>',136,0),(442,'CUARA',136,0),(443,'<NAME>',136,0),(444,'TINTORERO',136,0),(445,'<NAME>',136,0),(446,'<NAME>',136,0),(447,'BOLIVAR',137,0),(448,'ANZOATEGUI',137,0),(449,'GUARICO',137,0),(450,'<NAME>',137,0),(451,'<NAME>',137,0),(452,'MORAN',137,0),(453,'<NAME>',137,0),(454,'LA CANDELARIA',137,0),(455,'CABUDARE',138,0),(456,'<NAME>',138,0),(457,'<NAME>',138,0),(458,'<NAME>',139,0),(459,'<NAME>',139,0),(460,'CAMACARO',139,0),(461,'CASTAÑEDA',139,0),(462,'CHIQUINQUIRA',139,0),(463,'ESPINOZA <NAME>',139,0),(464,'LARA',139,0),(465,'<NAME>',139,0),(466,'<NAME>',139,0),(467,'TORRES',139,0),(468,'<NAME>',139,0),(469,'<NAME>',139,0),(470,'<NAME>',139,0),(471,'<NAME>',139,0),(472,'<NAME>',139,0),(473,'<NAME>',139,0),(474,'ALTAGRACIA',139,0),(475,'SIQUISIQUE',140,0),(476,'<NAME>',140,0),(477,'XAGUAS',140,0),(478,'MOROTURO',140,0),(479,'<NAME>',141,0),(480,'YACAMBU',141,0),(481,'<NAME>',141,0),(482,'SARARE',142,0),(483,'<NAME>',142,0),(484,'BURIA',142,0),(485,'<NAME>.',143,0),(486,'<NAME>',143,0),(487,'<NAME>',143,0),(488,'<NAME>',143,0),(489,'PTE. <NAME>',143,0),(490,'PRESIDENTE BETANCOURT',143,0),(491,'PRESIDENTE PAEZ',143,0),(492,'CM. LA AZULITA',144,0),(493,'<NAME>',145,0),(494,'CAPURI',145,0),(495,'CHACANTA',145,0),(496,'<NAME>',145,0),(497,'GUAIMARAL',145,0),(498,'MUCUTUY',145,0),(499,'MUCUCHACHI',145,0),(500,'ACEQUIAS',146,0),(501,'JAJI',146,0),(502,'<NAME>',146,0),(503,'<NAME>',146,0),(504,'MONTALBAN',146,0),(505,'MATRIZ',146,0),(506,'<NAME>',146,0),(507,'<NAME>',147,0),(508,'<NAME>',147,0),(509,'<NAME>',147,0),(510,'<NAME>',148,0),(511,'PALMIRA',148,0),(512,'<NAME>',149,0),(513,'<NAME>',149,0),(514,'ARIAS',150,0),(515,'SAGRARIO',150,0),(516,'MILLA',150,0),(517,'<NAME>',150,0),(518,'<NAME>',150,0),(519,'<NAME>',150,0),(520,'<NAME>',150,0),(521,'<NAME>',150,0),(522,'<NAME>',150,0),(523,'<NAME>',150,0),(524,'<NAME>',150,0),(525,'<NAME>',150,0),(526,'<NAME>',150,0),(527,'<NAME>',150,0),(528,'<NAME>',150,0),(529,'<NAME>',151,0),(530,'<NAME>',152,0),(531,'<NAME>',152,0),(532,'PIÑANGO',152,0),(533,'LA VENTA',152,0),(534,'CM. STA CRUZ DE MORA',153,0),(535,'<NAME>',153,0),(536,'MESA DE LAS PALMAS',153,0),(537,'CM. STA ELENA DE ARENALES',154,0),(538,'<NAME>',154,0),(539,'<NAME>',154,0),(540,'<NAME>',155,0),(541,'<NAME>',155,0),(542,'<NAME>',156,0),(543,'<NAME>',156,0),(544,'<NAME>',157,0),(545,'CM. MUCUCHIES',158,0),(546,'MUCURUBA',158,0),(547,'<NAME>',158,0),(548,'CACUTE',158,0),(549,'<NAME>',158,0),(550,'<NAME>',159,0),(551,'<NAME>',159,0),(552,'<NAME>',160,0),(553,'CHIGUARA',160,0),(554,'ESTANQUES',160,0),(555,'<NAME>',160,0),(556,'<NAME>',160,0),(557,'<NAME>A',160,0),(558,'<NAME>',161,0),(559,'TOVAR',161,0),(560,'<NAME>',161,0),(561,'<NAME>',161,0),(562,'<NAME>',162,0),(563,'INDEPENDENCIA',162,0),(564,'<NAME>',162,0),(565,'<NAME>',162,0),(566,'CM. STA MARIA DE CAPARO',163,0),(567,'<NAME>',164,0),(568,'<NAME>',164,0),(569,'CM. ZEA',165,0),(570,'<NAME>',165,0),(571,'CAUCAGUA',166,0),(572,'ARAGUITA',166,0),(573,'<NAME>',166,0),(574,'CAPAYA',166,0),(575,'PANAQUIRE',166,0),(576,'RIBAS',166,0),(577,'EL CAFE',166,0),(578,'MARIZAPA',166,0),(579,'HIGUEROTE',167,0),(580,'CURIEPE',167,0),(581,'TACARIGUA',167,0),(582,'<NAME>',168,0),(583,'<NAME>',168,0),(584,'PARACOTOS',168,0),(585,'<NAME>',168,0),(586,'TACATA',168,0),(587,'<NAME>',168,0),(588,'<NAME>',168,0),(589,'<NAME>',169,0),(590,'<NAME>',169,0),(591,'<NAME>',170,0),(592,'<NAME>',170,0),(593,'<NAME>',170,0),(594,'<NAME>',171,0),(595,'<NAME>',171,0),(596,'<NAME>',171,0),(597,'PAPARO',171,0),(598,'<NAME>',171,0),(599,'<NAME>',172,0),(600,'GUARENAS',173,0),(601,'PETARE',174,0),(602,'<NAME>',174,0),(603,'CAUCAGUITA',174,0),(604,'<NAME>',174,0),(605,'LA DOLORITA',174,0),(606,'CUA',175,0),(607,'<NAME>',175,0),(608,'GUATIRE',176,0),(609,'BOLIVAR',176,0),(610,'CHARALLAVE',177,0),(611,'<NAME>',177,0),(612,'<NAME>',178,0),(613,'<NAME>',179,0),(614,'CUMBO',179,0),(615,'<NAME>',180,0),(616,'<NAME>',180,0),(617,'BARUTA',181,0),(618,'EL CAFETAL',181,0),(619,'<NAME>',181,0),(620,'CARRIZAL',182,0),(621,'CHACAO',183,0),(622,'<NAME>',184,0),(623,'MAMPORAL',185,0),(624,'CUPIRA',186,0),(625,'MACHURUCUTO',186,0),(626,'CM. <NAME>',187,0),(627,'<NAME>',187,0),(628,'<NAME>',188,0),(629,'<NAME>',189,0),(630,'TERESEN',189,0),(631,'<NAME>',189,0),(632,'<NAME>',189,0),(633,'<NAME>',189,0),(634,'<NAME>',189,0),(635,'<NAME>',190,0),(636,'AREO',190,0),(637,'<NAME>',190,0),(638,'<NAME>',190,0),(639,'CM. P<NAME>',191,0),(640,'EL TEJERO',191,0),(641,'CM. TEMBLADOR',192,0),(642,'TABASCA',192,0),(643,'<NAME>',192,0),(644,'CHAGUARAMAS',192,0),(645,'<NAME>',193,0),(646,'JUSEPIN',193,0),(647,'<NAME>',193,0),(648,'<NAME>',193,0),(649,'LA PICA',193,0),(650,'ALTO DE LOS GODOS',193,0),(651,'BOQUERON',193,0),(652,'<NAME>',193,0),(653,'<NAME>',193,0),(654,'<NAME>',193,0),(655,'<NAME>',194,0),(656,'CHAGUARAMAL',194,0),(657,'GUANAGUANA',194,0),(658,'APARICIO',194,0),(659,'TAGUAYA',194,0),(660,'<NAME>',194,0),(661,'<NAME>',194,0),(662,'CM. QUIRIQUIRE',195,0),(663,'CACHIPO',195,0),(664,'<NAME>',196,0),(665,'<NAME>',196,0),(666,'<NAME>',197,0),(667,'<NAME>',198,0),(668,'CM. URACOA',199,0),(669,'CM. LA ASUNCION',200,0),(670,'<NAME>',201,0),(671,'ZABALA',201,0),(672,'CM. <NAME>',202,0),(673,'GUEVARA',202,0),(674,'MATASIETE',202,0),(675,'BOLIVAR',202,0),(676,'SUCRE',202,0),(677,'<NAME>',203,0),(678,'AGUIRRE',203,0),(679,'<NAME>',204,0),(680,'ADRIAN',204,0),(681,'<NAME>',205,0),(682,'<NAME>',206,0),(683,'<NAME>',206,0),(684,'CM. <NAME>',207,0),(685,'<NAME>',207,0),(686,'<NAME>',208,0),(687,'<NAME>',208,0),(688,'CM.<NAME>',209,0),(689,'<NAME>',210,0),(690,'<NAME>',210,0),(691,'<NAME>',211,0),(692,'<NAME>',211,0),(693,'<NAME>',212,0),(694,'UVERAL',212,0),(695,'<NAME>',213,0),(696,'CORDOBA',213,0),(697,'<NAME>',213,0),(698,'<NAME>',213,0),(699,'<NAME>',213,0),(700,'<NAME>',214,0),(701,'<NAME>',214,0),(702,'<NAME>',214,0),(703,'<NAME>',215,0),(704,'APARICION',215,0),(705,'LA ESTACION',215,0),(706,'<NAME>',216,0),(707,'PAYARA',216,0),(708,'PIMPINELA',216,0),(709,'<NAME>',216,0),(710,'CM. BISCUCUY',217,0),(711,'CONCEPCION',217,0),(712,'<NAME>',217,0),(713,'<NAME>',217,0),(714,'<NAME>',217,0),(715,'<NAME>',217,0),(716,'<NAME>',218,0),(717,'CANELONES',218,0),(718,'<NAME>',218,0),(719,'<NAME>',218,0),(720,'<NAME>',219,0),(721,'<NAME>',219,0),(722,'CM. <NAME>',220,0),(723,'<NAME>',221,0),(724,'<NAME>',221,0),(725,'<NAME>',222,0),(726,'<NAME>',222,0),(727,'CM. <NAME>',223,0),(728,'<NAME>',223,0),(729,'<NAME>',223,0),(730,'CM. <NAME>',224,0),(731,'FLORIDA',224,0),(732,'<NAME>',225,0),(733,'SAN <NAME>',225,0),(734,'<NAME>',225,0),(735,'EL <NAME>',225,0),(736,'<NAME>',225,0),(737,'<NAME>',226,0),(738,'<NAME>',226,0),(739,'GUARAUNOS',226,0),(740,'TUNAPUICITO',226,0),(741,'UNION',226,0),(742,'<NAME>. <NAME>',226,0),(743,'<NAME>',227,0),(744,'<NAME>',227,0),(745,'<NAME>',227,0),(746,'BOLIVAR',227,0),(747,'MACARAPANA',227,0),(748,'YAGUARAPARO',228,0),(749,'LIBERTAD',228,0),(750,'PAUJIL',228,0),(751,'IRAPA',229,0),(752,'<NAME>',229,0),(753,'SORO',229,0),(754,'<NAME>',229,0),(755,'MARABAL',229,0),(756,'<NAME>',230,0),(757,'CUMANACOA',231,0),(758,'ARENAS',231,0),(759,'ARICAGUA',231,0),(760,'COCOLLAR',231,0),(761,'<NAME>',231,0),(762,'<NAME>',231,0),(763,'CARIACO',232,0),(764,'CATUARO',232,0),(765,'RENDON',232,0),(766,'<NAME>',232,0),(767,'<NAME>',232,0),(768,'ALTAGRACIA',233,0),(769,'AYACUCHO',233,0),(770,'<NAME>',233,0),(771,'<NAME>',233,0),(772,'<NAME>',233,0),(773,'<NAME>',233,0),(774,'<NAME>',233,0),(775,'GUIRIA',234,0),(776,'<NAME>',234,0),(777,'<NAME>',234,0),(778,'BIDEAU',234,0),(779,'MARIÑO',235,0),(780,'<NAME>',235,0),(781,'TUNAPUY',236,0),(782,'<NAME>',236,0),(783,'<NAME>',237,0),(784,'<NAME>',237,0),(785,'<NAME>',238,0),(786,'ARAYA',239,0),(787,'MANICUARE',239,0),(788,'CHACOPATA',239,0),(789,'<NAME>',240,0),(790,'<NAME>',240,0),(791,'<NAME>',240,0),(792,'CM. <NAME>',241,0),(793,'PALOTAL',241,0),(794,'<NAME>',241,0),(795,'<NAME>',241,0),(796,'<NAME>',242,0),(797,'<NAME>',242,0),(798,'<NAME>',242,0),(799,'CM. TARIBA',243,0),(800,'LA FLORIDA',243,0),(801,'<NAME>',243,0),(802,'CM. LA GRITA',244,0),(803,'<NAME>',244,0),(804,'<NAME>',244,0),(805,'CM. RUBIO',245,0),(806,'BRAMON',245,0),(807,'LA PETROLEA',245,0),(808,'QUINIMARI',245,0),(809,'CM. LOBATERA',246,0),(810,'CONSTITUCION',246,0),(811,'LA CONCORDIA',247,0),(812,'<NAME>',247,0),(813,'<NAME>',247,0),(814,'<NAME>',247,0),(815,'DR. FCO. <NAME>',247,0),(816,'CM. PREGONERO',248,0),(817,'CARDENAS',248,0),(818,'POTOSI',248,0),(819,'<NAME>',248,0),(820,'CM. STA. ANA  <NAME>',249,0),(821,'CM. LA FRIA',250,0),(822,'<NAME>',250,0),(823,'<NAME>',250,0),(824,'CM. PALMIRA',251,0),(825,'CM. MICHELENA',252,0),(826,'<NAME>',253,0),(827,'<NAME>',253,0),(828,'DORADAS',253,0),(829,'<NAME>',253,0),(830,'<NAME>',254,0),(831,'<NAME>',254,0),(832,'CM. UREÑA',255,0),(833,'<NAME>',255,0),(834,'<NAME>',256,0),(835,'<NAME>',256,0),(836,'<NAME>',256,0),(837,'<NAME>',257,0),(838,'CM.<NAME>',258,0),(839,'<NAME>',258,0),(840,'<NAME>',258,0),(841,'<NAME>',259,0),(842,'<NAME>',259,0),(843,'<NAME>',259,0),(844,'CM. <NAME>',260,0),(845,'BOCONO',260,0),(846,'HERNANDEZ',260,0),(847,'<NAME>',261,0),(848,'<NAME>',262,0),(849,'CM. <NAME>',263,0),(850,'CM. EL COBRE',264,0),(851,'<NAME>',265,0),(852,'CM. <NAME>',266,0),(853,'<NAME>',267,0),(854,'CM. UMUQUENA',268,0),(855,'BETIJOQUE',269,0),(856,'<NAME>',269,0),(857,'LA PUEBLITA',269,0),(858,'<NAME>',269,0),(859,'BOCONO',270,0),(860,'EL CARMEN',270,0),(861,'MOSQUEY',270,0),(862,'AYACUCHO',270,0),(863,'BURBUSAY',270,0),(864,'GENERAL RIVAS',270,0),(865,'<NAME>',270,0),(866,'<NAME>',270,0),(867,'<NAME>',270,0),(868,'<NAME>',270,0),(869,'GUARAMACAL',270,0),(870,'LA VEGA DE GUARAMACAL',270,0),(871,'CARACHE',271,0),(872,'LA CONCEPCION',271,0),(873,'CUICAS',271,0),(874,'PANAMERICANA',271,0),(875,'<NAME>',271,0),(876,'ESCUQUE',272,0),(877,'<NAME>',272,0),(878,'LA UNION',272,0),(879,'<NAME>',272,0),(880,'<NAME>',273,0),(881,'CHIQUINQUIRA',273,0),(882,'MATRIZ',273,0),(883,'<NAME>',273,0),(884,'<NAME>',273,0),(885,'<NAME>',273,0),(886,'TRES ESQUINAS',273,0),(887,'<NAME>UEBRADA',274,0),(888,'JAJO',274,0),(889,'<NAME>',274,0),(890,'SANTIAGO',274,0),(891,'CABIMBU',274,0),(892,'TUÑAME',274,0),(893,'<NAME>',275,0),(894,'<NAME>',275,0),(895,'<NAME>',275,0),(896,'MENDOZA',275,0),(897,'<NAME>',275,0),(898,'<NAME>',275,0),(899,'CHEJENDE',276,0),(900,'CARRILLO',276,0),(901,'CEGARRA',276,0),(902,'BOLIVIA',276,0),(903,'<NAME>',276,0),(904,'<NAME>',276,0),(905,'<NAME>',276,0),(906,'EL DIVIDIVE',277,0),(907,'<NAME>',277,0),(908,'EL CENIZO',277,0),(909,'<NAME>',277,0),(910,'VALERITA',277,0),(911,'<NAME>',278,0),(912,'<NAME>',278,0),(913,'<NAME>',278,0),(914,'MOTATAN',279,0),(915,'EL BAÑO',279,0),(916,'JALISCO',279,0),(917,'PAMPAN',280,0),(918,'<NAME>',280,0),(919,'<NAME>',280,0),(920,'<NAME>',280,0),(921,'CARVAJAL',281,0),(922,'<NAME>',281,0),(923,'<NAME>',281,0),(924,'<NAME>',281,0),(925,'<NAME>',282,0),(926,'JUNIN',282,0),(927,'<NAME>',282,0),(928,'<NAME>',282,0),(929,'<NAME>',283,0),(930,'ARAGUANEY',283,0),(931,'<NAME>',283,0),(932,'<NAME>',283,0),(933,'<NAME>',284,0),(934,'CHEREGUE',284,0),(935,'GRANADOS',284,0),(936,'<NAME>',285,0),(937,'<NAME>',285,0),(938,'<NAME>',285,0),(939,'<NAME>',286,0),(940,'<NAME>',286,0),(941,'<NAME>',287,0),(942,'<NAME>',287,0),(943,'EL PROGRESO',287,0),(944,'<NAME>',287,0),(945,'PAMPANITO',288,0),(946,'PAMPANITO II',288,0),(947,'LA CONCEPCION',288,0),(948,'<NAME>',289,0),(949,'<NAME>',290,0),(950,'<NAME>',290,0),(951,'<NAME>',291,0),(952,'SALOM',291,0),(953,'TEMERLA',291,0),(954,'<NAME>',292,0),(955,'ALBARICO',292,0),(956,'<NAME>',292,0),(957,'<NAME>',293,0),(958,'<NAME>',294,0),(959,'<NAME>',295,0),(960,'<NAME>',295,0),(961,'<NAME>',296,0),(962,'<NAME>',297,0),(963,'<NAME>',298,0),(964,'CM. INDEPENDENCIA',299,0),(965,'<NAME>',300,0),(966,'<NAME>',301,0),(967,'<NAME>',302,0),(968,'<NAME>',302,0),(969,'<NAME>',303,0),(970,'LIBERTADOR',303,0),(971,'<NAME>',303,0),(972,'<NAME>',303,0),(973,'<NAME>',303,0),(974,'<NAME>',303,0),(975,'<NAME>',304,0),(976,'<NAME>',304,0),(977,'<NAME>',304,0),(978,'<NAME>',304,0),(979,'<NAME>',305,0),(980,'URRIBARRI',305,0),(981,'MORALITO',305,0),(982,'<NAME>',305,0),(983,'<NAME>',305,0),(984,'<NAME>',306,0),(985,'RICAURTE',306,0),(986,'<NAME>',306,0),(987,'<NAME>',306,0),(988,'<NAME>',306,0),(989,'TAMARE',306,0),(990,'<NAME>',306,0),(991,'BOLIVAR',307,0),(992,'COQUIVACOA',307,0),(993,'<NAME>',307,0),(994,'CHIQUINQUIRA',307,0),(995,'<NAME>',307,0),(996,'<NAME>',307,0),(997,'<NAME>',307,0),(998,'<NAME>',307,0),(999,'<NAME>',307,0),(1000,'<NAME>',307,0),(1001,'<NAME>',307,0),(1002,'<NAME>',307,0),(1003,'<NAME>',307,0),(1004,'<NAME>',307,0),(1005,'<NAME>',307,0),(1006,'<NAME>',307,0),(1007,'<NAME>',307,0),(1008,'<NAME>',307,0),(1009,'FARIA',308,0),(1010,'<NAME>',308,0),(1011,'<NAME>',308,0),(1012,'<NAME>',308,0),(1013,'ALTAGRACIA',308,0),(1014,'GOAJIRA',309,0),(1015,'<NAME>',309,0),(1016,'SINAMAICA',309,0),(1017,'<NAME>',309,0),(1018,'<NAME>',310,0),(1019,'<NAME>',310,0),(1020,'LIBERTAD',310,0),(1021,'<NAME>',310,0),(1022,'GIBRALTAR',311,0),(1023,'HERAS',311,0),(1024,'<NAME>',311,0),(1025,'<NAME>',311,0),(1026,'BOBURES',311,0),(1027,'<NAME>',311,0),(1028,'<NAME> (KM 48)',312,0),(1029,'POTRERITOS',312,0),(1030,'<NAME>',312,0),(1031,'CHIQUINQUIRA',312,0),(1032,'CONCEPCION',312,0),(1033,'<NAME>',313,0),(1034,'<NAME>',313,0),(1035,'VENEZUELA',313,0),(1036,'<NAME>',313,0),(1037,'LIBERTAD',313,0),(1038,'<NAME>',314,0),(1039,'ENCONTRADOS',314,0),(1040,'<NAME>',315,0),(1041,'<NAME>',315,0),(1042,'<NAME>',315,0),(1043,'AMBROSIO',316,0),(1044,'<NAME>',316,0),(1045,'<NAME>',316,0),(1046,'<NAME>',316,0),(1047,'<NAME>',316,0),(1048,'<NAME>',316,0),(1049,'<NAME>',316,0),(1050,'<NAME>',316,0),(1051,'<NAME>',316,0),(1052,'<NAME>',317,0),(1053,'LA VICTORIA',317,0),(1054,'<NAME>',317,0),(1055,'<NAME>',318,0),(1056,'LA CONCEPCION',318,0),(1057,'<NAME>',318,0),(1058,'<NAME>',318,0),(1059,'MONAGAS',319,0),(1060,'<NAME>',319,0),(1061,'<NAME>',320,0),(1062,'<NAME>',320,0),(1063,'<NAME>',320,0),(1064,'<NAME>',320,0),(1065,'<NAME>',320,0),(1066,'<NAME>',320,0),(1067,'BARI',321,0),(1068,'<NAME>',321,0),(1069,'<NAME>',322,0),(1070,'<NAME>',322,0),(1071,'<NAME>',322,0),(1072,'<NAME>',323,0),(1073,'<NAME>',323,0),(1074,'<NAME>',323,0),(1075,'<NAME>',324,0),(1076,'<NAME>',324,0),(1077,'PARHUEÑA',324,0),(1078,'PLATANILLAL',324,0),(1079,'CM. S<NAME>',325,0),(1080,'UCATA',325,0),(1081,'YAPACANA',325,0),(1082,'CANAME',325,0),(1083,'CM. MAROA',326,0),(1084,'VICTORINO',326,0),(1085,'COMUNIDAD',326,0),(1086,'CM. S<NAME>',327,0),(1087,'SOLANO',327,0),(1088,'COCUY',327,0),(1089,'CM. <NAME>',328,0),(1090,'SAMARIAPO',328,0),(1091,'SIPAPO',328,0),(1092,'MUNDUAPO',328,0),(1093,'GUAYAPO',328,0),(1094,'CM. SAN <NAME>',329,0),(1095,'ALTO VENTUARI',329,0),(1096,'<NAME>',329,0),(1097,'<NAME>',329,0),(1098,'<NAME>',330,0),(1099,'HUACHAMACARE',330,0),(1100,'MARAWAKA',330,0),(1101,'MAVACA',330,0),(1102,'<NAME>',330,0),(1103,'<NAME>',331,0),(1104,'<NAME>',331,0),(1105,'<NAME>',331,0),(1106,'<NAME>',331,0),(1107,'<NAME>',331,0),(1108,'<NAME>',331,0),(1109,'<NAME>',331,0),(1110,'<NAME>',331,0),(1111,'PEDERNALES',332,0),(1112,'<NAME> <NAME>',332,0),(1113,'CURIAPO',333,0),(1114,'<NAME>',333,0),(1115,'<NAME>',333,0),(1116,'<NAME>',333,0),(1117,'<NAME>',333,0),(1118,'<NAME>',333,0),(1119,'IMATACA',334,0),(1120,'<NAME>',334,0),(1121,'<NAME>',334,0),(1122,'<NAME>',334,0),(1123,'<NAME> JULIO',334,0),(1124,'CARABALLEDA',335,0),(1125,'CARAYACA',335,0),(1126,'CARUAO',335,0),(1127,'<NAME>',335,0),(1128,'<NAME>',335,0),(1129,'MACUTO',335,0),(1130,'MAIQUETIA',335,0),(1131,'NAIGUATA',335,0),(1132,'<NAME>',335,0),(1133,'PQ <NAME>',335,0),(1134,'PQ <NAME>',335,0);
/*!40000 ALTER TABLE `parroquia` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `publicidad`
--

DROP TABLE IF EXISTS `publicidad`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `publicidad` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image` varchar(100) DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  `position` varchar(45) DEFAULT NULL,
  `item_id` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `publicidad`
--

LOCK TABLES `publicidad` WRITE;
/*!40000 ALTER TABLE `publicidad` DISABLE KEYS */;
INSERT INTO `publicidad` VALUES (1,'guacamayastores-01.png',0,NULL,'2015-04-16','top',0),(2,'guacamayastores-02.png',0,NULL,'2015-04-16','left',0),(3,'guacamayastores-03.png',0,NULL,'2015-04-16','right',0),(4,'guacamayastores-08(2).png',0,NULL,'2015-04-16','first',0),(5,'guacamayastores-08(3).png',0,NULL,'2015-04-16','second',0);
/*!40000 ALTER TABLE `publicidad` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `role`
--

DROP TABLE IF EXISTS `role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` varchar(45) DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `role`
--

LOCK TABLES `role` WRITE;
/*!40000 ALTER TABLE `role` DISABLE KEYS */;
INSERT INTO `role` VALUES (1,'Administrador',NULL,NULL),(2,'Usuario',NULL,NULL);
/*!40000 ALTER TABLE `role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `slides`
--

DROP TABLE IF EXISTS `slides`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `slides` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `image` varchar(100) DEFAULT NULL,
  `active` int(11) DEFAULT '0',
  `deleted` int(11) DEFAULT '0',
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  `pos` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `slides`
--

LOCK TABLES `slides` WRITE;
/*!40000 ALTER TABLE `slides` DISABLE KEYS */;
INSERT INTO `slides` VALUES (1,'ny1.jpg',1,0,'2015-04-25','2015-06-15',1),(2,'ny2.jpg',1,0,'2015-04-25','2015-06-15',1),(3,'ny3.jpg',1,0,'2015-04-25','2015-04-25',1),(4,'Sin título-2-02.png',0,1,'2015-04-25','2015-04-25',1),(5,'2.png',0,1,'2015-04-25','2015-05-03',1),(6,'4.gif',0,1,'2015-04-25','2015-05-03',1),(7,'pubpeq.png',0,1,'2015-04-25','2015-05-03',1),(8,'publicidad-03.png',0,1,'2015-04-25','2015-05-03',1),(9,'pubgrande.png',0,1,'2015-04-25','2015-05-03',1),(10,'3(1)(1).png',0,1,'2015-06-11','2015-06-15',2),(12,'1(1).png',0,1,'2015-06-11','2015-06-15',2),(13,'2(1)(1).png',0,1,'2015-06-11','2015-06-11',1),(14,'2(1).png',0,1,'2015-06-11','2015-06-11',1),(15,'1(1)(1).png',0,1,'2015-06-11','2015-06-11',1),(16,'2(1)(1)(1).png',0,1,'2015-06-11','2015-06-11',1),(17,'2(1)(1).png',0,1,'2015-06-11','2015-06-15',1),(18,'3.png',0,1,'2015-06-11','2015-06-15',1),(19,'1(1)(1).png',0,1,'2015-06-11','2015-06-15',2),(20,'2(1)(1)(1).png',1,1,'2015-06-11','2015-06-11',1);
/*!40000 ALTER TABLE `slides` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subcat`
--

DROP TABLE IF EXISTS `subcat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subcat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_id` int(11) NOT NULL,
  `sub_nomb` varchar(100) NOT NULL,
  `sub_desc` varchar(100) NOT NULL,
  `created_at` date NOT NULL,
  `updated_at` date NOT NULL,
  `deleted` int(11) DEFAULT '0',
  `img` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subcat`
--

LOCK TABLES `subcat` WRITE;
/*!40000 ALTER TABLE `subcat` DISABLE KEYS */;
INSERT INTO `subcat` VALUES (1,1,'Anillo','Anillo','2015-04-25','2015-04-25',1,''),(2,3,'top','Top','2015-05-03','2015-05-03',1,NULL),(3,3,'full','full','2015-05-03','2015-05-03',0,'prontog.jpg'),(4,3,'full1','full','2015-05-03','2015-05-03',0,'prontog.jpg'),(5,3,'full2','full','2015-05-03','2015-05-03',0,'prontog.jpg'),(6,3,'full3','full','2015-05-03','2015-05-03',0,'prontog.jpg'),(7,3,'full4','full','2015-05-03','2015-05-03',0,'prontog.jpg'),(8,4,'lalalalal','lalalalal','2015-06-01','2015-06-01',0,'logo.png'),(9,8,'esta categoria','esta categoria','2015-06-01','2015-06-01',0,'maxresdefault.jpg'),(10,8,'bleru bleru','blaaaaar','2015-06-05','2015-06-05',0,'descarga.jpg');
/*!40000 ALTER TABLE `subcat` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tallas`
--

DROP TABLE IF EXISTS `tallas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tallas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `talla_nomb` varchar(20) DEFAULT NULL,
  `talla_desc` varchar(20) DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tallas`
--

LOCK TABLES `tallas` WRITE;
/*!40000 ALTER TABLE `tallas` DISABLE KEYS */;
INSERT INTO `tallas` VALUES (1,'S','tamaño pequeño','2015-03-08','2015-05-03',0),(2,'m','tamaño mediano','2015-03-08','2015-03-08',0),(3,'g','tamaño grandes','2015-03-08','2015-05-03',0),(4,'XL','extra grande','2015-05-03','2015-05-03',1);
/*!40000 ALTER TABLE `tallas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `usuario`
--

DROP TABLE IF EXISTS `usuario`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usuario` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(45) DEFAULT NULL,
  `password` varchar(200) DEFAULT NULL,
  `dir` varchar(255) DEFAULT NULL,
  `email` varchar(45) DEFAULT NULL,
  `telefono` varchar(20) DEFAULT NULL,
  `cedula` varchar(15) DEFAULT NULL,
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  `nombre` varchar(45) DEFAULT NULL,
  `apellido` varchar(45) DEFAULT NULL,
  `role` int(11) NOT NULL DEFAULT '2',
  `user_deleted` int(11) NOT NULL DEFAULT '0',
  `register_cod` varchar(150) NOT NULL,
  `register_cod_active` int(11) NOT NULL DEFAULT '0',
  `remember_token` varchar(255) NOT NULL,
  `dir2` varchar(255) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `department` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `usuario`
--

LOCK TABLES `usuario` WRITE;
/*!40000 ALTER TABLE `usuario` DISABLE KEYS */;
INSERT INTO `usuario` VALUES (1,'admin','$2y$08$E6jwtZftFZMcpA8sOAQzyOdekYpNQp5WHvM.CpWdcxeaCtiEGtWBu',NULL,NULL,NULL,NULL,NULL,'2015-06-11',NULL,NULL,1,0,'',0,'CwrlJPJkCf7EYFushc5qq0bvAl1XJtMRN4SxhHVSRFt6O7QWYPpkNfMIwKG2',NULL,NULL,NULL),(2,'carlos','$2y$08$dykg9ByOMbKqBJuA349tqufDth08T1S9mA.1i2Ij8OzPaXV7tLyJO','   caguaxx','<EMAIL>','123123',NULL,'2015-03-12','2015-06-11','carlos','salazar',0,0,'9b26f36e3f37a5d1841d3599a226e087',0,'lUwW2yrIr5xEKjgJ6Wd2QWqbmRgSMdwP5DkepwXlupycbn8wcrrZS4m4rtjY',NULL,NULL,7),(3,'pepe','$2y$08$PuhuwxUHidbo4qVDatu5UuQVDGYU6.l8kr/rRqCZk2XYRzjaMHCXi',NULL,'<EMAIL>',NULL,NULL,'2015-03-12','2015-07-02','pepe','pepe',0,0,'31fc7f18e6dc5f5d7cb09a40d1fa7115',0,'W754R9johJkDrVA0GbjejJNT0itE8YkT3gma6uIHwXc5mb35RwdAJh84ighZ',NULL,NULL,NULL),(4,'carlosqw','$2y$08$ckqZ644SPK904MS1oiOiiO3.9Uq7ct12XCphVHWOLG4r27LJkkKGS',NULL,'<EMAIL>',NULL,NULL,'2015-04-04','2015-04-04',NULL,NULL,0,0,'',0,'',NULL,NULL,NULL),(5,'pepetonioadminw','$2y$08$sjohuwRyVZqfx9jnid7jAeUYHCGkLEyl0GiKsylpcA7hNWZ7efHI2',NULL,'<EMAIL>',NULL,NULL,'2015-04-04','2015-04-04',NULL,NULL,1,0,'',0,'',NULL,NULL,NULL),(6,'jimenito','$2y$08$AnHgwBwnFv6aK.297At3Q.97nO6w0XkPkRgrd06EEJvj.La8I184S',NULL,'<EMAIL>',NULL,NULL,'2015-04-13','2015-04-13','jimenito','peralta',0,0,'',0,'2bOZ6XRFKjmKwFiZGVTRAqTpIcFb3vDBFBVv0PFKuXVAA6fd1erLGEhsdlog',NULL,NULL,NULL),(7,'felipe','$2y$08$lxDfqvpSFx0I8SKkiiu/LOd1PbXVmQhUnThxD.BRwtR6XlKRvX1D2','je','<EMAIL>',';jfdf','20990979','2015-04-25','2015-04-25','felipe','sosa',3,0,'',0,'dLj7LeD3Tchtpc1tj9ZkA1mAjNa500TK6hA2bQIw6vRX5D2be1ZcJENkllHW',';jfd;ajf','jdfajf;',1),(8,'afaetewqtwqt','$2y$08$Rb6AtlamiBj54M5QjqFOJuQ7rFebP1v9hOLeiQSMvNE37HK1qMObe','adfadf','<EMAIL>','adasdsad','asfaf','2015-06-01','2015-06-01','adfdaf','afadf',3,0,'',0,'','dafadf','afdadf',5),(9,'<EMAIL>','$2y$08$d4jJLd7RvuznUruJw3iZW.VvAryUmFe2Sr9wbTDJfaneE6qvwF7SO',' dfadfdfadf','<EMAIL>','1123123','209909791','2015-06-10','2015-06-19','carlos','salazar',3,0,'',0,'KqcSBfmiTzWWjxP53XxTbJ3Ajd2Q7dI9E3UzBuKKASFGj24ysoz8WVfQNdHk','aaaaaaaaaaaa','dafdfa',1),(10,'<EMAIL>','$2y$08$OjyCINg5o4RRI5jM3kLPMeg5gizM1GqxPJN/R2ZrcFaXhXYTJ9HBe','afafadfadf','<EMAIL>','234235','234234','2015-06-19','2015-06-19','carlos','adsfasfsa',3,0,'',0,'',NULL,'asfasfsaf',0),(11,'<EMAIL>','$2y$08$Ioj93tYTkDLlFsCiV/zdnOtifKI3Hp5Sv6OUODzhs3.11mJs.T0P.','adfadfadf','<EMAIL>',NULL,'20990979123','2015-07-02','2015-07-02','fafsafas','fafasfsafsaf',3,0,'',0,'',NULL,'fadfadf',3),(12,'<EMAIL>','$2y$08$pgonLE5RxbXK8ET/oxmmQ.atrmInPX7/Ok4EALq5MLpblFzeTyXiG','afasfasfsafaf','<EMAIL>',NULL,'123123123123','2015-07-02','2015-07-02','carlos','salazar',3,0,'',0,'',NULL,'afkaskfasf',0);
/*!40000 ALTER TABLE `usuario` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wish_list`
--

DROP TABLE IF EXISTS `wish_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `wish_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `deleted` int(11) DEFAULT '0',
  `created_at` date DEFAULT NULL,
  `updated_at` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wish_list`
--

LOCK TABLES `wish_list` WRITE;
/*!40000 ALTER TABLE `wish_list` DISABLE KEYS */;
INSERT INTO `wish_list` VALUES (1,2,1,0,'2015-06-02','2015-06-02');
/*!40000 ALTER TABLE `wish_list` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2015-07-02 16:04:23
