/*
Navicat MySQL Data Transfer

Source Server         : unicuces_gestordoc
Source Server Version : 50639
Source Host           : unicuces.edu.co:3306
Source Database       : cucese5_leto976

Target Server Type    : MYSQL
Target Server Version : 50639
File Encoding         : 65001

Date: 2018-03-27 01:39:02
*/


-- ----------------------------
-- Table structure for tblACLs
-- ----------------------------
CREATE TABLE `tblACLs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `target` int(11) NOT NULL DEFAULT '0',
  `targetType` tinyint(4) NOT NULL DEFAULT '0',
  `userID` int(11) NOT NULL DEFAULT '-1',
  `groupID` int(11) NOT NULL DEFAULT '-1',
  `mode` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblACLs
-- ----------------------------
INSERT INTO `tblACLs` VALUES ('1', '2', '1', '-1', '1', '3');
INSERT INTO `tblACLs` VALUES ('6', '2', '1', '5', '-1', '4');
INSERT INTO `tblACLs` VALUES ('7', '33', '1', '-1', '3', '2');
INSERT INTO `tblACLs` VALUES ('8', '33', '1', '10', '-1', '3');

-- ----------------------------
-- Table structure for tblAttributeDefinitions
-- ----------------------------
CREATE TABLE `tblAttributeDefinitions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `objtype` tinyint(4) NOT NULL DEFAULT '0',
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `multiple` tinyint(4) NOT NULL DEFAULT '0',
  `minvalues` int(11) NOT NULL DEFAULT '0',
  `maxvalues` int(11) NOT NULL DEFAULT '0',
  `valueset` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblAttributeDefinitions
-- ----------------------------

-- ----------------------------
-- Table structure for tblCategory
-- ----------------------------
CREATE TABLE `tblCategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblCategory
-- ----------------------------
INSERT INTO `tblCategory` VALUES ('1', '');
INSERT INTO `tblCategory` VALUES ('2', 'Procedimientos');

-- ----------------------------
-- Table structure for tblDirPath
-- ----------------------------
CREATE TABLE `tblDirPath` (
  `dirID` int(11) NOT NULL AUTO_INCREMENT,
  `dirPath` varchar(255) NOT NULL,
  PRIMARY KEY (`dirID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblDirPath
-- ----------------------------

-- ----------------------------
-- Table structure for tblDocumentApproveLog
-- ----------------------------
CREATE TABLE `tblDocumentApproveLog` (
  `approveLogID` int(11) NOT NULL AUTO_INCREMENT,
  `approveID` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `comment` text NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`approveLogID`),
  KEY `tblDocumentApproveLog_approve` (`approveID`),
  KEY `tblDocumentApproveLog_user` (`userID`),
  CONSTRAINT `tblDocumentApproveLog_approve` FOREIGN KEY (`approveID`) REFERENCES `tblDocumentApprovers` (`approveID`) ON DELETE CASCADE,
  CONSTRAINT `tblDocumentApproveLog_user` FOREIGN KEY (`userID`) REFERENCES `tblUsers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblDocumentApproveLog
-- ----------------------------
INSERT INTO `tblDocumentApproveLog` VALUES ('1', '1', '0', '', '2017-06-16 14:26:42', '5');
INSERT INTO `tblDocumentApproveLog` VALUES ('2', '2', '0', '', '2017-08-01 15:15:20', '5');
INSERT INTO `tblDocumentApproveLog` VALUES ('3', '3', '0', '', '2017-08-01 15:15:20', '5');
INSERT INTO `tblDocumentApproveLog` VALUES ('4', '4', '0', '', '2017-10-03 16:59:52', '1');
INSERT INTO `tblDocumentApproveLog` VALUES ('5', '5', '0', '', '2017-10-03 17:24:13', '5');
INSERT INTO `tblDocumentApproveLog` VALUES ('8', '8', '0', '', '2017-10-05 09:44:56', '5');
INSERT INTO `tblDocumentApproveLog` VALUES ('9', '9', '0', '', '2017-10-05 10:00:14', '5');
INSERT INTO `tblDocumentApproveLog` VALUES ('11', '11', '0', '', '2018-02-20 09:57:09', '5');
INSERT INTO `tblDocumentApproveLog` VALUES ('12', '12', '0', '', '2018-03-07 15:50:38', '5');

-- ----------------------------
-- Table structure for tblDocumentApprovers
-- ----------------------------
CREATE TABLE `tblDocumentApprovers` (
  `approveID` int(11) NOT NULL AUTO_INCREMENT,
  `documentID` int(11) NOT NULL DEFAULT '0',
  `version` smallint(5) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `required` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`approveID`),
  UNIQUE KEY `documentID` (`documentID`,`version`,`type`,`required`),
  CONSTRAINT `tblDocumentApprovers_document` FOREIGN KEY (`documentID`) REFERENCES `tblDocuments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblDocumentApprovers
-- ----------------------------
INSERT INTO `tblDocumentApprovers` VALUES ('1', '122', '1', '0', '3');
INSERT INTO `tblDocumentApprovers` VALUES ('2', '143', '1', '0', '3');
INSERT INTO `tblDocumentApprovers` VALUES ('3', '143', '1', '0', '10');
INSERT INTO `tblDocumentApprovers` VALUES ('4', '150', '1', '1', '2');
INSERT INTO `tblDocumentApprovers` VALUES ('5', '151', '1', '1', '2');
INSERT INTO `tblDocumentApprovers` VALUES ('8', '154', '1', '0', '16');
INSERT INTO `tblDocumentApprovers` VALUES ('9', '155', '1', '0', '12');
INSERT INTO `tblDocumentApprovers` VALUES ('11', '166', '1', '1', '2');
INSERT INTO `tblDocumentApprovers` VALUES ('12', '168', '1', '0', '12');

-- ----------------------------
-- Table structure for tblDocumentAttributes
-- ----------------------------
CREATE TABLE `tblDocumentAttributes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `document` int(11) DEFAULT NULL,
  `attrdef` int(11) DEFAULT NULL,
  `value` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `document` (`document`,`attrdef`),
  KEY `tblDocumentAttributes_attrdef` (`attrdef`),
  CONSTRAINT `tblDocumentAttributes_attrdef` FOREIGN KEY (`attrdef`) REFERENCES `tblAttributeDefinitions` (`id`),
  CONSTRAINT `tblDocumentAttributes_document` FOREIGN KEY (`document`) REFERENCES `tblDocuments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblDocumentAttributes
-- ----------------------------

