-- phpMyAdmin SQL Dump
-- version 4.8.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Aug 11, 2018 at 09:29 PM
-- Server version: 10.1.34-MariaDB
-- PHP Version: 7.0.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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 */;

--
-- Database: `goautodial`
--

-- --------------------------------------------------------

--
-- Table structure for table `attachments`
--

DROP TABLE IF EXISTS `attachments`; CREATE TABLE `attachments` (
  `id` int(11) NOT NULL,
  `message_id` int(11) NOT NULL,
  `folder_id` int(11) NOT NULL,
  `filepath` varchar(255) NOT NULL,
  `filetype` varchar(255) NOT NULL,
  `filesize` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `clients_1`
--

DROP TABLE IF EXISTS `clients_1`; CREATE TABLE `clients_1` (
  `id` int(11) NOT NULL,
  `company` int(1) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `id_number` varchar(255) DEFAULT NULL,
  `address` text,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zip_code` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `phone` text,
  `mobile` text,
  `email` varchar(255) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `type` text,
  `website` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `notes` text,
  `birthdate` datetime DEFAULT NULL,
  `marital_status` int(11) DEFAULT NULL,
  `creation_date` datetime DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `do_not_send_email` char(1) DEFAULT NULL,
  `gender` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `clients_2`
--

DROP TABLE IF EXISTS `clients_2`; CREATE TABLE `clients_2` (
  `id` int(11) NOT NULL,
  `company` int(1) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL,
  `id_number` varchar(255) DEFAULT NULL,
  `address` text,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `zip_code` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `phone` text,
  `mobile` text,
  `email` varchar(255) DEFAULT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `type` text,
  `website` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `notes` text,
  `birthdate` datetime DEFAULT NULL,
  `marital_status` int(11) DEFAULT NULL,
  `creation_date` datetime DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `do_not_send_email` char(1) DEFAULT NULL,
  `gender` int(1) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `customer_types`
--

DROP TABLE IF EXISTS `customer_types`; CREATE TABLE `customer_types` (
  `id` int(11) NOT NULL,
  `table_name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `events`
--

DROP TABLE IF EXISTS `events`; CREATE TABLE `events` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `title` varchar(512) NOT NULL,
  `all_day` int(1) NOT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `url` varchar(512) DEFAULT NULL,
  `alarm` varchar(80) DEFAULT NULL,
  `notification_sent` int(1) NOT NULL DEFAULT '0',
  `color` varchar(80) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `go_action_logs`
--

DROP TABLE IF EXISTS `go_action_logs`; CREATE TABLE `go_action_logs` (
  `id` int(11) NOT NULL,
  `user` varchar(50) NOT NULL,
  `ip_address` varchar(16) NOT NULL,
  `event_date` datetime NOT NULL,
  `action` varchar(50) NOT NULL,
  `details` text COLLATE utf8_unicode_ci,
  `db_query` text COLLATE utf8_unicode_ci,
  `user_group` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `go_agent_sessions`
--

DROP TABLE IF EXISTS `go_agent_sessions`; CREATE TABLE `go_agent_sessions` (
  `agent_session_id` int(11) NOT NULL,
  `sess_agent_user` varchar(25) NOT NULL,
  `sess_agent_phone` varchar(25) NOT NULL,
  `sess_agent_status` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `go_avatars`
--

DROP TABLE IF EXISTS `go_avatars`; CREATE TABLE `go_avatars` (
  `user_id` int(9) UNSIGNED NOT NULL,
  `type` varchar(30) NOT NULL,
  `data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `go_callback_lists`
--

DROP TABLE IF EXISTS `go_callback_lists`; CREATE TABLE `go_callback_lists` (
  `id` int(11) NOT NULL,
  `callback_id` int(9) UNSIGNED NOT NULL,
  `callback_time` datetime NOT NULL,
  `seen` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `go_campaigns`
--

DROP TABLE IF EXISTS `go_campaigns`; CREATE TABLE `go_campaigns` (
  `id` int(11) NOT NULL,
  `campaign_id` varchar(255) DEFAULT NULL,
  `campaign_type` varchar(255) DEFAULT NULL,
  `custom_fields_launch` enum('ONCALL','LOGIN') DEFAULT 'ONCALL',
  `custom_fields_list_id` bigint(14) DEFAULT NULL,
  `url_tab_first_title` varchar(50) DEFAULT NULL,
  `url_tab_first_url` text,
  `url_tab_second_title` varchar(50) DEFAULT NULL,
  `url_tab_second_url` text,
  `enable_callback_alert` tinyint(1) DEFAULT '0',
  `cb_noexpire` tinyint(1) DEFAULT '0',
  `cb_sendemail` tinyint(1) DEFAULT '0',
  `google_sheet_ids` text,
  `google_sheet_list_id` bigint(14) UNSIGNED DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `go_customers`
--

DROP TABLE IF EXISTS `go_customers`; CREATE TABLE `go_customers` (
  `cust_id` int(9) UNSIGNED NOT NULL,
  `lead_id` int(9) UNSIGNED NOT NULL,
  `group_list_id` bigint(14) UNSIGNED NOT NULL,
  `avatar` longtext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `go_dropbox`
--

DROP TABLE IF EXISTS `go_dropbox`; CREATE TABLE `go_dropbox` (
  `dropID` int(10) NOT NULL,
  `app_key` varchar(50) NOT NULL,
  `userID` varchar(25) NOT NULL,
  `dropbox_status` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `go_firewall_blocklist`
--

DROP TABLE IF EXISTS `go_firewall_blocklist`; CREATE TABLE `go_firewall_blocklist` (
  `block_id` int(20) UNSIGNED NOT NULL,
  `command` enum('-A','-I') DEFAULT '-I',
  `type` enum('INPUT','OUTPUT','FORWARD') DEFAULT 'INPUT',
  `source` varchar(200) DEFAULT NULL,
  `target` enum('DROP','REJECT') DEFAULT 'DROP',
  `active` enum('N','Y') DEFAULT 'N'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `go_firewall_interfaces`
--

DROP TABLE IF EXISTS `go_firewall_interfaces`; CREATE TABLE `go_firewall_interfaces` (
  `interface_id` int(20) UNSIGNED NOT NULL,
  `interface` varchar(50) NOT NULL,
  `command` enum('-A','-I') DEFAULT '-I',
  `type` enum('INPUT','OUTPUT','FORWARD') DEFAULT 'INPUT',
  `target` enum('ACCEPT','DROP','LOG','REJECT','DNAT','SNAT','MASQUERADE') DEFAULT 'ACCEPT',
  `active` enum('N','Y') DEFAULT 'N'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `go_firewall_rules`
--

DROP TABLE IF EXISTS `go_firewall_rules`; CREATE TABLE `go_firewall_rules` (
  `rule_id` int(20) UNSIGNED NOT NULL,
  `rule_number` varchar(20) NOT NULL,
  `command` enum('-A','-I') DEFAULT '-I',
  `type` enum('INPUT','OUTPUT','FORWARD') DEFAULT 'INPUT',
  `state` varchar(255) DEFAULT NULL,
  `protocol` enum('icmp','tcp','udp','all') DEFAULT 'all',
  `match_protocol` enum('N','Y') DEFAULT 'N',
  `source` varchar(200) NOT NULL DEFAULT '0.0.0.0/0',
  `destination` varchar(200) NOT NULL DEFAULT '0.0.0.0/0',
  `port_from` varchar(200) DEFAULT NULL,
  `port_to` varchar(200) DEFAULT NULL,
  `target` enum('ACCEPT','DROP','LOG','REJECT','DNAT','SNAT','MASQUERADE') DEFAULT 'ACCEPT',
  `active` enum('N','Y') DEFAULT 'N'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `go_firewall_whitelist`
--

DROP TABLE IF EXISTS `go_firewall_whitelist`; CREATE TABLE `go_firewall_whitelist` (
  `white_id` int(20) NOT NULL,
  `command` enum('-A','-I') DEFAULT '-I',
  `type` enum('INPUT','OUTPUT','FORWARD') DEFAULT 'INPUT',
  `source` varchar(200) DEFAULT NULL,
  `target` enum('ACCEPT') DEFAULT 'ACCEPT',
  `active` enum('Y','N') DEFAULT 'N',
  `description` varchar(150) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `go_language`
--

DROP TABLE IF EXISTS `go_language`; CREATE TABLE `go_language` (
  `id` int(6) UNSIGNED NOT NULL,
  `lang` varchar(10) NOT NULL,
  `name` varchar(100) NOT NULL,
  `path` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `go_last_login`
--

DROP TABLE IF EXISTS `go_last_login`; CREATE TABLE `go_last_login` (
  `account_num` varchar(50) NOT NULL,
  `event_time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `go_license`
--

DROP TABLE IF EXISTS `go_license`; CREATE TABLE `go_license` (
  `id` int(11) NOT NULL,
  `expiration_date` varchar(255) DEFAULT NULL,
  `extent_limit` varchar(255) DEFAULT NULL,
  `licensekey` char(255) DEFAULT NULL,
  `VARMULTITENANT` char(255) DEFAULT NULL,
  `VARSERVTYPE` char(255) DEFAULT NULL,
  `VAREXTENLIMIT` char(255) DEFAULT NULL,
  `VARSYSTEMEXTENLIMIT` char(255) DEFAULT NULL,
  `VARREMOTEFTP` char(255) DEFAULT NULL,
  `VARREMOTEFTPURL` char(255) DEFAULT NULL,
  `VARBRINGOWNVOIP` char(255) DEFAULT NULL,
  `go_licensepacakges_id` char(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `go_licensepackages`
--

DROP TABLE IF EXISTS `go_licensepackages`; CREATE TABLE `go_licensepackages` (
  `goLicensepackages_id` int(11) NOT NULL,
  `goLicensepackage_description` varchar(255) DEFAULT NULL,
  `goLicensepackage_page_access` varchar(400) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `go_license_sippy_conf`
--

DROP TABLE IF EXISTS `go_license_sippy_conf`; CREATE TABLE `go_license_sippy_conf` (
  `id` int(11) NOT NULL,
  `VARCOMPANYGOLOGOICO` varchar(255) DEFAULT NULL,
  `VARCOMPANYTHEMECOLOR` varchar(255) DEFAULT NULL,
  `VARCOMPANYSUBTHEMECOLOR` varchar(255) DEFAULT NULL,
  `VARCOMPANYSUBHOVERTHEMECOLOR` varchar(255) DEFAULT NULL,
  `VARCOMPANYLOGO` varchar(255) DEFAULT NULL,
  `VARCOMPANYTITLE` varchar(255) DEFAULT NULL,
  `VARSHOWSIGNUP` varchar(255) DEFAULT NULL,
  `VARSHOWFORGOTPASS` varchar(255) DEFAULT NULL,
  `VARTOSURL` varchar(400) DEFAULT NULL,
  `VARPRIVACYURL` varchar(400) DEFAULT NULL,
  `VARLOGINLOGO` varchar(255) DEFAULT NULL,
  `VARADMINLOGINBUTTON` varchar(255) DEFAULT NULL,
  `VARADMINSENDBUTTON` varchar(255) DEFAULT NULL,
  `VARGUIDELINK` varchar(400) DEFAULT NULL,
  `VARRSSNEWSFEED` varchar(400) DEFAULT NULL,
  `VARRSSBOARDS` varchar(400) DEFAULT NULL,
  `VARLINKFACEBOOK` varchar(400) DEFAULT NULL,
  `VARLINKTWITTER` varchar(400) DEFAULT NULL,
  `VARLINKGOAUTODIAL` varchar(400) DEFAULT NULL,
  `VARLINKENABLE` varchar(255) DEFAULT NULL,
  `VARCLOUDCOMPANY` varchar(255) DEFAULT NULL,
  `VARCOMPANYSEC` varchar(255) DEFAULT NULL,
  `VARCOMPANYNAME` varchar(255) DEFAULT NULL,
  `VARCLOUDURL` varchar(400) DEFAULT NULL,
  `VARJUSTGOVOIP` varchar(255) DEFAULT NULL,
  `VARSIPPYACCOUNTSURL` varchar(600) DEFAULT NULL,
  `VARSIPPYPASSRECOVERYSUPPORTEMAIL` varchar(400) DEFAULT NULL,
  `VARCLOUDSUPPORTURL` varchar(600) DEFAULT NULL,
  `VARCLOUDSALESEMAIL` varchar(400) DEFAULT NULL,
  `VARCLOUDVIOLATEEMAIL` varchar(400) DEFAULT NULL,
  `VARCLOUDNOREPLYEMAIL` varchar(400) DEFAULT NULL,
  `VARCLOUDSUPPORTEMAIL` varchar(400) DEFAULT NULL,
  `VARSIGNUPEMAILCONFIRMBODY` varchar(600) DEFAULT NULL,
  `VARAUTHREMOTEIP` varchar(255) DEFAULT NULL,
  `VARACCOUNTFORMAT` varchar(600) DEFAULT NULL,
  `VARCOMMISSIONAGENT` varchar(255) DEFAULT NULL,
  `VARCOMMISIONSIZE` varchar(255) DEFAULT NULL,
  `VARTARIFFPUBLIC` varchar(255) DEFAULT NULL,
  `VARBILLINGPLANPUBLIC` varchar(255) DEFAULT NULL,
  `VARACCOUNTCLASSPUBLIC` varchar(255) DEFAULT NULL,
  `VARTARIFFCE` varchar(255) DEFAULT NULL,
  `VARBILLINGPLANCE` varchar(255) DEFAULT NULL,
  `VARACCOUNTCLASSCE` varchar(255) DEFAULT NULL,
  `VAREMAILCC` varchar(255) DEFAULT NULL,
  `VAREMAILBCC` varchar(255) DEFAULT NULL,
  `VARRATEPERMINUTE` varchar(255) DEFAULT NULL,
  `VARSIPPYAPIUSERGOPACKAGES` varchar(255) DEFAULT NULL,
  `VARSIPPYAPIPASSGOPACKAGES` varchar(255) DEFAULT NULL,
  `VARSIPPYAPIUSERGOCLOUD` varchar(255) DEFAULT NULL,
  `VARSIPPYAPIPASSGOCLOUD` varchar(255) DEFAULT NULL,
  `VARSIPPYXMLRPCINCFILE` varchar(600) DEFAULT NULL,
  `VARSIPPYXMLRPCCLIENT` varchar(600) DEFAULT NULL,
  `VARSIPPYXMLRPCHTMLFILE` varchar(600) DEFAULT NULL,
  `VARAGENTTITLEBAR` varchar(255) DEFAULT NULL,
  `VARAGENTLOGOBIG` varchar(400) DEFAULT NULL,
  `VARAGENTLOGOSMALL` varchar(400) DEFAULT NULL,
  `VARAGENTTHEMECOLOR` varchar(255) DEFAULT NULL,
  `VARAGENTLOGINBUTTON` varchar(255) DEFAULT NULL,
  `VARAGENTCAMPREFRESH` varchar(255) DEFAULT NULL,
  `VARTABLEODDCOLOR` varchar(255) DEFAULT NULL,
  `VARTABLEEVENCOLOR` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `go_login_type`
--

DROP TABLE IF EXISTS `go_login_type`; CREATE TABLE `go_login_type` (
  `account_num` varchar(20) NOT NULL,
  `type` enum('0','1') NOT NULL DEFAULT '1',
  `new_signup` enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `go_multi_tenant`
--

DROP TABLE IF EXISTS `go_multi_tenant`; CREATE TABLE `go_multi_tenant` (
  `tenant_id` varchar(20) NOT NULL,
  `tenant_name` varchar(40) DEFAULT NULL,
  `admin` varchar(20) NOT NULL,
  `pass` varchar(20) NOT NULL,
  `active` enum('Y','N') NOT NULL DEFAULT 'Y',
  `access_call_times` enum('Y','N') NOT NULL DEFAULT 'N',
  `access_carriers` enum('Y','N') NOT NULL DEFAULT 'N',
  `access_phones` enum('Y','N') NOT NULL DEFAULT 'N',
  `access_voicemails` enum('Y','N') NOT NULL DEFAULT 'N',
  `phone_count` int(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `go_notifications`
--

DROP TABLE IF EXISTS `go_notifications`; CREATE TABLE `go_notifications` (
  `id` int(11) NOT NULL,
  `user` varchar(20) NOT NULL,
  `notification` varchar(30) NOT NULL,
  `title` varchar(100) NOT NULL,
  `message` text NOT NULL,
  `type` varchar(30) NOT NULL DEFAULT 'SYSTEM',
  `status` varchar(20) NOT NULL DEFAULT 'UNCLICKED'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `go_recordings`
--

DROP TABLE IF EXISTS `go_recordings`; CREATE TABLE `go_recordings` (
  `recording_id` int(10) NOT NULL,
  `start_time` datetime DEFAULT NULL,
  `mimetype` varchar(30) CHARACTER SET utf8 DEFAULT NULL,
  `data` longtext CHARACTER SET utf8
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `go_recording_access`
--

DROP TABLE IF EXISTS `go_recording_access`; CREATE TABLE `go_recording_access` (
  `access_id` int(20) UNSIGNED NOT NULL,
  `ip_address` varchar(200) DEFAULT NULL,
  `ip_block_list` varchar(200) DEFAULT NULL,
  `folder` varchar(255) DEFAULT NULL,
  `folder_alias` varchar(255) DEFAULT NULL,
  `active` enum('N','Y') DEFAULT 'N'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `go_remember`
--

DROP TABLE IF EXISTS `go_remember`; CREATE TABLE `go_remember` (
  `id` int(11) NOT NULL,
  `username` varchar(16) DEFAULT NULL,
  `usernamehash` varchar(128) DEFAULT NULL,
  `random_string` varchar(128) DEFAULT NULL,
  `origin_time` int(11) NOT NULL,
  `ip_address` varchar(15) DEFAULT '0.0.0.0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `go_server_settings`
--

DROP TABLE IF EXISTS `go_server_settings`; CREATE TABLE `go_server_settings` (
  `username` varchar(20) NOT NULL,
  `company_name` varchar(100) NOT NULL,
  `company_logo` varchar(100) NOT NULL,
  `theme_color` varchar(50) NOT NULL,
  `login_color` varchar(50) NOT NULL,
  `login_button` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `go_sessions`
--

DROP TABLE IF EXISTS `go_sessions`; CREATE TABLE `go_sessions` (
  `session_id` varchar(40) NOT NULL DEFAULT '0',
  `ip_address` varchar(16) NOT NULL DEFAULT '0',
  `user_agent` varchar(50) NOT NULL,
  `last_activity` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `user_data` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `go_sounds`
--

DROP TABLE IF EXISTS `go_sounds`; CREATE TABLE `go_sounds` (
  `goSound_id` int(10) NOT NULL,
  `type` varchar(30) DEFAULT NULL,
  `data` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `go_sysbackup_access`
--

DROP TABLE IF EXISTS `go_sysbackup_access`; CREATE TABLE `go_sysbackup_access` (
  `access_id` int(20) UNSIGNED NOT NULL,
  `ip_address` varchar(200) DEFAULT NULL,
  `ip_block_list` varchar(200) DEFAULT NULL,
  `folder` varchar(255) DEFAULT NULL,
  `folder_alias` varchar(255) DEFAULT NULL,
  `active` enum('N','Y') DEFAULT 'N'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `go_users`
--

DROP TABLE IF EXISTS `go_users`; CREATE TABLE `go_users` (
  `user_id` int(20) UNSIGNED NOT NULL,
  `user_name` varchar(20) NOT NULL,
  `user_pass` varchar(100) NOT NULL,
  `user_fname` varchar(50) DEFAULT NULL,
  `user_lname` varchar(50) DEFAULT NULL,
  `user_mname` varchar(50) DEFAULT NULL,
  `user_email` varchar(50) DEFAULT NULL,
  `user_level` int(1) DEFAULT '1',
  `user_group` varchar(50) DEFAULT 'Users',
  `user_enabled` enum('N','Y') DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `go_widget_position`
--

DROP TABLE IF EXISTS `go_widget_position`; CREATE TABLE `go_widget_position` (
  `id` int(11) NOT NULL,
  `user_id` varchar(50) NOT NULL,
  `html_id` varchar(50) DEFAULT NULL,
  `left_html` text COLLATE utf8_unicode_ci,
  `right_html` text COLLATE utf8_unicode_ci,
  `today_status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `server_statistics` enum('Y','N') NOT NULL DEFAULT 'Y',
  `dashboard_controls` enum('Y','N') NOT NULL DEFAULT 'Y',
  `dashboard_accounts-hide` enum('Y','N') NOT NULL DEFAULT 'Y',
  `agent_status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `plugins` enum('Y','N') NOT NULL DEFAULT 'Y',
  `go_analytics` enum('Y','N') NOT NULL DEFAULT 'Y',
  `goautodial_news` enum('Y','N') NOT NULL DEFAULT 'Y',
  `goautodial_forum` enum('Y','N') NOT NULL DEFAULT 'Y',
  `walk` enum('Y','N') NOT NULL DEFAULT 'Y',
  `nextlog` enum('Y','N') NOT NULL DEFAULT 'Y',
  `account_info` enum('Y','N') NOT NULL DEFAULT 'Y',
  `agents_and_phones` enum('Y','N') NOT NULL DEFAULT 'Y',
  `dashboard_goautodial_forum` enum('Y','N') NOT NULL DEFAULT 'Y',
  `dashboard_goautodial_news` enum('Y','N') NOT NULL DEFAULT 'Y',
  `dashboard_analytics` enum('Y','N') NOT NULL DEFAULT 'Y',
  `dashboard_plugins` enum('Y','N') NOT NULL DEFAULT 'Y',
  `dashboard_clusters` enum('Y','N') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `justgovoip_sippy_info`
--

DROP TABLE IF EXISTS `justgovoip_sippy_info`; CREATE TABLE `justgovoip_sippy_info` (
  `carrier_id` varchar(15) NOT NULL,
  `username` varchar(100) NOT NULL,
  `web_password` varchar(100) NOT NULL,
  `authname` varchar(100) NOT NULL,
  `voip_password` varchar(100) NOT NULL,
  `vm_password` varchar(250) DEFAULT NULL,
  `i_account` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `lime_surveys`
--

DROP TABLE IF EXISTS `lime_surveys`; CREATE TABLE `lime_surveys` (
  `sid` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `admin` varchar(50) DEFAULT NULL,
  `active` char(1) NOT NULL DEFAULT 'N',
  `expires` datetime DEFAULT NULL,
  `startdate` datetime DEFAULT NULL,
  `adminemail` varchar(320) DEFAULT NULL,
  `anonymized` char(1) NOT NULL DEFAULT 'N',
  `faxto` varchar(20) DEFAULT NULL,
  `format` char(1) DEFAULT NULL,
  `savetimings` char(1) DEFAULT 'N',
  `template` varchar(100) DEFAULT 'default',
  `language` varchar(50) DEFAULT NULL,
  `additional_languages` varchar(255) DEFAULT NULL,
  `datestamp` char(1) DEFAULT 'N',
  `usecookie` char(1) DEFAULT 'N',
  `allowregister` char(1) DEFAULT 'N',
  `allowsave` char(1) DEFAULT 'Y',
  `autonumber_start` bigint(11) DEFAULT '0',
  `autoredirect` char(1) DEFAULT 'N',
  `allowprev` char(1) DEFAULT 'Y',
  `printanswers` char(1) DEFAULT 'N',
  `ipaddr` char(1) DEFAULT 'N',
  `refurl` char(1) DEFAULT 'N',
  `datecreated` date DEFAULT NULL,
  `publicstatistics` char(1) DEFAULT 'N',
  `publicgraphs` char(1) DEFAULT 'N',
  `listpublic` char(1) DEFAULT 'N',
  `htmlemail` char(1) DEFAULT 'N',
  `tokenanswerspersistence` char(1) DEFAULT 'N',
  `assessments` char(1) DEFAULT 'N',
  `usecaptcha` char(1) DEFAULT 'N',
  `usetokens` char(1) DEFAULT 'N',
  `bounce_email` varchar(320) DEFAULT NULL,
  `attributedescriptions` text COLLATE utf8_unicode_ci,
  `emailresponseto` text COLLATE utf8_unicode_ci,
  `emailnotificationto` text COLLATE utf8_unicode_ci,
  `tokenlength` tinyint(2) DEFAULT '15',
  `showxquestions` char(1) NOT NULL DEFAULT 'Y',
  `showgroupinfo` char(1) DEFAULT 'B',
  `shownoanswer` char(1) DEFAULT 'Y',
  `showqnumcode` char(1) DEFAULT 'X',
  `bouncetime` bigint(20) DEFAULT NULL,
  `bounceprocessing` varchar(1) DEFAULT 'N',
  `bounceaccounttype` varchar(4) DEFAULT NULL,
  `bounceaccounthost` varchar(200) DEFAULT NULL,
  `bounceaccountpass` varchar(100) DEFAULT NULL,
  `bounceaccountencryption` varchar(3) DEFAULT NULL,
  `bounceaccountuser` varchar(200) DEFAULT NULL,
  `showwelcome` char(1) DEFAULT 'Y',
  `showprogress` char(1) DEFAULT 'Y',
  `allowjumps` char(1) DEFAULT 'N',
  `navigationdelay` tinyint(2) DEFAULT '0',
  `nokeyboard` char(1) DEFAULT 'N',
  `alloweditaftercompletion` char(1) DEFAULT 'N',
  `googleanalyticsstyle` char(1) DEFAULT NULL,
  `googleanalyticsapikey` varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `marital_status`
--

DROP TABLE IF EXISTS `marital_status`; CREATE TABLE `marital_status` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `messages_inbox`
--

DROP TABLE IF EXISTS `messages_inbox`; CREATE TABLE `messages_inbox` (
  `id` int(11) NOT NULL,
  `user_from` int(11) NOT NULL,
  `user_to` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` longtext,
  `date` datetime NOT NULL,
  `message_read` int(1) NOT NULL,
  `favorite` int(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `messages_junk`
--

DROP TABLE IF EXISTS `messages_junk`; CREATE TABLE `messages_junk` (
  `id` int(11) NOT NULL,
  `user_from` int(11) NOT NULL,
  `user_to` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` longtext,
  `date` datetime NOT NULL,
  `message_read` int(1) NOT NULL,
  `favorite` int(1) NOT NULL DEFAULT '0',
  `origin_folder` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `messages_outbox`
--

DROP TABLE IF EXISTS `messages_outbox`; CREATE TABLE `messages_outbox` (
  `id` int(11) NOT NULL,
  `user_from` int(11) NOT NULL,
  `user_to` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` longtext,
  `date` datetime NOT NULL,
  `message_read` int(1) NOT NULL,
  `favorite` int(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `module_MessageOfTheDay`
--

DROP TABLE IF EXISTS `module_MessageOfTheDay`; CREATE TABLE `module_MessageOfTheDay` (
  `id` int(11) NOT NULL,
  `customer_id` int(11) NOT NULL,
  `customer_type` varchar(255) NOT NULL,
  `favorite_quote` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `notifications`
--

DROP TABLE IF EXISTS `notifications`; CREATE TABLE `notifications` (
  `id` int(11) NOT NULL,
  `target_user` int(11) DEFAULT NULL,
  `text` varchar(512) NOT NULL,
  `date` datetime NOT NULL,
  `action` varchar(255) DEFAULT NULL,
  `type` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`; CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `setting` varchar(255) NOT NULL,
  `context` varchar(255) NOT NULL,
  `value` longtext
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `setting`, `context`, `value`) VALUES
(1, 'base_url', 'creamy', 'vaglxc01.goautodial.com'),
(2, 'admin_user', 'creamy', '1'),
(3, 'crm_version', 'creamy', '1.0'),
(4, 'installation_date', 'creamy', '2016-01-26 19:16:55'),
(5, 'module_system_enabled', 'creamy', '1'),
(6, 'statistics_system_enabled', 'creamy', '1'),
(7, 'notification_email_events', 'creamy', '1'),
(8, 'job_scheduling_min_freq', 'creamy', NULL),
(9, 'active_modules', 'creamy', 'GOagent'),
(10, 'customer_list_fields', 'creamy', 'id,name,email,phone,id_number'),
(11, 'timezone', 'creamy', 'Asia/Manila'),
(12, 'locale', 'creamy', 'en_US'),
(13, 'security_token', 'creamy', 'en_US'),
(14, 'confirmation_email', 'creamy', '0'),
(15, 'theme', 'creamy', 'black'),
(16, 'company_name', 'creamy', 'GOautodial Inc'),
(17, 'company_logo', 'creamy', 'img/customCompanyLogo.png'),
(18, 'GO_agent_url', 'module_GOautodialAgentDialer', 'http://127.0.0.1'),
(19, 'GO_agent_db', 'module_GOautodialAgentDialer', ''),
(20, 'GO_agent_user', 'module_GOautodialAgentDialer', 'admin'),
(21, 'GO_agent_pass', 'module_GOautodialAgentDialer', 'G02x16'),
(22, 'GO_agent_wss', 'module_GOautodialAgentDialer', 'vaglxc01.goautodial.com'),
(23, 'GO_agent_sip_server', 'module_GOautodialAgentDialer', 'kamailio'),
(24, 'GO_agent_wss_port', 'module_GOautodialAgentDialer', '4443'),
(25, 'GO_agent_wss_sip', 'module_GOautodialAgentDialer', 'vaglxc01.goautodial.com'),
(26, 'GO_agent_wss_sip_port', 'module_GOautodialAgentDialer', '5060'),
(27, 'GO_agent_use_wss', 'module_GOautodialAgentDialer', '1'),
(28, 'GO_show_phones', 'module_GOautodialAgentDialer', '1'),
(29, 'GO_agent_domain', 'module_GOautodialAgentDialer', 'vaglxc01.goautodial.com'),
(30, 'enable_smtp', 'smtp_settings', '1'),
(31, 'google_api_key', 'creamy', ''),
(32, 'slave_db_ip', 'creamy', '');

-- --------------------------------------------------------

--
-- Table structure for table `smtp_settings`
--

DROP TABLE IF EXISTS `smtp_settings`; CREATE TABLE `smtp_settings` (
  `debug` int(1) DEFAULT NULL,
  `timezone` varchar(250) DEFAULT NULL,
  `ipv6_support` int(1) DEFAULT NULL,
  `host` varchar(120) DEFAULT NULL,
  `port` int(4) DEFAULT NULL,
  `smtp_security` varchar(3) DEFAULT NULL,
  `smtp_auth` int(1) DEFAULT NULL,
  `username` varchar(120) DEFAULT NULL,
  `password` varchar(120) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `sounds`
--

DROP TABLE IF EXISTS `sounds`; CREATE TABLE `sounds` (
  `goSound_id` int(10) NOT NULL,
  `goFilename` varchar(120) DEFAULT NULL,
  `goDirectory` varchar(120) DEFAULT NULL,
  `goFileDate` datetime DEFAULT NULL,
  `goFilesize` varchar(20) DEFAULT NULL,
  `uploaded_by` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `statistics`
--

DROP TABLE IF EXISTS `statistics`; CREATE TABLE `statistics` (
  `id` int(11) NOT NULL,
  `timestamp` datetime NOT NULL,
  `clients_1` int(11) NOT NULL DEFAULT '0',
  `clients_2` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `tasks`
--

DROP TABLE IF EXISTS `tasks`; CREATE TABLE `tasks` (
  `id` int(11) NOT NULL,
  `title` varchar(50) CHARACTER SET utf8 NOT NULL,
  `description` varchar(512) NOT NULL,
  `user_id` int(11) NOT NULL,
  `target_customer_id` int(11) DEFAULT NULL,
  `creation_date` datetime NOT NULL,
  `completion_date` datetime DEFAULT NULL,
  `completed` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `timeline`
--

DROP TABLE IF EXISTS `timeline`; CREATE TABLE `timeline` (
  `id` int(11) NOT NULL,
  `type_id` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `user_id` varchar(16) NOT NULL,
  `user_from_id` varchar(16) NOT NULL,
  `title` varchar(50) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`; CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `userid` int(10) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `fullname` varchar(50) DEFAULT NULL,
  `password_hash` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `avatar` longtext,
  `creation_date` datetime NOT NULL,
  `user_group` varchar(20) DEFAULT NULL,
  `role` int(4) NOT NULL,
  `status` enum('1','0') CHARACTER SET latin1 NOT NULL DEFAULT '0',
  `gcal` enum('0','1') NOT NULL DEFAULT '0',
  `calendar_apikey` varchar(255) DEFAULT NULL,
  `calendar_id` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `user_access_group`
--

DROP TABLE IF EXISTS `user_access_group`; CREATE TABLE `user_access_group` (
  `id` int(11) NOT NULL,
  `user_group` varchar(250) NOT NULL,
  `permissions` text NOT NULL,
  `group_level` int(11) NOT NULL,
  `date_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `allowed_campaigns` text COLLATE utf8_unicode_ci,
  `group_list_id` bigint(14) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_access_group`
--

INSERT INTO `user_access_group` (`id`, `user_group`, `permissions`, `group_level`, `date_create`, `allowed_campaigns`, `group_list_id`) VALUES
(1, 'ADMIN', '{"dashboard":{"dashboard_display":"Y"},"user":{"user_create":"C","user_read":"R","user_update":"U","user_delete":"D"},"campaign":{"campaign_create":"C","campaign_read":"R","campaign_update":"U","campaign_delete":"D"},"disposition":{"disposition_create":"C","disposition_update":"U","disposition_delete":"D"},"pausecodes":{"pausecodes_create":"C","pausecodes_read":"R","pausecodes_update":"U","pausecodes_delete":"D"},"hotkeys":{"hotkeys_create":"C","hotkeys_read":"R","hotkeys_delete":"D"},"list":{"list_create":"C","list_read":"R","list_update":"U","list_delete":"D","list_upload":"C"},"customfields":{"customfields_create":"C","customfields_read":"R","customfields_update":"U","customfields_delete":"D"},"loadleads":{"loadleads_read":"R"},"script":{"script_create":"C","script_read":"R","script_update":"U","script_delete":"D"},"inbound":{"inbound_create":"C","inbound_read":"R","inbound_update":"U","inbound_delete":"D"},"voicefiles":{"voicefiles_upload":"C","voicefiles_delete":"D"},"reportsanalytics":{"reportsanalytics_display":"Y"},"recordings":{"recordings_display":"Y"},"support":{"support_display":"Y"},"multi-tenant":{"tenant_create":"Y","tenant_display":"Y","tenant_update":"Y","tenant_delete":"Y","tenant_logs":"Y","tenant_calltimes":"Y","tenant_phones":"Y","tenant_voicemails":"Y"}}', 9, '2013-06-05 03:42:17', NULL, NULL),
(2, 'AGENTS', '{"dashboard":{"dashboard_display":"N"},"user":{"user_create":"N","user_read":"N","user_update":"N","user_delete":"N"},"campaign":{"campaign_create":"N","campaign_read":"N","campaign_update":"N","campaign_delete":"N"},"disposition":{"disposition_create":"N","disposition_update":"N","disposition_delete":"N"},"pausecodes":{"pausecodes_create":"N","pausecodes_read":"N","pausecodes_update":"N","pausecodes_delete":"N"},"hotkeys":{"hotkeys_create":"N","hotkeys_read":"N","hotkeys_delete":"N"},"list":{"list_create":"N","list_read":"N","list_update":"N","list_delete":"N","list_upload":"N"},"customfields":{"customfields_create":"N","customfields_read":"N","customfields_update":"N","customfields_delete":"N"},"loadleads":{"loadleads_read":"N"},"script":{"script_create":"N","script_read":"N","script_update":"N","script_delete":"N"},"inbound":{"inbound_create":"N","inbound_read":"N","inbound_update":"N","inbound_delete":"N"},"voicefiles":{"voicefiles_upload":"N","voicefiles_delete":"N"},"reportsanalytics":{"reportsanalytics_display":"N"},"recordings":{"recordings_display":"N"},"support":{"support_display":"N"},"multi-tenant":{"tenant_create":"N","tenant_display":"N","tenant_update":"N","tenant_delete":"N","tenant_logs":"N","tenant_calltimes":"N","tenant_phones":"N","tenant_voicemails":"N"}}', 1, '2013-06-05 03:49:21', NULL, NULL),
(3, 'SUPERVISOR', '{"dashboard":{"dashboard_display":"Y"},"user":{"user_create":"C","user_read":"R","user_update":"N","user_delete":"N"},"campaign":{"campaign_create":"N","campaign_read":"R","campaign_update":"U","campaign_delete":"N"},"disposition":{"disposition_create":"C","disposition_update":"U","disposition_delete":"N"},"pausecodes":{"pausecodes_create":"C","pausecodes_read":"R","pausecodes_update":"U","pausecodes_delete":"N"},"hotkeys":{"hotkeys_create":"C","hotkeys_read":"R","hotkeys_delete":"N"},"list":{"list_create":"C","list_read":"R","list_update":"U","list_delete":"N","list_upload":"C"},"customfields":{"customfields_create":"C","customfields_read":"R","customfields_update":"U","customfields_delete":"N"},"script":{"script_create":"C","script_read":"R","script_update":"U","script_delete":"N"},"inbound":{"inbound_create":"C","inbound_read":"R","inbound_update":"U","inbound_delete":"N"},"ivr":{"ivr_create":"C","ivr_read":"R","ivr_update":"U","ivr_delete":"N"},"did":{"did_create":"C","did_read":"R","did_update":"U","did_delete":"N"},"voicefiles":{"voicefiles_upload":"C","voicefiles_play":"Y","voicefiles_download":"Y"},"moh":{"moh_create":"C","moh_read":"R","moh_update":"U","moh_delete":"N"},"reportsanalytics":{"reportsanalytics_statistical_display":"Y","reportsanalytics_agent_time_display":"Y","reportsanalytics_agent_performance_display":"Y","reportsanalytics_dial_status_display":"Y","reportsanalytics_agent_sales_display":"Y","reportsanalytics_sales_tracker_display":"Y","reportsanalytics_inbound_call_display":"Y","reportsanalytics_export_call_display":"Y"},"recordings":{"recordings_display":"Y"},"support":{"support_display":"Y"},"multi-tenant":{"tenant_create":"N","tenant_display":"N","tenant_update":"N","tenant_delete":"N","tenant_logs":"N","tenant_calltimes":"N","tenant_phones":"N","tenant_voicemails":"N"},"chat":{"chat_create":"C","chat_read":"R","chat_update":"U","chat_delete":"D"},"osticket":{"osticket_create":"C","osticket_read":"R","osticket_update":"U","osticket_delete":"D"}}', 8, '2018-08-11 21:24:38', NULL, NULL),
(4, 'TENANT', '{"dashboard":{"dashboard_display":"Y"},"user":{"user_create":"C","user_read":"R","user_update":"N","user_delete":"N"},"campaign":{"campaign_create":"N","campaign_read":"R","campaign_update":"U","campaign_delete":"N"},"disposition":{"disposition_create":"C","disposition_update":"U","disposition_delete":"N"},"pausecodes":{"pausecodes_create":"C","pausecodes_read":"R","pausecodes_update":"U","pausecodes_delete":"N"},"hotkeys":{"hotkeys_create":"C","hotkeys_read":"R","hotkeys_delete":"N"},"list":{"list_create":"C","list_read":"R","list_update":"U","list_delete":"N","list_upload":"C"},"customfields":{"customfields_create":"C","customfields_read":"R","customfields_update":"U","customfields_delete":"N"},"script":{"script_create":"C","script_read":"R","script_update":"U","script_delete":"N"},"inbound":{"inbound_create":"C","inbound_read":"R","inbound_update":"U","inbound_delete":"N"},"ivr":{"ivr_create":"C","ivr_read":"R","ivr_update":"U","ivr_delete":"N"},"did":{"did_create":"C","did_read":"R","did_update":"U","did_delete":"N"},"voicefiles":{"voicefiles_upload":"C","voicefiles_play":"Y","voicefiles_download":"Y"},"moh":{"moh_create":"C","moh_read":"R","moh_update":"U","moh_delete":"N"},"reportsanalytics":{"reportsanalytics_statistical_display":"Y","reportsanalytics_agent_time_display":"Y","reportsanalytics_agent_performance_display":"Y","reportsanalytics_dial_status_display":"Y","reportsanalytics_agent_sales_display":"Y","reportsanalytics_sales_tracker_display":"Y","reportsanalytics_inbound_call_display":"Y","reportsanalytics_export_call_display":"Y"},"recordings":{"recordings_display":"Y"},"support":{"support_display":"Y"},"multi-tenant":{"tenant_create":"N","tenant_display":"N","tenant_update":"N","tenant_delete":"N","tenant_logs":"N","tenant_calltimes":"N","tenant_phones":"N","tenant_voicemails":"N"},"chat":{"chat_create":"C","chat_read":"R","chat_update":"U","chat_delete":"D"},"osticket":{"osticket_create":"C","osticket_read":"R","osticket_update":"U","osticket_delete":"D"}}', 8, '2018-08-11 21:25:07', NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `attachments`
--
ALTER TABLE `attachments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `clients_1`
--
ALTER TABLE `clients_1`
  ADD PRIMARY KEY (`id`),
  ADD KEY `Unique unique_name` (`name`,`id_number`,`email`);

--
-- Indexes for table `clients_2`
--
ALTER TABLE `clients_2`
  ADD PRIMARY KEY (`id`),
  ADD KEY `Unique unique_name` (`name`,`id_number`,`email`);

--
-- Indexes for table `customer_types`
--
ALTER TABLE `customer_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `go_action_logs`
--
ALTER TABLE `go_action_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `go_agent_sessions`
--
ALTER TABLE `go_agent_sessions`
  ADD PRIMARY KEY (`agent_session_id`);

--
-- Indexes for table `go_avatars`
--
ALTER TABLE `go_avatars`
  ADD PRIMARY KEY (`user_id`);

--
-- Indexes for table `go_callback_lists`
--
ALTER TABLE `go_callback_lists`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `go_campaigns`
--
ALTER TABLE `go_campaigns`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `go_customers`
--
ALTER TABLE `go_customers`
  ADD PRIMARY KEY (`cust_id`);

--
-- Indexes for table `go_dropbox`
--
ALTER TABLE `go_dropbox`
  ADD PRIMARY KEY (`dropID`);

--
-- Indexes for table `go_firewall_blocklist`
--
ALTER TABLE `go_firewall_blocklist`
  ADD PRIMARY KEY (`block_id`);

--
-- Indexes for table `go_firewall_interfaces`
--
ALTER TABLE `go_firewall_interfaces`
  ADD PRIMARY KEY (`interface_id`);

--
-- Indexes for table `go_firewall_rules`
--
ALTER TABLE `go_firewall_rules`
  ADD PRIMARY KEY (`rule_id`);

--
-- Indexes for table `go_firewall_whitelist`
--
ALTER TABLE `go_firewall_whitelist`
  ADD PRIMARY KEY (`white_id`);

--
-- Indexes for table `go_language`
--
ALTER TABLE `go_language`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `go_last_login`
--
ALTER TABLE `go_last_login`
  ADD PRIMARY KEY (`account_num`);

--
-- Indexes for table `go_license`
--
ALTER TABLE `go_license`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `go_licensepackages`
--
ALTER TABLE `go_licensepackages`
  ADD PRIMARY KEY (`goLicensepackages_id`);

--
-- Indexes for table `go_license_sippy_conf`
--
ALTER TABLE `go_license_sippy_conf`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `go_login_type`
--
ALTER TABLE `go_login_type`
  ADD KEY `account_num` (`account_num`);

--
-- Indexes for table `go_multi_tenant`
--
ALTER TABLE `go_multi_tenant`
  ADD KEY `tenant_id` (`tenant_id`);

--
-- Indexes for table `go_notifications`
--
ALTER TABLE `go_notifications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `go_recordings`
--
ALTER TABLE `go_recordings`
  ADD PRIMARY KEY (`recording_id`);

--
-- Indexes for table `go_recording_access`
--
ALTER TABLE `go_recording_access`
  ADD PRIMARY KEY (`access_id`);

--
-- Indexes for table `go_remember`
--
ALTER TABLE `go_remember`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `go_sessions`
--
ALTER TABLE `go_sessions`
  ADD PRIMARY KEY (`session_id`);

--
-- Indexes for table `go_sounds`
--
ALTER TABLE `go_sounds`
  ADD KEY `goSound_id` (`goSound_id`);

--
-- Indexes for table `go_sysbackup_access`
--
ALTER TABLE `go_sysbackup_access`
  ADD PRIMARY KEY (`access_id`);

--
-- Indexes for table `go_users`
--
ALTER TABLE `go_users`
  ADD PRIMARY KEY (`user_id`);

--
-- Indexes for table `go_widget_position`
--
ALTER TABLE `go_widget_position`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `lime_surveys`
--
ALTER TABLE `lime_surveys`
  ADD PRIMARY KEY (`sid`);

--
-- Indexes for table `marital_status`
--
ALTER TABLE `marital_status`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `messages_inbox`
--
ALTER TABLE `messages_inbox`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `messages_junk`
--
ALTER TABLE `messages_junk`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `messages_outbox`
--
ALTER TABLE `messages_outbox`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `module_MessageOfTheDay`
--
ALTER TABLE `module_MessageOfTheDay`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `Unique unique_name` (`setting`,`context`);

--
-- Indexes for table `sounds`
--
ALTER TABLE `sounds`
  ADD PRIMARY KEY (`goSound_id`);

--
-- Indexes for table `statistics`
--
ALTER TABLE `statistics`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `tasks`
--
ALTER TABLE `tasks`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `timeline`
--
ALTER TABLE `timeline`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD KEY `Unique unique_name` (`name`,`email`);

--
-- Indexes for table `user_access_group`
--
ALTER TABLE `user_access_group`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `attachments`
--
ALTER TABLE `attachments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `clients_1`
--
ALTER TABLE `clients_1`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `clients_2`
--
ALTER TABLE `clients_2`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `customer_types`
--
ALTER TABLE `customer_types`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_action_logs`
--
ALTER TABLE `go_action_logs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_agent_sessions`
--
ALTER TABLE `go_agent_sessions`
  MODIFY `agent_session_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_callback_lists`
--
ALTER TABLE `go_callback_lists`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_campaigns`
--
ALTER TABLE `go_campaigns`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_customers`
--
ALTER TABLE `go_customers`
  MODIFY `cust_id` int(9) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_dropbox`
--
ALTER TABLE `go_dropbox`
  MODIFY `dropID` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_firewall_blocklist`
--
ALTER TABLE `go_firewall_blocklist`
  MODIFY `block_id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_firewall_interfaces`
--
ALTER TABLE `go_firewall_interfaces`
  MODIFY `interface_id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_firewall_rules`
--
ALTER TABLE `go_firewall_rules`
  MODIFY `rule_id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_firewall_whitelist`
--
ALTER TABLE `go_firewall_whitelist`
  MODIFY `white_id` int(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_language`
--
ALTER TABLE `go_language`
  MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_license`
--
ALTER TABLE `go_license`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_licensepackages`
--
ALTER TABLE `go_licensepackages`
  MODIFY `goLicensepackages_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_license_sippy_conf`
--
ALTER TABLE `go_license_sippy_conf`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_notifications`
--
ALTER TABLE `go_notifications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_recording_access`
--
ALTER TABLE `go_recording_access`
  MODIFY `access_id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_remember`
--
ALTER TABLE `go_remember`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_sounds`
--
ALTER TABLE `go_sounds`
  MODIFY `goSound_id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_sysbackup_access`
--
ALTER TABLE `go_sysbackup_access`
  MODIFY `access_id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_users`
--
ALTER TABLE `go_users`
  MODIFY `user_id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `go_widget_position`
--
ALTER TABLE `go_widget_position`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `marital_status`
--
ALTER TABLE `marital_status`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `messages_inbox`
--
ALTER TABLE `messages_inbox`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `messages_junk`
--
ALTER TABLE `messages_junk`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `messages_outbox`
--
ALTER TABLE `messages_outbox`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `module_MessageOfTheDay`
--
ALTER TABLE `module_MessageOfTheDay`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sounds`
--
ALTER TABLE `sounds`
  MODIFY `goSound_id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `statistics`
--
ALTER TABLE `statistics`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tasks`
--
ALTER TABLE `tasks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `timeline`
--
ALTER TABLE `timeline`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_access_group`
--
ALTER TABLE `user_access_group`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `go_sounds`
--
ALTER TABLE `go_sounds`
  ADD CONSTRAINT `go_sounds_ibfk_1` FOREIGN KEY (`goSound_id`) REFERENCES `sounds` (`goSound_id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;