-- MySQL dump 10.13 Distrib 5.5.49, for Linux (x86_64)
-- Host: localhost Database: zurmo327
-- ------------------------------------------------------
/*!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 */;
-- Table structure for table `_group`
DROP TABLE IF EXISTS `_group`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
`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,
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 */;
-- 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,
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 */;
-- Table structure for table `_right`
DROP TABLE IF EXISTS `_right`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
`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,
) 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 */;
-- Table structure for table `_user`
DROP TABLE IF EXISTS `_user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
`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,
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 */;
-- 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,
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 */;
-- Table structure for table `account`
DROP TABLE IF EXISTS `account`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
`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,
) 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 */;
-- 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,
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 */;
-- 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,
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 */;
-- 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,
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 */;
-- 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,
) 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 */;
-- 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,
) 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 */;
-- 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,
) 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 */;
-- 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,
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 */;
-- 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,
) 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 */;
-- 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,
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 */;
-- 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,
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 */;
-- 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,