-- MySQL dump 10.13 Distrib 5.7.25, for Linux (x86_64) -- -- Host: localhost Database: books -- ------------------------------------------------------ -- Server version 5.7.25-0ubuntu0.18.04.2 /*!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 `bautismos` -- DROP TABLE IF EXISTS `bautismos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bautismos` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `libro` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `folio` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `partida` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `church_id` int(10) unsigned DEFAULT NULL, `sacramento_id` int(10) unsigned DEFAULT NULL, `fecha` date DEFAULT NULL, `nombre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_paterno` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_materno` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sexo` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `fecha_nacimiento` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `lugar_nacimiento` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nombre_padre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_paterno_padre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_materno_padre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nombre_madre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_paterno_madre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_materno_madre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nombre_padrino` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_paterno_padrino` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_materno_padrino` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nombre_madrina` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_paterno_madrina` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_materno_madrina` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `libro_civil` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `folio_civil` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `acta_civil` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sacerdote_id` int(10) unsigned DEFAULT NULL, `parroco_id` int(10) unsigned DEFAULT NULL, `notas` text COLLATE utf8mb4_unicode_ci, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `municipio_id` bigint(20) DEFAULT NULL, `estado_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bautismos` -- LOCK TABLES `bautismos` WRITE; /*!40000 ALTER TABLE `bautismos` DISABLE KEYS */; /*!40000 ALTER TABLE `bautismos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `churchs` -- DROP TABLE IF EXISTS `churchs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `churchs` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `colony` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `municipio_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `estado_id` int(11) DEFAULT NULL, `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `postal_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `member_id` int(10) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `current` tinyint(4) DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `churchs` -- LOCK TABLES `churchs` WRITE; /*!40000 ALTER TABLE `churchs` DISABLE KEYS */; /*!40000 ALTER TABLE `churchs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `confirmaciones` -- DROP TABLE IF EXISTS `confirmaciones`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `confirmaciones` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `libro` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `folio` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `partida` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `church_id` int(10) unsigned DEFAULT NULL, `sacramento_id` int(10) unsigned DEFAULT NULL, `fecha` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nombre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_paterno` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_materno` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nombre_padre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_paterno_padre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_materno_padre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nombre_madre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_paterno_madre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_materno_madre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nombre_padrino` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_paterno_padrino` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_materno_padrino` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nombre_madrina` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_paterno_madrina` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_materno_madrina` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sacerdote_id` int(10) unsigned DEFAULT NULL, `parroco_id` int(10) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `church_bautismo_id` int(10) DEFAULT NULL, `fecha_bautismo` date DEFAULT NULL, `estado_id` bigint(20) DEFAULT NULL, `municipio_id` bigint(20) DEFAULT NULL, `folio_bautismo` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `libro_bautismo` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `partida_bautismo` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `confirmaciones` -- LOCK TABLES `confirmaciones` WRITE; /*!40000 ALTER TABLE `confirmaciones` DISABLE KEYS */; /*!40000 ALTER TABLE `confirmaciones` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `estado_municipios` -- DROP TABLE IF EXISTS `estado_municipios`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `estado_municipios` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `estado_id` bigint(20) DEFAULT NULL, `municipio_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2458 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `estado_municipios` -- LOCK TABLES `estado_municipios` WRITE; /*!40000 ALTER TABLE `estado_municipios` DISABLE KEYS */; INSERT INTO `estado_municipios` VALUES (1,1,1),(2,1,2),(3,1,3),(4,1,4),(5,1,5),(6,1,6),(7,1,7),(8,1,8),(9,1,9),(10,1,10),(11,1,11),(12,2,12),(13,2,13),(14,2,14),(15,2,15),(16,2,16),(17,3,17),(18,3,18),(19,3,19),(20,3,20),(21,3,21),(22,4,22),(23,4,23),(24,4,24),(25,4,25),(26,4,26),(27,4,27),(28,4,28),(29,4,29),(30,4,30),(31,4,31),(32,4,32),(33,5,33),(34,5,34),(35,5,35),(36,5,36),(37,5,37),(38,5,38),(39,5,39),(40,5,40),(41,5,41),(42,5,42),(43,5,43),(44,5,44),(45,5,45),(46,5,46),(47,5,47),(48,5,48),(49,5,49),(50,5,50),(51,5,51),(52,5,52),(53,5,53),(54,5,54),(55,5,55),(56,5,56),(57,5,57),(58,5,58),(59,5,59),(60,5,60),(61,5,61),(62,5,62),(63,5,63),(64,5,64),(65,5,65),(66,5,66),(67,5,67),(68,5,68),(69,5,69),(70,5,70),(71,6,71),(72,6,72),(73,6,73),(74,6,74),(75,6,75),(76,6,76),(77,6,77),(78,6,78),(79,6,79),(80,6,80),(81,7,81),(82,7,82),(83,7,83),(84,7,84),(85,7,85),(86,7,86),(87,7,87),(88,7,88),(89,7,89),(90,7,90),(91,7,91),(92,7,92),(93,7,93),(94,7,94),(95,7,95),(96,7,96),(97,7,97),(98,7,98),(99,7,99),(100,7,100),(101,7,101),(102,7,102),(103,7,103),(104,7,104),(105,7,105),(106,7,106),(107,7,107),(108,7,108),(109,7,109),(110,7,110),(111,7,111),(112,7,112),(113,7,113),(114,7,114),(115,7,115),(116,7,116),(117,7,117),(118,7,118),(119,7,119),(120,7,120),(121,7,121),(122,7,122),(123,7,123),(124,7,124),(125,7,125),(126,7,126),(127,7,127),(128,7,128),(129,7,129),(130,7,130),(131,7,131),(132,7,132),(133,7,133),(134,7,134),(135,7,135),(136,7,136),(137,7,137),(138,7,138),(139,7,139),(140,7,140),(141,7,141),(142,7,142),(143,7,143),(144,7,144),(145,7,145),(146,7,146),(147,7,147),(148,7,148),(149,7,149),(150,7,150),(151,7,151),(152,7,152),(153,7,153),(154,7,154),(155,7,155),(156,7,156),(157,7,157),(158,7,158),(159,7,159),(160,7,160),(161,7,161),(162,7,162),(163,7,163),(164,7,164),(165,7,165),(166,7,166),(167,7,167),(168,7,168),(169,7,169),(170,7,170),(171,7,171),(172,7,172),(173,7,173),(174,7,174),(175,7,175),(176,7,176),(177,7,177),(178,7,178),(179,7,179),(180,7,180),(181,7,181),(182,7,182),(183,7,183),(184,7,184),(185,7,185),(186,7,186),(187,7,187),(188,7,188),(189,7,189),(190,7,190),(191,7,191),(192,7,192),(193,7,193),(194,7,194),(195,7,195),(196,7,196),(197,7,197),(198,7,198),(199,8,199),(200,8,200),(201,8,201),(202,8,202),(203,8,203),(204,8,204),(205,8,205),(206,8,206),(207,8,207),(208,8,208),(209,8,209),(210,8,210),(211,8,211),(212,8,212),(213,8,213),(214,8,214),(215,8,215),(216,8,216),(217,8,217),(218,8,218),(219,8,219),(220,8,220),(221,8,221),(222,8,222),(223,8,223),(224,8,224),(225,8,225),(226,8,226),(227,8,227),(228,8,228),(229,8,229),(230,8,230),(231,8,231),(232,8,232),(233,8,233),(234,8,234),(235,8,235),(236,8,236),(237,8,237),(238,8,238),(239,8,239),(240,8,240),(241,8,241),(242,8,242),(243,8,243),(244,8,244),(245,8,245),(246,8,246),(247,8,247),(248,8,248),(249,8,249),(250,8,250),(251,8,251),(252,8,252),(253,8,253),(254,8,254),(255,8,255),(256,8,256),(257,8,257),(258,8,258),(259,8,259),(260,8,260),(261,8,261),(262,8,262),(263,8,263),(264,8,264),(265,8,265),(266,9,266),(267,9,267),(268,9,268),(269,9,269),(270,9,270),(271,9,271),(272,9,272),(273,9,273),(274,9,274),(275,9,275),(276,9,276),(277,9,277),(278,9,278),(279,9,279),(280,9,280),(281,9,281),(282,10,282),(283,10,283),(284,10,284),(285,10,285),(286,10,286),(287,10,287),(288,10,288),(289,10,289),(290,10,290),(291,10,291),(292,10,292),(293,10,293),(294,10,294),(295,10,295),(296,10,296),(297,10,297),(298,10,298),(299,10,299),(300,10,300),(301,10,301),(302,10,302),(303,10,303),(304,10,304),(305,10,305),(306,10,306),(307,10,307),(308,10,308),(309,10,309),(310,10,310),(311,10,311),(312,10,312),(313,10,313),(314,10,314),(315,10,315),(316,10,316),(317,10,317),(318,10,318),(319,10,319),(320,10,320),(321,11,321),(322,11,322),(323,11,323),(324,11,324),(325,11,325),(326,11,326),(327,11,327),(328,11,328),(329,11,329),(330,11,330),(331,11,331),(332,11,332),(333,11,333),(334,11,334),(335,11,335),(336,11,336),(337,11,337),(338,11,338),(339,11,339),(340,11,340),(341,11,341),(342,11,342),(343,11,343),(344,11,344),(345,11,345),(346,11,346),(347,11,347),(348,11,348),(349,11,349),(350,11,350),(351,11,351),(352,11,352),(353,11,353),(354,11,354),(355,11,355),(356,11,356),(357,11,357),(358,11,358),(359,11,359),(360,11,360),(361,11,361),(362,11,362),(363,11,363),(364,11,364),(365,11,365),(366,11,366),(367,12,367),(368,12,368),(369,12,369),(370,12,370),(371,12,371),(372,12,372),(373,12,373),(374,12,374),(375,12,375),(376,12,376),(377,12,377),(378,12,378),(379,12,379),(380,12,380),(381,12,381),(382,12,382),(383,12,383),(384,12,384),(385,12,385),(386,12,386),(387,12,387),(388,12,388),(389,12,389),(390,12,390),(391,12,391),(392,12,392),(393,12,393),(394,12,394),(395,12,395),(396,12,396),(397,12,397),(398,12,398),(399,12,399),(400,12,400),(401,12,401),(402,12,402),(403,12,403),(404,12,404),(405,12,405),(406,12,406),(407,12,407),(408,12,408),(409,12,409),(410,12,410),(411,12,411),(412,12,412),(413,12,413),(414,12,414),(415,12,415),(416,12,416),(417,12,417),(418,12,418),(419,12,419),(420,12,420),(421,12,421),(422,12,422),(423,12,423),(424,12,424),(425,12,425),(426,12,426),(427,12,427),(428,12,428),(429,12,429),(430,12,430),(431,12,431),(432,12,432),(433,12,433),(434,12,434),(435,12,435),(436,12,436),(437,12,437),(438,12,438),(439,12,439),(440,12,440),(441,12,441),(442,12,442),(443,12,443),(444,12,444),(445,12,445),(446,12,446),(447,12,447),(448,13,448),(449,13,449),(450,13,450),(451,13,451),(452,13,452),(453,13,453),(454,13,454),(455,13,455),(456,13,456),(457,13,457),(458,13,458),(459,13,459),(460,13,460),(461,13,461),(462,13,462),(463,13,463),(464,13,464),(465,13,465),(466,13,466),(467,13,467),(468,13,468),(469,13,469),(470,13,470),(471,13,471),(472,13,472),(473,13,473),(474,13,474),(475,13,475),(476,13,476),(477,13,477),(478,13,478),(479,13,479),(480,13,480),(481,13,481),(482,13,482),(483,13,483),(484,13,484),(485,13,485),(486,13,486),(487,13,487),(488,13,488),(489,13,489),(490,13,490),(491,13,491),(492,13,492),(493,13,493),(494,13,494),(495,13,495),(496,13,496),(497,13,497),(498,13,498),(499,13,499),(500,13,500),(501,13,501),(502,13,502),(503,13,503),(504,13,504),(505,13,505),(506,13,506),(507,13,507),(508,13,508),(509,13,509),(510,13,510),(511,13,511),(512,13,512),(513,13,513),(514,13,514),(515,13,515),(516,13,516),(517,13,517),(518,13,518),(519,13,519),(520,13,520),(521,13,521),(522,13,522),(523,13,523),(524,13,524),(525,13,525),(526,13,526),(527,13,527),(528,13,528),(529,13,529),(530,13,530),(531,13,531),(532,14,532),(533,14,533),(534,14,534),(535,14,535),(536,14,536),(537,14,537),(538,14,538),(539,14,539),(540,14,540),(541,14,541),(542,14,542),(543,14,543),(544,14,544),(545,14,545),(546,14,546),(547,14,547),(548,14,548),(549,14,549),(550,14,550),(551,14,551),(552,14,552),(553,14,553),(554,14,554),(555,14,555),(556,14,556),(557,14,557),(558,14,558),(559,14,559),(560,14,560),(561,14,561),(562,14,562),(563,14,563),(564,14,564),(565,14,565),(566,14,566),(567,14,567),(568,14,568),(569,14,569),(570,14,570),(571,14,571),(572,14,572),(573,14,573),(574,14,574),(575,14,575),(576,14,576),(577,14,577),(578,14,578),(579,14,579),(580,14,580),(581,14,581),(582,14,582),(583,14,583),(584,14,584),(585,14,585),(586,14,586),(587,14,587),(588,14,588),(589,14,589),(590,14,590),(591,14,591),(592,14,592),(593,14,593),(594,14,594),(595,14,595),(596,14,596),(597,14,597),(598,14,598),(599,14,599),(600,14,600),(601,14,601),(602,14,602),(603,14,603),(604,14,604),(605,14,605),(606,14,606),(607,14,607),(608,14,608),(609,14,609),(610,14,610),(611,14,611),(612,14,612),(613,14,613),(614,14,614),(615,14,615),(616,14,616),(617,14,617),(618,14,618),(619,14,619),(620,14,620),(621,14,621),(622,14,622),(623,14,623),(624,14,624),(625,14,625),(626,14,626),(627,14,627),(628,14,628),(629,14,629),(630,14,630),(631,14,631),(632,14,632),(633,14,633),(634,14,634),(635,14,635),(636,14,636),(637,14,637),(638,14,638),(639,14,639),(640,14,640),(641,14,641),(642,14,642),(643,14,643),(644,14,644),(645,14,645),(646,14,646),(647,14,647),(648,14,648),(649,14,649),(650,14,650),(651,14,651),(652,14,652),(653,14,653),(654,14,654),(655,14,655),(656,14,656),(657,15,657),(658,15,658),(659,15,659),(660,15,660),(661,15,661),(662,15,662),(663,15,663),(664,15,664),(665,15,665),(666,15,666),(667,15,667),(668,15,668),(669,15,669),(670,15,670),(671,15,671),(672,15,672),(673,15,673),(674,15,674),(675,15,675),(676,15,676),(677,15,677),(678,15,678),(679,15,679),(680,15,680),(681,15,681),(682,15,682),(683,15,683),(684,15,684),(685,15,685),(686,15,686),(687,15,687),(688,15,688),(689,15,689),(690,15,690),(691,15,691),(692,15,692),(693,15,693),(694,15,694),(695,15,695),(696,15,696),(697,15,697),(698,15,698),(699,15,699),(700,15,700),(701,15,701),(702,15,702),(703,15,703),(704,15,704),(705,15,705),(706,15,706),(707,15,707),(708,15,708),(709,15,709),(710,15,710),(711,15,711),(712,15,712),(713,15,713),(714,15,714),(715,15,715),(716,15,716),(717,15,717),(718,15,718),(719,15,719),(720,15,720),(721,15,721),(722,15,722),(723,15,723),(724,15,724),(725,15,725),(726,15,726),(727,15,727),(728,15,728),(729,15,729),(730,15,730),(731,15,731),(732,15,732),(733,15,733),(734,15,734),(735,15,735),(736,15,736),(737,15,737),(738,15,738),(739,15,739),(740,15,740),(741,15,741),(742,15,742),(743,15,743),(744,15,744),(745,15,745),(746,15,746),(747,15,747),(748,15,748),(749,15,749),(750,15,750),(751,15,751),(752,15,752),(753,15,753),(754,15,754),(755,15,755),(756,15,756),(757,15,757),(758,15,758),(759,15,759),(760,15,760),(761,15,761),(762,15,762),(763,15,763),(764,15,764),(765,15,765),(766,15,766),(767,15,767),(768,15,768),(769,15,769),(770,15,770),(771,15,771),(772,15,772),(773,15,773),(774,15,774),(775,15,775),(776,15,776),(777,15,777),(778,15,778),(779,15,779),(780,15,780),(781,15,781),(782,16,782),(783,16,783),(784,16,784),(785,16,785),(786,16,786),(787,16,787),(788,16,788),(789,16,789),(790,16,790),(791,16,791),(792,16,792),(793,16,793),(794,16,794),(795,16,795),(796,16,796),(797,16,797),(798,16,798),(799,16,799),(800,16,800),(801,16,801),(802,16,802),(803,16,803),(804,16,804),(805,16,805),(806,16,806),(807,16,807),(808,16,808),(809,16,809),(810,16,810),(811,16,811),(812,16,812),(813,16,813),(814,16,814),(815,16,815),(816,16,816),(817,16,817),(818,16,818),(819,16,819),(820,16,820),(821,16,821),(822,16,822),(823,16,823),(824,16,824),(825,16,825),(826,16,826),(827,16,827),(828,16,828),(829,16,829),(830,16,830),(831,16,831),(832,16,832),(833,16,833),(834,16,834),(835,16,835),(836,16,836),(837,16,837),(838,16,838),(839,16,839),(840,16,840),(841,16,841),(842,16,842),(843,16,843),(844,16,844),(845,16,845),(846,16,846),(847,16,847),(848,16,848),(849,16,849),(850,16,850),(851,16,851),(852,16,852),(853,16,853),(854,16,854),(855,16,855),(856,16,856),(857,16,857),(858,16,858),(859,16,859),(860,16,860),(861,16,861),(862,16,862),(863,16,863),(864,16,864),(865,16,865),(866,16,866),(867,16,867),(868,16,868),(869,16,869),(870,16,870),(871,16,871),(872,16,872),(873,16,873),(874,16,874),(875,16,875),(876,16,876),(877,16,877),(878,16,878),(879,16,879),(880,16,880),(881,16,881),(882,16,882),(883,16,883),(884,16,884),(885,16,885),(886,16,886),(887,16,887),(888,16,888),(889,16,889),(890,16,890),(891,16,891),(892,16,892),(893,16,893),(894,16,894),(895,17,895),(896,17,896),(897,17,897),(898,17,898),(899,17,899),(900,17,900),(901,17,901),(902,17,902),(903,17,903),(904,17,904),(905,17,905),(906,17,906),(907,17,907),(908,17,908),(909,17,909),(910,17,910),(911,17,911),(912,17,912),(913,17,913),(914,17,914),(915,17,915),(916,17,916),(917,17,917),(918,17,918),(919,17,919),(920,17,920),(921,17,921),(922,17,922),(923,17,923),(924,17,924),(925,17,925),(926,17,926),(927,17,927),(928,18,928),(929,18,929),(930,18,930),(931,18,931),(932,18,932),(933,18,933),(934,18,934),(935,18,935),(936,18,936),(937,18,937),(938,18,938),(939,18,939),(940,18,940),(941,18,941),(942,18,942),(943,18,943),(944,18,944),(945,18,945),(946,18,946),(947,18,947),(948,19,948),(949,19,949),(950,19,950),(951,19,951),(952,19,952),(953,19,953),(954,19,954),(955,19,955),(956,19,956),(957,19,957),(958,19,958),(959,19,959),(960,19,960),(961,19,961),(962,19,962),(963,19,963),(964,19,964),(965,19,965),(966,19,966),(967,19,967),(968,19,968),(969,19,969),(970,19,970),(971,19,971),(972,19,972),(973,19,973),(974,19,974),(975,19,975),(976,19,976),(977,19,977),(978,19,978),(979,19,979),(980,19,980),(981,19,981),(982,19,982),(983,19,983),(984,19,984),(985,19,985),(986,19,986),(987,19,987),(988,19,988),(989,19,989),(990,19,990),(991,19,991),(992,19,992),(993,19,993),(994,19,994),(995,19,995),(996,19,996),(997,19,997),(998,19,998),(999,20,999),(1000,20,1000),(1001,20,1001),(1002,20,1002),(1003,20,1003),(1004,20,1004),(1005,20,1005),(1006,20,1006),(1007,20,1007),(1008,20,1008),(1009,20,1009),(1010,20,1010),(1011,20,1011),(1012,20,1012),(1013,20,1013),(1014,20,1014),(1015,20,1015),(1016,20,1016),(1017,20,1017),(1018,20,1018),(1019,20,1019),(1020,20,1020),(1021,20,1021),(1022,20,1022),(1023,20,1023),(1024,20,1024),(1025,20,1025),(1026,20,1026),(1027,20,1027),(1028,20,1028),(1029,20,1029),(1030,20,1030),(1031,20,1031),(1032,20,1032),(1033,20,1033),(1034,20,1034),(1035,20,1035),(1036,20,1036),(1037,20,1037),(1038,20,1038),(1039,20,1039),(1040,20,1040),(1041,20,1041),(1042,20,1042),(1043,20,1043),(1044,20,1044),(1045,20,1045),(1046,20,1046),(1047,20,1047),(1048,20,1048),(1049,20,1049),(1050,20,1050),(1051,20,1051),(1052,20,1052),(1053,20,1053),(1054,20,1054),(1055,20,1055),(1056,20,1056),(1057,20,1057),(1058,20,1058),(1059,20,1059),(1060,20,1060),(1061,20,1061),(1062,20,1062),(1063,20,1063),(1064,20,1064),(1065,20,1065),(1066,20,1066),(1067,20,1067),(1068,20,1068),(1069,20,1069),(1070,20,1070),(1071,20,1071),(1072,20,1072),(1073,20,1073),(1074,20,1074),(1075,20,1075),(1076,20,1076),(1077,20,1077),(1078,20,1078),(1079,20,1079),(1080,20,1080),(1081,20,1081),(1082,20,1082),(1083,20,1083),(1084,20,1084),(1085,20,1085),(1086,20,1086),(1087,20,1087),(1088,20,1088),(1089,20,1089),(1090,20,1090),(1091,20,1091),(1092,20,1092),(1093,20,1093),(1094,20,1094),(1095,20,1095),(1096,20,1096),(1097,20,1097),(1098,20,1098),(1099,20,1099),(1100,20,1100),(1101,20,1101),(1102,20,1102),(1103,20,1103),(1104,20,1104),(1105,20,1105),(1106,20,1106),(1107,20,1107),(1108,20,1108),(1109,20,1109),(1110,20,1110),(1111,20,1111),(1112,20,1112),(1113,20,1113),(1114,20,1114),(1115,20,1115),(1116,20,1116),(1117,20,1117),(1118,20,1118),(1119,20,1119),(1120,20,1120),(1121,20,1121),(1122,20,1122),(1123,20,1123),(1124,20,1124),(1125,20,1125),(1126,20,1126),(1127,20,1127),(1128,20,1128),(1129,20,1129),(1130,20,1130),(1131,20,1131),(1132,20,1132),(1133,20,1133),(1134,20,1134),(1135,20,1135),(1136,20,1136),(1137,20,1137),(1138,20,1138),(1139,20,1139),(1140,20,1140),(1141,20,1141),(1142,20,1142),(1143,20,1143),(1144,20,1144),(1145,20,1145),(1146,20,1146),(1147,20,1147),(1148,20,1148),(1149,20,1149),(1150,20,1150),(1151,20,1151),(1152,20,1152),(1153,20,1153),(1154,20,1154),(1155,20,1155),(1156,20,1156),(1157,20,1157),(1158,20,1158),(1159,20,1159),(1160,20,1160),(1161,20,1161),(1162,20,1162),(1163,20,1163),(1164,20,1164),(1165,20,1165),(1166,20,1166),(1167,20,1167),(1168,20,1168),(1169,20,1169),(1170,20,1170),(1171,20,1171),(1172,20,1172),(1173,20,1173),(1174,20,1174),(1175,20,1175),(1176,20,1176),(1177,20,1177),(1178,20,1178),(1179,20,1179),(1180,20,1180),(1181,20,1181),(1182,20,1182),(1183,20,1183),(1184,20,1184),(1185,20,1185),(1186,20,1186),(1187,20,1187),(1188,20,1188),(1189,20,1189),(1190,20,1190),(1191,20,1191),(1192,20,1192),(1193,20,1193),(1194,20,1194),(1195,20,1195),(1196,20,1196),(1197,20,1197),(1198,20,1198),(1199,20,1199),(1200,20,1200),(1201,20,1201),(1202,20,1202),(1203,20,1203),(1204,20,1204),(1205,20,1205),(1206,20,1206),(1207,20,1207),(1208,20,1208),(1209,20,1209),(1210,20,1210),(1211,20,1211),(1212,20,1212),(1213,20,1213),(1214,20,1214),(1215,20,1215),(1216,20,1216),(1217,20,1217),(1218,20,1218),(1219,20,1219),(1220,20,1220),(1221,20,1221),(1222,20,1222),(1223,20,1223),(1224,20,1224),(1225,20,1225),(1226,20,1226),(1227,20,1227),(1228,20,1228),(1229,20,1229),(1230,20,1230),(1231,20,1231),(1232,20,1232),(1233,20,1233),(1234,20,1234),(1235,20,1235),(1236,20,1236),(1237,20,1237),(1238,20,1238),(1239,20,1239),(1240,20,1240),(1241,20,1241),(1242,20,1242),(1243,20,1243),(1244,20,1244),(1245,20,1245),(1246,20,1246),(1247,20,1247),(1248,20,1248),(1249,20,1249),(1250,20,1250),(1251,20,1251),(1252,20,1252),(1253,20,1253),(1254,20,1254),(1255,20,1255),(1256,20,1256),(1257,20,1257),(1258,20,1258),(1259,20,1259),(1260,20,1260),(1261,20,1261),(1262,20,1262),(1263,20,1263),(1264,20,1264),(1265,20,1265),(1266,20,1266),(1267,20,1267),(1268,20,1268),(1269,20,1269),(1270,20,1270),(1271,20,1271),(1272,20,1272),(1273,20,1273),(1274,20,1274),(1275,20,1275),(1276,20,1276),(1277,20,1277),(1278,20,1278),(1279,20,1279),(1280,20,1280),(1281,20,1281),(1282,20,1282),(1283,20,1283),(1284,20,1284),(1285,20,1285),(1286,20,1286),(1287,20,1287),(1288,20,1288),(1289,20,1289),(1290,20,1290),(1291,20,1291),(1292,20,1292),(1293,20,1293),(1294,20,1294),(1295,20,1295),(1296,20,1296),(1297,20,1297),(1298,20,1298),(1299,20,1299),(1300,20,1300),(1301,20,1301),(1302,20,1302),(1303,20,1303),(1304,20,1304),(1305,20,1305),(1306,20,1306),(1307,20,1307),(1308,20,1308),(1309,20,1309),(1310,20,1310),(1311,20,1311),(1312,20,1312),(1313,20,1313),(1314,20,1314),(1315,20,1315),(1316,20,1316),(1317,20,1317),(1318,20,1318),(1319,20,1319),(1320,20,1320),(1321,20,1321),(1322,20,1322),(1323,20,1323),(1324,20,1324),(1325,20,1325),(1326,20,1326),(1327,20,1327),(1328,20,1328),(1329,20,1329),(1330,20,1330),(1331,20,1331),(1332,20,1332),(1333,20,1333),(1334,20,1334),(1335,20,1335),(1336,20,1336),(1337,20,1337),(1338,20,1338),(1339,20,1339),(1340,20,1340),(1341,20,1341),(1342,20,1342),(1343,20,1343),(1344,20,1344),(1345,20,1345),(1346,20,1346),(1347,20,1347),(1348,20,1348),(1349,20,1349),(1350,20,1350),(1351,20,1351),(1352,20,1352),(1353,20,1353),(1354,20,1354),(1355,20,1355),(1356,20,1356),(1357,20,1357),(1358,20,1358),(1359,20,1359),(1360,20,1360),(1361,20,1361),(1362,20,1362),(1363,20,1363),(1364,20,1364),(1365,20,1365),(1366,20,1366),(1367,20,1367),(1368,20,1368),(1369,20,1369),(1370,20,1370),(1371,20,1371),(1372,20,1372),(1373,20,1373),(1374,20,1374),(1375,20,1375),(1376,20,1376),(1377,20,1377),(1378,20,1378),(1379,20,1379),(1380,20,1380),(1381,20,1381),(1382,20,1382),(1383,20,1383),(1384,20,1384),(1385,20,1385),(1386,20,1386),(1387,20,1387),(1388,20,1388),(1389,20,1389),(1390,20,1390),(1391,20,1391),(1392,20,1392),(1393,20,1393),(1394,20,1394),(1395,20,1395),(1396,20,1396),(1397,20,1397),(1398,20,1398),(1399,20,1399),(1400,20,1400),(1401,20,1401),(1402,20,1402),(1403,20,1403),(1404,20,1404),(1405,20,1405),(1406,20,1406),(1407,20,1407),(1408,20,1408),(1409,20,1409),(1410,20,1410),(1411,20,1411),(1412,20,1412),(1413,20,1413),(1414,20,1414),(1415,20,1415),(1416,20,1416),(1417,20,1417),(1418,20,1418),(1419,20,1419),(1420,20,1420),(1421,20,1421),(1422,20,1422),(1423,20,1423),(1424,20,1424),(1425,20,1425),(1426,20,1426),(1427,20,1427),(1428,20,1428),(1429,20,1429),(1430,20,1430),(1431,20,1431),(1432,20,1432),(1433,20,1433),(1434,20,1434),(1435,20,1435),(1436,20,1436),(1437,20,1437),(1438,20,1438),(1439,20,1439),(1440,20,1440),(1441,20,1441),(1442,20,1442),(1443,20,1443),(1444,20,1444),(1445,20,1445),(1446,20,1446),(1447,20,1447),(1448,20,1448),(1449,20,1449),(1450,20,1450),(1451,20,1451),(1452,20,1452),(1453,20,1453),(1454,20,1454),(1455,20,1455),(1456,20,1456),(1457,20,1457),(1458,20,1458),(1459,20,1459),(1460,20,1460),(1461,20,1461),(1462,20,1462),(1463,20,1463),(1464,20,1464),(1465,20,1465),(1466,20,1466),(1467,20,1467),(1468,20,1468),(1469,20,1469),(1470,20,1470),(1471,20,1471),(1472,20,1472),(1473,20,1473),(1474,20,1474),(1475,20,1475),(1476,20,1476),(1477,20,1477),(1478,20,1478),(1479,20,1479),(1480,20,1480),(1481,20,1481),(1482,20,1482),(1483,20,1483),(1484,20,1484),(1485,20,1485),(1486,20,1486),(1487,20,1487),(1488,20,1488),(1489,20,1489),(1490,20,1490),(1491,20,1491),(1492,20,1492),(1493,20,1493),(1494,20,1494),(1495,20,1495),(1496,20,1496),(1497,20,1497),(1498,20,1498),(1499,20,1499),(1500,20,1500),(1501,20,1501),(1502,20,1502),(1503,20,1503),(1504,20,1504),(1505,20,1505),(1506,20,1506),(1507,20,1507),(1508,20,1508),(1509,20,1509),(1510,20,1510),(1511,20,1511),(1512,20,1512),(1513,20,1513),(1514,20,1514),(1515,20,1515),(1516,20,1516),(1517,20,1517),(1518,20,1518),(1519,20,1519),(1520,20,1520),(1521,20,1521),(1522,20,1522),(1523,20,1523),(1524,20,1524),(1525,20,1525),(1526,20,1526),(1527,20,1527),(1528,20,1528),(1529,20,1529),(1530,20,1530),(1531,20,1531),(1532,20,1532),(1533,20,1533),(1534,20,1534),(1535,20,1535),(1536,20,1536),(1537,20,1537),(1538,20,1538),(1539,20,1539),(1540,20,1540),(1541,20,1541),(1542,20,1542),(1543,20,1543),(1544,20,1544),(1545,20,1545),(1546,20,1546),(1547,20,1547),(1548,20,1548),(1549,20,1549),(1550,20,1550),(1551,20,1551),(1552,20,1552),(1553,20,1553),(1554,20,1554),(1555,20,1555),(1556,20,1556),(1557,20,1557),(1558,20,1558),(1559,20,1559),(1560,20,1560),(1561,20,1561),(1562,20,1562),(1563,20,1563),(1564,20,1564),(1565,20,1565),(1566,20,1566),(1567,20,1567),(1568,20,1568),(1569,21,1569),(1570,21,1570),(1571,21,1571),(1572,21,1572),(1573,21,1573),(1574,21,1574),(1575,21,1575),(1576,21,1576),(1577,21,1577),(1578,21,1578),(1579,21,1579),(1580,21,1580),(1581,21,1581),(1582,21,1582),(1583,21,1583),(1584,21,1584),(1585,21,1585),(1586,21,1586),(1587,21,1587),(1588,21,1588),(1589,21,1589),(1590,21,1590),(1591,21,1591),(1592,21,1592),(1593,21,1593),(1594,21,1594),(1595,21,1595),(1596,21,1596),(1597,21,1597),(1598,21,1598),(1599,21,1599),(1600,21,1600),(1601,21,1601),(1602,21,1602),(1603,21,1603),(1604,21,1604),(1605,21,1605),(1606,21,1606),(1607,21,1607),(1608,21,1608),(1609,21,1609),(1610,21,1610),(1611,21,1611),(1612,21,1612),(1613,21,1613),(1614,21,1614),(1615,21,1615),(1616,21,1616),(1617,21,1617),(1618,21,1618),(1619,21,1619),(1620,21,1620),(1621,21,1621),(1622,21,1622),(1623,21,1623),(1624,21,1624),(1625,21,1625),(1626,21,1626),(1627,21,1627),(1628,21,1628),(1629,21,1629),(1630,21,1630),(1631,21,1631),(1632,21,1632),(1633,21,1633),(1634,21,1634),(1635,21,1635),(1636,21,1636),(1637,21,1637),(1638,21,1638),(1639,21,1639),(1640,21,1640),(1641,21,1641),(1642,21,1642),(1643,21,1643),(1644,21,1644),(1645,21,1645),(1646,21,1646),(1647,21,1647),(1648,21,1648),(1649,21,1649),(1650,21,1650),(1651,21,1651),(1652,21,1652),(1653,21,1653),(1654,21,1654),(1655,21,1655),(1656,21,1656),(1657,21,1657),(1658,21,1658),(1659,21,1659),(1660,21,1660),(1661,21,1661),(1662,21,1662),(1663,21,1663),(1664,21,1664),(1665,21,1665),(1666,21,1666),(1667,21,1667),(1668,21,1668),(1669,21,1669),(1670,21,1670),(1671,21,1671),(1672,21,1672),(1673,21,1673),(1674,21,1674),(1675,21,1675),(1676,21,1676),(1677,21,1677),(1678,21,1678),(1679,21,1679),(1680,21,1680),(1681,21,1681),(1682,21,1682),(1683,21,1683),(1684,21,1684),(1685,21,1685),(1686,21,1686),(1687,21,1687),(1688,21,1688),(1689,21,1689),(1690,21,1690),(1691,21,1691),(1692,21,1692),(1693,21,1693),(1694,21,1694),(1695,21,1695),(1696,21,1696),(1697,21,1697),(1698,21,1698),(1699,21,1699),(1700,21,1700),(1701,21,1701),(1702,21,1702),(1703,21,1703),(1704,21,1704),(1705,21,1705),(1706,21,1706),(1707,21,1707),(1708,21,1708),(1709,21,1709),(1710,21,1710),(1711,21,1711),(1712,21,1712),(1713,21,1713),(1714,21,1714),(1715,21,1715),(1716,21,1716),(1717,21,1717),(1718,21,1718),(1719,21,1719),(1720,21,1720),(1721,21,1721),(1722,21,1722),(1723,21,1723),(1724,21,1724),(1725,21,1725),(1726,21,1726),(1727,21,1727),(1728,21,1728),(1729,21,1729),(1730,21,1730),(1731,21,1731),(1732,21,1732),(1733,21,1733),(1734,21,1734),(1735,21,1735),(1736,21,1736),(1737,21,1737),(1738,21,1738),(1739,21,1739),(1740,21,1740),(1741,21,1741),(1742,21,1742),(1743,21,1743),(1744,21,1744),(1745,21,1745),(1746,21,1746),(1747,21,1747),(1748,21,1748),(1749,21,1749),(1750,21,1750),(1751,21,1751),(1752,21,1752),(1753,21,1753),(1754,21,1754),(1755,21,1755),(1756,21,1756),(1757,21,1757),(1758,21,1758),(1759,21,1759),(1760,21,1760),(1761,21,1761),(1762,21,1762),(1763,21,1763),(1764,21,1764),(1765,21,1765),(1766,21,1766),(1767,21,1767),(1768,21,1768),(1769,21,1769),(1770,21,1770),(1771,21,1771),(1772,21,1772),(1773,21,1773),(1774,21,1774),(1775,21,1775),(1776,21,1776),(1777,21,1777),(1778,21,1778),(1779,21,1779),(1780,21,1780),(1781,21,1781),(1782,21,1782),(1783,21,1783),(1784,21,1784),(1785,21,1785),(1786,22,1786),(1787,22,1787),(1788,22,1788),(1789,22,1789),(1790,22,1790),(1791,22,1791),(1792,22,1792),(1793,22,1793),(1794,22,1794),(1795,22,1795),(1796,22,1796),(1797,22,1797),(1798,22,1798),(1799,22,1799),(1800,22,1800),(1801,22,1801),(1802,22,1802),(1803,22,1803),(1804,23,1804),(1805,23,1805),(1806,23,1806),(1807,23,1807),(1808,23,1808),(1809,23,1809),(1810,23,1810),(1811,23,1811),(1812,23,1812),(1813,23,1813),(1814,24,1814),(1815,24,1815),(1816,24,1816),(1817,24,1817),(1818,24,1818),(1819,24,1819),(1820,24,1820),(1821,24,1821),(1822,24,1822),(1823,24,1823),(1824,24,1824),(1825,24,1825),(1826,24,1826),(1827,24,1827),(1828,24,1828),(1829,24,1829),(1830,24,1830),(1831,24,1831),(1832,24,1832),(1833,24,1833),(1834,24,1834),(1835,24,1835),(1836,24,1836),(1837,24,1837),(1838,24,1838),(1839,24,1839),(1840,24,1840),(1841,24,1841),(1842,24,1842),(1843,24,1843),(1844,24,1844),(1845,24,1845),(1846,24,1846),(1847,24,1847),(1848,24,1848),(1849,24,1849),(1850,24,1850),(1851,24,1851),(1852,24,1852),(1853,24,1853),(1854,24,1854),(1855,24,1855),(1856,24,1856),(1857,24,1857),(1858,24,1858),(1859,24,1859),(1860,24,1860),(1861,24,1861),(1862,24,1862),(1863,24,1863),(1864,24,1864),(1865,24,1865),(1866,24,1866),(1867,24,1867),(1868,24,1868),(1869,24,1869),(1870,24,1870),(1871,24,1871),(1872,25,1872),(1873,25,1873),(1874,25,1874),(1875,25,1875),(1876,25,1876),(1877,25,1877),(1878,25,1878),(1879,25,1879),(1880,25,1880),(1881,25,1881),(1882,25,1882),(1883,25,1883),(1884,25,1884),(1885,25,1885),(1886,25,1886),(1887,25,1887),(1888,25,1888),(1889,25,1889),(1890,26,1890),(1891,26,1891),(1892,26,1892),(1893,26,1893),(1894,26,1894),(1895,26,1895),(1896,26,1896),(1897,26,1897),(1898,26,1898),(1899,26,1899),(1900,26,1900),(1901,26,1901),(1902,26,1902),(1903,26,1903),(1904,26,1904),(1905,26,1905),(1906,26,1906),(1907,26,1907),(1908,26,1908),(1909,26,1909),(1910,26,1910),(1911,26,1911),(1912,26,1912),(1913,26,1913),(1914,26,1914),(1915,26,1915),(1916,26,1916),(1917,26,1917),(1918,26,1918),(1919,26,1919),(1920,26,1920),(1921,26,1921),(1922,26,1922),(1923,26,1923),(1924,26,1924),(1925,26,1925),(1926,26,1926),(1927,26,1927),(1928,26,1928),(1929,26,1929),(1930,26,1930),(1931,26,1931),(1932,26,1932),(1933,26,1933),(1934,26,1934),(1935,26,1935),(1936,26,1936),(1937,26,1937),(1938,26,1938),(1939,26,1939),(1940,26,1940),(1941,26,1941),(1942,26,1942),(1943,26,1943),(1944,26,1944),(1945,26,1945),(1946,26,1946),(1947,26,1947),(1948,26,1948),(1949,26,1949),(1950,26,1950),(1951,26,1951),(1952,26,1952),(1953,26,1953),(1954,26,1954),(1955,26,1955),(1956,26,1956),(1957,26,1957),(1958,26,1958),(1959,26,1959),(1960,26,1960),(1961,26,1961),(1962,27,1962),(1963,27,1963),(1964,27,1964),(1965,27,1965),(1966,27,1966),(1967,27,1967),(1968,27,1968),(1969,27,1969),(1970,27,1970),(1971,27,1971),(1972,27,1972),(1973,27,1973),(1974,27,1974),(1975,27,1975),(1976,27,1976),(1977,27,1977),(1978,27,1978),(1979,28,1979),(1980,28,1980),(1981,28,1981),(1982,28,1982),(1983,28,1983),(1984,28,1984),(1985,28,1985),(1986,28,1986),(1987,28,1987),(1988,28,1988),(1989,28,1989),(1990,28,1990),(1991,28,1991),(1992,28,1992),(1993,28,1993),(1994,28,1994),(1995,28,1995),(1996,28,1996),(1997,28,1997),(1998,28,1998),(1999,28,1999),(2000,28,2000),(2001,28,2001),(2002,28,2002),(2003,28,2003),(2004,28,2004),(2005,28,2005),(2006,28,2006),(2007,28,2007),(2008,28,2008),(2009,28,2009),(2010,28,2010),(2011,28,2011),(2012,28,2012),(2013,28,2013),(2014,28,2014),(2015,28,2015),(2016,28,2016),(2017,28,2017),(2018,28,2018),(2019,28,2019),(2020,28,2020),(2021,28,2021),(2022,29,2022),(2023,29,2023),(2024,29,2024),(2025,29,2025),(2026,29,2026),(2027,29,2027),(2028,29,2028),(2029,29,2029),(2030,29,2030),(2031,29,2031),(2032,29,2032),(2033,29,2033),(2034,29,2034),(2035,29,2035),(2036,29,2036),(2037,29,2037),(2038,29,2038),(2039,29,2039),(2040,29,2040),(2041,29,2041),(2042,29,2042),(2043,29,2043),(2044,29,2044),(2045,29,2045),(2046,29,2046),(2047,29,2047),(2048,29,2048),(2049,29,2049),(2050,29,2050),(2051,29,2051),(2052,29,2052),(2053,29,2053),(2054,29,2054),(2055,29,2055),(2056,29,2056),(2057,29,2057),(2058,29,2058),(2059,29,2059),(2060,29,2060),(2061,29,2061),(2062,29,2062),(2063,29,2063),(2064,29,2064),(2065,29,2065),(2066,29,2066),(2067,29,2067),(2068,29,2068),(2069,29,2069),(2070,29,2070),(2071,29,2071),(2072,29,2072),(2073,29,2073),(2074,29,2074),(2075,29,2075),(2076,29,2076),(2077,29,2077),(2078,29,2078),(2079,29,2079),(2080,29,2080),(2081,29,2081),(2082,30,2082),(2083,30,2083),(2084,30,2084),(2085,30,2085),(2086,30,2086),(2087,30,2087),(2088,30,2088),(2089,30,2089),(2090,30,2090),(2091,30,2091),(2092,30,2092),(2093,30,2093),(2094,30,2094),(2095,30,2095),(2096,30,2096),(2097,30,2097),(2098,30,2098),(2099,30,2099),(2100,30,2100),(2101,30,2101),(2102,30,2102),(2103,30,2103),(2104,30,2104),(2105,30,2105),(2106,30,2106),(2107,30,2107),(2108,30,2108),(2109,30,2109),(2110,30,2110),(2111,30,2111),(2112,30,2112),(2113,30,2113),(2114,30,2114),(2115,30,2115),(2116,30,2116),(2117,30,2117),(2118,30,2118),(2119,30,2119),(2120,30,2120),(2121,30,2121),(2122,30,2122),(2123,30,2123),(2124,30,2124),(2125,30,2125),(2126,30,2126),(2127,30,2127),(2128,30,2128),(2129,30,2129),(2130,30,2130),(2131,30,2131),(2132,30,2132),(2133,30,2133),(2134,30,2134),(2135,30,2135),(2136,30,2136),(2137,30,2137),(2138,30,2138),(2139,30,2139),(2140,30,2140),(2141,30,2141),(2142,30,2142),(2143,30,2143),(2144,30,2144),(2145,30,2145),(2146,30,2146),(2147,30,2147),(2148,30,2148),(2149,30,2149),(2150,30,2150),(2151,30,2151),(2152,30,2152),(2153,30,2153),(2154,30,2154),(2155,30,2155),(2156,30,2156),(2157,30,2157),(2158,30,2158),(2159,30,2159),(2160,30,2160),(2161,30,2161),(2162,30,2162),(2163,30,2163),(2164,30,2164),(2165,30,2165),(2166,30,2166),(2167,30,2167),(2168,30,2168),(2169,30,2169),(2170,30,2170),(2171,30,2171),(2172,30,2172),(2173,30,2173),(2174,30,2174),(2175,30,2175),(2176,30,2176),(2177,30,2177),(2178,30,2178),(2179,30,2179),(2180,30,2180),(2181,30,2181),(2182,30,2182),(2183,30,2183),(2184,30,2184),(2185,30,2185),(2186,30,2186),(2187,30,2187),(2188,30,2188),(2189,30,2189),(2190,30,2190),(2191,30,2191),(2192,30,2192),(2193,30,2193),(2194,30,2194),(2195,30,2195),(2196,30,2196),(2197,30,2197),(2198,30,2198),(2199,30,2199),(2200,30,2200),(2201,30,2201),(2202,30,2202),(2203,30,2203),(2204,30,2204),(2205,30,2205),(2206,30,2206),(2207,30,2207),(2208,30,2208),(2209,30,2209),(2210,30,2210),(2211,30,2211),(2212,30,2212),(2213,30,2213),(2214,30,2214),(2215,30,2215),(2216,30,2216),(2217,30,2217),(2218,30,2218),(2219,30,2219),(2220,30,2220),(2221,30,2221),(2222,30,2222),(2223,30,2223),(2224,30,2224),(2225,30,2225),(2226,30,2226),(2227,30,2227),(2228,30,2228),(2229,30,2229),(2230,30,2230),(2231,30,2231),(2232,30,2232),(2233,30,2233),(2234,30,2234),(2235,30,2235),(2236,30,2236),(2237,30,2237),(2238,30,2238),(2239,30,2239),(2240,30,2240),(2241,30,2241),(2242,30,2242),(2243,30,2243),(2244,30,2244),(2245,30,2245),(2246,30,2246),(2247,30,2247),(2248,30,2248),(2249,30,2249),(2250,30,2250),(2251,30,2251),(2252,30,2252),(2253,30,2253),(2254,30,2254),(2255,30,2255),(2256,30,2256),(2257,30,2257),(2258,30,2258),(2259,30,2259),(2260,30,2260),(2261,30,2261),(2262,30,2262),(2263,30,2263),(2264,30,2264),(2265,30,2265),(2266,30,2266),(2267,30,2267),(2268,30,2268),(2269,30,2269),(2270,30,2270),(2271,30,2271),(2272,30,2272),(2273,30,2273),(2274,30,2274),(2275,30,2275),(2276,30,2276),(2277,30,2277),(2278,30,2278),(2279,30,2279),(2280,30,2280),(2281,30,2281),(2282,30,2282),(2283,30,2283),(2284,30,2284),(2285,30,2285),(2286,30,2286),(2287,30,2287),(2288,30,2288),(2289,30,2289),(2290,30,2290),(2291,30,2291),(2292,30,2292),(2293,30,2293),(2294,31,2294),(2295,31,2295),(2296,31,2296),(2297,31,2297),(2298,31,2298),(2299,31,2299),(2300,31,2300),(2301,31,2301),(2302,31,2302),(2303,31,2303),(2304,31,2304),(2305,31,2305),(2306,31,2306),(2307,31,2307),(2308,31,2308),(2309,31,2309),(2310,31,2310),(2311,31,2311),(2312,31,2312),(2313,31,2313),(2314,31,2314),(2315,31,2315),(2316,31,2316),(2317,31,2317),(2318,31,2318),(2319,31,2319),(2320,31,2320),(2321,31,2321),(2322,31,2322),(2323,31,2323),(2324,31,2324),(2325,31,2325),(2326,31,2326),(2327,31,2327),(2328,31,2328),(2329,31,2329),(2330,31,2330),(2331,31,2331),(2332,31,2332),(2333,31,2333),(2334,31,2334),(2335,31,2335),(2336,31,2336),(2337,31,2337),(2338,31,2338),(2339,31,2339),(2340,31,2340),(2341,31,2341),(2342,31,2342),(2343,31,2343),(2344,31,2344),(2345,31,2345),(2346,31,2346),(2347,31,2347),(2348,31,2348),(2349,31,2349),(2350,31,2350),(2351,31,2351),(2352,31,2352),(2353,31,2353),(2354,31,2354),(2355,31,2355),(2356,31,2356),(2357,31,2357),(2358,31,2358),(2359,31,2359),(2360,31,2360),(2361,31,2361),(2362,31,2362),(2363,31,2363),(2364,31,2364),(2365,31,2365),(2366,31,2366),(2367,31,2367),(2368,31,2368),(2369,31,2369),(2370,31,2370),(2371,31,2371),(2372,31,2372),(2373,31,2373),(2374,31,2374),(2375,31,2375),(2376,31,2376),(2377,31,2377),(2378,31,2378),(2379,31,2379),(2380,31,2380),(2381,31,2381),(2382,31,2382),(2383,31,2383),(2384,31,2384),(2385,31,2385),(2386,31,2386),(2387,31,2387),(2388,31,2388),(2389,31,2389),(2390,31,2390),(2391,31,2391),(2392,31,2392),(2393,31,2393),(2394,31,2394),(2395,31,2395),(2396,31,2396),(2397,31,2397),(2398,31,2398),(2399,31,2399),(2400,32,2400),(2401,32,2401),(2402,32,2402),(2403,32,2403),(2404,32,2404),(2405,32,2405),(2406,32,2406),(2407,32,2407),(2408,32,2408),(2409,32,2409),(2410,32,2410),(2411,32,2411),(2412,32,2412),(2413,32,2413),(2414,32,2414),(2415,32,2415),(2416,32,2416),(2417,32,2417),(2418,32,2418),(2419,32,2419),(2420,32,2420),(2421,32,2421),(2422,32,2422),(2423,32,2423),(2424,32,2424),(2425,32,2425),(2426,32,2426),(2427,32,2427),(2428,32,2428),(2429,32,2429),(2430,32,2430),(2431,32,2431),(2432,32,2432),(2433,32,2433),(2434,32,2434),(2435,32,2435),(2436,32,2436),(2437,32,2437),(2438,32,2438),(2439,32,2439),(2440,32,2440),(2441,32,2441),(2442,32,2442),(2443,32,2443),(2444,32,2444),(2445,32,2445),(2446,32,2446),(2447,32,2447),(2448,32,2448),(2449,32,2449),(2450,32,2450),(2451,32,2451),(2452,32,2452),(2453,32,2453),(2454,32,2454),(2455,32,2455),(2456,32,2456),(2457,32,2457); /*!40000 ALTER TABLE `estado_municipios` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `estados` -- DROP TABLE IF EXISTS `estados`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `estados` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `estados` -- LOCK TABLES `estados` WRITE; /*!40000 ALTER TABLE `estados` DISABLE KEYS */; INSERT INTO `estados` VALUES (1,'Aguascalientes','2019-08-20 20:14:33','2019-08-20 20:14:33'),(2,'Baja California','2019-08-20 20:14:33','2019-08-20 20:14:33'),(3,'Baja California Sur','2019-08-20 20:14:33','2019-08-20 20:14:33'),(4,'Campeche','2019-08-20 20:14:33','2019-08-20 20:14:33'),(5,'Coahuila de Zaragoza','2019-08-20 20:14:33','2019-08-20 20:14:33'),(6,'Colima','2019-08-20 20:14:33','2019-08-20 20:14:33'),(7,'Chiapas','2019-08-20 20:14:33','2019-08-20 20:14:33'),(8,'Chihuahua','2019-08-20 20:14:33','2019-08-20 20:14:33'),(9,'Distrito Federal','2019-08-20 20:14:33','2019-08-20 20:14:33'),(10,'Durango','2019-08-20 20:14:33','2019-08-20 20:14:33'),(11,'Guanajuato','2019-08-20 20:14:33','2019-08-20 20:14:33'),(12,'Guerrero','2019-08-20 20:14:33','2019-08-20 20:14:33'),(13,'Hidalgo','2019-08-20 20:14:33','2019-08-20 20:14:33'),(14,'Jalisco','2019-08-20 20:14:33','2019-08-20 20:14:33'),(15,'México','2019-08-20 20:14:33','2019-08-20 20:14:33'),(16,'Michoacán de Ocampo','2019-08-20 20:14:33','2019-08-20 20:14:33'),(17,'Morelos','2019-08-20 20:14:33','2019-08-20 20:14:33'),(18,'Nayarit','2019-08-20 20:14:33','2019-08-20 20:14:33'),(19,'Nuevo León','2019-08-20 20:14:33','2019-08-20 20:14:33'),(20,'Oaxaca de Juárez','2019-08-20 20:14:33','2019-08-20 20:14:33'),(21,'Puebla','2019-08-20 20:14:33','2019-08-20 20:14:33'),(22,'Querétaro','2019-08-20 20:14:33','2019-08-20 20:14:33'),(23,'Quintana Roo','2019-08-20 20:14:33','2019-08-20 20:14:33'),(24,'San Luis Potosí','2019-08-20 20:14:33','2019-08-20 20:14:33'),(25,'Sinaloa','2019-08-20 20:14:33','2019-08-20 20:14:33'),(26,'Sonora','2019-08-20 20:14:33','2019-08-20 20:14:33'),(27,'Tabasco','2019-08-20 20:14:33','2019-08-20 20:14:33'),(28,'Tamaulipas','2019-08-20 20:14:33','2019-08-20 20:14:33'),(29,'Tlaxcala','2019-08-20 20:14:33','2019-08-20 20:14:33'),(30,'Veracruz de Ignacio de la Llave','2019-08-20 20:14:33','2019-08-20 20:14:33'),(31,'Yucatán','2019-08-20 20:14:33','2019-08-20 20:14:33'),(32,'Zacatecas','2019-08-20 20:14:33','2019-08-20 20:14:33'); /*!40000 ALTER TABLE `estados` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `eucaristias` -- DROP TABLE IF EXISTS `eucaristias`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `eucaristias` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `libro` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `folio` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `partida` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `church_id` int(10) unsigned DEFAULT NULL, `sacramento_id` int(10) unsigned DEFAULT NULL, `fecha` date DEFAULT NULL, `nombre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_paterno` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_materno` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nombre_padre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_paterno_padre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_materno_padre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nombre_madre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_paterno_madre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_materno_madre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nombre_padrino` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_paterno_padrino` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_materno_padrino` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nombre_madrina` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_paterno_madrina` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_materno_madrina` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sacerdote_id` int(10) unsigned DEFAULT NULL, `parroco_id` int(10) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `church_bautismo_id` int(10) DEFAULT NULL, `fecha_bautismo` date DEFAULT NULL, `municipio_id` bigint(20) DEFAULT NULL, `folio_bautismo` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `libro_bautismo` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `partida_bautismo` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `estado_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `eucaristias` -- LOCK TABLES `eucaristias` WRITE; /*!40000 ALTER TABLE `eucaristias` DISABLE KEYS */; /*!40000 ALTER TABLE `eucaristias` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `matrimonios` -- DROP TABLE IF EXISTS `matrimonios`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `matrimonios` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `libro` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `folio` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `partida` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `church_id` int(10) unsigned DEFAULT NULL, `sacramento_id` int(10) unsigned DEFAULT NULL, `fecha` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `esposo_nombre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `esposo_apellido_paterno` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `esposo_apellido_materno` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `esposa_nombre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `esposa_apellido_paterno` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `esposa_apellido_materno` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nombre_t1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_paterno_t1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_materno_t1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `nombre_t2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_paterno_t2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `apellido_materno_t2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sacerdote_id` int(10) unsigned DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `estado_id` bigint(20) DEFAULT NULL, `municipio_id` bigint(20) DEFAULT NULL, `parroco_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `matrimonios` -- LOCK TABLES `matrimonios` WRITE; /*!40000 ALTER TABLE `matrimonios` DISABLE KEYS */; /*!40000 ALTER TABLE `matrimonios` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `members` -- DROP TABLE IF EXISTS `members`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `members` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `last_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `rangos_eclesiastico_id` int(10) unsigned NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `members` -- LOCK TABLES `members` WRITE; /*!40000 ALTER TABLE `members` DISABLE KEYS */; /*!40000 ALTER TABLE `members` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `migrations` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `batch` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` VALUES (2,'2014_10_11_011318_create_roles_table',1),(3,'2014_10_12_000000_create_users_table',1),(4,'2014_10_12_100000_create_password_resets_table',1),(5,'2019_08_17_234849_create_sacramentos_table',2),(6,'2019_08_18_012023_create_rangos_eclesiasticos_table',3),(7,'2019_08_18_061141_create_churchs_table',4),(8,'2019_08_18_061422_create_members_table',4),(9,'2019_08_18_144525_create_bautismos_table',5),(10,'2019_08_19_004819_create_eucaristias_table',6),(11,'2019_08_19_010304_create_confirmaciones_table',7),(12,'2019_08_19_014639_create_matrimonios_table',8),(13,'2019_08_20_115128_add_column_username_to_users',9),(14,'2019_08_20_200754_create_estados_table',10); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `municipios` -- DROP TABLE IF EXISTS `municipios`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `municipios` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(200) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `municipios` -- LOCK TABLES `municipios` WRITE; /*!40000 ALTER TABLE `municipios` DISABLE KEYS */; INSERT INTO `municipios` VALUES (1,'Juarez'),(2,'Chihuahua'),(3,'Caliente'),(4,'Fria'),(5,'Mediana'),(6,'Templado'),(7,'Chiplote'),(8,'Candelita'),(9,'Super'),(10,'Chiquita'); /*!40000 ALTER TABLE `municipios` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, KEY `password_resets_email_index` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_resets` -- LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rangos_eclesiasticos` -- DROP TABLE IF EXISTS `rangos_eclesiasticos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rangos_eclesiasticos` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rangos_eclesiasticos` -- LOCK TABLES `rangos_eclesiasticos` WRITE; /*!40000 ALTER TABLE `rangos_eclesiasticos` DISABLE KEYS */; INSERT INTO `rangos_eclesiasticos` VALUES (1,'Parroco','2019-08-18 01:28:35','2019-08-18 01:28:35'),(2,'Vicario','2019-08-18 01:28:35','2019-08-18 01:28:35'),(3,'Obispo','2019-08-18 01:28:35','2019-08-18 05:43:25'); /*!40000 ALTER TABLE `rangos_eclesiasticos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `roles` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `roles_name_unique` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; INSERT INTO `roles` VALUES (1,'Administrador','2019-08-17 15:04:26','2019-08-17 15:04:26'); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sacramentos` -- DROP TABLE IF EXISTS `sacramentos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sacramentos` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `description` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sacramentos` -- LOCK TABLES `sacramentos` WRITE; /*!40000 ALTER TABLE `sacramentos` DISABLE KEYS */; INSERT INTO `sacramentos` VALUES (1,'Bautismo','2019-08-18 01:04:44','2019-08-18 01:04:44'),(2,'Confirmación','2019-08-18 01:04:44','2019-08-18 01:04:44'),(3,'Eucaristía','2019-08-18 01:04:44','2019-08-18 01:04:44'),(4,'Matriminio','2019-08-18 01:04:44','2019-08-18 01:04:44'); /*!40000 ALTER TABLE `sacramentos` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `first_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `role_id` int(10) unsigned NOT NULL, `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` datetime DEFAULT NULL, `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `users_email_unique` (`email`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` VALUES (1,'Administrador','Administrador','admin@gmail.com','$2y$10$kf00rvMUNHNIn58DTCNq5uB5v2NeAPbu6xaACpDD068lRzAwfchX.',1,NULL,'2019-08-17 15:05:14','2019-08-17 15:05:14',NULL,'admin'); /*!40000 ALTER TABLE `users` 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 2019-09-02 21:23:27