text: /*
  SQLyog Job Agent v10.42 Copyright(c) Webyog Inc. All Rights Reserved.
  
  
  MySQL - 5.5.5-10.1.13-MariaDB : Database - hris
  *********************************************************************
  */
  
  /*!40101 SET NAMES utf8 */;
  
  /*!40101 SET SQL_MODE=''*/;
  
  /*!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 */;
  CREATE DATABASE /*!32312 IF NOT EXISTS*/`hris` /*!40100 DEFAULT CHARACTER SET latin1 */;
  
  USE `hris`;
  
  /*Table structure for table `document_status` */
  
  DROP TABLE IF EXISTS `document_status`;
  
  CREATE TABLE `document_status` (
    `contract_id` int(255) NOT NULL AUTO_INCREMENT,
    `empcode` int(255) NOT NULL,
    `status` varchar(10) DEFAULT NULL,
    `start_date` date DEFAULT NULL,
    `end_date` date DEFAULT NULL,
    `inputby` varchar(30) CHARACTER SET utf8 DEFAULT NULL,
    `inputdate` datetime DEFAULT NULL,
    `updateby` varchar(30) CHARACTER SET utf8 DEFAULT NULL,
    `updatedate` datetime DEFAULT NULL,
    `contract_no` varchar(255) DEFAULT NULL,
    `masa_kerja` varchar(255) DEFAULT NULL,
    `sign_date` date DEFAULT NULL,
    `approved_id` int(255) NOT NULL,
    `remarks` varchar(255) DEFAULT NULL,
    `contract_status` varchar(10) DEFAULT NULL,
    PRIMARY KEY (`contract_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=latin1;
  
  /*Data for the table `document_status` */
  
  insert  into `document_status` values (5,1800002,'closed','2018-01-25','2018-04-25','gandhi','2018-03-23 19:11:42','gandhi','2018-04-09 08:51:34','002hr','0 Tahun 3 Bulan 0 Hari','2018-01-25',1800005,'kontak 3 bulan',NULL),(6,1800009,'closed','2013-06-18','2014-03-17',NULL,NULL,'gandhi','2018-04-12 23:20:43','','',NULL,0,'',NULL),(7,1800010,'submit','2018-03-15','2018-09-14',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(8,1800011,'closed','2017-08-07','2018-02-06',NULL,NULL,'gandhi','2018-04-12 23:22:05','','',NULL,0,'',NULL),(9,1800012,'submit','2017-12-19','2018-06-18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(10,1800013,'closed','2017-05-09','2018-05-08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(11,1800014,'submit','2018-01-10','2019-01-09',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(12,1800015,'closed','2018-03-19','2018-03-18',NULL,NULL,'gandhi','2018-04-24 16:43:34','','',NULL,0,'',NULL),(13,1800016,'submit','2018-02-05','2018-08-04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(14,1800017,'closed','2012-09-30','2013-06-29',NULL,NULL,'gandhi','2018-04-12 23:19:38','','',NULL,0,'',NULL),(15,1800018,'closed','2012-12-18','2013-09-17',NULL,NULL,'gandhi','2018-04-12 23:20:35','','',NULL,0,'',NULL),(16,1800019,'submit','2018-01-13','2018-07-12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(17,1800020,'closed','2012-11-07','2013-08-06',NULL,NULL,'gandhi','2018-04-12 23:20:12','','',NULL,0,'',NULL),(18,1800021,'closed','2012-11-07','2013-08-06',NULL,NULL,'gandhi','2018-04-12 23:20:17','','',NULL,0,'',NULL),(19,1800022,'closed','2017-01-21','2018-01-20',NULL,NULL,'gandhi','2018-04-12 23:21:55','','',NULL,0,'',NULL),(20,1800023,'submit','2018-02-12','2018-08-11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(21,1800024,'submit','2018-02-12','2018-08-11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(22,1800025,'closed','2017-01-21','2018-01-20',NULL,NULL,'gandhi','2018-04-12 23:21:51','','',NULL,0,'',NULL),(23,1800026,'closed','2017-08-26','2018-02-25',NULL,NULL,'gandhi','2018-04-12 23:22:38','','',NULL,0,'',NULL),(24,1800027,'closed','2017-08-26','2018-02-25',NULL,NULL,'gandhi','2018-04-12 23:22:43','','',NULL,0,'',NULL),(25,1800028,'closed','2017-08-26','2018-02-25',NULL,NULL,'gandhi','2018-04-12 23:22:48','','',NULL,0,'',NULL),(26,1800029,'closed','2017-05-08','2017-11-07',NULL,NULL,'gandhi','2018-04-12 23:20:59','','',NULL,0,'',NULL),(27,1800030,'submit','2017-11-02','2018-11-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(28,1800031,'submit','2017-10-08','2018-11-07',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(29,1800032,'submit','2017-10-08','2018-11-07',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(30,1800033,'submit','2017-11-02','2018-11-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(31,1800034,'closed','2017-05-08','2017-11-07',NULL,NULL,'gandhi','2018-04-12 23:20:52','','',NULL,0,'',NULL),(32,1800035,'submit','2017-11-02','2018-11-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(33,1800036,'submit','2017-11-02','2018-11-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(34,1800037,'submit','2017-11-02','2018-11-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(35,1800038,'closed','2017-05-02','1970-01-01',NULL,NULL,'gandhi','2018-04-12 23:18:35','','',NULL,0,'',NULL),(36,1800039,'closed','2017-05-13','2017-11-12',NULL,NULL,'gandhi','2018-04-12 23:21:04','','',NULL,0,'',NULL),(37,1800040,'submit','2017-12-05','2018-06-04',NULL,NULL,'gandhi','2018-05-22 07:47:46','','',NULL,0,'','PKWTII'),(38,1800041,'submit','2017-12-05','2018-06-04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(39,1800042,'submit','2017-12-05','2018-12-04',NULL,NULL,'dini','2018-05-22 07:20:37','','1 Tahun 0 Bulan 0 Hari',NULL,0,'','PKWTII'),(40,1800043,'submit','2017-12-05','2018-12-04',NULL,NULL,'dini','2018-05-22 07:18:53','','1 Tahun 0 Bulan 0 Hari',NULL,0,'','PKWTII'),(41,1800044,'submit','2018-02-12','2018-08-11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(42,1800045,'submit','2018-02-12','2018-08-11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(43,1800046,'submit','2018-02-27','2018-08-26',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(44,1800047,'submit','2018-03-02','2018-09-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(45,1800048,'closed','2012-10-22','2013-07-21',NULL,NULL,'gandhi','2018-04-12 23:19:43','','',NULL,0,'',NULL),(46,1800049,'closed','2013-02-16','2013-11-15',NULL,NULL,'gandhi','2018-04-12 23:20:40','','',NULL,0,'',NULL),(47,1800050,'submit','2017-11-22','2018-11-21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(48,1800051,'closed','2013-09-30','2013-06-29',NULL,NULL,'gandhi','2018-04-12 23:18:48','','',NULL,0,'',NULL),(49,1800052,'closed','2012-11-07','2013-08-06',NULL,NULL,'gandhi','2018-04-12 23:19:52','','',NULL,0,'',NULL),(50,1800053,'submit','2018-01-07','2019-01-06',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(51,1800054,'submit','2018-02-19','2018-08-18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(52,1800055,'closed','2013-12-12','2014-09-11',NULL,NULL,'gandhi','2018-04-12 23:20:47','','',NULL,0,'',NULL),(53,1800056,'closed','2017-11-13','2018-05-12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(54,1800057,'closed','2017-07-05','2018-01-04',NULL,NULL,'gandhi','2018-04-12 23:21:27','','',NULL,0,'',NULL),(55,1800058,'submit','2018-01-05','2019-01-04',NULL,NULL,'dini','2018-05-22 07:23:25','','1 Tahun 0 Bulan 0 Hari',NULL,0,'','PKWTII'),(56,1800059,'closed','2017-07-05','2018-01-04',NULL,NULL,'gandhi','2018-04-12 23:21:09','','',NULL,0,'',NULL),(57,1800060,'submit','2018-01-05','2019-01-04',NULL,NULL,'dini','2018-05-22 07:24:15','','1 Tahun 0 Bulan 0 Hari',NULL,0,'','PKWTII'),(58,1800061,'submit','2018-02-05','2018-08-04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(59,1800062,'submit','2018-02-19','2018-08-18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(60,1800063,'closed','2018-03-07','2018-03-06',NULL,NULL,'gandhi','2018-04-12 23:22:56','','',NULL,0,'',NULL),(61,1800064,'submit','2017-06-05','2018-06-04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(62,1800065,'submit','2017-06-05','2018-06-04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(63,1800066,'closed','2017-08-26','2018-02-25',NULL,NULL,'gandhi','2018-04-12 23:22:18','','',NULL,0,'',NULL),(64,1800067,'closed','2017-08-26','2018-02-25',NULL,NULL,'gandhi','2018-04-12 23:22:23','','',NULL,0,'',NULL),(65,1800068,'submit','2018-02-05','2018-08-04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(66,1800069,'submit','2018-02-05','2018-08-04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(67,1800070,'submit','2018-02-05','2018-08-04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(68,1800071,'submit','2018-03-07','2019-03-06',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(69,1800072,'closed','2017-03-06','2018-03-05',NULL,NULL,'gandhi','2018-04-12 23:22:52','','',NULL,0,'',NULL),(70,1800073,'closed','2017-01-21','2018-01-20',NULL,NULL,'gandhi','2018-04-12 23:21:33','','',NULL,0,'',NULL),(72,1800075,'closed','2017-04-22','2018-04-21',NULL,NULL,'gandhi','2018-04-24 16:43:50','','0 Tahun 11 Bulan 29 Hari',NULL,0,'',NULL),(73,1800076,'closed','2017-04-22','2018-04-21',NULL,NULL,'gandhi','2018-04-24 16:43:55','','',NULL,0,'',NULL),(74,1800077,'submit','2018-02-05','2018-08-04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(75,1800078,'submit','2018-02-05','2018-08-04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(76,1800079,'submit','2018-01-12','2019-01-11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(77,1800080,'submit','2018-02-05','2018-08-04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(78,1800081,'submit','2018-01-11','2018-07-10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(79,1800082,'closed','2017-01-21','2018-01-20',NULL,NULL,'gandhi','2018-04-12 23:21:46','','',NULL,0,'',NULL),(80,1800083,'closed','2017-01-21','2018-01-20',NULL,NULL,'gandhi','2018-04-12 23:21:42','','',NULL,0,'',NULL),(81,1800084,'closed','2017-02-23','2018-02-22',NULL,NULL,'gandhi','2018-04-12 23:22:12','','',NULL,0,'',NULL),(82,1800085,'submit','2018-03-19','2018-09-18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(83,1800086,'closed','2017-03-09','2018-03-08',NULL,NULL,'gandhi','2018-04-12 23:23:10','','',NULL,0,'',NULL),(84,1800087,'closed','2017-03-08','2018-03-07',NULL,NULL,'gandhi','2018-04-12 23:23:00','','',NULL,0,'',NULL),(85,1800088,'closed','2017-08-26','2018-02-25',NULL,NULL,'gandhi','2018-04-12 23:22:28','','',NULL,0,'',NULL),(86,1800089,'submit','2017-11-02','2018-11-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(87,1800090,'submit','2017-11-19','2018-11-18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(88,1800091,'closed','2017-10-31','2018-04-30',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(89,1800092,'submit','2018-02-12','2018-08-11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(90,1800093,'submit','2017-11-13','2018-11-12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(91,1800094,'submit','2018-02-14','2018-08-13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(92,1800095,'submit','2018-03-23','2018-09-22',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(93,1800096,'submit','2018-03-19','2018-09-18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(94,1800097,'submit','2018-03-29','2018-09-28',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(95,1800098,'closed','2012-11-07','2013-08-06',NULL,NULL,'gandhi','2018-04-12 23:20:00','','',NULL,0,'',NULL),(96,1800099,'closed','2012-11-07','2013-08-06',NULL,NULL,'gandhi','2018-04-12 23:20:07','','',NULL,0,'',NULL),(97,1800100,'submit','2017-11-13','2018-11-12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(98,1800101,'closed','2012-12-01','2013-08-31',NULL,NULL,'gandhi','2018-04-12 23:20:26','','',NULL,0,'',NULL),(99,1800102,'closed','2012-12-01','2013-08-31',NULL,NULL,'gandhi','2018-04-12 23:20:21','','',NULL,0,'',NULL),(100,1800103,'closed','2017-01-21','2018-01-20',NULL,NULL,'gandhi','2018-04-12 23:21:37','','',NULL,0,'',NULL),(101,1800104,'submit','2018-02-20','2018-08-19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(102,1800105,'submit','2018-03-08','2018-09-07',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(103,1800106,'submit','2018-02-20','2018-08-19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(104,1800107,'submit','2018-02-20','2018-08-19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(105,1800108,'submit','2017-11-13','2018-11-12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(106,1800109,'closed','2017-08-26','2018-02-25',NULL,NULL,'gandhi','2018-04-12 23:22:34','','',NULL,0,'',NULL),(107,1800110,'submit','2018-02-26','2018-08-25',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(108,1800111,'closed','2017-10-13','2018-04-12',NULL,NULL,'nugraha','2018-04-09 14:59:49','','',NULL,0,'',NULL),(109,1800112,'submit','2018-02-12','2018-08-11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(110,1800113,'submit','2018-02-20','2018-08-19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(111,1800114,'submit','2018-02-20','2018-08-19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(112,1800115,'submit','2018-02-20','2018-08-19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(113,1800116,'submit','2018-02-26','2018-08-25',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(114,1800117,'submit','2018-03-11','2018-09-10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(115,1800118,'submit','2017-12-02','2018-12-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(116,1800119,'submit','2018-03-19','2018-09-18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(117,1800120,'closed','2013-09-30','2013-06-29',NULL,NULL,'gandhi','2018-04-12 23:18:41','','',NULL,0,'',NULL),(118,1800121,'closed','2013-09-30','2013-06-29',NULL,NULL,'gandhi','2018-04-12 23:19:01','','',NULL,0,'',NULL),(119,1800122,'closed','2013-09-30','2013-06-29',NULL,NULL,'gandhi','2018-04-12 23:18:56','','',NULL,0,'',NULL),(120,1800123,'closed','2017-03-02','2018-03-01',NULL,NULL,'gandhi','2018-04-12 23:19:30','','',NULL,0,'',NULL),(121,1800124,'closed','2017-11-22','2018-05-21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(122,1800125,'closed','2017-11-26','2018-05-25',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(123,1800126,'submit','2018-03-02','2018-09-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(124,1800127,'submit','2018-03-02','2018-09-01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(125,1800128,'closed','2017-06-03','2018-06-02',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(126,1800129,'submit','2018-02-17','2018-08-16',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(127,1800130,'closed','2018-02-11','2018-05-10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(128,1800131,'submit','2018-02-19','2018-08-18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(129,1800132,'submit','2018-02-05','2018-08-04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(130,1800133,'closed','2012-12-09','2013-09-08',NULL,NULL,'gandhi','2018-04-12 23:20:31','','',NULL,0,'',NULL),(131,1800134,'submit','2017-10-20','2018-10-19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(132,1800135,'submit','2017-10-10','2018-10-09',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(133,1800136,'submit','2017-10-06','2018-10-05',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(134,1800137,'submit','2017-10-17','2018-10-16',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(135,1800138,'closed','2017-04-17','2018-04-16',NULL,NULL,'gandhi','2018-04-24 16:43:47','','',NULL,0,'',NULL),(136,1800139,'closed','2017-03-14','2018-03-13',NULL,NULL,'supatno','2018-04-16 13:31:47','','',NULL,0,'',NULL),(137,1800140,'closed','2017-09-09','2018-03-08',NULL,NULL,'gandhi','2018-04-12 23:23:05','','',NULL,0,'',NULL),(138,1800141,'closed','2017-10-10','2018-04-09',NULL,NULL,'gandhi','2018-04-24 16:43:39','','',NULL,0,'',NULL),(139,1800142,'closed','2017-10-13','2018-04-12',NULL,NULL,'gandhi','2018-04-24 16:43:43','','',NULL,0,'',NULL),(140,1800143,'submit','2017-11-09','2018-11-08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL),(141,1800144,'closed','2017-01-22','2018-01-21',NULL,NULL,'gandhi','2018-04-12 23:22:00','','',NULL,0,'',NULL),(151,1800289,'submit','2018-04-13','2018-10-12','dini','2018-05-22 14:08:13',NULL,NULL,'','0 Tahun 5 Bulan 30 Hari','2018-04-13',0,'','PKWTI'),(152,1800287,'submit','2018-04-13','2018-10-12','dini','2018-05-22 14:10:51',NULL,NULL,'','0 Tahun 5 Bulan 30 Hari','2018-04-13',0,'','PKWTI'),(153,1800286,'submit','2018-04-11','2018-07-10','dini','2018-05-22 14:11:44','dini','2018-05-22 14:11:57','','0 Tahun 2 Bulan 30 Hari','2018-04-11',0,'','PKWTI'),(154,1800290,'submit','2018-04-14','2018-10-13','dini','2018-05-22 14:15:47','dini','2018-05-22 14:16:15','','0 Tahun 5 Bulan 30 Hari','2018-04-14',0,'','PKWTI'),(155,1800291,'submit','2018-04-21','2018-10-20','dini','2018-05-22 14:23:02',NULL,NULL,'','0 Tahun 5 Bulan 30 Hari','2018-04-21',0,'','PKWTI'),(156,1800292,'submit','2018-04-24','2018-10-23','dini','2018-05-22 14:27:17',NULL,NULL,'','0 Tahun 5 Bulan 30 Hari','2018-04-24',0,'','PKWTI'),(157,1800293,'submit','2018-04-28','2018-10-27','dini','2018-05-22 14:30:38',NULL,NULL,'','0 Tahun 5 Bulan 30 Hari','2018-04-28',0,'','PKWTI'),(158,1800294,'submit','2018-04-28','2018-10-27','dini','2018-05-22 14:33:25',NULL,NULL,'','0 Tahun 5 Bulan 30 Hari','2018-04-28',0,'','PKWTI'),(159,1800295,'submit','2018-05-12','2018-11-11','dini','2018-05-22 14:36:07',NULL,NULL,'','0 Tahun 5 Bulan 29 Hari','2018-05-12',0,'','PKWTI'),(160,1800288,'submit','2018-04-16','2018-10-15','dini','2018-05-22 14:55:23',NULL,NULL,'','0 Tahun 5 Bulan 30 Hari','2018-04-16',0,'','PKWTI'),(161,1800001,'draft','2018-01-18','2018-07-17','gandhi','2018-05-28 07:24:15','gandhi','2018-05-31 15:37:41','-','0 Tahun 5 Bulan 30 Hari','2018-02-20',0,'','PKWTI');
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  