-- Table structure for table `oc_activity_mq`
--

CREATE TABLE `oc_activity_mq` (
  `mail_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `amq_timestamp` int(11) NOT NULL DEFAULT 0,
  `amq_latest_send` int(11) NOT NULL DEFAULT 0,
  `amq_type` varchar(255) COLLATE utf8_bin NOT NULL,
  `amq_affecteduser` varchar(64) COLLATE utf8_bin NOT NULL,
  `amq_appid` varchar(255) COLLATE utf8_bin NOT NULL,
  `amq_subject` varchar(255) COLLATE utf8_bin NOT NULL,
  `amq_subjectparams` varchar(4000) COLLATE utf8_bin NOT NULL,
  `object_type` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `object_id` bigint(20) 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;

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

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

CREATE TABLE `oc_addressbookchanges` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `synctoken` int(10) unsigned NOT NULL DEFAULT 1,
  `addressbookid` bigint(20) NOT NULL,
  `operation` smallint(6) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `addressbookid_synctoken` (`addressbookid`,`synctoken`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

INSERT INTO `oc_addressbookchanges` VALUES
(1, 'Database:Brandon.vcf', 1, 1, 1),
(2, 'Database:Brandon.vcf', 2, 1, 2),
(3, 'Database:Brandon.vcf', 3, 1, 2),
(4, 'Database:Brandon.vcf', 4, 1, 2),
(5, 'Database:Brandon.vcf', 5, 1, 2),
(6, 'Database:Brandon.vcf', 6, 1, 2),
(7, 'Database:Brandon.vcf', 7, 1, 2),
(8, 'Database:Brandon.vcf', 8, 1, 2),
(9, 'Database:Brandon.vcf', 9, 1, 2),
(10, 'Database:Brandon.vcf', 10, 1, 2);

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

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

CREATE TABLE `oc_addressbooks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `principaluri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `displayname` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `uri` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `synctoken` int(10) unsigned NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  UNIQUE KEY `addressbook_index` (`principaluri`,`uri`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- 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', 11);

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

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

CREATE TABLE `oc_appconfig` (
  `appid` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '',
  `configkey` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `configvalue` longtext COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`appid`,`configkey`),
  KEY `appconfig_config_key_index` (`configkey`),
  KEY `appconfig_appid_key` (`appid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

INSERT INTO `oc_appconfig` VALUES
('accessibility', 'enabled', 'yes'),
('accessibility', 'installed_version', '1.4.0'),
('accessibility', 'types', ''),
('activity', 'enabled', 'yes'),
('activity', 'installed_version', '2.11.0'),
('activity', 'types', 'filesystem'),
('audioplayer', 'enabled', 'yes'),
('audioplayer', 'installed_version', '2.9.0'),
('audioplayer', 'types', 'filesystem'),
('audioplayer_editor', 'enabled', 'yes'),
('audioplayer_editor', 'installed_version', '0.2.0'),
('audioplayer_editor', 'types', 'filesystem'),
('backgroundjob', 'lastjob', '231'),
('breezedark', 'enabled', 'yes'),
('breezedark', 'installed_version', '18.0.9'),
('breezedark', 'types', ''),
('bruteforcesettings', 'enabled', 'yes'),
('bruteforcesettings', 'installed_version', '1.5.0'),
('bruteforcesettings', 'types', ''),
('calendar', 'enabled', 'yes'),
('calendar', 'installed_version', '2.0.2'),
('calendar', 'types', ''),
('camerarawpreviews', 'enabled', 'yes'),
('camerarawpreviews', 'installed_version', '0.7.3'),
('camerarawpreviews', 'types', 'filesystem'),
('cloud_federation_api', 'enabled', 'yes'),
('cloud_federation_api', 'installed_version', '1.1.0'),
('cloud_federation_api', 'types', 'filesystem'),
('comments', 'enabled', 'yes'),
('comments', 'installed_version', '1.8.0'),
('comments', 'types', 'logging'),
('core', 'installed.bundles', '["CoreBundle"]'),
('core', 'installedat', '1580260726.0469'),
('core', 'lastcron', '1585536148'),
('core', 'lastupdateResult', '[]'),
('core', 'lastupdatedat', '1580262573'),
('core', 'oc.integritycheck.checker', '[]'),
('core', 'public_files', 'files_sharing/public.php'),
('core', 'public_webdav', 'dav/appinfo/v1/publicwebdav.php'),
('core', 'theming.variables', 'f6ed5fda11b7fc0126e289646105290d'),
('core', 'vendor', 'nextcloud'),
('dav', 'enabled', 'yes'),
('dav', 'installed_version', '1.14.0'),
('dav', 'types', 'filesystem'),
('event_update_notification', 'enabled', 'yes'),
('event_update_notification', 'installed_version', '1.0.1'),
('event_update_notification', 'types', 'logging,dav'),
('external', 'enabled', 'yes'),
('external', 'installed_version', '3.5.0'),
('external', 'max_site', '1'),
('external', 'sites', '{"1":{"id":1,"name":"Cozi","url":"https:\\/\\/my.cozi.com\\/calendar\\/","lang":"","type":"link","device":"","icon":"external.svg","groups":[],"redirect":false}}'),
('external', 'types', ''),
('federatedfilesharing', 'enabled', 'yes'),
('federatedfilesharing', 'installed_version', '1.8.0'),
('federatedfilesharing', 'types', ''),
('federation', 'enabled', 'yes'),
('federation', 'installed_version', '1.8.0'),
('federation', 'types', 'authentication'),
('files', 'cronjob_scan_files', '500'),
('files', 'enabled', 'yes'),
('files', 'installed_version', '1.13.1'),
('files', 'types', 'filesystem'),
('files_pdfviewer', 'enabled', 'yes'),
('files_pdfviewer', 'installed_version', '1.7.0'),
('files_pdfviewer', 'types', ''),
('files_rightclick', 'enabled', 'yes'),
('files_rightclick', 'installed_version', '0.15.2'),
('files_rightclick', 'types', ''),
('files_sharing', 'enabled', 'yes'),
('files_sharing', 'installed_version', '1.10.1'),
('files_sharing', 'types', 'filesystem'),
('files_trashbin', 'enabled', 'yes'),
('files_trashbin', 'installed_version', '1.8.0'),
('files_trashbin', 'types', 'filesystem,dav'),
('files_versions', 'enabled', 'yes'),
('files_versions', 'installed_version', '1.11.0'),
('files_versions', 'types', 'filesystem,dav'),
('files_videoplayer', 'enabled', 'yes'),
('files_videoplayer', 'installed_version', '1.7.0'),
('files_videoplayer', 'types', ''),
('firstrunwizard', 'enabled', 'yes'),
('firstrunwizard', 'installed_version', '2.7.0'),
('firstrunwizard', 'types', 'logging'),
('logreader', 'enabled', 'yes'),
('logreader', 'installed_version', '2.3.0'),
('logreader', 'types', ''),
('lookup_server_connector', 'enabled', 'yes'),
('lookup_server_connector', 'installed_version', '1.6.0'),
('lookup_server_connector', 'types', 'authentication'),
('music', 'enabled', 'no'),
('music', 'installed_version', '0.13.0'),
('music', 'ocsid', '164319'),
('music', 'types', 'filesystem'),
('nextcloud_announcements', 'enabled', 'yes'),
('nextcloud_announcements', 'installed_version', '1.7.0'),
('nextcloud_announcements', 'pub_date', 'Thu, 24 Oct 2019 00:00:00 +0200'),
('nextcloud_announcements', 'types', 'logging'),
('notifications', 'enabled', 'yes'),
('notifications', 'installed_version', '2.6.0'),
('notifications', 'types', 'logging'),
('oauth2', 'enabled', 'yes'),
('oauth2', 'installed_version', '1.6.0'),
('oauth2', 'types', 'authentication'),
('password_policy', 'enabled', 'yes'),
('password_policy', 'installed_version', '1.8.0'),
('password_policy', 'types', ''),
('photos', 'enabled', 'yes'),
('photos', 'installed_version', '1.0.0'),
('photos', 'types', ''),
('privacy', 'enabled', 'yes'),
('privacy', 'installed_version', '1.2.0'),
('privacy', 'types', ''),
('provisioning_api', 'enabled', 'yes'),
('provisioning_api', 'installed_version', '1.8.0'),
('provisioning_api', 'types', 'prevent_group_restriction'),
('recommendations', 'enabled', 'yes'),
('recommendations', 'installed_version', '0.6.0'),
('recommendations', 'types', ''),
('serverinfo', 'enabled', 'yes'),
('serverinfo', 'installed_version', '1.8.0'),
('serverinfo', 'types', ''),
('settings', 'enabled', 'yes'),
('settings', 'installed_version', '1.0.0'),
('settings', 'types', ''),
('sharebymail', 'enabled', 'yes'),
('sharebymail', 'installed_version', '1.8.0'),
('sharebymail', 'types', 'filesystem'),
('support', 'enabled', 'yes'),
('support', 'installed_version', '1.1.0'),
('support', 'types', 'session'),
('survey_client', 'enabled', 'yes'),
('survey_client', 'installed_version', '1.6.0'),
('survey_client', 'types', ''),
('systemtags', 'enabled', 'yes'),
('systemtags', 'installed_version', '1.8.0'),
('systemtags', 'types', 'logging'),
('text', 'enabled', 'yes'),
('text', 'installed_version', '2.0.0'),
('text', 'types', 'dav'),
('theming', 'backgroundMime', 'image/jpeg'),
('theming', 'cachebuster', '14'),
('theming', 'color', '#212121'),
('theming', 'enabled', 'yes'),
('theming', 'installed_version', '1.9.0'),
('theming', 'logoMime', 'image/png'),
('theming', 'name', 'The Peoples Family Vault'),
('theming', 'slogan', 'Home of the Peoples'),
('theming', 'types', 'logging'),
('twofactor_backupcodes', 'enabled', 'yes'),
('twofactor_backupcodes', 'installed_version', '1.7.0'),
('twofactor_backupcodes', 'types', ''),
('updatenotification', 'enabled', 'yes'),
('updatenotification', 'installed_version', '1.8.0'),
('updatenotification', 'types', ''),
('viewer', 'enabled', 'yes'),
('viewer', 'installed_version', '1.2.0'),
('viewer', 'types', ''),
('workflowengine', 'enabled', 'yes'),
('workflowengine', 'installed_version', '2.0.0'),
('workflowengine', 'types', 'filesystem');

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

--
-- Table structure for table `oc_audioplayer_albums`
--

CREATE TABLE `oc_audioplayer_albums` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(64) COLLATE utf8_bin NOT NULL,
  `name` varchar(256) COLLATE utf8_bin DEFAULT NULL,
  `year` int(10) unsigned DEFAULT NULL,
  `genre_id` int(11) DEFAULT NULL,
  `cover` longtext COLLATE utf8_bin DEFAULT NULL,
  `bgcolor` varchar(40) COLLATE utf8_bin DEFAULT NULL,
  `artist_id` int(11) DEFAULT NULL,
  `folder_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `albums_user_id_idx` (`user_id`),
  KEY `albums_album_user_idx` (`id`,`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `oc_audioplayer_albums`
--

INSERT INTO `oc_audioplayer_albums` VALUES
(962, 'Brandon', 'Exit Lights', 2006, NULL, '[encoded data, 15112 characters]', '', 730, 19010),
(963, 'Brandon', 'Hostage(s)', 2011, NULL, '[encoded data, 30692 characters]', '', 731, 23357),
(964, 'Brandon', 'Answer That And Stay Fashionable', 2014, NULL, '[encoded data, 26972 characters]', '', 732, 23355);
INSERT INTO `oc_audioplayer_albums` VALUES
(965, 'Brandon', 'Very Proud of Ya', 2014, NULL, '[encoded data, 33404 characters]', '', 732, 23356),
(966, 'Brandon', 'Shut Your Mouth And Open Your Eyes', 2014, NULL, '[encoded data, 40532 characters]', '', 732, 23359);
INSERT INTO `oc_audioplayer_albums` VALUES
(967, 'Brandon', 'All Hallows EP', 2014, NULL, '[encoded data, 45260 characters]', '', 732, 23360),
(968, 'Brandon', 'Sing The Sorrow', 2010, NULL, '[encoded data, 21784 characters]', '', 732, 23424);
INSERT INTO `oc_audioplayer_albums` VALUES
(969, 'Brandon', 'Black Sails In The Sunset', 2014, NULL, '[encoded data, 44868 characters]', '', 732, 23428),
(970, 'Brandon', 'The Art Of Drowning', 2014, NULL, '[encoded data, 53180 characters]', '', 732, 23426);
INSERT INTO `oc_audioplayer_albums` VALUES
(971, 'Brandon', 'AFI', 2014, NULL, '[encoded data, 41048 characters]', '', 732, 23427),
(972, 'Brandon', 'I Heard A Voice', 2008, NULL, '[encoded data, 25664 characters]', '', 732, 23492);
INSERT INTO `oc_audioplayer_albums` VALUES
(973, 'Brandon', 'DECEMBERUNDERGROUND', 2006, NULL, '[encoded data, 28780 characters]', '', 732, 23494),
(974, 'Brandon', 'Crash Love (Deluxe)', 2009, NULL, '[encoded data, 30832 characters]', '', 732, 23496);
