-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.7.18


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!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' */;


--
-- Create schema pruebas
--

-- CREATE DATABASE IF NOT EXISTS pruebas;
-- USE pruebas;

--
-- Definition of table `edas_audit`
--

DROP TABLE IF EXISTS `edas_audit`;
CREATE TABLE `edas_audit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `datetime` datetime NOT NULL,
  `ip` varchar(40) NOT NULL,
  `user` varchar(255) DEFAULT NULL,
  `table` varchar(300) DEFAULT NULL,
  `action` varchar(250) NOT NULL,
  `description` mediumtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=273 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `edas_audit`
--

/*!40000 ALTER TABLE `edas_audit` DISABLE KEYS */;
INSERT INTO `edas_audit` (`id`,`datetime`,`ip`,`user`,`table`,`action`,`description`) VALUES 
 (1,'2022-11-27 14:08:01','127.0.0.1','admin','edas_user','login',''),
 (2,'2022-11-27 14:18:13','127.0.0.1','admin','edas_user','logout',''),
 (3,'2022-11-27 14:18:45','127.0.0.1','admin','edas_user','login',''),
 (4,'2022-11-27 14:19:26','127.0.0.1','admin','edas_user','logout',''),
 (5,'2022-11-27 14:19:45','127.0.0.1','admin','edas_user','login',''),
 (6,'2022-11-27 18:20:53','127.0.0.1','admin','edas_user','logout',''),
 (7,'2022-11-27 18:25:05','127.0.0.1','admin','edas_user','login',''),
 (8,'2022-11-27 18:26:41','127.0.0.1','admin','edas_user','logout',''),
 (9,'2022-11-27 18:26:49','127.0.0.1','user1','edas_user','login',''),
 (10,'2022-11-27 19:08:01','127.0.0.1','user1','edas_nav_file','delete','---Keys\r\nid_edas_file : 1\r\n---Fields\r\nedas_directory_id [old]: 1\r\ncode [old]: Example_file_1\r\nname [old]: Ejemplo fichero 1\r\nlocked [old]: 0\r\ncreationDate [old]: 2022-11-23 17:58:46\r\nlastModificationDate [old]: 2022-11-23 17:58:46\r\nfiles [old]: [{\"name\":\"files\\/1\\/compralquilando-file3_fpfqw027.pdf\",\"usrName\":\"compralquilando-file3.pdf\",\"size\":69699,\"type\":\"application\\/pdf\",\"searchStr\":\"compralquilando-file3.pdf,!configuracion php_ini.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/configuracion php_ini_mqv5qml9.docx\",\"usrName\":\"configuracion php_ini\r\n'),
 (11,'2022-11-27 19:08:01','127.0.0.1','user1','edas_nav_file','delete','---Keys\r\nid_edas_file : 2\r\n---Fields\r\nedas_directory_id [old]: 1\r\ncode [old]: file_2\r\nname [old]: Ejemplo de fichero 2\r\nlocked [old]: 0\r\ncreationDate [old]: 2022-11-26 20:12:19\r\nlastModificationDate [old]: 2022-11-26 20:12:19\r\nfiles [old]: [{\"name\":\"files\\/2\\/6f77622ce5260a0065e908ae781b6d9ee3ca8a339b4a5a4cf1fbe562675e6a84_whrnbp7y.JPG\",\"usrName\":\"6f77622ce5260a0065e908ae781b6d9ee3ca8a339b4a5a4cf1fbe562675e6a84.JPG\",\"size\":545341,\"type\":\"image\\/jpeg\",\"searchStr\":\"6f77622ce5260a0065e908ae781b6d9ee3ca8a339b4a5a4cf1fbe562675e6a84.JPG,!:s\r\n'),
 (12,'2022-11-27 19:26:32','127.0.0.1','user1','edas_user','logout',''),
 (13,'2022-11-27 19:26:40','127.0.0.1','user1','edas_user','login',''),
 (14,'2022-11-27 19:57:38','127.0.0.1','user1','edas_nav_file','add','---Keys\r\nid_edas_file : 1\r\n---Fields\r\nedas_directory_id [new]: 2\r\ncode [new]: EXP1_000001_2_2022\r\nname [new]: Ejemplo de expediente\r\nlocked [new]: 0\r\nfiles [new]: [{\"name\":\"files\\/tmp\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/tmp\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"u\r\nowners [new]: 2,3,4\r\nreading_groups [new]: 1,2\r\nwriting_groups [new]: 2\r\ncreationDate [new]: 2022-11-27 19:57:38\r\nuserCreation [new]: user1\r\nlastModificationDate [new]: 2022-11-27 19:57:38\r\nuserLastModification [new]: user1\r\n'),
 (15,'2022-11-27 20:02:46','127.0.0.1','user1','edas_nav_file','edit','---Keys\r\nid_edas_file : 1\r\n---Fields\r\nowners [old]: 2,3,4\r\nowners [new]: 3\r\nlastModificationDate [old]: 2022-11-27 19:57:38\r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\n'),
 (16,'2022-11-28 09:19:29','127.0.0.1','user1','edas_user','logout',''),
 (17,'2022-11-28 12:44:08','127.0.0.1','admin','edas_user','login',''),
 (18,'2022-11-28 12:53:37','127.0.0.1','admin','edas_nav_file','add','---Keys\r\nid_edas_file : 2\r\n---Fields\r\nedas_directory_id [new]: 2\r\ncode [new]: EXP1_000002_3_2022\r\nname [new]: EXP1/000002.3/2022 tro ejemplo de Expediente\r\nlocked [new]: 0\r\nfiles [new]: [{\"name\":\"files\\/tmp\\/Lorem ipsum dolor sit amet_01ascwce.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/tmp\\/Lorem ipsum dolor sit amet_2n4gpeuf.docx\",\"u\r\nowners [new]: 2,3,4\r\nreading_groups [new]: 1,2\r\nwriting_groups [new]: 2\r\ncreationDate [new]: 2022-11-28 12:53:37\r\nuserCreation [new]: admin\r\nlastModificationDate [new]: 2022-11-28 12:53:37\r\nuserLastModification [new]: admin\r\n'),
 (19,'2022-11-28 12:55:47','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file : 2\r\n---Fields\r\nname [old]: EXP1/000002.3/2022 tro ejemplo de Expediente\r\nname [new]: EXP1/000002.3/2022 otro ejemplo de Expediente\r\nlastModificationDate [old]: 2022-11-28 12:53:37\r\nlastModificationDate [new]: 2022-11-28 12:55:47\r\n'),
 (20,'2022-11-28 18:54:43','127.0.0.1','admin','edas_user','logout',''),
 (21,'2022-11-28 18:56:55','127.0.0.1','admin','edas_user','login',''),
 (22,'2022-11-28 19:00:24','127.0.0.1','admin','edas_template_user','add','---Keys\r\nid_edas_template_user : 2\r\n---Fields\r\nname [new]: General\r\nbelongingGroups [new]: 0\r\n'),
 (23,'2022-11-28 19:16:06','127.0.0.1','admin','edas_user','edit','---Keys\r\nid_edas_user : 4\r\n---Fields\r\nactive [old]: 0\r\nactive [new]: 1\r\n'),
 (24,'2022-11-28 19:16:51','127.0.0.1','admin','edas_user','edit','---Keys\r\nid_edas_user : 4\r\n---Fields\r\nactive [old]: 0\r\nactive [new]: 1\r\n'),
 (25,'2022-11-28 19:17:00','127.0.0.1','admin','edas_user','edit','---Keys\r\nid_edas_user : 3\r\n---Fields\r\nactive [old]: 0\r\nactive [new]: 1\r\n'),
 (26,'2022-11-28 19:22:53','127.0.0.1','admin','edas_user','edit','---Keys\r\nid_edas_user : 4\r\n---Fields\r\nactive [old]: 1\r\nactive [new]: 0\r\n'),
 (27,'2022-11-28 19:23:03','127.0.0.1','admin','edas_user','edit','---Keys\r\nid_edas_user : 4\r\n---Fields\r\nactive [old]: 0\r\nactive [new]: 1\r\n'),
 (28,'2022-11-28 20:28:51','127.0.0.1','admin','edas_user','delete','---Keys\r\n0 : ( ( id_edas_user=4 ) )\r\n---Fields\r\nid_edas_user [old]: 4\r\nlogin [old]: user2\r\npassword [old]: user2\r\nname [old]: User 2\r\nemail [old]: user2@fhumanes.com\r\nactive [old]: 0\r\nedas_template_user_id [old]: 1\r\ndeletionDate [old]: 2022-11-28 20:24:18\r\nuserDeletion [old]: admin\r\n'),
 (29,'2022-11-28 20:41:27','127.0.0.1','admin','edas_user','delete','---Keys\r\n0 :   id_edas_user:4  \r\n---Fields\r\nid_edas_user [old]: 4\r\nlogin [old]: user2\r\npassword [old]: user2\r\nname [old]: User 2\r\nemail [old]: user2@fhumanes.com\r\nactive [old]: 0\r\nedas_template_user_id [old]: 1\r\ndeletionDate [old]: 2022-11-28 20:28:13\r\nuserDeletion [old]: admin\r\n'),
 (30,'2022-11-28 21:11:48','127.0.0.1','admin','edas_user','logout',''),
 (31,'2022-11-28 21:19:20','127.0.0.1','admin','edas_user','login',''),
 (32,'2022-11-28 21:19:28','127.0.0.1','admin','edas_user','edit','---Keys\r\nid_edas_user : 4\r\n'),
 (33,'2022-11-28 21:23:58','127.0.0.1','admin','edas_template_user','add','---Keys\r\nid_edas_template_user : 3\r\n---Fields\r\nname [new]: Users expedient EXP2\r\nbelongingGroups [new]: 0,1,3\r\n'),
 (34,'2022-11-28 21:24:10','127.0.0.1','admin','edas_user','edit','---Keys\r\nid_edas_user : 4\r\n---Fields\r\nedas_template_user_id [old]: 1\r\nedas_template_user_id [new]: 1,3\r\n'),
 (35,'2022-11-28 21:26:39','127.0.0.1','admin','edas_user','edit','---Keys\r\nid_edas_user : 4\r\n'),
 (36,'2022-11-28 21:27:52','127.0.0.1','admin','edas_user','edit','---Keys\r\nid_edas_user : 4\r\n---Fields\r\nactive [old]: 0\r\nactive [new]: 1\r\n'),
 (37,'2022-11-28 21:28:12','127.0.0.1','admin','edas_user','edit','---Keys\r\nid_edas_user : 1\r\n'),
 (38,'2022-11-28 21:28:16','127.0.0.1','admin','edas_user','edit','---Keys\r\nid_edas_user : 2\r\n'),
 (39,'2022-11-28 21:28:19','127.0.0.1','admin','edas_user','edit','---Keys\r\nid_edas_user : 3\r\n'),
 (40,'2022-11-29 12:40:05','127.0.0.1','admin','edas_user','logout',''),
 (41,'2022-11-29 13:31:18','127.0.0.1','admin','edas_user','login',''),
 (42,'2022-11-29 13:45:29','127.0.0.1','admin','edas_nav_directory','add','---Keys\r\nid_edas_directory : 5\r\n---Fields\r\nedas_parent_directory_id [new]: 1\r\ncode [new]: Expedient_EXP1\r\nname [new]: Test\r\nlevel [new]: 2\r\nlocked [new]: 0\r\nowners [new]: 1,2\r\nreading_groups [new]: 1\r\nwriting_groups [new]: 1\r\n'),
 (43,'2022-11-29 13:45:45','127.0.0.1','admin','edas_nav_directory','delete','---Keys\r\nid_edas_directory : 5\r\n---Fields\r\nedas_parent_directory_id [old]: 1\r\ncode [old]: Expedient_EXP1\r\nname [old]: Test\r\nlevel [old]: 2\r\nlocked [old]: 0\r\nowners [old]: 1,2\r\nreading_groups [old]: 1\r\nwriting_groups [old]: 1\r\n'),
 (44,'2022-11-29 13:46:40','127.0.0.1','admin','edas_nav_directory','add','---Keys\r\nid_edas_directory : 6\r\n---Fields\r\nedas_parent_directory_id [new]: 1\r\ncode [new]: Expedient_EXP1\r\nname [new]: Test\r\nlevel [new]: 2\r\nlocked [new]: 0\r\nowners [new]: 1,2\r\nreading_groups [new]: 1\r\nwriting_groups [new]: 1\r\n'),
 (45,'2022-11-29 13:46:49','127.0.0.1','admin','edas_nav_directory','delete','---Keys\r\nid_edas_directory : 6\r\n---Fields\r\nedas_parent_directory_id [old]: 1\r\ncode [old]: Expedient_EXP1\r\nname [old]: Test\r\nlevel [old]: 2\r\nlocked [old]: 0\r\nowners [old]: 1,2\r\nreading_groups [old]: 1\r\nwriting_groups [old]: 1\r\n'),
 (46,'2022-11-29 13:53:23','127.0.0.1','admin','edas_nav_directory','edit','---Keys\r\nid_edas_directory : 4\r\n'),
 (47,'2022-11-29 14:10:34','127.0.0.1','admin','edas_nav_file','add','---Keys\r\nid_edas_file : 3\r\n---Fields\r\nedas_directory_id [new]: 2\r\ncode [new]: EXP1_000003_4_2022\r\nname [new]: Otro ejemplo\r\nlocked [new]: 0\r\nfiles [new]: [{\"name\":\"files\\/tmp\\/Lorem ipsum dolor sit amet_lnq4eidv.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/tmp\\/Lorem ipsum dolor sit amet_sx241485.docx\",\"u\r\nowners [new]: 2,3,4\r\nreading_groups [new]: 1,2\r\nwriting_groups [new]: 2\r\ncreationDate [new]: 2022-11-29 14:10:34\r\nuserCreation [new]: admin\r\nlastModificationDate [new]: 2022-11-29 14:10:34\r\nuserLastModification [new]: admin\r\n'),
 (48,'2022-11-29 16:56:31','127.0.0.1','admin','edas_user','logout',''),
 (49,'2022-11-29 17:09:37','127.0.0.1','admin','edas_user','login',''),
 (50,'2022-11-29 17:16:41','127.0.0.1','admin','edas_nav_file','delete','---Keys\r\nid_edas_file : 3\r\n---Fields\r\nedas_directory_id [old]: 2\r\ncode [old]: EXP1_000003_4_2022\r\nname [old]: Otro ejemplo\r\nlocked [old]: 0\r\nfiles [old]: [{\"name\":\"files\\/3\\/Lorem ipsum dolor sit amet_lnq4eidv.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/3\\/Lorem ipsum dolor sit amet_sx241485.docx\",\"usrNa\r\nowners [old]: 2,3,4\r\nreading_groups [old]: 1,2\r\nwriting_groups [old]: 2\r\ncreationDate [old]: 2022-11-29 14:10:34\r\nlastModificationDate [old]: 2022-11-29 14:10:34\r\nuserCreation [old]: admin\r\nuserLastModification [old]: admin\r\n'),
 (51,'2022-11-29 17:53:58','127.0.0.1','admin','edas_user','logout',''),
 (52,'2022-11-29 18:03:14','127.0.0.1','user2','edas_user','login',''),
 (53,'2022-11-29 18:06:27','127.0.0.1','user2','edas_user','logout',''),
 (54,'2022-11-29 18:06:31','127.0.0.1','admin','edas_user','login',''),
 (55,'2022-11-29 18:07:20','127.0.0.1','admin','edas_user','edit','---Keys\r\nid_edas_user : 1\r\n---Fields\r\nedas_template_user_id [old]: 1\r\nedas_template_user_id [new]: 2,1,3\r\n'),
 (56,'2022-11-29 18:07:24','127.0.0.1','admin','edas_user','logout',''),
 (57,'2022-11-29 18:07:27','127.0.0.1','admin','edas_user','login',''),
 (58,'2022-11-29 18:09:51','127.0.0.1','admin','edas_directory','edit','---Keys\r\nid_edas_directory : 2\r\n---Fields\r\nreading_groups [old]: 1,2\r\nreading_groups [new]: 1,2,0\r\n'),
 (59,'2022-11-29 18:14:31','127.0.0.1','admin','edas_user','logout',''),
 (60,'2022-11-29 18:14:39','127.0.0.1','user2','edas_user','login',''),
 (61,'2022-11-29 18:15:21','::1','admin','edas_user','login',''),
 (62,'2022-11-29 18:15:44','::1','admin','edas_user','edit','---Keys\r\nid_edas_user : 4\r\n---Fields\r\nedas_template_user_id [old]: 1,3\r\nedas_template_user_id [new]: 3\r\n'),
 (63,'2022-11-29 18:17:05','127.0.0.1','user2','edas_user','logout',''),
 (64,'2022-11-29 18:17:14','127.0.0.1','user2','edas_user','login',''),
 (65,'2022-11-29 18:23:24','127.0.0.1','user2','edas_nav_directory','edit','---Keys\r\nid_edas_directory : 4\r\n---Fields\r\nwriting_groups [old]: 1,3\r\nwriting_groups [new]: 3\r\n'),
 (66,'2022-11-29 18:23:48','127.0.0.1','user2','edas_nav_directory','edit','---Keys\r\nid_edas_directory : 2\r\n---Fields\r\nreading_groups [old]: 1,2,0\r\nreading_groups [new]: 1,2\r\n'),
 (67,'2022-11-29 18:25:12','127.0.0.1','user2','edas_nav_directory','edit','---Keys\r\nid_edas_directory : 3\r\n---Fields\r\nreading_groups [old]: 2,1\r\nreading_groups [new]: 2\r\nwriting_groups [old]: 2,1\r\nwriting_groups [new]: 2\r\n'),
 (68,'2022-11-29 18:33:31','127.0.0.1','user2','edas_nav_file','edit','---Keys\r\nid_edas_file : 2\r\n---Fields\r\nowners [old]: 2,3,4\r\nowners [new]: 2,3\r\nlastModificationDate [old]: 2022-11-28 12:55:47\r\nlastModificationDate [new]: 2022-11-29 18:33:31\r\nuserLastModification [old]: admin\r\nuserLastModification [new]: user2\r\n'),
 (69,'2022-11-29 18:48:44','::1','admin','edas_user','login',''),
 (70,'2022-11-30 13:15:25','127.0.0.1','user2','edas_user','logout',''),
 (71,'2022-11-30 13:15:47','::1','admin','edas_user','logout',''),
 (72,'2022-11-30 13:44:07','127.0.0.1','user1','edas_user','login',''),
 (73,'2022-11-30 13:52:47','127.0.0.1','user1','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (74,'2022-11-30 14:25:39','127.0.0.1','user1','edas_user','logout',''),
 (75,'2022-11-30 14:28:43','127.0.0.1','admin','edas_user','login',''),
 (76,'2022-11-30 14:34:30','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: fff\r\n'),
 (77,'2022-11-30 14:35:31','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: dddd\r\n'),
 (78,'2022-11-30 14:35:54','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: aaa\r\n'),
 (79,'2022-11-30 14:37:45','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: dddd\r\n'),
 (80,'2022-11-30 14:39:04','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: cccc\r\n'),
 (81,'2022-11-30 14:40:34','127.0.0.1','admin','edas_user','logout',''),
 (82,'2022-11-30 14:41:27','127.0.0.1','admin','edas_user','login',''),
 (83,'2022-11-30 14:41:36','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: cccc\r\n'),
 (84,'2022-11-30 17:21:07','127.0.0.1','admin','edas_user','logout',''),
 (85,'2022-11-30 17:22:04','127.0.0.1','admin','edas_user','login',''),
 (86,'2022-11-30 17:22:12','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: ggg\r\n'),
 (87,'2022-11-30 17:24:42','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: ggg\r\n'),
 (88,'2022-11-30 17:27:41','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: frfrfr4\r\n'),
 (89,'2022-11-30 17:34:51','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: fff\r\n'),
 (90,'2022-11-30 17:41:24','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: ddd\r\n'),
 (91,'2022-11-30 17:42:22','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: dedede\r\n'),
 (92,'2022-11-30 17:50:43','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: fffff\r\n'),
 (93,'2022-11-30 18:21:02','127.0.0.1','admin','edas_user','logout',''),
 (94,'2022-11-30 18:58:09','127.0.0.1','admin','edas_user','login',''),
 (95,'2022-11-30 19:17:56','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (96,'2022-11-30 19:33:23','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (97,'2022-11-30 19:33:42','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (98,'2022-11-30 19:35:08','127.0.0.1','admin','edas_user','logout',''),
 (99,'2022-11-30 19:35:11','127.0.0.1','admin','edas_user','login',''),
 (100,'2022-11-30 19:35:22','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (101,'2022-11-30 19:44:17','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (102,'2022-11-30 19:45:51','127.0.0.1','admin','edas_user','logout',''),
 (103,'2022-11-30 19:45:56','127.0.0.1','admin','edas_user','login',''),
 (104,'2022-11-30 19:46:06','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (105,'2022-11-30 19:55:30','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (106,'2022-11-30 20:27:31','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (107,'2022-11-30 20:39:42','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (108,'2022-11-30 21:04:26','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (109,'2022-11-30 21:06:22','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (110,'2022-11-30 21:07:41','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (111,'2022-11-30 21:09:59','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (112,'2022-11-30 21:10:38','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (113,'2022-11-30 21:20:52','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (114,'2022-11-30 21:21:12','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (115,'2022-11-30 21:22:28','127.0.0.1','admin','edas_user','logout',''),
 (116,'2022-11-30 21:22:42','127.0.0.1','user1','edas_user','login',''),
 (117,'2022-11-30 21:22:54','127.0.0.1','user1','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (118,'2022-11-30 21:27:47','127.0.0.1','user1','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (119,'2022-12-01 13:57:49','127.0.0.1','user1','edas_user','logout',''),
 (120,'2022-12-01 14:00:28','127.0.0.1','admin','edas_user','login',''),
 (121,'2022-12-01 14:00:59','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (122,'2022-12-01 14:02:23','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (123,'2022-12-01 14:03:55','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (124,'2022-12-01 14:04:12','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (125,'2022-12-01 14:06:35','127.0.0.1','admin','edas_nav_file','add','---Keys\r\nid_edas_file : 4\r\n---Fields\r\nedas_directory_id [new]: 2\r\ncode [new]: EXP1_000003_4_2022\r\nname [new]: EXP1/000003.4/2022 ejemplo de expediente\r\nlocked [new]: 0\r\nfiles [new]: [{\"name\":\"files\\/tmp\\/Lorem ipsum dolor sit amet_7zfnayur.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/tmp\\/Lorem ipsum dolor sit amet_r8taccna.docx\",\"u\r\nowners [new]: 1,2\r\nreading_groups [new]: 1,2\r\nwriting_groups [new]: 2\r\ncreationDate [new]: 2022-12-01 14:06:35\r\nuserCreation [new]: admin\r\nlastModificationDate [new]: 2022-12-01 14:06:35\r\nuserLastModification [new]: admin\r\n'),
 (126,'2022-12-01 14:06:45','127.0.0.1','admin','edas_nav_file','delete','---Keys\r\nid_edas_file : 4\r\n---Fields\r\nedas_directory_id [old]: 2\r\ncode [old]: EXP1_000003_4_2022\r\nname [old]: EXP1/000003.4/2022 ejemplo de expediente\r\nlocked [old]: 0\r\nfiles [old]: [{\"name\":\"files\\/4\\/Lorem ipsum dolor sit amet_7zfnayur.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/4\\/Lorem ipsum dolor sit amet_r8taccna.docx\",\"usrNa\r\nowners [old]: 1,2\r\nreading_groups [old]: 1,2\r\nwriting_groups [old]: 2\r\ncreationDate [old]: 2022-12-01 14:06:35\r\nlastModificationDate [old]: 2022-12-01 14:06:35\r\nuserCreation [old]: admin\r\nuserLastModification [old]: admin\r\n'),
 (127,'2022-12-01 14:34:30','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\n---Fields\r\nid_edas_file [old]: \r\nid_edas_file [new]: 2\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000002_3_2022\r\nname [old]: \r\nname [new]: EXP1/000002.3/2022 otro ejemplo de Expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_01ascwce.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_2n4gpeuf.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 2,3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-28 12:53:37\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-29 18:33:31\r\nuserCreation [old]: \r\nuserCreation [new]: admin\r\nuserLastModification [old]: \r\nuserLastModification [new]: user2\r\n'),
 (128,'2022-12-01 14:39:38','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\n---Fields\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (129,'2022-12-01 14:43:41','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (130,'2022-12-01 14:45:19','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\n---Fields\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (131,'2022-12-01 16:38:26','127.0.0.1','admin','edas_user','logout',''),
 (132,'2022-12-01 16:41:05','127.0.0.1','admin','edas_user','login',''),
 (133,'2022-12-01 16:42:49','127.0.0.1','admin','edas_nav_file','add','---Keys\r\nid_edas_file : 5\r\n---Fields\r\nedas_directory_id [new]: 2\r\ncode [new]: EXP1_000004_5_2022\r\nname [new]: EXP1/000004.5/2022 es un ejemplo\r\nlocked [new]: 0\r\nfiles [new]: [{\"name\":\"files\\/tmp\\/Lorem ipsum dolor sit amet_6rmt1ap5.docx\",\"usrName\":\"Lorem ipsum dolor sit amet.docx\",\"size\":12822,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"Lorem ipsum dolor sit amet.docx,!Lorem ipsum dolor sit amet.pdf,!favicon-3x.png,!:sS\r\nowners [new]: 1\r\nreading_groups [new]: 1,2\r\nwriting_groups [new]: 2\r\ncreationDate [new]: 2022-12-01 16:42:49\r\nuserCreation [new]: admin\r\nlastModificationDate [new]: 2022-12-01 16:42:49\r\nuserLastModification [new]: admin\r\n'),
 (134,'2022-12-01 16:43:32','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 5\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000004_5_2022\r\nname [old]: \r\nname [new]: EXP1/000004.5/2022 es un ejemplo\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/5\\/Lorem ipsum dolor sit amet_6rmt1ap5.docx\",\"usrName\":\"Lorem ipsum dolor sit amet.docx\",\"size\":12822,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"Lorem ipsum dolor sit amet.docx,!Lorem ipsum dolor sit amet.pdf,!favicon-3x.png,!:sStr\r\nowners [old]: \r\nowners [new]: 1\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-12-01 16:42:49\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-12-01 16:42:49\r\nuserCreation [old]: \r\nuserCreation [new]: admin\r\nuserLastModification [old]: \r\nuserLastModification [new]: admin\r\n'),
 (135,'2022-12-01 16:43:40','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 5\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000004_5_2022\r\nname [old]: \r\nname [new]: EXP1/000004.5/2022 es un ejemplo\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/5\\/Lorem ipsum dolor sit amet_6rmt1ap5.docx\",\"usrName\":\"Lorem ipsum dolor sit amet.docx\",\"size\":12822,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"Lorem ipsum dolor sit amet.docx,!Lorem ipsum dolor sit amet.pdf,!favicon-3x.png,!:sStr\r\nowners [old]: \r\nowners [new]: 1\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-12-01 16:42:49\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-12-01 16:42:49\r\nuserCreation [old]: \r\nuserCreation [new]: admin\r\nuserLastModification [old]: \r\nuserLastModification [new]: admin\r\n'),
 (136,'2022-12-01 16:44:02','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 5\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000004_5_2022\r\nname [old]: \r\nname [new]: EXP1/000004.5/2022 es un ejemplo\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/5\\/Lorem ipsum dolor sit amet_6rmt1ap5.docx\",\"usrName\":\"Lorem ipsum dolor sit amet.docx\",\"size\":12822,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"Lorem ipsum dolor sit amet.docx,!Lorem ipsum dolor sit amet.pdf,!favicon-3x.png,!:sStr\r\nowners [old]: \r\nowners [new]: 1\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-12-01 16:42:49\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-12-01 16:42:49\r\nuserCreation [old]: \r\nuserCreation [new]: admin\r\nuserLastModification [old]: \r\nuserLastModification [new]: admin\r\n'),
 (137,'2022-12-01 16:44:14','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000004_5_2022\r\n'),
 (138,'2022-12-01 18:16:59','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (139,'2022-12-01 18:18:55','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 2\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000002_3_2022\r\nname [old]: \r\nname [new]: EXP1/000002.3/2022 otro ejemplo de Expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_01ascwce.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_2n4gpeuf.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 2,3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-28 12:53:37\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-29 18:33:31\r\nuserCreation [old]: \r\nuserCreation [new]: admin\r\nuserLastModification [old]: \r\nuserLastModification [new]: user2\r\n'),
 (140,'2022-12-01 18:20:44','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 5\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000004_5_2022\r\nname [old]: \r\nname [new]: EXP1/000004.5/2022 es un ejemplo\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/5\\/Lorem ipsum dolor sit amet_6rmt1ap5.docx\",\"usrName\":\"Lorem ipsum dolor sit amet.docx\",\"size\":12822,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"Lorem ipsum dolor sit amet.docx,!Lorem ipsum dolor sit amet.pdf,!favicon-3x.png,!:sStr\r\nowners [old]: \r\nowners [new]: 1\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-12-01 16:42:49\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-12-01 16:42:49\r\nuserCreation [old]: \r\nuserCreation [new]: admin\r\nuserLastModification [old]: \r\nuserLastModification [new]: admin\r\n'),
 (141,'2022-12-01 18:34:46','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (142,'2022-12-01 19:02:59','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 2\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000002_3_2022\r\nname [old]: \r\nname [new]: EXP1/000002.3/2022 otro ejemplo de Expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_01ascwce.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_2n4gpeuf.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 2,3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-28 12:53:37\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-29 18:33:31\r\nuserCreation [old]: \r\nuserCreation [new]: admin\r\nuserLastModification [old]: \r\nuserLastModification [new]: user2\r\n'),
 (143,'2022-12-01 19:03:21','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 5\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000004_5_2022\r\nname [old]: \r\nname [new]: EXP1/000004.5/2022 es un ejemplo\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/5\\/Lorem ipsum dolor sit amet_6rmt1ap5.docx\",\"usrName\":\"Lorem ipsum dolor sit amet.docx\",\"size\":12822,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"Lorem ipsum dolor sit amet.docx,!Lorem ipsum dolor sit amet.pdf,!favicon-3x.png,!:sStr\r\nowners [old]: \r\nowners [new]: 1\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-12-01 16:42:49\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-12-01 16:42:49\r\nuserCreation [old]: \r\nuserCreation [new]: admin\r\nuserLastModification [old]: \r\nuserLastModification [new]: admin\r\n'),
 (144,'2022-12-01 19:05:24','127.0.0.1','admin','edas_user','logout',''),
 (145,'2022-12-01 19:05:31','127.0.0.1','user1','edas_user','login',''),
 (146,'2022-12-01 19:06:05','127.0.0.1','user1','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000004_5_2022\r\n'),
 (147,'2022-12-01 19:33:51','127.0.0.1','user1','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 5\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000004_5_2022\r\nname [old]: \r\nname [new]: EXP1/000004.5/2022 es un ejemplo\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/5\\/Lorem ipsum dolor sit amet_6rmt1ap5.docx\",\"usrName\":\"Lorem ipsum dolor sit amet.docx\",\"size\":12822,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"Lorem ipsum dolor sit amet.docx,!Lorem ipsum dolor sit amet.pdf,!favicon-3x.png,!:sStr\r\nowners [old]: \r\nowners [new]: 1\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-12-01 16:42:49\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-12-01 16:42:49\r\nuserCreation [old]: \r\nuserCreation [new]: admin\r\nuserLastModification [old]: \r\nuserLastModification [new]: admin\r\n'),
 (148,'2022-12-01 19:39:45','127.0.0.1','user1','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 5\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000004_5_2022\r\nname [old]: \r\nname [new]: EXP1/000004.5/2022 es un ejemplo\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/5\\/Lorem ipsum dolor sit amet_6rmt1ap5.docx\",\"usrName\":\"Lorem ipsum dolor sit amet.docx\",\"size\":12822,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"Lorem ipsum dolor sit amet.docx,!Lorem ipsum dolor sit amet.pdf,!favicon-3x.png,!:sStr\r\nowners [old]: \r\nowners [new]: 1\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-12-01 16:42:49\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-12-01 16:42:49\r\nuserCreation [old]: \r\nuserCreation [new]: admin\r\nuserLastModification [old]: \r\nuserLastModification [new]: admin\r\n'),
 (149,'2022-12-01 19:40:26','127.0.0.1','user1','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (150,'2022-12-01 19:40:37','127.0.0.1','user1','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (151,'2022-12-01 19:52:47','127.0.0.1','user1','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (152,'2022-12-01 19:54:57','127.0.0.1','user1','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022 \r\n'),
 (153,'2022-12-01 19:56:08','127.0.0.1','user1','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (154,'2022-12-01 19:58:23','127.0.0.1','user1','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (155,'2022-12-01 19:58:36','127.0.0.1','user1','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (156,'2022-12-01 19:58:56','127.0.0.1','user1','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022 \r\n'),
 (157,'2022-12-01 20:02:18','127.0.0.1','user1','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (158,'2022-12-01 20:26:42','127.0.0.1','user1','edas_user','logout',''),
 (159,'2022-12-02 17:49:53','127.0.0.1','admin','edas_user','login',''),
 (160,'2022-12-02 17:50:13','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (161,'2022-12-02 17:50:33','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022 \r\n'),
 (162,'2022-12-02 17:50:38','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (163,'2022-12-02 18:20:54','127.0.0.1','admin','edas_user','logout',''),
 (164,'2022-12-05 18:26:58','127.0.0.1','admin','edas_user','login',''),
 (165,'2022-12-05 18:27:12','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (166,'2022-12-05 18:27:29','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (167,'2022-12-05 18:56:19','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (168,'2022-12-05 18:56:42','127.0.0.1','admin','edas_user','logout',''),
 (169,'2022-12-05 18:56:50','127.0.0.1','admin','edas_user','login',''),
 (170,'2022-12-05 18:57:16','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (171,'2022-12-05 19:00:16','127.0.0.1','admin','edas_user','logout',''),
 (172,'2022-12-05 19:00:20','127.0.0.1','admin','edas_user','login',''),
 (173,'2022-12-05 19:00:35','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (174,'2022-12-05 19:00:52','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (175,'2022-12-05 19:03:10','127.0.0.1','admin','edas_user','logout',''),
 (176,'2022-12-05 19:03:14','127.0.0.1','admin','edas_user','login',''),
 (177,'2022-12-05 19:04:18','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (178,'2022-12-05 19:06:22','127.0.0.1','admin','edas_user','logout',''),
 (179,'2022-12-05 19:07:43','127.0.0.1','admin','edas_user','login',''),
 (180,'2022-12-05 19:11:33','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (181,'2022-12-05 19:21:20','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (182,'2022-12-05 19:21:38','127.0.0.1','admin','edas_user','logout',''),
 (183,'2022-12-05 19:21:41','127.0.0.1','admin','edas_user','login',''),
 (184,'2022-12-05 19:23:15','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (185,'2022-12-05 19:23:40','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (186,'2022-12-05 19:26:27','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022 \r\n'),
 (187,'2022-12-05 19:27:12','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (188,'2022-12-05 19:36:28','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 2\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000002_3_2022\r\nname [old]: \r\nname [new]: EXP1/000002.3/2022 otro ejemplo de Expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_01ascwce.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_2n4gpeuf.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 2,3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-28 12:53:37\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-29 18:33:31\r\nuserCreation [old]: \r\nuserCreation [new]: admin\r\nuserLastModification [old]: \r\nuserLastModification [new]: user2\r\n'),
 (189,'2022-12-05 19:36:55','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000002_3_2022\r\n'),
 (190,'2022-12-05 19:44:26','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000002_3_2022\r\n'),
 (191,'2022-12-05 19:46:07','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (192,'2022-12-05 19:46:41','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000002_3_2022\r\n'),
 (193,'2022-12-05 20:24:48','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (194,'2022-12-05 20:25:02','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (195,'2022-12-05 20:26:59','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 2\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000002_3_2022\r\nname [old]: \r\nname [new]: EXP1/000002.3/2022 otro ejemplo de Expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_01ascwce.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_2n4gpeuf.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 2,3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-28 12:53:37\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-29 18:33:31\r\nuserCreation [old]: \r\nuserCreation [new]: admin\r\nuserLastModification [old]: \r\nuserLastModification [new]: user2\r\n'),
 (196,'2022-12-05 20:57:25','127.0.0.1','admin','edas_user','logout',''),
 (197,'2022-12-05 21:01:14','127.0.0.1','admin','edas_user','login',''),
 (198,'2022-12-05 21:25:31','127.0.0.1','admin','edas_user','logout',''),
 (199,'2022-12-05 21:25:37','127.0.0.1','user1','edas_user','login',''),
 (200,'2022-12-06 17:05:37','127.0.0.1','user1','edas_user','logout',''),
 (201,'2022-12-06 17:29:39','127.0.0.1','admin','edas_user','login',''),
 (202,'2022-12-06 17:30:56','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (203,'2022-12-06 17:31:07','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (204,'2022-12-06 17:56:49','127.0.0.1','admin','edas_user','logout',''),
 (205,'2022-12-06 17:56:53','127.0.0.1','admin','edas_user','login',''),
 (206,'2022-12-06 17:57:19','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (207,'2022-12-06 17:57:31','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n');
INSERT INTO `edas_audit` (`id`,`datetime`,`ip`,`user`,`table`,`action`,`description`) VALUES 
 (208,'2022-12-06 18:20:21','127.0.0.1','admin','edas_user','logout',''),
 (209,'2022-12-06 18:20:28','127.0.0.1','admin','edas_user','login',''),
 (210,'2022-12-06 18:49:16','127.0.0.1','admin','edas_user','logout',''),
 (211,'2022-12-06 18:49:21','127.0.0.1','admin','edas_user','login',''),
 (212,'2022-12-06 18:51:44','127.0.0.1','admin','edas_user','logout',''),
 (213,'2022-12-06 18:51:47','127.0.0.1','admin','edas_user','login',''),
 (214,'2022-12-06 19:08:08','127.0.0.1','admin','edas_user','logout',''),
 (215,'2022-12-06 19:08:11','127.0.0.1','admin','edas_user','login',''),
 (216,'2022-12-06 19:11:28','127.0.0.1','admin','edas_user','logout',''),
 (217,'2022-12-06 19:11:34','127.0.0.1','admin','edas_user','login',''),
 (218,'2022-12-06 19:16:55','127.0.0.1','admin','edas_user','logout',''),
 (219,'2022-12-06 19:17:00','127.0.0.1','admin','edas_user','login',''),
 (220,'2022-12-06 19:40:22','127.0.0.1','admin','edas_nav_directory','add','---Keys\r\nid_edas_directory : 7\r\n---Fields\r\nedas_parent_directory_id [new]: 3\r\nlevel [new]: 4\r\nlocked [new]: 0\r\nowners [new]: 1\r\nreading_groups [new]: 2\r\nwriting_groups [new]: 2\r\n'),
 (221,'2022-12-06 19:40:43','127.0.0.1','admin','edas_nav_directory','delete','---Keys\r\nid_edas_directory : 7\r\n---Fields\r\nedas_parent_directory_id [old]: 3\r\nlevel [old]: 4\r\nlocked [old]: 0\r\nowners [old]: 1\r\nreading_groups [old]: 2\r\nwriting_groups [old]: 2\r\n'),
 (222,'2022-12-06 19:41:18','127.0.0.1','admin','edas_nav_directory','edit','---Keys\r\nid_edas_directory : 1\r\n---Fields\r\nlevel [old]: 1\r\nlevel [new]: 2\r\n'),
 (223,'2022-12-06 19:41:30','127.0.0.1','admin','edas_nav_directory','edit','---Keys\r\nid_edas_directory : 2\r\n---Fields\r\nlevel [old]: 2\r\nlevel [new]: 3\r\n'),
 (224,'2022-12-06 19:41:36','127.0.0.1','admin','edas_nav_directory','edit','---Keys\r\nid_edas_directory : 4\r\n---Fields\r\nlevel [old]: 2\r\nlevel [new]: 3\r\n'),
 (225,'2022-12-06 19:41:47','127.0.0.1','admin','edas_nav_directory','edit','---Keys\r\nid_edas_directory : 3\r\n---Fields\r\nlevel [old]: 3\r\nlevel [new]: 4\r\n'),
 (226,'2022-12-06 20:00:14','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 2\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000002_3_2022\r\nname [old]: \r\nname [new]: EXP1/000002.3/2022 otro ejemplo de Expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_01ascwce.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_2n4gpeuf.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 2,3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-28 12:53:37\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-29 18:33:31\r\nuserCreation [old]: \r\nuserCreation [new]: admin\r\nuserLastModification [old]: \r\nuserLastModification [new]: user2\r\n'),
 (227,'2022-12-06 20:14:43','127.0.0.1','admin','edas_user','logout',''),
 (228,'2022-12-06 20:14:49','127.0.0.1','user2','edas_user','login',''),
 (229,'2022-12-07 14:03:49','127.0.0.1','user2','edas_user','logout',''),
 (230,'2022-12-07 20:24:54','127.0.0.1','admin','edas_user','login',''),
 (231,'2022-12-07 20:55:50','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (232,'2022-12-07 20:56:30','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (233,'2022-12-07 21:26:35','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (234,'2022-12-07 21:26:52','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /./Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (235,'2022-12-07 21:34:43','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (236,'2022-12-07 21:37:28','127.0.0.1','admin','edas_user','logout',''),
 (237,'2022-12-07 21:37:31','127.0.0.1','admin','edas_user','login',''),
 (238,'2022-12-07 21:38:01','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (239,'2022-12-07 21:43:33','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /./Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (240,'2022-12-07 21:45:36','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /./Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (241,'2022-12-07 21:53:37','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /./Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (242,'2022-12-07 21:54:29','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /./Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (243,'2022-12-07 21:54:47','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /./Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (244,'2022-12-07 21:55:03','127.0.0.1','admin','edas_user','logout',''),
 (245,'2022-12-07 21:55:11','127.0.0.1','user2','edas_user','login',''),
 (246,'2022-12-07 21:55:24','127.0.0.1','user2','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /./Home/Departament_1/Expedient_EXP1/EXP1_000001_2_2022\r\n'),
 (247,'2022-12-07 21:55:35','127.0.0.1','user2','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 1\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000001_2_2022\r\nname [old]: \r\nname [new]: Ejemplo de expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-27 19:57:38\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-27 20:02:46\r\nuserCreation [old]: \r\nuserCreation [new]: user1\r\nuserLastModification [old]: \r\nuserLastModification [new]: user1\r\n'),
 (248,'2022-12-08 12:46:48','127.0.0.1','user2','edas_user','logout',''),
 (249,'2022-12-08 12:49:39','127.0.0.1','admin','edas_user','login',''),
 (250,'2022-12-08 13:13:58','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 2\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000002_3_2022\r\nname [old]: \r\nname [new]: EXP1/000002.3/2022 otro ejemplo de Expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_01ascwce.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_2n4gpeuf.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 2,3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-28 12:53:37\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-29 18:33:31\r\nuserCreation [old]: \r\nuserCreation [new]: admin\r\nuserLastModification [old]: \r\nuserLastModification [new]: user2\r\n'),
 (251,'2022-12-08 13:13:59','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 2\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000002_3_2022\r\nname [old]: \r\nname [new]: EXP1/000002.3/2022 otro ejemplo de Expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_01ascwce.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_2n4gpeuf.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 2,3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-28 12:53:37\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-29 18:33:31\r\nuserCreation [old]: \r\nuserCreation [new]: admin\r\nuserLastModification [old]: \r\nuserLastModification [new]: user2\r\n'),
 (252,'2022-12-08 13:24:16','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000002_3_2022\r\n'),
 (253,'2022-12-08 13:25:10','127.0.0.1','admin','edas_user','logout',''),
 (254,'2022-12-08 13:25:14','127.0.0.1','admin','edas_user','login',''),
 (255,'2022-12-08 13:25:34','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000002_3_2022\r\n'),
 (256,'2022-12-08 13:27:36','127.0.0.1','admin','edas_nav_directory','edit','---Keys\r\nid_edas_directory : 1\r\n---Fields\r\nname [old]: Estructure Departament 1\r\nname [new]: Estructure Departament 1 .\r\n'),
 (257,'2022-12-08 13:37:41','127.0.0.1','admin','edas_nav_directory','edit','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [old]: Name Company\r\nname [new]: Name Company .\r\n'),
 (258,'2022-12-08 13:38:05','127.0.0.1','admin','edas_nav_directory','edit','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [old]: Name Company .\r\nname [new]: Name Company \r\n'),
 (259,'2022-12-08 13:38:59','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 5\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000004_5_2022\r\nname [old]: \r\nname [new]: EXP1/000004.5/2022 es un ejemplo\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/5\\/Lorem ipsum dolor sit amet_6rmt1ap5.docx\",\"usrName\":\"Lorem ipsum dolor sit amet.docx\",\"size\":12822,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"Lorem ipsum dolor sit amet.docx,!Lorem ipsum dolor sit amet.pdf,!favicon-3x.png,!:sStr\r\nowners [old]: \r\nowners [new]: 1\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-12-01 16:42:49\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-12-01 16:42:49\r\nuserCreation [old]: \r\nuserCreation [new]: admin\r\nuserLastModification [old]: \r\nuserLastModification [new]: admin\r\n'),
 (260,'2022-12-08 13:39:08','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000004_5_2022\r\n'),
 (261,'2022-12-08 13:39:24','127.0.0.1','admin','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 5\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000004_5_2022\r\nname [old]: \r\nname [new]: EXP1/000004.5/2022 es un ejemplo\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/5\\/Lorem ipsum dolor sit amet_6rmt1ap5.docx\",\"usrName\":\"Lorem ipsum dolor sit amet.docx\",\"size\":12822,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"Lorem ipsum dolor sit amet.docx,!Lorem ipsum dolor sit amet.pdf,!favicon-3x.png,!:sStr\r\nowners [old]: \r\nowners [new]: 1\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-12-01 16:42:49\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-12-01 16:42:49\r\nuserCreation [old]: \r\nuserCreation [new]: admin\r\nuserLastModification [old]: \r\nuserLastModification [new]: admin\r\n'),
 (262,'2022-12-08 13:47:24','127.0.0.1','admin','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000002_3_2022\r\n'),
 (263,'2022-12-08 13:52:43','127.0.0.1','admin','edas_group','add','---Keys\r\nid_edas_group : 4\r\n---Fields\r\ncode [new]: Deàrtament 2\r\nname [new]: Organization (Departament 2)\r\nactive [new]: 1\r\n'),
 (264,'2022-12-08 13:52:55','127.0.0.1','admin','edas_group','edit','---Keys\r\nid_edas_group : 4\r\n---Fields\r\ncode [old]: Deàrtament 2\r\ncode [new]: Departament 2\r\n'),
 (265,'2022-12-08 19:17:23','127.0.0.1','admin','edas_user','logout',''),
 (266,'2022-12-08 19:18:29','127.0.0.1','admin','edas_user','login',''),
 (267,'2022-12-08 19:19:23','127.0.0.1','admin','edas_nav_directory','add','---Keys\r\nid_edas_directory : 8\r\n---Fields\r\nedas_parent_directory_id [new]: 0\r\ncode [new]: Departament_2\r\nname [new]: Estructura Departament 2\r\nlevel [new]: 2\r\nlocked [new]: 0\r\nowners [new]: 1\r\nreading_groups [new]: 0\r\nwriting_groups [new]: 0\r\n'),
 (268,'2022-12-08 19:20:16','127.0.0.1','admin','edas_nav_directory','edit','---Keys\r\nid_edas_directory : 8\r\n---Fields\r\nreading_groups [old]: 0\r\nreading_groups [new]: 0,4\r\nwriting_groups [old]: 0\r\nwriting_groups [new]: 4\r\n'),
 (269,'2022-12-08 19:20:19','127.0.0.1','admin','edas_user','logout',''),
 (270,'2022-12-08 19:20:27','127.0.0.1','user2','edas_user','login',''),
 (271,'2022-12-08 19:20:55','127.0.0.1','user2','edas_nav_file','edit','---Keys\r\nid_edas_file [old]: \r\nid_edas_file [new]: 2\r\n---Fields\r\nedas_directory_id [old]: \r\nedas_directory_id [new]: 2\r\ncode [old]: \r\ncode [new]: EXP1_000002_3_2022\r\nname [old]: \r\nname [new]: EXP1/000002.3/2022 otro ejemplo de Expediente\r\nlocked [old]: \r\nlocked [new]: 0\r\nfiles [old]: \r\nfiles [new]: [{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_01ascwce.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_2n4gpeuf.docx\",\"usrNa\r\nowners [old]: \r\nowners [new]: 2,3\r\nreading_groups [old]: \r\nreading_groups [new]: 1,2\r\nwriting_groups [old]: \r\nwriting_groups [new]: 2\r\ncreationDate [old]: \r\ncreationDate [new]: 2022-11-28 12:53:37\r\nlastModificationDate [old]: \r\nlastModificationDate [new]: 2022-11-29 18:33:31\r\nuserCreation [old]: \r\nuserCreation [new]: admin\r\nuserLastModification [old]: \r\nuserLastModification [new]: user2\r\n'),
 (272,'2022-12-08 19:21:05','127.0.0.1','user2','edas_search_document','add','---Keys\r\nid_edas_directory : 0\r\n---Fields\r\nname [new]: /Home/Departament_1/Expedient_EXP1/EXP1_000002_3_2022\r\n');
/*!40000 ALTER TABLE `edas_audit` ENABLE KEYS */;


--
-- Definition of table `edas_directory`
--

DROP TABLE IF EXISTS `edas_directory`;
CREATE TABLE `edas_directory` (
  `id_edas_directory` int(11) NOT NULL AUTO_INCREMENT,
  `edas_parent_directory_id` int(11) DEFAULT NULL,
  `code` varchar(30) NOT NULL,
  `name` varchar(100) NOT NULL,
  `level` int(11) NOT NULL,
  `locked` varchar(1) NOT NULL DEFAULT '0',
  `owners` varchar(200) NOT NULL,
  `reading_groups` varchar(200) NOT NULL,
  `writing_groups` varchar(200) NOT NULL,
  `order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id_edas_directory`),
  KEY `fk_edas_directory_edas_directory_idx` (`edas_parent_directory_id`),
  CONSTRAINT `fk_edas_directory_edas_directory` FOREIGN KEY (`edas_parent_directory_id`) REFERENCES `edas_directory` (`id_edas_directory`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `edas_directory`
--

/*!40000 ALTER TABLE `edas_directory` DISABLE KEYS */;
INSERT INTO `edas_directory` (`id_edas_directory`,`edas_parent_directory_id`,`code`,`name`,`level`,`locked`,`owners`,`reading_groups`,`writing_groups`,`order`) VALUES 
 (0,NULL,'Home','Name Company ',1,'0','1','0','0',NULL),
 (1,0,'Departament_1','Estructure Departament 1 .',2,'0','1,2','1','1',NULL),
 (2,1,'Expedient_EXP1','Functional - Expedient EXP1',3,'0','2,3,4','1,2','2',NULL),
 (3,2,'Departament_1_Section_1','Section 1 Departament 1',4,'0','1','2','2',NULL),
 (4,1,'Expedient_EXP2','Functional - Expedient Exp2',3,'0','1','1,3','3',NULL),
 (8,0,'Departament_2','Estructura Departament 2',2,'0','1','0,4','4',NULL);
/*!40000 ALTER TABLE `edas_directory` ENABLE KEYS */;


--
-- Definition of table `edas_file`
--

DROP TABLE IF EXISTS `edas_file`;
CREATE TABLE `edas_file` (
  `id_edas_file` int(11) NOT NULL AUTO_INCREMENT,
  `edas_directory_id` int(11) NOT NULL,
  `code` varchar(30) NOT NULL,
  `name` varchar(100) NOT NULL,
  `locked` varchar(1) NOT NULL DEFAULT '0',
  `files` varchar(1000) NOT NULL,
  `owners` varchar(200) NOT NULL,
  `reading_groups` varchar(200) NOT NULL,
  `writing_groups` varchar(200) NOT NULL,
  `creationDate` datetime NOT NULL,
  `lastModificationDate` datetime NOT NULL,
  `userCreation` varchar(16) NOT NULL,
  `userLastModification` varchar(16) NOT NULL,
  PRIMARY KEY (`id_edas_file`),
  KEY `fk_edas_file_edas_directory1_idx` (`edas_directory_id`),
  CONSTRAINT `fk_edas_file_edas_directory1` FOREIGN KEY (`edas_directory_id`) REFERENCES `edas_directory` (`id_edas_directory`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `edas_file`
--

/*!40000 ALTER TABLE `edas_file` DISABLE KEYS */;
INSERT INTO `edas_file` (`id_edas_file`,`edas_directory_id`,`code`,`name`,`locked`,`files`,`owners`,`reading_groups`,`writing_groups`,`creationDate`,`lastModificationDate`,`userCreation`,`userLastModification`) VALUES 
 (1,2,'EXP1_000001_2_2022','Ejemplo de expediente','0','[{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_08qju77l.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/1\\/Lorem ipsum dolor sit amet_qsg5p13t.docx\",\"usrName\":\"Lorem ipsum dolor sit amet.docx\",\"size\":12822,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\"}]','3','1,2','2','2022-11-27 19:57:38','2022-11-27 20:02:46','user1','user1'),
 (2,2,'EXP1_000002_3_2022','EXP1/000002.3/2022 otro ejemplo de Expediente','0','[{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_01ascwce.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\",\"searchStr\":\"Lorem ipsum dolor sit amet.pdf,!Lorem ipsum dolor sit amet.docx,!:sStrEnd\"},{\"name\":\"files\\/2\\/Lorem ipsum dolor sit amet_2n4gpeuf.docx\",\"usrName\":\"Lorem ipsum dolor sit amet.docx\",\"size\":12822,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\"}]','2,3','1,2','2','2022-11-28 12:53:37','2022-11-29 18:33:31','admin','user2'),
 (5,2,'EXP1_000004_5_2022','EXP1/000004.5/2022 es un ejemplo','0','[{\"name\":\"files\\/5\\/Lorem ipsum dolor sit amet_6rmt1ap5.docx\",\"usrName\":\"Lorem ipsum dolor sit amet.docx\",\"size\":12822,\"type\":\"application\\/vnd.openxmlformats-officedocument.wordprocessingml.document\",\"searchStr\":\"Lorem ipsum dolor sit amet.docx,!Lorem ipsum dolor sit amet.pdf,!favicon-3x.png,!:sStrEnd\"},{\"name\":\"files\\/5\\/Lorem ipsum dolor sit amet_bcj2t3lb.pdf\",\"usrName\":\"Lorem ipsum dolor sit amet.pdf\",\"size\":284088,\"type\":\"application\\/pdf\"},{\"name\":\"files\\/5\\/favicon-3x_g31xa9nr.png\",\"usrName\":\"favicon-3x.png\",\"size\":45026,\"type\":\"image\\/png\"}]','1','1,2','2','2022-12-01 16:42:49','2022-12-01 16:42:49','admin','admin');
/*!40000 ALTER TABLE `edas_file` ENABLE KEYS */;


--
-- Definition of table `edas_group`
--

DROP TABLE IF EXISTS `edas_group`;
CREATE TABLE `edas_group` (
  `id_edas_group` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(30) NOT NULL,
  `name` varchar(100) NOT NULL,
  `active` varchar(1) NOT NULL DEFAULT '1',
  `deletionDate` datetime DEFAULT NULL,
  `userDeletion` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`id_edas_group`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `edas_group`
--

/*!40000 ALTER TABLE `edas_group` DISABLE KEYS */;
INSERT INTO `edas_group` (`id_edas_group`,`code`,`name`,`active`,`deletionDate`,`userDeletion`) VALUES 
 (0,'All','All Users','1',NULL,''),
 (1,'Departament 1','Organization by company structure','1',NULL,''),
 (2,'Expedient EXP1','Organization by topic','1',NULL,''),
 (3,'Expedient EXP2','Organization by topic','1',NULL,''),
 (4,'Departament 2','Organization (Departament 2)','1',NULL,'');
/*!40000 ALTER TABLE `edas_group` ENABLE KEYS */;


--
-- Definition of table `edas_settings`
--

DROP TABLE IF EXISTS `edas_settings`;
CREATE TABLE `edas_settings` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `TYPE` int(11) DEFAULT '1',
  `NAME` mediumtext,
  `USERNAME` mediumtext,
  `COOKIE` varchar(500) DEFAULT NULL,
  `SEARCH` mediumtext,
  `TABLENAME` varchar(300) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `edas_settings`
--

/*!40000 ALTER TABLE `edas_settings` DISABLE KEYS */;
INSERT INTO `edas_settings` (`ID`,`TYPE`,`NAME`,`USERNAME`,`COOKIE`,`SEARCH`,`TABLENAME`) VALUES 
 (1,2,NULL,NULL,'a50t8rra104mb0ws9wj35o7q','{\"gridWidth\":842.4,\"thWidths\":{\"grid_headcell_icons\":26.4,\"grid_headcell_checkbox\":12.399999999999999,\"grid_headcell_details\":35.4,\"grid_headcell_field\":32.4,\"grid_headcell_field1\":74.4,\"grid_headcell_field2\":74.4,\"grid_headcell_field3\":74.4,\"grid_headcell_field4\":30.4,\"grid_headcell_field5\":41.4,\"grid_headcell_field6\":121.4,\"grid_headcell_field7\":93.4,\"grid_headcell_field8\":89.4}}','edas_directory'),
 (2,4,NULL,NULL,'a50t8rra104mb0ws9wj35o7q','[\"id_edas_directory\",\"edas_parent_directory_id\",\"code\",\"name\",\"level\",\"locked\",\"owners\",\"reading_groups\",\"writing_groups\"]','edas_directory'),
 (3,2,NULL,NULL,'a50t8rra104mb0ws9wj35o7q','{\"gridWidth\":509.4,\"thWidths\":{\"grid_headcell_icons\":26.4,\"grid_headcell_checkbox\":18.4,\"grid_headcell_field\":10.399999999999999,\"grid_headcell_field1\":130.4,\"grid_headcell_field2\":266.4}}','edas_template_user'),
 (4,4,NULL,NULL,'a50t8rra104mb0ws9wj35o7q','[\"id_edas_template_user\",\"name\",\"belongingGroups\"]','edas_template_user'),
 (5,2,NULL,NULL,'a50t8rra104mb0ws9wj35o7q','{\"gridWidth\":891,\"thWidths\":{\"grid_headcell_field5\":881,\"grid_headcell_details\":15,\"grid_headcell_field\":100,\"grid_headcell_field1\":104,\"grid_headcell_field2\":121,\"grid_headcell_field3\":250,\"grid_headcell_field4\":241}}','edas_navigator_edas_nav_parent_list'),
 (6,2,NULL,NULL,'y1i7gd6n9dnaiudh6ce0l3xz','{\"gridWidth\":1199,\"thWidths\":{\"grid_headcell_icons\":27,\"grid_headcell_checkbox\":13,\"grid_headcell_field\":12,\"grid_headcell_field1\":98,\"grid_headcell_field2\":130,\"grid_headcell_field3\":292,\"grid_headcell_field4\":43,\"grid_headcell_field5\":83,\"grid_headcell_field6\":136,\"grid_headcell_field7\":82,\"grid_headcell_field8\":135,\"grid_headcell_field9\":27}}','edas_navigator_edas_file_list'),
 (7,2,NULL,NULL,'y1i7gd6n9dnaiudh6ce0l3xz','{\"gridWidth\":760,\"thWidths\":{\"grid_headcell_icons\":27,\"grid_headcell_checkbox\":13,\"grid_headcell_field\":15,\"grid_headcell_field1\":179,\"grid_headcell_field2\":422,\"grid_headcell_field3\":43}}','edas_navigator_edas_nav_directory_list'),
 (8,2,NULL,NULL,'y1i7gd6n9dnaiudh6ce0l3xz','{\"gridWidth\":768,\"thWidths\":{\"grid_headcell_icons\":27,\"grid_headcell_checkbox\":20,\"grid_headcell_field\":12,\"grid_headcell_field1\":130,\"grid_headcell_field2\":231,\"grid_headcell_field3\":235,\"grid_headcell_field4\":43}}','edas_navigator_edas_nav_file_list'),
 (9,2,NULL,NULL,'y1i7gd6n9dnaiudh6ce0l3xz','{\"gridWidth\":1079,\"thWidths\":{\"grid_headcell_field5\":1069,\"grid_headcell_details\":11,\"grid_headcell_field\":191,\"grid_headcell_field1\":313,\"grid_headcell_field2\":99,\"grid_headcell_field3\":206,\"grid_headcell_field4\":198}}','edas_navigator_edas_nav_parent_list'),
 (10,2,NULL,NULL,'lka43y1nlcfczd7ik2eck9fd','{\"gridWidth\":1142,\"thWidths\":{\"grid_headcell_icons\":27,\"grid_headcell_checkbox\":20,\"grid_headcell_field\":12,\"grid_headcell_field1\":131,\"grid_headcell_field2\":215,\"grid_headcell_field3\":624,\"grid_headcell_field4\":43}}','edas_navigator_edas_nav_file_list'),
 (11,2,NULL,NULL,'vbidjhirsuznec7ddfjx1l0l','{\"gridWidth\":1015,\"thWidths\":{\"grid_headcell_icons\":27,\"grid_headcell_checkbox\":20,\"grid_headcell_field\":12,\"grid_headcell_field1\":122,\"grid_headcell_field2\":229,\"grid_headcell_field3\":492,\"grid_headcell_field4\":43}}','edas_navigator_edas_nav_file_list'),
 (12,2,NULL,NULL,'vbidjhirsuznec7ddfjx1l0l','{\"gridWidth\":1118,\"thWidths\":{\"grid_headcell_field5\":1108,\"grid_headcell_details\":12,\"grid_headcell_field\":198,\"grid_headcell_field1\":325,\"grid_headcell_field2\":103,\"grid_headcell_field3\":214,\"grid_headcell_field4\":206}}','edas_navigator_edas_nav_parent_list'),
 (13,2,NULL,NULL,'vbidjhirsuznec7ddfjx1l0l','{\"gridWidth\":1218.4,\"thWidths\":{\"grid_headcell_icons\":26.4,\"grid_headcell_checkbox\":18.4,\"grid_headcell_field\":10.399999999999999,\"grid_headcell_field1\":148.4,\"grid_headcell_field2\":474.4,\"grid_headcell_field3\":36.4,\"grid_headcell_field4\":165.4,\"grid_headcell_field5\":246.4}}','edas_group'),
 (14,2,NULL,'admin',NULL,'{\"gridWidth\":729.4,\"thWidths\":{\"grid_headcell_icons\":26.4,\"grid_headcell_checkbox\":18.4,\"grid_headcell_field\":10.399999999999999,\"grid_headcell_field1\":241.4,\"grid_headcell_field2\":375.4}}','edas_template_user'),
 (15,2,NULL,'admin',NULL,'{\"gridWidth\":1036.4,\"thWidths\":{\"grid_headcell_icons\":26.4,\"grid_headcell_checkbox\":18.4,\"grid_headcell_field\":10.399999999999999,\"grid_headcell_field1\":51.4,\"grid_headcell_field2\":56.4,\"grid_headcell_field3\":109.4,\"grid_headcell_field4\":217.4,\"grid_headcell_field5\":36.4,\"grid_headcell_field6\":405.4}}','edas_user'),
 (16,2,NULL,'admin',NULL,'{\"gridWidth\":1218.4,\"thWidths\":{\"grid_headcell_icons\":26.4,\"grid_headcell_checkbox\":18.4,\"grid_headcell_field\":10.399999999999999,\"grid_headcell_field1\":148.4,\"grid_headcell_field2\":474.4,\"grid_headcell_field3\":36.4,\"grid_headcell_field4\":165.4,\"grid_headcell_field5\":246.4}}','edas_group'),
 (17,2,NULL,'admin',NULL,'{\"gridWidth\":1231.4,\"thWidths\":{\"grid_headcell_icons\":26.4,\"grid_headcell_checkbox\":12.399999999999999,\"grid_headcell_field\":10.399999999999999,\"grid_headcell_field1\":88.4,\"grid_headcell_field2\":118.4,\"grid_headcell_field3\":114.4,\"grid_headcell_field4\":41.4,\"grid_headcell_field5\":215.4,\"grid_headcell_field6\":127.4,\"grid_headcell_field7\":217.4,\"grid_headcell_field8\":131.4}}','edas_file'),
 (18,2,NULL,'admin',NULL,'{\"gridWidth\":1258.4,\"thWidths\":{\"grid_headcell_icons\":26.4,\"grid_headcell_checkbox\":18.4,\"grid_headcell_details\":35.4,\"grid_headcell_field\":14.399999999999999,\"grid_headcell_field1\":99.4,\"grid_headcell_field2\":144.4,\"grid_headcell_field3\":304.4,\"grid_headcell_field4\":30.4,\"grid_headcell_field5\":41.4,\"grid_headcell_field6\":98.4,\"grid_headcell_field7\":154.4,\"grid_headcell_field8\":152.4}}','edas_directory');
/*!40000 ALTER TABLE `edas_settings` ENABLE KEYS */;


--
-- Definition of table `edas_template_user`
--

DROP TABLE IF EXISTS `edas_template_user`;
CREATE TABLE `edas_template_user` (
  `id_edas_template_user` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `belongingGroups` varchar(200) NOT NULL,
  PRIMARY KEY (`id_edas_template_user`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `edas_template_user`
--

/*!40000 ALTER TABLE `edas_template_user` DISABLE KEYS */;
INSERT INTO `edas_template_user` (`id_edas_template_user`,`name`,`belongingGroups`) VALUES 
 (1,'Users expedient EXP1','1,2,0'),
 (2,'General','0'),
 (3,'Users expedient EXP2','0,1,3');
/*!40000 ALTER TABLE `edas_template_user` ENABLE KEYS */;


--
-- Definition of table `edas_user`
--

DROP TABLE IF EXISTS `edas_user`;
CREATE TABLE `edas_user` (
  `id_edas_user` int(11) NOT NULL AUTO_INCREMENT,
  `login` varchar(16) NOT NULL,
  `password` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `active` varchar(1) NOT NULL,
  `edas_template_user_id` varchar(200) NOT NULL,
  `belongingGroups` varchar(200) DEFAULT NULL,
  `deletionDate` datetime DEFAULT NULL,
  `userDeletion` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`id_edas_user`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `edas_user`
--

/*!40000 ALTER TABLE `edas_user` DISABLE KEYS */;
INSERT INTO `edas_user` (`id_edas_user`,`login`,`password`,`name`,`email`,`active`,`edas_template_user_id`,`belongingGroups`,`deletionDate`,`userDeletion`) VALUES 
 (1,'admin','admin','Administrator','info@fhumanes.com','1','2,1,3','0,1,2,3',NULL,''),
 (2,'humanes','humanes','Fernando Humanes','fernandohumanes@gmail.com','1','1','0,1,2',NULL,''),
 (3,'user1','user1','User 1','user1@humanes.com','1','1','0,1,2','2022-11-28 19:16:23','admin'),
 (4,'user2','user2','User 2','user2@fhumanes.com','1','3','0,1,3','2022-11-28 20:41:27','admin');
/*!40000 ALTER TABLE `edas_user` ENABLE KEYS */;


--
-- Definition of table `edasuggroups`
--

DROP TABLE IF EXISTS `edasuggroups`;
CREATE TABLE `edasuggroups` (
  `GroupID` int(11) NOT NULL AUTO_INCREMENT,
  `Label` varchar(300) DEFAULT NULL,
  `Provider` varchar(10) NOT NULL DEFAULT '',
  `Comment` mediumtext,
  PRIMARY KEY (`GroupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `edasuggroups`
