D7net
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
var
/
softaculous
/
sugar
/
Filename :
sugar.sql
back
Copy
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!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 */; -- -- Database: `soft_sugarc6526` -- -- -------------------------------------------------------- -- -- Table structure for table `accounts` -- CREATE TABLE `accounts` ( `id` char(36) NOT NULL, `name` varchar(150) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `description` text, `deleted` tinyint(1) DEFAULT '0', `assigned_user_id` char(36) DEFAULT NULL, `account_type` varchar(50) DEFAULT NULL, `industry` varchar(50) DEFAULT NULL, `annual_revenue` varchar(100) DEFAULT NULL, `phone_fax` varchar(100) DEFAULT NULL, `billing_address_street` varchar(150) DEFAULT NULL, `billing_address_city` varchar(100) DEFAULT NULL, `billing_address_state` varchar(100) DEFAULT NULL, `billing_address_postalcode` varchar(20) DEFAULT NULL, `billing_address_country` varchar(255) DEFAULT NULL, `rating` varchar(100) DEFAULT NULL, `phone_office` varchar(100) DEFAULT NULL, `phone_alternate` varchar(100) DEFAULT NULL, `website` varchar(255) DEFAULT NULL, `ownership` varchar(100) DEFAULT NULL, `employees` varchar(10) DEFAULT NULL, `ticker_symbol` varchar(10) DEFAULT NULL, `shipping_address_street` varchar(150) DEFAULT NULL, `shipping_address_city` varchar(100) DEFAULT NULL, `shipping_address_state` varchar(100) DEFAULT NULL, `shipping_address_postalcode` varchar(20) DEFAULT NULL, `shipping_address_country` varchar(255) DEFAULT NULL, `parent_id` char(36) DEFAULT NULL, `sic_code` varchar(10) DEFAULT NULL, `campaign_id` char(36) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_accnt_id_del` (`id`,`deleted`), KEY `idx_accnt_name_del` (`name`,`deleted`), KEY `idx_accnt_assigned_del` (`deleted`,`assigned_user_id`), KEY `idx_accnt_parent_id` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `accounts_audit` -- CREATE TABLE `accounts_audit` ( `id` char(36) NOT NULL, `parent_id` char(36) NOT NULL, `date_created` datetime DEFAULT NULL, `created_by` varchar(36) DEFAULT NULL, `field_name` varchar(100) DEFAULT NULL, `data_type` varchar(100) DEFAULT NULL, `before_value_string` varchar(255) DEFAULT NULL, `after_value_string` varchar(255) DEFAULT NULL, `before_value_text` text, `after_value_text` text, PRIMARY KEY (`id`), KEY `idx_accounts_parent_id` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `accounts_bugs` -- CREATE TABLE `accounts_bugs` ( `id` varchar(36) NOT NULL, `account_id` varchar(36) DEFAULT NULL, `bug_id` varchar(36) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_acc_bug_acc` (`account_id`), KEY `idx_acc_bug_bug` (`bug_id`), KEY `idx_account_bug` (`account_id`,`bug_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `accounts_cases` -- CREATE TABLE `accounts_cases` ( `id` varchar(36) NOT NULL, `account_id` varchar(36) DEFAULT NULL, `case_id` varchar(36) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_acc_case_acc` (`account_id`), KEY `idx_acc_acc_case` (`case_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `accounts_contacts` -- CREATE TABLE `accounts_contacts` ( `id` varchar(36) NOT NULL, `contact_id` varchar(36) DEFAULT NULL, `account_id` varchar(36) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_account_contact` (`account_id`,`contact_id`), KEY `idx_contid_del_accid` (`contact_id`,`deleted`,`account_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `accounts_opportunities` -- CREATE TABLE `accounts_opportunities` ( `id` varchar(36) NOT NULL, `opportunity_id` varchar(36) DEFAULT NULL, `account_id` varchar(36) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_account_opportunity` (`account_id`,`opportunity_id`), KEY `idx_oppid_del_accid` (`opportunity_id`,`deleted`,`account_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `acl_actions` -- CREATE TABLE `acl_actions` ( `id` char(36) NOT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `name` varchar(150) DEFAULT NULL, `category` varchar(100) DEFAULT NULL, `acltype` varchar(100) DEFAULT NULL, `aclaccess` int(3) DEFAULT NULL, `deleted` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_aclaction_id_del` (`id`,`deleted`), KEY `idx_category_name` (`category`,`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `acl_actions` -- INSERT INTO `acl_actions` VALUES ('11186b24-36ca-01ce-4054-5954ac4cd102', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'Notes', 'module', 90, 0), ('13504707-acc2-5693-df6b-5954ac77fbce', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'Leads', 'module', 89, 0), ('16f024bd-b66e-f0b4-c351-5954ac09b406', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'Tasks', 'module', 89, 0), ('1762013e-5274-522b-cba0-5954ac60f8c2', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'Leads', 'module', 90, 0), ('1950b742-6114-68e8-cd11-5954ac9cee46', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'ProspectLists', 'module', 89, 0), ('1b77c5a7-22fc-97ba-71ac-5954acb0134f', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'Leads', 'module', 90, 0), ('1d15231c-57a5-b0a3-e4f7-5954ac6f17c4', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'Tasks', 'module', 90, 0), ('1f6f159a-f48d-9aa2-0bb2-5954ac2d5586', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'ProspectLists', 'module', 90, 0), ('1f9f38ce-c81d-66cc-d45e-5954ac380d19', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'Leads', 'module', 90, 0), ('23347d09-6a53-5f88-3b9a-5954acdfad5a', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'Tasks', 'module', 90, 0), ('23a388d4-9509-5917-3a77-5954ac6083a6', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'Leads', 'module', 90, 0), ('258666fc-c481-a7fd-cca0-5954ac14707f', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'ProspectLists', 'module', 90, 0), ('27bd5fc5-4bfc-90b3-e9b6-5954ac9ecefc', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'Leads', 'module', 90, 0), ('28ebc7bb-bf14-f27c-e35b-5954acbf4a94', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'Bugs', 'module', 89, 0), ('29582720-34aa-e1b5-f18a-5954ac57b2a7', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'Tasks', 'module', 90, 0), ('2a09e5c9-886b-0380-861b-5954ac634213', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'Accounts', 'module', 89, 0), ('2bb1ef8b-8167-9933-527d-5954ac73a460', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'ProspectLists', 'module', 90, 0), ('2bd0b08a-d749-8db1-25cd-5954ac34a34c', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'Leads', 'module', 90, 0), ('2e21c361-f251-218b-7a78-5954ac1c67bf', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'Accounts', 'module', 90, 0), ('2f095dad-6d16-c50c-9b02-5954ace33220', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'Bugs', 'module', 90, 0), ('2fec0519-8408-8f5f-b735-5954ac073745', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'Leads', 'module', 90, 0), ('31d80b48-f2c5-899d-1d40-5954ac4713fd', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'ProspectLists', 'module', 90, 0), ('3238d06f-b87a-8889-cb42-5954acda0b14', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'Accounts', 'module', 90, 0), ('35288306-7050-a9bb-7b29-5954acb46394', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'Bugs', 'module', 90, 0), ('35890181-cf56-c6a9-ff74-5954acdd1257', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'Tasks', 'module', 90, 0), ('36443dfb-7670-9331-6fff-5954acbaa03d', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'Accounts', 'module', 90, 0), ('37fc2afc-cf2d-33fb-b33d-5954acd78b95', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'ProspectLists', 'module', 90, 0), ('38c70bd2-3715-5d05-b645-5954ac681d26', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'Documents', 'module', 89, 0), ('3a59876d-483f-c4cf-8a9b-5954acfa4615', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'Accounts', 'module', 90, 0), ('3b47bd2d-8f85-a78a-ba3c-5954acf2d4ac', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'Bugs', 'module', 90, 0), ('3ba4bed7-71d7-359a-cd1a-5954acfa5c56', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'Tasks', 'module', 90, 0), ('3cd6ebeb-47f5-de0e-bcd5-5954aceb0f3e', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'Documents', 'module', 90, 0), ('3e73273f-c723-350c-137b-5954acf7989f', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'Accounts', 'module', 90, 0), ('3fda0d12-3387-a78b-1f9c-5954acf2d2c0', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'ProjectTask', 'module', 90, 0), ('401dcc67-ef18-03ef-faba-5954ac24a9f0', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'ProspectLists', 'module', 90, 0), ('40edfac4-4101-c42f-b27a-5954acf37be7', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'Documents', 'module', 90, 0), ('4165fed6-0495-53e9-f457-5954aca0e710', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'Bugs', 'module', 90, 0), ('41c9a629-8234-527f-d41a-5954aca55229', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'Tasks', 'module', 90, 0), ('4254dcd6-b2f5-ccc7-4733-5954ac56c4aa', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'Project', 'module', 89, 0), ('42954e49-3f45-e858-7eb6-5954ac37636f', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'Accounts', 'module', 90, 0), ('45081014-1b02-e525-c279-5954aca31cd3', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'Documents', 'module', 90, 0), ('463590ee-9e51-b6be-c86f-5954acf460bc', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'ProspectLists', 'module', 90, 0), ('4669da5a-5828-cf81-59b9-5954ac43f7c0', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'Project', 'module', 90, 0), ('469e896f-925e-28e1-aa50-5954ac35f92c', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'Accounts', 'module', 90, 0), ('478733c1-0a6c-8fd8-84d9-5954ac8a5112', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'Bugs', 'module', 90, 0), ('47eab9fe-db82-b51d-1bba-5954acfde772', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'Tasks', 'module', 90, 0), ('4920a25c-d4e2-4dfc-16a2-5954ac3c41ad', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'Documents', 'module', 90, 0), ('4a01ce2d-3aa9-3983-b165-5954ac6a2af2', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'EmailTemplates', 'module', 89, 0), ('4a7af335-e02f-8546-886a-5954ac8ea11e', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'Project', 'module', 90, 0), ('4d3f085c-4751-85c8-0fdf-5954ac916f13', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'Documents', 'module', 90, 0), ('4d9f59dd-7b9b-d263-89f3-5954ac9a9d2b', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'Bugs', 'module', 90, 0), ('4e923a18-cc22-7808-4471-5954ac9244ca', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'Project', 'module', 90, 0), ('501283d4-2e02-e383-df59-5954ac7d978c', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'EmailTemplates', 'module', 90, 0), ('51460df7-b9fe-0045-31d4-5954ac31e456', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'Documents', 'module', 90, 0), ('5261e39d-868c-c9a3-9fc1-5954acca7461', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'Notes', 'module', 90, 0), ('52aceff9-c658-7cb6-96fc-5954ac281036', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'Project', 'module', 90, 0), ('53bd7226-989b-aabb-3fb4-5954acb56b62', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'Bugs', 'module', 90, 0), ('5563294e-5f8c-5bbb-6ff4-5954aca85040', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'Documents', 'module', 90, 0), ('56221d08-b91f-809b-b80d-5954ac01a3a9', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'EmailTemplates', 'module', 90, 0), ('56bef050-32a4-8489-26d0-5954acf10a8e', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'Project', 'module', 90, 0), ('5880e9ef-c7db-e78a-81fe-5954ac8f7a0c', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'Notes', 'module', 90, 0), ('5ae29151-d76a-ed1f-47d4-5954acd3145d', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'Project', 'module', 90, 0), ('5c3ff6fb-319e-7b32-b619-5954ac1e9dd2', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'EmailTemplates', 'module', 90, 0), ('5cb7b20d-64f9-c073-369a-5954ac54a143', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'Prospects', 'module', 89, 0), ('5e9c6e1d-c9d3-43a8-36c1-5954ace4a5e8', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'Notes', 'module', 90, 0), ('5eee76ce-a014-8aed-dcd8-5954ac33620c', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'Project', 'module', 90, 0), ('60c64b15-af52-18f8-3e4a-5954ac2958f6', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'Prospects', 'module', 90, 0), ('6261a787-8a64-721e-2444-5954acf989a0', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'EmailTemplates', 'module', 90, 0), ('64ce3d02-2860-d780-f014-5954aca57c87', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'Notes', 'module', 90, 0), ('64e042ca-4e48-29b3-bce7-5954acd170df', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'Prospects', 'module', 90, 0), ('688072a6-cd58-c833-b2d9-5954acd15444', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'EmailTemplates', 'module', 90, 0), ('68f5f240-64a5-fd5b-a111-5954acef37d4', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'Prospects', 'module', 90, 0), ('6a1c4a25-49a1-c6f6-3010-5954acc861fb', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'Campaigns', 'module', 89, 0), ('6a67aa8b-2766-4698-0b64-5954ac486f00', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'Meetings', 'module', 89, 0), ('6add26dd-82f7-2816-5120-5954ac18f2f8', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'Notes', 'module', 90, 0), ('6d0b0137-ea09-2b33-e5f8-5954ac1bb6ce', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'Prospects', 'module', 90, 0), ('6e9ed4fe-c350-02c0-e168-5954acad8781', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'EmailTemplates', 'module', 90, 0), ('704143d1-1e85-20b1-7504-5954ac86ad24', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'Campaigns', 'module', 90, 0), ('711ed797-40bc-1b39-7ef9-5954acc02f88', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'Prospects', 'module', 90, 0), ('74cb5fa8-13ee-7f11-34bd-5954ac4c45e3', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'EmailTemplates', 'module', 90, 0), ('75323401-54a7-e3d3-a762-5954ac04761e', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'Prospects', 'module', 90, 0), ('76574429-635b-5037-690b-5954ac697d84', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'Campaigns', 'module', 90, 0), ('79581461-8f47-c59c-37dc-5954aca60489', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'Prospects', 'module', 90, 0), ('7c7d1a45-ca1b-7dc0-5821-5954ac67a824', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'Campaigns', 'module', 90, 0), ('7eec5a40-b136-21d3-8027-5954ac86aafe', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'Contacts', 'module', 89, 0), ('829bb273-a2bc-4a1b-d22a-5954acb84f0f', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'Campaigns', 'module', 90, 0), ('850760ba-06fe-6bbb-2731-5954ac39a184', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'Contacts', 'module', 90, 0), ('88bd76d1-bb28-0008-c897-5954ac523a82', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'Campaigns', 'module', 90, 0), ('8b23ff18-cd3a-4259-ce4e-5954ac6fb216', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'Contacts', 'module', 90, 0), ('8edbc8e6-81cb-ccd3-60a9-5954acc9f4a8', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'Campaigns', 'module', 90, 0), ('9076196b-a05d-d2fa-2f4a-5954ac60c722', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'Meetings', 'module', 90, 0), ('91b6d519-ad22-d6ee-ddfe-5954ac75eaa0', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'Calls', 'module', 89, 0), ('9245523c-1c39-f371-f470-5954ac3e78a0', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'Cases', 'module', 89, 0), ('934f1f7e-038b-22f8-8551-5954ac6efbb8', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'Contacts', 'module', 90, 0), ('95059647-6926-949f-d756-5954ac97a54b', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'Campaigns', 'module', 90, 0), ('966f4b4b-6a0a-f7ca-8961-5954acf7fc5c', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'ProjectTask', 'module', 89, 0), ('97cfa3d3-0436-f6f2-bf43-5954ac81b879', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'Calls', 'module', 90, 0), ('98c19223-ec7a-429d-1951-5954acf21f6d', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'Meetings', 'module', 90, 0), ('9b7040cc-bbbb-c164-97eb-5954ac19f5ee', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'Contacts', 'module', 90, 0), ('9c8996d3-c152-0d56-0533-5954acd9d8de', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'ProjectTask', 'module', 90, 0), ('9df5e7e6-0c4e-29e9-f659-5954ac4fea58', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'Calls', 'module', 90, 0), ('9e7c31be-a2d0-eaa3-882c-5954ac7dd169', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'Cases', 'module', 90, 0), ('a09584b0-83d2-f366-35f7-5954ac0b3cfc', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'Opportunities', 'module', 89, 0), ('a1937b4e-c7af-a0af-d389-5954ac8ba041', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'Contacts', 'module', 90, 0), ('a1e80044-7f48-9d4b-d58a-5954ac1cbee2', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'ProjectTask', 'module', 90, 0), ('a21b67ab-6c12-6c77-b827-5954ac265ac7', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'Calls', 'module', 90, 0), ('a4b04dbc-5408-f6dc-ab0d-5954aca308a2', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'Opportunities', 'module', 90, 0), ('a4b7a643-3021-2c57-b721-5954ac5a1f56', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'Cases', 'module', 90, 0), ('a63235c4-62e5-7492-57ab-5954acd3f9db', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'Calls', 'module', 90, 0), ('a7b21db2-b206-cb83-cc54-5954aca170d9', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'Contacts', 'module', 90, 0), ('a8cb39db-cafd-48ba-6283-5954acc260ef', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'Opportunities', 'module', 90, 0), ('aa3c3197-092d-1cbd-5550-5954acd6dbb0', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'Calls', 'module', 90, 0), ('aa4dd14f-76d2-74b0-d629-5954ac3e3d97', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'EAPM', 'module', 89, 0), ('aabc7bac-826d-d0e7-27ec-5954ac8c17f2', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'Cases', 'module', 90, 0), ('adcfb100-5dcf-174d-13f9-5954ac9d8941', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'Contacts', 'module', 90, 0), ('ae50da87-1459-5d99-7778-5954ac118079', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'Calls', 'module', 90, 0), ('aed8ebea-3f4b-bd33-895c-5954ac2a3d14', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'ProjectTask', 'module', 90, 0), ('aedfa638-aae7-b881-5d6c-5954acd1c593', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'Opportunities', 'module', 90, 0), ('af0e3e06-aa8a-0351-8254-5954ac90ffb4', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'Meetings', 'module', 90, 0), ('b061bfab-7d27-8ac6-6780-5954ac84c3ad', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'EAPM', 'module', 90, 0), ('b25bff07-bdd4-26ae-956f-5954ac700aa7', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'Calls', 'module', 90, 0), ('b326718d-8e07-5d06-7add-5954ac2c2b2a', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'Cases', 'module', 90, 0), ('b335a6c8-9f22-13ae-ed01-5954ac9783d4', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'Opportunities', 'module', 90, 0), ('b6820960-d77e-7d21-12f9-5954ac491f84', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'EAPM', 'module', 90, 0), ('b6b462f9-93bb-a57c-bf9e-5954ac743e17', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'EmailMarketing', 'module', 89, 0), ('b90840f4-5020-ba34-fd3c-5954ac4c563b', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'Cases', 'module', 90, 0), ('b9435b2e-ab36-9feb-64e7-5954ac08666d', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'Meetings', 'module', 90, 0), ('b951b553-8ee5-b371-c321-5954acf42530', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'Opportunities', 'module', 90, 0), ('babc0457-09e0-0dfc-d11e-5954acb5f0d0', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'EmailMarketing', 'module', 90, 0), ('bbeb764c-5a12-d309-5744-5954ace17af6', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'Users', 'module', 89, 0), ('bc9e2864-09f6-d055-7eeb-5954ac0ae6d2', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'EAPM', 'module', 90, 0), ('bed5a272-9500-bd4b-a9d6-5954ac73503a', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'EmailMarketing', 'module', 90, 0), ('bf72d2c5-4b0f-10ce-2c82-5954ac3e966f', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'Opportunities', 'module', 90, 0), ('c008c68a-fb91-964a-a10b-5954ac578e45', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'Cases', 'module', 90, 0), ('c2bef9ce-eb00-3b3e-87e2-5954ac1e1e75', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'EAPM', 'module', 90, 0), ('c2ef56cd-ee58-470d-5e5a-5954acef7f69', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'EmailMarketing', 'module', 90, 0), ('c56d3c88-b8a6-01fe-865d-5954ac9dd40a', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'Cases', 'module', 90, 0), ('c617b340-054a-7f32-f588-5954ac3fe36f', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'Users', 'module', 90, 0), ('c6fdeaf6-f8b2-cea2-b834-5954ac6b4e20', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'EmailMarketing', 'module', 90, 0), ('c8da28fb-2e40-d7a6-8170-5954acbf56cd', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'EAPM', 'module', 90, 0), ('cb12d3fe-6c00-328a-be4c-5954acbb8e78', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'EmailMarketing', 'module', 90, 0), ('cc389552-c9f3-45f7-4f27-5954ac0dc56f', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'Users', 'module', 90, 0), ('cc679764-feae-047e-f9be-5954ace0ab87', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'Notes', 'module', 89, 0), ('ccefe239-bcca-1683-8bc0-5954acdc1657', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'EAPM', 'module', 90, 0), ('cdb7c588-d275-fb8a-8b59-5954ac2139d4', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'Opportunities', 'module', 90, 0), ('cf2a4544-1c8b-984f-95a0-5954ac720712', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'EmailMarketing', 'module', 90, 0), ('d0fdd550-9f2a-f039-e878-5954acdbe5df', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'EAPM', 'module', 90, 0), ('d2573631-7cfe-113f-34ab-5954acfa6f09', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'Users', 'module', 90, 0), ('d34234b8-6492-3aa4-04a8-5954ac75f411', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'EmailMarketing', 'module', 90, 0), ('d3ae38bd-c9c2-52e7-08a8-5954acc3ff40', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'Meetings', 'module', 90, 0), ('d7354bd5-3c58-d8a1-7ea9-5954ac9f521d', '[[regtime]]', '[[regtime]]', '1', '', 'access', 'Emails', 'module', 89, 0), ('d7bfa431-6192-12ae-cd62-5954acad67d6', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'Meetings', 'module', 90, 0), ('d871d384-3a63-b6f4-a70a-5954ac10b963', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'Users', 'module', 90, 0), ('db44faa4-7623-2946-1619-5954acaeaded', '[[regtime]]', '[[regtime]]', '1', '', 'view', 'Emails', 'module', 90, 0), ('dbd2be64-e1cc-9ab0-b66b-5954ac0ef716', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'Meetings', 'module', 90, 0), ('ddacdabb-e906-9899-2e06-5954ac5ea897', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'ProjectTask', 'module', 90, 0), ('de8fddd3-1932-c16e-e2fc-5954ac141e3e', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'Users', 'module', 90, 0), ('de9c8680-36f1-f601-8494-5954ac08acc5', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'Notes', 'module', 90, 0), ('df5c7ad4-ce38-0c25-3850-5954ac34d3a2', '[[regtime]]', '[[regtime]]', '1', '', 'list', 'Emails', 'module', 90, 0), ('e3745254-eee1-945d-a22c-5954ac3a017d', '[[regtime]]', '[[regtime]]', '1', '', 'edit', 'Emails', 'module', 90, 0), ('e4b21263-ed46-63c6-53ac-5954ac536a19', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'Users', 'module', 90, 0), ('e78c1348-d7a7-f24a-b63f-5954ac567ca0', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'Emails', 'module', 90, 0), ('e9e7a395-8f49-d7fa-f219-5954acf0f562', '[[regtime]]', '[[regtime]]', '1', '', 'delete', 'ProjectTask', 'module', 90, 0), ('ead7dd9d-0d88-cda0-0208-5954ac1adaa7', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'Users', 'module', 90, 0), ('eba20090-738a-43a7-2d3d-5954accef6cb', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'Emails', 'module', 90, 0), ('efb485ff-317d-f6ca-ff5f-5954ac476eb5', '[[regtime]]', '[[regtime]]', '1', '', 'export', 'Emails', 'module', 90, 0), ('f204b1af-aa73-25f0-6ac1-5954ac2ea25b', '[[regtime]]', '[[regtime]]', '1', '', 'import', 'ProjectTask', 'module', 90, 0), ('f3dc9bf2-edbf-8f4d-152e-5954aca3021b', '[[regtime]]', '[[regtime]]', '1', '', 'massupdate', 'Emails', 'module', 90, 0); -- -------------------------------------------------------- -- -- Table structure for table `acl_roles` -- CREATE TABLE `acl_roles` ( `id` char(36) NOT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `name` varchar(150) DEFAULT NULL, `description` text, `deleted` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_aclrole_id_del` (`id`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `acl_roles_actions` -- CREATE TABLE `acl_roles_actions` ( `id` varchar(36) NOT NULL, `role_id` varchar(36) DEFAULT NULL, `action_id` varchar(36) DEFAULT NULL, `access_override` int(3) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_acl_role_id` (`role_id`), KEY `idx_acl_action_id` (`action_id`), KEY `idx_aclrole_action` (`role_id`,`action_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `acl_roles_users` -- CREATE TABLE `acl_roles_users` ( `id` varchar(36) NOT NULL, `role_id` varchar(36) DEFAULT NULL, `user_id` varchar(36) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_aclrole_id` (`role_id`), KEY `idx_acluser_id` (`user_id`), KEY `idx_aclrole_user` (`role_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `address_book` -- CREATE TABLE `address_book` ( `assigned_user_id` char(36) NOT NULL, `bean` varchar(50) DEFAULT NULL, `bean_id` char(36) NOT NULL, KEY `ab_user_bean_idx` (`assigned_user_id`,`bean`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `bugs` -- CREATE TABLE `bugs` ( `id` char(36) NOT NULL, `name` varchar(255) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `description` text, `deleted` tinyint(1) DEFAULT '0', `assigned_user_id` char(36) DEFAULT NULL, `bug_number` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(255) DEFAULT NULL, `status` varchar(100) DEFAULT NULL, `priority` varchar(100) DEFAULT NULL, `resolution` varchar(255) DEFAULT NULL, `work_log` text, `found_in_release` varchar(255) DEFAULT NULL, `fixed_in_release` varchar(255) DEFAULT NULL, `source` varchar(255) DEFAULT NULL, `product_category` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `bugsnumk` (`bug_number`), KEY `bug_number` (`bug_number`), KEY `idx_bug_name` (`name`), KEY `idx_bugs_assigned_user` (`assigned_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `bugs_audit` -- CREATE TABLE `bugs_audit` ( `id` char(36) NOT NULL, `parent_id` char(36) NOT NULL, `date_created` datetime DEFAULT NULL, `created_by` varchar(36) DEFAULT NULL, `field_name` varchar(100) DEFAULT NULL, `data_type` varchar(100) DEFAULT NULL, `before_value_string` varchar(255) DEFAULT NULL, `after_value_string` varchar(255) DEFAULT NULL, `before_value_text` text, `after_value_text` text, PRIMARY KEY (`id`), KEY `idx_bugs_parent_id` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `calls` -- CREATE TABLE `calls` ( `id` char(36) NOT NULL, `name` varchar(50) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `description` text, `deleted` tinyint(1) DEFAULT '0', `assigned_user_id` char(36) DEFAULT NULL, `duration_hours` int(2) DEFAULT NULL, `duration_minutes` int(2) DEFAULT NULL, `date_start` datetime DEFAULT NULL, `date_end` datetime DEFAULT NULL, `parent_type` varchar(255) DEFAULT NULL, `status` varchar(100) DEFAULT 'Planned', `direction` varchar(100) DEFAULT NULL, `parent_id` char(36) DEFAULT NULL, `reminder_time` int(11) DEFAULT '-1', `email_reminder_time` int(11) DEFAULT '-1', `email_reminder_sent` tinyint(1) DEFAULT '0', `outlook_id` varchar(255) DEFAULT NULL, `repeat_type` varchar(36) DEFAULT NULL, `repeat_interval` int(3) DEFAULT '1', `repeat_dow` varchar(7) DEFAULT NULL, `repeat_until` date DEFAULT NULL, `repeat_count` int(7) DEFAULT NULL, `repeat_parent_id` char(36) DEFAULT NULL, `recurring_source` varchar(36) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_call_name` (`name`), KEY `idx_status` (`status`), KEY `idx_calls_date_start` (`date_start`), KEY `idx_calls_par_del` (`parent_id`,`parent_type`,`deleted`), KEY `idx_calls_assigned_del` (`deleted`,`assigned_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `calls_contacts` -- CREATE TABLE `calls_contacts` ( `id` varchar(36) NOT NULL, `call_id` varchar(36) DEFAULT NULL, `contact_id` varchar(36) DEFAULT NULL, `required` varchar(1) DEFAULT '1', `accept_status` varchar(25) DEFAULT 'none', `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_con_call_call` (`call_id`), KEY `idx_con_call_con` (`contact_id`), KEY `idx_call_contact` (`call_id`,`contact_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `calls_leads` -- CREATE TABLE `calls_leads` ( `id` varchar(36) NOT NULL, `call_id` varchar(36) DEFAULT NULL, `lead_id` varchar(36) DEFAULT NULL, `required` varchar(1) DEFAULT '1', `accept_status` varchar(25) DEFAULT 'none', `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_lead_call_call` (`call_id`), KEY `idx_lead_call_lead` (`lead_id`), KEY `idx_call_lead` (`call_id`,`lead_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `calls_users` -- CREATE TABLE `calls_users` ( `id` varchar(36) NOT NULL, `call_id` varchar(36) DEFAULT NULL, `user_id` varchar(36) DEFAULT NULL, `required` varchar(1) DEFAULT '1', `accept_status` varchar(25) DEFAULT 'none', `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_usr_call_call` (`call_id`), KEY `idx_usr_call_usr` (`user_id`), KEY `idx_call_users` (`call_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `campaigns` -- CREATE TABLE `campaigns` ( `id` char(36) NOT NULL, `name` varchar(50) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `assigned_user_id` char(36) DEFAULT NULL, `tracker_key` int(11) NOT NULL AUTO_INCREMENT, `tracker_count` int(11) DEFAULT '0', `refer_url` varchar(255) DEFAULT 'http://', `tracker_text` varchar(255) DEFAULT NULL, `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `status` varchar(100) DEFAULT NULL, `impressions` int(11) DEFAULT '0', `currency_id` char(36) DEFAULT NULL, `budget` double DEFAULT NULL, `expected_cost` double DEFAULT NULL, `actual_cost` double DEFAULT NULL, `expected_revenue` double DEFAULT NULL, `campaign_type` varchar(100) DEFAULT NULL, `objective` text, `content` text, `frequency` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`), KEY `camp_auto_tracker_key` (`tracker_key`), KEY `idx_campaign_name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `campaigns_audit` -- CREATE TABLE `campaigns_audit` ( `id` char(36) NOT NULL, `parent_id` char(36) NOT NULL, `date_created` datetime DEFAULT NULL, `created_by` varchar(36) DEFAULT NULL, `field_name` varchar(100) DEFAULT NULL, `data_type` varchar(100) DEFAULT NULL, `before_value_string` varchar(255) DEFAULT NULL, `after_value_string` varchar(255) DEFAULT NULL, `before_value_text` text, `after_value_text` text, PRIMARY KEY (`id`), KEY `idx_campaigns_parent_id` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `campaign_log` -- CREATE TABLE `campaign_log` ( `id` char(36) NOT NULL, `campaign_id` char(36) DEFAULT NULL, `target_tracker_key` varchar(36) DEFAULT NULL, `target_id` varchar(36) DEFAULT NULL, `target_type` varchar(100) DEFAULT NULL, `activity_type` varchar(100) DEFAULT NULL, `activity_date` datetime DEFAULT NULL, `related_id` varchar(36) DEFAULT NULL, `related_type` varchar(100) DEFAULT NULL, `archived` tinyint(1) DEFAULT '0', `hits` int(11) DEFAULT '0', `list_id` char(36) DEFAULT NULL, `deleted` tinyint(1) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `more_information` varchar(100) DEFAULT NULL, `marketing_id` char(36) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_camp_tracker` (`target_tracker_key`), KEY `idx_camp_campaign_id` (`campaign_id`), KEY `idx_camp_more_info` (`more_information`), KEY `idx_target_id` (`target_id`), KEY `idx_target_id_deleted` (`target_id`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `campaign_trkrs` -- CREATE TABLE `campaign_trkrs` ( `id` char(36) NOT NULL, `tracker_name` varchar(30) DEFAULT NULL, `tracker_url` varchar(255) DEFAULT 'http://', `tracker_key` int(11) NOT NULL AUTO_INCREMENT, `campaign_id` char(36) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `is_optout` tinyint(1) DEFAULT '0', `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `campaign_tracker_key_idx` (`tracker_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `cases` -- CREATE TABLE `cases` ( `id` char(36) NOT NULL, `name` varchar(255) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `description` text, `deleted` tinyint(1) DEFAULT '0', `assigned_user_id` char(36) DEFAULT NULL, `case_number` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(255) DEFAULT NULL, `status` varchar(100) DEFAULT NULL, `priority` varchar(100) DEFAULT NULL, `resolution` text, `work_log` text, `account_id` char(36) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `casesnumk` (`case_number`), KEY `case_number` (`case_number`), KEY `idx_case_name` (`name`), KEY `idx_account_id` (`account_id`), KEY `idx_cases_stat_del` (`assigned_user_id`,`status`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `cases_audit` -- CREATE TABLE `cases_audit` ( `id` char(36) NOT NULL, `parent_id` char(36) NOT NULL, `date_created` datetime DEFAULT NULL, `created_by` varchar(36) DEFAULT NULL, `field_name` varchar(100) DEFAULT NULL, `data_type` varchar(100) DEFAULT NULL, `before_value_string` varchar(255) DEFAULT NULL, `after_value_string` varchar(255) DEFAULT NULL, `before_value_text` text, `after_value_text` text, PRIMARY KEY (`id`), KEY `idx_cases_parent_id` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `cases_bugs` -- CREATE TABLE `cases_bugs` ( `id` varchar(36) NOT NULL, `case_id` varchar(36) DEFAULT NULL, `bug_id` varchar(36) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_cas_bug_cas` (`case_id`), KEY `idx_cas_bug_bug` (`bug_id`), KEY `idx_case_bug` (`case_id`,`bug_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `config` -- CREATE TABLE `config` ( `category` varchar(32) DEFAULT NULL, `name` varchar(32) DEFAULT NULL, `value` text, KEY `idx_config_cat` (`category`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `config` -- INSERT INTO `config` VALUES ('notify', 'fromaddress', '[[admin_email]]'), ('notify', 'fromname', '[[site_name]]'), ('notify', 'send_by_default', '1'), ('notify', 'on', '1'), ('notify', 'send_from_assigning_user', '0'), ('info', 'sugar_version', '6.5.26'), ('MySettings', 'tab', 'YToxNjp7aTowO3M6NDoiSG9tZSI7aToxO3M6ODoiQWNjb3VudHMiO2k6MjtzOjg6IkNvbnRhY3RzIjtpOjM7czoxMzoiT3Bwb3J0dW5pdGllcyI7aTo0O3M6NToiTGVhZHMiO2k6NTtzOjg6IkNhbGVuZGFyIjtpOjY7czo5OiJEb2N1bWVudHMiO2k6NztzOjY6IkVtYWlscyI7aTo4O3M6OToiQ2FtcGFpZ25zIjtpOjk7czo1OiJDYWxscyI7aToxMDtzOjg6Ik1lZXRpbmdzIjtpOjExO3M6NToiVGFza3MiO2k6MTI7czo1OiJOb3RlcyI7aToxMztzOjU6IkNhc2VzIjtpOjE0O3M6OToiUHJvc3BlY3RzIjtpOjE1O3M6MTM6IlByb3NwZWN0TGlzdHMiO30='), ('portal', 'on', '0'), ('tracker', 'Tracker', '1'), ('system', 'skypeout_on', '1'), ('sugarfeed', 'enabled', '1'), ('sugarfeed', 'module_UserFeed', '1'), ('sugarfeed', 'module_Contacts', '1'), ('sugarfeed', 'module_Leads', '1'), ('sugarfeed', 'module_Cases', '1'), ('sugarfeed', 'module_Opportunities', '1'), ('Update', 'CheckUpdates', 'automatic'), ('system', 'name', '[[site_name]]'); -- -------------------------------------------------------- -- -- Table structure for table `contacts` -- CREATE TABLE `contacts` ( `id` char(36) NOT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `description` text, `deleted` tinyint(1) DEFAULT '0', `assigned_user_id` char(36) DEFAULT NULL, `salutation` varchar(255) DEFAULT NULL, `first_name` varchar(100) DEFAULT NULL, `last_name` varchar(100) DEFAULT NULL, `title` varchar(100) DEFAULT NULL, `department` varchar(255) DEFAULT NULL, `do_not_call` tinyint(1) DEFAULT '0', `phone_home` varchar(100) DEFAULT NULL, `phone_mobile` varchar(100) DEFAULT NULL, `phone_work` varchar(100) DEFAULT NULL, `phone_other` varchar(100) DEFAULT NULL, `phone_fax` varchar(100) DEFAULT NULL, `primary_address_street` varchar(150) DEFAULT NULL, `primary_address_city` varchar(100) DEFAULT NULL, `primary_address_state` varchar(100) DEFAULT NULL, `primary_address_postalcode` varchar(20) DEFAULT NULL, `primary_address_country` varchar(255) DEFAULT NULL, `alt_address_street` varchar(150) DEFAULT NULL, `alt_address_city` varchar(100) DEFAULT NULL, `alt_address_state` varchar(100) DEFAULT NULL, `alt_address_postalcode` varchar(20) DEFAULT NULL, `alt_address_country` varchar(255) DEFAULT NULL, `assistant` varchar(75) DEFAULT NULL, `assistant_phone` varchar(100) DEFAULT NULL, `lead_source` varchar(255) DEFAULT NULL, `reports_to_id` char(36) DEFAULT NULL, `birthdate` date DEFAULT NULL, `campaign_id` char(36) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_cont_last_first` (`last_name`,`first_name`,`deleted`), KEY `idx_contacts_del_last` (`deleted`,`last_name`), KEY `idx_cont_del_reports` (`deleted`,`reports_to_id`,`last_name`), KEY `idx_reports_to_id` (`reports_to_id`), KEY `idx_del_id_user` (`deleted`,`id`,`assigned_user_id`), KEY `idx_cont_assigned` (`assigned_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `contacts_audit` -- CREATE TABLE `contacts_audit` ( `id` char(36) NOT NULL, `parent_id` char(36) NOT NULL, `date_created` datetime DEFAULT NULL, `created_by` varchar(36) DEFAULT NULL, `field_name` varchar(100) DEFAULT NULL, `data_type` varchar(100) DEFAULT NULL, `before_value_string` varchar(255) DEFAULT NULL, `after_value_string` varchar(255) DEFAULT NULL, `before_value_text` text, `after_value_text` text, PRIMARY KEY (`id`), KEY `idx_contacts_parent_id` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `contacts_bugs` -- CREATE TABLE `contacts_bugs` ( `id` varchar(36) NOT NULL, `contact_id` varchar(36) DEFAULT NULL, `bug_id` varchar(36) DEFAULT NULL, `contact_role` varchar(50) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_con_bug_con` (`contact_id`), KEY `idx_con_bug_bug` (`bug_id`), KEY `idx_contact_bug` (`contact_id`,`bug_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `contacts_cases` -- CREATE TABLE `contacts_cases` ( `id` varchar(36) NOT NULL, `contact_id` varchar(36) DEFAULT NULL, `case_id` varchar(36) DEFAULT NULL, `contact_role` varchar(50) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_con_case_con` (`contact_id`), KEY `idx_con_case_case` (`case_id`), KEY `idx_contacts_cases` (`contact_id`,`case_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `contacts_users` -- CREATE TABLE `contacts_users` ( `id` varchar(36) NOT NULL, `contact_id` varchar(36) DEFAULT NULL, `user_id` varchar(36) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_con_users_con` (`contact_id`), KEY `idx_con_users_user` (`user_id`), KEY `idx_contacts_users` (`contact_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `cron_remove_documents` -- CREATE TABLE `cron_remove_documents` ( `id` varchar(36) NOT NULL, `bean_id` varchar(36) DEFAULT NULL, `module` varchar(25) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_cron_remove_document_bean_id` (`bean_id`), KEY `idx_cron_remove_document_stamp` (`date_modified`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `currencies` -- CREATE TABLE `currencies` ( `id` char(36) NOT NULL, `name` varchar(36) DEFAULT NULL, `symbol` varchar(36) DEFAULT NULL, `iso4217` varchar(3) DEFAULT NULL, `conversion_rate` double DEFAULT '0', `status` varchar(100) DEFAULT NULL, `deleted` tinyint(1) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `created_by` char(36) NOT NULL, PRIMARY KEY (`id`), KEY `idx_currency_name` (`name`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `custom_fields` -- CREATE TABLE `custom_fields` ( `bean_id` varchar(36) DEFAULT NULL, `set_num` int(11) DEFAULT '0', `field0` varchar(255) DEFAULT NULL, `field1` varchar(255) DEFAULT NULL, `field2` varchar(255) DEFAULT NULL, `field3` varchar(255) DEFAULT NULL, `field4` varchar(255) DEFAULT NULL, `field5` varchar(255) DEFAULT NULL, `field6` varchar(255) DEFAULT NULL, `field7` varchar(255) DEFAULT NULL, `field8` varchar(255) DEFAULT NULL, `field9` varchar(255) DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', KEY `idx_beanid_set_num` (`bean_id`,`set_num`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `documents` -- CREATE TABLE `documents` ( `id` char(36) NOT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `description` text, `deleted` tinyint(1) DEFAULT '0', `assigned_user_id` char(36) DEFAULT NULL, `document_name` varchar(255) DEFAULT NULL, `doc_id` varchar(100) DEFAULT NULL, `doc_type` varchar(100) DEFAULT 'Sugar', `doc_url` varchar(255) DEFAULT NULL, `active_date` date DEFAULT NULL, `exp_date` date DEFAULT NULL, `category_id` varchar(100) DEFAULT NULL, `subcategory_id` varchar(100) DEFAULT NULL, `status_id` varchar(100) DEFAULT NULL, `document_revision_id` varchar(36) DEFAULT NULL, `related_doc_id` char(36) DEFAULT NULL, `related_doc_rev_id` char(36) DEFAULT NULL, `is_template` tinyint(1) DEFAULT '0', `template_type` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_doc_cat` (`category_id`,`subcategory_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `documents_accounts` -- CREATE TABLE `documents_accounts` ( `id` varchar(36) NOT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `document_id` varchar(36) DEFAULT NULL, `account_id` varchar(36) DEFAULT NULL, PRIMARY KEY (`id`), KEY `documents_accounts_account_id` (`account_id`,`document_id`), KEY `documents_accounts_document_id` (`document_id`,`account_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `documents_bugs` -- CREATE TABLE `documents_bugs` ( `id` varchar(36) NOT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `document_id` varchar(36) DEFAULT NULL, `bug_id` varchar(36) DEFAULT NULL, PRIMARY KEY (`id`), KEY `documents_bugs_bug_id` (`bug_id`,`document_id`), KEY `documents_bugs_document_id` (`document_id`,`bug_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `documents_cases` -- CREATE TABLE `documents_cases` ( `id` varchar(36) NOT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `document_id` varchar(36) DEFAULT NULL, `case_id` varchar(36) DEFAULT NULL, PRIMARY KEY (`id`), KEY `documents_cases_case_id` (`case_id`,`document_id`), KEY `documents_cases_document_id` (`document_id`,`case_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `documents_contacts` -- CREATE TABLE `documents_contacts` ( `id` varchar(36) NOT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `document_id` varchar(36) DEFAULT NULL, `contact_id` varchar(36) DEFAULT NULL, PRIMARY KEY (`id`), KEY `documents_contacts_contact_id` (`contact_id`,`document_id`), KEY `documents_contacts_document_id` (`document_id`,`contact_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `documents_opportunities` -- CREATE TABLE `documents_opportunities` ( `id` varchar(36) NOT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `document_id` varchar(36) DEFAULT NULL, `opportunity_id` varchar(36) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_docu_opps_oppo_id` (`opportunity_id`,`document_id`), KEY `idx_docu_oppo_docu_id` (`document_id`,`opportunity_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `document_revisions` -- CREATE TABLE `document_revisions` ( `id` varchar(36) NOT NULL, `change_log` varchar(255) DEFAULT NULL, `document_id` varchar(36) DEFAULT NULL, `doc_id` varchar(100) DEFAULT NULL, `doc_type` varchar(100) DEFAULT NULL, `doc_url` varchar(255) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `filename` varchar(255) DEFAULT NULL, `file_ext` varchar(100) DEFAULT NULL, `file_mime_type` varchar(100) DEFAULT NULL, `revision` varchar(100) DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `date_modified` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `documentrevision_mimetype` (`file_mime_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `eapm` -- CREATE TABLE `eapm` ( `id` char(36) NOT NULL, `name` varchar(255) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `description` text, `deleted` tinyint(1) DEFAULT '0', `assigned_user_id` char(36) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `url` varchar(255) DEFAULT NULL, `application` varchar(100) DEFAULT 'webex', `api_data` text, `consumer_key` varchar(255) DEFAULT NULL, `consumer_secret` varchar(255) DEFAULT NULL, `oauth_token` varchar(255) DEFAULT NULL, `oauth_secret` varchar(255) DEFAULT NULL, `validated` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_app_active` (`assigned_user_id`,`application`,`validated`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `emailman` -- CREATE TABLE `emailman` ( `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `user_id` char(36) DEFAULT NULL, `id` int(11) NOT NULL AUTO_INCREMENT, `campaign_id` char(36) DEFAULT NULL, `marketing_id` char(36) DEFAULT NULL, `list_id` char(36) DEFAULT NULL, `send_date_time` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `in_queue` tinyint(1) DEFAULT '0', `in_queue_date` datetime DEFAULT NULL, `send_attempts` int(11) DEFAULT '0', `deleted` tinyint(1) DEFAULT '0', `related_id` char(36) DEFAULT NULL, `related_type` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_eman_list` (`list_id`,`user_id`,`deleted`), KEY `idx_eman_campaign_id` (`campaign_id`), KEY `idx_eman_relid_reltype_id` (`related_id`,`related_type`,`campaign_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `emails` -- CREATE TABLE `emails` ( `id` char(36) NOT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `assigned_user_id` char(36) DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `deleted` tinyint(1) DEFAULT NULL, `date_sent` datetime DEFAULT NULL, `message_id` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `type` varchar(100) DEFAULT NULL, `status` varchar(100) DEFAULT NULL, `flagged` tinyint(1) DEFAULT NULL, `reply_to_status` tinyint(1) DEFAULT NULL, `intent` varchar(100) DEFAULT 'pick', `mailbox_id` char(36) DEFAULT NULL, `parent_type` varchar(100) DEFAULT NULL, `parent_id` char(36) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_email_name` (`name`), KEY `idx_message_id` (`message_id`), KEY `idx_email_parent_id` (`parent_id`), KEY `idx_email_assigned` (`assigned_user_id`,`type`,`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `emails_beans` -- CREATE TABLE `emails_beans` ( `id` char(36) NOT NULL, `email_id` char(36) DEFAULT NULL, `bean_id` char(36) DEFAULT NULL, `bean_module` varchar(100) DEFAULT NULL, `campaign_data` text, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_emails_beans_bean_id` (`bean_id`), KEY `idx_emails_beans_email_bean` (`email_id`,`bean_id`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `emails_email_addr_rel` -- CREATE TABLE `emails_email_addr_rel` ( `id` char(36) NOT NULL, `email_id` char(36) NOT NULL, `address_type` varchar(4) DEFAULT NULL, `email_address_id` char(36) NOT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_eearl_email_id` (`email_id`,`address_type`), KEY `idx_eearl_address_id` (`email_address_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `emails_text` -- CREATE TABLE `emails_text` ( `email_id` char(36) NOT NULL, `from_addr` varchar(255) DEFAULT NULL, `reply_to_addr` varchar(255) DEFAULT NULL, `to_addrs` text, `cc_addrs` text, `bcc_addrs` text, `description` longtext, `description_html` longtext, `raw_source` longtext, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`email_id`), KEY `emails_textfromaddr` (`from_addr`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `email_addresses` -- CREATE TABLE `email_addresses` ( `id` char(36) NOT NULL, `email_address` varchar(255) DEFAULT NULL, `email_address_caps` varchar(255) DEFAULT NULL, `invalid_email` tinyint(1) DEFAULT '0', `opt_out` tinyint(1) DEFAULT '0', `date_created` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_ea_caps_opt_out_invalid` (`email_address_caps`,`opt_out`,`invalid_email`), KEY `idx_ea_opt_out_invalid` (`email_address`,`opt_out`,`invalid_email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `email_addr_bean_rel` -- CREATE TABLE `email_addr_bean_rel` ( `id` char(36) NOT NULL, `email_address_id` char(36) NOT NULL, `bean_id` char(36) NOT NULL, `bean_module` varchar(100) DEFAULT NULL, `primary_address` tinyint(1) DEFAULT '0', `reply_to_address` tinyint(1) DEFAULT '0', `date_created` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_email_address_id` (`email_address_id`), KEY `idx_bean_id` (`bean_id`,`bean_module`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `email_cache` -- CREATE TABLE `email_cache` ( `ie_id` char(36) DEFAULT NULL, `mbox` varchar(60) DEFAULT NULL, `subject` varchar(255) DEFAULT NULL, `fromaddr` varchar(100) DEFAULT NULL, `toaddr` varchar(255) DEFAULT NULL, `senddate` datetime DEFAULT NULL, `message_id` varchar(255) DEFAULT NULL, `mailsize` int(10) unsigned DEFAULT NULL, `imap_uid` int(10) unsigned DEFAULT NULL, `msgno` int(10) unsigned DEFAULT NULL, `recent` tinyint(4) DEFAULT NULL, `flagged` tinyint(4) DEFAULT NULL, `answered` tinyint(4) DEFAULT NULL, `deleted` tinyint(4) DEFAULT NULL, `seen` tinyint(4) DEFAULT NULL, `draft` tinyint(4) DEFAULT NULL, KEY `idx_ie_id` (`ie_id`), KEY `idx_mail_date` (`ie_id`,`mbox`,`senddate`), KEY `idx_mail_from` (`ie_id`,`mbox`,`fromaddr`), KEY `idx_mail_subj` (`subject`), KEY `idx_mail_to` (`toaddr`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `email_marketing` -- CREATE TABLE `email_marketing` ( `id` char(36) NOT NULL, `deleted` tinyint(1) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `from_name` varchar(100) DEFAULT NULL, `from_addr` varchar(100) DEFAULT NULL, `reply_to_name` varchar(100) DEFAULT NULL, `reply_to_addr` varchar(100) DEFAULT NULL, `inbound_email_id` varchar(36) DEFAULT NULL, `date_start` datetime DEFAULT NULL, `template_id` char(36) NOT NULL, `status` varchar(100) DEFAULT NULL, `campaign_id` char(36) DEFAULT NULL, `all_prospect_lists` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_emmkt_name` (`name`), KEY `idx_emmkit_del` (`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `email_marketing_prospect_lists` -- CREATE TABLE `email_marketing_prospect_lists` ( `id` varchar(36) NOT NULL, `prospect_list_id` varchar(36) DEFAULT NULL, `email_marketing_id` varchar(36) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `email_mp_prospects` (`email_marketing_id`,`prospect_list_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `email_templates` -- CREATE TABLE `email_templates` ( `id` char(36) NOT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` varchar(36) DEFAULT NULL, `published` varchar(3) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `description` text, `subject` varchar(255) DEFAULT NULL, `body` text, `body_html` text, `deleted` tinyint(1) DEFAULT NULL, `assigned_user_id` char(36) DEFAULT NULL, `text_only` tinyint(1) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_email_template_name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `email_templates` -- INSERT INTO `email_templates` VALUES ('[[generatepasswordtmpl]]', '[[regtime]]', '[[regtime]]', '1', '1', 'off', 'System-generated password email', 'This template is used when the System Administrator sends a new password to a user.', 'New account information', '\nHere is your account username and temporary password:\nUsername : $contact_user_user_name\nPassword : $contact_user_user_hash\n\n$config_site_url\n\nAfter you log in using the above password, you may be required to reset the password to one of your own choice.', '<div><table width="550"><tbody><tr><td><p>Here is your account username and temporary password:</p><p>Username : $contact_user_user_name </p><p>Password : $contact_user_user_hash </p><br /><p>$config_site_url</p><br /><p>After you log in using the above password, you may be required to reset the password to one of your own choice.</p> </td> </tr><tr><td></td> </tr></tbody></table></div>', 0, NULL, 0, NULL), ('[[lostpasswordtmpl]]', '[[regtime]]', '[[regtime]]', '1', '1', 'off', 'Forgot Password email', 'This template is used to send a user a link to click to reset the user''s account password.', 'Reset your account password', '\nYou recently requested on $contact_user_pwd_last_changed to be able to reset your account password.\n\nClick on the link below to reset your password:\n\n$contact_user_link_guid', '<div><table width="550"><tbody><tr><td><p>You recently requested on $contact_user_pwd_last_changed to be able to reset your account password. </p><p>Click on the link below to reset your password:</p><p> $contact_user_link_guid </p> </td> </tr><tr><td></td> </tr></tbody></table></div>', 0, NULL, 0, NULL); -- -------------------------------------------------------- -- -- Table structure for table `fields_meta_data` -- CREATE TABLE `fields_meta_data` ( `id` varchar(255) NOT NULL, `name` varchar(255) DEFAULT NULL, `vname` varchar(255) DEFAULT NULL, `comments` varchar(255) DEFAULT NULL, `help` varchar(255) DEFAULT NULL, `custom_module` varchar(255) DEFAULT NULL, `type` varchar(255) DEFAULT NULL, `len` int(11) DEFAULT NULL, `required` tinyint(1) DEFAULT '0', `default_value` varchar(255) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `audited` tinyint(1) DEFAULT '0', `massupdate` tinyint(1) DEFAULT '0', `duplicate_merge` smallint(6) DEFAULT '0', `reportable` tinyint(1) DEFAULT '1', `importable` varchar(255) DEFAULT NULL, `ext1` varchar(255) DEFAULT NULL, `ext2` varchar(255) DEFAULT NULL, `ext3` varchar(255) DEFAULT NULL, `ext4` text, PRIMARY KEY (`id`), KEY `idx_meta_id_del` (`id`,`deleted`), KEY `idx_meta_cm_del` (`custom_module`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `folders` -- CREATE TABLE `folders` ( `id` char(36) NOT NULL, `name` varchar(25) DEFAULT NULL, `folder_type` varchar(25) DEFAULT NULL, `parent_folder` char(36) DEFAULT NULL, `has_child` tinyint(1) DEFAULT '0', `is_group` tinyint(1) DEFAULT '0', `is_dynamic` tinyint(1) DEFAULT '0', `dynamic_query` text, `assign_to_id` char(36) DEFAULT NULL, `created_by` char(36) NOT NULL, `modified_by` char(36) NOT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_parent_folder` (`parent_folder`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `folders_rel` -- CREATE TABLE `folders_rel` ( `id` char(36) NOT NULL, `folder_id` char(36) NOT NULL, `polymorphic_module` varchar(25) DEFAULT NULL, `polymorphic_id` char(36) NOT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_poly_module_poly_id` (`polymorphic_module`,`polymorphic_id`), KEY `idx_fr_id_deleted_poly` (`folder_id`,`deleted`,`polymorphic_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `folders_subscriptions` -- CREATE TABLE `folders_subscriptions` ( `id` char(36) NOT NULL, `folder_id` char(36) NOT NULL, `assigned_user_id` char(36) NOT NULL, PRIMARY KEY (`id`), KEY `idx_folder_id_assigned_user_id` (`folder_id`,`assigned_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `import_maps` -- CREATE TABLE `import_maps` ( `id` char(36) NOT NULL, `name` varchar(254) DEFAULT NULL, `source` varchar(36) DEFAULT NULL, `enclosure` varchar(1) DEFAULT ' ', `delimiter` varchar(1) DEFAULT ',', `module` varchar(36) DEFAULT NULL, `content` text, `default_values` text, `has_header` tinyint(1) DEFAULT '1', `deleted` tinyint(1) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `assigned_user_id` char(36) DEFAULT NULL, `is_published` varchar(3) DEFAULT 'no', PRIMARY KEY (`id`), KEY `idx_owner_module_name` (`assigned_user_id`,`module`,`name`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `inbound_email` -- CREATE TABLE `inbound_email` ( `id` varchar(36) NOT NULL, `deleted` tinyint(1) DEFAULT '0', `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `status` varchar(100) DEFAULT 'Active', `server_url` varchar(100) DEFAULT NULL, `email_user` varchar(100) DEFAULT NULL, `email_password` varchar(100) DEFAULT NULL, `port` int(5) DEFAULT NULL, `service` varchar(50) DEFAULT NULL, `mailbox` text, `delete_seen` tinyint(1) DEFAULT '0', `mailbox_type` varchar(10) DEFAULT NULL, `template_id` char(36) DEFAULT NULL, `stored_options` text, `group_id` char(36) DEFAULT NULL, `is_personal` tinyint(1) DEFAULT '0', `groupfolder_id` char(36) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `inbound_email_autoreply` -- CREATE TABLE `inbound_email_autoreply` ( `id` char(36) NOT NULL, `deleted` tinyint(1) DEFAULT '0', `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `autoreplied_to` varchar(100) DEFAULT NULL, `ie_id` char(36) NOT NULL, PRIMARY KEY (`id`), KEY `idx_ie_autoreplied_to` (`autoreplied_to`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `inbound_email_cache_ts` -- CREATE TABLE `inbound_email_cache_ts` ( `id` varchar(255) NOT NULL, `ie_timestamp` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `job_queue` -- CREATE TABLE `job_queue` ( `assigned_user_id` char(36) DEFAULT NULL, `id` char(36) NOT NULL, `name` varchar(255) DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `scheduler_id` char(36) DEFAULT NULL, `execute_time` datetime DEFAULT NULL, `status` varchar(20) DEFAULT NULL, `resolution` varchar(20) DEFAULT NULL, `message` text, `target` varchar(255) DEFAULT NULL, `data` text, `requeue` tinyint(1) DEFAULT '0', `retry_count` tinyint(4) DEFAULT NULL, `failure_count` tinyint(4) DEFAULT NULL, `job_delay` int(11) DEFAULT NULL, `client` varchar(255) DEFAULT NULL, `percent_complete` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_status_scheduler` (`status`,`scheduler_id`), KEY `idx_status_time` (`status`,`execute_time`,`date_entered`), KEY `idx_status_entered` (`status`,`date_entered`), KEY `idx_status_modified` (`status`,`date_modified`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `leads` -- CREATE TABLE `leads` ( `id` char(36) NOT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `description` text, `deleted` tinyint(1) DEFAULT '0', `assigned_user_id` char(36) DEFAULT NULL, `salutation` varchar(255) DEFAULT NULL, `first_name` varchar(100) DEFAULT NULL, `last_name` varchar(100) DEFAULT NULL, `title` varchar(100) DEFAULT NULL, `department` varchar(100) DEFAULT NULL, `do_not_call` tinyint(1) DEFAULT '0', `phone_home` varchar(100) DEFAULT NULL, `phone_mobile` varchar(100) DEFAULT NULL, `phone_work` varchar(100) DEFAULT NULL, `phone_other` varchar(100) DEFAULT NULL, `phone_fax` varchar(100) DEFAULT NULL, `primary_address_street` varchar(150) DEFAULT NULL, `primary_address_city` varchar(100) DEFAULT NULL, `primary_address_state` varchar(100) DEFAULT NULL, `primary_address_postalcode` varchar(20) DEFAULT NULL, `primary_address_country` varchar(255) DEFAULT NULL, `alt_address_street` varchar(150) DEFAULT NULL, `alt_address_city` varchar(100) DEFAULT NULL, `alt_address_state` varchar(100) DEFAULT NULL, `alt_address_postalcode` varchar(20) DEFAULT NULL, `alt_address_country` varchar(255) DEFAULT NULL, `assistant` varchar(75) DEFAULT NULL, `assistant_phone` varchar(100) DEFAULT NULL, `converted` tinyint(1) DEFAULT '0', `refered_by` varchar(100) DEFAULT NULL, `lead_source` varchar(100) DEFAULT NULL, `lead_source_description` text, `status` varchar(100) DEFAULT NULL, `status_description` text, `reports_to_id` char(36) DEFAULT NULL, `account_name` varchar(255) DEFAULT NULL, `account_description` text, `contact_id` char(36) DEFAULT NULL, `account_id` char(36) DEFAULT NULL, `opportunity_id` char(36) DEFAULT NULL, `opportunity_name` varchar(255) DEFAULT NULL, `opportunity_amount` varchar(50) DEFAULT NULL, `campaign_id` char(36) DEFAULT NULL, `birthdate` date DEFAULT NULL, `portal_name` varchar(255) DEFAULT NULL, `portal_app` varchar(255) DEFAULT NULL, `website` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_lead_acct_name_first` (`account_name`,`deleted`), KEY `idx_lead_last_first` (`last_name`,`first_name`,`deleted`), KEY `idx_lead_del_stat` (`last_name`,`status`,`deleted`,`first_name`), KEY `idx_lead_opp_del` (`opportunity_id`,`deleted`), KEY `idx_leads_acct_del` (`account_id`,`deleted`), KEY `idx_del_user` (`deleted`,`assigned_user_id`), KEY `idx_lead_assigned` (`assigned_user_id`), KEY `idx_lead_contact` (`contact_id`), KEY `idx_reports_to` (`reports_to_id`), KEY `idx_lead_phone_work` (`phone_work`), KEY `idx_leads_id_del` (`id`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `leads_audit` -- CREATE TABLE `leads_audit` ( `id` char(36) NOT NULL, `parent_id` char(36) NOT NULL, `date_created` datetime DEFAULT NULL, `created_by` varchar(36) DEFAULT NULL, `field_name` varchar(100) DEFAULT NULL, `data_type` varchar(100) DEFAULT NULL, `before_value_string` varchar(255) DEFAULT NULL, `after_value_string` varchar(255) DEFAULT NULL, `before_value_text` text, `after_value_text` text, PRIMARY KEY (`id`), KEY `idx_leads_parent_id` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `linked_documents` -- CREATE TABLE `linked_documents` ( `id` varchar(36) NOT NULL, `parent_id` varchar(36) DEFAULT NULL, `parent_type` varchar(25) DEFAULT NULL, `document_id` varchar(36) DEFAULT NULL, `document_revision_id` varchar(36) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_parent_document` (`parent_type`,`parent_id`,`document_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `meetings` -- CREATE TABLE `meetings` ( `id` char(36) NOT NULL, `name` varchar(50) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `description` text, `deleted` tinyint(1) DEFAULT '0', `assigned_user_id` char(36) DEFAULT NULL, `location` varchar(50) DEFAULT NULL, `password` varchar(50) DEFAULT NULL, `join_url` varchar(200) DEFAULT NULL, `host_url` varchar(400) DEFAULT NULL, `displayed_url` varchar(400) DEFAULT NULL, `creator` varchar(50) DEFAULT NULL, `external_id` varchar(50) DEFAULT NULL, `duration_hours` int(3) DEFAULT NULL, `duration_minutes` int(2) DEFAULT NULL, `date_start` datetime DEFAULT NULL, `date_end` datetime DEFAULT NULL, `parent_type` varchar(100) DEFAULT NULL, `status` varchar(100) DEFAULT 'Planned', `type` varchar(255) DEFAULT 'Sugar', `parent_id` char(36) DEFAULT NULL, `reminder_time` int(11) DEFAULT '-1', `email_reminder_time` int(11) DEFAULT '-1', `email_reminder_sent` tinyint(1) DEFAULT '0', `outlook_id` varchar(255) DEFAULT NULL, `sequence` int(11) DEFAULT '0', `repeat_type` varchar(36) DEFAULT NULL, `repeat_interval` int(3) DEFAULT '1', `repeat_dow` varchar(7) DEFAULT NULL, `repeat_until` date DEFAULT NULL, `repeat_count` int(7) DEFAULT NULL, `repeat_parent_id` char(36) DEFAULT NULL, `recurring_source` varchar(36) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_mtg_name` (`name`), KEY `idx_meet_par_del` (`parent_id`,`parent_type`,`deleted`), KEY `idx_meet_stat_del` (`assigned_user_id`,`status`,`deleted`), KEY `idx_meet_date_start` (`date_start`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `meetings_contacts` -- CREATE TABLE `meetings_contacts` ( `id` varchar(36) NOT NULL, `meeting_id` varchar(36) DEFAULT NULL, `contact_id` varchar(36) DEFAULT NULL, `required` varchar(1) DEFAULT '1', `accept_status` varchar(25) DEFAULT 'none', `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_con_mtg_mtg` (`meeting_id`), KEY `idx_con_mtg_con` (`contact_id`), KEY `idx_meeting_contact` (`meeting_id`,`contact_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `meetings_leads` -- CREATE TABLE `meetings_leads` ( `id` varchar(36) NOT NULL, `meeting_id` varchar(36) DEFAULT NULL, `lead_id` varchar(36) DEFAULT NULL, `required` varchar(1) DEFAULT '1', `accept_status` varchar(25) DEFAULT 'none', `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_lead_meeting_meeting` (`meeting_id`), KEY `idx_lead_meeting_lead` (`lead_id`), KEY `idx_meeting_lead` (`meeting_id`,`lead_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `meetings_users` -- CREATE TABLE `meetings_users` ( `id` varchar(36) NOT NULL, `meeting_id` varchar(36) DEFAULT NULL, `user_id` varchar(36) DEFAULT NULL, `required` varchar(1) DEFAULT '1', `accept_status` varchar(25) DEFAULT 'none', `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_usr_mtg_mtg` (`meeting_id`), KEY `idx_usr_mtg_usr` (`user_id`), KEY `idx_meeting_users` (`meeting_id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `notes` -- CREATE TABLE `notes` ( `assigned_user_id` char(36) DEFAULT NULL, `id` char(36) NOT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `file_mime_type` varchar(100) DEFAULT NULL, `filename` varchar(255) DEFAULT NULL, `parent_type` varchar(255) DEFAULT NULL, `parent_id` char(36) DEFAULT NULL, `contact_id` char(36) DEFAULT NULL, `portal_flag` tinyint(1) DEFAULT NULL, `embed_flag` tinyint(1) DEFAULT '0', `description` text, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_note_name` (`name`), KEY `idx_notes_parent` (`parent_id`,`parent_type`), KEY `idx_note_contact` (`contact_id`), KEY `idx_notes_assigned_del` (`deleted`,`assigned_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `oauth_consumer` -- CREATE TABLE `oauth_consumer` ( `id` char(36) NOT NULL, `name` varchar(255) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `description` text, `deleted` tinyint(1) DEFAULT '0', `assigned_user_id` char(36) DEFAULT NULL, `c_key` varchar(255) DEFAULT NULL, `c_secret` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `ckey` (`c_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `oauth_nonce` -- CREATE TABLE `oauth_nonce` ( `conskey` varchar(32) NOT NULL, `nonce` varchar(32) NOT NULL, `nonce_ts` bigint(20) DEFAULT NULL, PRIMARY KEY (`conskey`,`nonce`), KEY `oauth_nonce_keyts` (`conskey`,`nonce_ts`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `oauth_tokens` -- CREATE TABLE `oauth_tokens` ( `id` char(36) NOT NULL, `secret` varchar(32) DEFAULT NULL, `tstate` varchar(1) DEFAULT NULL, `consumer` char(36) NOT NULL, `token_ts` bigint(20) DEFAULT NULL, `verify` varchar(32) DEFAULT NULL, `deleted` tinyint(1) NOT NULL DEFAULT '0', `callback_url` varchar(255) DEFAULT NULL, `assigned_user_id` char(36) DEFAULT NULL, PRIMARY KEY (`id`,`deleted`), KEY `oauth_state_ts` (`tstate`,`token_ts`), KEY `constoken_key` (`consumer`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `opportunities` -- CREATE TABLE `opportunities` ( `id` char(36) NOT NULL, `name` varchar(50) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `description` text, `deleted` tinyint(1) DEFAULT '0', `assigned_user_id` char(36) DEFAULT NULL, `opportunity_type` varchar(255) DEFAULT NULL, `campaign_id` char(36) DEFAULT NULL, `lead_source` varchar(50) DEFAULT NULL, `amount` double DEFAULT NULL, `amount_usdollar` double DEFAULT NULL, `currency_id` char(36) DEFAULT NULL, `date_closed` date DEFAULT NULL, `next_step` varchar(100) DEFAULT NULL, `sales_stage` varchar(255) DEFAULT NULL, `probability` double DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_opp_name` (`name`), KEY `idx_opp_assigned` (`assigned_user_id`), KEY `idx_opp_id_deleted` (`id`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `opportunities_audit` -- CREATE TABLE `opportunities_audit` ( `id` char(36) NOT NULL, `parent_id` char(36) NOT NULL, `date_created` datetime DEFAULT NULL, `created_by` varchar(36) DEFAULT NULL, `field_name` varchar(100) DEFAULT NULL, `data_type` varchar(100) DEFAULT NULL, `before_value_string` varchar(255) DEFAULT NULL, `after_value_string` varchar(255) DEFAULT NULL, `before_value_text` text, `after_value_text` text, PRIMARY KEY (`id`), KEY `idx_opportunities_parent_id` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `opportunities_contacts` -- CREATE TABLE `opportunities_contacts` ( `id` varchar(36) NOT NULL, `contact_id` varchar(36) DEFAULT NULL, `opportunity_id` varchar(36) DEFAULT NULL, `contact_role` varchar(50) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_con_opp_con` (`contact_id`), KEY `idx_con_opp_opp` (`opportunity_id`), KEY `idx_opportunities_contacts` (`opportunity_id`,`contact_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `outbound_email` -- CREATE TABLE `outbound_email` ( `id` char(36) NOT NULL, `name` varchar(50) DEFAULT NULL, `type` varchar(15) DEFAULT 'user', `user_id` char(36) NOT NULL, `mail_sendtype` varchar(8) DEFAULT 'smtp', `mail_smtptype` varchar(20) DEFAULT 'other', `mail_smtpserver` varchar(100) DEFAULT NULL, `mail_smtpport` int(5) DEFAULT '0', `mail_smtpuser` varchar(100) DEFAULT NULL, `mail_smtppass` varchar(100) DEFAULT NULL, `mail_smtpauth_req` tinyint(1) DEFAULT '0', `mail_smtpssl` int(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `oe_user_id_idx` (`id`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `outbound_email` -- INSERT INTO `outbound_email` VALUES ('1523eece-e45f-e281-16db-5954ac7be06b', 'system', 'system', '1', 'SMTP', 'other', '', 25, '', '', 1, 0); -- -------------------------------------------------------- -- -- Table structure for table `project` -- CREATE TABLE `project` ( `id` char(36) NOT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `assigned_user_id` char(36) DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `name` varchar(50) DEFAULT NULL, `description` text, `deleted` tinyint(1) DEFAULT '0', `estimated_start_date` date DEFAULT NULL, `estimated_end_date` date DEFAULT NULL, `status` varchar(255) DEFAULT NULL, `priority` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `projects_accounts` -- CREATE TABLE `projects_accounts` ( `id` varchar(36) NOT NULL, `account_id` varchar(36) DEFAULT NULL, `project_id` varchar(36) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_proj_acct_proj` (`project_id`), KEY `idx_proj_acct_acct` (`account_id`), KEY `projects_accounts_alt` (`project_id`,`account_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `projects_bugs` -- CREATE TABLE `projects_bugs` ( `id` varchar(36) NOT NULL, `bug_id` varchar(36) DEFAULT NULL, `project_id` varchar(36) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_proj_bug_proj` (`project_id`), KEY `idx_proj_bug_bug` (`bug_id`), KEY `projects_bugs_alt` (`project_id`,`bug_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `projects_cases` -- CREATE TABLE `projects_cases` ( `id` varchar(36) NOT NULL, `case_id` varchar(36) DEFAULT NULL, `project_id` varchar(36) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_proj_case_proj` (`project_id`), KEY `idx_proj_case_case` (`case_id`), KEY `projects_cases_alt` (`project_id`,`case_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `projects_contacts` -- CREATE TABLE `projects_contacts` ( `id` varchar(36) NOT NULL, `contact_id` varchar(36) DEFAULT NULL, `project_id` varchar(36) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_proj_con_proj` (`project_id`), KEY `idx_proj_con_con` (`contact_id`), KEY `projects_contacts_alt` (`project_id`,`contact_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `projects_opportunities` -- CREATE TABLE `projects_opportunities` ( `id` varchar(36) NOT NULL, `opportunity_id` varchar(36) DEFAULT NULL, `project_id` varchar(36) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_proj_opp_proj` (`project_id`), KEY `idx_proj_opp_opp` (`opportunity_id`), KEY `projects_opportunities_alt` (`project_id`,`opportunity_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `projects_products` -- CREATE TABLE `projects_products` ( `id` varchar(36) NOT NULL, `product_id` varchar(36) DEFAULT NULL, `project_id` varchar(36) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_proj_prod_project` (`project_id`), KEY `idx_proj_prod_product` (`product_id`), KEY `projects_products_alt` (`project_id`,`product_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `project_task` -- CREATE TABLE `project_task` ( `id` char(36) NOT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `project_id` char(36) NOT NULL, `project_task_id` int(11) DEFAULT NULL, `name` varchar(50) DEFAULT NULL, `status` varchar(255) DEFAULT NULL, `description` text, `predecessors` text, `date_start` date DEFAULT NULL, `time_start` int(11) DEFAULT NULL, `time_finish` int(11) DEFAULT NULL, `date_finish` date DEFAULT NULL, `duration` int(11) DEFAULT NULL, `duration_unit` text, `actual_duration` int(11) DEFAULT NULL, `percent_complete` int(11) DEFAULT NULL, `date_due` date DEFAULT NULL, `time_due` time DEFAULT NULL, `parent_task_id` int(11) DEFAULT NULL, `assigned_user_id` char(36) DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `priority` varchar(255) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `milestone_flag` tinyint(1) DEFAULT NULL, `order_number` int(11) DEFAULT '1', `task_number` int(11) DEFAULT NULL, `estimated_effort` int(11) DEFAULT NULL, `actual_effort` int(11) DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `utilization` int(11) DEFAULT '100', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `project_task_audit` -- CREATE TABLE `project_task_audit` ( `id` char(36) NOT NULL, `parent_id` char(36) NOT NULL, `date_created` datetime DEFAULT NULL, `created_by` varchar(36) DEFAULT NULL, `field_name` varchar(100) DEFAULT NULL, `data_type` varchar(100) DEFAULT NULL, `before_value_string` varchar(255) DEFAULT NULL, `after_value_string` varchar(255) DEFAULT NULL, `before_value_text` text, `after_value_text` text, PRIMARY KEY (`id`), KEY `idx_project_task_parent_id` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `prospects` -- CREATE TABLE `prospects` ( `id` char(36) NOT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `description` text, `deleted` tinyint(1) DEFAULT '0', `assigned_user_id` char(36) DEFAULT NULL, `salutation` varchar(255) DEFAULT NULL, `first_name` varchar(100) DEFAULT NULL, `last_name` varchar(100) DEFAULT NULL, `title` varchar(100) DEFAULT NULL, `department` varchar(255) DEFAULT NULL, `do_not_call` tinyint(1) DEFAULT '0', `phone_home` varchar(100) DEFAULT NULL, `phone_mobile` varchar(100) DEFAULT NULL, `phone_work` varchar(100) DEFAULT NULL, `phone_other` varchar(100) DEFAULT NULL, `phone_fax` varchar(100) DEFAULT NULL, `primary_address_street` varchar(150) DEFAULT NULL, `primary_address_city` varchar(100) DEFAULT NULL, `primary_address_state` varchar(100) DEFAULT NULL, `primary_address_postalcode` varchar(20) DEFAULT NULL, `primary_address_country` varchar(255) DEFAULT NULL, `alt_address_street` varchar(150) DEFAULT NULL, `alt_address_city` varchar(100) DEFAULT NULL, `alt_address_state` varchar(100) DEFAULT NULL, `alt_address_postalcode` varchar(20) DEFAULT NULL, `alt_address_country` varchar(255) DEFAULT NULL, `assistant` varchar(75) DEFAULT NULL, `assistant_phone` varchar(100) DEFAULT NULL, `tracker_key` int(11) NOT NULL AUTO_INCREMENT, `birthdate` date DEFAULT NULL, `lead_id` char(36) DEFAULT NULL, `account_name` varchar(150) DEFAULT NULL, `campaign_id` char(36) DEFAULT NULL, PRIMARY KEY (`id`), KEY `prospect_auto_tracker_key` (`tracker_key`), KEY `idx_prospects_last_first` (`last_name`,`first_name`,`deleted`), KEY `idx_prospecs_del_last` (`last_name`,`deleted`), KEY `idx_prospects_id_del` (`id`,`deleted`), KEY `idx_prospects_assigned` (`assigned_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `prospect_lists` -- CREATE TABLE `prospect_lists` ( `assigned_user_id` char(36) DEFAULT NULL, `id` char(36) NOT NULL, `name` varchar(50) DEFAULT NULL, `list_type` varchar(100) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `deleted` tinyint(1) DEFAULT NULL, `description` text, `domain_name` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_prospect_list_name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `prospect_lists_prospects` -- CREATE TABLE `prospect_lists_prospects` ( `id` varchar(36) NOT NULL, `prospect_list_id` varchar(36) DEFAULT NULL, `related_id` varchar(36) DEFAULT NULL, `related_type` varchar(25) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_plp_pro_id` (`prospect_list_id`), KEY `idx_plp_rel_id` (`related_id`,`related_type`,`prospect_list_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `prospect_list_campaigns` -- CREATE TABLE `prospect_list_campaigns` ( `id` varchar(36) NOT NULL, `prospect_list_id` varchar(36) DEFAULT NULL, `campaign_id` varchar(36) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_pro_id` (`prospect_list_id`), KEY `idx_cam_id` (`campaign_id`), KEY `idx_prospect_list_campaigns` (`prospect_list_id`,`campaign_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `relationships` -- CREATE TABLE `relationships` ( `id` char(36) NOT NULL, `relationship_name` varchar(150) DEFAULT NULL, `lhs_module` varchar(100) DEFAULT NULL, `lhs_table` varchar(64) DEFAULT NULL, `lhs_key` varchar(64) DEFAULT NULL, `rhs_module` varchar(100) DEFAULT NULL, `rhs_table` varchar(64) DEFAULT NULL, `rhs_key` varchar(64) DEFAULT NULL, `join_table` varchar(128) DEFAULT NULL, `join_key_lhs` varchar(128) DEFAULT NULL, `join_key_rhs` varchar(128) DEFAULT NULL, `relationship_type` varchar(64) DEFAULT NULL, `relationship_role_column` varchar(64) DEFAULT NULL, `relationship_role_column_value` varchar(50) DEFAULT NULL, `reverse` tinyint(1) DEFAULT '0', `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_rel_name` (`relationship_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `relationships` -- INSERT INTO `relationships` VALUES ('1202c0b8-5eca-9ea8-b015-5954ac3c2175', 'emails_notes_rel', 'Emails', 'emails', 'id', 'Notes', 'notes', 'parent_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('125647b3-55f3-a42e-c6c5-5954acad7a83', 'case_emails', 'Cases', 'cases', 'id', 'Emails', 'emails', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Cases', 0, 0), ('1257cd60-45f1-362a-e4c4-5954aca580f8', 'consumer_tokens', 'OAuthKeys', 'oauth_consumer', 'id', 'OAuthTokens', 'oauth_tokens', 'consumer', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('12aec092-c1f1-f4c0-54a2-5954ac026fd0', 'opportunity_tasks', 'Opportunities', 'opportunities', 'id', 'Tasks', 'tasks', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Opportunities', 0, 0), ('137d6fef-9e20-93da-d04f-5954ac27403c', 'contact_notes_parent', 'Contacts', 'contacts', 'id', 'Notes', 'notes', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Contacts', 0, 0), ('16136706-4c4d-e23d-2402-5954ac3d3418', 'emails_contacts_rel', 'Emails', 'emails', 'id', 'Contacts', 'contacts', 'id', 'emails_beans', 'email_id', 'bean_id', 'many-to-many', 'bean_module', 'Contacts', 0, 0), ('163dbb3c-d514-5f12-68d7-5954ac50c4c3', 'oauthtokens_assigned_user', 'Users', 'users', 'id', 'OAuthTokens', 'oauth_tokens', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('178ed221-7ab3-5ad4-f1b2-5954ac92f3d8', 'contact_campaign_log', 'Contacts', 'contacts', 'id', 'CampaignLog', 'campaign_log', 'target_id', NULL, NULL, NULL, 'one-to-many', 'target_type', 'Contacts', 0, 0), ('18d52058-465b-3299-fc5a-5954ac0b5202', 'opportunity_notes', 'Opportunities', 'opportunities', 'id', 'Notes', 'notes', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Opportunities', 0, 0), ('19b0bded-1b72-02d2-457f-5954ac903aee', 'projects_opportunities', 'Project', 'project', 'id', 'Opportunities', 'opportunities', 'id', 'projects_opportunities', 'project_id', 'opportunity_id', 'many-to-many', NULL, NULL, 0, 0), ('1a34c115-c957-f150-ac8e-5954ac720c53', 'emails_accounts_rel', 'Emails', 'emails', 'id', 'Accounts', 'accounts', 'id', 'emails_beans', 'email_id', 'bean_id', 'many-to-many', 'bean_module', 'Accounts', 0, 0), ('1b310601-7d4a-c75f-33cc-5954ac670ff0', 'oauthkeys_assigned_user', 'Users', 'users', 'id', 'OAuthKeys', 'oauthkeys', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('1d2e7392-780c-eec8-2822-5954acc0dc76', 'documents_cases', 'Documents', 'documents', 'id', 'Cases', 'cases', 'id', 'documents_cases', 'document_id', 'case_id', 'many-to-many', NULL, NULL, 0, 0), ('1e484f36-2b2f-3566-44c7-5954ace69994', 'emails_leads_rel', 'Emails', 'emails', 'id', 'Leads', 'leads', 'id', 'emails_beans', 'email_id', 'bean_id', 'many-to-many', 'bean_module', 'Leads', 0, 0), ('1eef2d95-8107-f147-9708-5954acfe2772', 'opportunity_emails', 'Opportunities', 'opportunities', 'id', 'Emails', 'emails', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Opportunities', 0, 0), ('1f132d92-ad1e-f354-4db8-5954ac1f744b', 'project_tasks_notes', 'ProjectTask', 'project_task', 'id', 'Notes', 'notes', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'ProjectTask', 0, 0), ('1fb81a7f-1f05-4e9a-61d9-5954acbc3d8e', 'campaignlog_contact', 'CampaignLog', 'campaign_log', 'related_id', 'Contacts', 'contacts', 'id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('1fe24e8a-0c74-10f6-4be3-5954ac3088df', 'calls_leads', 'Calls', 'calls', 'id', 'Leads', 'leads', 'id', 'calls_leads', 'call_id', 'lead_id', 'many-to-many', NULL, NULL, 0, 0), ('225763a3-fdaf-88d6-0f90-5954ace13b0a', 'emails_meetings_rel', 'Emails', 'emails', 'id', 'Meetings', 'meetings', 'parent_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('23a0b7fa-26d2-78b1-d292-5954acd73606', 'campaignlog_lead', 'CampaignLog', 'campaign_log', 'related_id', 'Leads', 'leads', 'id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('24c703ec-b3e7-aee9-6cce-5954ac6a7453', 'project_tasks_tasks', 'ProjectTask', 'project_task', 'id', 'Tasks', 'tasks', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'ProjectTask', 0, 0), ('25138664-f0bb-c31d-1a2c-5954acc6226f', 'opportunity_leads', 'Opportunities', 'opportunities', 'id', 'Leads', 'leads', 'opportunity_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('27b3ae7e-bf2b-e12a-1881-5954acf69fca', 'campaignlog_created_opportunities', 'CampaignLog', 'campaign_log', 'related_id', 'Opportunities', 'opportunities', 'id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('2adab635-e8f0-c13d-835f-5954ac1629b3', 'project_tasks_meetings', 'ProjectTask', 'project_task', 'id', 'Meetings', 'meetings', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'ProjectTask', 0, 0), ('2b34499b-5c7f-e596-8a48-5954ac4d9234', 'opportunity_currencies', 'Opportunities', 'opportunities', 'currency_id', 'Currencies', 'currencies', 'id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('2bc284ba-261f-8cfb-0c51-5954ac900207', 'campaignlog_targeted_users', 'CampaignLog', 'campaign_log', 'target_id', 'Users', 'users', 'id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('2fd78a1c-0a3b-1957-82a3-5954ace9a20f', 'campaignlog_sent_emails', 'CampaignLog', 'campaign_log', 'related_id', 'Emails', 'emails', 'id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('30f37a76-4208-06f6-a5bc-5954acedf695', 'project_tasks_calls', 'ProjectTask', 'project_task', 'id', 'Calls', 'calls', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'ProjectTask', 0, 0), ('314eb562-1d47-9a03-c670-5954ac9d44ca', 'opportunities_campaign', 'Campaigns', 'campaigns', 'id', 'Opportunities', 'opportunities', 'campaign_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('31de5ec6-9a31-9d6d-a1fe-5954acc1a41f', 'documents_contacts', 'Documents', 'documents', 'id', 'Contacts', 'contacts', 'id', 'documents_contacts', 'document_id', 'contact_id', 'many-to-many', NULL, NULL, 0, 0), ('37087e17-f1af-69e3-0476-5954acdc3a45', 'project_tasks_emails', 'ProjectTask', 'project_task', 'id', 'Emails', 'emails', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'ProjectTask', 0, 0), ('387cccca-96ef-b70b-c056-5954ac3dd544', 'calls_users', 'Calls', 'calls', 'id', 'Users', 'users', 'id', 'calls_users', 'call_id', 'user_id', 'many-to-many', NULL, NULL, 0, 0), ('3d2b4c72-a947-ec06-8874-5954ac5aeb5a', 'project_tasks_assigned_user', 'Users', 'users', 'id', 'ProjectTask', 'project_task', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('3e834fe6-ac59-cdbe-7cf8-5954ac4011aa', 'prospect_list_campaigns', 'ProspectLists', 'prospect_lists', 'id', 'Campaigns', 'campaigns', 'id', 'prospect_list_campaigns', 'prospect_list_id', 'campaign_id', 'many-to-many', NULL, NULL, 0, 0), ('3fa708f8-bafd-9f1b-ab30-5954ac667977', 'emails_assigned_user', 'Users', 'users', 'id', 'Emails', 'emails', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('41d603bb-8112-415c-3716-5954ac011dab', 'schedulers_created_by_rel', 'Users', 'users', 'id', 'Schedulers', 'schedulers', 'created_by', NULL, NULL, NULL, 'one-to-one', NULL, NULL, 0, 0), ('4346f170-dee2-0e87-6167-5954aca9b225', 'project_tasks_modified_user', 'Users', 'users', 'id', 'ProjectTask', 'project_task', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('46535591-2ad3-8f95-7bbb-5954acd32e44', 'documents_opportunities', 'Documents', 'documents', 'id', 'Opportunities', 'opportunities', 'id', 'documents_opportunities', 'document_id', 'opportunity_id', 'many-to-many', NULL, NULL, 0, 0), ('4826f95d-b17a-ce57-6c3f-5954ac8b2084', 'schedulers_modified_user_id_rel', 'Users', 'users', 'id', 'Schedulers', 'schedulers', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('4968c4d5-0f13-f727-a73e-5954acc95b1c', 'project_tasks_created_by', 'Users', 'users', 'id', 'ProjectTask', 'project_task', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('4a7d15f5-db13-96f5-7161-5954acd0feaf', 'prospectlists_assigned_user', 'Users', 'users', 'id', 'prospectlists', 'prospect_lists', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('4c9e096d-2d60-e706-ebf6-5954ac408e10', 'campaign_modified_user', 'Users', 'users', 'id', 'Campaigns', 'campaigns', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('4dd6a010-d8a2-f20a-5c9d-5954ace6fdf8', 'schedulers_jobs_rel', 'Schedulers', 'schedulers', 'id', 'SchedulersJobs', 'job_queue', 'scheduler_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('4e4e0f0a-c16d-7069-fb07-5954ac055e13', 'tasks_modified_user', 'Users', 'users', 'id', 'Tasks', 'tasks', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('4ee3f1ba-7c5d-8138-ec1e-5954ace799ed', 'cases_bugs', 'Cases', 'cases', 'id', 'Bugs', 'bugs', 'id', 'cases_bugs', 'case_id', 'bug_id', 'many-to-many', NULL, NULL, 0, 0), ('4f78a64d-ee78-67e9-71c8-5954acc0e541', 'leads_documents', 'Leads', 'leads', 'id', 'Documents', 'documents', 'id', 'linked_documents', 'parent_id', 'document_id', 'many-to-many', 'parent_type', 'Leads', 0, 0), ('50500f5f-a554-2e22-376e-5954acbb90e5', 'users_email_addresses', 'Users', 'users', 'id', 'EmailAddresses', 'email_addresses', 'id', 'email_addr_bean_rel', 'bean_id', 'email_address_id', 'many-to-many', 'bean_module', 'Users', 0, 0), ('5114f080-43c4-151d-55ca-5954ac1a0b91', 'leads_modified_user', 'Users', 'users', 'id', 'Leads', 'leads', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('52ce0f91-30ca-42f1-5afc-5954ac222266', 'contact_notes', 'Contacts', 'contacts', 'id', 'Notes', 'notes', 'contact_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('52ebe10e-9444-c7a1-c074-5954ac7e05b9', 'prospect_list_contacts', 'ProspectLists', 'prospect_lists', 'id', 'Contacts', 'contacts', 'id', 'prospect_lists_prospects', 'prospect_list_id', 'related_id', 'many-to-many', 'related_type', 'Contacts', 0, 0), ('55ae27bf-3224-e92f-140b-5954acc1f22c', 'leads_created_by', 'Users', 'users', 'id', 'Leads', 'leads', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('561de191-355a-bd52-839d-5954ac6e7b27', 'tasks_created_by', 'Users', 'users', 'id', 'Tasks', 'tasks', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('5769ed77-1409-b615-e06a-5954ac04182f', 'accounts_modified_user', 'Users', 'users', 'id', 'Accounts', 'accounts', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('58000906-7fb4-1683-899d-5954ac4937fc', 'opportunities_assigned_user', 'Users', 'users', 'id', 'Opportunities', 'opportunities', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('58f614bf-d2fa-6138-ca0f-5954acf43777', 'sugarfeed_modified_user', 'Users', 'users', 'id', 'SugarFeed', 'sugarfeed', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('59bf77ba-fa23-2832-73fb-5954ac4edb31', 'documents_modified_user', 'Users', 'users', 'id', 'Documents', 'documents', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('5ac25a9a-57d4-61f4-c96a-5954aca8aae1', 'leads_assigned_user', 'Users', 'users', 'id', 'Leads', 'leads', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('5d305d3d-693c-c74e-36d3-5954ac766e1c', 'accounts_created_by', 'Users', 'users', 'id', 'Accounts', 'accounts', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('5d83e01d-3a9a-2f3f-3422-5954ac72270a', 'documents_created_by', 'Users', 'users', 'id', 'Documents', 'documents', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('5edcf032-81ae-5d5a-0c56-5954acafb780', 'leads_email_addresses', 'Leads', 'leads', 'id', 'EmailAddresses', 'email_addresses', 'id', 'email_addr_bean_rel', 'bean_id', 'email_address_id', 'many-to-many', 'bean_module', 'Leads', 0, 0), ('5f206ae3-8058-4c24-568c-5954ac304da0', 'prospect_list_prospects', 'ProspectLists', 'prospect_lists', 'id', 'Prospects', 'prospects', 'id', 'prospect_lists_prospects', 'prospect_list_id', 'related_id', 'many-to-many', 'related_type', 'Prospects', 0, 0), ('604841c3-035b-7cab-c332-5954ac32b6ec', 'meetings_contacts', 'Meetings', 'meetings', 'id', 'Contacts', 'contacts', 'id', 'meetings_contacts', 'meeting_id', 'contact_id', 'many-to-many', NULL, NULL, 0, 0), ('613afb13-4b40-5a78-10d9-5954acb1d66d', 'accounts_assigned_user', 'Users', 'users', 'id', 'Accounts', 'accounts', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('61900b1d-f008-a3dd-7750-5954ace5a4d0', 'documents_assigned_user', 'Users', 'users', 'id', 'Documents', 'documents', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('61c20e76-fdae-3683-ed88-5954ac56503e', 'case_notes', 'Cases', 'cases', 'id', 'Notes', 'notes', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Cases', 0, 0), ('62ed210f-45e4-8c10-529b-5954acb50372', 'leads_email_addresses_primary', 'Leads', 'leads', 'id', 'EmailAddresses', 'email_addresses', 'id', 'email_addr_bean_rel', 'bean_id', 'email_address_id', 'many-to-many', 'primary_address', '1', 0, 0), ('63360bd0-87c5-3198-2b9d-5954acb372a2', 'projects_notes', 'Project', 'project', 'id', 'Notes', 'notes', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Project', 0, 0), ('64881d65-2b3a-61cf-2299-5954ac4cfee4', 'schedulersjobs_assigned_user', 'Users', 'users', 'id', 'SchedulersJobs', 'schedulersjobs', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('656a3db1-22ef-6900-c0bf-5954acd5e385', 'contacts_bugs', 'Contacts', 'contacts', 'id', 'Bugs', 'bugs', 'id', 'contacts_bugs', 'contact_id', 'bug_id', 'many-to-many', NULL, NULL, 0, 0), ('658d1ef3-2eeb-5eb4-b00f-5954ac8fe2b3', 'accounts_email_addresses', 'Accounts', 'accounts', 'id', 'EmailAddresses', 'email_addresses', 'id', 'email_addr_bean_rel', 'bean_id', 'email_address_id', 'many-to-many', 'bean_module', 'Accounts', 0, 0), ('65ac0cb5-458b-81e9-b493-5954acbe2ca0', 'document_revisions', 'Documents', 'documents', 'id', 'DocumentRevisions', 'document_revisions', 'document_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('66900c1f-43b2-55d5-9eed-5954ac071b18', 'meetings_notes', 'Meetings', 'meetings', 'id', 'Notes', 'notes', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Meetings', 0, 0), ('6712d093-c1d6-4d9e-c104-5954ac105dd7', 'projects_tasks', 'Project', 'project', 'id', 'Tasks', 'tasks', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Project', 0, 0), ('6717ab2c-b810-3c12-0a14-5954acc4612c', 'lead_direct_reports', 'Leads', 'leads', 'id', 'Leads', 'leads', 'reports_to_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('677e0c12-963c-fe8d-c4a2-5954ace31d1a', 'opportunity_calls', 'Opportunities', 'opportunities', 'id', 'Calls', 'calls', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Opportunities', 0, 0), ('68844d9f-09cb-b77d-fc08-5954ac8cac34', 'bugs_modified_user', 'Users', 'users', 'id', 'Bugs', 'bugs', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('68ff6b21-4345-6fdb-b163-5954ac2cbd46', 'sugarfeed_created_by', 'Users', 'users', 'id', 'SugarFeed', 'sugarfeed', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('6968bfd1-b587-1fa9-dc52-5954aca041ac', 'accounts_email_addresses_primary', 'Accounts', 'accounts', 'id', 'EmailAddresses', 'email_addresses', 'id', 'email_addr_bean_rel', 'bean_id', 'email_address_id', 'many-to-many', 'primary_address', '1', 0, 0), ('6b17ed76-e10b-cdb8-100b-5954aca9e5bb', 'lead_tasks', 'Leads', 'leads', 'id', 'Tasks', 'tasks', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Leads', 0, 0), ('6b2a79ff-5dc0-eeee-fed7-5954ac439a5e', 'projects_meetings', 'Project', 'project', 'id', 'Meetings', 'meetings', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Project', 0, 0), ('6d7a9c2b-dd1a-ef9f-c1af-5954ac4de831', 'member_accounts', 'Accounts', 'accounts', 'id', 'Accounts', 'accounts', 'parent_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('6e4a5d38-f781-a914-9af2-5954ac0b78b8', 'bugs_created_by', 'Users', 'users', 'id', 'Bugs', 'bugs', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('6f330711-661f-42d9-7d18-5954acc1dcd9', 'lead_notes', 'Leads', 'leads', 'id', 'Notes', 'notes', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Leads', 0, 0), ('6f493ca7-3327-e9d5-7508-5954acc3755a', 'projects_calls', 'Project', 'project', 'id', 'Calls', 'calls', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Project', 0, 0), ('6f6c8574-6a2d-6a3b-641f-5954ace58d47', 'prospect_list_leads', 'ProspectLists', 'prospect_lists', 'id', 'Leads', 'leads', 'id', 'prospect_lists_prospects', 'prospect_list_id', 'related_id', 'many-to-many', 'related_type', 'Leads', 0, 0), ('71383a77-5c55-0c3e-68b6-5954ac25642f', 'notes_assigned_user', 'Users', 'users', 'id', 'Notes', 'notes', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('71690479-6ac8-650e-8ce9-5954ac62ddf7', 'projects_contacts', 'Project', 'project', 'id', 'Contacts', 'contacts', 'id', 'projects_contacts', 'project_id', 'contact_id', 'many-to-many', NULL, NULL, 0, 0), ('71858ce5-fc2d-d631-de6d-5954ac4afc4e', 'account_cases', 'Accounts', 'accounts', 'id', 'Cases', 'cases', 'account_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('735bfa8a-36ab-932a-a8b0-5954ac9ff236', 'projects_emails', 'Project', 'project', 'id', 'Emails', 'emails', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Project', 0, 0), ('73868086-d6f8-f6f6-6a9e-5954ac9ed6f8', 'lead_meetings', 'Leads', 'leads', 'id', 'Meetings', 'meetings', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Leads', 0, 0), ('74487d2d-76cb-b761-3ce1-5954ac507847', 'meetings_leads', 'Meetings', 'meetings', 'id', 'Leads', 'leads', 'id', 'meetings_leads', 'meeting_id', 'lead_id', 'many-to-many', NULL, NULL, 0, 0), ('747429d7-c725-8a39-1bef-5954acffd1fa', 'bugs_assigned_user', 'Users', 'users', 'id', 'Bugs', 'bugs', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('759b2789-b8c9-16bd-27f8-5954ace763a1', 'account_tasks', 'Accounts', 'accounts', 'id', 'Tasks', 'tasks', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Accounts', 0, 0), ('7713c480-57c0-5412-ab95-5954ac2180fe', 'notes_modified_user', 'Users', 'users', 'id', 'Notes', 'notes', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('773d6eb1-a102-d92f-039e-5954acc40840', 'sugarfeed_assigned_user', 'Users', 'users', 'id', 'SugarFeed', 'sugarfeed', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('777847ad-95c9-59c7-49e7-5954ac506189', 'projects_project_tasks', 'Project', 'project', 'id', 'ProjectTask', 'project_task', 'project_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('77945c31-752b-2db1-3824-5954acdd4a0b', 'lead_calls', 'Leads', 'leads', 'id', 'Calls', 'calls', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Leads', 0, 0), ('784a157e-d281-ec8f-983a-5954acfe553e', 'revisions_created_by', 'Users', 'users', 'id', 'DocumentRevisions', 'document_revisions', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('79aa96e8-6895-80ef-d72e-5954ac0610f5', 'prospect_list_users', 'ProspectLists', 'prospect_lists', 'id', 'Users', 'users', 'id', 'prospect_lists_prospects', 'prospect_list_id', 'related_id', 'many-to-many', 'related_type', 'Users', 0, 0), ('79b31afb-a02b-1e51-26ad-5954ac93e096', 'account_notes', 'Accounts', 'accounts', 'id', 'Notes', 'notes', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Accounts', 0, 0), ('7a8041cb-bc1e-3821-2c36-5954ace77fcc', 'accounts_bugs', 'Accounts', 'accounts', 'id', 'Bugs', 'bugs', 'id', 'accounts_bugs', 'account_id', 'bug_id', 'many-to-many', NULL, NULL, 0, 0), ('7a83e9c3-d53f-c882-4361-5954ac81fc56', 'bug_tasks', 'Bugs', 'bugs', 'id', 'Tasks', 'tasks', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Bugs', 0, 0), ('7b30a93c-8af4-f558-535a-5954aca27be5', 'emailtemplates_assigned_user', 'Users', 'users', 'id', 'EmailTemplates', 'email_templates', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('7b8d373f-d178-05a7-6653-5954ac112234', 'projects_assigned_user', 'Users', 'users', 'id', 'Project', 'project', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('7bae4fe1-6036-abc3-ea73-5954ac10e0f4', 'lead_emails', 'Leads', 'leads', 'id', 'Emails', 'emails', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Leads', 0, 0), ('7d31bd45-85be-698e-b60c-5954ac09bd59', 'notes_created_by', 'Users', 'users', 'id', 'Notes', 'notes', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('7dc4253f-9774-e68f-400a-5954acc0766a', 'prospects_modified_user', 'Users', 'users', 'id', 'Prospects', 'prospects', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('7dc9538d-b7b7-96cf-f80e-5954aca60f77', 'account_meetings', 'Accounts', 'accounts', 'id', 'Meetings', 'meetings', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Accounts', 0, 0), ('7de70b8a-ccde-e85b-e1d6-5954ac1299c4', 'contacts_cases', 'Contacts', 'contacts', 'id', 'Cases', 'cases', 'id', 'contacts_cases', 'contact_id', 'case_id', 'many-to-many', NULL, NULL, 0, 0), ('7fa170fa-1a25-c210-8ec3-5954acfd1e32', 'projects_modified_user', 'Users', 'users', 'id', 'Project', 'project', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('7fc41d1f-7e94-03bd-af8d-5954ac500efd', 'lead_campaign_log', 'Leads', 'leads', 'id', 'CampaignLog', 'campaign_log', 'target_id', NULL, NULL, NULL, 'one-to-many', 'target_type', 'Leads', 0, 0), ('809eeae5-15c9-2268-1a94-5954ac12c9d8', 'bug_meetings', 'Bugs', 'bugs', 'id', 'Meetings', 'meetings', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Bugs', 0, 0), ('81754957-664f-cb5d-b915-5954ac16caaa', 'prospects_created_by', 'Users', 'users', 'id', 'Prospects', 'prospects', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('81e18797-b266-a7f0-caa4-5954ac947996', 'account_calls', 'Accounts', 'accounts', 'id', 'Calls', 'calls', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Accounts', 0, 0), ('83c7dc39-7ac2-61eb-ef51-5954ac89a00f', 'projects_created_by', 'Users', 'users', 'id', 'Project', 'project', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('84a44b0e-13fa-5c1b-0e71-5954ac62a43d', 'meetings_users', 'Meetings', 'meetings', 'id', 'Users', 'users', 'id', 'meetings_users', 'meeting_id', 'user_id', 'many-to-many', NULL, NULL, 0, 0), ('84f10fe2-e77f-126b-d3ef-5954ac84a26d', 'campaign_campaigntrakers', 'Campaigns', 'campaigns', 'id', 'CampaignTrackers', 'campaign_trkrs', 'campaign_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('85864198-39b1-74ff-7faf-5954ac8ce8b5', 'prospects_assigned_user', 'Users', 'users', 'id', 'Prospects', 'prospects', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('85f18f9f-1dd9-b2ed-1bb3-5954acef9c81', 'account_emails', 'Accounts', 'accounts', 'id', 'Emails', 'emails', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Accounts', 0, 0), ('863aae22-db4e-2ccf-66fe-5954acb02f49', 'prospect_list_accounts', 'ProspectLists', 'prospect_lists', 'id', 'Accounts', 'accounts', 'id', 'prospect_lists_prospects', 'prospect_list_id', 'related_id', 'many-to-many', 'related_type', 'Accounts', 0, 0), ('86c167fa-a434-a4ac-1a54-5954ac5d096d', 'bug_calls', 'Bugs', 'bugs', 'id', 'Calls', 'calls', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Bugs', 0, 0), ('86ff099d-80d6-16fd-e289-5954acbe1932', 'tasks_assigned_user', 'Users', 'users', 'id', 'Tasks', 'tasks', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('89990d49-22c8-187b-896e-5954ac607b3c', 'prospects_email_addresses', 'Prospects', 'prospects', 'id', 'EmailAddresses', 'email_addresses', 'id', 'email_addr_bean_rel', 'bean_id', 'email_address_id', 'many-to-many', 'bean_module', 'Prospects', 0, 0), ('8a07b1f0-cc8f-ae22-3dc6-5954ac8eda32', 'account_leads', 'Accounts', 'accounts', 'id', 'Leads', 'leads', 'account_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('8cf17ef9-f6a5-777f-3c70-5954ac66e0d8', 'bug_emails', 'Bugs', 'bugs', 'id', 'Emails', 'emails', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Bugs', 0, 0), ('8d159504-8c34-b99e-e6a4-5954ac1b3208', 'tasks_notes', 'Tasks', 'tasks', 'id', 'Notes', 'notes', 'parent_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('8db77736-8a8f-463a-6f51-5954acdc380d', 'prospects_email_addresses_primary', 'Prospects', 'prospects', 'id', 'EmailAddresses', 'email_addresses', 'id', 'email_addr_bean_rel', 'bean_id', 'email_address_id', 'many-to-many', 'primary_address', '1', 0, 0), ('8e1e4398-f6d8-2419-d216-5954ac1a8d3b', 'account_campaign_log', 'Accounts', 'accounts', 'id', 'CampaignLog', 'campaign_log', 'target_id', NULL, NULL, NULL, 'one-to-many', 'target_type', 'Accounts', 0, 0), ('91d1fe44-d7f3-f540-17f9-5954ac994225', 'prospect_tasks', 'Prospects', 'prospects', 'id', 'Tasks', 'tasks', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Prospects', 0, 0), ('93021380-8c16-f56b-587d-5954ac8678e7', 'bug_notes', 'Bugs', 'bugs', 'id', 'Notes', 'notes', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Bugs', 0, 0), ('95e4bea9-f049-20a7-48bc-5954ac01db2b', 'prospect_notes', 'Prospects', 'prospects', 'id', 'Notes', 'notes', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Prospects', 0, 0), ('960c0b24-e173-3f07-0dc6-5954acfd417d', 'contact_tasks', 'Contacts', 'contacts', 'id', 'Tasks', 'tasks', 'contact_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('991d09d3-c5d4-3778-1974-5954acf9e962', 'bugs_release', 'Releases', 'releases', 'id', 'Bugs', 'bugs', 'found_in_release', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('99fe9958-3b78-ea4e-d37f-5954ac37e63f', 'prospect_meetings', 'Prospects', 'prospects', 'id', 'Meetings', 'meetings', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Prospects', 0, 0), ('9c112b0e-ed9a-51c3-3d1b-5954acc04c9e', 'email_marketing_prospect_lists', 'EmailMarketing', 'email_marketing', 'id', 'ProspectLists', 'prospect_lists', 'id', 'email_marketing_prospect_lists', 'email_marketing_id', 'prospect_list_id', 'many-to-many', NULL, NULL, 0, 0), ('9db30c82-889f-43b8-3e71-5954ac278adf', 'emails_modified_user', 'Users', 'users', 'id', 'Emails', 'emails', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('9e148109-633b-fec1-ac74-5954ac341a6a', 'prospect_calls', 'Prospects', 'prospects', 'id', 'Calls', 'calls', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Prospects', 0, 0), ('9f3fe038-f06e-7efb-f399-5954acb0af5a', 'bugs_fixed_in_release', 'Releases', 'releases', 'id', 'Bugs', 'bugs', 'fixed_in_release', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('9f8c703d-47d6-10ce-a20e-5954acf60153', 'accounts_contacts', 'Accounts', 'accounts', 'id', 'Contacts', 'contacts', 'id', 'accounts_contacts', 'account_id', 'contact_id', 'many-to-many', NULL, NULL, 0, 0), ('a1454de7-c3a8-0b44-e9c8-5954ac0c4254', 'opportunities_contacts', 'Opportunities', 'opportunities', 'id', 'Contacts', 'contacts', 'id', 'opportunities_contacts', 'opportunity_id', 'contact_id', 'many-to-many', NULL, NULL, 0, 0), ('a220a31e-5014-010e-26f6-5954accfc05e', 'prospect_emails', 'Prospects', 'prospects', 'id', 'Emails', 'emails', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Prospects', 0, 0), ('a2c36dfc-748b-32f1-ca65-5954ac195b39', 'contacts_users', 'Contacts', 'contacts', 'id', 'Users', 'users', 'id', 'contacts_users', 'contact_id', 'user_id', 'many-to-many', NULL, NULL, 0, 0), ('a636104f-a24e-53c7-6917-5954ac31903e', 'prospect_campaign_log', 'Prospects', 'prospects', 'id', 'CampaignLog', 'campaign_log', 'target_id', NULL, NULL, NULL, 'one-to-many', 'target_type', 'Prospects', 0, 0), ('aaa3e9cd-a6ac-e377-7c4f-5954ac96048c', 'roles_users', 'Roles', 'roles', 'id', 'Users', 'users', 'id', 'roles_users', 'role_id', 'user_id', 'many-to-many', NULL, NULL, 0, 0), ('afeea7b0-6e2a-bfae-3b91-5954ac7d3d10', 'campaigns_modified_user', 'Users', 'users', 'id', 'Campaigns', 'campaigns', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('b092ac6a-78dc-5cf5-5119-5954acb20048', 'emails_bugs_rel', 'Emails', 'emails', 'id', 'Bugs', 'bugs', 'id', 'emails_beans', 'email_id', 'bean_id', 'many-to-many', 'bean_module', 'Bugs', 0, 0), ('b1a4e5f2-1d16-a4f8-3232-5954acaa1090', 'projects_accounts', 'Project', 'project', 'id', 'Accounts', 'accounts', 'id', 'projects_accounts', 'project_id', 'account_id', 'many-to-many', NULL, NULL, 0, 0), ('b2fe0dbe-5623-ed5a-dd50-5954ac6839fb', 'users_email_addresses_primary', 'Users', 'users', 'id', 'EmailAddresses', 'email_addresses', 'id', 'email_addr_bean_rel', 'bean_id', 'email_address_id', 'many-to-many', 'primary_address', '1', 0, 0), ('b3ff27fa-b4f4-daf4-0dba-5954ac674c6c', 'accounts_opportunities', 'Accounts', 'accounts', 'id', 'Opportunities', 'opportunities', 'id', 'accounts_opportunities', 'account_id', 'opportunity_id', 'many-to-many', NULL, NULL, 0, 0), ('b59af191-94c2-1650-3c1e-5954ac2d70e3', 'campaigns_created_by', 'Users', 'users', 'id', 'Campaigns', 'campaigns', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('b6a353bf-08cd-8626-d1e4-5954ace2cf8f', 'emails_cases_rel', 'Emails', 'emails', 'id', 'Cases', 'cases', 'id', 'emails_beans', 'email_id', 'bean_id', 'many-to-many', 'bean_module', 'Cases', 0, 0), ('b6c75fca-71c5-3414-6524-5954acb77f3b', 'calls_modified_user', 'Users', 'users', 'id', 'Calls', 'calls', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('b7700997-26c3-439f-055b-5954ac9c1cde', 'calls_contacts', 'Calls', 'calls', 'id', 'Contacts', 'contacts', 'id', 'calls_contacts', 'call_id', 'contact_id', 'many-to-many', NULL, NULL, 0, 0), ('bbbe1509-be1e-6ce1-d3ad-5954ac4bfc5d', 'campaigns_assigned_user', 'Users', 'users', 'id', 'Campaigns', 'campaigns', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('bc919501-4f3b-d2a4-fd32-5954ac53e7c8', 'calls_created_by', 'Users', 'users', 'id', 'Calls', 'calls', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('be050890-430b-e787-1ea5-5954acab0e5d', 'inbound_email_created_by', 'Users', 'users', 'id', 'InboundEmail', 'inbound_email', 'created_by', NULL, NULL, NULL, 'one-to-one', NULL, NULL, 0, 0), ('c09f8c63-6573-2de4-a7d9-5954acbbd989', 'calls_assigned_user', 'Users', 'users', 'id', 'Calls', 'calls', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('c1d79bfd-75ba-b4ec-9aa1-5954ace7432e', 'campaign_accounts', 'Campaigns', 'campaigns', 'id', 'Accounts', 'accounts', 'campaign_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('c37b041d-8b61-f9a6-4fd9-5954ac68dd63', 'case_meetings', 'Cases', 'cases', 'id', 'Meetings', 'meetings', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Cases', 0, 0), ('c3f67743-39e8-10f9-e77d-5954ac54c154', 'inbound_email_modified_user_id', 'Users', 'users', 'id', 'InboundEmail', 'inbound_email', 'modified_user_id', NULL, NULL, NULL, 'one-to-one', NULL, NULL, 0, 0), ('c4b82728-d388-86a6-3042-5954ac294033', 'calls_notes', 'Calls', 'calls', 'id', 'Notes', 'notes', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Calls', 0, 0), ('c4fc07e2-d5fe-294d-bed0-5954ac7fcd49', 'emails_opportunities_rel', 'Emails', 'emails', 'id', 'Opportunities', 'opportunities', 'id', 'emails_beans', 'email_id', 'bean_id', 'many-to-many', 'bean_module', 'Opportunities', 0, 0), ('c7f4863c-a8e8-ba71-1942-5954acf44c61', 'campaign_contacts', 'Campaigns', 'campaigns', 'id', 'Contacts', 'contacts', 'campaign_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('c8e2c288-2cb2-2099-c706-5954acc1ced6', 'contacts_modified_user', 'Users', 'users', 'id', 'Contacts', 'contacts', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('c9450511-e55c-5e85-abc5-5954ac8c70d7', 'opportunity_meetings', 'Opportunities', 'opportunities', 'id', 'Meetings', 'meetings', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Opportunities', 0, 0), ('cd1107ae-784c-0384-129f-5954ac6499bb', 'documents_bugs', 'Documents', 'documents', 'id', 'Bugs', 'bugs', 'id', 'documents_bugs', 'document_id', 'bug_id', 'many-to-many', NULL, NULL, 0, 0), ('ce1bc53f-f7eb-58c5-8fed-5954ac050d7e', 'campaign_leads', 'Campaigns', 'campaigns', 'id', 'Leads', 'leads', 'campaign_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('ce465caf-16fa-b045-6298-5954acd77c4b', 'projects_bugs', 'Project', 'project', 'id', 'Bugs', 'bugs', 'id', 'projects_bugs', 'project_id', 'bug_id', 'many-to-many', NULL, NULL, 0, 0), ('ce7994b5-32b3-87b4-4733-5954acaf3166', 'contacts_created_by', 'Users', 'users', 'id', 'Contacts', 'contacts', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('cf17d5b2-8a0d-e811-fb8d-5954ac161572', 'emails_tasks_rel', 'Emails', 'emails', 'id', 'Tasks', 'tasks', 'id', 'emails_beans', 'email_id', 'bean_id', 'many-to-many', 'bean_module', 'Tasks', 0, 0), ('d43a3f3c-8b60-ed16-e016-5954ac3ce520', 'campaign_prospects', 'Campaigns', 'campaigns', 'id', 'Prospects', 'prospects', 'campaign_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('d4958d1c-d7cc-814b-6dc9-5954acec5a0e', 'contacts_assigned_user', 'Users', 'users', 'id', 'Contacts', 'contacts', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('d5306625-9996-b222-d627-5954ac42ed19', 'emails_users_rel', 'Emails', 'emails', 'id', 'Users', 'users', 'id', 'emails_beans', 'email_id', 'bean_id', 'many-to-many', 'bean_module', 'Users', 0, 0), ('d556eae0-9367-4382-1114-5954ac3fd027', 'eapm_modified_user', 'Users', 'users', 'id', 'EAPM', 'eapm', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('d6b5a028-e693-4ab0-188e-5954acec6ed8', 'acl_roles_actions', 'ACLRoles', 'acl_roles', 'id', 'ACLActions', 'acl_actions', 'id', 'acl_roles_actions', 'role_id', 'action_id', 'many-to-many', NULL, NULL, 0, 0), ('d7800619-fa03-d517-33bf-5954acf8a6a1', 'email_template_email_marketings', 'EmailTemplates', 'email_templates', 'id', 'EmailMarketing', 'email_marketing', 'template_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('d8a0f3fb-dbe7-0e71-a562-5954ac2ed731', 'saved_search_assigned_user', 'Users', 'users', 'id', 'SavedSearch', 'saved_search', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('d92dd4a9-8b98-c440-a663-5954acb916ac', 'eapm_created_by', 'Users', 'users', 'id', 'EAPM', 'eapm', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('da533c31-064e-87f5-ba28-5954acae61b5', 'campaign_opportunities', 'Campaigns', 'campaigns', 'id', 'Opportunities', 'opportunities', 'campaign_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('dabde96a-6ace-8d14-a72f-5954ac2f72ad', 'contacts_email_addresses', 'Contacts', 'contacts', 'id', 'EmailAddresses', 'email_addresses', 'id', 'email_addr_bean_rel', 'bean_id', 'email_address_id', 'many-to-many', 'bean_module', 'Contacts', 0, 0), ('db515d14-dec7-64f9-fe4f-5954ac121484', 'emails_project_task_rel', 'Emails', 'emails', 'id', 'ProjectTask', 'project_task', 'id', 'emails_beans', 'email_id', 'bean_id', 'many-to-many', 'bean_module', 'ProjectTask', 0, 0), ('dc532a45-45ea-bbce-73ea-5954ac61fc9c', 'cases_modified_user', 'Users', 'users', 'id', 'Cases', 'cases', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('dd42b3ad-644a-101f-aa0f-5954ac5b14bf', 'eapm_assigned_user', 'Users', 'users', 'id', 'EAPM', 'eapm', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('dead6fdc-badb-f38b-dc35-5954ac4b8e73', 'projects_cases', 'Project', 'project', 'id', 'Cases', 'cases', 'id', 'projects_cases', 'project_id', 'case_id', 'many-to-many', NULL, NULL, 0, 0), ('def602aa-08a5-e695-41ce-5954acf19894', 'emails_created_by', 'Users', 'users', 'id', 'Emails', 'emails', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('e0763aee-1e8f-53bf-c0a9-5954ac8a01a7', 'campaign_email_marketing', 'Campaigns', 'campaigns', 'id', 'EmailMarketing', 'email_marketing', 'campaign_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('e083b9e0-98bb-2516-d0e5-5954acdc3884', 'meetings_modified_user', 'Users', 'users', 'id', 'Meetings', 'meetings', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('e16c1df6-a2d6-d23e-cb54-5954acaf43f0', 'emails_projects_rel', 'Emails', 'emails', 'id', 'Project', 'project', 'id', 'emails_beans', 'email_id', 'bean_id', 'many-to-many', 'bean_module', 'Project', 0, 0), ('e1db9a80-5935-a8d2-d2bf-5954ac320768', 'cases_created_by', 'Users', 'users', 'id', 'Cases', 'cases', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('e69309f8-d370-3ccd-dd82-5954acf6c67e', 'campaign_emailman', 'Campaigns', 'campaigns', 'id', 'EmailMan', 'emailman', 'campaign_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('e69547b0-ac13-b383-e841-5954ac49c90f', 'opportunities_modified_user', 'Users', 'users', 'id', 'Opportunities', 'opportunities', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('e6f600da-bb3d-7d9b-7117-5954ac695b37', 'contacts_email_addresses_primary', 'Contacts', 'contacts', 'id', 'EmailAddresses', 'email_addresses', 'id', 'email_addr_bean_rel', 'bean_id', 'email_address_id', 'many-to-many', 'primary_address', '1', 0, 0), ('e78d3b79-179e-8504-e985-5954ac1af3e2', 'emails_prospects_rel', 'Emails', 'emails', 'id', 'Prospects', 'prospects', 'id', 'emails_beans', 'email_id', 'bean_id', 'many-to-many', 'bean_module', 'Prospects', 0, 0), ('e845ad97-c8a2-1fcb-ae72-5954ac34510c', 'meetings_created_by', 'Users', 'users', 'id', 'Meetings', 'meetings', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('e846d182-65ff-fe67-156c-5954ac076595', 'cases_assigned_user', 'Users', 'users', 'id', 'Cases', 'cases', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('eb2a67ee-3525-a580-61d9-5954acdaf4f4', 'acl_roles_users', 'ACLRoles', 'acl_roles', 'id', 'Users', 'users', 'id', 'acl_roles_users', 'role_id', 'user_id', 'many-to-many', NULL, NULL, 0, 0), ('ecb5a364-8762-d01e-6d2d-5954ac562e17', 'campaign_campaignlog', 'Campaigns', 'campaigns', 'id', 'CampaignLog', 'campaign_log', 'campaign_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('ed11a51b-d15d-2a9c-fbab-5954acdfdc5c', 'contact_direct_reports', 'Contacts', 'contacts', 'id', 'Contacts', 'contacts', 'reports_to_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('edec0af9-9546-594b-68e3-5954acb170fa', 'oauthkeys_modified_user', 'Users', 'users', 'id', 'OAuthKeys', 'oauthkeys', 'modified_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('ee056773-267b-fd58-a74b-5954ac93853a', 'case_calls', 'Cases', 'cases', 'id', 'Calls', 'calls', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Cases', 0, 0), ('ee5eb91d-10b8-393e-f894-5954ac0c89bb', 'opportunities_created_by', 'Users', 'users', 'id', 'Opportunities', 'opportunities', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('ee745da7-900f-b4c0-c0e3-5954ac720c90', 'meetings_assigned_user', 'Users', 'users', 'id', 'Meetings', 'meetings', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('f093d45a-5bcf-b24c-502e-5954acf7564a', 'documents_accounts', 'Documents', 'documents', 'id', 'Accounts', 'accounts', 'id', 'documents_accounts', 'document_id', 'account_id', 'many-to-many', NULL, NULL, 0, 0), ('f1c36fad-8ebf-d21e-3e15-5954acc84d15', 'oauthkeys_created_by', 'Users', 'users', 'id', 'OAuthKeys', 'oauthkeys', 'created_by', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('f28bcefd-63c0-b12f-7338-5954acf007be', 'user_direct_reports', 'Users', 'users', 'id', 'Users', 'users', 'reports_to_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('f2d0d5b4-6fe0-69ab-6b20-5954ac84f9c8', 'campaign_assigned_user', 'Users', 'users', 'id', 'Campaigns', 'campaigns', 'assigned_user_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('f33a83f2-421d-d449-ad1b-5954ac5a1fcf', 'contact_leads', 'Contacts', 'contacts', 'id', 'Leads', 'leads', 'contact_id', NULL, NULL, NULL, 'one-to-many', NULL, NULL, 0, 0), ('f422537b-7fe4-c708-f784-5954ace73ba8', 'case_tasks', 'Cases', 'cases', 'id', 'Tasks', 'tasks', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Cases', 0, 0), ('f6c90363-b701-db43-90e5-5954ac22e4e9', 'contact_tasks_parent', 'Contacts', 'contacts', 'id', 'Tasks', 'tasks', 'parent_id', NULL, NULL, NULL, 'one-to-many', 'parent_type', 'Contacts', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `releases` -- CREATE TABLE `releases` ( `id` char(36) NOT NULL, `deleted` tinyint(1) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `name` varchar(50) DEFAULT NULL, `list_order` int(4) DEFAULT NULL, `status` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_releases` (`name`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `roles` -- CREATE TABLE `roles` ( `id` char(36) NOT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `name` varchar(150) DEFAULT NULL, `description` text, `modules` text, `deleted` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_role_id_del` (`id`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `roles_modules` -- CREATE TABLE `roles_modules` ( `id` varchar(36) NOT NULL, `role_id` varchar(36) DEFAULT NULL, `module_id` varchar(36) DEFAULT NULL, `allow` tinyint(1) DEFAULT '0', `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_role_id` (`role_id`), KEY `idx_module_id` (`module_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `roles_users` -- CREATE TABLE `roles_users` ( `id` varchar(36) NOT NULL, `role_id` varchar(36) DEFAULT NULL, `user_id` varchar(36) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_ru_role_id` (`role_id`), KEY `idx_ru_user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `saved_search` -- CREATE TABLE `saved_search` ( `id` char(36) NOT NULL, `name` varchar(150) DEFAULT NULL, `search_module` varchar(150) DEFAULT NULL, `deleted` tinyint(1) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `assigned_user_id` char(36) DEFAULT NULL, `contents` text, `description` text, PRIMARY KEY (`id`), KEY `idx_desc` (`name`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `schedulers` -- CREATE TABLE `schedulers` ( `id` varchar(36) NOT NULL, `deleted` tinyint(1) DEFAULT '0', `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `job` varchar(255) DEFAULT NULL, `date_time_start` datetime DEFAULT NULL, `date_time_end` datetime DEFAULT NULL, `job_interval` varchar(100) DEFAULT NULL, `time_from` time DEFAULT NULL, `time_to` time DEFAULT NULL, `last_run` datetime DEFAULT NULL, `status` varchar(100) DEFAULT NULL, `catch_up` tinyint(1) DEFAULT '1', PRIMARY KEY (`id`), KEY `idx_schedule` (`date_time_start`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `schedulers` -- INSERT INTO `schedulers` VALUES ('314b8e6e-02b8-8bee-2d67-5954acb0ebfe', 0, '[[regtime]]', '[[regtime]]', '1', '1', 'Prune Tracker Tables', 'function::trimTracker', '2005-01-01 19:15:01', '2020-12-31 23:59:59', '0::2::1::*::*', NULL, NULL, NULL, 'Active', 1), ('3560078a-d5e7-651c-b0f0-5954ac60ed9a', 0, '[[regtime]]', '[[regtime]]', '1', '1', 'Check Inbound Mailboxes', 'function::pollMonitoredInboxes', '2005-01-01 07:30:01', '2020-12-31 23:59:59', '*::*::*::*::*', NULL, NULL, NULL, 'Active', 0), ('392fda1e-77d0-90eb-5f26-5954ac1a9ad6', 0, '[[regtime]]', '[[regtime]]', '1', '1', 'Run Nightly Process Bounced Campaign Emails', 'function::pollMonitoredInboxesForBouncedCampaignEmails', '2005-01-01 15:30:01', '2020-12-31 23:59:59', '0::2-6::*::*::*', NULL, NULL, NULL, 'Active', 1), ('4b90f515-2823-816a-e53b-5954acf0820e', 0, '[[regtime]]', '[[regtime]]', '1', '1', 'Run Nightly Mass Email Campaigns', 'function::runMassEmailCampaign', '2005-01-01 06:15:01', '2020-12-31 23:59:59', '0::2-6::*::*::*', NULL, NULL, NULL, 'Active', 1), ('785d4f41-bde6-7308-b6b7-5954ac5ea94a', 0, '[[regtime]]', '[[regtime]]', '1', '1', 'Prune Database on 1st of Month', 'function::pruneDatabase', '2005-01-01 10:45:01', '2020-12-31 23:59:59', '0::4::1::*::*', NULL, NULL, NULL, 'Inactive', 0), ('7e78be6e-d25f-6b9d-abec-5954ac6ef708', 0, '[[regtime]]', '[[regtime]]', '1', '1', 'Run Email Reminder Notifications', 'function::sendEmailReminders', '2008-01-01 07:45:01', '2020-12-31 23:59:59', '*::*::*::*::*', NULL, NULL, NULL, 'Active', 0), ('828a9457-da77-024c-e8dc-5954ac0a1732', 0, '[[regtime]]', '[[regtime]]', '1', '1', 'Clean Jobs Queue', 'function::cleanJobQueue', '2012-01-01 07:45:01', '2030-12-31 23:59:59', '0::5::*::*::*', NULL, NULL, NULL, 'Active', 0), ('86a17baf-62b0-1778-589e-5954ac61f3aa', 0, '[[regtime]]', '[[regtime]]', '1', '1', 'Removal of documents from filesystem', 'function::removeDocumentsFromFS', '2012-01-01 13:30:01', '2030-12-31 23:59:59', '0::3::1::*::*', NULL, NULL, NULL, 'Active', 0), ('8ccfe585-0319-9c40-7886-5954acce114f', 0, '[[regtime]]', '[[regtime]]', '1', '1', 'Prune SugarFeed Tables', 'function::trimSugarFeeds', '2005-01-01 16:00:01', '2020-12-31 23:59:59', '0::2::1::*::*', NULL, NULL, NULL, 'Active', 1); -- -------------------------------------------------------- -- -- Table structure for table `sugarfeed` -- CREATE TABLE `sugarfeed` ( `id` char(36) NOT NULL, `name` varchar(255) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `assigned_user_id` char(36) DEFAULT NULL, `related_module` varchar(100) DEFAULT NULL, `related_id` char(36) DEFAULT NULL, `link_url` varchar(255) DEFAULT NULL, `link_type` varchar(30) DEFAULT NULL, PRIMARY KEY (`id`), KEY `sgrfeed_date` (`date_entered`,`deleted`), KEY `idx_sgrfeed_rmod_rid_date` (`related_module`,`related_id`,`date_entered`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `tasks` -- CREATE TABLE `tasks` ( `id` char(36) NOT NULL, `name` varchar(50) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `description` text, `deleted` tinyint(1) DEFAULT '0', `assigned_user_id` char(36) DEFAULT NULL, `status` varchar(100) DEFAULT 'Not Started', `date_due_flag` tinyint(1) DEFAULT '0', `date_due` datetime DEFAULT NULL, `date_start_flag` tinyint(1) DEFAULT '0', `date_start` datetime DEFAULT NULL, `parent_type` varchar(255) DEFAULT NULL, `parent_id` char(36) DEFAULT NULL, `contact_id` char(36) DEFAULT NULL, `priority` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_tsk_name` (`name`), KEY `idx_task_con_del` (`contact_id`,`deleted`), KEY `idx_task_par_del` (`parent_id`,`parent_type`,`deleted`), KEY `idx_task_assigned` (`assigned_user_id`), KEY `idx_task_status` (`status`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `tracker` -- CREATE TABLE `tracker` ( `id` int(11) NOT NULL AUTO_INCREMENT, `monitor_id` char(36) NOT NULL, `user_id` varchar(36) DEFAULT NULL, `module_name` varchar(255) DEFAULT NULL, `item_id` varchar(36) DEFAULT NULL, `item_summary` varchar(255) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `action` varchar(255) DEFAULT NULL, `session_id` varchar(36) DEFAULT NULL, `visible` tinyint(1) DEFAULT '0', `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), KEY `idx_tracker_iid` (`item_id`), KEY `idx_tracker_userid_vis_id` (`user_id`,`visible`,`id`), KEY `idx_tracker_userid_itemid_vis` (`user_id`,`item_id`,`visible`), KEY `idx_tracker_monitor_id` (`monitor_id`), KEY `idx_tracker_date_modified` (`date_modified`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `upgrade_history` -- CREATE TABLE `upgrade_history` ( `id` char(36) NOT NULL, `filename` varchar(255) DEFAULT NULL, `md5sum` varchar(32) DEFAULT NULL, `type` varchar(30) DEFAULT NULL, `status` varchar(50) DEFAULT NULL, `version` varchar(64) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `description` text, `id_name` varchar(255) DEFAULT NULL, `manifest` longtext, `date_entered` datetime DEFAULT NULL, `enabled` tinyint(1) DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `upgrade_history_md5_uk` (`md5sum`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `users` -- CREATE TABLE `users` ( `id` char(36) NOT NULL, `user_name` varchar(60) DEFAULT NULL, `user_hash` varchar(255) DEFAULT NULL, `system_generated_password` tinyint(1) DEFAULT NULL, `pwd_last_changed` datetime DEFAULT NULL, `authenticate_id` varchar(100) DEFAULT NULL, `sugar_login` tinyint(1) DEFAULT '1', `first_name` varchar(30) DEFAULT NULL, `last_name` varchar(30) DEFAULT NULL, `is_admin` tinyint(1) DEFAULT '0', `external_auth_only` tinyint(1) DEFAULT '0', `receive_notifications` tinyint(1) DEFAULT '1', `description` text, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `title` varchar(50) DEFAULT NULL, `department` varchar(50) DEFAULT NULL, `phone_home` varchar(50) DEFAULT NULL, `phone_mobile` varchar(50) DEFAULT NULL, `phone_work` varchar(50) DEFAULT NULL, `phone_other` varchar(50) DEFAULT NULL, `phone_fax` varchar(50) DEFAULT NULL, `status` varchar(100) DEFAULT NULL, `address_street` varchar(150) DEFAULT NULL, `address_city` varchar(100) DEFAULT NULL, `address_state` varchar(100) DEFAULT NULL, `address_country` varchar(100) DEFAULT NULL, `address_postalcode` varchar(20) DEFAULT NULL, `deleted` tinyint(1) DEFAULT NULL, `portal_only` tinyint(1) DEFAULT '0', `show_on_employees` tinyint(1) DEFAULT '1', `employee_status` varchar(100) DEFAULT NULL, `messenger_id` varchar(100) DEFAULT NULL, `messenger_type` varchar(100) DEFAULT NULL, `reports_to_id` char(36) DEFAULT NULL, `is_group` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_user_name` (`user_name`,`is_group`,`status`,`last_name`,`first_name`,`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `users` -- INSERT INTO `users` VALUES ('1', '[[admin_username]]', '[[admin_pass]]', 0, NULL, NULL, 1, '[[admin_fname]]', '[[admin_lname]]', 1, 0, 1, NULL, '[[regtime]]', '[[regtime]]', '1', '', 'Administrator', NULL, NULL, NULL, NULL, NULL, NULL, 'Active', NULL, NULL, NULL, NULL, NULL, 0, 0, 1, 'Active', NULL, NULL, NULL, 0); -- -------------------------------------------------------- -- -- Table structure for table `users_feeds` -- CREATE TABLE `users_feeds` ( `user_id` varchar(36) DEFAULT NULL, `feed_id` varchar(36) DEFAULT NULL, `rank` int(11) DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', KEY `idx_ud_user_id` (`user_id`,`feed_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `users_last_import` -- CREATE TABLE `users_last_import` ( `id` char(36) NOT NULL, `assigned_user_id` char(36) DEFAULT NULL, `import_module` varchar(36) DEFAULT NULL, `bean_type` varchar(36) DEFAULT NULL, `bean_id` char(36) DEFAULT NULL, `deleted` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_user_id` (`assigned_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `users_password_link` -- CREATE TABLE `users_password_link` ( `id` char(36) NOT NULL, `username` varchar(36) DEFAULT NULL, `date_generated` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_username` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `users_signatures` -- CREATE TABLE `users_signatures` ( `id` char(36) NOT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `deleted` tinyint(1) DEFAULT NULL, `user_id` varchar(36) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `signature` text, `signature_html` text, PRIMARY KEY (`id`), KEY `idx_usersig_uid` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `user_preferences` -- CREATE TABLE `user_preferences` ( `id` char(36) NOT NULL, `category` varchar(50) DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `assigned_user_id` char(36) DEFAULT NULL, `contents` longtext, PRIMARY KEY (`id`), KEY `idx_userprefnamecat` (`assigned_user_id`,`category`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `user_preferences` -- INSERT INTO `user_preferences` VALUES ('2d1dd91f-5fbb-e3a3-825c-5954ac83a5ed', 'global', 0, '[[regtime]]', '[[regtime]]', '1', 'YToxOntzOjIwOiJjYWxlbmRhcl9wdWJsaXNoX2tleSI7czozNjoiMmNmZTMxMGMtM2ExMy1jNTQyLWU3NzAtNTk1NGFjYmM5MzM4Ijt9'); -- -------------------------------------------------------- -- -- Table structure for table `vcals` -- CREATE TABLE `vcals` ( `id` char(36) NOT NULL, `deleted` tinyint(1) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `user_id` char(36) NOT NULL, `type` varchar(100) DEFAULT NULL, `source` varchar(100) DEFAULT NULL, `content` text, PRIMARY KEY (`id`), KEY `idx_vcal` (`type`,`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `versions` -- CREATE TABLE `versions` ( `id` char(36) NOT NULL, `deleted` tinyint(1) DEFAULT NULL, `date_entered` datetime DEFAULT NULL, `date_modified` datetime DEFAULT NULL, `modified_user_id` char(36) DEFAULT NULL, `created_by` char(36) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `file_version` varchar(255) DEFAULT NULL, `db_version` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `idx_version` (`name`,`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `versions` -- INSERT INTO `versions` VALUES ('ad0ee2e1-55ad-a8e1-eff1-5954ac760b78', 0, '[[regtime]]', '[[regtime]]', '1', '1', 'Chart Data Cache', '3.5.1', '3.5.1'), ('b3e4cd9d-49a3-a06f-195d-5954ac1a2d3e', 0, '[[regtime]]', '[[regtime]]', '1', '1', 'htaccess', '3.5.1', '3.5.1'), ('b806722a-5256-8a48-50f0-5954ac95e00b', 0, '[[regtime]]', '[[regtime]]', '1', '1', 'Rebuild Relationships', '4.0.0', '4.0.0'), ('c841fa5e-38a4-8c7b-e590-5954ac004aa9', 0, '[[regtime]]', '[[regtime]]', '1', '1', 'Rebuild Extensions', '4.0.0', '4.0.0'); /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;