
--
-- Table structure for table `oc_files_trash`
--

CREATE TABLE `oc_files_trash` (
  `auto_id` bigint NOT NULL AUTO_INCREMENT,
  `id` varchar(250) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `user` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `timestamp` varchar(12) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `location` varchar(512) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `type` varchar(4) COLLATE utf8mb4_bin DEFAULT NULL,
  `mime` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`auto_id`),
  KEY `id_index` (`id`),
  KEY `timestamp_index` (`timestamp`),
  KEY `user_index` (`user`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_files_trash`
--

INSERT INTO `oc_files_trash` VALUES (1,'Photos','pagreppo','1757508666','.',NULL,NULL),(2,'Example.odt','pagreppo','1757508682','Documents',NULL,NULL),(3,'Documents','pagreppo','1757508918','.',NULL,NULL),(4,'Photos','StAmbroix','1757512701','.',NULL,NULL),(5,'Documents','StAmbroix','1757512701','.',NULL,NULL),(6,'Learn more about ownCloud','StAmbroix','1757512701','.',NULL,NULL);

--
-- Table structure for table `oc_group_admin`
--

CREATE TABLE `oc_group_admin` (
  `gid` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `uid` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`gid`,`uid`),
  KEY `group_admin_uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_group_admin`
--


--
-- Table structure for table `oc_group_user`
--

CREATE TABLE `oc_group_user` (
  `gid` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `uid` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`gid`,`uid`),
  KEY `gu_uid_index` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_group_user`
--

INSERT INTO `oc_group_user` VALUES ('admin','admin'),('admin','pagreppo');

--
-- Table structure for table `oc_groups`
--

CREATE TABLE `oc_groups` (
  `gid` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_groups`
--

INSERT INTO `oc_groups` VALUES ('admin');

--
-- Table structure for table `oc_jobs`
--

CREATE TABLE `oc_jobs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `class` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `argument` varchar(4000) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `last_run` int DEFAULT '0',
  `last_checked` int DEFAULT '0',
  `reserved_at` int DEFAULT '0',
  `execution_duration` int NOT NULL DEFAULT '-1',
  PRIMARY KEY (`id`),
  KEY `job_class_index` (`class`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_jobs`
--

INSERT INTO `oc_jobs` VALUES (1,'OCA\\Files\\BackgroundJob\\ScanFiles','null',1757505897,1757505897,0,0),(2,'OCA\\Files\\BackgroundJob\\DeleteOrphanedItems','null',1757505942,1757505942,0,0),(3,'OCA\\Files\\BackgroundJob\\CleanupFileLocks','null',1757505957,1757505957,0,0),(4,'OCA\\Files\\BackgroundJob\\CleanupPersistentFileLocks','null',1757505991,1757505991,0,0),(5,'OCA\\Files\\BackgroundJob\\PreviewCleanupJob','null',1757506006,1757506006,0,0),(6,'OCA\\DAV\\CardDAV\\SyncJob','null',1757535547,1757535547,0,0),(7,'OCA\\DAV\\BackgroundJob\\CleanProperties','null',1757535561,1757535561,0,0),(8,'OCA\\Activity\\BackgroundJob\\EmailNotification','null',1757535646,1757535646,0,0),(9,'OCA\\Activity\\BackgroundJob\\ExpireActivities','null',1757535782,1757535782,0,0),(10,'OCA\\ConfigReport\\Telemetry\\BackgroundJob','null',1757535807,1757535807,0,0),(11,'OCA\\Federation\\SyncJob','null',1757535823,1757535823,0,0),(12,'OCA\\Files_Sharing\\DeleteOrphanedSharesJob','null',1757535838,1757535838,0,0),(13,'OCA\\Files_Sharing\\ExpireSharesJob','null',1757535976,1757535976,0,0),(14,'OCA\\Files_Sharing\\External\\ScanExternalSharesJob','null',1757535988,1757535988,0,0),(15,'OCA\\Files_Trashbin\\BackgroundJob\\ExpireTrash','null',1757536008,1757536008,0,0),(16,'OCA\\Files_Versions\\BackgroundJob\\ExpireVersions','null',0,1757505872,0,-1),(17,'OCA\\Market\\CheckUpdateBackgroundJob','null',0,1757505872,0,-1),(18,'OCA\\UpdateNotification\\Notification\\BackgroundJob','null',0,1757505875,0,-1),(19,'\\OC\\Authentication\\Token\\DefaultTokenCleanupJob','null',0,1757505875,0,-1),(20,'OC\\Command\\CommandJob','\"O:33:\\\"OCA\\\\Files_Trashbin\\\\Command\\\\Expire\\\":1:{s:39:\\\"\\u0000OCA\\\\Files_Trashbin\\\\Command\\\\Expire\\u0000user\\\";s:8:\\\"pagreppo\\\";}\"',0,1757508666,0,-1),(21,'OC\\Command\\CommandJob','\"O:33:\\\"OCA\\\\Files_Trashbin\\\\Command\\\\Expire\\\":1:{s:39:\\\"\\u0000OCA\\\\Files_Trashbin\\\\Command\\\\Expire\\u0000user\\\";s:9:\\\"StAmbroix\\\";}\"',0,1757512701,0,-1),(22,'OC\\Command\\CommandJob','\"O:33:\\\"OCA\\\\Files_Trashbin\\\\Command\\\\Expire\\\":1:{s:39:\\\"\\u0000OCA\\\\Files_Trashbin\\\\Command\\\\Expire\\u0000user\\\";s:9:\\\"StAmbroix\\\";}\"',0,1757512701,0,-1);

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

CREATE TABLE `oc_migrations` (
  `app` varchar(177) COLLATE utf8mb3_unicode_ci NOT NULL,
  `version` varchar(14) COLLATE utf8mb3_unicode_ci NOT NULL,
  PRIMARY KEY (`app`,`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- 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) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mimetype_id_index` (`mimetype`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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

INSERT INTO `oc_mimetypes` VALUES (3,'application'),(24,'application/msword'),(8,'application/octet-stream'),(7,'application/pdf'),(26,'application/vnd.ms-excel'),(21,'application/vnd.oasis.opendocument.graphics'),(17,'application/vnd.oasis.opendocument.spreadsheet'),(4,'application/vnd.oasis.opendocument.text'),(23,'application/vnd.openxmlformats-officedocument.wordprocessingml.document'),(15,'application/x-gimp'),(22,'application/zip'),(18,'audio'),(19,'audio/ogg'),(1,'httpd'),(2,'httpd/unix-directory'),(5,'image'),(16,'image/gif'),(6,'image/jpeg'),(12,'image/png'),(29,'image/svg+xml'),(27,'message'),(28,'message/rfc822'),(9,'text'),(11,'text/html'),(10,'text/plain'),(25,'text/rtf'),(13,'video'),(20,'video/mp4'),(14,'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) COLLATE utf8mb4_bin NOT NULL,
  `mount_point` varchar(4000) 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=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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

INSERT INTO `oc_mounts` VALUES (1,2,1,'admin','/admin/'),(2,5,40,'pagreppo','/pagreppo/'),(3,4,110,'pagreppo','/pagreppo/uploads/'),(4,7,690,'StAmbroix','/StAmbroix/'),(5,6,829,'StAmbroix','/StAmbroix/uploads/');

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

CREATE TABLE `oc_notifications` (
  `notification_id` int NOT NULL AUTO_INCREMENT,
  `app` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `user` varchar(64) COLLATE utf8mb4_bin NOT NULL,
  `timestamp` int NOT NULL DEFAULT '0',
  `object_type` varchar(64) COLLATE utf8mb4_bin NOT NULL,
  `object_id` varchar(64) COLLATE utf8mb4_bin NOT NULL,
  `subject` varchar(64) COLLATE utf8mb4_bin NOT NULL,
  `subject_parameters` longtext COLLATE utf8mb4_bin,
  `message` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `message_parameters` longtext COLLATE utf8mb4_bin,
  `link` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `actions` longtext COLLATE utf8mb4_bin,
  `icon` varchar(4000) 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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


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

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

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

INSERT INTO `oc_preferences` VALUES ('StAmbroix','core','lang','fr'),('StAmbroix','core','timezone','Europe/Berlin'),('StAmbroix','firstrunwizard','show','0'),('admin','core','lang','fr'),('admin','core','timezone','Europe/Berlin'),('admin','firstrunwizard','show','0'),('pagreppo','core','lang','fr'),('pagreppo','core','timezone','Europe/Berlin'),('pagreppo','firstrunwizard','show','0');

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

CREATE TABLE `oc_properties` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `fileid` bigint unsigned NOT NULL,
  `propertyname` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `propertyvalue` varchar(255) 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;

--
-- 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) COLLATE utf8mb4_bin DEFAULT NULL,
  `calendardata` longblob,
  `uri` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `lastmodified` int unsigned DEFAULT NULL,
  `etag` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL,
  `size` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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


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

CREATE TABLE `oc_storages` (
  `id` varchar(64) 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=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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

INSERT INTO `oc_storages` VALUES ('local::/home/foebbyd/cloud/data/admin/uploads/',1,1,NULL),('home::admin',2,1,NULL),('local::/home/foebbyd/cloud/data/',3,1,NULL),('local::/home/foebbyd/cloud/data/pagreppo/uploads/',4,1,NULL),('home::pagreppo',5,1,NULL),('local::/home/foebbyd/cloud/data/StAmbroix/uploads/',6,1,NULL),('home::StAmbroix',7,1,NULL);

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

CREATE TABLE `oc_systemtag` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) 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;

--
-- 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) COLLATE utf8mb4_bin NOT NULL,
  PRIMARY KEY (`gid`,`systemtagid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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


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

CREATE TABLE `oc_systemtag_object_mapping` (
  `objectid` varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `objecttype` varchar(64) 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;

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


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

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

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


--
-- 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) 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;

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