-- ----------------------------
-- Table structure for tblDocumentCategory
-- ----------------------------
CREATE TABLE `tblDocumentCategory` (
  `categoryID` int(11) NOT NULL DEFAULT '0',
  `documentID` int(11) NOT NULL DEFAULT '0',
  KEY `tblDocumentCategory_category` (`categoryID`),
  KEY `tblDocumentCategory_document` (`documentID`),
  CONSTRAINT `tblDocumentCategory_category` FOREIGN KEY (`categoryID`) REFERENCES `tblCategory` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tblDocumentCategory_document` FOREIGN KEY (`documentID`) REFERENCES `tblDocuments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblDocumentCategory
-- ----------------------------

-- ----------------------------
-- Table structure for tblDocumentContent
-- ----------------------------
CREATE TABLE `tblDocumentContent` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `document` int(11) NOT NULL DEFAULT '0',
  `version` smallint(5) unsigned NOT NULL,
  `comment` text,
  `date` int(12) DEFAULT NULL,
  `createdBy` int(11) DEFAULT NULL,
  `dir` varchar(255) NOT NULL DEFAULT '',
  `orgFileName` varchar(150) NOT NULL DEFAULT '',
  `fileType` varchar(10) NOT NULL DEFAULT '',
  `mimeType` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `document` (`document`,`version`),
  CONSTRAINT `tblDocumentContent_document` FOREIGN KEY (`document`) REFERENCES `tblDocuments` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=188 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblDocumentContent
-- ----------------------------
INSERT INTO `tblDocumentContent` VALUES ('14', '14', '1', 'Registro de proveedores permanentes de la institución', '1432592632', '5', '14/', 'FR01-Lista de proveedores v1..xls', '.xls', 'application/vnd.ms-excel');
INSERT INTO `tblDocumentContent` VALUES ('15', '15', '1', 'Es un registro que emite la institución para solicitar insumos o equipos; indicando cantidad y costo.', '1432592749', '5', '15/', 'FR03-Ordenes de Compra.xlsx', '.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
INSERT INTO `tblDocumentContent` VALUES ('16', '16', '1', 'Registro de evaluación donde se califican criterios del proveedor ', '1432592813', '5', '16/', 'FR02-Evaluacion a Proveedoores.xls', '.xls', 'application/vnd.ms-excel');
INSERT INTO `tblDocumentContent` VALUES ('17', '17', '1', 'Registro de inventario de insumos, equipos y otros', '1432592888', '5', '17/', 'FR04- Inventario.xlsx', '.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
INSERT INTO `tblDocumentContent` VALUES ('18', '18', '1', 'Registro de insumos requeridos por cada área ', '1432592940', '5', '18/', 'FR05-Solicitud de Insumos por area.xlsx', '.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
INSERT INTO `tblDocumentContent` VALUES ('19', '19', '1', '', '1432593698', '5', '19/', 'PR01-COMPRAS.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('20', '20', '1', '', '1432593717', '5', '20/', 'PR02-SELECCION PROVEEDORES.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('22', '22', '1', 'Documento guia de manejo y uso de la imagen institucional', '1432593879', '5', '22/', 'Manual de Identidad Corporativa UNICUCES.docx', '.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document');
INSERT INTO `tblDocumentContent` VALUES ('42', '42', '1', '', '1438209493', '5', '42/', 'Convenio Practicas.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('45', '45', '1', '', '1438295331', '5', '45/', 'FR2-Solicitud  hoja de vida.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('46', '46', '1', '', '1438295352', '5', '46/', 'FR3-Seguimiento a practicantes.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('47', '47', '1', '', '1438295381', '5', '47/', 'FR04-FR05 ESTUDIANTES EN PRACTICA Y PENDIENTES.xlsx', '.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
INSERT INTO `tblDocumentContent` VALUES ('61', '61', '1', '', '1438295942', '5', '61/', 'Evaluacion a Proveedoores 2015.xls', '.xls', 'application/vnd.ms-excel');
INSERT INTO `tblDocumentContent` VALUES ('62', '62', '1', '', '1438295989', '5', '62/', 'Proyecto Plan De Accion Bienestar Universitario  2014-2 (Bienestar y Vicerrectoria Academica).pdf', '.pdf', 'application/pdf');
INSERT INTO `tblDocumentContent` VALUES ('68', '68', '1', 'Sistema de Gestión de la Calidad- Requisitos NTC-ISO 9001 (23-09-2015) ', '1489764487', '5', '68/', 'Norma-ISO-9001-2015.pdf', '.pdf', 'application/pdf');
INSERT INTO `tblDocumentContent` VALUES ('70', '70', '1', '', '1495491038', '5', '70/', 'PR-04 AUDITORIA.doc', '.doc', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('71', '71', '1', '', '1495491041', '5', '71/', 'PR-05 PRODUCTO SERVICIO NO CONFORME.doc', '.doc', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('81', '81', '1', '', '1495569099', '5', '81/', 'FR01- ASESORÍA Y ACOMPAÑAMIENTO PARA CONVOCATORIAS INTERNACIONALES.docx', '.docx', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('82', '82', '1', '', '1495569100', '5', '82/', 'FR-02 Listado Convenios Institucionales.xlsx', '.xlsx', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('83', '83', '1', '', '1495569101', '5', '83/', 'FR02-Registro Docentes Maestrìa UMECIT.docx', '.docx', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('84', '84', '1', '', '1495569103', '5', '84/', 'FR03-Experiencia de Participacion en Actividad de Cooperacion Academica-Profesional.docx', '.docx', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('85', '85', '1', '', '1495569104', '5', '85/', 'FR04-Visitante Nacional e Internacional actividad academica de cooperacion..docx', '.docx', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('86', '86', '1', '', '1495569104', '5', '86/', 'FR05-SOLICITUD DE EQUIPOS AUDIOVISUALES Y ADECUACIÒN DE ESPACIO FISICO PARA REALIZACIÒN DE ACTIVIDADES INSTITUCIONALES.docx', '.docx', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('87', '87', '1', '', '1495569105', '5', '87/', 'FR06-REGISTRO DE PARTICIPACION EN REDES U ORGANISMOS NACIONALES O INTERNACIONALES.docx', '.docx', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('88', '88', '1', '', '1495569106', '5', '88/', 'FR07-PLAN BITACORA DE CONTROL DE ACTIVIDADES COMPLEMENTARIAS DE BILINGUISMO.docx', '.docx', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('99', '99', '1', '', '1495744290', '5', '99/', 'F01-syllabus presencial.doc', '.doc', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('100', '100', '1', '', '1495744292', '5', '100/', 'FR-03 PLANEACION DOCENTE.xlsx', '.xlsx', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('101', '101', '1', '', '1495744293', '5', '101/', 'FR02- EVALUACIÓN DOCENTE.xls', '.xls', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('102', '102', '1', '', '1495744294', '5', '102/', 'FR04- Disponibilidad Docente.xlsx', '.xlsx', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('103', '103', '1', '', '1495744296', '5', '103/', 'FR05-CATEDRA ABIERTA.doc', '.doc', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('104', '104', '1', '', '1495744854', '5', '104/', 'REGLAMENTO DE PROYECCION SOCIAL.pdf', '.pdf', 'application/pdf');
INSERT INTO `tblDocumentContent` VALUES ('105', '105', '1', '', '1495745038', '5', '105/', 'DO-01 PROGRAMA DE INDUCCION.docx', '.docx', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('106', '106', '1', '', '1495745047', '5', '106/', 'DO-02PORTAFOLIO DE ACTIVIDADES DE BIENESTAR INSTITUCIONAL.xlsx', '.xlsx', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('107', '107', '1', '', '1495745132', '5', '107/', 'FR-01 MATRICULA DE ACTIVIDADES DEPORTIVAS Y CULTURALES DE BIENESTAR.doc', '.doc', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('108', '108', '1', '', '1495745133', '5', '108/', 'FR-02 SOLICITUD DE RECURSOS PARA ACTIVIDADES DE BIENESTAR.xlsx', '.xlsx', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('109', '109', '1', '', '1495745134', '5', '109/', 'FR-04 ENCUESTA DE CONOCIMIENTO - ACTIVIDADES DE BIENESTAR.xlsx', '.xlsx', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('110', '110', '1', '', '1495745137', '5', '110/', 'FR-05 FICHA DE PSICOLOGIA.xls', '.xls', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('111', '111', '1', '', '1495745139', '5', '111/', 'FR-06 PARTICIPACION ACTIVIDADES DE BIENESTAR.xlsx', '.xlsx', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('112', '112', '1', '', '1495745140', '5', '112/', 'FR-07 ENCUESTA DE SATISFACCIÓN.xlsx', '.xlsx', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('113', '113', '1', '', '1495745141', '5', '113/', 'FR-08 PLAN DE ACTIVIDADES Y PRESUPUESTOS DE BIENESTAR INSTITUCIONAL.xlsx', '.xlsx', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('114', '114', '1', '', '1495745892', '5', '114/', 'PR01- VINCULACION Y ADMINISTRACION DE PERSONAL.doc', '.doc', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('115', '115', '1', '', '1495745893', '5', '115/', 'PR02- INDUCCION Y REINDUCCION.doc', '.doc', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('120', '120', '1', '', '1495746477', '5', '120/', 'Formatos-Entrevistas.xlsx', '.xlsx', 'content/unknown');
INSERT INTO `tblDocumentContent` VALUES ('121', '121', '1', '', '1496177253', '5', '121/', 'PR-01 Vinculemonos.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('122', '122', '1', '', '1497641202', '5', '122/', 'DO-05 Normograma SGSST.xls', '.xls', 'application/vnd.ms-excel');
INSERT INTO `tblDocumentContent` VALUES ('124', '123', '1', '', '1499371369', '5', '123/', 'PR01- Inscripcion,Admision y Matricula.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('125', '124', '1', '', '1499371409', '5', '124/', 'PR02- Gestion novedades matricula.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('126', '125', '1', '', '1499371477', '5', '125/', 'FR-01 CANCELACION ADICION ASIGNATURAS.xls', '.xls', 'application/vnd.ms-excel');
INSERT INTO `tblDocumentContent` VALUES ('127', '126', '1', '', '1499371501', '5', '126/', 'FR-02 HORARIO DE CLASES - INSCRIPCION.xls', '.xls', 'application/vnd.ms-excel');
INSERT INTO `tblDocumentContent` VALUES ('128', '127', '1', '', '1499371743', '5', '127/', 'Caracterizaciones Finales 2016.xls', '.xls', 'application/vnd.ms-excel');
INSERT INTO `tblDocumentContent` VALUES ('129', '128', '1', '', '1499371926', '5', '128/', 'CONVENIO TIPO APRENDICES ENTRE UNICUCES Y XXX NOMBRE DE EMPRESA XXX.docx', '.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document');
INSERT INTO `tblDocumentContent` VALUES ('130', '129', '1', '', '1499371978', '5', '129/', 'CONVENIO TIPO PASANTÍAS ENTRE UNICUCES Y XXX NOMBRE DE EMPRESA XXX.docx', '.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document');
INSERT INTO `tblDocumentContent` VALUES ('132', '130', '1', '', '1499372061', '5', '130/', 'FR01 - FORMATO HOJA DE VIDA - ESTUDIANTES.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('133', '131', '1', '', '1499372260', '5', '131/', 'PR01 - GESTION DE EMPRENDIMIENTO.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('134', '132', '1', '', '1499372288', '5', '132/', 'PR02- Gestion con el Egresado.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('135', '133', '1', '', '1499372400', '5', '133/', 'PR01- CONTROL INFORMACION DOCUMENTADA.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('136', '134', '1', '', '1499372476', '5', '134/', 'PR-03 MEJORA CONTINUA.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('139', '137', '1', '', '1499373693', '5', '137/', 'PR01- DISENO SEGUIMIETNO CURRICULAR.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('140', '138', '1', '', '1499373720', '5', '138/', 'PR02-EVALUACION DOCENTE.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('141', '139', '1', '', '1499373742', '5', '139/', 'PR03- Prestamo de libros.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('142', '140', '1', '', '1499373793', '5', '140/', 'PR04- PEI y Planes de estudio.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('143', '141', '1', '', '1499373795', '5', '141/', 'PR04- PEI y Planes de estudio.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('144', '142', '1', '', '1499373858', '5', '142/', 'PR05- GESTION CURRICULAR.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('145', '143', '1', '', '1501618520', '5', '143/', 'Requisito vs Producto.xlsx', '.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
INSERT INTO `tblDocumentContent` VALUES ('154', '150', '1', '', '1507067992', '1', '150/', 'PR01- REVISION POR LA DIRECCION.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('155', '151', '1', '', '1507069453', '5', '151/', 'ISO_14001-2015.pdf', '.pdf', 'application/pdf');
INSERT INTO `tblDocumentContent` VALUES ('158', '154', '1', '', '1507214695', '5', '154/', 'DO-09 MATRIZ PROCESOS Vs. NORMA.pdf', '.pdf', 'application/pdf');
INSERT INTO `tblDocumentContent` VALUES ('159', '155', '1', '', '1507215611', '5', '155/', 'FR01- PONDERACION DE FACTORES Y CARACTERISTICAS.xlsx', '.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
INSERT INTO `tblDocumentContent` VALUES ('160', '156', '1', '', '1507299448', '5', '156/', 'NTC ISO 14001 2015.pdf', '.pdf', 'application/pdf');
INSERT INTO `tblDocumentContent` VALUES ('161', '157', '1', 'CNA', '1507299560', '5', '157/', 'LINEAMIENTOS ACREDITACION PREGRADO.pdf', '.pdf', 'application/pdf');
INSERT INTO `tblDocumentContent` VALUES ('162', '158', '1', '', '1507299837', '5', '158/', 'LINEAMIENTOS ACREDITACION INSTITUCIONAL.pdf', '.pdf', 'application/pdf');
INSERT INTO `tblDocumentContent` VALUES ('163', '159', '1', '', '1507299998', '5', '159/', 'Resolucion 1111 de 2017.pdf', '.pdf', 'application/pdf');
INSERT INTO `tblDocumentContent` VALUES ('164', '160', '1', '', '1507300166', '5', '160/', 'Decreto 1072 de 2015 Decreto Unico Sector Trabajo.pdf', '.pdf', 'application/pdf');
INSERT INTO `tblDocumentContent` VALUES ('165', '161', '1', '', '1507300261', '5', '161/', 'DECRETO 1443 DEL 31 DE JULIO DE 2014 DIPOSICIONES SG-SST.pdf', '.pdf', 'application/pdf');
INSERT INTO `tblDocumentContent` VALUES ('171', '166', '1', '', '1519138625', '5', '166/', 'DO-10 Direccionamiento Estrategico.pdf', '.pdf', 'application/pdf');
INSERT INTO `tblDocumentContent` VALUES ('172', '167', '1', '', '1519138889', '5', '167/', 'DO-01Mapa de Procesos UNICUCES.pdf', '.pdf', 'application/pdf');
INSERT INTO `tblDocumentContent` VALUES ('173', '168', '1', '', '1520455837', '5', '168/', 'PR01- AUTOEVALUACIÓN INSTITUCIONAL Y DE PROGRAMAS ACADÉMICOS.pdf', '.pdf', 'application/pdf');
INSERT INTO `tblDocumentContent` VALUES ('175', '170', '1', '', '1520989003', '5', '170/', 'Estructura-Organizacional-UNICUCES.pdf', '.pdf', 'application/pdf');
INSERT INTO `tblDocumentContent` VALUES ('176', '171', '1', '', '1521146305', '5', '171/', 'Estrucutura Organizacional 2018.xls', '.xls', 'application/vnd.ms-excel');
INSERT INTO `tblDocumentContent` VALUES ('177', '172', '1', '', '1521151334', '5', '172/', 'F01- Informe de Prestamo.xlsx', '.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
INSERT INTO `tblDocumentContent` VALUES ('178', '173', '1', '', '1521151375', '5', '173/', 'F02- Informe de Asistencia.xlsx', '.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
INSERT INTO `tblDocumentContent` VALUES ('179', '174', '1', '', '1521151422', '5', '174/', 'F03-CONTROL SEMANAL ASISTENCIA DOCENTES.xlsx', '.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
INSERT INTO `tblDocumentContent` VALUES ('180', '175', '1', '', '1521151562', '5', '175/', 'F04- Informe de Reporte de funcionamiento de salas o equipos salas.xlsx', '.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
INSERT INTO `tblDocumentContent` VALUES ('181', '176', '1', '', '1521151742', '5', '176/', 'F05- AUDIO_VISUALES.xls', '.xls', 'application/vnd.ms-excel');
INSERT INTO `tblDocumentContent` VALUES ('182', '177', '1', '', '1521151794', '5', '177/', 'F06-IMPRESION.xls', '.xls', 'application/vnd.ms-excel');
INSERT INTO `tblDocumentContent` VALUES ('183', '178', '1', '', '1521151857', '5', '178/', 'MANUAL DE PROCEDIMIENTOS DE SEGURIDAD - UNICUCES.pdf', '.pdf', 'application/pdf');
INSERT INTO `tblDocumentContent` VALUES ('184', '179', '1', '', '1521152638', '5', '179/', 'FR02-LISTADO INFORMACION DOCUMENTADA.xlsx', '.xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
INSERT INTO `tblDocumentContent` VALUES ('185', '180', '1', '', '1521152672', '5', '180/', 'FR03- CONTROL DE ASISTENCIA.doc', '.doc', 'application/msword');
INSERT INTO `tblDocumentContent` VALUES ('186', '181', '1', '', '1521152741', '5', '181/', 'RG-09 Encuesta Satisfaccion programas de educacion continua.docx', '.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document');
INSERT INTO `tblDocumentContent` VALUES ('187', '182', '1', '', '1521152896', '5', '182/', 'DO-07 TABLAS RETENCION.xls', '.xls', 'application/vnd.ms-excel');

-- ----------------------------
-- Table structure for tblDocumentContentAttributes
-- ----------------------------
CREATE TABLE `tblDocumentContentAttributes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` int(11) DEFAULT NULL,
  `attrdef` int(11) DEFAULT NULL,
  `value` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `content` (`content`,`attrdef`),
  KEY `tblDocumentContentAttributes_attrdef` (`attrdef`),
  CONSTRAINT `tblDocumentContentAttributes_attrdef` FOREIGN KEY (`attrdef`) REFERENCES `tblAttributeDefinitions` (`id`),
  CONSTRAINT `tblDocumentContentAttributes_document` FOREIGN KEY (`content`) REFERENCES `tblDocumentContent` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblDocumentContentAttributes
-- ----------------------------

-- ----------------------------
-- Table structure for tblDocumentFiles
-- ----------------------------
CREATE TABLE `tblDocumentFiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `document` int(11) NOT NULL DEFAULT '0',
  `userID` int(11) NOT NULL DEFAULT '0',
  `comment` text,
  `name` varchar(150) DEFAULT NULL,
  `date` int(12) DEFAULT NULL,
  `dir` varchar(255) NOT NULL DEFAULT '',
  `orgFileName` varchar(150) NOT NULL DEFAULT '',
  `fileType` varchar(10) NOT NULL DEFAULT '',
  `mimeType` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `tblDocumentFiles_document` (`document`),
  KEY `tblDocumentFiles_user` (`userID`),
  CONSTRAINT `tblDocumentFiles_document` FOREIGN KEY (`document`) REFERENCES `tblDocuments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tblDocumentFiles_user` FOREIGN KEY (`userID`) REFERENCES `tblUsers` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblDocumentFiles
-- ----------------------------

-- ----------------------------
-- Table structure for tblDocumentLinks
-- ----------------------------
CREATE TABLE `tblDocumentLinks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `document` int(11) NOT NULL DEFAULT '0',
  `target` int(11) NOT NULL DEFAULT '0',
  `userID` int(11) NOT NULL DEFAULT '0',
  `public` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `tblDocumentLinks_document` (`document`),
  KEY `tblDocumentLinks_user` (`userID`),
  CONSTRAINT `tblDocumentLinks_document` FOREIGN KEY (`document`) REFERENCES `tblDocuments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tblDocumentLinks_user` FOREIGN KEY (`userID`) REFERENCES `tblUsers` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblDocumentLinks
-- ----------------------------

-- ----------------------------
-- Table structure for tblDocumentLocks
-- ----------------------------
CREATE TABLE `tblDocumentLocks` (
  `document` int(11) NOT NULL DEFAULT '0',
  `userID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`document`),
  KEY `tblDocumentLocks_user` (`userID`),
  CONSTRAINT `tblDocumentLocks_document` FOREIGN KEY (`document`) REFERENCES `tblDocuments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tblDocumentLocks_user` FOREIGN KEY (`userID`) REFERENCES `tblUsers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblDocumentLocks
-- ----------------------------

-- ----------------------------
-- Table structure for tblDocumentReviewers
-- ----------------------------
CREATE TABLE `tblDocumentReviewers` (
  `reviewID` int(11) NOT NULL AUTO_INCREMENT,
  `documentID` int(11) NOT NULL DEFAULT '0',
  `version` smallint(5) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `required` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`reviewID`),
  UNIQUE KEY `documentID` (`documentID`,`version`,`type`,`required`),
  CONSTRAINT `tblDocumentReviewers_document` FOREIGN KEY (`documentID`) REFERENCES `tblDocuments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblDocumentReviewers
-- ----------------------------
INSERT INTO `tblDocumentReviewers` VALUES ('15', '14', '1', '0', '4');
INSERT INTO `tblDocumentReviewers` VALUES ('16', '15', '1', '0', '4');
INSERT INTO `tblDocumentReviewers` VALUES ('17', '16', '1', '0', '4');
INSERT INTO `tblDocumentReviewers` VALUES ('18', '17', '1', '0', '4');
INSERT INTO `tblDocumentReviewers` VALUES ('19', '18', '1', '0', '4');
INSERT INTO `tblDocumentReviewers` VALUES ('20', '19', '1', '0', '4');
INSERT INTO `tblDocumentReviewers` VALUES ('21', '20', '1', '0', '4');
INSERT INTO `tblDocumentReviewers` VALUES ('23', '22', '1', '0', '4');
INSERT INTO `tblDocumentReviewers` VALUES ('43', '42', '1', '0', '4');
INSERT INTO `tblDocumentReviewers` VALUES ('46', '45', '1', '0', '4');
INSERT INTO `tblDocumentReviewers` VALUES ('47', '46', '1', '0', '4');
INSERT INTO `tblDocumentReviewers` VALUES ('48', '47', '1', '0', '4');
INSERT INTO `tblDocumentReviewers` VALUES ('62', '61', '1', '0', '4');
INSERT INTO `tblDocumentReviewers` VALUES ('63', '62', '1', '0', '4');
INSERT INTO `tblDocumentReviewers` VALUES ('69', '68', '1', '0', '4');
INSERT INTO `tblDocumentReviewers` VALUES ('70', '122', '1', '0', '8');
INSERT INTO `tblDocumentReviewers` VALUES ('71', '143', '1', '0', '3');
INSERT INTO `tblDocumentReviewers` VALUES ('72', '143', '1', '0', '10');
INSERT INTO `tblDocumentReviewers` VALUES ('73', '150', '1', '0', '9');
INSERT INTO `tblDocumentReviewers` VALUES ('74', '151', '1', '1', '2');
INSERT INTO `tblDocumentReviewers` VALUES ('77', '154', '1', '0', '16');
INSERT INTO `tblDocumentReviewers` VALUES ('78', '155', '1', '0', '12');
INSERT INTO `tblDocumentReviewers` VALUES ('80', '166', '1', '1', '2');
INSERT INTO `tblDocumentReviewers` VALUES ('81', '168', '1', '0', '12');

-- ----------------------------
-- Table structure for tblDocumentReviewLog
-- ----------------------------
CREATE TABLE `tblDocumentReviewLog` (
  `reviewLogID` int(11) NOT NULL AUTO_INCREMENT,
  `reviewID` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `comment` text NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`reviewLogID`),
  KEY `tblDocumentReviewLog_review` (`reviewID`),
  KEY `tblDocumentReviewLog_user` (`userID`),
  CONSTRAINT `tblDocumentReviewLog_review` FOREIGN KEY (`reviewID`) REFERENCES `tblDocumentReviewers` (`reviewID`) ON DELETE CASCADE,
  CONSTRAINT `tblDocumentReviewLog_user` FOREIGN KEY (`userID`) REFERENCES `tblUsers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=140 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblDocumentReviewLog
-- ----------------------------
INSERT INTO `tblDocumentReviewLog` VALUES ('15', '15', '0', '', '2015-05-25 17:23:52', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('16', '16', '0', '', '2015-05-25 17:25:49', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('17', '17', '0', '', '2015-05-25 17:26:53', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('18', '18', '0', '', '2015-05-25 17:28:08', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('19', '19', '0', '', '2015-05-25 17:29:00', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('20', '20', '0', '', '2015-05-25 17:41:38', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('21', '21', '0', '', '2015-05-25 17:41:57', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('23', '23', '0', '', '2015-05-25 17:44:39', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('43', '43', '0', '', '2015-07-29 17:38:13', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('46', '46', '0', '', '2015-07-30 17:28:51', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('47', '47', '0', '', '2015-07-30 17:29:12', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('48', '48', '0', '', '2015-07-30 17:29:41', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('62', '62', '0', '', '2015-07-30 17:39:02', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('63', '63', '0', '', '2015-07-30 17:39:49', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('69', '69', '0', '', '2017-03-17 10:28:07', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('70', '69', '-2', 'Reviewer removed from process', '2017-03-21 15:24:41', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('76', '63', '-2', 'Reviewer removed from process', '2017-03-21 15:24:41', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('77', '62', '-2', 'Reviewer removed from process', '2017-03-21 15:24:41', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('91', '48', '-2', 'Reviewer removed from process', '2017-03-21 15:24:42', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('92', '47', '-2', 'Reviewer removed from process', '2017-03-21 15:24:42', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('93', '46', '-2', 'Reviewer removed from process', '2017-03-21 15:24:42', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('96', '43', '-2', 'Reviewer removed from process', '2017-03-21 15:24:42', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('116', '23', '-2', 'Reviewer removed from process', '2017-03-21 15:24:43', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('118', '21', '-2', 'Reviewer removed from process', '2017-03-21 15:24:43', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('119', '20', '-2', 'Reviewer removed from process', '2017-03-21 15:24:43', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('120', '19', '-2', 'Reviewer removed from process', '2017-03-21 15:24:43', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('121', '18', '-2', 'Reviewer removed from process', '2017-03-21 15:24:43', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('122', '17', '-2', 'Reviewer removed from process', '2017-03-21 15:24:43', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('123', '16', '-2', 'Reviewer removed from process', '2017-03-21 15:24:43', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('124', '15', '-2', 'Reviewer removed from process', '2017-03-21 15:24:43', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('125', '70', '0', '', '2017-06-16 14:26:42', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('126', '71', '0', '', '2017-08-01 15:15:20', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('127', '72', '0', '', '2017-08-01 15:15:20', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('128', '73', '0', '', '2017-10-03 16:59:52', '1');
INSERT INTO `tblDocumentReviewLog` VALUES ('129', '74', '0', '', '2017-10-03 17:24:13', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('132', '77', '0', '', '2017-10-05 09:44:55', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('136', '78', '0', '', '2017-10-05 10:00:13', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('138', '80', '0', '', '2018-02-20 09:57:09', '5');
INSERT INTO `tblDocumentReviewLog` VALUES ('139', '81', '0', '', '2018-03-07 15:50:38', '5');

-- ----------------------------
-- Table structure for tblDocuments
-- ----------------------------
CREATE TABLE `tblDocuments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) DEFAULT NULL,
  `comment` text,
  `date` int(12) DEFAULT NULL,
  `expires` int(12) DEFAULT NULL,
  `owner` int(11) DEFAULT NULL,
  `folder` int(11) DEFAULT NULL,
  `folderList` text NOT NULL,
  `inheritAccess` tinyint(1) NOT NULL DEFAULT '1',
  `defaultAccess` tinyint(4) NOT NULL DEFAULT '0',
  `locked` int(11) NOT NULL DEFAULT '-1',
  `keywords` text NOT NULL,
  `sequence` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `tblDocuments_folder` (`folder`),
  KEY `tblDocuments_owner` (`owner`),
  CONSTRAINT `tblDocuments_folder` FOREIGN KEY (`folder`) REFERENCES `tblFolders` (`id`),
  CONSTRAINT `tblDocuments_owner` FOREIGN KEY (`owner`) REFERENCES `tblUsers` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=183 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblDocuments
-- ----------------------------
INSERT INTO `tblDocuments` VALUES ('14', 'FR01-Lista de proveedores', 'Registro de proveedores permanentes de la institución', '1432592632', '0', '5', '12', ':1:2:4:12:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('15', 'FR03-Ordenes de Compra', 'Es un registro que emite la institución para solicitar insumos o equipos; indicando cantidad y costo.', '1432592749', '0', '5', '12', ':1:2:4:12:', '1', '2', '-1', '', '2');
INSERT INTO `tblDocuments` VALUES ('16', 'FR02-Evaluacion de proveedores', 'Registro de evaluación donde se califican criterios del proveedor ', '1432592813', '0', '5', '12', ':1:2:4:12:', '1', '2', '-1', '', '3');
INSERT INTO `tblDocuments` VALUES ('17', 'FR04-Inventario', 'Registro de inventario de insumos, equipos y otros', '1432592888', '0', '5', '12', ':1:2:4:12:', '1', '2', '-1', '', '4');
INSERT INTO `tblDocuments` VALUES ('18', 'FR05-Solicitud de insumos por area', 'Registro de insumos requeridos por cada área ', '1432592940', '0', '5', '12', ':1:2:4:12:', '1', '2', '-1', '', '5');
INSERT INTO `tblDocuments` VALUES ('19', 'PR01-Procedimiento compras', '', '1432593698', '0', '5', '12', ':1:2:4:12:', '1', '2', '-1', '', '6');
INSERT INTO `tblDocuments` VALUES ('20', 'PR02-Selección de Proveedores', '', '1432593717', '0', '5', '12', ':1:2:4:12:', '1', '2', '-1', '', '7');
INSERT INTO `tblDocuments` VALUES ('22', 'Manual de Identidad Corporativa', 'Documento guia de manejo y uso de la imagen institucional', '1432593879', '0', '5', '26', ':1:2:6:9:26:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('42', 'Convenio de practicas', '', '1438209493', '0', '5', '29', ':1:2:7:18:29:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('45', 'Formato Solicitud hoja de vida', '', '1438295331', '0', '5', '28', ':1:2:7:18:28:', '1', '2', '-1', '', '4');
INSERT INTO `tblDocuments` VALUES ('46', 'Formato Seguimiento a practicantes', '', '1438295352', '0', '5', '28', ':1:2:7:18:28:', '1', '2', '-1', '', '5');
INSERT INTO `tblDocuments` VALUES ('47', 'Formato estudiantes en practica', '', '1438295381', '0', '5', '28', ':1:2:7:18:28:', '1', '2', '-1', '', '6');
INSERT INTO `tblDocuments` VALUES ('61', 'Formato Evaluación de Proveedores', '', '1438295941', '0', '5', '12', ':1:2:4:12:', '1', '2', '-1', '', '8');
INSERT INTO `tblDocuments` VALUES ('62', 'Documento Plan de Bienestar', '', '1438295989', '0', '5', '32', ':1:2:7:13:32:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('68', 'ISO 9001:2015', '', '1489764487', '0', '5', '2', ':1:2:', '1', '2', '-1', '', '2');
INSERT INTO `tblDocuments` VALUES ('70', 'PR-04 AUDITORIA.doc', '', '1495491038', '0', '5', '21', ':1:2:6:9:21:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('71', 'PR-05 PRODUCTO SERVICIO NO CONFORME.doc', '', '1495491041', '0', '5', '21', ':1:2:6:9:21:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('81', 'FR01- ASESORÍA Y ACOMPAÑAMIENTO PARA CONVOCATORIAS INTERNACIONALES.docx', '', '1495569099', '0', '5', '24', ':1:2:6:8:24:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('82', 'FR-02 Listado Convenios Institucionales.xlsx', '', '1495569100', '0', '5', '24', ':1:2:6:8:24:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('83', 'FR02-Registro Docentes Maestrìa UMECIT.docx', '', '1495569101', '0', '5', '24', ':1:2:6:8:24:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('84', 'FR03-Experiencia de Participacion en Actividad de Cooperacion Academica-Profesional.docx', '', '1495569103', '0', '5', '24', ':1:2:6:8:24:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('85', 'FR04-Visitante Nacional e Internacional actividad academica de cooperacion..docx', '', '1495569104', '0', '5', '24', ':1:2:6:8:24:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('86', 'FR05-SOLICITUD DE EQUIPOS AUDIOVISUALES Y ADECUACIÒN DE ESPACIO FISICO PARA REALIZACIÒN DE ACTIVIDADES INSTITUCIONALES.docx', '', '1495569104', '0', '5', '24', ':1:2:6:8:24:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('87', 'FR06-REGISTRO DE PARTICIPACION EN REDES U ORGANISMOS NACIONALES O INTERNACIONALES.docx', '', '1495569105', '0', '5', '24', ':1:2:6:8:24:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('88', 'FR07-PLAN BITACORA DE CONTROL DE ACTIVIDADES COMPLEMENTARIAS DE BILINGUISMO.docx', '', '1495569106', '0', '5', '24', ':1:2:6:8:24:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('99', 'F01-syllabus presencial.doc', '', '1495744290', '0', '5', '34', ':1:2:7:20:34:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('100', 'FR-03 PLANEACION DOCENTE.xlsx', '', '1495744292', '0', '5', '34', ':1:2:7:20:34:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('101', 'FR02- EVALUACIÓN DOCENTE.xls', '', '1495744293', '0', '5', '34', ':1:2:7:20:34:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('102', 'FR04- Disponibilidad Docente.xlsx', '', '1495744294', '0', '5', '34', ':1:2:7:20:34:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('103', 'FR05-CATEDRA ABIERTA.doc', '', '1495744295', '0', '5', '34', ':1:2:7:20:34:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('104', 'REGLAMENTO DE PROYECCION SOCIAL.pdf', '', '1495744854', '0', '5', '29', ':1:2:7:18:29:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('105', 'DO-01 PROGRAMA DE INDUCCION.docx', '', '1495745038', '0', '5', '32', ':1:2:7:13:32:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('106', 'DO-02PORTAFOLIO DE ACTIVIDADES DE BIENESTAR INSTITUCIONAL.xlsx', '', '1495745047', '0', '5', '32', ':1:2:7:13:32:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('107', 'FR-01 MATRICULA DE ACTIVIDADES DEPORTIVAS Y CULTURALES DE BIENESTAR.doc', '', '1495745131', '0', '5', '31', ':1:2:7:13:31:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('108', 'FR-02 SOLICITUD DE RECURSOS PARA ACTIVIDADES DE BIENESTAR.xlsx', '', '1495745133', '0', '5', '31', ':1:2:7:13:31:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('109', 'FR-04 ENCUESTA DE CONOCIMIENTO - ACTIVIDADES DE BIENESTAR.xlsx', '', '1495745134', '0', '5', '31', ':1:2:7:13:31:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('110', 'FR-05 FICHA DE PSICOLOGIA.xls', '', '1495745137', '0', '5', '31', ':1:2:7:13:31:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('111', 'FR-06 PARTICIPACION ACTIVIDADES DE BIENESTAR.xlsx', '', '1495745139', '0', '5', '31', ':1:2:7:13:31:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('112', 'FR-07 ENCUESTA DE SATISFACCIÓN.xlsx', '', '1495745140', '0', '5', '31', ':1:2:7:13:31:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('113', 'FR-08 PLAN DE ACTIVIDADES Y PRESUPUESTOS DE BIENESTAR INSTITUCIONAL.xlsx', '', '1495745141', '0', '5', '31', ':1:2:7:13:31:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('114', 'PR01- VINCULACION Y ADMINISTRACION DE PERSONAL.doc', '', '1495745892', '0', '5', '36', ':1:2:4:11:36:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('115', 'PR02- INDUCCION Y REINDUCCION.doc', '', '1495745893', '0', '5', '36', ':1:2:4:11:36:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('120', 'Formatos-Entrevistas.xlsx', '', '1495746477', '0', '5', '41', ':1:2:4:15:41:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('121', 'PROCEDIMIENTO VINCULEMONOS', '', '1496177253', '0', '5', '27', ':1:2:7:18:27:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('122', 'Normograma SGSST', '', '1497641202', '0', '5', '38', ':1:2:4:11:38:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('123', 'Proc. Inscripción, admisión y matricula', '', '1499371369', '0', '5', '17', ':1:2:4:17:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('124', 'Proc. Gestión novedades matricula', '', '1499371409', '0', '5', '17', ':1:2:4:17:', '1', '2', '-1', '', '2');
INSERT INTO `tblDocuments` VALUES ('125', 'For. Cancelacion y/o adición de asignaturas', '', '1499371477', '0', '5', '17', ':1:2:4:17:', '1', '2', '-1', '', '3');
INSERT INTO `tblDocuments` VALUES ('126', 'For. Horario de clase', '', '1499371500', '0', '5', '17', ':1:2:4:17:', '1', '2', '-1', '', '4');
INSERT INTO `tblDocuments` VALUES ('127', 'Caracterizaciones de los Procesos', '', '1499371743', '0', '5', '6', ':1:2:6:', '1', '2', '-1', '', '3');
INSERT INTO `tblDocuments` VALUES ('128', 'Convenio tipo aprendices', '', '1499371926', '0', '5', '29', ':1:2:7:18:29:', '1', '2', '-1', '', '2');
INSERT INTO `tblDocuments` VALUES ('129', 'Convenio tipo pasantia', '', '1499371978', '0', '5', '29', ':1:2:7:18:29:', '1', '2', '-1', '', '3');
INSERT INTO `tblDocuments` VALUES ('130', 'Hoja de vida estudiante', '', '1499372061', '0', '5', '28', ':1:2:7:18:28:', '1', '2', '-1', '', '7');
INSERT INTO `tblDocuments` VALUES ('131', 'Proc. Gestión de Emprendimiento', '', '1499372260', '0', '5', '27', ':1:2:7:18:27:', '1', '2', '-1', '', '2');
INSERT INTO `tblDocuments` VALUES ('132', 'Proc. Gestión del egresado', '', '1499372288', '0', '5', '27', ':1:2:7:18:27:', '1', '2', '-1', '', '3');
INSERT INTO `tblDocuments` VALUES ('133', 'Proc. Información Documentada', '', '1499372400', '0', '5', '21', ':1:2:6:9:21:', '1', '2', '-1', '', '2');
INSERT INTO `tblDocuments` VALUES ('134', 'Proc. Mejora Continua', '', '1499372476', '0', '5', '21', ':1:2:6:9:21:', '1', '2', '-1', '', '3');
INSERT INTO `tblDocuments` VALUES ('137', 'Proc diseño y seguimiento curricular', '', '1499373693', '0', '5', '33', ':1:2:7:20:33:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('138', 'Proc evaluacion docente', '', '1499373719', '0', '5', '33', ':1:2:7:20:33:', '1', '2', '-1', '', '2');
INSERT INTO `tblDocuments` VALUES ('139', 'Proc Prestamo de Libros', '', '1499373742', '0', '5', '33', ':1:2:7:20:33:', '1', '2', '-1', '', '3');
INSERT INTO `tblDocuments` VALUES ('140', 'Proc. PEI y Planes de estudio', '', '1499373792', '0', '5', '33', ':1:2:7:20:33:', '1', '2', '-1', '', '4');
INSERT INTO `tblDocuments` VALUES ('141', 'Proc. PEI y Planes de estudio', '', '1499373795', '0', '5', '33', ':1:2:7:20:33:', '1', '2', '-1', '', '4');
INSERT INTO `tblDocuments` VALUES ('142', 'Proc. Gestión Curricular', '', '1499373858', '0', '5', '33', ':1:2:7:20:33:', '1', '2', '-1', '', '5');
INSERT INTO `tblDocuments` VALUES ('143', 'Requisitos vs Producto', '', '1501618519', '0', '5', '26', ':1:2:6:9:26:', '1', '2', '-1', '', '2');
INSERT INTO `tblDocuments` VALUES ('150', 'Proc. Revisión por la Dirección', '', '1507067992', '0', '1', '22', ':1:2:6:8:22:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('151', 'ISO 14001', '', '1507069453', '0', '5', '6', ':1:2:6:', '0', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('154', 'D09- MATRIZ PROCESOS VS NORMA', '', '1507214695', '0', '5', '23', ':1:2:6:8:23:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('155', 'F01- PONDERACION DE FACTORES Y CARACTERISTICAS', '', '1507215609', '0', '5', '25', ':1:2:6:9:25:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('156', 'ISO 14001:2015', '', '1507299448', '0', '5', '2', ':1:2:', '0', '2', '-1', '', '4');
INSERT INTO `tblDocuments` VALUES ('157', 'LINEAMIENTO ACREDITACIÓN PROGRAMAS', '', '1507299560', '0', '5', '2', ':1:2:', '1', '2', '-1', '', '5');
INSERT INTO `tblDocuments` VALUES ('158', 'LINEAMIENTOS ACREDITACIÓN INSTITUCIONAL', '', '1507299837', '0', '5', '2', ':1:2:', '1', '2', '-1', '', '6');
INSERT INTO `tblDocuments` VALUES ('159', 'RESOLUCIÓN 1111/ 2017', '', '1507299998', '0', '5', '2', ':1:2:', '1', '2', '-1', '', '7');
INSERT INTO `tblDocuments` VALUES ('160', 'DECRETO 1072 DE 2015', '', '1507300166', '0', '5', '2', ':1:2:', '1', '2', '-1', '', '8');
INSERT INTO `tblDocuments` VALUES ('161', 'DECRETO 1443 DE 2014', '', '1507300261', '0', '5', '2', ':1:2:', '1', '2', '-1', '', '9');
INSERT INTO `tblDocuments` VALUES ('166', 'Direccionamiento Estrátegico', '', '1519138625', '0', '5', '23', ':1:2:6:8:23:', '1', '2', '-1', '', '4');
INSERT INTO `tblDocuments` VALUES ('167', 'MAPA DE PROCESOS', '', '1519138889', '0', '5', '23', ':1:2:6:8:23:', '1', '2', '-1', '', '5');
INSERT INTO `tblDocuments` VALUES ('168', 'PR-01 Autoevalóacion institucional y de programas académicos', '', '1520455837', '0', '5', '21', ':1:2:6:9:21:', '1', '2', '-1', '', '4');
INSERT INTO `tblDocuments` VALUES ('170', 'ESTRUCTURA ORGANIZACIONAL 2018', '', '1520989003', '0', '5', '23', ':1:2:6:8:23:', '1', '2', '-1', '', '7');
INSERT INTO `tblDocuments` VALUES ('171', 'ESTRUCTURA ORGANIZACIONAL 2018', '', '1521146305', '0', '5', '23', ':1:2:6:8:23:', '1', '2', '-1', '', '8');
INSERT INTO `tblDocuments` VALUES ('172', 'F01-Informe de préstamo de equipos audiovisuales', '', '1521151334', '0', '5', '39', ':1:2:4:14:39:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('173', 'F02-INFORME DE ASISTENCIA A PRACTICAS SALAS DE COMPUTO', '', '1521151375', '0', '5', '39', ':1:2:4:14:39:', '1', '2', '-1', '', '2');
INSERT INTO `tblDocuments` VALUES ('174', 'F03-INFORME DE ASISTENCIA A PRACTICAS SALAS DE COMPUTO', '', '1521151422', '0', '5', '39', ':1:2:4:14:39:', '1', '2', '-1', '', '3');
INSERT INTO `tblDocuments` VALUES ('175', 'F04-REPORTE DE FUNCIONAMIENTO DE SALAS DE COMPUTO', '', '1521151562', '0', '5', '39', ':1:2:4:14:39:', '1', '2', '-1', '', '4');
INSERT INTO `tblDocuments` VALUES ('176', 'F05-INFORME DE PRÉSTAMO DE EQUIPOS DE AUDIOVISUALES  ', '', '1521151742', '0', '5', '39', ':1:2:4:14:39:', '1', '2', '-1', '', '5');
INSERT INTO `tblDocuments` VALUES ('177', 'F06- INFORME  DE  ASISTENCIA  A  PRACTICAS  A  SALAS  DE  COMPUTO ', '', '1521151794', '0', '5', '39', ':1:2:4:14:39:', '1', '2', '-1', '', '6');
INSERT INTO `tblDocuments` VALUES ('178', 'MANUAL DE PROCEDIMIENTOS DE SEGURIDAD', '', '1521151857', '0', '5', '14', ':1:2:4:14:', '1', '2', '-1', '', '1');
INSERT INTO `tblDocuments` VALUES ('179', 'FR02-LISTADO DE INFORMACIÓN DOCUMENTADA', '', '1521152638', '0', '5', '25', ':1:2:6:9:25:', '1', '2', '-1', '', '2');
INSERT INTO `tblDocuments` VALUES ('180', 'FR03- CONTROL DE ASISTENCIA', '', '1521152672', '0', '5', '25', ':1:2:6:9:25:', '1', '2', '-1', '', '3');
INSERT INTO `tblDocuments` VALUES ('181', 'FR09-ENCUESTA DE SATISFACCIÓN PARA PROGRAMAS  DE EDUCACIÓN CONTINUA', '', '1521152741', '0', '5', '25', ':1:2:6:9:25:', '1', '2', '-1', '', '4');
INSERT INTO `tblDocuments` VALUES ('182', 'DO7- TABLAS DE RETENCIÓN', '', '1521152896', '0', '5', '23', ':1:2:6:8:23:', '1', '2', '-1', '', '9');

-- ----------------------------
-- Table structure for tblDocumentStatus
-- ----------------------------
CREATE TABLE `tblDocumentStatus` (
  `statusID` int(11) NOT NULL AUTO_INCREMENT,
  `documentID` int(11) NOT NULL DEFAULT '0',
  `version` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`statusID`),
  UNIQUE KEY `documentID` (`documentID`,`version`),
  CONSTRAINT `tblDocumentStatus_document` FOREIGN KEY (`documentID`) REFERENCES `tblDocuments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=188 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblDocumentStatus
-- ----------------------------
INSERT INTO `tblDocumentStatus` VALUES ('14', '14', '1');
INSERT INTO `tblDocumentStatus` VALUES ('15', '15', '1');
INSERT INTO `tblDocumentStatus` VALUES ('16', '16', '1');
INSERT INTO `tblDocumentStatus` VALUES ('17', '17', '1');
INSERT INTO `tblDocumentStatus` VALUES ('18', '18', '1');
INSERT INTO `tblDocumentStatus` VALUES ('19', '19', '1');
INSERT INTO `tblDocumentStatus` VALUES ('20', '20', '1');
INSERT INTO `tblDocumentStatus` VALUES ('22', '22', '1');
INSERT INTO `tblDocumentStatus` VALUES ('42', '42', '1');
INSERT INTO `tblDocumentStatus` VALUES ('45', '45', '1');
INSERT INTO `tblDocumentStatus` VALUES ('46', '46', '1');
INSERT INTO `tblDocumentStatus` VALUES ('47', '47', '1');
INSERT INTO `tblDocumentStatus` VALUES ('61', '61', '1');
INSERT INTO `tblDocumentStatus` VALUES ('62', '62', '1');
INSERT INTO `tblDocumentStatus` VALUES ('68', '68', '1');
INSERT INTO `tblDocumentStatus` VALUES ('70', '70', '1');
INSERT INTO `tblDocumentStatus` VALUES ('71', '71', '1');
INSERT INTO `tblDocumentStatus` VALUES ('81', '81', '1');
INSERT INTO `tblDocumentStatus` VALUES ('82', '82', '1');
INSERT INTO `tblDocumentStatus` VALUES ('83', '83', '1');
INSERT INTO `tblDocumentStatus` VALUES ('84', '84', '1');
INSERT INTO `tblDocumentStatus` VALUES ('85', '85', '1');
INSERT INTO `tblDocumentStatus` VALUES ('86', '86', '1');
INSERT INTO `tblDocumentStatus` VALUES ('87', '87', '1');
INSERT INTO `tblDocumentStatus` VALUES ('88', '88', '1');
INSERT INTO `tblDocumentStatus` VALUES ('99', '99', '1');
INSERT INTO `tblDocumentStatus` VALUES ('100', '100', '1');
INSERT INTO `tblDocumentStatus` VALUES ('101', '101', '1');
INSERT INTO `tblDocumentStatus` VALUES ('102', '102', '1');
INSERT INTO `tblDocumentStatus` VALUES ('103', '103', '1');
INSERT INTO `tblDocumentStatus` VALUES ('104', '104', '1');
INSERT INTO `tblDocumentStatus` VALUES ('105', '105', '1');
INSERT INTO `tblDocumentStatus` VALUES ('106', '106', '1');
INSERT INTO `tblDocumentStatus` VALUES ('107', '107', '1');
INSERT INTO `tblDocumentStatus` VALUES ('108', '108', '1');
INSERT INTO `tblDocumentStatus` VALUES ('109', '109', '1');
INSERT INTO `tblDocumentStatus` VALUES ('110', '110', '1');
INSERT INTO `tblDocumentStatus` VALUES ('111', '111', '1');
INSERT INTO `tblDocumentStatus` VALUES ('112', '112', '1');
INSERT INTO `tblDocumentStatus` VALUES ('113', '113', '1');
INSERT INTO `tblDocumentStatus` VALUES ('114', '114', '1');
INSERT INTO `tblDocumentStatus` VALUES ('115', '115', '1');
INSERT INTO `tblDocumentStatus` VALUES ('120', '120', '1');
INSERT INTO `tblDocumentStatus` VALUES ('121', '121', '1');
INSERT INTO `tblDocumentStatus` VALUES ('122', '122', '1');
INSERT INTO `tblDocumentStatus` VALUES ('124', '123', '1');
INSERT INTO `tblDocumentStatus` VALUES ('125', '124', '1');
INSERT INTO `tblDocumentStatus` VALUES ('126', '125', '1');
INSERT INTO `tblDocumentStatus` VALUES ('127', '126', '1');
INSERT INTO `tblDocumentStatus` VALUES ('128', '127', '1');
INSERT INTO `tblDocumentStatus` VALUES ('129', '128', '1');
INSERT INTO `tblDocumentStatus` VALUES ('130', '129', '1');
INSERT INTO `tblDocumentStatus` VALUES ('132', '130', '1');
INSERT INTO `tblDocumentStatus` VALUES ('133', '131', '1');
INSERT INTO `tblDocumentStatus` VALUES ('134', '132', '1');
INSERT INTO `tblDocumentStatus` VALUES ('135', '133', '1');
INSERT INTO `tblDocumentStatus` VALUES ('136', '134', '1');
INSERT INTO `tblDocumentStatus` VALUES ('139', '137', '1');
INSERT INTO `tblDocumentStatus` VALUES ('140', '138', '1');
INSERT INTO `tblDocumentStatus` VALUES ('141', '139', '1');
INSERT INTO `tblDocumentStatus` VALUES ('142', '140', '1');
INSERT INTO `tblDocumentStatus` VALUES ('143', '141', '1');
INSERT INTO `tblDocumentStatus` VALUES ('144', '142', '1');
INSERT INTO `tblDocumentStatus` VALUES ('145', '143', '1');
INSERT INTO `tblDocumentStatus` VALUES ('154', '150', '1');
INSERT INTO `tblDocumentStatus` VALUES ('155', '151', '1');
INSERT INTO `tblDocumentStatus` VALUES ('158', '154', '1');
INSERT INTO `tblDocumentStatus` VALUES ('159', '155', '1');
INSERT INTO `tblDocumentStatus` VALUES ('160', '156', '1');
INSERT INTO `tblDocumentStatus` VALUES ('161', '157', '1');
INSERT INTO `tblDocumentStatus` VALUES ('162', '158', '1');
INSERT INTO `tblDocumentStatus` VALUES ('163', '159', '1');
INSERT INTO `tblDocumentStatus` VALUES ('164', '160', '1');
INSERT INTO `tblDocumentStatus` VALUES ('165', '161', '1');
INSERT INTO `tblDocumentStatus` VALUES ('171', '166', '1');
INSERT INTO `tblDocumentStatus` VALUES ('172', '167', '1');
INSERT INTO `tblDocumentStatus` VALUES ('173', '168', '1');
INSERT INTO `tblDocumentStatus` VALUES ('175', '170', '1');
INSERT INTO `tblDocumentStatus` VALUES ('176', '171', '1');
INSERT INTO `tblDocumentStatus` VALUES ('177', '172', '1');
INSERT INTO `tblDocumentStatus` VALUES ('178', '173', '1');
INSERT INTO `tblDocumentStatus` VALUES ('179', '174', '1');
INSERT INTO `tblDocumentStatus` VALUES ('180', '175', '1');
INSERT INTO `tblDocumentStatus` VALUES ('181', '176', '1');
INSERT INTO `tblDocumentStatus` VALUES ('182', '177', '1');
INSERT INTO `tblDocumentStatus` VALUES ('183', '178', '1');
INSERT INTO `tblDocumentStatus` VALUES ('184', '179', '1');
INSERT INTO `tblDocumentStatus` VALUES ('185', '180', '1');
INSERT INTO `tblDocumentStatus` VALUES ('186', '181', '1');
INSERT INTO `tblDocumentStatus` VALUES ('187', '182', '1');

-- ----------------------------
-- Table structure for tblDocumentStatusLog
-- ----------------------------
CREATE TABLE `tblDocumentStatusLog` (
  `statusLogID` int(11) NOT NULL AUTO_INCREMENT,
  `statusID` int(11) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `comment` text NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `userID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`statusLogID`),
  KEY `statusID` (`statusID`),
  KEY `tblDocumentStatusLog_user` (`userID`),
  CONSTRAINT `tblDocumentStatusLog_status` FOREIGN KEY (`statusID`) REFERENCES `tblDocumentStatus` (`statusID`) ON DELETE CASCADE,
  CONSTRAINT `tblDocumentStatusLog_user` FOREIGN KEY (`userID`) REFERENCES `tblUsers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=191 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblDocumentStatusLog
-- ----------------------------
INSERT INTO `tblDocumentStatusLog` VALUES ('14', '14', '0', 'New document content submitted', '2015-05-25 17:23:52', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('15', '15', '0', 'New document content submitted', '2015-05-25 17:25:49', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('16', '16', '0', 'New document content submitted', '2015-05-25 17:26:53', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('17', '17', '0', 'New document content submitted', '2015-05-25 17:28:08', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('18', '18', '0', 'New document content submitted', '2015-05-25 17:29:00', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('19', '19', '0', 'New document content submitted', '2015-05-25 17:41:38', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('20', '20', '0', 'New document content submitted', '2015-05-25 17:41:57', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('22', '22', '0', 'New document content submitted', '2015-05-25 17:44:39', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('42', '42', '0', 'New document content submitted', '2015-07-29 17:38:13', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('45', '45', '0', 'New document content submitted', '2015-07-30 17:28:51', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('46', '46', '0', 'New document content submitted', '2015-07-30 17:29:12', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('47', '47', '0', 'New document content submitted', '2015-07-30 17:29:41', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('61', '61', '0', 'New document content submitted', '2015-07-30 17:39:02', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('62', '62', '0', 'New document content submitted', '2015-07-30 17:39:49', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('68', '68', '0', 'New document content submitted', '2017-03-17 10:28:07', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('69', '68', '2', '', '2017-03-21 15:46:07', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('70', '68', '-2', 'Vigente', '2017-03-21 15:48:50', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('71', '68', '2', 'Vigente', '2017-03-21 15:49:13', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('73', '70', '2', 'New document content submitted', '2017-05-22 17:10:39', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('74', '71', '2', 'New document content submitted', '2017-05-22 17:10:41', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('84', '81', '2', 'New document content submitted', '2017-05-23 14:51:39', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('85', '82', '2', 'New document content submitted', '2017-05-23 14:51:41', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('86', '83', '2', 'New document content submitted', '2017-05-23 14:51:42', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('87', '84', '2', 'New document content submitted', '2017-05-23 14:51:43', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('88', '85', '2', 'New document content submitted', '2017-05-23 14:51:44', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('89', '86', '2', 'New document content submitted', '2017-05-23 14:51:44', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('90', '87', '2', 'New document content submitted', '2017-05-23 14:51:45', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('91', '88', '2', 'New document content submitted', '2017-05-23 14:51:46', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('102', '99', '2', 'New document content submitted', '2017-05-25 15:31:31', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('103', '100', '2', 'New document content submitted', '2017-05-25 15:31:32', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('104', '101', '2', 'New document content submitted', '2017-05-25 15:31:33', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('105', '102', '2', 'New document content submitted', '2017-05-25 15:31:34', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('106', '103', '2', 'New document content submitted', '2017-05-25 15:31:36', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('107', '104', '2', 'New document content submitted', '2017-05-25 15:40:54', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('108', '105', '2', 'New document content submitted', '2017-05-25 15:43:58', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('109', '106', '2', 'New document content submitted', '2017-05-25 15:44:08', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('110', '107', '2', 'New document content submitted', '2017-05-25 15:45:32', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('111', '108', '2', 'New document content submitted', '2017-05-25 15:45:33', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('112', '109', '2', 'New document content submitted', '2017-05-25 15:45:34', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('113', '110', '2', 'New document content submitted', '2017-05-25 15:45:38', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('114', '111', '2', 'New document content submitted', '2017-05-25 15:45:39', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('115', '112', '2', 'New document content submitted', '2017-05-25 15:45:40', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('116', '113', '2', 'New document content submitted', '2017-05-25 15:45:41', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('117', '114', '2', 'New document content submitted', '2017-05-25 15:58:12', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('118', '115', '2', 'New document content submitted', '2017-05-25 15:58:13', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('123', '120', '2', 'New document content submitted', '2017-05-25 16:07:57', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('124', '121', '2', 'New document content submitted', '2017-05-30 15:47:33', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('125', '122', '0', 'New document content submitted', '2017-06-16 14:26:42', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('127', '124', '2', 'New document content submitted', '2017-07-06 15:02:50', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('128', '125', '2', 'New document content submitted', '2017-07-06 15:03:29', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('129', '126', '2', 'New document content submitted', '2017-07-06 15:04:37', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('130', '127', '2', 'New document content submitted', '2017-07-06 15:05:01', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('131', '128', '2', 'New document content submitted', '2017-07-06 15:09:03', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('132', '129', '2', 'New document content submitted', '2017-07-06 15:12:07', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('133', '130', '2', 'New document content submitted', '2017-07-06 15:12:58', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('135', '132', '2', 'New document content submitted', '2017-07-06 15:14:21', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('136', '133', '2', 'New document content submitted', '2017-07-06 15:17:40', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('137', '134', '2', 'New document content submitted', '2017-07-06 15:18:08', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('138', '135', '2', 'New document content submitted', '2017-07-06 15:20:00', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('139', '136', '2', 'New document content submitted', '2017-07-06 15:21:16', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('142', '139', '2', 'New document content submitted', '2017-07-06 15:41:33', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('143', '140', '2', 'New document content submitted', '2017-07-06 15:42:00', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('144', '141', '2', 'New document content submitted', '2017-07-06 15:42:22', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('145', '142', '2', 'New document content submitted', '2017-07-06 15:43:13', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('146', '143', '2', 'New document content submitted', '2017-07-06 15:43:15', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('147', '144', '2', 'New document content submitted', '2017-07-06 15:44:18', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('148', '145', '0', 'New document content submitted', '2017-08-01 15:15:21', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('157', '154', '0', 'New document content submitted', '2017-10-03 16:59:52', '1');
INSERT INTO `tblDocumentStatusLog` VALUES ('158', '155', '0', 'New document content submitted', '2017-10-03 17:24:13', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('161', '158', '0', 'New document content submitted', '2017-10-05 09:44:56', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('162', '159', '0', 'New document content submitted', '2017-10-05 10:00:15', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('163', '160', '2', 'New document content submitted', '2017-10-06 09:17:28', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('164', '161', '2', 'New document content submitted', '2017-10-06 09:19:20', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('165', '162', '2', 'New document content submitted', '2017-10-06 09:24:03', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('166', '163', '2', 'New document content submitted', '2017-10-06 09:26:38', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('167', '164', '2', 'New document content submitted', '2017-10-06 09:29:26', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('168', '165', '2', 'New document content submitted', '2017-10-06 09:31:01', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('174', '171', '0', 'New document content submitted', '2018-02-20 09:57:10', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('175', '172', '2', 'New document content submitted', '2018-02-20 10:01:29', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('176', '173', '0', 'New document content submitted', '2018-03-07 15:50:38', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('178', '175', '2', 'New document content submitted', '2018-03-13 19:56:43', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('179', '176', '2', 'New document content submitted', '2018-03-15 15:38:25', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('180', '177', '2', 'New document content submitted', '2018-03-15 17:02:14', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('181', '178', '2', 'New document content submitted', '2018-03-15 17:02:55', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('182', '179', '2', 'New document content submitted', '2018-03-15 17:03:43', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('183', '180', '2', 'New document content submitted', '2018-03-15 17:06:02', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('184', '181', '2', 'New document content submitted', '2018-03-15 17:09:02', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('185', '182', '2', 'New document content submitted', '2018-03-15 17:09:54', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('186', '183', '2', 'New document content submitted', '2018-03-15 17:10:58', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('187', '184', '2', 'New document content submitted', '2018-03-15 17:23:58', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('188', '185', '2', 'New document content submitted', '2018-03-15 17:24:32', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('189', '186', '2', 'New document content submitted', '2018-03-15 17:25:41', '5');
INSERT INTO `tblDocumentStatusLog` VALUES ('190', '187', '2', 'New document content submitted', '2018-03-15 17:28:16', '5');

-- ----------------------------
-- Table structure for tblEvents
-- ----------------------------
CREATE TABLE `tblEvents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) DEFAULT NULL,
  `comment` text,
  `start` int(12) DEFAULT NULL,
  `stop` int(12) DEFAULT NULL,
  `date` int(12) DEFAULT NULL,
  `userID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblEvents
-- ----------------------------
INSERT INTO `tblEvents` VALUES ('1', 'Revision de Inidicadores de Gestion Actuales', '', '1432270800', '1434430799', '1432309755', '1');

-- ----------------------------
-- Table structure for tblFolderAttributes
-- ----------------------------
CREATE TABLE `tblFolderAttributes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `folder` int(11) DEFAULT NULL,
  `attrdef` int(11) DEFAULT NULL,
  `value` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `folder` (`folder`,`attrdef`),
  KEY `tblFolderAttributes_attrdef` (`attrdef`),
  CONSTRAINT `tblFolderAttributes_attrdef` FOREIGN KEY (`attrdef`) REFERENCES `tblAttributeDefinitions` (`id`),
  CONSTRAINT `tblFolderAttributes_folder` FOREIGN KEY (`folder`) REFERENCES `tblFolders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblFolderAttributes
-- ----------------------------

-- ----------------------------
-- Table structure for tblFolders
-- ----------------------------
CREATE TABLE `tblFolders` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(70) DEFAULT NULL,
  `parent` int(11) DEFAULT NULL,
  `folderList` text NOT NULL,
  `comment` text,
  `date` int(12) DEFAULT NULL,
  `owner` int(11) DEFAULT NULL,
  `inheritAccess` tinyint(1) NOT NULL DEFAULT '1',
  `defaultAccess` tinyint(4) NOT NULL DEFAULT '0',
  `sequence` double NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `parent` (`parent`),
  KEY `tblFolders_owner` (`owner`),
  CONSTRAINT `tblFolders_owner` FOREIGN KEY (`owner`) REFERENCES `tblUsers` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblFolders
-- ----------------------------
INSERT INTO `tblFolders` VALUES ('1', 'Sistema Integrador de Gestión de la UNICUCES, SIGU', '0', '', 'DMS root', '1428906533', '1', '0', '2', '0');
INSERT INTO `tblFolders` VALUES ('2', 'Sistema Integrador de Gestión de la UNICUCES, SIGU', '1', ':1:', '', '1429730818', '1', '0', '2', '1');
INSERT INTO `tblFolders` VALUES ('4', 'Apoyo', '2', ':1:2:', 'Incluyen todos aquellos procesos para la provisión de los recursos que son necesarios en los procesos estratégicos y misionales.', '1432590754', '5', '1', '2', '2');
INSERT INTO `tblFolders` VALUES ('6', 'Estrategico', '2', ':1:2:', 'Incluyen procesos relativos al establecimiento de políticas y estrategias, fijación de objetivos, provisión de comunicación, aseguramiento de la disponibilidad de recursos necesarios y revisiones por la dirección.', '1432591614', '5', '1', '2', '3');
INSERT INTO `tblFolders` VALUES ('7', 'Misional', '2', ':1:2:', 'Incluyen todos los procesos que proporcionan el resultado previsto por la institución en el cumplimiento de su objeto social o razón de ser.', '1432591692', '5', '1', '2', '4');
INSERT INTO `tblFolders` VALUES ('8', 'Gestión Institucional', '6', ':1:2:6:', 'Líder de proceso: Rectoría / Representante de la Direccion', '1432591906', '5', '1', '2', '1');
INSERT INTO `tblFolders` VALUES ('9', 'Gestión de Planeación y Mejora Continua', '6', ':1:2:6:', 'Líder de proceso: Director de Planeación y Desarrollo', '1432592019', '5', '1', '2', '2');
INSERT INTO `tblFolders` VALUES ('10', 'Gestión Contable y Financiera', '4', ':1:2:4:', 'Líder de Proceso: Vicerrector Administrativa / Financiera', '1432592111', '5', '1', '2', '1');
INSERT INTO `tblFolders` VALUES ('11', 'Gestión del Talento Humano', '4', ':1:2:4:', 'Líder de proceso: Vicerrector Administrativa/ Coordinador Recurso Humano', '1432592158', '5', '1', '2', '2');
INSERT INTO `tblFolders` VALUES ('12', 'Gestión Mantenimiento,Compras y Suministros', '4', ':1:2:4:', 'Líder de proceso: Vicerrector Administrativa/ Director Planeación y Desarrollo', '1432592255', '5', '1', '2', '3');
INSERT INTO `tblFolders` VALUES ('13', 'Bienestar Institucional', '7', ':1:2:7:', 'Líder de proceso: Director Bienestar Universitario', '1432592299', '5', '1', '2', '4');
INSERT INTO `tblFolders` VALUES ('14', 'Gestión TICs', '4', ':1:2:4:', 'Líder de Proceso: Director Planeación / Coordinador Servicios Informáticos', '1432592377', '5', '1', '2', '5');
INSERT INTO `tblFolders` VALUES ('15', 'Gestión Mercadeo y Comunicaciones', '4', ':1:2:4:', 'Líder de proceso: Director Mercadeo', '1432592418', '5', '1', '2', '6');
INSERT INTO `tblFolders` VALUES ('17', 'Gestión Registro y Control Académico', '4', ':1:2:4:', 'Líder de proceso: Secretaria Académica ', '1432593427', '5', '1', '2', '1');
INSERT INTO `tblFolders` VALUES ('18', 'Gestión Proyeccion Social y Extensión', '7', ':1:2:7:', 'Líder proceso: Director Proyección Social', '1432593483', '5', '1', '2', '2');
INSERT INTO `tblFolders` VALUES ('19', 'Gestión Investigación', '7', ':1:2:7:', 'Líder de Proceso: Director Investigaciones', '1432593540', '5', '1', '2', '3');
INSERT INTO `tblFolders` VALUES ('20', 'Educación y Formación', '7', ':1:2:7:', 'Líder de Proceso: Vicerrector Académico/ Directores de Programa/ Docentes', '1432593646', '5', '1', '2', '4');
INSERT INTO `tblFolders` VALUES ('21', 'PROCEDIMIENTOS', '9', ':1:2:6:9:', '', '1495485956', '5', '1', '2', '1');
INSERT INTO `tblFolders` VALUES ('22', 'PROCEDIMIENTOS', '8', ':1:2:6:8:', '', '1495567335', '5', '1', '2', '1');
INSERT INTO `tblFolders` VALUES ('23', 'DOCUMENTOS', '8', ':1:2:6:8:', '', '1495568478', '5', '1', '2', '2');
INSERT INTO `tblFolders` VALUES ('24', 'FORMATOS', '8', ':1:2:6:8:', '', '1495568939', '5', '1', '2', '3');
INSERT INTO `tblFolders` VALUES ('25', 'FORMATOS', '9', ':1:2:6:9:', '', '1495569262', '5', '1', '2', '2');
INSERT INTO `tblFolders` VALUES ('26', 'DOCUMENTOS', '9', ':1:2:6:9:', '', '1495740828', '5', '1', '2', '3');
INSERT INTO `tblFolders` VALUES ('27', 'PROCEDIMIENTOS', '18', ':1:2:7:18:', '', '1495740943', '5', '1', '2', '1');
INSERT INTO `tblFolders` VALUES ('28', 'FORMATOS', '18', ':1:2:7:18:', '', '1495740996', '5', '1', '2', '2');
INSERT INTO `tblFolders` VALUES ('29', 'DOCUMENTOS', '18', ':1:2:7:18:', '', '1495741168', '5', '1', '2', '3');
INSERT INTO `tblFolders` VALUES ('30', 'PROCEDIMIENTOS', '13', ':1:2:7:13:', '', '1495741293', '5', '1', '2', '1');
INSERT INTO `tblFolders` VALUES ('31', 'FORMATOS', '13', ':1:2:7:13:', '', '1495741339', '5', '1', '2', '2');
INSERT INTO `tblFolders` VALUES ('32', 'DOCUMENTO', '13', ':1:2:7:13:', '', '1495741472', '5', '1', '2', '3');
INSERT INTO `tblFolders` VALUES ('33', 'PROCEDIMIENTOS', '20', ':1:2:7:20:', '', '1495741601', '5', '0', '2', '1');
INSERT INTO `tblFolders` VALUES ('34', 'FORMATOS', '20', ':1:2:7:20:', '', '1495744199', '5', '1', '2', '2');
INSERT INTO `tblFolders` VALUES ('35', 'FORMATOS', '10', ':1:2:4:10:', '', '1495745332', '5', '1', '2', '1');
INSERT INTO `tblFolders` VALUES ('36', 'PROCEDIMIENTOS', '11', ':1:2:4:11:', '', '1495745840', '5', '1', '2', '1');
INSERT INTO `tblFolders` VALUES ('37', 'FORMATOS', '11', ':1:2:4:11:', '', '1495745848', '5', '1', '2', '2');
INSERT INTO `tblFolders` VALUES ('38', 'SISTEMA DE  GESTION DE SEGURIDAD Y SALUD EN EL TRABAJO', '11', ':1:2:4:11:', '', '1495745980', '5', '1', '2', '3');
INSERT INTO `tblFolders` VALUES ('39', 'FORMATOS', '14', ':1:2:4:14:', '', '1495746179', '5', '1', '2', '1');
INSERT INTO `tblFolders` VALUES ('40', 'PROCEDIMIENTOS', '15', ':1:2:4:15:', '', '1495746312', '5', '1', '2', '1');
INSERT INTO `tblFolders` VALUES ('41', 'FORMATOS', '15', ':1:2:4:15:', '', '1495746323', '5', '1', '2', '2');
INSERT INTO `tblFolders` VALUES ('42', 'MANUAL DE FUNCIONES Y PERFILES DE CARGO', '11', ':1:2:4:11:', '', '1520989181', '5', '1', '2', '4');

-- ----------------------------
-- Table structure for tblGroupMembers
-- ----------------------------
CREATE TABLE `tblGroupMembers` (
  `groupID` int(11) NOT NULL DEFAULT '0',
  `userID` int(11) NOT NULL DEFAULT '0',
  `manager` smallint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `groupID` (`groupID`,`userID`),
  KEY `tblGroupMembers_user` (`userID`),
  CONSTRAINT `tblGroupMembers_group` FOREIGN KEY (`groupID`) REFERENCES `tblGroups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `tblGroupMembers_user` FOREIGN KEY (`userID`) REFERENCES `tblUsers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblGroupMembers
-- ----------------------------
INSERT INTO `tblGroupMembers` VALUES ('1', '1', '1');
INSERT INTO `tblGroupMembers` VALUES ('1', '5', '0');
INSERT INTO `tblGroupMembers` VALUES ('2', '1', '0');
INSERT INTO `tblGroupMembers` VALUES ('2', '6', '1');
INSERT INTO `tblGroupMembers` VALUES ('2', '8', '1');
INSERT INTO `tblGroupMembers` VALUES ('2', '9', '1');
INSERT INTO `tblGroupMembers` VALUES ('2', '10', '1');
INSERT INTO `tblGroupMembers` VALUES ('3', '10', '1');
INSERT INTO `tblGroupMembers` VALUES ('4', '11', '1');
INSERT INTO `tblGroupMembers` VALUES ('7', '8', '1');

-- ----------------------------
-- Table structure for tblGroups
-- ----------------------------
CREATE TABLE `tblGroups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `comment` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblGroups
-- ----------------------------
INSERT INTO `tblGroups` VALUES ('1', 'SGC UNICUCES', 'Documentación del SGC UNICUCES');
INSERT INTO `tblGroups` VALUES ('2', 'Alta Dirección', '');
INSERT INTO `tblGroups` VALUES ('3', 'Grupo Directores Programas Académicos', 'Directores de  Programas Académicos de Administración Logística, Comercio y Finanzas Internacionales, Ingeniería Industrial, Administración de Empresas, Ingeniería de Sistemas, Contaduría Pública, Mercadeo Empresarial, Especialización en Gerencia de Proyectos');
INSERT INTO `tblGroups` VALUES ('4', 'Grupo Proyección Social y Extensión', 'Director Proyección Social, \r\nEmprendimiento\r\nSuperarse\r\n');
INSERT INTO `tblGroups` VALUES ('5', 'Grupo Investigación', 'Director Investigación\r\nAsistente Investigación\r\nDocentes Investigadores');
INSERT INTO `tblGroups` VALUES ('6', 'Grupo Contable y Financiero', 'Director Contable\r\nCoordinador Contable\r\nAuxiliar contable\r\nAuxiliar tesorería\r\n\r\n');
INSERT INTO `tblGroups` VALUES ('7', 'Grupo Recurso Humano', 'Vicerrector Administrativo\r\nCoordinador Recurso Humano\r\nAuxiliar SGSST');

-- ----------------------------
-- Table structure for tblKeywordCategories
-- ----------------------------
CREATE TABLE `tblKeywordCategories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `owner` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblKeywordCategories
-- ----------------------------

-- ----------------------------
-- Table structure for tblKeywords
-- ----------------------------
CREATE TABLE `tblKeywords` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` int(11) NOT NULL DEFAULT '0',
  `keywords` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tblKeywords_category` (`category`),
  CONSTRAINT `tblKeywords_category` FOREIGN KEY (`category`) REFERENCES `tblKeywordCategories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblKeywords
-- ----------------------------

-- ----------------------------
-- Table structure for tblMandatoryApprovers
-- ----------------------------
CREATE TABLE `tblMandatoryApprovers` (
  `userID` int(11) NOT NULL DEFAULT '0',
  `approverUserID` int(11) NOT NULL DEFAULT '0',
  `approverGroupID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`userID`,`approverUserID`,`approverGroupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblMandatoryApprovers
-- ----------------------------
INSERT INTO `tblMandatoryApprovers` VALUES ('5', '1', '0');
INSERT INTO `tblMandatoryApprovers` VALUES ('10', '9', '0');
INSERT INTO `tblMandatoryApprovers` VALUES ('11', '10', '0');

-- ----------------------------
-- Table structure for tblMandatoryReviewers
-- ----------------------------
CREATE TABLE `tblMandatoryReviewers` (
  `userID` int(11) NOT NULL DEFAULT '0',
  `reviewerUserID` int(11) NOT NULL DEFAULT '0',
  `reviewerGroupID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`userID`,`reviewerUserID`,`reviewerGroupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblMandatoryReviewers
-- ----------------------------
INSERT INTO `tblMandatoryReviewers` VALUES ('5', '1', '0');
INSERT INTO `tblMandatoryReviewers` VALUES ('10', '9', '0');
INSERT INTO `tblMandatoryReviewers` VALUES ('11', '10', '0');
INSERT INTO `tblMandatoryReviewers` VALUES ('21', '1', '0');

-- ----------------------------
-- Table structure for tblNotify
-- ----------------------------
CREATE TABLE `tblNotify` (
  `target` int(11) NOT NULL DEFAULT '0',
  `targetType` int(11) NOT NULL DEFAULT '0',
  `userID` int(11) NOT NULL DEFAULT '-1',
  `groupID` int(11) NOT NULL DEFAULT '-1',
  PRIMARY KEY (`target`,`targetType`,`userID`,`groupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblNotify
-- ----------------------------
INSERT INTO `tblNotify` VALUES ('1', '1', '-1', '2');
INSERT INTO `tblNotify` VALUES ('1', '1', '1', '-1');

-- ----------------------------
-- Table structure for tblPathList
-- ----------------------------
CREATE TABLE `tblPathList` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parentPath` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblPathList
-- ----------------------------

-- ----------------------------
-- Table structure for tblSessions
-- ----------------------------
CREATE TABLE `tblSessions` (
  `id` varchar(50) NOT NULL DEFAULT '',
  `userID` int(11) NOT NULL DEFAULT '0',
  `lastAccess` int(11) NOT NULL DEFAULT '0',
  `theme` varchar(30) NOT NULL DEFAULT '',
  `language` varchar(30) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `tblSessions_user` (`userID`),
  CONSTRAINT `tblSessions_user` FOREIGN KEY (`userID`) REFERENCES `tblUsers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblSessions
-- ----------------------------
INSERT INTO `tblSessions` VALUES ('31db5c5a001c068abb55ceec492b189c', '1', '1522126541', 'clean', 'Spanish');

-- ----------------------------
-- Table structure for tblUserImages
-- ----------------------------
CREATE TABLE `tblUserImages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userID` int(11) NOT NULL DEFAULT '0',
  `image` blob NOT NULL,
  `mimeType` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `tblUserImages_user` (`userID`),
  CONSTRAINT `tblUserImages_user` FOREIGN KEY (`userID`) REFERENCES `tblUsers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblUserImages
-- ----------------------------

-- ----------------------------
-- Table structure for tblUserPasswordHistory
-- ----------------------------
CREATE TABLE `tblUserPasswordHistory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userID` int(11) NOT NULL DEFAULT '0',
  `pwd` varchar(50) DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `tblUserPasswordHistory_user` (`userID`),
  CONSTRAINT `tblUserPasswordHistory_user` FOREIGN KEY (`userID`) REFERENCES `tblUsers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblUserPasswordHistory
-- ----------------------------

-- ----------------------------
-- Table structure for tblUserPasswordRequest
-- ----------------------------
CREATE TABLE `tblUserPasswordRequest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userID` int(11) NOT NULL DEFAULT '0',
  `hash` varchar(50) DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `tblUserPasswordRequest_user` (`userID`),
  CONSTRAINT `tblUserPasswordRequest_user` FOREIGN KEY (`userID`) REFERENCES `tblUsers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblUserPasswordRequest
-- ----------------------------

-- ----------------------------
-- Table structure for tblUsers
-- ----------------------------
CREATE TABLE `tblUsers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(50) DEFAULT NULL,
  `pwd` varchar(50) DEFAULT NULL,
  `fullName` varchar(100) DEFAULT NULL,
  `email` varchar(70) DEFAULT NULL,
  `language` varchar(32) NOT NULL,
  `theme` varchar(32) NOT NULL,
  `comment` text NOT NULL,
  `role` smallint(1) NOT NULL DEFAULT '0',
  `hidden` smallint(1) NOT NULL DEFAULT '0',
  `pwdExpiration` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `loginfailures` tinyint(4) NOT NULL DEFAULT '0',
  `disabled` smallint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `login` (`login`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblUsers
-- ----------------------------
INSERT INTO `tblUsers` VALUES ('1', 'admin', 'a616f057a935166768c6341744378a82', 'admin - Carlos Augusto Narvaez', 'planeacion@unicuces.edu.co', 'Spanish', 'clean', '1a1dc91c907325c69271ddf0c944bc72', '1', '0', '2015-04-13 01:33:03', '0', '0');
INSERT INTO `tblUsers` VALUES ('3', 'bienestar', 'ddfd7b29c07b1bae219fa9725902e368', 'Jose Roberto Rosero', 'dirbienestar@unicuces.edu.co', 'Spanish', 'blue', '', '0', '0', '0000-00-00 00:00:00', '0', '0');
INSERT INTO `tblUsers` VALUES ('5', 'fjastaiza', 'a6d76ae1d0392026e2ea46a4a92c6d8d', 'Francia Janeth Astaiza Obando', 'asesorcalidad@unicuces.edu.co', 'Spanish', 'blue', '', '1', '0', '2017-03-21 15:22:51', '0', '0');
INSERT INTO `tblUsers` VALUES ('6', 'secretariageneral', '918a8b5e4380bc0b291b52f304f8c1a9', 'Edilia Diaz', 'secretariageneral@unicuces.edu.co', 'Spanish', 'clean', '', '0', '0', '0000-00-00 00:00:00', '0', '0');
INSERT INTO `tblUsers` VALUES ('7', 'asesorcalidad', '13f8bccf9aa508aaf09ac4fc02f2d09d', 'Francia J Astaiza o', 'asesorcalidad@unicuces.edu.co', 'Spanish', 'clean', '', '1', '0', '0000-00-00 00:00:00', '0', '0');
INSERT INTO `tblUsers` VALUES ('8', 'viceadministrativo', '80c82f4004327aa18a852b59dc3232df', 'Rito Díaz', 'viceadministrativa@unicuces.edu.co', 'Spanish', 'clean', '', '0', '0', '0000-00-00 00:00:00', '0', '0');
INSERT INTO `tblUsers` VALUES ('9', 'rectoria', '6acf12c8cc4e16e282f43a9d170f3255', 'Augusto Narvaéz', 'rectoria@unicuces.edu.co', 'Spanish', 'clean', '', '0', '0', '0000-00-00 00:00:00', '0', '0');
INSERT INTO `tblUsers` VALUES ('10', 'viceacademico', '3626b5466457705599bf8a841ae11186', 'Wilson Romero', 'viceacademica@unicuces.edu.co', 'Spanish', 'clean', '', '0', '0', '0000-00-00 00:00:00', '0', '0');
INSERT INTO `tblUsers` VALUES ('11', 'proyeccionsocial', 'bbbb6b91d581fb45df6e372bb33830ba', 'Jhon Jairo Muñoz', 'proyeccionsocial@unicuces.edu.co', 'Spanish', 'clean', '', '0', '0', '0000-00-00 00:00:00', '0', '0');
INSERT INTO `tblUsers` VALUES ('12', 'autoevaluacion', '0247f3c00c71f657d8befeae3f0bc0e2', 'Melissa Hurtado O', 'autoevaluacion@unicuces.edu.co', 'Spanish', 'clean', '', '0', '0', '0000-00-00 00:00:00', '0', '0');
INSERT INTO `tblUsers` VALUES ('14', 'investigacion', '944ffdfa02dd68c65508bed7c196cfb6', 'Ana Mercedes Ocampo H', 'investigacion@unicuces.edu.co', 'Spanish', 'clean', '', '0', '0', '0000-00-00 00:00:00', '0', '0');
INSERT INTO `tblUsers` VALUES ('15', 'planeacion', '7bb39d0249f5b68f1e02dc27bffe6a41', 'Carlos Augusto Narvaez', 'planeacion@unicuces.edu.co', 'Spanish', 'clean', '', '0', '0', '0000-00-00 00:00:00', '0', '0');
INSERT INTO `tblUsers` VALUES ('16', 'Olga Moreno', 'e44d46e0bb9691cf448a9bb19391e8ab', 'olga moreno', 'olgadiamarmorenohernandez@gmail.com', 'Spanish', 'clean', '', '0', '0', '0000-00-00 00:00:00', '0', '0');
INSERT INTO `tblUsers` VALUES ('17', 'Contabilidad', 'd5a9e0f7baefc827e7ac792cc2ba3439', 'Lucila Benitez', 'conta@unicuces.edu.co', 'Spanish', 'clean', '', '0', '0', '0000-00-00 00:00:00', '0', '0');
INSERT INTO `tblUsers` VALUES ('18', 'recursohumano', 'eaaad2ce4f1cec627af7f8fb923f1488', 'Liliana Montoya', 'recursoshumanos@unicuces.edu.co', 'Spanish', 'clean', '', '0', '0', '0000-00-00 00:00:00', '0', '0');
INSERT INTO `tblUsers` VALUES ('19', 'emprendimiento', '186fab3b9ce0088ef35f04606d86a3fc', 'Gloria Mercedes Martinez L', 'emprendimiento@unicuces.edu.co', 'Spanish', 'clean', '', '0', '0', '0000-00-00 00:00:00', '0', '0');
INSERT INTO `tblUsers` VALUES ('20', 'relacionesinternacionales', '16b1c83de8f9518e673838b2d6ea75dc', 'Ana María Morales G', 'ori@unicuces.edu.co', 'Spanish', 'clean', '', '0', '0', '0000-00-00 00:00:00', '0', '0');
INSERT INTO `tblUsers` VALUES ('21', 'aplaneacion', '6a2e1a35e0e51fd9e36d0c2f52f3750d', 'A Planeación', 'aplaneacion@unicuces.edu.co', 'Spanish', 'clean', '', '1', '0', '0000-00-00 00:00:00', '0', '0');

-- ----------------------------
-- Table structure for tblVersion
-- ----------------------------
CREATE TABLE `tblVersion` (
  `date` datetime DEFAULT NULL,
  `major` smallint(6) DEFAULT NULL,
  `minor` smallint(6) DEFAULT NULL,
  `subminor` smallint(6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tblVersion
-- ----------------------------
INSERT INTO `tblVersion` VALUES ('2015-04-13 01:28:53', '3', '4', '0');
