-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL version:             7.0.0.4053
-- Date/time:                    2019-11-25 14:58:43
-- --------------------------------------------------------


-- Dumping database structure for iaa
CREATE DATABASE IF NOT EXISTS `iaa` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `iaa`;


-- Dumping structure for table iaa.actividaddocente
CREATE TABLE IF NOT EXISTS `actividaddocente` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `resolucion` varchar(50) DEFAULT NULL,
  `ci` int(11) DEFAULT NULL,
  `nombre` varchar(50) DEFAULT NULL,
  `apellido` varchar(50) NOT NULL,
  `ano` int(11) DEFAULT NULL,
  `curso` varchar(50) NOT NULL,
  `materia` varchar(50) NOT NULL,
  `horas` int(50) NOT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table iaa.actividaddocente: ~0 rows (approximately)


-- Dumping structure for table iaa.aeronave
CREATE TABLE IF NOT EXISTS `aeronave` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `marca` text DEFAULT NULL,
  `modelo` text DEFAULT NULL,
  `matricula` text DEFAULT NULL,
  `tipo` int(11) DEFAULT NULL,
  `horas_totales_vuelo` float(11,2) DEFAULT NULL,
  `horas_proxima_inspeccion` int(11) DEFAULT NULL,
  `horas_remanentes` int(11) DEFAULT NULL,
  `cantidad_combustible_consumido` int(11) DEFAULT NULL,
  `combustible_por_anio` int(11) DEFAULT NULL,
  `certificado_aero` date DEFAULT NULL,
  `seguro` date DEFAULT NULL,
  `estado` int(10) DEFAULT NULL,
  `motivo` int(11) DEFAULT NULL,
  `observaciones` text DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Dumping data for table iaa.aeronave: ~5 rows (approximately)
REPLACE INTO `aeronave` (`id`, `marca`, `modelo`, `matricula`, `tipo`, `horas_totales_vuelo`, `horas_proxima_inspeccion`, `horas_remanentes`, `cantidad_combustible_consumido`, `combustible_por_anio`, `certificado_aero`, `seguro`, `estado`, `motivo`, `observaciones`, `creado`, `actualizado`) VALUES
	(5, 'Marca 1', 'AGLO-544', '4666-RR', 1, 16606.00, 23, 1, 12123, 433, '2019-11-08', '2019-11-15', 0, 9, '<p>sdsdsds</p>', '2019-11-08 04:10:45', '2019-11-13 23:43:11'),
	(6, 'Marca 2', 'AGLO-544', '3333', 1, 13000.50, 2, -2, 33, 66, '2019-11-15', '2019-11-23', 1, 0, '<p>pepepepep</p>', '2019-11-08 04:12:22', '2019-11-13 23:42:58'),
	(7, 'Marca 3', 'MVF322tt', 'RTT-5466', 0, 3.00, 3, 0, 44, 55, '2019-11-15', '2019-11-23', 0, 0, '<p>gggg</p>', '2019-11-08 04:27:17', '2019-11-08 04:43:59'),
	(8, 'Marca 4', 'MVF322TT', 'RTT-54533', 1, 155552.41, 4, 0, 1344, 66, '2019-11-08', '2019-11-08', 0, 0, '<p>probando la falla</p>', '2019-11-08 19:17:31', NULL),
	(9, 'Marca 5', 'MVF322', '454545', 1, 300.00, 500, 200, 344, 343, '2019-11-18', '2019-11-18', 1, 9, '', '2019-11-18 22:51:53', NULL);


-- Dumping structure for table iaa.aeronave_img
CREATE TABLE IF NOT EXISTS `aeronave_img` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `aeronave_id` int(10) NOT NULL,
  `nombre` varchar(40) COLLATE utf8_bin NOT NULL,
  `tipo` varchar(40) COLLATE utf8_bin NOT NULL,
  `creado` datetime NOT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- Dumping data for table iaa.aeronave_img: ~0 rows (approximately)


-- Dumping structure for table iaa.bitacora
CREATE TABLE IF NOT EXISTS `bitacora` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `idreservavuelo` int(11) DEFAULT NULL,
  `fechainicio` date DEFAULT NULL,
  `horainicio` time DEFAULT NULL,
  `fechafin` date DEFAULT NULL,
  `horafin` time DEFAULT NULL,
  `idaeronave` int(11) DEFAULT NULL,
  `idpiloto1` int(11) DEFAULT NULL,
  `idpiloto2` int(11) DEFAULT NULL,
  `pax` text COLLATE utf8_spanish_ci DEFAULT NULL,
  `origen` text COLLATE utf8_spanish_ci DEFAULT NULL,
  `destino` text COLLATE utf8_spanish_ci DEFAULT NULL,
  `mision` varchar(11) COLLATE utf8_spanish_ci DEFAULT NULL,
  `observaciones` text CHARACTER SET utf8 DEFAULT NULL,
  `codigollamada` text COLLATE utf8_spanish_ci DEFAULT NULL,
  `estado` int(11) DEFAULT NULL,
  `creado` datetime NOT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci ROW_FORMAT=DYNAMIC;

