·SET NAMES 'UTF8'

·SELECT * FROM secure_level

·DESC setup value

·ALTER TABLE setup CHANGE value value text

·SELECT * FROM qagent WHERE agent_id=-1

·INSERT INTO qagent VALUES (-1,'ALL')

·DESC qname

·ALTER TABLE qname CHANGE qname_id queue_id int(6)

·SELECT * FROM qname WHERE queue_id=-1

·INSERT INTO qname VALUES (-1,'ALL')

·SELECT * FROM setup

·DESC designer

·SELECT * FROM designer

·SELECT * FROM qevent ORDER BY null

·INSERT INTO designer (keyword,parameter,value) VALUES ('EVENT_RECEIVED','','COMPLETECALLER,COMPLETEAGENT,ABANDON,EXITEMPTY,EXITWITHKEY,EXITWITHTIMEOUT,TRANSFER')

·INSERT INTO designer (keyword,parameter,value) VALUES ('EVENT_ANSWERED','','COMPLETECALLER,COMPLETEAGENT')

·INSERT INTO designer (keyword,parameter,value) VALUES ('EVENT_ABANDONED','','ABANDON')

·INSERT INTO designer (keyword,parameter,value) VALUES ('EVENT_UNANSWERED','','EXITEMPTY,EXITWITHKEY,EXITWITHTIMEOUT')

·INSERT INTO designer (keyword,parameter,value) VALUES ('EVENT_TRANSFERRED','','TRANSFER')

·INSERT INTO designer (keyword,parameter,value) VALUES ('EVENT_LOGIN','','AGENTLOGIN,ADDMEMBER')

·INSERT INTO designer (keyword,parameter,value) VALUES ('EVENT_LOGOUT','','AGENTLOGOFF,REMOVEMEMBER')

·DESC language

·SELECT * FROM language WHERE iso_code='en'

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','Sunday','Sunday',1)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','Monday','Monday',1)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','Tuesday','Tuesday',1)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','Wednesday','Wednesday',1)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','Thursday','Thursday',1)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','Friday','Friday',1)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','Saturday','Saturday',1)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','January','January',1)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','February','February',1)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','March','March',1)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','April','April',1)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','May','May',1)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','June','June',1)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','July','July',1)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','August','August',1)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','September','September',1)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','October','October',1)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','November','November',1)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','December','December',1)

·SELECT level FROM acl WHERE resource = 'index.php'

·SELECT detail FROM secure_level WHERE 255 & level

·INSERT INTO designer (keyword,parameter,value) VALUES ('agent_reports','','agent_summary.php,agent_availability.php,agent_durations.php,agent_pauses.php,agent_dispositions.php,agent_detail.php')

·INSERT INTO designer (keyword,parameter,value) VALUES ('unanswered_reports','','unanswered_calls_summary.php,unanswered_calls_by_holdtime.php,unanswered_calls_by_event.php,unanswered_calls_by_queue.php,unanswered_calls_by_url.php,unanswered_calls_by_did.php,unanswered_calls_detail.php')

·INSERT INTO designer (keyword,parameter,value) VALUES ('distribution_reports','','distribution_summary.php,distribution_by_queue.php,distribution_by_month.php,distribution_by_week.php,distribution_by_day.php,distribution_by_hour.php,distribution_by_day_of_week.php,distribution_by_url.php,distribution_by_did.php,distribution_detail.php')

·INSERT INTO designer (keyword,parameter,value) VALUES ('setup_reports','','admin-setup.php,admin-designer.php,admin-users.php,admin-acl.php,admin-language.php,admin-schedule.php')

·INSERT INTO designer (keyword,parameter,value) VALUES ('answered_reports','','answered_calls_summary.php,answered_calls_by_holdtime.php,answered_calls_by_queue.php,answered_calls_by_agent.php,answered_calls_by_event.php,answered_calls_by_url.php,answered_calls_by_did.php,answered_calls_by_duration.php,answered_calls_transferred.php,answered_calls_detail.php')

·INSERT INTO designer (keyword,parameter,value) VALUES ('realtime_reports','','realtime_queue_summary.php,realtime_agent_status.php,realtime_waiting_calls.php')

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='distribution_summary.php'

