/var/softaculous/zurmo/
/var/softaculous/zurmo
NameSizeModeActions
images/-0755rm
php53/-0755rm
php56/-0755rm
php71/-0755rm
php81/-0755rm
upgrade/-0755rm
clone.php63740644editdlrm
debug.php78080644editdlrm
edit.php58470644editdlrm
edit.xml4330644editdlrm
extend.php18950644editdlrm
fileindex.php490644editdlrm
import.php35890644editdlrm
info.xml34970644editdlrm
install.js9240644editdlrm
install.php98510644editdlrm
install.xml5070644editdlrm
md521950644editdlrm
notes.txt10880644editdlrm
perInstance.php39570644editdlrm
update_pass.php21860644editdlrm
upgrade.php96720644editdlrm
upgrade.xml3880644editdlrm
zurmo.sql3558650644editdlrm
zurmo.zip360014600644editdlrm
Edit: /var/softaculous/zurmo/zurmo.sql (355865B)
-- MySQL dump 10.13 Distrib 5.5.49, for Linux (x86_64) -- -- Host: localhost Database: zurmo327 -- ------------------------------------------------------ -- Server version 5.5.49 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `__role_children_cache` -- DROP TABLE IF EXISTS `__role_children_cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `__role_children_cache` ( `permitable_id` int(11) NOT NULL DEFAULT '0', `role_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`permitable_id`,`role_id`), UNIQUE KEY `permitable_id` (`permitable_id`,`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `__role_children_cache` -- LOCK TABLES `__role_children_cache` WRITE; /*!40000 ALTER TABLE `__role_children_cache` DISABLE KEYS */; /*!40000 ALTER TABLE `__role_children_cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `_group` -- DROP TABLE IF EXISTS `_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `_group` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `permitable_id` int(11) unsigned DEFAULT NULL, `_group_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_eman` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `_group` -- LOCK TABLES `_group` WRITE; /*!40000 ALTER TABLE `_group` DISABLE KEYS */; INSERT INTO `_group` VALUES (1,'Super Administrators',2,NULL),(2,'Everyone',3,NULL); /*!40000 ALTER TABLE `_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `_group__user` -- DROP TABLE IF EXISTS `_group__user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `_group__user` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `_group_id` int(11) unsigned DEFAULT NULL, `_user_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_di_resu__di_puorg_` (`_group_id`,`_user_id`), KEY `di_puorg_` (`_group_id`), KEY `di_resu_` (`_user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `_group__user` -- LOCK TABLES `_group__user` WRITE; /*!40000 ALTER TABLE `_group__user` DISABLE KEYS */; INSERT INTO `_group__user` VALUES (1,1,1),(2,1,2); /*!40000 ALTER TABLE `_group__user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `_right` -- DROP TABLE IF EXISTS `_right`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `_right` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `modulename` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `type` tinyint(11) DEFAULT NULL, `permitable_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `_right` -- LOCK TABLES `_right` WRITE; /*!40000 ALTER TABLE `_right` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `_right` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `_user` -- DROP TABLE IF EXISTS `_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `_user` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `hash` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL, `language` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `locale` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `timezone` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `username` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `serializedavatardata` text COLLATE utf8_unicode_ci, `isactive` tinyint(1) unsigned DEFAULT NULL, `isrootuser` tinyint(1) unsigned DEFAULT NULL, `hidefromselecting` tinyint(1) unsigned DEFAULT NULL, `issystemuser` tinyint(1) unsigned DEFAULT NULL, `hidefromleaderboard` tinyint(1) unsigned DEFAULT NULL, `lastlogindatetime` datetime DEFAULT NULL, `permitable_id` int(11) unsigned DEFAULT NULL, `person_id` int(11) unsigned DEFAULT NULL, `currency_id` int(11) unsigned DEFAULT NULL, `manager__user_id` int(11) unsigned DEFAULT NULL, `role_id` int(11) unsigned DEFAULT NULL, `secondaryemail_email_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_emanresu` (`username`), KEY `permitable_id` (`permitable_id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `_user` -- LOCK TABLES `_user` WRITE; /*!40000 ALTER TABLE `_user` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `_user_meeting` -- DROP TABLE IF EXISTS `_user_meeting`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `_user_meeting` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `meeting_id` int(11) unsigned DEFAULT NULL, `_user_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_di_resu__di_gniteem` (`meeting_id`,`_user_id`), KEY `di_gniteem` (`meeting_id`), KEY `di_resu_` (`_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `_user_meeting` -- LOCK TABLES `_user_meeting` WRITE; /*!40000 ALTER TABLE `_user_meeting` DISABLE KEYS */; /*!40000 ALTER TABLE `_user_meeting` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `account` -- DROP TABLE IF EXISTS `account`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `account` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `annualrevenue` double DEFAULT NULL, `description` text COLLATE utf8_unicode_ci, `employees` int(11) DEFAULT NULL, `latestactivitydatetime` datetime DEFAULT NULL, `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `officephone` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL, `officefax` varchar(24) COLLATE utf8_unicode_ci DEFAULT NULL, `website` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `ownedsecurableitem_id` int(11) unsigned DEFAULT NULL, `account_id` int(11) unsigned DEFAULT NULL, `billingaddress_address_id` int(11) unsigned DEFAULT NULL, `industry_customfield_id` int(11) unsigned DEFAULT NULL, `primaryemail_email_id` int(11) unsigned DEFAULT NULL, `secondaryemail_email_id` int(11) unsigned DEFAULT NULL, `shippingaddress_address_id` int(11) unsigned DEFAULT NULL, `type_customfield_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `account` -- LOCK TABLES `account` WRITE; /*!40000 ALTER TABLE `account` DISABLE KEYS */; /*!40000 ALTER TABLE `account` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `account_project` -- DROP TABLE IF EXISTS `account_project`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `account_project` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `account_id` int(11) unsigned DEFAULT NULL, `project_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_di_tcejorp_di_tnuocca` (`account_id`,`project_id`), KEY `di_tnuocca` (`account_id`), KEY `di_tcejorp` (`project_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `account_project` -- LOCK TABLES `account_project` WRITE; /*!40000 ALTER TABLE `account_project` DISABLE KEYS */; /*!40000 ALTER TABLE `account_project` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `account_read` -- DROP TABLE IF EXISTS `account_read`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `account_read` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `securableitem_id` int(11) unsigned NOT NULL, `munge_id` varchar(12) COLLATE utf8_unicode_ci NOT NULL, `count` int(8) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `securableitem_id_munge_id` (`securableitem_id`,`munge_id`), KEY `account_read_securableitem_id` (`securableitem_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `account_read` -- LOCK TABLES `account_read` WRITE; /*!40000 ALTER TABLE `account_read` DISABLE KEYS */; /*!40000 ALTER TABLE `account_read` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `account_read_subscription` -- DROP TABLE IF EXISTS `account_read_subscription`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `account_read_subscription` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `userid` int(11) unsigned NOT NULL, `modelid` int(11) unsigned NOT NULL, `modifieddatetime` datetime DEFAULT NULL, `subscriptiontype` tinyint(4) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `userid_modelid` (`userid`,`modelid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `account_read_subscription` -- LOCK TABLES `account_read_subscription` WRITE; /*!40000 ALTER TABLE `account_read_subscription` DISABLE KEYS */; /*!40000 ALTER TABLE `account_read_subscription` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `account_read_subscription_temp_build` -- DROP TABLE IF EXISTS `account_read_subscription_temp_build`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `account_read_subscription_temp_build` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `accountid` int(11) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `account_read_subscription_temp_build` -- LOCK TABLES `account_read_subscription_temp_build` WRITE; /*!40000 ALTER TABLE `account_read_subscription_temp_build` DISABLE KEYS */; /*!40000 ALTER TABLE `account_read_subscription_temp_build` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accountaccountaffiliation` -- DROP TABLE IF EXISTS `accountaccountaffiliation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `accountaccountaffiliation` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `item_id` int(11) unsigned DEFAULT NULL, `primaryaccountaffiliation_account_id` int(11) unsigned DEFAULT NULL, `secondaryaccountaffiliation_account_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `accountaccountaffiliation` -- LOCK TABLES `accountaccountaffiliation` WRITE; /*!40000 ALTER TABLE `accountaccountaffiliation` DISABLE KEYS */; /*!40000 ALTER TABLE `accountaccountaffiliation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accountcontactaffiliation` -- DROP TABLE IF EXISTS `accountcontactaffiliation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `accountcontactaffiliation` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `primary` tinyint(1) unsigned DEFAULT NULL, `item_id` int(11) unsigned DEFAULT NULL, `role_customfield_id` int(11) unsigned DEFAULT NULL, `accountaffiliation_account_id` int(11) unsigned DEFAULT NULL, `contactaffiliation_contact_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `accountcontactaffiliation` -- LOCK TABLES `accountcontactaffiliation` WRITE; /*!40000 ALTER TABLE `accountcontactaffiliation` DISABLE KEYS */; /*!40000 ALTER TABLE `accountcontactaffiliation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `accountstarred` -- DROP TABLE IF EXISTS `accountstarred`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `accountstarred` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `basestarredmodel_id` int(11) unsigned DEFAULT NULL, `account_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `basestarredmodel_id_account_id` (`basestarredmodel_id`,`account_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `accountstarred` -- LOCK TABLES `accountstarred` WRITE; /*!40000 ALTER TABLE `accountstarred` DISABLE KEYS */; /*!40000 ALTER TABLE `accountstarred` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `activelanguage` -- DROP TABLE IF EXISTS `activelanguage`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `activelanguage` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `code` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `nativename` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `activationdatetime` datetime DEFAULT NULL, `lastupdatedatetime` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `activelanguage` -- LOCK TABLES `activelanguage` WRITE; /*!40000 ALTER TABLE `activelanguage` DISABLE KEYS */; /*!40000 ALTER TABLE `activelanguage` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `activity` -- DROP TABLE IF EXISTS `activity`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `activity` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `latestdatetime` datetime DEFAULT NULL, `ownedsecurableitem_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `ownedsecurableitem_id` (`ownedsecurableitem_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `activity` -- LOCK TABLES `activity` WRITE; /*!40000 ALTER TABLE `activity` DISABLE KEYS */; /*!40000 ALTER TABLE `activity` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `activity_item` -- DROP TABLE IF EXISTS `activity_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `activity_item` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `activity_id` int(11) unsigned DEFAULT NULL, `item_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_di_meti_di_ytivitca` (`activity_id`,`item_id`), KEY `di_ytivitca` (`activity_id`), KEY `di_meti` (`item_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `activity_item` -- LOCK TABLES `activity_item` WRITE; /*!40000 ALTER TABLE `activity_item` DISABLE KEYS */; /*!40000 ALTER TABLE `activity_item` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `actual_permissions_cache` -- DROP TABLE IF EXISTS `actual_permissions_cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `actual_permissions_cache` ( `securableitem_id` int(11) unsigned NOT NULL, `permitable_id` int(11) unsigned NOT NULL, `allow_permissions` tinyint(3) unsigned NOT NULL, `deny_permissions` tinyint(3) unsigned NOT NULL, PRIMARY KEY (`securableitem_id`,`permitable_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `actual_permissions_cache` -- LOCK TABLES `actual_permissions_cache` WRITE; /*!40000 ALTER TABLE `actual_permissions_cache` DISABLE KEYS */; /*!40000 ALTER TABLE `actual_permissions_cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `actual_rights_cache` -- DROP TABLE IF EXISTS `actual_rights_cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `actual_rights_cache` ( `identifier` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `entry` int(11) unsigned NOT NULL, PRIMARY KEY (`identifier`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `actual_rights_cache` -- LOCK TABLES `actual_rights_cache` WRITE; /*!40000 ALTER TABLE `actual_rights_cache` DISABLE KEYS */; /*!40000 ALTER TABLE `actual_rights_cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `address` -- DROP TABLE IF EXISTS `address`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `address` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `city` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `country` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `invalid` tinyint(1) unsigned DEFAULT NULL, `latitude` double DEFAULT NULL, `longitude` double DEFAULT NULL, `postalcode` varchar(16) COLLATE utf8_unicode_ci DEFAULT NULL, `street1` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `street2` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `state` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `address` -- LOCK TABLES `address` WRITE; /*!40000 ALTER TABLE `address` DISABLE KEYS */; /*!40000 ALTER TABLE `address` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `auditevent` -- DROP TABLE IF EXISTS `auditevent`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `auditevent` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `datetime` datetime DEFAULT NULL, `eventname` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `modulename` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `modelclassname` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `modelid` int(11) DEFAULT NULL, `serializeddata` text COLLATE utf8_unicode_ci, `_user_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `modelclass_modelid_index` (`modelclassname`,`modelid`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `auditevent` -- LOCK TABLES `auditevent` WRITE; /*!40000 ALTER TABLE `auditevent` DISABLE KEYS */; INSERT INTO `auditevent` VALUES (1,'[[regtime]]','User Password Changed','UsersModule','User',1,'s:5:\"super\";',1),(2,'[[regtime]]','Item Modified','ZurmoModule','User',1,'a:4:{i:0;s:10:\"Super User\";i:1;a:1:{i:0;s:8:\"isActive\";}i:2;s:5:\"false\";i:3;s:4:\"true\";}',1),(3,'[[regtime]]','User Password Changed','UsersModule','User',2,'s:22:\"backendjoboractionuser\";',1),(4,'[[regtime]]','Item Modified','ZurmoModule','User',2,'a:4:{i:0;s:11:\"System User\";i:1;a:1:{i:0;s:8:\"isActive\";}i:2;s:5:\"false\";i:3;s:4:\"true\";}',1),(5,'[[regtime]]','Item Modified','ZurmoModule','User',2,'a:4:{i:0;s:11:\"System User\";i:1;a:1:{i:0;s:8:\"isActive\";}i:2;s:4:\"true\";i:3;s:5:\"false\";}',1); /*!40000 ALTER TABLE `auditevent` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `autoresponder` -- DROP TABLE IF EXISTS `autoresponder`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `autoresponder` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `htmlcontent` text COLLATE utf8_unicode_ci, `textcontent` text COLLATE utf8_unicode_ci, `fromoperationdurationinterval` int(11) DEFAULT NULL, `fromoperationdurationtype` text COLLATE utf8_unicode_ci, `operationtype` int(11) DEFAULT NULL, `enabletracking` tinyint(1) unsigned DEFAULT NULL, `item_id` int(11) unsigned DEFAULT NULL, `marketinglist_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `autoresponder` -- LOCK TABLES `autoresponder` WRITE; /*!40000 ALTER TABLE `autoresponder` DISABLE KEYS */; /*!40000 ALTER TABLE `autoresponder` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `autoresponderemailmessagecontent` -- DROP TABLE IF EXISTS `autoresponderemailmessagecontent`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `autoresponderemailmessagecontent` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `htmlcontent` text COLLATE utf8_unicode_ci, `textcontent` text COLLATE utf8_unicode_ci, `item_id` int(11) unsigned DEFAULT NULL, `autoresponder_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `autoresponderemailmessagecontent` -- LOCK TABLES `autoresponderemailmessagecontent` WRITE; /*!40000 ALTER TABLE `autoresponderemailmessagecontent` DISABLE KEYS */; /*!40000 ALTER TABLE `autoresponderemailmessagecontent` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `autoresponderitem` -- DROP TABLE IF EXISTS `autoresponderitem`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `autoresponderitem` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `processdatetime` datetime DEFAULT NULL, `processed` tinyint(1) unsigned DEFAULT NULL, `contact_id` int(11) unsigned DEFAULT NULL, `emailmessage_id` int(11) unsigned DEFAULT NULL, `autoresponder_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `autoresponderitem` -- LOCK TABLES `autoresponderitem` WRITE; /*!40000 ALTER TABLE `autoresponderitem` DISABLE KEYS */; /*!40000 ALTER TABLE `autoresponderitem` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `autoresponderitemactivity` -- DROP TABLE IF EXISTS `autoresponderitemactivity`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `autoresponderitemactivity` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `emailmessageactivity_id` int(11) unsigned DEFAULT NULL, `autoresponderitem_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `emailmessageactivity_id_autoresponderitem_id` (`emailmessageactivity_id`,`autoresponderitem_id`), KEY `emailmessageactivity_id` (`emailmessageactivity_id`), KEY `autoresponderitem_id` (`autoresponderitem_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `autoresponderitemactivity` -- LOCK TABLES `autoresponderitemactivity` WRITE; /*!40000 ALTER TABLE `autoresponderitemactivity` DISABLE KEYS */; /*!40000 ALTER TABLE `autoresponderitemactivity` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `basecustomfield` -- DROP TABLE IF EXISTS `basecustomfield`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `basecustomfield` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `data_customfielddata_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `basecustomfield` -- LOCK TABLES `basecustomfield` WRITE; /*!40000 ALTER TABLE `basecustomfield` DISABLE KEYS */; /*!40000 ALTER TABLE `basecustomfield` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `basestarredmodel` -- DROP TABLE IF EXISTS `basestarredmodel`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `basestarredmodel` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `_user_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `basestarredmodel` -- LOCK TABLES `basestarredmodel` WRITE; /*!40000 ALTER TABLE `basestarredmodel` DISABLE KEYS */; /*!40000 ALTER TABLE `basestarredmodel` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `bytimeworkflowinqueue` -- DROP TABLE IF EXISTS `bytimeworkflowinqueue`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `bytimeworkflowinqueue` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `modelclassname` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `processdatetime` datetime DEFAULT NULL, `item_id` int(11) unsigned DEFAULT NULL, `modelitem_item_id` int(11) unsigned DEFAULT NULL, `savedworkflow_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `bytimeworkflowinqueue` -- LOCK TABLES `bytimeworkflowinqueue` WRITE; /*!40000 ALTER TABLE `bytimeworkflowinqueue` DISABLE KEYS */; /*!40000 ALTER TABLE `bytimeworkflowinqueue` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `calculatedderivedattributemetadata` -- DROP TABLE IF EXISTS `calculatedderivedattributemetadata`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `calculatedderivedattributemetadata` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `derivedattributemetadata_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `calculatedderivedattributemetadata` -- LOCK TABLES `calculatedderivedattributemetadata` WRITE; /*!40000 ALTER TABLE `calculatedderivedattributemetadata` DISABLE KEYS */; /*!40000 ALTER TABLE `calculatedderivedattributemetadata` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `campaign` -- DROP TABLE IF EXISTS `campaign`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `campaign` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `status` int(11) DEFAULT NULL, `supportsrichtext` tinyint(1) unsigned DEFAULT NULL, `sendondatetime` datetime DEFAULT NULL, `fromname` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `fromaddress` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `htmlcontent` text COLLATE utf8_unicode_ci, `textcontent` text COLLATE utf8_unicode_ci, `enabletracking` tinyint(1) unsigned DEFAULT NULL, `ownedsecurableitem_id` int(11) unsigned DEFAULT NULL, `marketinglist_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `campaign` -- LOCK TABLES `campaign` WRITE; /*!40000 ALTER TABLE `campaign` DISABLE KEYS */; /*!40000 ALTER TABLE `campaign` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `campaign_read` -- DROP TABLE IF EXISTS `campaign_read`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `campaign_read` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `securableitem_id` int(11) unsigned NOT NULL, `munge_id` varchar(12) COLLATE utf8_unicode_ci NOT NULL, `count` int(8) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `securableitem_id_munge_id` (`securableitem_id`,`munge_id`), KEY `campaign_read_securableitem_id` (`securableitem_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `campaign_read` -- LOCK TABLES `campaign_read` WRITE; /*!40000 ALTER TABLE `campaign_read` DISABLE KEYS */; /*!40000 ALTER TABLE `campaign_read` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `campaignemailmessagecontent` -- DROP TABLE IF EXISTS `campaignemailmessagecontent`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `campaignemailmessagecontent` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `htmlcontent` text COLLATE utf8_unicode_ci, `textcontent` text COLLATE utf8_unicode_ci, `item_id` int(11) unsigned DEFAULT NULL, `campaign_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `campaignemailmessagecontent` -- LOCK TABLES `campaignemailmessagecontent` WRITE; /*!40000 ALTER TABLE `campaignemailmessagecontent` DISABLE KEYS */; /*!40000 ALTER TABLE `campaignemailmessagecontent` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `campaignitem` -- DROP TABLE IF EXISTS `campaignitem`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `campaignitem` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `processed` tinyint(1) unsigned DEFAULT NULL, `contact_id` int(11) unsigned DEFAULT NULL, `emailmessage_id` int(11) unsigned DEFAULT NULL, `campaign_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `campaign_id` (`campaign_id`), KEY `contact_id` (`contact_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `campaignitem` -- LOCK TABLES `campaignitem` WRITE; /*!40000 ALTER TABLE `campaignitem` DISABLE KEYS */; /*!40000 ALTER TABLE `campaignitem` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `campaignitemactivity` -- DROP TABLE IF EXISTS `campaignitemactivity`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `campaignitemactivity` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `emailmessageactivity_id` int(11) unsigned DEFAULT NULL, `campaignitem_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `emailmessageactivity_id_campaignitem_id` (`emailmessageactivity_id`,`campaignitem_id`), KEY `emailmessageactivity_id` (`emailmessageactivity_id`), KEY `campaignitem_id` (`campaignitem_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `campaignitemactivity` -- LOCK TABLES `campaignitemactivity` WRITE; /*!40000 ALTER TABLE `campaignitemactivity` DISABLE KEYS */; /*!40000 ALTER TABLE `campaignitemactivity` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `comment` -- DROP TABLE IF EXISTS `comment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `comment` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `description` text COLLATE utf8_unicode_ci, `item_id` int(11) unsigned DEFAULT NULL, `relatedmodel_id` int(11) unsigned DEFAULT NULL, `relatedmodel_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `comment` -- LOCK TABLES `comment` WRITE; /*!40000 ALTER TABLE `comment` DISABLE KEYS */; /*!40000 ALTER TABLE `comment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contact` -- DROP TABLE IF EXISTS `contact`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contact` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `companyname` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `description` text COLLATE utf8_unicode_ci, `latestactivitydatetime` datetime DEFAULT NULL, `website` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `googlewebtrackingid` text COLLATE utf8_unicode_ci, `twitterid` text COLLATE utf8_unicode_ci, `facebookid` text COLLATE utf8_unicode_ci, `person_id` int(11) unsigned DEFAULT NULL, `account_id` int(11) unsigned DEFAULT NULL, `industry_customfield_id` int(11) unsigned DEFAULT NULL, `secondaryaddress_address_id` int(11) unsigned DEFAULT NULL, `secondaryemail_email_id` int(11) unsigned DEFAULT NULL, `source_customfield_id` int(11) unsigned DEFAULT NULL, `state_contactstate_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `person_id` (`person_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contact` -- LOCK TABLES `contact` WRITE; /*!40000 ALTER TABLE `contact` DISABLE KEYS */; /*!40000 ALTER TABLE `contact` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contact_opportunity` -- DROP TABLE IF EXISTS `contact_opportunity`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contact_opportunity` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `contact_id` int(11) unsigned DEFAULT NULL, `opportunity_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_di_ytinutroppo_di_tcatnoc` (`contact_id`,`opportunity_id`), KEY `di_tcatnoc` (`contact_id`), KEY `di_ytinutroppo` (`opportunity_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contact_opportunity` -- LOCK TABLES `contact_opportunity` WRITE; /*!40000 ALTER TABLE `contact_opportunity` DISABLE KEYS */; /*!40000 ALTER TABLE `contact_opportunity` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contact_project` -- DROP TABLE IF EXISTS `contact_project`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contact_project` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `contact_id` int(11) unsigned DEFAULT NULL, `project_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_di_tcejorp_di_tcatnoc` (`contact_id`,`project_id`), KEY `di_tcatnoc` (`contact_id`), KEY `di_tcejorp` (`project_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contact_project` -- LOCK TABLES `contact_project` WRITE; /*!40000 ALTER TABLE `contact_project` DISABLE KEYS */; /*!40000 ALTER TABLE `contact_project` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contact_read` -- DROP TABLE IF EXISTS `contact_read`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contact_read` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `securableitem_id` int(11) unsigned NOT NULL, `munge_id` varchar(12) COLLATE utf8_unicode_ci NOT NULL, `count` int(8) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `securableitem_id_munge_id` (`securableitem_id`,`munge_id`), KEY `contact_read_securableitem_id` (`securableitem_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contact_read` -- LOCK TABLES `contact_read` WRITE; /*!40000 ALTER TABLE `contact_read` DISABLE KEYS */; /*!40000 ALTER TABLE `contact_read` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contact_read_subscription` -- DROP TABLE IF EXISTS `contact_read_subscription`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contact_read_subscription` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `userid` int(11) unsigned NOT NULL, `modelid` int(11) unsigned NOT NULL, `modifieddatetime` datetime DEFAULT NULL, `subscriptiontype` tinyint(4) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `userid_modelid` (`userid`,`modelid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contact_read_subscription` -- LOCK TABLES `contact_read_subscription` WRITE; /*!40000 ALTER TABLE `contact_read_subscription` DISABLE KEYS */; /*!40000 ALTER TABLE `contact_read_subscription` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contactstarred` -- DROP TABLE IF EXISTS `contactstarred`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contactstarred` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `basestarredmodel_id` int(11) unsigned DEFAULT NULL, `contact_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `basestarredmodel_id_contact_id` (`basestarredmodel_id`,`contact_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contactstarred` -- LOCK TABLES `contactstarred` WRITE; /*!40000 ALTER TABLE `contactstarred` DISABLE KEYS */; /*!40000 ALTER TABLE `contactstarred` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contactstate` -- DROP TABLE IF EXISTS `contactstate`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contactstate` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `order` int(11) DEFAULT NULL, `serializedlabels` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contactstate` -- LOCK TABLES `contactstate` WRITE; /*!40000 ALTER TABLE `contactstate` DISABLE KEYS */; INSERT INTO `contactstate` VALUES (1,'New',0,NULL),(2,'In Progress',1,NULL),(3,'Recycled',2,NULL),(4,'Dead',3,NULL),(5,'Qualified',4,NULL),(6,'Customer',5,NULL); /*!40000 ALTER TABLE `contactstate` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contactwebform` -- DROP TABLE IF EXISTS `contactwebform`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contactwebform` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` text COLLATE utf8_unicode_ci, `redirecturl` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `submitbuttonlabel` text COLLATE utf8_unicode_ci, `serializeddata` text COLLATE utf8_unicode_ci, `excludestyles` tinyint(1) unsigned DEFAULT NULL, `enablecaptcha` tinyint(1) unsigned DEFAULT NULL, `language` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `defaultpermissionsetting` tinyint(11) DEFAULT NULL, `defaultpermissiongroupsetting` int(11) DEFAULT NULL, `ownedsecurableitem_id` int(11) unsigned DEFAULT NULL, `defaultstate_contactstate_id` int(11) unsigned DEFAULT NULL, `defaultowner__user_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contactwebform` -- LOCK TABLES `contactwebform` WRITE; /*!40000 ALTER TABLE `contactwebform` DISABLE KEYS */; /*!40000 ALTER TABLE `contactwebform` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contactwebform_read` -- DROP TABLE IF EXISTS `contactwebform_read`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contactwebform_read` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `securableitem_id` int(11) unsigned NOT NULL, `munge_id` varchar(12) COLLATE utf8_unicode_ci NOT NULL, `count` int(8) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `securableitem_id_munge_id` (`securableitem_id`,`munge_id`), KEY `contactwebform_read_securableitem_id` (`securableitem_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contactwebform_read` -- LOCK TABLES `contactwebform_read` WRITE; /*!40000 ALTER TABLE `contactwebform_read` DISABLE KEYS */; /*!40000 ALTER TABLE `contactwebform_read` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `contactwebformentry` -- DROP TABLE IF EXISTS `contactwebformentry`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `contactwebformentry` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `serializeddata` text COLLATE utf8_unicode_ci, `status` int(11) DEFAULT NULL, `message` text COLLATE utf8_unicode_ci, `hashindex` text COLLATE utf8_unicode_ci, `item_id` int(11) unsigned DEFAULT NULL, `contact_id` int(11) unsigned DEFAULT NULL, `entries_contactwebform_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `contactwebformentry` -- LOCK TABLES `contactwebformentry` WRITE; /*!40000 ALTER TABLE `contactwebformentry` DISABLE KEYS */; /*!40000 ALTER TABLE `contactwebformentry` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `conversation` -- DROP TABLE IF EXISTS `conversation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `conversation` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `description` text COLLATE utf8_unicode_ci, `latestdatetime` datetime DEFAULT NULL, `subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `ownerhasreadlatest` tinyint(1) unsigned DEFAULT NULL, `isclosed` tinyint(1) unsigned DEFAULT NULL, `ownedsecurableitem_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `conversation` -- LOCK TABLES `conversation` WRITE; /*!40000 ALTER TABLE `conversation` DISABLE KEYS */; /*!40000 ALTER TABLE `conversation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `conversation_item` -- DROP TABLE IF EXISTS `conversation_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `conversation_item` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `conversation_id` int(11) unsigned DEFAULT NULL, `item_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_di_meti_di_noitasrevnoc` (`conversation_id`,`item_id`), KEY `di_noitasrevnoc` (`conversation_id`), KEY `di_meti` (`item_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `conversation_item` -- LOCK TABLES `conversation_item` WRITE; /*!40000 ALTER TABLE `conversation_item` DISABLE KEYS */; /*!40000 ALTER TABLE `conversation_item` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `conversation_read` -- DROP TABLE IF EXISTS `conversation_read`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `conversation_read` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `securableitem_id` int(11) unsigned NOT NULL, `munge_id` varchar(12) COLLATE utf8_unicode_ci NOT NULL, `count` int(8) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `securableitem_id_munge_id` (`securableitem_id`,`munge_id`), KEY `conversation_read_securableitem_id` (`securableitem_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `conversation_read` -- LOCK TABLES `conversation_read` WRITE; /*!40000 ALTER TABLE `conversation_read` DISABLE KEYS */; /*!40000 ALTER TABLE `conversation_read` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `conversationparticipant` -- DROP TABLE IF EXISTS `conversationparticipant`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `conversationparticipant` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `hasreadlatest` tinyint(1) unsigned DEFAULT NULL, `person_item_id` int(11) unsigned DEFAULT NULL, `conversation_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `conversationparticipant` -- LOCK TABLES `conversationparticipant` WRITE; /*!40000 ALTER TABLE `conversationparticipant` DISABLE KEYS */; /*!40000 ALTER TABLE `conversationparticipant` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `conversationstarred` -- DROP TABLE IF EXISTS `conversationstarred`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `conversationstarred` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `basestarredmodel_id` int(11) unsigned DEFAULT NULL, `conversation_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `basestarredmodel_id_conversation_id` (`basestarredmodel_id`,`conversation_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `conversationstarred` -- LOCK TABLES `conversationstarred` WRITE; /*!40000 ALTER TABLE `conversationstarred` DISABLE KEYS */; /*!40000 ALTER TABLE `conversationstarred` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `currency` -- DROP TABLE IF EXISTS `currency`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `currency` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `active` tinyint(1) unsigned DEFAULT NULL, `code` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL, `ratetobase` double DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_edoc` (`code`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `currency` -- LOCK TABLES `currency` WRITE; /*!40000 ALTER TABLE `currency` DISABLE KEYS */; INSERT INTO `currency` VALUES (1,1,'USD',1); /*!40000 ALTER TABLE `currency` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `currencyvalue` -- DROP TABLE IF EXISTS `currencyvalue`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `currencyvalue` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `ratetobase` double DEFAULT NULL, `value` double DEFAULT NULL, `currency_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `currencyvalue` -- LOCK TABLES `currencyvalue` WRITE; /*!40000 ALTER TABLE `currencyvalue` DISABLE KEYS */; /*!40000 ALTER TABLE `currencyvalue` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customfield` -- DROP TABLE IF EXISTS `customfield`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `customfield` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `value` text COLLATE utf8_unicode_ci, `basecustomfield_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customfield` -- LOCK TABLES `customfield` WRITE; /*!40000 ALTER TABLE `customfield` DISABLE KEYS */; /*!40000 ALTER TABLE `customfield` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customfielddata` -- DROP TABLE IF EXISTS `customfielddata`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `customfielddata` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `defaultvalue` text COLLATE utf8_unicode_ci, `serializeddata` text COLLATE utf8_unicode_ci, `serializedlabels` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`), UNIQUE KEY `unique_eman` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customfielddata` -- LOCK TABLES `customfielddata` WRITE; /*!40000 ALTER TABLE `customfielddata` DISABLE KEYS */; INSERT INTO `customfielddata` VALUES (1,'AccountContactAffiliationRoles',NULL,'a:6:{i:0;s:7:\"Billing\";i:1;s:8:\"Shipping\";i:2;s:7:\"Support\";i:3;s:9:\"Technical\";i:4;s:14:\"Administrative\";i:5;s:15:\"Project Manager\";}',NULL),(2,'Industries',NULL,'a:9:{i:0;s:10:\"Automotive\";i:1;s:7:\"Banking\";i:2;s:17:\"Business Services\";i:3;s:6:\"Energy\";i:4;s:18:\"Financial Services\";i:5;s:9:\"Insurance\";i:6;s:13:\"Manufacturing\";i:7;s:6:\"Retail\";i:8;s:10:\"Technology\";}',NULL),(3,'AccountTypes',NULL,'a:3:{i:0;s:8:\"Prospect\";i:1;s:8:\"Customer\";i:2;s:6:\"Vendor\";}',NULL),(4,'LeadSources',NULL,'a:4:{i:0;s:14:\"Self-Generated\";i:1;s:12:\"Inbound Call\";i:2;s:9:\"Tradeshow\";i:3;s:13:\"Word of Mouth\";}',NULL),(5,'MeetingCategories','Meeting','a:2:{i:0;s:7:\"Meeting\";i:1;s:4:\"Call\";}',NULL),(6,'SalesStages','Prospecting','a:6:{i:0;s:11:\"Prospecting\";i:1;s:13:\"Qualification\";i:2;s:11:\"Negotiating\";i:3;s:6:\"Verbal\";i:4;s:10:\"Closed Won\";i:5;s:11:\"Closed Lost\";}',NULL),(7,'ProductStages',NULL,'a:3:{i:0;s:4:\"Open\";i:1;s:4:\"Lost\";i:2;s:3:\"Won\";}',NULL),(8,'Titles',NULL,'a:4:{i:0;s:3:\"Mr.\";i:1;s:4:\"Mrs.\";i:2;s:3:\"Ms.\";i:3;s:3:\"Dr.\";}',NULL); /*!40000 ALTER TABLE `customfielddata` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customfieldvalue` -- DROP TABLE IF EXISTS `customfieldvalue`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `customfieldvalue` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `multiplevaluescustomfield_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `multiplevaluescustomfield_id` (`multiplevaluescustomfield_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customfieldvalue` -- LOCK TABLES `customfieldvalue` WRITE; /*!40000 ALTER TABLE `customfieldvalue` DISABLE KEYS */; /*!40000 ALTER TABLE `customfieldvalue` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dashboard` -- DROP TABLE IF EXISTS `dashboard`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dashboard` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `isdefault` tinyint(1) unsigned DEFAULT NULL, `layoutid` int(11) DEFAULT NULL, `layouttype` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL, `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `ownedsecurableitem_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dashboard` -- LOCK TABLES `dashboard` WRITE; /*!40000 ALTER TABLE `dashboard` DISABLE KEYS */; /*!40000 ALTER TABLE `dashboard` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `derivedattributemetadata` -- DROP TABLE IF EXISTS `derivedattributemetadata`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `derivedattributemetadata` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `modelclassname` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `serializedmetadata` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `derivedattributemetadata` -- LOCK TABLES `derivedattributemetadata` WRITE; /*!40000 ALTER TABLE `derivedattributemetadata` DISABLE KEYS */; /*!40000 ALTER TABLE `derivedattributemetadata` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dropdowndependencyderivedattributemetadata` -- DROP TABLE IF EXISTS `dropdowndependencyderivedattributemetadata`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dropdowndependencyderivedattributemetadata` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `derivedattributemetadata_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dropdowndependencyderivedattributemetadata` -- LOCK TABLES `dropdowndependencyderivedattributemetadata` WRITE; /*!40000 ALTER TABLE `dropdowndependencyderivedattributemetadata` DISABLE KEYS */; /*!40000 ALTER TABLE `dropdowndependencyderivedattributemetadata` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `email` -- DROP TABLE IF EXISTS `email`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `email` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `emailaddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `isinvalid` tinyint(1) unsigned DEFAULT NULL, `optout` tinyint(1) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `email` -- LOCK TABLES `email` WRITE; /*!40000 ALTER TABLE `email` DISABLE KEYS */; /*!40000 ALTER TABLE `email` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailaccount` -- DROP TABLE IF EXISTS `emailaccount`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emailaccount` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `fromname` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `fromaddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `name` text COLLATE utf8_unicode_ci, `replytoname` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `outboundhost` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `outboundusername` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `outboundpassword` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `outboundsecurity` varchar(3) COLLATE utf8_unicode_ci DEFAULT NULL, `outboundtype` varchar(4) COLLATE utf8_unicode_ci DEFAULT NULL, `outboundport` int(11) DEFAULT NULL, `usecustomoutboundsettings` int(11) DEFAULT NULL, `replytoaddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `item_id` int(11) unsigned DEFAULT NULL, `_user_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailaccount` -- LOCK TABLES `emailaccount` WRITE; /*!40000 ALTER TABLE `emailaccount` DISABLE KEYS */; /*!40000 ALTER TABLE `emailaccount` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailbox` -- DROP TABLE IF EXISTS `emailbox`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emailbox` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `item_id` int(11) unsigned DEFAULT NULL, `_user_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailbox` -- LOCK TABLES `emailbox` WRITE; /*!40000 ALTER TABLE `emailbox` DISABLE KEYS */; /*!40000 ALTER TABLE `emailbox` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailfolder` -- DROP TABLE IF EXISTS `emailfolder`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emailfolder` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `item_id` int(11) unsigned DEFAULT NULL, `emailbox_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailfolder` -- LOCK TABLES `emailfolder` WRITE; /*!40000 ALTER TABLE `emailfolder` DISABLE KEYS */; /*!40000 ALTER TABLE `emailfolder` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailmessage` -- DROP TABLE IF EXISTS `emailmessage`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emailmessage` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `sendattempts` int(11) DEFAULT NULL, `sentdatetime` datetime DEFAULT NULL, `sendondatetime` datetime DEFAULT NULL, `headers` text COLLATE utf8_unicode_ci, `mailertype` text COLLATE utf8_unicode_ci, `mailersettings` text COLLATE utf8_unicode_ci, `contenttype` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `ownedsecurableitem_id` int(11) unsigned DEFAULT NULL, `folder_emailfolder_id` int(11) unsigned DEFAULT NULL, `content_emailmessagecontent_id` int(11) unsigned DEFAULT NULL, `sender_emailmessagesender_id` int(11) unsigned DEFAULT NULL, `error_emailmessagesenderror_id` int(11) unsigned DEFAULT NULL, `account_emailaccount_id` int(11) unsigned DEFAULT NULL, `sendgridaccount_sendgridemailaccount_id` int(11) unsigned DEFAULT NULL, `contact_contact_id` int(11) unsigned DEFAULT NULL, `campaigncontent_campaignemailmessagecontent_id` int(11) unsigned DEFAULT NULL, `autorespondercontent_autoresponderemailmessagecontent_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailmessage` -- LOCK TABLES `emailmessage` WRITE; /*!40000 ALTER TABLE `emailmessage` DISABLE KEYS */; /*!40000 ALTER TABLE `emailmessage` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailmessage_read` -- DROP TABLE IF EXISTS `emailmessage_read`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emailmessage_read` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `securableitem_id` int(11) unsigned NOT NULL, `munge_id` varchar(12) COLLATE utf8_unicode_ci NOT NULL, `count` int(8) unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `securableitem_id_munge_id` (`securableitem_id`,`munge_id`), KEY `emailmessage_read_securableitem_id` (`securableitem_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailmessage_read` -- LOCK TABLES `emailmessage_read` WRITE; /*!40000 ALTER TABLE `emailmessage_read` DISABLE KEYS */; /*!40000 ALTER TABLE `emailmessage_read` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailmessageactivity` -- DROP TABLE IF EXISTS `emailmessageactivity`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emailmessageactivity` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `latestdatetime` datetime DEFAULT NULL, `type` int(11) DEFAULT NULL, `quantity` int(11) DEFAULT NULL, `latestsourceip` text COLLATE utf8_unicode_ci, `item_id` int(11) unsigned DEFAULT NULL, `person_id` int(11) unsigned DEFAULT NULL, `emailmessageurl_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailmessageactivity` -- LOCK TABLES `emailmessageactivity` WRITE; /*!40000 ALTER TABLE `emailmessageactivity` DISABLE KEYS */; /*!40000 ALTER TABLE `emailmessageactivity` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailmessagecontactvariablecontent` -- DROP TABLE IF EXISTS `emailmessagecontactvariablecontent`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emailmessagecontactvariablecontent` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `serializedcontent` text COLLATE utf8_unicode_ci, `item_id` int(11) unsigned DEFAULT NULL, `contact_contact_id` int(11) unsigned DEFAULT NULL, `emailmessage_emailmessage_id` int(11) unsigned DEFAULT NULL, `campaign_campaign_id` int(11) unsigned DEFAULT NULL, `autoresponder_autoresponder_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailmessagecontactvariablecontent` -- LOCK TABLES `emailmessagecontactvariablecontent` WRITE; /*!40000 ALTER TABLE `emailmessagecontactvariablecontent` DISABLE KEYS */; /*!40000 ALTER TABLE `emailmessagecontactvariablecontent` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailmessagecontent` -- DROP TABLE IF EXISTS `emailmessagecontent`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emailmessagecontent` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `htmlcontent` text COLLATE utf8_unicode_ci, `textcontent` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailmessagecontent` -- LOCK TABLES `emailmessagecontent` WRITE; /*!40000 ALTER TABLE `emailmessagecontent` DISABLE KEYS */; /*!40000 ALTER TABLE `emailmessagecontent` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailmessagerecipient` -- DROP TABLE IF EXISTS `emailmessagerecipient`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emailmessagerecipient` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `toaddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `toname` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `type` int(11) DEFAULT NULL, `emailmessage_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `remailmessage` (`emailmessage_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailmessagerecipient` -- LOCK TABLES `emailmessagerecipient` WRITE; /*!40000 ALTER TABLE `emailmessagerecipient` DISABLE KEYS */; /*!40000 ALTER TABLE `emailmessagerecipient` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailmessagerecipient_item` -- DROP TABLE IF EXISTS `emailmessagerecipient_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emailmessagerecipient_item` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `emailmessagerecipient_id` int(11) unsigned DEFAULT NULL, `item_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_di_meti_di_tneipiceregassemliame` (`emailmessagerecipient_id`,`item_id`), KEY `di_tneipiceregassemliame` (`emailmessagerecipient_id`), KEY `di_meti` (`item_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailmessagerecipient_item` -- LOCK TABLES `emailmessagerecipient_item` WRITE; /*!40000 ALTER TABLE `emailmessagerecipient_item` DISABLE KEYS */; /*!40000 ALTER TABLE `emailmessagerecipient_item` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailmessagesender` -- DROP TABLE IF EXISTS `emailmessagesender`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emailmessagesender` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `fromaddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `fromname` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailmessagesender` -- LOCK TABLES `emailmessagesender` WRITE; /*!40000 ALTER TABLE `emailmessagesender` DISABLE KEYS */; /*!40000 ALTER TABLE `emailmessagesender` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailmessagesender_item` -- DROP TABLE IF EXISTS `emailmessagesender_item`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emailmessagesender_item` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `emailmessagesender_id` int(11) unsigned DEFAULT NULL, `item_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `unique_di_meti_di_rednesegassemliame` (`emailmessagesender_id`,`item_id`), KEY `di_rednesegassemliame` (`emailmessagesender_id`), KEY `di_meti` (`item_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailmessagesender_item` -- LOCK TABLES `emailmessagesender_item` WRITE; /*!40000 ALTER TABLE `emailmessagesender_item` DISABLE KEYS */; /*!40000 ALTER TABLE `emailmessagesender_item` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailmessagesenderror` -- DROP TABLE IF EXISTS `emailmessagesenderror`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emailmessagesenderror` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `createddatetime` datetime DEFAULT NULL, `serializeddata` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailmessagesenderror` -- LOCK TABLES `emailmessagesenderror` WRITE; /*!40000 ALTER TABLE `emailmessagesenderror` DISABLE KEYS */; /*!40000 ALTER TABLE `emailmessagesenderror` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailmessageurl` -- DROP TABLE IF EXISTS `emailmessageurl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emailmessageurl` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `emailmessageactivity_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailmessageurl` -- LOCK TABLES `emailmessageurl` WRITE; /*!40000 ALTER TABLE `emailmessageurl` DISABLE KEYS */; /*!40000 ALTER TABLE `emailmessageurl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailsignature` -- DROP TABLE IF EXISTS `emailsignature`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emailsignature` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `textcontent` text COLLATE utf8_unicode_ci, `htmlcontent` text COLLATE utf8_unicode_ci, `_user_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailsignature` -- LOCK TABLES `emailsignature` WRITE; /*!40000 ALTER TABLE `emailsignature` DISABLE KEYS */; /*!40000 ALTER TABLE `emailsignature` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `emailtemplate` -- DROP TABLE IF EXISTS `emailtemplate`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `emailtemplate` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `type` int(11) DEFAULT NULL, `isdraft` tinyint(1) unsigned DEFAULT NULL, `builttype` int(11) DEFAULT NULL, `modelclassname` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `language` varchar(2) COLLATE utf8_unicode_ci DEFAULT NULL, `htmlcontent` text COLLATE utf8_unicode_ci, `textcontent` text COLLATE utf8_unicode_ci, `serializeddata` text COLLATE utf8_unicode_ci, `isfeatured` tinyint(1) unsigned DEFAULT NULL, `ownedsecurableitem_id` int(11) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `emailtemplate` -- LOCK TABLES `emailtemplate` WRITE; /*!40000 ALTER TABLE `emailtemplate` DISABLE KEYS */; INSERT INTO `emailtemplate` VALUES (1,NULL,0,3,NULL,'Blank','Blank','en',NULL,NULL,'{\"baseTemplateId\":\"\",\"icon\":\"icon-template-0\",\"dom\":{\"canvas1\":{\"content\":{\"builderrowelement_1393965668_53163a6448794\":{\"content\":{\"buildercolumnelement_1393965668_53163a644866d\":{\"content\":[],\"properties\":[],\"class\":\"BuilderColumnElement\"}},\"properties\":{\"backend\":{\"configuration\":\"1\"}},\"class\":\"BuilderRowElement\"}},\"properties\":{\"frontend\":{\"inlineStyles\":{\"background-color\":\"#ffffff\",\"color\":\"#545454\"}}},\"class\":\"BuilderCanvasElement\"}}}',NULL,1),(2,NULL,0,3,NULL,'1 Column','1 Column','en',NULL,NULL,'{\"baseTemplateId\":\"\",\"icon\":\"icon-template-5\",\"dom\":{\"canvas1\":{\"content\":{\"builderheaderimagetextelement_1393965594_53163a1a0eb53\":{\"content\":{\"buildercolumnelement_1393965594_53163a1a0ef48\":{\"content\":{\"builderimageelement_1393965594_53163a1a0ee52\":{\"content\":{\"image\":1},\"properties\":[],\"class\":\"BuilderImageElement\"}},\"properties\":[],\"class\":\"BuilderColumnElement\"},\"buildercolumnelement_1393965594_53163a1a145cc\":{\"content\":{\"builderheadertextelement_1393965594_53163a1a14515\":{\"content\":{\"text\":\"Acme Inc. Newsletter\"},\"properties\":{\"frontend\":{\"inlineStyles\":{\"color\":\"#ffffff\",\"font-weight\":\"bold\",\"text-align\":\"right\"}}},\"class\":\"BuilderHeaderTextElement\"}},\"properties\":[],\"class\":\"BuilderColumnElement\"}},\"properties\":{\"backend\":{\"configuration\":\"1:2\",\"header\":\"1\"},\"frontend\":{\"inlineStyles\":{\"background-color\":\"#282a76\"}}},\"class\":\"BuilderHeaderImageTextElement\"},\"builderrowelement_1393965668_53163a6448794\":{\"content\":{\"buildercolumnelement_1393965668_53163a644866d\":{\"content\":{\"buildertitleelement_1393965668_53163a6447762\":{\"content\":{\"text\":\"Hello there William S...\"},\"properties\":{\"backend\":{\"headingLevel\":\"h3\"},\"frontend\":{\"inlineStyles\":{\"color\":\"#666666\",\"font-size\":\"24\",\"font-weight\":\"bold\",\"text-align\":\"center\"}}},\"class\":\"BuilderTitleElement\"},\"builderimageelement_1393970522_53164d5a3787a\":{\"content\":{\"image\":3},\"properties\":[],\"class\":\"BuilderImageElement\"},\"builderexpanderelement_1393970557_53164d7d2881e\":{\"content\":[],\"properties\":{\"frontend\":{\"height\":\"10\"}},\"class\":\"BuilderExpanderElement\"},\"buildertextelement_1393965781_53163ad53b77c\":{\"content\":{\"text\":\"\\n

\\n Orsino, the Duke of Illyria<\\/i>, is consumed by his passion for the melancholy Countess Olivia. His ostentatious musings on the nature of love begin with what has become one of Shakespeare\'s most famous lines: \\\"If music be the food of love, play on.\\\" It is apparent that Orsino\'s love is hollow. He is a romantic dreamer, for whom the idea of being in love is most important. When Valentine gives him the terrible news that Olivia<\\/b> plans to seclude herself for seven years to mourn her deceased brother, Orsino seems unfazed, and hopes Olivia may one day be as bewitched by love (the one self king) as he. Fittingly, the scene ends with Orsino off to lay in a bed of flowers, where he can be alone with his love-thoughts. Later in the play it will be up to Viola to teach Orsino the true meaning of love.\\n<\\/p>\\n\"},\"properties\":[],\"class\":\"BuilderTextElement\"},\"builderbuttonelement_1393965942_53163b76e666c\":{\"content\":[],\"properties\":{\"backend\":{\"text\":\"Call Me\",\"sizeClass\":\"medium-button\",\"align\":\"left\"},\"frontend\":{\"href\":\"http:\\/\\/localhost\\/Zurmo\\/app\\/index.php\",\"target\":\"_blank\",\"inlineStyles\":{\"background-color\":\"#97c43d\",\"border-color\":\"#7cb830\"}}},\"class\":\"BuilderButtonElement\"},\"builderdividerelement_1393965948_53163b7cb98ae\":{\"content\":[],\"properties\":{\"frontend\":{\"inlineStyles\":{\"border-top-width\":\"1\",\"border-top-style\":\"solid\",\"border-top-color\":\"#cccccc\"}},\"backend\":{\"divider-padding\":\"10\"}},\"class\":\"BuilderDividerElement\"},\"buildersocialelement_1394060039_5317ab07cf03d\":{\"content\":[],\"properties\":{\"backend\":{\"layout\":\"vertical\",\"services\":{\"Twitter\":{\"enabled\":\"1\",\"url\":\"http:\\/\\/www.twitter.com\\/\"},\"Facebook\":{\"enabled\":\"1\",\"url\":\"http:\\/\\/www.facebook.com\\/\"},\"GooglePlus\":{\"enabled\":\"1\",\"url\":\"http:\\/\\/gplus.com\"}}}},\"class\":\"BuilderSocialElement\"},\"builderexpanderelement_1393970592_53164da0bd137\":{\"content\":[],\"properties\":{\"frontend\":{\"height\":\"10\"}},\"class\":\"BuilderExpanderElement\"},\"builderfooterelement_1393966090_53163c0ac51bd\":{\"content\":{\"text\":\"[[GLOBAL^MARKETING^FOOTER^HTML]]\"},\"properties\":{\"frontend\":{\"inlineStyles\":{\"background-color\":\"#efefef\",\"font-size\":\"10\"}}},\"class\":\"BuilderFooterElement\"}},\"properties\":[],\"class\":\"BuilderColumnElement\"}},\"properties\":[],\"class\":\"BuilderRowElement\"}},\"properties\":{\"frontend\":{\"inlineStyles\":{\"background-color\":\"#ffffff\",\"color\":\"#545454\"}}},\"class\":\"BuilderCanvasElement\"}}}',NULL,2),(3,NULL,0,3,NULL,'2 Columns','2 Columns','en',NULL,NULL,'{\"baseTemplateId\":\"\",\"icon\":\"icon-template-2\",\"dom\":{\"canvas1\":{\"content\":{\"builderheaderimagetextelement_1393965594_53163a1a0eb53\":{\"content\":{\"buildercolumnelement_1393965594_53163a1a0ef48\":{\"content\":{\"builderimageelement_1393965594_53163a1a0ee52\":{\"content\":{\"image\":1},\"properties\":[],\"class\":\"BuilderImageElement\"}},\"properties\":[],\"class\":\"BuilderColumnElement\"},\"buildercolumnelement_1393965594_53163a1a145cc\":{\"content\":{\"builderheadertextelement_1393965594_53163a1a14515\":{\"content\":{\"text\":\"Acme Inc. Newsletter\"},\"properties\":{\"frontend\":{\"inlineStyles\":{\"color\":\"#ffffff\",\"font-weight\":\"bold\",\"text-align\":\"right\"}}},\"class\":\"BuilderHeaderTextElement\"}},\"properties\":[],\"class\":\"BuilderColumnElement\"}},\"properties\":{\"backend\":{\"configuration\":\"1:2\",\"header\":\"1\"},\"frontend\":{\"inlineStyles\":{\"background-color\":\"#282a76\"}}},\"class\":\"BuilderHeaderImageTextElement\"},\"builderrowelement_1394062546_5317b4d264a62\":{\"content\":{\"buildercolumnelement_1394062546_5317b4d26488b\":{\"content\":{\"buildertitleelement_1394062546_5317b4d263942\":{\"content\":{\"text\":\"Hello there William S...\"},\"properties\":{\"backend\":{\"headingLevel\":\"h1\"},\"frontend\":{\"inlineStyles\":{\"color\":\"#666666\",\"font-size\":\"28\",\"font-weight\":\"bold\",\"line-height\":\"200\"}}},\"class\":\"BuilderTitleElement\"}},\"properties\":[],\"class\":\"BuilderColumnElement\"}},\"properties\":[],\"class\":\"BuilderRowElement\"},\"builderrowelement_1393965668_53163a6448794\":{\"content\":{\"buildercolumnelement_1393965668_53163a644866d\":{\"content\":{\"buildertextelement_1393965781_53163ad53b77c\":{\"content\":{\"text\":\"\\n

\\n Orsino, the Duke of Illyria<\\/i>, is consumed by his passion for the melancholy Countess Olivia. His ostentatious musings on the nature of love begin with what has become one of Shakespeare\'s most famous lines: \\\"If music be the food of love, play on.\\\" It is apparent that Orsino\'s love is hollow. He is a romantic dreamer, for whom the idea of being in love is most important. When Valentine gives him the terrible news that Olivia<\\/b> plans to seclude herself for seven years to mourn her deceased brother, Orsino seems unfazed, and hopes Olivia may one day be as bewitched by love (the one self king) as he. Fittingly, the scene ends with Orsino off to lay in a bed of flowers, where he can be alone with his love-thoughts. Later in the play it will be up to Viola to teach Orsino the true meaning of love.\\n<\\/p>\\n\"},\"properties\":[],\"class\":\"BuilderTextElement\"},\"builderbuttonelement_1393965942_53163b76e666c\":{\"content\":[],\"properties\":{\"backend\":{\"text\":\"Contact Us Now\",\"sizeClass\":\"medium-button\",\"align\":\"left\"},\"frontend\":{\"href\":\"http:\\/\\/localhost\\/Zurmo\\/app\\/index.php\",\"target\":\"_blank\",\"inlineStyles\":{\"background-color\":\"#97c43d\",\"border-color\":\"#7cb830\"}}},\"class\":\"BuilderButtonElement\"}},\"properties\":[],\"class\":\"BuilderColumnElement\"},\"buildercolumnelement_1394061698_5317b182c1f19\":{\"content\":{\"buildertextelement_1394061967_5317b28fc8088\":{\"content\":{\"text\":\"\\nNew Articles<\\/b>\\n