-- Dumping data for table iaa.bitacora: ~3 rows (approximately)
REPLACE INTO `bitacora` (`id`, `idreservavuelo`, `fechainicio`, `horainicio`, `fechafin`, `horafin`, `idaeronave`, `idpiloto1`, `idpiloto2`, `pax`, `origen`, `destino`, `mision`, `observaciones`, `codigollamada`, `estado`, `creado`, `actualizado`) VALUES
	(21, 4, '2019-11-19', '13:33:00', '2019-11-20', '13:33:00', 6, 2, 3, 'dfdfd', 'dfdf', 'dfdf', 'E-3', '<p>dffdfd</p>', '4444', 1, '2019-11-16 15:18:48', NULL),
	(22, 2, '2019-11-19', '14:44:00', '2019-11-21', '15:00:00', 8, 2, 3, 'rrrr', 'rrrr', 'rerere', 'E-3', '<p>ererer</p>', 'ererer', 0, '2019-11-16 23:35:43', NULL),
	(23, 6, '2019-11-18', '16:20:00', '2019-11-19', '18:05:00', 5, 2, 3, 'pax', 'tucuman', 'cancun', 'E-3', '', 'eco eco tango', 1, '2019-11-18 20:21:33', NULL);


-- Dumping structure for table iaa.calificacion
CREATE TABLE IF NOT EXISTS `calificacion` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `cursoinstancia_id` int(11) DEFAULT NULL,
  `usuario_id` int(11) DEFAULT NULL,
  `materia_id` int(11) DEFAULT NULL,
  `calificacion` decimal(5,2) DEFAULT NULL,
  `juicio` text COLLATE latin1_spanish_ci DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  `acta` varchar(50) COLLATE latin1_spanish_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;

-- Dumping data for table iaa.calificacion: ~0 rows (approximately)


