-- Table structure for table `oc_cards_properties`
--

CREATE TABLE `oc_cards_properties` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `addressbookid` bigint(20) NOT NULL DEFAULT 0,
  `cardid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `name` varchar(64) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `preferred` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `card_contactid_index` (`cardid`),
  KEY `card_name_index` (`name`),
  KEY `card_value_index` (`value`),
  KEY `cards_prop_abid_name_value` (`addressbookid`,`name`,`value`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_cards_properties`
--

INSERT INTO `oc_cards_properties` VALUES
(1,2,1,'UID','ba8e55ec-89f3-49f0-b428-d54e209dea70',0),
(2,2,1,'FN','Leon Green',0),
(3,2,1,'ADR',';;123 Street Street;City;State;;Country',0),
(4,2,1,'EMAIL','leon@example.com',0),
(5,2,1,'TEL','+999999999999',0),
(6,2,1,'TITLE','Manager',0),
(7,2,1,'ORG','Company',0),
(8,2,1,'BDAY','20000101',0),
(9,2,1,'URL','www.nextcloud.com',0),
(10,2,1,'NOTE','This is an example contact',0),
(26,1,2,'UID','fluencyhub',0),
(27,1,2,'FN','FluencyHub',0),
(28,1,2,'N','FluencyHub;;;;',0),
(29,1,2,'EMAIL','info@fluencyhub.com.au',0),
(30,1,2,'X-SOCIALPROFILE','https://nc.fluencyhub.au/index.php/u/fluencyhub',0),
(31,1,2,'CLOUD','fluencyhub@nc.fluencyhub.au',0),
(32,1,3,'UID','admin',0),
(33,1,3,'FN','admin',0),
(34,1,3,'N','admin;;;;',0),
(35,1,3,'EMAIL','info@fluencyhub.com.au',0),
(36,1,3,'X-SOCIALPROFILE','https://nc.fluencyhub.au/index.php/u/admin',0),
(37,1,3,'CLOUD','admin@nc.fluencyhub.au',0);

--
-- Table structure for table `oc_circles_circle`
--

CREATE TABLE `oc_circles_circle` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `unique_id` varchar(31) NOT NULL,
  `name` varchar(127) NOT NULL,
  `display_name` varchar(255) DEFAULT '',
  `sanitized_name` varchar(127) DEFAULT '',
  `instance` varchar(255) DEFAULT '',
  `config` int(10) unsigned DEFAULT NULL,
  `source` int(10) unsigned DEFAULT NULL,
  `settings` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `creation` datetime DEFAULT NULL,
  `contact_addressbook` int(10) unsigned DEFAULT NULL,
  `contact_groupname` varchar(127) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_8195F548E3C68343` (`unique_id`),
  KEY `IDX_8195F548D48A2F7C` (`config`),
  KEY `IDX_8195F5484230B1DE` (`instance`),
  KEY `IDX_8195F5485F8A7F73` (`source`),
  KEY `IDX_8195F548C317B362` (`sanitized_name`),
  KEY `dname` (`display_name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_circles_circle`
--

INSERT INTO `oc_circles_circle` VALUES
(1,'3DFnCXu2Cx4oEzs5QKjVbnRpvaLrIgA','user:admin:3DFnCXu2Cx4oEzs5QKjVbnRpvaLrIgA','admin','','',1,1,'[]','','2026-05-03 06:41:59',0,''),
(2,'ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH','app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH','Circles','','',8193,10001,'[]','','2026-05-03 06:41:59',0,''),
(3,'MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK','group:staff','staff','','',1540,2,'{\"population\":1,\"populationInherited\":1}','','2026-05-03 12:16:49',0,''),
(4,'TGqGy6eHANccyi4Ayk6htP6gRTVgqj6','user:fluencyhub:TGqGy6eHANccyi4Ayk6htP6gRTVgqj6','FluencyHub','','',1,1,'[]','','2026-05-04 01:01:28',0,''),
(5,'AMVjqfjj7YAPCF8Rt67I21IADm3c8IH','group:admin','admin','','',1540,2,'{\"population\":1,\"populationInherited\":1}','','2026-05-04 01:01:31',0,'');

--
-- Table structure for table `oc_circles_event`
--

CREATE TABLE `oc_circles_event` (
  `token` varchar(63) NOT NULL,
  `instance` varchar(255) NOT NULL,
  `event` longtext DEFAULT NULL,
  `result` longtext DEFAULT NULL,
  `interface` int(11) NOT NULL DEFAULT 0,
  `severity` int(11) DEFAULT NULL,
  `retry` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `creation` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`token`,`instance`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_circles_event`
--

INSERT INTO `oc_circles_event` VALUES
('334825eb-fd00-4932-a0e1-fd8e6cbabe46','nc.fluencyhub.au','{\"class\":\"OCA\\\\Circles\\\\FederatedItems\\\\SingleMemberAdd\",\"severity\":3,\"params\":[],\"internal\":[],\"data\":[],\"result\":[],\"origin\":\"nc.fluencyhub.au\",\"sender\":\"nc.fluencyhub.au\",\"itemId\":\"\",\"outcome\":{\"id\":\"2S2lu9MTALfV2WWtbumDvBRfIQYxsjs\",\"circleId\":\"MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK\",\"singleId\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"userId\":\"fluencyhub\",\"userType\":1,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":1,\"status\":\"Member\",\"displayName\":\"fluencyhub\",\"displayUpdate\":0,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":0,\"invitedBy\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"displayName\":\"Circles\",\"instance\":\"nc.fluencyhub.au\",\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}},\"basedOn\":{\"id\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"name\":\"user:fluencyhub:TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"displayName\":\"fluencyhub\",\"sanitizedName\":\"\",\"source\":1,\"population\":0,\"populationInherited\":0,\"config\":1,\"description\":\"\",\"url\":\"\",\"creation\":1777856488,\"initiator\":null,\"owner\":{\"id\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"circleId\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"singleId\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"userId\":\"fluencyhub\",\"userType\":1,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"fluencyhub\",\"displayUpdate\":1777856491,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":1777856488,\"basedOn\":{\"id\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"name\":\"user:fluencyhub:TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"displayName\":\"fluencyhub\",\"sanitizedName\":\"\",\"source\":1,\"population\":0,\"populationInherited\":0,\"config\":1,\"description\":\"\",\"url\":\"\",\"creation\":1777856488,\"initiator\":null}}},\"circle\":{\"id\":\"MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK\",\"name\":\"group:staff\",\"displayName\":\"staff\",\"sanitizedName\":\"\",\"source\":2,\"population\":0,\"populationInherited\":0,\"config\":1540,\"description\":\"\",\"url\":\"\",\"creation\":1777810609,\"initiator\":{\"id\":\"qrtirXRwwOaYKdURgzS5gLBNO4UyWCg\",\"circleId\":\"MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK\",\"singleId\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"Circles\",\"displayUpdate\":1777810609,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":1777810609},\"owner\":{\"id\":\"qrtirXRwwOaYKdURgzS5gLBNO4UyWCg\",\"circleId\":\"MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK\",\"singleId\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"Circles\",\"displayUpdate\":1777810609,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":1777810609,\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}},\"settings\":{\"population\":0,\"populationInherited\":0}}},\"members\":[{\"id\":\"2S2lu9MTALfV2WWtbumDvBRfIQYxsjs\",\"circleId\":\"MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK\",\"singleId\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"userId\":\"fluencyhub\",\"userType\":1,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":1,\"status\":\"Member\",\"displayName\":\"fluencyhub\",\"displayUpdate\":0,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":0,\"invitedBy\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"displayName\":\"Circles\",\"instance\":\"nc.fluencyhub.au\",\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}},\"basedOn\":{\"id\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"name\":\"user:fluencyhub:TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"displayName\":\"fluencyhub\",\"sanitizedName\":\"\",\"source\":1,\"population\":0,\"populationInherited\":0,\"config\":1,\"description\":\"\",\"url\":\"\",\"creation\":1777856488,\"initiator\":null,\"owner\":{\"id\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"circleId\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"singleId\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"userId\":\"fluencyhub\",\"userType\":1,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"fluencyhub\",\"displayUpdate\":1777856491,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":1777856488,\"basedOn\":{\"id\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"name\":\"user:fluencyhub:TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"displayName\":\"fluencyhub\",\"sanitizedName\":\"\",\"source\":1,\"population\":0,\"populationInherited\":0,\"config\":1,\"description\":\"\",\"url\":\"\",\"creation\":1777856488,\"initiator\":null}}},\"circle\":{\"id\":\"MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK\",\"name\":\"group:staff\",\"displayName\":\"staff\",\"sanitizedName\":\"\",\"source\":2,\"population\":0,\"populationInherited\":0,\"config\":1540,\"description\":\"\",\"url\":\"\",\"creation\":1777810609,\"initiator\":{\"id\":\"qrtirXRwwOaYKdURgzS5gLBNO4UyWCg\",\"circleId\":\"MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK\",\"singleId\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"Circles\",\"displayUpdate\":1777810609,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":1777810609},\"owner\":{\"id\":\"qrtirXRwwOaYKdURgzS5gLBNO4UyWCg\",\"circleId\":\"MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK\",\"singleId\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"Circles\",\"displayUpdate\":1777810609,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":1777810609,\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}},\"settings\":{\"population\":0,\"populationInherited\":0}}}],\"circle\":{\"id\":\"MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK\",\"name\":\"group:staff\",\"displayName\":\"staff\",\"sanitizedName\":\"\",\"source\":2,\"population\":0,\"populationInherited\":0,\"config\":1540,\"description\":\"\",\"url\":\"\",\"creation\":1777810609,\"initiator\":{\"id\":\"qrtirXRwwOaYKdURgzS5gLBNO4UyWCg\",\"circleId\":\"MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK\",\"singleId\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"Circles\",\"displayUpdate\":1777810609,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":1777810609},\"owner\":{\"id\":\"qrtirXRwwOaYKdURgzS5gLBNO4UyWCg\",\"circleId\":\"MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK\",\"singleId\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"Circles\",\"displayUpdate\":1777810609,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":1777810609,\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}},\"settings\":{\"population\":0,\"populationInherited\":0}},\"member\":{\"id\":\"2S2lu9MTALfV2WWtbumDvBRfIQYxsjs\",\"circleId\":\"MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK\",\"singleId\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"userId\":\"fluencyhub\",\"userType\":1,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":1,\"status\":\"Member\",\"displayName\":\"fluencyhub\",\"displayUpdate\":0,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":0,\"invitedBy\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"displayName\":\"Circles\",\"instance\":\"nc.fluencyhub.au\",\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}},\"basedOn\":{\"id\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"name\":\"user:fluencyhub:TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"displayName\":\"fluencyhub\",\"sanitizedName\":\"\",\"source\":1,\"population\":0,\"populationInherited\":0,\"config\":1,\"description\":\"\",\"url\":\"\",\"creation\":1777856488,\"initiator\":null,\"owner\":{\"id\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"circleId\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"singleId\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"userId\":\"fluencyhub\",\"userType\":1,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"fluencyhub\",\"displayUpdate\":1777856491,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":1777856488,\"basedOn\":{\"id\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"name\":\"user:fluencyhub:TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"displayName\":\"fluencyhub\",\"sanitizedName\":\"\",\"source\":1,\"population\":0,\"populationInherited\":0,\"config\":1,\"description\":\"\",\"url\":\"\",\"creation\":1777856488,\"initiator\":null}}},\"circle\":{\"id\":\"MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK\",\"name\":\"group:staff\",\"displayName\":\"staff\",\"sanitizedName\":\"\",\"source\":2,\"population\":0,\"populationInherited\":0,\"config\":1540,\"description\":\"\",\"url\":\"\",\"creation\":1777810609,\"initiator\":{\"id\":\"qrtirXRwwOaYKdURgzS5gLBNO4UyWCg\",\"circleId\":\"MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK\",\"singleId\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"Circles\",\"displayUpdate\":1777810609,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":1777810609},\"owner\":{\"id\":\"qrtirXRwwOaYKdURgzS5gLBNO4UyWCg\",\"circleId\":\"MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK\",\"singleId\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"Circles\",\"displayUpdate\":1777810609,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":1777810609,\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}},\"settings\":{\"population\":0,\"populationInherited\":0}}}}','{\"files\":[[]]}',0,3,0,9,NULL,1777856491),
('8e0c53f7-f9fc-4988-aeeb-cb846ef6c45d','nc.fluencyhub.au','{\"class\":\"OCA\\\\Circles\\\\FederatedItems\\\\SingleMemberAdd\",\"severity\":3,\"params\":[],\"internal\":[],\"data\":[],\"result\":[],\"origin\":\"nc.fluencyhub.au\",\"sender\":\"nc.fluencyhub.au\",\"itemId\":\"\",\"outcome\":{\"id\":\"RVC2Hr5Kf2w9AScBMn2ib57RdHd8fpA\",\"circleId\":\"AMVjqfjj7YAPCF8Rt67I21IADm3c8IH\",\"singleId\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"userId\":\"fluencyhub\",\"userType\":1,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":1,\"status\":\"Member\",\"displayName\":\"fluencyhub\",\"displayUpdate\":0,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":0,\"invitedBy\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"displayName\":\"Circles\",\"instance\":\"nc.fluencyhub.au\",\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}},\"basedOn\":{\"id\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"name\":\"user:fluencyhub:TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"displayName\":\"fluencyhub\",\"sanitizedName\":\"\",\"source\":1,\"population\":0,\"populationInherited\":0,\"config\":1,\"description\":\"\",\"url\":\"\",\"creation\":1777856488,\"initiator\":null,\"owner\":{\"id\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"circleId\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"singleId\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"userId\":\"fluencyhub\",\"userType\":1,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"fluencyhub\",\"displayUpdate\":1777856488,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":1777856488,\"basedOn\":{\"id\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"name\":\"user:fluencyhub:TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"displayName\":\"fluencyhub\",\"sanitizedName\":\"\",\"source\":1,\"population\":0,\"populationInherited\":0,\"config\":1,\"description\":\"\",\"url\":\"\",\"creation\":1777856488,\"initiator\":null}}},\"circle\":{\"id\":\"AMVjqfjj7YAPCF8Rt67I21IADm3c8IH\",\"name\":\"group:admin\",\"displayName\":\"admin\",\"sanitizedName\":\"\",\"source\":2,\"population\":0,\"populationInherited\":0,\"config\":1540,\"description\":\"\",\"url\":\"\",\"creation\":0,\"initiator\":{\"id\":\"ZlNQ7Ty5oBGnlkKJCsANwDQQkehzOAw\",\"circleId\":\"AMVjqfjj7YAPCF8Rt67I21IADm3c8IH\",\"singleId\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"Circles\",\"displayUpdate\":0,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":0,\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}},\"owner\":{\"id\":\"ZlNQ7Ty5oBGnlkKJCsANwDQQkehzOAw\",\"circleId\":\"AMVjqfjj7YAPCF8Rt67I21IADm3c8IH\",\"singleId\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"Circles\",\"displayUpdate\":0,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":0,\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}},\"settings\":{\"population\":0,\"populationInherited\":0}}},\"members\":[{\"id\":\"RVC2Hr5Kf2w9AScBMn2ib57RdHd8fpA\",\"circleId\":\"AMVjqfjj7YAPCF8Rt67I21IADm3c8IH\",\"singleId\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"userId\":\"fluencyhub\",\"userType\":1,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":1,\"status\":\"Member\",\"displayName\":\"fluencyhub\",\"displayUpdate\":0,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":0,\"invitedBy\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"displayName\":\"Circles\",\"instance\":\"nc.fluencyhub.au\",\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}},\"basedOn\":{\"id\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"name\":\"user:fluencyhub:TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"displayName\":\"fluencyhub\",\"sanitizedName\":\"\",\"source\":1,\"population\":0,\"populationInherited\":0,\"config\":1,\"description\":\"\",\"url\":\"\",\"creation\":1777856488,\"initiator\":null,\"owner\":{\"id\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"circleId\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"singleId\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"userId\":\"fluencyhub\",\"userType\":1,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"fluencyhub\",\"displayUpdate\":1777856488,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":1777856488,\"basedOn\":{\"id\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"name\":\"user:fluencyhub:TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"displayName\":\"fluencyhub\",\"sanitizedName\":\"\",\"source\":1,\"population\":0,\"populationInherited\":0,\"config\":1,\"description\":\"\",\"url\":\"\",\"creation\":1777856488,\"initiator\":null}}},\"circle\":{\"id\":\"AMVjqfjj7YAPCF8Rt67I21IADm3c8IH\",\"name\":\"group:admin\",\"displayName\":\"admin\",\"sanitizedName\":\"\",\"source\":2,\"population\":0,\"populationInherited\":0,\"config\":1540,\"description\":\"\",\"url\":\"\",\"creation\":0,\"initiator\":{\"id\":\"ZlNQ7Ty5oBGnlkKJCsANwDQQkehzOAw\",\"circleId\":\"AMVjqfjj7YAPCF8Rt67I21IADm3c8IH\",\"singleId\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"Circles\",\"displayUpdate\":0,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":0,\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}},\"owner\":{\"id\":\"ZlNQ7Ty5oBGnlkKJCsANwDQQkehzOAw\",\"circleId\":\"AMVjqfjj7YAPCF8Rt67I21IADm3c8IH\",\"singleId\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"Circles\",\"displayUpdate\":0,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":0,\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}},\"settings\":{\"population\":0,\"populationInherited\":0}}}],\"circle\":{\"id\":\"AMVjqfjj7YAPCF8Rt67I21IADm3c8IH\",\"name\":\"group:admin\",\"displayName\":\"admin\",\"sanitizedName\":\"\",\"source\":2,\"population\":0,\"populationInherited\":0,\"config\":1540,\"description\":\"\",\"url\":\"\",\"creation\":0,\"initiator\":{\"id\":\"ZlNQ7Ty5oBGnlkKJCsANwDQQkehzOAw\",\"circleId\":\"AMVjqfjj7YAPCF8Rt67I21IADm3c8IH\",\"singleId\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"Circles\",\"displayUpdate\":0,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":0,\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}},\"owner\":{\"id\":\"ZlNQ7Ty5oBGnlkKJCsANwDQQkehzOAw\",\"circleId\":\"AMVjqfjj7YAPCF8Rt67I21IADm3c8IH\",\"singleId\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"Circles\",\"displayUpdate\":0,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":0,\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}},\"settings\":{\"population\":0,\"populationInherited\":0}},\"member\":{\"id\":\"RVC2Hr5Kf2w9AScBMn2ib57RdHd8fpA\",\"circleId\":\"AMVjqfjj7YAPCF8Rt67I21IADm3c8IH\",\"singleId\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"userId\":\"fluencyhub\",\"userType\":1,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":1,\"status\":\"Member\",\"displayName\":\"fluencyhub\",\"displayUpdate\":0,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":0,\"invitedBy\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"displayName\":\"Circles\",\"instance\":\"nc.fluencyhub.au\",\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}},\"basedOn\":{\"id\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"name\":\"user:fluencyhub:TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"displayName\":\"fluencyhub\",\"sanitizedName\":\"\",\"source\":1,\"population\":0,\"populationInherited\":0,\"config\":1,\"description\":\"\",\"url\":\"\",\"creation\":1777856488,\"initiator\":null,\"owner\":{\"id\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"circleId\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"singleId\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"userId\":\"fluencyhub\",\"userType\":1,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"fluencyhub\",\"displayUpdate\":1777856488,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":1777856488,\"basedOn\":{\"id\":\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"name\":\"user:fluencyhub:TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\",\"displayName\":\"fluencyhub\",\"sanitizedName\":\"\",\"source\":1,\"population\":0,\"populationInherited\":0,\"config\":1,\"description\":\"\",\"url\":\"\",\"creation\":1777856488,\"initiator\":null}}},\"circle\":{\"id\":\"AMVjqfjj7YAPCF8Rt67I21IADm3c8IH\",\"name\":\"group:admin\",\"displayName\":\"admin\",\"sanitizedName\":\"\",\"source\":2,\"population\":0,\"populationInherited\":0,\"config\":1540,\"description\":\"\",\"url\":\"\",\"creation\":0,\"initiator\":{\"id\":\"ZlNQ7Ty5oBGnlkKJCsANwDQQkehzOAw\",\"circleId\":\"AMVjqfjj7YAPCF8Rt67I21IADm3c8IH\",\"singleId\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"Circles\",\"displayUpdate\":0,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":0,\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}},\"owner\":{\"id\":\"ZlNQ7Ty5oBGnlkKJCsANwDQQkehzOAw\",\"circleId\":\"AMVjqfjj7YAPCF8Rt67I21IADm3c8IH\",\"singleId\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"instance\":\"nc.fluencyhub.au\",\"local\":true,\"level\":9,\"status\":\"Member\",\"displayName\":\"Circles\",\"displayUpdate\":0,\"notes\":[],\"contactId\":\"\",\"contactMeta\":\"\",\"joined\":0,\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}},\"settings\":{\"population\":0,\"populationInherited\":0}}}}','{\"files\":[[]]}',0,3,0,9,NULL,1777856491);

--
-- Table structure for table `oc_circles_member`
--

