File Manager

X7ROOT File Manager

Current Path: /var/softaculous/nextcloud

?? ..
?? .htaccess(7.1 KB)
?? _.htaccess(534 B)
?? changelog.txt(183.49 KB)
?? check_suphp.php(101 B)
?? clone.php(5.7 KB)
?? config.php(524 B)
?? data.zip(55.47 MB)
?? edit.php(5.81 KB)
?? edit.xml(433 B)
?? extend.php(6.9 KB)
?? fileindex.php(293 B)
?? images
?? import.php(3.55 KB)
?? info.xml(4.67 KB)
?? install.js(924 B)
?? install.php(16.41 KB)
?? install.xml(1.59 KB)
?? md5(1.39 KB)
?? nextcloud.sql(218.04 KB)
?? nextcloud.zip(682.1 MB)
?? notes.txt(2.67 KB)
?? php53
?? php56
?? php71
?? php81
?? php82
?? update_pass.php(1.02 KB)
?? upgrade.php(5.43 KB)
?? upgrade.xml(299 B)

Editing: nextcloud.sql

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

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

--
-- Database: `nextcloud3300apps`
--

-- --------------------------------------------------------

--
-- Table structure for table `oc_accounts`
--

CREATE TABLE `oc_accounts` (
  `uid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `data` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

--
-- Table structure for table `oc_accounts_data`
--

CREATE TABLE `oc_accounts_data` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `uid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `value` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `accounts_data_uid` (`uid`),
  KEY `accounts_data_name` (`name`),
  KEY `accounts_data_value` (`value`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=16 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_activity`
--

CREATE TABLE `oc_activity` (
  `activity_id` bigint NOT NULL AUTO_INCREMENT,
  `timestamp` int NOT NULL DEFAULT '0',
  `priority` int NOT NULL DEFAULT '0',
  `type` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `user` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `affecteduser` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `app` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `subject` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `subjectparams` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `message` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `messageparams` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `file` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `link` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `object_type` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `object_id` bigint NOT NULL DEFAULT '0',
  PRIMARY KEY (`activity_id`),
  KEY `activity_user_time` (`affecteduser`,`timestamp`),
  KEY `activity_filter_by` (`affecteduser`,`user`,`timestamp`),
  KEY `activity_filter` (`affecteduser`,`type`,`app`,`timestamp`),
  KEY `activity_object` (`object_type`,`object_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_activity_mq`
--

CREATE TABLE `oc_activity_mq` (
  `mail_id` bigint NOT NULL AUTO_INCREMENT,
  `amq_timestamp` int NOT NULL DEFAULT '0',
  `amq_latest_send` int NOT NULL DEFAULT '0',
  `amq_type` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `amq_affecteduser` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `amq_appid` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `amq_subject` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `amq_subjectparams` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `object_type` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `object_id` bigint NOT NULL DEFAULT '0',
  PRIMARY KEY (`mail_id`),
  KEY `amp_user` (`amq_affecteduser`),
  KEY `amp_latest_send_time` (`amq_latest_send`),
  KEY `amp_timestamp_time` (`amq_timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_addressbookchanges`
--

CREATE TABLE `oc_addressbookchanges` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uri` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `synctoken` int unsigned NOT NULL DEFAULT '1',
  `addressbookid` bigint NOT NULL,
  `operation` smallint NOT NULL,
  `created_at` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `addressbookid_synctoken` (`addressbookid`,`synctoken`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=2 ;

--
-- Dumping data for table `oc_addressbookchanges`
--

INSERT INTO `oc_addressbookchanges` VALUES
(1, 'default', 1, 2, 1, [[timestamp]]);

-- --------------------------------------------------------

--
-- Table structure for table `oc_addressbooks`
--

CREATE TABLE `oc_addressbooks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `principaluri` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `displayname` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `uri` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `description` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `synctoken` int unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `addressbook_index` (`principaluri`,`uri`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=3 ;

--
-- Dumping data for table `oc_addressbooks`
--

INSERT INTO `oc_addressbooks` VALUES
(1, 'principals/system/system', 'system', 'system', 'System addressbook which holds all users of this instance', 1),
(2, 'principals/users/[[admin_username]]', 'Contacts', 'contacts', NULL, 2);

-- --------------------------------------------------------

--
-- Table structure for table `oc_appconfig`
--

CREATE TABLE `oc_appconfig` (
  `appid` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `configkey` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `configvalue` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `type` int unsigned NOT NULL DEFAULT '2',
  `lazy` smallint unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`appid`,`configkey`),
  KEY `ac_lazy_i` (`lazy`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin;

--
-- Dumping data for table `oc_appconfig`
--

INSERT INTO `oc_appconfig` VALUES
('activity', 'enabled', 'yes', 2, 0),
('activity', 'installed_version', '6.0.0-dev.0', 2, 0),
('activity', 'types', 'filesystem', 2, 0),
('app_api', 'enabled', 'yes', 2, 0),
('app_api', 'installed_version', '33.0.0', 2, 0),
('app_api', 'types', '', 2, 0),
('backgroundjob', 'lastjob', '52486071908868096', 2, 0),
('bruteforcesettings', 'enabled', 'yes', 2, 0),
('bruteforcesettings', 'installed_version', '6.0.0-dev.0', 2, 0),
('bruteforcesettings', 'types', '', 2, 0),
('calendar', 'enabled', 'yes', 2, 0),
('calendar', 'installed_version', '6.2.0', 2, 0),
('calendar', 'types', '', 2, 0),
('circles', 'enabled', 'yes', 2, 0),
('circles', 'installed_version', '33.0.0', 2, 0),
('circles', 'loopback_tmp_path', '[[relativeurl]]', 4, 0),
('circles', 'loopback_tmp_scheme', '[[protocol]]', 4, 0),
('circles', 'types', 'filesystem,dav', 2, 0),
('cloud_federation_api', 'enabled', 'yes', 2, 0),
('cloud_federation_api', 'installed_version', '1.17.0', 2, 0),
('cloud_federation_api', 'types', 'filesystem', 2, 0),
('comments', 'enabled', 'yes', 2, 0),
('comments', 'installed_version', '1.23.0', 2, 0),
('comments', 'types', 'logging', 2, 0),
('contacts', 'enabled', 'yes', 2, 0),
('contacts', 'installed_version', '8.3.3', 2, 0),
('contacts', 'types', 'dav', 2, 0),
('contactsinteraction', 'enabled', 'yes', 2, 0),
('contactsinteraction', 'installed_version', '1.14.1', 2, 0),
('contactsinteraction', 'types', 'dav', 2, 0),
('core', 'files_metadata', '{"photos-original_date_time":{"value":null,"type":"int","etag":"","indexed":true,"editPermission":0},"photos-size":{"value":null,"type":"array","etag":"","indexed":false,"editPermission":0},"photos-exif":{"value":null,"type":"array","etag":"","indexed":false,"editPermission":0},"photos-ifd0":{"value":null,"type":"array","etag":"","indexed":false,"editPermission":0}}', 64, 1),
('core', 'installedat', '[[timestamp]].7761', 2, 0),
('core', 'lastcron', '[[timestamp]]', 8, 0),
('core', 'lastupdatedat', '[[timestamp]]', 8, 0),
('core', 'oc.integritycheck.checker', '[]', 64, 1),
('core', 'public_files', 'files_sharing/public.php', 2, 0),
('core', 'vendor', 'nextcloud', 2, 0),
('dashboard', 'enabled', 'yes', 2, 0),
('dashboard', 'installed_version', '7.13.0', 2, 0),
('dashboard', 'types', '', 2, 0),
('dav', 'enabled', 'yes', 2, 0),
('dav', 'hasCustomDefaultContact', '0', 32, 0),
('dav', 'installed_version', '1.36.0', 2, 0),
('dav', 'types', 'filesystem', 2, 0),
('federatedfilesharing', 'enabled', 'yes', 2, 0),
('federatedfilesharing', 'installed_version', '1.23.0', 2, 0),
('federatedfilesharing', 'types', '', 2, 0),
('federation', 'enabled', 'yes', 2, 0),
('federation', 'installed_version', '1.23.0', 2, 0),
('federation', 'types', 'authentication', 2, 0),
('files', 'enabled', 'yes', 2, 0),
('files', 'installed_version', '2.5.0', 2, 0),
('files', 'types', 'filesystem', 2, 0),
('files_downloadlimit', 'enabled', 'yes', 2, 0),
('files_downloadlimit', 'installed_version', '5.1.0-dev.0', 2, 0),
('files_downloadlimit', 'types', '', 2, 0),
('files_pdfviewer', 'enabled', 'yes', 2, 0),
('files_pdfviewer', 'installed_version', '6.0.0-dev.0', 2, 0),
('files_pdfviewer', 'types', '', 2, 0),
('files_reminders', 'enabled', 'yes', 2, 0),
('files_reminders', 'installed_version', '1.6.0', 2, 0),
('files_reminders', 'types', '', 2, 0),
('files_sharing', 'enabled', 'yes', 2, 0),
('files_sharing', 'installed_version', '1.25.2', 2, 0),
('files_sharing', 'types', 'filesystem', 2, 0),
('files_trashbin', 'enabled', 'yes', 2, 0),
('files_trashbin', 'installed_version', '1.23.0', 2, 0),
('files_trashbin', 'types', 'filesystem,dav', 2, 0),
('files_versions', 'enabled', 'yes', 2, 0),
('files_versions', 'installed_version', '1.26.0', 2, 0),
('files_versions', 'types', 'filesystem,dav', 2, 0),
('firstrunwizard', 'enabled', 'yes', 2, 0),
('firstrunwizard', 'installed_version', '6.0.0-dev.0', 2, 0),
('firstrunwizard', 'types', '', 2, 0),
('logreader', 'enabled', 'yes', 2, 0),
('logreader', 'installed_version', '6.0.0', 2, 0),
('logreader', 'types', 'logging', 2, 0),
('lookup_server_connector', 'enabled', 'yes', 2, 0),
('lookup_server_connector', 'installed_version', '1.21.0', 2, 0),
('lookup_server_connector', 'types', 'authentication', 2, 0),
('mail', 'enabled', 'yes', 2, 0),
('mail', 'installed_version', '5.7.0', 2, 0),
('mail', 'types', '', 2, 0),
('nextcloud_announcements', 'enabled', 'yes', 2, 0),
('nextcloud_announcements', 'installed_version', '5.0.0', 2, 0),
('nextcloud_announcements', 'types', 'logging', 2, 0),
('notes', 'enabled', 'yes', 2, 0),
('notes', 'installed_version', '4.13.0', 2, 0),
('notes', 'types', '', 2, 0),
('notifications', 'enabled', 'yes', 2, 0),
('notifications', 'installed_version', '6.0.0', 2, 0),
('notifications', 'types', 'logging', 2, 0),
('oauth2', 'enabled', 'yes', 2, 0),
('oauth2', 'installed_version', '1.21.0', 2, 0),
('oauth2', 'types', 'authentication', 2, 0),
('password_policy', 'enabled', 'yes', 2, 0),
('password_policy', 'installed_version', '5.0.0-dev.0', 2, 0),
('password_policy', 'types', 'authentication', 2, 0),
('photos', 'enabled', 'yes', 2, 0),
('photos', 'installed_version', '6.0.0-dev.0', 2, 0),
('photos', 'types', 'dav,authentication', 2, 0),
('privacy', 'enabled', 'yes', 2, 0),
('privacy', 'installed_version', '5.0.0-dev.0', 2, 0),
('privacy', 'types', '', 2, 0),
('profile', 'enabled', 'yes', 2, 0),
('profile', 'installed_version', '1.2.0', 2, 0),
('profile', 'types', '', 2, 0),
('provisioning_api', 'enabled', 'yes', 2, 0),
('provisioning_api', 'installed_version', '1.23.0', 2, 0),
('provisioning_api', 'types', 'prevent_group_restriction', 2, 0),
('recommendations', 'enabled', 'yes', 2, 0),
('recommendations', 'installed_version', '6.0.0-dev.0', 2, 0),
('recommendations', 'types', '', 2, 0),
('related_resources', 'enabled', 'yes', 2, 0),
('related_resources', 'installed_version', '4.0.0-dev.0', 2, 0),
('related_resources', 'types', '', 2, 0),
('richdocuments', 'enabled', 'yes', 2, 0),
('richdocuments', 'installed_version', '10.0.1', 2, 0),
('richdocuments', 'types', 'filesystem,prevent_group_restriction', 2, 0),
('richdocumentscode', 'enabled', 'yes', 2, 0),
('richdocumentscode', 'installed_version', '25.4.901', 2, 0),
('richdocumentscode', 'types', '', 2, 0),
('serverinfo', 'enabled', 'yes', 2, 0),
('serverinfo', 'installed_version', '5.0.0-dev.0', 2, 0),
('serverinfo', 'types', '', 2, 0),
('settings', 'enabled', 'yes', 2, 0),
('settings', 'installed_version', '1.16.0', 2, 0),
('settings', 'types', '', 2, 0),
('sharebymail', 'enabled', 'yes', 2, 0),
('sharebymail', 'installed_version', '1.23.0', 2, 0),
('sharebymail', 'types', 'filesystem', 2, 0),
('spreed', 'enabled', 'yes', 2, 0),
('spreed', 'installed_version', '23.0.1', 2, 0),
('spreed', 'signaling_token_privkey_es256', '', 2, 0),
('spreed', 'signaling_token_pubkey_es256', '', 2, 0),
('spreed', 'types', 'dav,prevent_group_restriction', 2, 0),
('support', 'enabled', 'yes', 2, 0),
('support', 'installed_version', '5.0.0', 2, 0),
('support', 'types', 'session', 2, 0),
('survey_client', 'enabled', 'yes', 2, 0),
('survey_client', 'installed_version', '5.0.0-dev.0', 2, 0),
('survey_client', 'types', '', 2, 0),
('systemtags', 'enabled', 'yes', 2, 0),
('systemtags', 'installed_version', '1.23.0', 2, 0),
('systemtags', 'types', 'logging', 2, 0),
('text', 'enabled', 'yes', 2, 0),
('text', 'installed_version', '7.0.0-dev.3', 2, 0),
('text', 'types', 'dav', 2, 0),
('theming', 'enabled', 'yes', 2, 0),
('theming', 'installed_version', '2.8.0', 2, 0),
('theming', 'types', 'logging', 2, 0),
('twofactor_backupcodes', 'enabled', 'yes', 2, 0),
('twofactor_backupcodes', 'installed_version', '1.22.0', 2, 0),
('twofactor_backupcodes', 'types', '', 2, 0),
('twofactor_totp', 'enabled', 'yes', 2, 0),
('twofactor_totp', 'installed_version', '15.0.0-dev.0', 2, 0),
('twofactor_totp', 'types', '', 2, 0),
('updatenotification', 'enabled', 'yes', 2, 0),
('updatenotification', 'installed_version', '1.23.0', 2, 0),
('updatenotification', 'types', '', 2, 0),
('user_status', 'enabled', 'yes', 2, 0),
('user_status', 'installed_version', '1.13.0', 2, 0),
('user_status', 'types', '', 2, 0),
('viewer', 'enabled', 'yes', 2, 0),
('viewer', 'installed_version', '6.0.0-dev.0', 2, 0),
('viewer', 'types', '', 2, 0),
('weather_status', 'enabled', 'yes', 2, 0),
('weather_status', 'installed_version', '1.13.0', 2, 0),
('weather_status', 'types', '', 2, 0),
('webhook_listeners', 'enabled', 'yes', 2, 0),
('webhook_listeners', 'installed_version', '1.5.0', 2, 0),
('webhook_listeners', 'types', 'filesystem', 2, 0),
('workflowengine', 'enabled', 'yes', 2, 0),
('workflowengine', 'installed_version', '2.15.0', 2, 0),
('workflowengine', 'types', 'filesystem', 2, 0);

-- --------------------------------------------------------

--
-- Table structure for table `oc_appconfig_ex`
--

CREATE TABLE `oc_appconfig_ex` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `configkey` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `configvalue` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `sensitive` smallint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `appconfig_ex__idx` (`appid`,`configkey`),
  KEY `appconfig_ex__configkey` (`configkey`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_authorized_groups`
--

CREATE TABLE `oc_authorized_groups` (
  `id` int NOT NULL AUTO_INCREMENT,
  `group_id` varchar(200) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `class` varchar(200) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  KEY `admindel_groupid_idx` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_authtoken`
--

CREATE TABLE `oc_authtoken` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `login_name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `password` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `name` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `token` varchar(200) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `type` smallint unsigned DEFAULT '0',
  `remember` smallint unsigned DEFAULT '0',
  `last_activity` int unsigned DEFAULT '0',
  `last_check` int unsigned DEFAULT '0',
  `scope` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `expires` int unsigned DEFAULT NULL,
  `private_key` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `public_key` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `version` smallint unsigned NOT NULL DEFAULT '1',
  `password_invalid` tinyint(1) DEFAULT '0',
  `password_hash` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `authtoken_token_index` (`token`),
  KEY `authtoken_last_activity_idx` (`last_activity`),
  KEY `authtoken_uid_index` (`uid`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

--
-- Dumping data for table `oc_authtoken`
--

-- --------------------------------------------------------

--
-- Table structure for table `oc_bruteforce_attempts`
--

CREATE TABLE `oc_bruteforce_attempts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `action` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `occurred` int unsigned NOT NULL DEFAULT '0',
  `ip` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `subnet` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `metadata` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `bruteforce_attempts_ip` (`ip`),
  KEY `bruteforce_attempts_subnet` (`subnet`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_calendarchanges`
--

CREATE TABLE `oc_calendarchanges` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uri` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `synctoken` int unsigned NOT NULL DEFAULT '1',
  `calendarid` bigint NOT NULL,
  `operation` smallint NOT NULL,
  `calendartype` int NOT NULL DEFAULT '0',
  `created_at` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `calid_type_synctoken` (`calendarid`,`calendartype`,`synctoken`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_calendarobjects`
--

CREATE TABLE `oc_calendarobjects` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `calendardata` longblob,
  `uri` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `calendarid` bigint unsigned NOT NULL,
  `lastmodified` int unsigned DEFAULT NULL,
  `etag` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `size` bigint unsigned NOT NULL,
  `componenttype` varchar(8) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `firstoccurence` bigint unsigned DEFAULT NULL,
  `lastoccurence` bigint unsigned DEFAULT NULL,
  `uid` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `classification` int DEFAULT '0',
  `calendartype` int NOT NULL DEFAULT '0',
  `deleted_at` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `calobjects_index` (`calendarid`,`calendartype`,`uri`),
  UNIQUE KEY `calobjects_by_uid_index` (`calendarid`,`calendartype`,`uid`),
  KEY `calobj_clssfction_index` (`classification`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_calendarobjects_props`
--

CREATE TABLE `oc_calendarobjects_props` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `calendarid` bigint NOT NULL DEFAULT '0',
  `objectid` bigint unsigned NOT NULL DEFAULT '0',
  `name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `parameter` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `value` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `calendartype` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `calendarobject_index` (`objectid`,`calendartype`),
  KEY `calendarobject_name_index` (`name`,`calendartype`),
  KEY `calendarobject_value_index` (`value`,`calendartype`),
  KEY `calendarobject_calid_index` (`calendarid`,`calendartype`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=4 ;

--
-- Dumping data for table `oc_calendarobjects_props`
--

INSERT INTO `oc_calendarobjects_props` VALUES
(1, 1, 1, 'SUMMARY', NULL, 'Example event - open me!', 0),
(2, 1, 1, 'DESCRIPTION', NULL, 'Welcome to Nextcloud Calendar!\n\nThis is a sample event - explore the flexibility of planning with Nextcloud Calendar by making any edits you want!\n\nWith Nextcloud Calendar, you can:\n- Create, edit, and manage events effortlessly.\n- Create multiple calend', 0),
(3, 2, 2, 'SUMMARY', NULL, '? Leon Green (2000)', 0);

-- --------------------------------------------------------

--
-- Table structure for table `oc_calendars`
--

CREATE TABLE `oc_calendars` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `principaluri` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `displayname` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `uri` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `synctoken` int unsigned NOT NULL DEFAULT '1',
  `description` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `calendarorder` int unsigned NOT NULL DEFAULT '0',
  `calendarcolor` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `timezone` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `components` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `transparent` smallint NOT NULL DEFAULT '0',
  `deleted_at` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `calendars_index` (`principaluri`,`uri`),
  KEY `cals_princ_del_idx` (`principaluri`,`deleted_at`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=3 ;

--
-- Dumping data for table `oc_calendars`
--

INSERT INTO `oc_calendars` VALUES
(1, 'principals/users/[[admin_username]]', 'Personal', 'personal', 2, NULL, 0, '#00679e', NULL, 'VEVENT', 0, NULL),
(2, 'principals/users/[[admin_username]]', 'Contact birthdays', 'contact_birthdays', 2, NULL, 0, '#E9D859', NULL, 'VEVENT', 0, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `oc_calendarsubscriptions`
--

CREATE TABLE `oc_calendarsubscriptions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uri` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `principaluri` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `displayname` varchar(100) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `refreshrate` varchar(10) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `calendarorder` int unsigned NOT NULL DEFAULT '0',
  `calendarcolor` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `striptodos` smallint DEFAULT NULL,
  `stripalarms` smallint DEFAULT NULL,
  `stripattachments` smallint DEFAULT NULL,
  `lastmodified` int unsigned DEFAULT NULL,
  `synctoken` int unsigned NOT NULL DEFAULT '1',
  `source` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  PRIMARY KEY (`id`),
  UNIQUE KEY `calsub_index` (`principaluri`,`uri`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_calendars_federated`
--

CREATE TABLE `oc_calendars_federated` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `display_name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `color` varchar(7) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `uri` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `principaluri` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `remote_Url` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `token` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `sync_token` int unsigned NOT NULL DEFAULT '0',
  `last_sync` bigint unsigned DEFAULT NULL,
  `shared_by` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `shared_by_display_name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `components` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `permissions` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fedcals_uris_index` (`principaluri`,`uri`),
  KEY `fedcals_last_sync_index` (`last_sync`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_calendar_appt_bookings`
--

CREATE TABLE `oc_calendar_appt_bookings` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `appt_config_id` bigint unsigned NOT NULL,
  `created_at` int NOT NULL,
  `token` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `display_name` varchar(128) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `description` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `email` varchar(128) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `start` int NOT NULL,
  `end` int NOT NULL,
  `timezone` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `confirmed` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `cal_appt_bk_token_uniq_idx` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_calendar_appt_configs`
--

CREATE TABLE `oc_calendar_appt_configs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `token` varchar(128) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `name` varchar(128) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `description` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `location` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `visibility` varchar(10) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `target_calendar_uri` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `calendar_freebusy_uris` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `availability` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `start` int DEFAULT NULL,
  `end` int DEFAULT NULL,
  `length` int NOT NULL,
  `increment` int NOT NULL,
  `preparation_duration` int NOT NULL DEFAULT '0',
  `followup_duration` int NOT NULL DEFAULT '0',
  `time_before_next_slot` int DEFAULT NULL,
  `daily_max` int DEFAULT NULL,
  `future_limit` int DEFAULT NULL,
  `create_talk_room` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `cal_appt_token_uniq_idx` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_calendar_invitations`
--

CREATE TABLE `oc_calendar_invitations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `recurrenceid` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `attendee` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `organizer` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `sequence` bigint unsigned DEFAULT NULL,
  `token` varchar(60) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `expiration` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `calendar_invitation_tokens` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_calendar_proposal_dats`
--

CREATE TABLE `oc_calendar_proposal_dats` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `pid` bigint unsigned NOT NULL,
  `date` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_calendar_proposal_dts`
--

CREATE TABLE `oc_calendar_proposal_dts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `uuid` varchar(36) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `title` text CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `description` text CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `location` text CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `duration` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_calendar_proposal_pts`
--

CREATE TABLE `oc_calendar_proposal_pts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `pid` bigint unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `address` varchar(320) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `attendance` varchar(8) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `status` varchar(8) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `realm` varchar(8) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `token` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_calendar_proposal_vts`
--

CREATE TABLE `oc_calendar_proposal_vts` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `pid` bigint unsigned NOT NULL DEFAULT '0',
  `participant_id` bigint unsigned NOT NULL,
  `date_id` bigint unsigned NOT NULL,
  `vote` varchar(8) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_calendar_reminders`
--

CREATE TABLE `oc_calendar_reminders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `calendar_id` bigint NOT NULL,
  `object_id` bigint NOT NULL,
  `is_recurring` smallint DEFAULT NULL,
  `uid` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `recurrence_id` bigint unsigned DEFAULT NULL,
  `is_recurrence_exception` smallint NOT NULL,
  `event_hash` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `alarm_hash` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `type` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `is_relative` smallint NOT NULL,
  `notification_date` bigint unsigned NOT NULL,
  `is_repeat_based` smallint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `calendar_reminder_objid` (`object_id`),
  KEY `calendar_reminder_uidrec` (`uid`,`recurrence_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_calendar_resources`
--

CREATE TABLE `oc_calendar_resources` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `backend_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `resource_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `email` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `displayname` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `group_restrictions` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `calendar_resources_bkdrsc` (`backend_id`,`resource_id`),
  KEY `calendar_resources_email` (`email`),
  KEY `calendar_resources_name` (`displayname`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_calendar_resources_md`
--

CREATE TABLE `oc_calendar_resources_md` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `resource_id` bigint unsigned NOT NULL,
  `key` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `value` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `calendar_resources_md_idk` (`resource_id`,`key`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_calendar_rooms`
--

CREATE TABLE `oc_calendar_rooms` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `backend_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `resource_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `email` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `displayname` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `group_restrictions` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `calendar_rooms_bkdrsc` (`backend_id`,`resource_id`),
  KEY `calendar_rooms_email` (`email`),
  KEY `calendar_rooms_name` (`displayname`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_calendar_rooms_md`
--

CREATE TABLE `oc_calendar_rooms_md` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `room_id` bigint unsigned NOT NULL,
  `key` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `value` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `calendar_rooms_md_idk` (`room_id`,`key`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_cards`
--

CREATE TABLE `oc_cards` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `addressbookid` bigint NOT NULL DEFAULT '0',
  `carddata` longblob,
  `uri` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `lastmodified` bigint unsigned DEFAULT NULL,
  `etag` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `size` bigint unsigned NOT NULL,
  `uid` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cards_abiduri` (`addressbookid`,`uri`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_cards_properties`
--

CREATE TABLE `oc_cards_properties` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `addressbookid` bigint NOT NULL DEFAULT '0',
  `cardid` bigint unsigned NOT NULL DEFAULT '0',
  `name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `value` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `preferred` int 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  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_circles_circle` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `unique_id` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `name` varchar(127) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `display_name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `sanitized_name` varchar(127) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `instance` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `config` int unsigned DEFAULT NULL,
  `source` int unsigned DEFAULT NULL,
  `settings` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `description` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `creation` datetime DEFAULT NULL,
  `contact_addressbook` int unsigned DEFAULT NULL,
  `contact_groupname` varchar(127) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin 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  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_circles_event` (
  `token` varchar(63) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `instance` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `event` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `result` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `interface` int NOT NULL DEFAULT '0',
  `severity` int DEFAULT NULL,
  `retry` int DEFAULT NULL,
  `status` int DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  `creation` bigint DEFAULT NULL,
  PRIMARY KEY (`token`,`instance`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_circles_member` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `single_id` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `circle_id` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `member_id` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `user_id` varchar(127) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `user_type` smallint NOT NULL DEFAULT '1',
  `instance` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `invited_by` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `level` smallint NOT NULL,
  `status` varchar(15) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `note` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `cached_name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `cached_update` datetime DEFAULT NULL,
  `contact_id` varchar(127) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `contact_meta` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `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  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_circles_membership` (
  `circle_id` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `single_id` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `level` int unsigned NOT NULL,
  `inheritance_first` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `inheritance_last` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `inheritance_depth` int unsigned NOT NULL,
  `inheritance_path` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin 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=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_circles_mount` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `mount_id` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `circle_id` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `single_id` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `token` varchar(63) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `parent` int DEFAULT NULL,
  `mountpoint` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `mountpoint_hash` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `remote` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `remote_id` int 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_circles_mountpoint` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `mount_id` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `single_id` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `mountpoint` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `mountpoint_hash` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_circles_remote` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(15) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT 'Unknown',
  `interface` int NOT NULL DEFAULT '0',
  `uid` varchar(20) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `instance` varchar(127) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `href` varchar(254) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `item` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `creation` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_F94EF834230B1DE` (`instance`),
  KEY `IDX_F94EF83539B0606` (`uid`),
  KEY `IDX_F94EF8334F8E741` (`href`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_circles_share_lock` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `item_id` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `circle_id` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `instance` varchar(127) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_337F52F8126F525E70EE2FF6` (`item_id`,`circle_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_circles_token` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `share_id` int DEFAULT NULL,
  `circle_id` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `single_id` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `member_id` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `token` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `password` varchar(127) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `accepted` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sicisimit` (`share_id`,`circle_id`,`single_id`,`member_id`,`token`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_collres_accesscache` (
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `collection_id` bigint NOT NULL DEFAULT '0',
  `resource_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `resource_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin 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=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_collres_collections` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_collres_resources` (
  `collection_id` bigint NOT NULL,
  `resource_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `resource_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`collection_id`,`resource_type`,`resource_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_comments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` bigint unsigned NOT NULL DEFAULT '0',
  `topmost_parent_id` bigint unsigned NOT NULL DEFAULT '0',
  `children_count` int unsigned NOT NULL DEFAULT '0',
  `actor_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `actor_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `message` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `verb` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `creation_timestamp` datetime DEFAULT NULL,
  `latest_child_timestamp` datetime DEFAULT NULL,
  `object_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `object_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `reference_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `reactions` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `expire_date` datetime DEFAULT NULL,
  `meta_data` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_comments_read_markers` (
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `object_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `object_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin 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=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_dav_absence` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `first_day` varchar(10) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `last_day` varchar(10) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `status` varchar(100) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `message` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `replacement_user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `replacement_user_display_name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `dav_absence_uid_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_dav_cal_proxy` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `owner_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `proxy_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `permissions` int 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_dav_shares` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `principaluri` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `type` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `access` smallint DEFAULT NULL,
  `resourceid` bigint unsigned NOT NULL,
  `publicuri` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `token` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_directlink` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `file_id` bigint unsigned NOT NULL,
  `token` varchar(60) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `expiration` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `directlink_token_idx` (`token`),
  KEY `directlink_expiration_idx` (`expiration`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_direct_edit` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `editor_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `token` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `file_id` bigint NOT NULL,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `share_id` bigint DEFAULT NULL,
  `timestamp` bigint unsigned NOT NULL,
  `accessed` tinyint(1) DEFAULT '0',
  `file_path` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_4D5AFECA5F37A13B` (`token`),
  KEY `direct_edit_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_ex_apps` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `version` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `daemon_config_name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '0',
  `port` smallint unsigned NOT NULL,
  `secret` varchar(256) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `status` json NOT NULL,
  `enabled` smallint NOT NULL DEFAULT '0',
  `created_time` bigint 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_ex_apps_daemons` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `display_name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `accepts_deploy_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `protocol` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `host` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `deploy_config` json NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ex_apps_daemons__name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_ex_apps_routes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `url` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `verb` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `access_level` int NOT NULL DEFAULT '0',
  `headers_to_exclude` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `bruteforce_protection` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ex_apps_routes_appid` (`appid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_ex_deploy_options` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `type` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `value` json NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `deploy_options__idx` (`appid`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_ex_occ_commands` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `description` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `hidden` smallint NOT NULL DEFAULT '0',
  `arguments` json NOT NULL,
  `options` json NOT NULL,
  `usages` json NOT NULL,
  `execute_handler` varchar(410) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ex_occ_commands__idx` (`appid`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_ex_settings_forms` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `formid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `scheme` json NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ex_settings_forms__idx` (`appid`,`formid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_ex_task_processing` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `app_id` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `display_name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `task_type` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `custom_task_type` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `provider` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `task_processing_idx` (`app_id`,`name`,`task_type`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_ex_ui_files_actions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `display_name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `mime` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `permissions` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `order` bigint NOT NULL DEFAULT '0',
  `icon` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `action_handler` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `version` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '1.0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ex_ui_files_actions__idx` (`appid`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_ex_ui_scripts` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `type` varchar(16) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `name` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `path` varchar(410) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `after_app_id` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ui_script__idx` (`appid`,`type`,`name`,`path`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_ex_ui_states` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `type` varchar(16) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `name` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `key` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `value` json NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ui_state__idx` (`appid`,`type`,`name`,`key`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_ex_ui_styles` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `type` varchar(16) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `name` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `path` varchar(410) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ui_style__idx` (`appid`,`type`,`name`,`path`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_ex_ui_top_menu` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `appid` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `name` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `display_name` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `icon` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `admin_required` smallint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ui_top_menu__idx` (`appid`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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

-- --------------------------------------------------------

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

CREATE TABLE `oc_federated_reshares` (
  `share_id` bigint NOT NULL,
  `remote_id` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  PRIMARY KEY (`share_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_filecache` (
  `fileid` bigint NOT NULL AUTO_INCREMENT,
  `storage` bigint NOT NULL DEFAULT '0',
  `path` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `path_hash` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `parent` bigint NOT NULL DEFAULT '0',
  `name` varchar(250) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `mimetype` bigint NOT NULL DEFAULT '0',
  `mimepart` bigint NOT NULL DEFAULT '0',
  `size` bigint NOT NULL DEFAULT '0',
  `mtime` bigint NOT NULL DEFAULT '0',
  `storage_mtime` bigint NOT NULL DEFAULT '0',
  `encrypted` int NOT NULL DEFAULT '0',
  `unencrypted_size` bigint NOT NULL DEFAULT '0',
  `etag` varchar(40) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `permissions` int DEFAULT '0',
  `checksum` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin 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  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

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

-- --------------------------------------------------------

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

CREATE TABLE `oc_filecache_extended` (
  `fileid` bigint unsigned NOT NULL,
  `metadata_etag` varchar(40) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `creation_time` bigint NOT NULL DEFAULT '0',
  `upload_time` bigint NOT NULL DEFAULT '0',
  PRIMARY KEY (`fileid`),
  KEY `fce_ctime_idx` (`creation_time`),
  KEY `fce_utime_idx` (`upload_time`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_files_metadata` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `file_id` bigint NOT NULL,
  `json` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `sync_token` varchar(15) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `last_update` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `files_meta_fileid` (`file_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=11 ;

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

INSERT INTO `oc_files_metadata` VALUES
(1, 11, '{"photos-size":{"value":{"width":500,"height":500},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-original_date_time":{"value":[[timestamp]],"type":"int","etag":"","indexed":true,"editPermission":0}}', '[[sync_token1]]', '[[regtime]]'),
(2, 12, '{"photos-original_date_time":{"value":[[timestamp]],"type":"int","etag":"","indexed":true,"editPermission":0}}', '[[sync_token2]]', '[[regtime]]'),
(3, 15, '{"photos-exif":{"value":{"ExposureTime":"1\\/320","FNumber":"4\\/1","ExposureProgram":3,"ISOSpeedRatings":640,"UndefinedTag__x____":640,"ExifVersion":"0230","DateTimeOriginal":"2015:10:15 11:07:44","DateTimeDigitized":"2015:10:15 11:07:44","ShutterSpeedValue":"27970\\/3361","ApertureValue":"4\\/1","ExposureBiasValue":"1\\/3","MaxApertureValue":"4\\/1","MeteringMode":5,"Flash":16,"FocalLength":"200\\/1","SubSecTimeOriginal":"63","SubSecTimeDigitized":"63","ColorSpace":1,"ExifImageWidth":1600,"ExifImageLength":1067,"FocalPlaneXResolution":"1600\\/1","FocalPlaneYResolution":"1600\\/1","FocalPlaneResolutionUnit":3,"CustomRendered":0,"ExposureMode":0,"WhiteBalance":0,"SceneCaptureType":0,"UndefinedTag__xA___":"000084121f"},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-ifd0":{"value":{"Make":"Canon","Model":"Canon EOS 5D Mark III","Orientation":1,"XResolution":"240\\/1","YResolution":"240\\/1","ResolutionUnit":2,"Software":"Adobe Photoshop Lightroom 6.2.1 (Macintosh)","DateTime":"2015:10:16 14:40:21","Exif_IFD_Pointer":230},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-size":{"value":{"width":1600,"height":1067},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-original_date_time":{"value":1444907264,"type":"int","etag":"","indexed":true,"editPermission":0}}', '[[sync_token3]]', '[[regtime]]'),
(4, 16, '{"photos-size":{"value":{"width":3000,"height":2000},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-original_date_time":{"value":[[timestamp]],"type":"int","etag":"","indexed":true,"editPermission":0}}', '[[sync_token4]]', '[[regtime]]'),
(5, 17, '{"photos-exif":{"value":{"ExposureTime":"1\\/160","FNumber":"4\\/1","ExposureProgram":3,"ISOSpeedRatings":100,"ExifVersion":"0230","DateTimeOriginal":"2013:06:27 07:51:09","DateTimeDigitized":"2013:06:27 07:51:09","ComponentsConfiguration":"","ShutterSpeedValue":"59\\/8","ApertureValue":"4\\/1","ExposureBiasValue":"2\\/3","MaxApertureValue":"4\\/1","MeteringMode":5,"Flash":16,"FocalLength":"45\\/1","SubSecTime":"00","SubSecTimeOriginal":"00","SubSecTimeDigitized":"00","FlashPixVersion":"0100","ColorSpace":1,"ExifImageWidth":1200,"ExifImageLength":1800,"FocalPlaneXResolution":"382423\\/97","FocalPlaneYResolution":"185679\\/47","FocalPlaneResolutionUnit":2,"CustomRendered":0,"ExposureMode":0,"WhiteBalance":0,"SceneCaptureType":0,"UndefinedTag__xA___":"000052602c"},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-ifd0":{"value":{"Make":"Canon","Model":"Canon EOS 5D Mark III","Orientation":1,"XResolution":"72\\/1","YResolution":"72\\/1","ResolutionUnit":2,"Software":"Aperture 3.4.5","DateTime":"2013:06:27 07:51:09","Exif_IFD_Pointer":202},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-size":{"value":{"width":1200,"height":1800},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-original_date_time":{"value":1372319469,"type":"int","etag":"","indexed":true,"editPermission":0}}', '[[sync_token5]]', '[[regtime]]'),
(6, 18, '{"photos-exif":{"value":{"ExposureTime":"10\\/12500","FNumber":"35\\/10","ExposureProgram":3,"ISOSpeedRatings":100,"DateTimeOriginal":"2018:05:16 20:03:00","DateTimeDigitized":"2018:05:16 20:03:00","ExposureBiasValue":"0\\/6","MaxApertureValue":"30\\/10","MeteringMode":5,"LightSource":0,"Flash":16,"FocalLength":"700\\/10","MakerNote":"Nikon","UserComment":"Christoph WurstCC-SA 4.0","SubSecTime":"30","SubSecTimeOriginal":"30","SubSecTimeDigitized":"30","ColorSpace":1,"SensingMethod":2,"FileSource":"","SceneType":"","CustomRendered":0,"ExposureMode":0,"WhiteBalance":0,"DigitalZoomRatio":"1\\/1","FocalLengthIn__mmFilm":70,"SceneCaptureType":0,"GainControl":0,"Contrast":1,"Saturation":0,"Sharpness":1,"SubjectDistanceRange":0},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-ifd0":{"value":{"ImageDescription":"Christoph WurstCC-SA 4.0","Make":"NIKON CORPORATION","Model":"NIKON D610","Orientation":1,"XResolution":"72\\/1","YResolution":"72\\/1","ResolutionUnit":2,"Software":"GIMP 2.10.14","DateTime":"2019:12:10 08:51:16","Artist":"Christoph Wurst                     ","Copyright":"Christoph Wurst                                       ","Exif_IFD_Pointer":402,"GPS_IFD_Pointer":13738,"DateTimeOriginal":"2018:05:16 20:03:00"},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-size":{"value":{"width":1920,"height":1281},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-original_date_time":{"value":1526500980,"type":"int","etag":"","indexed":true,"editPermission":0}}', '[[sync_token6]]', '[[regtime]]'),
(7, 19, '{"photos-exif":{"value":{"ExposureTime":"1\\/125","FNumber":"28\\/5","ExposureProgram":3,"ISOSpeedRatings":320,"UndefinedTag__x____":320,"ExifVersion":"0230","DateTimeOriginal":"2012:06:30 12:32:11","DateTimeDigitized":"2012:06:30 12:32:11","ComponentsConfiguration":"","ShutterSpeedValue":"7\\/1","ApertureValue":"5\\/1","ExposureBiasValue":"0\\/1","MaxApertureValue":"189284\\/33461","MeteringMode":5,"Flash":16,"FocalLength":"280\\/1","SubSecTime":"83","SubSecTimeOriginal":"83","SubSecTimeDigitized":"83","FlashPixVersion":"0100","ColorSpace":1,"ExifImageWidth":1600,"ExifImageLength":1067,"FocalPlaneXResolution":"1920000\\/487","FocalPlaneYResolution":"320000\\/81","FocalPlaneResolutionUnit":2,"CustomRendered":0,"ExposureMode":0,"WhiteBalance":0,"SceneCaptureType":0,"UndefinedTag__xA___":"0000000000"},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-ifd0":{"value":{"Make":"Canon","Model":"Canon EOS 5D Mark III","Orientation":1,"XResolution":"72\\/1","YResolution":"72\\/1","ResolutionUnit":2,"DateTime":"2012:06:30 12:32:11","Exif_IFD_Pointer":174},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-size":{"value":{"width":1600,"height":1067},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-original_date_time":{"value":1341059531,"type":"int","etag":"","indexed":true,"editPermission":0}}', '[[sync_token7]]', '[[regtime]]'),
(8, 20, '{"photos-exif":{"value":{"ExposureTime":"1\\/80","FNumber":"4\\/1","ExposureProgram":3,"ISOSpeedRatings":400,"ExifVersion":"0230","DateTimeOriginal":"2012:07:02 19:50:36","DateTimeDigitized":"2012:07:02 19:50:36","ComponentsConfiguration":"","ShutterSpeedValue":"51\\/8","ApertureValue":"4\\/1","ExposureBiasValue":"0\\/1","MaxApertureValue":"4\\/1","MeteringMode":5,"Flash":16,"FocalLength":"32\\/1","SubSecTime":"00","SubSecTimeOriginal":"00","SubSecTimeDigitized":"00","FlashPixVersion":"0100","ColorSpace":1,"ExifImageWidth":1600,"ExifImageLength":1066,"FocalPlaneXResolution":"382423\\/97","FocalPlaneYResolution":"185679\\/47","FocalPlaneResolutionUnit":2,"CustomRendered":0,"ExposureMode":0,"WhiteBalance":0,"SceneCaptureType":0},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-ifd0":{"value":{"Make":"Canon","Model":"Canon EOS 5D Mark III","Orientation":1,"XResolution":"72\\/1","YResolution":"72\\/1","ResolutionUnit":2,"Software":"GIMP 2.8.0","DateTime":"2012:07:02 22:06:14","Exif_IFD_Pointer":198},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-size":{"value":{"width":1600,"height":1066},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-original_date_time":{"value":1341258636,"type":"int","etag":"","indexed":true,"editPermission":0}}', '[[sync_token8]]', '[[regtime]]'),
(9, 21, '{"photos-exif":{"value":{"ExposureTime":"1\\/500","FNumber":"28\\/5","ExposureProgram":1,"ISOSpeedRatings":8000,"ExifVersion":"0230","DateTimeOriginal":"2012:06:30 16:15:15","DateTimeDigitized":"2012:06:30 16:15:15","ComponentsConfiguration":"","ShutterSpeedValue":"9\\/1","ApertureValue":"5\\/1","ExposureBiasValue":"0\\/1","MaxApertureValue":"6149\\/1087","MeteringMode":5,"Flash":16,"FocalLength":"280\\/1","SubSecTime":"00","SubSecTimeOriginal":"00","SubSecTimeDigitized":"00","FlashPixVersion":"0100","ColorSpace":1,"ExifImageWidth":1600,"ExifImageLength":1067,"FocalPlaneXResolution":"382423\\/97","FocalPlaneYResolution":"134321\\/34","FocalPlaneResolutionUnit":2,"CustomRendered":0,"ExposureMode":1,"WhiteBalance":0,"SceneCaptureType":0},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-ifd0":{"value":{"Make":"Canon","Model":"Canon EOS 5D Mark III","Orientation":1,"XResolution":"72\\/1","YResolution":"72\\/1","ResolutionUnit":2,"Software":"Aperture 3.3.1","DateTime":"2012:06:30 16:15:15","Exif_IFD_Pointer":202},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-size":{"value":{"width":1600,"height":1067},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-original_date_time":{"value":1341072915,"type":"int","etag":"","indexed":true,"editPermission":0}}', '[[sync_token9]]', '[[regtime]]'),
(10, 23, '{"photos-exif":{"value":{"ExposureTime":"1\\/640","FNumber":"28\\/5","ExposureProgram":1,"ISOSpeedRatings":12800,"ExifVersion":"0230","DateTimeOriginal":"2012:06:30 13:47:40","DateTimeDigitized":"2012:06:30 13:47:40","ComponentsConfiguration":"","ShutterSpeedValue":"75\\/8","ApertureValue":"5\\/1","ExposureBiasValue":"0\\/1","MaxApertureValue":"6149\\/1087","MeteringMode":5,"Flash":16,"FocalLength":"235\\/1","SubSecTime":"00","SubSecTimeOriginal":"00","SubSecTimeDigitized":"00","FlashPixVersion":"0100","ExifImageWidth":1600,"ExifImageLength":1067,"FocalPlaneXResolution":"382423\\/97","FocalPlaneYResolution":"134321\\/34","FocalPlaneResolutionUnit":2,"CustomRendered":0,"ExposureMode":1,"WhiteBalance":0,"SceneCaptureType":0},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-ifd0":{"value":{"Make":"Canon","Model":"Canon EOS 5D Mark III","Orientation":1,"XResolution":"72\\/1","YResolution":"72\\/1","ResolutionUnit":2,"Software":"Aperture 3.3.1","DateTime":"2012:06:30 13:47:40","Exif_IFD_Pointer":202},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-size":{"value":{"width":1600,"height":1067},"type":"array","etag":"","indexed":false,"editPermission":0},"photos-original_date_time":{"value":1341064060,"type":"int","etag":"","indexed":true,"editPermission":0}}', '[[sync_token10]]', '[[regtime]]');

-- --------------------------------------------------------

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

CREATE TABLE `oc_files_metadata_index` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `file_id` bigint NOT NULL,
  `meta_key` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `meta_value_string` varchar(63) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `meta_value_int` bigint 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  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=11 ;

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

INSERT INTO `oc_files_metadata_index` VALUES
(1, 11, 'photos-original_date_time', NULL, [[timestamp]]),
(2, 12, 'photos-original_date_time', NULL, [[timestamp]]),
(3, 15, 'photos-original_date_time', NULL, 1444907264),
(4, 16, 'photos-original_date_time', NULL, [[timestamp]]),
(5, 17, 'photos-original_date_time', NULL, 1372319469),
(6, 18, 'photos-original_date_time', NULL, 1526500980),
(7, 19, 'photos-original_date_time', NULL, 1341059531),
(8, 20, 'photos-original_date_time', NULL, 1341258636),
(9, 21, 'photos-original_date_time', NULL, 1341072915),
(10, 23, 'photos-original_date_time', NULL, 1341064060);

-- --------------------------------------------------------

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

CREATE TABLE `oc_files_reminders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `file_id` bigint 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_files_trash` (
  `auto_id` bigint NOT NULL AUTO_INCREMENT,
  `id` varchar(250) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `user` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `timestamp` varchar(12) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `location` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `type` varchar(4) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `mime` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `deleted_by` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`auto_id`),
  KEY `id_index` (`id`),
  KEY `timestamp_index` (`timestamp`),
  KEY `user_index` (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_files_versions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `file_id` bigint NOT NULL,
  `timestamp` bigint NOT NULL,
  `size` bigint NOT NULL,
  `mimetype` bigint NOT NULL,
  `metadata` json NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `files_versions_uniq_index` (`file_id`,`timestamp`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=65 ;

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

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

-- --------------------------------------------------------

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

CREATE TABLE `oc_file_locks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `lock` int NOT NULL DEFAULT '0',
  `key` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `ttl` int NOT NULL DEFAULT '-1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `lock_key_index` (`key`),
  KEY `lock_ttl_index` (`ttl`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_flow_checks` (
  `id` int NOT NULL AUTO_INCREMENT,
  `class` varchar(256) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `operator` varchar(16) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `value` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `hash` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `flow_unique_hash` (`hash`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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

-- --------------------------------------------------------

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

CREATE TABLE `oc_flow_operations_scope` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `operation_id` int NOT NULL DEFAULT '0',
  `type` int NOT NULL DEFAULT '0',
  `value` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `flow_unique_scope` (`operation_id`,`type`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_groups` (
  `gid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `displayname` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT 'name',
  PRIMARY KEY (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin;

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

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

-- --------------------------------------------------------

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

CREATE TABLE `oc_group_admin` (
  `gid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `uid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`gid`,`uid`),
  KEY `group_admin_uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_group_user` (
  `gid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `uid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`gid`,`uid`),
  KEY `gu_uid_index` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin;

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

INSERT INTO `oc_group_user` VALUES
('admin', '[[admin_username]]');

-- --------------------------------------------------------

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

CREATE TABLE `oc_jobs` (
  `id` bigint unsigned NOT NULL,
  `class` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `argument` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `last_run` int DEFAULT '0',
  `last_checked` int DEFAULT '0',
  `reserved_at` int DEFAULT '0',
  `execution_duration` int DEFAULT '0',
  `argument_hash` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `time_sensitive` smallint 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=[[utf8]] COLLATE=[[utf8]]_bin;

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

INSERT INTO `oc_jobs` VALUES
(52486071799816192, 'OCA\\Activity\\BackgroundJob\\EmailNotification', 'null', [[timestamp]], [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486071908868096, 'OCA\\Activity\\BackgroundJob\\ExpireActivities', 'null', [[timestamp]], [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 0),
(52486072026308608, 'OCA\\Activity\\BackgroundJob\\DigestMail', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486072168914944, 'OCA\\Activity\\BackgroundJob\\RemoveFormerActivitySettings', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486072483487744, 'OCA\\ServerInfo\\Jobs\\UpdateStorageStats', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486074186375168, 'OCA\\ContactsInteraction\\BackgroundJob\\CleanupJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486076254167040, 'OCA\\OAuth2\\BackgroundJob\\CleanupExpiredAuthorizationCode', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486079446032384, 'OCA\\Notifications\\BackgroundJob\\GenerateUserSettings', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486079546695680, 'OCA\\Notifications\\BackgroundJob\\SendNotificationMails', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486089822740480, 'OCA\\AppAPI\\BackgroundJob\\ExAppInitStatusCheckJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486092876193792, 'OCA\\WorkflowEngine\\BackgroundJobs\\Rotate', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486095795429376, 'OCA\\UserStatus\\BackgroundJob\\ClearOldStatusesBackgroundJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486096571375616, 'OCA\\NextcloudAnnouncements\\Cron\\Crawler', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486100199448576, 'OCA\\UpdateNotification\\BackgroundJob\\UpdateAvailableNotifications', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486104674770944, 'OCA\\Files_Sharing\\DeleteOrphanedSharesJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486104817377280, 'OCA\\Files_Sharing\\ExpireSharesJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486104918040576, 'OCA\\Files_Sharing\\SharesReminderJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486105022898176, 'OCA\\Files_Sharing\\BackgroundJob\\FederatedSharesDiscoverJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486105316499456, 'OCA\\Support\\BackgroundJobs\\CheckSubscription', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486118654386176, 'OCA\\DAV\\BackgroundJob\\CleanupDirectLinksJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486118725689344, 'OCA\\DAV\\BackgroundJob\\UpdateCalendarResourcesRoomsBackgroundJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486118796992512, 'OCA\\DAV\\BackgroundJob\\CleanupInvitationTokenJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486118897655808, 'OCA\\DAV\\BackgroundJob\\EventReminderJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486118973153280, 'OCA\\DAV\\BackgroundJob\\CalendarRetentionJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486119082205184, 'OCA\\DAV\\BackgroundJob\\PruneOutdatedSyncTokensJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486119170285568, 'OCA\\DAV\\BackgroundJob\\FederatedCalendarPeriodicSyncJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486121187745792, 'OCA\\Files\\BackgroundJob\\ScanFiles', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486121259048960, 'OCA\\Files\\BackgroundJob\\DeleteOrphanedItems', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486121330352128, 'OCA\\Files\\BackgroundJob\\CleanupFileLocks', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486121405849600, 'OCA\\Files\\BackgroundJob\\CleanupDirectEditingTokens', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486121477152768, 'OCA\\Files\\BackgroundJob\\DeleteExpiredOpenLocalEditor', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486123465252865, 'OCA\\Files_Versions\\BackgroundJob\\ExpireVersions', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486124832595968, 'OCA\\WebhookListeners\\BackgroundJobs\\WebhookTokenCleanup', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486125629513728, 'OCA\\Federation\\SyncJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486128368394240, 'OCA\\Text\\Cron\\Cleanup', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486129559576576, 'OCA\\FilesReminders\\BackgroundJob\\CleanUpReminders', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486129660239872, 'OCA\\FilesReminders\\BackgroundJob\\ScheduledNotifications', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486131509927936, 'OCA\\Photos\\Jobs\\AutomaticPlaceMapperJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486132805967872, 'OCA\\Files_Trashbin\\BackgroundJob\\ExpireTrash', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486137918824448, 'OCA\\Circles\\Cron\\Maintenance', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486138099179520, 'OC\\Authentication\\Token\\TokenCleanupJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486138178871296, 'OC\\Log\\Rotate', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486138258563072, 'OC\\Preview\\BackgroundCleanupJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486138376003584, 'OC\\TextProcessing\\RemoveOldTasksBackgroundJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486138543775744, 'OC\\User\\BackgroundJobs\\CleanupDeletedUsers', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486138774462464, 'OC\\Core\\BackgroundJobs\\GenerateMetadataJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486138917068800, 'OC\\Core\\BackgroundJobs\\PreviewMigrationJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486140095668224, 'OCA\\FirstRunWizard\\Notification\\BackgroundJob', '{"uid":"[[admin_username]]"}', 0, [[timestamp]], 0, 0, 'ed1cbe38683040ba735f2ac7d5e5783105ec8b5d13e6855e8da42a3454adb0c9', 1),
(52486142289289216, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",4]', 0, [[timestamp]], 0, 0, 'f588e8eeaff62265baf2d8f6aa795f136066ac564b02ca93ea7a441d8fb82284', 1),
(52486142717108224, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",5]', 0, [[timestamp]], 0, 0, '8b35c08d91cb539471c71692c934b08c0338fc2a5e9fec4efb436b0df925cea1', 1),
(52486143019098112, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",6]', 0, [[timestamp]], 0, 0, '0d8b45e9f114117060b67f4c0ffbf40656805fb9b2bba425847e61c1b613b959', 1),
(52486143350448128, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",7]', 0, [[timestamp]], 0, 0, '0303e2b31d94b4259e254be4bbea2c864ffaf8a9a51f4825e42a15e883442dab', 1),
(52486143761489920, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",8]', 0, [[timestamp]], 0, 0, '5dcf1fc4bc35feb6839b4145ae45e3194dcaa61365221ea2b412de567da8cbbc', 1),
(52486144046702592, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",9]', 0, [[timestamp]], 0, 0, '0ef54b3dba11c241bc477cd1903cb033dc87edabfcac714af1b436a8f94ada6c', 1),
(52486144470327296, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",10]', 0, [[timestamp]], 0, 0, '46f5110363c64ea262ad77bd56b481edaa28960aaccd985fb9a1be49b2aefdbf', 1),
(52486144906534912, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",11]', 0, [[timestamp]], 0, 0, 'f94b75fced4aa7c934ad48b8c7b1a151e7bdb3c75befbd0909660da8f5105e35', 1),
(52486145502126080, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",12]', 0, [[timestamp]], 0, 0, 'a84f02f449b504d6bd0729d8168d460f5bc7c8f7ba972ae7f73d31502f79d93d', 1),
(52486145837670400, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",13]', 0, [[timestamp]], 0, 0, 'db6c9234620f69e4b58e6197bc91ae021381b39f5e3ce48015e139ca26a2ab63', 1),
(52486146529730560, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",15]', 0, [[timestamp]], 0, 0, '4e5099be54ea7b64c4f2b4814cda25ca77523f678457803beef75640f0bbd9da', 1),
(52486146932383744, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",16]', 0, [[timestamp]], 0, 0, '32c8cd9086bd3ad9eb6414e2aee8c83e5a3cc9648a828c320d8982948356687b', 1),
(52486147318259712, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",17]', 0, [[timestamp]], 0, 0, '51f2e1f3e610d1de56e3b53aeb9e00ef3d388ab7a01901b8078f8db3fba83a0b', 1),
(52486147670581248, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",18]', 0, [[timestamp]], 0, 0, '33798b5393b5e51717a9bf418bc67ca7bb410e5d0e6d56e324b558b29513068e', 1),
(52486148056457216, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",19]', 0, [[timestamp]], 0, 0, 'ba0a0ed151c84dac3b7c48fb1fd7514793ea28f4e81c55fd194f9dab7d62a300', 1),
(52486148425555968, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",20]', 0, [[timestamp]], 0, 0, 'fb37f6858f9cd83799da315106f065b455703d4a2686df13df8f2e901ce3a362', 1),
(52486148895318016, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",21]', 0, [[timestamp]], 0, 0, '1d5a4f2d5d6fcb9aca5b87769912049844b82319863f53c97f484043fd5e58cb', 1),
(52486149314748416, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",22]', 0, [[timestamp]], 0, 0, '314087acf3de957c95b385be8c6139f2c0253c2a5100d9b91e89e4305ad48746', 1),
(52486149969059840, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",23]', 0, [[timestamp]], 0, 0, '54ba9f8d5478447b4fee13a377e1878d089bfc6ec2091d121c12c33f88bbf710', 1),
(52486150640148480, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",25]', 0, [[timestamp]], 0, 0, 'f7b16bcf3310ff37f4f8208941b68402abd1359230546ce68fd004c4a8b0948e', 1),
(52486150975692800, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",26]', 0, [[timestamp]], 0, 0, '005dec9ea82ed6049bb276b169790c10dad98ced49df55bde5bba7f60ae25f0f', 1),
(52486151374151680, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",27]', 0, [[timestamp]], 0, 0, '78a608b2897ae2a116e9c80641abec371ebd9eea4a454630f1119710558381a1', 1),
(52486151755833344, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",28]', 0, [[timestamp]], 0, 0, '55189359302c77e930896626563301ae275ce6a53a5c567bad6905aae3783063', 1),
(52486152078794752, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",29]', 0, [[timestamp]], 0, 0, 'ef22b15f63e04b485f7f31a0c3e38674e6b875051f394f8d01d57007edbb3dd4', 1),
(52486152410144768, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",30]', 0, [[timestamp]], 0, 0, '9aa8a289578fd2a7b5680ad902aed53a4ceed649f5918fc9bc11ac2e7b8948c7', 1),
(52486152770854912, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",31]', 0, [[timestamp]], 0, 0, '05ab1203293e55367ebc114ac4a8a16a2f1244bf7459caeaf24cf47598e1a7e7', 1),
(52486153127370752, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",32]', 0, [[timestamp]], 0, 0, 'dfaa1d229412ad151b5d05a2b840ecadf7c5e7dc47c0448342f3081f43b83f32', 1),
(52486153475497984, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",33]', 0, [[timestamp]], 0, 0, '6c30b17298a457f6b465869f9afeb69fd3e8a2eeb5348de9fad485e755c4fd6f', 1),
(52486153957842944, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",34]', 0, [[timestamp]], 0, 0, 'd1e3e0d6008b733328e7787e5a26b8c14e60e883f21c28f4e968fc27a760c2b9', 1),
(52486154326941696, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",35]', 0, [[timestamp]], 0, 0, 'adbdaf064b915813d9c52337d3bcd1f028f16710c2879e5d9bd2b4f376fcd0f5', 1),
(52486154784120832, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",36]', 0, [[timestamp]], 0, 0, '12ef6a6751a28809fd03f07a1220104b1e724defa6f90d5b3969868280217560', 1),
(52486155107082240, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",37]', 0, [[timestamp]], 0, 0, '6637a6e73d9add61216bc11bbcca9cbfe31c3d9678e95a74a67bc0e31d7ea58c', 1),
(52486155421655040, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",38]', 0, [[timestamp]], 0, 0, 'fb470daa5e7696d8fc8f9a52433de70de233deedba66b5589404975b5d50d0ba', 1),
(52486155740422144, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",39]', 0, [[timestamp]], 0, 0, '7c93da13554feed5f341cc3a5d107a2ed72f5958bb2e2a0f7dff7b5a33f08690', 1),
(52486156080160768, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",40]', 0, [[timestamp]], 0, 0, '2627221314e3d0b6a356c01b1bb17b20a0c0880075540313570bfe9419f3f8ad', 1),
(52486156457648128, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",41]', 0, [[timestamp]], 0, 0, '243c551c4843c53a30a643753dced6bfd6a9fe9cb7614889bea621ceb24ca7b2', 1),
(52486156814163968, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",42]', 0, [[timestamp]], 0, 0, 'cad2cda3789e8a0076498ef350711a576ffe0b0ef2f5642ca90e2aba45d130c7', 1),
(52486157141319680, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",43]', 0, [[timestamp]], 0, 0, '0926e7398bdd5ef043f3b9abbba2824eacdad1ebb3bab95e1050b976a045e98a', 1),
(52486157481058304, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",44]', 0, [[timestamp]], 0, 0, 'cf5118f364a60cfbbae54cffcd80141ac043fdb31e3551441e235e5de53cfcd0', 1),
(52486157829185536, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",45]', 0, [[timestamp]], 0, 0, 'e431fcd38f478a34e22ea69807a89fad02f69d157925461d58c56c2bdb5c3d43', 1),
(52486158303141888, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",46]', 0, [[timestamp]], 0, 0, 'ecf57fa6426a4d43b979bc4f05115e5623ddc3887a3635af8fd7aea383b95539', 1),
(52486158739349504, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",47]', 0, [[timestamp]], 0, 0, '257dd9702987e3ac77bb744e320362233df18730ff8f7128b6e58b964e8b96ab', 1),
(52486159158779904, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",48]', 0, [[timestamp]], 0, 0, '2f5572f636a6cdd5eea74dba63a9a1ceb0ff6ceafb8048c8581e92227f27586a', 1),
(52486159485935616, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",49]', 0, [[timestamp]], 0, 0, 'ab493bb0dcbda0f7c5a5ca0c505b3b7c65a89b93751ecaa115668876177082b2', 1),
(52486159859228672, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",50]', 0, [[timestamp]], 0, 0, 'e39a8034ec45d8d090c5cd67cfbe4c290722f172006f419e855f80fc721c85df', 1),
(52486160228327424, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",51]', 0, [[timestamp]], 0, 0, '041ff683391d644e2eda34d912378c557d917f8aff202829c60fcaeb585ec189', 1),
(52486160651952128, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",52]', 0, [[timestamp]], 0, 0, 'bbc9248fef254e9b2956ae427201173b4862ec071a05a5ae2495ef51fcc29156', 1),
(52486160958136320, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",53]', 0, [[timestamp]], 0, 0, 'cc7b6a8728540ba67535170e4308d1b0fe5d9df81362355719e5fc2d36d8e619', 1),
(52486161281097728, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",54]', 0, [[timestamp]], 0, 0, '255037f7af38912b42c3000ab63bbcae26b9bc402bf8b9b1a5de3c86af8ba481', 1),
(52486161641807872, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",55]', 0, [[timestamp]], 0, 0, '52444e35d728948af4bcfa2e5ec624915c8c02613a4458b41ff1dac4454f32b1', 1),
(52486161960574976, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",56]', 0, [[timestamp]], 0, 0, 'dbdbeae2d135b3093313ab978375e901f5e1e5ac7619e4d92f86e6da435168a0', 1),
(52486162283536384, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",57]', 0, [[timestamp]], 0, 0, '6548c6a15b9641b46b25ab421e90a5876eebf2b46408f98e484c624e8e64081d', 1),
(52486162715549696, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",58]', 0, [[timestamp]], 0, 0, '7903b785c36984c32432c9683ff4366f6400f6512a2cfe99b5657ea34fae35f4', 1),
(52486163034316800, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",59]', 0, [[timestamp]], 0, 0, '15b0e744846d7748db69f7886c2abdb55b13b783bd6eacd2de8b9957e2207e15', 1),
(52486163478913024, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",60]', 0, [[timestamp]], 0, 0, '5e5118860eca4668c05bac4461d423651469bf35a1bddfde650659809a1c2c9a', 1),
(52486163839623168, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",61]', 0, [[timestamp]], 0, 0, '443d52aac8a9ffd4496911163307a60e1e620527b1940b23844d73a773915f17', 1),
(52486164170973184, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",62]', 0, [[timestamp]], 0, 0, '25c52e63066d85dfe8d80a50abfa0394469be1bec95c5d9e8e0eaea48181fbb7', 1),
(52486164506517504, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",63]', 0, [[timestamp]], 0, 0, '57c563f5f058ddc63009f74d6f8d0a820a109f80d3fca5e54c2c8235148f272e', 1),
(52486164808507392, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",64]', 0, [[timestamp]], 0, 0, '8cda3958a8280a428c35b66a21ba5d17077ae762dece8a4a37da50f3e51924f1', 1),
(52486165127274496, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",65]', 0, [[timestamp]], 0, 0, 'cb9e048cfb94ea572f055b3caab6480fb08b109554b6e91efa2a825e2708ee59', 1),
(52486165487984640, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",66]', 0, [[timestamp]], 0, 0, '9d725d00c54a8b6f8571c1b5c38ac39107be14c2c042010495dac337512a8023', 1),
(52486165831917568, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",67]', 0, [[timestamp]], 0, 0, '193f608e1cf40adf040cf4811b060504550f5f5afafedc2c174ac2810e626017', 1),
(52486166188433408, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",68]', 0, [[timestamp]], 0, 0, 'cc188d1435ffdf91b2b20e0af7b4fab97f289545724e5a2244ce21e4e819bbd2', 1),
(52486166536560640, 'OC\\FilesMetadata\\Job\\UpdateSingleMetadata', '["[[admin_username]]",69]', 0, [[timestamp]], 0, 0, '7166bc63d8ecffea256bf43c37e45cb2399c2b653da2fb1cfbe298c2b3da96f4', 1),
(52486855656513536, 'OCA\\Calendar\\BackgroundJob\\CleanUpOutdatedBookingsJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486887495475200, 'OCA\\Contacts\\Cron\\SocialUpdateRegistration', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486943053225984, 'OCA\\Mail\\BackgroundJob\\CleanupJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486943179055104, 'OCA\\Mail\\BackgroundJob\\ContextChat\\SubmitContentJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486943296495616, 'OCA\\Mail\\BackgroundJob\\OutboxWorkerJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486943392964608, 'OCA\\Mail\\BackgroundJob\\IMipMessageJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486943522988032, 'OCA\\Mail\\BackgroundJob\\DraftsJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486943627845632, 'OCA\\Mail\\BackgroundJob\\TrashRetentionJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486943732703232, 'OCA\\Mail\\BackgroundJob\\WakeJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486953446711296, 'OCA\\Richdocuments\\Backgroundjobs\\ObtainCapabilities', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52486953639649280, 'OCA\\Richdocuments\\Backgroundjobs\\Cleanup', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52487000502607872, 'OCA\\Talk\\BackgroundJob\\CheckCertificates', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52487001014312960, 'OCA\\Talk\\BackgroundJob\\CheckHostedSignalingServer', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52487001203056640, 'OCA\\Talk\\BackgroundJob\\CheckMatterbridges', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52487001307914240, 'OCA\\Talk\\BackgroundJob\\ExpireChatMessages', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52487001433743360, 'OCA\\Talk\\BackgroundJob\\ExpireObjectRooms', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52487001538600960, 'OCA\\Talk\\BackgroundJob\\ExpireSignalingMessage', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52487001677012992, 'OCA\\Talk\\BackgroundJob\\LockInactiveRooms', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52487001777676288, 'OCA\\Talk\\BackgroundJob\\MaximumCallDuration', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52487001920282624, 'OCA\\Talk\\BackgroundJob\\Reminder', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52487002146775040, 'OCA\\Talk\\BackgroundJob\\RemoveEmptyRooms', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52487002394238976, 'OCA\\Talk\\BackgroundJob\\ResetAssignedSignalingServer', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52487002541039616, 'OCA\\Talk\\BackgroundJob\\RetryNotificationsJob', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1),
(52487002645897216, 'OCA\\Talk\\BackgroundJob\\SendScheduledMessages', 'null', 0, [[timestamp]], 0, 0, '74234e98afe7498fb5daf1f36ac2d78acc339464f950703b8c019892f982b90b', 1);

-- --------------------------------------------------------

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

CREATE TABLE `oc_known_users` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `known_to` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `known_user` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ku_known_to` (`known_to`),
  KEY `ku_known_user` (`known_user`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_login_flow_v2` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `timestamp` bigint unsigned NOT NULL,
  `started` smallint unsigned NOT NULL DEFAULT '0',
  `poll_token` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `login_token` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `public_key` text CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `private_key` text CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `client_name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `login_name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `server` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `app_password` varchar(1024) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `poll_token` (`poll_token`),
  UNIQUE KEY `login_token` (`login_token`),
  KEY `timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_accounts`
--

CREATE TABLE `oc_mail_accounts` (
  `id` int NOT NULL AUTO_INCREMENT,
  `drafts_mailbox_id` int DEFAULT NULL,
  `sent_mailbox_id` int DEFAULT NULL,
  `trash_mailbox_id` int DEFAULT NULL,
  `archive_mailbox_id` int DEFAULT NULL,
  `junk_mailbox_id` int DEFAULT NULL,
  `snooze_mailbox_id` int DEFAULT NULL,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `email` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `inbound_host` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `inbound_port` varchar(6) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `inbound_ssl_mode` varchar(10) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `inbound_user` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `inbound_password` varchar(2048) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `outbound_host` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `outbound_port` varchar(6) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `outbound_ssl_mode` varchar(10) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `outbound_user` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `outbound_password` varchar(2048) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `signature` text CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `last_mailbox_sync` int NOT NULL DEFAULT '0',
  `editor_mode` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT 'plaintext',
  `order` int NOT NULL DEFAULT '1',
  `show_subscribed_only` tinyint(1) DEFAULT '0',
  `personal_namespace` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `sieve_enabled` tinyint(1) DEFAULT '0',
  `sieve_host` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `sieve_port` varchar(6) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `sieve_ssl_mode` varchar(10) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `sieve_user` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `sieve_password` varchar(2048) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `provisioning_id` int DEFAULT NULL,
  `signature_above_quote` tinyint(1) DEFAULT '0',
  `signature_mode` smallint NOT NULL DEFAULT '0',
  `auth_method` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT 'password',
  `oauth_refresh_token` text CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `oauth_token_ttl` int DEFAULT NULL,
  `oauth_access_token` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `smime_certificate_id` int DEFAULT NULL,
  `quota_percentage` int DEFAULT NULL,
  `trash_retention_days` int DEFAULT NULL,
  `search_body` tinyint(1) DEFAULT '0',
  `ooo_follows_system` tinyint(1) DEFAULT '0',
  `debug` tinyint(1) DEFAULT '0',
  `classification_enabled` tinyint(1) DEFAULT '1',
  `imip_create` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `mail_userid_index` (`user_id`),
  KEY `IDX_61A7E87F59A77CDC` (`drafts_mailbox_id`),
  KEY `IDX_61A7E87F75F54A4B` (`sent_mailbox_id`),
  KEY `IDX_61A7E87F1FA4CF4D` (`trash_mailbox_id`),
  KEY `IDX_61A7E87F5FDB8C8A` (`junk_mailbox_id`),
  KEY `IDX_61A7E87FA47FE329` (`archive_mailbox_id`),
  KEY `IDX_61A7E87F7587D725` (`snooze_mailbox_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_actions`
--

CREATE TABLE `oc_mail_actions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `account_id` int NOT NULL,
  `name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_BB037BC09B6B5FBA` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_action_step`
--

CREATE TABLE `oc_mail_action_step` (
  `id` int NOT NULL AUTO_INCREMENT,
  `action_id` int NOT NULL,
  `mailbox_id` int DEFAULT NULL,
  `tag_id` int DEFAULT NULL,
  `name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `order` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_1EFF6C499D32F035` (`action_id`),
  KEY `IDX_1EFF6C4966EC35CC` (`mailbox_id`),
  KEY `IDX_1EFF6C49BAD26311` (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_aliases`
--

CREATE TABLE `oc_mail_aliases` (
  `id` int NOT NULL AUTO_INCREMENT,
  `account_id` int NOT NULL DEFAULT '0',
  `name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `alias` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `signature` text CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `signature_mode` smallint NOT NULL DEFAULT '0',
  `smime_certificate_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_attachments`
--

CREATE TABLE `oc_mail_attachments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `local_message_id` int DEFAULT NULL,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `file_name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `created_at` int NOT NULL DEFAULT '0',
  `mime_type` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mail_attach_userid_index` (`user_id`),
  KEY `IDX_6C63D3AD31594979` (`local_message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_blocks_shares`
--

CREATE TABLE `oc_mail_blocks_shares` (
  `id` int NOT NULL AUTO_INCREMENT,
  `text_block_id` int NOT NULL,
  `type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `share_with` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mail_blocks_shares_tbid_sw_idx` (`text_block_id`,`share_with`),
  KEY `IDX_33EF06EE5FAF0E1E` (`text_block_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_cc_tasks`
--

CREATE TABLE `oc_mail_cc_tasks` (
  `id` int NOT NULL AUTO_INCREMENT,
  `mailbox_id` int NOT NULL,
  `last_message_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mail_cc_tasks_uniq` (`mailbox_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_coll_addresses`
--

CREATE TABLE `oc_mail_coll_addresses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `email` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `display_name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mail_coll_addr_userid_index` (`user_id`),
  KEY `mail_coll_addr_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_internal_address`
--

CREATE TABLE `oc_mail_internal_address` (
  `id` int NOT NULL AUTO_INCREMENT,
  `address` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mail_internal_address_uniq` (`address`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_local_messages`
--

CREATE TABLE `oc_mail_local_messages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` int unsigned NOT NULL,
  `account_id` int NOT NULL,
  `alias_id` int DEFAULT NULL,
  `send_at` int DEFAULT NULL,
  `subject` tinytext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `html` tinyint(1) DEFAULT '0',
  `in_reply_to_message_id` text CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `failed` tinyint(1) DEFAULT '0',
  `editor_body` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `updated_at` int DEFAULT NULL,
  `smime_sign` tinyint(1) DEFAULT '0',
  `smime_certificate_id` int DEFAULT NULL,
  `smime_encrypt` tinyint(1) DEFAULT '0',
  `status` int DEFAULT '0',
  `raw` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `request_mdn` tinyint(1) DEFAULT '0',
  `pgp_mime` tinyint(1) DEFAULT '0',
  `body_plain` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `body_html` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_mailboxes`
--

CREATE TABLE `oc_mail_mailboxes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(1024) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `account_id` int NOT NULL,
  `attributes` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '[]',
  `delimiter` varchar(1) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `messages` int NOT NULL,
  `unseen` int NOT NULL,
  `selectable` tinyint(1) DEFAULT '0',
  `special_use` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '[]',
  `sync_new_lock` int DEFAULT NULL,
  `sync_changed_lock` int DEFAULT NULL,
  `sync_vanished_lock` int DEFAULT NULL,
  `sync_new_token` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `sync_changed_token` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `sync_vanished_token` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `sync_in_background` tinyint(1) DEFAULT '0',
  `my_acls` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `shared` tinyint(1) DEFAULT '0',
  `name_hash` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mail_mb_account_id_name_hash` (`account_id`,`name_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_messages`
--

CREATE TABLE `oc_mail_messages` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `uid` int NOT NULL,
  `message_id` varchar(1023) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `mailbox_id` int NOT NULL,
  `subject` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `sent_at` int NOT NULL,
  `flag_answered` tinyint(1) DEFAULT '0',
  `flag_deleted` tinyint(1) DEFAULT '0',
  `flag_draft` tinyint(1) DEFAULT '0',
  `flag_flagged` tinyint(1) DEFAULT '0',
  `flag_seen` tinyint(1) DEFAULT '0',
  `flag_forwarded` tinyint(1) DEFAULT '0',
  `flag_junk` tinyint(1) DEFAULT '0',
  `flag_notjunk` tinyint(1) DEFAULT '0',
  `flag_attachments` tinyint(1) DEFAULT '0',
  `flag_important` tinyint(1) DEFAULT '0',
  `structure_analyzed` tinyint(1) DEFAULT '0',
  `preview_text` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `references` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `in_reply_to` varchar(1023) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `thread_root_id` varchar(1023) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `flag_mdnsent` tinyint(1) DEFAULT '0',
  `imip_message` tinyint(1) DEFAULT '0',
  `imip_processed` tinyint(1) DEFAULT '0',
  `imip_error` tinyint(1) DEFAULT '0',
  `encrypted` tinyint(1) DEFAULT '0',
  `mentions_me` tinyint(1) DEFAULT '0',
  `summary` varchar(1024) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mail_messages_id_flags` (`mailbox_id`,`flag_important`,`flag_deleted`,`flag_seen`),
  KEY `mail_messages_id_flags2` (`mailbox_id`,`flag_deleted`,`flag_flagged`),
  KEY `mail_messages_msgid_idx` (`message_id`(128)),
  KEY `mail_msg_thrd_root_snt_idx` (`mailbox_id`,`thread_root_id`(64),`sent_at`),
  KEY `mail_messages_mb_id_uid` (`mailbox_id`,`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_messages_retention`
--

CREATE TABLE `oc_mail_messages_retention` (
  `id` int NOT NULL AUTO_INCREMENT,
  `known_since` int NOT NULL,
  `mailbox_id` int NOT NULL,
  `uid` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mail_msg_retention_mbuid_idx` (`mailbox_id`,`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_messages_snoozed`
--

CREATE TABLE `oc_mail_messages_snoozed` (
  `id` int NOT NULL AUTO_INCREMENT,
  `snoozed_until` int NOT NULL,
  `src_mailbox_id` int DEFAULT NULL,
  `mailbox_id` int NOT NULL,
  `uid` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mail_msg_snoozed_mbuid_idx` (`mailbox_id`,`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_message_tags`
--

CREATE TABLE `oc_mail_message_tags` (
  `id` int NOT NULL AUTO_INCREMENT,
  `imap_message_id` varchar(1023) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `tag_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mail_msg_imap_id_idx` (`imap_message_id`(128))
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_provisionings`
--

CREATE TABLE `oc_mail_provisionings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `provisioning_domain` varchar(63) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `email_template` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `imap_user` varchar(128) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `imap_host` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `imap_port` smallint unsigned NOT NULL,
  `imap_ssl_mode` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `smtp_user` varchar(128) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `smtp_host` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `smtp_port` smallint unsigned NOT NULL,
  `smtp_ssl_mode` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `sieve_enabled` tinyint(1) DEFAULT '0',
  `sieve_user` varchar(128) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `sieve_host` varchar(128) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `sieve_port` smallint unsigned DEFAULT NULL,
  `sieve_ssl_mode` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `ldap_aliases_provisioning` tinyint(1) DEFAULT '0',
  `ldap_aliases_attribute` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `master_password_enabled` tinyint(1) DEFAULT '0',
  `master_password` varchar(256) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mail_provsng_dm_idx` (`provisioning_domain`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_recipients`
--

CREATE TABLE `oc_mail_recipients` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `local_message_id` int DEFAULT NULL,
  `message_id` int DEFAULT NULL,
  `type` int NOT NULL,
  `label` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `email` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mail_recipient_msg_id_idx` (`message_id`),
  KEY `mail_recipient_email_idx` (`email`),
  KEY `IDX_715DB7E31594979` (`local_message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_smime_certificates`
--

CREATE TABLE `oc_mail_smime_certificates` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `email_address` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `certificate` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `private_key` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  PRIMARY KEY (`id`),
  KEY `mail_smime_certs_uid_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_tags`
--

CREATE TABLE `oc_mail_tags` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `imap_label` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `display_name` varchar(128) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `color` varchar(9) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '#fff',
  `is_default_tag` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mail_msg_tags_usr_lbl_idx` (`user_id`,`imap_label`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_text_blocks`
--

CREATE TABLE `oc_mail_text_blocks` (
  `id` int NOT NULL AUTO_INCREMENT,
  `owner` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `title` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `content` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `preview` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  KEY `mail_text_blocks_owner_idx` (`owner`),
  KEY `mail_text_blocks_id_owner_idx` (`id`,`owner`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_mail_trusted_senders`
--

CREATE TABLE `oc_mail_trusted_senders` (
  `id` int NOT NULL AUTO_INCREMENT,
  `email` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `type` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT 'individual',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mail_trusted_sender_uniq` (`email`,`user_id`),
  KEY `mail_trusted_senders_type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_migrations` (
  `app` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `version` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`app`,`version`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_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'),
('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_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'),
('mail', '0100Date20180825194217'),
('mail', '0110Date20180825195812'),
('mail', '0110Date20180825201241'),
('mail', '0130Date20190408134101'),
('mail', '0156Date20190828140357'),
('mail', '0161Date20190902103559'),
('mail', '0161Date20190902103701'),
('mail', '0161Date20190902114635'),
('mail', '0180Date20190927124207'),
('mail', '0190Date20191118160843'),
('mail', '0210Date20191212144925'),
('mail', '1020Date20191002091034'),
('mail', '1020Date20191002091035'),
('mail', '1020Date20200206134751'),
('mail', '1030Date20200228105714'),
('mail', '1040Date20200422130220'),
('mail', '1040Date20200422142920'),
('mail', '1040Date20200506111214'),
('mail', '1040Date20200515080614'),
('mail', '1040Date20200529124657'),
('mail', '1050Date20200624101359'),
('mail', '1050Date20200831124954'),
('mail', '1050Date20200921141700'),
('mail', '1050Date20200923180030'),
('mail', '1060Date20201015084952'),
('mail', '1080Date20201119084820'),
('mail', '1080Date20210108093802'),
('mail', '1090Date20210127160127'),
('mail', '1090Date20210216154409'),
('mail', '1096Date20210407150016'),
('mail', '1100Date20210304143008'),
('mail', '1100Date20210317164707'),
('mail', '1100Date20210326103929'),
('mail', '1100Date20210409091311'),
('mail', '1100Date20210419080523'),
('mail', '1100Date20210419121734'),
('mail', '1100Date20210421113423'),
('mail', '1100Date20210512142306'),
('mail', '1101Date20210616141806'),
('mail', '1105Date20210922104324'),
('mail', '1110Date20210908114229'),
('mail', '1115Date20211216144446'),
('mail', '1120Date20220223094709'),
('mail', '1124Date20220531094751'),
('mail', '1124Date20220601084530'),
('mail', '1130Date20220412111833'),
('mail', '1130Date20220520062301'),
('mail', '1140Date20220628174152'),
('mail', '1140Date20220701103556'),
('mail', '1140Date20220808203258'),
('mail', '1140Date20221027171138'),
('mail', '1140Date20221113205737'),
('mail', '1140Date20221206162029'),
('mail', '2000Date20220908130842'),
('mail', '2010Date20221002201527'),
('mail', '2020Date20221103140538'),
('mail', '2100Date20221013143851'),
('mail', '2300Date20221205160349'),
('mail', '2300Date20221215143450'),
('mail', '2300Date20221216115727'),
('mail', '2300Date20230120085320'),
('mail', '2300Date20230127093733'),
('mail', '2300Date20230214104736'),
('mail', '2300Date20230221170502'),
('mail', '3000Date20230301152454'),
('mail', '3001Date20230307113544'),
('mail', '3300Date20230706140531'),
('mail', '3300Date20230801124717'),
('mail', '3400Date20230807300513'),
('mail', '3400Date20230814160451'),
('mail', '3400Date20230818160236'),
('mail', '3400Date20230819161945'),
('mail', '3400Date20230823153943'),
('mail', '3400Date20230907103114'),
('mail', '3500Date20231005091430'),
('mail', '3500Date20231009102414'),
('mail', '3500Date20231114180656'),
('mail', '3500Date20231115182612'),
('mail', '3500Date20231115184458'),
('mail', '3600Date20240205180726'),
('mail', '3600Date20240220134813'),
('mail', '3600Date20240227172825'),
('mail', '3700Date20240430115406'),
('mail', '3700Date20240506161400'),
('mail', '3800Date20240628163133'),
('mail', '4000Date20240716172702'),
('mail', '4001Date20241009140707'),
('mail', '4001Date20241017154801'),
('mail', '4001Date20241017155914'),
('mail', '4100Date20240916174827'),
('mail', '4100Date20241021091352'),
('mail', '4100Date20241209000000'),
('mail', '4200Date20241210000000'),
('mail', '4200Date20241210000001'),
('mail', '5000Date20250405000000'),
('mail', '5005Date20250903114906'),
('mail', '5005Date20250903114909'),
('mail', '5005Date20250927125152'),
('mail', '5006Date20250927130132'),
('mail', '5006Date20251015082003'),
('mail', '5006Date20251023191023'),
('mail', '5007Date20251024153423'),
('mail', '5007Date20251208000000'),
('mail', '5007Date20260108124422'),
('mail', '5200Date20250728000000'),
('notes', '3005Date20200528204430'),
('notes', '3005Date20200528204431'),
('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'),
('richdocuments', '10000Date20251217143558'),
('richdocuments', '2060Date20200302131958'),
('richdocuments', '2060Date20200302132145'),
('richdocuments', '30704Date20200626072306'),
('richdocuments', '30709Date20201111104147'),
('richdocuments', '30717Date20210310164901'),
('richdocuments', '50200Date20211220212457'),
('richdocuments', '9000Date20250128212050'),
('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'),
('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 NOT NULL AUTO_INCREMENT,
  `mimetype` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `mimetype_id_index` (`mimetype`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=26 ;

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

INSERT INTO `oc_mimetypes` VALUES
(3, 'application'),
(23, 'application/font-sfnt'),
(21, 'application/gzip'),
(19, 'application/javascript'),
(22, 'application/json'),
(20, 'application/octet-stream'),
(7, 'application/pdf'),
(16, 'application/vnd.excalidraw+json'),
(14, 'application/vnd.oasis.opendocument.graphics'),
(13, 'application/vnd.oasis.opendocument.presentation'),
(17, 'application/vnd.oasis.opendocument.spreadsheet'),
(15, 'application/vnd.oasis.opendocument.text'),
(4, 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'),
(1, 'httpd'),
(2, 'httpd/unix-directory'),
(8, 'image'),
(12, 'image/jpeg'),
(9, 'image/png'),
(24, 'image/svg+xml'),
(5, 'text'),
(6, 'text/markdown'),
(18, 'text/vcard'),
(10, 'video'),
(11, 'video/mp4');

-- --------------------------------------------------------

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

CREATE TABLE `oc_mounts` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `storage_id` bigint NOT NULL,
  `root_id` bigint NOT NULL,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `mount_point` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `mount_id` bigint DEFAULT NULL,
  `mount_provider_class` varchar(128) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `mount_point_hash` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mounts_user_root_path_index` (`user_id`,`root_id`,`mount_point_hash`),
  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  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=2 ;

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

INSERT INTO `oc_mounts` VALUES
(1, 1, 1, '[[admin_username]]', '/[[admin_username]]/', NULL, 'OC\\Files\\Mount\\LocalHomeMountProvider', '');

-- --------------------------------------------------------

--
-- Table structure for table `oc_notes_meta`
--

CREATE TABLE `oc_notes_meta` (
  `id` int NOT NULL AUTO_INCREMENT,
  `file_id` int NOT NULL,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `last_update` int NOT NULL,
  `etag` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `content_etag` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `file_etag` varchar(40) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `notes_meta_file_user_index` (`file_id`,`user_id`),
  KEY `notes_meta_file_id_index` (`file_id`),
  KEY `notes_meta_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

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

-- --------------------------------------------------------

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

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

-- --------------------------------------------------------

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

CREATE TABLE `oc_notifications_settings` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `batch_time` int NOT NULL DEFAULT '0',
  `last_send_id` bigint NOT NULL DEFAULT '0',
  `next_send_time` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `notset_user` (`user_id`),
  KEY `notset_nextsend` (`next_send_time`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_oauth2_access_tokens` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `token_id` int NOT NULL,
  `client_id` int NOT NULL,
  `hashed_code` varchar(128) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `encrypted_token` varchar(786) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `code_created_at` bigint unsigned NOT NULL DEFAULT '0',
  `token_count` bigint 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_oauth2_clients` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `redirect_uri` varchar(2000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `client_identifier` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `secret` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `oauth2_client_id_idx` (`client_identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_open_local_editor` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `path_hash` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `expiration_time` bigint unsigned NOT NULL,
  `token` varchar(128) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `openlocal_user_path_token` (`user_id`,`path_hash`,`token`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_photos_albums` (
  `album_id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `user` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `created` bigint NOT NULL,
  `location` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `last_added_photo` bigint NOT NULL,
  `filters` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  PRIMARY KEY (`album_id`),
  KEY `pa_user` (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_photos_albums_collabs` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `album_id` bigint NOT NULL,
  `collaborator_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `collaborator_type` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `album_collabs_uniq_collab` (`album_id`,`collaborator_id`,`collaborator_type`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_photos_albums_files` (
  `album_file_id` bigint NOT NULL AUTO_INCREMENT,
  `album_id` bigint NOT NULL,
  `file_id` bigint NOT NULL,
  `added` bigint NOT NULL,
  `owner` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_preferences` (
  `userid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `appid` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `configkey` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `configvalue` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `lazy` smallint unsigned NOT NULL DEFAULT '0',
  `type` smallint unsigned NOT NULL DEFAULT '0',
  `flags` int unsigned NOT NULL DEFAULT '0',
  `indexed` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin 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=[[utf8]] COLLATE=[[utf8]]_bin;

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

INSERT INTO `oc_preferences` VALUES
('[[admin_username]]', 'core', 'lang', '[[language]]', 0, 1, 0, ''),
('[[admin_username]]', 'core', 'templateDirectory', 'Templates/', 0, 0, 0, ''),
('[[admin_username]]', 'login', 'lastLogin', '[[timestamp]]', 0, 0, 0, '');
-- --------------------------------------------------------

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

CREATE TABLE `oc_preferences_ex` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `userid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `appid` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `configkey` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `configvalue` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `sensitive` smallint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `preferences_ex__idx` (`userid`,`appid`,`configkey`),
  KEY `preferences_ex__configkey` (`configkey`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_previews` (
  `id` bigint unsigned NOT NULL,
  `file_id` bigint unsigned NOT NULL,
  `storage_id` bigint unsigned NOT NULL,
  `old_file_id` bigint unsigned DEFAULT NULL,
  `location_id` bigint unsigned DEFAULT NULL,
  `width` int unsigned NOT NULL,
  `height` int unsigned NOT NULL,
  `mimetype_id` int NOT NULL,
  `source_mimetype_id` int 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) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `mtime` int unsigned NOT NULL,
  `size` int unsigned NOT NULL,
  `version_id` bigint 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=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_preview_locations` (
  `id` bigint unsigned NOT NULL,
  `bucket_name` varchar(40) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `object_store_name` varchar(40) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unique_bucket_store` (`bucket_name`,`object_store_name`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_preview_versions` (
  `id` bigint unsigned NOT NULL,
  `file_id` bigint unsigned NOT NULL,
  `version` varchar(1024) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_privacy_admins` (
  `id` int NOT NULL AUTO_INCREMENT,
  `displayname` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_profile_config` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `config` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `profile_config_user_id_idx` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_properties` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `userid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `propertypath` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `propertyname` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `propertyvalue` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `valuetype` smallint DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `properties_path_index` (`userid`,`propertypath`),
  KEY `properties_pathonly_index` (`propertypath`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_ratelimit_entries` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `hash` varchar(128) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `delete_after` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ratelimit_hash` (`hash`),
  KEY `ratelimit_delete_after` (`delete_after`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_reactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` bigint unsigned NOT NULL,
  `message_id` bigint unsigned NOT NULL,
  `actor_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `actor_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `reaction` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_recent_contact` (
  `id` int NOT NULL AUTO_INCREMENT,
  `actor_uid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `uid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `email` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `federated_cloud_id` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `card` longblob NOT NULL,
  `last_contact` int 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_richdocuments_assets`
--

CREATE TABLE `oc_richdocuments_assets` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `fileid` bigint NOT NULL,
  `token` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `timestamp` bigint unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `rd_assets_token_idx` (`token`),
  UNIQUE KEY `rd_assets_timestamp_idx` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_richdocuments_direct`
--

CREATE TABLE `oc_richdocuments_direct` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `token` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `uid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `fileid` bigint NOT NULL,
  `timestamp` bigint unsigned DEFAULT '0',
  `template_destination` bigint DEFAULT NULL,
  `template_id` bigint DEFAULT NULL,
  `share` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `initiator_host` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `initiator_token` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `rd_direct_token_idx` (`token`),
  KEY `rd_direct_timestamp_idx` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_richdocuments_template`
--

CREATE TABLE `oc_richdocuments_template` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `userid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `fileid` bigint NOT NULL,
  `templateid` bigint NOT NULL,
  `timestamp` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `rd_t_user_file` (`userid`,`fileid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `oc_richdocuments_wopi`
--

CREATE TABLE `oc_richdocuments_wopi` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `owner_uid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `editor_uid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `guest_displayname` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `fileid` bigint NOT NULL,
  `version` varchar(1024) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '0',
  `canwrite` tinyint(1) DEFAULT '0',
  `server_host` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT 'localhost',
  `token` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `expiry` bigint unsigned DEFAULT NULL,
  `template_destination` bigint DEFAULT NULL,
  `template_id` bigint DEFAULT NULL,
  `hide_download` tinyint(1) DEFAULT '0',
  `direct` tinyint(1) DEFAULT '0',
  `remote_server` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `remote_server_token` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `share` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `token_type` int DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `rd_wopi_token_idx` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_schedulingobjects` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `principaluri` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `calendardata` longblob,
  `uri` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `lastmodified` int unsigned DEFAULT NULL,
  `etag` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `size` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `schedulobj_principuri_index` (`principaluri`),
  KEY `schedulobj_lastmodified_idx` (`lastmodified`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_sec_signatory` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `key_id_sum` varchar(127) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `key_id` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `host` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `provider_id` varchar(31) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `account` varchar(127) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `public_key` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `metadata` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `type` smallint NOT NULL DEFAULT '9',
  `status` smallint NOT NULL DEFAULT '0',
  `creation` int unsigned DEFAULT '0',
  `last_updated` int 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_share` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `share_type` smallint NOT NULL DEFAULT '0',
  `share_with` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `password` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `uid_owner` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `uid_initiator` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `parent` bigint DEFAULT NULL,
  `item_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `item_source` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `item_target` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `file_source` bigint DEFAULT NULL,
  `file_target` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `permissions` smallint NOT NULL DEFAULT '0',
  `stime` bigint NOT NULL DEFAULT '0',
  `accepted` smallint NOT NULL DEFAULT '0',
  `expiration` datetime DEFAULT NULL,
  `token` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `mail_send` smallint NOT NULL DEFAULT '0',
  `share_name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `password_by_talk` tinyint(1) DEFAULT '0',
  `note` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `hide_download` smallint DEFAULT '0',
  `label` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `attributes` json DEFAULT NULL,
  `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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_shares_limits` (
  `id` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `limit` bigint NOT NULL,
  `downloads` bigint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_share_external` (
  `id` bigint NOT NULL,
  `parent` bigint DEFAULT '-1',
  `share_type` int DEFAULT NULL,
  `remote` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `remote_id` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `share_token` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `password` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `name` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `owner` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `user` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `mountpoint` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `mountpoint_hash` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `accepted` int 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=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_storages` (
  `numeric_id` bigint NOT NULL AUTO_INCREMENT,
  `id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `available` int NOT NULL DEFAULT '1',
  `last_checked` int DEFAULT NULL,
  PRIMARY KEY (`numeric_id`),
  UNIQUE KEY `storages_id_index` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=3 ;

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

INSERT INTO `oc_storages` VALUES
(1, 'home::[[admin_username]]', 1, NULL),
(2, 'local::[[softdatadir]]/', 1, NULL);

-- --------------------------------------------------------

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

CREATE TABLE `oc_storages_credentials` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `identifier` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `credentials` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  PRIMARY KEY (`id`),
  UNIQUE KEY `stocred_ui` (`user`,`identifier`),
  KEY `stocred_user` (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_systemtag` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `visibility` smallint NOT NULL DEFAULT '1',
  `editable` smallint NOT NULL DEFAULT '1',
  `etag` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `color` varchar(6) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tag_ident` (`name`,`visibility`,`editable`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_systemtag_group` (
  `systemtagid` bigint unsigned NOT NULL DEFAULT '0',
  `gid` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`gid`,`systemtagid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_systemtag_object_mapping` (
  `objectid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `objecttype` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `systemtagid` bigint 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=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_attachments` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `room_id` bigint unsigned NOT NULL,
  `message_id` bigint unsigned NOT NULL,
  `message_time` bigint unsigned NOT NULL,
  `object_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `actor_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `actor_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  KEY `objects_in_room` (`room_id`,`object_type`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_attendees` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `room_id` bigint unsigned NOT NULL,
  `actor_type` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `actor_id` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `display_name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `pin` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `participant_type` smallint unsigned NOT NULL DEFAULT '0',
  `favorite` tinyint(1) DEFAULT '0',
  `notification_level` int DEFAULT '0',
  `last_joined_call` int unsigned NOT NULL DEFAULT '0',
  `last_read_message` bigint DEFAULT '0',
  `last_mention_message` bigint DEFAULT '0',
  `read_privacy` smallint unsigned DEFAULT '0',
  `access_token` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `remote_id` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `last_mention_direct` bigint NOT NULL DEFAULT '0',
  `permissions` int NOT NULL DEFAULT '0',
  `notification_calls` int NOT NULL DEFAULT '1',
  `phone_number` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `call_id` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `invited_cloud_id` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `state` smallint unsigned NOT NULL DEFAULT '0',
  `unread_messages` bigint unsigned NOT NULL DEFAULT '0',
  `last_attendee_activity` bigint 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 DEFAULT '0',
  `has_scheduled_messages` int 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=4 ;

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

INSERT INTO `oc_talk_attendees` VALUES
(1, 1, 'users', '[[admin_username]]', '[[admin_username]]', NULL, 3, 0, 0, 0, 1, 0, 0, NULL, NULL, 0, 0, 1, '', '', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(2, 2, 'users', '[[admin_username]]', '[[admin_username]]', NULL, 1, 1, 0, 0, 5, 0, 0, NULL, NULL, 0, 0, 1, '', '', NULL, 0, 0, [[timestamp]], 0, 0, 0, 0, 0, 0, 0, 0),
(3, 3, 'users', '[[admin_username]]', '[[admin_username]]', NULL, 1, 0, 0, 0, 6, 0, 0, NULL, NULL, 0, 0, 1, '', '', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_bans` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `moderator_actor_type` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `moderator_actor_id` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `moderator_displayname` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `banned_actor_type` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `banned_actor_id` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `banned_displayname` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `room_id` bigint unsigned NOT NULL,
  `banned_time` datetime DEFAULT NULL,
  `internal_note` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_bots_conversation` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `bot_id` bigint unsigned NOT NULL DEFAULT '0',
  `token` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `state` smallint 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_bots_server` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `url` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `url_hash` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `description` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `secret` varchar(128) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `error_count` bigint unsigned NOT NULL DEFAULT '0',
  `last_error_date` datetime DEFAULT NULL,
  `last_error_message` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `state` smallint unsigned DEFAULT '0',
  `features` int 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_bridges` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `room_id` bigint unsigned NOT NULL,
  `json_values` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `enabled` smallint unsigned NOT NULL DEFAULT '0',
  `pid` int unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `tbr_room_id` (`room_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_commands` (
  `id` int NOT NULL AUTO_INCREMENT,
  `app` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `command` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `script` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `response` int NOT NULL DEFAULT '1',
  `enabled` int NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_consent` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `token` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `actor_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `actor_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_internalsignaling` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `sender` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `recipient` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `message` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `timestamp` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tis_recipient_time` (`recipient`,`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_invitations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `state` smallint unsigned NOT NULL DEFAULT '0',
  `local_room_id` bigint unsigned NOT NULL,
  `access_token` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `remote_server_url` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `remote_token` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `remote_attendee_id` bigint unsigned NOT NULL,
  `inviter_cloud_id` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `inviter_display_name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `local_cloud_id` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_phone_numbers` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `phone_number` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `actor_id` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_5E5DC3C46B01BC5B` (`phone_number`),
  KEY `IDX_5E5DC3C410DAF24A` (`actor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_polls` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `room_id` bigint NOT NULL,
  `question` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `options` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `votes` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `num_voters` bigint DEFAULT '0',
  `actor_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `actor_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `display_name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `status` smallint DEFAULT '0',
  `result_mode` smallint DEFAULT '0',
  `max_votes` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `talk_poll_room` (`room_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_poll_votes` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `poll_id` bigint NOT NULL,
  `room_id` bigint NOT NULL,
  `actor_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `actor_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `display_name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `option_id` int 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_proxy_messages` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `local_token` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `remote_server_url` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `remote_token` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `remote_message_id` bigint unsigned NOT NULL,
  `actor_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `actor_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `actor_display_name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `message_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `system_message` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `expiration_datetime` datetime DEFAULT NULL,
  `message` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `message_parameters` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `creation_datetime` datetime DEFAULT NULL,
  `meta_data` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_reminders` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `token` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `message_id` bigint 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_retry_ocm` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `remote_server` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `num_attempts` int unsigned NOT NULL DEFAULT '0',
  `next_retry` datetime DEFAULT NULL,
  `notification_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `resource_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `provider_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `notification` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`),
  KEY `talk_retry_ocm_next` (`next_retry`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_rooms` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `token` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `type` int NOT NULL,
  `password` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `active_since` datetime DEFAULT NULL,
  `last_activity` datetime DEFAULT NULL,
  `last_message` bigint DEFAULT '0',
  `object_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `object_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `read_only` int NOT NULL DEFAULT '0',
  `lobby_state` int NOT NULL DEFAULT '0',
  `lobby_timer` datetime DEFAULT NULL,
  `assigned_hpb` int DEFAULT NULL,
  `sip_enabled` smallint unsigned NOT NULL DEFAULT '0',
  `description` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `listable` smallint unsigned DEFAULT '0',
  `call_flag` int NOT NULL DEFAULT '0',
  `default_permissions` int NOT NULL DEFAULT '0',
  `call_permissions` int NOT NULL DEFAULT '0',
  `remote_server` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `remote_token` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `message_expiration` int NOT NULL DEFAULT '0',
  `breakout_room_mode` int NOT NULL DEFAULT '0',
  `breakout_room_status` int NOT NULL DEFAULT '0',
  `avatar` varchar(24) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `call_recording` int NOT NULL DEFAULT '0',
  `recording_consent` smallint unsigned NOT NULL DEFAULT '0',
  `has_federation` smallint unsigned NOT NULL DEFAULT '0',
  `mention_permissions` int NOT NULL DEFAULT '0',
  `has_attachments` smallint DEFAULT '0',
  `transcription_language` varchar(16) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `last_pinned_id` bigint 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_scheduled_msg` (
  `id` bigint unsigned NOT NULL,
  `room_id` bigint NOT NULL,
  `actor_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `actor_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `message` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `message_type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `meta_data` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `thread_id` bigint NOT NULL DEFAULT '0',
  `parent_id` bigint 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=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_sessions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `attendee_id` bigint unsigned NOT NULL,
  `session_id` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `in_call` int NOT NULL DEFAULT '0',
  `last_ping` int unsigned NOT NULL DEFAULT '0',
  `state` smallint 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_threads` (
  `id` bigint NOT NULL,
  `room_id` bigint NOT NULL,
  `last_message_id` bigint NOT NULL DEFAULT '0',
  `num_replies` bigint NOT NULL DEFAULT '0',
  `last_activity` datetime DEFAULT NULL,
  `name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `tt_room_threads` (`room_id`),
  KEY `talkthread_lastactive` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_talk_thread_attendees` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `room_id` bigint NOT NULL,
  `thread_id` bigint NOT NULL,
  `attendee_id` bigint NOT NULL,
  `actor_type` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `actor_id` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `notification_level` int 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_taskprocessing_tasks` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `type` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `input` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `output` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `status` int DEFAULT '0',
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `app_id` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `custom_id` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `last_updated` int unsigned DEFAULT '0',
  `completion_expected_at` datetime DEFAULT NULL,
  `progress` double DEFAULT '0',
  `error_message` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `scheduled_at` int unsigned DEFAULT NULL,
  `started_at` int unsigned DEFAULT NULL,
  `ended_at` int unsigned DEFAULT NULL,
  `webhook_uri` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `webhook_method` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `allow_cleanup` smallint unsigned NOT NULL DEFAULT '1',
  `user_facing_error_message` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `include_watermark` smallint 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_text2image_tasks` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `input` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `status` int DEFAULT '0',
  `number_of_images` int NOT NULL DEFAULT '1',
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `app_id` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `identifier` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_textprocessing_tasks` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `type` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `input` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `output` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `status` int DEFAULT '0',
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `app_id` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `identifier` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `last_updated` int 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_text_documents` (
  `id` bigint unsigned NOT NULL,
  `current_version` bigint unsigned DEFAULT '0',
  `last_saved_version` bigint unsigned DEFAULT '0',
  `last_saved_version_time` bigint unsigned NOT NULL,
  `last_saved_version_etag` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `base_version_etag` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  `checksum` varchar(8) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_text_sessions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `guest_name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `color` varchar(7) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `token` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `document_id` bigint NOT NULL,
  `last_contact` bigint unsigned NOT NULL,
  `last_awareness_message` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_text_steps` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `document_id` bigint unsigned NOT NULL,
  `session_id` bigint unsigned NOT NULL,
  `data` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `version` bigint unsigned DEFAULT '0',
  `timestamp` bigint 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`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_trusted_servers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `url` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `url_hash` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `token` varchar(128) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `shared_secret` varchar(256) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `status` int NOT NULL DEFAULT '2',
  `sync_token` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `url_hash` (`url_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_twofactor_backupcodes` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `code` varchar(128) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `used` smallint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `twofactor_backupcodes_uid` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_twofactor_providers` (
  `provider_id` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `uid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `enabled` smallint NOT NULL,
  PRIMARY KEY (`provider_id`,`uid`),
  KEY `twofactor_providers_uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin;

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

INSERT INTO `oc_twofactor_providers` VALUES
('backup_codes', '[[admin_username]]', 0),
('totp', '[[admin_username]]', 0);

-- --------------------------------------------------------

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

CREATE TABLE `oc_twofactor_totp_secrets` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `secret` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `state` int NOT NULL DEFAULT '2',
  `last_counter` bigint NOT NULL DEFAULT '-1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `totp_secrets_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_users` (
  `uid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `displayname` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `password` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `uid_lower` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT '',
  PRIMARY KEY (`uid`),
  KEY `user_uid_lower` (`uid_lower`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin;

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

INSERT INTO `oc_users` VALUES
('[[admin_username]]', NULL, '[[admin_pass]]', '[[admin_username_lower]]');

-- --------------------------------------------------------

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

CREATE TABLE `oc_user_status` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `status` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `status_timestamp` int unsigned NOT NULL,
  `is_user_defined` tinyint(1) DEFAULT NULL,
  `message_id` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `custom_icon` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `custom_message` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `clear_at` int unsigned DEFAULT NULL,
  `is_backup` tinyint(1) DEFAULT '0',
  `status_message_timestamp` int 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  DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_user_transfer_owner` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `source_user` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `target_user` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `file_id` bigint NOT NULL,
  `node_name` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_vcategory` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `category` varchar(255) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_vcategory_to_object` (
  `objid` bigint unsigned NOT NULL DEFAULT '0',
  `categoryid` bigint unsigned NOT NULL DEFAULT '0',
  `type` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  PRIMARY KEY (`categoryid`,`objid`,`type`),
  KEY `vcategory_objectd_index` (`objid`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin;

-- --------------------------------------------------------

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

CREATE TABLE `oc_webauthn` (
  `id` int NOT NULL AUTO_INCREMENT,
  `uid` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `name` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `public_key_credential_id` varchar(512) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `data` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin 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=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_webhook_listeners` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `app_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `http_method` varchar(32) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `uri` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `event` varchar(4000) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL,
  `event_filter` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `user_id_filter` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `headers` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `auth_method` varchar(16) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
  `auth_data` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  `token_needed` longtext CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

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

CREATE TABLE `oc_webhook_tokens` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `token_id` bigint unsigned NOT NULL,
  `user_id` varchar(64) CHARACTER SET [[utf8]] COLLATE [[utf8]]_bin DEFAULT NULL,
  `created_at` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin AUTO_INCREMENT=1 ;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `oc_mail_accounts`
--
ALTER TABLE `oc_mail_accounts`
  ADD CONSTRAINT `FK_61A7E87F1FA4CF4D` FOREIGN KEY (`trash_mailbox_id`) REFERENCES `oc_mail_mailboxes` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_61A7E87F59A77CDC` FOREIGN KEY (`drafts_mailbox_id`) REFERENCES `oc_mail_mailboxes` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_61A7E87F5FDB8C8A` FOREIGN KEY (`junk_mailbox_id`) REFERENCES `oc_mail_mailboxes` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_61A7E87F7587D725` FOREIGN KEY (`snooze_mailbox_id`) REFERENCES `oc_mail_mailboxes` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_61A7E87F75F54A4B` FOREIGN KEY (`sent_mailbox_id`) REFERENCES `oc_mail_mailboxes` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_61A7E87FA47FE329` FOREIGN KEY (`archive_mailbox_id`) REFERENCES `oc_mail_mailboxes` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `oc_mail_actions`
--
ALTER TABLE `oc_mail_actions`
  ADD CONSTRAINT `FK_BB037BC09B6B5FBA` FOREIGN KEY (`account_id`) REFERENCES `oc_mail_accounts` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `oc_mail_action_step`
--
ALTER TABLE `oc_mail_action_step`
  ADD CONSTRAINT `FK_1EFF6C4966EC35CC` FOREIGN KEY (`mailbox_id`) REFERENCES `oc_mail_mailboxes` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_1EFF6C499D32F035` FOREIGN KEY (`action_id`) REFERENCES `oc_mail_actions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_1EFF6C49BAD26311` FOREIGN KEY (`tag_id`) REFERENCES `oc_mail_tags` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `oc_mail_attachments`
--
ALTER TABLE `oc_mail_attachments`
  ADD CONSTRAINT `attachment_local_message` FOREIGN KEY (`local_message_id`) REFERENCES `oc_mail_local_messages` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `oc_mail_blocks_shares`
--
ALTER TABLE `oc_mail_blocks_shares`
  ADD CONSTRAINT `FK_33EF06EE5FAF0E1E` FOREIGN KEY (`text_block_id`) REFERENCES `oc_mail_text_blocks` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `oc_mail_cc_tasks`
--
ALTER TABLE `oc_mail_cc_tasks`
  ADD CONSTRAINT `FK_41D5703266EC35CC` FOREIGN KEY (`mailbox_id`) REFERENCES `oc_mail_mailboxes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `oc_mail_recipients`
--
ALTER TABLE `oc_mail_recipients`
  ADD CONSTRAINT `recipient_local_message` FOREIGN KEY (`local_message_id`) REFERENCES `oc_mail_local_messages` (`id`) ON DELETE CASCADE;

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

X7ROOT File Manager

Editing: nextcloud.sql

Upload File

Create Folder