text: -- MySQL dump 10.16  Distrib 10.1.26-MariaDB, for Linux (x86_64)
  --
  -- Host: localhost    Database: timekeeping_sirjun
  -- ------------------------------------------------------
  -- Server version	10.1.26-MariaDB
  
  /*!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 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!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 */;
  
  --
  -- Table structure for table `employee`
  --
  
  DROP TABLE IF EXISTS `employee`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `employee` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `employee_number` varchar(20) DEFAULT NULL,
    `sss_no` int(11) DEFAULT NULL,
    `tin_no` int(11) DEFAULT NULL,
    `phil_health` int(11) DEFAULT NULL,
    `user_id` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `employee`
  --
  
  LOCK TABLES `employee` WRITE;
  /*!40000 ALTER TABLE `employee` DISABLE KEYS */;
  INSERT INTO `employee` VALUES (1,NULL,1234,1230,123,2),(2,NULL,11,0,0,4),(3,NULL,123,0,0,10),(30,NULL,NULL,NULL,NULL,56);
  /*!40000 ALTER TABLE `employee` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `intern`
  --
  
  DROP TABLE IF EXISTS `intern`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `intern` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `school` varchar(255) DEFAULT NULL,
    `no_of_hrs` int(11) NOT NULL,
    `course` varchar(150) DEFAULT NULL,
    `birthday` date DEFAULT NULL,
    `year` varchar(50) DEFAULT NULL,
    `remaining` varchar(10) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `intern`
  --
  
  LOCK TABLES `intern` WRITE;
  /*!40000 ALTER TABLE `intern` DISABLE KEYS */;
  INSERT INTO `intern` VALUES (1,3,'USTs',250,'BSITWMA','2017-05-06','2017-2018','250'),(2,5,'Feu',250,'Feu-it','2017-10-10','feu','250'),(3,6,'123213',0,'Bsit','0000-00-00','asd',NULL),(6,9,NULL,520,NULL,NULL,NULL,'520');
  /*!40000 ALTER TABLE `intern` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `logs`
  --
  
  DROP TABLE IF EXISTS `logs`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `logs` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `action` varchar(50) NOT NULL,
    `description` text NOT NULL,
    `position` varchar(50) DEFAULT NULL,
    `ip_address` varchar(20) NOT NULL,
    `user` varchar(200) NOT NULL,
    `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `logs`
  --
  
  LOCK TABLES `logs` WRITE;
  /*!40000 ALTER TABLE `logs` DISABLE KEYS */;
  INSERT INTO `logs` VALUES (1,'Account Access','Account Login ','Admin','::1','Erin Rugas','2017-10-08 16:30:13'),(2,'Account Access','Account Logout ','Admin','::1','Erin Rugas','2017-10-08 16:30:13'),(3,'Account Access','Account Login ','Intern','::1','Intern Intern','2017-10-08 16:30:13'),(4,'Account Access','Account Logout ','Intern','::1','Intern Intern','2017-10-08 16:30:13'),(5,'Account Access','Account Login ','Human Resource','::1','Hr Hr','2017-10-08 16:30:13'),(6,'Account Access','Account Logout ','Human Resource','::1','Hr Hr','2017-10-08 16:30:36'),(7,'Account Access','Account Login ','Human Resource','::1','Hr Hr','2017-10-08 16:31:17'),(8,'Account Access','Reject Overtime of Employee Emplo','Human Resource','::1','Hr Hr','2017-10-08 16:34:08'),(9,'Approve Overtime','Approved Overtime of Employee Emplo','Human Resource','::1','Hr Hr','2017-10-08 16:36:31'),(10,'Account Access','Account Logout ','Human Resource','::1','Hr Hr','2017-10-08 16:40:05'),(11,'Account Access','Account Login ','Employee','::1','Farrah Dionisios','2017-10-08 16:41:13'),(12,'File Overtime','Filed Overtime By Farrah Dionisios','Employee','::1','Farrah Dionisios','2017-10-08 16:41:31'),(13,'Account Access','Account Logout ','Employee','::1','Farrah Dionisios','2017-10-08 16:41:34'),(14,'Account Access','Account Login ','Admin','::1','Erin Rugas','2017-10-08 16:47:03'),(15,'User Time-in/Time-out','Work From Home','Admin','::1','Erin Rugas','2017-10-08 16:47:10'),(16,'Account Modify','Update information of Intern Interns','Admin','::1','Erin Rugas','2017-10-08 16:56:32'),(17,'Account Modify','Active account of Intern Interns','Admin','::1','Erin Rugas','2017-10-08 16:56:45'),(18,'Account Modify','Update information of Farrah Debrah Dionisios','Admin','::1','Erin Rugas','2017-10-08 17:01:16'),(19,'Account Modify','Update information of Farrah Debrah Dionisios','Admin','::1','Erin Rugas','2017-10-08 17:01:27'),(20,'Account Modify','Update information of Farrah Debrah Dionisio','Admin','::1','Erin Rugas','2017-10-08 17:01:34'),(21,'Account Modify','Update profile picture','Admin','::1','Erin Rugas','2017-10-08 17:02:00'),(22,'Account Modify','Update information','Admin','::1','Erin John Rugas','2017-10-08 17:04:47'),(23,'Edit Position','Update Position ','Admin','::1','Erin John Rugas','2017-10-08 17:08:01'),(24,'Edit Position','Update Position Admin','Admin','::1','Erin John Rugas','2017-10-08 17:08:25'),(25,'Add Position','Added Position ','Admin','::1','Erin John Rugas','2017-10-08 17:09:05'),(26,'Add Position','Added Position ','Admin','::1','Erin John Rugas','2017-10-08 17:10:29'),(27,'Add Position','Added Position Project Head','Admin','::1','Erin John Rugas','2017-10-08 17:10:55'),(28,'Shift Modify','Edit Shift Mid','Admin','::1','Erin John Rugas','2017-10-08 17:12:08'),(29,'Shift Modify','Edit Mid Shift','Admin','::1','Erin John Rugas','2017-10-08 17:12:44'),(30,'Account Modify','Deactivate account of Hr Hr','Admin','::1','Erin John Rugas','2017-10-08 17:13:07'),(31,'Account Modify','Active account of Hr Hr','Admin','::1','Erin John Rugas','2017-10-08 17:13:23'),(32,'Account Access','Account Logout ','Admin','::1','Erin John Rugas','2017-10-08 17:22:25'),(33,'Account Access','Account Login ','Admin','::1','Erin John Rugas','2017-10-08 17:22:31'),(34,'Edit Position','Update Position Human Resource','Admin','::1','Erin John Rugas','2017-10-08 17:23:09'),(35,'Edit Position','Update Position Admin','Admin','::1','Erin John Rugas','2017-10-08 17:23:15');
  /*!40000 ALTER TABLE `logs` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `menu`
  --
  
  DROP TABLE IF EXISTS `menu`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `menu` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(100) NOT NULL,
    `icon` varchar(50) NOT NULL,
    `status` tinyint(1) DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `url` varchar(100) NOT NULL,
    `with_sub` tinyint(2) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `menu`
  --
  
  LOCK TABLES `menu` WRITE;
  /*!40000 ALTER TABLE `menu` DISABLE KEYS */;
  INSERT INTO `menu` VALUES (1,'Dashboard','fa fa-dashboard',1,'2017-08-21 14:10:21','2017-09-02 10:03:46','dashboard',NULL),(2,'User Management','fa fa-users',1,'2017-08-21 14:10:21','2017-09-05 17:59:01','users',NULL),(3,'Attendance','fa fa-calendar',1,'2017-08-21 14:10:21','2017-09-05 18:10:20','',1),(4,'Management Shift','fa fa-clock-o',1,'2017-08-21 14:10:21','2017-10-05 08:28:52','',1),(5,'Position Management','fa fa-sitemap',1,'2017-08-21 14:10:21','2017-09-02 10:04:25','position',NULL),(6,'Logs','fa fa-tasks',1,'2017-10-08 17:21:44','0000-00-00 00:00:00','logs',NULL);
  /*!40000 ALTER TABLE `menu` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `position`
  --
  
  DROP TABLE IF EXISTS `position`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `position` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(50) NOT NULL,
    `privileges` varchar(100) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `privilege_sub_menu` varchar(100) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `position`
  --
  
  LOCK TABLES `position` WRITE;
  /*!40000 ALTER TABLE `position` DISABLE KEYS */;
  INSERT INTO `position` VALUES (1,'Admin','1,2,3,4,5,6','2017-08-22 02:02:42','2017-10-08 17:23:15','1,2,3,4,5,6,7'),(2,'Employee','1,3','2017-08-22 02:02:55','2017-10-06 00:19:11','2,3,4,5,6'),(3,'Human Resource','1,2,3,4,5,6','2017-08-22 05:02:01','2017-10-08 17:23:09','1,2,3,4,5,6,7'),(4,'Intern','1,3','2017-08-22 05:18:24','2017-10-06 00:20:22','3,6'),(11,'Manager','1,2,3,4,5','2017-09-01 05:40:00','0000-00-00 00:00:00',NULL),(14,'Project Head','1,3','2017-10-08 17:10:55','0000-00-00 00:00:00',NULL);
  /*!40000 ALTER TABLE `position` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `record`
  --
  
  DROP TABLE IF EXISTS `record`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `record` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `date` date DEFAULT NULL,
    `time_in` time DEFAULT NULL,
    `time_out` time DEFAULT NULL,
    `status` varchar(50) DEFAULT NULL,
    `type` varchar(12) DEFAULT NULL,
    `late_status` varchar(12) DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=326 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `record`
  --
  
  LOCK TABLES `record` WRITE;
  /*!40000 ALTER TABLE `record` DISABLE KEYS */;
  INSERT INTO `record` VALUES (151,1,'2017-10-03','11:15:46','19:15:46','8 hours',NULL,NULL,'2017-10-03 03:15:46'),(152,1,'2017-10-03','11:15:47','19:15:47','Work From Home',NULL,NULL,'2017-10-03 03:15:47'),(153,1,'2017-10-03',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-03 03:15:47'),(154,1,'2017-10-03',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-03 03:15:55'),(155,1,'2017-10-03','11:15:57','15:15:57','4 hours',NULL,NULL,'2017-10-03 03:15:57'),(156,1,'2017-10-03','13:29:53','17:29:53','4 hours',NULL,NULL,'2017-10-03 05:29:53'),(157,1,'2017-10-03','13:59:12','21:59:12','8 hours',NULL,NULL,'2017-10-03 05:59:12'),(158,1,'2017-10-04','10:06:00','14:06:00','4 hours',NULL,NULL,'2017-10-04 02:06:00'),(159,1,'2017-10-04','10:06:00','18:06:00','8 hours',NULL,NULL,'2017-10-04 02:06:00'),(160,1,'2017-10-04','10:06:01','18:06:01','8 hours',NULL,NULL,'2017-10-04 02:06:01'),(161,2,'2017-10-04','10:22:11','18:22:11','8 hours',NULL,NULL,'2017-10-04 02:22:11'),(162,2,'2017-10-04','10:22:11','18:22:11','8 hours',NULL,NULL,'2017-10-04 02:22:11'),(163,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 02:35:46'),(164,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 03:04:44'),(165,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 03:04:45'),(166,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 03:04:51'),(167,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 03:04:52'),(168,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 03:42:54'),(169,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 03:42:55'),(170,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 03:42:55'),(171,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 03:44:06'),(172,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 03:44:11'),(173,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 03:44:12'),(174,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 03:44:14'),(175,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 03:44:21'),(176,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 03:44:54'),(177,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 03:44:56'),(178,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 03:50:25'),(179,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 03:50:28'),(180,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 03:52:27'),(181,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 03:52:55'),(182,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 03:52:58'),(183,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 03:52:59'),(184,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 03:53:06'),(185,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 03:53:08'),(186,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 03:54:04'),(187,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 03:54:07'),(188,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 03:54:30'),(189,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 03:55:46'),(190,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 03:55:48'),(191,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 03:55:50'),(192,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 03:55:51'),(193,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 03:56:00'),(194,1,'2017-10-04','11:56:02','15:56:02','4 hours',NULL,NULL,'2017-10-04 03:56:02'),(195,1,'2017-10-04','11:56:02','19:56:02','8 hours',NULL,NULL,'2017-10-04 03:56:02'),(196,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 03:57:43'),(197,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 04:01:30'),(198,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 04:01:32'),(199,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 04:02:24'),(200,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 04:02:26'),(201,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 04:02:29'),(202,1,'2017-10-04',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-04 04:03:28'),(203,1,'2017-10-04',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-04 04:03:30'),(204,1,'2017-10-04','14:34:47','18:34:47','4 hours',NULL,NULL,'2017-10-04 06:34:47'),(205,1,'2017-10-04','15:13:16','19:13:16','4 hours',NULL,NULL,'2017-10-04 07:13:16'),(206,1,'2017-10-04','15:13:23','23:13:23','8 hours',NULL,NULL,'2017-10-04 07:13:23'),(207,1,'2017-10-04','15:13:34','23:13:34','Work From Home',NULL,NULL,'2017-10-04 07:13:34'),(208,1,'2017-10-04','15:13:47','23:13:47','Work From Home',NULL,NULL,'2017-10-04 07:13:47'),(209,1,'2017-10-04','15:16:10','19:16:10','4 hours',NULL,NULL,'2017-10-04 07:16:10'),(210,1,'2017-10-04','15:17:00','19:17:00','4 hours',NULL,NULL,'2017-10-04 07:17:00'),(211,1,'2017-10-04','15:19:36','23:19:36','Work From Home',NULL,NULL,'2017-10-04 07:19:36'),(212,1,'2017-10-04','15:20:48','19:20:48','4 hours',NULL,NULL,'2017-10-04 07:20:48'),(213,1,'2017-10-04','15:21:26','23:21:26','8 hours',NULL,NULL,'2017-10-04 07:21:26'),(214,1,'2017-10-04','15:21:58','19:21:58','4 hours',NULL,NULL,'2017-10-04 07:21:58'),(215,1,'2017-10-04','15:22:03','19:22:03','4 hours',NULL,NULL,'2017-10-04 07:22:03'),(216,1,'2017-10-04','15:23:22','23:23:22','8 hours',NULL,NULL,'2017-10-04 07:23:22'),(217,1,'2017-10-04','15:23:30','23:23:30','8 hours',NULL,NULL,'2017-10-04 07:23:30'),(218,1,'2017-10-04','15:23:37','23:23:37','Work From Home',NULL,NULL,'2017-10-04 07:23:37'),(219,2,'2017-10-05',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-05 09:04:37'),(220,2,'2017-10-05','17:04:38','01:04:38','Work From Home',NULL,NULL,'2017-10-05 09:04:38'),(221,2,'2017-10-05',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-05 09:04:52'),(222,2,'2017-10-05',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-05 09:04:53'),(223,2,'2017-10-05',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-05 09:07:01'),(224,2,'2017-10-05',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-05 09:07:02'),(225,2,'2017-10-05',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-05 09:07:03'),(226,2,'2017-10-05',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-05 09:07:03'),(227,2,'2017-10-05',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-05 09:07:03'),(228,2,'2017-10-05','17:09:03','01:09:03','Work From Home',NULL,NULL,'2017-10-05 09:09:03'),(229,2,'2017-10-05','17:12:00','21:12:00','4 hours',NULL,NULL,'2017-10-05 09:12:00'),(230,2,'2017-10-05','17:12:00','01:12:00','8 hours',NULL,NULL,'2017-10-05 09:12:00'),(231,2,'2017-10-05',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-05 13:30:18'),(232,2,'2017-10-05',NULL,NULL,'Sick Leave',NULL,NULL,'2017-10-05 13:30:38'),(233,2,'2017-10-05',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-05 13:30:38'),(318,1,'2017-10-06','22:06:09','06:06:09','8 hours',NULL,NULL,'2017-10-06 14:06:09'),(320,1,'2017-10-07','15:59:12','23:59:12','8 hours',NULL,NULL,'2017-10-07 07:59:12'),(321,31,'2017-10-07','17:09:17',NULL,NULL,NULL,NULL,'2017-10-07 09:09:17'),(323,1,'2017-10-08',NULL,NULL,'Vacation Leave',NULL,NULL,'2017-10-07 17:59:03'),(324,4,'2017-10-08','23:22:36','03:22:36','4 hours',NULL,NULL,'2017-10-08 15:22:36'),(325,1,'2017-10-09','00:47:10','08:47:10','Work From Home',NULL,NULL,'2017-10-08 16:47:10');
  /*!40000 ALTER TABLE `record` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `record_overtime`
  --
  
  DROP TABLE IF EXISTS `record_overtime`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `record_overtime` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `reason` text,
    `start` time NOT NULL,
    `end` time NOT NULL,
    `overtime_date` date NOT NULL,
    `date_submitted` date DEFAULT NULL,
    `ot_hours` varchar(20) DEFAULT NULL,
    `status` tinyint(4) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `record_overtime`
  --
  
  LOCK TABLES `record_overtime` WRITE;
  /*!40000 ALTER TABLE `record_overtime` DISABLE KEYS */;
  INSERT INTO `record_overtime` VALUES (19,2,'Will Play Tomb Raider','17:30:00','20:00:00','2017-10-06','2017-10-05','3',1),(20,2,'I Need Money :\'(','17:30:00','20:00:00','2017-10-09','2017-10-05','3',1),(21,2,'Will Play Overwatch And Eat','17:30:00','21:00:00','2017-10-11','2017-10-05','4',1),(22,2,'Wala Lang','15:02:00','16:44:00','2017-10-05','2017-10-06','1',0),(23,2,'Wala Lang','03:02:00','16:44:00','2017-10-05','2017-10-06','13',2),(24,2,'Wala Lang','14:02:00','13:05:00','2017-10-05','2017-10-06','-1',1),(25,2,'','14:22:00','15:20:00','0000-00-00','2017-10-06','0',1),(26,2,'1010','10:10:00','22:10:00','2017-10-10','2017-10-08','12',2),(27,4,'tinatamad mag code','12:31:00','00:31:00','2017-12-31','2017-10-08','-12',2),(28,4,'Tatambay','14:22:00','02:09:00','2017-02-22','2017-10-09','-12',0);
  /*!40000 ALTER TABLE `record_overtime` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `school`
  --
  
  DROP TABLE IF EXISTS `school`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `school` (
    `school_id` int(11) NOT NULL AUTO_INCREMENT,
    `school_name` varchar(50) NOT NULL,
    `internship` int(11) NOT NULL,
    `hours` int(11) NOT NULL,
    PRIMARY KEY (`school_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `school`
  --
  
  LOCK TABLES `school` WRITE;
  /*!40000 ALTER TABLE `school` DISABLE KEYS */;
  INSERT INTO `school` VALUES (1,'UST',1,250);
  /*!40000 ALTER TABLE `school` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `shift`
  --
  
  DROP TABLE IF EXISTS `shift`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `shift` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `shift_type` varchar(50) DEFAULT NULL,
    `start_time` time DEFAULT NULL,
    `end_time` time DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `shift`
  --
  
  LOCK TABLES `shift` WRITE;
  /*!40000 ALTER TABLE `shift` DISABLE KEYS */;
  INSERT INTO `shift` VALUES (1,'Morning','08:00:00','17:00:00'),(2,'Mid','15:00:00','01:00:00'),(3,'Night','22:00:00','10:00:00');
  /*!40000 ALTER TABLE `shift` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `sub_menu`
  --
  
  DROP TABLE IF EXISTS `sub_menu`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `sub_menu` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `sub` varchar(100) NOT NULL,
    `url` varchar(100) NOT NULL,
    `menu_id` int(11) NOT NULL,
    `intern` int(11) DEFAULT NULL,
    `admin_hr` tinyint(1) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `sub_menu`
  --
  
  LOCK TABLES `sub_menu` WRITE;
  /*!40000 ALTER TABLE `sub_menu` DISABLE KEYS */;
  INSERT INTO `sub_menu` VALUES (1,'Shift Type','shift',4,NULL,1),(3,'Timesheet','timesheet',3,1,1),(4,'Leaves','leaves',3,NULL,1),(5,'Calendar','calendar',3,NULL,1),(6,'Overtime','overtime',3,1,1),(7,'Employee Attendance','attendance/employee',3,NULL,1);
  /*!40000 ALTER TABLE `sub_menu` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `users`
  --
  
  DROP TABLE IF EXISTS `users`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!40101 SET character_set_client = utf8 */;
  CREATE TABLE `users` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `firstname` varchar(60) NOT NULL,
    `lastname` varchar(60) NOT NULL,
    `middlename` varchar(60) DEFAULT NULL,
    `email` varchar(100) NOT NULL,
    `password` varchar(80) NOT NULL,
    `profile_picture` varchar(60) DEFAULT NULL,
    `position_id` int(11) NOT NULL,
    `employee_number` varchar(50) DEFAULT NULL,
    `status` tinyint(5) NOT NULL,
    `reg_key` varchar(30) DEFAULT NULL,
    `verified_email` tinyint(2) DEFAULT NULL,
    `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
    `start_date` date DEFAULT NULL,
    `shift_id` int(11) DEFAULT NULL,
    `reset_status` tinyint(2) DEFAULT NULL,
    `reset_key` varchar(50) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=latin1;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `users`
  --
  
  LOCK TABLES `users` WRITE;
  /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  INSERT INTO `users` VALUES (1,'Erin John','Rugas','','ejr012495@gmail.com','$2y$11$Kt4z2p0tCAHgSarRHqEWXu7rmWOh46xpH9ygp2nK8pdEWMYwmTbsS','no_image.jpg',1,NULL,1,'_Wix4k7mYT2_',0,'2017-09-03 12:21:05','2017-10-08 17:04:47','0000-00-00',1,NULL,NULL),(2,'Employee','Emplo','','employee@mail.com','$2y$11$NVZNbD4tTOk4Cs6Go.trMe8ffOTt4CHlTHEPWCeOYctetMvwJXkea','6b48c0b21b979322e0cabb9bc38a081d.jpg',2,NULL,1,'_RIO8Qx0hwU_',0,'2017-09-03 12:22:39','2017-10-08 15:40:05','2017-01-10',1,NULL,NULL),(3,'Intern','Interns','','intern@mail.com','$2y$11$W1brU2Inx.5nLAOr4khcweCh/3pttEI3hSICpuojIF1h6Cy7Y8PtG','c86f2b763e9443c28255ccb39e858917.jpeg',4,NULL,1,'_v98lGqSxng_',0,'2017-09-03 12:24:12','2017-10-08 16:56:32','0000-00-00',1,NULL,NULL),(4,'Farrah Debrah','Dionisio','Delos Santos','farrahdee24@gmail.com','$2y$11$jHbG/TqK4wAmWqr5Jbt44O9YJSgwAp665LdXIXteNPF70h.4lcTYK','aedee00cb789673704bb341d2139ca2a.png',2,NULL,1,'_5VXDxiSqOt_',0,'2017-09-04 22:02:49','2017-10-08 17:02:00','0000-00-00',2,NULL,NULL),(5,'Armani','Armani','Armni','armani@gmail.com','$2y$11$BwzWE7VlZw5owYOsuChDWOOx6MEvb7jtgOkoxpsnXPll8ioaxIEDG','682653e39f320b6ea663abcdbeb0732c.png',4,NULL,1,'_j4rQ28lxve_',0,'2017-09-09 20:14:55','2017-10-07 15:26:22','2017-10-10',1,NULL,NULL),(6,'Armani','Armani','Armani','hello@gmail.com','$2y$11$zc4e021z8S2zqYyhk8/ULOLKi3HYJuvOw7djrym5f60b.9nJX2wV2','no_image.jpg',4,NULL,0,'_5WvapwPS4R_',0,'2017-09-09 20:19:28','2017-10-07 00:24:47','0000-00-00',1,NULL,NULL),(9,'Sample Intern','V','Sample Intern','sampleintern@gmail.com','$2y$11$aTcb95ciwVcSWMR4atexGuqpgQaBWT43xJr47Ac8VrDui0iiEA0Ri','no_image.jpg',4,NULL,1,'_HLN0gYjnrW_',0,'2017-09-30 11:29:51','2017-10-07 17:50:30','0000-00-00',1,0,'_lcuAb6jdWUmr4gS_'),(10,'Hr','Hr','Hr','hr@gmail.com','$2y$11$iLQonyOCGXiH.uh7OBWSG.KBvQw7OjPFzNxKzJ1fav3IPshR/5OTC','no_image.jpg',3,NULL,1,'_3uTyzZkDUd_',0,'2017-10-01 06:22:09','2017-10-08 17:13:23','0000-00-00',1,NULL,NULL),(24,'Adsad','Asdasd','Asdsad','asdsd@gmail.com','$2y$11$aKbxECT2CYkCInSXRzfcjebSEXjMr0Rwkj5QllcWghSU5ywlkGpcW','no_image.jpg',1,NULL,0,'_iM6wJuegRt_',0,'2017-10-03 00:45:02','2017-10-07 00:10:00','0000-00-00',1,NULL,NULL),(56,'Email','Emailconfirmation','Confirmation','emailconfirmation@mail.com','$2y$11$aUrZdu2vn4OGS9a2TnMJOuuGcc8taZCMl3XxXqfJTKqXvN6E2RuPm','no_image.jpg',1,NULL,1,'_jV0FwDsdYPZ8tE4_',1,'2017-10-07 17:34:44','2017-10-08 15:40:05','2017-10-05',1,0,'_u5x8jdgBCsVDlOi_');
  /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  UNLOCK TABLES;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_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 */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed on 2017-10-09  1:23:59
  