-- MySQL dump 10.13  Distrib 5.6.41, for Linux (x86_64)
--
-- Host: localhost    Database: innov936_RHH
-- ------------------------------------------------------
-- Server version	5.6.41

/*!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 utf8mb4 */;
/*!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 `ajustes`
--

DROP TABLE IF EXISTS `ajustes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ajustes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `FECHA_INI` date NOT NULL,
  `FECHA_FIN` date DEFAULT NULL,
  `empleado_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_ajustes_empleados1` (`empleado_id`),
  CONSTRAINT `fk_ajustes_empleados1` FOREIGN KEY (`empleado_id`) REFERENCES `empleados` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ajustes`
--

LOCK TABLES `ajustes` WRITE;
/*!40000 ALTER TABLE `ajustes` DISABLE KEYS */;
/*!40000 ALTER TABLE `ajustes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ajustes_asignaciones`
--

DROP TABLE IF EXISTS `ajustes_asignaciones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ajustes_asignaciones` (
  `asignacion_id` int(11) NOT NULL,
  `ajuste_id` int(11) NOT NULL,
  KEY `fk_asignaciones_empleados_asignaciones1` (`asignacion_id`),
  KEY `fk_asignaciones_empleados_ajustes1` (`ajuste_id`),
  CONSTRAINT `fk_asignaciones_empleados_ajustes1` FOREIGN KEY (`ajuste_id`) REFERENCES `ajustes` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `fk_asignaciones_empleados_asignaciones1` FOREIGN KEY (`asignacion_id`) REFERENCES `asignaciones` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ajustes_asignaciones`
--

LOCK TABLES `ajustes_asignaciones` WRITE;
/*!40000 ALTER TABLE `ajustes_asignaciones` DISABLE KEYS */;
/*!40000 ALTER TABLE `ajustes_asignaciones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ajustes_deducciones`
--

DROP TABLE IF EXISTS `ajustes_deducciones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ajustes_deducciones` (
  `deduccion_id` int(11) NOT NULL,
  `ajuste_id` int(11) NOT NULL,
  KEY `fk_deducciones_empleados_deducciones1` (`deduccion_id`),
  KEY `fk_deducciones_empleados_ajustes1` (`ajuste_id`),
  CONSTRAINT `fk_deducciones_empleados_ajustes1` FOREIGN KEY (`ajuste_id`) REFERENCES `ajustes` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `fk_deducciones_empleados_deducciones1` FOREIGN KEY (`deduccion_id`) REFERENCES `deducciones` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ajustes_deducciones`
--

LOCK TABLES `ajustes_deducciones` WRITE;
/*!40000 ALTER TABLE `ajustes_deducciones` DISABLE KEYS */;
/*!40000 ALTER TABLE `ajustes_deducciones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `asignaciones`
--

DROP TABLE IF EXISTS `asignaciones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `asignaciones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `DESCRIPCION` varchar(60) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asignaciones`
--

LOCK TABLES `asignaciones` WRITE;
/*!40000 ALTER TABLE `asignaciones` DISABLE KEYS */;
INSERT INTO `asignaciones` (`id`, `DESCRIPCION`) VALUES (1,'Prima por Reconocimiento'),(2,'Prima por Hogar'),(3,'Prima por Antigüedad'),(4,'Prima por Transporte'),(5,'Prima por Hijos'),(6,'Prima de Nivelación y Eficiencia Profesional'),(7,'Bono Nocturno'),(8,'Recargo Domingos y Dias Feriados');
/*!40000 ALTER TABLE `asignaciones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ausencias`
--

DROP TABLE IF EXISTS `ausencias`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ausencias` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `TIPO` varchar(45) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Remunerada , No Remunerada',
  `FECHA` date NOT NULL,
  `JUSTIFICACION` text COLLATE utf8_unicode_ci,
  `empleado_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_ausencias_empleados1` (`empleado_id`),
  CONSTRAINT `fk_ausencias_empleados1` FOREIGN KEY (`empleado_id`) REFERENCES `empleados` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ausencias`
--

LOCK TABLES `ausencias` WRITE;
/*!40000 ALTER TABLE `ausencias` DISABLE KEYS */;
/*!40000 ALTER TABLE `ausencias` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cargos`
--

DROP TABLE IF EXISTS `cargos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cargos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `NOMBRE` varchar(45) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  `DESCRIPCION` varchar(45) CHARACTER SET utf8 COLLATE utf8_spanish_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cargos`
--

LOCK TABLES `cargos` WRITE;
/*!40000 ALTER TABLE `cargos` DISABLE KEYS */;
/*!40000 ALTER TABLE `cargos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cestatickets`
--

DROP TABLE IF EXISTS `cestatickets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cestatickets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `FECHA_INI` date NOT NULL,
  `FECHA_FIN` date NOT NULL,
  `FECHA_ELA` datetime NOT NULL,
  `VALOR_DIARIO` decimal(19,5) NOT NULL COMMENT '50% - UNIDAD TRIBUTARIA',
  `SUELDO_MINIMO` decimal(19,5) NOT NULL,
  `BLOQUEAR` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cestatickets`
--

LOCK TABLES `cestatickets` WRITE;
/*!40000 ALTER TABLE `cestatickets` DISABLE KEYS */;
/*!40000 ALTER TABLE `cestatickets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `comerciales`
--

DROP TABLE IF EXISTS `comerciales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `comerciales` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `CANTIDAD` decimal(19,5) NOT NULL,
  `FECHA` date NOT NULL,
  `empleado_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_comerciales_empleados1` (`empleado_id`),
  CONSTRAINT `fk_comerciales_empleados1` FOREIGN KEY (`empleado_id`) REFERENCES `empleados` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `comerciales`
--

LOCK TABLES `comerciales` WRITE;
/*!40000 ALTER TABLE `comerciales` DISABLE KEYS */;
/*!40000 ALTER TABLE `comerciales` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `contratos`
--

DROP TABLE IF EXISTS `contratos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contratos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `FECHA_INI` date NOT NULL,
  `FECHA_FIN` date DEFAULT NULL,
  `MODALIDAD` varchar(45) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL COMMENT 'Fijo , Contratado , Eventuales',
  `departamento_id` int(11) NOT NULL,
  `cargo_id` int(11) NOT NULL,
  `empleado_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_asignaciones_departamentos1` (`departamento_id`),
  KEY `fk_asignaciones_cargos1` (`cargo_id`),
  KEY `fk_asignaciones_empleados1` (`empleado_id`),
  CONSTRAINT `fk_asignaciones_cargos1` FOREIGN KEY (`cargo_id`) REFERENCES `cargos` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_asignaciones_departamentos1` FOREIGN KEY (`departamento_id`) REFERENCES `departamentos` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_asignaciones_empleados1` FOREIGN KEY (`empleado_id`) REFERENCES `empleados` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contratos`
--

LOCK TABLES `contratos` WRITE;
/*!40000 ALTER TABLE `contratos` DISABLE KEYS */;
/*!40000 ALTER TABLE `contratos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `deducciones`
--

DROP TABLE IF EXISTS `deducciones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `deducciones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `DESCRIPCION` varchar(60) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `deducciones`
--

LOCK TABLES `deducciones` WRITE;
/*!40000 ALTER TABLE `deducciones` DISABLE KEYS */;
INSERT INTO `deducciones` (`id`, `DESCRIPCION`) VALUES (1,'S.S.O (4%)'),(2,'Régimen Prestacional de Empleo (0.50%)'),(3,'Fondo de Ahorro Obligatorio de Vivienda (FAOV) (1%)'),(4,'Fondo de Pensiones (3%)'),(5,'Caja de Ahorros'),(6,'Préstamo Caja de Ahorros'),(7,'Deducciones por Créditos Comerciales'),(8,'Deducciones por Tribunales'),(9,'Retención del Impuesto Sobre la Renta'),(10,'Ley de Vivienda y Habitat (1%)');
/*!40000 ALTER TABLE `deducciones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `departamentos`
--

DROP TABLE IF EXISTS `departamentos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `departamentos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `NOMBRE` varchar(60) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  `programa_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_departamentos_programas1` (`programa_id`),
  CONSTRAINT `fk_departamentos_programas1` FOREIGN KEY (`programa_id`) REFERENCES `programas` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `departamentos`
--

LOCK TABLES `departamentos` WRITE;
/*!40000 ALTER TABLE `departamentos` DISABLE KEYS */;
/*!40000 ALTER TABLE `departamentos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detalle_cestatickets`
--

DROP TABLE IF EXISTS `detalle_cestatickets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detalle_cestatickets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `TOTAL` decimal(19,5) NOT NULL,
  `DIAS_ADICIONALES` int(11) NOT NULL,
  `DIAS_DESCONTAR` int(11) NOT NULL,
  `DIAS_LABORADOS` int(11) NOT NULL,
  `CARGO` varchar(45) COLLATE utf8_spanish_ci NOT NULL,
  `DEPARTAMENTO` varchar(45) COLLATE utf8_spanish_ci NOT NULL,
  `MODALIDAD` varchar(45) COLLATE utf8_spanish_ci NOT NULL,
  `empleado_id` int(11) NOT NULL,
  `cestaticket_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_detalle_cestatickets_cestatickets1` (`cestaticket_id`),
  KEY `fk_detalle_cestatickets_empleados1` (`empleado_id`),
  CONSTRAINT `fk_detalle_cestatickets_cestatickets1` FOREIGN KEY (`cestaticket_id`) REFERENCES `cestatickets` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `fk_detalle_cestatickets_empleados1` FOREIGN KEY (`empleado_id`) REFERENCES `empleados` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detalle_cestatickets`
--

LOCK TABLES `detalle_cestatickets` WRITE;
/*!40000 ALTER TABLE `detalle_cestatickets` DISABLE KEYS */;
/*!40000 ALTER TABLE `detalle_cestatickets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detalle_eventualidades`
--

DROP TABLE IF EXISTS `detalle_eventualidades`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detalle_eventualidades` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `FECHA` date NOT NULL,
  `VALOR` decimal(19,5) NOT NULL,
  `empleado_id` int(11) NOT NULL,
  `eventualidad_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_detalle_eventualidades_empleados1` (`empleado_id`),
  KEY `fk_detalle_eventualidades_eventualidades1` (`eventualidad_id`),
  CONSTRAINT `fk_detalle_eventualidades_empleados1` FOREIGN KEY (`empleado_id`) REFERENCES `empleados` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `fk_detalle_eventualidades_eventualidades1` FOREIGN KEY (`eventualidad_id`) REFERENCES `eventualidades` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detalle_eventualidades`
--

LOCK TABLES `detalle_eventualidades` WRITE;
/*!40000 ALTER TABLE `detalle_eventualidades` DISABLE KEYS */;
/*!40000 ALTER TABLE `detalle_eventualidades` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detalle_recibos`
--

DROP TABLE IF EXISTS `detalle_recibos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detalle_recibos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `CONCEPTO` varchar(13) COLLATE utf8_unicode_ci NOT NULL,
  `NOMBRE` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `MONTO` decimal(19,5) NOT NULL,
  `recibo_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_detalle_recibos_recibos1` (`recibo_id`),
  CONSTRAINT `fk_detalle_recibos_recibos1` FOREIGN KEY (`recibo_id`) REFERENCES `recibos` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detalle_recibos`
--

LOCK TABLES `detalle_recibos` WRITE;
/*!40000 ALTER TABLE `detalle_recibos` DISABLE KEYS */;
/*!40000 ALTER TABLE `detalle_recibos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `empleados`
--

DROP TABLE IF EXISTS `empleados`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `empleados` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `NACIONALIDAD` varchar(15) COLLATE utf8_spanish_ci NOT NULL,
  `CEDULA` varchar(15) COLLATE utf8_spanish_ci NOT NULL,
  `SEXO` varchar(10) COLLATE utf8_spanish_ci NOT NULL,
  `NOMBRE` varchar(45) COLLATE utf8_spanish_ci NOT NULL,
  `APELLIDO` varchar(45) COLLATE utf8_spanish_ci NOT NULL,
  `FECHANAC` date NOT NULL,
  `INGRESO` date NOT NULL COMMENT 'FECHA DE INGRESO',
  `SALIDA` date DEFAULT NULL COMMENT 'Fecha de Salida de la empresa (Despido o otro)',
  `TELEFONO` varchar(15) COLLATE utf8_spanish_ci DEFAULT NULL,
  `CELULAR` varchar(15) COLLATE utf8_spanish_ci DEFAULT NULL,
  `DIRECCION` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL,
  `ESTADO` varchar(25) COLLATE utf8_spanish_ci DEFAULT NULL,
  `CIUDAD` varchar(20) COLLATE utf8_spanish_ci DEFAULT NULL,
  `MUNICIPIO` varchar(25) COLLATE utf8_spanish_ci DEFAULT NULL,
  `EMAIL` varchar(30) COLLATE utf8_spanish_ci DEFAULT NULL,
  `EDOCIVIL` varchar(15) COLLATE utf8_spanish_ci DEFAULT NULL COMMENT 'SOLTERO\nCASADO\nVIUDO\nDIVORCIADO\nCONCUBINATO\n',
  `ALFABETA` varchar(2) COLLATE utf8_spanish_ci DEFAULT NULL COMMENT 'SABE LEER?',
  `PRIMARIA` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL COMMENT 'DONDE ESTUDIO PRIMARIA',
  `SECUNDARIA` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL COMMENT 'DONDE ESTUDIO SCUNDARIA',
  `SUPERIOR` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL COMMENT 'DONDE CURSO ESTUDIOS UNIVERSITARIOS',
  `SANGRE` varchar(4) COLLATE utf8_spanish_ci DEFAULT NULL COMMENT 'O-\nO+\nA-\nA+\nB-\nB+\nAB-\nAB+',
  `PESO` int(11) DEFAULT NULL COMMENT 'EN KILOGRAMOS SIN DECIMALES',
  `EMFERMEDADES` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
  `OPERACIONES` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
  `ALERGICO` varchar(100) COLLATE utf8_spanish_ci DEFAULT NULL,
  `ESTATURA` int(11) DEFAULT NULL COMMENT 'ESTATURA EN CM',
  `COMPLEXION` varchar(10) COLLATE utf8_spanish_ci DEFAULT NULL COMMENT 'PEQUENA\nMEDIANA\nGRANDE',
  `TCAMISA` varchar(4) COLLATE utf8_spanish_ci DEFAULT NULL COMMENT 'TALLA CAMISA',
  `TPANTALOM` int(11) DEFAULT NULL COMMENT 'TALLA PANTALON',
  `TCALZADO` int(11) DEFAULT NULL COMMENT 'TALLA ZAPATO',
  `DISCAPACIDAD` varchar(45) COLLATE utf8_spanish_ci DEFAULT NULL,
  `NOMEMERGENCIA` varchar(45) COLLATE utf8_spanish_ci DEFAULT NULL,
  `TELEMERGECIA` varchar(11) COLLATE utf8_spanish_ci DEFAULT NULL,
  `BANCO` varchar(30) COLLATE utf8_spanish_ci DEFAULT NULL,
  `NCUENTA` varchar(30) COLLATE utf8_spanish_ci DEFAULT NULL,
  `TPAGO` varchar(10) COLLATE utf8_spanish_ci DEFAULT NULL,
  `grupo_id` int(11) NOT NULL,
  `localizacion_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_empleados_grupos1` (`grupo_id`),
  KEY `fk_empleados_localizaciones1` (`localizacion_id`),
  CONSTRAINT `fk_empleados_grupos1` FOREIGN KEY (`grupo_id`) REFERENCES `grupos` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_empleados_localizaciones1` FOREIGN KEY (`localizacion_id`) REFERENCES `localizaciones` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `empleados`
--

LOCK TABLES `empleados` WRITE;
/*!40000 ALTER TABLE `empleados` DISABLE KEYS */;
/*!40000 ALTER TABLE `empleados` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `eventualidades`
--

DROP TABLE IF EXISTS `eventualidades`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `eventualidades` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `NOMBRE` varchar(60) COLLATE utf8_spanish_ci NOT NULL,
  `TIPO` varchar(45) COLLATE utf8_spanish_ci NOT NULL COMMENT 'Asignacion o Deduccion',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `eventualidades`
--

LOCK TABLES `eventualidades` WRITE;
/*!40000 ALTER TABLE `eventualidades` DISABLE KEYS */;
/*!40000 ALTER TABLE `eventualidades` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `experiencias`
--

DROP TABLE IF EXISTS `experiencias`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `experiencias` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ORGANISMO` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `CARGO` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `FECHA_INI` date NOT NULL,
  `FECHA_FIN` date NOT NULL,
  `OBSERVACIONES` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
  `empleado_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_experiencias_empleados1` (`empleado_id`),
  CONSTRAINT `fk_experiencias_empleados1` FOREIGN KEY (`empleado_id`) REFERENCES `empleados` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `experiencias`
--

LOCK TABLES `experiencias` WRITE;
/*!40000 ALTER TABLE `experiencias` DISABLE KEYS */;
/*!40000 ALTER TABLE `experiencias` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `familiares`
--

DROP TABLE IF EXISTS `familiares`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `familiares` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `NOMBRE` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `PARENTESCO` varchar(45) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Hijo, Hija, Padre, Madre, Hermano, Hermana',
  `DISCAPACIDAD` varchar(2) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No' COMMENT 'Si o No',
  `INSTRUCCION` varchar(45) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Ninguna',
  `FECHA` date NOT NULL,
  `FECHA_EFEC` date NOT NULL COMMENT 'Fecha en la que se hace efectivo para el sistema',
  `empleado_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_familiares_empleados1` (`empleado_id`),
  CONSTRAINT `fk_familiares_empleados1` FOREIGN KEY (`empleado_id`) REFERENCES `empleados` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `familiares`
--

LOCK TABLES `familiares` WRITE;
/*!40000 ALTER TABLE `familiares` DISABLE KEYS */;
/*!40000 ALTER TABLE `familiares` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `feriados`
--

DROP TABLE IF EXISTS `feriados`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `feriados` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `FECHA` date NOT NULL,
  `DESCRIPCION` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `feriados`
--

LOCK TABLES `feriados` WRITE;
/*!40000 ALTER TABLE `feriados` DISABLE KEYS */;
/*!40000 ALTER TABLE `feriados` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `grupos`
--

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

--
-- Dumping data for table `grupos`
--

LOCK TABLES `grupos` WRITE;
/*!40000 ALTER TABLE `grupos` DISABLE KEYS */;
INSERT INTO `grupos` (`id`, `NOMBRE`) VALUES (1,'Empleado'),(2,'Obrero');
/*!40000 ALTER TABLE `grupos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `historiales`
--

DROP TABLE IF EXISTS `historiales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `historiales` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `SUELDO_BASE` decimal(19,5) NOT NULL,
  `FECHA_INI` date NOT NULL COMMENT 'Inicio ',
  `FECHA_FIN` date DEFAULT NULL COMMENT 'Fin',
  `FECHA_RET` date DEFAULT NULL COMMENT 'Fecha desde donde se va a pagar el sueldo retroactivo',
  `cargo_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_historiales_cargos1` (`cargo_id`),
  CONSTRAINT `fk_historiales_cargos1` FOREIGN KEY (`cargo_id`) REFERENCES `cargos` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `historiales`
--

LOCK TABLES `historiales` WRITE;
/*!40000 ALTER TABLE `historiales` DISABLE KEYS */;
/*!40000 ALTER TABLE `historiales` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `horas_extras`
--

DROP TABLE IF EXISTS `horas_extras`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `horas_extras` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `TIPO` varchar(45) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Nocturno, Domingos y Feriados',
  `FECHA` date NOT NULL,
  `COMENTARIO` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `empleado_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_horasextras_empleados1` (`empleado_id`),
  CONSTRAINT `fk_horasextras_empleados1` FOREIGN KEY (`empleado_id`) REFERENCES `empleados` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `horas_extras`
--

LOCK TABLES `horas_extras` WRITE;
/*!40000 ALTER TABLE `horas_extras` DISABLE KEYS */;
/*!40000 ALTER TABLE `horas_extras` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `islr`
--

DROP TABLE IF EXISTS `islr`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `islr` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `PORCENTAJE` decimal(19,5) NOT NULL,
  `FECHA` date NOT NULL,
  `empleado_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_islr_empleados1` (`empleado_id`),
  CONSTRAINT `fk_islr_empleados1` FOREIGN KEY (`empleado_id`) REFERENCES `empleados` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `islr`
--

LOCK TABLES `islr` WRITE;
/*!40000 ALTER TABLE `islr` DISABLE KEYS */;
/*!40000 ALTER TABLE `islr` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `localizaciones`
--

DROP TABLE IF EXISTS `localizaciones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `localizaciones` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `departamento_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_localizaciones_departamentos1` (`departamento_id`),
  CONSTRAINT `fk_localizaciones_departamentos1` FOREIGN KEY (`departamento_id`) REFERENCES `departamentos` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `localizaciones`
--

LOCK TABLES `localizaciones` WRITE;
/*!40000 ALTER TABLE `localizaciones` DISABLE KEYS */;
/*!40000 ALTER TABLE `localizaciones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `nominas`
--

DROP TABLE IF EXISTS `nominas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nominas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `FECHA_INI` date NOT NULL,
  `FECHA_FIN` date NOT NULL,
  `QUINCENA` varchar(45) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Primera Quincena , Segunda',
  `FECHA_ELA` datetime NOT NULL COMMENT 'Fecha de Elaboracion de la nomina',
  `SUELDO_MINIMO` decimal(19,5) NOT NULL,
  `BLOQUEAR` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `nominas`
--

LOCK TABLES `nominas` WRITE;
/*!40000 ALTER TABLE `nominas` DISABLE KEYS */;
/*!40000 ALTER TABLE `nominas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `prestamos`
--

DROP TABLE IF EXISTS `prestamos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `prestamos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `CANTIDAD` decimal(19,5) NOT NULL,
  `FECHA` date NOT NULL,
  `empleado_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_prestamos_empleados1` (`empleado_id`),
  CONSTRAINT `fk_prestamos_empleados1` FOREIGN KEY (`empleado_id`) REFERENCES `empleados` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `prestamos`
--

LOCK TABLES `prestamos` WRITE;
/*!40000 ALTER TABLE `prestamos` DISABLE KEYS */;
/*!40000 ALTER TABLE `prestamos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `programas`
--

DROP TABLE IF EXISTS `programas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `programas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `CODIGO` int(11) NOT NULL,
  `NOMBRE` varchar(45) COLLATE utf8_spanish_ci NOT NULL,
  `TIPO` varchar(45) COLLATE utf8_spanish_ci NOT NULL COMMENT 'Actividad  /  Proyecto',
  `NUMERO` int(11) NOT NULL COMMENT 'Numero de la Actividad o Proyecto',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `programas`
--

LOCK TABLES `programas` WRITE;
/*!40000 ALTER TABLE `programas` DISABLE KEYS */;
/*!40000 ALTER TABLE `programas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `recibos`
--

DROP TABLE IF EXISTS `recibos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `recibos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `CARGO` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `DEPARTAMENTO` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `MODALIDAD` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `SUELDO_BASE` decimal(19,5) DEFAULT NULL,
  `DIAS_LABORADOS` int(11) DEFAULT NULL,
  `nomina_id` int(11) NOT NULL,
  `empleado_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_recibos_nominas1` (`nomina_id`),
  KEY `fk_recibos_empleados1` (`empleado_id`),
  CONSTRAINT `fk_recibos_empleados1` FOREIGN KEY (`empleado_id`) REFERENCES `empleados` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `fk_recibos_nominas1` FOREIGN KEY (`nomina_id`) REFERENCES `nominas` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `recibos`
--

LOCK TABLES `recibos` WRITE;
/*!40000 ALTER TABLE `recibos` DISABLE KEYS */;
/*!40000 ALTER TABLE `recibos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `titulos`
--

DROP TABLE IF EXISTS `titulos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `titulos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `TITULO` varchar(45) COLLATE utf8_unicode_ci NOT NULL COMMENT 'T.S.U , Profesional Universitario , Post-Grado , Maestria , Doctorado',
  `ESPECIALIDAD` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `INSTITUCION` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  `FECHA` date NOT NULL,
  `empleado_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_titulos_empleados1` (`empleado_id`),
  CONSTRAINT `fk_titulos_empleados1` FOREIGN KEY (`empleado_id`) REFERENCES `empleados` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `titulos`
--

LOCK TABLES `titulos` WRITE;
/*!40000 ALTER TABLE `titulos` DISABLE KEYS */;
/*!40000 ALTER TABLE `titulos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tribunales`
--

DROP TABLE IF EXISTS `tribunales`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tribunales` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `CANTIDAD` decimal(19,5) NOT NULL,
  `FECHA` date NOT NULL,
  `empleado_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_tribunales_empleados1` (`empleado_id`),
  CONSTRAINT `fk_tribunales_empleados1` FOREIGN KEY (`empleado_id`) REFERENCES `empleados` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tribunales`
--

LOCK TABLES `tribunales` WRITE;
/*!40000 ALTER TABLE `tribunales` DISABLE KEYS */;
/*!40000 ALTER TABLE `tribunales` 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` int(11) NOT NULL AUTO_INCREMENT,
  `USERNAME` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `PASSWORD` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  `NOMBRE` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `APELLIDO` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `GRUPO` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_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` (`id`, `USERNAME`, `PASSWORD`, `NOMBRE`, `APELLIDO`, `GRUPO`) VALUES (1,'admin','21232f297a57a5a743894a0e4a801fc3','Administrador','','Administrador'),(2,'orlando.barreto@innovationandit.com.mx','5350c45de5b3fb78c71db40a285589c4','ORLANDO ','BARRETO','Usuario');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'innov936_RHH'
--

--
-- Dumping routines for database 'innov936_RHH'
--
/*!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-04-06 21:40:42