--

/*!40000 ALTER TABLE `edasuggroups` DISABLE KEYS */;
/*!40000 ALTER TABLE `edasuggroups` ENABLE KEYS */;


--
-- Definition of table `edasugmembers`
--

DROP TABLE IF EXISTS `edasugmembers`;
CREATE TABLE `edasugmembers` (
  `UserName` varchar(255) NOT NULL,
  `GroupID` int(11) NOT NULL,
  `Provider` varchar(10) NOT NULL DEFAULT '',
  PRIMARY KEY (`UserName`(50),`GroupID`,`Provider`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `edasugmembers`
--

/*!40000 ALTER TABLE `edasugmembers` DISABLE KEYS */;
INSERT INTO `edasugmembers` (`UserName`,`GroupID`,`Provider`) VALUES 
 ('admin',-1,'');
/*!40000 ALTER TABLE `edasugmembers` ENABLE KEYS */;


--
-- Definition of table `edasugrights`
--

DROP TABLE IF EXISTS `edasugrights`;
CREATE TABLE `edasugrights` (
  `TableName` varchar(255) NOT NULL,
  `GroupID` int(11) NOT NULL,
  `AccessMask` varchar(10) DEFAULT NULL,
  `Page` mediumtext,
  PRIMARY KEY (`TableName`(50),`GroupID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `edasugrights`
--

/*!40000 ALTER TABLE `edasugrights` DISABLE KEYS */;
INSERT INTO `edasugrights` (`TableName`,`GroupID`,`AccessMask`,`Page`) VALUES 
 ('edas_directory',-1,'ADESPIM',NULL),
 ('edas_dir_files',-2,'AEDSP',''),
 ('edas_dir_files',-1,'AEDSP',''),
 ('edas_file',-1,'ADESPIM',NULL),
 ('edas_group',-1,'ADESPIM',NULL),
 ('edas_navigator',-2,'S',''),
 ('edas_navigator',-1,'ADESPIM',NULL),
 ('edas_nav_directory',-2,'AEDS',''),
 ('edas_nav_directory',-1,'ADESPIM',NULL),
 ('edas_nav_file',-2,'AEDS',''),
 ('edas_nav_file',-1,'ADESPIM',NULL),
 ('edas_nav_parent',-2,'S',''),
 ('edas_nav_parent',-1,'ADESPIM',NULL),
 ('edas_search_document',-2,'A',''),
 ('edas_search_document',-1,'A',''),
 ('edas_template_user',-1,'ADESPIM',NULL),
 ('edas_user',-1,'ADESPIM',NULL);
/*!40000 ALTER TABLE `edasugrights` ENABLE KEYS */;




/*!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 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
