
--
-- Table structure for table `oc_migrations`
--

CREATE TABLE `oc_migrations` (
  `app` varchar(177) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `version` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  PRIMARY KEY (`app`,`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_migrations`
--

INSERT INTO `oc_migrations` VALUES ('activity','20161122085340'),('activity','20161122092159'),('activity','20170131134507'),('activity','20170724182159'),('activity','20181019151118'),('activity','20181022150134'),('core','20170101010100'),('core','20170101215145'),('core','20170111103310'),('core','20170213215145'),('core','20170214112458'),('core','20170221114437'),('core','20170221121536'),('core','20170315173825'),('core','20170320173955'),('core','20170418154659'),('core','20170516100103'),('core','20170526104128'),('core','20170605143658'),('core','20170711191432'),('core','20170804201253'),('core','20170928120000'),('core','20171026130750'),('core','20180123131835'),('core','20180302155233'),('core','20180319102121'),('core','20180607072706'),('core','20181017105216'),('core','20181017120818'),('core','20181113071753'),('core','20181220085457'),('core','20190125162909'),('core','20200610110817'),('core','20210928123126'),('core','20230105001100'),('core','20230120101715'),('core','20230210073645'),('core','20230210103154'),('core','20240112140951'),('core','20240131080456'),('dav','20170116150538'),('dav','20170116170538'),('dav','20170202213905'),('dav','20170202220512'),('dav','20170427182800'),('dav','20170519091921'),('dav','20170526100342'),('dav','20170711193427'),('dav','20170927201245'),('dav','20180622095921'),('dav','20181115210344'),('dav','20190823065724'),('dav','20200114181454'),('dav','20200427142541'),('dav','20210714123001'),('federatedfilesharing','20170804201125'),('federatedfilesharing','20170804201253'),('federatedfilesharing','20190410160725'),('files_external','20170814051424'),('files_external','20210511082903'),('files_external','20220329110116'),('files_sharing','20170804201125'),('files_sharing','20170804201253'),('files_sharing','20170830112305'),('files_sharing','20171115154900'),('files_sharing','20171215103657'),('files_sharing','20190426123324'),('files_sharing','20200504211654'),('files_sharing','20200823121322'),('files_trashbin','20170804201125'),('files_trashbin','20170804201253'),('notifications','20170801085340'),('notifications','20170801152524'),('notifications','20180119080933'),('notifications','20180604132522');

--
-- Table structure for table `oc_mimetypes`
--

CREATE TABLE `oc_mimetypes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `mimetype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mimetype_id_index` (`mimetype`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `oc_mimetypes`
--

INSERT INTO `oc_mimetypes` VALUES (3,'application'),(68,'application/illustrator'),(39,'application/javascript'),(40,'application/json'),(15,'application/msword'),(11,'application/octet-stream'),(7,'application/pdf'),(64,'application/postscript'),(20,'application/vnd.ms-excel'),(45,'application/vnd.ms-excel.sheet.macroEnabled.12'),(50,'application/vnd.ms-powerpoint'),(57,'application/vnd.ms-powerpoint.presentation.macroEnabled.12'),(51,'application/vnd.ms-powerpoint.slideshow.macroEnabled.12'),(58,'application/vnd.ms-word.document.macroEnabled.12'),(32,'application/vnd.oasis.opendocument.graphics'),(56,'application/vnd.oasis.opendocument.presentation'),(28,'application/vnd.oasis.opendocument.spreadsheet'),(4,'application/vnd.oasis.opendocument.text'),(18,'application/vnd.openxmlformats-officedocument.presentationml.presentation'),(12,'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'),(70,'application/vnd.openxmlformats-officedocument.spreadsheetml.template'),(10,'application/vnd.openxmlformats-officedocument.wordprocessingml.document'),(69,'application/vnd.openxmlformats-officedocument.wordprocessingml.template'),(62,'application/vnd.visio'),(17,'application/x-7z-compressed'),(35,'application/x-ms-dos-executable'),(36,'application/x-msdos-program'),(33,'application/x-msi'),(60,'application/x-photoshop'),(49,'application/x-rar-compressed'),(16,'application/x-tar'),(38,'application/xml'),(19,'application/zip'),(13,'audio'),(14,'audio/mp4'),(22,'audio/mpegurl'),(1,'httpd'),(2,'httpd/unix-directory'),(5,'image'),(61,'image/bmp'),(54,'image/gif'),(66,'image/heic'),(6,'image/jpeg'),(8,'image/png'),(65,'image/svg+xml'),(43,'image/tiff'),(42,'image/x-dcraw'),(46,'message'),(47,'message/rfc822'),(21,'text'),(53,'text/css'),(44,'text/csv'),(37,'text/html'),(24,'text/plain'),(52,'text/rtf'),(55,'text/vcard'),(26,'video'),(27,'video/mp4'),(67,'video/quicktime'),(48,'video/x-msvideo');

--
-- Table structure for table `oc_mounts`
--

CREATE TABLE `oc_mounts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `storage_id` int NOT NULL,
  `root_id` bigint NOT NULL,
  `user_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `mount_point` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mounts_user_root_index` (`user_id`,`root_id`),
  KEY `mounts_user_index` (`user_id`),
  KEY `mounts_storage_index` (`storage_id`),
  KEY `mounts_root_index` (`root_id`)
) ENGINE=InnoDB AUTO_INCREMENT=185 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `oc_mounts`
--

INSERT INTO `oc_mounts` VALUES (1,1,1,'ucr','/ucr/'),(3,1,107,'Mauricio Solano','/Mauricio Solano/files/documentos administrativos/'),(4,8,108,'Maria Vinas','/Maria Vinas/'),(7,5,192,'Andrea Irias','/Andrea Irias/'),(8,6,98,'Alvaro Azofeifa','/Alvaro Azofeifa/files/Consejos científicos/'),(9,6,98,'Luis Gomez','/Luis Gomez/files/Consejos científicos/'),(10,6,98,'Victor Jimenez','/Victor Jimenez/files/Consejos científicos/'),(11,4,284,'Alvaro Azofeifa','/Alvaro Azofeifa/'),(12,9,352,'Mauricio Solano','/Mauricio Solano/'),(17,10,1313,'Victor Jimenez','/Victor Jimenez/'),(19,13,1355,'Melissa Barquero','/Melissa Barquero/'),(20,1,1430,'Erika Villalobos','/Erika Villalobos/files/Documentos SG-COMPUTO/'),(21,1,1455,'Erika Villalobos','/Erika Villalobos/files/Videos Seguimiento SG-CIGRAS/'),(25,16,1526,'Erika Villalobos','/Erika Villalobos/'),(29,17,3655,'Kelvin Arce','/Kelvin Arce/'),(40,30,4341,'Veronica Campos','/Veronica Campos/'),(41,29,4351,'Stefanny Campos','/Stefanny Campos/'),(42,27,4423,'Isabel Sanabria','/Isabel Sanabria/'),(45,6,4306,'Victor Jimenez','/Victor Jimenez/files/RC-AG-59/'),(46,6,1517,'Victor Jimenez','/Victor Jimenez/files/SG/'),(53,6,4306,'Guillermo Vargas','/Guillermo Vargas/files/RC-AG-59/'),(54,26,4480,'Guillermo Vargas','/Guillermo Vargas/'),(55,6,4306,'Alvaro Azofeifa','/Alvaro Azofeifa/files/RC-AG-59/'),(56,6,4306,'Andrea Holst','/Andrea Holst/files/RC-AG-59/'),(58,6,4306,'Diego Bogantes','/Diego Bogantes/files/RC-AG-59/'),(59,6,1517,'Diego Bogantes','/Diego Bogantes/files/SG/'),(67,6,1517,'Nancy','/Nancy/files/SG/'),(71,23,4534,'Ester Vargas','/Ester Vargas/'),(72,21,4608,'Andres Monge','/Andres Monge/'),(73,25,4706,'Guillermo Solano','/Guillermo Solano/'),(74,28,4744,'Paula Carvajal','/Paula Carvajal/'),(76,22,4909,'Eduardo Fernandez','/Eduardo Fernandez/'),(77,19,4940,'Nancy','/Nancy/'),(80,18,6434,'Rosa Mora','/Rosa Mora/'),(82,30,6904,'Andres Monge','/Andres Monge/files/LS/'),(83,30,6904,'Guillermo Solano','/Guillermo Solano/files/LS/'),(86,30,11659,'Maria Vinas','/Maria Vinas/files/FOTOS CIGRAS/'),(88,30,11659,'Mauricio Solano','/Mauricio Solano/files/FOTOS CIGRAS/'),(89,32,78677,'sebastian.camacho','/sebastian.camacho/'),(90,33,78693,'marcelomurilloq','/marcelomurilloq/'),(92,6,1517,'marcelomurilloq','/marcelomurilloq/files/SG/'),(93,34,79106,'Guido Perez','/Guido Perez/'),(96,30,11663,'Guido Perez','/Guido Perez/files/25 julio 2018/'),(98,30,80279,'Guido Perez','/Guido Perez/files/FOTOS GRANOS/'),(99,30,80279,'Eduardo Fernandez','/Eduardo Fernandez/files/FOTOS GRANOS/'),(100,30,80279,'Stefanny Campos','/Stefanny Campos/files/FOTOS GRANOS/'),(101,30,80744,'Ester Vargas','/Ester Vargas/files/SOYA TZ/'),(102,30,80744,'Andres Monge','/Andres Monge/files/SOYA TZ/'),(103,30,80744,'Guillermo Solano','/Guillermo Solano/files/SOYA TZ/'),(104,17,80886,'Stefanny Campos','/Stefanny Campos/files/Fotos Banner Servicios LM/'),(106,30,11659,'Kelvin Arce','/Kelvin Arce/files/FOTOS CIGRAS/'),(107,30,11659,'sebastian.camacho','/sebastian.camacho/files/FOTOS CIGRAS/'),(110,6,4340,'Ester Vargas','/Ester Vargas/files/RC-AG-59 Control de personal autorizado V12 c-21-003.ods/'),(115,6,4340,'Isabel Sanabria','/Isabel Sanabria/files/RC-AG-59 Control de personal autorizado V12 c-21-003.ods/'),(116,6,4340,'Alvaro Azofeifa','/Alvaro Azofeifa/files/RC-AG-59 Control de personal autorizado V12 c-21-003.ods/'),(117,6,4340,'Andrea Holst','/Andrea Holst/files/RC-AG-59 Control de personal autorizado V12 c-21-003.ods/'),(119,6,4340,'Diego Bogantes','/Diego Bogantes/files/RC-AG-59 Control de personal autorizado V12 c-21-003.ods/'),(120,6,4340,'Guillermo Vargas','/Guillermo Vargas/files/RC-AG-59 Control de personal autorizado V12 c-21-003.ods/'),(121,6,4340,'Victor Jimenez','/Victor Jimenez/files/RC-AG-59 Control de personal autorizado V12 c-21-003.ods/'),(122,30,86441,'Erika Villalobos','/Erika Villalobos/files/INFORMES/'),(132,30,87551,'Rosa Mora','/Rosa Mora/files/INFORMES LS/'),(133,30,87551,'Erika Villalobos','/Erika Villalobos/files/INFORMES LS/'),(136,30,87551,'Guillermo Solano','/Guillermo Solano/files/INFORMES LS/'),(137,35,90169,'Catalina Acuna','/Catalina Acuna/'),(141,39,90885,'Veronica Campos','/Veronica Campos/uploads/'),(143,42,90966,'Kelvin Arce','/Kelvin Arce/uploads/'),(144,36,91004,'ucr','/ucr/uploads/'),(145,44,90965,'Erika Villalobos','/Erika Villalobos/uploads/'),(146,46,90964,'Andrea Irias','/Andrea Irias/uploads/'),(147,63,90990,'Victor Jimenez','/Victor Jimenez/uploads/'),(148,38,90989,'Luis Barboza','/Luis Barboza/uploads/'),(149,65,91042,'Luis Barboza','/Luis Barboza/'),(152,65,91170,'Melissa Barquero','/Melissa Barquero/files/Consejos científicos (2)/'),(153,65,91058,'Melissa Barquero','/Melissa Barquero/files/Consejos asesores/'),(154,65,94458,'Erika Villalobos','/Erika Villalobos/files/SG/'),(155,65,94457,'Erika Villalobos','/Erika Villalobos/files/RC-AG-59/'),(156,65,94458,'Eduardo Fernandez','/Eduardo Fernandez/files/SG/'),(157,65,94458,'Catalina Acuna','/Catalina Acuna/files/SG/'),(158,65,94458,'Kelvin Arce','/Kelvin Arce/files/SG/'),(159,65,94458,'Melissa Barquero','/Melissa Barquero/files/SG/'),(160,65,94458,'Rosa Mora','/Rosa Mora/files/SG/'),(161,65,94458,'Veronica Campos','/Veronica Campos/files/SG/'),(162,65,94458,'Guillermo Solano','/Guillermo Solano/files/SG/'),(163,65,94458,'Andrea Irias','/Andrea Irias/files/SG/'),(164,65,94458,'Guido Perez','/Guido Perez/files/SG/'),(165,65,94457,'Catalina Acuna','/Catalina Acuna/files/RC-AG-59/'),(166,65,94457,'Andrea Irias','/Andrea Irias/files/RC-AG-59/'),(167,65,91058,'Maria Vinas','/Maria Vinas/files/Consejos asesores/'),(168,65,91170,'Maria Vinas','/Maria Vinas/files/Consejos científicos/'),(169,65,94458,'Maria Vinas','/Maria Vinas/files/SG/'),(170,65,94457,'Maria Vinas','/Maria Vinas/files/RC-AG-59/'),(171,65,91058,'Mauricio Solano','/Mauricio Solano/files/Consejos asesores/'),(172,65,91170,'Mauricio Solano','/Mauricio Solano/files/Consejos científicos/'),(173,65,94453,'Mauricio Solano','/Mauricio Solano/files/Documentos administrativos CIGRAS/'),(174,65,94458,'Mauricio Solano','/Mauricio Solano/files/SG/'),(175,65,94457,'Mauricio Solano','/Mauricio Solano/files/RC-AG-59/'),(176,30,101504,'Luis Barboza','/Luis Barboza/files/NORMAS/'),(177,65,94458,'Andres Monge','/Andres Monge/files/SG/'),(178,65,94457,'Andres Monge','/Andres Monge/files/RC-AG-59/'),(179,65,94457,'Veronica Campos','/Veronica Campos/files/RC-AG-59/'),(180,65,94457,'Guillermo Solano','/Guillermo Solano/files/RC-AG-59/'),(181,65,94457,'Guido Perez','/Guido Perez/files/RC-AG-59/'),(182,65,94457,'Kelvin Arce','/Kelvin Arce/files/RC-AG-59/'),(183,65,94457,'Eduardo Fernandez','/Eduardo Fernandez/files/RC-AG-59/'),(184,48,103332,'Maria Vinas','/Maria Vinas/uploads/');

--
-- Table structure for table `oc_notifications`
--

CREATE TABLE `oc_notifications` (
  `notification_id` int NOT NULL AUTO_INCREMENT,
  `app` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `user` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `timestamp` int NOT NULL DEFAULT '0',
  `object_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `object_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `subject` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `subject_parameters` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `message` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `message_parameters` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `link` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `actions` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `icon` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`notification_id`),
  KEY `IDX_16B80748C96E70CF` (`app`),
  KEY `IDX_16B807488D93D649` (`user`),
  KEY `IDX_16B80748A5D6E63E` (`timestamp`),
  KEY `IDX_16B8074811CB6B3A232D562B` (`object_type`,`object_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `oc_notifications`
--

INSERT INTO `oc_notifications` VALUES (2,'updatenotification','ucr',1618865312,'core','10.3.2','update_available','[]','','[]','http://localhost/index.php/settings/admin#updater','[]','');

--
-- Table structure for table `oc_persistent_locks`
--

CREATE TABLE `oc_persistent_locks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `file_id` bigint NOT NULL COMMENT 'FK to fileid in table oc_file_cache',
  `owner_account_id` bigint unsigned DEFAULT NULL COMMENT 'owner of the lock - FK to account table',
  `owner` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'owner of the lock - just a human readable string',
  `timeout` int unsigned NOT NULL COMMENT 'timestamp when the lock expires',
  `created_at` int unsigned NOT NULL COMMENT 'timestamp when the lock was created',
  `token` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'uuid for webdav locks - 1024 random chars for WOPI locks',
  `token_hash` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'md5(token)',
  `scope` smallint NOT NULL COMMENT '1 - exclusive, 2 - shared',
  `depth` smallint NOT NULL COMMENT '0, 1 or infinite',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_F0C3D55BB3BC57DA` (`token_hash`),
  KEY `IDX_F0C3D55B93CB796C` (`file_id`),
  KEY `IDX_F0C3D55BC901C6FF` (`owner_account_id`),
  CONSTRAINT `FK_F0C3D55B93CB796C` FOREIGN KEY (`file_id`) REFERENCES `oc_filecache` (`fileid`) ON DELETE CASCADE,
  CONSTRAINT `FK_F0C3D55BC901C6FF` FOREIGN KEY (`owner_account_id`) REFERENCES `oc_accounts` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `oc_persistent_locks`
--


--
-- Table structure for table `oc_preferences`
--

CREATE TABLE `oc_preferences` (
  `userid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `appid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `configkey` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `configvalue` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  PRIMARY KEY (`userid`,`appid`,`configkey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `oc_preferences`
--

INSERT INTO `oc_preferences` VALUES ('Alvaro Azofeifa','core','lang','en'),('Alvaro Azofeifa','core','timezone','America/Guatemala'),('Alvaro Azofeifa','firstrunwizard','show','0'),('Andrea Irias','core','lang','es'),('Andrea Irias','core','timezone','America/Guatemala'),('Andrea Irias','firstrunwizard','show','0'),('Andres Monge','core','lang','pt_BR'),('Andres Monge','core','timezone','America/Guatemala'),('Andres Monge','firstrunwizard','show','0'),('Catalina Acuna','core','lang','es_ES'),('Catalina Acuna','core','timezone','America/Guatemala'),('Catalina Acuna','firstrunwizard','show','0'),('Eduardo Fernandez','core','lang','es'),('Eduardo Fernandez','core','timezone','America/Guatemala'),('Eduardo Fernandez','files','file_sorting','mtime'),('Eduardo Fernandez','files','file_sorting_direction','desc'),('Eduardo Fernandez','firstrunwizard','show','0'),('Erika Villalobos','core','lang','es_AR'),('Erika Villalobos','core','timezone','America/Guatemala'),('Erika Villalobos','files','file_sorting','name'),('Erika Villalobos','files','file_sorting_direction','asc'),('Erika Villalobos','firstrunwizard','show','0'),('Ester Vargas','core','lang','es'),('Ester Vargas','core','timezone','America/Guatemala'),('Ester Vargas','files','file_sorting','name'),('Ester Vargas','files','file_sorting_direction','asc'),('Ester Vargas','firstrunwizard','show','0'),('Guido Perez','core','lang','es'),('Guido Perez','core','timezone','America/Guatemala'),('Guido Perez','firstrunwizard','show','0'),('Guillermo Solano','core','lang','es'),('Guillermo Solano','core','timezone','America/Guatemala'),('Guillermo Solano','firstrunwizard','show','0'),('Guillermo Vargas','core','lang','es'),('Guillermo Vargas','core','timezone','America/Guatemala'),('Guillermo Vargas','firstrunwizard','show','0'),('Isabel Sanabria','core','lang','es'),('Isabel Sanabria','core','timezone','America/Guatemala'),('Isabel Sanabria','firstrunwizard','show','0'),('Kelvin Arce','core','lang','es'),('Kelvin Arce','core','timezone','America/Guatemala'),('Kelvin Arce','files','file_sorting','name'),('Kelvin Arce','files','file_sorting_direction','asc'),('Kelvin Arce','firstrunwizard','show','0'),('Luis Barboza','core','lang','es_419'),('Luis Barboza','core','timezone','America/Guatemala'),('Luis Barboza','files','quota','none'),('Luis Barboza','firstrunwizard','show','0'),('Maria Vinas','core','lang','en'),('Maria Vinas','core','timezone','America/Guatemala'),('Maria Vinas','firstrunwizard','show','0'),('Mauricio Solano','core','lang','es'),('Mauricio Solano','core','timezone','America/Guatemala'),('Mauricio Solano','files','file_sorting','name'),('Mauricio Solano','files','file_sorting_direction','asc'),('Mauricio Solano','firstrunwizard','show','0'),('Melissa Barquero','core','lang','es'),('Melissa Barquero','core','timezone','America/Guatemala'),('Melissa Barquero','files','file_sorting','name'),('Melissa Barquero','files','file_sorting_direction','asc'),('Melissa Barquero','firstrunwizard','show','0'),('Nancy','core','lang','es'),('Nancy','core','timezone','America/Guatemala'),('Nancy','firstrunwizard','show','0'),('Rosa Mora','core','lang','es'),('Rosa Mora','core','timezone','America/Guatemala'),('Rosa Mora','firstrunwizard','show','0'),('Stefanny Campos','core','lang','es'),('Stefanny Campos','core','timezone','America/Guatemala'),('Stefanny Campos','firstrunwizard','show','0'),('Veronica Campos','core','lang','es'),('Veronica Campos','core','timezone','America/Guatemala'),('Veronica Campos','files','file_sorting','name'),('Veronica Campos','files','file_sorting_direction','asc'),('Veronica Campos','firstrunwizard','show','0'),('Victor Jimenez','core','lang','en'),('Victor Jimenez','core','timezone','America/Guatemala'),('Victor Jimenez','firstrunwizard','show','0'),('marcelomurilloq','core','lang','en'),('marcelomurilloq','core','timezone','America/Guatemala'),('marcelomurilloq','firstrunwizard','show','0'),('sebastian.camacho','core','lang','es'),('sebastian.camacho','core','timezone','America/Guatemala'),('sebastian.camacho','firstrunwizard','show','0'),('ucr','core','lang','es'),('ucr','core','timezone','America/Guatemala'),('ucr','files','file_sorting','name'),('ucr','files','file_sorting_direction','desc'),('ucr','files','show_hidden','1'),('ucr','firstrunwizard','show','0');

--
-- Table structure for table `oc_privatedata`
--

CREATE TABLE `oc_privatedata` (
  `keyid` int unsigned NOT NULL AUTO_INCREMENT,
  `user` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `app` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`keyid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `oc_privatedata`
--


--
-- Table structure for table `oc_properties`
--

CREATE TABLE `oc_properties` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `fileid` bigint unsigned NOT NULL,
  `propertyname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `propertyvalue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `propertytype` smallint NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `fileid_index` (`fileid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `oc_properties`
--


--
-- Table structure for table `oc_schedulingobjects`
--

CREATE TABLE `oc_schedulingobjects` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `principaluri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `calendardata` longblob,
  `uri` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `lastmodified` int unsigned DEFAULT NULL,
  `etag` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `size` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `oc_schedulingobjects`
--


--
-- Table structure for table `oc_share`
--

CREATE TABLE `oc_share` (
  `id` int NOT NULL AUTO_INCREMENT,
  `share_type` smallint NOT NULL DEFAULT '0',
  `share_with` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `uid_owner` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `uid_initiator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `parent` int DEFAULT NULL,
  `item_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `item_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `item_target` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `file_source` bigint DEFAULT NULL,
  `file_target` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `permissions` smallint NOT NULL DEFAULT '0',
  `stime` bigint NOT NULL DEFAULT '0',
  `accepted` smallint NOT NULL DEFAULT '0',
  `expiration` datetime DEFAULT NULL,
  `token` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `mail_send` smallint NOT NULL DEFAULT '0',
  `share_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `attributes` longtext COLLATE utf8mb4_bin,
  PRIMARY KEY (`id`),
  KEY `item_share_type_index` (`item_type`,`share_type`),
  KEY `file_source_index` (`file_source`),
  KEY `token_index` (`token`),
  KEY `share_with_index` (`share_with`),
  KEY `item_source_index` (`item_source`),
  KEY `item_source_type_index` (`item_source`,`share_type`,`item_type`)
) ENGINE=InnoDB AUTO_INCREMENT=158 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `oc_share`
--

INSERT INTO `oc_share` VALUES (1,0,'Mauricio Solano','ucr','ucr',NULL,'folder','107',NULL,107,'/documentos administrativos',31,1619040818,0,NULL,NULL,0,NULL,NULL),(16,0,'Erika Villalobos','ucr','ucr',NULL,'folder','1430',NULL,1430,'/Documentos SG-COMPUTO',23,1626993824,0,NULL,NULL,0,NULL,NULL),(17,0,'Erika Villalobos','ucr','ucr',NULL,'folder','1455',NULL,1455,'/Videos Seguimiento SG-CIGRAS',23,1627057970,0,NULL,NULL,0,NULL,NULL),(62,0,'Ester Vargas','Veronica Campos','Veronica Campos',NULL,'folder','6904',NULL,6904,'/LS',31,1637857118,2,NULL,NULL,0,NULL,NULL),(63,0,'Guillermo Solano','Veronica Campos','Veronica Campos',NULL,'folder','6904',NULL,6904,'/LS',7,1637857127,0,NULL,NULL,0,NULL,NULL),(64,0,'Andres Monge','Veronica Campos','Veronica Campos',NULL,'folder','6904',NULL,6904,'/LS',7,1637857132,0,NULL,NULL,0,NULL,NULL),(66,0,'Maria Vinas','Veronica Campos','Veronica Campos',NULL,'folder','11659',NULL,11659,'/FOTOS CIGRAS',23,1650563236,0,NULL,NULL,0,NULL,NULL),(67,0,'Melissa Barquero','Veronica Campos','Veronica Campos',NULL,'folder','11659',NULL,11659,'/FOTOS CIGRAS',23,1650563243,2,NULL,NULL,0,NULL,NULL),(69,0,'Mauricio Solano','Veronica Campos','Veronica Campos',NULL,'folder','11659',NULL,11659,'/FOTOS CIGRAS',23,1650563252,0,NULL,NULL,0,NULL,NULL),(75,0,'Guido Perez','Veronica Campos','Veronica Campos',NULL,'folder','11663',NULL,11663,'/25 julio 2018',31,1657905589,0,NULL,NULL,0,NULL,NULL),(77,0,'Stefanny Campos','Veronica Campos','Veronica Campos',NULL,'folder','80279',NULL,80279,'/FOTOS GRANOS',23,1659037111,0,NULL,NULL,0,NULL,NULL),(78,0,'Guido Perez','Veronica Campos','Veronica Campos',NULL,'folder','80279',NULL,80279,'/FOTOS GRANOS',23,1659037115,0,NULL,NULL,0,NULL,NULL),(79,0,'Eduardo Fernandez','Veronica Campos','Veronica Campos',NULL,'folder','80279',NULL,80279,'/FOTOS GRANOS',23,1659037120,0,NULL,NULL,0,NULL,NULL),(80,0,'Ester Vargas','Veronica Campos','Veronica Campos',NULL,'folder','80744',NULL,80744,'/SOYA TZ',23,1660255832,0,NULL,NULL,0,NULL,NULL),(81,0,'Guillermo Solano','Veronica Campos','Veronica Campos',NULL,'folder','80744',NULL,80744,'/SOYA TZ',23,1660255838,0,NULL,NULL,0,NULL,NULL),(82,0,'Andres Monge','Veronica Campos','Veronica Campos',NULL,'folder','80744',NULL,80744,'/SOYA TZ',23,1660255844,0,NULL,NULL,0,NULL,NULL),(83,0,'Stefanny Campos','Kelvin Arce','Kelvin Arce',NULL,'folder','80886',NULL,80886,'/Fotos Banner Servicios LM',31,1661270630,0,NULL,NULL,0,NULL,NULL),(84,0,'Melissa Barquero','Veronica Campos','Veronica Campos',NULL,'folder','80279',NULL,80279,'/FOTOS GRANOS',31,1662663623,2,NULL,NULL,0,NULL,NULL),(85,0,'Kelvin Arce','Veronica Campos','Veronica Campos',NULL,'folder','11659',NULL,11659,'/FOTOS CIGRAS',31,1663969855,0,NULL,NULL,0,NULL,NULL),(86,0,'sebastian.camacho','Veronica Campos','Kelvin Arce',NULL,'folder','11659',NULL,11659,'/FOTOS CIGRAS',31,1664208541,0,NULL,NULL,0,NULL,NULL),(100,0,'Erika Villalobos','Veronica Campos','Veronica Campos',NULL,'folder','86441',NULL,86441,'/INFORMES',31,1704229967,0,NULL,NULL,0,NULL,NULL),(110,0,'Erika Villalobos','Veronica Campos','Veronica Campos',NULL,'folder','87551',NULL,87551,'/INFORMES LS',31,1714507970,0,NULL,NULL,0,NULL,NULL),(111,0,'Melissa Barquero','Veronica Campos','Veronica Campos',NULL,'folder','87551',NULL,87551,'/INFORMES LS',31,1714507977,2,NULL,NULL,0,NULL,NULL),(112,0,'Rosa Mora','Veronica Campos','Veronica Campos',NULL,'folder','87551',NULL,87551,'/INFORMES LS',31,1714507985,0,NULL,NULL,0,NULL,NULL),(113,0,'Guillermo Solano','Veronica Campos','Melissa Barquero',NULL,'folder','87551',NULL,87551,'/INFORMES LS',31,1715004086,0,NULL,NULL,0,NULL,NULL),(117,0,'Maria Vinas','Luis Barboza','Luis Barboza',NULL,'folder','91058',NULL,91058,'/Consejos asesores',23,1732130471,0,NULL,NULL,0,NULL,NULL),(118,0,'Mauricio Solano','Luis Barboza','Luis Barboza',NULL,'folder','91058',NULL,91058,'/Consejos asesores',23,1732130478,0,NULL,NULL,0,NULL,NULL),(119,0,'Mauricio Solano','Luis Barboza','Luis Barboza',NULL,'folder','91170',NULL,91170,'/Consejos científicos',23,1732130491,0,NULL,NULL,0,NULL,NULL),(120,0,'Maria Vinas','Luis Barboza','Luis Barboza',NULL,'folder','91170',NULL,91170,'/Consejos científicos',23,1732130497,0,NULL,NULL,0,NULL,NULL),(121,0,'Melissa Barquero','Luis Barboza','Luis Barboza',NULL,'folder','91170',NULL,91170,'/Consejos científicos (2)',23,1732130502,0,NULL,NULL,0,NULL,NULL),(122,0,'Melissa Barquero','Luis Barboza','Luis Barboza',NULL,'folder','91058',NULL,91058,'/Consejos asesores',23,1732130515,0,NULL,NULL,0,NULL,NULL),(123,0,'Mauricio Solano','Luis Barboza','Luis Barboza',NULL,'folder','94453',NULL,94453,'/Documentos administrativos CIGRAS',23,1732130660,0,NULL,NULL,0,NULL,NULL),(124,0,'Erika Villalobos','Luis Barboza','Luis Barboza',NULL,'folder','94458',NULL,94458,'/SG',31,1732132532,0,NULL,NULL,0,NULL,NULL),(125,0,'Erika Villalobos','Luis Barboza','Luis Barboza',NULL,'folder','94457',NULL,94457,'/RC-AG-59',31,1732133232,0,NULL,NULL,0,NULL,NULL),(126,0,'Guido Perez','Luis Barboza','Erika Villalobos',NULL,'folder','94458',NULL,94458,'/SG',23,1732135086,0,NULL,NULL,0,NULL,NULL),(127,0,'Eduardo Fernandez','Luis Barboza','Erika Villalobos',NULL,'folder','94458',NULL,94458,'/SG',23,1732135137,0,NULL,NULL,0,NULL,NULL),(128,0,'Catalina Acuna','Luis Barboza','Erika Villalobos',NULL,'folder','94458',NULL,94458,'/SG',23,1732135154,0,NULL,NULL,0,NULL,NULL),(129,0,'Andres Monge','Luis Barboza','Erika Villalobos',NULL,'folder','94458',NULL,94458,'/SG',23,1732135179,0,NULL,NULL,0,NULL,NULL),(130,0,'Mauricio Solano','Luis Barboza','Erika Villalobos',NULL,'folder','94458',NULL,94458,'/SG',23,1732135189,0,NULL,NULL,0,NULL,NULL),(131,0,'Maria Vinas','Luis Barboza','Erika Villalobos',NULL,'folder','94458',NULL,94458,'/SG',23,1732135228,0,NULL,NULL,0,NULL,NULL),(132,0,'Kelvin Arce','Luis Barboza','Erika Villalobos',NULL,'folder','94458',NULL,94458,'/SG',23,1732135246,0,NULL,NULL,0,NULL,NULL),(133,0,'Diego Bogantes','Luis Barboza','Erika Villalobos',NULL,'folder','94458',NULL,94458,'/SG',23,1732135259,0,NULL,NULL,0,NULL,NULL),(134,0,'Rosa Mora','Luis Barboza','Erika Villalobos',NULL,'folder','94458',NULL,94458,'/SG',23,1732135283,0,NULL,NULL,0,NULL,NULL),(135,0,'Melissa Barquero','Luis Barboza','Erika Villalobos',NULL,'folder','94458',NULL,94458,'/SG',23,1732135300,0,NULL,NULL,0,NULL,NULL),(136,0,'Veronica Campos','Luis Barboza','Erika Villalobos',NULL,'folder','94458',NULL,94458,'/SG',23,1732135440,0,NULL,NULL,0,NULL,NULL),(137,0,'Guillermo Solano','Luis Barboza','Erika Villalobos',NULL,'folder','94458',NULL,94458,'/SG',23,1732135465,0,NULL,NULL,0,NULL,NULL),(138,0,'Andrea Irias','Luis Barboza','Erika Villalobos',NULL,'folder','94458',NULL,94458,'/SG',23,1732135576,0,NULL,NULL,0,NULL,NULL),(139,0,'Mauricio Solano','Luis Barboza','Erika Villalobos',NULL,'folder','94457',NULL,94457,'/RC-AG-59',23,1732137120,0,NULL,NULL,0,NULL,NULL),(140,0,'Andres Monge','Luis Barboza','Erika Villalobos',NULL,'folder','94457',NULL,94457,'/RC-AG-59',23,1732137132,0,NULL,NULL,0,NULL,NULL),(141,0,'Catalina Acuna','Luis Barboza','Erika Villalobos',NULL,'folder','94457',NULL,94457,'/RC-AG-59',23,1732137157,0,NULL,NULL,0,NULL,NULL),(142,0,'Maria Vinas','Luis Barboza','Erika Villalobos',NULL,'folder','94457',NULL,94457,'/RC-AG-59',23,1732137264,0,NULL,NULL,0,NULL,NULL),(143,0,'Victor Jimenez','Luis Barboza','Erika Villalobos',NULL,'folder','94457',NULL,94457,'/RC-AG-59',23,1732137446,0,NULL,NULL,0,NULL,NULL),(144,0,'marcelomurilloq','Luis Barboza','Erika Villalobos',NULL,'folder','94457',NULL,94457,'/RC-AG-59',23,1732137456,0,NULL,NULL,0,NULL,NULL),(145,0,'Alvaro Azofeifa','Luis Barboza','Erika Villalobos',NULL,'folder','94457',NULL,94457,'/RC-AG-59',23,1732137470,0,NULL,NULL,0,NULL,NULL),(146,0,'Andrea Irias','Luis Barboza','Erika Villalobos',NULL,'folder','94457',NULL,94457,'/RC-AG-59',23,1732137482,0,NULL,NULL,0,NULL,NULL),(147,0,'Andrea Holst','Luis Barboza','Erika Villalobos',NULL,'folder','94457',NULL,94457,'/RC-AG-59',23,1732137501,0,NULL,NULL,0,NULL,NULL),(148,0,'Guillermo Vargas','Luis Barboza','Erika Villalobos',NULL,'folder','94457',NULL,94457,'/RC-AG-59',23,1732137561,0,NULL,NULL,0,NULL,NULL),(151,0,'Luis Barboza','Veronica Campos','Veronica Campos',NULL,'folder','101504',NULL,101504,'/NORMAS',31,1746637580,0,NULL,NULL,0,NULL,NULL),(152,0,'Veronica Campos','Luis Barboza','Erika Villalobos',NULL,'folder','94457',NULL,94457,'/RC-AG-59',1,1755552441,0,NULL,NULL,0,NULL,NULL),(153,0,'Kelvin Arce','Luis Barboza','Erika Villalobos',NULL,'folder','94457',NULL,94457,'/RC-AG-59',1,1755552494,0,NULL,NULL,0,NULL,NULL),(154,0,'Eduardo Fernandez','Luis Barboza','Erika Villalobos',NULL,'folder','94457',NULL,94457,'/RC-AG-59',1,1755552513,0,NULL,NULL,0,NULL,NULL),(155,0,'Guido Perez','Luis Barboza','Erika Villalobos',NULL,'folder','94457',NULL,94457,'/RC-AG-59',1,1755552535,0,NULL,NULL,0,NULL,NULL),(156,0,'Diego Bogantes','Luis Barboza','Erika Villalobos',NULL,'folder','94457',NULL,94457,'/RC-AG-59',1,1755552565,0,NULL,NULL,0,NULL,NULL),(157,0,'Guillermo Solano','Luis Barboza','Erika Villalobos',NULL,'folder','94457',NULL,94457,'/RC-AG-59',1,1755552630,0,NULL,NULL,0,NULL,NULL);

--
-- Table structure for table `oc_share_external`
--

CREATE TABLE `oc_share_external` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `remote` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'Url of the remote owncloud instance',
  `remote_id` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '-1',
  `share_token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'Public share token',
  `password` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'Optional password for the public share',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'Original name on the remote server',
  `owner` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'User that owns the public share on the remote server',
  `user` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'Local user which added the external share',
  `mountpoint` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'Full path where the share is mounted',
  `mountpoint_hash` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'md5 hash of the mountpoint',
  `accepted` int NOT NULL DEFAULT '0',
  `lastscan` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sh_external_mp` (`user`,`mountpoint_hash`),
  KEY `sh_external_user` (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `oc_share_external`
--


--
-- Table structure for table `oc_storages`
--

CREATE TABLE `oc_storages` (
  `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `numeric_id` int NOT NULL AUTO_INCREMENT,
  `available` int NOT NULL DEFAULT '1',
  `last_checked` int DEFAULT NULL,
  PRIMARY KEY (`numeric_id`),
  UNIQUE KEY `storages_id_index` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `oc_storages`
--

INSERT INTO `oc_storages` VALUES ('home::ucr',1,1,NULL),('local::/var/www/html/cigrascloud/data/',2,1,NULL),('local::/var/www/html/sgcigras.ucr.ac.cr/data/',3,1,NULL),('home::Alvaro Azofeifa',4,1,NULL),('home::Andrea Irias',5,1,NULL),('home::Luis Gomez',7,1,NULL),('home::Maria Vinas',8,1,NULL),('home::Mauricio Solano',9,1,NULL),('home::Victor Jimenez',10,1,NULL),('local::/var/www/html/cigrascloud.ucr.ac.cr/data/',11,1,NULL),('home::Melissa Barquero',13,1,NULL),('home::Diego Bogantes',15,1,NULL),('home::Erika Villalobos',16,1,NULL),('home::Kelvin Arce',17,1,NULL),('home::Rosa Mora',18,1,NULL),('home::Nancy',19,1,NULL),('home::Andrea Holst',20,1,NULL),('home::Andres Monge',21,1,NULL),('home::Eduardo Fernandez',22,1,NULL),('home::Ester Vargas',23,1,NULL),('home::Guillermo Solano',25,1,NULL),('home::Guillermo Vargas',26,1,NULL),('home::Isabel Sanabria',27,1,NULL),('home::Paula Carvajal',28,1,NULL),('home::Stefanny Campos',29,1,NULL),('home::Veronica Campos',30,1,NULL),('home::sebastian.camacho',32,1,NULL),('home::marcelomurilloq',33,1,NULL),('home::Guido Perez',34,1,NULL),('home::Catalina Acuna',35,1,NULL),('local::/var/www/html/cigrascloud.ucr.ac.cr/data/ucr/uploads/',36,1,NULL),('7bbcc7872bdd8155ad55000cbe975bfb',37,1,NULL),('45416e05c6d8ebd412c36f2d10fd856f',38,1,NULL),('7da6d672460eff4949dd5ef542c9de90',39,1,NULL),('41d7118578bcc0641c41fb3ff0aa216a',40,1,NULL),('b6c1e8138fc9f4adf2d096c2d8928a05',41,1,NULL),('bf5ffd6d0e0f1c0a72d4e84b45389b2f',42,1,NULL),('12df4941e438bae6414735ac272cc029',43,1,NULL),('e528c31cd9732ed7c922ffee605133aa',44,1,NULL),('813eb62ab5e2fca3cf43524ecacc1fee',45,1,NULL),('1348504676aadf32f9c056eb6fff325b',46,1,NULL),('441c75a8c128d2541555af4f018523bd',47,1,NULL),('558e01a273cf53347355e456b128b3dd',48,1,NULL),('e98a65ca41d0e78283d76441b7259679',49,1,NULL),('9d7a25f1a1a93b1a654a65052eab61c2',50,1,NULL),('d5832e1d26af960c5b6710102af7890c',51,1,NULL),('7626c2eae5354f6ed1923b75d510e6e9',52,1,NULL),('edee0e1ca0c09ac0cccdfd8509fadfb6',53,1,NULL),('40ef04ccb4f13fb28a3b9956d73642d4',54,1,NULL),('4bc81011c9d2d6f28ce987b69b2b9455',55,1,NULL),('c357f29b13ae9ab5e7a71881e6b8cdd3',56,1,NULL),('33ab71a660a1ea5a0aee744e5a0f44e6',57,1,NULL),('1e7cc028af476528e024446ab730bfc5',58,1,NULL),('8ca5ceb294d2c6c94989531dcbb79b61',59,1,NULL),('7afe9f9f0c93f69987a72621c41355bd',60,1,NULL),('local::/var/www/html/cigrascloud.ucr.ac.cr/data/Nancy/uploads/',61,1,NULL),('f6c859aa615578c14ea33f084feef0f2',62,1,NULL),('e7aa35a8c5885bba0950274028f409e3',63,1,NULL),('b5d03e63fce7b24906b36b8685eda59e',64,1,NULL),('home::Luis Barboza',65,1,NULL);

--
-- Table structure for table `oc_systemtag`
--

CREATE TABLE `oc_systemtag` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `visibility` smallint NOT NULL DEFAULT '1',
  `editable` smallint NOT NULL DEFAULT '1',
  `assignable` smallint NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `tag_ident` (`name`,`visibility`,`editable`,`assignable`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `oc_systemtag`
--


--
-- Table structure for table `oc_systemtag_group`
--

CREATE TABLE `oc_systemtag_group` (
  `systemtagid` int unsigned NOT NULL DEFAULT '0',
  `gid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  PRIMARY KEY (`gid`,`systemtagid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `oc_systemtag_group`
--


--
-- Table structure for table `oc_systemtag_object_mapping`
--

CREATE TABLE `oc_systemtag_object_mapping` (
  `objectid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `objecttype` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `systemtagid` int unsigned NOT NULL DEFAULT '0',
  UNIQUE KEY `mapping` (`objecttype`,`objectid`,`systemtagid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `oc_systemtag_object_mapping`
--


--
-- Table structure for table `oc_trusted_servers`
--

CREATE TABLE `oc_trusted_servers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'Url of trusted server',
  `url_hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT 'sha1 hash of the url without the protocol',
  `token` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'token used to exchange the shared secret',
  `shared_secret` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'shared secret used to authenticate',
  `status` int NOT NULL DEFAULT '2' COMMENT 'current status of the connection',
  `sync_token` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT 'cardDav sync token',
  PRIMARY KEY (`id`),
  UNIQUE KEY `url_hash` (`url_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `oc_trusted_servers`
--


--
-- Table structure for table `oc_users`
--

CREATE TABLE `oc_users` (
  `uid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `displayname` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `oc_users`
--

INSERT INTO `oc_users` VALUES ('Alvaro Azofeifa',NULL,'1|$2y$10$/C.SdLjO4X3Rq/9L1hI/1OmqIQHw287VVRZ/0XJa4in9QLI5A62Su'),('Andrea Holst',NULL,'1|$2y$10$SbO0aGQnBRoZHiK/PvsHdOvM3ec529AxLZVrf6hGc4mjjXxboSlWy'),('Andrea Irias',NULL,'1|$2y$10$RYP3nfZuHWbscMWqfq.ro.muA06KjZA5Vm5OFq415Rwn.Pnk0rseW'),('Andres Monge',NULL,'1|$2y$10$bs2B1QCpcWsziyqGTJ3gzO5MOZw445C37noKNnmArW0PZ0RTzbxNq'),('Catalina Acuna',NULL,'1|$2y$10$wxBJ08A6O9g.NikVQ24pGOZIO9HCitV70MeMo4iRFWJ88NuMV75J6'),('Diego Bogantes',NULL,'1|$2y$10$.fWy9j825m5oDdR4pXbMr.ny.rzw9.OjXg8Pjk4CNFxZogK938wDa'),('Eduardo Fernandez',NULL,'1|$2y$10$jufVjJcj2v1X2J4GJDua3.ib5zNSa3spFjFzOTSFbMJ0YrViln5HW'),('Erika Villalobos',NULL,'1|$2y$10$3xkjeOSI3tRqEiKT7cLKnOFV/yWmnZdmt5aISMzv.bJY.Lg0fGpCy'),('Ester Vargas',NULL,'1|$2y$10$QZSTq3eG0NfNnSu7YkE2bu1Mi16eazbCV15FpoR6V7PO1rqkYWlza'),('Guido Perez',NULL,'1|$2y$10$W8cVJ2evgF/ozciZmGpYP.TyByv64j.t1DwmaWi6nO0OJBIKhqhNG'),('Guillermo Solano',NULL,'1|$2y$10$Q7WpF6qO5.xToy24TjI2B.7qZxQ.HnehEAR2TJr3FlgSiEHqF5lTS'),('Guillermo Vargas',NULL,'1|$2y$10$fewzHEXakOHmTglqJenAmeLn9SNM7VxNTwTbIE5OmPWnbd0TyMZbe'),('Isabel Sanabria',NULL,'1|$2y$10$KqUrDSZ3GPajHO6BX9Cis.HSWPHH9BN4LYhhzthKXy2fJCEdP/Lae'),('Kelvin Arce',NULL,'1|$2y$10$D0dv6KAjdTYre2vE8uOjmuyu/HbmHQLV5ao.MY5MCWuucOMmlhE9.'),('Luis Barboza',NULL,'1|$2y$10$sn5N.9e0MCwsFuCsZM.PiO8q7Vfy8MVzNqpwcddfjf4wQ0aCSNwwm'),('Luis Gomez',NULL,'1|$2y$10$KoNuo8o/XsAwoUx1YMA.bOX9UbNBYHuAFzeJfIQQtBWidUzB9KSzq'),('Maria Vinas',NULL,'1|$2y$10$khH6ZRG/bjNQTYRZqgew3ebaq4/0mpynbJkROWbvJL/SC.x5Tr3wS'),('Mauricio Solano',NULL,'1|$2y$10$CZX8zoYLnnRvFNsPLu7VU.rz.n3GDMAYUhOec6llJej/T3hkIV9/6'),('Melissa Barquero',NULL,'1|$2y$10$1c1kpwRzpW3ctkRdSDHQJuUdEjfV8ic0ad6pAKuzr562wsabymB4S'),('Nancy','Nancy Paticia Leiva','1|$2y$10$jkw8f8NfOv4RkFX5zketm.Loz8nGLxmEWZl1tk43xoelj7s68KzGi'),('Paula Carvajal',NULL,'1|$2y$10$Dm1ByvqsGMiDBh9o.Odsb.EzF4O7fBPbPbdWTw3Zv8h4yQhRfKKoi'),('Rosa Mora',NULL,'1|$2y$10$F7eDVWPJVsyKoipxW1N3v.SrQCtyghFraT0.cXVTmhhm4A2QKYhO2'),('Stefanny Campos',NULL,'1|$2y$10$CW2Qi9f7P/peF/ROEQyjeuN0Cb0iswf5d8ikQSiJ3sHunbbsR56zu'),('Veronica Campos',NULL,'1|$2y$10$RJ7IogJn4.gjyc/.eBle2eEAVM3kna7tzS8ZH8UPxMA.66YOOBzCS'),('Victor Jimenez',NULL,'1|$2y$10$wZXREWOuFRW20E.gY8yqm.ic728GrqBoaCyFtLedMtUYK3b/QmoC6'),('marcelomurilloq',NULL,'1|$2y$10$0C/SzVz8Tk9Q1PPJi6D3suBZgG9LX7V21bnxGdlOlIQp.sEV/.Ete'),('sebastian.camacho',NULL,'1|$2y$10$YbiW.ram9yovQhtVZ8O8L.jkR9m1u4OFl72jXLQeBUzAheKCGX1OS'),('ucr',NULL,'1|$2y$10$/cRcJPLhDT9CQAw6jVElquuFZIPKjtRaPrxx6yPNWtVWirgCdQjb.');

--
-- Table structure for table `oc_vcategory`
--

CREATE TABLE `oc_vcategory` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `uid_index` (`uid`),
  KEY `type_index` (`type`),
  KEY `category_index` (`category`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `oc_vcategory`
--

INSERT INTO `oc_vcategory` VALUES (1,'Mauricio Solano','files','_$!<Favorite>!$_');

--
-- Table structure for table `oc_vcategory_to_object`
--

CREATE TABLE `oc_vcategory_to_object` (
  `objid` bigint unsigned NOT NULL DEFAULT '0',
  `categoryid` int unsigned NOT NULL DEFAULT '0',
  `type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`categoryid`,`objid`,`type`),
  KEY `vcategory_objectd_index` (`objid`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;

--
-- Dumping data for table `oc_vcategory_to_object`
--

INSERT INTO `oc_vcategory_to_object` VALUES (404,1,'files'),(529,1,'files');


