관리-도구

편집 파일: espo.sql

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: `espo842` -- -- -------------------------------------------------------- -- -- Table structure for table `account` -- CREATE TABLE `account` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(249) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `industry` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sic_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `billing_address_street` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `billing_address_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `billing_address_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `billing_address_country` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `billing_address_postal_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `shipping_address_street` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `shipping_address_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `shipping_address_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `shipping_address_country` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `shipping_address_postal_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `campaign_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigned_user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_CREATED_AT_ID` (`created_at`,`id`), KEY `IDX_CREATED_AT` (`created_at`,`deleted`), KEY `IDX_NAME` (`name`,`deleted`), KEY `IDX_ASSIGNED_USER` (`assigned_user_id`,`deleted`), KEY `IDX_CAMPAIGN_ID` (`campaign_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_ASSIGNED_USER_ID` (`assigned_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `account_contact` -- CREATE TABLE `account_contact` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `account_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contact_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `role` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_inactive` tinyint(1) DEFAULT '0', `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_ACCOUNT_ID_CONTACT_ID` (`account_id`,`contact_id`), KEY `IDX_ACCOUNT_ID` (`account_id`), KEY `IDX_CONTACT_ID` (`contact_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `account_document` -- CREATE TABLE `account_document` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `account_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_ACCOUNT_ID_DOCUMENT_ID` (`account_id`,`document_id`), KEY `IDX_ACCOUNT_ID` (`account_id`), KEY `IDX_DOCUMENT_ID` (`document_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `account_portal_user` -- CREATE TABLE `account_portal_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `account_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_USER_ID_ACCOUNT_ID` (`user_id`,`account_id`), KEY `IDX_USER_ID` (`user_id`), KEY `IDX_ACCOUNT_ID` (`account_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `account_target_list` -- CREATE TABLE `account_target_list` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `account_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_list_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `opted_out` tinyint(1) DEFAULT '0', `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_ACCOUNT_ID_TARGET_LIST_ID` (`account_id`,`target_list_id`), KEY `IDX_ACCOUNT_ID` (`account_id`), KEY `IDX_TARGET_LIST_ID` (`target_list_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `action_history_record` -- CREATE TABLE `action_history_record` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `number` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `target_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `action` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `ip_address` varchar(39) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `auth_token_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `auth_log_record_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_NUMBER` (`number`), KEY `IDX_TARGET` (`target_type`,`target_id`), KEY `IDX_USER_ID` (`user_id`), KEY `IDX_AUTH_TOKEN_ID` (`auth_token_id`), KEY `IDX_AUTH_LOG_RECORD_ID` (`auth_log_record_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `address_country` -- CREATE TABLE `address_country` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `code` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_preferred` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_NAME` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `app_log_record` -- CREATE TABLE `app_log_record` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `number` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `created_at` datetime DEFAULT NULL, `message` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `level` varchar(9) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `code` int(11) DEFAULT NULL, `exception_class` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `line` int(11) DEFAULT NULL, `request_method` varchar(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `request_resource_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `request_url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_NUMBER` (`number`), KEY `IDX_LEVEL` (`level`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `array_value` -- CREATE TABLE `array_value` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `attribute` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `entity_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `entity_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_ENTITY_TYPE_VALUE` (`entity_type`,`value`), KEY `IDX_ENTITY_VALUE` (`entity_type`,`entity_id`,`value`), KEY `IDX_ENTITY` (`entity_id`,`entity_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `attachment` -- CREATE TABLE `attachment` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `size` bigint(20) DEFAULT NULL, `field` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_being_uploaded` tinyint(1) NOT NULL DEFAULT '0', `created_at` datetime DEFAULT NULL, `role` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `storage` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `storage_file_path` varchar(260) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `global` tinyint(1) NOT NULL DEFAULT '0', `parent_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `related_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `related_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `source_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_PARENT` (`parent_type`,`parent_id`), KEY `IDX_RELATED` (`related_id`,`related_type`), KEY `IDX_SOURCE` (`source_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `authentication_provider` -- CREATE TABLE `authentication_provider` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `oidc_client_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `oidc_client_secret` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `oidc_authorization_endpoint` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `oidc_token_endpoint` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `oidc_jwks_endpoint` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `oidc_jwt_signature_algorithm_list` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `oidc_scopes` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `oidc_create_user` tinyint(1) NOT NULL DEFAULT '0', `oidc_username_claim` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'sub', `oidc_sync` tinyint(1) NOT NULL DEFAULT '0', `oidc_logout_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `oidc_authorization_prompt` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `auth_log_record` -- CREATE TABLE `auth_log_record` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `is_denied` tinyint(1) NOT NULL DEFAULT '0', `denial_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `request_time` double DEFAULT NULL, `request_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `request_method` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `authentication_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `portal_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `auth_token_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_IP_ADDRESS` (`ip_address`), KEY `IDX_IP_ADDRESS_REQUEST_TIME` (`ip_address`,`request_time`), KEY `IDX_REQUEST_TIME` (`request_time`), KEY `IDX_PORTAL_ID` (`portal_id`), KEY `IDX_USER_ID` (`user_id`), KEY `IDX_AUTH_TOKEN_ID` (`auth_token_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `auth_token` -- CREATE TABLE `auth_token` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `token` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `hash` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `secret` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `last_access` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `portal_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_TOKEN` (`token`,`deleted`), KEY `IDX_HASH` (`hash`), KEY `IDX_USER_ID` (`user_id`), KEY `IDX_PORTAL_ID` (`portal_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `autofollow` -- CREATE TABLE `autofollow` ( `id` int(11) NOT NULL AUTO_INCREMENT, `deleted` tinyint(1) DEFAULT '0', `entity_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_ENTITY_TYPE` (`entity_type`), KEY `IDX_USER` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `call` -- CREATE TABLE `call` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Planned', `date_start` datetime DEFAULT NULL, `date_end` datetime DEFAULT NULL, `direction` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Outbound', `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `parent_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `account_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigned_user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_DATE_START_STATUS` (`date_start`,`status`), KEY `IDX_DATE_START` (`date_start`,`deleted`), KEY `IDX_STATUS` (`status`,`deleted`), KEY `IDX_ASSIGNED_USER` (`assigned_user_id`,`deleted`), KEY `IDX_ASSIGNED_USER_STATUS` (`assigned_user_id`,`status`), KEY `IDX_PARENT` (`parent_id`,`parent_type`), KEY `IDX_ACCOUNT_ID` (`account_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_ASSIGNED_USER_ID` (`assigned_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `call_contact` -- CREATE TABLE `call_contact` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `call_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contact_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'None', `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_CALL_ID_CONTACT_ID` (`call_id`,`contact_id`), KEY `IDX_CALL_ID` (`call_id`), KEY `IDX_CONTACT_ID` (`contact_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `call_lead` -- CREATE TABLE `call_lead` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `call_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `lead_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'None', `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_CALL_ID_LEAD_ID` (`call_id`,`lead_id`), KEY `IDX_CALL_ID` (`call_id`), KEY `IDX_LEAD_ID` (`lead_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `call_user` -- CREATE TABLE `call_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `call_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'None', `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_USER_ID_CALL_ID` (`user_id`,`call_id`), KEY `IDX_USER_ID` (`user_id`), KEY `IDX_CALL_ID` (`call_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `campaign` -- CREATE TABLE `campaign` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Planning', `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Email', `start_date` date DEFAULT NULL, `end_date` date DEFAULT NULL, `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `budget` double DEFAULT NULL, `mail_merge_only_with_address` tinyint(1) NOT NULL DEFAULT '1', `budget_currency` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigned_user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contacts_template_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `leads_template_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `accounts_template_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `users_template_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CREATED_AT` (`created_at`,`deleted`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_ASSIGNED_USER_ID` (`assigned_user_id`), KEY `IDX_CONTACTS_TEMPLATE_ID` (`contacts_template_id`), KEY `IDX_LEADS_TEMPLATE_ID` (`leads_template_id`), KEY `IDX_ACCOUNTS_TEMPLATE_ID` (`accounts_template_id`), KEY `IDX_USERS_TEMPLATE_ID` (`users_template_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `campaign_log_record` -- CREATE TABLE `campaign_log_record` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `action` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `action_date` datetime DEFAULT NULL, `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `string_data` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `string_additional_data` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `application` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Espo', `created_at` datetime DEFAULT NULL, `is_test` tinyint(1) NOT NULL DEFAULT '0', `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `campaign_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `object_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `object_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `queue_item_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_ACTION_DATE` (`action_date`,`deleted`), KEY `IDX_ACTION` (`action`,`deleted`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_CAMPAIGN_ID` (`campaign_id`), KEY `IDX_PARENT` (`parent_id`,`parent_type`), KEY `IDX_OBJECT` (`object_id`,`object_type`), KEY `IDX_QUEUE_ITEM_ID` (`queue_item_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `campaign_target_list` -- CREATE TABLE `campaign_target_list` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `campaign_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_list_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_CAMPAIGN_ID_TARGET_LIST_ID` (`campaign_id`,`target_list_id`), KEY `IDX_CAMPAIGN_ID` (`campaign_id`), KEY `IDX_TARGET_LIST_ID` (`target_list_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `campaign_target_list_excluding` -- CREATE TABLE `campaign_target_list_excluding` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `campaign_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_list_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_CAMPAIGN_ID_TARGET_LIST_ID` (`campaign_id`,`target_list_id`), KEY `IDX_CAMPAIGN_ID` (`campaign_id`), KEY `IDX_TARGET_LIST_ID` (`target_list_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `campaign_tracking_url` -- CREATE TABLE `campaign_tracking_url` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `action` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Redirect', `message` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `modified_at` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `campaign_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CAMPAIGN_ID` (`campaign_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `case` -- CREATE TABLE `case` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `number` int(10) unsigned NOT NULL AUTO_INCREMENT, `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'New', `priority` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Normal', `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `account_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `lead_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contact_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `inbound_email_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigned_user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_NUMBER` (`number`), KEY `IDX_STATUS` (`status`,`deleted`), KEY `IDX_ASSIGNED_USER` (`assigned_user_id`,`deleted`), KEY `IDX_ASSIGNED_USER_STATUS` (`assigned_user_id`,`status`), KEY `IDX_ACCOUNT_ID` (`account_id`), KEY `IDX_LEAD_ID` (`lead_id`), KEY `IDX_CONTACT_ID` (`contact_id`), KEY `IDX_INBOUND_EMAIL_ID` (`inbound_email_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_ASSIGNED_USER_ID` (`assigned_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `case_contact` -- CREATE TABLE `case_contact` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `case_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contact_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_CASE_ID_CONTACT_ID` (`case_id`,`contact_id`), KEY `IDX_CASE_ID` (`case_id`), KEY `IDX_CONTACT_ID` (`contact_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `case_knowledge_base_article` -- CREATE TABLE `case_knowledge_base_article` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `case_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `knowledge_base_article_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_CASE_ID_KNOWLEDGE_BASE_ARTICLE_ID` (`case_id`,`knowledge_base_article_id`), KEY `IDX_CASE_ID` (`case_id`), KEY `IDX_KNOWLEDGE_BASE_ARTICLE_ID` (`knowledge_base_article_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `contact` -- CREATE TABLE `contact` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `salutation_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `first_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `do_not_call` tinyint(1) NOT NULL DEFAULT '0', `address_street` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_country` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_postal_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `middle_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `account_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `campaign_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigned_user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_CREATED_AT_ID` (`created_at`,`id`), KEY `IDX_CREATED_AT` (`created_at`,`deleted`), KEY `IDX_FIRST_NAME` (`first_name`,`deleted`), KEY `IDX_NAME` (`first_name`,`last_name`), KEY `IDX_ASSIGNED_USER` (`assigned_user_id`,`deleted`), KEY `IDX_ACCOUNT_ID` (`account_id`), KEY `IDX_CAMPAIGN_ID` (`campaign_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_ASSIGNED_USER_ID` (`assigned_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `contact_document` -- CREATE TABLE `contact_document` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `contact_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `document_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_CONTACT_ID_DOCUMENT_ID` (`contact_id`,`document_id`), KEY `IDX_CONTACT_ID` (`contact_id`), KEY `IDX_DOCUMENT_ID` (`document_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `contact_meeting` -- CREATE TABLE `contact_meeting` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `contact_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meeting_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'None', `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_CONTACT_ID_MEETING_ID` (`contact_id`,`meeting_id`), KEY `IDX_CONTACT_ID` (`contact_id`), KEY `IDX_MEETING_ID` (`meeting_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `contact_opportunity` -- CREATE TABLE `contact_opportunity` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `contact_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `opportunity_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `role` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_CONTACT_ID_OPPORTUNITY_ID` (`contact_id`,`opportunity_id`), KEY `IDX_CONTACT_ID` (`contact_id`), KEY `IDX_OPPORTUNITY_ID` (`opportunity_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `contact_target_list` -- CREATE TABLE `contact_target_list` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `contact_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_list_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `opted_out` tinyint(1) DEFAULT '0', `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_CONTACT_ID_TARGET_LIST_ID` (`contact_id`,`target_list_id`), KEY `IDX_CONTACT_ID` (`contact_id`), KEY `IDX_TARGET_LIST_ID` (`target_list_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `currency` -- CREATE TABLE `currency` ( `id` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `rate` double DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `currency` -- INSERT INTO `currency` VALUES ('USD', 1); -- -------------------------------------------------------- -- -- Table structure for table `dashboard_template` -- CREATE TABLE `dashboard_template` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `layout` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `dashlets_options` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `document` -- CREATE TABLE `document` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Active', `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `publish_date` date DEFAULT NULL, `expiration_date` date DEFAULT NULL, `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `file_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigned_user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `folder_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_ASSIGNED_USER_ID` (`assigned_user_id`), KEY `IDX_FOLDER_ID` (`folder_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `document_folder` -- CREATE TABLE `document_folder` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_PARENT_ID` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `document_folder_path` -- CREATE TABLE `document_folder_path` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ascendor_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `descendor_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_ASCENDOR_ID` (`ascendor_id`), KEY `IDX_DESCENDOR_ID` (`descendor_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `document_lead` -- CREATE TABLE `document_lead` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `document_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `lead_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_DOCUMENT_ID_LEAD_ID` (`document_id`,`lead_id`), KEY `IDX_DOCUMENT_ID` (`document_id`), KEY `IDX_LEAD_ID` (`lead_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `document_opportunity` -- CREATE TABLE `document_opportunity` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `document_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `opportunity_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_DOCUMENT_ID_OPPORTUNITY_ID` (`document_id`,`opportunity_id`), KEY `IDX_DOCUMENT_ID` (`document_id`), KEY `IDX_OPPORTUNITY_ID` (`opportunity_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `email` -- CREATE TABLE `email` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `from_string` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reply_to_string` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_name_map` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `is_replied` tinyint(1) NOT NULL DEFAULT '0', `message_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `message_id_internal` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `body_plain` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `is_html` tinyint(1) NOT NULL DEFAULT '1', `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Archived', `has_attachment` tinyint(1) NOT NULL DEFAULT '0', `date_sent` datetime DEFAULT NULL, `delivery_date` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `is_system` tinyint(1) NOT NULL DEFAULT '0', `ics_contents` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `ics_event_uid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `from_email_address_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `sent_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigned_user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `replied_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_event_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_event_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `group_folder_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `account_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_DATE_SENT` (`date_sent`,`deleted`), KEY `IDX_DATE_SENT_STATUS` (`date_sent`,`status`,`deleted`), KEY `IDX_MESSAGE_ID` (`message_id`), KEY `IDX_ICS_EVENT_UID` (`ics_event_uid`), KEY `IDX_FROM_EMAIL_ADDRESS_ID` (`from_email_address_id`), KEY `IDX_PARENT` (`parent_id`,`parent_type`), KEY `IDX_SENT_BY_ID` (`sent_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_ASSIGNED_USER_ID` (`assigned_user_id`), KEY `IDX_REPLIED_ID` (`replied_id`), KEY `IDX_CREATED_EVENT` (`created_event_id`,`created_event_type`), KEY `IDX_GROUP_FOLDER_ID` (`group_folder_id`), KEY `IDX_ACCOUNT_ID` (`account_id`), FULLTEXT KEY `IDX_SYSTEM_FULL_TEXT_SEARCH` (`name`,`body_plain`,`body`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `email_account` -- CREATE TABLE `email_account` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `email_address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Active', `host` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `port` int(11) DEFAULT '993', `security` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SSL', `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `monitored_folders` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `sent_folder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `store_sent_emails` tinyint(1) NOT NULL DEFAULT '0', `keep_fetched_emails_unread` tinyint(1) NOT NULL DEFAULT '0', `fetch_since` date DEFAULT NULL, `fetch_data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `connected_at` datetime DEFAULT NULL, `use_imap` tinyint(1) NOT NULL DEFAULT '1', `use_smtp` tinyint(1) NOT NULL DEFAULT '0', `smtp_host` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `smtp_port` int(11) DEFAULT '587', `smtp_auth` tinyint(1) NOT NULL DEFAULT '1', `smtp_security` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'TLS', `smtp_username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `smtp_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `smtp_auth_mechanism` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'login', `imap_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `smtp_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_folder_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigned_user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_EMAIL_FOLDER_ID` (`email_folder_id`), KEY `IDX_ASSIGNED_USER_ID` (`assigned_user_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `email_address` -- CREATE TABLE `email_address` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `lower` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `invalid` tinyint(1) NOT NULL DEFAULT '0', `opt_out` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `IDX_LOWER` (`lower`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `email_email_account` -- CREATE TABLE `email_email_account` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `email_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_account_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_EMAIL_ID_EMAIL_ACCOUNT_ID` (`email_id`,`email_account_id`), KEY `IDX_EMAIL_ID` (`email_id`), KEY `IDX_EMAIL_ACCOUNT_ID` (`email_account_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `email_email_address` -- CREATE TABLE `email_email_address` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `email_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_address_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_type` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_EMAIL_ID_EMAIL_ADDRESS_ID_ADDRESS_TYPE` (`email_id`,`email_address_id`,`address_type`), KEY `IDX_EMAIL_ID` (`email_id`), KEY `IDX_EMAIL_ADDRESS_ID` (`email_address_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `email_filter` -- CREATE TABLE `email_filter` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `from` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `to` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `body_contains` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `body_contains_all` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `is_global` tinyint(1) NOT NULL DEFAULT '0', `action` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Skip', `mark_as_read` tinyint(1) NOT NULL DEFAULT '0', `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `parent_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_folder_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `group_email_folder_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_PARENT` (`parent_id`,`parent_type`), KEY `IDX_EMAIL_FOLDER_ID` (`email_folder_id`), KEY `IDX_GROUP_EMAIL_FOLDER_ID` (`group_email_folder_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `email_folder` -- CREATE TABLE `email_folder` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `order` int(11) DEFAULT NULL, `skip_notifications` tinyint(1) NOT NULL DEFAULT '0', `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `assigned_user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_ASSIGNED_USER_ID` (`assigned_user_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `email_inbound_email` -- CREATE TABLE `email_inbound_email` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `email_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `inbound_email_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_EMAIL_ID_INBOUND_EMAIL_ID` (`email_id`,`inbound_email_id`), KEY `IDX_EMAIL_ID` (`email_id`), KEY `IDX_INBOUND_EMAIL_ID` (`inbound_email_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `email_queue_item` -- CREATE TABLE `email_queue_item` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `attempt_count` int(11) DEFAULT '0', `created_at` datetime DEFAULT NULL, `sent_at` datetime DEFAULT NULL, `email_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_test` tinyint(1) NOT NULL DEFAULT '0', `mass_email_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_SENT_AT` (`sent_at`), KEY `IDX_MASS_EMAIL_ID` (`mass_email_id`), KEY `IDX_TARGET` (`target_id`,`target_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `email_template` -- CREATE TABLE `email_template` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `subject` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `is_html` tinyint(1) NOT NULL DEFAULT '1', `one_off` tinyint(1) NOT NULL DEFAULT '0', `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `category_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigned_user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `version_number` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CATEGORY_ID` (`category_id`), KEY `IDX_ASSIGNED_USER_ID` (`assigned_user_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `email_template` -- INSERT INTO `email_template` VALUES ('[[unique_id_email]]', 'Case-to-Email auto-reply', 0, 'Case has been created', '<p>{Person.name},</p><p>Case ''{Case.name}'' has been created with number {Case.number} and assigned to {User.name}.</p>', 1, 0, '[[regtime]]', '[[regtime]]', NULL, NULL, 'system', NULL, 1); -- -------------------------------------------------------- -- -- Table structure for table `email_template_category` -- CREATE TABLE `email_template_category` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `order` int(11) DEFAULT NULL, `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_PARENT_ID` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `email_template_category_path` -- CREATE TABLE `email_template_category_path` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ascendor_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `descendor_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_ASCENDOR_ID` (`ascendor_id`), KEY `IDX_DESCENDOR_ID` (`descendor_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `email_user` -- CREATE TABLE `email_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `email_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_read` tinyint(1) DEFAULT '0', `is_important` tinyint(1) DEFAULT '0', `in_trash` tinyint(1) DEFAULT '0', `in_archive` tinyint(1) DEFAULT '0', `folder_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_EMAIL_ID_USER_ID` (`email_id`,`user_id`), KEY `IDX_EMAIL_ID` (`email_id`), KEY `IDX_USER_ID` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `entity_email_address` -- CREATE TABLE `entity_email_address` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `entity_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_address_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `entity_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `primary` tinyint(1) DEFAULT '0', `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_ENTITY_ID_EMAIL_ADDRESS_ID_ENTITY_TYPE` (`entity_id`,`email_address_id`,`entity_type`), KEY `IDX_ENTITY_ID` (`entity_id`), KEY `IDX_EMAIL_ADDRESS_ID` (`email_address_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `entity_phone_number` -- CREATE TABLE `entity_phone_number` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `entity_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone_number_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `entity_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `primary` tinyint(1) DEFAULT '0', `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_ENTITY_ID_PHONE_NUMBER_ID_ENTITY_TYPE` (`entity_id`,`phone_number_id`,`entity_type`), KEY `IDX_ENTITY_ID` (`entity_id`), KEY `IDX_PHONE_NUMBER_ID` (`phone_number_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `entity_team` -- CREATE TABLE `entity_team` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `entity_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `team_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `entity_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_ENTITY_ID_TEAM_ID_ENTITY_TYPE` (`entity_id`,`team_id`,`entity_type`), KEY `IDX_ENTITY_ID` (`entity_id`), KEY `IDX_TEAM_ID` (`team_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `entity_user` -- CREATE TABLE `entity_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `entity_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `entity_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_ENTITY_ID_USER_ID_ENTITY_TYPE` (`entity_id`,`user_id`,`entity_type`), KEY `IDX_ENTITY_ID` (`entity_id`), KEY `IDX_USER_ID` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `export` -- CREATE TABLE `export` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Pending', `params` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `notify_on_finish` tinyint(1) NOT NULL DEFAULT '0', `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `attachment_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_ATTACHMENT` (`attachment_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `extension` -- CREATE TABLE `extension` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `version` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `file_list` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `license_status` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `license_status_message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `is_installed` tinyint(1) NOT NULL DEFAULT '0', `check_version_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_LICENSE_STATUS` (`license_status`), KEY `IDX_CREATED_BY_ID` (`created_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `external_account` -- CREATE TABLE `external_account` ( `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `enabled` tinyint(1) NOT NULL DEFAULT '0', `is_locked` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `group_email_folder` -- CREATE TABLE `group_email_folder` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `order` int(11) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `group_email_folder_team` -- CREATE TABLE `group_email_folder_team` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `group_email_folder_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `team_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_GROUP_EMAIL_FOLDER_ID_TEAM_ID` (`group_email_folder_id`,`team_id`), KEY `IDX_GROUP_EMAIL_FOLDER_ID` (`group_email_folder_id`), KEY `IDX_TEAM_ID` (`team_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `import` -- CREATE TABLE `import` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `entity_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_index` int(11) DEFAULT NULL, `params` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `attribute_list` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `file_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `import_entity` -- CREATE TABLE `import_entity` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `deleted` tinyint(1) DEFAULT '0', `is_imported` tinyint(1) NOT NULL DEFAULT '0', `is_updated` tinyint(1) NOT NULL DEFAULT '0', `is_duplicate` tinyint(1) NOT NULL DEFAULT '0', `entity_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `entity_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `import_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_ENTITY_IMPORT` (`import_id`,`entity_type`), KEY `IDX_ENTITY` (`entity_id`,`entity_type`), KEY `IDX_IMPORT` (`import_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `import_error` -- CREATE TABLE `import_error` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `row_index` int(11) DEFAULT NULL, `export_row_index` int(11) DEFAULT NULL, `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `validation_failures` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `row` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `import_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_ROW_INDEX` (`row_index`), KEY `IDX_IMPORT_ROW_INDEX` (`import_id`,`row_index`), KEY `IDX_IMPORT_ID` (`import_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `inbound_email` -- CREATE TABLE `inbound_email` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `email_address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Active', `host` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `port` int(11) DEFAULT '993', `security` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'SSL', `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `monitored_folders` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `fetch_since` date DEFAULT NULL, `fetch_data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `add_all_team_users` tinyint(1) NOT NULL DEFAULT '1', `sent_folder` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `store_sent_emails` tinyint(1) NOT NULL DEFAULT '0', `keep_fetched_emails_unread` tinyint(1) NOT NULL DEFAULT '0', `connected_at` datetime DEFAULT NULL, `exclude_from_reply` tinyint(1) NOT NULL DEFAULT '0', `use_imap` tinyint(1) NOT NULL DEFAULT '1', `use_smtp` tinyint(1) NOT NULL DEFAULT '0', `smtp_is_shared` tinyint(1) NOT NULL DEFAULT '0', `smtp_is_for_mass_email` tinyint(1) NOT NULL DEFAULT '0', `smtp_host` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `smtp_port` int(11) DEFAULT '587', `smtp_auth` tinyint(1) NOT NULL DEFAULT '1', `smtp_security` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'TLS', `smtp_username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `smtp_password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `smtp_auth_mechanism` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'login', `create_case` tinyint(1) NOT NULL DEFAULT '0', `case_distribution` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Direct-Assignment', `target_user_position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reply` tinyint(1) NOT NULL DEFAULT '0', `reply_from_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reply_to_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reply_from_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `from_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `imap_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `smtp_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `assign_to_user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `team_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reply_email_template_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `group_email_folder_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_ASSIGN_TO_USER_ID` (`assign_to_user_id`), KEY `IDX_TEAM_ID` (`team_id`), KEY `IDX_REPLY_EMAIL_TEMPLATE_ID` (`reply_email_template_id`), KEY `IDX_GROUP_EMAIL_FOLDER_ID` (`group_email_folder_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `inbound_email_team` -- CREATE TABLE `inbound_email_team` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `inbound_email_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `team_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_INBOUND_EMAIL_ID_TEAM_ID` (`inbound_email_id`,`team_id`), KEY `IDX_INBOUND_EMAIL_ID` (`inbound_email_id`), KEY `IDX_TEAM_ID` (`team_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `integration` -- CREATE TABLE `integration` ( `id` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `enabled` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `job` -- CREATE TABLE `job` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `status` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Pending', `execute_time` datetime DEFAULT NULL, `number` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `class_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `service_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `method_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `job` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `queue` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `group` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_group` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `started_at` datetime DEFAULT NULL, `executed_at` datetime DEFAULT NULL, `pid` int(11) DEFAULT NULL, `attempts` int(11) DEFAULT NULL, `target_id` varchar(48) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_type` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `failed_attempts` int(11) DEFAULT NULL, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `scheduled_job_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_NUMBER` (`number`), KEY `IDX_EXECUTE_TIME` (`status`,`execute_time`), KEY `IDX_STATUS` (`status`,`deleted`), KEY `IDX_STATUS_SCHEDULED_JOB_ID` (`status`,`scheduled_job_id`), KEY `IDX_SCHEDULED_JOB_ID` (`scheduled_job_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ; -- -- Dumping data for table `job` -- INSERT INTO `job` VALUES ('6708c73f79dc4e265', 'Dummy', 0, 'Pending', '[[regtime]]', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, '[[regtime]]', '[[regtime]]', '6708c71f883043702'); -- -------------------------------------------------------- -- -- Table structure for table `kanban_order` -- CREATE TABLE `kanban_order` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `order` smallint(6) DEFAULT NULL, `group` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `entity_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `entity_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_ENTITY_USER_ID` (`entity_type`,`entity_id`,`user_id`), KEY `IDX_ENTITY_TYPE` (`entity_type`), KEY `IDX_ENTITY_TYPE_USER_ID` (`entity_type`,`user_id`), KEY `IDX_ENTITY` (`entity_id`,`entity_type`), KEY `IDX_USER` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `knowledge_base_article` -- CREATE TABLE `knowledge_base_article` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Draft', `language` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Article', `publish_date` date DEFAULT NULL, `expiration_date` date DEFAULT NULL, `order` int(11) DEFAULT NULL, `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigned_user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `version_number` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_ASSIGNED_USER_ID` (`assigned_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `knowledge_base_article_knowledge_base_category` -- CREATE TABLE `knowledge_base_article_knowledge_base_category` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `knowledge_base_article_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `knowledge_base_category_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_KNOWLEDGE_BASE_ARTICLE_ID_KNOWLEDGE_BASE_CATEGORY_ID` (`knowledge_base_article_id`,`knowledge_base_category_id`), KEY `IDX_KNOWLEDGE_BASE_ARTICLE_ID` (`knowledge_base_article_id`), KEY `IDX_KNOWLEDGE_BASE_CATEGORY_ID` (`knowledge_base_category_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `knowledge_base_article_portal` -- CREATE TABLE `knowledge_base_article_portal` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `portal_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `knowledge_base_article_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_PORTAL_ID_KNOWLEDGE_BASE_ARTICLE_ID` (`portal_id`,`knowledge_base_article_id`), KEY `IDX_PORTAL_ID` (`portal_id`), KEY `IDX_KNOWLEDGE_BASE_ARTICLE_ID` (`knowledge_base_article_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `knowledge_base_category` -- CREATE TABLE `knowledge_base_category` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `order` int(11) DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_PARENT_ID` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `knowledge_base_category_path` -- CREATE TABLE `knowledge_base_category_path` ( `id` int(11) NOT NULL AUTO_INCREMENT, `ascendor_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `descendor_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_ASCENDOR_ID` (`ascendor_id`), KEY `IDX_DESCENDOR_ID` (`descendor_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `layout_record` -- CREATE TABLE `layout_record` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `layout_set_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_NAME_LAYOUT_SET_ID` (`name`,`layout_set_id`), KEY `IDX_LAYOUT_SET_ID` (`layout_set_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `layout_set` -- CREATE TABLE `layout_set` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `layout_list` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `lead` -- CREATE TABLE `lead` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `salutation_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `first_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'New', `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `industry` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `opportunity_amount` double DEFAULT NULL, `website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_street` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_country` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_postal_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `do_not_call` tinyint(1) NOT NULL DEFAULT '0', `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `converted_at` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `account_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `middle_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `opportunity_amount_currency` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigned_user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `campaign_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_account_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_contact_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_opportunity_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_CREATED_AT_ID` (`created_at`,`id`), KEY `IDX_FIRST_NAME` (`first_name`,`deleted`), KEY `IDX_NAME` (`first_name`,`last_name`), KEY `IDX_STATUS` (`status`,`deleted`), KEY `IDX_CREATED_AT` (`created_at`,`deleted`), KEY `IDX_CREATED_AT_STATUS` (`created_at`,`status`), KEY `IDX_ASSIGNED_USER` (`assigned_user_id`,`deleted`), KEY `IDX_ASSIGNED_USER_STATUS` (`assigned_user_id`,`status`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_ASSIGNED_USER_ID` (`assigned_user_id`), KEY `IDX_CAMPAIGN_ID` (`campaign_id`), KEY `IDX_CREATED_ACCOUNT_ID` (`created_account_id`), KEY `IDX_CREATED_CONTACT_ID` (`created_contact_id`), KEY `IDX_CREATED_OPPORTUNITY_ID` (`created_opportunity_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `lead_capture` -- CREATE TABLE `lead_capture` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `is_active` tinyint(1) NOT NULL DEFAULT '1', `subscribe_to_target_list` tinyint(1) NOT NULL DEFAULT '1', `subscribe_contact_to_target_list` tinyint(1) NOT NULL DEFAULT '1', `field_list` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `duplicate_check` tinyint(1) NOT NULL DEFAULT '1', `opt_in_confirmation` tinyint(1) NOT NULL DEFAULT '0', `opt_in_confirmation_lifetime` int(11) DEFAULT '48', `opt_in_confirmation_success_message` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `create_lead_before_opt_in_confirmation` tinyint(1) NOT NULL DEFAULT '0', `skip_opt_in_confirmation_if_subscribed` tinyint(1) NOT NULL DEFAULT '0', `lead_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Web Site', `api_key` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone_number_country` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `campaign_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_list_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `opt_in_confirmation_email_template_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_team_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `inbound_email_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CAMPAIGN_ID` (`campaign_id`), KEY `IDX_TARGET_LIST_ID` (`target_list_id`), KEY `IDX_OPT_IN_CONFIRMATION_EMAIL_TEMPLATE_ID` (`opt_in_confirmation_email_template_id`), KEY `IDX_TARGET_TEAM_ID` (`target_team_id`), KEY `IDX_INBOUND_EMAIL_ID` (`inbound_email_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `lead_capture_log_record` -- CREATE TABLE `lead_capture_log_record` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `number` int(10) unsigned NOT NULL AUTO_INCREMENT, `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `is_created` tinyint(1) NOT NULL DEFAULT '0', `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `lead_capture_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_NUMBER` (`number`), KEY `IDX_LEAD_CAPTURE_ID` (`lead_capture_id`), KEY `IDX_TARGET` (`target_id`,`target_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `lead_meeting` -- CREATE TABLE `lead_meeting` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `lead_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meeting_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'None', `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_LEAD_ID_MEETING_ID` (`lead_id`,`meeting_id`), KEY `IDX_LEAD_ID` (`lead_id`), KEY `IDX_MEETING_ID` (`meeting_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `lead_target_list` -- CREATE TABLE `lead_target_list` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `lead_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_list_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `opted_out` tinyint(1) DEFAULT '0', `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_LEAD_ID_TARGET_LIST_ID` (`lead_id`,`target_list_id`), KEY `IDX_LEAD_ID` (`lead_id`), KEY `IDX_TARGET_LIST_ID` (`target_list_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `mass_action` -- CREATE TABLE `mass_action` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `entity_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `action` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Pending', `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `params` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `processed_count` int(11) DEFAULT NULL, `notify_on_finish` tinyint(1) NOT NULL DEFAULT '0', `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `mass_email` -- CREATE TABLE `mass_email` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Pending', `store_sent_emails` tinyint(1) NOT NULL DEFAULT '0', `opt_out_entirely` tinyint(1) NOT NULL DEFAULT '0', `from_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `from_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reply_to_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `reply_to_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `start_at` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `email_template_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `campaign_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `inbound_email_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_EMAIL_TEMPLATE_ID` (`email_template_id`), KEY `IDX_CAMPAIGN_ID` (`campaign_id`), KEY `IDX_INBOUND_EMAIL_ID` (`inbound_email_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `mass_email_target_list` -- CREATE TABLE `mass_email_target_list` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `mass_email_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_list_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_MASS_EMAIL_ID_TARGET_LIST_ID` (`mass_email_id`,`target_list_id`), KEY `IDX_MASS_EMAIL_ID` (`mass_email_id`), KEY `IDX_TARGET_LIST_ID` (`target_list_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `mass_email_target_list_excluding` -- CREATE TABLE `mass_email_target_list_excluding` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `mass_email_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_list_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_MASS_EMAIL_ID_TARGET_LIST_ID` (`mass_email_id`,`target_list_id`), KEY `IDX_MASS_EMAIL_ID` (`mass_email_id`), KEY `IDX_TARGET_LIST_ID` (`target_list_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `meeting` -- CREATE TABLE `meeting` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Planned', `date_start` datetime DEFAULT NULL, `date_end` datetime DEFAULT NULL, `is_all_day` tinyint(1) NOT NULL DEFAULT '0', `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `date_start_date` date DEFAULT NULL, `date_end_date` date DEFAULT NULL, `parent_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `account_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigned_user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_DATE_START_STATUS` (`date_start`,`status`), KEY `IDX_DATE_START` (`date_start`,`deleted`), KEY `IDX_STATUS` (`status`,`deleted`), KEY `IDX_ASSIGNED_USER` (`assigned_user_id`,`deleted`), KEY `IDX_ASSIGNED_USER_STATUS` (`assigned_user_id`,`status`), KEY `IDX_PARENT` (`parent_id`,`parent_type`), KEY `IDX_ACCOUNT_ID` (`account_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_ASSIGNED_USER_ID` (`assigned_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `meeting_user` -- CREATE TABLE `meeting_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `meeting_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'None', `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_USER_ID_MEETING_ID` (`user_id`,`meeting_id`), KEY `IDX_USER_ID` (`user_id`), KEY `IDX_MEETING_ID` (`meeting_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `next_number` -- CREATE TABLE `next_number` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `entity_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `field_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `value` int(11) DEFAULT '1', PRIMARY KEY (`id`), KEY `IDX_ENTITY_TYPE_FIELD_NAME` (`entity_type`,`field_name`), KEY `IDX_ENTITY_TYPE` (`entity_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `note` -- CREATE TABLE `note` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `post` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `type` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Post', `target_type` varchar(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `number` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `is_global` tinyint(1) NOT NULL DEFAULT '0', `is_internal` tinyint(1) NOT NULL DEFAULT '0', `is_pinned` tinyint(1) NOT NULL DEFAULT '0', `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `parent_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `related_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `related_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `super_parent_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `super_parent_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_NUMBER` (`number`), KEY `IDX_CREATED_AT` (`created_at`), KEY `IDX_CREATED_BY_NUMBER` (`created_by_id`,`number`), KEY `IDX_TYPE` (`type`), KEY `IDX_TARGET_TYPE` (`target_type`), KEY `IDX_PARENT_ID` (`parent_id`), KEY `IDX_PARENT_TYPE` (`parent_type`), KEY `IDX_RELATED_ID` (`related_id`), KEY `IDX_RELATED_TYPE` (`related_type`), KEY `IDX_SUPER_PARENT_TYPE` (`super_parent_type`), KEY `IDX_SUPER_PARENT_ID` (`super_parent_id`), KEY `IDX_PARENT` (`parent_id`,`parent_type`), KEY `IDX_RELATED` (`related_id`,`related_type`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_SUPER_PARENT` (`super_parent_id`,`super_parent_type`), FULLTEXT KEY `IDX_SYSTEM_FULL_TEXT_SEARCH` (`post`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `note_portal` -- CREATE TABLE `note_portal` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `note_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `portal_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_NOTE_ID_PORTAL_ID` (`note_id`,`portal_id`), KEY `IDX_NOTE_ID` (`note_id`), KEY `IDX_PORTAL_ID` (`portal_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `note_team` -- CREATE TABLE `note_team` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `note_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `team_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_NOTE_ID_TEAM_ID` (`note_id`,`team_id`), KEY `IDX_NOTE_ID` (`note_id`), KEY `IDX_TEAM_ID` (`team_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `note_user` -- CREATE TABLE `note_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `note_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_NOTE_ID_USER_ID` (`note_id`,`user_id`), KEY `IDX_NOTE_ID` (`note_id`), KEY `IDX_USER_ID` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `notification` -- CREATE TABLE `notification` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `number` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `read` tinyint(1) NOT NULL DEFAULT '0', `email_is_processed` tinyint(1) NOT NULL DEFAULT '0', `created_at` datetime DEFAULT NULL, `message` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `related_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `related_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `related_parent_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `related_parent_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_NUMBER` (`number`), KEY `IDX_CREATED_AT` (`created_at`), KEY `IDX_USER` (`user_id`,`created_at`), KEY `IDX_USER_ID` (`user_id`), KEY `IDX_RELATED` (`related_id`,`related_type`), KEY `IDX_RELATED_PARENT` (`related_parent_id`,`related_parent_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `opportunity` -- CREATE TABLE `opportunity` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `amount` double DEFAULT NULL, `stage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Prospecting', `last_stage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `probability` int(11) DEFAULT NULL, `lead_source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `close_date` date DEFAULT NULL, `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `amount_currency` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `account_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contact_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `campaign_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigned_user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_CREATED_AT_ID` (`created_at`,`id`), KEY `IDX_STAGE` (`stage`,`deleted`), KEY `IDX_LAST_STAGE` (`last_stage`), KEY `IDX_ASSIGNED_USER` (`assigned_user_id`,`deleted`), KEY `IDX_CREATED_AT` (`created_at`,`deleted`), KEY `IDX_CREATED_AT_STAGE` (`created_at`,`stage`), KEY `IDX_ASSIGNED_USER_STAGE` (`assigned_user_id`,`stage`), KEY `IDX_ACCOUNT_ID` (`account_id`), KEY `IDX_CONTACT_ID` (`contact_id`), KEY `IDX_CAMPAIGN_ID` (`campaign_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_ASSIGNED_USER_ID` (`assigned_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `password_change_request` -- CREATE TABLE `password_change_request` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `request_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_REQUEST_ID` (`request_id`), KEY `IDX_USER_ID` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `phone_number` -- CREATE TABLE `phone_number` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `numeric` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `invalid` tinyint(1) NOT NULL DEFAULT '0', `opt_out` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `IDX_NAME` (`name`), KEY `IDX_NUMERIC` (`numeric`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `portal` -- CREATE TABLE `portal` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `custom_id` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `tab_list` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `quick_create_list` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `theme` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `theme_params` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `language` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `time_zone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `date_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `time_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `week_start` int(11) DEFAULT '-1', `default_currency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dashboard_layout` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `dashlets_options` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `custom_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `auth_token_lifetime` double DEFAULT NULL, `auth_token_max_idle_time` double DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `logo_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `company_logo_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `layout_set_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `authentication_provider_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CUSTOM_ID` (`custom_id`), KEY `IDX_LAYOUT_SET_ID` (`layout_set_id`), KEY `IDX_AUTHENTICATION_PROVIDER_ID` (`authentication_provider_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `portal_portal_role` -- CREATE TABLE `portal_portal_role` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `portal_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `portal_role_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_PORTAL_ID_PORTAL_ROLE_ID` (`portal_id`,`portal_role_id`), KEY `IDX_PORTAL_ID` (`portal_id`), KEY `IDX_PORTAL_ROLE_ID` (`portal_role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `portal_role` -- CREATE TABLE `portal_role` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `field_data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `export_permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'not-set', `mass_update_permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'not-set', `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `portal_role_user` -- CREATE TABLE `portal_role_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `portal_role_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_PORTAL_ROLE_ID_USER_ID` (`portal_role_id`,`user_id`), KEY `IDX_PORTAL_ROLE_ID` (`portal_role_id`), KEY `IDX_USER_ID` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `portal_user` -- CREATE TABLE `portal_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `portal_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_PORTAL_ID_USER_ID` (`portal_id`,`user_id`), KEY `IDX_PORTAL_ID` (`portal_id`), KEY `IDX_USER_ID` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `preferences` -- CREATE TABLE `preferences` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `reminder` -- CREATE TABLE `reminder` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `remind_at` datetime DEFAULT NULL, `start_at` datetime DEFAULT NULL, `type` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Popup', `seconds` int(11) DEFAULT '0', `is_submitted` tinyint(1) NOT NULL DEFAULT '0', `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `entity_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `entity_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_REMIND_AT` (`remind_at`), KEY `IDX_START_AT` (`start_at`), KEY `IDX_TYPE` (`type`), KEY `IDX_USER_ID` (`user_id`), KEY `IDX_ENTITY` (`entity_id`,`entity_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `role` -- CREATE TABLE `role` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `assignment_permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'not-set', `user_permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'not-set', `message_permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'not-set', `portal_permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'not-set', `group_email_account_permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'not-set', `export_permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'not-set', `mass_update_permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'not-set', `data_privacy_permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'not-set', `follower_management_permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'not-set', `audit_permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'not-set', `mention_permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'not-set', `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `field_data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `role_team` -- CREATE TABLE `role_team` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `role_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `team_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_ROLE_ID_TEAM_ID` (`role_id`,`team_id`), KEY `IDX_ROLE_ID` (`role_id`), KEY `IDX_TEAM_ID` (`team_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `role_user` -- CREATE TABLE `role_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `role_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_ROLE_ID_USER_ID` (`role_id`,`user_id`), KEY `IDX_ROLE_ID` (`role_id`), KEY `IDX_USER_ID` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `scheduled_job` -- CREATE TABLE `scheduled_job` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `job` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Active', `scheduling` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_run` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `is_internal` tinyint(1) NOT NULL DEFAULT '0', `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `scheduled_job` -- INSERT INTO `scheduled_job` VALUES ('6708c71f7b611b73a', 'Submit Popup Reminders', 0, 'SubmitPopupReminders', 'Active', '* * * * *', NULL, '[[regtime]]', '[[regtime]]', 1, NULL, NULL), ('6708c71f7e91c441a', 'Process Job Group', 0, 'ProcessJobGroup', 'Active', '* * * * *', NULL, '[[regtime]]', '[[regtime]]', 1, NULL, NULL), ('6708c71f81beae59c', 'Process Job Queue q0', 0, 'ProcessJobQueueQ0', 'Active', '* * * * *', NULL, '[[regtime]]', '[[regtime]]', 1, NULL, NULL), ('6708c71f83c176bf9', 'Process Job Queue q1', 0, 'ProcessJobQueueQ1', 'Active', '*/1 * * * *', NULL, '[[regtime]]', '[[regtime]]', 1, NULL, NULL), ('6708c71f862b3f9f5', 'Process Job Queue e0', 0, 'ProcessJobQueueE0', 'Active', '* * * * *', NULL, '[[regtime]]', '[[regtime]]', 1, NULL, NULL), ('6708c71f883043702', 'Dummy', 0, 'Dummy', 'Active', '1 */12 * * *', NULL, '[[regtime]]', '[[regtime]]', 1, NULL, NULL), ('6708c71f8a39fb362', 'Check for New Version', 0, 'CheckNewVersion', 'Active', '15 5 * * *', NULL, '[[regtime]]', '[[regtime]]', 1, NULL, NULL), ('6708c71f8c0e987f6', 'Check for New Versions of Installed Extensions', 0, 'CheckNewExtensionVersion', 'Active', '25 5 * * *', NULL, '[[regtime]]', '[[regtime]]', 1, NULL, NULL), ('6708c73f68a06fcac', 'Check Group Email Accounts', 0, 'CheckInboundEmails', 'Active', '*/2 * * * *', NULL, '[[regtime]]', '[[regtime]]', 0, 'system', NULL), ('6708c73f6b64ec1e3', 'Check Personal Email Accounts', 0, 'CheckEmailAccounts', 'Active', '*/1 * * * *', NULL, '[[regtime]]', '[[regtime]]', 0, 'system', NULL), ('6708c73f6cf65bfdf', 'Send Email Reminders', 0, 'SendEmailReminders', 'Active', '*/2 * * * *', NULL, '[[regtime]]', '[[regtime]]', 0, 'system', NULL), ('6708c73f6fa692773', 'Send Email Notifications', 0, 'SendEmailNotifications', 'Active', '*/2 * * * *', NULL, '[[regtime]]', '[[regtime]]', 0, 'system', NULL), ('6708c73f71ab1efd8', 'Clean-up', 0, 'Cleanup', 'Active', '1 1 * * 0', NULL, '[[regtime]]', '[[regtime]]', 0, 'system', NULL), ('6708c73f736a3f489', 'Send Mass Emails', 0, 'ProcessMassEmail', 'Active', '10,30,50 * * * *', NULL, '[[regtime]]', '[[regtime]]', 0, 'system', NULL), ('6708c73f74da02033', 'Auth Token Control', 0, 'AuthTokenControl', 'Active', '*/6 * * * *', NULL, '[[regtime]]', '[[regtime]]', 0, 'system', NULL), ('6708c73f769e981e3', 'Control Knowledge Base Article Status', 0, 'ControlKnowledgeBaseArticleStatus', 'Active', '10 1 * * *', NULL, '[[regtime]]', '[[regtime]]', 0, 'system', NULL), ('6708c73f781732f07', 'Process Webhook Queue', 0, 'ProcessWebhookQueue', 'Active', '*/2 * * * *', NULL, '[[regtime]]', '[[regtime]]', 0, 'system', NULL); -- -------------------------------------------------------- -- -- Table structure for table `scheduled_job_log_record` -- CREATE TABLE `scheduled_job_log_record` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `execution_time` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `scheduled_job_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_SCHEDULED_JOB_ID_EXECUTION_TIME` (`scheduled_job_id`,`execution_time`), KEY `IDX_SCHEDULED_JOB_ID` (`scheduled_job_id`), KEY `IDX_TARGET` (`target_id`,`target_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `sms` -- CREATE TABLE `sms` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `from_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Archived', `date_sent` datetime DEFAULT NULL, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `from_phone_number_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `replied_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_DATE_SENT` (`date_sent`,`deleted`), KEY `IDX_DATE_SENT_STATUS` (`date_sent`,`status`,`deleted`), KEY `IDX_FROM_PHONE_NUMBER_ID` (`from_phone_number_id`), KEY `IDX_PARENT` (`parent_id`,`parent_type`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_REPLIED_ID` (`replied_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `sms_phone_number` -- CREATE TABLE `sms_phone_number` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `sms_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `phone_number_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_type` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_SMS_ID_PHONE_NUMBER_ID_ADDRESS_TYPE` (`sms_id`,`phone_number_id`,`address_type`), KEY `IDX_SMS_ID` (`sms_id`), KEY `IDX_PHONE_NUMBER_ID` (`phone_number_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `star_subscription` -- CREATE TABLE `star_subscription` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `deleted` tinyint(1) DEFAULT '0', `created_at` datetime DEFAULT NULL, `entity_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `entity_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_USER_ENTITY` (`user_id`,`entity_id`,`entity_type`), KEY `IDX_USER_ENTITY_TYPE` (`user_id`,`entity_type`), KEY `IDX_ENTITY` (`entity_id`,`entity_type`), KEY `IDX_USER` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `stream_subscription` -- CREATE TABLE `stream_subscription` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `deleted` tinyint(1) DEFAULT '0', `entity_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `entity_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_USER_ENTITY` (`user_id`,`entity_id`,`entity_type`), KEY `IDX_ENTITY` (`entity_id`,`entity_type`), KEY `IDX_USER` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `system_data` -- CREATE TABLE `system_data` ( `id` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `last_password_recovery_date` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `system_data` -- INSERT INTO `system_data` VALUES ('1', 0, NULL); -- -------------------------------------------------------- -- -- Table structure for table `target` -- CREATE TABLE `target` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `salutation_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `first_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '', `last_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '', `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `account_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_street` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_city` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_state` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_country` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `address_postal_code` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `do_not_call` tinyint(1) NOT NULL DEFAULT '0', `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `middle_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigned_user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_FIRST_NAME` (`first_name`,`deleted`), KEY `IDX_NAME` (`first_name`,`last_name`), KEY `IDX_ASSIGNED_USER` (`assigned_user_id`,`deleted`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_ASSIGNED_USER_ID` (`assigned_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `target_list` -- CREATE TABLE `target_list` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigned_user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CREATED_AT` (`created_at`,`deleted`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_ASSIGNED_USER_ID` (`assigned_user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `target_list_user` -- CREATE TABLE `target_list_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_list_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `opted_out` tinyint(1) DEFAULT '0', `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_USER_ID_TARGET_LIST_ID` (`user_id`,`target_list_id`), KEY `IDX_USER_ID` (`user_id`), KEY `IDX_TARGET_LIST_ID` (`target_list_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `task` -- CREATE TABLE `task` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Not Started', `priority` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Normal', `date_start` datetime DEFAULT NULL, `date_end` datetime DEFAULT NULL, `date_start_date` date DEFAULT NULL, `date_end_date` date DEFAULT NULL, `date_completed` datetime DEFAULT NULL, `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `parent_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `parent_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `account_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contact_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `assigned_user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `email_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_DATE_START_STATUS` (`date_start`,`status`), KEY `IDX_DATE_END_STATUS` (`date_end`,`status`), KEY `IDX_DATE_START` (`date_start`,`deleted`), KEY `IDX_STATUS` (`status`,`deleted`), KEY `IDX_ASSIGNED_USER` (`assigned_user_id`,`deleted`), KEY `IDX_ASSIGNED_USER_STATUS` (`assigned_user_id`,`status`), KEY `IDX_PARENT` (`parent_id`,`parent_type`), KEY `IDX_ACCOUNT_ID` (`account_id`), KEY `IDX_CONTACT_ID` (`contact_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`), KEY `IDX_ASSIGNED_USER_ID` (`assigned_user_id`), KEY `IDX_EMAIL_ID` (`email_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `team` -- CREATE TABLE `team` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `position_list` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `layout_set_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `working_time_calendar_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_LAYOUT_SET_ID` (`layout_set_id`), KEY `IDX_WORKING_TIME_CALENDAR_ID` (`working_time_calendar_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `team_user` -- CREATE TABLE `team_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `team_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `role` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_TEAM_ID_USER_ID` (`team_id`,`user_id`), KEY `IDX_TEAM_ID` (`team_id`), KEY `IDX_USER_ID` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `template` -- CREATE TABLE `template` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `body` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `header` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `footer` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `entity_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `left_margin` double DEFAULT '10', `right_margin` double DEFAULT '10', `top_margin` double DEFAULT '10', `bottom_margin` double DEFAULT '20', `print_footer` tinyint(1) NOT NULL DEFAULT '0', `print_header` tinyint(1) NOT NULL DEFAULT '0', `footer_position` double DEFAULT '10', `header_position` double DEFAULT '0', `style` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `page_orientation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Portrait', `page_format` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'A4', `page_width` double DEFAULT NULL, `page_height` double DEFAULT NULL, `font_face` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `version_number` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `two_factor_code` -- CREATE TABLE `two_factor_code` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `method` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `attempts_left` int(11) DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `created_at` datetime DEFAULT NULL, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CREATED_AT` (`created_at`), KEY `IDX_USER_ID_METHOD` (`user_id`,`method`), KEY `IDX_USER_ID_METHOD_IS_ACTIVE` (`user_id`,`method`,`is_active`), KEY `IDX_USER_ID_METHOD_CREATED_AT` (`user_id`,`method`,`created_at`), KEY `IDX_USER_ID` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `unique_id` -- CREATE TABLE `unique_id` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `terminate_at` datetime DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_NAME` (`name`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_TARGET` (`target_id`,`target_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'regular', `password` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `auth_method` varchar(24) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `api_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `salutation_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `first_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `last_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `avatar_color` varchar(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `gender` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `delete_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `middle_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `default_team_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `contact_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `avatar_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `dashboard_template_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `working_time_calendar_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `layout_set_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_USER_NAME_DELETE_ID` (`user_name`,`delete_id`), KEY `IDX_USER_NAME` (`user_name`), KEY `IDX_TYPE` (`type`), KEY `IDX_DEFAULT_TEAM_ID` (`default_team_id`), KEY `IDX_CONTACT_ID` (`contact_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_DASHBOARD_TEMPLATE_ID` (`dashboard_template_id`), KEY `IDX_WORKING_TIME_CALENDAR_ID` (`working_time_calendar_id`), KEY `IDX_LAYOUT_SET_ID` (`layout_set_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `user` -- INSERT INTO `user` VALUES ('[[unique_id_user]]', 0, '[[admin_username]]', 'admin', '[[admin_pass]]', NULL, NULL, NULL, NULL, 'Admin', 1, NULL, NULL, NULL, '[[regtime]]', '[[regtime]]', '0', NULL, NULL, NULL, NULL, 'system', NULL, NULL, NULL), ('system', 0, 'system', 'system', NULL, NULL, NULL, NULL, NULL, 'System', 1, NULL, NULL, NULL, '[[regtime]]', '[[regtime]]', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -- -- Table structure for table `user_data` -- CREATE TABLE `user_data` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `imap_handlers` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `smtp_handlers` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `auth2_f_a` tinyint(1) NOT NULL DEFAULT '0', `auth2_f_a_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `auth2_f_a_totp_secret` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `auth2_f_a_email_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_USER_ID` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `user_working_time_range` -- CREATE TABLE `user_working_time_range` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `working_time_range_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_USER_ID_WORKING_TIME_RANGE_ID` (`user_id`,`working_time_range_id`), KEY `IDX_USER_ID` (`user_id`), KEY `IDX_WORKING_TIME_RANGE_ID` (`working_time_range_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `webhook` -- CREATE TABLE `webhook` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `event` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_active` tinyint(1) NOT NULL DEFAULT '1', `entity_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `field` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `secret_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `user_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_EVENT` (`event`), KEY `IDX_ENTITY_TYPE_TYPE` (`entity_type`,`type`), KEY `IDX_ENTITY_TYPE_FIELD` (`entity_type`,`field`), KEY `IDX_USER_ID` (`user_id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `webhook_event_queue_item` -- CREATE TABLE `webhook_event_queue_item` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `number` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `event` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `is_processed` tinyint(1) NOT NULL DEFAULT '0', `target_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_NUMBER` (`number`), KEY `IDX_TARGET` (`target_id`,`target_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `webhook_queue_item` -- CREATE TABLE `webhook_queue_item` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `deleted` tinyint(1) DEFAULT '0', `number` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `event` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `data` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `status` varchar(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Pending', `processed_at` datetime DEFAULT NULL, `attempts` int(11) DEFAULT '0', `process_at` datetime DEFAULT NULL, `webhook_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `target_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_NUMBER` (`number`), KEY `IDX_WEBHOOK_ID` (`webhook_id`), KEY `IDX_TARGET` (`target_id`,`target_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `working_time_calendar` -- CREATE TABLE `working_time_calendar` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `time_zone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `time_ranges` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `weekday0` tinyint(1) NOT NULL DEFAULT '0', `weekday1` tinyint(1) NOT NULL DEFAULT '1', `weekday2` tinyint(1) NOT NULL DEFAULT '1', `weekday3` tinyint(1) NOT NULL DEFAULT '1', `weekday4` tinyint(1) NOT NULL DEFAULT '1', `weekday5` tinyint(1) NOT NULL DEFAULT '1', `weekday6` tinyint(1) NOT NULL DEFAULT '0', `weekday0_time_ranges` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `weekday1_time_ranges` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `weekday2_time_ranges` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `weekday3_time_ranges` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `weekday4_time_ranges` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `weekday5_time_ranges` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `weekday6_time_ranges` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `working_time_calendar_working_time_range` -- CREATE TABLE `working_time_calendar_working_time_range` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `working_time_calendar_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `working_time_range_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `UNIQ_WORKING_TIME_CALENDAR_ID_WORKING_TIME_RANGE_ID` (`working_time_calendar_id`,`working_time_range_id`), KEY `IDX_WORKING_TIME_CALENDAR_ID` (`working_time_calendar_id`), KEY `IDX_WORKING_TIME_RANGE_ID` (`working_time_range_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `working_time_range` -- CREATE TABLE `working_time_range` ( `id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `deleted` tinyint(1) DEFAULT '0', `time_ranges` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `date_start` date DEFAULT NULL, `date_end` date DEFAULT NULL, `type` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'Non-working', `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci, `created_at` datetime DEFAULT NULL, `modified_at` datetime DEFAULT NULL, `created_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `modified_by_id` varchar(17) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `IDX_TYPE_RANGE` (`type`,`date_start`,`date_end`), KEY `IDX_TYPE` (`type`), KEY `IDX_CREATED_BY_ID` (`created_by_id`), KEY `IDX_MODIFIED_BY_ID` (`modified_by_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!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 */;