rendered paste body-- phpMyAdmin SQL Dump-- version 2.11.9.3-- http://www.phpmyadmin.net---- Host: localhost-- Generation Time: Jan 27, 2010 at 10:45 AM-- Server version: 5.0.77-- PHP Version: 5.1.6SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";---- Database: `queuemetrics`-- For QueueMetrics version 1.6.0 beta 1---- ------------------------------------------------------------ Table structure for table `agaw_alarms`--CREATE TABLE IF NOT EXISTS `agaw_alarms` ( `queue_id` int(11) NOT NULL auto_increment, `q_qconv_p_visible` int(11) NOT NULL default '0', `q_qconv_p_red` varchar(50) NOT NULL, `q_qconv_p_yellow` varchar(50) NOT NULL, `q_conv_p_visible` int(11) NOT NULL default '0', `q_conv_p_red` varchar(50) NOT NULL, `q_conv_p_yellow` varchar(50) NOT NULL, `q_acl_visible` int(11) NOT NULL default '0', `q_acl_red` varchar(50) NOT NULL, `q_acl_yellow` varchar(50) NOT NULL, `q_wrap_visible` int(11) NOT NULL default '0', `q_wrap_red` varchar(50) NOT NULL, `q_wrap_yellow` varchar(50) NOT NULL, `q_avgwait_visible` int(11) NOT NULL default '0', `q_avgwait_red` varchar(50) NOT NULL, `q_avgwait_yellow` varchar(50) NOT NULL, `q_maxwait_visible` int(11) NOT NULL default '0', `q_maxwait_red` varchar(50) NOT NULL, `q_maxwait_yellow` varchar(50) NOT NULL, `q_n_calls_visible` int(11) NOT NULL default '0', `q_n_calls_red` varchar(50) NOT NULL, `q_n_calls_yellow` varchar(50) NOT NULL, `q_cph_visible` int(11) NOT NULL default '0', `q_cph_red` varchar(50) NOT NULL, `q_cph_yellow` varchar(50) NOT NULL, `q_qcph_visible` int(11) NOT NULL default '0', `q_qcph_red` varchar(50) NOT NULL, `q_qcph_yellow` varchar(50) NOT NULL, `q_sph_visible` int(11) NOT NULL default '0', `q_sph_red` varchar(50) NOT NULL, `q_sph_yellow` varchar(50) NOT NULL, `qconv_p_visible` int(11) NOT NULL default '0', `qconv_p_red` varchar(50) NOT NULL, `qconv_p_yellow` varchar(50) NOT NULL, `conv_p_visible` int(11) NOT NULL default '0', `conv_p_red` varchar(50) NOT NULL, `conv_p_yellow` varchar(50) NOT NULL, `acl_visible` int(11) NOT NULL default '0', `acl_red` varchar(50) NOT NULL, `acl_yellow` varchar(50) NOT NULL, `wrap_visible` int(11) NOT NULL default '0', `wrap_red` varchar(50) NOT NULL, `wrap_yellow` varchar(50) NOT NULL, `n_calls_visible` int(11) NOT NULL default '0', `n_calls_red` varchar(50) NOT NULL, `n_calls_yellow` varchar(50) NOT NULL, `cph_visible` int(11) NOT NULL default '0', `cph_red` varchar(50) NOT NULL, `cph_yellow` varchar(50) NOT NULL, `qcph_visible` int(11) NOT NULL default '0', `qcph_red` varchar(50) NOT NULL, `qcph_yellow` varchar(50) NOT NULL, `sph_visible` int(11) NOT NULL default '0', `sph_red` varchar(50) NOT NULL, `sph_yellow` varchar(50) NOT NULL, `sys_dt_creazione` datetime NOT NULL, `sys_user_creazione` int(11) NOT NULL, `sys_dt_modifica` datetime NOT NULL, `sys_user_modifica` int(11) NOT NULL, `sys_optilock` int(11) NOT NULL, UNIQUE KEY `queue_id` (`queue_id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;---- Dumping data for table `agaw_alarms`--INSERT INTO `agaw_alarms` (`queue_id`, `q_qconv_p_visible`, `q_qconv_p_red`, `q_qconv_p_yellow`, `q_conv_p_visible`, `q_conv_p_red`, `q_conv_p_yellow`, `q_acl_visible`, `q_acl_red`, `q_acl_yellow`, `q_wrap_visible`, `q_wrap_red`, `q_wrap_yellow`, `q_avgwait_visible`, `q_avgwait_red`, `q_avgwait_yellow`, `q_maxwait_visible`, `q_maxwait_red`, `q_maxwait_yellow`, `q_n_calls_visible`, `q_n_calls_red`, `q_n_calls_yellow`, `q_cph_visible`, `q_cph_red`, `q_cph_yellow`, `q_qcph_visible`, `q_qcph_red`, `q_qcph_yellow`, `q_sph_visible`, `q_sph_red`, `q_sph_yellow`, `qconv_p_visible`, `qconv_p_red`, `qconv_p_yellow`, `conv_p_visible`, `conv_p_red`, `conv_p_yellow`, `acl_visible`, `acl_red`, `acl_yellow`, `wrap_visible`, `wrap_red`, `wrap_yellow`, `n_calls_visible`, `n_calls_red`, `n_calls_yellow`, `cph_visible`, `cph_red`, `cph_yellow`, `qcph_visible`, `qcph_red`, `qcph_yellow`, `sph_visible`, `sph_red`, `sph_yellow`, `sys_dt_creazione`, `sys_user_creazione`, `sys_dt_modifica`, `sys_user_modifica`, `sys_optilock`) VALUES(2, 0, '', '', 0, '', '', 1, '>200', '>100', 0, '', '', 0, '', '', 0, '', '', 1, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 0, '', '', 1, '>300', '>150', 0, '', '', 1, '', '', 0, '', '', 0, '', '', 0, '', '', '2008-12-04 14:56:50', 32, '2008-12-04 14:57:42', 32, 62265);-- ------------------------------------------------------------ Table structure for table `agaw_dati`--CREATE TABLE IF NOT EXISTS `agaw_dati` ( `id_dato` int(11) NOT NULL auto_increment, `id_run` int(11) NOT NULL, `agente` varchar(50) default NULL, `acl` int(11) NOT NULL, `acl_alarm` enum('n','r','y','h') default 'n', `sph` decimal(6,3) NOT NULL, `sph_alarm` enum('n','r','y','h') default 'n', `qcph` decimal(6,3) NOT NULL, `qcph_alarm` enum('n','y','r','h') default 'n', `cph` decimal(6,3) NOT NULL, `cph_alarm` enum('n','r','y','h') default 'n', `n_calls` int(11) NOT NULL, `n_calls_alarm` enum('n','r','y','h') default 'n', `qconv_p` decimal(6,3) NOT NULL, `qconv_p_alarm` enum('n','y','r','h') default 'n', `conv_p` decimal(6,3) NOT NULL, `conv_p_alarm` enum('n','y','r','h') default 'n', `wrap` int(11) NOT NULL, `wrap_alarm` enum('n','y','r','h') default 'n', `logon_status` enum('unk','on','off','pau') default 'unk', `last_logon` datetime NOT NULL, `logon_pcode` varchar(10) default NULL, PRIMARY KEY (`id_dato`), KEY `by_run_agent` (`id_run`,`agente`(10))) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;---- Dumping data for table `agaw_dati`---- ------------------------------------------------------------ Table structure for table `agaw_logs`--CREATE TABLE IF NOT EXISTS `agaw_logs` ( `id_logs` int(10) unsigned NOT NULL auto_increment, `tst_entry` datetime NOT NULL, `subsys` enum('adm','cli','ldr') default NULL, `user_id` int(10) unsigned NOT NULL, `entry` varchar(250) NOT NULL, `level` enum('i','w','e') default NULL, PRIMARY KEY (`id_logs`), KEY `by_subsys2` (`subsys`,`id_logs`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;---- Dumping data for table `agaw_logs`---- ------------------------------------------------------------ Table structure for table `agaw_runs`--CREATE TABLE IF NOT EXISTS `agaw_runs` ( `id_run` int(11) NOT NULL auto_increment, `run_status` varchar(2) NOT NULL, `tst_start` datetime NOT NULL, `tst_complete` datetime NOT NULL, `queue` varchar(50) NOT NULL, `n_agents` int(11) NOT NULL, `n_calls_taken` int(11) default NULL, `n_calls_lost` int(11) NOT NULL, `n_calls_ongoing` int(11) NOT NULL, `pid_runner` varchar(50) NOT NULL, `cod_runner` varchar(50) NOT NULL, `query_ms` int(11) NOT NULL, `insert_ms` int(11) NOT NULL, `q_n_wait` int(11) NOT NULL, `q_max_wait_sec` int(11) NOT NULL, `q_acl` int(11) NOT NULL, `q_sph` decimal(6,3) NOT NULL, `q_cph` decimal(6,3) NOT NULL, `q_n_wait_alarm` enum('n','y','r','h') default 'n', `q_max_wait_sec_alarm` enum('n','y','r','h') default 'n', `q_acl_alarm` enum('n','y','r','h') default 'n', `q_sph_alarm` enum('n','y','r','h') default 'n', `q_cph_alarm` enum('n','y','r','h') default 'n', `q_qcph` decimal(6,3) NOT NULL, `q_qcph_alarm` enum('n','y','r','h') default 'n', `q_qconv_p` decimal(6,3) NOT NULL, `q_qconv_p_alarm` enum('n','y','r','h') default 'n', `q_conv_p` decimal(6,3) NOT NULL, `q_conv_p_alarm` enum('n','y','r','h') default 'n', `q_wrap` int(11) NOT NULL, `q_wrap_alarm` enum('n','y','r','h') default 'n', `q_avgwait` int(11) NOT NULL, `q_avgwait_alarm` enum('n','y','r','h') default 'n', PRIMARY KEY (`id_run`), KEY `by_status_queue` (`run_status`,`queue`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;---- Dumping data for table `agaw_runs`---- ------------------------------------------------------------ Table structure for table `agenti_noti`--CREATE TABLE IF NOT EXISTS `agenti_noti` ( `id_agente` int(11) NOT NULL auto_increment, `nome_agente` varchar(30) NOT NULL default '', `descr_agente` varchar(50) NOT NULL default '', `location` int(11) NOT NULL default '0', `group_by` int(11) NOT NULL default '0', `current_terminal` varchar(100) NOT NULL default '', `vnc_url` varchar(100) NOT NULL default '', `supervised_by` int(10) unsigned NOT NULL default '0', `xmpp_address` varchar(200) NOT NULL, `payroll_code` varchar(50) character set utf8 NOT NULL, `sys_dt_creazione` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_creazione` int(11) NOT NULL default '0', `sys_dt_modifica` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_modifica` int(11) NOT NULL default '0', `sys_optilock` int(11) NOT NULL default '0', `chiave_agente` text NOT NULL, PRIMARY KEY (`id_agente`), KEY `conta_location` (`location`), KEY `USR_LOCATION` (`location`), KEY `find_term` (`current_terminal`(5))) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=73 ;---- Dumping data for table `agenti_noti`--INSERT INTO `agenti_noti` (`id_agente`, `nome_agente`, `descr_agente`, `location`, `group_by`, `current_terminal`, `vnc_url`, `supervised_by`, `xmpp_address`, `payroll_code`, `sys_dt_creazione`, `sys_user_creazione`, `sys_dt_modifica`, `sys_user_modifica`, `sys_optilock`, `chiave_agente`) VALUES(71, 'Agent/101', 'John Doe (101)', 1, 0, '-', '', 0, 'agent101@chatserver', '', '2007-06-18 22:28:20', 32, '2008-12-04 14:58:55', 32, 4013, ''),(72, 'Agent/102', 'Mike Boo (102)', 3, 0, '12', 'http://mike.boo.workstation/vnc', 0, '', '', '2007-06-18 22:29:07', 32, '2008-12-04 14:59:16', 32, 46753, '');-- ------------------------------------------------------------ Table structure for table `agent_groups`--CREATE TABLE IF NOT EXISTS `agent_groups` ( `id_group` int(11) NOT NULL auto_increment, `group_name` varchar(100) NOT NULL, `group_description` varchar(250) NOT NULL, `group_icon` varchar(128) NOT NULL, `read_key` varchar(30) NOT NULL, `sys_dt_creazione` datetime NOT NULL, `sys_user_creazione` int(11) NOT NULL, `sys_dt_modifica` datetime NOT NULL, `sys_user_modifica` int(11) NOT NULL, `sys_optilock` int(11) NOT NULL, PRIMARY KEY (`id_group`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;---- Dumping data for table `agent_groups`--INSERT INTO `agent_groups` (`id_group`, `group_name`, `group_description`, `group_icon`, `read_key`, `sys_dt_creazione`, `sys_user_creazione`, `sys_dt_modifica`, `sys_user_modifica`, `sys_optilock`) VALUES(1, 'Default', 'Flat default group', 'default.png', '', '2010-01-27 10:39:05', 0, '0000-00-00 00:00:00', 0, 43398);-- ------------------------------------------------------------ Table structure for table `arch_classes`--CREATE TABLE IF NOT EXISTS `arch_classes` ( `id_classe` int(11) NOT NULL auto_increment, `nome_classe` varchar(15) NOT NULL default '', `des_classe` varchar(200) NOT NULL default '', `chiavi` text NOT NULL, `sys_dt_creazione` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_creazione` int(11) NOT NULL default '0', `sys_dt_modifica` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_modifica` int(11) NOT NULL default '0', `sys_optilock` int(11) NOT NULL default '0', PRIMARY KEY (`id_classe`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;---- Dumping data for table `arch_classes`--INSERT INTO `arch_classes` (`id_classe`, `nome_classe`, `des_classe`, `chiavi`, `sys_dt_creazione`, `sys_user_creazione`, `sys_dt_modifica`, `sys_user_modifica`, `sys_optilock`) VALUES(1, 'SYSOP', 'Sysop', 'USER SYSOP', '0000-00-00 00:00:00', 0, '2008-12-04 14:55:00', 32, 8304),(2, 'USERS', 'Normal users', 'USER QUEUE_AN REALTIME AGREP CALLMONITOR RTLIVE CHPASSWD QA_REPORT QA_TRACK CLOSECALLS AGAW_REP BRO_MSG MON_IM', '2004-10-29 10:09:00', 0, '2008-12-04 14:55:14', 32, 18290),(3, 'ADMIN', 'Administrator', 'USER QUEUE_AN USR_AGENT USR_QUEUE USRADMIN USR_REPORTS REALTIME AGREP CALLMONITOR USR_LOCATION USR_OUTCOME USR_PCODE RTLIVE CHPASSWD MON_AUDIO MON_VNC USR_MYSQL QA_REPORT QA_TRACK CLOSECALLS AGAW_ADM BRO_MSG MON_IM USR_QAEDIT QUEUE_LST PAYROLL QLOG_EDIT QLOG_LNGR', '2004-10-29 10:08:48', 0, '2009-05-12 11:00:00', 32, 50334),(4, 'AGENTS', 'Individual agents', 'AGENT CHPASSWD AGAW', '2004-11-02 15:24:48', 5, '2008-12-04 14:54:10', 32, 92037),(5, 'ROBOTS', 'We are the robots', 'USER QUEUE_AN USR_AGENT USR_QUEUE USRADMIN REALTIME AGREP CALLMONITOR USR_LOCATION ROBOT', '2006-10-08 11:18:58', 32, '2008-12-04 14:55:50', 32, 40302),(6, 'SUPERVISORS', 'Agent supervisors', 'USER SUPERVISOR REALTIME QUEUE_AN QA_REPORT QA_TRACK CLOSECALLS AGAW_REP BRO_MSG MON_IM', '2007-02-03 22:20:23', 32, '2008-12-04 14:54:39', 32, 20339),(7, 'VISITORS', 'Visitors', 'VISITOR CHPASSWD', '2007-06-18 22:22:40', 32, '2008-12-04 14:55:31', 32, 21495);-- ------------------------------------------------------------ Table structure for table `arch_syslog`--CREATE TABLE IF NOT EXISTS `arch_syslog` ( `log_id` int(11) NOT NULL auto_increment, `sys_dt_creazione` datetime NOT NULL, `sys_user_creazione` int(11) NOT NULL, `session` varchar(50) NOT NULL, `action` int(11) NOT NULL, `text1` text NOT NULL, `text2` text NOT NULL, `text3` text NOT NULL, `text4` text NOT NULL, PRIMARY KEY (`log_id`), KEY `by_action` (`sys_dt_creazione`,`action`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;---- Dumping data for table `arch_syslog`--INSERT INTO `arch_syslog` (`log_id`, `sys_dt_creazione`, `sys_user_creazione`, `session`, `action`, `text1`, `text2`, `text3`, `text4`) VALUES(1, '2009-08-19 16:12:20', 32, 'E777AFDE35D8843AEC24DA0E24C2AC5B', 1001, 'demoadmin', '10.10.3.100', '', '');-- ------------------------------------------------------------ Table structure for table `arch_users`--CREATE TABLE IF NOT EXISTS `arch_users` ( `user_id` int(11) NOT NULL auto_increment, `login` varchar(50) NOT NULL default '', `PASSWORD` varchar(50) NOT NULL default '', `real_name` varchar(50) NOT NULL default '', `abilitato` tinyint(4) NOT NULL default '0', `email` varchar(50) NOT NULL default '', `masterkey` tinyint(4) NOT NULL default '0', `classe` int(11) NOT NULL default '0', `chiavi_utente` text NOT NULL, `n_logon` int(11) NOT NULL default '0', `ultimo_logon` datetime NOT NULL default '0000-00-00 00:00:00', `commento` varchar(200) NOT NULL default '', `token` varchar(50) NOT NULL default '', `sys_dt_creazione` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_creazione` int(11) NOT NULL default '0', `sys_dt_modifica` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_modifica` int(11) NOT NULL default '0', `sys_optilock` int(11) NOT NULL default '0', PRIMARY KEY (`user_id`), KEY `do_logon` (`login`(3),`abilitato`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=0 AUTO_INCREMENT=44 ;---- Dumping data for table `arch_users`--INSERT INTO `arch_users` (`user_id`, `login`, `PASSWORD`, `real_name`, `abilitato`, `email`, `masterkey`, `classe`, `chiavi_utente`, `n_logon`, `ultimo_logon`, `commento`, `token`, `sys_dt_creazione`, `sys_user_creazione`, `sys_dt_modifica`, `sys_user_modifica`, `sys_optilock`) VALUES(39, 'demouser', 'demo', 'Demo User', 1, '', 0, 2, '', 2, '2008-12-04 15:02:16', '', '', '2007-06-18 22:20:24', 32, '0000-00-00 00:00:00', 0, 65033),(32, 'demoadmin', 'demo', 'Demo Admin', 1, '', 0, 3, 'CONFIG', 3034, '2009-08-19 16:12:20', '', '', '2006-07-13 18:20:40', 31, '2009-04-21 16:39:54', 32, 54624),(33, 'Agent/101', '999', 'John Doe', 1, '', 0, 4, '', 24, '2007-06-18 16:09:51', '', '', '2006-09-09 00:20:21', 32, '2007-03-06 18:43:19', 32, 27250),(35, 'robot', 'robot', 'Ro Bot', 0, '', 0, 5, '', 62, '2007-05-11 15:03:17', '', '', '2006-10-08 11:19:21', 32, '2008-05-13 15:43:12', 32, 19560),(41, 'demosupervisor', 'demo', 'Super Visor', 0, '', 0, 6, '', 1, '2007-06-18 22:35:50', '', '', '2007-06-18 22:21:30', 32, '2008-05-13 15:42:56', 32, 57118),(40, 'demovisitor', 'demo', 'Visi Tor', 0, '', 0, 7, '', 2, '2007-06-18 22:35:27', '', '', '2007-06-18 22:21:06', 32, '2008-05-13 15:43:05', 32, 8960),(42, 'Agent/102', '998', 'Mike Boo', 1, '', 0, 4, '', 0, '0000-00-00 00:00:00', '', '', '2007-06-18 22:22:16', 32, '0000-00-00 00:00:00', 0, 22952);-- ------------------------------------------------------------ Table structure for table `broadcast_msg`--CREATE TABLE IF NOT EXISTS `broadcast_msg` ( `id_msg` int(11) NOT NULL auto_increment, `tst_msg` datetime NOT NULL, `testo_msg` varchar(250) NOT NULL, `for_everyone` tinyint(4) NOT NULL default '0', `by_queue` varchar(200) NOT NULL, `by_id_supervisor` int(11) NOT NULL, `by_id_location` int(11) NOT NULL, `sys_dt_creazione` datetime NOT NULL, `sys_user_creazione` int(11) NOT NULL, `sys_dt_modifica` datetime NOT NULL, `sys_user_modifica` int(11) NOT NULL, `sys_optilock` int(11) NOT NULL, PRIMARY KEY (`id_msg`), KEY `idx_by_time` (`tst_msg`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;---- Dumping data for table `broadcast_msg`---- ------------------------------------------------------------ Table structure for table `call_status`--CREATE TABLE IF NOT EXISTS `call_status` ( `status_id` int(10) unsigned NOT NULL auto_increment, `status_code` varchar(45) NOT NULL default '', `status_descr` varchar(100) NOT NULL default '', `read_key` varchar(100) NOT NULL default '', `isContact` tinyint(3) unsigned NOT NULL default '0', `isQContact` tinyint(3) unsigned NOT NULL default '0', `isSale` tinyint(3) unsigned NOT NULL default '0', `sys_dt_creazione` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_creazione` int(11) NOT NULL default '0', `sys_dt_modifica` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_modifica` int(11) NOT NULL default '0', `sys_optilock` int(11) NOT NULL default '0', PRIMARY KEY (`status_id`), KEY `byCode` (`status_code`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Gli stati delle chiamate' AUTO_INCREMENT=14 ;---- Dumping data for table `call_status`--INSERT INTO `call_status` (`status_id`, `status_code`, `status_descr`, `read_key`, `isContact`, `isQContact`, `isSale`, `sys_dt_creazione`, `sys_user_creazione`, `sys_dt_modifica`, `sys_user_modifica`, `sys_optilock`) VALUES(4, 'dc', 'Disconnected', '', 0, 0, 0, '2007-02-20 10:45:16', 32, '0000-00-00 00:00:00', 0, 79823),(5, 'a', 'Answering Machine', '', 0, 0, 0, '2007-02-20 10:45:26', 32, '0000-00-00 00:00:00', 0, 75070),(6, 'n', 'Not Available', '', 0, 0, 0, '2007-02-20 10:45:48', 32, '0000-00-00 00:00:00', 0, 69801),(7, 'dnc', 'Do not call anymore', '', 1, 1, 0, '2007-02-20 10:46:04', 32, '0000-00-00 00:00:00', 0, 84938),(8, 'ni', 'Not Interested', '', 1, 1, 0, '2007-02-20 10:46:16', 32, '0000-00-00 00:00:00', 0, 20554),(9, 'sale', 'Sale', '', 1, 1, 1, '2007-02-20 10:46:27', 32, '0000-00-00 00:00:00', 0, 18066),(10, 'nq', 'Not Qualified', '', 1, 1, 0, '2007-02-20 21:37:16', 32, '0000-00-00 00:00:00', 0, 42953),(11, 'xfer', 'Transfer to IVR', '', 0, 0, 0, '2007-02-20 21:37:49', 32, '0000-00-00 00:00:00', 0, 54799),(12, 'b', 'Busy', '', 0, 0, 0, '2007-02-20 21:37:58', 32, '0000-00-00 00:00:00', 0, 7809);-- ------------------------------------------------------------ Table structure for table `code_possibili`--CREATE TABLE IF NOT EXISTS `code_possibili` ( `id_coda` int(11) NOT NULL auto_increment, `nome_coda` varchar(50) NOT NULL default '', `composizione_coda` text NOT NULL, `agenti_membri` text NOT NULL, `agenti_spilloff_1` text NOT NULL, `agenti_spilloff_2` text NOT NULL, `wrapuptime` int(11) NOT NULL default '0', `announcement_duration` int(11) NOT NULL default '0', `visibility_key` varchar(50) NOT NULL default '', `q_direction` enum('inbound','outbound') NOT NULL default 'inbound', `q_frontpage` tinyint(4) NOT NULL default '1', `sl_calls_y` varchar(20) NOT NULL default '', `sl_calls_r` varchar(20) NOT NULL default '', `sl_ag_calls_y` varchar(20) NOT NULL default '', `sl_ag_calls_r` varchar(20) NOT NULL default '', `sl_ag_wait_y` varchar(20) NOT NULL default '', `sl_ag_wait_r` varchar(20) NOT NULL default '', `sl_ag_pause_y` varchar(20) NOT NULL default '', `sl_ag_pause_r` varchar(20) NOT NULL default '', `sl_waittime_y` varchar(20) NOT NULL default '', `sl_waittime_r` varchar(20) NOT NULL default '', `sl_talktime_y` varchar(20) NOT NULL default '', `sl_talktime_r` varchar(20) NOT NULL default '', `sys_dt_creazione` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_creazione` int(11) NOT NULL default '0', `sys_dt_modifica` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_modifica` int(11) NOT NULL default '0', `sys_optilock` int(11) NOT NULL default '0', `chat_group` varchar(50) NOT NULL, `agaw_lookback_min` int(11) NOT NULL, `agaw_enabled` tinyint(4) NOT NULL, `queue_url` varchar(100) NOT NULL, PRIMARY KEY (`id_coda`), KEY `fetch_comp_coda` (`composizione_coda`(15))) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;---- Dumping data for table `code_possibili`--INSERT INTO `code_possibili` (`id_coda`, `nome_coda`, `composizione_coda`, `agenti_membri`, `agenti_spilloff_1`, `agenti_spilloff_2`, `wrapuptime`, `announcement_duration`, `visibility_key`, `q_direction`, `q_frontpage`, `sl_calls_y`, `sl_calls_r`, `sl_ag_calls_y`, `sl_ag_calls_r`, `sl_ag_wait_y`, `sl_ag_wait_r`, `sl_ag_pause_y`, `sl_ag_pause_r`, `sl_waittime_y`, `sl_waittime_r`, `sl_talktime_y`, `sl_talktime_r`, `sys_dt_creazione`, `sys_user_creazione`, `sys_dt_modifica`, `sys_user_modifica`, `sys_optilock`, `chat_group`, `agaw_lookback_min`, `agaw_enabled`, `queue_url`) VALUES(1, '00 All', 'queue-dps|queue-test|q1|q2', 'Agent/101|Agent/102', '', '', 0, 0, '', 'inbound', 1, '>1', '>5', '>2', '', '<2', '', '', '', '>30', '>60', '', '>300', '2007-06-18 22:30:26', 32, '2008-12-04 14:56:28', 32, 13239, '', 0, 0, ''),(2, 'Q DPS', 'queue-dps', 'Agent/101|Agent/102', '', '', 0, 0, '', 'inbound', 1, '', '', '', '', '', '', '', '', '', '', '', '', '2007-06-18 22:30:39', 32, '2008-12-04 14:58:19', 32, 23651, 'chat@chatserver', 720, 1, ''),(3, 'Q Test', 'queue-test', 'Agent/101|Agent/102', '', '', 0, 0, '', 'inbound', 1, '', '', '', '', '', '', '', '', '', '', '', '', '2007-06-18 22:30:49', 32, '2007-06-18 22:31:15', 32, 39403, '', 0, 0, '');-- ------------------------------------------------------------ Table structure for table `dbversion`--CREATE TABLE IF NOT EXISTS `dbversion` ( `version_id` int(11) NOT NULL default '0', `lic_version` varchar(45) NOT NULL default '', `lic_approved` varchar(45) NOT NULL default '', `plex_id` varchar(70) NOT NULL default '') ENGINE=MyISAM DEFAULT CHARSET=latin1;---- Dumping data for table `dbversion`--INSERT INTO `dbversion` (`version_id`, `lic_version`, `lic_approved`, `plex_id`) VALUES(19, '', 'xx1.5.4', '');-- ------------------------------------------------------------ Table structure for table `locations`--CREATE TABLE IF NOT EXISTS `locations` ( `id_location` int(11) NOT NULL auto_increment, `loc_name` varchar(100) NOT NULL default '', `loc_description` varchar(250) NOT NULL default '', `read_key` varchar(30) NOT NULL default '', `sys_dt_creazione` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_creazione` int(11) NOT NULL default '0', `sys_dt_modifica` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_modifica` int(11) NOT NULL default '0', `sys_optilock` int(11) NOT NULL default '0', PRIMARY KEY (`id_location`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;---- Dumping data for table `locations`--INSERT INTO `locations` (`id_location`, `loc_name`, `loc_description`, `read_key`, `sys_dt_creazione`, `sys_user_creazione`, `sys_dt_modifica`, `sys_user_modifica`, `sys_optilock`) VALUES(1, 'Main', 'Main Location', '', '2006-02-20 12:40:42', 5, '0000-00-00 00:00:00', 0, 77047),(3, 'Other', 'Secondary location', '', '2007-06-18 22:24:07', 32, '0000-00-00 00:00:00', 0, 44698);-- ------------------------------------------------------------ Table structure for table `oq_calls`--CREATE TABLE IF NOT EXISTS `oq_calls` ( `call_id` int(11) NOT NULL auto_increment, `oqueue_id` int(11) NOT NULL default '0', `number` varchar(50) NOT NULL default '', `person` varchar(100) NOT NULL default '', `descr` varchar(100) NOT NULL default '', `priority` int(11) NOT NULL default '0', `status` char(2) NOT NULL default '', `in_conversation` set('s','n') NOT NULL default '', `agent_conversation` varchar(50) NOT NULL default '', `sys_dt_creazione` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_creazione` int(11) NOT NULL default '0', `sys_dt_modifica` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_modifica` int(11) NOT NULL default '0', `sys_optilock` int(11) NOT NULL default '0', PRIMARY KEY (`call_id`), KEY `oqueue_id` (`oqueue_id`), KEY `conversation` (`in_conversation`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;---- Dumping data for table `oq_calls`---- ------------------------------------------------------------ Table structure for table `oq_notes`--CREATE TABLE IF NOT EXISTS `oq_notes` ( `oq_note_id` int(11) NOT NULL auto_increment, `oq_call_id` int(11) NOT NULL default '0', `note` text NOT NULL, `status` char(2) NOT NULL default '', `sys_dt_creazione` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_creazione` int(11) NOT NULL default '0', `sys_dt_modifica` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_modifica` int(11) NOT NULL default '0', `sys_optilock` int(11) NOT NULL default '0', PRIMARY KEY (`oq_note_id`), KEY `oq_call_id` (`oq_call_id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;---- Dumping data for table `oq_notes`---- ------------------------------------------------------------ Table structure for table `oq_queues`--CREATE TABLE IF NOT EXISTS `oq_queues` ( `oq_id` int(11) NOT NULL auto_increment, `nome` varchar(50) NOT NULL default '', `visibility_key` varchar(50) NOT NULL default '', `sys_dt_creazione` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_creazione` int(11) NOT NULL default '0', `sys_dt_modifica` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_modifica` int(11) NOT NULL default '0', `sys_optilock` int(11) NOT NULL default '0', PRIMARY KEY (`oq_id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;---- Dumping data for table `oq_queues`---- ------------------------------------------------------------ Table structure for table `pause_codes`--CREATE TABLE IF NOT EXISTS `pause_codes` ( `pcode_id` int(10) unsigned NOT NULL auto_increment, `pcode` varchar(45) NOT NULL default '', `pcode_desc` varchar(100) NOT NULL default '', `read_key` varchar(100) NOT NULL default '', `isBillable` tinyint(3) unsigned NOT NULL default '0', `pauseType` enum('-','w','o') NOT NULL default '-', `sys_dt_creazione` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_creazione` int(11) NOT NULL default '0', `sys_dt_modifica` datetime NOT NULL default '0000-00-00 00:00:00', `sys_user_modifica` int(11) NOT NULL default '0', `sys_optilock` int(11) NOT NULL default '0', PRIMARY KEY (`pcode_id`), KEY `byCode` (`pcode`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Codici di pausa' AUTO_INCREMENT=14 ;---- Dumping data for table `pause_codes`--INSERT INTO `pause_codes` (`pcode_id`, `pcode`, `pcode_desc`, `read_key`, `isBillable`, `pauseType`, `sys_dt_creazione`, `sys_user_creazione`, `sys_dt_modifica`, `sys_user_modifica`, `sys_optilock`) VALUES(12, '13', 'Backoffice', '', 1, '-', '2007-06-18 22:25:54', 32, '0000-00-00 00:00:00', 0, 41093),(11, '12', 'Email', '', 1, '-', '2007-06-18 22:25:42', 32, '0000-00-00 00:00:00', 0, 4864),(10, '11', 'Hourly break', '', 0, '-', '2007-06-18 22:25:29', 32, '0000-00-00 00:00:00', 0, 82109),(9, '10', 'Lunch', '', 0, '-', '2007-06-18 22:25:15', 32, '0000-00-00 00:00:00', 0, 66047),(13, '20', 'Wrap', '', 1, 'w', '2008-12-04 15:00:06', 32, '0000-00-00 00:00:00', 0, 81215);-- ------------------------------------------------------------ Table structure for table `qa_comments`--CREATE TABLE IF NOT EXISTS `qa_comments` ( `comment_id` int(11) NOT NULL auto_increment, `call_id` varchar(50) character set utf8 NOT NULL, `form_comment` text NOT NULL, `sys_dt_creazione` datetime NOT NULL, `sys_user_creazione` int(11) NOT NULL, `sys_dt_modifica` datetime NOT NULL, `sys_user_modifica` int(11) NOT NULL, `sys_optilock` int(11) NOT NULL, PRIMARY KEY (`comment_id`), KEY `by_callid` (`call_id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;---- Dumping data for table `qa_comments`---- ------------------------------------------------------------ Table structure for table `qa_data`--CREATE TABLE IF NOT EXISTS `qa_data` ( `qadata_id` int(11) NOT NULL auto_increment, `call_id` varchar(50) character set utf8 NOT NULL, `call_tst` int(11) default NULL, `call_caller` varchar(50) NOT NULL, `call_agent` varchar(50) NOT NULL, `call_agent_group_id` int(11) default '0', `call_queue` varchar(50) NOT NULL, `call_status_code` varchar(45) default NULL, `form_id` int(11) NOT NULL, `status` varchar(10) NOT NULL default 'A', `form_comment` varchar(250) NOT NULL, `itemval_1` tinyint(4) default NULL, `itemval_2` tinyint(4) default NULL, `itemval_3` tinyint(4) default NULL, `itemval_4` tinyint(4) default NULL, `itemval_5` tinyint(4) default NULL, `itemval_6` tinyint(4) default NULL, `itemval_7` tinyint(4) default NULL, `itemval_8` tinyint(4) default NULL, `itemval_9` tinyint(4) default NULL, `itemval_10` tinyint(4) default NULL, `itemval_11` tinyint(4) default NULL, `itemval_12` tinyint(4) default NULL, `itemval_13` tinyint(4) default NULL, `itemval_14` tinyint(4) default NULL, `itemval_15` tinyint(4) default NULL, `itemval_16` tinyint(4) default NULL, `itemval_17` tinyint(4) default NULL, `itemval_18` tinyint(4) default NULL, `itemval_19` tinyint(4) default NULL, `itemval_20` tinyint(4) default NULL, `itemval_21` tinyint(4) default NULL, `itemval_22` tinyint(4) default NULL, `itemval_23` tinyint(4) default NULL, `itemval_24` tinyint(4) default NULL, `itemval_25` tinyint(4) default NULL, `itemval_26` tinyint(4) default NULL, `itemval_27` tinyint(4) default NULL, `itemval_28` tinyint(4) default NULL, `itemval_29` tinyint(4) default NULL, `itemval_30` tinyint(4) default NULL, `itemval_31` tinyint(4) default NULL, `itemval_32` tinyint(4) default NULL, `itemval_33` tinyint(4) default NULL, `itemval_34` tinyint(4) default NULL, `itemval_35` tinyint(4) default NULL, `itemval_36` tinyint(4) default NULL, `itemval_37` tinyint(4) default NULL, `itemval_38` tinyint(4) default NULL, `itemval_39` tinyint(4) default NULL, `itemval_40` tinyint(4) default NULL, `itemval_41` tinyint(4) default NULL, `itemval_42` tinyint(4) default NULL, `itemval_43` tinyint(4) default NULL, `itemval_44` tinyint(4) default NULL, `itemval_45` tinyint(4) default NULL, `itemval_46` tinyint(4) default NULL, `itemval_47` tinyint(4) default NULL, `itemval_48` tinyint(4) default NULL, `itemval_49` tinyint(4) default NULL, `itemval_50` tinyint(4) default NULL, `itemval_51` tinyint(4) default NULL, `itemval_52` tinyint(4) default NULL, `itemval_53` tinyint(4) default NULL, `itemval_54` tinyint(4) default NULL, `itemval_55` tinyint(4) default NULL, `itemval_56` tinyint(4) default NULL, `itemval_57` tinyint(4) default NULL, `itemval_58` tinyint(4) default NULL, `itemval_59` tinyint(4) default NULL, `itemval_60` tinyint(4) default NULL, `itemval_61` tinyint(4) default NULL, `itemval_62` tinyint(4) default NULL, `itemval_63` tinyint(4) default NULL, `itemval_64` tinyint(4) default NULL, `itemval_65` tinyint(4) default NULL, `itemval_66` tinyint(4) default NULL, `itemval_67` tinyint(4) default NULL, `itemval_68` tinyint(4) default NULL, `itemval_69` tinyint(4) default NULL, `itemval_70` tinyint(4) default NULL, `itemval_71` tinyint(4) default NULL, `itemval_72` tinyint(4) default NULL, `itemval_73` tinyint(4) default NULL, `itemval_74` tinyint(4) default NULL, `itemval_75` tinyint(4) default NULL, `itemval_76` tinyint(4) default NULL, `itemval_77` tinyint(4) default NULL, `itemval_78` tinyint(4) default NULL, `itemval_79` tinyint(4) default NULL, `itemval_80` tinyint(4) default NULL, `itemval_81` tinyint(4) default NULL, `itemval_82` tinyint(4) default NULL, `itemval_83` tinyint(4) default NULL, `itemval_84` tinyint(4) default NULL, `itemval_85` tinyint(4) default NULL, `itemval_86` tinyint(4) default NULL, `itemval_87` tinyint(4) default NULL, `itemval_88` tinyint(4) default NULL, `itemval_89` tinyint(4) default NULL, `itemval_90` tinyint(4) default NULL, `itemval_91` tinyint(4) default NULL, `itemval_92` tinyint(4) default NULL, `itemval_93` tinyint(4) default NULL, `itemval_94` tinyint(4) default NULL, `itemval_95` tinyint(4) default NULL, `itemval_96` tinyint(4) default NULL, `itemval_97` tinyint(4) default NULL, `itemval_98` tinyint(4) default NULL, `itemval_99` tinyint(4) default NULL, `itemval_100` tinyint(4) default NULL, `itemval_101` tinyint(4) default NULL, `itemval_102` tinyint(4) default NULL, `itemval_103` tinyint(4) default NULL, `itemval_104` tinyint(4) default NULL, `itemval_105` tinyint(4) default NULL, `itemval_106` tinyint(4) default NULL, `itemval_107` tinyint(4) default NULL, `itemval_108` tinyint(4) default NULL, `itemval_109` tinyint(4) default NULL, `itemval_110` tinyint(4) default NULL, `itemval_111` tinyint(4) default NULL, `itemval_112` tinyint(4) default NULL, `itemval_113` tinyint(4) default NULL, `itemval_114` tinyint(4) default NULL, `itemval_115` tinyint(4) default NULL, `itemval_116` tinyint(4) default NULL, `itemval_117` tinyint(4) default NULL, `itemval_118` tinyint(4) default NULL, `itemval_119` tinyint(4) default NULL, `itemval_120` tinyint(4) default NULL, `itemval_121` tinyint(4) default NULL, `itemval_122` tinyint(4) default NULL, `itemval_123` tinyint(4) default NULL, `itemval_124` tinyint(4) default NULL, `itemval_125` tinyint(4) default NULL, `itemval_126` tinyint(4) default NULL, `itemval_127` tinyint(4) default NULL, `itemval_128` tinyint(4) default NULL, `itemval_129` tinyint(4) default NULL, `itemval_130` tinyint(4) default NULL, `score_1` mediumint(8) unsigned default '0', `score_2` mediumint(8) unsigned default '0', `score_3` mediumint(8) unsigned default '0', `score_4` mediumint(8) unsigned default '0', `score_5` mediumint(8) unsigned default '0', `score_6` mediumint(8) unsigned default '0', `score_7` mediumint(8) unsigned default '0', `score_8` mediumint(8) unsigned default '0', `score_9` mediumint(8) unsigned default '0', `score_10` mediumint(8) unsigned default '0', `shortcut_present` tinyint(1) NOT NULL default '0', `sectionweight_1` mediumint(8) unsigned NOT NULL default '1', `sectionweight_2` mediumint(8) unsigned NOT NULL default '1', `sectionweight_3` mediumint(8) unsigned NOT NULL default '1', `sectionweight_4` mediumint(8) unsigned NOT NULL default '1', `sectionweight_5` mediumint(8) unsigned NOT NULL default '1', `sectionweight_6` mediumint(8) unsigned NOT NULL default '1', `sectionweight_7` mediumint(8) unsigned NOT NULL default '1', `sectionweight_8` mediumint(8) unsigned NOT NULL default '1', `sectionweight_9` mediumint(8) unsigned NOT NULL default '1', `sectionweight_10` mediumint(8) unsigned NOT NULL default '1', `sys_dt_creazione` datetime NOT NULL, `sys_user_creazione` int(11) NOT NULL, `sys_dt_modifica` datetime NOT NULL, `sys_user_modifica` int(11) NOT NULL, `sys_optilock` int(11) NOT NULL, PRIMARY KEY (`qadata_id`), KEY `by_form_q_tst` (`form_id`,`call_queue`,`call_tst`), KEY `by_call_id_2` (`call_id`,`sys_user_creazione`), KEY `by_formid_tst` (`form_id`,`call_tst`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;---- Dumping data for table `qa_data`---- ------------------------------------------------------------ Table structure for table `qa_forms`--CREATE TABLE IF NOT EXISTS `qa_forms` ( `form_id` int(11) NOT NULL auto_increment, `nome_form` varchar(50) NOT NULL, `seckey_input` varchar(50) default NULL, `seckey_report` varchar(50) NOT NULL, `is_locked` set('y','n') NOT NULL default 'n', `section_1` varchar(50) NOT NULL, `section_2` varchar(50) NOT NULL, `section_3` varchar(50) NOT NULL, `section_4` varchar(50) NOT NULL, `section_5` varchar(50) NOT NULL, `section_6` varchar(50) NOT NULL, `section_7` varchar(50) NOT NULL, `section_8` varchar(50) NOT NULL, `section_9` varchar(50) NOT NULL, `section_10` varchar(50) NOT NULL, `section_1_len` tinyint(4) NOT NULL, `section_2_len` tinyint(4) NOT NULL, `section_3_len` tinyint(4) NOT NULL, `section_4_len` tinyint(4) NOT NULL, `section_5_len` tinyint(4) NOT NULL, `section_6_len` tinyint(4) NOT NULL, `section_7_len` tinyint(4) NOT NULL, `section_8_len` tinyint(4) NOT NULL, `section_9_len` tinyint(4) NOT NULL, `section_10_len` tinyint(4) NOT NULL, `rating_1` tinyint(4) NOT NULL, `rating_2` tinyint(4) NOT NULL, `rating_3` tinyint(4) NOT NULL, `item_1` varchar(5) NOT NULL, `item_2` varchar(5) NOT NULL, `item_3` varchar(5) NOT NULL, `item_4` varchar(5) NOT NULL, `item_5` varchar(5) NOT NULL, `item_6` varchar(5) NOT NULL, `item_7` varchar(5) NOT NULL, `item_8` varchar(5) NOT NULL, `item_9` varchar(5) NOT NULL, `item_10` varchar(5) NOT NULL, `item_11` varchar(5) NOT NULL, `item_12` varchar(5) NOT NULL, `item_13` varchar(5) NOT NULL, `item_14` varchar(5) NOT NULL, `item_15` varchar(5) NOT NULL, `item_16` varchar(5) NOT NULL, `item_17` varchar(5) NOT NULL, `item_18` varchar(5) NOT NULL, `item_19` varchar(5) NOT NULL, `item_20` varchar(5) NOT NULL, `item_21` varchar(5) NOT NULL, `item_22` varchar(5) NOT NULL, `item_23` varchar(5) NOT NULL, `item_24` varchar(5) NOT NULL, `item_25` varchar(5) NOT NULL, `item_26` varchar(5) NOT NULL, `item_27` varchar(5) NOT NULL, `item_28` varchar(5) NOT NULL, `item_29` varchar(5) NOT NULL, `item_30` varchar(5) NOT NULL, `item_31` varchar(5) NOT NULL, `item_32` varchar(5) NOT NULL, `item_33` varchar(5) NOT NULL, `item_34` varchar(5) NOT NULL, `item_35` varchar(5) NOT NULL, `item_36` varchar(5) NOT NULL, `item_37` varchar(5) NOT NULL, `item_38` varchar(5) NOT NULL, `item_39` varchar(5) NOT NULL, `item_40` varchar(5) NOT NULL, `item_41` varchar(5) NOT NULL, `item_42` varchar(5) NOT NULL, `item_43` varchar(5) NOT NULL, `item_44` varchar(5) NOT NULL, `item_45` varchar(5) NOT NULL, `item_46` varchar(5) NOT NULL, `item_47` varchar(5) NOT NULL, `item_48` varchar(5) NOT NULL, `item_49` varchar(5) NOT NULL, `item_50` varchar(5) NOT NULL, `item_51` varchar(5) NOT NULL, `item_52` varchar(5) NOT NULL, `item_53` varchar(5) NOT NULL, `item_54` varchar(5) NOT NULL, `item_55` varchar(5) NOT NULL, `item_56` varchar(5) NOT NULL, `item_57` varchar(5) NOT NULL, `item_58` varchar(5) NOT NULL, `item_59` varchar(5) NOT NULL, `item_60` varchar(5) NOT NULL, `item_61` varchar(5) NOT NULL, `item_62` varchar(5) NOT NULL, `item_63` varchar(5) NOT NULL, `item_64` varchar(5) NOT NULL, `item_65` varchar(5) NOT NULL, `item_66` varchar(5) NOT NULL, `item_67` varchar(5) NOT NULL, `item_68` varchar(5) NOT NULL, `item_69` varchar(5) NOT NULL, `item_70` varchar(5) NOT NULL, `item_71` varchar(5) NOT NULL, `item_72` varchar(5) NOT NULL, `item_73` varchar(5) NOT NULL, `item_74` varchar(5) NOT NULL, `item_75` varchar(5) NOT NULL, `item_76` varchar(5) NOT NULL, `item_77` varchar(5) NOT NULL, `item_78` varchar(5) NOT NULL, `item_79` varchar(5) NOT NULL, `item_80` varchar(5) NOT NULL, `item_81` varchar(5) NOT NULL, `item_82` varchar(5) NOT NULL, `item_83` varchar(5) NOT NULL, `item_84` varchar(5) NOT NULL, `item_85` varchar(5) NOT NULL, `item_86` varchar(5) NOT NULL, `item_87` varchar(5) NOT NULL, `item_88` varchar(5) NOT NULL, `item_89` varchar(5) NOT NULL, `item_90` varchar(5) NOT NULL, `item_91` varchar(5) NOT NULL, `item_92` varchar(5) NOT NULL, `item_93` varchar(5) NOT NULL, `item_94` varchar(5) NOT NULL, `item_95` varchar(5) NOT NULL, `item_96` varchar(5) NOT NULL, `item_97` varchar(5) NOT NULL, `item_98` varchar(5) NOT NULL, `item_99` varchar(5) NOT NULL, `item_100` varchar(5) NOT NULL, `item_101` varchar(5) NOT NULL, `item_102` varchar(5) NOT NULL, `item_103` varchar(5) NOT NULL, `item_104` varchar(5) NOT NULL, `item_105` varchar(5) NOT NULL, `item_106` varchar(5) NOT NULL, `item_107` varchar(5) NOT NULL, `item_108` varchar(5) NOT NULL, `item_109` varchar(5) NOT NULL, `item_110` varchar(5) NOT NULL, `item_111` varchar(5) NOT NULL, `item_112` varchar(5) NOT NULL, `item_113` varchar(5) NOT NULL, `item_114` varchar(5) NOT NULL, `item_115` varchar(5) NOT NULL, `item_116` varchar(5) NOT NULL, `item_117` varchar(5) NOT NULL, `item_118` varchar(5) NOT NULL, `item_119` varchar(5) NOT NULL, `item_120` varchar(5) NOT NULL, `item_121` varchar(5) NOT NULL, `item_122` varchar(5) NOT NULL, `item_123` varchar(5) NOT NULL, `item_124` varchar(5) NOT NULL, `item_125` varchar(5) NOT NULL, `item_126` varchar(5) NOT NULL, `item_127` varchar(5) NOT NULL, `item_128` varchar(5) NOT NULL, `item_129` varchar(5) NOT NULL, `item_130` varchar(5) NOT NULL, `sys_dt_creazione` datetime NOT NULL, `sys_user_creazione` int(11) NOT NULL, `sys_dt_modifica` datetime NOT NULL, `sys_user_modifica` int(11) NOT NULL, `sys_optilock` int(11) NOT NULL, PRIMARY KEY (`form_id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;---- Dumping data for table `qa_forms`--INSERT INTO `qa_forms` (`form_id`, `nome_form`, `seckey_input`, `seckey_report`, `is_locked`, `section_1`, `section_2`, `section_3`, `section_4`, `section_5`, `section_6`, `section_7`, `section_8`, `section_9`, `section_10`, `section_1_len`, `section_2_len`, `section_3_len`, `section_4_len`, `section_5_len`, `section_6_len`, `section_7_len`, `section_8_len`, `section_9_len`, `section_10_len`, `rating_1`, `rating_2`, `rating_3`, `item_1`, `item_2`, `item_3`, `item_4`, `item_5`, `item_6`, `item_7`, `item_8`, `item_9`, `item_10`, `item_11`, `item_12`, `item_13`, `item_14`, `item_15`, `item_16`, `item_17`, `item_18`, `item_19`, `item_20`, `item_21`, `item_22`, `item_23`, `item_24`, `item_25`, `item_26`, `item_27`, `item_28`, `item_29`, `item_30`, `item_31`, `item_32`, `item_33`, `item_34`, `item_35`, `item_36`, `item_37`, `item_38`, `item_39`, `item_40`, `item_41`, `item_42`, `item_43`, `item_44`, `item_45`, `item_46`, `item_47`, `item_48`, `item_49`, `item_50`, `item_51`, `item_52`, `item_53`, `item_54`, `item_55`, `item_56`, `item_57`, `item_58`, `item_59`, `item_60`, `item_61`, `item_62`, `item_63`, `item_64`, `item_65`, `item_66`, `item_67`, `item_68`, `item_69`, `item_70`, `item_71`, `item_72`, `item_73`, `item_74`, `item_75`, `item_76`, `item_77`, `item_78`, `item_79`, `item_80`, `item_81`, `item_82`, `item_83`, `item_84`, `item_85`, `item_86`, `item_87`, `item_88`, `item_89`, `item_90`, `item_91`, `item_92`, `item_93`, `item_94`, `item_95`, `item_96`, `item_97`, `item_98`, `item_99`, `item_100`, `item_101`, `item_102`, `item_103`, `item_104`, `item_105`, `item_106`, `item_107`, `item_108`, `item_109`, `item_110`, `item_111`, `item_112`, `item_113`, `item_114`, `item_115`, `item_116`, `item_117`, `item_118`, `item_119`, `item_120`, `item_121`, `item_122`, `item_123`, `item_124`, `item_125`, `item_126`, `item_127`, `item_128`, `item_129`, `item_130`, `sys_dt_creazione`, `sys_user_creazione`, `sys_dt_modifica`, `sys_user_modifica`, `sys_optilock`) VALUES(5, 'Quality Assurance', '', '', '', 'Engagement', 'Resolution', 'Business needs', '', '', '', '', '', '', '', 9, 5, 1, 0, 0, 0, 0, 0, 0, 0, 25, 50, 75, 'SCG', 'COU', 'ENE', 'TON', 'CLE', 'HOL', 'DEE', 'LIS', 'CLO', 'ASS', 'REL', 'HEL', 'PRO', 'TIM', 'DBC', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '2008-03-15 15:22:09', 32, '2008-03-15 15:24:16', 32, 29959);-- ------------------------------------------------------------ Table structure for table `qa_forms_items`--CREATE TABLE IF NOT EXISTS `qa_forms_items` ( `item_id` int(11) NOT NULL auto_increment, `item_code` varchar(5) NOT NULL, `item_desc` varchar(100) NOT NULL, `valuetype` enum('yesno','dropdown','freevalue') default 'freevalue', `ddranges` text character set utf8, `weight` tinyint(4) default '1', `shortcut` tinyint(1) default '0', `mandatory` tinyint(1) NOT NULL default '1', `sys_dt_creazione` datetime NOT NULL, `sys_user_creazione` int(11) NOT NULL, `sys_dt_modifica` datetime NOT NULL, `sys_user_modifica` int(11) NOT NULL, `sys_optilock` int(11) NOT NULL, PRIMARY KEY (`item_id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;---- Dumping data for table `qa_forms_items`--INSERT INTO `qa_forms_items` (`item_id`, `item_code`, `item_desc`, `valuetype`, `ddranges`, `weight`, `shortcut`, `mandatory`, `sys_dt_creazione`, `sys_user_creazione`, `sys_dt_modifica`, `sys_user_modifica`, `sys_optilock`) VALUES(1, 'SCG', 'How positive clear and eager was the use of the Corporate greeting?', 'freevalue', NULL, 1, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0),(2, 'COU', 'How well did the rep display courtesy?', 'freevalue', NULL, 1, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0),(3, 'ENE', 'Rate rep''s enery level throughout the call', 'freevalue', NULL, 1, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0),(4, 'ASS', 'Was assurance given for client''s assistance?', 'freevalue', NULL, 1, 0, 1, '0000-00-00 00:00:00', 0, '2008-03-14 17:57:42', 32, 893),(5, 'REL', 'How accurate and relevant was the information provided?', 'freevalue', NULL, 1, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0),(6, 'DBC', 'Was DBC done?', 'freevalue', NULL, 1, 0, 1, '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', 0, 0),(14, 'CLE', 'How clear and concise was the rep''s vocalization and pronunciation?', 'freevalue', NULL, 1, 0, 1, '2008-03-15 15:18:51', 32, '0000-00-00 00:00:00', 0, 54831),(13, 'TON', 'How well did the rep vary the tone and speed of speech?', 'freevalue', NULL, 1, 0, 1, '2008-03-15 15:18:26', 32, '0000-00-00 00:00:00', 0, 32158),(15, 'HOL', 'Did the rep use the correct hold procedure?', 'freevalue', NULL, 1, 0, 1, '2008-03-15 15:19:13', 32, '0000-00-00 00:00:00', 0, 1008),(16, 'DEE', 'Did the rep avoid deed air?', 'freevalue', NULL, 1, 0, 1, '2008-03-15 15:19:24', 32, '0000-00-00 00:00:00', 0, 17570),(17, 'LIS', 'Did the rep display active listening skills?', 'freevalue', NULL, 1, 0, 1, '2008-03-15 15:19:47', 32, '0000-00-00 00:00:00', 0, 34695),(18, 'CLO', 'How positive and appropriate was the call closure phase?', 'freevalue', NULL, 1, 0, 1, '2008-03-15 15:20:05', 32, '0000-00-00 00:00:00', 0, 46685),(19, 'HEL', 'Was additional help offered with enthusiasm?', 'freevalue', NULL, 1, 0, 1, '2008-03-15 15:20:37', 32, '0000-00-00 00:00:00', 0, 25434),(20, 'PRO', 'Was the problem resolved on first contact?', 'freevalue', NULL, 1, 0, 1, '2008-03-15 15:20:52', 32, '0000-00-00 00:00:00', 0, 19127),(21, 'TIM', 'Did the rep manage time effectively?', 'freevalue', NULL, 1, 0, 1, '2008-03-15 15:21:04', 32, '0000-00-00 00:00:00', 0, 72653);-- ------------------------------------------------------------ Table structure for table `qlog_opencalls`--CREATE TABLE IF NOT EXISTS `qlog_opencalls` ( `rowId` int(10) unsigned NOT NULL auto_increment, `partition` varchar(20) NOT NULL default '', `callId` varchar(45) NOT NULL default '', `queue` varchar(45) NOT NULL default '', `subqueue` varchar(45) NOT NULL default '', `lastVerb` varchar(45) NOT NULL default '', `lastTst` int(10) unsigned NOT NULL default '0', `lastUpd` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`rowId`), KEY `accIdx1` (`callId`,`partition`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=43289 ;---- Dumping data for table `qlog_opencalls`---- ------------------------------------------------------------ Table structure for table `qm_reports`--CREATE TABLE IF NOT EXISTS `qm_reports` ( `item_id` int(11) NOT NULL auto_increment, `parent` int(11) NOT NULL, `item_type` enum('rep','rt','wb','scr','ite') NOT NULL, `visibility_key` varchar(50) NOT NULL, `name_short` varchar(100) NOT NULL, `title` varchar(100) NOT NULL, `subtitle` varchar(100) NOT NULL, `dataobject` varchar(100) NOT NULL, `parameters` varchar(200) NOT NULL, `sort_order` int(11) NOT NULL, `visible_in_all` tinyint(4) NOT NULL default '1', `sys_dt_creazione` datetime NOT NULL, `sys_user_creazione` int(11) NOT NULL, `sys_dt_modifica` datetime NOT NULL, `sys_user_modifica` int(11) NOT NULL, `sys_optilock` int(11) NOT NULL, PRIMARY KEY (`item_id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=85 ;---- Dumping data for table `qm_reports`--INSERT INTO `qm_reports` (`item_id`, `parent`, `item_type`, `visibility_key`, `name_short`, `title`, `subtitle`, `dataobject`, `parameters`, `sort_order`, `visible_in_all`, `sys_dt_creazione`, `sys_user_creazione`, `sys_dt_modifica`, `sys_user_modifica`, `sys_optilock`) VALUES(1, 0, 'rep', '', '', 'All Reports', '', '', '', 0, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 37082),(2, 1, 'scr', '', '#hdr_answered#', '#clok_answered_calls#', '', '', '', 10, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 60612),(3, 2, 'ite', '', '', '#clok_all_calls#', '', 'OkDO.RiassAllCalls', '', 10, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 78560),(4, 2, 'ite', '', '', '#clok_calls_fully_within_the_given_time_interval#', '', 'OkDO.RiassFullyWithin', '', 20, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 17671),(5, 2, 'ite', '', '', '#clok_agents_on_queue#', '', 'OkDO.AgentsOnQueue', '', 30, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 51454),(6, 2, 'ite', '', '', '#clok_service_level_agreement#', '', 'OkDO.ServiceLevelAgreement', '', 40, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 61413),(7, 2, 'ite', '', '', '#clok_disconnection_causes#', '', 'OkDO.DisconnectionCauses', '', 50, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 51360),(8, 2, 'ite', '', '', '#clok_transfers#', '', 'OkDO.Transfers', '', 60, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 4513),(9, 2, 'ite', '', '', '#clok_answered_calls_by_queue#', '', 'OkDO.AnsweredcallsByQueue', '', 70, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 48693),(10, 2, 'ite', '', '', '#clok_answered_calls_by_direction#', '', 'OkDO.AnsweredcallsByDirection', '', 80, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 16289),(11, 2, 'ite', '', '', '#clok_stints#', '', 'OkDO.StintsOk', '', 90, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 26749),(12, 2, 'ite', '', '', '#clok_queue_position#', '', 'OkDO.QPosOk', '', 100, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 15669),(13, 2, 'ite', '', '', '#clok_ivr#', '', 'OkDO.IvrOk', '', 110, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 95748),(14, 2, 'ite', '', '', '#clok_dnis#', '', 'OkDO.DnisOk', '', 120, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 41960),(15, 1, 'scr', '', '#hdr_answered_details#', '#hdr_answered_details_title#', '', '', '', 20, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 19648),(16, 15, 'ite', '', '', '#cld_queue_detail#', '', 'DetailsDO.CallsOK', '', 10, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 4394),(17, 1, 'scr', '', '#hdr_unanswered#', '#hdr_unanswered#', '', '', '', 30, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 9086),(18, 17, 'ite', '', '', '#clko_all_calls#', '', 'KoDO.ReportKoAll', '', 10, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 78346),(19, 17, 'ite', '', '', '#clko_calls_fully_within_the_given_time_interval#', '', 'KoDO.ReportKoFully', '', 20, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 69768),(20, 17, 'ite', '', '', '#clko_disconnection_causes#', '', 'KoDO.DiscCauses', '', 30, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 94648),(21, 17, 'ite', '', '', '#clko_unanswered_calls_by_queue#', '', 'KoDO.UnansByQueue', '', 40, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 52956),(22, 17, 'ite', '', '', '#clko_unanswered_outbound#', '', 'KoDO.OutboundKo', '', 50, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 23845),(23, 17, 'ite', '', '', '#clko_unanswered_calls_distribution_by_length#', '', 'KoDO.UnansByLen', '', 60, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 43349),(24, 17, 'ite', '', '', '#clko_inclusive_sla_computed#', '', 'KoDO.InclusiveSLA', '', 70, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 75336),(25, 17, 'ite', '', '', '#clko_keypress#', '', 'KoDO.ReportKoKeyPress', '', 80, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 82267),(26, 17, 'ite', '', '', '#clko_stints_ko#', '', 'KoDO.StintsKo', '', 90, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 42841),(27, 17, 'ite', '', '', '#clko_stints_all#', '', 'KoDO.StintsOkKo', '', 100, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 61039),(28, 17, 'ite', '', '', '#clko_qpos_ko#', '', 'KoDO.QPosKo', '', 110, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 34069),(29, 17, 'ite', '', '', '#clko_qpos_all#', '', 'KoDO.QPosOkKo', '', 120, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 14340),(30, 17, 'ite', '', '', '#clko_ivr_ko#', '', 'KoDO.IvrKo', '', 130, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 20196),(31, 17, 'ite', '', '', '#clko_ivr_all#', '', 'KoDO.IvrOkKo', '', 140, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 86803),(32, 17, 'ite', '', '', '#clko_dnis_ko#', '', 'KoDO.DnisKo', '', 150, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 46824),(33, 17, 'ite', '', '', '#clko_dnis_all#', '', 'KoDO.DnisOkKo', '', 160, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 62717),(34, 1, 'scr', '', '#hdr_unanswered_details#', '#hdr_unanswered_details_title#', '', '', '', 40, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 24622),(35, 34, 'ite', '', '', '#cld_detail_of_unanswered_calls#', '', 'DetailsDO.CallsKO', '', 10, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 19511),(36, 1, 'scr', '', '#hdr_area#', '#hdr_area_title#', '', '', '', 50, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 97391),(37, 36, 'ite', '', '', '#carea_area_code_report#', '', 'AreaAnDO.Setup', '', 10, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 55799),(38, 36, 'ite', '', '', '#carea_detail_for_answered_calls#', '', 'AreaAnDO.CallsOK', '', 20, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 95711),(39, 36, 'ite', '', '', '#carea_detail_for_unanswered_calls#', '', 'AreaAnDO.CallsKO', '', 30, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 26199),(40, 1, 'scr', '', '#hdr_attempts#', '#hdr_distrib#', '', '', '', 60, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 73643),(41, 40, 'ite', '', '', '#clacd_inbound_acd_call_attempts#', '', 'DistrDO.ReportAcd', '', 10, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 93194),(42, 40, 'ite', '', '', '#clacd_acd_attempts_by_queue#', '', 'DistrDO.AcdByQueue', '', 20, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 87846),(43, 40, 'ite', '', '', '#clacd_acd_attempts_by_terminal#', '', 'DistrDO.AcdByTerminals', '', 30, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 44012),(44, 1, 'scr', '', '#hdr_distrib_day#', '#hdr_distrib_day_title#', '', '', '', 70, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 76438),(45, 44, 'ite', '', '', '#cldst_answered_call_distribution_per_day#', '', 'CallDistrDO.AnsDistrPerDay', '', 10, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 63542),(46, 44, 'ite', '', '', '#cldst_answered_call_wait_time_per_day#', '', 'CallDistrDO.AnsWaitPerDay', '', 20, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 88277),(47, 44, 'ite', '', '', '#cldst_unanswered_call_wait_time_per_day#', '', 'CallDistrDO.UnansWaitPerDay', '', 30, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 56419),(48, 44, 'ite', '', '', '#cldst_sales_per_day#', '', 'CallDistrDO.SalesPerDay', '', 40, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 81354),(49, 44, 'ite', '', '', '#cldst_schedule_per_day#', '', 'CallDistrDO.StaffPerDay', '', 50, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 58924),(50, 44, 'ite', '', '', '#cldst_queue_length_per_day#', '', 'CallDistrDO.QPosPerDay', '', 60, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 76380),(51, 44, 'ite', '', '', '#cldst_inclusive_sla_per_day#', '', 'CallDistrDO.InclSlaPerDay', '', 70, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 18553),(52, 1, 'scr', '', '#hdr_distrib_hour#', '#hdr_distrib_hour_title#', '', '', '', 80, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 13475),(53, 52, 'ite', '', '', '#cldst_answered_call_distribution_per_hour#', '', 'CallDistrDO.AnsDistrPerHr', '', 10, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 73075),(54, 52, 'ite', '', '', '#cldst_answered_call_wait_time_per_hour#', '', 'CallDistrDO.AnsWaitPerHr', '', 20, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 6446),(55, 52, 'ite', '', '', '#cldst_unanswered_call_wait_time_per_hour#', '', 'CallDistrDO.UnansWaitPerHr', '', 30, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 66380),(56, 52, 'ite', '', '', '#cldst_sales_per_hour#', '', 'CallDistrDO.SalesPerHr', '', 40, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 31090),(57, 52, 'ite', '', '', '#cldst_schedule_per_hour#', '', 'CallDistrDO.StaffPerHr', '', 50, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 63274),(58, 52, 'ite', '', '', '#cldst_queue_length_per_hour#', '', 'CallDistrDO.QPosPerHr', '', 60, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 77273),(59, 52, 'ite', '', '', '#cldst_inclusive_sla_per_hour#', '', 'CallDistrDO.InclSlaPerHr', '', 70, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 94898),(60, 1, 'scr', '', '#hdr_distrib_dow#', '#hdr_distrib_dow_title#', '', '', '', 90, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 65455),(61, 60, 'ite', '', '', '#cldst_answered_call_distribution_per_dow#', '', 'CallDistrDO.AnsDistrPerDOW', '', 10, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 89074),(62, 60, 'ite', '', '', '#cldst_answered_call_wait_time_per_dow#', '', 'CallDistrDO.AnsWaitPerDOW', '', 20, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 98473),(63, 60, 'ite', '', '', '#cldst_unanswered_call_wait_time_per_dow#', '', 'CallDistrDO.UnansWaitPerDOW', '', 30, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 31673),(64, 60, 'ite', '', '', '#cldst_sales_per_dow#', '', 'CallDistrDO.SalesPerDOW', '', 40, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 30619),(65, 60, 'ite', '', '', '#cldst_schedule_per_dow#', '', 'CallDistrDO.StaffPerDOW', '', 50, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 14981),(66, 60, 'ite', '', '', '#cldst_queue_length_per_dow#', '', 'CallDistrDO.QPosPerDOW', '', 60, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 75540),(67, 60, 'ite', '', '', '#cldst_inclusive_sla_per_dow#', '', 'CallDistrDO.InclSlaPerDOW', '', 70, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 63748),(68, 1, 'scr', '', '#hdr_agents#', '#hdr_agents_title#', '', '', '', 100, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 99892),(69, 68, 'ite', '', '', '#clage_agent_session_detail#', '', 'AgentsDO.ReportAgents', '', 10, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 78731),(70, 68, 'ite', '', '', '#clage_session_and_pause_durations#', '', 'AgentsDO.SessionPauseDur', '', 20, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 13631),(71, 68, 'ite', '', '', '#clage_agent_availability_for_all_the_queues_they_are_member_of#', '', 'AgentsDO.AgentAvail', '', 30, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 98363),(72, 68, 'ite', '', '', '#clage_answered_calls_for_selected_queues#', '', 'AgentsDO.AnsCallsQueues', '', 40, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 43632),(73, 68, 'ite', '', '', '#clage_answered_calls_by_custom_group#', '', 'AgentsDO.AnsCallsCG', '', 50, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 81999),(74, 68, 'ite', '', '', '#clage_answered_calls_by_location#', '', 'AgentsDO.AnsCallsLocation', '', 60, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 83420),(75, 68, 'ite', '', '', '#clage_answered_calls_by_service_group#', '', 'AgentsDO.AnsCallsSG', '', 70, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 50852),(76, 1, 'scr', '', '#hdr_agents_det#', '#hdr_agents_det_title#', '', '', '', 110, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 36807),(77, 76, 'ite', '', '', '#cld_detail_of_agent_sessions#', '', 'DetailsDO.AgentSessions', '', 10, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 56145),(78, 76, 'ite', '', '', '#cld_detail_of_agent_pauses#', '', 'DetailsDO.AgentPauses', '', 20, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 1478),(79, 1, 'scr', '', '#hdr_outcomes#', '#hdr_outcomes_title#', '', '', '', 120, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 56754),(80, 79, 'ite', '', '', '#aout_outcomes#', '', 'OutcomesDO.GeneralRep', '', 10, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 74212),(81, 79, 'ite', '', '', '#aout_call_res_by_outcome#', '', 'OutcomesDO.CallResByOutcome', '', 20, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 92079),(82, 79, 'ite', '', '', '#aout_act_billable#', '', 'OutcomesDO.ActivBillable', '', 30, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 52347),(83, 79, 'ite', '', '', '#aout_act_notbillable#', '', 'OutcomesDO.ActivNotBillable', '', 40, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 99381),(84, 79, 'ite', '', '', '#aout_agent_report#', '', 'OutcomesDO.AgentReportDetailed', '', 50, 1, '2010-01-27 10:39:26', 0, '0000-00-00 00:00:00', 0, 76195);-- ------------------------------------------------------------ Table structure for table `queue_log`--CREATE TABLE IF NOT EXISTS `queue_log` ( `partition` varchar(20) NOT NULL default '', `time_id` int(11) unsigned NOT NULL default '0', `call_id` varchar(30) NOT NULL default '', `queue` varchar(50) NOT NULL, `agent` varchar(30) NOT NULL default '', `verb` varchar(30) NOT NULL default '', `data1` varchar(200) default NULL, `data2` varchar(30) NOT NULL default '', `data3` varchar(30) NOT NULL default '', `data4` varchar(30) NOT NULL default '', `serverid` varchar(10) NOT NULL default '', `unique_row_count` int(10) unsigned NOT NULL auto_increment, KEY `idx_sel` (`partition`,`time_id`,`queue`(2)), KEY `partizione_b` (`partition`,`time_id`,`unique_row_count`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;---- Dumping data for table `queue_log`--