·INSERT INTO acl (resource,level) VALUES ('distribution_summary.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='distribution_by_queue.php'

·INSERT INTO acl (resource,level) VALUES ('distribution_by_queue.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='distribution_by_month.php'

·INSERT INTO acl (resource,level) VALUES ('distribution_by_month.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='distribution_by_week.php'

·INSERT INTO acl (resource,level) VALUES ('distribution_by_week.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='distribution_by_day.php'

·INSERT INTO acl (resource,level) VALUES ('distribution_by_day.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='distribution_by_hour.php'

·INSERT INTO acl (resource,level) VALUES ('distribution_by_hour.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='distribution_by_day_of_week.php'

·INSERT INTO acl (resource,level) VALUES ('distribution_by_day_of_week.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='distribution_by_url.php'

·INSERT INTO acl (resource,level) VALUES ('distribution_by_url.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='distribution_by_did.php'

·INSERT INTO acl (resource,level) VALUES ('distribution_by_did.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='distribution_detail.php'

·INSERT INTO acl (resource,level) VALUES ('distribution_detail.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='answered_calls_summary.php'

·INSERT INTO acl (resource,level) VALUES ('answered_calls_summary.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='answered_calls_by_holdtime.php'

·INSERT INTO acl (resource,level) VALUES ('answered_calls_by_holdtime.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='answered_calls_by_queue.php'

·INSERT INTO acl (resource,level) VALUES ('answered_calls_by_queue.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='answered_calls_by_agent.php'

·INSERT INTO acl (resource,level) VALUES ('answered_calls_by_agent.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='answered_calls_by_event.php'

·INSERT INTO acl (resource,level) VALUES ('answered_calls_by_event.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='answered_calls_by_url.php'

·INSERT INTO acl (resource,level) VALUES ('answered_calls_by_url.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='answered_calls_by_did.php'

·INSERT INTO acl (resource,level) VALUES ('answered_calls_by_did.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='answered_calls_by_duration.php'

·INSERT INTO acl (resource,level) VALUES ('answered_calls_by_duration.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='answered_calls_transferred.php'

·INSERT INTO acl (resource,level) VALUES ('answered_calls_transferred.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='answered_calls_detail.php'

·INSERT INTO acl (resource,level) VALUES ('answered_calls_detail.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='unanswered_calls_summary.php'

·INSERT INTO acl (resource,level) VALUES ('unanswered_calls_summary.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='unanswered_calls_by_holdtime.php'

·INSERT INTO acl (resource,level) VALUES ('unanswered_calls_by_holdtime.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='unanswered_calls_by_event.php'

·INSERT INTO acl (resource,level) VALUES ('unanswered_calls_by_event.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='unanswered_calls_by_queue.php'

·INSERT INTO acl (resource,level) VALUES ('unanswered_calls_by_queue.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='unanswered_calls_by_url.php'

·INSERT INTO acl (resource,level) VALUES ('unanswered_calls_by_url.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='unanswered_calls_by_did.php'

·INSERT INTO acl (resource,level) VALUES ('unanswered_calls_by_did.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='unanswered_calls_detail.php'

·INSERT INTO acl (resource,level) VALUES ('unanswered_calls_detail.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='agent_summary.php'

·INSERT INTO acl (resource,level) VALUES ('agent_summary.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='agent_availability.php'

·INSERT INTO acl (resource,level) VALUES ('agent_availability.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='agent_durations.php'

·INSERT INTO acl (resource,level) VALUES ('agent_durations.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='agent_pauses.php'

·INSERT INTO acl (resource,level) VALUES ('agent_pauses.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='agent_dispositions.php'

·INSERT INTO acl (resource,level) VALUES ('agent_dispositions.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='agent_detail.php'

·INSERT INTO acl (resource,level) VALUES ('agent_detail.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='admin-setup.php'

·INSERT INTO acl (resource,level) VALUES ('admin-setup.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='admin-designer.php'

·INSERT INTO acl (resource,level) VALUES ('admin-designer.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='admin-users.php'

·INSERT INTO acl (resource,level) VALUES ('admin-users.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='admin-acl.php'

·INSERT INTO acl (resource,level) VALUES ('admin-acl.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='admin-language.php'

·INSERT INTO acl (resource,level) VALUES ('admin-language.php',7)

·SELECT resource,level FROM acl

·SELECT level FROM acl WHERE resource='admin-schedule.php'

·INSERT INTO acl (resource,level) VALUES ('admin-schedule.php',7)

·SET NAMES 'UTF8'

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','Home','Home',1)

·INSERT INTO language (iso_code,string,translation,pending) VALUES('en','Filter','Filter',1)