PMA_token |s:16:"Y|7&U]rmlZeETgJM";auth_type|s:3:"env";browser_access_time|a:1:{s:7:"default";i:1569131648;}relation|a:1:{i:1;a:22:{s:11:"PMA_VERSION";s:5:"4.8.3";s:7:"relwork";b:0;s:11:"displaywork";b:0;s:12:"bookmarkwork";b:0;s:7:"pdfwork";b:0;s:8:"commwork";b:0;s:8:"mimework";b:0;s:11:"historywork";b:0;s:10:"recentwork";b:0;s:12:"favoritework";b:0;s:11:"uiprefswork";b:0;s:12:"trackingwork";b:0;s:14:"userconfigwork";b:0;s:9:"menuswork";b:0;s:7:"navwork";b:0;s:17:"savedsearcheswork";b:0;s:18:"centralcolumnswork";b:0;s:20:"designersettingswork";b:0;s:19:"exporttemplateswork";b:0;s:8:"allworks";b:0;s:4:"user";N;s:2:"db";N;}}cache|a:6:{s:8:"server_1";a:4:{s:15:"userprefs_mtime";i:1569131630;s:14:"userprefs_type";s:7:"session";s:12:"config_mtime";i:1555968202;s:9:"userprefs";a:4:{s:28:"PmaNoRelation_DisableWarning";b:1;s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}s:22:"DefaultTransformations";a:5:{s:9:"Substring";a:3:{i:0;s:1:"0";i:1;s:3:"all";i:2;s:3:"…";}s:8:"External";a:4:{i:0;s:1:"0";i:1;s:24:"-f /dev/null -i -wrap -q";i:2;s:1:"1";i:3;s:1:"1";}s:10:"DateFormat";a:3:{i:0;s:1:"0";i:1;s:5:"local";i:2;s:5:"local";}s:6:"Inline";a:2:{i:0;s:3:"100";i:1;s:3:"100";}s:13:"TextImageLink";a:3:{i:0;s:3:"100";i:1;s:2:"50";i:2;s:2:"50";}}s:6:"Server";a:2:{s:7:"hide_db";s:0:"";s:7:"only_db";s:0:"";}}}s:25:"server_1_cpses_slcu0dcuq0";a:5:{s:12:"is_grantuser";b:0;s:13:"is_createuser";b:0;s:12:"is_superuser";b:0;s:11:"binary_logs";a:0:{}s:18:"menu-levels-server";a:13:{s:9:"databases";s:9:"Databases";s:3:"sql";s:3:"SQL";s:6:"status";s:6:"Status";s:6:"rights";s:5:"Users";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:8:"settings";s:8:"Settings";s:6:"binlog";s:10:"Binary log";s:11:"replication";s:11:"Replication";s:4:"vars";s:9:"Variables";s:7:"charset";s:8:"Charsets";s:7:"plugins";s:7:"Plugins";s:6:"engine";s:7:"Engines";}}s:9:"server_1_";a:3:{s:11:"binary_logs";a:0:{}s:18:"menu-levels-server";a:13:{s:9:"databases";s:9:"Databases";s:3:"sql";s:3:"SQL";s:6:"status";s:6:"Status";s:6:"rights";s:5:"Users";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:8:"settings";s:8:"Settings";s:6:"binlog";s:10:"Binary log";s:11:"replication";s:11:"Replication";s:4:"vars";s:9:"Variables";s:7:"charset";s:8:"Charsets";s:7:"plugins";s:7:"Plugins";s:6:"engine";s:7:"Engines";}s:24:"disabled_storage_engines";b:0;}s:25:"server_1_cpses_sluy60lbey";a:5:{s:12:"is_grantuser";b:0;s:13:"is_createuser";b:0;s:12:"is_superuser";b:0;s:11:"binary_logs";a:0:{}s:18:"menu-levels-server";a:13:{s:9:"databases";s:9:"Databases";s:3:"sql";s:3:"SQL";s:6:"status";s:6:"Status";s:6:"rights";s:5:"Users";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:8:"settings";s:8:"Settings";s:6:"binlog";s:10:"Binary log";s:11:"replication";s:11:"Replication";s:4:"vars";s:9:"Variables";s:7:"charset";s:8:"Charsets";s:7:"plugins";s:7:"Plugins";s:6:"engine";s:7:"Engines";}}s:25:"server_1_cpses_sldcl4eu6p";a:5:{s:12:"is_superuser";b:0;s:12:"is_grantuser";b:0;s:13:"is_createuser";b:0;s:11:"binary_logs";a:0:{}s:18:"menu-levels-server";a:13:{s:9:"databases";s:9:"Databases";s:3:"sql";s:3:"SQL";s:6:"status";s:6:"Status";s:6:"rights";s:5:"Users";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:8:"settings";s:8:"Settings";s:6:"binlog";s:10:"Binary log";s:11:"replication";s:11:"Replication";s:4:"vars";s:9:"Variables";s:7:"charset";s:8:"Charsets";s:7:"plugins";s:7:"Plugins";s:6:"engine";s:7:"Engines";}}s:25:"server_1_cpses_sl6iw92v30";a:4:{s:12:"is_grantuser";b:0;s:13:"is_createuser";b:0;s:12:"is_superuser";b:0;s:14:"menu-levels-db";a:14:{s:9:"structure";s:9:"Structure";s:3:"sql";s:3:"SQL";s:6:"search";s:6:"Search";s:17:"multi_table_query";s:5:"Query";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:9:"operation";s:10:"Operations";s:10:"privileges";s:10:"Privileges";s:8:"routines";s:8:"Routines";s:6:"events";s:6:"Events";s:8:"triggers";s:8:"Triggers";s:8:"tracking";s:8:"Tracking";s:8:"designer";s:8:"Designer";s:15:"central_columns";s:15:"Central columns";}}}encryption_key|s:32:"��y��
7����{|f��!���9a��Ԩ{��";userconfig|a:2:{s:2:"db";a:10:{s:28:"PmaNoRelation_DisableWarning";b:1;s:12:"ShowCreateDb";b:1;s:12:"Console/Mode";s:8:"collapse";s:32:"DefaultTransformations/Substring";a:3:{i:0;s:1:"0";i:1;s:3:"all";i:2;s:3:"…";}s:31:"DefaultTransformations/External";a:4:{i:0;s:1:"0";i:1;s:24:"-f /dev/null -i -wrap -q";i:2;s:1:"1";i:3;s:1:"1";}s:33:"DefaultTransformations/DateFormat";a:3:{i:0;s:1:"0";i:1;s:5:"local";i:2;s:5:"local";}s:29:"DefaultTransformations/Inline";a:2:{i:0;s:3:"100";i:1;s:3:"100";}s:36:"DefaultTransformations/TextImageLink";a:3:{i:0;s:3:"100";i:1;s:2:"50";i:2;s:2:"50";}s:14:"Server/hide_db";s:0:"";s:14:"Server/only_db";s:0:"";}s:2:"ts";i:1569131630;}two_factor_check|b:1;is_git_revision|b:0;tmpval|a:16:{s:15:"favorite_tables";a:1:{i:1;a:0:{}}s:13:"recent_tables";a:1:{i:1;a:2:{i:0;a:2:{s:2:"db";s:5:"usctm";s:5:"table";s:6:"events";}i:1;a:2:{s:2:"db";s:5:"usctm";s:5:"table";s:7:"Program";}}}s:18:"table_limit_offset";i:0;s:21:"table_limit_offset_db";s:5:"usctm";s:5:"query";a:10:{s:32:"a60ebda797a300d202eccd2a010ea289";a:8:{s:3:"sql";s:322:"#

CREATE TABLE IF NOT EXISTS `lead_source` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"4c696fbc37d0265e671de72845323aaa";a:8:{s:3:"sql";s:188:"#

INSERT INTO `lead_source` (`id`, `title`, `sort`, `deleted`) VALUES
(1, 'Google', 1, 0),
(2, 'Facebook', 2, 0),
(3, 'Twitter', 3, 0),
(4, 'Youtube', 4, 0),
(5, 'Elsewhere', 5, 0)";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"44e0eb68746ea8a9939475773d9c97c7";a:8:{s:3:"sql";s:380:"#


CREATE TABLE IF NOT EXISTS `lead_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `color` varchar(7) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"20f10e114daf30ce339789926da83acb";a:8:{s:3:"sql";s:325:"#

 INSERT INTO `lead_status` (`id`, `title`, `color`, `sort`, `deleted`) VALUES 
('1', 'New', '#f1c40f', '0', '0'), 
('2', 'Qualified', '#2d9cdb', '1', '0'),  
('3', 'Discussion', '#29c2c2', '2', '0'),  
('4', 'Negotiation', '#2d9cdb', '3', '0'),
('5', 'Won', '#83c340', '4', '0'),
('6', 'Lost', '#e74c3c', '5', '0')";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"95de9d2ddbe3a3e87419c5c43f420ca0";a:8:{s:3:"sql";s:81:"#

ALTER TABLE `notifications` ADD `lead_id` INT(11) NOT NULL AFTER `client_id`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"85d318a33248664aeab8ac929def4167";a:8:{s:3:"sql";s:120:"#

INSERT INTO `settings` (`setting_name`, `setting_value`, `type`, `deleted`) VALUES ('module_lead', '0', 'app', '0')";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"2cdd668c96f571093a1b821a104639a0";a:8:{s:3:"sql";s:31:"DROP TABLE `expense_categories`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"744dc0c6088da5d2300ababbf671dae8";a:8:{s:3:"sql";s:22:"DROP TABLE `estimates`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"b6de60819a3320abb1d6f855d040a23c";a:8:{s:3:"sql";s:27:"DROP TABLE `estimate_forms`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"bcfc76dfc7a944f3eec306e110d1d18e";a:8:{s:3:"sql";s:22:"SELECT * FROM `events`";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";s:1:"0";s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}}s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;s:12:"display_blob";b:0;s:19:"hide_transformation";b:0;s:3:"pos";s:1:"0";s:8:"max_rows";i:25;s:12:"repeat_cells";i:100;s:13:"table_uiprefs";a:1:{i:1;a:1:{s:5:"usctm";a:1:{s:6:"events";a:0:{}}}}s:20:"possible_as_geometry";b:1;}ConfigFile1|a:5:{s:28:"PmaNoRelation_DisableWarning";b:1;s:12:"ShowCreateDb";b:0;s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}s:22:"DefaultTransformations";a:5:{s:9:"Substring";a:3:{i:0;s:1:"0";i:1;s:3:"all";i:2;s:3:"…";}s:8:"External";a:4:{i:0;s:1:"0";i:1;s:24:"-f /dev/null -i -wrap -q";i:2;s:1:"1";i:3;s:1:"1";}s:10:"DateFormat";a:3:{i:0;s:1:"0";i:1;s:5:"local";i:2;s:5:"local";}s:6:"Inline";a:3:{i:0;s:3:"100";i:1;s:3:"100";s:12:"wrapper_link";N;}s:13:"TextImageLink";a:3:{i:0;s:3:"100";i:1;s:2:"50";i:2;s:2:"50";}}s:7:"Servers";a:1:{i:1;a:2:{s:7:"only_db";s:0:"";s:7:"hide_db";s:0:"";}}}debug|a:0:{}prev_error_subm_time|i:1569126711;error_subm_count|i:1;userprefs_autoload|b:1;sql_history|a:4:{i:0;a:3:{s:2:"db";s:5:"usctm";s:5:"table";s:7:"Program";s:8:"sqlquery";s:79:"CREATE TABLE `usctm`.`Program` ( `Customer` INT(55) NOT NULL ) ENGINE = MyISAM;";}i:1;a:3:{s:2:"db";s:5:"usctm";s:5:"table";s:0:"";s:8:"sqlquery";s:120:"#

INSERT INTO `settings` (`setting_name`, `setting_value`, `type`, `deleted`) VALUES ('module_lead', '0', 'app', '0')";}i:2;a:3:{s:2:"db";s:5:"usctm";s:5:"table";s:6:"events";s:8:"sqlquery";s:22:"SELECT * FROM `events`";}i:3;a:3:{s:2:"db";s:5:"usctm";s:5:"table";s:0:"";s:8:"sqlquery";s:859:"DROP TABLE `activity_logs`, `announcements`, `attendance`, `checklist_items`, `ci_sessions`, `clients`, `client_groups`, `custom_fields`, `custom_field_values`, `custom_widgets`, `dashboards`, `email_templates`, `estimate_items`, `estimate_requests`, `events`, `expenses`, `general_files`, `help_articles`, `help_categories`, `invoices`, `invoice_items`, `invoice_payments`, `items`, `leads`, `lead_source`, `lead_status`, `leave_applications`, `leave_types`, `messages`, `milestones`, `notes`, `notifications`, `notification_settings`, `payment_methods`, `paypal_ipn`, `posts`, `Program`, `projects`, `project_comments`, `project_files`, `project_members`, `project_settings`, `project_time`, `roles`, `settings`, `social_links`, `tasks`, `task_status`, `taxes`, `team`, `team_member_job_info`, `tickets`, `ticket_comments`, `ticket_types`, `to_do`, `users`;";}}Import_message|a:2:{s:7:"message";s:591:"<div class="error"><h1>Error</h1><p><strong>SQL query:</strong>
    </p>
<p>
<code class="sql"><pre>
#

INSERT INTO `settings` (`setting_name`, `setting_value`, `type`, `deleted`) VALUES ('module_lead', '0', 'app', '0')
</pre></code>
</p>
<p>
    <strong>MySQL said: </strong><a href="./url.php?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.6%2Fen%2Ferror-messages-server.html" target="mysql_doc"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help" /></a>
</p>
<code>#1062 - Duplicate entry 'module_lead' for key 'setting_name'</code><br/></div>";s:11:"go_back_url";s:22:"db_import.php?db=usctm";}__upload_status|a:1:{s:7:"handler";s:47:"PhpMyAdmin\Plugins\Import\Upload\UploadNoplugin";}is_multi_query|b:0;prev_errors|a:4:{s:32:"e9e8d0c7593da79e7ece44a35cbe0aab";O:16:"PhpMyAdmin\Error":12:{s:7:"*file";s:35:"./libraries/classes/ErrorReport.php";s:7:"*line";i:96;s:12:"*backtrace";a:3:{i:0;a:5:{s:4:"file";s:35:"./libraries/classes/ErrorReport.php";s:4:"line";i:60;s:8:"function";s:7:"getData";s:5:"class";s:22:"PhpMyAdmin\ErrorReport";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:35:"./libraries/classes/ErrorReport.php";s:4:"line";i:248;s:8:"function";s:13:"getPrettyData";s:5:"class";s:22:"PhpMyAdmin\ErrorReport";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:18:"./error_report.php";s:4:"line";i:130;s:8:"function";s:7:"getForm";s:5:"class";s:22:"PhpMyAdmin\ErrorReport";s:4:"type";s:2:"->";}}s:16:"*hide_location";b:0;s:9:"*number";i:8;s:9:"*string";s:0:"";s:10:"*message";s:20:"Undefined index: url";s:14:"*isDisplayed";b:1;s:12:"*useBBCode";b:0;s:7:"*hash";s:32:"e9e8d0c7593da79e7ece44a35cbe0aab";s:9:"*params";a:0:{}s:16:"*addedMessages";a:0:{}}s:32:"660b1e034b4d12982b63bb6a8a9a5191";O:16:"PhpMyAdmin\Error":12:{s:7:"*file";s:35:"./libraries/classes/ErrorReport.php";s:7:"*line";i:103;s:12:"*backtrace";a:3:{i:0;a:5:{s:4:"file";s:35:"./libraries/classes/ErrorReport.php";s:4:"line";i:60;s:8:"function";s:7:"getData";s:5:"class";s:22:"PhpMyAdmin\ErrorReport";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:35:"./libraries/classes/ErrorReport.php";s:4:"line";i:248;s:8:"function";s:13:"getPrettyData";s:5:"class";s:22:"PhpMyAdmin\ErrorReport";s:4:"type";s:2:"->";}i:2;a:5:{s:4:"file";s:18:"./error_report.php";s:4:"line";i:130;s:8:"function";s:7:"getForm";s:5:"class";s:22:"PhpMyAdmin\ErrorReport";s:4:"type";s:2:"->";}}s:16:"*hide_location";b:0;s:9:"*number";i:8;s:9:"*string";s:0:"";s:10:"*message";s:29:"Undefined index: microhistory";s:14:"*isDisplayed";b:1;s:12:"*useBBCode";b:0;s:7:"*hash";s:32:"660b1e034b4d12982b63bb6a8a9a5191";s:9:"*params";a:0:{}s:16:"*addedMessages";a:0:{}}s:32:"ce85d517afa2db716f67d8c71fb1986c";O:16:"PhpMyAdmin\Error":12:{s:7:"*file";s:35:"./libraries/classes/ErrorReport.php";s:7:"*line";i:96;s:12:"*backtrace";a:2:{i:0;a:5:{s:4:"file";s:35:"./libraries/classes/ErrorReport.php";s:4:"line";i:253;s:8:"function";s:7:"getData";s:5:"class";s:22:"PhpMyAdmin\ErrorReport";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:18:"./error_report.php";s:4:"line";i:130;s:8:"function";s:7:"getForm";s:5:"class";s:22:"PhpMyAdmin\ErrorReport";s:4:"type";s:2:"->";}}s:16:"*hide_location";b:0;s:9:"*number";i:8;s:9:"*string";s:0:"";s:10:"*message";s:20:"Undefined index: url";s:14:"*isDisplayed";b:1;s:12:"*useBBCode";b:0;s:7:"*hash";s:32:"ce85d517afa2db716f67d8c71fb1986c";s:9:"*params";a:0:{}s:16:"*addedMessages";a:0:{}}s:32:"547c5872d1d7148fa3d229e6993105f1";O:16:"PhpMyAdmin\Error":12:{s:7:"*file";s:35:"./libraries/classes/ErrorReport.php";s:7:"*line";i:103;s:12:"*backtrace";a:2:{i:0;a:5:{s:4:"file";s:35:"./libraries/classes/ErrorReport.php";s:4:"line";i:253;s:8:"function";s:7:"getData";s:5:"class";s:22:"PhpMyAdmin\ErrorReport";s:4:"type";s:2:"->";}i:1;a:5:{s:4:"file";s:18:"./error_report.php";s:4:"line";i:130;s:8:"function";s:7:"getForm";s:5:"class";s:22:"PhpMyAdmin\ErrorReport";s:4:"type";s:2:"->";}}s:16:"*hide_location";b:0;s:9:"*number";i:8;s:9:"*string";s:0:"";s:10:"*message";s:29:"Undefined index: microhistory";s:14:"*isDisplayed";b:1;s:12:"*useBBCode";b:0;s:7:"*hash";s:32:"547c5872d1d7148fa3d229e6993105f1";s:9:"*params";a:0:{}s:16:"*addedMessages";a:0:{}}}errors|a:0:{}