-# ************************************************************
-# Sequel Pro SQL dump
-# Version 4096
-#
-# http://www.sequelpro.com/
-# http://code.google.com/p/sequel-pro/
-#
-# Host: localhost (MySQL 10.0.13-MariaDB)
-# Database: centini
-# Generation Time: 2014-10-19 23:41:08 +0000
-# ************************************************************
-
+-- --------------------------------------------------------
+-- Host:                         192.168.1.8
+-- Server version:               5.5.38-0ubuntu0.14.04.1 - (Ubuntu)
+-- Server OS:                    debian-linux-gnu
+-- HeidiSQL Version:             8.3.0.4834
+-- --------------------------------------------------------
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
-/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
-/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
 /*!40101 SET NAMES utf8 */;
 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
-
-
-# Dump of table groups
-# ------------------------------------------------------------
-
-DROP TABLE IF EXISTS `groups`;
-
-CREATE TABLE `groups` (
+
+-- Dumping structure for table centini.groups
+CREATE TABLE IF NOT EXISTS `groups` (
   `group` char(16) NOT NULL,
   `description` varchar(50) DEFAULT NULL,
   PRIMARY KEY (`group`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
-LOCK TABLES `groups` WRITE;
+-- Dumping data for table centini.groups: ~3 rows (approximately)
 /*!40000 ALTER TABLE `groups` DISABLE KEYS */;
-
-INSERT INTO `groups` (`group`, `description`)
-VALUES
-	('group1','Test Group 1'),
-	('group2','Test Group 2'),
-	('group3','Test Group 3');
-
+INSERT INTO `groups` (`group`, `description`) VALUES
+	('group1', 'Test Group 1'),
+	('group2', 'Test Group 2'),
+	('group3', 'Test Group 3');
 /*!40000 ALTER TABLE `groups` ENABLE KEYS */;
-UNLOCK TABLES;
-
-
-# Dump of table queue_log
-# ------------------------------------------------------------
-
-DROP TABLE IF EXISTS `queue_log`;
-
-CREATE TABLE `queue_log` (
+
+
+-- Dumping structure for table centini.group_member
+CREATE TABLE IF NOT EXISTS `group_member` (
+  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
+  `group` char(16) NOT NULL,
+  `username` char(16) NOT NULL,
+  PRIMARY KEY (`id`),
+  UNIQUE KEY `group` (`group`,`username`),
+  KEY `group_member_fk2` (`username`),
+  CONSTRAINT `group_member_fk1` FOREIGN KEY (`group`) REFERENCES `groups` (`group`) ON DELETE CASCADE ON UPDATE CASCADE,
+  CONSTRAINT `group_member_fk2` FOREIGN KEY (`username`) REFERENCES `users` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
+) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
+
+-- Dumping data for table centini.group_member: ~4 rows (approximately)
+/*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
+INSERT INTO `group_member` (`id`, `group`, `username`) VALUES
+	(1, 'group1', 'agent1'),
+	(2, 'group1', 'spv1'),
+	(3, 'group2', 'spv1'),
+	(4, 'group3', 'agent2');
+/*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
+
+
+-- Dumping structure for table centini.incoming_call_log
+CREATE TABLE IF NOT EXISTS `incoming_call_log` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
-
-
-# Dump of table queue_member
-# ------------------------------------------------------------
-
-DROP TABLE IF EXISTS `queue_member`;
-
-CREATE TABLE `queue_member` (
+-- Dumping data for table centini.incoming_call_log: ~0 rows (approximately)
+/*!40000 ALTER TABLE `incoming_call_log` DISABLE KEYS */;
+/*!40000 ALTER TABLE `incoming_call_log` ENABLE KEYS */;
+
+
+-- Dumping structure for table centini.outgoing_call_log
+CREATE TABLE IF NOT EXISTS `outgoing_call_log` (
+  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- Dumping data for table centini.outgoing_call_log: ~0 rows (approximately)
+/*!40000 ALTER TABLE `outgoing_call_log` DISABLE KEYS */;
+/*!40000 ALTER TABLE `outgoing_call_log` ENABLE KEYS */;
+
+
+-- Dumping structure for table centini.queues
+CREATE TABLE IF NOT EXISTS `queues` (
+  `queue` char(16) NOT NULL DEFAULT '',
+  PRIMARY KEY (`queue`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- Dumping data for table centini.queues: ~0 rows (approximately)
+/*!40000 ALTER TABLE `queues` DISABLE KEYS */;
+/*!40000 ALTER TABLE `queues` ENABLE KEYS */;
+
+
+-- Dumping structure for table centini.queue_member
+CREATE TABLE IF NOT EXISTS `queue_member` (
   `id` smallint(11) unsigned NOT NULL AUTO_INCREMENT,
   `queue` char(16) NOT NULL DEFAULT '',
   `username` char(16) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`),
   KEY `queue_member_fk1` (`queue`),
   KEY `queue_member_fk2` (`username`),
-  CONSTRAINT `queue_member_fk2` FOREIGN KEY (`username`) REFERENCES `users` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
-  CONSTRAINT `queue_member_fk1` FOREIGN KEY (`queue`) REFERENCES `queues` (`queue`) ON DELETE CASCADE ON UPDATE CASCADE
+  CONSTRAINT `queue_member_fk1` FOREIGN KEY (`queue`) REFERENCES `queues` (`queue`) ON DELETE CASCADE ON UPDATE CASCADE,
+  CONSTRAINT `queue_member_fk2` FOREIGN KEY (`username`) REFERENCES `users` (`username`) ON DELETE CASCADE ON UPDATE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
-
-
-# Dump of table queues
-# ------------------------------------------------------------
-
-DROP TABLE IF EXISTS `queues`;
-
-CREATE TABLE `queues` (
-  `queue` char(16) NOT NULL DEFAULT '',
-  PRIMARY KEY (`queue`)
+-- Dumping data for table centini.queue_member: ~0 rows (approximately)
+/*!40000 ALTER TABLE `queue_member` DISABLE KEYS */;
+/*!40000 ALTER TABLE `queue_member` ENABLE KEYS */;
+
+
+-- Dumping structure for table centini.users
+CREATE TABLE IF NOT EXISTS `users` (
+  `username` char(16) NOT NULL,
+  `password` varchar(32) NOT NULL,
+  `fullname` varchar(50) DEFAULT NULL,
+  `level` enum('Administrator','Agent','Supervisor','Manager') NOT NULL DEFAULT 'Agent',
+  `peer` varchar(10) DEFAULT NULL,
+  PRIMARY KEY (`username`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
-
-
-# Dump of table user_call_log
-# ------------------------------------------------------------
-
-DROP TABLE IF EXISTS `user_call_log`;
-
-CREATE TABLE `user_call_log` (
-  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
-
-
-# Dump of table group_member
-# ------------------------------------------------------------
-
-DROP TABLE IF EXISTS `group_member`;
-
-CREATE TABLE `group_member` (
-  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
-  `group` char(16) NOT NULL,
-  `username` char(16) NOT NULL,
-  PRIMARY KEY (`id`),
-  UNIQUE KEY `group` (`group`,`username`),
-  KEY `group_member_fk2` (`username`),
-  CONSTRAINT `group_member_fk2` FOREIGN KEY (`username`) REFERENCES `users` (`username`) ON DELETE CASCADE ON UPDATE CASCADE,
-  CONSTRAINT `group_member_fk1` FOREIGN KEY (`group`) REFERENCES `groups` (`group`) ON DELETE CASCADE ON UPDATE CASCADE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
-LOCK TABLES `group_member` WRITE;
-/*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
-
-INSERT INTO `group_member` (`id`, `group`, `username`)
-VALUES
-	(1,'group1','agent1'),
-	(2,'group1','spv1'),
-	(3,'group2','spv1'),
-	(4,'group3','agent2');
-
-/*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
-UNLOCK TABLES;
-
-
-# Dump of table user_pause_log
-# ------------------------------------------------------------
-
-DROP TABLE IF EXISTS `user_pause_log`;
-
-CREATE TABLE `user_pause_log` (
+-- Dumping data for table centini.users: ~5 rows (approximately)
+/*!40000 ALTER TABLE `users` DISABLE KEYS */;
+INSERT INTO `users` (`username`, `password`, `fullname`, `level`, `peer`) VALUES
+	('admin', '1a1dc91c907325c69271ddf0c944bc72', 'Administrator', 'Administrator', NULL),
+	('agent1', '1a1dc91c907325c69271ddf0c944bc72', 'Test Agent Satu', 'Agent', NULL),
+	('agent2', '32250170a0dca92d53ec9624f336ca24', 'Test Agent Dua', 'Agent', NULL),
+	('manager1', '32250170a0dca92d53ec9624f336ca24', 'Test Manager Satu', 'Manager', NULL),
+	('spv1', '1a1dc91c907325c69271ddf0c944bc72', 'Test Supervisor Satu', 'Supervisor', NULL);
+/*!40000 ALTER TABLE `users` ENABLE KEYS */;
+
+
+-- Dumping structure for table centini.user_pause_log
+CREATE TABLE IF NOT EXISTS `user_pause_log` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `username` char(16) DEFAULT NULL,
   `start` datetime NOT NULL,

  PRIMARY KEY (`id`),
  KEY `user_session_log_fk1` (`username`),
  CONSTRAINT `user_session_log_fk1` FOREIGN KEY (`username`) REFERENCES `users` (`username`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `user_session_log` WRITE;
/*!40000 ALTER TABLE `user_session_log` DISABLE KEYS */;

INSERT INTO `user_session_log` (`id`, `username`, `start`, `finish`)
VALUES
	(1,'agent1','2014-10-14 12:52:21',NULL),
	(2,'agent1','2014-10-14 12:56:23',NULL),
	(3,'agent1','2014-10-14 12:58:16',NULL),
	(4,'agent1','2014-10-14 12:59:22',NULL),
	(5,'agent1','2014-10-14 13:00:52',NULL),
	(6,'agent1','2014-10-14 13:02:21',NULL),
	(7,'agent1','2014-10-14 13:05:18',NULL),
	(8,'agent1','2014-10-14 13:05:54',NULL),
	(9,'agent1','2014-10-14 13:06:35',NULL),
	(10,'agent1','2014-10-14 13:09:34',NULL),
	(11,'agent1','2014-10-14 13:13:52',NULL),
	(12,'agent1','2014-10-14 13:15:48',NULL),
	(13,'spv1','2014-10-14 13:22:54','2014-10-14 13:24:23'),
	(14,'agent1','2014-10-14 13:23:09','2014-10-14 13:23:44'),
	(15,'agent1','2014-10-14 14:22:31','2014-10-14 14:22:45'),
	(16,'agent1','2014-10-14 15:02:55',NULL),
	(17,'spv1','2014-10-14 15:03:38',NULL),
	(18,'agent1','2014-10-14 15:06:40','2014-10-14 15:10:58'),
	(19,'spv1','2014-10-14 15:07:35','2014-10-14 15:11:11'),
	(20,'spv1','2014-10-14 15:11:42','2014-10-14 15:16:59'),
	(21,'agent1','2014-10-14 15:12:11','2014-10-14 15:16:43'),
	(22,'agent1','2014-10-14 15:19:07',NULL),
	(23,'agent1','2014-10-14 15:26:45',NULL),
	(24,'agent1','2014-10-14 15:32:11',NULL),
	(25,'agent1','2014-10-15 10:01:12','2014-10-15 10:01:17'),
	(26,'agent1','2014-10-15 10:01:19','2014-10-15 10:03:10'),
	(27,'agent1','2014-10-15 10:09:28','2014-10-15 10:16:07'),
	(28,'agent1','2014-10-15 11:40:16','2014-10-15 11:40:53'),
	(29,'agent1','2014-10-15 11:40:56','2014-10-15 11:42:05'),
	(30,'agent1','2014-10-15 11:44:23','2014-10-15 11:44:45'),
	(31,'agent1','2014-10-15 11:45:39','2014-10-15 11:46:33'),
	(32,'agent1','2014-10-15 11:48:10','2014-10-15 11:48:26'),
	(33,'agent1','2014-10-15 11:56:04','2014-10-15 11:57:23'),
	(34,'agent1','2014-10-15 11:58:52',NULL),
	(35,'agent1','2014-10-15 12:00:21',NULL),
	(36,'agent1','2014-10-15 12:02:43',NULL),
	(37,'agent1','2014-10-15 12:02:43','2014-10-15 12:02:51'),
	(38,'agent1','2014-10-15 12:02:54',NULL),
	(39,'agent1','2014-10-15 12:04:50',NULL),
	(40,'agent1','2014-10-15 12:09:16',NULL),
	(41,'agent1','2014-10-15 12:11:07','2014-10-15 12:12:38'),
	(42,'agent1','2014-10-15 12:14:04','2014-10-15 12:26:51'),
	(43,'agent1','2014-10-15 12:27:35','2014-10-15 12:31:20'),
	(44,'agent1','2014-10-15 12:31:30','2014-10-15 12:54:15'),
	(45,'agent1','2014-10-15 12:56:39','2014-10-15 12:57:34'),
	(46,'agent1','2014-10-15 13:04:26','2014-10-15 14:01:32'),
	(47,'agent1','2014-10-15 14:12:52','2014-10-15 14:13:09'),
	(48,'agent1','2014-10-15 14:37:20','2014-10-15 14:37:32'),
	(49,'agent1','2014-10-15 14:37:57',NULL),
	(50,'agent1','2014-10-16 10:00:24','2014-10-16 11:37:20'),
	(51,'agent1','2014-10-16 12:07:42','2014-10-16 12:07:45'),
	(52,'spv1','2014-10-16 12:08:30',NULL),
	(53,'agent1','2014-10-16 12:08:43','2014-10-16 12:08:53'),
	(54,'spv1','2014-10-16 12:11:33','2014-10-16 12:16:02'),
	(55,'agent1','2014-10-16 12:11:58','2014-10-16 12:12:12'),
	(56,'agent2','2014-10-16 12:12:20','2014-10-16 12:16:06'),
	(57,'manager1','2014-10-16 12:13:34','2014-10-16 12:15:59'),
	(58,'agent1','2014-10-16 12:15:04','2014-10-16 12:15:54'),
	(59,'spv1','2014-10-16 12:17:09',NULL),
	(60,'agent1','2014-10-16 12:19:28','2014-10-16 12:19:35'),
	(61,'manager1','2014-10-16 12:19:58',NULL),
	(62,'agent1','2014-10-16 12:20:23',NULL),
	(63,'agent1','2014-10-16 12:25:44','2014-10-16 12:26:41'),
	(64,'agent1','2014-10-16 12:26:16',NULL),
	(65,'agent1','2014-10-16 12:27:13',NULL),
	(66,'agent1','2014-10-16 12:37:04',NULL),
	(67,'agent2','2014-10-16 12:37:41','2014-10-16 12:40:45'),
	(68,'spv1','2014-10-16 12:38:00','2014-10-16 12:40:31'),
	(69,'manager1','2014-10-16 12:38:14','2014-10-16 12:40:07'),
	(70,'spv1','2014-10-16 12:44:06','2014-10-16 12:44:20'),
	(71,'manager1','2014-10-16 12:44:36',NULL),
	(72,'spv1','2014-10-16 12:44:50',NULL),
	(73,'agent1','2014-10-16 12:45:07',NULL),
	(74,'agent2','2014-10-16 12:45:26',NULL),
	(75,'manager1','2014-10-16 13:55:49',NULL),
	(76,'spv1','2014-10-16 13:56:04',NULL),
	(77,'manager1','2014-10-16 14:01:54','2014-10-16 14:03:39'),
	(78,'spv1','2014-10-16 14:02:07','2014-10-16 14:36:31'),
	(79,'agent1','2014-10-16 14:02:32','2014-10-16 14:21:37'),
	(80,'agent2','2014-10-16 14:02:47','2014-10-16 14:21:22'),
	(81,'manager1','2014-10-16 14:04:01','2014-10-16 14:36:42'),
	(82,'agent1','2014-10-18 13:41:17','2014-10-18 14:22:43'),
	(83,'agent1','2014-10-18 14:22:47',NULL),
	(84,'agent1','2014-10-18 21:44:44','2014-10-18 21:48:35'),
	(85,'agent1','2014-10-18 21:48:36','2014-10-18 21:50:48'),
	(86,'agent1','2014-10-18 21:50:48','2014-10-18 21:51:27'),
	(87,'agent1','2014-10-18 21:51:28','2014-10-18 21:53:25'),
	(88,'agent1','2014-10-18 21:53:25','2014-10-18 22:05:24'),
	(89,'agent1','2014-10-18 22:06:21','2014-10-18 22:07:38'),
	(90,'agent1','2014-10-18 22:08:10','2014-10-18 23:00:05'),
	(91,'agent1','2014-10-18 23:06:52','2014-10-18 23:07:45'),
	(92,'agent1','2014-10-18 23:07:51','2014-10-18 23:07:58'),
	(93,'agent1','2014-10-19 09:43:20','2014-10-19 12:18:56'),
	(94,'agent1','2014-10-19 12:45:37','2014-10-19 12:47:26'),
	(95,'agent1','2014-10-19 12:47:39','2014-10-19 12:48:50'),
	(96,'agent1','2014-10-19 12:48:58','2014-10-19 12:49:37'),
	(97,'agent1','2014-10-19 12:49:47','2014-10-19 12:50:22'),
	(98,'agent1','2014-10-19 12:50:27','2014-10-19 12:51:48'),
	(99,'agent1','2014-10-19 12:51:54','2014-10-19 12:51:57'),
	(100,'agent1','2014-10-19 12:53:43','2014-10-19 12:53:47'),
	(101,'agent1','2014-10-19 12:54:04','2014-10-19 13:06:01'),
	(102,'agent1','2014-10-19 13:06:20','2014-10-19 13:09:45'),
	(103,'agent1','2014-10-19 13:10:39','2014-10-19 13:14:41'),
	(104,'agent1','2014-10-19 13:14:44','2014-10-19 13:20:50'),
	(105,'agent1','2014-10-19 13:21:00','2014-10-19 13:21:50'),
	(106,'agent1','2014-10-19 13:22:43','2014-10-19 13:22:52'),
	(107,'agent1','2014-10-19 13:23:20','2014-10-19 13:24:42'),
	(108,'agent1','2014-10-19 13:25:00','2014-10-19 13:25:06'),
	(109,'agent1','2014-10-19 16:00:02','2014-10-19 16:00:12'),
	(110,'agent1','2014-10-19 17:53:15','2014-10-19 19:57:16'),
	(111,'agent1','2014-10-19 21:26:09','2014-10-19 21:26:13');

/*!40000 ALTER TABLE `user_session_log` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table users
# ------------------------------------------------------------

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `username` char(16) NOT NULL,
  `password` varchar(32) NOT NULL,
  `fullname` varchar(50) DEFAULT NULL,
  `level` enum('Administrator','Agent','Supervisor','Manager') NOT NULL DEFAULT 'Agent',
  `peer` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;

INSERT INTO `users` (`username`, `password`, `fullname`, `level`, `peer`)
VALUES
	('admin','32250170a0dca92d53ec9624f336ca24','Administrator','Administrator',NULL),
	('agent1','32250170a0dca92d53ec9624f336ca24','Test Agent Satu','Agent',NULL),
	('agent2','32250170a0dca92d53ec9624f336ca24','Test Agent Dua','Agent',NULL),
	('manager1','32250170a0dca92d53ec9624f336ca24','Test Manager Satu','Manager',NULL),
	('spv1','32250170a0dca92d53ec9624f336ca24','Test Supervisor Satu','Supervisor',NULL);

/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;



/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

  KEY `user_pause_log_fk1` (`username`),
  KEY `reason` (`reason`),
  CONSTRAINT `user_pause_log_fk1` FOREIGN KEY (`username`) REFERENCES `users` (`username`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;

-- Dumping data for table centini.user_pause_log: ~58 rows (approximately)
/*!40000 ALTER TABLE `user_pause_log` DISABLE KEYS */;
INSERT INTO `user_pause_log` (`id`, `username`, `start`, `finish`, `reason`) VALUES
	(1, 'agent1', '2014-10-15 12:30:39', NULL, 'Test Doank'),
	(2, 'agent1', '2014-10-15 13:04:40', '2014-10-15 13:05:10', 'Test Doank'),
	(3, 'agent1', '2014-10-15 13:08:40', '2014-10-15 14:01:31', 'Test Doank'),
	(4, 'agent1', '2014-10-15 14:39:16', NULL, 'Test Doank'),
	(5, 'agent1', '2014-10-23 11:39:25', '2014-10-23 11:40:02', 'LUNCH'),
	(6, 'agent1', '2014-10-23 11:40:28', '2014-10-23 11:40:46', 'ISTIRAHAT'),
	(7, 'agent1', '2014-10-23 11:40:58', '2014-10-23 11:45:17', 'TOILET'),
	(8, 'agent1', '2014-10-23 11:46:23', '2014-10-23 11:46:43', 'TIDUR'),
	(9, 'agent1', '2014-10-23 11:52:09', '2014-10-23 11:52:12', 'Pilih reason..'),
	(10, 'agent1', '2014-10-23 11:52:55', '2014-10-23 11:54:07', 'TOILET'),
	(11, 'agent1', '2014-10-23 12:49:54', NULL, 'LUNCH'),
	(12, 'agent1', '2014-10-23 12:50:01', NULL, 'Pilih reason..'),
	(13, 'agent1', '2014-10-23 12:50:12', NULL, 'LUNCH'),
	(14, 'agent1', '2014-10-23 12:50:27', NULL, 'LUNCH'),
	(15, 'agent1', '2014-10-23 12:52:21', NULL, 'LUNCH'),
	(16, 'agent1', '2014-10-23 13:37:58', '2014-10-23 13:38:14', 'LUNCH'),
	(17, 'agent1', '2014-10-23 13:38:24', '2014-10-23 13:39:05', 'TIDUR'),
	(18, 'agent1', '2014-10-23 13:39:40', NULL, 'LUNCH'),
	(19, 'agent1', '2014-10-23 14:21:07', NULL, 'NGOBROL'),
	(20, 'agent1', '2014-10-23 15:07:47', '2014-10-23 15:07:55', 'ISTIRAHAT'),
	(21, 'agent1', '2014-10-23 15:08:11', '2014-10-23 15:08:19', 'LUNCH'),
	(22, 'agent1', '2014-10-23 15:12:09', NULL, 'ISTIRAHAT'),
	(23, 'agent2', '2014-10-27 08:17:55', NULL, 'ISTIRAHAT'),
	(24, 'agent1', '2014-10-27 08:43:35', '2014-10-27 08:43:49', 'LUNCH'),
	(25, 'agent1', '2014-10-27 08:43:55', '2014-10-27 08:46:04', 'ISTIRAHAT'),
	(26, 'agent1', '2014-10-27 08:57:09', '2014-10-27 09:01:07', 'ISTIRAHAT'),
	(27, 'agent1', '2014-10-27 09:08:01', NULL, 'ISTIRAHAT'),
	(28, 'agent1', '2014-10-27 13:50:53', '2014-10-27 14:04:55', 'TOILET'),
	(29, 'agent1', '2014-10-27 14:08:27', '2014-10-27 14:09:48', 'ISTIRAHAT'),
	(30, 'agent2', '2014-10-27 14:29:18', NULL, 'ISTIRAHAT'),
	(31, 'agent1', '2014-10-28 08:16:49', '2014-10-28 09:20:44', 'LUNCH'),
	(32, 'agent1', '2014-10-28 09:20:56', '2014-10-28 09:43:48', 'ISTIRAHAT'),
	(33, 'agent1', '2014-10-28 10:01:03', '2014-10-28 10:01:06', 'Pilih reason..'),
	(34, 'agent1', '2014-10-28 10:01:09', '2014-10-28 10:29:17', 'TOILET'),
	(35, 'agent1', '2014-10-28 10:36:37', NULL, 'LUNCH'),
	(36, 'spv1', '2014-10-28 12:23:46', '2014-10-28 12:23:49', 'Pilih reason..'),
	(37, 'agent1', '2014-10-28 13:05:29', '2014-10-28 13:05:31', 'TOILET'),
	(38, 'agent1', '2014-10-28 13:05:34', NULL, 'ISTIRAHAT'),
	(39, 'agent1', '2014-10-29 07:10:56', '2014-10-29 07:11:34', 'Pilih reason..'),
	(40, 'agent1', '2014-10-29 07:11:39', '2014-10-29 08:06:40', 'ISTIRAHAT'),
	(41, 'agent1', '2014-10-29 08:06:45', '2014-10-29 08:08:29', 'TOILET'),
	(42, 'agent1', '2014-10-29 08:09:54', NULL, 'ISTIRAHAT'),
	(43, 'spv1', '2014-10-29 08:10:35', '2014-10-29 08:10:37', 'LUNCH'),
	(44, 'agent1', '2014-10-29 08:23:38', '2014-10-29 08:24:18', 'NO_REASON'),
	(45, 'agent1', '2014-10-29 10:06:14', '2014-10-29 14:36:06', 'ISTIRAHAT'),
	(46, 'agent2', '2014-10-29 12:28:39', NULL, 'ISTIRAHAT'),
	(47, 'agent2', '2014-10-29 12:29:56', '2014-10-29 12:29:59', 'ISTIRAHAT'),
	(48, 'agent2', '2014-10-29 12:30:01', '2014-10-29 12:30:04', 'LUNCH'),
	(49, 'agent2', '2014-10-29 13:16:16', NULL, 'ISTIRAHAT'),
	(50, 'agent1', '2014-10-29 14:50:46', '2014-10-30 05:32:39', 'ISTIRAHAT'),
	(51, 'agent1', '2014-10-30 09:11:27', '2014-11-10 09:08:07', 'ISTIRAHAT'),
	(52, 'agent1', '2014-11-10 09:08:14', '2014-11-10 09:08:21', 'ISTIRAHAT'),
	(53, 'agent1', '2014-11-10 09:08:29', '2014-11-10 09:11:15', 'NO_REASON'),
	(54, 'agent1', '2014-11-10 09:11:18', '2014-11-10 09:17:44', 'ISTIRAHAT'),
	(55, 'agent1', '2014-11-10 09:19:17', '2014-11-10 12:47:33', 'ISTIRAHAT'),
	(56, 'agent2', '2014-11-10 12:47:13', '2014-11-10 12:58:29', 'ISTIRAHAT'),
	(57, 'spv1', '2014-11-10 12:56:33', NULL, 'ISTIRAHAT'),
	(58, 'manager1', '2014-11-10 12:58:24', NULL, 'ISTIRAHAT');
/*!40000 ALTER TABLE `user_pause_log` ENABLE KEYS */;


-- Dumping structure for table centini.user_session_log
CREATE TABLE IF NOT EXISTS `user_session_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` char(16) DEFAULT NULL,
  `start` datetime NOT NULL,
