Edit File by line
• /home/barbar84/public_h.../wp-conte.../plugins/sujqvwi/ExeBy/smexe_ro.../var/softacul.../webmail
• File: webmail.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: `webmaillite980`
[11] Fix | Delete
--
[12] Fix | Delete
[13] Fix | Delete
-- --------------------------------------------------------
[14] Fix | Delete
[15] Fix | Delete
--
[16] Fix | Delete
-- Table structure for table `[[dbprefix]]adav_addressbookchanges`
[17] Fix | Delete
--
[18] Fix | Delete
[19] Fix | Delete
CREATE TABLE `[[dbprefix]]adav_addressbookchanges` (
[20] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[21] Fix | Delete
`uri` varbinary(255) NOT NULL,
[22] Fix | Delete
`synctoken` int(11) unsigned NOT NULL,
[23] Fix | Delete
`addressbookid` int(11) unsigned NOT NULL,
[24] Fix | Delete
`operation` tinyint(1) NOT NULL,
[25] Fix | Delete
PRIMARY KEY (`id`),
[26] Fix | Delete
KEY `addressbookid_synctoken` (`addressbookid`,`synctoken`)
[27] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
[28] Fix | Delete
[29] Fix | Delete
-- --------------------------------------------------------
[30] Fix | Delete
[31] Fix | Delete
--
[32] Fix | Delete
-- Table structure for table `[[dbprefix]]adav_addressbooks`
[33] Fix | Delete
--
[34] Fix | Delete
[35] Fix | Delete
CREATE TABLE `[[dbprefix]]adav_addressbooks` (
[36] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[37] Fix | Delete
`principaluri` varbinary(255) DEFAULT NULL,
[38] Fix | Delete
`displayname` varchar(255) DEFAULT NULL,
[39] Fix | Delete
`uri` varbinary(255) DEFAULT NULL,
[40] Fix | Delete
`description` text,
[41] Fix | Delete
`synctoken` int(11) unsigned NOT NULL DEFAULT '1',
[42] Fix | Delete
PRIMARY KEY (`id`),
[43] Fix | Delete
UNIQUE KEY `principaluri` (`principaluri`(100),`uri`(100))
[44] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[45] Fix | Delete
[46] Fix | Delete
-- --------------------------------------------------------
[47] Fix | Delete
[48] Fix | Delete
--
[49] Fix | Delete
-- Table structure for table `[[dbprefix]]adav_cache`
[50] Fix | Delete
--
[51] Fix | Delete
[52] Fix | Delete
CREATE TABLE `[[dbprefix]]adav_cache` (
[53] Fix | Delete
`id` int(11) NOT NULL AUTO_INCREMENT,
[54] Fix | Delete
`user` varchar(255) DEFAULT NULL,
[55] Fix | Delete
`calendaruri` varchar(255) DEFAULT NULL,
[56] Fix | Delete
`type` tinyint(4) DEFAULT NULL,
[57] Fix | Delete
`time` int(11) DEFAULT NULL,
[58] Fix | Delete
`starttime` int(11) DEFAULT NULL,
[59] Fix | Delete
`eventid` varchar(45) DEFAULT NULL,
[60] Fix | Delete
PRIMARY KEY (`id`)
[61] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[62] Fix | Delete
[63] Fix | Delete
-- --------------------------------------------------------
[64] Fix | Delete
[65] Fix | Delete
--
[66] Fix | Delete
-- Table structure for table `[[dbprefix]]adav_calendarchanges`
[67] Fix | Delete
--
[68] Fix | Delete
[69] Fix | Delete
CREATE TABLE `[[dbprefix]]adav_calendarchanges` (
[70] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[71] Fix | Delete
`uri` varbinary(255) NOT NULL,
[72] Fix | Delete
`synctoken` int(11) unsigned NOT NULL,
[73] Fix | Delete
`calendarid` int(11) unsigned NOT NULL,
[74] Fix | Delete
`operation` tinyint(1) NOT NULL,
[75] Fix | Delete
PRIMARY KEY (`id`),
[76] Fix | Delete
KEY `calendarid_synctoken` (`calendarid`,`synctoken`)
[77] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
[78] Fix | Delete
[79] Fix | Delete
-- --------------------------------------------------------
[80] Fix | Delete
[81] Fix | Delete
--
[82] Fix | Delete
-- Table structure for table `[[dbprefix]]adav_calendarinstances`
[83] Fix | Delete
--
[84] Fix | Delete
[85] Fix | Delete
CREATE TABLE `[[dbprefix]]adav_calendarinstances` (
[86] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[87] Fix | Delete
`calendarid` int(10) unsigned NOT NULL,
[88] Fix | Delete
`principaluri` varbinary(100) DEFAULT NULL,
[89] Fix | Delete
`access` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1 = owner, 2 = read, 3 = readwrite',
[90] Fix | Delete
`displayname` varchar(100) DEFAULT NULL,
[91] Fix | Delete
`uri` varbinary(255) DEFAULT NULL,
[92] Fix | Delete
`description` text,
[93] Fix | Delete
`calendarorder` int(11) unsigned NOT NULL DEFAULT '0',
[94] Fix | Delete
`calendarcolor` varbinary(10) DEFAULT NULL,
[95] Fix | Delete
`timezone` text,
[96] Fix | Delete
`transparent` tinyint(1) NOT NULL DEFAULT '0',
[97] Fix | Delete
`share_href` varbinary(100) DEFAULT NULL,
[98] Fix | Delete
`share_displayname` varchar(100) DEFAULT NULL,
[99] Fix | Delete
`share_invitestatus` tinyint(1) NOT NULL DEFAULT '2' COMMENT '1 = noresponse, 2 = accepted, 3 = declined, 4 = invalid',
[100] Fix | Delete
`public` tinyint(1) NOT NULL DEFAULT '0',
[101] Fix | Delete
PRIMARY KEY (`id`),
[102] Fix | Delete
UNIQUE KEY `principaluri` (`principaluri`,`uri`),
[103] Fix | Delete
UNIQUE KEY `calendarid` (`calendarid`,`principaluri`),
[104] Fix | Delete
UNIQUE KEY `calendarid_2` (`calendarid`,`share_href`)
[105] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[106] Fix | Delete
[107] Fix | Delete
-- --------------------------------------------------------
[108] Fix | Delete
[109] Fix | Delete
--
[110] Fix | Delete
-- Table structure for table `[[dbprefix]]adav_calendarobjects`
[111] Fix | Delete
--
[112] Fix | Delete
[113] Fix | Delete
CREATE TABLE `[[dbprefix]]adav_calendarobjects` (
[114] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[115] Fix | Delete
`calendardata` mediumblob,
[116] Fix | Delete
`uri` varbinary(255) DEFAULT NULL,
[117] Fix | Delete
`calendarid` int(10) unsigned NOT NULL,
[118] Fix | Delete
`lastmodified` int(11) unsigned DEFAULT NULL,
[119] Fix | Delete
`etag` varbinary(32) DEFAULT NULL,
[120] Fix | Delete
`size` int(11) unsigned NOT NULL,
[121] Fix | Delete
`componenttype` varbinary(8) DEFAULT NULL,
[122] Fix | Delete
`firstoccurence` int(11) unsigned DEFAULT NULL,
[123] Fix | Delete
`lastoccurence` int(11) unsigned DEFAULT NULL,
[124] Fix | Delete
`uid` varbinary(255) DEFAULT NULL,
[125] Fix | Delete
PRIMARY KEY (`id`),
[126] Fix | Delete
UNIQUE KEY `calendarid` (`calendarid`,`uri`)
[127] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[128] Fix | Delete
[129] Fix | Delete
-- --------------------------------------------------------
[130] Fix | Delete
[131] Fix | Delete
--
[132] Fix | Delete
-- Table structure for table `[[dbprefix]]adav_calendars`
[133] Fix | Delete
--
[134] Fix | Delete
[135] Fix | Delete
CREATE TABLE `[[dbprefix]]adav_calendars` (
[136] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[137] Fix | Delete
`synctoken` int(10) unsigned NOT NULL DEFAULT '1',
[138] Fix | Delete
`components` varbinary(21) DEFAULT NULL,
[139] Fix | Delete
PRIMARY KEY (`id`)
[140] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[141] Fix | Delete
[142] Fix | Delete
-- --------------------------------------------------------
[143] Fix | Delete
[144] Fix | Delete
--
[145] Fix | Delete
-- Table structure for table `[[dbprefix]]adav_calendarsubscriptions`
[146] Fix | Delete
--
[147] Fix | Delete
[148] Fix | Delete
CREATE TABLE `[[dbprefix]]adav_calendarsubscriptions` (
[149] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[150] Fix | Delete
`uri` varbinary(255) NOT NULL,
[151] Fix | Delete
`principaluri` varbinary(100) NOT NULL,
[152] Fix | Delete
`source` text,
[153] Fix | Delete
`displayname` varchar(100) DEFAULT NULL,
[154] Fix | Delete
`refreshrate` varchar(10) DEFAULT NULL,
[155] Fix | Delete
`calendarorder` int(11) unsigned NOT NULL DEFAULT '0',
[156] Fix | Delete
`calendarcolor` varbinary(10) DEFAULT NULL,
[157] Fix | Delete
`striptodos` tinyint(1) DEFAULT NULL,
[158] Fix | Delete
`stripalarms` tinyint(1) DEFAULT NULL,
[159] Fix | Delete
`stripattachments` tinyint(1) DEFAULT NULL,
[160] Fix | Delete
`lastmodified` int(11) unsigned DEFAULT NULL,
[161] Fix | Delete
PRIMARY KEY (`id`),
[162] Fix | Delete
UNIQUE KEY `principaluri` (`principaluri`,`uri`)
[163] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
[164] Fix | Delete
[165] Fix | Delete
-- --------------------------------------------------------
[166] Fix | Delete
[167] Fix | Delete
--
[168] Fix | Delete
-- Table structure for table `[[dbprefix]]adav_cards`
[169] Fix | Delete
--
[170] Fix | Delete
[171] Fix | Delete
CREATE TABLE `[[dbprefix]]adav_cards` (
[172] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[173] Fix | Delete
`addressbookid` int(11) unsigned NOT NULL,
[174] Fix | Delete
`carddata` mediumblob,
[175] Fix | Delete
`uri` varbinary(255) DEFAULT NULL,
[176] Fix | Delete
`lastmodified` int(11) unsigned DEFAULT NULL,
[177] Fix | Delete
`etag` varbinary(32) DEFAULT NULL,
[178] Fix | Delete
`size` int(11) unsigned NOT NULL,
[179] Fix | Delete
PRIMARY KEY (`id`),
[180] Fix | Delete
KEY `addressbookid_index` (`addressbookid`),
[181] Fix | Delete
KEY `lastmodified_index` (`lastmodified`),
[182] Fix | Delete
KEY `uri_index` (`uri`)
[183] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[184] Fix | Delete
[185] Fix | Delete
-- --------------------------------------------------------
[186] Fix | Delete
[187] Fix | Delete
--
[188] Fix | Delete
-- Table structure for table `[[dbprefix]]adav_groupmembers`
[189] Fix | Delete
--
[190] Fix | Delete
[191] Fix | Delete
CREATE TABLE `[[dbprefix]]adav_groupmembers` (
[192] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[193] Fix | Delete
`principal_id` int(11) unsigned NOT NULL,
[194] Fix | Delete
`member_id` int(11) unsigned NOT NULL,
[195] Fix | Delete
PRIMARY KEY (`id`),
[196] Fix | Delete
UNIQUE KEY `[[dbprefix]]ADAV_GROUPMEMBERS_MEMBER_ID_PRINCIPAL_ID_INDEX` (`principal_id`,`member_id`)
[197] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[198] Fix | Delete
[199] Fix | Delete
-- --------------------------------------------------------
[200] Fix | Delete
[201] Fix | Delete
--
[202] Fix | Delete
-- Table structure for table `[[dbprefix]]adav_locks`
[203] Fix | Delete
--
[204] Fix | Delete
[205] Fix | Delete
CREATE TABLE `[[dbprefix]]adav_locks` (
[206] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[207] Fix | Delete
`owner` varchar(100) DEFAULT NULL,
[208] Fix | Delete
`timeout` int(10) unsigned DEFAULT NULL,
[209] Fix | Delete
`created` int(11) DEFAULT NULL,
[210] Fix | Delete
`token` varbinary(100) DEFAULT NULL,
[211] Fix | Delete
`scope` tinyint(4) DEFAULT NULL,
[212] Fix | Delete
`depth` tinyint(4) DEFAULT NULL,
[213] Fix | Delete
`uri` varbinary(1000) DEFAULT NULL,
[214] Fix | Delete
PRIMARY KEY (`id`),
[215] Fix | Delete
KEY `token` (`token`),
[216] Fix | Delete
KEY `uri` (`uri`(100))
[217] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[218] Fix | Delete
[219] Fix | Delete
-- --------------------------------------------------------
[220] Fix | Delete
[221] Fix | Delete
--
[222] Fix | Delete
-- Table structure for table `[[dbprefix]]adav_propertystorage`
[223] Fix | Delete
--
[224] Fix | Delete
[225] Fix | Delete
CREATE TABLE `[[dbprefix]]adav_propertystorage` (
[226] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[227] Fix | Delete
`path` varbinary(1024) NOT NULL,
[228] Fix | Delete
`name` varbinary(100) NOT NULL,
[229] Fix | Delete
`valuetype` int(10) unsigned DEFAULT NULL,
[230] Fix | Delete
`value` mediumblob,
[231] Fix | Delete
PRIMARY KEY (`id`),
[232] Fix | Delete
UNIQUE KEY `path_property` (`path`(600),`name`)
[233] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
[234] Fix | Delete
[235] Fix | Delete
-- --------------------------------------------------------
[236] Fix | Delete
[237] Fix | Delete
--
[238] Fix | Delete
-- Table structure for table `[[dbprefix]]adav_reminders`
[239] Fix | Delete
--
[240] Fix | Delete
[241] Fix | Delete
CREATE TABLE `[[dbprefix]]adav_reminders` (
[242] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[243] Fix | Delete
`user` varchar(100) NOT NULL,
[244] Fix | Delete
`calendaruri` varchar(255) DEFAULT NULL,
[245] Fix | Delete
`eventid` varchar(255) DEFAULT NULL,
[246] Fix | Delete
`time` int(11) DEFAULT NULL,
[247] Fix | Delete
`starttime` int(11) DEFAULT NULL,
[248] Fix | Delete
`allday` tinyint(1) NOT NULL DEFAULT '0',
[249] Fix | Delete
PRIMARY KEY (`id`)
[250] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[251] Fix | Delete
[252] Fix | Delete
-- --------------------------------------------------------
[253] Fix | Delete
[254] Fix | Delete
--
[255] Fix | Delete
-- Table structure for table `[[dbprefix]]adav_schedulingobjects`
[256] Fix | Delete
--
[257] Fix | Delete
[258] Fix | Delete
CREATE TABLE `[[dbprefix]]adav_schedulingobjects` (
[259] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[260] Fix | Delete
`principaluri` varbinary(255) DEFAULT NULL,
[261] Fix | Delete
`calendardata` mediumblob,
[262] Fix | Delete
`uri` varbinary(255) DEFAULT NULL,
[263] Fix | Delete
`lastmodified` int(11) unsigned DEFAULT NULL,
[264] Fix | Delete
`etag` varbinary(32) DEFAULT NULL,
[265] Fix | Delete
`size` int(11) unsigned NOT NULL,
[266] Fix | Delete
PRIMARY KEY (`id`)
[267] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=1 ;
[268] Fix | Delete
[269] Fix | Delete
-- --------------------------------------------------------
[270] Fix | Delete
[271] Fix | Delete
--
[272] Fix | Delete
-- Table structure for table `[[dbprefix]]contacts`
[273] Fix | Delete
--
[274] Fix | Delete
[275] Fix | Delete
CREATE TABLE `[[dbprefix]]contacts` (
[276] Fix | Delete
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[277] Fix | Delete
`UUID` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[278] Fix | Delete
`IdUser` int(11) NOT NULL DEFAULT '0',
[279] Fix | Delete
`IdTenant` int(11) NOT NULL DEFAULT '0',
[280] Fix | Delete
`Storage` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[281] Fix | Delete
`AddressBookId` int(11) DEFAULT NULL,
[282] Fix | Delete
`FullName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[283] Fix | Delete
`UseFriendlyName` tinyint(1) NOT NULL DEFAULT '1',
[284] Fix | Delete
`PrimaryEmail` int(11) NOT NULL DEFAULT '0',
[285] Fix | Delete
`PrimaryPhone` int(11) NOT NULL DEFAULT '1',
[286] Fix | Delete
`PrimaryAddress` int(11) NOT NULL DEFAULT '0',
[287] Fix | Delete
`ViewEmail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[288] Fix | Delete
`Title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[289] Fix | Delete
`FirstName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[290] Fix | Delete
`LastName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[291] Fix | Delete
`NickName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[292] Fix | Delete
`Skype` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[293] Fix | Delete
`Facebook` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[294] Fix | Delete
`PersonalEmail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[295] Fix | Delete
`PersonalAddress` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[296] Fix | Delete
`PersonalCity` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[297] Fix | Delete
`PersonalState` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[298] Fix | Delete
`PersonalZip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[299] Fix | Delete
`PersonalCountry` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[300] Fix | Delete
`PersonalWeb` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[301] Fix | Delete
`PersonalFax` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[302] Fix | Delete
`PersonalPhone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[303] Fix | Delete
`PersonalMobile` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[304] Fix | Delete
`BusinessEmail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[305] Fix | Delete
`BusinessCompany` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[306] Fix | Delete
`BusinessAddress` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[307] Fix | Delete
`BusinessCity` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[308] Fix | Delete
`BusinessState` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[309] Fix | Delete
`BusinessZip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[310] Fix | Delete
`BusinessCountry` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[311] Fix | Delete
`BusinessJobTitle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[312] Fix | Delete
`BusinessDepartment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[313] Fix | Delete
`BusinessOffice` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[314] Fix | Delete
`BusinessPhone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[315] Fix | Delete
`BusinessFax` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[316] Fix | Delete
`BusinessWeb` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[317] Fix | Delete
`OtherEmail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[318] Fix | Delete
`Notes` text COLLATE utf8mb4_unicode_ci,
[319] Fix | Delete
`BirthDay` int(11) NOT NULL DEFAULT '0',
[320] Fix | Delete
`BirthMonth` int(11) NOT NULL DEFAULT '0',
[321] Fix | Delete
`BirthYear` int(11) NOT NULL DEFAULT '0',
[322] Fix | Delete
`ETag` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[323] Fix | Delete
`Auto` tinyint(1) NOT NULL DEFAULT '0',
[324] Fix | Delete
`Frequency` int(11) NOT NULL DEFAULT '0',
[325] Fix | Delete
`DateModified` datetime DEFAULT NULL,
[326] Fix | Delete
`Properties` json DEFAULT NULL,
[327] Fix | Delete
`CreatedAt` timestamp NULL DEFAULT NULL,
[328] Fix | Delete
`UpdatedAt` timestamp NULL DEFAULT NULL,
[329] Fix | Delete
PRIMARY KEY (`Id`),
[330] Fix | Delete
KEY `contacts_iduser_index` (`IdUser`),
[331] Fix | Delete
KEY `contacts_idtenant_index` (`IdTenant`),
[332] Fix | Delete
KEY `contacts_uuid_index` (`UUID`),
[333] Fix | Delete
KEY `contacts_storage_index` (`Storage`),
[334] Fix | Delete
KEY `contacts_frequency_index` (`Frequency`),
[335] Fix | Delete
FULLTEXT KEY `contacts_fullname_index` (`FullName`),
[336] Fix | Delete
FULLTEXT KEY `contacts_viewemail_index` (`ViewEmail`),
[337] Fix | Delete
FULLTEXT KEY `contacts_personalemail_index` (`PersonalEmail`),
[338] Fix | Delete
FULLTEXT KEY `contacts_businessemail_index` (`BusinessEmail`),
[339] Fix | Delete
FULLTEXT KEY `contacts_businesscompany_index` (`BusinessCompany`),
[340] Fix | Delete
FULLTEXT KEY `contacts_otheremail_index` (`OtherEmail`)
[341] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
[342] Fix | Delete
[343] Fix | Delete
-- --------------------------------------------------------
[344] Fix | Delete
[345] Fix | Delete
--
[346] Fix | Delete
-- Table structure for table `[[dbprefix]]contacts_addressbooks`
[347] Fix | Delete
--
[348] Fix | Delete
[349] Fix | Delete
CREATE TABLE `[[dbprefix]]contacts_addressbooks` (
[350] Fix | Delete
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[351] Fix | Delete
`UUID` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[352] Fix | Delete
`UserId` int(11) NOT NULL DEFAULT '0',
[353] Fix | Delete
`Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[354] Fix | Delete
`CreatedAt` timestamp NULL DEFAULT NULL,
[355] Fix | Delete
`UpdatedAt` timestamp NULL DEFAULT NULL,
[356] Fix | Delete
PRIMARY KEY (`Id`),
[357] Fix | Delete
KEY `contacts_addressbooks_userid_index` (`UserId`)
[358] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
[359] Fix | Delete
[360] Fix | Delete
-- --------------------------------------------------------
[361] Fix | Delete
[362] Fix | Delete
--
[363] Fix | Delete
-- Table structure for table `[[dbprefix]]contacts_cards`
[364] Fix | Delete
--
[365] Fix | Delete
[366] Fix | Delete
CREATE TABLE `[[dbprefix]]contacts_cards` (
[367] Fix | Delete
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[368] Fix | Delete
`CardId` int(11) NOT NULL DEFAULT '0',
[369] Fix | Delete
`AddressBookId` int(11) NOT NULL DEFAULT '0',
[370] Fix | Delete
`FullName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[371] Fix | Delete
`PrimaryEmail` int(11) NOT NULL DEFAULT '0',
[372] Fix | Delete
`ViewEmail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[373] Fix | Delete
`FirstName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[374] Fix | Delete
`LastName` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[375] Fix | Delete
`PersonalEmail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[376] Fix | Delete
`BusinessEmail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[377] Fix | Delete
`OtherEmail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[378] Fix | Delete
`BusinessCompany` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[379] Fix | Delete
`Frequency` int(11) NOT NULL DEFAULT '0',
[380] Fix | Delete
`IsGroup` tinyint(1) NOT NULL DEFAULT '0',
[381] Fix | Delete
`Properties` json DEFAULT NULL,
[382] Fix | Delete
PRIMARY KEY (`Id`),
[383] Fix | Delete
KEY `contacts_cards_cardid_index` (`CardId`),
[384] Fix | Delete
KEY `contacts_cards_addressbookid_index` (`AddressBookId`),
[385] Fix | Delete
KEY `contacts_cards_isgroup_index` (`IsGroup`),
[386] Fix | Delete
KEY `contacts_cards_frequency_index` (`Frequency`),
[387] Fix | Delete
FULLTEXT KEY `contacts_cards_fullname_index` (`FullName`),
[388] Fix | Delete
FULLTEXT KEY `contacts_cards_viewemail_index` (`ViewEmail`),
[389] Fix | Delete
FULLTEXT KEY `contacts_cards_personalemail_index` (`PersonalEmail`),
[390] Fix | Delete
FULLTEXT KEY `contacts_cards_businessemail_index` (`BusinessEmail`),
[391] Fix | Delete
FULLTEXT KEY `contacts_cards_businesscompany_index` (`BusinessCompany`),
[392] Fix | Delete
FULLTEXT KEY `contacts_cards_otheremail_index` (`OtherEmail`)
[393] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
[394] Fix | Delete
[395] Fix | Delete
-- --------------------------------------------------------
[396] Fix | Delete
[397] Fix | Delete
--
[398] Fix | Delete
-- Table structure for table `[[dbprefix]]contacts_ctags`
[399] Fix | Delete
--
[400] Fix | Delete
[401] Fix | Delete
CREATE TABLE `[[dbprefix]]contacts_ctags` (
[402] Fix | Delete
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[403] Fix | Delete
`UserId` int(11) NOT NULL DEFAULT '0',
[404] Fix | Delete
`Storage` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[405] Fix | Delete
`CTag` int(11) NOT NULL DEFAULT '0',
[406] Fix | Delete
`CreatedAt` timestamp NULL DEFAULT NULL,
[407] Fix | Delete
`UpdatedAt` timestamp NULL DEFAULT NULL,
[408] Fix | Delete
PRIMARY KEY (`Id`),
[409] Fix | Delete
KEY `contacts_ctags_userid_index` (`UserId`)
[410] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
[411] Fix | Delete
[412] Fix | Delete
-- --------------------------------------------------------
[413] Fix | Delete
[414] Fix | Delete
--
[415] Fix | Delete
-- Table structure for table `[[dbprefix]]contacts_groups`
[416] Fix | Delete
--
[417] Fix | Delete
[418] Fix | Delete
CREATE TABLE `[[dbprefix]]contacts_groups` (
[419] Fix | Delete
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[420] Fix | Delete
`UUID` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[421] Fix | Delete
`IdUser` int(11) NOT NULL DEFAULT '0',
[422] Fix | Delete
`Name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[423] Fix | Delete
`IsOrganization` tinyint(1) NOT NULL DEFAULT '0',
[424] Fix | Delete
`Email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[425] Fix | Delete
`Company` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[426] Fix | Delete
`Street` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[427] Fix | Delete
`City` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[428] Fix | Delete
`State` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[429] Fix | Delete
`Zip` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[430] Fix | Delete
`Country` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[431] Fix | Delete
`Phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[432] Fix | Delete
`Fax` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[433] Fix | Delete
`Web` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[434] Fix | Delete
`Events` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[435] Fix | Delete
`Properties` json DEFAULT NULL,
[436] Fix | Delete
`CreatedAt` timestamp NULL DEFAULT NULL,
[437] Fix | Delete
`UpdatedAt` timestamp NULL DEFAULT NULL,
[438] Fix | Delete
PRIMARY KEY (`Id`),
[439] Fix | Delete
KEY `contacts_groups_iduser_index` (`IdUser`),
[440] Fix | Delete
FULLTEXT KEY `contacts_groups_name_index` (`Name`)
[441] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
[442] Fix | Delete
[443] Fix | Delete
-- --------------------------------------------------------
[444] Fix | Delete
[445] Fix | Delete
--
[446] Fix | Delete
-- Table structure for table `[[dbprefix]]contacts_group_contact`
[447] Fix | Delete
--
[448] Fix | Delete
[449] Fix | Delete
CREATE TABLE `[[dbprefix]]contacts_group_contact` (
[450] Fix | Delete
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[451] Fix | Delete
`GroupId` int(10) unsigned NOT NULL,
[452] Fix | Delete
`ContactId` int(10) unsigned NOT NULL,
[453] Fix | Delete
PRIMARY KEY (`Id`),
[454] Fix | Delete
KEY `contacts_group_contact_groupid_index` (`GroupId`),
[455] Fix | Delete
KEY `contacts_group_contact_contactid_index` (`ContactId`)
[456] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
[457] Fix | Delete
[458] Fix | Delete
-- --------------------------------------------------------
[459] Fix | Delete
[460] Fix | Delete
--
[461] Fix | Delete
-- Table structure for table `[[dbprefix]]contacts_group_events`
[462] Fix | Delete
--
[463] Fix | Delete
[464] Fix | Delete
CREATE TABLE `[[dbprefix]]contacts_group_events` (
[465] Fix | Delete
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[466] Fix | Delete
`GroupUUID` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[467] Fix | Delete
`CalendarUUID` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[468] Fix | Delete
`EventUUID` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
[469] Fix | Delete
`CreatedAt` timestamp NULL DEFAULT NULL,
[470] Fix | Delete
`UpdatedAt` timestamp NULL DEFAULT NULL,
[471] Fix | Delete
PRIMARY KEY (`Id`)
[472] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
[473] Fix | Delete
[474] Fix | Delete
-- --------------------------------------------------------
[475] Fix | Delete
[476] Fix | Delete
--
[477] Fix | Delete
-- Table structure for table `[[dbprefix]]core_auth_tokens`
[478] Fix | Delete
--
[479] Fix | Delete
[480] Fix | Delete
CREATE TABLE `[[dbprefix]]core_auth_tokens` (
[481] Fix | Delete
`Id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
[482] Fix | Delete
`UserId` int(11) NOT NULL DEFAULT '0',
[483] Fix | Delete
`Token` text COLLATE utf8mb4_unicode_ci NOT NULL,
[484] Fix | Delete
`LastUsageDateTime` int(11) NOT NULL DEFAULT '0',
[485] Fix | Delete
`CreatedAt` timestamp NULL DEFAULT NULL,
[486] Fix | Delete
`UpdatedAt` timestamp NULL DEFAULT NULL,
[487] Fix | Delete
PRIMARY KEY (`Id`),
[488] Fix | Delete
KEY `core_auth_tokens_userid_index` (`UserId`)
[489] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
[490] Fix | Delete
[491] Fix | Delete
-- --------------------------------------------------------
[492] Fix | Delete
[493] Fix | Delete
--
[494] Fix | Delete
-- Table structure for table `[[dbprefix]]core_channels`
[495] Fix | Delete
--
[496] Fix | Delete
[497] Fix | Delete
CREATE TABLE `[[dbprefix]]core_channels` (
[498] Fix | Delete
`Id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[499] Fix | Delete
123
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function