Advertisement
Guest User

Untitled

a guest
Dec 10th, 2019
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.55 KB | None | 0 0
  1. INSERT INTO call.reason (id, version, reason_id_enum, name, date_created, creator_session_name, creator_session_id_code, last_updated, editor_session_name, editor_session_id_code)
  2. VALUES (1,1,-1,'Sisseloginud','2019-05-08 12:58:43', 'Sten Vaher', '39801010101', '2019-05-08 12:58:43', 'Sten Vaher', '39801010101');
  3. INSERT INTO call.service_group(id, version, service_group_enum, value, description, skill, group_role_name, date_created, creator_session_name, creator_session_id_code, last_updated, editor_session_name, editor_session_id_code)
  4. VALUES(1,1,'1345','Inglise keel', 'Teenusgrupi', true,'AIK','2019-11-06 23:45:54.182', 'Sten Vaher', '39801010101','2019-11-06 23:45:54.182','Sten Vaher','39801010101');
  5. INSERT INTO call.service_group(id, version, service_group_enum, value, description, skill, group_role_name, date_created, creator_session_name, creator_session_id_code, last_updated, editor_session_name, editor_session_id_code)
  6. VALUES(2,2,'1314','1314' , 'Teenusgrupi2', false,'AIK2','2019-11-06 23:45:54.182', 'Sten Vaher', '39801010101','2019-11-06 23:46:54.182','Sten Vaher','39801010101');
  7. INSERT INTO call.service_group(id, version, service_group_enum, value, description, skill, group_role_name, date_created, creator_session_name, creator_session_id_code, last_updated, editor_session_name, editor_session_id_code)
  8. VALUES(3,1,'1345_TOOMAS_TEST','1345_piisavalt_pikk_tekst' , 'Teenusgrupi2', false,'AIK2','2019-11-06 23:45:54.182', 'Sten Vaher', '39801010101','2019-11-06 23:45:54.182','Sten Vaher','39801010101');
  9. INSERT INTO call.service_group(id, version, service_group_enum, value, description, skill, group_role_name, date_created, creator_session_name, creator_session_id_code, last_updated, editor_session_name, editor_session_id_code)
  10. VALUES(4,1,'1182_HOTLINE','1182' , 'Teenusgrupi2', false,'AIK2','2019-11-06 23:45:54.182', 'Sten Vaher', '39801010101','2019-11-06 23:45:54.182','Sten Vaher','39801010101');
  11. INSERT INTO call.agent_status(id, version, solidus_call_id, status_enum, status_time, date_created, last_updated)
  12. VALUES (1,1,'123123','AGENT_STATUS_UNKNOWN','2019-05-08 12:57:43', '2019-05-08 12:57:43', '2019-05-08 12:57:43');
  13. INSERT INTO call.agent_readiness(id, version, readiness, readiness_time, reason_id_enum, readiness_duration, not_readiness_duration, date_created, last_updated)
  14. VALUES(1,1,true,'2019-05-08 12:57:43',-1,10,6000,'2019-05-08 12:57:43','2019-05-08 12:57:43');
  15. INSERT INTO call.agent_readiness_reason_duration (id, version, agent_readiness_id, reason_id_enum, reason_duration, date_created, last_updated)
  16. VALUES(1,1,1,-1,10,'2019-11-06 23:45:54.182','2019-11-06 23:45:54.182');
  17. INSERT INTO call.agent (id, version, record_id, name, phone_number, log_in_time, log_out_time, date_created, service_group_list_enum, last_updated, logon_id, agent_readiness_id, agent_status_id, last_login, computer_name)
  18. VALUES (1, 1, 1, 'Test', '123', '2019-05-08 12:56:43', '2019-05-08 12:56:43', '2019-05-08 12:56:43', '1,2,3,4','2019-05-08 12:56:43', 1, 1, 1, true, 'test');
  19. INSERT INTO call.agent_status_hist(id, agent_status_id, version, solidus_call_id, status_enum, status_time, date_created, last_updated)
  20. VALUES (1,1,1,'123123','AGENT_STATUS_UNKNOWN', '2019-05-08 12:57:43', '2019-05-08 12:57:43', '2019-05-08 12:57:43');
  21. INSERT INTO call.agent_status_hist(id, agent_status_id, version, solidus_call_id, status_enum, status_time, date_created, last_updated)
  22. VALUES (2,1,2,'123123','AGENT_STATUS_UNKNOWN', '2019-05-08 12:57:43', '2019-05-08 12:57:43', '2019-05-08 12:57:43');
  23. INSERT INTO call.agent_status(id, version, solidus_call_id, status_enum, status_time, date_created, last_updated)
  24. VALUES (2,1,'123223','AGENT_STATUS_UNKNOWN','2019-05-08 12:57:43', '2019-05-08 12:57:43', '2019-05-08 12:57:43');
  25. INSERT INTO call.agent_status_hist(id, agent_status_id, version, solidus_call_id, status_enum, status_time, date_created, last_updated)
  26. VALUES (3,2,1,'123223','AGENT_STATUS_UNKNOWN', '2019-05-08 12:57:43', '2019-05-08 12:57:43', '2019-05-08 12:57:43');
  27. INSERT INTO call.agent_readiness(id, version, readiness, readiness_time, reason_id_enum, readiness_duration, not_readiness_duration, date_created, last_updated)
  28. VALUES(2,1,true,'2019-05-08 12:58:43',-1,10,6000,'2019-05-08 12:57:43','2019-05-08 12:57:43');
  29. INSERT INTO call.agent (id, version, record_id, name, phone_number, log_in_time, log_out_time, date_created, service_group_list_enum, last_updated, logon_id, agent_readiness_id, agent_status_id, last_login, computer_name)
  30. VALUES (2, 1, 1, 'Test', '123', '2019-05-08 12:58:43', '2019-05-08 12:58:43', '2019-05-08 12:58:43', '2','2019-05-08 12:58:43', 2, 2, 2, true, 'test');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement