-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Tempo de geração: 19-Nov-2025 às 15:07
-- Versão do servidor: 10.4.32-MariaDB
-- versão do PHP: 8.2.12
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
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 utf8mb4 */;
--
-- Banco de dados: `suitecrm`
--
-- --------------------------------------------------------
--
-- Estrutura da tabela `accounts`
--
CREATE TABLE `accounts` (
`id` char(36) NOT NULL,
`name` varchar(150) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`account_type` varchar(50) DEFAULT NULL,
`industry` varchar(50) DEFAULT NULL,
`annual_revenue` varchar(100) DEFAULT NULL,
`phone_fax` varchar(100) DEFAULT NULL,
`billing_address_street` varchar(150) DEFAULT NULL,
`billing_address_city` varchar(100) DEFAULT NULL,
`billing_address_state` varchar(100) DEFAULT NULL,
`billing_address_postalcode` varchar(20) DEFAULT NULL,
`billing_address_country` varchar(255) DEFAULT NULL,
`rating` varchar(100) DEFAULT NULL,
`phone_office` varchar(100) DEFAULT NULL,
`phone_alternate` varchar(100) DEFAULT NULL,
`website` varchar(255) DEFAULT NULL,
`ownership` varchar(100) DEFAULT NULL,
`employees` varchar(10) DEFAULT NULL,
`ticker_symbol` varchar(10) DEFAULT NULL,
`shipping_address_street` varchar(150) DEFAULT NULL,
`shipping_address_city` varchar(100) DEFAULT NULL,
`shipping_address_state` varchar(100) DEFAULT NULL,
`shipping_address_postalcode` varchar(20) DEFAULT NULL,
`shipping_address_country` varchar(255) DEFAULT NULL,
`parent_id` char(36) DEFAULT NULL,
`sic_code` varchar(10) DEFAULT NULL,
`campaign_id` char(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `accounts_audit`
--
CREATE TABLE `accounts_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `accounts_bugs`
--
CREATE TABLE `accounts_bugs` (
`id` varchar(36) NOT NULL,
`account_id` varchar(36) DEFAULT NULL,
`bug_id` varchar(36) DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `accounts_cases`
--
CREATE TABLE `accounts_cases` (
`id` varchar(36) NOT NULL,
`account_id` varchar(36) DEFAULT NULL,
`case_id` varchar(36) DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `accounts_contacts`
--
CREATE TABLE `accounts_contacts` (
`id` varchar(36) NOT NULL,
`contact_id` varchar(36) DEFAULT NULL,
`account_id` varchar(36) DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `accounts_cstm`
--
CREATE TABLE `accounts_cstm` (
`id_c` char(36) NOT NULL,
`jjwg_maps_lng_c` float(11,8) DEFAULT 0.00000000,
`jjwg_maps_lat_c` float(10,8) DEFAULT 0.00000000,
`jjwg_maps_geocode_status_c` varchar(255) DEFAULT NULL,
`jjwg_maps_address_c` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `accounts_opportunities`
--
CREATE TABLE `accounts_opportunities` (
`id` varchar(36) NOT NULL,
`opportunity_id` varchar(36) DEFAULT NULL,
`account_id` varchar(36) DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `acl_actions`
--
CREATE TABLE `acl_actions` (
`id` char(36) NOT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`name` varchar(150) DEFAULT NULL,
`category` varchar(100) DEFAULT NULL,
`acltype` varchar(100) DEFAULT NULL,
`aclaccess` int(3) DEFAULT NULL,
`deleted` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Extraindo dados da tabela `acl_actions`
--
INSERT INTO `acl_actions` (`id`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `name`, `category`, `acltype`, `aclaccess`, `deleted`) VALUES
('105e3e3a-22f1-023f-184f-68fce4a835a4', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'AOS_Products', 'module', 90, 0),
('105e40d2-633b-5e53-c296-68fce45677d5', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'AM_ProjectTemplates', 'module', 90, 0),
('106dcd58-962f-9af8-dc63-68fce4dfaefb', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Emails', 'module', 90, 0),
('117250b6-6a06-d651-1ecd-68fce45cbf61', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'AOS_Products', 'module', 90, 0),
('11a21290-4ac2-6cb4-35ff-68fce4b25e22', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Emails', 'module', 90, 0),
('11a37ce9-f8e6-4f8d-c7b8-68fce46aa60f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'AM_ProjectTemplates', 'module', 90, 0),
('12d1433d-7dac-dfc4-cb26-68fce41cf13a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Emails', 'module', 90, 0),
('12f9cf7f-0db3-50f0-b2a6-68fce4e235c1', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'AM_ProjectTemplates', 'module', 90, 0),
('13260bf3-bd2c-a3f8-3daf-68fce4d44279', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'FP_events', 'module', 89, 0),
('1405941e-a5d4-efe9-03c0-68fce453f5e7', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Emails', 'module', 90, 0),
('14eac9fd-b3db-eeea-c943-68fce4ec5bb4', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'FP_events', 'module', 90, 0),
('1522b584-51ee-1550-8825-68fce473fda6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Emails', 'module', 90, 0),
('1644c7df-9042-9c48-89c2-68fce4e583da', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Emails', 'module', 90, 0),
('16550b76-19e4-37d4-e1b8-68fce4b245ab', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'FP_events', 'module', 90, 0),
('176c204b-d634-65d9-c7d1-68fce40b9214', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Emails', 'module', 90, 0),
('17df5c67-70d9-998a-8587-68fce4bb2b61', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'FP_events', 'module', 90, 0),
('195e7005-bc62-c0f9-06bf-68fce4e0ee79', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'FP_events', 'module', 90, 0),
('1aaf2392-d4ec-67e7-e437-68fce45cc63b', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'FP_events', 'module', 90, 0),
('1ab6054a-7be4-c9ea-2003-68fce4d9b1d4', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'AOW_Processed', 'module', 89, 0),
('1b3b5b05-a691-3960-a6e5-68fce4c97202', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Users', 'module', 89, 0),
('1b87812a-85dd-ae65-f053-68fce4ed9e0a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Prospects', 'module', 89, 0),
('1bea40e2-8939-c74e-3d2a-68fce46bed7f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'FP_events', 'module', 90, 0),
('1c400ece-a3ed-65ce-63aa-68fce5c8215f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'SurveyQuestionOptions', 'module', 90, 0),
('1d0d9caa-6d7b-b0cb-c496-68fce4541402', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Users', 'module', 90, 0),
('1d1c0d10-a960-d140-0801-68fce5f08247', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'SurveyQuestionOptions', 'module', 90, 0),
('1d53d1a7-32f4-b9da-d3da-68fce4117dff', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'FP_events', 'module', 90, 0),
('1d600a2c-e847-be06-0d6b-68fce4d34c38', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Alerts', 'module', 90, 0),
('1e5dbca0-5c30-2a5d-d7ea-68fce48feb06', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Prospects', 'module', 90, 0),
('1e73b69f-5479-1cf6-ec11-68fce416c485', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Users', 'module', 90, 0),
('1f74ea09-f951-e01e-f149-68fce466c01c', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Prospects', 'module', 90, 0),
('1fd8995b-90dc-89e7-3082-68fce45f4c4a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Users', 'module', 90, 0),
('20830f72-303c-37bc-eb16-68fce4bfd137', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Calls_Reschedule', 'module', 90, 0),
('208e0602-613d-eac7-23b7-68fce4f5ff25', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Prospects', 'module', 90, 0),
('20a21a8c-e763-7030-dbce-68fce48864f1', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Accounts', 'module', 89, 0),
('216658b5-0578-c25f-9970-68fce4ff4671', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Users', 'module', 90, 0),
('21b9c429-2bef-70b7-b67f-68fce4ac732d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Prospects', 'module', 90, 0),
('22452540-264f-605b-07c7-68fce4d05039', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Accounts', 'module', 90, 0),
('22472b9b-db27-ed54-5165-68fce48a85ce', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'AOR_Scheduled_Reports', 'module', 89, 0),
('22dcecac-4206-c765-ceae-68fce43274e4', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Prospects', 'module', 90, 0),
('22eed573-048b-782a-9417-68fce48614e6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Users', 'module', 90, 0),
('237f0db0-64a4-8424-54d9-68fce4dfc802', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'AOD_Index', 'module', 90, 0),
('238f666e-f998-78ff-401f-68fce4b447b5', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Accounts', 'module', 90, 0),
('23ac789f-4730-e7fc-efa9-68fce467e82d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'AOR_Scheduled_Reports', 'module', 90, 0),
('23ef1a27-56a7-7f1c-b61a-68fce4d2b418', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Prospects', 'module', 90, 0),
('244d20bd-e2a4-5111-c0b2-68fce46456dd', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Users', 'module', 90, 0),
('24b48390-d885-0a62-4169-68fce4067e2d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Accounts', 'module', 90, 0),
('24f10db5-087a-6557-3d00-68fce499ee8a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'AOR_Scheduled_Reports', 'module', 90, 0),
('25023c36-d08d-d565-9156-68fce4efcec9', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Prospects', 'module', 90, 0),
('25a531fc-c097-2fdc-af35-68fce4948947', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Users', 'module', 90, 0),
('25d9ec70-97e3-81f9-4097-68fce40ac3bf', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Accounts', 'module', 90, 0),
('263f3bee-a770-5e31-f059-68fce43b46c4', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'AOR_Scheduled_Reports', 'module', 90, 0),
('273cc845-76fe-6d25-ba8a-68fce4891ddc', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Accounts', 'module', 90, 0),
('279821ec-812a-b549-1299-68fce4ffafb0', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'AOR_Scheduled_Reports', 'module', 90, 0),
('288f7981-175b-22c8-d7a6-68fce4d89e71', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'SecurityGroups', 'module', 89, 0),
('28a11630-614c-7119-38fc-68fce4012c20', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Accounts', 'module', 90, 0),
('28be9c2b-7196-6628-e314-68fce4d3714b', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'AOR_Scheduled_Reports', 'module', 90, 0),
('29c26c5e-733f-68f2-7667-68fce4598094', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Accounts', 'module', 90, 0),
('29dd0d0f-a61d-bf14-8b7a-68fce45f43cc', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'SecurityGroups', 'module', 90, 0),
('29ed9bbb-8d8b-0e97-07df-68fce49e4d63', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'AOR_Scheduled_Reports', 'module', 90, 0),
('2b173e6c-0fb3-9c09-3c76-68fce46a2e8c', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'AOR_Scheduled_Reports', 'module', 90, 0),
('2b534418-11bd-d280-445d-68fce4dbe5ce', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'AOP_Case_Events', 'module', 89, 0),
('2b536164-ed7a-820a-f962-68fce4836a2a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'SecurityGroups', 'module', 90, 0),
('2cb64012-6877-cf76-cd61-68fce4856cb9', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'SecurityGroups', 'module', 90, 0),
('2cd20e70-5fa7-891d-db51-68fce4b89445', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'AOP_Case_Events', 'module', 90, 0),
('2df64bdd-7cb6-9ce5-5b74-68fce4256137', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'SecurityGroups', 'module', 90, 0),
('2df82b99-f724-2b92-59b1-68fce448c75e', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'AOP_Case_Events', 'module', 90, 0),
('2e490591-f908-a2ea-6354-68fce42807f8', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'AOW_Processed', 'module', 90, 0),
('2f28b69d-1c6f-e760-9c3e-68fce4120019', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'AOP_Case_Events', 'module', 90, 0),
('2f66ff3b-0c9d-3d4c-4f0a-68fce4425dbd', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'SecurityGroups', 'module', 90, 0),
('30b1523b-d86a-1d6f-e5bd-68fce40318ef', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'AOP_Case_Events', 'module', 90, 0),
('30ea44d3-31e6-ad7a-83cf-68fce415b8cb', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'SecurityGroups', 'module', 90, 0),
('313f5950-26c6-a864-921b-68fce436173c', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Documents', 'module', 89, 0),
('32146c86-d292-52cb-4386-68fce47e9142', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'SecurityGroups', 'module', 90, 0),
('322e92d1-cccc-b460-c221-68fce41b5177', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'AOP_Case_Events', 'module', 90, 0),
('32da1eff-e8df-0371-109d-68fce4745e48', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Documents', 'module', 90, 0),
('33bedfb4-1859-5382-ac64-68fce4a1cae3', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'AOP_Case_Events', 'module', 90, 0),
('33d60b13-d3eb-728a-0b03-68fce49776be', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Calls_Reschedule', 'module', 90, 0),
('34297b0e-a0b4-4114-bb24-68fce4a5a69e', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Documents', 'module', 90, 0),
('34c704f0-0ea6-d9c9-2aa1-68fce51a8bd8', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'SurveyQuestionOptions', 'module', 90, 0),
('35a59807-9e32-744a-2c20-68fce4d74be9', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Documents', 'module', 90, 0),
('35c23a27-45cf-1fc7-93c7-68fce49d2a5f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'AOP_Case_Events', 'module', 90, 0),
('36dc6aaa-4f1c-b05e-00a9-68fce4d93769', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Documents', 'module', 90, 0),
('381c995b-523e-d6a1-14d4-68fce47d12ee', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Documents', 'module', 90, 0),
('38400547-ffc3-e509-9a99-68fce4a9cb67', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'AOD_Index', 'module', 90, 0),
('393d6fa6-19ef-4c32-1205-68fce48db6af', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Documents', 'module', 90, 0),
('39efd79a-28a0-39b0-1f3a-68fce4a1c1cd', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Spots', 'module', 89, 0),
('3a7f6750-a629-c6cb-4f3a-68fce4981272', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Documents', 'module', 90, 0),
('3aa7765b-93a4-5d24-530c-68fce47573ed', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'AM_TaskTemplates', 'module', 89, 0),
('3b5d9d1d-31c6-68e0-fe52-68fce45f9060', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'SurveyResponses', 'module', 89, 0),
('3bb5893a-e4b4-fe8f-da1c-68fce4a70c92', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Spots', 'module', 90, 0),
('3c255c0e-020e-1689-251f-68fce4ed3292', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'AM_TaskTemplates', 'module', 90, 0),
('3ca8fd1a-125c-4ba6-472e-68fce4c02747', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'SurveyResponses', 'module', 90, 0),
('3cfeceff-9c6e-0ace-633e-68fce4e80e3d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Spots', 'module', 90, 0),
('3d3dc0ca-a31c-ee79-0975-68fce4712eec', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Meetings', 'module', 89, 0),
('3d7ba0b6-29f2-7587-8c2d-68fce4ec2618', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'AM_TaskTemplates', 'module', 90, 0),
('3de74d68-797f-9ee5-548f-68fce4d43fe3', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'SurveyResponses', 'module', 90, 0),
('3e72bec8-0f5a-ea16-1d9d-68fce436e3a2', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Spots', 'module', 90, 0),
('3ed0932c-f355-3e9d-ac56-68fce4bd1bc0', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Meetings', 'module', 90, 0),
('3ed588ae-5658-0ee8-0234-68fce4e8ed02', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'AM_TaskTemplates', 'module', 90, 0),
('3f32d353-22ec-2a2b-2b46-68fce4dbe2d6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'SurveyResponses', 'module', 90, 0),
('3fe13215-3866-38ae-28fe-68fce410c5b8', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Spots', 'module', 90, 0),
('400fcb21-3ca8-20f7-e625-68fce4c003e3', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'AM_TaskTemplates', 'module', 90, 0),
('4031004d-cc8c-4eab-5627-68fce4dd7d8a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Meetings', 'module', 90, 0),
('4068b31e-e11c-713e-71bc-68fce470d8af', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'SurveyResponses', 'module', 90, 0),
('4131d4f2-d652-7531-dc16-68fce450797a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'AM_TaskTemplates', 'module', 90, 0),
('41333d3a-2ff5-a6da-4512-68fce4fe0c23', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Spots', 'module', 90, 0),
('416e3360-88cd-b9d6-4c41-68fce46a1faf', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Meetings', 'module', 90, 0),
('4187068a-f86e-faa3-3595-68fce4e02b96', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'AOW_Processed', 'module', 90, 0),
('41a2548f-92b3-8334-65f1-68fce47ac4f3', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'SurveyResponses', 'module', 90, 0),
('42615ac9-166f-617a-7430-68fce44b310f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'AM_TaskTemplates', 'module', 90, 0),
('42a6c2e2-8075-c9cc-f5c6-68fce40b4320', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Spots', 'module', 90, 0),
('42b125ce-29fb-9e37-4fbe-68fce494d73c', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Meetings', 'module', 90, 0),
('42f53f99-e59d-1c99-6efe-68fce486386f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'SurveyResponses', 'module', 90, 0),
('43a4367e-6120-b66b-3c5e-68fce433c691', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'AM_TaskTemplates', 'module', 90, 0),
('43f52e70-ba20-15bc-466a-68fce4f88259', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Meetings', 'module', 90, 0),
('444c7393-0e2c-df06-5159-68fce40aabc9', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'SurveyResponses', 'module', 90, 0),
('4458e580-c89b-36ac-d314-68fce43009a5', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Spots', 'module', 90, 0),
('453920b8-acc6-f545-e316-68fce4510dfc', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Meetings', 'module', 90, 0),
('462e7466-218e-fdab-c891-68fce448e802', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'jjwg_Maps', 'module', 89, 0),
('4669d488-ae96-1759-b5d2-68fce402c351', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Meetings', 'module', 90, 0),
('467a1617-5878-ee8b-e6bd-68fce445f86d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Leads', 'module', 89, 0),
('47a9418b-b7b4-c414-b252-68fce49c9611', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'jjwg_Maps', 'module', 90, 0),
('47ab6e1f-c4eb-5948-a325-68fce40c0391', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'FP_Event_Locations', 'module', 89, 0),
('48550745-021e-2c7f-7b6f-68fce436d71b', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Calls_Reschedule', 'module', 90, 0),
('48e9cbb3-c01f-005f-5ca0-68fce4a28e63', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'jjwg_Maps', 'module', 90, 0),
('49873d68-a731-3ca3-de21-68fce487e06a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'FP_Event_Locations', 'module', 90, 0),
('49ae1933-d69d-3a54-d086-68fce45cb4bd', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Leads', 'module', 90, 0),
('4a218c61-6499-adef-0818-68fce4ffb5d9', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'jjwg_Maps', 'module', 90, 0),
('4aff88c9-337e-9df2-9726-68fce4195aea', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'FP_Event_Locations', 'module', 90, 0),
('4b4777b9-5f1a-f626-4ea1-68fce4a84a16', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'jjwg_Maps', 'module', 90, 0),
('4b92e689-cc7e-1380-443c-68fce4174355', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'EmailMarketing', 'module', 89, 0),
('4bca03b2-6914-92e2-8a9f-68fce5a83b84', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'SurveyQuestionOptions', 'module', 90, 0),
('4c5d744b-8ad5-7332-2d40-68fce49c2eac', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'FP_Event_Locations', 'module', 90, 0),
('4c6888b4-fa9e-ce8b-3cb9-68fce4b137f8', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'AOS_Contracts', 'module', 89, 0),
('4c7e084c-f692-0043-5357-68fce484dd62', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'jjwg_Maps', 'module', 90, 0),
('4cc107b6-2ffc-2dd4-919c-68fce4e2c902', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'AOD_Index', 'module', 90, 0),
('4ccefc5e-1b97-70bf-a36a-68fce4466c0b', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'EmailMarketing', 'module', 90, 0),
('4db2b5ad-98fe-0bd4-22d7-68fce4d3bbc3', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'jjwg_Maps', 'module', 90, 0),
('4dd8cd2f-de83-e0f8-5d35-68fce497d0b5', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Leads', 'module', 90, 0),
('4de94328-7dc0-21fe-0522-68fce404ff87', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'FP_Event_Locations', 'module', 90, 0),
('4e06ceaa-e1bd-b8d1-3ba7-68fce426521c', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'EmailMarketing', 'module', 90, 0),
('4e0dda9f-6abb-db77-0a5c-68fce45a53e6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'AOS_Contracts', 'module', 90, 0),
('4f0311e2-3c7e-d0ad-3f9e-68fce4d14586', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'jjwg_Maps', 'module', 90, 0),
('4f1f3156-e284-38c2-9df6-68fce48a98e6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'EmailMarketing', 'module', 90, 0),
('4f2ff0d9-e072-5c53-3663-68fce48eefae', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'AOS_Contracts', 'module', 90, 0),
('4f4368c6-874a-57f1-a352-68fce45de72d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'FP_Event_Locations', 'module', 90, 0),
('50214763-97cf-8ef8-95d6-68fce465d628', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Leads', 'module', 90, 0),
('504ea1bb-4628-bbd1-1799-68fce458b32f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'EmailMarketing', 'module', 90, 0),
('506c4870-ebe6-7904-82d9-68fce4381ea6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'AOS_Contracts', 'module', 90, 0),
('5095aca6-1dc4-6dbd-69d0-68fce4acba19', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'FP_Event_Locations', 'module', 90, 0),
('5172ec64-1d12-28d3-8e77-68fce4a37838', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'EmailMarketing', 'module', 90, 0),
('51af3066-3791-a09e-aa69-68fce4441325', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'AOS_Contracts', 'module', 90, 0),
('521043ce-d489-cad2-0b89-68fce44babdd', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'FP_Event_Locations', 'module', 90, 0),
('521c7b13-05ef-234e-3b0f-68fce44ccc06', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Leads', 'module', 90, 0),
('5294b97a-f95b-6acb-ebdd-68fce444eb00', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'EmailMarketing', 'module', 90, 0),
('52d47fcb-c20b-03d2-ebb4-68fce4f785a6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Opportunities', 'module', 89, 0),
('5319d549-6a5b-336c-ef63-68fce419c866', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'AOS_Contracts', 'module', 90, 0),
('53cccabc-a887-4ebf-78ac-68fce439d293', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'EmailMarketing', 'module', 90, 0),
('53ea0b12-4382-404d-556e-68fce474438a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'AOW_Processed', 'module', 90, 0),
('541dc688-1428-8387-deac-68fce408cd4d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Leads', 'module', 90, 0),
('54535bf9-9bb1-7196-20c7-68fce4d9cf14', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'AOS_Contracts', 'module', 90, 0),
('54634000-5d72-a71c-a71f-68fce44a610d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Opportunities', 'module', 90, 0),
('557e7b40-0ae0-b91e-b0d7-68fce477559d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'OutboundEmailAccounts', 'module', 89, 0),
('558408e5-e9a3-aecf-f641-68fce48c2cd9', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'AOS_Contracts', 'module', 90, 0),
('5596ecda-e95c-d0ba-8f2c-68fce41c7e11', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Opportunities', 'module', 90, 0),
('56361e9d-93a3-eb88-bdc3-68fce42d7d82', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Leads', 'module', 90, 0),
('56ee7b47-09f3-37af-77e7-68fce4454efa', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Opportunities', 'module', 90, 0),
('57730307-6829-32e0-c4a9-68fce4645ca9', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'OutboundEmailAccounts', 'module', 90, 0),
('582ceff1-8a17-893e-e514-68fce4c99432', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Opportunities', 'module', 90, 0),
('58720b65-078a-ea89-bae6-68fce4b0b60b', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Leads', 'module', 90, 0),
('58ccf0b7-2a6b-98b5-2bd6-68fce4a03c21', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'OutboundEmailAccounts', 'module', 90, 0),
('595bfc68-dee7-3302-97d0-68fce40a2d41', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Opportunities', 'module', 90, 0),
('59fe5a2c-9263-cf8b-a022-68fce4d6028e', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'OutboundEmailAccounts', 'module', 90, 0),
('5a0af8ab-202b-3dcc-0e2b-68fce4c3136e', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'AOP_Case_Updates', 'module', 89, 0),
('5a8b6dfd-9f90-df41-40da-68fce4098848', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Opportunities', 'module', 90, 0),
('5b4182c4-164d-30a4-7323-68fce449706d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'OutboundEmailAccounts', 'module', 90, 0),
('5bbd7974-1bc4-3b07-8e4d-68fce4ad4ec6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Project', 'module', 89, 0),
('5bc5656c-8c24-fdf7-efb7-68fce487d669', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Opportunities', 'module', 90, 0),
('5bd00b65-dfab-bd67-7cc1-68fce47df56f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Calls_Reschedule', 'module', 90, 0),
('5bd92e03-08f3-8763-cc3f-68fce451f33c', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'AOP_Case_Updates', 'module', 90, 0),
('5c79dd38-c9cd-399a-08ba-68fce41e4126', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'OutboundEmailAccounts', 'module', 90, 0),
('5d39ae8a-ac9e-8462-9ac4-68fce42a86fc', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'AOP_Case_Updates', 'module', 90, 0),
('5d6d5b7c-6422-cdc1-5ad9-68fce4867c9a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Project', 'module', 90, 0),
('5dad2f70-5b1a-6590-9731-68fce4eecbb1', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'OutboundEmailAccounts', 'module', 90, 0),
('5e674bfa-7b0d-8a5c-807a-68fce469d93f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'AOP_Case_Updates', 'module', 90, 0),
('5ec7b9e7-4e4c-1f1f-dae8-68fce4655f1c', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Project', 'module', 90, 0),
('5ed8dee6-ebc1-0e72-8bf6-68fce4adf21d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'OutboundEmailAccounts', 'module', 90, 0),
('5f410ebd-e65a-7d38-f9f6-68fce551ac70', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'SurveyQuestionOptions', 'module', 90, 0),
('5f7b0401-1cc3-d78b-10ca-68fce44b8cf9', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'AOD_Index', 'module', 90, 0),
('5f951bd8-5d20-103a-2412-68fce4a035b8', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'AOP_Case_Updates', 'module', 90, 0),
('60284030-5c6b-befc-238f-68fce4dd167d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Project', 'module', 90, 0),
('60c6ef09-7136-9c1e-77cb-68fce40408b2', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'AOP_Case_Updates', 'module', 90, 0),
('615004fb-e14c-99c5-0248-68fce4c8cb94', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Project', 'module', 90, 0),
('61e6a1fc-b9e3-f27e-9ace-68fce4d75cf1', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'AOP_Case_Updates', 'module', 90, 0),
('62bd436d-63aa-04bc-afb7-68fce4f13ffb', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Project', 'module', 90, 0),
('630b4b37-a22c-370d-97f7-68fce412a6b1', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'AOP_Case_Updates', 'module', 90, 0),
('63e34c36-bf49-c38a-7b06-68fce461e523', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Project', 'module', 90, 0),
('6552250f-1ae7-397e-dc8d-68fce44abad8', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Project', 'module', 90, 0),
('65da099e-c8e0-f503-2d0d-68fce498d3e2', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'AOW_Processed', 'module', 90, 0),
('67ead30b-85de-b299-00f3-68fce4656683', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Tasks', 'module', 89, 0),
('692d2abc-5ce5-46e7-5224-68fce4908f75', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Tasks', 'module', 90, 0),
('6a58a127-2727-d9e7-11ac-68fce40f9f07', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Tasks', 'module', 90, 0),
('6ba162f1-1532-e72a-6b7b-68fce40ea7c3', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Tasks', 'module', 90, 0),
('6cdee8d7-a0fc-522b-fc5b-68fce4efd92a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Tasks', 'module', 90, 0),
('6df28de5-025f-b011-a4da-68fce499666c', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Surveys', 'module', 89, 0),
('6dfebf20-4d29-7f49-6261-68fce4057db6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Tasks', 'module', 90, 0),
('6f27cc08-edab-0630-d0fc-68fce44a16d3', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Tasks', 'module', 90, 0),
('6fded6fc-0996-b4c1-edfd-68fce41869c6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Surveys', 'module', 90, 0),
('70461399-da31-761d-142d-68fce4c190f9', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Tasks', 'module', 90, 0),
('71337e08-7943-a583-e95e-68fce4f62c4c', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Surveys', 'module', 90, 0),
('71a50819-84eb-4d66-ea68-68fce44cea48', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'AOD_Index', 'module', 90, 0),
('72589ca4-3d83-38a9-b9b2-68fce44e3ae6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'jjwg_Markers', 'module', 89, 0),
('7258c91f-0e6d-fa86-27cf-68fce428edbd', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Surveys', 'module', 90, 0),
('7393c1d7-bf19-8b69-516e-68fce4f9dbc2', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Surveys', 'module', 90, 0),
('73d6d381-bdcf-0238-65af-68fce4396b32', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'jjwg_Markers', 'module', 90, 0),
('74eec093-4319-ace9-ec75-68fce4ad81be', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Surveys', 'module', 90, 0),
('7525d084-f3f6-9802-2acb-68fce4cd781e', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'jjwg_Markers', 'module', 90, 0),
('76468d1c-3452-23ab-92fe-68fce467d341', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Surveys', 'module', 90, 0),
('7660be3a-d52d-aa43-2c9b-68fce475f6ad', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'jjwg_Markers', 'module', 90, 0),
('776b3208-1e63-2257-6495-68fce4f9532d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Surveys', 'module', 90, 0),
('777b9bf5-8679-7d05-b32a-68fce4d331c2', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'jjwg_Markers', 'module', 90, 0),
('7885011b-65ac-1a9e-d0cf-68fce4acbe09', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'AOW_Processed', 'module', 90, 0),
('78b402e1-5b2c-4197-868f-68fce4081fb2', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'jjwg_Markers', 'module', 90, 0),
('7a179d80-92eb-4f80-8ffa-68fce4782b72', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'jjwg_Markers', 'module', 90, 0),
('7ae7e209-08a2-e89d-1a0d-68fce49bb072', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'AOS_Invoices', 'module', 89, 0),
('7b4bff8e-6370-fd39-b0c0-68fce4528d42', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'jjwg_Markers', 'module', 90, 0),
('7b94bd4c-ab0c-32da-5d7b-68fce46e4b63', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'AOS_Quotes', 'module', 89, 0),
('7c2eef77-ccd3-7ad0-ce0a-68fce4a95065', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'AOS_Invoices', 'module', 90, 0),
('7d031d0a-7ec1-881a-c01e-68fce45d0269', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'AOS_Quotes', 'module', 90, 0),
('7d796819-b539-7763-0d65-68fce4550f93', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'AOS_Invoices', 'module', 90, 0),
('7e33cbf2-dc1d-7006-d2c5-68fce4f5bc7f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'AOS_Quotes', 'module', 90, 0),
('7ec20c15-bafc-e0e5-81d3-68fce4abe9a5', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'AOS_Invoices', 'module', 90, 0),
('7f555707-e65c-cc15-96a2-68fce4cb37a4', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'AOS_Quotes', 'module', 90, 0),
('7ffe1810-7279-294b-0908-68fce49fd497', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'AOS_Invoices', 'module', 90, 0),
('8049dc3d-ef9f-b089-ce10-68fce42cad1d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'AOK_Knowledge_Base_Categories', 'module', 89, 0),
('80831261-2aed-f6c0-96ac-68fce445bb51', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'AOS_Quotes', 'module', 90, 0),
('814023dc-5657-6d7e-0471-68fce45c79a8', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'AOS_Invoices', 'module', 90, 0),
('819f6865-9153-642b-3280-68fce4e6afdf', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'AOK_Knowledge_Base_Categories', 'module', 90, 0),
('81b0fa85-0d9b-c859-9fb6-68fce4b33dde', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'AOS_Quotes', 'module', 90, 0),
('8240025d-9135-1571-1916-68fce4151429', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'AOD_IndexEvent', 'module', 89, 0),
('8268f181-ff21-17c1-4ad1-68fce4f2f4f0', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'AOS_Invoices', 'module', 90, 0),
('82db12a1-5033-0ac1-5f70-68fce4ad31e9', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'ExternalOAuthConnection', 'module', 89, 0),
('82dd1d76-d0d1-7153-ea11-68fce418d4f8', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'EmailTemplates', 'module', 89, 0),
('82e555d6-be2e-cca6-0a68-68fce47f043d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'AOS_Quotes', 'module', 90, 0),
('83132916-fc06-cbee-4006-68fce440e481', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'AOK_Knowledge_Base_Categories', 'module', 90, 0),
('83b2aea3-2d84-86a9-d975-68fce4907f98', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'AOD_IndexEvent', 'module', 90, 0),
('83cf29b3-247b-a730-4029-68fce4935a21', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'AOS_Invoices', 'module', 90, 0),
('8420029e-41eb-8256-bbb2-68fce43c681f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'EmailTemplates', 'module', 90, 0),
('84252924-0553-8d1a-09b1-68fce4a580c7', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'AOS_Quotes', 'module', 90, 0),
('849ca2cc-10d4-f768-274a-68fce40101f1', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'ExternalOAuthConnection', 'module', 90, 0),
('84c3e1c8-da97-67db-42a4-68fce4081970', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'AOK_Knowledge_Base_Categories', 'module', 90, 0),
('8501802d-7a4c-67fe-3e76-68fce4b91b2a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'AOD_IndexEvent', 'module', 90, 0),
('85451ff8-d962-2f8c-5cd0-68fce40fb5bc', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'ProjectTask', 'module', 89, 0),
('854b5f96-580d-f602-7929-68fce4cba4c5', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'EmailTemplates', 'module', 90, 0),
('85c5347b-0100-9197-81ea-68fce4ddc327', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'ExternalOAuthConnection', 'module', 90, 0),
('862709ef-71de-fa80-fda4-68fce492430f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'AOK_Knowledge_Base_Categories', 'module', 90, 0),
('8651639d-3762-dddf-6a6e-68fce456de47', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'AOD_IndexEvent', 'module', 90, 0),
('866cb710-5b8a-f846-5bc8-68fce457818f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'EmailTemplates', 'module', 90, 0),
('869bc579-5542-b199-fdb0-68fce4492997', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'ProjectTask', 'module', 90, 0),
('86f73eb9-27ca-d13b-9070-68fce42a173c', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'ExternalOAuthConnection', 'module', 90, 0),
('876d94aa-0198-e6c4-2ca2-68fce4c86b3a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'AOK_Knowledge_Base_Categories', 'module', 90, 0),
('879c4f00-1ae2-0c8d-9356-68fce4c90825', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'AOD_IndexEvent', 'module', 90, 0),
('87c6183f-1974-44d2-690e-68fce4104dba', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'EmailTemplates', 'module', 90, 0),
('87db4f89-15a6-4984-fab3-68fce43cd598', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'ProjectTask', 'module', 90, 0),
('8845afdd-51aa-d956-3628-68fce430e4d6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'ExternalOAuthConnection', 'module', 90, 0),
('88c04237-ea1e-ecd3-59b0-68fce4ca40b6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'AOK_Knowledge_Base_Categories', 'module', 90, 0),
('88fd8808-d77c-c030-b7a2-68fce481be2a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'ProjectTask', 'module', 90, 0),
('893849e0-66e7-4c4d-e1da-68fce4058854', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'EmailTemplates', 'module', 90, 0),
('89457628-aa0c-d958-603b-68fce422fcbb', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'AOD_IndexEvent', 'module', 90, 0),
('89a69306-3f7e-40ee-3dd2-68fce4aaa945', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'ExternalOAuthConnection', 'module', 90, 0),
('8a02bb58-dc1d-8d27-804c-68fce456c3e8', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'AOK_Knowledge_Base_Categories', 'module', 90, 0),
('8a1a4768-27c6-8913-111c-68fce468f390', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'ProjectTask', 'module', 90, 0),
('8a60b3fc-4b1e-c286-1de2-68fce405e407', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'EmailTemplates', 'module', 90, 0),
('8a93032e-198e-cc9f-f38d-68fce4ab59db', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'AOD_IndexEvent', 'module', 90, 0),
('8aedb3cc-ad81-3816-0c3b-68fce4327475', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'ExternalOAuthConnection', 'module', 90, 0),
('8b0e0d62-670a-10fe-ec9e-68fce449d59a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'AOW_Processed', 'module', 90, 0),
('8b77d69a-a084-91a0-ebd6-68fce4ff329e', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'EmailTemplates', 'module', 90, 0),
('8b7f0850-ae89-6923-f0ca-68fce4145699', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'ProjectTask', 'module', 90, 0),
('8bd3bfee-aaba-b775-f390-68fce4568e58', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'AOD_IndexEvent', 'module', 90, 0),
('8c2b41b2-9771-28ee-0768-68fce464f441', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'ExternalOAuthConnection', 'module', 90, 0),
('8caf4bf8-cec6-aa22-7dbe-68fce495676e', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'ProjectTask', 'module', 90, 0),
('8e05d92f-d76b-3ab5-e768-68fce4dd49d2', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'ProjectTask', 'module', 90, 0),
('92611f13-8c30-bc79-433d-68fce4917983', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'AOR_Reports', 'module', 89, 0),
('931e004f-b356-f2f2-2999-68fce450e61a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'AOS_Products', 'module', 89, 0),
('9412ae9e-cde2-f354-a4ab-68fce4bf0d53', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'AOR_Reports', 'module', 90, 0),
('956103f9-9d55-5d62-00fc-68fce425c8f8', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'AOR_Reports', 'module', 90, 0),
('969f143c-cb1b-103d-b861-68fce4d2defb', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'AOR_Reports', 'module', 90, 0),
('98095daf-198c-4093-b5b5-68fce4025e71', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'AOR_Reports', 'module', 90, 0),
('995b9932-4557-d563-0b7b-68fce4b57b15', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'AOR_Reports', 'module', 90, 0),
('9a987f7f-0072-9238-8728-68fce4bebf05', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'AOR_Reports', 'module', 90, 0),
('9c05f713-89d6-9a7e-30c1-68fce4d763cc', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'AOR_Reports', 'module', 90, 0),
('9ce10e02-d54a-09f4-0671-68fce45a6140', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'AM_ProjectTemplates', 'module', 89, 0),
('9d37a26d-ab25-da2a-3dc4-68fce47a4c77', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'SurveyQuestionResponses', 'module', 89, 0),
('9e1480cc-3449-c120-ad15-68fce4b0dfa4', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'jjwg_Areas', 'module', 89, 0),
('9e7f8ef8-2dea-aaa4-3fc7-68fce4e9ce72', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'SurveyQuestionResponses', 'module', 90, 0),
('9f84096e-7513-d77a-a5e3-68fce4ca559b', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'jjwg_Areas', 'module', 90, 0),
('9fc7dfd7-bc1a-52f2-fea2-68fce43f3a50', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'SurveyQuestionResponses', 'module', 90, 0),
('a0b6bb9e-6aab-dcd1-2aba-68fce474b6ce', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'jjwg_Areas', 'module', 90, 0),
('a106934f-7bfd-8de5-c728-68fce4980083', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'SurveyQuestionResponses', 'module', 90, 0),
('a16e0af5-2f25-4019-6466-68fce4464078', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'AOW_Processed', 'module', 90, 0),
('a1e6a784-c1f1-972a-5ec3-68fce45c1ae1', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'jjwg_Areas', 'module', 90, 0),
('a23cf16f-bec6-5867-7122-68fce4575e9a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'SurveyQuestionResponses', 'module', 90, 0),
('a31c922b-8f95-f2dc-2d81-68fce4a2bb33', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'jjwg_Areas', 'module', 90, 0),
('a36783a7-0ed0-99d7-18af-68fce494af59', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'SurveyQuestionResponses', 'module', 90, 0),
('a44426c0-b03e-c795-3711-68fce4d81b40', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'jjwg_Areas', 'module', 90, 0),
('a49387ba-35f5-b604-0dd2-68fce41776d3', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'SurveyQuestionResponses', 'module', 90, 0),
('a58f2b01-e273-bd5d-652b-68fce4dd2a79', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'jjwg_Areas', 'module', 90, 0),
('a5ca7939-7676-aafb-58d2-68fce44a4237', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'SurveyQuestionResponses', 'module', 90, 0),
('a6284eb5-9742-f536-789f-68fce40b9565', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'EAPM', 'module', 89, 0),
('a6ccd217-d816-9ed3-159c-68fce4478dd8', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'jjwg_Areas', 'module', 90, 0),
('a734dd7e-9091-cdfa-05ed-68fce433ece9', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'AOS_PDF_Templates', 'module', 89, 0),
('a78b5bc3-da37-e292-78a8-68fce46217d6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'EAPM', 'module', 90, 0),
('a8237f62-40e4-e967-9ae1-68fce486c9b9', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Cases', 'module', 89, 0),
('a872c65e-1c26-db82-bd14-68fce4e6f9db', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'AOS_PDF_Templates', 'module', 90, 0),
('a8e5e516-e240-e654-6559-68fce437aa8c', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'EAPM', 'module', 90, 0),
('a99b07c9-e7f6-ced8-adb8-68fce40818aa', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'AOS_Products', 'module', 90, 0),
('a9a0ec1a-78a6-7c58-836d-68fce484b06b', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Cases', 'module', 90, 0),
('a9ba63ea-940f-8f8b-54a7-68fce4fefd4f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'AOS_PDF_Templates', 'module', 90, 0),
('aa327f01-d2ee-bcc3-d553-68fce428fdf6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'EAPM', 'module', 90, 0),
('aadc5ecd-2b0e-7f30-43ed-68fce4189e64', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Notes', 'module', 89, 0),
('ab251ddb-528e-45fc-abd7-68fce450215f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'AOS_PDF_Templates', 'module', 90, 0),
('ab4ddc05-bb9b-6b22-0521-68fce4db0ff3', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Cases', 'module', 90, 0),
('ab7d114a-9a62-e416-6ae7-68fce496c178', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'ExternalOAuthProvider', 'module', 89, 0),
('ab7f9682-430c-220e-8834-68fce4b197bc', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'EAPM', 'module', 90, 0),
('abb63603-97f1-d7e1-29af-68fce43f6b32', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'AOK_KnowledgeBase', 'module', 89, 0),
('ac03fd40-965f-5e58-9da0-68fce4add642', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Notes', 'module', 90, 0),
('ac4c988b-6eec-76cf-265b-68fce4fdd006', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'AOS_PDF_Templates', 'module', 90, 0),
('acb6ebd6-06eb-e259-6f04-68fce4bb23e7', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Cases', 'module', 90, 0),
('acb92f9a-8eaf-1bc3-afb5-68fce4ed2b77', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'EAPM', 'module', 90, 0),
('acdc67c8-40de-535b-ef8d-68fce40888fc', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'ExternalOAuthProvider', 'module', 90, 0),
('ad232fac-91d8-c00a-7d06-68fce4987bc5', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Notes', 'module', 90, 0),
('ad4ffd55-fdbf-0e7f-45fa-68fce4956d36', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'AOK_KnowledgeBase', 'module', 90, 0),
('ad83026b-5e0d-584e-51e5-68fce4480fc4', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'AOS_PDF_Templates', 'module', 90, 0),
('adc6dc42-50f9-3bfd-6b8d-68fce4a212b8', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Cases', 'module', 90, 0),
('adfbff8c-f671-e9fd-3427-68fce4f99931', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'EAPM', 'module', 90, 0),
('ae13fa60-1ab9-21a6-28dd-68fce4ee1203', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'ExternalOAuthProvider', 'module', 90, 0),
('ae4986b3-adeb-c741-cf0d-68fce4e8d9a3', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Notes', 'module', 90, 0),
('ae92ccba-6662-7d29-49a4-68fce4801313', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'AOK_KnowledgeBase', 'module', 90, 0),
('aea80f77-dea6-d419-1dd1-68fce4be8e03', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'AOS_PDF_Templates', 'module', 90, 0),
('af29903f-3a5a-deba-347f-68fce4c115ac', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Cases', 'module', 90, 0),
('af2c8871-7681-588e-94d3-68fce49bf514', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'EAPM', 'module', 90, 0),
('af581331-a479-6ccd-1452-68fce49e74b0', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'ExternalOAuthProvider', 'module', 90, 0),
('af7e4d9d-169b-e0e9-0056-68fce44ee38a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Notes', 'module', 90, 0),
('afe4b929-a6ff-eab3-9da8-68fce4c75155', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'AOK_KnowledgeBase', 'module', 90, 0),
('aff4aa71-1451-5e4b-19cf-68fce401e5ed', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'AOS_PDF_Templates', 'module', 90, 0),
('b051d769-1e2e-b493-b1c6-68fce45df978', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Cases', 'module', 90, 0),
('b0887e4e-499b-8942-8087-68fce41bacfa', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'ExternalOAuthProvider', 'module', 90, 0),
('b0c8f90e-2509-73b8-2962-68fce47f76ad', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Notes', 'module', 90, 0),
('b1297107-7354-baaf-d624-68fce41dbe4e', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'AOK_KnowledgeBase', 'module', 90, 0),
('b1a80272-c4cb-f966-1064-68fce41f979a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'ExternalOAuthProvider', 'module', 90, 0),
('b1adcf13-3fa6-232f-9344-68fce496f00c', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Cases', 'module', 90, 0),
('b1f5564a-17ab-72b3-1392-68fce42ae5ee', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Notes', 'module', 90, 0),
('b257dafa-911d-ec59-957a-68fce44fde85', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'AOK_KnowledgeBase', 'module', 90, 0),
('b2d5e0a2-edda-a2a8-a7da-68fce466aa6e', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'ExternalOAuthProvider', 'module', 90, 0),
('b30f98c6-513a-d12e-e604-68fce4eebbe1', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Notes', 'module', 90, 0),
('b395e51a-3728-6195-5d91-68fce4dd24d0', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'AOK_KnowledgeBase', 'module', 90, 0),
('b41713a9-22be-a5ef-babd-68fce4788f09', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'ExternalOAuthProvider', 'module', 90, 0),
('b4e82533-b15d-2c31-7757-68fce4f50298', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'AOK_KnowledgeBase', 'module', 90, 0),
('b5ad089d-9045-00c4-a3db-68fce4b9614b', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'AM_ProjectTemplates', 'module', 90, 0),
('b5c53d04-aa56-af60-ef49-68fce406634e', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Campaigns', 'module', 89, 0);
INSERT INTO `acl_actions` (`id`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `name`, `category`, `acltype`, `aclaccess`, `deleted`) VALUES
('b6f5be99-97d7-009e-1641-68fce4b45733', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Campaigns', 'module', 90, 0),
('b80f06d0-c55d-4e0e-2d7e-68fce4d04ff3', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Campaigns', 'module', 90, 0),
('b939441d-a0ea-c55b-009b-68fce45e277f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Campaigns', 'module', 90, 0),
('ba6c2425-6eba-4950-01c6-68fce4ef68c4', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Campaigns', 'module', 90, 0),
('bb88b302-3c75-75a8-9799-68fce4e30850', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Campaigns', 'module', 90, 0),
('bca56d60-e1b4-3bcc-9999-68fce481a844', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Campaigns', 'module', 90, 0),
('bd480090-1206-39e6-17ea-68fce447d3ea', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'AOS_Products', 'module', 90, 0),
('bdea61bf-6f44-c532-5042-68fce45c4b43', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Campaigns', 'module', 90, 0),
('bf289b5e-3063-9f60-605c-68fce421c4c2', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'InboundEmail', 'module', 89, 0),
('c0887783-99ce-8028-5ca3-68fce4154d9e', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'InboundEmail', 'module', 90, 0),
('c1c43bfb-a99f-24c3-9f37-68fce4736454', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'InboundEmail', 'module', 90, 0),
('c2f1fa45-c7f1-f152-161a-68fce4a58289', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'InboundEmail', 'module', 90, 0),
('c424c1ba-9398-0686-8948-68fce49d7359', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'InboundEmail', 'module', 90, 0),
('c53e3e48-bb69-1196-33d7-68fce4d7f7dd', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'InboundEmail', 'module', 90, 0),
('c590ab37-816f-891b-32c3-68fce41462df', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'jjwg_Address_Cache', 'module', 89, 0),
('c6235139-9680-df4b-e368-68fce47c8701', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'SurveyQuestions', 'module', 89, 0),
('c67f9299-b37d-6317-c7f8-68fce4b43359', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'InboundEmail', 'module', 90, 0),
('c70e7a76-c4ca-cb96-2647-68fce4c47525', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'jjwg_Address_Cache', 'module', 90, 0),
('c79298cc-9347-767e-e101-68fce4de8f43', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'AOW_WorkFlow', 'module', 89, 0),
('c7ab75e3-413e-e0be-c460-68fce421bb1a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'InboundEmail', 'module', 90, 0),
('c7c117bc-97db-9efe-3189-68fce4fcd923', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'SurveyQuestions', 'module', 90, 0),
('c80d0955-6859-3c35-7666-68fce46d71e6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'AM_ProjectTemplates', 'module', 90, 0),
('c8947ccc-6950-d8b2-31dc-68fce4e3fe7a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'jjwg_Address_Cache', 'module', 90, 0),
('c90f831c-0c7c-c26a-70bc-68fce4a04436', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'SurveyQuestions', 'module', 90, 0),
('c93267f4-1e71-c14f-7d44-68fce42e093a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'AOW_WorkFlow', 'module', 90, 0),
('c9d3dd9b-a7d8-ad12-ae68-68fce472ba68', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'jjwg_Address_Cache', 'module', 90, 0),
('ca4d2e26-e1d2-ed81-0347-68fce439e99f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'SurveyQuestions', 'module', 90, 0),
('caaccc24-ba10-3992-d6a9-68fce4bc0523', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'AOW_WorkFlow', 'module', 90, 0),
('cb063a64-a57a-7a34-ebf0-68fce43997d6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'jjwg_Address_Cache', 'module', 90, 0),
('cb6f0436-28ab-5e87-84ba-68fce47be5b4', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'SurveyQuestions', 'module', 90, 0),
('cbeb3c6c-49f9-b0b1-a9d2-68fce403630f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'AOW_WorkFlow', 'module', 90, 0),
('cc5922ee-eee3-7247-583d-68fce4f8cd0e', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'jjwg_Address_Cache', 'module', 90, 0),
('cc9ebc1d-bd77-d8b2-0b72-68fce48b3903', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'SurveyQuestions', 'module', 90, 0),
('cd54ea2d-c1b8-7f75-512c-68fce4d13e7f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'AOW_WorkFlow', 'module', 90, 0),
('cd904f72-088b-fcbb-4831-68fce43e2baa', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'jjwg_Address_Cache', 'module', 90, 0),
('cddd0200-c837-0079-b86f-68fce46221c6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'SurveyQuestions', 'module', 90, 0),
('ce771a71-7d42-a8be-79fe-68fce4fa2ace', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'AOW_WorkFlow', 'module', 90, 0),
('cecd72e2-fff5-7633-f34c-68fce4021c9f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'jjwg_Address_Cache', 'module', 90, 0),
('cf12efac-f31f-671c-87db-68fce4cefd18', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'SurveyQuestions', 'module', 90, 0),
('cf913efb-b4d6-9691-b3a7-68fce4443c6d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'AOW_WorkFlow', 'module', 90, 0),
('d04e0515-c302-6f49-92a2-68fce4f14c72', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'AOS_Products', 'module', 90, 0),
('d0ae1404-798b-5690-e6e4-68fce41e77e8', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'TemplateSectionLine', 'module', 89, 0),
('d0b55143-dc83-c558-4311-68fce408684f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'AOW_WorkFlow', 'module', 90, 0),
('d2237e17-b1b4-dcd3-1201-68fce423567e', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'TemplateSectionLine', 'module', 90, 0),
('d242a96e-c19b-ad86-48cf-68fce40f32e5', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'AOS_Product_Categories', 'module', 89, 0),
('d358259f-d825-bb18-093e-68fce43b423c', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'TemplateSectionLine', 'module', 90, 0),
('d3d7a249-7487-3d42-080f-68fce423c39d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'AOS_Product_Categories', 'module', 90, 0),
('d4936eb2-ec07-d8a5-582d-68fce478893b', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Calls', 'module', 89, 0),
('d495595a-55c0-c84f-5f10-68fce46522da', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'TemplateSectionLine', 'module', 90, 0),
('d5132d6e-3edc-4f23-ecb4-68fce4dca49b', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'AOS_Product_Categories', 'module', 90, 0),
('d5d067e4-369d-d1cb-820b-68fce40f46de', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Calls', 'module', 90, 0),
('d5f8aa87-6da5-39b2-1668-68fce47d8ef7', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'TemplateSectionLine', 'module', 90, 0),
('d63bc40b-f2fa-550b-8a96-68fce48c1c02', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'AOS_Product_Categories', 'module', 90, 0),
('d73d3064-cbea-b00e-fa48-68fce4b89a0b', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Calls', 'module', 90, 0),
('d7483033-1492-f9ba-094f-68fce4f64200', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'TemplateSectionLine', 'module', 90, 0),
('d7539a91-de02-0c9b-67e7-68fce47c6a56', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'AOS_Product_Categories', 'module', 90, 0),
('d85c599b-b9ef-f0d6-2507-68fce4ec113c', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Contacts', 'module', 89, 0),
('d86f1b18-1a30-8edd-3366-68fce4e5b0e8', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Calls', 'module', 90, 0),
('d87187fc-2cb0-9856-0d66-68fce4c277b9', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'AOS_Product_Categories', 'module', 90, 0),
('d872ea85-16d2-047e-0c96-68fce4be6000', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'TemplateSectionLine', 'module', 90, 0),
('d987a305-b389-d415-6c90-68fce43b4c4f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'AOS_Product_Categories', 'module', 90, 0),
('d98d288d-016c-11ca-b1bb-68fce44fae3f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Contacts', 'module', 90, 0),
('d99097a6-1fb3-2d35-e260-68fce4da2202', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'TemplateSectionLine', 'module', 90, 0),
('d99e357c-390c-3c5b-4fbc-68fce43bce84', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Calls', 'module', 90, 0),
('da850518-bd3d-0ec9-5110-68fce4a6dd5f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'AM_ProjectTemplates', 'module', 90, 0),
('da9aa9af-ebcc-541d-fed3-68fce4b4a736', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Contacts', 'module', 90, 0),
('dab294b0-f662-6015-48a4-68fce400f4d4', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'AOS_Product_Categories', 'module', 90, 0),
('dabd9d7c-4346-e240-d268-68fce42de2d4', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Calls', 'module', 90, 0),
('dba4c6c3-94eb-1edc-4a36-68fce4041212', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Bugs', 'module', 89, 0),
('dbae9717-71e6-77ce-1661-68fce4bd66fb', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Contacts', 'module', 90, 0),
('dc05dbc3-c439-26bd-0e18-68fce47a59b2', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Calls', 'module', 90, 0),
('dcb9918d-682d-8928-4814-68fce45c5226', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Contacts', 'module', 90, 0),
('dd2627fe-d2a0-bf79-4bbc-68fce49830b3', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Bugs', 'module', 90, 0),
('dd3b154c-561e-67c9-8e39-68fce40c38f4', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Calls', 'module', 90, 0),
('ddb3af8b-9b01-1f3f-212d-68fce4e583b9', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Contacts', 'module', 90, 0),
('de75c1d6-b996-2b0a-7b26-68fce42941ce', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Bugs', 'module', 90, 0),
('dedeffa4-7b28-94cb-705c-68fce496abc1', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Contacts', 'module', 90, 0),
('dfde2274-8c06-17af-0827-68fce451d553', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Bugs', 'module', 90, 0),
('dff54971-19c3-2ef2-3050-68fce463892f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Contacts', 'module', 90, 0),
('e13430f9-c50f-1957-513e-68fce4055f61', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Bugs', 'module', 90, 0),
('e1500098-d5af-4a8a-5831-68fce4fef870', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Calls_Reschedule', 'module', 90, 0),
('e28a0f20-a55a-64e8-d044-68fce49e04a1', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Bugs', 'module', 90, 0),
('e2e40f91-e4b9-cec8-c947-68fce43e06a8', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'AOS_Products', 'module', 90, 0),
('e3aa203f-7170-6ab9-103d-68fce4da189d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Bugs', 'module', 90, 0),
('e3f18175-b3a9-8ea4-af20-68fce41ec0f7', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'ProspectLists', 'module', 89, 0),
('e50cd4dc-f217-83c1-7915-68fce47dfb28', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'Bugs', 'module', 90, 0),
('e58bc028-e5b1-e962-b247-68fce43cdd51', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'ProspectLists', 'module', 90, 0),
('e711cd76-56df-db74-219e-68fce4ebae46', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'ProspectLists', 'module', 90, 0),
('e83e0ecb-7799-203a-7b00-68fce4ee6f82', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'ProspectLists', 'module', 90, 0),
('e96dd61e-092f-58ce-629b-68fce4d22236', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'ProspectLists', 'module', 90, 0),
('eab2d42b-f5f3-77ca-2d2c-68fce47f5b0f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Alerts', 'module', 89, 0),
('eab5fd45-e02d-5d70-f225-68fce42eff2c', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'ProspectLists', 'module', 90, 0),
('ebfa3b88-3236-7f93-4826-68fce4f176f7', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'ProspectLists', 'module', 90, 0),
('ec42dfab-a0d1-2a47-5051-68fce44aa48a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Alerts', 'module', 90, 0),
('ed290641-5c5f-a4de-3674-68fce4aa3aff', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'massupdate', 'ProspectLists', 'module', 90, 0),
('ed71b342-3742-128f-d20c-68fce45f2b75', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Alerts', 'module', 90, 0),
('ef0a5551-3b88-92a9-a157-68fce4aa3d8a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'edit', 'Alerts', 'module', 90, 0),
('efe983cb-ca90-0503-cd00-68fce4dc6b1a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'SurveyQuestionOptions', 'module', 89, 0),
('f008094c-05f7-4e98-6aff-68fce4506bad', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'AM_ProjectTemplates', 'module', 90, 0),
('f097214e-4a48-e464-89b8-68fce45dd6b2', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'delete', 'Alerts', 'module', 90, 0),
('f0df44ab-8627-a87e-d1e8-68fce4c3d61c', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Calls_Reschedule', 'module', 89, 0),
('f154be34-ce53-bdb1-bbf2-68fce4bae65a', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'SurveyQuestionOptions', 'module', 90, 0),
('f1c6348e-e60c-9c7c-4d7e-68fce4da170f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'AOD_Index', 'module', 89, 0),
('f1c63f56-897e-1f0b-3ca9-68fce401079f', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'Alerts', 'module', 90, 0),
('f2461a58-8cd3-6ed4-b6e9-68fce4ddde22', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'Calls_Reschedule', 'module', 90, 0),
('f2ab48df-d7a6-3266-e006-68fce4dd4f59', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'SurveyQuestionOptions', 'module', 90, 0),
('f2ff0e4a-6a0b-7192-d043-68fce405838b', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'access', 'Emails', 'module', 89, 0),
('f302762f-5244-81ca-1d0a-68fce4d02cd5', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'export', 'Alerts', 'module', 90, 0),
('f37d32af-9fb7-8a7a-2686-68fce4d0e442', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'view', 'AOD_Index', 'module', 90, 0),
('f3b102dd-b5f6-9ca2-11ed-68fce43239cf', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'Calls_Reschedule', 'module', 90, 0),
('f4d00de5-fedb-f5c1-aaad-68fce44fee31', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'import', 'AOS_Products', 'module', 90, 0),
('fd700145-d123-a0d8-c26d-68fce41b2d6d', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '', 'list', 'AOD_Index', 'module', 90, 0);
-- --------------------------------------------------------
--
-- Estrutura da tabela `acl_roles`
--
CREATE TABLE `acl_roles` (
`id` char(36) NOT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`name` varchar(150) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `acl_roles_actions`
--
CREATE TABLE `acl_roles_actions` (
`id` varchar(36) NOT NULL,
`role_id` varchar(36) DEFAULT NULL,
`action_id` varchar(36) DEFAULT NULL,
`access_override` int(3) DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `acl_roles_users`
--
CREATE TABLE `acl_roles_users` (
`id` varchar(36) NOT NULL,
`role_id` varchar(36) DEFAULT NULL,
`user_id` varchar(36) DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `address_book`
--
CREATE TABLE `address_book` (
`assigned_user_id` char(36) NOT NULL,
`bean` varchar(50) DEFAULT NULL,
`bean_id` char(36) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `alerts`
--
CREATE TABLE `alerts` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`is_read` tinyint(1) DEFAULT NULL,
`target_module` varchar(255) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL,
`url_redirect` varchar(255) DEFAULT NULL,
`reminder_id` char(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `am_projecttemplates`
--
CREATE TABLE `am_projecttemplates` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`status` varchar(100) DEFAULT 'Draft',
`priority` varchar(100) DEFAULT 'High',
`override_business_hours` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `am_projecttemplates_audit`
--
CREATE TABLE `am_projecttemplates_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `am_projecttemplates_contacts_1_c`
--
CREATE TABLE `am_projecttemplates_contacts_1_c` (
`id` varchar(36) NOT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`am_projecttemplates_ida` varchar(36) DEFAULT NULL,
`contacts_idb` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `am_projecttemplates_project_1_c`
--
CREATE TABLE `am_projecttemplates_project_1_c` (
`id` varchar(36) NOT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`am_projecttemplates_project_1am_projecttemplates_ida` varchar(36) DEFAULT NULL,
`am_projecttemplates_project_1project_idb` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `am_projecttemplates_users_1_c`
--
CREATE TABLE `am_projecttemplates_users_1_c` (
`id` varchar(36) NOT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`am_projecttemplates_ida` varchar(36) DEFAULT NULL,
`users_idb` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `am_tasktemplates`
--
CREATE TABLE `am_tasktemplates` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`status` varchar(100) DEFAULT 'Not Started',
`priority` varchar(100) DEFAULT 'High',
`percent_complete` int(255) DEFAULT 0,
`predecessors` int(255) DEFAULT NULL,
`milestone_flag` tinyint(1) DEFAULT 0,
`relationship_type` varchar(100) DEFAULT 'FS',
`task_number` int(255) DEFAULT NULL,
`order_number` int(255) DEFAULT NULL,
`estimated_effort` int(255) DEFAULT NULL,
`utilization` varchar(100) DEFAULT '0',
`duration` int(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `am_tasktemplates_am_projecttemplates_c`
--
CREATE TABLE `am_tasktemplates_am_projecttemplates_c` (
`id` varchar(36) NOT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`am_tasktemplates_am_projecttemplatesam_projecttemplates_ida` varchar(36) DEFAULT NULL,
`am_tasktemplates_am_projecttemplatesam_tasktemplates_idb` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `am_tasktemplates_audit`
--
CREATE TABLE `am_tasktemplates_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aobh_businesshours`
--
CREATE TABLE `aobh_businesshours` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`opening_hours` varchar(100) DEFAULT '1',
`closing_hours` varchar(100) DEFAULT '1',
`open_status` tinyint(1) DEFAULT NULL,
`day` varchar(100) DEFAULT 'monday'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aod_index`
--
CREATE TABLE `aod_index` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`last_optimised` datetime DEFAULT NULL,
`location` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Extraindo dados da tabela `aod_index`
--
INSERT INTO `aod_index` (`id`, `name`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `description`, `deleted`, `assigned_user_id`, `last_optimised`, `location`) VALUES
('1', 'Index', '2025-10-25 14:57:04', '2025-10-25 14:57:04', '1', '1', NULL, 0, NULL, NULL, 'modules/AOD_Index/Index/Index');
-- --------------------------------------------------------
--
-- Estrutura da tabela `aod_indexevent`
--
CREATE TABLE `aod_indexevent` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`error` varchar(255) DEFAULT NULL,
`success` tinyint(1) DEFAULT 0,
`record_id` char(36) DEFAULT NULL,
`record_module` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aod_indexevent_audit`
--
CREATE TABLE `aod_indexevent_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aod_index_audit`
--
CREATE TABLE `aod_index_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aok_knowledgebase`
--
CREATE TABLE `aok_knowledgebase` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`status` varchar(100) DEFAULT 'Draft',
`revision` varchar(255) DEFAULT NULL,
`additional_info` text DEFAULT NULL,
`user_id_c` char(36) DEFAULT NULL,
`user_id1_c` char(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aok_knowledgebase_audit`
--
CREATE TABLE `aok_knowledgebase_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aok_knowledgebase_categories`
--
CREATE TABLE `aok_knowledgebase_categories` (
`id` varchar(36) NOT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`aok_knowledgebase_id` varchar(36) DEFAULT NULL,
`aok_knowledge_base_categories_id` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aok_knowledge_base_categories`
--
CREATE TABLE `aok_knowledge_base_categories` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aok_knowledge_base_categories_audit`
--
CREATE TABLE `aok_knowledge_base_categories_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aop_case_events`
--
CREATE TABLE `aop_case_events` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`case_id` char(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aop_case_events_audit`
--
CREATE TABLE `aop_case_events_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aop_case_updates`
--
CREATE TABLE `aop_case_updates` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`case_id` char(36) DEFAULT NULL,
`contact_id` char(36) DEFAULT NULL,
`internal` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aop_case_updates_audit`
--
CREATE TABLE `aop_case_updates_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aor_charts`
--
CREATE TABLE `aor_charts` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`aor_report_id` char(36) DEFAULT NULL,
`type` varchar(100) DEFAULT NULL,
`x_field` int(11) DEFAULT NULL,
`y_field` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aor_conditions`
--
CREATE TABLE `aor_conditions` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`aor_report_id` char(36) DEFAULT NULL,
`condition_order` int(255) DEFAULT NULL,
`logic_op` varchar(255) DEFAULT NULL,
`parenthesis` varchar(255) DEFAULT NULL,
`module_path` longtext DEFAULT NULL,
`field` varchar(100) DEFAULT NULL,
`operator` varchar(100) DEFAULT NULL,
`value_type` varchar(100) DEFAULT NULL,
`value` varchar(255) DEFAULT NULL,
`parameter` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aor_fields`
--
CREATE TABLE `aor_fields` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`aor_report_id` char(36) DEFAULT NULL,
`field_order` int(255) DEFAULT NULL,
`module_path` longtext DEFAULT NULL,
`field` varchar(100) DEFAULT NULL,
`display` tinyint(1) DEFAULT NULL,
`link` tinyint(1) DEFAULT NULL,
`label` varchar(255) DEFAULT NULL,
`field_function` varchar(100) DEFAULT NULL,
`sort_by` varchar(100) DEFAULT NULL,
`format` varchar(100) DEFAULT NULL,
`total` varchar(100) DEFAULT NULL,
`sort_order` varchar(100) DEFAULT NULL,
`group_by` tinyint(1) DEFAULT NULL,
`group_order` varchar(100) DEFAULT NULL,
`group_display` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aor_reports`
--
CREATE TABLE `aor_reports` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`report_module` varchar(100) DEFAULT NULL,
`graphs_per_row` int(11) DEFAULT 2
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aor_reports_audit`
--
CREATE TABLE `aor_reports_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aor_scheduled_reports`
--
CREATE TABLE `aor_scheduled_reports` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`schedule` varchar(100) DEFAULT NULL,
`last_run` datetime DEFAULT NULL,
`status` varchar(100) DEFAULT NULL,
`email_recipients` longtext DEFAULT NULL,
`aor_report_id` char(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_contracts`
--
CREATE TABLE `aos_contracts` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`reference_code` varchar(255) DEFAULT NULL,
`start_date` date DEFAULT NULL,
`end_date` date DEFAULT NULL,
`total_contract_value` decimal(26,6) DEFAULT NULL,
`total_contract_value_usdollar` decimal(26,6) DEFAULT NULL,
`currency_id` char(36) DEFAULT NULL,
`status` varchar(100) DEFAULT 'Not Started',
`customer_signed_date` date DEFAULT NULL,
`company_signed_date` date DEFAULT NULL,
`renewal_reminder_date` datetime DEFAULT NULL,
`contract_type` varchar(100) DEFAULT 'Type',
`contract_account_id` char(36) DEFAULT NULL,
`opportunity_id` char(36) DEFAULT NULL,
`contact_id` char(36) DEFAULT NULL,
`call_id` char(36) DEFAULT NULL,
`total_amt` decimal(26,6) DEFAULT NULL,
`total_amt_usdollar` decimal(26,6) DEFAULT NULL,
`subtotal_amount` decimal(26,6) DEFAULT NULL,
`subtotal_amount_usdollar` decimal(26,6) DEFAULT NULL,
`discount_amount` decimal(26,6) DEFAULT NULL,
`discount_amount_usdollar` decimal(26,6) DEFAULT NULL,
`tax_amount` decimal(26,6) DEFAULT NULL,
`tax_amount_usdollar` decimal(26,6) DEFAULT NULL,
`shipping_amount` decimal(26,6) DEFAULT NULL,
`shipping_amount_usdollar` decimal(26,6) DEFAULT NULL,
`shipping_tax` varchar(100) DEFAULT NULL,
`shipping_tax_amt` decimal(26,6) DEFAULT NULL,
`shipping_tax_amt_usdollar` decimal(26,6) DEFAULT NULL,
`total_amount` decimal(26,6) DEFAULT NULL,
`total_amount_usdollar` decimal(26,6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_contracts_audit`
--
CREATE TABLE `aos_contracts_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_contracts_documents`
--
CREATE TABLE `aos_contracts_documents` (
`id` varchar(36) NOT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`aos_contracts_id` varchar(36) DEFAULT NULL,
`documents_id` varchar(36) DEFAULT NULL,
`document_revision_id` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_invoices`
--
CREATE TABLE `aos_invoices` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`billing_account_id` char(36) DEFAULT NULL,
`billing_contact_id` char(36) DEFAULT NULL,
`billing_address_street` varchar(150) DEFAULT NULL,
`billing_address_city` varchar(100) DEFAULT NULL,
`billing_address_state` varchar(100) DEFAULT NULL,
`billing_address_postalcode` varchar(20) DEFAULT NULL,
`billing_address_country` varchar(255) DEFAULT NULL,
`shipping_address_street` varchar(150) DEFAULT NULL,
`shipping_address_city` varchar(100) DEFAULT NULL,
`shipping_address_state` varchar(100) DEFAULT NULL,
`shipping_address_postalcode` varchar(20) DEFAULT NULL,
`shipping_address_country` varchar(255) DEFAULT NULL,
`number` int(11) NOT NULL,
`total_amt` decimal(26,6) DEFAULT NULL,
`total_amt_usdollar` decimal(26,6) DEFAULT NULL,
`subtotal_amount` decimal(26,6) DEFAULT NULL,
`subtotal_amount_usdollar` decimal(26,6) DEFAULT NULL,
`discount_amount` decimal(26,6) DEFAULT NULL,
`discount_amount_usdollar` decimal(26,6) DEFAULT NULL,
`tax_amount` decimal(26,6) DEFAULT NULL,
`tax_amount_usdollar` decimal(26,6) DEFAULT NULL,
`shipping_amount` decimal(26,6) DEFAULT NULL,
`shipping_amount_usdollar` decimal(26,6) DEFAULT NULL,
`shipping_tax` varchar(100) DEFAULT NULL,
`shipping_tax_amt` decimal(26,6) DEFAULT NULL,
`shipping_tax_amt_usdollar` decimal(26,6) DEFAULT NULL,
`total_amount` decimal(26,6) DEFAULT NULL,
`total_amount_usdollar` decimal(26,6) DEFAULT NULL,
`currency_id` char(36) DEFAULT NULL,
`quote_number` int(11) DEFAULT NULL,
`quote_date` date DEFAULT NULL,
`invoice_date` date DEFAULT NULL,
`due_date` date DEFAULT NULL,
`status` varchar(100) DEFAULT NULL,
`template_ddown_c` text DEFAULT NULL,
`subtotal_tax_amount` decimal(26,6) DEFAULT NULL,
`subtotal_tax_amount_usdollar` decimal(26,6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_invoices_audit`
--
CREATE TABLE `aos_invoices_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_line_item_groups`
--
CREATE TABLE `aos_line_item_groups` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`total_amt` decimal(26,6) DEFAULT NULL,
`total_amt_usdollar` decimal(26,6) DEFAULT NULL,
`discount_amount` decimal(26,6) DEFAULT NULL,
`discount_amount_usdollar` decimal(26,6) DEFAULT NULL,
`subtotal_amount` decimal(26,6) DEFAULT NULL,
`subtotal_amount_usdollar` decimal(26,6) DEFAULT NULL,
`tax_amount` decimal(26,6) DEFAULT NULL,
`tax_amount_usdollar` decimal(26,6) DEFAULT NULL,
`subtotal_tax_amount` decimal(26,6) DEFAULT NULL,
`subtotal_tax_amount_usdollar` decimal(26,6) DEFAULT NULL,
`total_amount` decimal(26,6) DEFAULT NULL,
`total_amount_usdollar` decimal(26,6) DEFAULT NULL,
`parent_type` varchar(100) DEFAULT NULL,
`parent_id` char(36) DEFAULT NULL,
`number` int(11) DEFAULT NULL,
`currency_id` char(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_line_item_groups_audit`
--
CREATE TABLE `aos_line_item_groups_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_pdf_templates`
--
CREATE TABLE `aos_pdf_templates` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` longtext DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`active` tinyint(1) DEFAULT 1,
`type` varchar(100) DEFAULT NULL,
`pdfheader` longtext DEFAULT NULL,
`pdffooter` longtext DEFAULT NULL,
`margin_left` int(255) DEFAULT 15,
`margin_right` int(255) DEFAULT 15,
`margin_top` int(255) DEFAULT 16,
`margin_bottom` int(255) DEFAULT 16,
`margin_header` int(255) DEFAULT 9,
`margin_footer` int(255) DEFAULT 9,
`page_size` varchar(100) DEFAULT NULL,
`orientation` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_pdf_templates_audit`
--
CREATE TABLE `aos_pdf_templates_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_products`
--
CREATE TABLE `aos_products` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`maincode` varchar(100) DEFAULT 'XXXX',
`part_number` varchar(25) DEFAULT NULL,
`category` varchar(100) DEFAULT NULL,
`type` varchar(100) DEFAULT 'Good',
`cost` decimal(26,6) DEFAULT NULL,
`cost_usdollar` decimal(26,6) DEFAULT NULL,
`currency_id` char(36) DEFAULT NULL,
`price` decimal(26,6) DEFAULT NULL,
`price_usdollar` decimal(26,6) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`contact_id` char(36) DEFAULT NULL,
`product_image` varchar(255) DEFAULT NULL,
`aos_product_category_id` char(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_products_audit`
--
CREATE TABLE `aos_products_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_products_quotes`
--
CREATE TABLE `aos_products_quotes` (
`id` char(36) NOT NULL,
`name` text DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`currency_id` char(36) DEFAULT NULL,
`part_number` varchar(255) DEFAULT NULL,
`item_description` text DEFAULT NULL,
`number` int(11) DEFAULT NULL,
`product_qty` decimal(18,4) DEFAULT NULL,
`product_cost_price` decimal(26,6) DEFAULT NULL,
`product_cost_price_usdollar` decimal(26,6) DEFAULT NULL,
`product_list_price` decimal(26,6) DEFAULT NULL,
`product_list_price_usdollar` decimal(26,6) DEFAULT NULL,
`product_discount` decimal(26,6) DEFAULT NULL,
`product_discount_usdollar` decimal(26,6) DEFAULT NULL,
`product_discount_amount` decimal(26,6) DEFAULT NULL,
`product_discount_amount_usdollar` decimal(26,6) DEFAULT NULL,
`discount` varchar(255) DEFAULT 'Percentage',
`product_unit_price` decimal(26,6) DEFAULT NULL,
`product_unit_price_usdollar` decimal(26,6) DEFAULT NULL,
`vat_amt` decimal(26,6) DEFAULT NULL,
`vat_amt_usdollar` decimal(26,6) DEFAULT NULL,
`product_total_price` decimal(26,6) DEFAULT NULL,
`product_total_price_usdollar` decimal(26,6) DEFAULT NULL,
`vat` varchar(100) DEFAULT '5.0',
`parent_type` varchar(100) DEFAULT NULL,
`parent_id` char(36) DEFAULT NULL,
`product_id` char(36) DEFAULT NULL,
`group_id` char(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_products_quotes_audit`
--
CREATE TABLE `aos_products_quotes_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_product_categories`
--
CREATE TABLE `aos_product_categories` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`is_parent` tinyint(1) DEFAULT 0,
`parent_category_id` char(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_product_categories_audit`
--
CREATE TABLE `aos_product_categories_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_quotes`
--
CREATE TABLE `aos_quotes` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`approval_issue` text DEFAULT NULL,
`billing_account_id` char(36) DEFAULT NULL,
`billing_contact_id` char(36) DEFAULT NULL,
`billing_address_street` varchar(150) DEFAULT NULL,
`billing_address_city` varchar(100) DEFAULT NULL,
`billing_address_state` varchar(100) DEFAULT NULL,
`billing_address_postalcode` varchar(20) DEFAULT NULL,
`billing_address_country` varchar(255) DEFAULT NULL,
`shipping_address_street` varchar(150) DEFAULT NULL,
`shipping_address_city` varchar(100) DEFAULT NULL,
`shipping_address_state` varchar(100) DEFAULT NULL,
`shipping_address_postalcode` varchar(20) DEFAULT NULL,
`shipping_address_country` varchar(255) DEFAULT NULL,
`expiration` date DEFAULT NULL,
`number` int(11) DEFAULT NULL,
`opportunity_id` char(36) DEFAULT NULL,
`template_ddown_c` text DEFAULT NULL,
`total_amt` decimal(26,6) DEFAULT NULL,
`total_amt_usdollar` decimal(26,6) DEFAULT NULL,
`subtotal_amount` decimal(26,6) DEFAULT NULL,
`subtotal_amount_usdollar` decimal(26,6) DEFAULT NULL,
`discount_amount` decimal(26,6) DEFAULT NULL,
`discount_amount_usdollar` decimal(26,6) DEFAULT NULL,
`tax_amount` decimal(26,6) DEFAULT NULL,
`tax_amount_usdollar` decimal(26,6) DEFAULT NULL,
`shipping_amount` decimal(26,6) DEFAULT NULL,
`shipping_amount_usdollar` decimal(26,6) DEFAULT NULL,
`shipping_tax` varchar(100) DEFAULT NULL,
`shipping_tax_amt` decimal(26,6) DEFAULT NULL,
`shipping_tax_amt_usdollar` decimal(26,6) DEFAULT NULL,
`total_amount` decimal(26,6) DEFAULT NULL,
`total_amount_usdollar` decimal(26,6) DEFAULT NULL,
`currency_id` char(36) DEFAULT NULL,
`stage` varchar(100) DEFAULT 'Draft',
`term` varchar(100) DEFAULT NULL,
`terms_c` text DEFAULT NULL,
`approval_status` varchar(100) DEFAULT NULL,
`invoice_status` varchar(100) DEFAULT 'Not Invoiced',
`subtotal_tax_amount` decimal(26,6) DEFAULT NULL,
`subtotal_tax_amount_usdollar` decimal(26,6) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_quotes_aos_invoices_c`
--
CREATE TABLE `aos_quotes_aos_invoices_c` (
`id` varchar(36) NOT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`aos_quotes77d9_quotes_ida` varchar(36) DEFAULT NULL,
`aos_quotes6b83nvoices_idb` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_quotes_audit`
--
CREATE TABLE `aos_quotes_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_quotes_os_contracts_c`
--
CREATE TABLE `aos_quotes_os_contracts_c` (
`id` varchar(36) NOT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`aos_quotese81e_quotes_ida` varchar(36) DEFAULT NULL,
`aos_quotes4dc0ntracts_idb` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aos_quotes_project_c`
--
CREATE TABLE `aos_quotes_project_c` (
`id` varchar(36) NOT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`aos_quotes1112_quotes_ida` varchar(36) DEFAULT NULL,
`aos_quotes7207project_idb` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aow_actions`
--
CREATE TABLE `aow_actions` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`aow_workflow_id` char(36) DEFAULT NULL,
`action_order` int(255) DEFAULT NULL,
`action` varchar(100) DEFAULT NULL,
`parameters` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aow_conditions`
--
CREATE TABLE `aow_conditions` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`aow_workflow_id` char(36) DEFAULT NULL,
`condition_order` int(255) DEFAULT NULL,
`module_path` longtext DEFAULT NULL,
`field` varchar(100) DEFAULT NULL,
`operator` varchar(100) DEFAULT NULL,
`value_type` varchar(255) DEFAULT NULL,
`value` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aow_processed`
--
CREATE TABLE `aow_processed` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`aow_workflow_id` char(36) DEFAULT NULL,
`parent_id` char(36) DEFAULT NULL,
`parent_type` varchar(100) DEFAULT NULL,
`status` varchar(100) DEFAULT 'Pending'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aow_processed_aow_actions`
--
CREATE TABLE `aow_processed_aow_actions` (
`id` varchar(36) NOT NULL,
`aow_processed_id` varchar(36) DEFAULT NULL,
`aow_action_id` varchar(36) DEFAULT NULL,
`status` varchar(36) DEFAULT 'Pending',
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aow_workflow`
--
CREATE TABLE `aow_workflow` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`flow_module` varchar(100) DEFAULT NULL,
`flow_run_on` varchar(100) DEFAULT '0',
`status` varchar(100) DEFAULT 'Active',
`run_when` varchar(100) DEFAULT 'Always',
`multiple_runs` tinyint(1) DEFAULT 0,
`run_on_import` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `aow_workflow_audit`
--
CREATE TABLE `aow_workflow_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `bugs`
--
CREATE TABLE `bugs` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`bug_number` int(11) NOT NULL,
`type` varchar(255) DEFAULT NULL,
`status` varchar(100) DEFAULT NULL,
`priority` varchar(100) DEFAULT NULL,
`resolution` varchar(255) DEFAULT NULL,
`work_log` text DEFAULT NULL,
`found_in_release` varchar(255) DEFAULT NULL,
`fixed_in_release` varchar(255) DEFAULT NULL,
`source` varchar(255) DEFAULT NULL,
`product_category` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `bugs_audit`
--
CREATE TABLE `bugs_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `calls`
--
CREATE TABLE `calls` (
`id` char(36) NOT NULL,
`name` varchar(50) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`duration_hours` int(2) DEFAULT NULL,
`duration_minutes` int(2) DEFAULT NULL,
`date_start` datetime DEFAULT NULL,
`date_end` datetime DEFAULT NULL,
`parent_type` varchar(255) DEFAULT NULL,
`status` varchar(100) DEFAULT 'Planned',
`direction` varchar(100) DEFAULT NULL,
`parent_id` char(36) DEFAULT NULL,
`reminder_time` int(11) DEFAULT -1,
`email_reminder_time` int(11) DEFAULT -1,
`email_reminder_sent` tinyint(1) DEFAULT 0,
`outlook_id` varchar(255) DEFAULT NULL,
`repeat_type` varchar(36) DEFAULT NULL,
`repeat_interval` int(3) DEFAULT 1,
`repeat_dow` varchar(7) DEFAULT NULL,
`repeat_until` date DEFAULT NULL,
`repeat_count` int(7) DEFAULT NULL,
`repeat_parent_id` char(36) DEFAULT NULL,
`recurring_source` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `calls_contacts`
--
CREATE TABLE `calls_contacts` (
`id` varchar(36) NOT NULL,
`call_id` varchar(36) DEFAULT NULL,
`contact_id` varchar(36) DEFAULT NULL,
`required` varchar(1) DEFAULT '1',
`accept_status` varchar(25) DEFAULT 'none',
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `calls_leads`
--
CREATE TABLE `calls_leads` (
`id` varchar(36) NOT NULL,
`call_id` varchar(36) DEFAULT NULL,
`lead_id` varchar(36) DEFAULT NULL,
`required` varchar(1) DEFAULT '1',
`accept_status` varchar(25) DEFAULT 'none',
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `calls_reschedule`
--
CREATE TABLE `calls_reschedule` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`reason` varchar(100) DEFAULT NULL,
`call_id` char(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `calls_reschedule_audit`
--
CREATE TABLE `calls_reschedule_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `calls_users`
--
CREATE TABLE `calls_users` (
`id` varchar(36) NOT NULL,
`call_id` varchar(36) DEFAULT NULL,
`user_id` varchar(36) DEFAULT NULL,
`required` varchar(1) DEFAULT '1',
`accept_status` varchar(25) DEFAULT 'none',
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `campaigns`
--
CREATE TABLE `campaigns` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`tracker_key` int(11) NOT NULL,
`tracker_count` int(11) DEFAULT 0,
`refer_url` varchar(255) DEFAULT 'http://',
`tracker_text` varchar(255) DEFAULT NULL,
`start_date` date DEFAULT NULL,
`end_date` date DEFAULT NULL,
`status` varchar(100) DEFAULT NULL,
`impressions` int(11) DEFAULT 0,
`currency_id` char(36) DEFAULT NULL,
`budget` double DEFAULT NULL,
`expected_cost` double DEFAULT NULL,
`actual_cost` double DEFAULT NULL,
`expected_revenue` double DEFAULT NULL,
`campaign_type` varchar(100) DEFAULT NULL,
`objective` text DEFAULT NULL,
`content` text DEFAULT NULL,
`frequency` varchar(100) DEFAULT NULL,
`survey_id` char(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `campaigns_audit`
--
CREATE TABLE `campaigns_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `campaign_log`
--
CREATE TABLE `campaign_log` (
`id` char(36) NOT NULL,
`campaign_id` char(36) DEFAULT NULL,
`target_tracker_key` varchar(36) DEFAULT NULL,
`target_id` varchar(36) DEFAULT NULL,
`target_type` varchar(100) DEFAULT NULL,
`activity_type` varchar(100) DEFAULT NULL,
`activity_date` datetime DEFAULT NULL,
`related_id` varchar(36) DEFAULT NULL,
`related_type` varchar(100) DEFAULT NULL,
`archived` tinyint(1) DEFAULT 0,
`hits` int(11) DEFAULT 0,
`list_id` char(36) DEFAULT NULL,
`deleted` tinyint(1) DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`more_information` varchar(100) DEFAULT NULL,
`marketing_id` char(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `campaign_trkrs`
--
CREATE TABLE `campaign_trkrs` (
`id` char(36) NOT NULL,
`tracker_name` varchar(255) DEFAULT NULL,
`tracker_url` varchar(255) DEFAULT 'http://',
`tracker_key` int(11) NOT NULL,
`campaign_id` char(36) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`is_optout` tinyint(1) DEFAULT 0,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `cases`
--
CREATE TABLE `cases` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`case_number` int(11) NOT NULL,
`type` varchar(255) DEFAULT NULL,
`status` varchar(100) DEFAULT NULL,
`priority` varchar(100) DEFAULT NULL,
`resolution` text DEFAULT NULL,
`work_log` text DEFAULT NULL,
`account_id` char(36) DEFAULT NULL,
`state` varchar(100) DEFAULT 'Open',
`contact_created_by_id` char(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `cases_audit`
--
CREATE TABLE `cases_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `cases_bugs`
--
CREATE TABLE `cases_bugs` (
`id` varchar(36) NOT NULL,
`case_id` varchar(36) DEFAULT NULL,
`bug_id` varchar(36) DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `cases_cstm`
--
CREATE TABLE `cases_cstm` (
`id_c` char(36) NOT NULL,
`jjwg_maps_lng_c` float(11,8) DEFAULT 0.00000000,
`jjwg_maps_lat_c` float(10,8) DEFAULT 0.00000000,
`jjwg_maps_geocode_status_c` varchar(255) DEFAULT NULL,
`jjwg_maps_address_c` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `config`
--
CREATE TABLE `config` (
`category` varchar(32) DEFAULT NULL,
`name` varchar(32) DEFAULT NULL,
`value` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Extraindo dados da tabela `config`
--
INSERT INTO `config` (`category`, `name`, `value`) VALUES
('notify', 'fromaddress', 'do_not_reply@example.com'),
('notify', 'fromname', 'SuiteCRM'),
('notify', 'send_by_default', '1'),
('notify', 'on', '1'),
('notify', 'send_from_assigning_user', '0'),
('info', 'sugar_version', '6.5.25'),
('MySettings', 'tab', 'YTozMzp7aTowO3M6NDoiSG9tZSI7aToxO3M6ODoiQWNjb3VudHMiO2k6MjtzOjg6IkNvbnRhY3RzIjtpOjM7czoxMzoiT3Bwb3J0dW5pdGllcyI7aTo0O3M6NToiTGVhZHMiO2k6NTtzOjEwOiJBT1NfUXVvdGVzIjtpOjY7czo4OiJDYWxlbmRhciI7aTo3O3M6OToiRG9jdW1lbnRzIjtpOjg7czo2OiJFbWFpbHMiO2k6OTtzOjU6IlNwb3RzIjtpOjEwO3M6OToiQ2FtcGFpZ25zIjtpOjExO3M6NToiQ2FsbHMiO2k6MTI7czo4OiJNZWV0aW5ncyI7aToxMztzOjU6IlRhc2tzIjtpOjE0O3M6NToiTm90ZXMiO2k6MTU7czoxMjoiQU9TX0ludm9pY2VzIjtpOjE2O3M6MTM6IkFPU19Db250cmFjdHMiO2k6MTc7czo1OiJDYXNlcyI7aToxODtzOjk6IlByb3NwZWN0cyI7aToxOTtzOjEzOiJQcm9zcGVjdExpc3RzIjtpOjIwO3M6NzoiUHJvamVjdCI7aToyMTtzOjE5OiJBTV9Qcm9qZWN0VGVtcGxhdGVzIjtpOjIyO3M6MTY6IkFNX1Rhc2tUZW1wbGF0ZXMiO2k6MjM7czo5OiJGUF9ldmVudHMiO2k6MjQ7czoxODoiRlBfRXZlbnRfTG9jYXRpb25zIjtpOjI1O3M6MTI6IkFPU19Qcm9kdWN0cyI7aToyNjtzOjIyOiJBT1NfUHJvZHVjdF9DYXRlZ29yaWVzIjtpOjI3O3M6MTc6IkFPU19QREZfVGVtcGxhdGVzIjtpOjI4O3M6MTE6IkFPUl9SZXBvcnRzIjtpOjI5O3M6MTc6IkFPS19Lbm93bGVkZ2VCYXNlIjtpOjMwO3M6Mjk6IkFPS19Lbm93bGVkZ2VfQmFzZV9DYXRlZ29yaWVzIjtpOjMxO3M6MTQ6IkVtYWlsVGVtcGxhdGVzIjtpOjMyO3M6NzoiU3VydmV5cyI7fQ=='),
('portal', 'on', '0'),
('tracker', 'Tracker', '1'),
('sugarfeed', 'enabled', '1'),
('sugarfeed', 'module_UserFeed', '1'),
('sugarfeed', 'module_Cases', '1'),
('sugarfeed', 'module_Contacts', '1'),
('sugarfeed', 'module_Leads', '1'),
('sugarfeed', 'module_Opportunities', '1'),
('Update', 'CheckUpdates', 'manual'),
('system', 'name', 'SuiteCRM'),
('system', 'adminwizard', '1');
-- --------------------------------------------------------
--
-- Estrutura da tabela `contacts`
--
CREATE TABLE `contacts` (
`id` char(36) NOT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`salutation` varchar(255) DEFAULT NULL,
`first_name` varchar(100) DEFAULT NULL,
`last_name` varchar(100) DEFAULT NULL,
`title` varchar(100) DEFAULT NULL,
`photo` varchar(255) DEFAULT NULL,
`department` varchar(255) DEFAULT NULL,
`do_not_call` tinyint(1) DEFAULT 0,
`phone_home` varchar(100) DEFAULT NULL,
`phone_mobile` varchar(100) DEFAULT NULL,
`phone_work` varchar(100) DEFAULT NULL,
`phone_other` varchar(100) DEFAULT NULL,
`phone_fax` varchar(100) DEFAULT NULL,
`lawful_basis` text DEFAULT NULL,
`date_reviewed` date DEFAULT NULL,
`lawful_basis_source` varchar(100) DEFAULT NULL,
`primary_address_street` varchar(150) DEFAULT NULL,
`primary_address_city` varchar(100) DEFAULT NULL,
`primary_address_state` varchar(100) DEFAULT NULL,
`primary_address_postalcode` varchar(20) DEFAULT NULL,
`primary_address_country` varchar(255) DEFAULT NULL,
`alt_address_street` varchar(150) DEFAULT NULL,
`alt_address_city` varchar(100) DEFAULT NULL,
`alt_address_state` varchar(100) DEFAULT NULL,
`alt_address_postalcode` varchar(20) DEFAULT NULL,
`alt_address_country` varchar(255) DEFAULT NULL,
`assistant` varchar(75) DEFAULT NULL,
`assistant_phone` varchar(100) DEFAULT NULL,
`lead_source` varchar(255) DEFAULT NULL,
`reports_to_id` char(36) DEFAULT NULL,
`birthdate` date DEFAULT NULL,
`campaign_id` char(36) DEFAULT NULL,
`joomla_account_id` varchar(255) DEFAULT NULL,
`portal_account_disabled` tinyint(1) DEFAULT NULL,
`portal_user_type` varchar(100) DEFAULT 'Single'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `contacts_audit`
--
CREATE TABLE `contacts_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `contacts_bugs`
--
CREATE TABLE `contacts_bugs` (
`id` varchar(36) NOT NULL,
`contact_id` varchar(36) DEFAULT NULL,
`bug_id` varchar(36) DEFAULT NULL,
`contact_role` varchar(50) DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `contacts_cases`
--
CREATE TABLE `contacts_cases` (
`id` varchar(36) NOT NULL,
`contact_id` varchar(36) DEFAULT NULL,
`case_id` varchar(36) DEFAULT NULL,
`contact_role` varchar(50) DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `contacts_cstm`
--
CREATE TABLE `contacts_cstm` (
`id_c` char(36) NOT NULL,
`jjwg_maps_lng_c` float(11,8) DEFAULT 0.00000000,
`jjwg_maps_lat_c` float(10,8) DEFAULT 0.00000000,
`jjwg_maps_geocode_status_c` varchar(255) DEFAULT NULL,
`jjwg_maps_address_c` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `contacts_users`
--
CREATE TABLE `contacts_users` (
`id` varchar(36) NOT NULL,
`contact_id` varchar(36) DEFAULT NULL,
`user_id` varchar(36) DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `cron_remove_documents`
--
CREATE TABLE `cron_remove_documents` (
`id` varchar(36) NOT NULL,
`bean_id` varchar(36) DEFAULT NULL,
`module` varchar(25) DEFAULT NULL,
`date_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `currencies`
--
CREATE TABLE `currencies` (
`id` char(36) NOT NULL,
`name` varchar(36) DEFAULT NULL,
`symbol` varchar(36) DEFAULT NULL,
`iso4217` varchar(3) DEFAULT NULL,
`conversion_rate` double DEFAULT 0,
`status` varchar(100) DEFAULT NULL,
`deleted` tinyint(1) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`created_by` char(36) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Extraindo dados da tabela `currencies`
--
INSERT INTO `currencies` (`id`, `name`, `symbol`, `iso4217`, `conversion_rate`, `status`, `deleted`, `date_entered`, `date_modified`, `created_by`) VALUES
('ef0a3270-8f39-472a-b752-6905eb9c0382', 'US Dollar', 'USD', 'USD', 1, 'Active', 0, '2025-11-01 11:12:15', '2025-11-01 11:12:15', '1'),
('ef3eec1e-f4ae-8888-b95c-6905eb8e0848', 'Euro', '€', 'EUR', 1, 'Active', 0, '2025-11-01 11:12:46', '2025-11-01 11:12:46', '1');
-- --------------------------------------------------------
--
-- Estrutura da tabela `custom_fields`
--
CREATE TABLE `custom_fields` (
`bean_id` varchar(36) DEFAULT NULL,
`set_num` int(11) DEFAULT 0,
`field0` varchar(255) DEFAULT NULL,
`field1` varchar(255) DEFAULT NULL,
`field2` varchar(255) DEFAULT NULL,
`field3` varchar(255) DEFAULT NULL,
`field4` varchar(255) DEFAULT NULL,
`field5` varchar(255) DEFAULT NULL,
`field6` varchar(255) DEFAULT NULL,
`field7` varchar(255) DEFAULT NULL,
`field8` varchar(255) DEFAULT NULL,
`field9` varchar(255) DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `documents`
--
CREATE TABLE `documents` (
`id` char(36) NOT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`document_name` varchar(255) DEFAULT NULL,
`doc_id` varchar(100) DEFAULT NULL,
`doc_type` varchar(100) DEFAULT 'Sugar',
`doc_url` varchar(255) DEFAULT NULL,
`active_date` date DEFAULT NULL,
`exp_date` date DEFAULT NULL,
`category_id` varchar(100) DEFAULT NULL,
`subcategory_id` varchar(100) DEFAULT NULL,
`status_id` varchar(100) DEFAULT NULL,
`document_revision_id` varchar(36) DEFAULT NULL,
`related_doc_id` char(36) DEFAULT NULL,
`related_doc_rev_id` char(36) DEFAULT NULL,
`is_template` tinyint(1) DEFAULT 0,
`template_type` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `documents_accounts`
--
CREATE TABLE `documents_accounts` (
`id` varchar(36) NOT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`document_id` varchar(36) DEFAULT NULL,
`account_id` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `documents_bugs`
--
CREATE TABLE `documents_bugs` (
`id` varchar(36) NOT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`document_id` varchar(36) DEFAULT NULL,
`bug_id` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `documents_cases`
--
CREATE TABLE `documents_cases` (
`id` varchar(36) NOT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`document_id` varchar(36) DEFAULT NULL,
`case_id` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `documents_contacts`
--
CREATE TABLE `documents_contacts` (
`id` varchar(36) NOT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`document_id` varchar(36) DEFAULT NULL,
`contact_id` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `documents_opportunities`
--
CREATE TABLE `documents_opportunities` (
`id` varchar(36) NOT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`document_id` varchar(36) DEFAULT NULL,
`opportunity_id` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `document_revisions`
--
CREATE TABLE `document_revisions` (
`id` varchar(36) NOT NULL,
`change_log` varchar(255) DEFAULT NULL,
`document_id` varchar(36) DEFAULT NULL,
`doc_id` varchar(100) DEFAULT NULL,
`doc_type` varchar(100) DEFAULT NULL,
`doc_url` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`filename` varchar(255) DEFAULT NULL,
`file_ext` varchar(100) DEFAULT NULL,
`file_mime_type` varchar(100) DEFAULT NULL,
`revision` varchar(100) DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`date_modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `eapm`
--
CREATE TABLE `eapm` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`description` text DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`url` varchar(255) DEFAULT NULL,
`application` varchar(100) DEFAULT 'webex',
`api_data` text DEFAULT NULL,
`consumer_key` varchar(255) DEFAULT NULL,
`consumer_secret` varchar(255) DEFAULT NULL,
`oauth_token` varchar(255) DEFAULT NULL,
`oauth_secret` varchar(255) DEFAULT NULL,
`validated` tinyint(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `emailman`
--
CREATE TABLE `emailman` (
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`user_id` char(36) DEFAULT NULL,
`id` int(11) NOT NULL,
`campaign_id` char(36) DEFAULT NULL,
`marketing_id` char(36) DEFAULT NULL,
`list_id` char(36) DEFAULT NULL,
`send_date_time` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`in_queue` tinyint(1) DEFAULT 0,
`in_queue_date` datetime DEFAULT NULL,
`send_attempts` int(11) DEFAULT 0,
`deleted` tinyint(1) DEFAULT 0,
`related_id` char(36) DEFAULT NULL,
`related_type` varchar(100) DEFAULT NULL,
`related_confirm_opt_in` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `emails`
--
CREATE TABLE `emails` (
`id` char(36) NOT NULL,
`name` varchar(255) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0,
`assigned_user_id` char(36) DEFAULT NULL,
`orphaned` tinyint(1) DEFAULT NULL,
`last_synced` datetime DEFAULT NULL,
`date_sent_received` datetime DEFAULT NULL,
`message_id` varchar(255) DEFAULT NULL,
`type` varchar(100) DEFAULT NULL,
`status` varchar(100) DEFAULT NULL,
`flagged` tinyint(1) DEFAULT NULL,
`reply_to_status` tinyint(1) DEFAULT NULL,
`intent` varchar(100) DEFAULT 'pick',
`mailbox_id` char(36) DEFAULT NULL,
`parent_type` varchar(100) DEFAULT NULL,
`parent_id` char(36) DEFAULT NULL,
`uid` varchar(255) DEFAULT NULL,
`category_id` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `emails_beans`
--
CREATE TABLE `emails_beans` (
`id` char(36) NOT NULL,
`email_id` char(36) DEFAULT NULL,
`bean_id` char(36) DEFAULT NULL,
`bean_module` varchar(100) DEFAULT NULL,
`campaign_data` text DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `emails_email_addr_rel`
--
CREATE TABLE `emails_email_addr_rel` (
`id` char(36) NOT NULL,
`email_id` char(36) NOT NULL,
`address_type` varchar(4) DEFAULT NULL,
`email_address_id` char(36) NOT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `emails_text`
--
CREATE TABLE `emails_text` (
`email_id` char(36) NOT NULL,
`from_addr` varchar(255) DEFAULT NULL,
`reply_to_addr` varchar(255) DEFAULT NULL,
`to_addrs` text DEFAULT NULL,
`cc_addrs` text DEFAULT NULL,
`bcc_addrs` text DEFAULT NULL,
`description` longtext DEFAULT NULL,
`description_html` longtext DEFAULT NULL,
`raw_source` longtext DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `email_addresses`
--
CREATE TABLE `email_addresses` (
`id` char(36) NOT NULL,
`email_address` varchar(255) DEFAULT NULL,
`email_address_caps` varchar(255) DEFAULT NULL,
`invalid_email` tinyint(1) DEFAULT 0,
`opt_out` tinyint(1) DEFAULT 0,
`confirm_opt_in` varchar(255) DEFAULT 'not-opt-in',
`confirm_opt_in_date` datetime DEFAULT NULL,
`confirm_opt_in_sent_date` datetime DEFAULT NULL,
`confirm_opt_in_fail_date` datetime DEFAULT NULL,
`confirm_opt_in_token` varchar(255) DEFAULT NULL,
`date_created` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `email_addresses_audit`
--
CREATE TABLE `email_addresses_audit` (
`id` char(36) NOT NULL,
`parent_id` char(36) NOT NULL,
`date_created` datetime DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`field_name` varchar(100) DEFAULT NULL,
`data_type` varchar(100) DEFAULT NULL,
`before_value_string` varchar(255) DEFAULT NULL,
`after_value_string` varchar(255) DEFAULT NULL,
`before_value_text` text DEFAULT NULL,
`after_value_text` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `email_addr_bean_rel`
--
CREATE TABLE `email_addr_bean_rel` (
`id` char(36) NOT NULL,
`email_address_id` char(36) NOT NULL,
`bean_id` char(36) NOT NULL,
`bean_module` varchar(100) DEFAULT NULL,
`primary_address` tinyint(1) DEFAULT 0,
`reply_to_address` tinyint(1) DEFAULT 0,
`date_created` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `email_cache`
--
CREATE TABLE `email_cache` (
`ie_id` char(36) DEFAULT NULL,
`mbox` varchar(60) DEFAULT NULL,
`subject` varchar(255) DEFAULT NULL,
`fromaddr` varchar(100) DEFAULT NULL,
`toaddr` varchar(255) DEFAULT NULL,
`senddate` datetime DEFAULT NULL,
`message_id` varchar(255) DEFAULT NULL,
`mailsize` int(10) UNSIGNED DEFAULT NULL,
`imap_uid` int(10) UNSIGNED DEFAULT NULL,
`msgno` int(10) UNSIGNED DEFAULT NULL,
`recent` tinyint(4) DEFAULT NULL,
`flagged` tinyint(4) DEFAULT NULL,
`answered` tinyint(4) DEFAULT NULL,
`deleted` tinyint(4) DEFAULT NULL,
`seen` tinyint(4) DEFAULT NULL,
`draft` tinyint(4) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `email_marketing`
--
CREATE TABLE `email_marketing` (
`id` char(36) NOT NULL,
`deleted` tinyint(1) DEFAULT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` char(36) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`from_name` varchar(100) DEFAULT NULL,
`from_addr` varchar(100) DEFAULT NULL,
`reply_to_name` varchar(100) DEFAULT NULL,
`reply_to_addr` varchar(100) DEFAULT NULL,
`inbound_email_id` varchar(36) DEFAULT NULL,
`date_start` datetime DEFAULT NULL,
`template_id` char(36) NOT NULL,
`status` varchar(100) DEFAULT NULL,
`campaign_id` char(36) DEFAULT NULL,
`outbound_email_id` char(36) DEFAULT NULL,
`all_prospect_lists` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `email_marketing_prospect_lists`
--
CREATE TABLE `email_marketing_prospect_lists` (
`id` varchar(36) NOT NULL,
`prospect_list_id` varchar(36) DEFAULT NULL,
`email_marketing_id` varchar(36) DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`deleted` tinyint(1) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
-- --------------------------------------------------------
--
-- Estrutura da tabela `email_templates`
--
CREATE TABLE `email_templates` (
`id` char(36) NOT NULL,
`date_entered` datetime DEFAULT NULL,
`date_modified` datetime DEFAULT NULL,
`modified_user_id` char(36) DEFAULT NULL,
`created_by` varchar(36) DEFAULT NULL,
`published` varchar(3) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`description` text DEFAULT NULL,
`subject` varchar(255) DEFAULT NULL,
`body` longtext DEFAULT NULL,
`body_html` longtext DEFAULT NULL,
`deleted` tinyint(1) DEFAULT NULL,
`assigned_user_id` char(36) DEFAULT NULL,
`text_only` tinyint(1) DEFAULT NULL,
`type` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Extraindo dados da tabela `email_templates`
--
INSERT INTO `email_templates` (`id`, `date_entered`, `date_modified`, `modified_user_id`, `created_by`, `published`, `name`, `description`, `subject`, `body`, `body_html`, `deleted`, `assigned_user_id`, `text_only`, `type`) VALUES
('10bc02de-a5b0-38d6-aadf-68fce5a8e06c', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '1', 'off', 'Forgot Password email', 'This template is used to send a user a link to click to reset the user\'s account password.', 'Reset your account password', '\r\nYou recently requested on $contact_user_pwd_last_changed to be able to reset your account password.\r\n\r\nClick on the link below to reset your password:\r\n\r\n$contact_user_link_guid', 'You recently requested on $contact_user_pwd_last_changed to be able to reset your account password. Click on the link below to reset your password: $contact_user_link_guid |
|
Two Factor Authentication code is $code. |
|
Hi $contact_first_name $contact_last_name,
\r\n \r\n Please confirm that you have opted in by selecting the following link:\r\n Opt In\r\n
', 0, NULL, NULL, 'system'),
('6038515d-d8b5-147f-be63-68fce59be5c5', '2013-05-24 14:31:45', '2025-10-25 14:55:36', '1', '1', 'off', 'Event Invite Template', 'Default event invite template.', 'You have been invited to $fp_events_name', 'Dear $contact_name,\r\nYou have been invited to $fp_events_name on $fp_events_date_start to $fp_events_date_end\r\n$fp_events_description\r\nYours Sincerely,\r\n', '\r\nDear $contact_name,
\r\nYou have been invited to $fp_events_name on $fp_events_date_start to $fp_events_date_end
\r\n$fp_events_description
\r\nIf you would like to accept this invititation please click accept.
\r\n $fp_events_link or $fp_events_link_declined
\r\nYours Sincerely,
\r\n', 0, NULL, NULL, 'system'),
('71fb0854-80e4-d936-c7a0-68fce523b17e', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '1', 'off', 'Contact Case Update', 'Template to send to a contact when their case is updated.', '$acase_name update [CASE:$acase_case_number]', 'Hi $user_first_name $user_last_name,\r\n\r\n You\'ve had an update to your case $acase_name (# $acase_case_number) on $aop_case_updates_date_entered:\r\n $contact_first_name $contact_last_name, said:\r\n $aop_case_updates_description', 'Hi $contact_first_name $contact_last_name,
\r\n
\r\n You\'ve had an update to your case $acase_name (# $acase_case_number) on $aop_case_updates_date_entered:
\r\n $user_first_name $user_last_name said:
\r\n $aop_case_updates_description
', 0, NULL, NULL, 'system'),
('793c2fbd-0222-f318-9bef-68fce5099260', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '1', 'off', 'Case Closure', 'Template for informing a contact that their case has been closed.', '$acase_name [CASE:$acase_case_number] closed', 'Hi $contact_first_name $contact_last_name,\r\n\r\n Your case $acase_name (# $acase_case_number) has been closed on $acase_date_entered\r\n Status: $acase_status\r\n Reference: $acase_case_number\r\n Resolution: $acase_resolution', ' Hi $contact_first_name $contact_last_name,
\r\n Your case $acase_name (# $acase_case_number) has been closed on $acase_date_entered
\r\n \r\n | Status | $acase_status |
\r\n | Reference | $acase_case_number |
\r\n | Resolution | $acase_resolution |
\r\n
', 0, NULL, NULL, 'system'),
('817fb5a6-f5e9-f9ae-db5b-68fce51e75f6', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '1', 'off', 'Joomla Account Creation', 'Template used when informing a contact that they\'ve been given an account on the joomla portal.', 'Support Portal Account Created', 'Hi $contact_name,\r\n An account has been created for you at $portal_address.\r\n You may login using this email address and the password $joomla_pass', 'Hi $contact_name,
\r\n An account has been created for you at $portal_address.
\r\n You may login using this email address and the password $joomla_pass
', 0, NULL, NULL, 'system'),
('8446cc1e-2fb5-37f4-d90a-68fce55ce6c7', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '1', 'off', 'Case Creation', 'Template to send to a contact when a case is received from them.', '$acase_name [CASE:$acase_case_number]', 'Hi $contact_first_name $contact_last_name,\r\n\r\n We\'ve received your case $acase_name (# $acase_case_number) on $acase_date_entered\r\n Status: $acase_status\r\n Reference: $acase_case_number\r\n Description: $acase_description', ' Hi $contact_first_name $contact_last_name,
\r\n We\'ve received your case $acase_name (# $acase_case_number) on $acase_date_entered
\r\n \r\n | Status | $acase_status |
\r\n | Reference | $acase_case_number |
\r\n | Description | $acase_description |
\r\n
', 0, NULL, NULL, 'system'),
('a0460d6d-4eb8-5f50-9c33-68fce5f5ff33', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '1', 'off', 'User Case Update', 'Email template to send to a SuiteCRM user when their case is updated.', '$acase_name (# $acase_case_number) update', 'Hi $user_first_name $user_last_name,\r\n\r\n You\'ve had an update to your case $acase_name (# $acase_case_number) on $aop_case_updates_date_entered:\r\n $contact_first_name $contact_last_name, said:\r\n $aop_case_updates_description\r\n You may review this Case at:\r\n $sugarurl/index.php?module=Cases&action=DetailView&record=$acase_id;', 'Hi $user_first_name $user_last_name,
\r\n
\r\n You\'ve had an update to your case $acase_name (# $acase_case_number) on $aop_case_updates_date_entered:
\r\n $contact_first_name $contact_last_name, said:
\r\n $aop_case_updates_description
\r\n You may review this Case at: $sugarurl/index.php?module=Cases&action=DetailView&record=$acase_id;
', 0, NULL, NULL, 'system'),
('d1e707b8-dfe1-4bd1-a7cc-68fce5f63bd0', '2025-10-25 14:55:36', '2025-10-25 14:55:36', '1', '1', 'off', 'System-generated password email', 'This template is used when the System Administrator sends a new password to a user.', 'New account information', '\r\nHere is your account username and temporary password:\r\nUsername : $contact_user_user_name\r\nPassword : $contact_user_user_hash\r\n\r\n$config_site_url\r\n\r\nAfter you log in using the above password, you may be required to reset the password to one of your own choice.', 'Here is your account username and temporary password: Username : $contact_user_user_name Password : $contact_user_user_hash
$config_site_url
After you log in using the above password, you may be required to reset the password to one of your own choice. |
|