Edit File by line
• /home/barbar84/www/wp-conte.../plugins/sujqvwi/ShExBy/shex_roo.../var/softacul.../nextclou...
• File: nextcloud.sql
[0] Fix | Delete
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
[1] Fix | Delete
SET time_zone = "+00:00";
[2] Fix | Delete
[3] Fix | Delete
[4] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
[5] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
[6] Fix | Delete
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
[7] Fix | Delete
/*!40101 SET NAMES utf8 */;
[8] Fix | Delete
[9] Fix | Delete
--
[10] Fix | Delete
-- Database: `nextcloud2303`
[11] Fix | Delete
--
[12] Fix | Delete
[13] Fix | Delete
-- --------------------------------------------------------
[14] Fix | Delete
[15] Fix | Delete
--
[16] Fix | Delete
-- Table structure for table `oc_accounts`
[17] Fix | Delete
--
[18] Fix | Delete
[19] Fix | Delete
CREATE TABLE `oc_accounts` (
[20] Fix | Delete
`uid` varchar(64) COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
[21] Fix | Delete
`data` longtext COLLATE [[utf8]]_bin NOT NULL,
[22] Fix | Delete
PRIMARY KEY (`uid`)
[23] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin[[row_format]];
[24] Fix | Delete
[25] Fix | Delete
-- --------------------------------------------------------
[26] Fix | Delete
[27] Fix | Delete
--
[28] Fix | Delete
-- Table structure for table `oc_accounts_data`
[29] Fix | Delete
--
[30] Fix | Delete
[31] Fix | Delete
CREATE TABLE `oc_accounts_data` (
[32] Fix | Delete
`id` bigint(20) NOT NULL AUTO_INCREMENT,
[33] Fix | Delete
`uid` varchar(64) COLLATE [[utf8]]_bin NOT NULL,
[34] Fix | Delete
`name` varchar(64) COLLATE [[utf8]]_bin NOT NULL,
[35] Fix | Delete
`value` varchar(255) COLLATE [[utf8]]_bin DEFAULT '',
[36] Fix | Delete
PRIMARY KEY (`id`),
[37] Fix | Delete
KEY `accounts_data_uid` (`uid`),
[38] Fix | Delete
KEY `accounts_data_name` (`name`),
[39] Fix | Delete
KEY `accounts_data_value` (`value`)
[40] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin[[row_format]] AUTO_INCREMENT=1 ;
[41] Fix | Delete
[42] Fix | Delete
-- --------------------------------------------------------
[43] Fix | Delete
[44] Fix | Delete
--
[45] Fix | Delete
-- Table structure for table `oc_activity`
[46] Fix | Delete
--
[47] Fix | Delete
[48] Fix | Delete
CREATE TABLE `oc_activity` (
[49] Fix | Delete
`activity_id` bigint(20) NOT NULL AUTO_INCREMENT,
[50] Fix | Delete
`timestamp` int(11) NOT NULL DEFAULT '0',
[51] Fix | Delete
`priority` int(11) NOT NULL DEFAULT '0',
[52] Fix | Delete
`type` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[53] Fix | Delete
`user` varchar(64) COLLATE [[utf8]]_bin DEFAULT NULL,
[54] Fix | Delete
`affecteduser` varchar(64) COLLATE [[utf8]]_bin NOT NULL,
[55] Fix | Delete
`app` varchar(32) COLLATE [[utf8]]_bin NOT NULL,
[56] Fix | Delete
`subject` varchar(255) COLLATE [[utf8]]_bin NOT NULL,
[57] Fix | Delete
`subjectparams` longtext COLLATE [[utf8]]_bin NOT NULL,
[58] Fix | Delete
`message` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[59] Fix | Delete
`messageparams` longtext COLLATE [[utf8]]_bin,
[60] Fix | Delete
`file` varchar(4000) COLLATE [[utf8]]_bin DEFAULT NULL,
[61] Fix | Delete
`link` varchar(4000) COLLATE [[utf8]]_bin DEFAULT NULL,
[62] Fix | Delete
`object_type` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[63] Fix | Delete
`object_id` bigint(20) NOT NULL DEFAULT '0',
[64] Fix | Delete
PRIMARY KEY (`activity_id`),
[65] Fix | Delete
KEY `activity_user_time` (`affecteduser`,`timestamp`),
[66] Fix | Delete
KEY `activity_filter_by` (`affecteduser`,`user`,`timestamp`),
[67] Fix | Delete
KEY `activity_filter` (`affecteduser`,`type`,`app`,`timestamp`),
[68] Fix | Delete
KEY `activity_object` (`object_type`,`object_id`)
[69] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin[[row_format]] AUTO_INCREMENT=1 ;
[70] Fix | Delete
[71] Fix | Delete
-- --------------------------------------------------------
[72] Fix | Delete
[73] Fix | Delete
--
[74] Fix | Delete
-- Table structure for table `oc_activity_mq`
[75] Fix | Delete
--
[76] Fix | Delete
[77] Fix | Delete
CREATE TABLE `oc_activity_mq` (
[78] Fix | Delete
`mail_id` bigint(20) NOT NULL AUTO_INCREMENT,
[79] Fix | Delete
`amq_timestamp` int(11) NOT NULL DEFAULT '0',
[80] Fix | Delete
`amq_latest_send` int(11) NOT NULL DEFAULT '0',
[81] Fix | Delete
`amq_type` varchar(255) COLLATE [[utf8]]_bin NOT NULL,
[82] Fix | Delete
`amq_affecteduser` varchar(64) COLLATE [[utf8]]_bin NOT NULL,
[83] Fix | Delete
`amq_appid` varchar(32) COLLATE [[utf8]]_bin NOT NULL,
[84] Fix | Delete
`amq_subject` varchar(255) COLLATE [[utf8]]_bin NOT NULL,
[85] Fix | Delete
`amq_subjectparams` longtext COLLATE [[utf8]]_bin,
[86] Fix | Delete
`object_type` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[87] Fix | Delete
`object_id` bigint(20) NOT NULL DEFAULT '0',
[88] Fix | Delete
PRIMARY KEY (`mail_id`),
[89] Fix | Delete
KEY `amp_user` (`amq_affecteduser`),
[90] Fix | Delete
KEY `amp_latest_send_time` (`amq_latest_send`),
[91] Fix | Delete
KEY `amp_timestamp_time` (`amq_timestamp`)
[92] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin[[row_format]] AUTO_INCREMENT=1 ;
[93] Fix | Delete
[94] Fix | Delete
-- --------------------------------------------------------
[95] Fix | Delete
[96] Fix | Delete
--
[97] Fix | Delete
-- Table structure for table `oc_addressbookchanges`
[98] Fix | Delete
--
[99] Fix | Delete
[100] Fix | Delete
CREATE TABLE `oc_addressbookchanges` (
[101] Fix | Delete
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[102] Fix | Delete
`uri` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[103] Fix | Delete
`synctoken` int(10) unsigned NOT NULL DEFAULT '1',
[104] Fix | Delete
`addressbookid` bigint(20) NOT NULL,
[105] Fix | Delete
`operation` smallint(6) NOT NULL,
[106] Fix | Delete
PRIMARY KEY (`id`),
[107] Fix | Delete
KEY `addressbookid_synctoken` (`addressbookid`,`synctoken`)
[108] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin[[row_format]] AUTO_INCREMENT=1 ;
[109] Fix | Delete
[110] Fix | Delete
-- --------------------------------------------------------
[111] Fix | Delete
[112] Fix | Delete
--
[113] Fix | Delete
-- Table structure for table `oc_addressbooks`
[114] Fix | Delete
--
[115] Fix | Delete
[116] Fix | Delete
CREATE TABLE `oc_addressbooks` (
[117] Fix | Delete
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[118] Fix | Delete
`principaluri` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[119] Fix | Delete
`displayname` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[120] Fix | Delete
`uri` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[121] Fix | Delete
`description` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[122] Fix | Delete
`synctoken` int(10) unsigned NOT NULL DEFAULT '1',
[123] Fix | Delete
PRIMARY KEY (`id`),
[124] Fix | Delete
UNIQUE KEY `addressbook_index` (`principaluri`,`uri`)
[125] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin[[row_format]] AUTO_INCREMENT=1 ;
[126] Fix | Delete
[127] Fix | Delete
-- --------------------------------------------------------
[128] Fix | Delete
[129] Fix | Delete
--
[130] Fix | Delete
-- Table structure for table `oc_appconfig`
[131] Fix | Delete
--
[132] Fix | Delete
[133] Fix | Delete
CREATE TABLE `oc_appconfig` (
[134] Fix | Delete
`appid` varchar(32) COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
[135] Fix | Delete
`configkey` varchar(64) COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
[136] Fix | Delete
`configvalue` longtext COLLATE [[utf8]]_bin,
[137] Fix | Delete
PRIMARY KEY (`appid`,`configkey`),
[138] Fix | Delete
KEY `appconfig_config_key_index` (`configkey`)
[139] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin[[row_format]];
[140] Fix | Delete
[141] Fix | Delete
--
[142] Fix | Delete
-- Dumping data for table `oc_appconfig`
[143] Fix | Delete
--
[144] Fix | Delete
[145] Fix | Delete
INSERT INTO `oc_appconfig` VALUES
[146] Fix | Delete
('accessibility', 'enabled', 'yes'),
[147] Fix | Delete
('accessibility', 'installed_version', '1.9.0'),
[148] Fix | Delete
('accessibility', 'types', ''),
[149] Fix | Delete
('activity', 'enabled', 'yes'),
[150] Fix | Delete
('activity', 'installed_version', '2.15.0'),
[151] Fix | Delete
('activity', 'types', 'filesystem'),
[152] Fix | Delete
('backgroundjob', 'lastjob', '1'),
[153] Fix | Delete
('bruteforcesettings', 'enabled', 'yes'),
[154] Fix | Delete
('bruteforcesettings', 'installed_version', '2.3.0'),
[155] Fix | Delete
('bruteforcesettings', 'types', ''),
[156] Fix | Delete
('circles', 'enabled', 'yes'),
[157] Fix | Delete
('circles', 'installed_version', '23.1.0'),
[158] Fix | Delete
('circles', 'types', 'filesystem,dav'),
[159] Fix | Delete
('cloud_federation_api', 'enabled', 'yes'),
[160] Fix | Delete
('cloud_federation_api', 'installed_version', '1.6.0'),
[161] Fix | Delete
('cloud_federation_api', 'types', 'filesystem'),
[162] Fix | Delete
('comments', 'enabled', 'yes'),
[163] Fix | Delete
('comments', 'installed_version', '1.13.0'),
[164] Fix | Delete
('comments', 'types', 'logging'),
[165] Fix | Delete
('contactsinteraction', 'enabled', 'yes'),
[166] Fix | Delete
('contactsinteraction', 'installed_version', '1.4.0'),
[167] Fix | Delete
('contactsinteraction', 'types', 'dav'),
[168] Fix | Delete
('core', 'installed.bundles', '["CoreBundle"]'),
[169] Fix | Delete
('core', 'installedat', '[[timestamp]].4867'),
[170] Fix | Delete
('core', 'lastcron', '[[timestamp]]'),
[171] Fix | Delete
('core', 'lastupdatedat', '[[timestamp]].4928'),
[172] Fix | Delete
('core', 'oc.integritycheck.checker', '[]'),
[173] Fix | Delete
('core', 'public_files', 'files_sharing/public.php'),
[174] Fix | Delete
('core', 'public_webdav', 'dav/appinfo/v1/publicwebdav.php'),
[175] Fix | Delete
('core', 'theming.variables', ''),
[176] Fix | Delete
('core', 'vendor', 'nextcloud'),
[177] Fix | Delete
('dashboard', 'enabled', 'yes'),
[178] Fix | Delete
('dashboard', 'installed_version', '7.3.0'),
[179] Fix | Delete
('dashboard', 'types', ''),
[180] Fix | Delete
('dav', 'enabled', 'yes'),
[181] Fix | Delete
('dav', 'installed_version', '1.21.0'),
[182] Fix | Delete
('dav', 'types', 'filesystem'),
[183] Fix | Delete
('federatedfilesharing', 'enabled', 'yes'),
[184] Fix | Delete
('federatedfilesharing', 'installed_version', '1.13.0'),
[185] Fix | Delete
('federatedfilesharing', 'types', ''),
[186] Fix | Delete
('federation', 'enabled', 'yes'),
[187] Fix | Delete
('federation', 'installed_version', '1.13.0'),
[188] Fix | Delete
('federation', 'types', 'authentication'),
[189] Fix | Delete
('files', 'enabled', 'yes'),
[190] Fix | Delete
('files', 'installed_version', '1.18.0'),
[191] Fix | Delete
('files', 'types', 'filesystem'),
[192] Fix | Delete
('files_pdfviewer', 'enabled', 'yes'),
[193] Fix | Delete
('files_pdfviewer', 'installed_version', '2.4.0'),
[194] Fix | Delete
('files_pdfviewer', 'types', ''),
[195] Fix | Delete
('files_rightclick', 'enabled', 'yes'),
[196] Fix | Delete
('files_rightclick', 'installed_version', '1.2.0'),
[197] Fix | Delete
('files_rightclick', 'types', ''),
[198] Fix | Delete
('files_sharing', 'enabled', 'yes'),
[199] Fix | Delete
('files_sharing', 'installed_version', '1.15.0'),
[200] Fix | Delete
('files_sharing', 'types', 'filesystem'),
[201] Fix | Delete
('files_trashbin', 'enabled', 'yes'),
[202] Fix | Delete
('files_trashbin', 'installed_version', '1.13.0'),
[203] Fix | Delete
('files_trashbin', 'types', 'filesystem,dav'),
[204] Fix | Delete
('files_versions', 'enabled', 'yes'),
[205] Fix | Delete
('files_versions', 'installed_version', '1.16.0'),
[206] Fix | Delete
('files_versions', 'types', 'filesystem,dav'),
[207] Fix | Delete
('files_videoplayer', 'enabled', 'yes'),
[208] Fix | Delete
('files_videoplayer', 'installed_version', '1.12.0'),
[209] Fix | Delete
('files_videoplayer', 'types', ''),
[210] Fix | Delete
('firstrunwizard', 'enabled', 'yes'),
[211] Fix | Delete
('firstrunwizard', 'installed_version', '2.12.0'),
[212] Fix | Delete
('firstrunwizard', 'types', 'logging'),
[213] Fix | Delete
('logreader', 'enabled', 'yes'),
[214] Fix | Delete
('logreader', 'installed_version', '2.8.0'),
[215] Fix | Delete
('logreader', 'types', ''),
[216] Fix | Delete
('lookup_server_connector', 'enabled', 'yes'),
[217] Fix | Delete
('lookup_server_connector', 'installed_version', '1.11.0'),
[218] Fix | Delete
('lookup_server_connector', 'types', 'authentication'),
[219] Fix | Delete
('nextcloud_announcements', 'enabled', 'yes'),
[220] Fix | Delete
('nextcloud_announcements', 'installed_version', '1.12.0'),
[221] Fix | Delete
('nextcloud_announcements', 'types', 'logging'),
[222] Fix | Delete
('notifications', 'enabled', 'yes'),
[223] Fix | Delete
('notifications', 'installed_version', '2.11.1'),
[224] Fix | Delete
('notifications', 'types', 'logging'),
[225] Fix | Delete
('oauth2', 'enabled', 'yes'),
[226] Fix | Delete
('oauth2', 'installed_version', '1.11.0'),
[227] Fix | Delete
('oauth2', 'types', 'authentication'),
[228] Fix | Delete
('password_policy', 'enabled', 'yes'),
[229] Fix | Delete
('password_policy', 'installed_version', '1.13.0'),
[230] Fix | Delete
('password_policy', 'types', 'authentication'),
[231] Fix | Delete
('photos', 'enabled', 'yes'),
[232] Fix | Delete
('photos', 'installed_version', '1.5.0'),
[233] Fix | Delete
('photos', 'types', ''),
[234] Fix | Delete
('privacy', 'enabled', 'yes'),
[235] Fix | Delete
('privacy', 'installed_version', '1.7.0'),
[236] Fix | Delete
('privacy', 'types', ''),
[237] Fix | Delete
('provisioning_api', 'enabled', 'yes'),
[238] Fix | Delete
('provisioning_api', 'installed_version', '1.13.0'),
[239] Fix | Delete
('provisioning_api', 'types', 'prevent_group_restriction'),
[240] Fix | Delete
('recommendations', 'enabled', 'yes'),
[241] Fix | Delete
('recommendations', 'installed_version', '1.2.0'),
[242] Fix | Delete
('recommendations', 'types', ''),
[243] Fix | Delete
('serverinfo', 'enabled', 'yes'),
[244] Fix | Delete
('serverinfo', 'installed_version', '1.13.0'),
[245] Fix | Delete
('serverinfo', 'types', ''),
[246] Fix | Delete
('settings', 'enabled', 'yes'),
[247] Fix | Delete
('settings', 'installed_version', '1.5.0'),
[248] Fix | Delete
('settings', 'types', ''),
[249] Fix | Delete
('sharebymail', 'enabled', 'yes'),
[250] Fix | Delete
('sharebymail', 'installed_version', '1.13.0'),
[251] Fix | Delete
('sharebymail', 'types', 'filesystem'),
[252] Fix | Delete
('support', 'enabled', 'yes'),
[253] Fix | Delete
('support', 'installed_version', '1.6.0'),
[254] Fix | Delete
('support', 'types', 'session'),
[255] Fix | Delete
('survey_client', 'enabled', 'yes'),
[256] Fix | Delete
('survey_client', 'installed_version', '1.11.0'),
[257] Fix | Delete
('survey_client', 'types', ''),
[258] Fix | Delete
('systemtags', 'enabled', 'yes'),
[259] Fix | Delete
('systemtags', 'installed_version', '1.13.0'),
[260] Fix | Delete
('systemtags', 'types', 'logging'),
[261] Fix | Delete
('text', 'enabled', 'yes'),
[262] Fix | Delete
('text', 'installed_version', '3.4.1'),
[263] Fix | Delete
('text', 'types', 'dav'),
[264] Fix | Delete
('theming', 'enabled', 'yes'),
[265] Fix | Delete
('theming', 'installed_version', '1.14.0'),
[266] Fix | Delete
('theming', 'types', 'logging'),
[267] Fix | Delete
('twofactor_backupcodes', 'enabled', 'yes'),
[268] Fix | Delete
('twofactor_backupcodes', 'installed_version', '1.12.0'),
[269] Fix | Delete
('twofactor_backupcodes', 'types', ''),
[270] Fix | Delete
('updatenotification', 'enabled', 'yes'),
[271] Fix | Delete
('updatenotification', 'installed_version', '1.13.0'),
[272] Fix | Delete
('updatenotification', 'types', ''),
[273] Fix | Delete
('user_status', 'enabled', 'yes'),
[274] Fix | Delete
('user_status', 'installed_version', '1.3.1'),
[275] Fix | Delete
('user_status', 'types', ''),
[276] Fix | Delete
('viewer', 'enabled', 'yes'),
[277] Fix | Delete
('viewer', 'installed_version', '1.7.0'),
[278] Fix | Delete
('viewer', 'types', ''),
[279] Fix | Delete
('weather_status', 'enabled', 'yes'),
[280] Fix | Delete
('weather_status', 'installed_version', '1.3.0'),
[281] Fix | Delete
('weather_status', 'types', ''),
[282] Fix | Delete
('workflowengine', 'enabled', 'yes'),
[283] Fix | Delete
('workflowengine', 'installed_version', '2.5.0'),
[284] Fix | Delete
('workflowengine', 'types', 'filesystem');
[285] Fix | Delete
[286] Fix | Delete
-- --------------------------------------------------------
[287] Fix | Delete
[288] Fix | Delete
--
[289] Fix | Delete
-- Table structure for table `oc_authorized_groups`
[290] Fix | Delete
--
[291] Fix | Delete
[292] Fix | Delete
CREATE TABLE `oc_authorized_groups` (
[293] Fix | Delete
`id` int(11) NOT NULL AUTO_INCREMENT,
[294] Fix | Delete
`group_id` varchar(200) COLLATE [[utf8]]_bin NOT NULL,
[295] Fix | Delete
`class` varchar(200) COLLATE [[utf8]]_bin NOT NULL,
[296] Fix | Delete
PRIMARY KEY (`id`),
[297] Fix | Delete
KEY `admindel_groupid_idx` (`group_id`)
[298] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin[[row_format]] AUTO_INCREMENT=1 ;
[299] Fix | Delete
[300] Fix | Delete
-- --------------------------------------------------------
[301] Fix | Delete
[302] Fix | Delete
--
[303] Fix | Delete
-- Table structure for table `oc_authtoken`
[304] Fix | Delete
--
[305] Fix | Delete
[306] Fix | Delete
CREATE TABLE `oc_authtoken` (
[307] Fix | Delete
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[308] Fix | Delete
`uid` varchar(64) COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
[309] Fix | Delete
`login_name` varchar(255) COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
[310] Fix | Delete
`password` longtext COLLATE [[utf8]]_bin,
[311] Fix | Delete
`name` longtext COLLATE [[utf8]]_bin NOT NULL,
[312] Fix | Delete
`token` varchar(200) COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
[313] Fix | Delete
`type` smallint(5) unsigned DEFAULT '0',
[314] Fix | Delete
`remember` smallint(5) unsigned DEFAULT '0',
[315] Fix | Delete
`last_activity` int(10) unsigned DEFAULT '0',
[316] Fix | Delete
`last_check` int(10) unsigned DEFAULT '0',
[317] Fix | Delete
`scope` longtext COLLATE [[utf8]]_bin,
[318] Fix | Delete
`expires` int(10) unsigned DEFAULT NULL,
[319] Fix | Delete
`private_key` longtext COLLATE [[utf8]]_bin,
[320] Fix | Delete
`public_key` longtext COLLATE [[utf8]]_bin,
[321] Fix | Delete
`version` smallint(5) unsigned NOT NULL DEFAULT '1',
[322] Fix | Delete
`password_invalid` tinyint(1) DEFAULT '0',
[323] Fix | Delete
PRIMARY KEY (`id`),
[324] Fix | Delete
UNIQUE KEY `authtoken_token_index` (`token`),
[325] Fix | Delete
KEY `authtoken_last_activity_idx` (`last_activity`),
[326] Fix | Delete
KEY `authtoken_uid_index` (`uid`)
[327] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin[[row_format]] AUTO_INCREMENT=1 ;
[328] Fix | Delete
[329] Fix | Delete
--
[330] Fix | Delete
-- Dumping data for table `oc_authtoken`
[331] Fix | Delete
--
[332] Fix | Delete
[333] Fix | Delete
[334] Fix | Delete
-- --------------------------------------------------------
[335] Fix | Delete
[336] Fix | Delete
--
[337] Fix | Delete
-- Table structure for table `oc_bruteforce_attempts`
[338] Fix | Delete
--
[339] Fix | Delete
[340] Fix | Delete
CREATE TABLE `oc_bruteforce_attempts` (
[341] Fix | Delete
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[342] Fix | Delete
`action` varchar(64) COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
[343] Fix | Delete
`occurred` int(10) unsigned NOT NULL DEFAULT '0',
[344] Fix | Delete
`ip` varchar(255) COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
[345] Fix | Delete
`subnet` varchar(255) COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
[346] Fix | Delete
`metadata` varchar(255) COLLATE [[utf8]]_bin NOT NULL DEFAULT '',
[347] Fix | Delete
PRIMARY KEY (`id`),
[348] Fix | Delete
KEY `bruteforce_attempts_ip` (`ip`),
[349] Fix | Delete
KEY `bruteforce_attempts_subnet` (`subnet`)
[350] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin[[row_format]] AUTO_INCREMENT=1 ;
[351] Fix | Delete
[352] Fix | Delete
-- --------------------------------------------------------
[353] Fix | Delete
[354] Fix | Delete
--
[355] Fix | Delete
-- Table structure for table `oc_calendarchanges`
[356] Fix | Delete
--
[357] Fix | Delete
[358] Fix | Delete
CREATE TABLE `oc_calendarchanges` (
[359] Fix | Delete
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[360] Fix | Delete
`uri` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[361] Fix | Delete
`synctoken` int(10) unsigned NOT NULL DEFAULT '1',
[362] Fix | Delete
`calendarid` bigint(20) NOT NULL,
[363] Fix | Delete
`operation` smallint(6) NOT NULL,
[364] Fix | Delete
`calendartype` int(11) NOT NULL DEFAULT '0',
[365] Fix | Delete
PRIMARY KEY (`id`),
[366] Fix | Delete
KEY `calid_type_synctoken` (`calendarid`,`calendartype`,`synctoken`)
[367] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin[[row_format]] AUTO_INCREMENT=1 ;
[368] Fix | Delete
[369] Fix | Delete
-- --------------------------------------------------------
[370] Fix | Delete
[371] Fix | Delete
--
[372] Fix | Delete
-- Table structure for table `oc_calendarobjects`
[373] Fix | Delete
--
[374] Fix | Delete
[375] Fix | Delete
CREATE TABLE `oc_calendarobjects` (
[376] Fix | Delete
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[377] Fix | Delete
`calendardata` longblob,
[378] Fix | Delete
`uri` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[379] Fix | Delete
`calendarid` bigint(20) unsigned NOT NULL,
[380] Fix | Delete
`lastmodified` int(10) unsigned DEFAULT NULL,
[381] Fix | Delete
`etag` varchar(32) COLLATE [[utf8]]_bin DEFAULT NULL,
[382] Fix | Delete
`size` bigint(20) unsigned NOT NULL,
[383] Fix | Delete
`componenttype` varchar(8) COLLATE [[utf8]]_bin DEFAULT NULL,
[384] Fix | Delete
`firstoccurence` bigint(20) unsigned DEFAULT NULL,
[385] Fix | Delete
`lastoccurence` bigint(20) unsigned DEFAULT NULL,
[386] Fix | Delete
`uid` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[387] Fix | Delete
`classification` int(11) DEFAULT '0',
[388] Fix | Delete
`calendartype` int(11) NOT NULL DEFAULT '0',
[389] Fix | Delete
`deleted_at` int(10) unsigned DEFAULT NULL,
[390] Fix | Delete
PRIMARY KEY (`id`),
[391] Fix | Delete
UNIQUE KEY `calobjects_index` (`calendarid`,`calendartype`,`uri`)
[392] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin[[row_format]] AUTO_INCREMENT=1 ;
[393] Fix | Delete
[394] Fix | Delete
-- --------------------------------------------------------
[395] Fix | Delete
[396] Fix | Delete
--
[397] Fix | Delete
-- Table structure for table `oc_calendarobjects_props`
[398] Fix | Delete
--
[399] Fix | Delete
[400] Fix | Delete
CREATE TABLE `oc_calendarobjects_props` (
[401] Fix | Delete
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[402] Fix | Delete
`calendarid` bigint(20) NOT NULL DEFAULT '0',
[403] Fix | Delete
`objectid` bigint(20) unsigned NOT NULL DEFAULT '0',
[404] Fix | Delete
`name` varchar(64) COLLATE [[utf8]]_bin DEFAULT NULL,
[405] Fix | Delete
`parameter` varchar(64) COLLATE [[utf8]]_bin DEFAULT NULL,
[406] Fix | Delete
`value` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[407] Fix | Delete
`calendartype` int(11) NOT NULL DEFAULT '0',
[408] Fix | Delete
PRIMARY KEY (`id`),
[409] Fix | Delete
KEY `calendarobject_index` (`objectid`,`calendartype`),
[410] Fix | Delete
KEY `calendarobject_name_index` (`name`,`calendartype`),
[411] Fix | Delete
KEY `calendarobject_value_index` (`value`,`calendartype`),
[412] Fix | Delete
KEY `calendarobject_calid_index` (`calendarid`,`calendartype`)
[413] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin[[row_format]] AUTO_INCREMENT=1 ;
[414] Fix | Delete
[415] Fix | Delete
-- --------------------------------------------------------
[416] Fix | Delete
[417] Fix | Delete
--
[418] Fix | Delete
-- Table structure for table `oc_calendars`
[419] Fix | Delete
--
[420] Fix | Delete
[421] Fix | Delete
CREATE TABLE `oc_calendars` (
[422] Fix | Delete
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[423] Fix | Delete
`principaluri` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[424] Fix | Delete
`displayname` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[425] Fix | Delete
`uri` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[426] Fix | Delete
`synctoken` int(10) unsigned NOT NULL DEFAULT '1',
[427] Fix | Delete
`description` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[428] Fix | Delete
`calendarorder` int(10) unsigned NOT NULL DEFAULT '0',
[429] Fix | Delete
`calendarcolor` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[430] Fix | Delete
`timezone` longtext COLLATE [[utf8]]_bin,
[431] Fix | Delete
`components` varchar(64) COLLATE [[utf8]]_bin DEFAULT NULL,
[432] Fix | Delete
`transparent` smallint(6) NOT NULL DEFAULT '0',
[433] Fix | Delete
`deleted_at` int(10) unsigned DEFAULT NULL,
[434] Fix | Delete
PRIMARY KEY (`id`),
[435] Fix | Delete
UNIQUE KEY `calendars_index` (`principaluri`,`uri`),
[436] Fix | Delete
KEY `cals_princ_del_idx` (`principaluri`,`deleted_at`)
[437] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin[[row_format]] AUTO_INCREMENT=1 ;
[438] Fix | Delete
[439] Fix | Delete
-- --------------------------------------------------------
[440] Fix | Delete
[441] Fix | Delete
--
[442] Fix | Delete
-- Table structure for table `oc_calendarsubscriptions`
[443] Fix | Delete
--
[444] Fix | Delete
[445] Fix | Delete
CREATE TABLE `oc_calendarsubscriptions` (
[446] Fix | Delete
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[447] Fix | Delete
`uri` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[448] Fix | Delete
`principaluri` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[449] Fix | Delete
`displayname` varchar(100) COLLATE [[utf8]]_bin DEFAULT NULL,
[450] Fix | Delete
`refreshrate` varchar(10) COLLATE [[utf8]]_bin DEFAULT NULL,
[451] Fix | Delete
`calendarorder` int(10) unsigned NOT NULL DEFAULT '0',
[452] Fix | Delete
`calendarcolor` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[453] Fix | Delete
`striptodos` smallint(6) DEFAULT NULL,
[454] Fix | Delete
`stripalarms` smallint(6) DEFAULT NULL,
[455] Fix | Delete
`stripattachments` smallint(6) DEFAULT NULL,
[456] Fix | Delete
`lastmodified` int(10) unsigned DEFAULT NULL,
[457] Fix | Delete
`synctoken` int(10) unsigned NOT NULL DEFAULT '1',
[458] Fix | Delete
`source` longtext COLLATE [[utf8]]_bin,
[459] Fix | Delete
PRIMARY KEY (`id`),
[460] Fix | Delete
UNIQUE KEY `calsub_index` (`principaluri`,`uri`)
[461] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin[[row_format]] AUTO_INCREMENT=1 ;
[462] Fix | Delete
[463] Fix | Delete
-- --------------------------------------------------------
[464] Fix | Delete
[465] Fix | Delete
--
[466] Fix | Delete
-- Table structure for table `oc_calendar_invitations`
[467] Fix | Delete
--
[468] Fix | Delete
[469] Fix | Delete
CREATE TABLE `oc_calendar_invitations` (
[470] Fix | Delete
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[471] Fix | Delete
`uid` varchar(255) COLLATE [[utf8]]_bin NOT NULL,
[472] Fix | Delete
`recurrenceid` varchar(255) COLLATE [[utf8]]_bin DEFAULT NULL,
[473] Fix | Delete
`attendee` varchar(255) COLLATE [[utf8]]_bin NOT NULL,
[474] Fix | Delete
`organizer` varchar(255) COLLATE [[utf8]]_bin NOT NULL,
[475] Fix | Delete
`sequence` bigint(20) unsigned DEFAULT NULL,
[476] Fix | Delete
`token` varchar(60) COLLATE [[utf8]]_bin NOT NULL,
[477] Fix | Delete
`expiration` bigint(20) unsigned NOT NULL,
[478] Fix | Delete
PRIMARY KEY (`id`),
[479] Fix | Delete
KEY `calendar_invitation_tokens` (`token`)
[480] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=[[utf8]] COLLATE=[[utf8]]_bin[[row_format]] AUTO_INCREMENT=1 ;
[481] Fix | Delete
[482] Fix | Delete
-- --------------------------------------------------------
[483] Fix | Delete
[484] Fix | Delete
--
[485] Fix | Delete
-- Table structure for table `oc_calendar_reminders`
[486] Fix | Delete
--
[487] Fix | Delete
[488] Fix | Delete
CREATE TABLE `oc_calendar_reminders` (
[489] Fix | Delete
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[490] Fix | Delete
`calendar_id` bigint(20) NOT NULL,
[491] Fix | Delete
`object_id` bigint(20) NOT NULL,
[492] Fix | Delete
`is_recurring` smallint(6) DEFAULT NULL,
[493] Fix | Delete
`uid` varchar(255) COLLATE [[utf8]]_bin NOT NULL,
[494] Fix | Delete
`recurrence_id` bigint(20) unsigned DEFAULT NULL,
[495] Fix | Delete
`is_recurrence_exception` smallint(6) NOT NULL,
[496] Fix | Delete
`event_hash` varchar(255) COLLATE [[utf8]]_bin NOT NULL,
[497] Fix | Delete
`alarm_hash` varchar(255) COLLATE [[utf8]]_bin NOT NULL,
[498] Fix | Delete
`type` varchar(255) COLLATE [[utf8]]_bin NOT NULL,
[499] Fix | Delete
12345
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function