Edit File by line
/home/barbar84/public_h.../wp-conte.../plugins/sujqvwi/ExeBy/smexe_ro.../var/softacul.../zurmo
File: zurmo.sql
-- MySQL dump 10.13 Distrib 5.5.49, for Linux (x86_64)
[0] Fix | Delete
--
[1] Fix | Delete
-- Host: localhost Database: zurmo327
[2] Fix | Delete
-- ------------------------------------------------------
[3] Fix | Delete
-- Server version 5.5.49
[4] Fix | Delete
[5] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
[6] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
[7] Fix | Delete
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
[8] Fix | Delete
/*!40101 SET NAMES utf8 */;
[9] Fix | Delete
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
[10] Fix | Delete
/*!40103 SET TIME_ZONE='+00:00' */;
[11] Fix | Delete
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
[12] Fix | Delete
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
[13] Fix | Delete
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
[14] Fix | Delete
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
[15] Fix | Delete
[16] Fix | Delete
--
[17] Fix | Delete
-- Table structure for table `__role_children_cache`
[18] Fix | Delete
--
[19] Fix | Delete
[20] Fix | Delete
DROP TABLE IF EXISTS `__role_children_cache`;
[21] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[22] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[23] Fix | Delete
CREATE TABLE `__role_children_cache` (
[24] Fix | Delete
`permitable_id` int(11) NOT NULL DEFAULT '0',
[25] Fix | Delete
`role_id` int(11) NOT NULL DEFAULT '0',
[26] Fix | Delete
PRIMARY KEY (`permitable_id`,`role_id`),
[27] Fix | Delete
UNIQUE KEY `permitable_id` (`permitable_id`,`role_id`)
[28] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[29] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[30] Fix | Delete
[31] Fix | Delete
--
[32] Fix | Delete
-- Dumping data for table `__role_children_cache`
[33] Fix | Delete
--
[34] Fix | Delete
[35] Fix | Delete
LOCK TABLES `__role_children_cache` WRITE;
[36] Fix | Delete
/*!40000 ALTER TABLE `__role_children_cache` DISABLE KEYS */;
[37] Fix | Delete
/*!40000 ALTER TABLE `__role_children_cache` ENABLE KEYS */;
[38] Fix | Delete
UNLOCK TABLES;
[39] Fix | Delete
[40] Fix | Delete
--
[41] Fix | Delete
-- Table structure for table `_group`
[42] Fix | Delete
--
[43] Fix | Delete
[44] Fix | Delete
DROP TABLE IF EXISTS `_group`;
[45] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[46] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[47] Fix | Delete
CREATE TABLE `_group` (
[48] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[49] Fix | Delete
`name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
[50] Fix | Delete
`permitable_id` int(11) unsigned DEFAULT NULL,
[51] Fix | Delete
`_group_id` int(11) unsigned DEFAULT NULL,
[52] Fix | Delete
PRIMARY KEY (`id`),
[53] Fix | Delete
UNIQUE KEY `unique_eman` (`name`)
[54] Fix | Delete
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[55] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[56] Fix | Delete
[57] Fix | Delete
--
[58] Fix | Delete
-- Dumping data for table `_group`
[59] Fix | Delete
--
[60] Fix | Delete
[61] Fix | Delete
LOCK TABLES `_group` WRITE;
[62] Fix | Delete
/*!40000 ALTER TABLE `_group` DISABLE KEYS */;
[63] Fix | Delete
INSERT INTO `_group` VALUES (1,'Super Administrators',2,NULL),(2,'Everyone',3,NULL);
[64] Fix | Delete
/*!40000 ALTER TABLE `_group` ENABLE KEYS */;
[65] Fix | Delete
UNLOCK TABLES;
[66] Fix | Delete
[67] Fix | Delete
--
[68] Fix | Delete
-- Table structure for table `_group__user`
[69] Fix | Delete
--
[70] Fix | Delete
[71] Fix | Delete
DROP TABLE IF EXISTS `_group__user`;
[72] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[73] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[74] Fix | Delete
CREATE TABLE `_group__user` (
[75] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[76] Fix | Delete
`_group_id` int(11) unsigned DEFAULT NULL,
[77] Fix | Delete
`_user_id` int(11) unsigned DEFAULT NULL,
[78] Fix | Delete
PRIMARY KEY (`id`),
[79] Fix | Delete
UNIQUE KEY `unique_di_resu__di_puorg_` (`_group_id`,`_user_id`),
[80] Fix | Delete
KEY `di_puorg_` (`_group_id`),
[81] Fix | Delete
KEY `di_resu_` (`_user_id`)
[82] Fix | Delete
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[83] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[84] Fix | Delete
[85] Fix | Delete
--
[86] Fix | Delete
-- Dumping data for table `_group__user`
[87] Fix | Delete
--
[88] Fix | Delete
[89] Fix | Delete
LOCK TABLES `_group__user` WRITE;
[90] Fix | Delete
/*!40000 ALTER TABLE `_group__user` DISABLE KEYS */;
[91] Fix | Delete
INSERT INTO `_group__user` VALUES (1,1,1),(2,1,2);
[92] Fix | Delete
/*!40000 ALTER TABLE `_group__user` ENABLE KEYS */;
[93] Fix | Delete
UNLOCK TABLES;
[94] Fix | Delete
[95] Fix | Delete
--
[96] Fix | Delete
-- Table structure for table `_right`
[97] Fix | Delete
--
[98] Fix | Delete
[99] Fix | Delete
DROP TABLE IF EXISTS `_right`;
[100] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[101] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[102] Fix | Delete
CREATE TABLE `_right` (
[103] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[104] Fix | Delete
`modulename` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
[105] Fix | Delete
`name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
[106] Fix | Delete
`type` tinyint(11) DEFAULT NULL,
[107] Fix | Delete
`permitable_id` int(11) unsigned DEFAULT NULL,
[108] Fix | Delete
PRIMARY KEY (`id`)
[109] Fix | Delete
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[110] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[111] Fix | Delete
[112] Fix | Delete
--
[113] Fix | Delete
-- Dumping data for table `_right`
[114] Fix | Delete
--
[115] Fix | Delete
[116] Fix | Delete
LOCK TABLES `_right` WRITE;
[117] Fix | Delete
/*!40000 ALTER TABLE `_right` DISABLE KEYS */;
[118] Fix | Delete
INSERT INTO `_right` VALUES (1,'UsersModule','Login Via Web',1,3),(2,'UsersModule','Login Via Mobile',1,3),(3,'UsersModule','Login Via Web API',1,3),(4,'AccountsModule','Access Accounts Tab',1,3),(5,'AccountsModule','Create Accounts',1,3),(6,'AccountsModule','Delete Accounts',1,3),(7,'CampaignsModule','Access Campaigns Tab',1,3),(8,'CampaignsModule','Create Campaigns',1,3),(9,'CampaignsModule','Delete Campaigns',1,3),(10,'ContactsModule','Access Contacts Tab',1,3),(11,'ContactsModule','Create Contacts',1,3),(12,'ContactsModule','Delete Contacts',1,3),(13,'ConversationsModule','Access Conversations Tab',1,3),(14,'ConversationsModule','Create Conversations',1,3),(15,'ConversationsModule','Delete Conversations',1,3),(16,'EmailMessagesModule','Access Emails Tab',1,3),(17,'EmailMessagesModule','Create Emails',1,3),(18,'EmailMessagesModule','Delete Emails',1,3),(19,'EmailTemplatesModule','Access Email Templates',1,3),(20,'EmailTemplatesModule','Create Email Templates',1,3),(21,'EmailTemplatesModule','Delete Email Templates',1,3),(22,'LeadsModule','Access Leads Tab',1,3),(23,'LeadsModule','Create Leads',1,3),(24,'LeadsModule','Delete Leads',1,3),(25,'LeadsModule','Convert Leads',1,3),(26,'OpportunitiesModule','Access Opportunities Tab',1,3),(27,'OpportunitiesModule','Create Opportunities',1,3),(28,'OpportunitiesModule','Delete Opportunities',1,3),(29,'MarketingModule','Access Marketing Tab',1,3),(30,'MarketingListsModule','Access Marketing Lists Tab',1,3),(31,'MarketingListsModule','Create Marketing Lists',1,3),(32,'MarketingListsModule','Delete Marketing Lists',1,3),(33,'MeetingsModule','Access Meetings',1,3),(34,'MeetingsModule','Create Meetings',1,3),(35,'MeetingsModule','Delete Meetings',1,3),(36,'MissionsModule','Access Missions Tab',1,3),(37,'MissionsModule','Create Missions',1,3),(38,'MissionsModule','Delete Missions',1,3),(39,'NotesModule','Access Notes',1,3),(40,'NotesModule','Create Notes',1,3),(41,'NotesModule','Delete Notes',1,3),(42,'ReportsModule','Access Reports Tab',1,3),(43,'ReportsModule','Create Reports',1,3),(44,'ReportsModule','Delete Reports',1,3),(45,'TasksModule','Access Tasks',1,3),(46,'TasksModule','Create Tasks',1,3),(47,'TasksModule','Delete Tasks',1,3),(48,'HomeModule','Access Dashboards',1,3),(49,'HomeModule','Create Dashboards',1,3),(50,'HomeModule','Delete Dashboards',1,3),(51,'ExportModule','Access Export Tool',1,3),(52,'SocialItemsModule','Access Social Items',1,3),(53,'ProductsModule','Access Products Tab',1,3),(54,'ProductsModule','Create Products',1,3),(55,'ProductsModule','Delete Products',1,3),(56,'ProductTemplatesModule','Access Catalog Items Tab',1,3),(57,'ProductTemplatesModule','Create Catalog Items',1,3),(58,'ProductTemplatesModule','Delete Catalog Items',1,3),(59,'ProjectsModule','Access Projects Tab',1,3),(60,'ProjectsModule','Create Projects',1,3),(61,'ProjectsModule','Delete Projects',1,3),(62,'CalendarsModule','Access Calandar Tab',1,3),(63,'CalendarsModule','Create Calendar',1,3),(64,'CalendarsModule','Delete Calendar',1,3),(65,'UsersModule','Login Via Mobile',2,4),(66,'UsersModule','Login Via Web',2,4),(67,'UsersModule','Login Via Web API',2,4);
[119] Fix | Delete
/*!40000 ALTER TABLE `_right` ENABLE KEYS */;
[120] Fix | Delete
UNLOCK TABLES;
[121] Fix | Delete
[122] Fix | Delete
--
[123] Fix | Delete
-- Table structure for table `_user`
[124] Fix | Delete
--
[125] Fix | Delete
[126] Fix | Delete
DROP TABLE IF EXISTS `_user`;
[127] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[128] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[129] Fix | Delete
CREATE TABLE `_user` (
[130] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[131] Fix | Delete
`hash` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
[132] Fix | Delete
`language` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
[133] Fix | Delete
`locale` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
[134] Fix | Delete
`timezone` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
[135] Fix | Delete
`username` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
[136] Fix | Delete
`serializedavatardata` text COLLATE utf8_unicode_ci,
[137] Fix | Delete
`isactive` tinyint(1) unsigned DEFAULT NULL,
[138] Fix | Delete
`isrootuser` tinyint(1) unsigned DEFAULT NULL,
[139] Fix | Delete
`hidefromselecting` tinyint(1) unsigned DEFAULT NULL,
[140] Fix | Delete
`issystemuser` tinyint(1) unsigned DEFAULT NULL,
[141] Fix | Delete
`hidefromleaderboard` tinyint(1) unsigned DEFAULT NULL,
[142] Fix | Delete
`lastlogindatetime` datetime DEFAULT NULL,
[143] Fix | Delete
`permitable_id` int(11) unsigned DEFAULT NULL,
[144] Fix | Delete
`person_id` int(11) unsigned DEFAULT NULL,
[145] Fix | Delete
`currency_id` int(11) unsigned DEFAULT NULL,
[146] Fix | Delete
`manager__user_id` int(11) unsigned DEFAULT NULL,
[147] Fix | Delete
`role_id` int(11) unsigned DEFAULT NULL,
[148] Fix | Delete
`secondaryemail_email_id` int(11) unsigned DEFAULT NULL,
[149] Fix | Delete
PRIMARY KEY (`id`),
[150] Fix | Delete
UNIQUE KEY `unique_emanresu` (`username`),
[151] Fix | Delete
KEY `permitable_id` (`permitable_id`)
[152] Fix | Delete
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[153] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[154] Fix | Delete
[155] Fix | Delete
--
[156] Fix | Delete
-- Dumping data for table `_user`
[157] Fix | Delete
--
[158] Fix | Delete
[159] Fix | Delete
LOCK TABLES `_user` WRITE;
[160] Fix | Delete
/*!40000 ALTER TABLE `_user` DISABLE KEYS */;
[161] Fix | Delete
INSERT INTO `_user` VALUES (1,'[[admin_pass]]',NULL,NULL,'America/Chicago','super',NULL,1,1,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),(2,'$2y$12$8JogkPrMyWUs.JAEcM50eu82gc2BrHRutmg/V7JacMmqdTOaLFwXO',NULL,NULL,'America/Chicago','backendjoboractionuser',NULL,0,NULL,1,1,1,NULL,4,2,NULL,NULL,NULL,NULL);
[162] Fix | Delete
/*!40000 ALTER TABLE `_user` ENABLE KEYS */;
[163] Fix | Delete
UNLOCK TABLES;
[164] Fix | Delete
[165] Fix | Delete
--
[166] Fix | Delete
-- Table structure for table `_user_meeting`
[167] Fix | Delete
--
[168] Fix | Delete
[169] Fix | Delete
DROP TABLE IF EXISTS `_user_meeting`;
[170] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[171] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[172] Fix | Delete
CREATE TABLE `_user_meeting` (
[173] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[174] Fix | Delete
`meeting_id` int(11) unsigned DEFAULT NULL,
[175] Fix | Delete
`_user_id` int(11) unsigned DEFAULT NULL,
[176] Fix | Delete
PRIMARY KEY (`id`),
[177] Fix | Delete
UNIQUE KEY `unique_di_resu__di_gniteem` (`meeting_id`,`_user_id`),
[178] Fix | Delete
KEY `di_gniteem` (`meeting_id`),
[179] Fix | Delete
KEY `di_resu_` (`_user_id`)
[180] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[181] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[182] Fix | Delete
[183] Fix | Delete
--
[184] Fix | Delete
-- Dumping data for table `_user_meeting`
[185] Fix | Delete
--
[186] Fix | Delete
[187] Fix | Delete
LOCK TABLES `_user_meeting` WRITE;
[188] Fix | Delete
/*!40000 ALTER TABLE `_user_meeting` DISABLE KEYS */;
[189] Fix | Delete
/*!40000 ALTER TABLE `_user_meeting` ENABLE KEYS */;
[190] Fix | Delete
UNLOCK TABLES;
[191] Fix | Delete
[192] Fix | Delete
--
[193] Fix | Delete
-- Table structure for table `account`
[194] Fix | Delete
--
[195] Fix | Delete
[196] Fix | Delete
DROP TABLE IF EXISTS `account`;
[197] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[198] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[199] Fix | Delete
CREATE TABLE `account` (
[200] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[201] Fix | Delete
`annualrevenue` double DEFAULT NULL,
[202] Fix | Delete
`description` text COLLATE utf8_unicode_ci,
[203] Fix | Delete
`employees` int(11) DEFAULT NULL,
[204] Fix | Delete
`latestactivitydatetime` datetime DEFAULT NULL,
[205] Fix | Delete
`name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
[206] Fix | Delete
`officephone` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL,
[207] Fix | Delete
`officefax` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL,
[208] Fix | Delete
`website` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
[209] Fix | Delete
`ownedsecurableitem_id` int(11) unsigned DEFAULT NULL,
[210] Fix | Delete
`account_id` int(11) unsigned DEFAULT NULL,
[211] Fix | Delete
`billingaddress_address_id` int(11) unsigned DEFAULT NULL,
[212] Fix | Delete
`industry_customfield_id` int(11) unsigned DEFAULT NULL,
[213] Fix | Delete
`primaryemail_email_id` int(11) unsigned DEFAULT NULL,
[214] Fix | Delete
`secondaryemail_email_id` int(11) unsigned DEFAULT NULL,
[215] Fix | Delete
`shippingaddress_address_id` int(11) unsigned DEFAULT NULL,
[216] Fix | Delete
`type_customfield_id` int(11) unsigned DEFAULT NULL,
[217] Fix | Delete
PRIMARY KEY (`id`)
[218] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[219] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[220] Fix | Delete
[221] Fix | Delete
--
[222] Fix | Delete
-- Dumping data for table `account`
[223] Fix | Delete
--
[224] Fix | Delete
[225] Fix | Delete
LOCK TABLES `account` WRITE;
[226] Fix | Delete
/*!40000 ALTER TABLE `account` DISABLE KEYS */;
[227] Fix | Delete
/*!40000 ALTER TABLE `account` ENABLE KEYS */;
[228] Fix | Delete
UNLOCK TABLES;
[229] Fix | Delete
[230] Fix | Delete
--
[231] Fix | Delete
-- Table structure for table `account_project`
[232] Fix | Delete
--
[233] Fix | Delete
[234] Fix | Delete
DROP TABLE IF EXISTS `account_project`;
[235] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[236] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[237] Fix | Delete
CREATE TABLE `account_project` (
[238] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[239] Fix | Delete
`account_id` int(11) unsigned DEFAULT NULL,
[240] Fix | Delete
`project_id` int(11) unsigned DEFAULT NULL,
[241] Fix | Delete
PRIMARY KEY (`id`),
[242] Fix | Delete
UNIQUE KEY `unique_di_tcejorp_di_tnuocca` (`account_id`,`project_id`),
[243] Fix | Delete
KEY `di_tnuocca` (`account_id`),
[244] Fix | Delete
KEY `di_tcejorp` (`project_id`)
[245] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[246] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[247] Fix | Delete
[248] Fix | Delete
--
[249] Fix | Delete
-- Dumping data for table `account_project`
[250] Fix | Delete
--
[251] Fix | Delete
[252] Fix | Delete
LOCK TABLES `account_project` WRITE;
[253] Fix | Delete
/*!40000 ALTER TABLE `account_project` DISABLE KEYS */;
[254] Fix | Delete
/*!40000 ALTER TABLE `account_project` ENABLE KEYS */;
[255] Fix | Delete
UNLOCK TABLES;
[256] Fix | Delete
[257] Fix | Delete
--
[258] Fix | Delete
-- Table structure for table `account_read`
[259] Fix | Delete
--
[260] Fix | Delete
[261] Fix | Delete
DROP TABLE IF EXISTS `account_read`;
[262] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[263] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[264] Fix | Delete
CREATE TABLE `account_read` (
[265] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[266] Fix | Delete
`securableitem_id` int(11) unsigned NOT NULL,
[267] Fix | Delete
`munge_id` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
[268] Fix | Delete
`count` int(8) unsigned NOT NULL,
[269] Fix | Delete
PRIMARY KEY (`id`),
[270] Fix | Delete
UNIQUE KEY `securableitem_id_munge_id` (`securableitem_id`,`munge_id`),
[271] Fix | Delete
KEY `account_read_securableitem_id` (`securableitem_id`)
[272] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[273] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[274] Fix | Delete
[275] Fix | Delete
--
[276] Fix | Delete
-- Dumping data for table `account_read`
[277] Fix | Delete
--
[278] Fix | Delete
[279] Fix | Delete
LOCK TABLES `account_read` WRITE;
[280] Fix | Delete
/*!40000 ALTER TABLE `account_read` DISABLE KEYS */;
[281] Fix | Delete
/*!40000 ALTER TABLE `account_read` ENABLE KEYS */;
[282] Fix | Delete
UNLOCK TABLES;
[283] Fix | Delete
[284] Fix | Delete
--
[285] Fix | Delete
-- Table structure for table `account_read_subscription`
[286] Fix | Delete
--
[287] Fix | Delete
[288] Fix | Delete
DROP TABLE IF EXISTS `account_read_subscription`;
[289] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[290] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[291] Fix | Delete
CREATE TABLE `account_read_subscription` (
[292] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[293] Fix | Delete
`userid` int(11) unsigned NOT NULL,
[294] Fix | Delete
`modelid` int(11) unsigned NOT NULL,
[295] Fix | Delete
`modifieddatetime` datetime DEFAULT NULL,
[296] Fix | Delete
`subscriptiontype` tinyint(4) DEFAULT NULL,
[297] Fix | Delete
PRIMARY KEY (`id`),
[298] Fix | Delete
UNIQUE KEY `userid_modelid` (`userid`,`modelid`)
[299] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[300] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[301] Fix | Delete
[302] Fix | Delete
--
[303] Fix | Delete
-- Dumping data for table `account_read_subscription`
[304] Fix | Delete
--
[305] Fix | Delete
[306] Fix | Delete
LOCK TABLES `account_read_subscription` WRITE;
[307] Fix | Delete
/*!40000 ALTER TABLE `account_read_subscription` DISABLE KEYS */;
[308] Fix | Delete
/*!40000 ALTER TABLE `account_read_subscription` ENABLE KEYS */;
[309] Fix | Delete
UNLOCK TABLES;
[310] Fix | Delete
[311] Fix | Delete
--
[312] Fix | Delete
-- Table structure for table `account_read_subscription_temp_build`
[313] Fix | Delete
--
[314] Fix | Delete
[315] Fix | Delete
DROP TABLE IF EXISTS `account_read_subscription_temp_build`;
[316] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[317] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[318] Fix | Delete
CREATE TABLE `account_read_subscription_temp_build` (
[319] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[320] Fix | Delete
`accountid` int(11) unsigned NOT NULL,
[321] Fix | Delete
PRIMARY KEY (`id`)
[322] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[323] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[324] Fix | Delete
[325] Fix | Delete
--
[326] Fix | Delete
-- Dumping data for table `account_read_subscription_temp_build`
[327] Fix | Delete
--
[328] Fix | Delete
[329] Fix | Delete
LOCK TABLES `account_read_subscription_temp_build` WRITE;
[330] Fix | Delete
/*!40000 ALTER TABLE `account_read_subscription_temp_build` DISABLE KEYS */;
[331] Fix | Delete
/*!40000 ALTER TABLE `account_read_subscription_temp_build` ENABLE KEYS */;
[332] Fix | Delete
UNLOCK TABLES;
[333] Fix | Delete
[334] Fix | Delete
--
[335] Fix | Delete
-- Table structure for table `accountaccountaffiliation`
[336] Fix | Delete
--
[337] Fix | Delete
[338] Fix | Delete
DROP TABLE IF EXISTS `accountaccountaffiliation`;
[339] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[340] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[341] Fix | Delete
CREATE TABLE `accountaccountaffiliation` (
[342] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[343] Fix | Delete
`item_id` int(11) unsigned DEFAULT NULL,
[344] Fix | Delete
`primaryaccountaffiliation_account_id` int(11) unsigned DEFAULT NULL,
[345] Fix | Delete
`secondaryaccountaffiliation_account_id` int(11) unsigned DEFAULT NULL,
[346] Fix | Delete
PRIMARY KEY (`id`)
[347] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[348] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[349] Fix | Delete
[350] Fix | Delete
--
[351] Fix | Delete
-- Dumping data for table `accountaccountaffiliation`
[352] Fix | Delete
--
[353] Fix | Delete
[354] Fix | Delete
LOCK TABLES `accountaccountaffiliation` WRITE;
[355] Fix | Delete
/*!40000 ALTER TABLE `accountaccountaffiliation` DISABLE KEYS */;
[356] Fix | Delete
/*!40000 ALTER TABLE `accountaccountaffiliation` ENABLE KEYS */;
[357] Fix | Delete
UNLOCK TABLES;
[358] Fix | Delete
[359] Fix | Delete
--
[360] Fix | Delete
-- Table structure for table `accountcontactaffiliation`
[361] Fix | Delete
--
[362] Fix | Delete
[363] Fix | Delete
DROP TABLE IF EXISTS `accountcontactaffiliation`;
[364] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[365] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[366] Fix | Delete
CREATE TABLE `accountcontactaffiliation` (
[367] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[368] Fix | Delete
`primary` tinyint(1) unsigned DEFAULT NULL,
[369] Fix | Delete
`item_id` int(11) unsigned DEFAULT NULL,
[370] Fix | Delete
`role_customfield_id` int(11) unsigned DEFAULT NULL,
[371] Fix | Delete
`accountaffiliation_account_id` int(11) unsigned DEFAULT NULL,
[372] Fix | Delete
`contactaffiliation_contact_id` int(11) unsigned DEFAULT NULL,
[373] Fix | Delete
PRIMARY KEY (`id`)
[374] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[375] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[376] Fix | Delete
[377] Fix | Delete
--
[378] Fix | Delete
-- Dumping data for table `accountcontactaffiliation`
[379] Fix | Delete
--
[380] Fix | Delete
[381] Fix | Delete
LOCK TABLES `accountcontactaffiliation` WRITE;
[382] Fix | Delete
/*!40000 ALTER TABLE `accountcontactaffiliation` DISABLE KEYS */;
[383] Fix | Delete
/*!40000 ALTER TABLE `accountcontactaffiliation` ENABLE KEYS */;
[384] Fix | Delete
UNLOCK TABLES;
[385] Fix | Delete
[386] Fix | Delete
--
[387] Fix | Delete
-- Table structure for table `accountstarred`
[388] Fix | Delete
--
[389] Fix | Delete
[390] Fix | Delete
DROP TABLE IF EXISTS `accountstarred`;
[391] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[392] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[393] Fix | Delete
CREATE TABLE `accountstarred` (
[394] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[395] Fix | Delete
`basestarredmodel_id` int(11) unsigned DEFAULT NULL,
[396] Fix | Delete
`account_id` int(11) unsigned DEFAULT NULL,
[397] Fix | Delete
PRIMARY KEY (`id`),
[398] Fix | Delete
UNIQUE KEY `basestarredmodel_id_account_id` (`basestarredmodel_id`,`account_id`)
[399] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[400] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[401] Fix | Delete
[402] Fix | Delete
--
[403] Fix | Delete
-- Dumping data for table `accountstarred`
[404] Fix | Delete
--
[405] Fix | Delete
[406] Fix | Delete
LOCK TABLES `accountstarred` WRITE;
[407] Fix | Delete
/*!40000 ALTER TABLE `accountstarred` DISABLE KEYS */;
[408] Fix | Delete
/*!40000 ALTER TABLE `accountstarred` ENABLE KEYS */;
[409] Fix | Delete
UNLOCK TABLES;
[410] Fix | Delete
[411] Fix | Delete
--
[412] Fix | Delete
-- Table structure for table `activelanguage`
[413] Fix | Delete
--
[414] Fix | Delete
[415] Fix | Delete
DROP TABLE IF EXISTS `activelanguage`;
[416] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[417] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[418] Fix | Delete
CREATE TABLE `activelanguage` (
[419] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[420] Fix | Delete
`code` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL,
[421] Fix | Delete
`name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
[422] Fix | Delete
`nativename` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
[423] Fix | Delete
`activationdatetime` datetime DEFAULT NULL,
[424] Fix | Delete
`lastupdatedatetime` datetime DEFAULT NULL,
[425] Fix | Delete
PRIMARY KEY (`id`)
[426] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[427] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[428] Fix | Delete
[429] Fix | Delete
--
[430] Fix | Delete
-- Dumping data for table `activelanguage`
[431] Fix | Delete
--
[432] Fix | Delete
[433] Fix | Delete
LOCK TABLES `activelanguage` WRITE;
[434] Fix | Delete
/*!40000 ALTER TABLE `activelanguage` DISABLE KEYS */;
[435] Fix | Delete
/*!40000 ALTER TABLE `activelanguage` ENABLE KEYS */;
[436] Fix | Delete
UNLOCK TABLES;
[437] Fix | Delete
[438] Fix | Delete
--
[439] Fix | Delete
-- Table structure for table `activity`
[440] Fix | Delete
--
[441] Fix | Delete
[442] Fix | Delete
DROP TABLE IF EXISTS `activity`;
[443] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[444] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[445] Fix | Delete
CREATE TABLE `activity` (
[446] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[447] Fix | Delete
`latestdatetime` datetime DEFAULT NULL,
[448] Fix | Delete
`ownedsecurableitem_id` int(11) unsigned DEFAULT NULL,
[449] Fix | Delete
PRIMARY KEY (`id`),
[450] Fix | Delete
KEY `ownedsecurableitem_id` (`ownedsecurableitem_id`)
[451] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[452] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[453] Fix | Delete
[454] Fix | Delete
--
[455] Fix | Delete
-- Dumping data for table `activity`
[456] Fix | Delete
--
[457] Fix | Delete
[458] Fix | Delete
LOCK TABLES `activity` WRITE;
[459] Fix | Delete
/*!40000 ALTER TABLE `activity` DISABLE KEYS */;
[460] Fix | Delete
/*!40000 ALTER TABLE `activity` ENABLE KEYS */;
[461] Fix | Delete
UNLOCK TABLES;
[462] Fix | Delete
[463] Fix | Delete
--
[464] Fix | Delete
-- Table structure for table `activity_item`
[465] Fix | Delete
--
[466] Fix | Delete
[467] Fix | Delete
DROP TABLE IF EXISTS `activity_item`;
[468] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[469] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[470] Fix | Delete
CREATE TABLE `activity_item` (
[471] Fix | Delete
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
[472] Fix | Delete
`activity_id` int(11) unsigned DEFAULT NULL,
[473] Fix | Delete
`item_id` int(11) unsigned DEFAULT NULL,
[474] Fix | Delete
PRIMARY KEY (`id`),
[475] Fix | Delete
UNIQUE KEY `unique_di_meti_di_ytivitca` (`activity_id`,`item_id`),
[476] Fix | Delete
KEY `di_ytivitca` (`activity_id`),
[477] Fix | Delete
KEY `di_meti` (`item_id`)
[478] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
[479] Fix | Delete
/*!40101 SET character_set_client = @saved_cs_client */;
[480] Fix | Delete
[481] Fix | Delete
--
[482] Fix | Delete
-- Dumping data for table `activity_item`
[483] Fix | Delete
--
[484] Fix | Delete
[485] Fix | Delete
LOCK TABLES `activity_item` WRITE;
[486] Fix | Delete
/*!40000 ALTER TABLE `activity_item` DISABLE KEYS */;
[487] Fix | Delete
/*!40000 ALTER TABLE `activity_item` ENABLE KEYS */;
[488] Fix | Delete
UNLOCK TABLES;
[489] Fix | Delete
[490] Fix | Delete
--
[491] Fix | Delete
-- Table structure for table `actual_permissions_cache`
[492] Fix | Delete
--
[493] Fix | Delete
[494] Fix | Delete
DROP TABLE IF EXISTS `actual_permissions_cache`;
[495] Fix | Delete
/*!40101 SET @saved_cs_client = @@character_set_client */;
[496] Fix | Delete
/*!40101 SET character_set_client = utf8 */;
[497] Fix | Delete
CREATE TABLE `actual_permissions_cache` (
[498] Fix | Delete
`securableitem_id` int(11) unsigned NOT NULL,
[499] Fix | Delete
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function