· 8 years ago · Aug 29, 2018, 08:32 PM
1-- phpMyAdmin SQL Dump
2-- version 4.8.2
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost
6-- Generation Time: Aug 11, 2018 at 09:29 PM
7-- Server version: 10.1.34-MariaDB
8-- PHP Version: 7.0.30
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Database: `goautodial`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Table structure for table `attachments`
29--
30
31DROP TABLE IF EXISTS `attachments`; CREATE TABLE `attachments` (
32 `id` int(11) NOT NULL,
33 `message_id` int(11) NOT NULL,
34 `folder_id` int(11) NOT NULL,
35 `filepath` varchar(255) NOT NULL,
36 `filetype` varchar(255) NOT NULL,
37 `filesize` int(11) NOT NULL
38) ENGINE=InnoDB DEFAULT CHARSET=utf8;
39
40-- --------------------------------------------------------
41
42--
43-- Table structure for table `clients_1`
44--
45
46DROP TABLE IF EXISTS `clients_1`; CREATE TABLE `clients_1` (
47 `id` int(11) NOT NULL,
48 `company` int(1) NOT NULL DEFAULT '0',
49 `name` varchar(255) NOT NULL,
50 `id_number` varchar(255) DEFAULT NULL,
51 `address` text,
52 `city` varchar(255) DEFAULT NULL,
53 `state` varchar(255) DEFAULT NULL,
54 `zip_code` varchar(255) DEFAULT NULL,
55 `country` varchar(255) DEFAULT NULL,
56 `phone` text,
57 `mobile` text,
58 `email` varchar(255) DEFAULT NULL,
59 `avatar` varchar(255) DEFAULT NULL,
60 `type` text,
61 `website` varchar(255) DEFAULT NULL,
62 `company_name` varchar(255) DEFAULT NULL,
63 `notes` text,
64 `birthdate` datetime DEFAULT NULL,
65 `marital_status` int(11) DEFAULT NULL,
66 `creation_date` datetime DEFAULT NULL,
67 `created_by` int(11) NOT NULL,
68 `do_not_send_email` char(1) DEFAULT NULL,
69 `gender` int(1) DEFAULT NULL
70) ENGINE=InnoDB DEFAULT CHARSET=utf8;
71
72-- --------------------------------------------------------
73
74--
75-- Table structure for table `clients_2`
76--
77
78DROP TABLE IF EXISTS `clients_2`; CREATE TABLE `clients_2` (
79 `id` int(11) NOT NULL,
80 `company` int(1) NOT NULL DEFAULT '0',
81 `name` varchar(255) NOT NULL,
82 `id_number` varchar(255) DEFAULT NULL,
83 `address` text,
84 `city` varchar(255) DEFAULT NULL,
85 `state` varchar(255) DEFAULT NULL,
86 `zip_code` varchar(255) DEFAULT NULL,
87 `country` varchar(255) DEFAULT NULL,
88 `phone` text,
89 `mobile` text,
90 `email` varchar(255) DEFAULT NULL,
91 `avatar` varchar(255) DEFAULT NULL,
92 `type` text,
93 `website` varchar(255) DEFAULT NULL,
94 `company_name` varchar(255) DEFAULT NULL,
95 `notes` text,
96 `birthdate` datetime DEFAULT NULL,
97 `marital_status` int(11) DEFAULT NULL,
98 `creation_date` datetime DEFAULT NULL,
99 `created_by` int(11) NOT NULL,
100 `do_not_send_email` char(1) DEFAULT NULL,
101 `gender` int(1) DEFAULT NULL
102) ENGINE=InnoDB DEFAULT CHARSET=utf8;
103
104-- --------------------------------------------------------
105
106--
107-- Table structure for table `customer_types`
108--
109
110DROP TABLE IF EXISTS `customer_types`; CREATE TABLE `customer_types` (
111 `id` int(11) NOT NULL,
112 `table_name` varchar(255) NOT NULL,
113 `description` varchar(255) NOT NULL
114) ENGINE=InnoDB DEFAULT CHARSET=utf8;
115
116-- --------------------------------------------------------
117
118--
119-- Table structure for table `events`
120--
121
122DROP TABLE IF EXISTS `events`; CREATE TABLE `events` (
123 `id` int(11) NOT NULL,
124 `user_id` int(11) NOT NULL,
125 `title` varchar(512) NOT NULL,
126 `all_day` int(1) NOT NULL,
127 `start_date` datetime DEFAULT NULL,
128 `end_date` datetime DEFAULT NULL,
129 `url` varchar(512) DEFAULT NULL,
130 `alarm` varchar(80) DEFAULT NULL,
131 `notification_sent` int(1) NOT NULL DEFAULT '0',
132 `color` varchar(80) NOT NULL
133) ENGINE=InnoDB DEFAULT CHARSET=utf8;
134
135-- --------------------------------------------------------
136
137--
138-- Table structure for table `go_action_logs`
139--
140
141DROP TABLE IF EXISTS `go_action_logs`; CREATE TABLE `go_action_logs` (
142 `id` int(11) NOT NULL,
143 `user` varchar(50) NOT NULL,
144 `ip_address` varchar(16) NOT NULL,
145 `event_date` datetime NOT NULL,
146 `action` varchar(50) NOT NULL,
147 `details` text COLLATE utf8_unicode_ci,
148 `db_query` text COLLATE utf8_unicode_ci,
149 `user_group` varchar(20) DEFAULT NULL
150) ENGINE=InnoDB DEFAULT CHARSET=utf8;
151
152-- --------------------------------------------------------
153
154--
155-- Table structure for table `go_agent_sessions`
156--
157
158DROP TABLE IF EXISTS `go_agent_sessions`; CREATE TABLE `go_agent_sessions` (
159 `agent_session_id` int(11) NOT NULL,
160 `sess_agent_user` varchar(25) NOT NULL,
161 `sess_agent_phone` varchar(25) NOT NULL,
162 `sess_agent_status` varchar(25) NOT NULL
163) ENGINE=InnoDB DEFAULT CHARSET=utf8;
164
165-- --------------------------------------------------------
166
167--
168-- Table structure for table `go_avatars`
169--
170
171DROP TABLE IF EXISTS `go_avatars`; CREATE TABLE `go_avatars` (
172 `user_id` int(9) UNSIGNED NOT NULL,
173 `type` varchar(30) NOT NULL,
174 `data` text NOT NULL
175) ENGINE=InnoDB DEFAULT CHARSET=latin1;
176
177-- --------------------------------------------------------
178
179--
180-- Table structure for table `go_callback_lists`
181--
182
183DROP TABLE IF EXISTS `go_callback_lists`; CREATE TABLE `go_callback_lists` (
184 `id` int(11) NOT NULL,
185 `callback_id` int(9) UNSIGNED NOT NULL,
186 `callback_time` datetime NOT NULL,
187 `seen` tinyint(1) NOT NULL DEFAULT '0'
188) ENGINE=InnoDB DEFAULT CHARSET=latin1;
189
190-- --------------------------------------------------------
191
192--
193-- Table structure for table `go_campaigns`
194--
195
196DROP TABLE IF EXISTS `go_campaigns`; CREATE TABLE `go_campaigns` (
197 `id` int(11) NOT NULL,
198 `campaign_id` varchar(255) DEFAULT NULL,
199 `campaign_type` varchar(255) DEFAULT NULL,
200 `custom_fields_launch` enum('ONCALL','LOGIN') DEFAULT 'ONCALL',
201 `custom_fields_list_id` bigint(14) DEFAULT NULL,
202 `url_tab_first_title` varchar(50) DEFAULT NULL,
203 `url_tab_first_url` text,
204 `url_tab_second_title` varchar(50) DEFAULT NULL,
205 `url_tab_second_url` text,
206 `enable_callback_alert` tinyint(1) DEFAULT '0',
207 `cb_noexpire` tinyint(1) DEFAULT '0',
208 `cb_sendemail` tinyint(1) DEFAULT '0',
209 `google_sheet_ids` text,
210 `google_sheet_list_id` bigint(14) UNSIGNED DEFAULT '0'
211) ENGINE=InnoDB DEFAULT CHARSET=latin1;
212
213-- --------------------------------------------------------
214
215--
216-- Table structure for table `go_customers`
217--
218
219DROP TABLE IF EXISTS `go_customers`; CREATE TABLE `go_customers` (
220 `cust_id` int(9) UNSIGNED NOT NULL,
221 `lead_id` int(9) UNSIGNED NOT NULL,
222 `group_list_id` bigint(14) UNSIGNED NOT NULL,
223 `avatar` longtext
224) ENGINE=InnoDB DEFAULT CHARSET=latin1;
225
226-- --------------------------------------------------------
227
228--
229-- Table structure for table `go_dropbox`
230--
231
232DROP TABLE IF EXISTS `go_dropbox`; CREATE TABLE `go_dropbox` (
233 `dropID` int(10) NOT NULL,
234 `app_key` varchar(50) NOT NULL,
235 `userID` varchar(25) NOT NULL,
236 `dropbox_status` varchar(5) NOT NULL
237) ENGINE=InnoDB DEFAULT CHARSET=latin1;
238
239-- --------------------------------------------------------
240
241--
242-- Table structure for table `go_firewall_blocklist`
243--
244
245DROP TABLE IF EXISTS `go_firewall_blocklist`; CREATE TABLE `go_firewall_blocklist` (
246 `block_id` int(20) UNSIGNED NOT NULL,
247 `command` enum('-A','-I') DEFAULT '-I',
248 `type` enum('INPUT','OUTPUT','FORWARD') DEFAULT 'INPUT',
249 `source` varchar(200) DEFAULT NULL,
250 `target` enum('DROP','REJECT') DEFAULT 'DROP',
251 `active` enum('N','Y') DEFAULT 'N'
252) ENGINE=InnoDB DEFAULT CHARSET=latin1;
253
254-- --------------------------------------------------------
255
256--
257-- Table structure for table `go_firewall_interfaces`
258--
259
260DROP TABLE IF EXISTS `go_firewall_interfaces`; CREATE TABLE `go_firewall_interfaces` (
261 `interface_id` int(20) UNSIGNED NOT NULL,
262 `interface` varchar(50) NOT NULL,
263 `command` enum('-A','-I') DEFAULT '-I',
264 `type` enum('INPUT','OUTPUT','FORWARD') DEFAULT 'INPUT',
265 `target` enum('ACCEPT','DROP','LOG','REJECT','DNAT','SNAT','MASQUERADE') DEFAULT 'ACCEPT',
266 `active` enum('N','Y') DEFAULT 'N'
267) ENGINE=InnoDB DEFAULT CHARSET=latin1;
268
269-- --------------------------------------------------------
270
271--
272-- Table structure for table `go_firewall_rules`
273--
274
275DROP TABLE IF EXISTS `go_firewall_rules`; CREATE TABLE `go_firewall_rules` (
276 `rule_id` int(20) UNSIGNED NOT NULL,
277 `rule_number` varchar(20) NOT NULL,
278 `command` enum('-A','-I') DEFAULT '-I',
279 `type` enum('INPUT','OUTPUT','FORWARD') DEFAULT 'INPUT',
280 `state` varchar(255) DEFAULT NULL,
281 `protocol` enum('icmp','tcp','udp','all') DEFAULT 'all',
282 `match_protocol` enum('N','Y') DEFAULT 'N',
283 `source` varchar(200) NOT NULL DEFAULT '0.0.0.0/0',
284 `destination` varchar(200) NOT NULL DEFAULT '0.0.0.0/0',
285 `port_from` varchar(200) DEFAULT NULL,
286 `port_to` varchar(200) DEFAULT NULL,
287 `target` enum('ACCEPT','DROP','LOG','REJECT','DNAT','SNAT','MASQUERADE') DEFAULT 'ACCEPT',
288 `active` enum('N','Y') DEFAULT 'N'
289) ENGINE=InnoDB DEFAULT CHARSET=latin1;
290
291-- --------------------------------------------------------
292
293--
294-- Table structure for table `go_firewall_whitelist`
295--
296
297DROP TABLE IF EXISTS `go_firewall_whitelist`; CREATE TABLE `go_firewall_whitelist` (
298 `white_id` int(20) NOT NULL,
299 `command` enum('-A','-I') DEFAULT '-I',
300 `type` enum('INPUT','OUTPUT','FORWARD') DEFAULT 'INPUT',
301 `source` varchar(200) DEFAULT NULL,
302 `target` enum('ACCEPT') DEFAULT 'ACCEPT',
303 `active` enum('Y','N') DEFAULT 'N',
304 `description` varchar(150) DEFAULT NULL
305) ENGINE=InnoDB DEFAULT CHARSET=utf8;
306
307-- --------------------------------------------------------
308
309--
310-- Table structure for table `go_language`
311--
312
313DROP TABLE IF EXISTS `go_language`; CREATE TABLE `go_language` (
314 `id` int(6) UNSIGNED NOT NULL,
315 `lang` varchar(10) NOT NULL,
316 `name` varchar(100) NOT NULL,
317 `path` varchar(255) DEFAULT NULL
318) ENGINE=InnoDB DEFAULT CHARSET=utf8;
319
320-- --------------------------------------------------------
321
322--
323-- Table structure for table `go_last_login`
324--
325
326DROP TABLE IF EXISTS `go_last_login`; CREATE TABLE `go_last_login` (
327 `account_num` varchar(50) NOT NULL,
328 `event_time` datetime NOT NULL
329) ENGINE=InnoDB DEFAULT CHARSET=utf8;
330
331-- --------------------------------------------------------
332
333--
334-- Table structure for table `go_license`
335--
336
337DROP TABLE IF EXISTS `go_license`; CREATE TABLE `go_license` (
338 `id` int(11) NOT NULL,
339 `expiration_date` varchar(255) DEFAULT NULL,
340 `extent_limit` varchar(255) DEFAULT NULL,
341 `licensekey` char(255) DEFAULT NULL,
342 `VARMULTITENANT` char(255) DEFAULT NULL,
343 `VARSERVTYPE` char(255) DEFAULT NULL,
344 `VAREXTENLIMIT` char(255) DEFAULT NULL,
345 `VARSYSTEMEXTENLIMIT` char(255) DEFAULT NULL,
346 `VARREMOTEFTP` char(255) DEFAULT NULL,
347 `VARREMOTEFTPURL` char(255) DEFAULT NULL,
348 `VARBRINGOWNVOIP` char(255) DEFAULT NULL,
349 `go_licensepacakges_id` char(255) DEFAULT NULL
350) ENGINE=InnoDB DEFAULT CHARSET=utf8;
351
352-- --------------------------------------------------------
353
354--
355-- Table structure for table `go_licensepackages`
356--
357
358DROP TABLE IF EXISTS `go_licensepackages`; CREATE TABLE `go_licensepackages` (
359 `goLicensepackages_id` int(11) NOT NULL,
360 `goLicensepackage_description` varchar(255) DEFAULT NULL,
361 `goLicensepackage_page_access` varchar(400) DEFAULT NULL
362) ENGINE=InnoDB DEFAULT CHARSET=utf8;
363
364-- --------------------------------------------------------
365
366--
367-- Table structure for table `go_license_sippy_conf`
368--
369
370DROP TABLE IF EXISTS `go_license_sippy_conf`; CREATE TABLE `go_license_sippy_conf` (
371 `id` int(11) NOT NULL,
372 `VARCOMPANYGOLOGOICO` varchar(255) DEFAULT NULL,
373 `VARCOMPANYTHEMECOLOR` varchar(255) DEFAULT NULL,
374 `VARCOMPANYSUBTHEMECOLOR` varchar(255) DEFAULT NULL,
375 `VARCOMPANYSUBHOVERTHEMECOLOR` varchar(255) DEFAULT NULL,
376 `VARCOMPANYLOGO` varchar(255) DEFAULT NULL,
377 `VARCOMPANYTITLE` varchar(255) DEFAULT NULL,
378 `VARSHOWSIGNUP` varchar(255) DEFAULT NULL,
379 `VARSHOWFORGOTPASS` varchar(255) DEFAULT NULL,
380 `VARTOSURL` varchar(400) DEFAULT NULL,
381 `VARPRIVACYURL` varchar(400) DEFAULT NULL,
382 `VARLOGINLOGO` varchar(255) DEFAULT NULL,
383 `VARADMINLOGINBUTTON` varchar(255) DEFAULT NULL,
384 `VARADMINSENDBUTTON` varchar(255) DEFAULT NULL,
385 `VARGUIDELINK` varchar(400) DEFAULT NULL,
386 `VARRSSNEWSFEED` varchar(400) DEFAULT NULL,
387 `VARRSSBOARDS` varchar(400) DEFAULT NULL,
388 `VARLINKFACEBOOK` varchar(400) DEFAULT NULL,
389 `VARLINKTWITTER` varchar(400) DEFAULT NULL,
390 `VARLINKGOAUTODIAL` varchar(400) DEFAULT NULL,
391 `VARLINKENABLE` varchar(255) DEFAULT NULL,
392 `VARCLOUDCOMPANY` varchar(255) DEFAULT NULL,
393 `VARCOMPANYSEC` varchar(255) DEFAULT NULL,
394 `VARCOMPANYNAME` varchar(255) DEFAULT NULL,
395 `VARCLOUDURL` varchar(400) DEFAULT NULL,
396 `VARJUSTGOVOIP` varchar(255) DEFAULT NULL,
397 `VARSIPPYACCOUNTSURL` varchar(600) DEFAULT NULL,
398 `VARSIPPYPASSRECOVERYSUPPORTEMAIL` varchar(400) DEFAULT NULL,
399 `VARCLOUDSUPPORTURL` varchar(600) DEFAULT NULL,
400 `VARCLOUDSALESEMAIL` varchar(400) DEFAULT NULL,
401 `VARCLOUDVIOLATEEMAIL` varchar(400) DEFAULT NULL,
402 `VARCLOUDNOREPLYEMAIL` varchar(400) DEFAULT NULL,
403 `VARCLOUDSUPPORTEMAIL` varchar(400) DEFAULT NULL,
404 `VARSIGNUPEMAILCONFIRMBODY` varchar(600) DEFAULT NULL,
405 `VARAUTHREMOTEIP` varchar(255) DEFAULT NULL,
406 `VARACCOUNTFORMAT` varchar(600) DEFAULT NULL,
407 `VARCOMMISSIONAGENT` varchar(255) DEFAULT NULL,
408 `VARCOMMISIONSIZE` varchar(255) DEFAULT NULL,
409 `VARTARIFFPUBLIC` varchar(255) DEFAULT NULL,
410 `VARBILLINGPLANPUBLIC` varchar(255) DEFAULT NULL,
411 `VARACCOUNTCLASSPUBLIC` varchar(255) DEFAULT NULL,
412 `VARTARIFFCE` varchar(255) DEFAULT NULL,
413 `VARBILLINGPLANCE` varchar(255) DEFAULT NULL,
414 `VARACCOUNTCLASSCE` varchar(255) DEFAULT NULL,
415 `VAREMAILCC` varchar(255) DEFAULT NULL,
416 `VAREMAILBCC` varchar(255) DEFAULT NULL,
417 `VARRATEPERMINUTE` varchar(255) DEFAULT NULL,
418 `VARSIPPYAPIUSERGOPACKAGES` varchar(255) DEFAULT NULL,
419 `VARSIPPYAPIPASSGOPACKAGES` varchar(255) DEFAULT NULL,
420 `VARSIPPYAPIUSERGOCLOUD` varchar(255) DEFAULT NULL,
421 `VARSIPPYAPIPASSGOCLOUD` varchar(255) DEFAULT NULL,
422 `VARSIPPYXMLRPCINCFILE` varchar(600) DEFAULT NULL,
423 `VARSIPPYXMLRPCCLIENT` varchar(600) DEFAULT NULL,
424 `VARSIPPYXMLRPCHTMLFILE` varchar(600) DEFAULT NULL,
425 `VARAGENTTITLEBAR` varchar(255) DEFAULT NULL,
426 `VARAGENTLOGOBIG` varchar(400) DEFAULT NULL,
427 `VARAGENTLOGOSMALL` varchar(400) DEFAULT NULL,
428 `VARAGENTTHEMECOLOR` varchar(255) DEFAULT NULL,
429 `VARAGENTLOGINBUTTON` varchar(255) DEFAULT NULL,
430 `VARAGENTCAMPREFRESH` varchar(255) DEFAULT NULL,
431 `VARTABLEODDCOLOR` varchar(255) DEFAULT NULL,
432 `VARTABLEEVENCOLOR` varchar(255) DEFAULT NULL
433) ENGINE=InnoDB DEFAULT CHARSET=utf8;
434
435-- --------------------------------------------------------
436
437--
438-- Table structure for table `go_login_type`
439--
440
441DROP TABLE IF EXISTS `go_login_type`; CREATE TABLE `go_login_type` (
442 `account_num` varchar(20) NOT NULL,
443 `type` enum('0','1') NOT NULL DEFAULT '1',
444 `new_signup` enum('0','1') NOT NULL DEFAULT '0'
445) ENGINE=InnoDB DEFAULT CHARSET=utf8;
446
447-- --------------------------------------------------------
448
449--
450-- Table structure for table `go_multi_tenant`
451--
452
453DROP TABLE IF EXISTS `go_multi_tenant`; CREATE TABLE `go_multi_tenant` (
454 `tenant_id` varchar(20) NOT NULL,
455 `tenant_name` varchar(40) DEFAULT NULL,
456 `admin` varchar(20) NOT NULL,
457 `pass` varchar(20) NOT NULL,
458 `active` enum('Y','N') NOT NULL DEFAULT 'Y',
459 `access_call_times` enum('Y','N') NOT NULL DEFAULT 'N',
460 `access_carriers` enum('Y','N') NOT NULL DEFAULT 'N',
461 `access_phones` enum('Y','N') NOT NULL DEFAULT 'N',
462 `access_voicemails` enum('Y','N') NOT NULL DEFAULT 'N',
463 `phone_count` int(10) DEFAULT NULL
464) ENGINE=InnoDB DEFAULT CHARSET=utf8;
465
466-- --------------------------------------------------------
467
468--
469-- Table structure for table `go_notifications`
470--
471
472DROP TABLE IF EXISTS `go_notifications`; CREATE TABLE `go_notifications` (
473 `id` int(11) NOT NULL,
474 `user` varchar(20) NOT NULL,
475 `notification` varchar(30) NOT NULL,
476 `title` varchar(100) NOT NULL,
477 `message` text NOT NULL,
478 `type` varchar(30) NOT NULL DEFAULT 'SYSTEM',
479 `status` varchar(20) NOT NULL DEFAULT 'UNCLICKED'
480) ENGINE=InnoDB DEFAULT CHARSET=utf8;
481
482-- --------------------------------------------------------
483
484--
485-- Table structure for table `go_recordings`
486--
487
488DROP TABLE IF EXISTS `go_recordings`; CREATE TABLE `go_recordings` (
489 `recording_id` int(10) NOT NULL,
490 `start_time` datetime DEFAULT NULL,
491 `mimetype` varchar(30) CHARACTER SET utf8 DEFAULT NULL,
492 `data` longtext CHARACTER SET utf8
493) ENGINE=InnoDB DEFAULT CHARSET=latin1;
494
495-- --------------------------------------------------------
496
497--
498-- Table structure for table `go_recording_access`
499--
500
501DROP TABLE IF EXISTS `go_recording_access`; CREATE TABLE `go_recording_access` (
502 `access_id` int(20) UNSIGNED NOT NULL,
503 `ip_address` varchar(200) DEFAULT NULL,
504 `ip_block_list` varchar(200) DEFAULT NULL,
505 `folder` varchar(255) DEFAULT NULL,
506 `folder_alias` varchar(255) DEFAULT NULL,
507 `active` enum('N','Y') DEFAULT 'N'
508) ENGINE=InnoDB DEFAULT CHARSET=latin1;
509
510-- --------------------------------------------------------
511
512--
513-- Table structure for table `go_remember`
514--
515
516DROP TABLE IF EXISTS `go_remember`; CREATE TABLE `go_remember` (
517 `id` int(11) NOT NULL,
518 `username` varchar(16) DEFAULT NULL,
519 `usernamehash` varchar(128) DEFAULT NULL,
520 `random_string` varchar(128) DEFAULT NULL,
521 `origin_time` int(11) NOT NULL,
522 `ip_address` varchar(15) DEFAULT '0.0.0.0'
523) ENGINE=InnoDB DEFAULT CHARSET=utf8;
524
525-- --------------------------------------------------------
526
527--
528-- Table structure for table `go_server_settings`
529--
530
531DROP TABLE IF EXISTS `go_server_settings`; CREATE TABLE `go_server_settings` (
532 `username` varchar(20) NOT NULL,
533 `company_name` varchar(100) NOT NULL,
534 `company_logo` varchar(100) NOT NULL,
535 `theme_color` varchar(50) NOT NULL,
536 `login_color` varchar(50) NOT NULL,
537 `login_button` varchar(100) NOT NULL
538) ENGINE=InnoDB DEFAULT CHARSET=utf8;
539
540-- --------------------------------------------------------
541
542--
543-- Table structure for table `go_sessions`
544--
545
546DROP TABLE IF EXISTS `go_sessions`; CREATE TABLE `go_sessions` (
547 `session_id` varchar(40) NOT NULL DEFAULT '0',
548 `ip_address` varchar(16) NOT NULL DEFAULT '0',
549 `user_agent` varchar(50) NOT NULL,
550 `last_activity` int(10) UNSIGNED NOT NULL DEFAULT '0',
551 `user_data` text NOT NULL
552) ENGINE=InnoDB DEFAULT CHARSET=utf8;
553
554-- --------------------------------------------------------
555
556--
557-- Table structure for table `go_sounds`
558--
559
560DROP TABLE IF EXISTS `go_sounds`; CREATE TABLE `go_sounds` (
561 `goSound_id` int(10) NOT NULL,
562 `type` varchar(30) DEFAULT NULL,
563 `data` text
564) ENGINE=InnoDB DEFAULT CHARSET=latin1;
565
566-- --------------------------------------------------------
567
568--
569-- Table structure for table `go_sysbackup_access`
570--
571
572DROP TABLE IF EXISTS `go_sysbackup_access`; CREATE TABLE `go_sysbackup_access` (
573 `access_id` int(20) UNSIGNED NOT NULL,
574 `ip_address` varchar(200) DEFAULT NULL,
575 `ip_block_list` varchar(200) DEFAULT NULL,
576 `folder` varchar(255) DEFAULT NULL,
577 `folder_alias` varchar(255) DEFAULT NULL,
578 `active` enum('N','Y') DEFAULT 'N'
579) ENGINE=InnoDB DEFAULT CHARSET=latin1;
580
581-- --------------------------------------------------------
582
583--
584-- Table structure for table `go_users`
585--
586
587DROP TABLE IF EXISTS `go_users`; CREATE TABLE `go_users` (
588 `user_id` int(20) UNSIGNED NOT NULL,
589 `user_name` varchar(20) NOT NULL,
590 `user_pass` varchar(100) NOT NULL,
591 `user_fname` varchar(50) DEFAULT NULL,
592 `user_lname` varchar(50) DEFAULT NULL,
593 `user_mname` varchar(50) DEFAULT NULL,
594 `user_email` varchar(50) DEFAULT NULL,
595 `user_level` int(1) DEFAULT '1',
596 `user_group` varchar(50) DEFAULT 'Users',
597 `user_enabled` enum('N','Y') DEFAULT 'Y'
598) ENGINE=InnoDB DEFAULT CHARSET=latin1;
599
600-- --------------------------------------------------------
601
602--
603-- Table structure for table `go_widget_position`
604--
605
606DROP TABLE IF EXISTS `go_widget_position`; CREATE TABLE `go_widget_position` (
607 `id` int(11) NOT NULL,
608 `user_id` varchar(50) NOT NULL,
609 `html_id` varchar(50) DEFAULT NULL,
610 `left_html` text COLLATE utf8_unicode_ci,
611 `right_html` text COLLATE utf8_unicode_ci,
612 `today_status` enum('Y','N') NOT NULL DEFAULT 'Y',
613 `server_statistics` enum('Y','N') NOT NULL DEFAULT 'Y',
614 `dashboard_controls` enum('Y','N') NOT NULL DEFAULT 'Y',
615 `dashboard_accounts-hide` enum('Y','N') NOT NULL DEFAULT 'Y',
616 `agent_status` enum('Y','N') NOT NULL DEFAULT 'Y',
617 `plugins` enum('Y','N') NOT NULL DEFAULT 'Y',
618 `go_analytics` enum('Y','N') NOT NULL DEFAULT 'Y',
619 `goautodial_news` enum('Y','N') NOT NULL DEFAULT 'Y',
620 `goautodial_forum` enum('Y','N') NOT NULL DEFAULT 'Y',
621 `walk` enum('Y','N') NOT NULL DEFAULT 'Y',
622 `nextlog` enum('Y','N') NOT NULL DEFAULT 'Y',
623 `account_info` enum('Y','N') NOT NULL DEFAULT 'Y',
624 `agents_and_phones` enum('Y','N') NOT NULL DEFAULT 'Y',
625 `dashboard_goautodial_forum` enum('Y','N') NOT NULL DEFAULT 'Y',
626 `dashboard_goautodial_news` enum('Y','N') NOT NULL DEFAULT 'Y',
627 `dashboard_analytics` enum('Y','N') NOT NULL DEFAULT 'Y',
628 `dashboard_plugins` enum('Y','N') NOT NULL DEFAULT 'Y',
629 `dashboard_clusters` enum('Y','N') NOT NULL DEFAULT 'Y'
630) ENGINE=InnoDB DEFAULT CHARSET=utf8;
631
632-- --------------------------------------------------------
633
634--
635-- Table structure for table `justgovoip_sippy_info`
636--
637
638DROP TABLE IF EXISTS `justgovoip_sippy_info`; CREATE TABLE `justgovoip_sippy_info` (
639 `carrier_id` varchar(15) NOT NULL,
640 `username` varchar(100) NOT NULL,
641 `web_password` varchar(100) NOT NULL,
642 `authname` varchar(100) NOT NULL,
643 `voip_password` varchar(100) NOT NULL,
644 `vm_password` varchar(250) DEFAULT NULL,
645 `i_account` int(11) NOT NULL
646) ENGINE=InnoDB DEFAULT CHARSET=utf8;
647
648-- --------------------------------------------------------
649
650--
651-- Table structure for table `lime_surveys`
652--
653
654DROP TABLE IF EXISTS `lime_surveys`; CREATE TABLE `lime_surveys` (
655 `sid` int(11) NOT NULL,
656 `owner_id` int(11) NOT NULL,
657 `admin` varchar(50) DEFAULT NULL,
658 `active` char(1) NOT NULL DEFAULT 'N',
659 `expires` datetime DEFAULT NULL,
660 `startdate` datetime DEFAULT NULL,
661 `adminemail` varchar(320) DEFAULT NULL,
662 `anonymized` char(1) NOT NULL DEFAULT 'N',
663 `faxto` varchar(20) DEFAULT NULL,
664 `format` char(1) DEFAULT NULL,
665 `savetimings` char(1) DEFAULT 'N',
666 `template` varchar(100) DEFAULT 'default',
667 `language` varchar(50) DEFAULT NULL,
668 `additional_languages` varchar(255) DEFAULT NULL,
669 `datestamp` char(1) DEFAULT 'N',
670 `usecookie` char(1) DEFAULT 'N',
671 `allowregister` char(1) DEFAULT 'N',
672 `allowsave` char(1) DEFAULT 'Y',
673 `autonumber_start` bigint(11) DEFAULT '0',
674 `autoredirect` char(1) DEFAULT 'N',
675 `allowprev` char(1) DEFAULT 'Y',
676 `printanswers` char(1) DEFAULT 'N',
677 `ipaddr` char(1) DEFAULT 'N',
678 `refurl` char(1) DEFAULT 'N',
679 `datecreated` date DEFAULT NULL,
680 `publicstatistics` char(1) DEFAULT 'N',
681 `publicgraphs` char(1) DEFAULT 'N',
682 `listpublic` char(1) DEFAULT 'N',
683 `htmlemail` char(1) DEFAULT 'N',
684 `tokenanswerspersistence` char(1) DEFAULT 'N',
685 `assessments` char(1) DEFAULT 'N',
686 `usecaptcha` char(1) DEFAULT 'N',
687 `usetokens` char(1) DEFAULT 'N',
688 `bounce_email` varchar(320) DEFAULT NULL,
689 `attributedescriptions` text COLLATE utf8_unicode_ci,
690 `emailresponseto` text COLLATE utf8_unicode_ci,
691 `emailnotificationto` text COLLATE utf8_unicode_ci,
692 `tokenlength` tinyint(2) DEFAULT '15',
693 `showxquestions` char(1) NOT NULL DEFAULT 'Y',
694 `showgroupinfo` char(1) DEFAULT 'B',
695 `shownoanswer` char(1) DEFAULT 'Y',
696 `showqnumcode` char(1) DEFAULT 'X',
697 `bouncetime` bigint(20) DEFAULT NULL,
698 `bounceprocessing` varchar(1) DEFAULT 'N',
699 `bounceaccounttype` varchar(4) DEFAULT NULL,
700 `bounceaccounthost` varchar(200) DEFAULT NULL,
701 `bounceaccountpass` varchar(100) DEFAULT NULL,
702 `bounceaccountencryption` varchar(3) DEFAULT NULL,
703 `bounceaccountuser` varchar(200) DEFAULT NULL,
704 `showwelcome` char(1) DEFAULT 'Y',
705 `showprogress` char(1) DEFAULT 'Y',
706 `allowjumps` char(1) DEFAULT 'N',
707 `navigationdelay` tinyint(2) DEFAULT '0',
708 `nokeyboard` char(1) DEFAULT 'N',
709 `alloweditaftercompletion` char(1) DEFAULT 'N',
710 `googleanalyticsstyle` char(1) DEFAULT NULL,
711 `googleanalyticsapikey` varchar(25) DEFAULT NULL
712) ENGINE=InnoDB DEFAULT CHARSET=utf8;
713
714-- --------------------------------------------------------
715
716--
717-- Table structure for table `marital_status`
718--
719
720DROP TABLE IF EXISTS `marital_status`; CREATE TABLE `marital_status` (
721 `id` int(11) NOT NULL,
722 `name` varchar(255) NOT NULL
723) ENGINE=InnoDB DEFAULT CHARSET=utf8;
724
725-- --------------------------------------------------------
726
727--
728-- Table structure for table `messages_inbox`
729--
730
731DROP TABLE IF EXISTS `messages_inbox`; CREATE TABLE `messages_inbox` (
732 `id` int(11) NOT NULL,
733 `user_from` int(11) NOT NULL,
734 `user_to` int(11) NOT NULL,
735 `subject` varchar(255) NOT NULL,
736 `message` longtext,
737 `date` datetime NOT NULL,
738 `message_read` int(1) NOT NULL,
739 `favorite` int(1) NOT NULL DEFAULT '0'
740) ENGINE=InnoDB DEFAULT CHARSET=utf8;
741
742-- --------------------------------------------------------
743
744--
745-- Table structure for table `messages_junk`
746--
747
748DROP TABLE IF EXISTS `messages_junk`; CREATE TABLE `messages_junk` (
749 `id` int(11) NOT NULL,
750 `user_from` int(11) NOT NULL,
751 `user_to` int(11) NOT NULL,
752 `subject` varchar(255) NOT NULL,
753 `message` longtext,
754 `date` datetime NOT NULL,
755 `message_read` int(1) NOT NULL,
756 `favorite` int(1) NOT NULL DEFAULT '0',
757 `origin_folder` varchar(255) NOT NULL
758) ENGINE=InnoDB DEFAULT CHARSET=utf8;
759
760-- --------------------------------------------------------
761
762--
763-- Table structure for table `messages_outbox`
764--
765
766DROP TABLE IF EXISTS `messages_outbox`; CREATE TABLE `messages_outbox` (
767 `id` int(11) NOT NULL,
768 `user_from` int(11) NOT NULL,
769 `user_to` int(11) NOT NULL,
770 `subject` varchar(255) NOT NULL,
771 `message` longtext,
772 `date` datetime NOT NULL,
773 `message_read` int(1) NOT NULL,
774 `favorite` int(1) NOT NULL DEFAULT '0'
775) ENGINE=InnoDB DEFAULT CHARSET=utf8;
776
777-- --------------------------------------------------------
778
779--
780-- Table structure for table `module_MessageOfTheDay`
781--
782
783DROP TABLE IF EXISTS `module_MessageOfTheDay`; CREATE TABLE `module_MessageOfTheDay` (
784 `id` int(11) NOT NULL,
785 `customer_id` int(11) NOT NULL,
786 `customer_type` varchar(255) NOT NULL,
787 `favorite_quote` text
788) ENGINE=InnoDB DEFAULT CHARSET=utf8;
789
790-- --------------------------------------------------------
791
792--
793-- Table structure for table `notifications`
794--
795
796DROP TABLE IF EXISTS `notifications`; CREATE TABLE `notifications` (
797 `id` int(11) NOT NULL,
798 `target_user` int(11) DEFAULT NULL,
799 `text` varchar(512) NOT NULL,
800 `date` datetime NOT NULL,
801 `action` varchar(255) DEFAULT NULL,
802 `type` varchar(255) NOT NULL
803) ENGINE=InnoDB DEFAULT CHARSET=utf8;
804
805-- --------------------------------------------------------
806
807--
808-- Table structure for table `settings`
809--
810
811DROP TABLE IF EXISTS `settings`; CREATE TABLE `settings` (
812 `id` int(11) NOT NULL,
813 `setting` varchar(255) NOT NULL,
814 `context` varchar(255) NOT NULL,
815 `value` longtext
816) ENGINE=InnoDB DEFAULT CHARSET=utf8;
817
818--
819-- Dumping data for table `settings`
820--
821
822INSERT INTO `settings` (`id`, `setting`, `context`, `value`) VALUES
823(1, 'base_url', 'creamy', 'vaglxc01.goautodial.com'),
824(2, 'admin_user', 'creamy', '1'),
825(3, 'crm_version', 'creamy', '1.0'),
826(4, 'installation_date', 'creamy', '2016-01-26 19:16:55'),
827(5, 'module_system_enabled', 'creamy', '1'),
828(6, 'statistics_system_enabled', 'creamy', '1'),
829(7, 'notification_email_events', 'creamy', '1'),
830(8, 'job_scheduling_min_freq', 'creamy', NULL),
831(9, 'active_modules', 'creamy', 'GOagent'),
832(10, 'customer_list_fields', 'creamy', 'id,name,email,phone,id_number'),
833(11, 'timezone', 'creamy', 'Asia/Manila'),
834(12, 'locale', 'creamy', 'en_US'),
835(13, 'security_token', 'creamy', 'en_US'),
836(14, 'confirmation_email', 'creamy', '0'),
837(15, 'theme', 'creamy', 'black'),
838(16, 'company_name', 'creamy', 'GOautodial Inc'),
839(17, 'company_logo', 'creamy', 'img/customCompanyLogo.png'),
840(18, 'GO_agent_url', 'module_GOautodialAgentDialer', 'http://127.0.0.1'),
841(19, 'GO_agent_db', 'module_GOautodialAgentDialer', ''),
842(20, 'GO_agent_user', 'module_GOautodialAgentDialer', 'admin'),
843(21, 'GO_agent_pass', 'module_GOautodialAgentDialer', 'G02x16'),
844(22, 'GO_agent_wss', 'module_GOautodialAgentDialer', 'vaglxc01.goautodial.com'),
845(23, 'GO_agent_sip_server', 'module_GOautodialAgentDialer', 'kamailio'),
846(24, 'GO_agent_wss_port', 'module_GOautodialAgentDialer', '4443'),
847(25, 'GO_agent_wss_sip', 'module_GOautodialAgentDialer', 'vaglxc01.goautodial.com'),
848(26, 'GO_agent_wss_sip_port', 'module_GOautodialAgentDialer', '5060'),
849(27, 'GO_agent_use_wss', 'module_GOautodialAgentDialer', '1'),
850(28, 'GO_show_phones', 'module_GOautodialAgentDialer', '1'),
851(29, 'GO_agent_domain', 'module_GOautodialAgentDialer', 'vaglxc01.goautodial.com'),
852(30, 'enable_smtp', 'smtp_settings', '1'),
853(31, 'google_api_key', 'creamy', ''),
854(32, 'slave_db_ip', 'creamy', '');
855
856-- --------------------------------------------------------
857
858--
859-- Table structure for table `smtp_settings`
860--
861
862DROP TABLE IF EXISTS `smtp_settings`; CREATE TABLE `smtp_settings` (
863 `debug` int(1) DEFAULT NULL,
864 `timezone` varchar(250) DEFAULT NULL,
865 `ipv6_support` int(1) DEFAULT NULL,
866 `host` varchar(120) DEFAULT NULL,
867 `port` int(4) DEFAULT NULL,
868 `smtp_security` varchar(3) DEFAULT NULL,
869 `smtp_auth` int(1) DEFAULT NULL,
870 `username` varchar(120) DEFAULT NULL,
871 `password` varchar(120) DEFAULT NULL
872) ENGINE=InnoDB DEFAULT CHARSET=latin1;
873
874-- --------------------------------------------------------
875
876--
877-- Table structure for table `sounds`
878--
879
880DROP TABLE IF EXISTS `sounds`; CREATE TABLE `sounds` (
881 `goSound_id` int(10) NOT NULL,
882 `goFilename` varchar(120) DEFAULT NULL,
883 `goDirectory` varchar(120) DEFAULT NULL,
884 `goFileDate` datetime DEFAULT NULL,
885 `goFilesize` varchar(20) DEFAULT NULL,
886 `uploaded_by` varchar(20) DEFAULT NULL
887) ENGINE=InnoDB DEFAULT CHARSET=latin1;
888
889-- --------------------------------------------------------
890
891--
892-- Table structure for table `statistics`
893--
894
895DROP TABLE IF EXISTS `statistics`; CREATE TABLE `statistics` (
896 `id` int(11) NOT NULL,
897 `timestamp` datetime NOT NULL,
898 `clients_1` int(11) NOT NULL DEFAULT '0',
899 `clients_2` int(11) NOT NULL DEFAULT '0'
900) ENGINE=InnoDB DEFAULT CHARSET=utf8;
901
902-- --------------------------------------------------------
903
904--
905-- Table structure for table `tasks`
906--
907
908DROP TABLE IF EXISTS `tasks`; CREATE TABLE `tasks` (
909 `id` int(11) NOT NULL,
910 `title` varchar(50) CHARACTER SET utf8 NOT NULL,
911 `description` varchar(512) NOT NULL,
912 `user_id` int(11) NOT NULL,
913 `target_customer_id` int(11) DEFAULT NULL,
914 `creation_date` datetime NOT NULL,
915 `completion_date` datetime DEFAULT NULL,
916 `completed` int(3) NOT NULL
917) ENGINE=InnoDB DEFAULT CHARSET=utf8;
918
919-- --------------------------------------------------------
920
921--
922-- Table structure for table `timeline`
923--
924
925DROP TABLE IF EXISTS `timeline`; CREATE TABLE `timeline` (
926 `id` int(11) NOT NULL,
927 `type_id` int(11) NOT NULL,
928 `type` varchar(50) NOT NULL,
929 `user_id` varchar(16) NOT NULL,
930 `user_from_id` varchar(16) NOT NULL,
931 `title` varchar(50) NOT NULL,
932 `start_date` datetime NOT NULL,
933 `end_date` datetime NOT NULL,
934 `description` longtext COLLATE utf8_unicode_ci
935) ENGINE=InnoDB DEFAULT CHARSET=utf8;
936
937-- --------------------------------------------------------
938
939--
940-- Table structure for table `users`
941--
942
943DROP TABLE IF EXISTS `users`; CREATE TABLE `users` (
944 `id` int(11) NOT NULL,
945 `userid` int(10) DEFAULT NULL,
946 `name` varchar(255) NOT NULL,
947 `fullname` varchar(50) DEFAULT NULL,
948 `password_hash` varchar(255) NOT NULL,
949 `phone` varchar(255) DEFAULT NULL,
950 `email` varchar(255) DEFAULT NULL,
951 `avatar` longtext,
952 `creation_date` datetime NOT NULL,
953 `user_group` varchar(20) DEFAULT NULL,
954 `role` int(4) NOT NULL,
955 `status` enum('1','0') CHARACTER SET latin1 NOT NULL DEFAULT '0',
956 `gcal` enum('0','1') NOT NULL DEFAULT '0',
957 `calendar_apikey` varchar(255) DEFAULT NULL,
958 `calendar_id` varchar(255) DEFAULT NULL
959) ENGINE=InnoDB DEFAULT CHARSET=utf8;
960
961-- --------------------------------------------------------
962
963--
964-- Table structure for table `user_access_group`
965--
966
967DROP TABLE IF EXISTS `user_access_group`; CREATE TABLE `user_access_group` (
968 `id` int(11) NOT NULL,
969 `user_group` varchar(250) NOT NULL,
970 `permissions` text NOT NULL,
971 `group_level` int(11) NOT NULL,
972 `date_create` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
973 `allowed_campaigns` text COLLATE utf8_unicode_ci,
974 `group_list_id` bigint(14) DEFAULT NULL
975) ENGINE=InnoDB DEFAULT CHARSET=utf8;
976
977--
978-- Dumping data for table `user_access_group`
979--
980
981INSERT INTO `user_access_group` (`id`, `user_group`, `permissions`, `group_level`, `date_create`, `allowed_campaigns`, `group_list_id`) VALUES
982(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),
983(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),
984(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),
985(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);
986
987--
988-- Indexes for dumped tables
989--
990
991--
992-- Indexes for table `attachments`
993--
994ALTER TABLE `attachments`
995 ADD PRIMARY KEY (`id`);
996
997--
998-- Indexes for table `clients_1`
999--
1000ALTER TABLE `clients_1`
1001 ADD PRIMARY KEY (`id`),
1002 ADD KEY `Unique unique_name` (`name`,`id_number`,`email`);
1003
1004--
1005-- Indexes for table `clients_2`
1006--
1007ALTER TABLE `clients_2`
1008 ADD PRIMARY KEY (`id`),
1009 ADD KEY `Unique unique_name` (`name`,`id_number`,`email`);
1010
1011--
1012-- Indexes for table `customer_types`
1013--
1014ALTER TABLE `customer_types`
1015 ADD PRIMARY KEY (`id`);
1016
1017--
1018-- Indexes for table `events`
1019--
1020ALTER TABLE `events`
1021 ADD PRIMARY KEY (`id`);
1022
1023--
1024-- Indexes for table `go_action_logs`
1025--
1026ALTER TABLE `go_action_logs`
1027 ADD PRIMARY KEY (`id`);
1028
1029--
1030-- Indexes for table `go_agent_sessions`
1031--
1032ALTER TABLE `go_agent_sessions`
1033 ADD PRIMARY KEY (`agent_session_id`);
1034
1035--
1036-- Indexes for table `go_avatars`
1037--
1038ALTER TABLE `go_avatars`
1039 ADD PRIMARY KEY (`user_id`);
1040
1041--
1042-- Indexes for table `go_callback_lists`
1043--
1044ALTER TABLE `go_callback_lists`
1045 ADD PRIMARY KEY (`id`);
1046
1047--
1048-- Indexes for table `go_campaigns`
1049--
1050ALTER TABLE `go_campaigns`
1051 ADD PRIMARY KEY (`id`);
1052
1053--
1054-- Indexes for table `go_customers`
1055--
1056ALTER TABLE `go_customers`
1057 ADD PRIMARY KEY (`cust_id`);
1058
1059--
1060-- Indexes for table `go_dropbox`
1061--
1062ALTER TABLE `go_dropbox`
1063 ADD PRIMARY KEY (`dropID`);
1064
1065--
1066-- Indexes for table `go_firewall_blocklist`
1067--
1068ALTER TABLE `go_firewall_blocklist`
1069 ADD PRIMARY KEY (`block_id`);
1070
1071--
1072-- Indexes for table `go_firewall_interfaces`
1073--
1074ALTER TABLE `go_firewall_interfaces`
1075 ADD PRIMARY KEY (`interface_id`);
1076
1077--
1078-- Indexes for table `go_firewall_rules`
1079--
1080ALTER TABLE `go_firewall_rules`
1081 ADD PRIMARY KEY (`rule_id`);
1082
1083--
1084-- Indexes for table `go_firewall_whitelist`
1085--
1086ALTER TABLE `go_firewall_whitelist`
1087 ADD PRIMARY KEY (`white_id`);
1088
1089--
1090-- Indexes for table `go_language`
1091--
1092ALTER TABLE `go_language`
1093 ADD PRIMARY KEY (`id`);
1094
1095--
1096-- Indexes for table `go_last_login`
1097--
1098ALTER TABLE `go_last_login`
1099 ADD PRIMARY KEY (`account_num`);
1100
1101--
1102-- Indexes for table `go_license`
1103--
1104ALTER TABLE `go_license`
1105 ADD PRIMARY KEY (`id`);
1106
1107--
1108-- Indexes for table `go_licensepackages`
1109--
1110ALTER TABLE `go_licensepackages`
1111 ADD PRIMARY KEY (`goLicensepackages_id`);
1112
1113--
1114-- Indexes for table `go_license_sippy_conf`
1115--
1116ALTER TABLE `go_license_sippy_conf`
1117 ADD PRIMARY KEY (`id`);
1118
1119--
1120-- Indexes for table `go_login_type`
1121--
1122ALTER TABLE `go_login_type`
1123 ADD KEY `account_num` (`account_num`);
1124
1125--
1126-- Indexes for table `go_multi_tenant`
1127--
1128ALTER TABLE `go_multi_tenant`
1129 ADD KEY `tenant_id` (`tenant_id`);
1130
1131--
1132-- Indexes for table `go_notifications`
1133--
1134ALTER TABLE `go_notifications`
1135 ADD PRIMARY KEY (`id`);
1136
1137--
1138-- Indexes for table `go_recordings`
1139--
1140ALTER TABLE `go_recordings`
1141 ADD PRIMARY KEY (`recording_id`);
1142
1143--
1144-- Indexes for table `go_recording_access`
1145--
1146ALTER TABLE `go_recording_access`
1147 ADD PRIMARY KEY (`access_id`);
1148
1149--
1150-- Indexes for table `go_remember`
1151--
1152ALTER TABLE `go_remember`
1153 ADD PRIMARY KEY (`id`);
1154
1155--
1156-- Indexes for table `go_sessions`
1157--
1158ALTER TABLE `go_sessions`
1159 ADD PRIMARY KEY (`session_id`);
1160
1161--
1162-- Indexes for table `go_sounds`
1163--
1164ALTER TABLE `go_sounds`
1165 ADD KEY `goSound_id` (`goSound_id`);
1166
1167--
1168-- Indexes for table `go_sysbackup_access`
1169--
1170ALTER TABLE `go_sysbackup_access`
1171 ADD PRIMARY KEY (`access_id`);
1172
1173--
1174-- Indexes for table `go_users`
1175--
1176ALTER TABLE `go_users`
1177 ADD PRIMARY KEY (`user_id`);
1178
1179--
1180-- Indexes for table `go_widget_position`
1181--
1182ALTER TABLE `go_widget_position`
1183 ADD PRIMARY KEY (`id`);
1184
1185--
1186-- Indexes for table `lime_surveys`
1187--
1188ALTER TABLE `lime_surveys`
1189 ADD PRIMARY KEY (`sid`);
1190
1191--
1192-- Indexes for table `marital_status`
1193--
1194ALTER TABLE `marital_status`
1195 ADD PRIMARY KEY (`id`);
1196
1197--
1198-- Indexes for table `messages_inbox`
1199--
1200ALTER TABLE `messages_inbox`
1201 ADD PRIMARY KEY (`id`);
1202
1203--
1204-- Indexes for table `messages_junk`
1205--
1206ALTER TABLE `messages_junk`
1207 ADD PRIMARY KEY (`id`);
1208
1209--
1210-- Indexes for table `messages_outbox`
1211--
1212ALTER TABLE `messages_outbox`
1213 ADD PRIMARY KEY (`id`);
1214
1215--
1216-- Indexes for table `module_MessageOfTheDay`
1217--
1218ALTER TABLE `module_MessageOfTheDay`
1219 ADD PRIMARY KEY (`id`);
1220
1221--
1222-- Indexes for table `notifications`
1223--
1224ALTER TABLE `notifications`
1225 ADD PRIMARY KEY (`id`);
1226
1227--
1228-- Indexes for table `settings`
1229--
1230ALTER TABLE `settings`
1231 ADD PRIMARY KEY (`id`),
1232 ADD KEY `Unique unique_name` (`setting`,`context`);
1233
1234--
1235-- Indexes for table `sounds`
1236--
1237ALTER TABLE `sounds`
1238 ADD PRIMARY KEY (`goSound_id`);
1239
1240--
1241-- Indexes for table `statistics`
1242--
1243ALTER TABLE `statistics`
1244 ADD PRIMARY KEY (`id`);
1245
1246--
1247-- Indexes for table `tasks`
1248--
1249ALTER TABLE `tasks`
1250 ADD PRIMARY KEY (`id`);
1251
1252--
1253-- Indexes for table `timeline`
1254--
1255ALTER TABLE `timeline`
1256 ADD PRIMARY KEY (`id`);
1257
1258--
1259-- Indexes for table `users`
1260--
1261ALTER TABLE `users`
1262 ADD PRIMARY KEY (`id`),
1263 ADD KEY `Unique unique_name` (`name`,`email`);
1264
1265--
1266-- Indexes for table `user_access_group`
1267--
1268ALTER TABLE `user_access_group`
1269 ADD PRIMARY KEY (`id`);
1270
1271--
1272-- AUTO_INCREMENT for dumped tables
1273--
1274
1275--
1276-- AUTO_INCREMENT for table `attachments`
1277--
1278ALTER TABLE `attachments`
1279 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1280
1281--
1282-- AUTO_INCREMENT for table `clients_1`
1283--
1284ALTER TABLE `clients_1`
1285 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1286
1287--
1288-- AUTO_INCREMENT for table `clients_2`
1289--
1290ALTER TABLE `clients_2`
1291 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1292
1293--
1294-- AUTO_INCREMENT for table `customer_types`
1295--
1296ALTER TABLE `customer_types`
1297 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1298
1299--
1300-- AUTO_INCREMENT for table `events`
1301--
1302ALTER TABLE `events`
1303 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1304
1305--
1306-- AUTO_INCREMENT for table `go_action_logs`
1307--
1308ALTER TABLE `go_action_logs`
1309 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1310
1311--
1312-- AUTO_INCREMENT for table `go_agent_sessions`
1313--
1314ALTER TABLE `go_agent_sessions`
1315 MODIFY `agent_session_id` int(11) NOT NULL AUTO_INCREMENT;
1316
1317--
1318-- AUTO_INCREMENT for table `go_callback_lists`
1319--
1320ALTER TABLE `go_callback_lists`
1321 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1322
1323--
1324-- AUTO_INCREMENT for table `go_campaigns`
1325--
1326ALTER TABLE `go_campaigns`
1327 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1328
1329--
1330-- AUTO_INCREMENT for table `go_customers`
1331--
1332ALTER TABLE `go_customers`
1333 MODIFY `cust_id` int(9) UNSIGNED NOT NULL AUTO_INCREMENT;
1334
1335--
1336-- AUTO_INCREMENT for table `go_dropbox`
1337--
1338ALTER TABLE `go_dropbox`
1339 MODIFY `dropID` int(10) NOT NULL AUTO_INCREMENT;
1340
1341--
1342-- AUTO_INCREMENT for table `go_firewall_blocklist`
1343--
1344ALTER TABLE `go_firewall_blocklist`
1345 MODIFY `block_id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT;
1346
1347--
1348-- AUTO_INCREMENT for table `go_firewall_interfaces`
1349--
1350ALTER TABLE `go_firewall_interfaces`
1351 MODIFY `interface_id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT;
1352
1353--
1354-- AUTO_INCREMENT for table `go_firewall_rules`
1355--
1356ALTER TABLE `go_firewall_rules`
1357 MODIFY `rule_id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT;
1358
1359--
1360-- AUTO_INCREMENT for table `go_firewall_whitelist`
1361--
1362ALTER TABLE `go_firewall_whitelist`
1363 MODIFY `white_id` int(20) NOT NULL AUTO_INCREMENT;
1364
1365--
1366-- AUTO_INCREMENT for table `go_language`
1367--
1368ALTER TABLE `go_language`
1369 MODIFY `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT;
1370
1371--
1372-- AUTO_INCREMENT for table `go_license`
1373--
1374ALTER TABLE `go_license`
1375 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1376
1377--
1378-- AUTO_INCREMENT for table `go_licensepackages`
1379--
1380ALTER TABLE `go_licensepackages`
1381 MODIFY `goLicensepackages_id` int(11) NOT NULL AUTO_INCREMENT;
1382
1383--
1384-- AUTO_INCREMENT for table `go_license_sippy_conf`
1385--
1386ALTER TABLE `go_license_sippy_conf`
1387 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1388
1389--
1390-- AUTO_INCREMENT for table `go_notifications`
1391--
1392ALTER TABLE `go_notifications`
1393 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1394
1395--
1396-- AUTO_INCREMENT for table `go_recording_access`
1397--
1398ALTER TABLE `go_recording_access`
1399 MODIFY `access_id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT;
1400
1401--
1402-- AUTO_INCREMENT for table `go_remember`
1403--
1404ALTER TABLE `go_remember`
1405 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1406
1407--
1408-- AUTO_INCREMENT for table `go_sounds`
1409--
1410ALTER TABLE `go_sounds`
1411 MODIFY `goSound_id` int(10) NOT NULL AUTO_INCREMENT;
1412
1413--
1414-- AUTO_INCREMENT for table `go_sysbackup_access`
1415--
1416ALTER TABLE `go_sysbackup_access`
1417 MODIFY `access_id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT;
1418
1419--
1420-- AUTO_INCREMENT for table `go_users`
1421--
1422ALTER TABLE `go_users`
1423 MODIFY `user_id` int(20) UNSIGNED NOT NULL AUTO_INCREMENT;
1424
1425--
1426-- AUTO_INCREMENT for table `go_widget_position`
1427--
1428ALTER TABLE `go_widget_position`
1429 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1430
1431--
1432-- AUTO_INCREMENT for table `marital_status`
1433--
1434ALTER TABLE `marital_status`
1435 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1436
1437--
1438-- AUTO_INCREMENT for table `messages_inbox`
1439--
1440ALTER TABLE `messages_inbox`
1441 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1442
1443--
1444-- AUTO_INCREMENT for table `messages_junk`
1445--
1446ALTER TABLE `messages_junk`
1447 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1448
1449--
1450-- AUTO_INCREMENT for table `messages_outbox`
1451--
1452ALTER TABLE `messages_outbox`
1453 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1454
1455--
1456-- AUTO_INCREMENT for table `module_MessageOfTheDay`
1457--
1458ALTER TABLE `module_MessageOfTheDay`
1459 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1460
1461--
1462-- AUTO_INCREMENT for table `notifications`
1463--
1464ALTER TABLE `notifications`
1465 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1466
1467--
1468-- AUTO_INCREMENT for table `settings`
1469--
1470ALTER TABLE `settings`
1471 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1472
1473--
1474-- AUTO_INCREMENT for table `sounds`
1475--
1476ALTER TABLE `sounds`
1477 MODIFY `goSound_id` int(10) NOT NULL AUTO_INCREMENT;
1478
1479--
1480-- AUTO_INCREMENT for table `statistics`
1481--
1482ALTER TABLE `statistics`
1483 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1484
1485--
1486-- AUTO_INCREMENT for table `tasks`
1487--
1488ALTER TABLE `tasks`
1489 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1490
1491--
1492-- AUTO_INCREMENT for table `timeline`
1493--
1494ALTER TABLE `timeline`
1495 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1496
1497--
1498-- AUTO_INCREMENT for table `users`
1499--
1500ALTER TABLE `users`
1501 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1502
1503--
1504-- AUTO_INCREMENT for table `user_access_group`
1505--
1506ALTER TABLE `user_access_group`
1507 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1508
1509--
1510-- Constraints for dumped tables
1511--
1512
1513--
1514-- Constraints for table `go_sounds`
1515--
1516ALTER TABLE `go_sounds`
1517 ADD CONSTRAINT `go_sounds_ibfk_1` FOREIGN KEY (`goSound_id`) REFERENCES `sounds` (`goSound_id`);
1518COMMIT;
1519
1520/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1521/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1522/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;