CREATE TABLE `oc_circles_member` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `single_id` varchar(31) DEFAULT NULL,
  `circle_id` varchar(31) NOT NULL,
  `member_id` varchar(31) DEFAULT NULL,
  `user_id` varchar(127) NOT NULL,
  `user_type` smallint(6) NOT NULL DEFAULT 1,
  `instance` varchar(255) DEFAULT '',
  `invited_by` varchar(31) DEFAULT NULL,
  `level` smallint(6) NOT NULL,
  `status` varchar(15) DEFAULT NULL,
  `note` longtext DEFAULT NULL,
  `cached_name` varchar(255) DEFAULT '',
  `cached_update` datetime DEFAULT NULL,
  `contact_id` varchar(127) DEFAULT NULL,
  `contact_meta` longtext DEFAULT NULL,
  `joined` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `circles_member_cisiuiutil` (`circle_id`,`single_id`,`user_id`,`user_type`,`instance`,`level`),
  KEY `circles_member_cisi` (`circle_id`,`single_id`),
  KEY `IDX_25C66A49E7A1254A` (`contact_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_circles_member`
--

INSERT INTO `oc_circles_member` VALUES
(1,'ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH','ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH','ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH','circles',10000,'',NULL,9,'Member','[]','Circles','2026-05-03 06:41:59','',NULL,'2026-05-03 06:41:59'),
(2,'3DFnCXu2Cx4oEzs5QKjVbnRpvaLrIgA','3DFnCXu2Cx4oEzs5QKjVbnRpvaLrIgA','3DFnCXu2Cx4oEzs5QKjVbnRpvaLrIgA','admin',1,'','ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH',9,'Member','[]','admin','2026-05-04 01:12:17','',NULL,'2026-05-03 06:41:59'),
(3,'ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH','MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK','qrtirXRwwOaYKdURgzS5gLBNO4UyWCg','circles',10000,'',NULL,9,'Member','[]','Circles','2026-05-03 12:16:49','',NULL,'2026-05-03 12:16:49'),
(4,'TGqGy6eHANccyi4Ayk6htP6gRTVgqj6','TGqGy6eHANccyi4Ayk6htP6gRTVgqj6','TGqGy6eHANccyi4Ayk6htP6gRTVgqj6','fluencyhub',1,'','ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH',9,'Member','[]','FluencyHub','2026-05-04 01:01:35','',NULL,'2026-05-04 01:01:28'),
(5,'ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH','AMVjqfjj7YAPCF8Rt67I21IADm3c8IH','ZlNQ7Ty5oBGnlkKJCsANwDQQkehzOAw','circles',10000,'',NULL,9,'Member','[]','Circles','2026-05-04 01:01:31','',NULL,'2026-05-04 01:01:31'),
(6,'TGqGy6eHANccyi4Ayk6htP6gRTVgqj6','AMVjqfjj7YAPCF8Rt67I21IADm3c8IH','RVC2Hr5Kf2w9AScBMn2ib57RdHd8fpA','fluencyhub',1,'','ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH',1,'Member','{\"invitedBy\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"displayName\":\"Circles\",\"instance\":\"nc.fluencyhub.au\",\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}}}','FluencyHub','2026-05-04 01:01:35','',NULL,'2026-05-04 01:01:31'),
(7,'TGqGy6eHANccyi4Ayk6htP6gRTVgqj6','MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK','2S2lu9MTALfV2WWtbumDvBRfIQYxsjs','fluencyhub',1,'','ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH',1,'Member','{\"invitedBy\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"userId\":\"circles\",\"userType\":10000,\"displayName\":\"Circles\",\"instance\":\"nc.fluencyhub.au\",\"basedOn\":{\"id\":\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"name\":\"app:circles:ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\",\"displayName\":\"Circles\",\"sanitizedName\":\"\",\"source\":10001,\"population\":0,\"populationInherited\":0,\"config\":8193,\"description\":\"\",\"url\":\"\",\"creation\":1777790519,\"initiator\":null}}}','FluencyHub','2026-05-04 01:01:35','',NULL,'2026-05-04 01:01:31');

--
-- Table structure for table `oc_circles_membership`
--

CREATE TABLE `oc_circles_membership` (
  `circle_id` varchar(31) NOT NULL,
  `single_id` varchar(31) NOT NULL,
  `level` int(10) unsigned NOT NULL,
  `inheritance_first` varchar(31) NOT NULL,
  `inheritance_last` varchar(31) NOT NULL,
  `inheritance_depth` int(10) unsigned NOT NULL,
  `inheritance_path` longtext NOT NULL,
  PRIMARY KEY (`single_id`,`circle_id`),
  KEY `IDX_8FC816EAE7C1D92B` (`single_id`),
  KEY `circles_membership_ifilci` (`inheritance_first`,`inheritance_last`,`circle_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_circles_membership`
--

INSERT INTO `oc_circles_membership` VALUES
('3DFnCXu2Cx4oEzs5QKjVbnRpvaLrIgA','3DFnCXu2Cx4oEzs5QKjVbnRpvaLrIgA',9,'3DFnCXu2Cx4oEzs5QKjVbnRpvaLrIgA','3DFnCXu2Cx4oEzs5QKjVbnRpvaLrIgA',1,'[\"3DFnCXu2Cx4oEzs5QKjVbnRpvaLrIgA\"]'),
('AMVjqfjj7YAPCF8Rt67I21IADm3c8IH','TGqGy6eHANccyi4Ayk6htP6gRTVgqj6',1,'TGqGy6eHANccyi4Ayk6htP6gRTVgqj6','AMVjqfjj7YAPCF8Rt67I21IADm3c8IH',1,'[\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\"]'),
('MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK','TGqGy6eHANccyi4Ayk6htP6gRTVgqj6',1,'TGqGy6eHANccyi4Ayk6htP6gRTVgqj6','MGyAW2v8Ba6oBCBpqPndA4GuxntPyuK',1,'[\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\"]'),
('TGqGy6eHANccyi4Ayk6htP6gRTVgqj6','TGqGy6eHANccyi4Ayk6htP6gRTVgqj6',9,'TGqGy6eHANccyi4Ayk6htP6gRTVgqj6','TGqGy6eHANccyi4Ayk6htP6gRTVgqj6',1,'[\"TGqGy6eHANccyi4Ayk6htP6gRTVgqj6\"]'),
('ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH','ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH',9,'ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH','ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH',1,'[\"ZA8yMfZLfqXHcU8dggjdJQ8pfUwu8IH\"]');

--
-- Table structure for table `oc_circles_mount`
--

CREATE TABLE `oc_circles_mount` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mount_id` varchar(31) NOT NULL,
  `circle_id` varchar(31) NOT NULL,
  `single_id` varchar(31) NOT NULL,
  `token` varchar(63) DEFAULT NULL,
  `parent` int(11) DEFAULT NULL,
  `mountpoint` longtext DEFAULT NULL,
  `mountpoint_hash` varchar(64) DEFAULT NULL,
  `remote` varchar(255) DEFAULT '',
  `remote_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `circles_mount_cimipt` (`circle_id`,`mount_id`,`parent`,`token`),
  KEY `m_sid_rmt_rid` (`circle_id`,`remote`,`remote_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_circles_mount`
--


--
-- Table structure for table `oc_circles_mountpoint`
--

CREATE TABLE `oc_circles_mountpoint` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mount_id` varchar(31) NOT NULL,
  `single_id` varchar(31) NOT NULL,
  `mountpoint` longtext DEFAULT NULL,
  `mountpoint_hash` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mp_sid_hash` (`single_id`,`mountpoint_hash`),
  KEY `circles_mountpoint_ms` (`mount_id`,`single_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_circles_mountpoint`
--


--
-- Table structure for table `oc_circles_remote`
--

CREATE TABLE `oc_circles_remote` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(15) NOT NULL DEFAULT 'Unknown',
  `interface` int(11) NOT NULL DEFAULT 0,
  `uid` varchar(20) DEFAULT NULL,
  `instance` varchar(127) DEFAULT NULL,
  `href` varchar(254) DEFAULT NULL,
  `item` longtext DEFAULT NULL,
  `creation` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_F94EF834230B1DE` (`instance`),
  KEY `IDX_F94EF83539B0606` (`uid`),
  KEY `IDX_F94EF8334F8E741` (`href`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_circles_remote`
--


--
-- Table structure for table `oc_circles_share_lock`
--

CREATE TABLE `oc_circles_share_lock` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` varchar(31) NOT NULL,
  `circle_id` varchar(31) NOT NULL,
  `instance` varchar(127) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_337F52F8126F525E70EE2FF6` (`item_id`,`circle_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_circles_share_lock`
--


--
-- Table structure for table `oc_circles_token`
--

CREATE TABLE `oc_circles_token` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `share_id` int(11) DEFAULT NULL,
  `circle_id` varchar(31) DEFAULT NULL,
  `single_id` varchar(31) DEFAULT NULL,
  `member_id` varchar(31) DEFAULT NULL,
  `token` varchar(31) DEFAULT NULL,
  `password` varchar(127) DEFAULT NULL,
  `accepted` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sicisimit` (`share_id`,`circle_id`,`single_id`,`member_id`,`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_circles_token`
--


--
-- Table structure for table `oc_collres_accesscache`
--

CREATE TABLE `oc_collres_accesscache` (
  `user_id` varchar(64) NOT NULL,
  `collection_id` bigint(20) NOT NULL DEFAULT 0,
  `resource_type` varchar(64) NOT NULL DEFAULT '',
  `resource_id` varchar(64) NOT NULL DEFAULT '',
  `access` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`user_id`,`collection_id`,`resource_type`,`resource_id`),
  KEY `collres_user_res` (`user_id`,`resource_type`,`resource_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_collres_accesscache`
--


--
-- Table structure for table `oc_collres_collections`
--

CREATE TABLE `oc_collres_collections` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_collres_collections`
--


--
-- Table structure for table `oc_collres_resources`
--

CREATE TABLE `oc_collres_resources` (
  `collection_id` bigint(20) NOT NULL,
  `resource_type` varchar(64) NOT NULL,
  `resource_id` varchar(64) NOT NULL,
  PRIMARY KEY (`collection_id`,`resource_type`,`resource_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_collres_resources`
--


--
-- Table structure for table `oc_comments`
--

CREATE TABLE `oc_comments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `topmost_parent_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `children_count` int(10) unsigned NOT NULL DEFAULT 0,
  `actor_type` varchar(64) NOT NULL DEFAULT '',
  `actor_id` varchar(64) NOT NULL DEFAULT '',
  `message` longtext DEFAULT NULL,
  `verb` varchar(64) DEFAULT NULL,
  `creation_timestamp` datetime DEFAULT NULL,
  `latest_child_timestamp` datetime DEFAULT NULL,
  `object_type` varchar(64) NOT NULL DEFAULT '',
  `object_id` varchar(64) NOT NULL DEFAULT '',
  `reference_id` varchar(64) DEFAULT NULL,
  `reactions` varchar(4000) DEFAULT NULL,
  `expire_date` datetime DEFAULT NULL,
  `meta_data` longtext DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `comments_parent_id_index` (`parent_id`),
  KEY `comments_topmost_parent_id_idx` (`topmost_parent_id`),
  KEY `comments_object_index` (`object_type`,`object_id`,`creation_timestamp`),
  KEY `comments_actor_index` (`actor_type`,`actor_id`),
  KEY `expire_date` (`expire_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_comments`
--


--
-- Table structure for table `oc_comments_read_markers`
--

CREATE TABLE `oc_comments_read_markers` (
  `user_id` varchar(64) NOT NULL DEFAULT '',
  `object_type` varchar(64) NOT NULL DEFAULT '',
  `object_id` varchar(64) NOT NULL DEFAULT '',
  `marker_datetime` datetime DEFAULT NULL,
  PRIMARY KEY (`user_id`,`object_type`,`object_id`),
  KEY `comments_marker_object_index` (`object_type`,`object_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_comments_read_markers`
--


--
-- Table structure for table `oc_dav_absence`
--

CREATE TABLE `oc_dav_absence` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) NOT NULL,
  `first_day` varchar(10) NOT NULL,
  `last_day` varchar(10) NOT NULL,
  `status` varchar(100) NOT NULL,
  `message` longtext NOT NULL,
  `replacement_user_id` varchar(64) DEFAULT '',
  `replacement_user_display_name` varchar(64) DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `dav_absence_uid_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_dav_absence`
--


--
-- Table structure for table `oc_dav_cal_proxy`
--

CREATE TABLE `oc_dav_cal_proxy` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `owner_id` varchar(64) NOT NULL,
  `proxy_id` varchar(64) NOT NULL,
  `permissions` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `dav_cal_proxy_uidx` (`owner_id`,`proxy_id`,`permissions`),
  KEY `dav_cal_proxy_ipid` (`proxy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_dav_cal_proxy`
--


--
-- Table structure for table `oc_dav_shares`
--

CREATE TABLE `oc_dav_shares` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `principaluri` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `access` smallint(6) DEFAULT NULL,
  `resourceid` bigint(20) unsigned NOT NULL,
  `publicuri` varchar(255) DEFAULT NULL,
  `token` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `dav_shares_index` (`principaluri`,`resourceid`,`type`,`publicuri`),
  KEY `dav_shares_resourceid_type` (`resourceid`,`type`),
  KEY `dav_shares_resourceid_access` (`resourceid`,`access`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_dav_shares`
--


--
-- Table structure for table `oc_direct_edit`
--

CREATE TABLE `oc_direct_edit` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `editor_id` varchar(64) NOT NULL,
  `token` varchar(64) NOT NULL,
  `file_id` bigint(20) NOT NULL,
  `user_id` varchar(64) DEFAULT NULL,
  `share_id` bigint(20) DEFAULT NULL,
  `timestamp` bigint(20) unsigned NOT NULL,
  `accessed` tinyint(1) DEFAULT 0,
  `file_path` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_4D5AFECA5F37A13B` (`token`),
  KEY `direct_edit_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_direct_edit`
--


--
-- Table structure for table `oc_directlink`
--

CREATE TABLE `oc_directlink` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) DEFAULT NULL,
  `file_id` bigint(20) unsigned NOT NULL,
  `token` varchar(60) DEFAULT NULL,
  `expiration` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `directlink_token_idx` (`token`),
  KEY `directlink_expiration_idx` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_directlink`
--


--
-- Table structure for table `oc_ex_apps`
--

CREATE TABLE `oc_ex_apps` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) NOT NULL,
  `version` varchar(32) NOT NULL,
  `name` varchar(64) NOT NULL,
  `daemon_config_name` varchar(64) NOT NULL DEFAULT '0',
  `port` smallint(5) unsigned NOT NULL,
  `secret` varchar(256) NOT NULL,
  `status` longtext NOT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`status`)),
  `enabled` smallint(6) NOT NULL DEFAULT 0,
  `created_time` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ex_apps__appid` (`appid`),
  UNIQUE KEY `ex_apps_c_port__idx` (`daemon_config_name`,`port`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_ex_apps`
--


--
-- Table structure for table `oc_ex_apps_daemons`
--

CREATE TABLE `oc_ex_apps_daemons` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `accepts_deploy_id` varchar(64) NOT NULL,
  `protocol` varchar(32) NOT NULL,
  `host` varchar(255) NOT NULL,
  `deploy_config` longtext NOT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`deploy_config`)),
  PRIMARY KEY (`id`),
  UNIQUE KEY `ex_apps_daemons__name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_ex_apps_daemons`
--


--
-- Table structure for table `oc_ex_apps_routes`
--

CREATE TABLE `oc_ex_apps_routes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) NOT NULL,
  `url` varchar(512) NOT NULL,
  `verb` varchar(64) NOT NULL,
  `access_level` int(11) NOT NULL DEFAULT 0,
  `headers_to_exclude` varchar(512) DEFAULT NULL,
  `bruteforce_protection` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ex_apps_routes_appid` (`appid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_ex_apps_routes`
--


--
-- Table structure for table `oc_ex_deploy_options`
--

CREATE TABLE `oc_ex_deploy_options` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) NOT NULL,
  `type` varchar(32) NOT NULL,
  `value` longtext NOT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`value`)),
  PRIMARY KEY (`id`),
  UNIQUE KEY `deploy_options__idx` (`appid`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_ex_deploy_options`
--


--
-- Table structure for table `oc_ex_occ_commands`
--

CREATE TABLE `oc_ex_occ_commands` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) NOT NULL,
  `name` varchar(64) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `hidden` smallint(6) NOT NULL DEFAULT 0,
  `arguments` longtext NOT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`arguments`)),
  `options` longtext NOT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`options`)),
  `usages` longtext NOT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`usages`)),
  `execute_handler` varchar(410) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ex_occ_commands__idx` (`appid`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_ex_occ_commands`
--


--
-- Table structure for table `oc_ex_settings_forms`
--

CREATE TABLE `oc_ex_settings_forms` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) NOT NULL,
  `formid` varchar(64) NOT NULL,
  `scheme` longtext NOT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`scheme`)),
  PRIMARY KEY (`id`),
  UNIQUE KEY `ex_settings_forms__idx` (`appid`,`formid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_ex_settings_forms`
--


--
-- Table structure for table `oc_ex_task_processing`
--

CREATE TABLE `oc_ex_task_processing` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `app_id` varchar(32) NOT NULL,
  `name` varchar(255) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `task_type` varchar(255) NOT NULL,
  `custom_task_type` longtext DEFAULT NULL,
  `provider` longtext NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `task_processing_idx` (`app_id`,`name`,`task_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_ex_task_processing`
--


--
-- Table structure for table `oc_ex_ui_files_actions`
--

CREATE TABLE `oc_ex_ui_files_actions` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) NOT NULL,
  `name` varchar(64) NOT NULL,
  `display_name` varchar(64) NOT NULL,
  `mime` longtext NOT NULL DEFAULT 'file',
  `permissions` varchar(255) NOT NULL,
  `order` bigint(20) NOT NULL DEFAULT 0,
  `icon` varchar(255) DEFAULT '',
  `action_handler` varchar(64) NOT NULL,
  `version` varchar(64) NOT NULL DEFAULT '1.0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ex_ui_files_actions__idx` (`appid`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_ex_ui_files_actions`
--


--
-- Table structure for table `oc_ex_ui_scripts`
--

CREATE TABLE `oc_ex_ui_scripts` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) NOT NULL,
  `type` varchar(16) NOT NULL,
  `name` varchar(32) NOT NULL,
  `path` varchar(410) NOT NULL,
  `after_app_id` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ui_script__idx` (`appid`,`type`,`name`,`path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_ex_ui_scripts`
--


--
-- Table structure for table `oc_ex_ui_states`
--

CREATE TABLE `oc_ex_ui_states` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) NOT NULL,
  `type` varchar(16) NOT NULL,
  `name` varchar(32) NOT NULL,
  `key` varchar(64) NOT NULL,
  `value` longtext NOT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`value`)),
  PRIMARY KEY (`id`),
  UNIQUE KEY `ui_state__idx` (`appid`,`type`,`name`,`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_ex_ui_states`
--


--
-- Table structure for table `oc_ex_ui_styles`
--

CREATE TABLE `oc_ex_ui_styles` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) NOT NULL,
  `type` varchar(16) NOT NULL,
  `name` varchar(32) NOT NULL,
  `path` varchar(410) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ui_style__idx` (`appid`,`type`,`name`,`path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_ex_ui_styles`
--


--
-- Table structure for table `oc_ex_ui_top_menu`
--

CREATE TABLE `oc_ex_ui_top_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) NOT NULL,
  `name` varchar(32) NOT NULL,
  `display_name` varchar(32) NOT NULL,
  `icon` varchar(255) DEFAULT '',
  `admin_required` smallint(6) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ui_top_menu__idx` (`appid`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_ex_ui_top_menu`
--


--
-- Table structure for table `oc_external_applicable`
--

CREATE TABLE `oc_external_applicable` (
  `applicable_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `mount_id` bigint(20) NOT NULL,
  `type` int(11) NOT NULL,
  `value` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`applicable_id`),
  UNIQUE KEY `applicable_type_value_mount` (`type`,`value`,`mount_id`),
  KEY `applicable_mount` (`mount_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_external_applicable`
--

INSERT INTO `oc_external_applicable` VALUES
(1,1,1,NULL);

--
-- Table structure for table `oc_external_config`
--

CREATE TABLE `oc_external_config` (
  `config_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `mount_id` bigint(20) NOT NULL,
  `key` varchar(64) NOT NULL,
  `value` varchar(4000) DEFAULT NULL,
  PRIMARY KEY (`config_id`),
  UNIQUE KEY `config_mount_key` (`mount_id`,`key`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_external_config`
--

INSERT INTO `oc_external_config` VALUES
(1,1,'bucket','nextcloud'),
(2,1,'hostname','effc475f195a9a5dc4f995e231689fef.r2.cloudflarestorage.com'),
(3,1,'port','443'),
(4,1,'proxy',''),
(5,1,'region','auto'),
(6,1,'storageClass',''),
(7,1,'use_ssl','1'),
(8,1,'use_path_style',''),
(9,1,'legacy_auth',''),
(10,1,'useMultipartCopy','1'),
(11,1,'use_presigned_url',''),
(12,1,'sse_c_key',''),
(13,1,'key','f4f1b308ae4922cbd43b02abd86e0c32'),
(14,1,'secret','0b5cdbbeb88d76c561c69874b2562ba7ce0fea20bca5f812780b9d5f75cc948f');

--
-- Table structure for table `oc_external_mounts`
--

CREATE TABLE `oc_external_mounts` (
  `mount_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `mount_point` varchar(128) NOT NULL,
  `storage_backend` varchar(64) NOT NULL,
  `auth_backend` varchar(64) NOT NULL,
  `priority` int(11) NOT NULL DEFAULT 100,
  `type` int(11) NOT NULL,
  PRIMARY KEY (`mount_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_external_mounts`
--

INSERT INTO `oc_external_mounts` VALUES
(1,'/Cloud drive','amazons3','amazons3::accesskey',100,1);

--
-- Table structure for table `oc_external_options`
--

CREATE TABLE `oc_external_options` (
  `option_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `mount_id` bigint(20) NOT NULL,
  `key` varchar(64) NOT NULL,
  `value` varchar(256) NOT NULL,
  PRIMARY KEY (`option_id`),
  UNIQUE KEY `option_mount_key` (`mount_id`,`key`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_external_options`
--

INSERT INTO `oc_external_options` VALUES
(1,1,'encrypt','\"1\"'),
(2,1,'previews','\"1\"'),
(3,1,'enable_sharing','\"1\"'),
(4,1,'filesystem_check_changes','\"2\"'),
(5,1,'encoding_compatibility','\"\"'),
(6,1,'readonly','\"\"');

--
-- Table structure for table `oc_federated_invites`
--

CREATE TABLE `oc_federated_invites` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) NOT NULL,
  `recipient_provider` varchar(2083) DEFAULT NULL,
  `recipient_user_id` varchar(1024) DEFAULT NULL,
  `recipient_name` varchar(1024) DEFAULT NULL,
  `recipient_email` varchar(320) DEFAULT NULL,
  `token` varchar(60) NOT NULL,
  `accepted` tinyint(1) DEFAULT 0,
  `created_at` bigint(20) NOT NULL,
  `expired_at` bigint(20) DEFAULT NULL,
  `accepted_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_A2C17D5A5F37A13B` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_federated_invites`
--


--
-- Table structure for table `oc_federated_reshares`
--

CREATE TABLE `oc_federated_reshares` (
  `share_id` bigint(20) NOT NULL,
  `remote_id` varchar(255) DEFAULT '',
  PRIMARY KEY (`share_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_federated_reshares`
--


--
-- Table structure for table `oc_file_locks`
--

CREATE TABLE `oc_file_locks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `lock` int(11) NOT NULL DEFAULT 0,
  `key` varchar(64) NOT NULL,
  `ttl` int(11) NOT NULL DEFAULT -1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `lock_key_index` (`key`),
  KEY `lock_ttl_index` (`ttl`)
) ENGINE=InnoDB AUTO_INCREMENT=722 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_file_locks`
--

INSERT INTO `oc_file_locks` VALUES
(1,0,'files/b0d3006c11a6fcd5bc6b3877cd28f47e',1777794157),
(2,0,'files/02540f1f1fe4f174e53cb5306658ae5e',1777794157),
(3,0,'files/84fc6d08ed3bd071bcdab33a99d2d7d9',1777794157),
(4,0,'files/fd8da3434edce128b167807022298f49',1777794157),
(5,0,'files/b6ef755cfc70b5eb94f5d3aad8ba833d',1777794157),
(6,0,'files/3513aba8aa4305d3ad33fc7122d4af30',1777794157),
(7,0,'files/78ca1ee24c6399d1c8b8702a5522ef86',1777802209),
(8,0,'files/d398928936d6a5106d10883342778164',1777802209),
(9,0,'files/b5da0f3c02a2111afeb7ae1121bf46ab',1777802209),
(10,0,'files/3994246842f1d8e84d340165c13747e6',1777802209),
(11,0,'files/d12a59af6742853ce984df8f0c6a3696',1777813693),
(12,0,'files/e2ddf8a74f4f32a38aba3f84d876b346',1777804113),
(14,0,'files/acb1d6a86247c8b0f899e884ea32feae',1777850064),
(15,0,'files/a85129d8ea386cf59f6cf571f97ff56b',1777850064),
(16,0,'files/4c448ad234fd52ac08937124f605e837',1777813693),
(17,0,'files/ec82acd325bf0f919db54d4dfba0e9f9',1777804174),
(20,0,'files/c08a6662e5ce85a27652c360db603833',1777850064),
(21,0,'files/e951ba6b0f4a104c50cd027bfba31e57',1777850064),
(23,0,'files/0b7480fe86e7ecb37f7f27b656e51fb3',1777850042),
(24,0,'files/d0355f20c35057e60d9d9ffe5bcfc203',1777850065),
(25,0,'files/67c266ebdcffa2a21c0a4ecb4eb1aaba',1777850065),
(26,0,'files/499d60f939c2848375f0fb89ed0cc50a',1777850065),
(27,0,'files/c69740341d724f216e854aa12faebbcd',1777850065),
(28,0,'files/459e3b502d080afca843a38a07cb597c',1777850065),
(29,0,'files/0c2d6d35c7fdea29b6dea23b38f35fcc',1777850065),
(30,0,'files/50ed9b4334b0f575e18bf48266c201e0',1777813713),
(31,0,'files/bde9e39fa02c71c4d7fe1369a8fb437c',1777850065),
(105,0,'files/8abe2542d1ebc824807d2d46992cdfca',1777813679),
(106,0,'files/769135c89a2b07cd697493bef1bd2604',1777813644),
(148,0,'files/71fc843368dc755e5180bf9a8fb1de10',1777850055),
(164,0,'files/621f772834356c1459f471bc6825ec39',1777850065),
(248,0,'files/70394c0f953a7e1b3ef871b6ddad4669',1777813676),
(289,0,'files/81ede32979da4dac56089f002b7280ff',1777850065),
(293,0,'files/f06ecec7ee5c3a4da12f57f96df15e70',1777813693),
(295,0,'files/6fc02cbededb0f2da96caa159a83d9d9',1777813693),
(447,0,'files/00aed066acf010cb2983941a2631e940',1777813711),
(470,0,'files/20a4785bbef8f3f87028de641b7a554a',1777850065),
(551,0,'files/7cdfe0cd3922471c81ede2068bdbb5dd',1777813743),
(568,0,'files/6569f13c0e1a9e3a69dfde163a23a14b',1777850065),
(588,0,'files/f3d3d3e17192cb4b2e3a66f765dbcdb0',1777850040),
(590,0,'files/b794875d292e3eee8b4de0ce5b7a9d6d',1777850065),
(666,0,'files/7530bb25a652017d80c2b0f36ba8da37',1777850053),
(704,0,'files/d0a7f8dbf06c177a04d9ba15b66adb94',1777850065);

--
-- Table structure for table `oc_filecache`
--

CREATE TABLE `oc_filecache` (
  `fileid` bigint(20) NOT NULL AUTO_INCREMENT,
  `storage` bigint(20) NOT NULL DEFAULT 0,
  `path` varchar(4000) DEFAULT NULL,
  `path_hash` varchar(32) NOT NULL DEFAULT '',
  `parent` bigint(20) NOT NULL DEFAULT 0,
  `name` varchar(250) DEFAULT NULL,
  `mimetype` bigint(20) NOT NULL DEFAULT 0,
  `mimepart` bigint(20) NOT NULL DEFAULT 0,
  `size` bigint(20) NOT NULL DEFAULT 0,
  `mtime` bigint(20) NOT NULL DEFAULT 0,
  `storage_mtime` bigint(20) NOT NULL DEFAULT 0,
  `encrypted` int(11) NOT NULL DEFAULT 0,
  `unencrypted_size` bigint(20) NOT NULL DEFAULT 0,
  `etag` varchar(40) DEFAULT NULL,
  `permissions` int(11) DEFAULT 0,
  `checksum` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`fileid`),
  UNIQUE KEY `fs_storage_path_hash` (`storage`,`path_hash`),
  KEY `fs_parent_name_hash` (`parent`,`name`),
  KEY `fs_storage_mimetype` (`storage`,`mimetype`),
  KEY `fs_storage_mimepart` (`storage`,`mimepart`),
  KEY `fs_storage_size` (`storage`,`size`,`fileid`),
  KEY `fs_parent` (`parent`),
  KEY `fs_name_hash` (`name`),
  KEY `fs_mtime` (`mtime`),
  KEY `fs_size` (`size`),
  KEY `fs_storage_path_prefix` (`storage`,`path`(64))
) ENGINE=InnoDB AUTO_INCREMENT=192 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_filecache`
--

INSERT INTO `oc_filecache` VALUES
(1,1,'','d41d8cd98f00b204e9800998ecf8427e',-1,'',2,1,62632138,1777797332,1777797332,0,0,'69f708d45c4a3',23,''),
(2,1,'files','45b963397aa40d4a0063e0d85e4fe7a1',1,'files',2,1,62632138,1777790523,1777790523,0,0,'69f6ee3b9a530',31,''),
(3,1,'files/Documents','0ad78ba05b6961d92f7970b2b3922eca',2,'Documents',2,1,1108446,1777790519,1777790519,0,0,'69f6ee37ea9c5',31,''),
(4,1,'files/Documents/Welcome to Nextcloud Hub.docx','b44cb84f22ceddc4ca2826e026038091',3,'Welcome to Nextcloud Hub.docx',4,3,23876,1777790519,1777790519,0,0,'0e3cc6e5d11d7bb14358f84cbe6c31c4',27,''),
(5,1,'files/Documents/Example.md','efe0853470dd0663db34818b444328dd',3,'Example.md',6,5,1095,1777790519,1777790519,0,0,'9245c6bc03979d6bc7e4f25d963f0660',27,''),
(6,1,'files/Documents/Readme.md','51ec9e44357d147dd5c212b850f6910f',3,'Readme.md',6,5,136,1777790519,1777790519,0,0,'e497aba7612e8c12bb0590f637ece5db',27,''),
(7,1,'files/Documents/Nextcloud flyer.pdf','9c5b4dc7182a7435767708ac3e8d126c',3,'Nextcloud flyer.pdf',7,3,1083339,1777790519,1777790519,0,0,'bc574aa12d6aecaffda6b9fb7fa01324',27,''),
(8,1,'files/Nextcloud intro.mp4','e4919345bcc87d4585a5525daaad99c0',2,'Nextcloud intro.mp4',9,8,3963036,1777790519,1777790519,0,0,'3ec517d0d98260d8f8d3860d3c7d4392',27,''),
(9,1,'files/Nextcloud.png','2bcc0ff06465ef1bfc4a868efde1e485',2,'Nextcloud.png',11,10,50598,1777790520,1777790520,0,0,'99d14e3159d2715ec0bfb1fcc374189d',27,''),
(10,1,'files/Templates','530b342d0b8164ff3b4754c2273a453e',2,'Templates',2,1,23476072,1777790522,1777790522,0,0,'69f6ee3ae8556',31,''),
(11,1,'files/Templates/Diagram & table.ods','0a89f154655f6d4a0098bc4e6ca87367',10,'Diagram & table.ods',12,3,13378,1777790520,1777790520,0,0,'b2e721b0e88d8b21ac559ad62b5a579b',27,''),
(12,1,'files/Templates/Flowchart.whiteboard','b944a25f1ef13e8e256107178bb28141',10,'Flowchart.whiteboard',13,3,31132,1777790520,1777790520,0,0,'606895d4a709ffbe57d9dae1f7733909',27,''),
(13,1,'files/Templates/Elegant.odp','f3ec70ed694c0ca215f094b98eb046a7',10,'Elegant.odp',14,3,14316,1777790520,1777790520,0,0,'10ac3208c020eb9774bdd5bb65ae2a7b',27,''),
(14,1,'files/Templates/Syllabus.odt','03b3147e6dae00674c1d50fe22bb8496',10,'Syllabus.odt',15,3,32323,1777790520,1777790520,0,0,'608f8507417d4f78758354bc77564245',27,''),
(15,1,'files/Templates/Security.odp','f60c1935b9b65bc06c6c6bfb5776d799',10,'Security.odp',14,3,190107,1777790520,1777790520,0,0,'70c226a7bf81c7d65abc2e4fba1dd426',27,''),
(16,1,'files/Templates/Pitch deck.odp','008c83c17a2021c0ca2a45592902cbf8',10,'Pitch deck.odp',14,3,35963,1777790520,1777790520,0,0,'70e3a95df354be569f2febc8bf70423a',27,''),
(17,1,'files/Templates/Triangle.odp','00d15a150581c646b5fef301fe99d5b6',10,'Triangle.odp',14,3,35454,1777790520,1777790520,0,0,'0a622494161852fb3e40c20262c80f51',27,''),
(18,1,'files/Templates/Nostalgia.odp','3ec95d91860764c9c4316dcfa4be06aa',10,'Nostalgia.odp',14,3,560887,1777790520,1777790520,0,0,'050cb56ba24d92c825596a4ca57ebf33',27,''),
(19,1,'files/Templates/Venn diagram.whiteboard','71d9f77ebd2c126375fa7170a1c86509',10,'Venn diagram.whiteboard',13,3,23359,1777790520,1777790520,0,0,'46fefeb01fd46c6cd9bf6b754c287723',27,''),
(20,1,'files/Templates/Timeline.whiteboard','a009a1620252b19a9307d35de49311e9',10,'Timeline.whiteboard',13,3,31325,1777790520,1777790520,0,0,'26afb7c20ec1b72cc11f9cdceaccfb51',27,''),
(21,1,'files/Templates/Photo book.odt','ea35993988e2799424fef3ff4f420c24',10,'Photo book.odt',15,3,5155877,1777790520,1777790520,0,0,'220465fbc7cb62b1678faa05df0e32a1',27,''),
(22,1,'files/Templates/Menu.odt','64663435ca7de4c9ca8d7672f2e2663a',10,'Menu.odt',15,3,33089,1777790520,1777790520,0,0,'81864a864fe9ecb1ddc9253baff5ca5e',27,''),
(23,1,'files/Templates/Certificate.odt','925a8dcedb5c2d2f6ef697aa3edf17c6',10,'Certificate.odt',15,3,33441,1777790520,1777790520,0,0,'ee37bfba138a0b8da9a144a22a0015c1',27,''),
(24,1,'files/Templates/Calendar.odt','0708fc19c3dfcbc1b4b9ed9fd4cc9fdc',10,'Calendar.odt',15,3,22675,1777790520,1777790520,0,0,'fb394c337fd10466a7fbbddc511d6268',27,''),
(25,1,'files/Templates/Yellow idea.odp','3a57051288d7b81bef3196a2123f4af5',10,'Yellow idea.odp',14,3,81196,1777790520,1777790520,0,0,'0875541a3ec5d041749fa71e80829845',27,''),
(26,1,'files/Templates/Onboarding.odp','2131269b631b9e1b4d5ffdb5cc3e09bc',10,'Onboarding.odp',14,3,9904434,1777790521,1777790521,0,0,'3d0dce5f970838e9a691aee95650defb',27,''),
(27,1,'files/Templates/Ecosystem.odp','83433827d87227520f743f7ac13fb047',10,'Ecosystem.odp',14,3,1441424,1777790521,1777790521,0,0,'00ad0eec0fde383aaa372eec77ad1f61',27,''),
(28,1,'files/Templates/Product plan.md','a9fbf58bf31cebb8143f7ad3a5205633',10,'Product plan.md',6,5,573,1777790521,1777790521,0,0,'2b5b4c4c6ffb4c99ec81c39cfbbcd876',27,''),
(29,1,'files/Templates/Sticky notes.whiteboard','72309dacd55c6de379c738caf18d84c4',10,'Sticky notes.whiteboard',13,3,45778,1777790521,1777790521,0,0,'e03d6267d0c60987ca67c2799b7c7f59',27,''),
(30,1,'files/Templates/Readme.md','71fa2e74ab30f39eed525572ccc3bbec',10,'Readme.md',6,5,554,1777790521,1777790521,0,0,'efcd5c716a49cd8ae5ad51c7c1f5c678',27,''),
(31,1,'files/Templates/Business model canvas.whiteboard','1c4e5432621502fa9a668c49b25b81d9',10,'Business model canvas.whiteboard',13,3,30290,1777790521,1777790521,0,0,'82bc2135837ebe9a155e4027c5c39093',27,''),
(32,1,'files/Templates/Impact effort.whiteboard','071dbd5231cfcb493fa2fcc4a763be05',10,'Impact effort.whiteboard',13,3,30671,1777790521,1777790521,0,0,'d4a151aa16ee96ea48f7ef66ef413187',27,''),
(33,1,'files/Templates/Brainstorming.whiteboard','aa2d36938cf5c1f41813d1e8bbd3ae00',10,'Brainstorming.whiteboard',13,3,30780,1777790521,1777790521,0,0,'9fadb9e491a7713597473b6765e9a863',27,''),
(34,1,'files/Templates/Meeting notes.md','c0279758bb570afdcdbc2471b2f16285',10,'Meeting notes.md',6,5,326,1777790521,1777790521,0,0,'7332418353ca434f13cda3fbfb605a09',27,''),
(35,1,'files/Templates/Letter.odt','15545ade0e9863c98f3a5cc0fbf2836a',10,'Letter.odt',15,3,15961,1777790521,1777790521,0,0,'9578b81a6c730b97789f77bfe7599dc9',27,''),
(36,1,'files/Templates/Flowchart.odg','832942849155883ceddc6f3cede21867',10,'Flowchart.odg',16,3,11836,1777790521,1777790521,0,0,'cf91bface7fe7de2ea94c71e39cf3f66',27,''),
(37,1,'files/Templates/Business model canvas.ods','86c10a47dedf156bf4431cb75e0f76ec',10,'Business model canvas.ods',12,3,29055,1777790522,1777790522,0,0,'233afff8a7d243bc7b7c9742521ca422',27,''),
(38,1,'files/Templates/Invoice.ods','c777e4557c09ad1582c1ce3e2608cdd9',10,'Invoice.ods',12,3,22002,1777790522,1777790522,0,0,'0f10ecfc4dc250626e1a06caa4387289',27,''),
(39,1,'files/Templates/Modern company.odp','96ad2c06ebb6a79bcdf2f4030421dee3',10,'Modern company.odp',14,3,317015,1777790522,1777790522,0,0,'96a79cb34c9cd5f36916941edcb9cae4',27,''),
(40,1,'files/Templates/Report.odt','51fbc02b90f00b6b3c8783ab160938ae',10,'Report.odt',15,3,34163,1777790522,1777790522,0,0,'930acaae963ab059caa90a7905fd91f0',27,''),
(41,1,'files/Templates/Invoice.odt','40fdccb51b6c3e3cf20532e06ed5016e',10,'Invoice.odt',15,3,17276,1777790522,1777790522,0,0,'a4c25c76ae04f8284641204c5a372dc2',27,''),
(42,1,'files/Templates/Gotong royong.odp','14b958f5aafb7cfd703090226f3cbd1b',10,'Gotong royong.odp',14,3,3509628,1777790522,1777790522,0,0,'f312520c18f0fef3e453495ad35ae341',27,''),
(43,1,'files/Templates/Org chart.odg','fd846bc062b158abb99a75a5b33b53e7',10,'Org chart.odg',16,3,13878,1777790522,1777790522,0,0,'9c27df0596d0dc8eb3617fc8548b76e0',27,''),
(44,1,'files/Templates/Resume.odt','ace8f81202eadb2f0c15ba6ecc2539f5',10,'Resume.odt',15,3,17331,1777790522,1777790522,0,0,'4fe584d0ed95b8895b36d9f6ae54c485',27,''),
(45,1,'files/Templates/Expense report.ods','d0a4025621279b95d2f94ff4ec09eab3',10,'Expense report.ods',12,3,19026,1777790522,1777790522,0,0,'3764fd03af2a444837ea2395bf55acc4',27,''),
(46,1,'files/Templates/Mother\'s day.odt','cb66c617dbb4acc9b534ec095c400b53',10,'Mother\'s day.odt',15,3,340061,1777790522,1777790522,0,0,'43d9156f92028b92499ee62f6abfb19b',27,''),
(47,1,'files/Templates/Party invitation.odt','439f95f734be87868374b1a5a312c550',10,'Party invitation.odt',15,3,868111,1777790522,1777790522,0,0,'71d04d95f307cc9040b02eb7765c4a42',27,''),
(48,1,'files/Templates/Mindmap.odg','74cff798fc1b9634ee45380599b2a6da',10,'Mindmap.odg',16,3,13653,1777790522,1777790522,0,0,'211894505a36628dac61ea531342daf6',27,''),
(49,1,'files/Templates/Simple.odp','a2c90ff606d31419d699b0b437969c61',10,'Simple.odp',14,3,14810,1777790522,1777790522,0,0,'6afe836be647ccc4b914360220e118f0',27,''),
(50,1,'files/Templates/Mind map.whiteboard','27c7b4d83fd3526a42122bcacf5dfbe9',10,'Mind map.whiteboard',13,3,35657,1777790522,1777790522,0,0,'f6d8de0a705e88a6643a8377a48940ed',27,''),
(51,1,'files/Templates/Business model canvas.odg','6a8f3e02bdf45c8b0671967969393bcb',10,'Business model canvas.odg',16,3,16988,1777790522,1777790522,0,0,'0e89ac73801c8a8fe9d8f480d32e4e08',27,''),
(52,1,'files/Templates/Checklist.ods','bf1cf0b1734780fa0f93520224ccf706',10,'Checklist.ods',12,3,256849,1777790522,1777790522,0,0,'afe17693fb2c3e66442f2ec6beea3217',27,''),
(53,1,'files/Templates/Meeting agenda.whiteboard','be213da59b99766ceae11e80093803a9',10,'Meeting agenda.whiteboard',13,3,27629,1777790522,1777790522,0,0,'9491094aac46aac50839fa2e2a676aa5',27,''),
(54,1,'files/Templates/Kanban board.whiteboard','174b2766514fef9a88cbb3076e362b4a',10,'Kanban board.whiteboard',13,3,25621,1777790522,1777790522,0,0,'06363840ca936e8a6c53de2b54678834',27,''),
(55,1,'files/Templates/Timesheet.ods','cb79c81e41d3c3c77cd31576dc7f1a3a',10,'Timesheet.ods',12,3,90170,1777790522,1777790522,0,0,'5caf3d5f536f81a7daca40ffe1ab4f18',27,''),
(56,1,'files/Readme.md','49af83716f8dcbfa89aaf835241c0b9f',2,'Readme.md',6,5,197,1777790522,1777790522,0,0,'f22d0106b55a249c6dcd1384df5628a4',27,''),
(57,1,'files/Photos','d01bb67e7b71dd49fd06bad922f521c9',2,'Photos',2,1,5656463,1777790523,1777790523,0,0,'69f6ee3b5bbf6',31,''),
(58,1,'files/Photos/Toucan.jpg','681d1e78f46a233e12ecfa722cbc2aef',57,'Toucan.jpg',17,10,167989,1777790523,1777790523,0,0,'4b9910f87e7a69be67cbe929ccc8b249',27,''),
(59,1,'files/Photos/Gorilla.jpg','6d5f5956d8ff76a5f290cebb56402789',57,'Gorilla.jpg',17,10,474653,1777790523,1777790523,0,0,'8af4a268473d45ccaac31d95fe82dde4',27,''),
(60,1,'files/Photos/Vineyard.jpg','14e5f2670b0817614acd52269d971db8',57,'Vineyard.jpg',17,10,427030,1777790523,1777790523,0,0,'4584cfa4f8e9632d50c7b706a7c50fa3',27,''),
(61,1,'files/Photos/Readme.md','2a4ac36bb841d25d06d164f291ee97db',57,'Readme.md',6,5,150,1777790523,1777790523,0,0,'c25a30813740e3f1c1cbab2b903961e8',27,''),
(62,1,'files/Photos/Birdie.jpg','cd31c7af3a0ec6e15782b5edd2774549',57,'Birdie.jpg',17,10,593508,1777790523,1777790523,0,0,'5deccad4e0755b4af298ac09a2d59007',27,''),
(63,1,'files/Photos/Frog.jpg','d6219add1a9129ed0c1513af985e2081',57,'Frog.jpg',17,10,457744,1777790523,1777790523,0,0,'8e0799197756257013abc937a7833da3',27,''),
(64,1,'files/Photos/Steps.jpg','7b2ca8d05bbad97e00cbf5833d43e912',57,'Steps.jpg',17,10,567689,1777790523,1777790523,0,0,'ffb05665096005870756703ae068a3f8',27,''),
(65,1,'files/Photos/Nextcloud community.jpg','b9b3caef83a2a1c20354b98df6bcd9d0',57,'Nextcloud community.jpg',17,10,797325,1777790523,1777790523,0,0,'9d9ab25d836b3db943efb8a09bfda0a7',27,''),
(66,1,'files/Photos/Library.jpg','0b785d02a19fc00979f82f6b54a05805',57,'Library.jpg',17,10,2170375,1777790523,1777790523,0,0,'66e229bcc113e643cb803533727e3048',27,''),
(67,1,'files/Nextcloud Manual.pdf','2bc58a43566a8edde804a4a97a9c7469',2,'Nextcloud Manual.pdf',7,3,27397533,1777790523,1777790523,0,0,'77c54e00b036b1936323f81c08878468',27,''),
(68,1,'files/Reasons to use Nextcloud.pdf','418b19142a61c5bef296ea56ee144ca3',2,'Reasons to use Nextcloud.pdf',7,3,976625,1777790523,1777790523,0,0,'2abba9ddd33597850184f27a650e55ea',27,''),
(69,1,'files/Templates credits.md','f7c01e3e0b55bb895e09dc08d19375b3',2,'Templates credits.md',6,5,3168,1777790523,1777790523,0,0,'f51c5196a886cb191d4dfe9eee9c1885',27,''),
(70,2,'','d41d8cd98f00b204e9800998ecf8427e',-1,'',2,1,-1,1777790523,1777790523,0,0,'69f6ee3bc4c59',23,''),
(71,2,'appdata_oc0mxdaizlw5','4ee4e97b083489be4cc23698f9d548fe',70,'appdata_oc0mxdaizlw5',2,1,0,1777790597,1777790597,0,0,'69f6ee3bc4a60',31,''),
(72,2,'appdata_oc0mxdaizlw5/dav','04c4eccc537c0986f52fef2e85f3d974',71,'dav',2,1,0,1777790523,1777790523,0,0,'69f6ee3bc67e0',31,''),
(73,2,'appdata_oc0mxdaizlw5/dav/defaultContact','e3eb836535c97e1d744a25626287cf58',72,'defaultContact',2,1,0,1777790523,1777790523,0,0,'69f6ee3bc786c',31,''),
(74,2,'appdata_oc0mxdaizlw5/dav/defaultContact/defaultContact.vcf','f5ae6734aca5de3af56378bd347bb832',73,'defaultContact.vcf',18,5,269311,1777790523,1777790523,0,0,'e0cf4b4d2dd82ce8697d0487931a06e4',27,''),
(75,2,'appdata_oc0mxdaizlw5/js','485f43101b670c12364b22c69aa66c20',71,'js',2,1,0,1777790536,1777790536,0,0,'69f6ee4850939',31,''),
(76,2,'appdata_oc0mxdaizlw5/js/core','139944cdcb0220e98ecc719f8a4987c1',75,'core',2,1,0,1777790536,1777790536,0,0,'69f6ee4851f63',31,''),
(77,2,'appdata_oc0mxdaizlw5/js/core/merged-template-prepend.js','72267601d1348b62f114ebbe8d5b32d1',76,'merged-template-prepend.js',19,3,16186,1777790536,1777790536,0,0,'29432e5c89401867e96ed963f74dffa3',27,''),
(78,2,'appdata_oc0mxdaizlw5/js/core/merged-template-prepend.js.deps','211cfc2d1a4cf7d56ca859cc148ff5ed',76,'merged-template-prepend.js.deps',20,3,232,1777790536,1777790536,0,0,'2a9aa23d537dbce62a527bfb3e702715',27,''),
(79,2,'appdata_oc0mxdaizlw5/js/core/merged-template-prepend.js.gzip','375402b27fb930cf8643f197a3cd8aa5',76,'merged-template-prepend.js.gzip',21,3,3317,1777790536,1777790536,0,0,'4207246cc9e501b83a70d59450c773fb',27,''),
(80,2,'appdata_oc0mxdaizlw5/theming','97c021d2a0805d9d3ada722f385a8488',71,'theming',2,1,0,1777790536,1777790536,0,0,'69f6ee485bfb0',31,''),
(81,2,'appdata_oc0mxdaizlw5/theming/global','06837f682bcfd44ffed63281d213fc32',80,'global',2,1,0,1777790557,1777790557,0,0,'69f6ee485d0f7',31,''),
(82,2,'appdata_oc0mxdaizlw5/appstore','88729541c7622ec1c5c21b0a4bf07e0d',71,'appstore',2,1,0,1777798609,1777798609,0,0,'69f6ee4ab4d21',31,''),
(83,2,'appdata_oc0mxdaizlw5/appstore/apps.json','7849927114df95396619782dd8619934',82,'apps.json',22,3,3304347,1777798604,1777798604,0,0,'1e6a7e4cdb83462fed22c2e3c82d4bfa',27,''),
(84,2,'appdata_oc0mxdaizlw5/theming/global/0','c1c379f71210febae477430f19d87157',81,'0',2,1,0,1777790557,1777790557,0,0,'69f6ee5d0abe0',31,''),
(85,2,'appdata_oc0mxdaizlw5/theming/global/0/icon-core-#00679efiletypes_image.svg','8751a3bef95c1f6c5fe358dcdb44b85a',84,'icon-core-#00679efiletypes_image.svg',23,10,705,1777790557,1777790557,0,0,'688ecfc8afc74151209c8c8f3744d676',27,''),
(86,2,'appdata_oc0mxdaizlw5/theming/global/0/icon-core-#00679efiletypes_text.svg','1cd071205858e357f15078ad21f414e8',84,'icon-core-#00679efiletypes_text.svg',23,10,299,1777790557,1777790557,0,0,'4e0fa2362312cf1dc2ff4ce3d8fe505f',27,''),
(87,2,'appdata_oc0mxdaizlw5/avatar','fd761cc9c0acd12722520f7d9281f523',71,'avatar',2,1,0,1777790557,1777790557,0,0,'69f6ee5d7ad2f',31,''),
(88,2,'appdata_oc0mxdaizlw5/avatar/admin','895be482d6d7db9c1c1ae410009a172d',87,'admin',2,1,0,1777790557,1777790557,0,0,'69f6ee5d7c16d',31,''),
(89,2,'appdata_oc0mxdaizlw5/avatar/admin/avatar-dark.png','52a96d5775353e711cbdb36d96aaf7aa',88,'avatar-dark.png',11,10,15938,1777790557,1777790557,0,0,'686101028d99ce7847d4c3af36da48b8',27,''),
(90,2,'appdata_oc0mxdaizlw5/avatar/admin/generated','85e6acd72234e43ae84b1d4909927506',88,'generated',20,3,0,1777790557,1777790557,0,0,'0603bc2d3501351ddaafa768dfe8ac7a',27,''),
(91,2,'appdata_oc0mxdaizlw5/avatar/admin/avatar-dark.512.png','bbaec8adf004d62ba496679ceedca7c5',88,'avatar-dark.512.png',11,10,6633,1777790557,1777790557,0,0,'0a369dad338719f11d59253d4f7d22e4',27,''),
(92,2,'appdata_oc0mxdaizlw5/identityproof','436b6e1f40710e135c9f0e93fb7b6534',71,'identityproof',2,1,0,1777790597,1777790597,0,0,'69f6ee85b0a18',31,''),
(93,2,'appdata_oc0mxdaizlw5/identityproof/app-core-ocm_external','8e5b5fc941778c8d6e2e7f5a906b9215',92,'app-core-ocm_external',2,1,0,1777790597,1777790597,0,0,'69f6ee85b25d9',31,''),
(94,2,'appdata_oc0mxdaizlw5/identityproof/app-core-ocm_external/private','3f114379de3275c3032215540c52b50b',93,'private',20,3,3588,1777790597,1777790597,0,0,'05a66d65b5307fc7ce5ad4bc215c48ef',27,''),
(95,2,'appdata_oc0mxdaizlw5/identityproof/app-core-ocm_external/public','b2b0950091918e3c0727ae793b6c744f',93,'public',20,3,451,1777790597,1777790597,0,0,'a3d3b5736d3f159c1a9da389042df2b9',27,''),
(96,1,'cache','0fea6a13c52b4d4725368f24b045ca84',1,'cache',2,1,0,1777797332,1777797332,0,0,'69f708d459e77',31,''),
(97,2,'appdata_oc0mxdaizlw5/appstore/appapi_apps.json','170ee6657f4d298de45721a4a0d6a43d',82,'appapi_apps.json',22,3,94935,1777798606,1777798606,0,0,'9c641ef4eaef871dd966ece76b648013',27,''),
(98,2,'appdata_oc0mxdaizlw5/appstore/discover.json','098d887b2a22d5350bea570038f603c3',82,'discover.json',22,3,7293,1777798608,1777798608,0,0,'28a48842d849a9d53f98f8fb5b586af1',27,''),
(99,2,'appdata_oc0mxdaizlw5/appstore/categories.json','61df8d4bd5d48b114fce3cf41ab10e49',82,'categories.json',22,3,170863,1777798609,1777798609,0,0,'5c36e52b4fcfd4557b2b9bfe35f295b4',27,''),
(100,2,'appdata_oc0mxdaizlw5/appstore/app-discover-cache','9da7579b09e24d1f385a2f988a414fda',82,'app-discover-cache',2,1,0,1777798609,1777798609,0,0,'69f70dd1779fa',31,''),
(101,2,'appdata_oc0mxdaizlw5/appstore/app-discover-cache/69f70b0d-8bf','368f293cc7ce466b10b826f575175a21',100,'69f70b0d-8bf',2,1,0,1777798610,1777798610,0,0,'69f70dd17a4a4',31,''),
(102,2,'appdata_oc0mxdaizlw5/appstore/app-discover-cache/69f70b0d-8bf/c8834d65c69ee6b39acb6665edc25d5c.YXVkaW8vd2VibQ==.webm','e8e24aace36962bc8a632c66d1c14092',101,'c8834d65c69ee6b39acb6665edc25d5c.YXVkaW8vd2VibQ==.webm',25,8,821961,1777798610,1777798610,0,0,'b72f38605addbb9387576e36cf1c7eac',27,''),
(103,2,'appdata_oc0mxdaizlw5/appstore/app-discover-cache/69f70b0d-8bf/933b36972157bd0b16d3408609be3337.aW1hZ2UvcG5n.png','d47a437172f075eea2807fec03be8942',101,'933b36972157bd0b16d3408609be3337.aW1hZ2UvcG5n.png',11,10,573971,1777798610,1777798610,0,0,'6cccea599191d0836e030006853ff3f5',27,''),
(104,2,'appdata_oc0mxdaizlw5/appstore/app-discover-cache/69f70b0d-8bf/ac17c3a942d58047e5c767339f0d7dc7.aW1hZ2UvcG5n.png','5c41e00ed7d44337d44079f9aaf9f736',101,'ac17c3a942d58047e5c767339f0d7dc7.aW1hZ2UvcG5n.png',11,10,495792,1777798610,1777798610,0,0,'44f75c0db669a2bcb972ed9b25110c54',27,''),
(105,3,'','d41d8cd98f00b204e9800998ecf8427e',-1,'',2,1,0,0,0,0,0,'',31,''),
(106,4,'','d41d8cd98f00b204e9800998ecf8427e',-1,'',2,1,6196500,1777981205,1777846455,0,0,'69f9d71554cb4',31,NULL),
(107,5,'','d41d8cd98f00b204e9800998ecf8427e',-1,'',2,1,55207,1777799887,1777799887,0,55207,'69f712cfe35be',31,NULL),
(108,5,'appdata_oc0mxdaizlw5','4ee4e97b083489be4cc23698f9d548fe',107,'appdata_oc0mxdaizlw5',2,1,55207,1777799887,1777799887,0,55207,'69f712cfe4217',31,NULL),
(109,5,'appdata_oc0mxdaizlw5/theming','97c021d2a0805d9d3ada722f385a8488',108,'theming',2,1,0,1777799887,1777799887,0,0,'69f712cfe643d',31,NULL),
(110,5,'appdata_oc0mxdaizlw5/theming/global','06837f682bcfd44ffed63281d213fc32',109,'global',2,1,0,1777799887,1777799887,0,0,'69f712cfe7d12',31,NULL),
(111,5,'appdata_oc0mxdaizlw5/js','485f43101b670c12364b22c69aa66c20',108,'js',2,1,0,1777800389,1777800389,0,0,'69f714c51f160',31,NULL),
(112,5,'appdata_oc0mxdaizlw5/js/core','139944cdcb0220e98ecc719f8a4987c1',111,'core',2,1,0,1777800389,1777800389,0,0,'69f714c5201b5',31,NULL),
(116,4,'files','45b963397aa40d4a0063e0d85e4fe7a1',106,'files',2,1,0,1777810143,1777810093,0,0,'69f73adf644e9',31,NULL),
(117,4,'files_trashbin/files/sydneytools.png.d1777810093','adf66c63e72b718eb12a8d8aa26824f2',137,'sydneytools.png.d1777810093',11,10,76521,1748685459,1748685459,0,0,'69f7154189f2e',27,''),
(118,4,'files_trashbin/files/Pizza.pdf.d1777810093','a807c9d599c08eb86a1226b5a8dcab1b',137,'Pizza.pdf.d1777810093',7,3,4105411,1645696499,1645696499,0,0,'69f7157eae330',27,''),
(119,5,'appdata_oc0mxdaizlw5/identityproof','436b6e1f40710e135c9f0e93fb7b6534',108,'identityproof',2,1,4039,1777808675,1777808675,0,4039,'69f73523bbd15',31,NULL),
(120,5,'appdata_oc0mxdaizlw5/identityproof/app-core-ocm_external','8e5b5fc941778c8d6e2e7f5a906b9215',119,'app-core-ocm_external',2,1,4039,1777808675,1777808675,0,4039,'69f73523bdb5b',31,NULL),
(121,5,'appdata_oc0mxdaizlw5/identityproof/app-core-ocm_external/private','3f114379de3275c3032215540c52b50b',120,'private',20,3,3588,1777982769,1777982769,0,3588,'69f9dd314d595',27,''),
(122,5,'appdata_oc0mxdaizlw5/identityproof/app-core-ocm_external/public','b2b0950091918e3c0727ae793b6c744f',120,'public',20,3,451,1777982769,1777982769,0,451,'69f9dd31cb748',27,''),
(123,6,'','d41d8cd98f00b204e9800998ecf8427e',-1,'',2,1,6229976,1777846465,1777846464,0,0,'69f7c8c12ab98',31,''),
(124,4,'files_trashbin/files/uri:oid:preview:79558804574232576.d1777846440','f9e2094a0fbc1d2d1e549207477ad74e',137,'uri:oid:preview:79558804574232576.d1777846440',20,3,84619,1777800529,1777800529,0,0,'6cc32e131a9dc2e0a52c7c9af5ebb3fa',27,''),
(125,6,'uri:oid:preview:79558812933480448','50afe5849bc68ed611e72787c730762b',123,'uri:oid:preview:79558812933480448',20,3,4107,1777800530,1777800530,0,0,'f098047fc85643e7b50643d8741c2367',27,''),
(126,6,'urn:oid:113','cc514dcbc977be0be941e890d82f93fd',123,'urn:oid:113',20,3,16186,1777800390,1777800390,0,0,'91c8a7dd99b430e1d603c761251b86bf',27,''),
(127,6,'urn:oid:114','09cfb32f7c6014a77b34504089b8daa6',123,'urn:oid:114',20,3,232,1777800391,1777800391,0,0,'24bc87ff52a6b7bbc573b3907ad713d2',27,''),
(128,6,'urn:oid:115','079f4f3ce6e7b1131ada965a31541c67',123,'urn:oid:115',20,3,3317,1777800392,1777800392,0,0,'b5f3d562772a60f844ff6b3dec718338',27,''),
(129,6,'urn:oid:117','b1a5d7df7f29a038c4b1f081dd6805cb',123,'urn:oid:117',20,3,76521,1777800514,1777800514,0,0,'51315caa23054c61b4efdc1cda33b778',27,''),
(130,6,'urn:oid:118','3fe9477dd7624ccdd22f1ba5275948eb',123,'urn:oid:118',20,3,4105411,1777800577,1777800577,0,0,'acd10426aa933c3579593cca464ad5ed',27,''),
(131,4,'files_trashbin/files/urn:oid:121.d1777810111','f21f1bdf10da2665e901d2d3724d2ee9',137,'urn:oid:121.d1777810111',20,3,3588,1777808676,1777808676,0,0,'ebbcb71c0e9f38592ebd90c6f20bf851',27,''),
(132,6,'urn:oid:122','177a262991a34c3a2c32fd7e2243af11',123,'urn:oid:122',20,3,451,1777808677,1777808677,0,0,'3b9c0bfc9f2a7095ecd0d34aef0146e3',27,''),
(133,4,'files_trashbin/files/airship.png.d1777810076','afb632d35019c841fb60ec3018d8247a',137,'airship.png.d1777810076',11,10,905747,1714649273,1714649273,0,0,'69f73a7eafa77',27,''),
(134,4,'files_trashbin/files/uri:oid:preview:79599703614218241.d1777846453','9f58d850ed651abfef0452a362f56081',137,'uri:oid:preview:79599703614218241.d1777846453',20,3,1020614,1777810051,1777810051,0,0,'2aef52bf54f37aa0ffaa0f1f91cc93ba',27,''),
(135,6,'uri:oid:preview:79599714896896001','91c047599da7e13a3fbafee26cbb188c',123,'uri:oid:preview:79599714896896001',20,3,8727,1777810053,1777810053,0,0,'cd85ede425135d26c883c3cfcdc8b609',27,''),
(136,4,'files_trashbin','fb66dca5f27af6f15c1d1d81e6f8d28b',106,'files_trashbin',2,1,6196500,1777846455,1777810076,0,0,'69f7c8b71e28a',31,NULL),
(137,4,'files_trashbin/files','3014a771cbe30761f2e9ff3272110dbf',136,'files',2,1,6196500,1777846455,1777846442,0,0,'69f7c8b71e28a',31,NULL),
(138,4,'files_trashbin/versions','c639d144d3f1014051e14a98beac5705',136,'versions',2,1,0,1777810076,1777810076,0,0,'69f73a9cd5307',31,NULL),
(139,4,'files_trashbin/keys','9195c7cfc1b867f229ac78cc1b6a0be3',136,'keys',2,1,0,1777810076,1777810076,0,0,'69f73a9cd6feb',31,NULL),
(140,6,'urn:oid:133','e0908073cad6ac65e5a98a25e0e4518f',123,'urn:oid:133',20,3,905747,1777810078,1777810078,0,0,'16216053e5afc0b185a4dcbabfc9ec31',27,''),
(141,6,'urn:oid:131','64a53bbad64544af3187f4ae1e48a505',123,'urn:oid:131',20,3,3588,1777810112,1777810112,0,0,'ebbcb71c0e9f38592ebd90c6f20bf851',27,''),
(142,4,'files/Photos','d01bb67e7b71dd49fd06bad922f521c9',116,'Photos',2,1,0,1777810143,1777810143,0,0,'69f73adf62e6b',31,NULL),
(143,5,'appdata_oc0mxdaizlw5/theming/global/0','c1c379f71210febae477430f19d87157',110,'0',2,1,0,1777846406,1777846406,0,0,'69f7c88692b6b',31,NULL),
(144,5,'appdata_oc0mxdaizlw5/theming/global/0/icon-core-#00679efiletypes_file.svg','ec53b573b1264321ad16658045a3d60c',143,'icon-core-#00679efiletypes_file.svg',23,10,456,1777846406,1777846406,0,0,'69f7c88698502',27,''),
(145,6,'urn:oid:144','833e4de80f1efd5ccc6049ed575dada9',123,'urn:oid:144',20,3,456,1777846407,1777846407,0,0,'7cdb99eac32ef1d202d41bec34cef420',27,''),
(146,6,'urn:oid:124','1063d21d64bca4365c4f2a1c1af868fc',123,'urn:oid:124',20,3,84619,1777846441,1777846441,0,0,'6cc32e131a9dc2e0a52c7c9af5ebb3fa',27,''),
(147,6,'urn:oid:134','c6f8349c82d267b7c0dfb75605c3b08e',123,'urn:oid:134',20,3,1020614,1777846454,1777846454,0,0,'2aef52bf54f37aa0ffaa0f1f91cc93ba',27,''),
(148,5,'appdata_oc0mxdaizlw5/theming/global/0/icon-core-#00679efiletypes_application-pdf.svg','b1d683576da9cf2d89c9215a26471c50',143,'icon-core-#00679efiletypes_application-pdf.svg',23,10,468,1777846477,1777846477,0,0,'69f7c8cdd5657',27,''),
(149,5,'appdata_oc0mxdaizlw5/theming/global/0/icon-core-#00679efiletypes_folder.svg','0112eeac17c16a53673f23ba783d237a',143,'icon-core-#00679efiletypes_folder.svg',23,10,507,1777846477,1777846477,0,0,'69f7c8cdd57f6',27,''),
(153,5,'appdata_oc0mxdaizlw5/avatar','fd761cc9c0acd12722520f7d9281f523',108,'avatar',2,1,51168,1777856488,1777856488,0,0,'69f7efe8a903f',31,NULL),
(154,5,'appdata_oc0mxdaizlw5/avatar/fluencyhub','4f9411e22cb718780892fabeafc7e645',153,'fluencyhub',2,1,13140,1777856488,1777856488,0,0,'69f7efe8aad88',31,NULL),
(158,5,'appdata_oc0mxdaizlw5/avatar/fluencyhub/avatar.png','3e3ab7cc9bafa200639098c3de4bd6c5',154,'avatar.png',11,10,5524,1777856492,1777856492,0,0,'69f7efec7b0ee',27,''),
(159,5,'appdata_oc0mxdaizlw5/avatar/fluencyhub/generated','74a9a9294360a208d5fc2f0bfa8f178a',154,'generated',20,3,0,1777856497,1777856497,0,0,'69f7eff1c97c9',27,''),
(160,5,'appdata_oc0mxdaizlw5/avatar/fluencyhub/avatar.512.png','db050d01dc1accb8a8845c63ccdfcf44',154,'avatar.512.png',11,10,2077,1777856493,1777856493,0,0,'69f7efedb7255',27,''),
(161,7,'','d41d8cd98f00b204e9800998ecf8427e',-1,'',2,1,0,1777856578,1777856496,0,0,'69f7f0425bb66',31,NULL),
(162,7,'files','45b963397aa40d4a0063e0d85e4fe7a1',161,'files',2,1,0,1777856496,1777856496,0,0,'69f7eff0821d7',31,NULL),
(163,5,'appdata_oc0mxdaizlw5/avatar/fluencyhub/avatar-dark.png','a6ea76a7b87ea1bc223b3b597c844f05',154,'avatar-dark.png',11,10,5539,1777856497,1777856497,0,0,'69f7eff123fde',27,''),
(164,5,'appdata_oc0mxdaizlw5/avatar/fluencyhub/avatar-dark.512.png','979c00ff8de1ee64cce5214d7ac16642',154,'avatar-dark.512.png',11,10,2091,1777856498,1777856498,0,0,'69f7eff20e31e',27,''),
(165,7,'cache','0fea6a13c52b4d4725368f24b045ca84',161,'cache',2,1,0,1777856578,1777856578,0,0,'69f7f0425b001',31,NULL),
(166,5,'appdata_oc0mxdaizlw5/avatar/fluencyhub/avatar.64.png','928710e2fc4e2f3c3fec7b7cb6ae7966',154,'avatar.64.png',11,10,328,1777856616,1777856616,0,0,'69f7f06846094',27,''),
(167,5,'appdata_oc0mxdaizlw5/avatar/admin','895be482d6d7db9c1c1ae410009a172d',153,'admin',2,1,38028,1777857137,1777857137,0,0,'69f7f2717809e',31,NULL),
(168,5,'appdata_oc0mxdaizlw5/avatar/admin/avatar.png','eed57f6612e50b179f9f1c7410cefb45',167,'avatar.png',11,10,15643,1777857137,1777857137,0,0,'69f7f27185298',27,''),
(169,5,'appdata_oc0mxdaizlw5/avatar/admin/generated','85e6acd72234e43ae84b1d4909927506',167,'generated',20,3,0,1777982264,1777982264,0,0,'69f9db38043a8',27,''),
(170,5,'appdata_oc0mxdaizlw5/avatar/admin/avatar.512.png','bcf0cad8055fa643bd0e59ace3a56458',167,'avatar.512.png',11,10,6447,1777857139,1777857139,0,0,'69f7f2730348a',27,''),
(171,5,'appdata_oc0mxdaizlw5/appstore','88729541c7622ec1c5c21b0a4bf07e0d',108,'appstore',2,1,0,1777868892,1777868892,0,0,'69f8205c6ab7a',31,NULL),
(172,5,'appdata_oc0mxdaizlw5/appstore/apps.json','7849927114df95396619782dd8619934',171,'apps.json',22,3,3356912,1777868896,1777868896,0,0,'69f820603ccf5',27,''),
(173,5,'appdata_oc0mxdaizlw5/appstore/appapi_apps.json','170ee6657f4d298de45721a4a0d6a43d',171,'appapi_apps.json',22,3,94935,1777868900,1777868900,0,0,'69f82064574cc',27,''),
(174,5,'appdata_oc0mxdaizlw5/appstore/categories.json','61df8d4bd5d48b114fce3cf41ab10e49',171,'categories.json',22,3,170863,1777868904,1777868904,0,0,'69f82068e3ec1',27,''),
(175,5,'appdata_oc0mxdaizlw5/appstore/discover.json','098d887b2a22d5350bea570038f603c3',171,'discover.json',22,3,7293,1777868905,1777868905,0,0,'69f820695e0d5',27,''),
(176,4,'cache','0fea6a13c52b4d4725368f24b045ca84',106,'cache',2,1,0,1777981205,1777981205,0,0,'69f9d7154f9bb',31,NULL),
(180,5,'appdata_oc0mxdaizlw5/avatar/admin/avatar-dark.png','52a96d5775353e711cbdb36d96aaf7aa',167,'avatar-dark.png',11,10,15938,1777982263,1777982263,0,0,'69f9db37540b9',27,''),
(181,5,'appdata_oc0mxdaizlw5/avatar/admin/avatar-dark.512.png','bbaec8adf004d62ba496679ceedca7c5',167,'avatar-dark.512.png',11,10,6633,1777982264,1777982264,0,0,'69f9db383a227',27,''),
(182,5,'appdata_oc0mxdaizlw5/js/core/merged-template-prepend.js','72267601d1348b62f114ebbe8d5b32d1',112,'merged-template-prepend.js',19,3,16186,1777982761,1777982761,0,0,'69f9dd29c7036',27,''),
(183,5,'appdata_oc0mxdaizlw5/js/core/merged-template-prepend.js.deps','211cfc2d1a4cf7d56ca859cc148ff5ed',112,'merged-template-prepend.js.deps',20,3,232,1777982762,1777982762,0,0,'69f9dd2a8b83f',27,''),
(184,5,'appdata_oc0mxdaizlw5/js/core/merged-template-prepend.js.gzip','375402b27fb930cf8643f197a3cd8aa5',112,'merged-template-prepend.js.gzip',21,3,3317,1777982763,1777982763,0,0,'69f9dd2b3cba7',27,''),
(185,5,'appdata_oc0mxdaizlw5/avatar/admin/avatar.64.png','07163005e395c8cf40d529194a2f36c2',167,'avatar.64.png',11,10,792,1778989799,1778989799,0,0,'6a093ae7942c7',27,''),
(186,5,'appdata_oc0mxdaizlw5/dav-photocache','82bc4cc80ce8d4b4bdb5732f6c361e66',108,'dav-photocache',2,1,0,1778989810,1778989810,0,0,'6a093af23c143',31,NULL),
(188,5,'appdata_oc0mxdaizlw5/dav-photocache/cc2ac829e1f7dfdf22a8ed14215fac9e','25798f884010a752bf18c729860cd591',186,'cc2ac829e1f7dfdf22a8ed14215fac9e',2,1,0,1778989810,1778989810,0,0,'6a093af23d0f0',31,NULL),
(189,5,'appdata_oc0mxdaizlw5/dav-photocache/cc2ac829e1f7dfdf22a8ed14215fac9e/photo.png','49492442916c528904a84b1838f4e59d',188,'photo.png',11,10,7256,1778989810,1778989810,0,0,'6a093af23e942',27,''),
(190,5,'appdata_oc0mxdaizlw5/dav-photocache/a69b7e9ffdab98b3cb80c7775bb6ce31','d380dec2f012314f169bec7d041b7040',186,'a69b7e9ffdab98b3cb80c7775bb6ce31',2,1,0,1778989810,1778989810,0,0,'6a093af2408f1',31,NULL),
(191,5,'appdata_oc0mxdaizlw5/dav-photocache/a69b7e9ffdab98b3cb80c7775bb6ce31/photo.png','d8d8d3b02cd795b74655a5296f25aa07',190,'photo.png',11,10,2409,1778989810,1778989810,0,0,'6a093af2420aa',27,'');

--
-- Table structure for table `oc_filecache_extended`
--

CREATE TABLE `oc_filecache_extended` (
  `fileid` bigint(20) unsigned NOT NULL,
  `metadata_etag` varchar(40) DEFAULT NULL,
  `creation_time` bigint(20) NOT NULL DEFAULT 0,
  `upload_time` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`fileid`),
  KEY `fce_ctime_idx` (`creation_time`),
  KEY `fce_utime_idx` (`upload_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_filecache_extended`
--

INSERT INTO `oc_filecache_extended` VALUES
(4,NULL,1777790519,0),
(5,NULL,1777790519,0),
(6,NULL,1777790519,0),
(7,NULL,1777790519,0),
(8,NULL,1777790520,0),
(9,NULL,1777790520,0),
(11,NULL,1777790520,0),
(12,NULL,1777790520,0),
(13,NULL,1777790520,0),
(14,NULL,1777790520,0),
(15,NULL,1777790520,0),
(16,NULL,1777790520,0),
(17,NULL,1777790520,0),
(18,NULL,1777790520,0),
(19,NULL,1777790520,0),
(20,NULL,1777790520,0),
(21,NULL,1777790520,0),
(22,NULL,1777790520,0),
(23,NULL,1777790520,0),
(24,NULL,1777790520,0),
(25,NULL,1777790520,0),
(26,NULL,1777790521,0),
(27,NULL,1777790521,0),
(28,NULL,1777790521,0),
(29,NULL,1777790521,0),
(30,NULL,1777790521,0),
(31,NULL,1777790521,0),
(32,NULL,1777790521,0),
(33,NULL,1777790521,0),
(34,NULL,1777790521,0),
(35,NULL,1777790521,0),
(36,NULL,1777790522,0),
(37,NULL,1777790522,0),
(38,NULL,1777790522,0),
(39,NULL,1777790522,0),
(40,NULL,1777790522,0),
(41,NULL,1777790522,0),
(42,NULL,1777790522,0),
(43,NULL,1777790522,0),
(44,NULL,1777790522,0),
(45,NULL,1777790522,0),
(46,NULL,1777790522,0),
(47,NULL,1777790522,0),
(48,NULL,1777790522,0),
(49,NULL,1777790522,0),
(50,NULL,1777790522,0),
(51,NULL,1777790522,0),
(52,NULL,1777790522,0),
(53,NULL,1777790522,0),
(54,NULL,1777790522,0),
(55,NULL,1777790522,0),
(56,NULL,1777790523,0),
(58,NULL,1777790523,0),
(59,NULL,1777790523,0),
(60,NULL,1777790523,0),
(61,NULL,1777790523,0),
(62,NULL,1777790523,0),
(63,NULL,1777790523,0),
(64,NULL,1777790523,0),
(65,NULL,1777790523,0),
(66,NULL,1777790523,0),
(67,NULL,1777790523,0),
(68,NULL,1777790523,0),
(69,NULL,1777790523,0),
(74,NULL,1777790523,0),
(77,NULL,1777790536,0),
(78,NULL,1777790536,0),
(79,NULL,1777790536,0),
(83,NULL,1777790542,0),
(85,NULL,1777790557,0),
(86,NULL,1777790557,0),
(89,NULL,1777790557,0),
(90,NULL,1777790557,0),
(91,NULL,1777790557,0),
(94,NULL,1777790597,0),
(95,NULL,1777790597,0),
(97,NULL,1777798606,0),
(98,NULL,1777798608,0),
(99,NULL,1777798609,0),
(102,NULL,1777798610,0),
(103,NULL,1777798610,0),
(104,NULL,1777798610,0),
(117,NULL,0,1777800515),
(118,NULL,0,1777800577),
(121,NULL,1777982769,0),
(122,NULL,1777982770,0),
(133,NULL,0,1777810046),
(144,NULL,1777846407,0),
(148,NULL,1777846478,0),
(149,NULL,1777846478,0),
(158,NULL,1777856493,0),
(159,NULL,1777856498,0),
(160,NULL,1777856494,0),
(163,NULL,1777856497,0),
(164,NULL,1777856498,0),
(166,NULL,1777856617,0),
(168,NULL,1777857138,0),
(169,NULL,1777982264,0),
(170,NULL,1777857139,0),
(172,NULL,1777868898,0),
(173,NULL,1777868901,0),
(174,NULL,1777868905,0),
(175,NULL,1777868906,0),
(180,NULL,1777982264,0),
(181,NULL,1777982265,0),
(182,NULL,1777982762,0),
(183,NULL,1777982763,0),
(184,NULL,1777982763,0),
(185,NULL,1778989800,0),
(189,NULL,1778989811,0),
(191,NULL,1778989810,0);

--
-- Table structure for table `oc_files_metadata`
--

CREATE TABLE `oc_files_metadata` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `file_id` bigint(20) NOT NULL,
  `json` longtext NOT NULL,
  `sync_token` varchar(15) NOT NULL,
  `last_update` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `files_meta_fileid` (`file_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_files_metadata`
--

INSERT INTO `oc_files_metadata` VALUES
(1,8,'{\"photos-original_date_time\":{\"value\":1777790519,\"type\":\"int\",\"etag\":\"\",\"indexed\":true,\"editPermission\":0}}','uWrvJQN','2026-05-03 16:42:00'),
(2,9,'{\"photos-size\":{\"value\":{\"width\":500,\"height\":500},\"type\":\"array\",\"etag\":\"\",\"indexed\":false,\"editPermission\":0},\"photos-original_date_time\":{\"value\":1777790520,\"type\":\"int\",\"etag\":\"\",\"indexed\":true,\"editPermission\":0}}','Ws4Uafx','2026-05-03 16:42:00'),
(3,58,'{\"photos-size\":{\"value\":{\"width\":1600,\"height\":1067},\"type\":\"array\",\"etag\":\"\",\"indexed\":false,\"editPermission\":0},\"photos-original_date_time\":{\"value\":1777790523,\"type\":\"int\",\"etag\":\"\",\"indexed\":true,\"editPermission\":0}}','gqzcmBm','2026-05-03 16:42:03'),
(4,59,'{\"photos-size\":{\"value\":{\"width\":1600,\"height\":1067},\"type\":\"array\",\"etag\":\"\",\"indexed\":false,\"editPermission\":0},\"photos-original_date_time\":{\"value\":1777790523,\"type\":\"int\",\"etag\":\"\",\"indexed\":true,\"editPermission\":0}}','nGoUcoo','2026-05-03 16:42:03'),
(5,60,'{\"photos-size\":{\"value\":{\"width\":1920,\"height\":1281},\"type\":\"array\",\"etag\":\"\",\"indexed\":false,\"editPermission\":0},\"photos-original_date_time\":{\"value\":1777790523,\"type\":\"int\",\"etag\":\"\",\"indexed\":true,\"editPermission\":0}}','F5x8E7b','2026-05-03 16:42:03'),
(6,62,'{\"photos-size\":{\"value\":{\"width\":1600,\"height\":1067},\"type\":\"array\",\"etag\":\"\",\"indexed\":false,\"editPermission\":0},\"photos-original_date_time\":{\"value\":1777790523,\"type\":\"int\",\"etag\":\"\",\"indexed\":true,\"editPermission\":0}}','qpqWu7U','2026-05-03 16:42:03'),
(7,63,'{\"photos-size\":{\"value\":{\"width\":1600,\"height\":1067},\"type\":\"array\",\"etag\":\"\",\"indexed\":false,\"editPermission\":0},\"photos-original_date_time\":{\"value\":1777790523,\"type\":\"int\",\"etag\":\"\",\"indexed\":true,\"editPermission\":0}}','sLQuF8o','2026-05-03 16:42:03'),
(8,64,'{\"photos-size\":{\"value\":{\"width\":1200,\"height\":1800},\"type\":\"array\",\"etag\":\"\",\"indexed\":false,\"editPermission\":0},\"photos-original_date_time\":{\"value\":1777790523,\"type\":\"int\",\"etag\":\"\",\"indexed\":true,\"editPermission\":0}}','8fwxda6','2026-05-03 16:42:03'),
(9,65,'{\"photos-size\":{\"value\":{\"width\":3000,\"height\":2000},\"type\":\"array\",\"etag\":\"\",\"indexed\":false,\"editPermission\":0},\"photos-original_date_time\":{\"value\":1777790523,\"type\":\"int\",\"etag\":\"\",\"indexed\":true,\"editPermission\":0}}','SxgWsTO','2026-05-03 16:42:03'),
(10,66,'{\"photos-size\":{\"value\":{\"width\":1600,\"height\":1066},\"type\":\"array\",\"etag\":\"\",\"indexed\":false,\"editPermission\":0},\"photos-original_date_time\":{\"value\":1777790523,\"type\":\"int\",\"etag\":\"\",\"indexed\":true,\"editPermission\":0}}','UrROj1r','2026-05-03 16:42:03');

--
-- Table structure for table `oc_files_metadata_index`
--

CREATE TABLE `oc_files_metadata_index` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `file_id` bigint(20) NOT NULL,
  `meta_key` varchar(31) DEFAULT NULL,
  `meta_value_string` varchar(63) DEFAULT NULL,
  `meta_value_int` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `f_meta_index` (`file_id`,`meta_key`,`meta_value_string`),
  KEY `f_meta_index_i` (`file_id`,`meta_key`,`meta_value_int`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_files_metadata_index`
--

INSERT INTO `oc_files_metadata_index` VALUES
(1,8,'photos-original_date_time',NULL,1777790519),
(2,9,'photos-original_date_time',NULL,1777790520),
(3,58,'photos-original_date_time',NULL,1777790523),
(4,59,'photos-original_date_time',NULL,1777790523),
(5,60,'photos-original_date_time',NULL,1777790523),
(6,62,'photos-original_date_time',NULL,1777790523),
(7,63,'photos-original_date_time',NULL,1777790523),
(8,64,'photos-original_date_time',NULL,1777790523),
(9,65,'photos-original_date_time',NULL,1777790523),
(10,66,'photos-original_date_time',NULL,1777790523);

--
-- Table structure for table `oc_files_reminders`
--

CREATE TABLE `oc_files_reminders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) NOT NULL,
  `file_id` bigint(20) unsigned NOT NULL,
  `due_date` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  `notified` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `reminders_uniq_idx` (`user_id`,`file_id`,`due_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_files_reminders`
--


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

CREATE TABLE `oc_files_trash` (
  `auto_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `id` varchar(250) NOT NULL DEFAULT '',
  `user` varchar(64) NOT NULL DEFAULT '',
  `timestamp` varchar(12) NOT NULL DEFAULT '',
  `location` varchar(512) NOT NULL DEFAULT '',
  `type` varchar(4) DEFAULT NULL,
  `mime` varchar(255) DEFAULT NULL,
  `deleted_by` varchar(64) 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,'airship.png','admin','1777810076','Cloud drive',NULL,NULL,'admin'),
(2,'Pizza.pdf','admin','1777810093','.',NULL,NULL,'admin'),
(3,'sydneytools.png','admin','1777810093','.',NULL,NULL,'admin'),
(4,'urn:oid:121','admin','1777810111','Cloud drive',NULL,NULL,'admin'),
(5,'uri:oid:preview:79558804574232576','admin','1777846440','Cloud drive',NULL,NULL,'admin'),
(6,'uri:oid:preview:79599703614218241','admin','1777846453','Cloud drive',NULL,NULL,'admin');

--
-- Table structure for table `oc_files_versions`
--

CREATE TABLE `oc_files_versions` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `file_id` bigint(20) NOT NULL,
  `timestamp` bigint(20) NOT NULL,
  `size` bigint(20) NOT NULL,
  `mimetype` bigint(20) NOT NULL,
  `metadata` longtext NOT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`metadata`)),
  PRIMARY KEY (`id`),
  UNIQUE KEY `files_versions_uniq_index` (`file_id`,`timestamp`)
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_files_versions`
--

INSERT INTO `oc_files_versions` VALUES
(1,4,1777790519,23876,4,'{\"author\":\"admin\"}'),
(2,5,1777790519,1095,6,'{\"author\":\"admin\"}'),
(3,6,1777790519,136,6,'{\"author\":\"admin\"}'),
(4,7,1777790519,1083339,7,'{\"author\":\"admin\"}'),
(5,8,1777790519,3963036,9,'{\"author\":\"admin\"}'),
(6,9,1777790520,50598,11,'{\"author\":\"admin\"}'),
(7,11,1777790520,13378,12,'{\"author\":\"admin\"}'),
(8,12,1777790520,31132,13,'{\"author\":\"admin\"}'),
(9,13,1777790520,14316,14,'{\"author\":\"admin\"}'),
(10,14,1777790520,32323,15,'{\"author\":\"admin\"}'),
(11,15,1777790520,190107,14,'{\"author\":\"admin\"}'),
(12,16,1777790520,35963,14,'{\"author\":\"admin\"}'),
(13,17,1777790520,35454,14,'{\"author\":\"admin\"}'),
(14,18,1777790520,560887,14,'{\"author\":\"admin\"}'),
(15,19,1777790520,23359,13,'{\"author\":\"admin\"}'),
(16,20,1777790520,31325,13,'{\"author\":\"admin\"}'),
(17,21,1777790520,5155877,15,'{\"author\":\"admin\"}'),
(18,22,1777790520,33089,15,'{\"author\":\"admin\"}'),
(19,23,1777790520,33441,15,'{\"author\":\"admin\"}'),
(20,24,1777790520,22675,15,'{\"author\":\"admin\"}'),
(21,25,1777790520,81196,14,'{\"author\":\"admin\"}'),
(22,26,1777790521,9904434,14,'{\"author\":\"admin\"}'),
(23,27,1777790521,1441424,14,'{\"author\":\"admin\"}'),
(24,28,1777790521,573,6,'{\"author\":\"admin\"}'),
(25,29,1777790521,45778,13,'{\"author\":\"admin\"}'),
(26,30,1777790521,554,6,'{\"author\":\"admin\"}'),
(27,31,1777790521,30290,13,'{\"author\":\"admin\"}'),
(28,32,1777790521,30671,13,'{\"author\":\"admin\"}'),
(29,33,1777790521,30780,13,'{\"author\":\"admin\"}'),
(30,34,1777790521,326,6,'{\"author\":\"admin\"}'),
(31,35,1777790521,15961,15,'{\"author\":\"admin\"}'),
(32,36,1777790521,11836,16,'{\"author\":\"admin\"}'),
(33,37,1777790522,29055,12,'{\"author\":\"admin\"}'),
(34,38,1777790522,22002,12,'{\"author\":\"admin\"}'),
(35,39,1777790522,317015,14,'{\"author\":\"admin\"}'),
(36,40,1777790522,34163,15,'{\"author\":\"admin\"}'),
(37,41,1777790522,17276,15,'{\"author\":\"admin\"}'),
(38,42,1777790522,3509628,14,'{\"author\":\"admin\"}'),
(39,43,1777790522,13878,16,'{\"author\":\"admin\"}'),
(40,44,1777790522,17331,15,'{\"author\":\"admin\"}'),
(41,45,1777790522,19026,12,'{\"author\":\"admin\"}'),
(42,46,1777790522,340061,15,'{\"author\":\"admin\"}'),
(43,47,1777790522,868111,15,'{\"author\":\"admin\"}'),
(44,48,1777790522,13653,16,'{\"author\":\"admin\"}'),
(45,49,1777790522,14810,14,'{\"author\":\"admin\"}'),
(46,50,1777790522,35657,13,'{\"author\":\"admin\"}'),
(47,51,1777790522,16988,16,'{\"author\":\"admin\"}'),
(48,52,1777790522,256849,12,'{\"author\":\"admin\"}'),
(49,53,1777790522,27629,13,'{\"author\":\"admin\"}'),
(50,54,1777790522,25621,13,'{\"author\":\"admin\"}'),
(51,55,1777790522,90170,12,'{\"author\":\"admin\"}'),
(52,56,1777790522,197,6,'{\"author\":\"admin\"}'),
(53,58,1777790523,167989,17,'{\"author\":\"admin\"}'),
(54,59,1777790523,474653,17,'{\"author\":\"admin\"}'),
(55,60,1777790523,427030,17,'{\"author\":\"admin\"}'),
(56,61,1777790523,150,6,'{\"author\":\"admin\"}'),
(57,62,1777790523,593508,17,'{\"author\":\"admin\"}'),
(58,63,1777790523,457744,17,'{\"author\":\"admin\"}'),
(59,64,1777790523,567689,17,'{\"author\":\"admin\"}'),
(60,65,1777790523,797325,17,'{\"author\":\"admin\"}'),
(61,66,1777790523,2170375,17,'{\"author\":\"admin\"}'),
(62,67,1777790523,27397533,7,'{\"author\":\"admin\"}'),
(63,68,1777790523,976625,7,'{\"author\":\"admin\"}'),
(64,69,1777790523,3168,6,'{\"author\":\"admin\"}');

--
-- Table structure for table `oc_flow_checks`
--

CREATE TABLE `oc_flow_checks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `class` varchar(256) NOT NULL DEFAULT '',
  `operator` varchar(16) NOT NULL DEFAULT '',
  `value` longtext DEFAULT NULL,
  `hash` varchar(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `flow_unique_hash` (`hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_flow_checks`
--


--
-- Table structure for table `oc_flow_operations`
--

CREATE TABLE `oc_flow_operations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `class` varchar(256) NOT NULL DEFAULT '',
  `name` varchar(256) DEFAULT '',
  `checks` longtext DEFAULT NULL,
  `operation` longtext DEFAULT NULL,
  `entity` varchar(256) NOT NULL DEFAULT 'OCA\\WorkflowEngine\\Entity\\File',
  `events` longtext NOT NULL DEFAULT '[]',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_flow_operations`
--


--
-- Table structure for table `oc_flow_operations_scope`
--

CREATE TABLE `oc_flow_operations_scope` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `operation_id` int(11) NOT NULL DEFAULT 0,
  `type` int(11) NOT NULL DEFAULT 0,
  `value` varchar(64) DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `flow_unique_scope` (`operation_id`,`type`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_flow_operations_scope`
--


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

CREATE TABLE `oc_group_admin` (
  `gid` varchar(64) NOT NULL DEFAULT '',
  `uid` varchar(64) 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`
--

INSERT INTO `oc_group_admin` VALUES
('staff','fluencyhub');

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

CREATE TABLE `oc_group_user` (
  `gid` varchar(64) NOT NULL DEFAULT '',
  `uid` varchar(64) 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','fluencyhub'),
('staff','fluencyhub');

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

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

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

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

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

CREATE TABLE `oc_jobs` (
  `id` bigint(20) unsigned NOT NULL,
  `class` varchar(255) NOT NULL DEFAULT '',
  `argument` text NOT NULL DEFAULT '',
  `last_run` int(11) DEFAULT 0,
  `last_checked` int(11) DEFAULT 0,
  `reserved_at` int(11) DEFAULT 0,
  `execution_duration` int(11) DEFAULT 0,
  `argument_hash` varchar(64) DEFAULT NULL,
  `time_sensitive` smallint(6) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `job_class_index` (`class`),
  KEY `job_lastcheck_reserved` (`last_checked`,`reserved_at`),
  KEY `job_argument_hash` (`class`,`argument_hash`),
  KEY `jobs_time_sensitive` (`time_sensitive`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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

INSERT INTO `oc_jobs` VALUES
(79515797405753345,'OCA\\Support\\BackgroundJobs\\CheckSubscription','null',1777790538,1777790538,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515798559186945,'OCA\\Notifications\\BackgroundJob\\GenerateUserSettings','null',1777790557,1777790557,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515798567575553,'OCA\\Notifications\\BackgroundJob\\SendNotificationMails','null',1777790596,1777790596,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515800459206657,'OCA\\DAV\\BackgroundJob\\CleanupDirectLinksJob','null',1777790680,1777790680,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',0),
(79515800463400961,'OCA\\DAV\\BackgroundJob\\UpdateCalendarResourcesRoomsBackgroundJob','null',0,1777982665,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515800467595265,'OCA\\DAV\\BackgroundJob\\CleanupInvitationTokenJob','null',1777797612,1777797612,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',0),
(79515800467595266,'OCA\\DAV\\BackgroundJob\\EventReminderJob','null',1777797637,1777797637,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515800471789569,'OCA\\DAV\\BackgroundJob\\CalendarRetentionJob','null',0,1777790515,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515800475983873,'OCA\\DAV\\BackgroundJob\\PruneOutdatedSyncTokensJob','null',0,1777790515,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515800480178177,'OCA\\DAV\\BackgroundJob\\FederatedCalendarPeriodicSyncJob','null',0,1777790515,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515801902047233,'OCA\\Files_Trashbin\\BackgroundJob\\ExpireTrash','null',0,1777790515,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515802501832705,'OCA\\FilesReminders\\BackgroundJob\\CleanUpReminders','null',0,1777790515,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515802506027009,'OCA\\FilesReminders\\BackgroundJob\\ScheduledNotifications','null',0,1777790515,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515803110006785,'OCA\\Files_Versions\\BackgroundJob\\ExpireVersions','null',0,1777790515,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515803751735297,'OCA\\ContactsInteraction\\BackgroundJob\\CleanupJob','null',0,1777790515,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515804414435329,'OCA\\Photos\\Jobs\\AutomaticPlaceMapperJob','null',0,1777790515,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515805223936001,'OCA\\WebhookListeners\\BackgroundJobs\\WebhookTokenCleanup','null',0,1777790516,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515806717108225,'OCA\\Activity\\BackgroundJob\\EmailNotification','null',0,1777790516,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515806721302529,'OCA\\Activity\\BackgroundJob\\ExpireActivities','null',0,1777790516,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515806725496833,'OCA\\Activity\\BackgroundJob\\DigestMail','null',0,1777790516,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515806729691137,'OCA\\Activity\\BackgroundJob\\RemoveFormerActivitySettings','null',0,1777790516,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515806767439873,'OCA\\NextcloudAnnouncements\\Cron\\Crawler','null',0,1777790516,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515807572746241,'OCA\\WorkflowEngine\\BackgroundJobs\\Rotate','null',0,1777790516,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515808474521601,'OCA\\UserStatus\\BackgroundJob\\ClearOldStatusesBackgroundJob','null',0,1777790516,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515809296605185,'OCA\\Federation\\SyncJob','null',0,1777790517,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515809325965313,'OCA\\UpdateNotification\\BackgroundJob\\UpdateAvailableNotifications','null',0,1777790517,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515810244517889,'OCA\\Text\\Cron\\Cleanup','null',0,1777790517,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515812865957889,'OCA\\ServerInfo\\Jobs\\UpdateStorageStats','null',0,1777790517,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515813839036417,'OCA\\OAuth2\\BackgroundJob\\CleanupExpiredAuthorizationCode','null',0,1777790518,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515815248322561,'OCA\\AppAPI\\BackgroundJob\\ExAppInitStatusCheckJob','null',0,1777790518,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515816494030849,'OCA\\Files_Sharing\\DeleteOrphanedSharesJob','null',0,1777790518,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515816498225153,'OCA\\Files_Sharing\\ExpireSharesJob','null',0,1777790518,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515816502419457,'OCA\\Files_Sharing\\SharesReminderJob','null',0,1777790518,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515816502419458,'OCA\\Files_Sharing\\BackgroundJob\\FederatedSharesDiscoverJob','null',0,1777790518,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515817681018881,'OCA\\Files\\BackgroundJob\\ScanFiles','null',0,1777790519,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515817685213185,'OCA\\Files\\BackgroundJob\\DeleteOrphanedItems','null',0,1777790519,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515817689407489,'OCA\\Files\\BackgroundJob\\CleanupFileLocks','null',0,1777790519,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515817693601793,'OCA\\Files\\BackgroundJob\\CleanupDirectEditingTokens','null',0,1777790519,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515817693601794,'OCA\\Files\\BackgroundJob\\DeleteExpiredOpenLocalEditor','null',0,1777790519,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515819031584769,'OCA\\Circles\\Cron\\Maintenance','null',0,1777790519,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515819065139201,'OC\\Authentication\\Token\\TokenCleanupJob','null',0,1777982665,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515819069333505,'OC\\Log\\Rotate','null',0,1777982664,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515819073527809,'OC\\Preview\\BackgroundCleanupJob','null',0,1777982665,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515819077722113,'OC\\TextProcessing\\RemoveOldTasksBackgroundJob','null',0,1777982665,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515819081916417,'OC\\User\\BackgroundJobs\\CleanupDeletedUsers','null',0,1777982665,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515819086110721,'OC\\Core\\BackgroundJobs\\GenerateMetadataJob','null',0,1777982665,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515819086110722,'OC\\Core\\BackgroundJobs\\PreviewMigrationJob','null',0,1777982665,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79515820138881025,'OCA\\FirstRunWizard\\Notification\\BackgroundJob','{\"uid\":\"admin\"}',0,1777790519,0,0,'70071f2985a39d9762e53229dd5125d134cd7601939c1a4d69cd99aa90057e8a',1),
(79515821325869057,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",4]',0,1777790519,0,0,'4956793059d80398b3d78ea2215ebb860a2e0c724aefa0ce04b1a8bbb5a70f46',1),
(79515821468475393,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",5]',0,1777790519,0,0,'bab5ba2238ecad63141db6c5f1608efc3b0efecc909f4f8d8e111e0d5c23edad',1),
(79515821585915905,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",6]',0,1777790519,0,0,'0d840fcf4d96c36eb80b922e14ca2b7aa5acaba8f61b45e2d8bd832199fe8c9d',1),
(79515821711745025,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",7]',0,1777790519,0,0,'5889fec72259069bfcddd1167dbbf1c854234eb06614dd8fd894eff7956192a7',1),
(79515822026317825,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",8]',0,1777790520,0,0,'075228ca5e1ab3f24fd39c1402e41a206a4afd78fc71b52f0021faaa6121c260',1),
(79515822298947585,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",9]',0,1777790520,0,0,'6aeb888c4dfdca1c745d4f2367a7386cf490285b3d961db0382c594a54c400a0',1),
(79515822714183681,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",11]',0,1777790520,0,0,'32ea4cc1f86ec7aba234f815b18136b6eab27615e67f71a4f752e863214b3b22',1),
(79515822957453313,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",12]',0,1777790520,0,0,'2f60738088dd89b5b25465a7c6c482de073a21ffe62c3b8a3ec59ad5a1f4c15f',1),
(79515823137808385,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",13]',0,1777790520,0,0,'05b302cbd33b86157c9981f8eb4ab72466e203421a1a8d2b9d504b7ec7e17ea7',1),
(79515823301386241,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",14]',0,1777790520,0,0,'70e10015f10fbd6d13870e3908314ad4de673976fc3075d2eda0d7d4b2681dc6',1),
(79515823527878657,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",15]',0,1777790520,0,0,'22aa486f345e5794cae46ce5def4dd3810bcc6c191e1190594fcdcbfaf05c65f',1),
(79515823796314113,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",16]',0,1777790520,0,0,'cdf77c66ee9dc02019f56d1e8999668d813066995c75ab4c48ce506c209fe0f6',1),
(79515824043778049,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",17]',0,1777790520,0,0,'50c3dc17edc7103fd33d90ad8c17fabaa4ab920310c26f5a1209a75cf06ff91c',1),
(79515824228327425,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",18]',0,1777790520,0,0,'d6f63b0735f2a90b0ce0af8891b0398880b7399b786f84b0818adeeba359f1bb',1),
(79515824429654017,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",19]',0,1777790520,0,0,'27a2cbe5b547b14f49ab72b681e53a8a1e74f549192ae8898bb4c2f4f88555fd',1),
(79515824580648961,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",20]',0,1777790520,0,0,'876775feb13959831d8c7753e2a4abd552e03b394d84939656bb5dce9ce4f8f6',1),
(79515824949747713,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",21]',0,1777790520,0,0,'79363e541ba12589811d7a0d3403d97d4d60a73c91e92db043322e5ca990c8fb',1),
(79515825117519873,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",22]',0,1777790520,0,0,'830acf7a8ef52afbe08fc2713df540bc14c79f1a0f95c854da5e26b0386477f7',1),
(79515825281097729,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",23]',0,1777790520,0,0,'9cea6ce18595672d882c9d89a3acfbcf7958a0839bc4a5abaa9ef02d88aebaf1',1),
(79515825486618625,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",24]',0,1777790520,0,0,'727ef905962bfe27b36d943813e028d0e3664c929d5a714f0d7ac0d000ffa5fd',1),
(79515825671168001,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",25]',0,1777790520,0,0,'529311c9ad07ba8de6b18178dbcf95b582b72597ade6c56cf1d41d7c6d7397c9',1),
(79515826426142721,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",26]',0,1777790521,0,0,'003cfb4d3aba0fde31ba26c3b3a820a3d150ea868d5ee2c37c1a33771ef8e8b8',1),
(79515826686189569,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",27]',0,1777790521,0,0,'b0cc502625f847e1481b6d24d1eb94752736146434df36043a153c9b1ee284c5',1),
(79515826967207937,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",28]',0,1777790521,0,0,'2e1a9923add930564317a65c0bfc12ca3daa3e2530c1accdaf2277732f6ad934',1),
(79515827306946561,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",29]',0,1777790521,0,0,'128fb9e5163de0bb1da6d975fed7b8c360a97ec2b9fee149f4bb8aaa9598d2b4',1),
(79515827642490881,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",30]',0,1777790521,0,0,'e782f2107c9202401ac95b15d443e8da595c6bd92e26e8c5a086a268967794c9',1),
(79515828032561153,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",31]',0,1777790521,0,0,'86924dbd7b48f415fbf674a2669f36ccb651e936cda773d270e5342bc467d53b',1),
(79515828573626369,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",32]',0,1777790521,0,0,'ee02ec2ee4e390442f92c13e988ac867bb67074f52aecb22a05bdeee504d6e5f',1),
(79515829307629569,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",33]',0,1777790521,0,0,'d2fc6457a2d723b580d9219ce144539740f68beea42d1a1379b60ea972699109',1),
(79515829542510593,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",34]',0,1777790521,0,0,'154b723aa40ccca0c4ef5a72218d14f10a6618261e58095632eca79ecef12329',1),
(79515829978718209,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",35]',0,1777790521,0,0,'a0ef7cdcb39b887087357a25bd2c1da932604ad5db4388671a25dd4a8bd0317a',1),
(79515830683361281,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",36]',0,1777790522,0,0,'16df61184ae9e35c363a154732c7351c493d2a3ac34cdf8697fdfbc2da04f191',1),
(79515831006322689,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",37]',0,1777790522,0,0,'b1e224ce7c7b3a952f648379b84369decad2d9b9ff4206324f216da3fad24c68',1),
(79515831278952449,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",38]',0,1777790522,0,0,'57471075f497d1a8eadd28685fbd9bbf6da61a6c9440d215d823c6ffbd54d4e7',1),
(79515831518027777,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",39]',0,1777790522,0,0,'5ca6ac67eac9782f6f7a0b7771f087a2584e0241fb44c99c4743984285097b2e',1),
(79515831727742977,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",40]',0,1777790522,0,0,'07ba9c6a76e9b0c3a72981be352527e6b36975e7b0976a4fcb3bbc0559d2b542',1),
(79515831933263873,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",41]',0,1777790522,0,0,'4c14497df884240ef37196f1f3e78f9ecb5715d4e5e8155f4c866e4d45d1a9b2',1),
(79515832184922113,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",42]',0,1777790522,0,0,'d5a6a27596364bdb824290d1d838e04ef81f732a54d4af8b01a3ff7e4765c99c',1),
(79515832403025921,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",43]',0,1777790522,0,0,'b7e10b61bf98d5f2376b308c483713cefc1dde08cc62fa9525d280283ac00634',1),
(79515832608546817,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",44]',0,1777790522,0,0,'7f449813b099905192fcaeb5607970d09c4d8d0998bd58dd3621979f8cd11cb0',1),
(79515832776318977,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",45]',0,1777790522,0,0,'ba2ef4e3cfbade663cfae1431113a10c4d523728ac0ad237af333b584375ddb4',1),
(79515832986034177,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",46]',0,1777790522,0,0,'80ff70d0c920a046219b03ff7d3ad47cb1bf4a6208c3200dacf769b3fa6c748c',1),
(79515833187360769,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",47]',0,1777790522,0,0,'a3890d747cc802dba6a5bf5ea3bc64fa76642bfe22a036742524262b78e1fa00',1),
(79515833384493057,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",48]',0,1777790522,0,0,'37b98ebdecc5f0658741278c00b9b39e585ef51a5528ec2849a1f22fc65e6a68',1),
(79515833590013953,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",49]',0,1777790522,0,0,'e1d9319ef784d6e2697941e9c9b806eff09802f8c8b88681164e1fad8a195a2c',1),
(79515833782951937,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",50]',0,1777790522,0,0,'8737a4a10f2493722aef7c2c8e88401b265cddd3be46f68449a98ec3e63f972a',1),
(79515833942335489,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",51]',0,1777790522,0,0,'c7cc806c5e0ef963d164ac8ddbd45a0d07c20632a814374beba02523041e6366',1),
(79515834105913345,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",52]',0,1777790522,0,0,'fd7e2f45366cbfaa56418e9f66de32b1152ceff0b9e2a95c35f8ab9cf14e9ab3',1),
(79515834294657025,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",53]',0,1777790522,0,0,'8b5b90195e90aaf9fb390893dd50cec8b0b5c9291bfc906502ca69130ec3d4b8',1),
(79515834428874753,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",54]',0,1777790522,0,0,'377bbca9da63af8ce04de552dedba2ec51ab03dedabd1720fd8af9044500ec08',1),
(79515834579869697,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",55]',0,1777790522,0,0,'c0b05087e2b5a15f9e2889da4e63410fc313358d668337a87e0012a7d4a49abb',1),
(79515834823139329,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",56]',0,1777790523,0,0,'7c8bf950975a947a8c9ac0c21b5d220c756e025a71ae33a74845207900dfd749',1),
(79515835104157697,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",58]',0,1777790523,0,0,'409ec9f1d90018b9f66098974ec9968cf79ee3f302c3652e51cd170119a00520',1),
(79515835280318465,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",59]',0,1777790523,0,0,'45552acc443d9d07f90f8158d08f71c2946b7d6d9582a774b5eaf37a6ed0d098',1),
(79515835439702017,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",60]',0,1777790523,0,0,'bec1c7d501f1362921bf353f973bceeaeae23549f33cbb877d4f8a4c1e1faf1a',1),
(79515835615862785,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",61]',0,1777790523,0,0,'81c2aa0d57fcc47833a580a4bc712a66208eea31170e2147f0f87b40518d9bd7',1),
(79515835787829249,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",62]',0,1777790523,0,0,'982c464ca0b889af5c5ac79b2dee1cbf75e32ac61ed4cc66abab20e40a61f2e0',1),
(79515835976572929,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",63]',0,1777790523,0,0,'c12cb2f0c41617e72d606ef37c423ea29f2dbb010fc7e81a472f244dd72d6c65',1),
(79515836131762177,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",64]',0,1777790523,0,0,'7f402ba3cef5fc7b12679baf2b5f047d246471bd7bd036548f41df749bea4395',1),
(79515836291145729,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",65]',0,1777790523,0,0,'4fa2d101b945d707d4037aee409fbd634dbc9d5595f92bff6e0bcdffef35b2f2',1),
(79515836471500801,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",66]',0,1777790523,0,0,'32c6ca54a7ed9b052b2e59d2a322aac7b746489ca0869b0fbaaab36f9db1bad7',1),
(79515837180338177,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",67]',0,1777790523,0,0,'4ded08e5f465423d5884dcefd4c3a8b81347c5a983282846ec6127edc59a0ba2',1),
(79515837373276161,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",68]',0,1777790523,0,0,'2fb4d2a3a31a3ea5ca61c6eb5b9797b4d7a7bc6f503483919c1a1522bb4c13eb',1),
(79515837578797057,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",69]',0,1777790523,0,0,'74a4e54b11539312a43e30d92a031bfc501d870bba6a7c5ae3b7f2c8863bf3c1',1),
(79551165496745984,'OCA\\Files_External\\BackgroundJob\\CredentialsCleanup','null',0,1777798749,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79558751260434432,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",117]',0,1777800515,0,0,'b373d4ab3e1ca3ca3a165b18179649ec3b1d25c7ca3f7f5b2de8863458c079ba',1),
(79559017993003008,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",118]',0,1777800577,0,0,'aff256289b68f1c25163270ce36645ee68162051729f67aa11e1abb11cca443e',1),
(79599691324907521,'OC\\FilesMetadata\\Job\\UpdateSingleMetadata','[\"admin\",133]',0,1777810047,0,0,'12eb93b9c63d3eda2424d6cbf46c09994c5b22852ae52f7592d162326b0285b0',1),
(79599828327653377,'OC\\Command\\CommandJob','\"O:33:\\\"OCA\\\\Files_Trashbin\\\\Command\\\\Expire\\\":1:{s:39:\\\"\\u0000OCA\\\\Files_Trashbin\\\\Command\\\\Expire\\u0000user\\\";s:5:\\\"admin\\\";}\"',0,1777846455,0,0,'210cdd5c1cc8185bfdcf2f1f58d9ba5ea15477e7fa4d5f6a314e8d84d9d6d8a9',1),
(79757070347726848,'OC\\Repair\\Owncloud\\MoveAvatarsBackgroundJob','null',0,1777846690,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79757070389669888,'OC\\Repair\\Owncloud\\CleanPreviewsBackgroundJob','{\"uid\":\"admin\"}',0,1777846690,0,0,'70071f2985a39d9762e53229dd5125d134cd7601939c1a4d69cd99aa90057e8a',1),
(79757076270084096,'OC\\Core\\BackgroundJobs\\BackgroundCleanupUpdaterBackupsJob','null',0,1777982665,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79757076291055616,'OC\\Core\\BackgroundJobs\\CleanupLoginFlowV2','null',0,1777982665,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79757076307832832,'OC\\Security\\Bruteforce\\CleanupJob','null',0,1777982665,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79757076324610048,'OC\\Core\\BackgroundJobs\\LookupServerSendCheckBackgroundJob','null',0,1777982665,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79757076353970176,'OC\\TextToImage\\RemoveOldTasksBackgroundJob','null',0,1777982665,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79757076366553088,'OC\\TaskProcessing\\RemoveOldTasksBackgroundJob','null',0,1777982665,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79757076400107520,'OC\\Repair\\NC29\\SanitizeAccountPropertiesJob','null',0,1777982665,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79757076509159424,'OCA\\DAV\\BackgroundJob\\DeleteOutdatedSchedulingObjects','null',0,1777846691,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79757076630794240,'OCA\\DAV\\BackgroundJob\\RegisterRegenerateBirthdayCalendars','null',0,1777846691,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79757076668542976,'OCA\\DAV\\Migration\\BuildCalendarSearchIndexBackgroundJob','{\"offset\":0,\"stopAt\":2}',0,1777846691,0,0,'26e261b46da95958e24f603706a55cf9720baf72c3baa0d192ea7cdf04e76063',1),
(79757076697903104,'OCA\\DAV\\BackgroundJob\\BuildReminderIndexBackgroundJob','{\"offset\":0,\"stopAt\":2}',0,1777846691,0,0,'26e261b46da95958e24f603706a55cf9720baf72c3baa0d192ea7cdf04e76063',1),
(79757076727263232,'OCA\\DAV\\BackgroundJob\\CleanupOrphanedChildrenJob','{\"childTable\":\"calendarobjects\",\"parentTable\":\"calendars\",\"parentId\":\"calendarid\",\"logMessage\":\"%d events without a calendar have been cleaned up\"}',0,1777982665,0,0,'e26121e7e36d2e409270830cf15a711388e2923c216360510d925f91a85fc450',1),
(79757076739846144,'OCA\\DAV\\BackgroundJob\\CleanupOrphanedChildrenJob','{\"childTable\":\"calendarobjects_props\",\"parentTable\":\"calendarobjects\",\"parentId\":\"objectid\",\"logMessage\":\"%d properties without an events have been cleaned up\"}',0,1777982665,0,0,'1f98048b2e8d20cc2ee3ab97b9d570607928151cedd191bf6e281b8e164985e2',1),
(79757076760817664,'OCA\\DAV\\BackgroundJob\\CleanupOrphanedChildrenJob','{\"childTable\":\"calendarchanges\",\"parentTable\":\"calendars\",\"parentId\":\"calendarid\",\"logMessage\":\"%d changes without a calendar have been cleaned up\"}',0,1777982665,0,0,'d4d8f852a56d37bb2b01b57a3a794991a161ba60d6eded8f36642f234994046e',1),
(79757076777594880,'OCA\\DAV\\BackgroundJob\\CleanupOrphanedChildrenJob','{\"childTable\":\"calendarobjects\",\"parentTable\":\"calendarsubscriptions\",\"parentId\":\"calendarid\",\"logMessage\":\"%d cached events without a calendar subscription have been cleaned up\"}',0,1777982665,0,0,'d52e753e34a31023f4e201f49841284f5974f8425ac2aa154081fda7eda33f0b',1),
(79757076794372096,'OCA\\DAV\\BackgroundJob\\CleanupOrphanedChildrenJob','{\"childTable\":\"calendarchanges\",\"parentTable\":\"calendarsubscriptions\",\"parentId\":\"calendarid\",\"logMessage\":\"%d changes without a calendar subscription have been cleaned up\"}',0,1777982665,0,0,'a6571d0db5f452f53b09175c46fe6d39f6a0732154334a0c642d5ee06f56e4d0',1),
(79757076823732224,'OCA\\DAV\\BackgroundJob\\CleanupOrphanedChildrenJob','{\"childTable\":\"cards\",\"parentTable\":\"addressbooks\",\"parentId\":\"addressbookid\",\"logMessage\":\"%d contacts without an addressbook have been cleaned up\"}',0,1777982665,0,0,'fd628fdb5374eda379c323ff10e28a562d28d4c8db0345e529e65de37f09094e',1),
(79757076840509440,'OCA\\DAV\\BackgroundJob\\CleanupOrphanedChildrenJob','{\"childTable\":\"cards_properties\",\"parentTable\":\"cards\",\"parentId\":\"cardid\",\"logMessage\":\"%d properties without a contact have been cleaned up\"}',0,1777982665,0,0,'f9043c0778287d2635e9b4e8a8e5788cd020ffe2e1bd866a06dc7cabf4eea987',1),
(79757076853092352,'OCA\\DAV\\BackgroundJob\\CleanupOrphanedChildrenJob','{\"childTable\":\"addressbookchanges\",\"parentTable\":\"addressbooks\",\"parentId\":\"addressbookid\",\"logMessage\":\"%d changes without an addressbook have been cleaned up\"}',0,1777982665,0,0,'4a744e5242f7a1103b5106decb14409228f24698cef10838680e7a8321a88372',1),
(79757076924395520,'OCA\\Survey_Client\\BackgroundJobs\\AdminNotification','null',0,1777982665,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79757076945367040,'OCA\\Theming\\Jobs\\MigrateBackgroundImages','{\"stage\":\"prepare\"}',0,1777982665,0,0,'8760b159378869e104390034cc3e518ab586e37c5a611d0de8631b9b5053e699',1),
(79757076962144256,'OCA\\TwoFactorBackupCodes\\BackgroundJob\\CheckBackupCodes','null',0,1777982665,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79799182531420161,'OCA\\Settings\\BackgroundJobs\\VerifyUserData','{\"verificationCode\":\"\",\"data\":\"\",\"type\":\"email\",\"uid\":\"fluencyhub\",\"try\":0,\"lastRun\":1777856495}',0,1777856495,0,0,'f93709a55c16d68b3161946474d895deb3b313721bbcc1b4e6faf8660d00f760',1),
(79799186457288705,'OCA\\Settings\\BackgroundJobs\\VerifyUserData','{\"verificationCode\":\"\",\"data\":\"info@fluencyhub.com.au\",\"type\":\"email\",\"uid\":\"fluencyhub\",\"try\":0,\"lastRun\":1777856495}',0,1777856495,0,0,'927c93c874b4a2357b28e5d5e627b68600c80b70110557e28297c58fddde818c',1),
(79799540322328577,'OCA\\FirstRunWizard\\Notification\\BackgroundJob','{\"uid\":\"fluencyhub\"}',0,1777856607,0,0,'d05eb509bf2a8ac54314bf7e5e2937f099754b079def806e0167b4629aed4d62',1),
(79801941712363521,'OCA\\Settings\\BackgroundJobs\\VerifyUserData','{\"verificationCode\":\"\",\"data\":\"info@fluencyhub.com.au\",\"type\":\"email\",\"uid\":\"admin\",\"try\":0,\"lastRun\":1777857137}',0,1777857137,0,0,'633d1dd9579f6ce9594b58832990f9b6e12c7610bbcccddb20702053dede1c9a',1),
(79852804946452481,'OCA\\Talk\\BackgroundJob\\CheckCertificates','null',0,1777869018,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79852804959035393,'OCA\\Talk\\BackgroundJob\\CheckHostedSignalingServer','null',0,1777869018,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79852805063892993,'OCA\\Talk\\BackgroundJob\\CheckMatterbridges','null',0,1777869018,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79852805068087297,'OCA\\Talk\\BackgroundJob\\ExpireChatMessages','null',0,1777869018,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79852805072281601,'OCA\\Talk\\BackgroundJob\\ExpireObjectRooms','null',0,1777869018,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79852805076475905,'OCA\\Talk\\BackgroundJob\\ExpireSignalingMessage','null',0,1777869018,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79852805080670209,'OCA\\Talk\\BackgroundJob\\LockInactiveRooms','null',0,1777869018,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79852805080670210,'OCA\\Talk\\BackgroundJob\\MaximumCallDuration','null',0,1777869018,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79852805084864513,'OCA\\Talk\\BackgroundJob\\Reminder','null',0,1777869018,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79852805089058817,'OCA\\Talk\\BackgroundJob\\RemoveEmptyRooms','null',0,1777869018,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79852805093253121,'OCA\\Talk\\BackgroundJob\\ResetAssignedSignalingServer','null',0,1777869018,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79852805093253122,'OCA\\Talk\\BackgroundJob\\RetryNotificationsJob','null',0,1777869018,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79852805097447425,'OCA\\Talk\\BackgroundJob\\SendScheduledMessages','null',0,1777869018,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79853772182315009,'OCA\\Calendar\\BackgroundJob\\CleanUpOutdatedBookingsJob','null',0,1777869205,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(79853831833706497,'OCA\\Contacts\\Cron\\SocialUpdateRegistration','null',0,1777869219,0,0,'74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b',1),
(80336072372318208,'OCA\\DAV\\Migration\\BuildSocialSearchIndexBackgroundJob','{\"offset\":0,\"stopAt\":3}',0,1777981499,0,0,'65a9c439ba3f9f9df316a936e28ae2bb7a8520fc686757a96061dd66b1ae8e61',1);

--
-- Table structure for table `oc_known_users`
--

CREATE TABLE `oc_known_users` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `known_to` varchar(255) NOT NULL,
  `known_user` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ku_known_to` (`known_to`),
  KEY `ku_known_user` (`known_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_known_users`
--


--
-- Table structure for table `oc_login_flow_v2`
--

CREATE TABLE `oc_login_flow_v2` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` bigint(20) unsigned NOT NULL,
  `started` smallint(5) unsigned NOT NULL DEFAULT 0,
  `poll_token` varchar(255) NOT NULL,
  `login_token` varchar(255) NOT NULL,
  `public_key` text NOT NULL,
  `private_key` text NOT NULL,
  `client_name` varchar(255) NOT NULL,
  `login_name` varchar(255) DEFAULT NULL,
  `server` varchar(255) DEFAULT NULL,
  `app_password` varchar(1024) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `poll_token` (`poll_token`),
  UNIQUE KEY `login_token` (`login_token`),
  KEY `timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_login_flow_v2`
--


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

CREATE TABLE `oc_migrations` (
  `app` varchar(255) NOT NULL,
  `version` varchar(255) 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','2006Date20170808154933'),
('activity','2006Date20170808155040'),
('activity','2006Date20170919095939'),
('activity','2007Date20181107114613'),
('activity','2008Date20181011095117'),
('activity','2010Date20190416112817'),
('activity','2011Date20201006132544'),
('activity','2011Date20201006132545'),
('activity','2011Date20201006132546'),
('activity','2011Date20201006132547'),
('activity','2011Date20201207091915'),
('app_api','032000Date20250109162434'),
('app_api','032001Date20250115164140'),
('app_api','032002Date20250527174907'),
('app_api','1000Date202305221555'),
('app_api','1004Date202311061844'),
('app_api','2000Date20240120094952'),
('app_api','2005Date20240209094951'),
('app_api','2201Date20240221124152'),
('app_api','2203Date20240325124149'),
('app_api','2204Date20240403125002'),
('app_api','2205Date20240411124836'),
('app_api','2206Date20240502145029'),
('app_api','2207Date20240502145029'),
('app_api','2700Date20240515092246'),
('app_api','2800Date20240710220000'),
('app_api','2800Date20240711080316'),
('app_api','3000Date20240715170800'),
('app_api','3000Date20240807085759'),
('app_api','3100Date20240822080316'),
('app_api','3200Date20240905080316'),
('app_api','5000Date20241120135411'),
('calendar','2040Date20210908101001'),
('calendar','3000Date20211109132439'),
('calendar','3010Date20220111090252'),
('calendar','4050Date20230614163505'),
('calendar','5050Date20250701000001'),
('calendar','5050Date20250701000002'),
('calendar','5050Date20250701000003'),
('calendar','5050Date20250701000004'),
('circles','0022Date20220526111723'),
('circles','0022Date20220526113601'),
('circles','0022Date20220703115023'),
('circles','0023Date20211216113101'),
('circles','0024Date20220203123901'),
('circles','0024Date20220203123902'),
('circles','0024Date20220317190331'),
('circles','0028Date20230705222601'),
('circles','0031Date20241105133904'),
('circles','0032Date20250623120204'),
('cloud_federation_api','1016Date202502262004'),
('contactsinteraction','010000Date20200304152605'),
('core','13000Date20170705121758'),
('core','13000Date20170718121200'),
('core','13000Date20170814074715'),
('core','13000Date20170919121250'),
('core','13000Date20170926101637'),
('core','14000Date20180129121024'),
('core','14000Date20180404140050'),
('core','14000Date20180516101403'),
('core','14000Date20180518120534'),
('core','14000Date20180522074438'),
('core','14000Date20180710092004'),
('core','14000Date20180712153140'),
('core','15000Date20180926101451'),
('core','15000Date20181015062942'),
('core','15000Date20181029084625'),
('core','16000Date20190207141427'),
('core','16000Date20190212081545'),
('core','16000Date20190427105638'),
('core','16000Date20190428150708'),
('core','17000Date20190514105811'),
('core','18000Date20190920085628'),
('core','18000Date20191014105105'),
('core','18000Date20191204114856'),
('core','19000Date20200211083441'),
('core','20000Date20201109081915'),
('core','20000Date20201109081918'),
('core','20000Date20201109081919'),
('core','20000Date20201111081915'),
('core','21000Date20201120141228'),
('core','21000Date20201202095923'),
('core','21000Date20210119195004'),
('core','21000Date20210309185126'),
('core','21000Date20210309185127'),
('core','22000Date20210216080825'),
('core','23000Date20210721100600'),
('core','23000Date20210906132259'),
('core','23000Date20210930122352'),
('core','23000Date20211203110726'),
('core','23000Date20211213203940'),
('core','24000Date20211210141942'),
('core','24000Date20211213081506'),
('core','24000Date20211213081604'),
('core','24000Date20211222112246'),
('core','24000Date20211230140012'),
('core','24000Date20220131153041'),
('core','24000Date20220202150027'),
('core','24000Date20220404230027'),
('core','24000Date20220425072957'),
('core','25000Date20220515204012'),
('core','25000Date20220602190540'),
('core','25000Date20220905140840'),
('core','25000Date20221007010957'),
('core','27000Date20220613163520'),
('core','27000Date20230309104325'),
('core','27000Date20230309104802'),
('core','28000Date20230616104802'),
('core','28000Date20230728104802'),
('core','28000Date20230803221055'),
('core','28000Date20230906104802'),
('core','28000Date20231004103301'),
('core','28000Date20231103104802'),
('core','28000Date20231126110901'),
('core','28000Date20240828142927'),
('core','29000Date20231126110901'),
('core','29000Date20231213104850'),
('core','29000Date20240124132201'),
('core','29000Date20240124132202'),
('core','29000Date20240131122720'),
('core','30000Date20240429122720'),
('core','30000Date20240708160048'),
('core','30000Date20240717111406'),
('core','30000Date20240814180800'),
('core','30000Date20240815080800'),
('core','30000Date20240906095113'),
('core','31000Date20240101084401'),
('core','31000Date20240814184402'),
('core','31000Date20250213102442'),
('core','32000Date20250620081925'),
('core','32000Date20250731062008'),
('core','32000Date20250806110519'),
('core','33000Date20250819110529'),
('core','33000Date20251013110519'),
('core','33000Date20251023110529'),
('core','33000Date20251023120529'),
('core','33000Date20251106131209'),
('core','33000Date20251124110529'),
('core','33000Date20251126152410'),
('core','33000Date20251209123503'),
('core','33000Date20260126120000'),
('core','34000Date20260318095645'),
('dav','1004Date20170825134824'),
('dav','1004Date20170919104507'),
('dav','1004Date20170924124212'),
('dav','1004Date20170926103422'),
('dav','1005Date20180413093149'),
('dav','1005Date20180530124431'),
('dav','1006Date20180619154313'),
('dav','1006Date20180628111625'),
('dav','1008Date20181030113700'),
('dav','1008Date20181105104826'),
('dav','1008Date20181105104833'),
('dav','1008Date20181105110300'),
('dav','1008Date20181105112049'),
('dav','1008Date20181114084440'),
('dav','1011Date20190725113607'),
('dav','1011Date20190806104428'),
('dav','1012Date20190808122342'),
('dav','1016Date20201109085907'),
('dav','1017Date20210216083742'),
('dav','1018Date20210312100735'),
('dav','1024Date20211221144219'),
('dav','1025Date20240308063933'),
('dav','1027Date20230504122946'),
('dav','1029Date20221114151721'),
('dav','1029Date20231004091403'),
('dav','1030Date20240205103243'),
('dav','1031Date20240610134258'),
('dav','1034Date20250605132605'),
('dav','1034Date20250813093701'),
('dav','1036Date20251202000000'),
('federatedfilesharing','1010Date20200630191755'),
('federatedfilesharing','1011Date20201120125158'),
('federation','1010Date20200630191302'),
('files','11301Date20191205150729'),
('files','12101Date20221011153334'),
('files','2003Date20241021095629'),
('files_downloadlimit','000000Date20210910094923'),
('files_external','1011Date20200630192246'),
('files_external','1015Date20211104103506'),
('files_external','1016Date20220324154536'),
('files_external','1025Date20250228162604'),
('files_external','22000Date20210216084416'),
('files_reminders','10000Date20230725162149'),
('files_sharing','11300Date20201120141438'),
('files_sharing','21000Date20201223143245'),
('files_sharing','22000Date20210216084241'),
('files_sharing','24000Date20220208195521'),
('files_sharing','24000Date20220404142216'),
('files_sharing','31000Date20240821142813'),
('files_sharing','32000Date20251017081948'),
('files_sharing','33000Date20251030081948'),
('files_trashbin','1010Date20200630192639'),
('files_trashbin','1020Date20240403003535'),
('files_versions','1020Date20221114144058'),
('notifications','2004Date20190107135757'),
('notifications','2010Date20210218082811'),
('notifications','2010Date20210218082855'),
('notifications','2011Date20210930134607'),
('notifications','2011Date20220826074907'),
('oauth2','010401Date20181207190718'),
('oauth2','010402Date20190107124745'),
('oauth2','011601Date20230522143227'),
('oauth2','011602Date20230613160650'),
('oauth2','011603Date20230620111039'),
('oauth2','011901Date20240829164356'),
('photos','20000Date20220727125801'),
('photos','20001Date20220830131446'),
('photos','20003Date20221102170153'),
('photos','20003Date20221103094628'),
('photos','30000Date20240417075405'),
('photos','32000Date20250507132617'),
('privacy','100Date20190217131943'),
('spreed','10000Date20200819121721'),
('spreed','10000Date20201012144235'),
('spreed','10000Date20201015134000'),
('spreed','10000Date20201015143852'),
('spreed','10000Date20201015150000'),
('spreed','11000Date20200922161218'),
('spreed','11000Date20201011082810'),
('spreed','11000Date20201201102528'),
('spreed','11000Date20201204110210'),
('spreed','11000Date20201209142525'),
('spreed','11000Date20201209142526'),
('spreed','11001Date20210211111527'),
('spreed','11001Date20210212105406'),
('spreed','12000Date20210217134030'),
('spreed','12000Date20210401124139'),
('spreed','12000Date20210528100404'),
('spreed','13000Date20210625232111'),
('spreed','13000Date20210901164235'),
('spreed','13000Date20210921142733'),
('spreed','13000Date20211007192733'),
('spreed','14000Date20211203132513'),
('spreed','14000Date20220217115327'),
('spreed','14000Date20220328153054'),
('spreed','14000Date20220330141647'),
('spreed','15000Date20220427183026'),
('spreed','15000Date20220503121308'),
('spreed','15000Date20220506005058'),
('spreed','16000Date20221110151714'),
('spreed','16000Date20221116163301'),
('spreed','16000Date20221208013745'),
('spreed','16000Date20230502145340'),
('spreed','18000Date20230504205823'),
('spreed','18000Date20230808120823'),
('spreed','18000Date20230821112014'),
('spreed','18000Date20230824123939'),
('spreed','18000Date20230920182747'),
('spreed','18000Date20230928131717'),
('spreed','18000Date20231005091416'),
('spreed','18000Date20231018065816'),
('spreed','18000Date20231024141626'),
('spreed','18000Date20231024141627'),
('spreed','19000Date20240212155937'),
('spreed','19000Date20240214095011'),
('spreed','19000Date20240227084313'),
('spreed','19000Date20240305115243'),
('spreed','19000Date20240312105627'),
('spreed','19000Date20240313134926'),
('spreed','19000Date20240416104656'),
('spreed','19000Date20240709183938'),
('spreed','20000Date20240621150333'),
('spreed','20000Date20240621150334'),
('spreed','20000Date20240621150335'),
('spreed','20000Date20240623123938'),
('spreed','20000Date20240716190335'),
('spreed','20000Date20240717180417'),
('spreed','20000Date20240718031959'),
('spreed','2000Date20170707093535'),
('spreed','2000Date20171026140256'),
('spreed','2000Date20171026140257'),
('spreed','2001Date20170707115443'),
('spreed','2001Date20170913104501'),
('spreed','2001Date20170921145301'),
('spreed','2001Date20170929092606'),
('spreed','2001Date20171009132424'),
('spreed','2001Date20171026134605'),
('spreed','2001Date20171026141336'),
('spreed','2001Date20171031102049'),
('spreed','2001Date20180103144447'),
('spreed','2001Date20180103150836'),
('spreed','21000Date20240919222538'),
('spreed','21001Date20250328123156'),
('spreed','21001Date20250417141337'),
('spreed','21001Date20250509153510'),
('spreed','22000Date20250526102909'),
('spreed','22000Date20250623142327'),
('spreed','22000Date20250710124258'),
('spreed','22000Date20250803160923'),
('spreed','22000Date20250813122342'),
('spreed','22001Date20250927174738'),
('spreed','23000Date20251030090219'),
('spreed','23000Date20251105125333'),
('spreed','23000Date20251114105144'),
('spreed','23000Date20251215204457'),
('spreed','23000Date20251218142903'),
('spreed','23000Date20260107162758'),
('spreed','3002Date20180319104030'),
('spreed','3003Date20180707222130'),
('spreed','3003Date20180718112436'),
('spreed','3003Date20180718133519'),
('spreed','3003Date20180720162342'),
('spreed','3003Date20180722152733'),
('spreed','3003Date20180722152849'),
('spreed','3003Date20180730080327'),
('spreed','4099Date20181001123058'),
('spreed','5099Date20190121102337'),
('spreed','5099Date20190319134820'),
('spreed','6099Date20190627172429'),
('spreed','7000Date20190717141457'),
('spreed','7000Date20190724121136'),
('spreed','7000Date20190724121137'),
('spreed','8000Date20200331144101'),
('spreed','8000Date20200402124456'),
('spreed','8000Date20200407073807'),
('spreed','8000Date20200407115318'),
('systemtags','31000Date20241018063111'),
('systemtags','31000Date20241114171300'),
('text','010000Date20190617184535'),
('text','030001Date20200402075029'),
('text','030201Date20201116110353'),
('text','030201Date20201116123153'),
('text','030501Date20220202101853'),
('text','030701Date20230207131313'),
('text','030901Date20231114150437'),
('text','040100Date20240611165300'),
('text','070000Date20250925110024'),
('text','080000Date20260331132113'),
('theming','2006Date20240905111627'),
('twofactor_backupcodes','1002Date20170607104347'),
('twofactor_backupcodes','1002Date20170607113030'),
('twofactor_backupcodes','1002Date20170919123342'),
('twofactor_backupcodes','1002Date20170926101419'),
('twofactor_backupcodes','1002Date20180821043638'),
('twofactor_totp','010501Date20181018124436'),
('twofactor_totp','020102Date20190304124405'),
('twofactor_totp','030000Date20190305114917'),
('twofactor_totp','140000Date202503027114917'),
('user_status','0001Date20200602134824'),
('user_status','0002Date20200902144824'),
('user_status','1000Date20201111130204'),
('user_status','1003Date20210809144824'),
('user_status','1008Date20230921144701'),
('webhook_listeners','1000Date20240527153425'),
('webhook_listeners','1001Date20240716184935'),
('webhook_listeners','1500Date20251007130000'),
('workflowengine','2000Date20190808074233'),
('workflowengine','2200Date20210805101925');

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

CREATE TABLE `oc_mimetypes` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `mimetype` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mimetype_id_index` (`mimetype`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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

INSERT INTO `oc_mimetypes` VALUES
(3,'application'),
(21,'application/gzip'),
(19,'application/javascript'),
(22,'application/json'),
(20,'application/octet-stream'),
(7,'application/pdf'),
(35,'application/toml'),
(13,'application/vnd.excalidraw+json'),
(16,'application/vnd.oasis.opendocument.graphics'),
(14,'application/vnd.oasis.opendocument.presentation'),
(12,'application/vnd.oasis.opendocument.spreadsheet'),
(15,'application/vnd.oasis.opendocument.text'),
(4,'application/vnd.openxmlformats-officedocument.wordprocessingml.document'),
(31,'application/vnd.recordare.musicxml'),
(32,'application/vnd.recordare.musicxml+xml'),
(34,'application/x-openvpn-profile'),
(29,'application/zstd'),
(1,'httpd'),
(2,'httpd/unix-directory'),
(10,'image'),
(26,'image/heic'),
(17,'image/jpeg'),
(11,'image/png'),
(23,'image/svg+xml'),
(27,'image/webp'),
(5,'text'),
(6,'text/markdown'),
(33,'text/plain'),
(18,'text/vcard'),
(30,'text/x-nfo'),
(8,'video'),
(9,'video/mp4'),
(28,'video/quicktime'),
(25,'video/webm');

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

CREATE TABLE `oc_mounts` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `storage_id` bigint(20) NOT NULL,
  `root_id` bigint(20) NOT NULL,
  `user_id` varchar(64) NOT NULL,
  `mount_point` varchar(4000) NOT NULL,
  `mount_id` bigint(20) DEFAULT NULL,
  `mount_provider_class` varchar(128) DEFAULT NULL,
  `mount_point_hash` varchar(32) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mounts_user_path_root_index` (`user_id`,`mount_point_hash`,`root_id`),
  KEY `mounts_storage_index` (`storage_id`),
  KEY `mounts_root_index` (`root_id`),
  KEY `mounts_mount_id_index` (`mount_id`),
  KEY `mounts_class_index` (`mount_provider_class`),
  KEY `mount_user_storage` (`storage_id`,`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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

INSERT INTO `oc_mounts` VALUES
(3,4,106,'admin','/admin/',NULL,'OC\\Files\\Mount\\ObjectHomeMountProvider','65846967add5725ad01dabcc978e314e'),
(5,6,123,'admin','/admin/files/Cloud drive/',1,'OCA\\Files_External\\Config\\ConfigAdapter','10411b2c4869831d28ff50de5cea29bd'),
(6,6,123,'fluencyhub','/fluencyhub/files/Cloud drive/',1,'OCA\\Files_External\\Config\\ConfigAdapter','81d9a008dd14d5948b9510ea61a02c24'),
(7,7,161,'fluencyhub','/fluencyhub/',NULL,'OC\\Files\\Mount\\ObjectHomeMountProvider','6946f60f5b10c2710d8e44a56967d07e');

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

CREATE TABLE `oc_notifications` (
  `notification_id` int(11) NOT NULL AUTO_INCREMENT,
  `app` varchar(32) NOT NULL,
  `user` varchar(64) NOT NULL,
  `timestamp` int(11) NOT NULL DEFAULT 0,
  `object_type` varchar(64) NOT NULL,
  `object_id` varchar(64) NOT NULL,
  `subject` varchar(64) NOT NULL,
  `subject_parameters` longtext DEFAULT NULL,
  `message` varchar(64) DEFAULT NULL,
  `message_parameters` longtext DEFAULT NULL,
  `link` varchar(4000) DEFAULT NULL,
  `icon` varchar(4000) DEFAULT NULL,
  `actions` longtext DEFAULT NULL,
  PRIMARY KEY (`notification_id`),
  KEY `oc_notifications_app` (`app`),
  KEY `oc_notifications_user` (`user`),
  KEY `oc_notifications_timestamp` (`timestamp`),
  KEY `oc_notifications_object` (`object_type`,`object_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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

INSERT INTO `oc_notifications` VALUES
(1,'firstrunwizard','fluencyhub',1777856578,'app','recognize','apphint-recognize','[]','','[]','','','[]'),
(2,'firstrunwizard','fluencyhub',1777856578,'app','groupfolders','apphint-groupfolders','[]','','[]','','','[]'),
(3,'firstrunwizard','fluencyhub',1777856578,'app','forms','apphint-forms','[]','','[]','','','[]'),
(4,'firstrunwizard','fluencyhub',1777856578,'app','deck','apphint-deck','[]','','[]','','','[]'),
(5,'firstrunwizard','fluencyhub',1777856578,'app','tasks','apphint-tasks','[]','','[]','','','[]'),
(6,'firstrunwizard','fluencyhub',1777856578,'app','whiteboard','apphint-whiteboard','[]','','[]','','','[]');

--
-- Table structure for table `oc_notifications_pushhash`
--

CREATE TABLE `oc_notifications_pushhash` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(64) NOT NULL,
  `token` int(11) NOT NULL DEFAULT 0,
  `deviceidentifier` varchar(128) NOT NULL,
  `devicepublickey` varchar(512) NOT NULL,
  `devicepublickeyhash` varchar(128) NOT NULL,
  `pushtokenhash` varchar(128) NOT NULL,
  `proxyserver` varchar(256) NOT NULL,
  `apptype` varchar(32) NOT NULL DEFAULT 'unknown',
  PRIMARY KEY (`id`),
  UNIQUE KEY `oc_npushhash_uid` (`uid`,`token`),
  KEY `oc_npushhash_di` (`deviceidentifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_notifications_pushhash`
--


--
-- Table structure for table `oc_notifications_settings`
--

CREATE TABLE `oc_notifications_settings` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) NOT NULL,
  `batch_time` int(11) NOT NULL DEFAULT 0,
  `last_send_id` bigint(20) NOT NULL DEFAULT 0,
  `next_send_time` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `notset_user` (`user_id`),
  KEY `notset_nextsend` (`next_send_time`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_notifications_settings`
--

INSERT INTO `oc_notifications_settings` VALUES
(1,'fluencyhub',5,0,0);

--
-- Table structure for table `oc_oauth2_access_tokens`
--

CREATE TABLE `oc_oauth2_access_tokens` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `token_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `hashed_code` varchar(128) NOT NULL,
  `encrypted_token` varchar(786) NOT NULL,
  `code_created_at` bigint(20) unsigned NOT NULL DEFAULT 0,
  `token_count` bigint(20) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `oauth2_access_hash_idx` (`hashed_code`),
  KEY `oauth2_access_client_id_idx` (`client_id`),
  KEY `oauth2_tk_c_created_idx` (`token_count`,`code_created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_oauth2_access_tokens`
--


--
-- Table structure for table `oc_oauth2_clients`
--

CREATE TABLE `oc_oauth2_clients` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `redirect_uri` varchar(2000) NOT NULL,
  `client_identifier` varchar(64) NOT NULL,
  `secret` varchar(512) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `oauth2_client_id_idx` (`client_identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_oauth2_clients`
--


--
-- Table structure for table `oc_open_local_editor`
--

CREATE TABLE `oc_open_local_editor` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) NOT NULL,
  `path_hash` varchar(64) NOT NULL,
  `expiration_time` bigint(20) unsigned NOT NULL,
  `token` varchar(128) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `openlocal_user_path_token` (`user_id`,`path_hash`,`token`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_open_local_editor`
--

INSERT INTO `oc_open_local_editor` VALUES
(1,'fluencyhub','84d3df510660d5d80c29cf9b00ecadc88c0ec605',1778990536,'4Z26VKkNoefggg389llRoceqMAZhv2okkS3zpSjYR7Q9TgazomGZW3xxoi0AkgKQh09Gohc6P1TnUEMEdDSEAgk5UssUZAngwv642GOJKyK8raE1MFIfTmjShuuN3nDa');

--
-- Table structure for table `oc_photos_albums`
--

CREATE TABLE `oc_photos_albums` (
  `album_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `user` varchar(255) NOT NULL,
  `created` bigint(20) NOT NULL,
  `location` varchar(255) NOT NULL,
  `last_added_photo` bigint(20) NOT NULL,
  `filters` longtext DEFAULT NULL,
  PRIMARY KEY (`album_id`),
  KEY `pa_user` (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_photos_albums`
--


--
-- Table structure for table `oc_photos_albums_collabs`
--

CREATE TABLE `oc_photos_albums_collabs` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `album_id` bigint(20) NOT NULL,
  `collaborator_id` varchar(64) NOT NULL,
  `collaborator_type` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `album_collabs_uniq_collab` (`album_id`,`collaborator_id`,`collaborator_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_photos_albums_collabs`
--


--
-- Table structure for table `oc_photos_albums_files`
--

CREATE TABLE `oc_photos_albums_files` (
  `album_file_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `album_id` bigint(20) NOT NULL,
  `file_id` bigint(20) NOT NULL,
  `added` bigint(20) NOT NULL,
  `owner` varchar(64) DEFAULT NULL,
  PRIMARY KEY (`album_file_id`),
  UNIQUE KEY `paf_album_file` (`album_id`,`file_id`),
  KEY `paf_folder` (`album_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_photos_albums_files`
--


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

CREATE TABLE `oc_preferences` (
  `userid` varchar(64) NOT NULL DEFAULT '',
  `appid` varchar(32) NOT NULL DEFAULT '',
  `configkey` varchar(64) NOT NULL DEFAULT '',
  `configvalue` longtext DEFAULT NULL,
  `lazy` smallint(5) unsigned NOT NULL DEFAULT 0,
  `type` smallint(5) unsigned NOT NULL DEFAULT 0,
  `flags` int(10) unsigned NOT NULL DEFAULT 0,
  `indexed` varchar(64) DEFAULT '',
  PRIMARY KEY (`userid`,`appid`,`configkey`),
  KEY `prefs_uid_lazy_i` (`userid`,`lazy`),
  KEY `prefs_app_key_ind_fl_i` (`appid`,`configkey`,`indexed`,`flags`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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

INSERT INTO `oc_preferences` VALUES
('admin','activity','configured','yes',0,0,0,''),
('admin','avatar','generated','true',0,0,0,''),
('admin','circles','userSingleId','3DFnCXu2Cx4oEzs5QKjVbnRpvaLrIgA',0,1,2,'3DFnCXu2Cx4oEzs5QKjVbnRpvaLrIgA'),
('admin','core','lang','en',0,1,0,''),
('admin','core','templateDirectory','Templates/',0,0,0,''),
('admin','core','timezone','Australia/Brisbane',0,1,0,''),
('admin','dashboard','firstRun','0',0,4,0,''),
('admin','files','lastSeenQuotaUsage','0',0,0,0,''),
('admin','files_sharing','user_needs_share_refresh','0',0,4,0,''),
('admin','firstrunwizard','apphint','19',0,2,0,''),
('admin','firstrunwizard','show','33.0.3',0,1,0,''),
('admin','login','firstLogin','1777790519',0,0,0,''),
('admin','login','lastLogin','1778989827',0,0,0,''),
('admin','login_token','Es8db9Fu3Fk3hFjpZcQku3+9dp/rvWwJ','1778989828',0,0,0,''),
('admin','password_policy','failedLoginAttempts','0',0,0,0,''),
('admin','settings','email','info@fluencyhub.com.au',0,1,2,'info@fluencyhub.com.au'),
('admin','settings','user_list_show_new_user_form','0',1,4,0,''),
('fluencyhub','activity','configured','yes',0,0,0,''),
('fluencyhub','avatar','generated','true',0,0,0,''),
('fluencyhub','avatar','version','1',0,0,0,''),
('fluencyhub','circles','userSingleId','TGqGy6eHANccyi4Ayk6htP6gRTVgqj6',0,1,2,'TGqGy6eHANccyi4Ayk6htP6gRTVgqj6'),
('fluencyhub','core','lang','en',0,1,0,''),
('fluencyhub','core','timezone','Australia/Sydney',0,1,0,''),
('fluencyhub','dashboard','firstRun','0',0,4,0,''),
('fluencyhub','files','files_views_configs','{\"folders\":{\"expanded\":true}}',0,0,0,''),
('fluencyhub','files','lastSeenQuotaUsage','0',0,0,0,''),
('fluencyhub','files','quota','none',0,0,0,''),
('fluencyhub','files_sharing','user_needs_share_refresh','0',0,4,0,''),
('fluencyhub','firstrunwizard','apphint','19',0,2,0,''),
('fluencyhub','firstrunwizard','show','33.0.3',0,1,0,''),
('fluencyhub','login','firstLogin','1777856578',0,0,0,''),
('fluencyhub','login','lastLogin','1778548158',0,0,0,''),
('fluencyhub','login_token','qO4mvD5SaUCOy/mAYLL+H4ogNPE7aJTz','1777856608',0,0,0,''),
('fluencyhub','password_policy','failedLoginAttempts','0',0,0,0,''),
('fluencyhub','settings','email','info@fluencyhub.com.au',0,1,2,'info@fluencyhub.com.au'),
('fluencyhub','settings','manager','[\"admin\"]',0,0,0,'');

--
-- Table structure for table `oc_preferences_ex`
--

CREATE TABLE `oc_preferences_ex` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `userid` varchar(64) NOT NULL,
  `appid` varchar(32) NOT NULL,
  `configkey` varchar(64) NOT NULL,
  `configvalue` longtext DEFAULT NULL,
  `sensitive` smallint(6) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `preferences_ex__idx` (`userid`,`appid`,`configkey`),
  KEY `preferences_ex__configkey` (`configkey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_preferences_ex`
--


--
-- Table structure for table `oc_preview_locations`
--

CREATE TABLE `oc_preview_locations` (
  `id` bigint(20) unsigned NOT NULL,
  `bucket_name` varchar(40) NOT NULL,
  `object_store_name` varchar(40) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_bucket_store` (`bucket_name`,`object_store_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_preview_locations`
--

INSERT INTO `oc_preview_locations` VALUES
(79558804670701568,'nextcloud','server1');

--
-- Table structure for table `oc_preview_versions`
--

CREATE TABLE `oc_preview_versions` (
  `id` bigint(20) unsigned NOT NULL,
  `file_id` bigint(20) unsigned NOT NULL,
  `version` varchar(1024) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_preview_versions`
--


--
-- Table structure for table `oc_previews`
--

CREATE TABLE `oc_previews` (
  `id` bigint(20) unsigned NOT NULL,
  `file_id` bigint(20) unsigned NOT NULL,
  `storage_id` bigint(20) unsigned NOT NULL,
  `old_file_id` bigint(20) unsigned DEFAULT NULL,
  `location_id` bigint(20) unsigned DEFAULT NULL,
  `width` int(10) unsigned NOT NULL,
  `height` int(10) unsigned NOT NULL,
  `mimetype_id` int(11) NOT NULL,
  `source_mimetype_id` int(11) NOT NULL,
  `max` tinyint(1) NOT NULL DEFAULT 0,
  `cropped` tinyint(1) NOT NULL DEFAULT 0,
  `encrypted` tinyint(1) NOT NULL DEFAULT 0,
  `etag` char(40) NOT NULL,
  `mtime` int(10) unsigned NOT NULL,
  `size` int(10) unsigned NOT NULL,
  `version_id` bigint(20) NOT NULL DEFAULT -1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `previews_file_uniq_idx` (`file_id`,`width`,`height`,`mimetype_id`,`cropped`,`version_id`),
  KEY `IDX_67DC472793CB796C` (`file_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_previews`
--

INSERT INTO `oc_previews` VALUES
(79515982982733825,58,1,NULL,NULL,1600,1067,17,17,1,0,0,'4b9910f87e7a69be67cbe929ccc8b249',1777790557,137923,-1),
(79515983259557889,59,1,NULL,NULL,1600,1067,17,17,1,0,0,'8af4a268473d45ccaac31d95fe82dde4',1777790557,232378,-1),
(79515983364415489,58,1,NULL,NULL,256,256,17,17,0,1,0,'4b9910f87e7a69be67cbe929ccc8b249',1777790557,13785,-1),
(79515983389581313,61,1,NULL,NULL,4096,4096,11,6,1,0,0,'c25a30813740e3f1c1cbab2b903961e8',1777790557,36192,-1),
(79515983452495873,60,1,NULL,NULL,1920,1281,17,17,1,0,0,'4584cfa4f8e9632d50c7b706a7c50fa3',1777790557,294390,-1),
(79515983658016769,59,1,NULL,NULL,256,256,17,17,0,1,0,'8af4a268473d45ccaac31d95fe82dde4',1777790557,13880,-1),
(79515983658016770,62,1,NULL,NULL,1600,1067,17,17,1,0,0,'5deccad4e0755b4af298ac09a2d59007',1777790557,165982,-1),
(79515983913869313,60,1,NULL,NULL,256,256,17,17,0,1,0,'4584cfa4f8e9632d50c7b706a7c50fa3',1777790557,15761,-1),
(79515984085835777,63,1,NULL,NULL,1600,1067,17,17,1,0,0,'8e0799197756257013abc937a7833da3',1777790557,147631,-1),
(79515984119390209,62,1,NULL,NULL,256,256,17,17,0,1,0,'5deccad4e0755b4af298ac09a2d59007',1777790557,13183,-1),
(79515984199081985,64,1,NULL,NULL,1200,1800,17,17,1,0,0,'ffb05665096005870756703ae068a3f8',1777790557,207095,-1),
(79515984387825665,63,1,NULL,NULL,256,256,17,17,0,1,0,'8e0799197756257013abc937a7833da3',1777790557,8563,-1),
(79515984597540865,64,1,NULL,NULL,256,256,17,17,0,1,0,'ffb05665096005870756703ae068a3f8',1777790557,8544,-1),
(79515984769507329,61,1,NULL,NULL,256,256,11,6,0,1,0,'c25a30813740e3f1c1cbab2b903961e8',1777790557,6477,-1),
(79558804574232576,117,4,NULL,79558804670701568,508,630,11,11,1,0,0,'69f7154189f2e',1777800527,84619,-1),
(79558812933480448,117,4,NULL,79558804670701568,64,64,11,11,0,1,0,'69f7154189f2e',1777800529,4107,-1),
(79599703614218241,133,6,NULL,79558804670701568,1273,721,11,11,1,0,0,'69f73a7eafa77',1777810050,1020614,-1),
(79599714896896001,133,6,NULL,79558804670701568,64,64,11,11,0,1,0,'69f73a7eafa77',1777810052,8727,-1);

--
-- Table structure for table `oc_privacy_admins`
--

CREATE TABLE `oc_privacy_admins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `displayname` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_privacy_admins`
--


--
-- Table structure for table `oc_profile_config`
--

CREATE TABLE `oc_profile_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) NOT NULL,
  `config` longtext NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `profile_config_user_id_idx` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_profile_config`
--

INSERT INTO `oc_profile_config` VALUES
(1,'admin','{\"address\":{\"visibility\":\"show_users_only\"},\"avatar\":{\"visibility\":\"show\"},\"biography\":{\"visibility\":\"show\"},\"displayname\":{\"visibility\":\"show\"},\"headline\":{\"visibility\":\"show\"},\"organisation\":{\"visibility\":\"show\"},\"role\":{\"visibility\":\"show\"},\"email\":{\"visibility\":\"show_users_only\"},\"phone\":{\"visibility\":\"show_users_only\"},\"twitter\":{\"visibility\":\"show\"},\"bluesky\":{\"visibility\":\"show\"},\"website\":{\"visibility\":\"show\"},\"pronouns\":{\"visibility\":\"show\"}}');

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

CREATE TABLE `oc_properties` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `userid` varchar(64) NOT NULL DEFAULT '',
  `propertypath` varchar(255) NOT NULL DEFAULT '',
  `propertyname` varchar(255) NOT NULL DEFAULT '',
  `propertyvalue` longtext NOT NULL,
  `valuetype` smallint(6) DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `properties_path_index` (`userid`,`propertypath`),
  KEY `properties_pathonly_index` (`propertypath`),
  KEY `properties_name_path_user` (`propertyname`,`propertypath`,`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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


--
-- Table structure for table `oc_ratelimit_entries`
--

CREATE TABLE `oc_ratelimit_entries` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `hash` varchar(128) NOT NULL,
  `delete_after` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ratelimit_hash` (`hash`),
  KEY `ratelimit_delete_after` (`delete_after`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_ratelimit_entries`
--

INSERT INTO `oc_ratelimit_entries` VALUES
(5,'1b836052357ac4360efafc91d3b412228e696cd6bf759e2de1d6d2f9fb2f0c5c8d6f51278b8dce1672023957841164b3ef6aae661f714f3cb3d8582206ec6ddf','2026-05-17 04:49:58'),
(6,'0d73ae4f56495c62c2756183e9fd091d18074e7a7a11eba39d0ee3bb06b92b0bc5db0c25ee0db30a9a29c2c325180179394fcd105bb599d03c3f35a1b3bb76f4','2026-05-17 03:54:16');

--
-- Table structure for table `oc_reactions`
--

CREATE TABLE `oc_reactions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) unsigned NOT NULL,
  `message_id` bigint(20) unsigned NOT NULL,
  `actor_type` varchar(64) NOT NULL DEFAULT '',
  `actor_id` varchar(64) NOT NULL DEFAULT '',
  `reaction` varchar(32) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `comment_reaction_unique` (`parent_id`,`actor_type`,`actor_id`,`reaction`),
  KEY `comment_reaction` (`reaction`),
  KEY `comment_reaction_parent_id` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_reactions`
--


--
-- Table structure for table `oc_recent_contact`
--

CREATE TABLE `oc_recent_contact` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `actor_uid` varchar(64) NOT NULL,
  `uid` varchar(64) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `federated_cloud_id` varchar(255) DEFAULT NULL,
  `card` longblob NOT NULL,
  `last_contact` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `recent_contact_actor_uid` (`actor_uid`),
  KEY `recent_contact_id_uid` (`id`,`actor_uid`),
  KEY `recent_contact_uid` (`uid`),
  KEY `recent_contact_email` (`email`),
  KEY `recent_contact_fed_id` (`federated_cloud_id`),
  KEY `recent_contact_last_contact` (`last_contact`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_recent_contact`
--


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

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

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


--
-- Table structure for table `oc_sec_signatory`
--

CREATE TABLE `oc_sec_signatory` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `key_id_sum` varchar(127) NOT NULL,
  `key_id` varchar(512) NOT NULL,
  `host` varchar(512) NOT NULL,
  `provider_id` varchar(31) NOT NULL,
  `account` varchar(127) DEFAULT '',
  `public_key` longtext NOT NULL DEFAULT '',
  `metadata` longtext NOT NULL DEFAULT '[]',
  `type` smallint(6) NOT NULL DEFAULT 9,
  `status` smallint(6) NOT NULL DEFAULT 0,
  `creation` int(10) unsigned DEFAULT 0,
  `last_updated` int(10) unsigned DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sec_sig_unic` (`provider_id`,`host`,`account`),
  KEY `sec_sig_key` (`key_id_sum`,`provider_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_sec_signatory`
--


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

CREATE TABLE `oc_share` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `share_type` smallint(6) NOT NULL DEFAULT 0,
  `share_with` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `uid_owner` varchar(64) NOT NULL DEFAULT '',
  `uid_initiator` varchar(64) DEFAULT NULL,
  `parent` bigint(20) DEFAULT NULL,
  `item_type` varchar(64) NOT NULL DEFAULT '',
  `item_source` varchar(255) DEFAULT NULL,
  `item_target` varchar(255) DEFAULT NULL,
  `file_source` bigint(20) DEFAULT NULL,
  `file_target` varchar(512) DEFAULT NULL,
  `permissions` smallint(6) NOT NULL DEFAULT 0,
  `stime` bigint(20) NOT NULL DEFAULT 0,
  `accepted` smallint(6) NOT NULL DEFAULT 0,
  `expiration` datetime DEFAULT NULL,
  `token` varchar(32) DEFAULT NULL,
  `mail_send` smallint(6) NOT NULL DEFAULT 0,
  `share_name` varchar(64) DEFAULT NULL,
  `password_by_talk` tinyint(1) DEFAULT 0,
  `note` longtext DEFAULT NULL,
  `hide_download` smallint(6) DEFAULT 0,
  `label` varchar(255) DEFAULT NULL,
  `attributes` longtext DEFAULT NULL COMMENT '(DC2Type:json)' CHECK (json_valid(`attributes`)),
  `password_expiration_time` datetime DEFAULT NULL,
  `reminder_sent` tinyint(1) DEFAULT 0,
  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 `share_with_file_target_index` (`share_with`,`file_target`(128)),
  KEY `parent_index` (`parent`),
  KEY `owner_index` (`uid_owner`),
  KEY `initiator_index` (`uid_initiator`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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


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

CREATE TABLE `oc_share_external` (
  `id` bigint(20) NOT NULL,
  `parent` bigint(20) DEFAULT -1,
  `share_type` int(11) DEFAULT NULL,
  `remote` varchar(512) NOT NULL,
  `remote_id` varchar(255) DEFAULT '',
  `share_token` varchar(64) NOT NULL,
  `password` varchar(64) DEFAULT NULL,
  `name` varchar(4000) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `user` varchar(64) NOT NULL,
  `mountpoint` varchar(4000) NOT NULL,
  `mountpoint_hash` varchar(32) NOT NULL,
  `accepted` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sh_external_mp` (`user`,`mountpoint_hash`),
  KEY `user_mountpoint_index` (`user`,`mountpoint`(128))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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


--
-- Table structure for table `oc_shares_limits`
--

CREATE TABLE `oc_shares_limits` (
  `id` varchar(32) NOT NULL,
  `limit` bigint(20) NOT NULL,
  `downloads` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_shares_limits`
--


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

CREATE TABLE `oc_storages` (
  `numeric_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `id` varchar(64) DEFAULT NULL,
  `available` int(11) NOT NULL DEFAULT 1,
  `last_checked` int(11) 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
(1,'home::admin',1,NULL),
(2,'local::/home/fhub/nc_data/',1,NULL),
(3,'amazon::external::a8f9ef231e1e7362dba000b3d9036160',0,1777809334),
(4,'object::user:admin',1,NULL),
(5,'object::store:amazon::nextcloud',1,NULL),
(6,'amazon::external::943e741a5ef2dba8d8cc6e7f37e367a6',1,1778990102),
(7,'object::user:fluencyhub',1,NULL);

--
-- Table structure for table `oc_storages_credentials`
--

CREATE TABLE `oc_storages_credentials` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user` varchar(64) DEFAULT NULL,
  `identifier` varchar(64) NOT NULL,
  `credentials` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `stocred_ui` (`user`,`identifier`),
  KEY `stocred_user` (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_storages_credentials`
--


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

CREATE TABLE `oc_systemtag` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL DEFAULT '',
  `visibility` smallint(6) NOT NULL DEFAULT 1,
  `editable` smallint(6) NOT NULL DEFAULT 1,
  `etag` varchar(32) DEFAULT NULL,
  `color` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tag_ident` (`name`,`visibility`,`editable`)
) 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` bigint(20) unsigned NOT NULL DEFAULT 0,
  `gid` varchar(255) 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) NOT NULL DEFAULT '',
  `objecttype` varchar(64) NOT NULL DEFAULT '',
  `systemtagid` bigint(20) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`objecttype`,`objectid`,`systemtagid`),
  KEY `systag_by_tagid` (`systemtagid`,`objecttype`),
  KEY `systag_by_objectid` (`objectid`),
  KEY `systag_objecttype` (`objecttype`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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


--
-- Table structure for table `oc_talk_attachments`
--

CREATE TABLE `oc_talk_attachments` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `room_id` bigint(20) unsigned NOT NULL,
  `message_id` bigint(20) unsigned NOT NULL,
  `message_time` bigint(20) unsigned NOT NULL,
  `object_type` varchar(64) NOT NULL,
  `actor_type` varchar(64) NOT NULL,
  `actor_id` varchar(64) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `objects_in_room` (`room_id`,`object_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_attachments`
--


--
-- Table structure for table `oc_talk_attendees`
--

CREATE TABLE `oc_talk_attendees` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `room_id` bigint(20) unsigned NOT NULL,
  `actor_type` varchar(32) NOT NULL,
  `actor_id` varchar(255) NOT NULL,
  `display_name` varchar(255) DEFAULT '',
  `pin` varchar(32) DEFAULT NULL,
  `participant_type` smallint(5) unsigned NOT NULL DEFAULT 0,
  `favorite` tinyint(1) DEFAULT 0,
  `notification_level` int(11) DEFAULT 0,
  `last_joined_call` int(10) unsigned NOT NULL DEFAULT 0,
  `last_read_message` bigint(20) DEFAULT 0,
  `last_mention_message` bigint(20) DEFAULT 0,
  `read_privacy` smallint(5) unsigned DEFAULT 0,
  `access_token` varchar(64) DEFAULT NULL,
  `remote_id` varchar(255) DEFAULT NULL,
  `last_mention_direct` bigint(20) NOT NULL DEFAULT 0,
  `permissions` int(11) NOT NULL DEFAULT 0,
  `notification_calls` int(11) NOT NULL DEFAULT 1,
  `phone_number` varchar(255) DEFAULT '',
  `call_id` varchar(255) DEFAULT '',
  `invited_cloud_id` varchar(255) DEFAULT NULL,
  `state` smallint(5) unsigned NOT NULL DEFAULT 0,
  `unread_messages` bigint(20) unsigned NOT NULL DEFAULT 0,
  `last_attendee_activity` bigint(20) unsigned NOT NULL DEFAULT 0,
  `archived` tinyint(1) DEFAULT 0,
  `important` tinyint(1) DEFAULT 0,
  `sensitive` tinyint(1) DEFAULT 0,
  `has_unread_threads` tinyint(1) DEFAULT 0,
  `has_unread_thread_mentions` tinyint(1) DEFAULT 0,
  `has_unread_thread_directs` tinyint(1) DEFAULT 0,
  `hidden_pinned_id` bigint(20) DEFAULT 0,
  `has_scheduled_messages` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ta_ident` (`room_id`,`actor_type`,`actor_id`),
  KEY `ta_roompin` (`room_id`,`pin`),
  KEY `ta_actor` (`actor_type`,`actor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_attendees`
--


--
-- Table structure for table `oc_talk_bans`
--

CREATE TABLE `oc_talk_bans` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `moderator_actor_type` varchar(32) NOT NULL,
  `moderator_actor_id` varchar(255) NOT NULL,
  `moderator_displayname` varchar(255) DEFAULT NULL,
  `banned_actor_type` varchar(32) NOT NULL,
  `banned_actor_id` varchar(255) NOT NULL,
  `banned_displayname` varchar(255) DEFAULT NULL,
  `room_id` bigint(20) unsigned NOT NULL,
  `banned_time` datetime DEFAULT NULL,
  `internal_note` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `talk_room_bans` (`banned_actor_type`,`banned_actor_id`,`room_id`),
  KEY `IDX_6F1A533454177093` (`room_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_bans`
--


--
-- Table structure for table `oc_talk_bots_conversation`
--

CREATE TABLE `oc_talk_bots_conversation` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `bot_id` bigint(20) unsigned NOT NULL DEFAULT 0,
  `token` varchar(64) DEFAULT NULL,
  `state` smallint(5) unsigned DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `talk_bots_convo_uniq` (`bot_id`,`token`),
  KEY `talk_bots_convo_token` (`token`,`state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_bots_conversation`
--


--
-- Table structure for table `oc_talk_bots_server`
--

CREATE TABLE `oc_talk_bots_server` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `url` varchar(4000) NOT NULL,
  `url_hash` varchar(64) NOT NULL,
  `description` varchar(4000) DEFAULT NULL,
  `secret` varchar(128) NOT NULL,
  `error_count` bigint(20) unsigned NOT NULL DEFAULT 0,
  `last_error_date` datetime DEFAULT NULL,
  `last_error_message` varchar(4000) DEFAULT NULL,
  `state` smallint(5) unsigned DEFAULT 0,
  `features` int(10) unsigned NOT NULL DEFAULT 3,
  PRIMARY KEY (`id`),
  UNIQUE KEY `talk_bots_server_urlhash` (`url_hash`),
  UNIQUE KEY `talk_bots_server_secret` (`secret`),
  KEY `talk_bots_server_state` (`state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_bots_server`
--


--
-- Table structure for table `oc_talk_bridges`
--

CREATE TABLE `oc_talk_bridges` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `room_id` bigint(20) unsigned NOT NULL,
  `json_values` longtext NOT NULL,
  `enabled` smallint(5) unsigned NOT NULL DEFAULT 0,
  `pid` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tbr_room_id` (`room_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_bridges`
--


--
-- Table structure for table `oc_talk_commands`
--

CREATE TABLE `oc_talk_commands` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `app` varchar(64) DEFAULT '',
  `name` varchar(64) NOT NULL,
  `command` varchar(64) NOT NULL,
  `script` longtext NOT NULL,
  `response` int(11) NOT NULL DEFAULT 1,
  `enabled` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_commands`
--


--
-- Table structure for table `oc_talk_consent`
--

CREATE TABLE `oc_talk_consent` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `token` varchar(64) NOT NULL,
  `actor_type` varchar(64) NOT NULL,
  `actor_id` varchar(64) NOT NULL,
  `date_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `talk_reccons_token` (`token`),
  KEY `talk_reccons_actor` (`actor_id`,`actor_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_consent`
--


--
-- Table structure for table `oc_talk_internalsignaling`
--

CREATE TABLE `oc_talk_internalsignaling` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `sender` varchar(512) NOT NULL,
  `recipient` varchar(512) NOT NULL,
  `message` longtext NOT NULL,
  `timestamp` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tis_recipient_time` (`recipient`,`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_internalsignaling`
--


--
-- Table structure for table `oc_talk_invitations`
--

CREATE TABLE `oc_talk_invitations` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) NOT NULL,
  `state` smallint(5) unsigned NOT NULL DEFAULT 0,
  `local_room_id` bigint(20) unsigned NOT NULL,
  `access_token` varchar(64) NOT NULL,
  `remote_server_url` varchar(512) NOT NULL,
  `remote_token` varchar(32) NOT NULL,
  `remote_attendee_id` bigint(20) unsigned NOT NULL,
  `inviter_cloud_id` varchar(255) DEFAULT NULL,
  `inviter_display_name` varchar(255) DEFAULT NULL,
  `local_cloud_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `talk_fedinv_remote` (`remote_server_url`,`remote_attendee_id`),
  KEY `talk_fedinv_lri` (`local_room_id`),
  KEY `talk_user_state` (`user_id`,`state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_invitations`
--


--
-- Table structure for table `oc_talk_phone_numbers`
--

CREATE TABLE `oc_talk_phone_numbers` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(255) NOT NULL,
  `actor_id` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_5E5DC3C46B01BC5B` (`phone_number`),
  KEY `IDX_5E5DC3C410DAF24A` (`actor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_phone_numbers`
--


--
-- Table structure for table `oc_talk_poll_votes`
--

CREATE TABLE `oc_talk_poll_votes` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `poll_id` bigint(20) NOT NULL,
  `room_id` bigint(20) NOT NULL,
  `actor_type` varchar(64) NOT NULL,
  `actor_id` varchar(64) NOT NULL,
  `display_name` varchar(255) DEFAULT NULL,
  `option_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `talk_poll_vote` (`poll_id`,`actor_type`,`actor_id`),
  KEY `talk_vote_room` (`room_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_poll_votes`
--


--
-- Table structure for table `oc_talk_polls`
--

CREATE TABLE `oc_talk_polls` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `room_id` bigint(20) NOT NULL,
  `question` longtext DEFAULT NULL,
  `options` longtext DEFAULT NULL,
  `votes` longtext DEFAULT NULL,
  `num_voters` bigint(20) DEFAULT 0,
  `actor_type` varchar(64) NOT NULL,
  `actor_id` varchar(64) NOT NULL,
  `display_name` varchar(255) DEFAULT NULL,
  `status` smallint(6) DEFAULT 0,
  `result_mode` smallint(6) DEFAULT 0,
  `max_votes` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `talk_poll_room` (`room_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_polls`
--


--
-- Table structure for table `oc_talk_proxy_messages`
--

CREATE TABLE `oc_talk_proxy_messages` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `local_token` varchar(32) NOT NULL,
  `remote_server_url` varchar(512) NOT NULL,
  `remote_token` varchar(32) NOT NULL,
  `remote_message_id` bigint(20) unsigned NOT NULL,
  `actor_type` varchar(64) NOT NULL,
  `actor_id` varchar(64) NOT NULL,
  `actor_display_name` varchar(255) DEFAULT NULL,
  `message_type` varchar(64) NOT NULL,
  `system_message` varchar(64) DEFAULT NULL,
  `expiration_datetime` datetime DEFAULT NULL,
  `message` longtext DEFAULT NULL,
  `message_parameters` longtext DEFAULT NULL,
  `creation_datetime` datetime DEFAULT NULL,
  `meta_data` longtext DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `talk_pcm_remote` (`remote_server_url`,`remote_token`,`remote_message_id`),
  KEY `talk_pmc_local` (`local_token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_proxy_messages`
--


--
-- Table structure for table `oc_talk_reminders`
--

CREATE TABLE `oc_talk_reminders` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) NOT NULL,
  `token` varchar(64) NOT NULL,
  `message_id` bigint(20) unsigned NOT NULL,
  `date_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `talk_reminder_user_msg` (`user_id`,`message_id`),
  KEY `talk_reminder_exectime` (`date_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_reminders`
--


--
-- Table structure for table `oc_talk_retry_ocm`
--

CREATE TABLE `oc_talk_retry_ocm` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `remote_server` varchar(255) NOT NULL,
  `num_attempts` int(10) unsigned NOT NULL DEFAULT 0,
  `next_retry` datetime DEFAULT NULL,
  `notification_type` varchar(64) NOT NULL,
  `resource_type` varchar(64) NOT NULL,
  `provider_id` varchar(64) NOT NULL,
  `notification` longtext NOT NULL,
  PRIMARY KEY (`id`),
  KEY `talk_retry_ocm_next` (`next_retry`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_retry_ocm`
--


--
-- Table structure for table `oc_talk_rooms`
--

CREATE TABLE `oc_talk_rooms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT '',
  `token` varchar(32) DEFAULT '',
  `type` int(11) NOT NULL,
  `password` varchar(255) DEFAULT '',
  `active_since` datetime DEFAULT NULL,
  `last_activity` datetime DEFAULT NULL,
  `last_message` bigint(20) DEFAULT 0,
  `object_type` varchar(64) DEFAULT '',
  `object_id` varchar(64) DEFAULT '',
  `read_only` int(11) NOT NULL DEFAULT 0,
  `lobby_state` int(11) NOT NULL DEFAULT 0,
  `lobby_timer` datetime DEFAULT NULL,
  `assigned_hpb` int(11) DEFAULT NULL,
  `sip_enabled` smallint(5) unsigned NOT NULL DEFAULT 0,
  `description` longtext DEFAULT '',
  `listable` smallint(5) unsigned DEFAULT 0,
  `call_flag` int(11) NOT NULL DEFAULT 0,
  `default_permissions` int(11) NOT NULL DEFAULT 0,
  `call_permissions` int(11) NOT NULL DEFAULT 0,
  `remote_server` varchar(512) DEFAULT NULL,
  `remote_token` varchar(32) DEFAULT NULL,
  `message_expiration` int(11) NOT NULL DEFAULT 0,
  `breakout_room_mode` int(11) NOT NULL DEFAULT 0,
  `breakout_room_status` int(11) NOT NULL DEFAULT 0,
  `avatar` varchar(24) DEFAULT '',
  `call_recording` int(11) NOT NULL DEFAULT 0,
  `recording_consent` smallint(5) unsigned NOT NULL DEFAULT 0,
  `has_federation` smallint(5) unsigned NOT NULL DEFAULT 0,
  `mention_permissions` int(11) NOT NULL DEFAULT 0,
  `has_attachments` smallint(6) DEFAULT 0,
  `transcription_language` varchar(16) DEFAULT '',
  `last_pinned_id` bigint(20) DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tr_room_token` (`token`),
  KEY `last_active` (`last_activity`),
  KEY `tr_room_object` (`object_type`,`object_id`),
  KEY `tr_listable` (`listable`),
  KEY `remote_id` (`remote_server`,`remote_token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_rooms`
--


--
-- Table structure for table `oc_talk_scheduled_msg`
--

CREATE TABLE `oc_talk_scheduled_msg` (
  `id` bigint(20) unsigned NOT NULL,
  `room_id` bigint(20) NOT NULL,
  `actor_id` varchar(64) NOT NULL,
  `actor_type` varchar(64) NOT NULL,
  `message` longtext DEFAULT '',
  `message_type` varchar(64) NOT NULL,
  `meta_data` longtext DEFAULT NULL,
  `thread_id` bigint(20) NOT NULL DEFAULT 0,
  `parent_id` bigint(20) DEFAULT NULL,
  `send_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tt_room_sched` (`room_id`),
  KEY `tt_actor_room_sched` (`room_id`,`actor_type`,`actor_id`),
  KEY `tt_send_at_sched` (`send_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_scheduled_msg`
--


--
-- Table structure for table `oc_talk_sessions`
--

CREATE TABLE `oc_talk_sessions` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `attendee_id` bigint(20) unsigned NOT NULL,
  `session_id` varchar(512) NOT NULL,
  `in_call` int(11) NOT NULL DEFAULT 0,
  `last_ping` int(10) unsigned NOT NULL DEFAULT 0,
  `state` smallint(5) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ts_session` (`session_id`),
  KEY `ts_in_call` (`in_call`),
  KEY `ts_last_ping` (`last_ping`),
  KEY `ts_attendee_id` (`attendee_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_sessions`
--


--
-- Table structure for table `oc_talk_thread_attendees`
--

CREATE TABLE `oc_talk_thread_attendees` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `room_id` bigint(20) NOT NULL,
  `thread_id` bigint(20) NOT NULL,
  `attendee_id` bigint(20) NOT NULL,
  `actor_type` varchar(255) NOT NULL,
  `actor_id` varchar(255) NOT NULL,
  `notification_level` int(11) DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tta_throom_attendee` (`thread_id`,`room_id`,`actor_type`,`actor_id`),
  KEY `tta_room_attendee` (`room_id`,`actor_type`,`actor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_thread_attendees`
--


--
-- Table structure for table `oc_talk_threads`
--

CREATE TABLE `oc_talk_threads` (
  `id` bigint(20) NOT NULL,
  `room_id` bigint(20) NOT NULL,
  `last_message_id` bigint(20) NOT NULL DEFAULT 0,
  `num_replies` bigint(20) NOT NULL DEFAULT 0,
  `last_activity` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `tt_room_threads` (`room_id`),
  KEY `talkthread_lastactive` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_talk_threads`
--


--
-- Table structure for table `oc_taskprocessing_tasks`
--

CREATE TABLE `oc_taskprocessing_tasks` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `input` longtext NOT NULL,
  `output` longtext DEFAULT NULL,
  `status` int(11) DEFAULT 0,
  `user_id` varchar(64) DEFAULT NULL,
  `app_id` varchar(32) NOT NULL DEFAULT '',
  `custom_id` varchar(255) DEFAULT '',
  `last_updated` int(10) unsigned DEFAULT 0,
  `completion_expected_at` datetime DEFAULT NULL,
  `progress` double DEFAULT 0,
  `error_message` varchar(4000) DEFAULT NULL,
  `scheduled_at` int(10) unsigned DEFAULT NULL,
  `started_at` int(10) unsigned DEFAULT NULL,
  `ended_at` int(10) unsigned DEFAULT NULL,
  `webhook_uri` varchar(4000) DEFAULT NULL,
  `webhook_method` varchar(64) DEFAULT NULL,
  `allow_cleanup` smallint(5) unsigned NOT NULL DEFAULT 1,
  `user_facing_error_message` varchar(4000) DEFAULT NULL,
  `include_watermark` smallint(5) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `taskp_tasks_status_type` (`status`,`type`),
  KEY `taskp_tasks_updated` (`last_updated`),
  KEY `taskp_tasks_uid_appid_cid` (`user_id`,`app_id`,`custom_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_taskprocessing_tasks`
--


--
-- Table structure for table `oc_text2image_tasks`
--

CREATE TABLE `oc_text2image_tasks` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `input` longtext NOT NULL,
  `status` int(11) DEFAULT 0,
  `number_of_images` int(11) NOT NULL DEFAULT 1,
  `user_id` varchar(64) DEFAULT NULL,
  `app_id` varchar(32) NOT NULL DEFAULT '',
  `identifier` varchar(255) DEFAULT '',
  `last_updated` datetime DEFAULT NULL,
  `completion_expected_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `t2i_tasks_updated` (`last_updated`),
  KEY `t2i_tasks_status` (`status`),
  KEY `t2i_tasks_uid_appid_ident` (`user_id`,`app_id`,`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_text2image_tasks`
--


--
-- Table structure for table `oc_text_documents`
--

CREATE TABLE `oc_text_documents` (
  `id` bigint(20) unsigned NOT NULL,
  `current_version` bigint(20) unsigned DEFAULT 0,
  `last_saved_version` bigint(20) unsigned DEFAULT 0,
  `last_saved_version_time` bigint(20) unsigned NOT NULL,
  `last_saved_version_etag` varchar(64) DEFAULT '',
  `base_version_etag` varchar(64) DEFAULT '',
  `checksum` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_text_documents`
--


--
-- Table structure for table `oc_text_sessions`
--

CREATE TABLE `oc_text_sessions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) DEFAULT NULL,
  `guest_name` varchar(64) DEFAULT NULL,
  `color` varchar(7) DEFAULT NULL,
  `token` varchar(64) NOT NULL,
  `document_id` bigint(20) NOT NULL,
  `last_contact` bigint(20) unsigned NOT NULL,
  `last_awareness_message` longtext DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `rd_session_token_idx` (`token`),
  KEY `ts_lastcontact` (`last_contact`),
  KEY `ts_docid_lastcontact` (`document_id`,`last_contact`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_text_sessions`
--


--
-- Table structure for table `oc_text_steps`
--

CREATE TABLE `oc_text_steps` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `document_id` bigint(20) unsigned NOT NULL,
  `session_id` bigint(20) unsigned NOT NULL,
  `data` longtext NOT NULL,
  `version` bigint(20) unsigned DEFAULT 0,
  `timestamp` bigint(20) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `rd_steps_did_idx` (`document_id`),
  KEY `rd_steps_version_idx` (`version`),
  KEY `textstep_session` (`session_id`),
  KEY `text_steps_doc_id_id_index` (`document_id`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_text_steps`
--


--
-- Table structure for table `oc_textprocessing_tasks`
--

CREATE TABLE `oc_textprocessing_tasks` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) NOT NULL,
  `input` longtext NOT NULL,
  `output` longtext DEFAULT NULL,
  `status` int(11) DEFAULT 0,
  `user_id` varchar(64) DEFAULT NULL,
  `app_id` varchar(32) NOT NULL DEFAULT '',
  `identifier` varchar(255) NOT NULL DEFAULT '',
  `last_updated` int(10) unsigned DEFAULT 0,
  `completion_expected_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tp_tasks_updated` (`last_updated`),
  KEY `tp_tasks_status_type_nonunique` (`status`,`type`),
  KEY `tp_tasks_uid_appid_ident` (`user_id`,`app_id`,`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_textprocessing_tasks`
--


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

CREATE TABLE `oc_trusted_servers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(512) NOT NULL,
  `url_hash` varchar(255) NOT NULL DEFAULT '',
  `token` varchar(128) DEFAULT NULL,
  `shared_secret` varchar(256) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT 2,
  `sync_token` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `url_hash` (`url_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

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


--
-- Table structure for table `oc_twofactor_backupcodes`
--

CREATE TABLE `oc_twofactor_backupcodes` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) NOT NULL DEFAULT '',
  `code` varchar(128) NOT NULL,
  `used` smallint(6) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `twofactor_backupcodes_uid` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_twofactor_backupcodes`
--


--
-- Table structure for table `oc_twofactor_providers`
--

CREATE TABLE `oc_twofactor_providers` (
  `provider_id` varchar(32) NOT NULL,
  `uid` varchar(64) NOT NULL,
  `enabled` smallint(6) NOT NULL,
  PRIMARY KEY (`provider_id`,`uid`),
  KEY `twofactor_providers_uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_twofactor_providers`
--

INSERT INTO `oc_twofactor_providers` VALUES
('backup_codes','admin',0),
('backup_codes','fluencyhub',0),
('totp','admin',0),
('totp','fluencyhub',0);

--
-- Table structure for table `oc_twofactor_totp_secrets`
--

CREATE TABLE `oc_twofactor_totp_secrets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) NOT NULL DEFAULT '',
  `secret` longtext NOT NULL,
  `state` int(11) NOT NULL DEFAULT 2,
  `last_counter` bigint(20) NOT NULL DEFAULT -1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `totp_secrets_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_twofactor_totp_secrets`
--


--
-- Table structure for table `oc_user_status`
--

CREATE TABLE `oc_user_status` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `status_timestamp` int(10) unsigned NOT NULL,
  `is_user_defined` tinyint(1) DEFAULT NULL,
  `message_id` varchar(255) DEFAULT NULL,
  `custom_icon` varchar(255) DEFAULT NULL,
  `custom_message` longtext DEFAULT NULL,
  `clear_at` int(10) unsigned DEFAULT NULL,
  `is_backup` tinyint(1) DEFAULT 0,
  `status_message_timestamp` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_status_uid_ix` (`user_id`),
  KEY `user_status_clr_ix` (`clear_at`),
  KEY `user_status_tstmp_ix` (`status_timestamp`),
  KEY `user_status_iud_ix` (`is_user_defined`,`status`),
  KEY `user_status_mtstmp_ix` (`status_message_timestamp`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_user_status`
--

INSERT INTO `oc_user_status` VALUES
(1,'admin','online',1778998567,0,NULL,NULL,NULL,NULL,0,0),
(2,'fluencyhub','away',1778998908,0,NULL,NULL,NULL,NULL,0,0);

--
-- Table structure for table `oc_user_transfer_owner`
--

CREATE TABLE `oc_user_transfer_owner` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `source_user` varchar(64) NOT NULL,
  `target_user` varchar(64) NOT NULL,
  `file_id` bigint(20) NOT NULL,
  `node_name` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_user_transfer_owner`
--


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

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

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

INSERT INTO `oc_users` VALUES
('admin',NULL,'3|$argon2id$v=19$m=65536,t=4,p=1$NThES05EQUUvZFR3SmRLeg$1B8TEuk1N66UrZOSA0g2XdYY41QTwYyjWZe/QCxOuOc','admin'),
('fluencyhub','FluencyHub','3|$argon2id$v=19$m=65536,t=4,p=1$R3dPU09DWVN1UXouYllCdA$1ZgVigZQOqJqMQZ+97mglg5yJItBHT8mAiITdBMnmFw','fluencyhub');

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

CREATE TABLE `oc_vcategory` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(64) NOT NULL DEFAULT '',
  `type` varchar(64) NOT NULL DEFAULT '',
  `category` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_category_per_user` (`uid`,`type`,`category`),
  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(20) unsigned NOT NULL DEFAULT 0,
  `categoryid` bigint(20) unsigned NOT NULL DEFAULT 0,
  `type` varchar(64) 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`
--


--
-- Table structure for table `oc_webauthn`
--

CREATE TABLE `oc_webauthn` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(64) NOT NULL,
  `name` varchar(64) NOT NULL,
  `public_key_credential_id` varchar(512) NOT NULL,
  `data` longtext NOT NULL,
  `user_verification` tinyint(1) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `webauthn_uid` (`uid`),
  KEY `webauthn_publicKeyCredentialId` (`public_key_credential_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_webauthn`
--


--
-- Table structure for table `oc_webhook_listeners`
--

CREATE TABLE `oc_webhook_listeners` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `app_id` varchar(64) DEFAULT NULL,
  `user_id` varchar(64) DEFAULT NULL,
  `http_method` varchar(32) NOT NULL,
  `uri` varchar(4000) NOT NULL,
  `event` varchar(4000) NOT NULL,
  `event_filter` longtext DEFAULT NULL,
  `user_id_filter` varchar(64) DEFAULT NULL,
  `headers` longtext DEFAULT NULL,
  `auth_method` varchar(16) NOT NULL DEFAULT '',
  `auth_data` longtext DEFAULT NULL,
  `token_needed` longtext DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_webhook_listeners`
--


--
-- Table structure for table `oc_webhook_tokens`
--

CREATE TABLE `oc_webhook_tokens` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `token_id` bigint(20) unsigned NOT NULL,
  `user_id` varchar(64) DEFAULT NULL,
  `created_at` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `oc_webhook_tokens`
--



