/*
SQLyog Ultimate v9.20 
MySQL - 5.7.24 : Database - etars
*********************************************************************
*/




CREATE DATABASE /*!32312 IF NOT EXISTS*/`etars` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `etars`;

/*Table structure for table `auditorias` */


CREATE TABLE `auditorias` (
  `dni_postulante` int(11) DEFAULT NULL,
  `movimiento` varchar(50) DEFAULT NULL,
  `estado` varchar(50) DEFAULT NULL,
  `usuario` varchar(50) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id` int(10) NOT NULL AUTO_INCREMENT,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=186 DEFAULT CHARSET=latin1;

/*Data for the table `auditorias` */

insert  into `auditorias`(`dni_postulante`,`movimiento`,`estado`,`usuario`,`created_at`,`updated_at`,`id`) values (40123123,'INSERT','1','fapc2012@gmail.com','2020-09-02 13:16:10','2020-09-02 13:16:10',152),(NULL,'DELETE','1','fapc2012@gmail.com','2020-09-02 13:22:50','2020-09-02 13:22:50',153),(48123123,'INSERT','1','fapc2012@gmail.com','2020-09-02 13:24:29','2020-09-02 13:24:29',154),(48123123,'DELETE','1','fapc2012@gmail.com','2020-09-02 13:31:59','2020-09-02 13:31:59',155),(48123123,'DELETE','1','fapc2012@gmail.com','2020-09-02 13:46:55','2020-09-02 13:46:55',156),(48123123,'DELETE','1','fapc2012@gmail.com','2020-09-02 13:47:45','2020-09-02 13:47:45',157),(48123123,'DELETE','1','fapc2012@gmail.com','2020-09-02 13:49:47','2020-09-02 13:49:47',158),(48123123,'DELETE','1','fapc2012@gmail.com','2020-09-02 13:50:44','2020-09-02 13:50:44',159),(48123123,'DELETE','1','fapc2012@gmail.com','2020-09-02 13:51:00','2020-09-02 13:51:00',160),(48123123,'DELETE','1','fapc2012@gmail.com','2020-09-02 13:53:08','2020-09-02 13:53:08',161),(41233111,'INSERT','1','fapc2012@gmail.com','2020-09-02 14:59:07','2020-09-02 14:59:07',162),(12345678,'INSERT','1','fapc2012@gmail.com','2020-09-02 15:20:31','2020-09-02 15:20:31',163),(50122333,'INSERT','1','fapc2012@gmail.com','2020-09-02 15:27:09','2020-09-02 15:27:09',164),(41200100,'INSERT','1','fapc2012@gmail.com','2020-09-02 15:28:23','2020-09-02 15:28:23',165),(40639147,'INSERT','1','fapc2012@gmail.com','2020-09-02 16:09:04','2020-09-02 16:09:04',166),(38236258,'INSERT','1','fapc2012@gmail.com','2020-09-02 16:22:59','2020-09-02 16:22:59',167),(50999666,'INSERT','1','fapc2012@gmail.com','2020-09-02 16:24:40','2020-09-02 16:24:40',168),(50999666,'UPDATE','1','fapc2012@gmail.com','2020-09-02 21:18:51','2020-09-02 21:18:51',169),(50122333,'UPDATE','3','fapc2012@gmail.com','2020-09-02 21:21:25','2020-09-02 21:21:25',170),(38236258,'UPDATE','6','fapc2012@gmail.com','2020-09-02 21:22:58','2020-09-02 21:22:58',171),(50122333,'UPDATE','4','fapc2012@gmail.com','2020-09-02 21:23:38','2020-09-02 21:23:38',172),(50122333,'UPDATE','4','fapc2012@gmail.com','2020-09-02 21:29:12','2020-09-02 21:29:12',173),(50122333,'UPDATE','4','fapc2012@gmail.com','2020-09-02 21:31:56','2020-09-02 21:31:56',174),(50999666,'UPDATE','1','fapc2012@gmail.com','2020-09-02 21:32:15','2020-09-02 21:32:15',175),(50122333,'UPDATE','5','fapc2012@gmail.com','2020-09-02 21:33:21','2020-09-02 21:33:21',176),(50122333,'UPDATE','5','fapc2012@gmail.com','2020-09-02 21:33:44','2020-09-02 21:33:44',177),(50999666,'UPDATE','2','fapc2012@gmail.com','2020-09-02 21:34:05','2020-09-02 21:34:05',178),(40639147,'UPDATE','2','fapc2012@gmail.com','2020-09-02 21:35:14','2020-09-02 21:35:14',179),(50999666,'UPDATE','3','fapc2012@gmail.com','2020-09-02 21:35:21','2020-09-02 21:35:21',180),(50563563,'INSERT','1','fapc2012@gmail.com','2020-09-03 19:25:57','2020-09-03 19:25:57',181),(48123699,'INSERT','1','fapc2012@gmail.com','2020-09-03 19:29:44','2020-09-03 19:29:44',182),(41233111,'DELETE','1','fapc2012@gmail.com','2020-09-03 19:31:29','2020-09-03 19:31:29',183),(50999666,'UPDATE','3','fapc2012@gmail.com','2020-09-03 19:37:07','2020-09-03 19:37:07',184),(12345678,'UPDATE','3','fapc2012@gmail.com','2020-09-03 19:37:25','2020-09-03 19:37:25',185);

/*Table structure for table `estados` */


CREATE TABLE `estados` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `nombre_estado` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `estados` */

insert  into `estados`(`id`,`nombre_estado`,`created_at`,`updated_at`) values (1,'INICIAL',NULL,NULL),(2,'LLAMADO',NULL,NULL),(3,'EN TRAMITE',NULL,NULL),(4,'LLAMADO A EXAMEN',NULL,NULL),(5,'NO INGRESA',NULL,NULL),(6,'INSCRIPTO A ETARS',NULL,NULL);

/*Table structure for table `failed_jobs` */


CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `failed_jobs` */

/*Table structure for table `familias` */


CREATE TABLE `familias` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nombre_padre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dni_padre` int(11) DEFAULT '0',
  `telefono_padre` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ars_padre` char(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `legajo_padre` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cc_padre` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `interno_padre` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nombre_madre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dni_madre` int(11) DEFAULT '0',
  `telefono_madre` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ars_madre` char(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `legajo_madre` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cc_madre` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `interno_madre` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nombre_tutor` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dni_tutor` int(11) DEFAULT '0',
  `telefono_tutor` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ars_tutor` char(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `legajo_tutor` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cc_tutor` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `interno_tutor` varchar(4) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `nombre_hermano` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dni_hermano` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `familias` */

insert  into `familias`(`id`,`nombre_padre`,`dni_padre`,`telefono_padre`,`ars_padre`,`legajo_padre`,`cc_padre`,`interno_padre`,`nombre_madre`,`dni_madre`,`telefono_madre`,`ars_madre`,`legajo_madre`,`cc_madre`,`interno_madre`,`nombre_tutor`,`dni_tutor`,`telefono_tutor`,`ars_tutor`,`legajo_tutor`,`cc_tutor`,`interno_tutor`,`created_at`,`updated_at`,`nombre_hermano`,`dni_hermano`) values (38,'PASPASPSD',45512122,'12321321','N',NULL,NULL,NULL,'',NULL,NULL,'N',NULL,NULL,NULL,'',NULL,NULL,'N',NULL,NULL,NULL,'2020-09-02 14:59:06','2020-09-02 14:59:06','',0),(39,'',NULL,NULL,'N',NULL,NULL,NULL,'MISMAS YAEL',30123133,'12345445','N',NULL,NULL,NULL,'',NULL,NULL,'N',NULL,NULL,NULL,'2020-09-02 15:20:31','2020-09-02 15:20:31','',0),(40,'ERNESTO BAU',27123123,'41023652','S','1541','4544','5545','',NULL,NULL,'N',NULL,NULL,NULL,'',NULL,NULL,'N',NULL,NULL,NULL,'2020-09-02 15:27:09','2020-09-02 15:27:09','',0),(41,'',NULL,NULL,'N',NULL,NULL,NULL,'PERES ANALIA',25633211,'4102332541','N',NULL,NULL,NULL,'',NULL,NULL,'N',NULL,NULL,NULL,'2020-09-02 15:28:23','2020-09-02 15:28:23','PEDRO RICO',40698741),(42,'ROBLES DANIEL',21369855,'4102563','S','8512','0130','4152','',NULL,NULL,'N',NULL,NULL,NULL,'',NULL,NULL,'N',NULL,NULL,NULL,'2020-09-02 16:09:04','2020-09-02 16:09:04','ROBLES BARBARA',39123456),(43,'PIA ALBERTO',23569874,'4102233','N',NULL,NULL,NULL,'',NULL,NULL,'N',NULL,NULL,NULL,'',NULL,NULL,'N',NULL,NULL,NULL,'2020-09-02 16:22:59','2020-09-02 16:22:59','PIA ANDRES',38120369),(44,'',NULL,NULL,'N',NULL,NULL,NULL,'',NULL,NULL,'N',NULL,NULL,NULL,'PERESA DADARIO',25698741,'4102568945','N',NULL,NULL,NULL,'2020-09-02 16:24:40','2020-09-02 16:24:40','',0),(45,'PERES ALDO',25366633,'123454545','N',NULL,NULL,NULL,'',NULL,NULL,'N',NULL,NULL,NULL,'',NULL,NULL,'N',NULL,NULL,NULL,'2020-09-03 19:25:57','2020-09-03 19:25:57','',NULL),(46,'',NULL,NULL,'N',NULL,NULL,NULL,'LAADADA',25365412,'123456456','S','4444','4545','5645','',NULL,NULL,'N',NULL,NULL,NULL,'2020-09-03 19:29:44','2020-09-03 19:29:44','',NULL);

/*Table structure for table `migrations` */


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=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `migrations` */

insert  into `migrations`(`id`,`migration`,`batch`) values (4,'2014_10_12_000000_create_users_table',1),(5,'2014_10_12_100000_create_password_resets_table',1),(6,'2019_08_19_000000_create_failed_jobs_table',1),(7,'2020_06_24_235212_create_registros_table',2),(8,'2020_06_24_235427_create_postulantes_table',2),(9,'2020_06_24_235501_create_familias_table',2),(10,'2020_06_24_235623_create_estados_table',2),(11,'2020_06_24_235641_create_reportes_table',2),(12,'2020_06_24_235716_create_personals_table',2),(13,'2020_06_25_235713_create_tipo_personals_table',2);

/*Data for the table `password_resets` */

/*Table structure for table `personals` */


CREATE TABLE `personals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nombre_personal` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `clave_personal` int(11) NOT NULL,
  `reporte_id` int(10) unsigned NOT NULL,
  `tipo_personal_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;

/*Table structure for table `registros` */


CREATE TABLE `registros` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `valido` char(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `clave` 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 `registros_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `registros` */

/*Table structure for table `reportes` */


CREATE TABLE `reportes` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tipo_reporte` int(11) NOT NULL,
  `descripcion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `estado_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;

/*Data for the table `reportes` */

/*Table structure for table `tipo_personals` */


CREATE TABLE `tipo_personals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `descripcion_tipo` int(11) 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;