-- Dumping structure for table iaa.categoria
CREATE TABLE IF NOT EXISTS `categoria` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(200) DEFAULT NULL,
  `orden` int(11) DEFAULT NULL,
  `color` varchar(50) NOT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `orden` (`orden`),
  KEY `orden_2` (`orden`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- Dumping data for table iaa.categoria: ~1 rows (approximately)
REPLACE INTO `categoria` (`id`, `nombre`, `orden`, `color`, `creado`, `actualizado`) VALUES
	(1, '3', 0, '#00ffff', '2019-08-24 01:01:24', '2019-08-24 01:01:34');


-- Dumping structure for table iaa.certificado
CREATE TABLE IF NOT EXISTS `certificado` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(100) DEFAULT NULL,
  `descripcion` varchar(100) DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- Dumping data for table iaa.certificado: ~6 rows (approximately)
REPLACE INTO `certificado` (`id`, `nombre`, `descripcion`, `creado`, `actualizado`) VALUES
	(1, 'Nivel de estudios', 'Nivel de estudios', '2017-04-01 14:30:56', NULL),
	(2, 'Nivel de ingl&eacute;s', 'Nivel de inglés', '2017-04-01 14:30:56', NULL),
	(3, 'Licencia', 'Licencia', '2017-04-01 14:30:56', NULL),
	(4, 'Horas de vuelo', 'Horas de vuelo', '2017-04-01 14:30:56', NULL),
	(5, 'Psicofísico', 'Psicof&iacute;sico', '2017-04-01 14:30:56', NULL),
	(6, 'CI', 'CI', '2017-04-01 14:30:56', NULL);


-- Dumping structure for table iaa.cursoinstancia
CREATE TABLE IF NOT EXISTS `cursoinstancia` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `curso_id` int(11) NOT NULL,
  `descripcion` varchar(200) COLLATE utf8_bin NOT NULL,
  `fechaIniIns` date NOT NULL COMMENT 'Fecha inicio de inscripción',
  `fechaFinIns` date NOT NULL COMMENT 'Fecha de fin de inscripción',
  `fechaInicio` date NOT NULL COMMENT 'Fecha inicio de curso',
  `fechaFin` date NOT NULL COMMENT 'Fecha fin de curso',
  `estado_id` int(11) DEFAULT 1,
  `creado` datetime NOT NULL,
  `actualizado` datetime DEFAULT NULL,
  `periodo_id` int(11) DEFAULT 0,
  `periodo` int(11) DEFAULT NULL,
  `cargahoraria` varchar(11) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- Dumping data for table iaa.cursoinstancia: ~0 rows (approximately)


-- Dumping structure for table iaa.cursoinstancia_materia
CREATE TABLE IF NOT EXISTS `cursoinstancia_materia` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cursoinstancia_id` int(11) NOT NULL,
  `materia_id` int(11) NOT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- Dumping data for table iaa.cursoinstancia_materia: ~0 rows (approximately)


-- Dumping structure for table iaa.curso_certificado
CREATE TABLE IF NOT EXISTS `curso_certificado` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `curso_id` int(11) NOT NULL,
  `certificado_id` int(11) NOT NULL,
  `obligatorio` int(11) NOT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- Dumping data for table iaa.curso_certificado: ~0 rows (approximately)


-- Dumping structure for table iaa.curso_materia
CREATE TABLE IF NOT EXISTS `curso_materia` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `curso_id` int(11) NOT NULL,
  `materia_id` int(11) NOT NULL,
  `cargaHoraria` int(11) DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- Dumping data for table iaa.curso_materia: ~0 rows (approximately)


-- Dumping structure for table iaa.duracion
CREATE TABLE IF NOT EXISTS `duracion` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(100) DEFAULT NULL,
  `valor` int(11) DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- Dumping data for table iaa.duracion: ~8 rows (approximately)
REPLACE INTO `duracion` (`id`, `nombre`, `valor`, `creado`, `actualizado`) VALUES
	(1, '1 hora', 1, NULL, NULL),
	(2, '1 h. 30 m.', 2, NULL, NULL),
	(3, '2 horas ', 3, NULL, NULL),
	(4, '3 horas', 4, NULL, NULL),
	(5, '4 horas', 5, NULL, NULL),
	(6, '4 h. 30 m.', 6, NULL, NULL),
	(7, '5 horas ', 7, NULL, NULL),
	(8, '6 horas', 8, NULL, NULL);


-- Dumping structure for table iaa.historico_aprobacion
CREATE TABLE IF NOT EXISTS `historico_aprobacion` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombres` varchar(511) COLLATE latin1_spanish_ci DEFAULT NULL,
  `apellidos` varchar(511) COLLATE latin1_spanish_ci DEFAULT NULL,
  `cedula` varchar(255) COLLATE latin1_spanish_ci DEFAULT NULL,
  `asignatura` varchar(255) COLLATE latin1_spanish_ci DEFAULT NULL,
  `fecha` date DEFAULT NULL,
  `acta` varchar(255) COLLATE latin1_spanish_ci DEFAULT NULL,
  `nota` varchar(255) COLLATE latin1_spanish_ci DEFAULT NULL,
  `resultado` varchar(255) COLLATE latin1_spanish_ci DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;

-- Dumping data for table iaa.historico_aprobacion: ~0 rows (approximately)


-- Dumping structure for table iaa.historico_totalizado
CREATE TABLE IF NOT EXISTS `historico_totalizado` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `anio` varchar(255) COLLATE latin1_spanish_ci DEFAULT NULL,
  `inscriptos` int(255) DEFAULT NULL,
  `aprobados` int(255) DEFAULT NULL,
  `porcentaje` int(255) DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;

-- Dumping data for table iaa.historico_totalizado: ~0 rows (approximately)


-- Dumping structure for table iaa.idioma
CREATE TABLE IF NOT EXISTS `idioma` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `codigo` varchar(20) COLLATE utf8_bin NOT NULL,
  `descripcion` varchar(20) COLLATE utf8_bin NOT NULL,
  `creado` datetime NOT NULL,
  `actualizado` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- Dumping data for table iaa.idioma: ~2 rows (approximately)
REPLACE INTO `idioma` (`id`, `codigo`, `descripcion`, `creado`, `actualizado`) VALUES
	(1, 'es', 'Español', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
	(2, 'igl', 'Inglés', '0000-00-00 00:00:00', '0000-00-00 00:00:00');


-- Dumping structure for table iaa.inscripcion
CREATE TABLE IF NOT EXISTS `inscripcion` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `usuario_id` int(100) DEFAULT NULL,
  `cursoinstancia_id` int(100) DEFAULT NULL,
  `rolmoodle_id` int(11) DEFAULT NULL,
  `preinscripcion_id` int(11) DEFAULT NULL,
  `estado` enum('pendiente','finalizado','encurso','abandonado') DEFAULT NULL,
  `aprobado` int(11) DEFAULT 0,
  `promedioAprobado` decimal(5,2) DEFAULT 0.00,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table iaa.inscripcion: ~0 rows (approximately)


-- Dumping structure for table iaa.mantenimiento
CREATE TABLE IF NOT EXISTS `mantenimiento` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `idaeronave` int(100) DEFAULT NULL,
  `horas_totales` int(11) DEFAULT NULL,
  `certificado_aero` date DEFAULT NULL,
  `seguro` date DEFAULT NULL,
  `observaciones` text DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Dumping data for table iaa.mantenimiento: ~2 rows (approximately)
REPLACE INTO `mantenimiento` (`id`, `idaeronave`, `horas_totales`, `certificado_aero`, `seguro`, `observaciones`, `creado`, `actualizado`) VALUES
	(2, 2, 44, '2019-08-25', '2019-08-10', '<p>343443343434</p>', '2019-08-29 02:21:41', '2019-08-29 22:21:14'),
	(3, 3, 30, '2019-08-27', '2019-09-01', '<p>fgfggfgfg</p>', '2019-08-29 02:22:29', '2019-08-29 22:21:31'),
	(5, 2, 44, '2019-10-18', '2019-10-18', '<p>redfdfdf</p>', '2019-10-18 23:55:37', NULL);


-- Dumping structure for table iaa.materia
CREATE TABLE IF NOT EXISTS `materia` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `descripcion` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT '',
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table iaa.materia: ~0 rows (approximately)


-- Dumping structure for table iaa.organigrama
CREATE TABLE IF NOT EXISTS `organigrama` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(100) DEFAULT NULL,
  `descripcion` text DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table iaa.organigrama: ~0 rows (approximately)


-- Dumping structure for table iaa.organigrama_img
CREATE TABLE IF NOT EXISTS `organigrama_img` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `organigrama_id` int(10) NOT NULL,
  `nombre` varchar(40) COLLATE utf8_bin NOT NULL,
  `tipo` varchar(40) COLLATE utf8_bin NOT NULL,
  `creado` datetime NOT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- Dumping data for table iaa.organigrama_img: ~0 rows (approximately)


-- Dumping structure for table iaa.orm
CREATE TABLE IF NOT EXISTS `orm` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `idusuario` int(11) DEFAULT NULL,
  `salud` int(11) DEFAULT NULL,
  `suenio` int(11) DEFAULT NULL,
  `experiencia_reciente` int(11) DEFAULT NULL,
  `experiencia` int(11) DEFAULT NULL,
  `equipamiento` int(11) DEFAULT NULL,
  `anotaciones` int(11) DEFAULT NULL,
  `meteorologia` int(11) DEFAULT NULL,
  `operaciones` int(11) DEFAULT NULL,
  `facilidades` int(11) DEFAULT NULL,
  `cumplimiento` int(11) DEFAULT NULL,
  `pasajeros` int(11) DEFAULT NULL,
  `trabajo` int(11) DEFAULT NULL,
  `resultado` text DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- Dumping data for table iaa.orm: ~1 rows (approximately)
REPLACE INTO `orm` (`id`, `idusuario`, `salud`, `suenio`, `experiencia_reciente`, `experiencia`, `equipamiento`, `anotaciones`, `meteorologia`, `operaciones`, `facilidades`, `cumplimiento`, `pasajeros`, `trabajo`, `resultado`, `creado`, `actualizado`) VALUES
	(11, 3, 1, 1, 3, 2, 2, 3, 1, 1, 3, 2, 2, 3, 'negro', '2019-11-23 23:55:58', NULL);


-- Dumping structure for table iaa.periodo
CREATE TABLE IF NOT EXISTS `periodo` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(100) DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- Dumping data for table iaa.periodo: ~0 rows (approximately)
REPLACE INTO `periodo` (`id`, `nombre`, `creado`, `actualizado`) VALUES
	(1, '2017', NULL, NULL);


-- Dumping structure for table iaa.pilotos
CREATE TABLE IF NOT EXISTS `pilotos` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `idusuario` int(10) DEFAULT NULL,
  `tiempo_total_vuelo` time DEFAULT NULL,
  `horas_monomotor` time DEFAULT NULL,
  `horas_multimotor` time DEFAULT NULL,
  `horas_vuelo_instrumento` time DEFAULT NULL,
  `horas_piloto_instructor` time DEFAULT NULL,
  `horas_nocturnas` time DEFAULT NULL,
  `total_horas_anio` int(10) DEFAULT NULL,
  `aproximaciones_instrumentales` int(10) DEFAULT NULL,
  `cantidad_aterrizajes` int(10) DEFAULT NULL,
  `fecha_vencimiento_psicofisico` date DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- Dumping data for table iaa.pilotos: ~3 rows (approximately)
REPLACE INTO `pilotos` (`id`, `idusuario`, `tiempo_total_vuelo`, `horas_monomotor`, `horas_multimotor`, `horas_vuelo_instrumento`, `horas_piloto_instructor`, `horas_nocturnas`, `total_horas_anio`, `aproximaciones_instrumentales`, `cantidad_aterrizajes`, `fecha_vencimiento_psicofisico`, `creado`, `actualizado`) VALUES
	(1, 1, '00:01:11', '00:02:22', '00:03:33', '00:00:44', '00:00:55', NULL, 66, 66, 55, '2019-08-29', '2019-08-29 20:47:17', '2019-10-10 00:08:26'),
	(2, 2, '03:00:14', '00:05:53', '03:44:45', '01:44:45', '03:55:56', '02:00:00', 5454, 5702, 110, '2019-08-29', '2019-08-29 21:43:33', '2019-10-10 00:08:34'),
	(3, 3, '02:00:00', '13:00:00', '15:00:00', '15:50:00', '23:00:00', '14:00:00', 300, 66, 55, '2019-11-20', '2019-11-21 01:03:24', NULL);


-- Dumping structure for table iaa.planificacion
CREATE TABLE IF NOT EXISTS `planificacion` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(255) DEFAULT NULL,
  `cursoinstancia_id` int(11) DEFAULT NULL,
  `fechaInicio` date DEFAULT NULL,
  `fechaFin` date DEFAULT NULL,
  `fechaCierre` datetime DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table iaa.planificacion: ~0 rows (approximately)


-- Dumping structure for table iaa.preinscripcion
CREATE TABLE IF NOT EXISTS `preinscripcion` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `cursoinstancia_id` int(11) DEFAULT NULL,
  `preinscripto_id` int(11) DEFAULT NULL,
  `periodo_id` int(11) NOT NULL DEFAULT 0,
  `periodo` int(11) DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  `estado` enum('derivada','pendiente') DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table iaa.preinscripcion: ~0 rows (approximately)


-- Dumping structure for table iaa.preinscripcion_adjunto
CREATE TABLE IF NOT EXISTS `preinscripcion_adjunto` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `preinscripcion_id` int(10) NOT NULL,
  `nombre` varchar(40) COLLATE latin1_spanish_ci NOT NULL,
  `tipo` varchar(40) COLLATE latin1_spanish_ci NOT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;

-- Dumping data for table iaa.preinscripcion_adjunto: ~0 rows (approximately)


-- Dumping structure for table iaa.preinscripto
CREATE TABLE IF NOT EXISTS `preinscripto` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nombres` varchar(100) DEFAULT NULL,
  `apellidos` varchar(100) DEFAULT NULL,
  `documento` varchar(100) DEFAULT NULL,
  `telefono` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `fechaNacimiento` date DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table iaa.preinscripto: ~0 rows (approximately)


-- Dumping structure for table iaa.registroasistencia
CREATE TABLE IF NOT EXISTS `registroasistencia` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `usuario_id` int(11) DEFAULT NULL,
  `registrodeclase_id` int(11) DEFAULT NULL,
  `asistio` int(11) DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;

-- Dumping data for table iaa.registroasistencia: ~0 rows (approximately)


-- Dumping structure for table iaa.registrodeclase
CREATE TABLE IF NOT EXISTS `registrodeclase` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `fecha` date DEFAULT NULL,
  `temario` text COLLATE latin1_spanish_ci DEFAULT NULL,
  `materia` text COLLATE latin1_spanish_ci DEFAULT NULL,
  `duracion` int(11) DEFAULT NULL,
  `horario` varchar(100) COLLATE latin1_spanish_ci DEFAULT NULL,
  `observaciones` text COLLATE latin1_spanish_ci DEFAULT NULL,
  `docente_id` int(11) DEFAULT NULL,
  `materia_id` int(11) NOT NULL,
  `cursoinstancia_id` int(11) DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;

-- Dumping data for table iaa.registrodeclase: ~0 rows (approximately)


-- Dumping structure for table iaa.reportefalla
CREATE TABLE IF NOT EXISTS `reportefalla` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `idaeronave` int(10) NOT NULL,
  `fecha` date NOT NULL,
  `comentario` longtext NOT NULL,
  `estado` enum('P','F') NOT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

-- Dumping data for table iaa.reportefalla: ~8 rows (approximately)
REPLACE INTO `reportefalla` (`id`, `idaeronave`, `fecha`, `comentario`, `estado`, `creado`, `actualizado`) VALUES
	(6, 7, '2019-09-17', '<p>presenta fallos en el ala derecha, posterior al casco</p>', 'F', '2019-09-17 21:07:02', '2019-11-22 22:15:13'),
	(8, 9, '2019-11-20', '<p>fallando el motor</p>', 'P', '2019-11-21 02:14:17', NULL),
	(12, 8, '2019-11-22', '<p>dssdsdsds</p>', 'F', '0000-00-00 00:00:00', '2019-11-22 22:31:23'),
	(13, 6, '2019-11-23', '<p>dddddddddddd</p>', 'P', NULL, NULL),
	(14, 6, '2019-11-23', '<p>dddddddddddd</p>', 'P', NULL, NULL),
	(15, 6, '2019-11-23', '<p>dddddddddddd</p>', 'P', NULL, NULL),
	(16, 6, '2019-11-23', '<p>dddddddddddd</p>', 'P', NULL, NULL),
	(17, 6, '2019-11-23', '<p>dddddddddddd</p>', 'P', NULL, NULL);


-- Dumping structure for table iaa.reportessugerencias
CREATE TABLE IF NOT EXISTS `reportessugerencias` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `fecha` date NOT NULL,
  `usuario_id` int(11) NOT NULL,
  `situacion` text NOT NULL,
  `tipo` enum('Calidad','Seguridad','Drones') DEFAULT NULL,
  `estado` enum('Pendiente','En Estudio','Finalizado','') CHARACTER SET utf8 DEFAULT 'Pendiente',
  `medida` text DEFAULT NULL,
  `fechaMedida` date DEFAULT NULL,
  `usuarioMedida_id` int(11) DEFAULT NULL,
  `recomendaciones` text NOT NULL,
  `creado` datetime NOT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Dumping data for table iaa.reportessugerencias: ~0 rows (approximately)


-- Dumping structure for table iaa.reservasimulador
CREATE TABLE IF NOT EXISTS `reservasimulador` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(150) COLLATE utf8_spanish_ci DEFAULT NULL,
  `body` text COLLATE utf8_spanish_ci DEFAULT NULL,
  `url` varchar(150) COLLATE utf8_spanish_ci DEFAULT NULL,
  `class` varchar(45) COLLATE utf8_spanish_ci DEFAULT 'info',
  `start` varchar(15) COLLATE utf8_spanish_ci DEFAULT NULL,
  `end` varchar(15) COLLATE utf8_spanish_ci DEFAULT NULL,
  `usuario_id` int(11) DEFAULT NULL,
  `simulador_id` int(11) DEFAULT NULL,
  `turno_id` int(11) DEFAULT NULL,
  `tipo` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `estado` enum('PENDIENTE','REALIZADO','CANCELADO','NO REALIZADO') CHARACTER SET utf8 DEFAULT 'PENDIENTE',
  `observaciones` varchar(500) CHARACTER SET utf8 DEFAULT NULL,
  `creado` datetime NOT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

-- Dumping data for table iaa.reservasimulador: ~2 rows (approximately)
REPLACE INTO `reservasimulador` (`id`, `title`, `body`, `url`, `class`, `start`, `end`, `usuario_id`, `simulador_id`, `turno_id`, `tipo`, `estado`, `observaciones`, `creado`, `actualizado`) VALUES
	(1, 'Turno 1  de 9:00 a 10:30', 'gggg', ' Usuario: 1-moose moose', 'event-warning', '1567062000000', '1567067400000', 1, 2, 1, 'AVIACIÓN GENERAL', 'PENDIENTE', NULL, '2019-08-29 22:33:16', NULL),
	(2, 'Turno 1  de 9:00 a 10:30', 'dfdfdf', ' Usuario: 1-moose moose', 'event-warning', '1567148400000', '1567153800000', 1, 1, 1, 'AVIACIÓN GENERAL', 'PENDIENTE', NULL, '2019-08-30 04:08:16', NULL),
	(3, 'Turno 1  de 9:00 a 10:30', '', ' Usuario: 1-moose moose', 'event-warning', '1574150400000', '1574155800000', 1, 1, 1, 'AVIACIÓN GENERAL', 'PENDIENTE', NULL, '2019-11-16 02:59:05', NULL);


-- Dumping structure for table iaa.reservavuelo
CREATE TABLE IF NOT EXISTS `reservavuelo` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fechainicio` date DEFAULT NULL,
  `horainicio` time DEFAULT NULL,
  `fechafin` date DEFAULT NULL,
  `horafin` time DEFAULT NULL,
  `idaeronave` int(11) DEFAULT NULL,
  `idpiloto1` int(11) DEFAULT NULL,
  `idpiloto2` int(11) DEFAULT NULL,
  `pax` text COLLATE utf8_spanish_ci DEFAULT NULL,
  `origen` text COLLATE utf8_spanish_ci DEFAULT NULL,
  `destino` text COLLATE utf8_spanish_ci DEFAULT NULL,
  `mision` varchar(11) COLLATE utf8_spanish_ci DEFAULT NULL,
  `observaciones` text CHARACTER SET utf8 DEFAULT NULL,
  `codigollamada` text COLLATE utf8_spanish_ci DEFAULT NULL,
  `title` text COLLATE utf8_spanish_ci DEFAULT NULL,
  `url` text COLLATE utf8_spanish_ci DEFAULT NULL,
  `class` text COLLATE utf8_spanish_ci DEFAULT NULL,
  `start` text COLLATE utf8_spanish_ci DEFAULT NULL,
  `end` text COLLATE utf8_spanish_ci DEFAULT NULL,
  `activo` int(11) DEFAULT NULL,
  `creado` datetime NOT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci ROW_FORMAT=DYNAMIC;

-- Dumping data for table iaa.reservavuelo: ~3 rows (approximately)
REPLACE INTO `reservavuelo` (`id`, `fechainicio`, `horainicio`, `fechafin`, `horafin`, `idaeronave`, `idpiloto1`, `idpiloto2`, `pax`, `origen`, `destino`, `mision`, `observaciones`, `codigollamada`, `title`, `url`, `class`, `start`, `end`, `activo`, `creado`, `actualizado`) VALUES
	(1, '2019-11-18', '12:22:00', '0000-00-00', '00:00:00', 0, 0, 0, '', '', '', '', '', '', '2019-11-18-12:22--marca 132-AGLO-544', 'Vuelo: Origen: - Destino: ', 'event-warning', '1574031600000', '1574031600000', 0, '2019-11-16 19:12:36', NULL),
	(2, '2019-11-19', '14:44:00', '2019-11-21', '15:00:00', 8, 2, 3, 'rrrr', 'rrrr', 'rerere', 'E-3', '<p>ererer</p>', 'ererer', '2019-11-19-14:44:00-2019-11-21-marca 132-AGLO-544', 'Vuelo: Origen:rrrr - Destino: rerere', 'event-warning', '1574118000000', '1574290800000', 1, '2019-11-16 23:35:06', '2019-11-16 23:35:43'),
	(3, '2019-11-18', '16:20:00', '2019-11-19', '18:05:00', 5, 2, 3, 'pax', 'tucuman', 'cancun', 'E-3', '', 'eco eco tango', '2019-11-18-16:20:00-2019-11-19-marca 132-AGLO-544', 'Vuelo: Origen:tucuman - Destino: cancun', 'event-warning', '1574031600000', '1574118000000', 1, '2019-11-18 20:20:30', '2019-11-18 20:21:33');


-- Dumping structure for table iaa.rol
CREATE TABLE IF NOT EXISTS `rol` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(100) DEFAULT NULL,
  `etiqueta` varchar(10) DEFAULT NULL,
  `prioridad` int(11) DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- Dumping data for table iaa.rol: ~6 rows (approximately)
REPLACE INTO `rol` (`id`, `nombre`, `etiqueta`, `prioridad`, `creado`, `actualizado`) VALUES
	(1, 'Docente', 'DOC', 3, '2016-08-30 21:33:37', NULL),
	(2, 'Alumno', 'ALU', 4, '2016-08-30 21:33:40', NULL),
	(3, 'Piloto', 'PIL', 5, '2016-08-30 21:33:41', NULL),
	(4, 'Mec&aacute;nico', 'MEC', 6, '2016-08-30 21:33:42', NULL),
	(5, 'Administrador', 'ADM', 1, '2016-08-30 21:33:43', NULL),
	(6, 'Bedel', 'BED', 2, '2016-08-30 21:33:44', NULL);


-- Dumping structure for table iaa.rolmoodle
CREATE TABLE IF NOT EXISTS `rolmoodle` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(100) DEFAULT NULL,
  `etiqueta` varchar(100) DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- Dumping data for table iaa.rolmoodle: ~2 rows (approximately)
REPLACE INTO `rolmoodle` (`id`, `nombre`, `etiqueta`, `creado`, `actualizado`) VALUES
	(4, 'Docente', 'teacher', '2016-08-30 21:33:50', NULL),
	(5, 'Alumno', 'student', '2016-08-30 21:33:51', NULL);


-- Dumping structure for table iaa.rtv
CREATE TABLE IF NOT EXISTS `rtv` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `idbitacora` int(11) DEFAULT NULL,
  `fecha` date DEFAULT NULL,
  `horapm` time DEFAULT NULL,
  `horaam` time DEFAULT NULL,
  `tiempovuelo` time DEFAULT NULL,
  `asel` text DEFAULT NULL,
  `ifr` int(11) DEFAULT NULL,
  `pi` int(11) DEFAULT NULL,
  `dia_noche` int(11) DEFAULT NULL,
  `aproximaciones` int(11) DEFAULT NULL,
  `aterrisajes` int(11) DEFAULT NULL,
  `combustible_cargado` int(11) DEFAULT NULL,
  `horometroinicial` float(10,2) DEFAULT NULL,
  `horometrofinal` float(10,2) DEFAULT NULL,
  `estado` enum('C','NC') DEFAULT NULL,
  `motivo` enum('CLIMATICO','TRIPULACION','AERONAVE','OTRO') DEFAULT NULL,
  `falla` enum('SI','NO') DEFAULT NULL,
  `observaciones_falla` longtext DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- Dumping data for table iaa.rtv: ~4 rows (approximately)
REPLACE INTO `rtv` (`id`, `idbitacora`, `fecha`, `horapm`, `horaam`, `tiempovuelo`, `asel`, `ifr`, `pi`, `dia_noche`, `aproximaciones`, `aterrisajes`, `combustible_cargado`, `horometroinicial`, `horometrofinal`, `estado`, `motivo`, `falla`, `observaciones_falla`, `creado`, `actualizado`) VALUES
	(1, 20, '2019-11-18', '14:00:00', '16:00:00', '00:00:02', ' AMEL ', 1, 1, 0, 121, 12, 121, 120100.00, 121200.00, 'NC', 'CLIMATICO', 'SI', '<p>1212</p>', '2019-11-15 22:51:17', '2019-11-22 22:33:58'),
	(3, 16, '2019-11-13', '16:00:00', '17:55:00', '01:55:00', ' ASEL ', 1, 0, 0, 4434, 3434, 3434, 133300.00, 121200.00, 'NC', 'AERONAVE', 'NO', '<p>gggg</p>', '2019-11-15 23:45:19', '2019-11-16 00:11:32'),
	(4, 21, '2019-11-19', '00:01:00', '01:00:00', '00:59:00', ' AMEL ', 1, 1, 0, 31, 32, 33, 12000.50, 13000.50, 'NC', 'CLIMATICO', 'SI', '<p>dddddddddddd</p>', '2019-11-18 16:00:27', '2019-11-23 19:42:47'),
	(5, 22, '2019-11-19', '12:22:00', '13:33:00', '01:11:00', ' AMEL ', 1, 0, 0, 121, 12, 1344, 14000.50, 155552.41, 'NC', 'CLIMATICO', 'SI', '<p>dssdsdsds</p>', '2019-11-20 04:12:33', '2019-11-22 22:30:45'),
	(6, 23, '2019-11-18', '13:00:00', '15:00:00', '02:00:00', ' AMEL ', 0, 1, 1, 15, 12, 12123, 15505.00, 16606.00, 'NC', 'TRIPULACION', 'NO', '<p>fallando los cascos</p>', '2019-11-20 23:37:44', '2019-11-23 19:42:14');


-- Dumping structure for table iaa.simulador
CREATE TABLE IF NOT EXISTS `simulador` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `codigo` varchar(50) DEFAULT NULL,
  `nombre` varchar(100) DEFAULT NULL,
  `descripcion` text DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- Dumping data for table iaa.simulador: ~4 rows (approximately)
REPLACE INTO `simulador` (`id`, `codigo`, `nombre`, `descripcion`, `creado`, `actualizado`) VALUES
	(8, 'RC1', 'ELITE RC 1', '<p style="text-align: justify;">El entrenador de vuelo ELITE, es destinado al cumplimiento de los requisitos para la obtenci&oacute;n de la Habilitaci&oacute;n de Vuelo por Instrumentos de los alumnos del cursos de Piloto Comercial con HVI que obtuvieron una beca pr&aacute;ctica en dicho curso. A su vez, atiende los requerimientos de entrenamiento de todos los pilotos civiles del pa&iacute;s que posean una Habilitaci&oacute;n de Vuelo por Instrumentos vigente.</p>', '2016-11-19 20:08:44', '2018-07-18 18:33:52'),
	(9, 'Frasca', 'FRASCA 142', '<p style="text-align: justify;">El entrenador de vuelo FRASCA, atiende los requerimientos de entrenamiento de todos los pilotos civiles del pa&iacute;s que posean una Habilitaci&oacute;n Multimotor y de Vuelo por Instrumentos vigente.</p>', '2017-04-03 11:10:15', '2018-10-02 14:48:39'),
	(10, 'ATC', 'TWR 3D', '<p style="text-align: justify;">El Simulador de Torre en 3D brinda entrenamiento pr&aacute;ctico a los estudiantes del curso de Controladores de Tr&aacute;nsito A&eacute;reo, completando la formaci&oacute;n de los mismos en un entorno realista y de acuerdo a las exigencias del puesto de trabajo.</p>', '2016-11-19 20:10:44', '2018-09-08 20:56:39'),
	(13, 'RADAR', 'RADAR', '<p style="text-align: justify;">El Simulador RADAR permite completar la formaci&oacute;n profesional del Controlador de Transito A&eacute;reo en las Fases de Aproximaci&oacute;n y &Aacute;rea con control RADAR. El mismo puede operar en un ambiente simulado o con datos reales obtenidos directamente del sistema de vigilancia RADAR.</p>', '2017-04-03 11:14:26', '2018-07-18 18:34:27');


-- Dumping structure for table iaa.simuladorturno
CREATE TABLE IF NOT EXISTS `simuladorturno` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(100) COLLATE latin1_spanish_ci DEFAULT NULL,
  `horario` varchar(100) COLLATE latin1_spanish_ci DEFAULT NULL,
  `comienzo` varchar(10) COLLATE latin1_spanish_ci NOT NULL,
  `fin` varchar(19) COLLATE latin1_spanish_ci NOT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;

-- Dumping data for table iaa.simuladorturno: ~3 rows (approximately)
REPLACE INTO `simuladorturno` (`id`, `nombre`, `horario`, `comienzo`, `fin`, `creado`, `actualizado`) VALUES
	(1, 'Turno 1 ', '9:00 a 10:30', '09:00:00', '10:30:00', NULL, NULL),
	(2, 'Turno 2 ', '11:00 a 12:30', '11:00:00', '12:30:00', NULL, NULL),
	(3, 'Turno 3', '14:00 a 15:30', '14:00:00', '15:30:00', NULL, NULL);


-- Dumping structure for table iaa.simulador_img
CREATE TABLE IF NOT EXISTS `simulador_img` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `simulador_id` int(10) NOT NULL,
  `nombre` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `tipo` varchar(40) COLLATE utf8_bin NOT NULL,
  `creado` datetime NOT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- Dumping data for table iaa.simulador_img: ~6 rows (approximately)
REPLACE INTO `simulador_img` (`id`, `simulador_id`, `nombre`, `tipo`, `creado`, `actualizado`) VALUES
	(7, 7, NULL, 'image/jpeg', '2016-11-19 20:07:22', '2016-11-19 20:09:52'),
	(8, 8, NULL, 'image/jpeg', '2016-11-19 20:09:43', '2017-03-29 15:53:28'),
	(9, 9, NULL, 'image/jpeg', '2016-11-19 20:11:21', '2018-10-02 14:48:39'),
	(10, 12, NULL, 'image/jpeg', '2017-04-03 11:10:15', NULL),
	(11, 13, NULL, 'image/jpeg', '2017-04-03 11:14:26', NULL),
	(12, 10, NULL, 'image/jpeg', '2017-07-14 12:26:26', NULL);


-- Dumping structure for table iaa.usuariorol
CREATE TABLE IF NOT EXISTS `usuariorol` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `usuario_id` int(11) DEFAULT NULL,
  `rol_id` int(11) DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- Dumping data for table iaa.usuariorol: ~3 rows (approximately)
REPLACE INTO `usuariorol` (`id`, `usuario_id`, `rol_id`, `creado`, `actualizado`) VALUES
	(1, 1, 5, '2019-06-22 08:52:55', NULL),
	(2, 2, 3, '2019-08-30 16:43:08', NULL),
	(4, 3, 3, '2019-11-04 00:48:54', NULL);


-- Dumping structure for table iaa.usuario_adjunto
CREATE TABLE IF NOT EXISTS `usuario_adjunto` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `usuario_id` int(10) NOT NULL,
  `nombre` varchar(40) COLLATE latin1_spanish_ci NOT NULL,
  `tipo` varchar(40) COLLATE latin1_spanish_ci NOT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;

-- Dumping data for table iaa.usuario_adjunto: ~0 rows (approximately)


-- Dumping structure for table iaa.web
CREATE TABLE IF NOT EXISTS `web` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `bienvenida` text DEFAULT NULL,
  `institucional` text DEFAULT NULL,
  `mision` text DEFAULT NULL,
  `vision` text DEFAULT NULL,
  `organigrama` text DEFAULT NULL,
  `aeronave` text DEFAULT NULL,
  `simulador` text DEFAULT NULL,
  `reserva_simulador` text DEFAULT NULL,
  `inscripcion` text DEFAULT NULL,
  `docente` text DEFAULT NULL,
  `cursos` text DEFAULT NULL,
  `preinscripcion` text DEFAULT NULL,
  `contacto` text DEFAULT NULL,
  `cursos_incompany` text DEFAULT NULL,
  `creado` datetime DEFAULT NULL,
  `actualizado` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table iaa.web: ~0 rows (approximately)
