--
-- Host: localhost    Database: perpsol_paperless
-- ------------------------------------------------------


--
-- Table structure for table `pl_assets`
--

CREATE TABLE `pl_assets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) DEFAULT NULL,
  `vendor_reference_no` varchar(250) DEFAULT NULL,
  `part_number` varchar(250) DEFAULT NULL,
  `vendor_contact` varchar(250) DEFAULT NULL,
  `department` varchar(250) DEFAULT NULL,
  `category` varchar(250) DEFAULT NULL,
  `is_deleted` int(3) DEFAULT '0' COMMENT '0 = no; 1 = yes',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_assets`
--

INSERT INTO `pl_assets` (`id`, `name`, `vendor_reference_no`, `part_number`, `vendor_contact`, `department`, `category`, `is_deleted`) VALUES (1,'test','545642135','45655321','+973 3333 3333','Maintenance','1,3',0),(2,'testing','5857595652','564654897','+973 3333 3333','Maintenance','1,2,3',0);

--
-- Table structure for table `pl_category`
--

CREATE TABLE `pl_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) DEFAULT NULL,
  `description` text,
  `subcategory` varchar(250) DEFAULT NULL,
  `is_deleted` int(3) DEFAULT '0' COMMENT '0 = no; 1 = yes',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_category`
--

INSERT INTO `pl_category` (`id`, `name`, `description`, `subcategory`, `is_deleted`) VALUES (1,'Test','test test','2,3',0),(2,'Tested','test test ','1,2,3',0),(3,'Testing','Category Details','2',0);

--
-- Table structure for table `pl_chatnotitfication`
--

CREATE TABLE `pl_chatnotitfication` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `receiver_id` int(11) DEFAULT NULL,
  `sender_id` int(11) DEFAULT NULL,
  `dos_id` int(11) DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `chat_text` text,
  `url` varchar(255) DEFAULT NULL,
  `is_read` int(3) DEFAULT '0' COMMENT '0 = no; 1 = yes',
  `u_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_chatnotitfication`
--

INSERT INTO `pl_chatnotitfication` (`id`, `receiver_id`, `sender_id`, `dos_id`, `count`, `chat_text`, `url`, `is_read`, `u_date`) VALUES (10,2,6,25,1,'hello','http://perpsol.com/backend/web/pldoschecklist/index?id=25',1,'2019-01-16 13:04:15'),(11,6,2,25,4,'testte','http://perpsol.com/backend/web/pldoschecklist/index?id=25',0,'2019-01-17 12:20:20'),(12,6,2,26,1,'hello','http://perpsol.com/backend/web/pldoschecklist/index?id=26',0,'2019-01-16 13:09:01'),(13,8,2,32,2,'test','http://perpsol.com/backend/web/pldoschecklist/index?id=32',1,'2019-04-12 11:59:11'),(14,8,2,30,2,'I am doing well.','http://perpsol.com/backend/web/pldoschecklist/index?id=30',0,'2019-04-18 12:57:05'),(15,2,8,30,1,'I am doing well , how are you ?','http://perpsol.com/backend/web/pldoschecklist/index?id=30',1,'2019-04-18 05:56:48');

--
-- Table structure for table `pl_checklist`
--

CREATE TABLE `pl_checklist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) DEFAULT NULL,
  `deadline` date DEFAULT NULL,
  `is_deleted` int(3) DEFAULT '0' COMMENT '1 = yes; 0 = no',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_checklist`
--

INSERT INTO `pl_checklist` (`id`, `name`, `deadline`, `is_deleted`) VALUES (1,'Testing','2018-08-28',0),(2,'Hello','2018-08-29',0),(3,'PLUG SETTING','2018-11-28',0),(4,'VEHICLE CHECK LIST','2018-12-27',0);

--
-- Table structure for table `pl_dos`
--

CREATE TABLE `pl_dos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(250) DEFAULT NULL,
  `assign_emp` varchar(255) DEFAULT NULL,
  `planned_job` varchar(255) DEFAULT NULL,
  `start_planning_date` date DEFAULT NULL,
  `latitude` varchar(255) DEFAULT NULL,
  `longitude` varchar(255) DEFAULT NULL,
  `customer` varchar(255) DEFAULT NULL,
  `hq` varchar(255) DEFAULT NULL,
  `well_name` varchar(255) DEFAULT NULL,
  `rig_name` varchar(255) DEFAULT NULL,
  `date_of_mobilization` date DEFAULT NULL,
  `operations_manager` varchar(255) DEFAULT NULL,
  `customer_representative` varchar(255) DEFAULT NULL,
  `engineer` varchar(255) DEFAULT NULL,
  `crew_lead` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `drilling_engineer` varchar(255) DEFAULT NULL,
  `chief_geologist` varchar(255) DEFAULT NULL,
  `well_type` varchar(255) DEFAULT NULL,
  `hole_sizes` varchar(255) DEFAULT NULL,
  `casing_sizes` varchar(255) DEFAULT NULL,
  `area` varchar(255) DEFAULT NULL,
  `td` varchar(255) DEFAULT NULL,
  `depth` varchar(255) DEFAULT NULL,
  `exp_max_temperature` varchar(255) DEFAULT NULL,
  `elevation` varchar(255) DEFAULT NULL,
  `surface_leve` varchar(255) DEFAULT NULL,
  `max_surface_pressure` varchar(255) DEFAULT NULL,
  `system_pressure_rating` varchar(255) DEFAULT NULL,
  `run` varchar(255) DEFAULT NULL,
  `dos_progress` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT '0',
  `category` varchar(250) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `is_deleted` int(11) DEFAULT '0' COMMENT '0= no; 1= yes',
  `is_completed` int(3) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_dos`
--

INSERT INTO `pl_dos` (`id`, `title`, `assign_emp`, `planned_job`, `start_planning_date`, `latitude`, `longitude`, `customer`, `hq`, `well_name`, `rig_name`, `date_of_mobilization`, `operations_manager`, `customer_representative`, `engineer`, `crew_lead`, `department`, `drilling_engineer`, `chief_geologist`, `well_type`, `hole_sizes`, `casing_sizes`, `area`, `td`, `depth`, `exp_max_temperature`, `elevation`, `surface_leve`, `max_surface_pressure`, `system_pressure_rating`, `run`, `dos_progress`, `status`, `category`, `start_date`, `end_date`, `created_by`, `is_deleted`, `is_completed`) VALUES (7,'Coring',NULL,NULL,'2018-02-14',NULL,NULL,'BAPCO','MANAMA','ZALQ','BP-1','2018-02-16','FAHAD','LORA','','','IT','M. GANNAS','CIRCI','GAS','14','13-3/8\"','ABCD','1200 M','300 M','150 B','138','24','2000PSI','10,000PSI','CORING',NULL,0,NULL,'2018-12-14','2018-12-31',2,1,0),(8,'test',NULL,NULL,'2018-11-27',NULL,NULL,'test','450','test','test','2018-12-30','test','test','test','test','test','test','test','test','test','4540','testing','test','5487','548','test','454','454','4878','test',NULL,NULL,NULL,'2018-12-18','2018-12-31',2,1,0),(9,'Coring',NULL,NULL,'2018-02-14',NULL,NULL,'BAPCO','MANAMA','ZALQ_4','BP-1','2018-02-16','FAHAD','LORA','test','test','testing','M. GANNAS','CIRCI','GAS','14','13-3/8\"','ZALLAQ','1200 M','300 F','150 C','138','24','2000PSI','10,000PSI','CORING',NULL,NULL,NULL,'2018-12-18','2019-01-02',2,1,0),(10,'test',NULL,NULL,'2018-11-28',NULL,NULL,'BAPCO','MANAMA','ZALQ_4','BP-1','2018-12-20','FAHAD','LORA','','','','M. GANNAS','CIRCI','GAS','14','13-3/8\"','ZALLAQ','1200 M','300 M','150 C','138','24','2000PSI','10,000PSI','CORING',NULL,0,NULL,'2018-12-18','2018-12-31',2,1,0),(11,'PERF',NULL,NULL,'1970-01-01',NULL,NULL,'ARAMCO','SAUDI-test','SDGM_202','SINO-3','1970-01-01','HOUSAM','GAMAL','','','','MAHMOUD','WAHEED','OIL','14','13-3/8\"','ABQAIQ','13000 M','200 M','100 C','130','30','15000PSI','2000PSI','CORING',NULL,0,NULL,'2018-12-26','2019-03-07',2,1,0),(12,'SDGM_202',NULL,'PERF','2018-02-14',NULL,NULL,'ARAMCO','SAUDI','SDGM_202','SINO-3','2018-12-28','HOUSAM','GAMAL','','','','MAHMOUD','WAHEED','OIL','14','13-3/8\"','ABQAIQ','13000 M','200 M','100 C','130','30','15000PSI','2000PSI','CORING',NULL,0,NULL,'2018-12-26','2018-12-31',2,1,0),(13,'SDGM_2021',NULL,'PERF','1970-01-01',NULL,NULL,'ARAMCO','SAUDI-testing-1','SDGM_2021','SINO-3','1970-01-01','HOUSAM','GAMAL','','','','MAHMOUD','WAHEED','OIL','14','13-3/8\"','ABQAIQ','13000 M','200 M','100 C','130','30','15000PSI','2000PSI','CORING',NULL,0,NULL,'2018-12-26','2019-01-02',2,1,0),(14,'SDGM_555',NULL,'PERF','2018-02-14',NULL,NULL,'ARAMCO','SAUDI','SDGM_555','SINO-3','2018-12-28','HOUSAM','GAMAL','','','IT','MAHMOUD','WAHEED','OIL','14','13-3/8\"','ABQAIQ','13000 M','200 M','100 C','130','30','15000PSI','2000PSI','CORING',NULL,0,NULL,'2018-12-26','2018-12-31',2,1,0),(15,'SDGM_6027',NULL,'PERF','1970-01-01',NULL,NULL,'ARAMCO','SAUDI-testing-1','SDGM_6027','SINO-3','1970-01-01','HOUSAM','GAMAL','','','','MAHMOUD','WAHEED','OIL','14','13-3/8\"','ABQAIQ','13000 M','200 M','100 C','130','30','15000PSI','2000PSI','CORING',NULL,0,NULL,'2018-12-27','2018-12-25',2,1,0),(16,'SDGM_6028',NULL,'PERF','1970-01-01',NULL,NULL,'ARAMCO','SAUDI-testing-1','SDGM_6028','SINO-3','1970-01-01','HOUSAM','GAMAL','','','','MAHMOUD','WAHEED','OIL','14','13-3/8\"','ABQAIQ','13000 M','200 M','100 C','130','30','15000PSI','2000PSI','CORING',NULL,0,NULL,'2018-12-27','2018-12-25',2,1,0),(17,'SDGM_202',NULL,'PERF','2018-02-14',NULL,NULL,'ARAMCO','SAUDI','SDGM_202','SINO-3','2018-12-28','HOUSAM','GAMAL','','','','MAHMOUD','WAHEED','OIL','14','13-3/8\"','ABQAIQ','13000 M','200 M','100 C','130','30','15000PSI','2000PSI','CORING',NULL,1,NULL,'2018-12-27','2018-12-31',2,1,0),(18,'SDGM_202',NULL,'PERF','2018-02-14',NULL,NULL,'ARAMCO','SAUDI','SDGM_202','SINO-3','2018-12-28','HOUSAM','GAMAL','','','','MAHMOUD','WAHEED','OIL','14','13-3/8\"','ABQAIQ','13000 M','200 M','100 C','130','30','15000PSI','2000PSI','CORING',NULL,6,NULL,'2018-12-27','2018-12-31',2,0,1),(19,'SDGM_6028',NULL,'PERF','1970-01-01',NULL,NULL,'ARAMCO','SAUDI-testing-1','SDGM_6028','SINO-3','1970-01-01','HOUSAM','GAMAL','','','','MAHMOUD','WAHEED','OIL','14','13-3/8\"','ABQAIQ','13000 M','200 M','100 C','130','30','15000PSI','2000PSI','CORING',NULL,7,NULL,'2018-12-27','2018-12-18',2,0,1),(20,'SDGM_6028',NULL,'PERF','1970-01-01',NULL,NULL,'ARAMCO','SAUDI-testing-1','SDGM_6028','SINO-3','1970-01-01','HOUSAM','GAMAL','','','','MAHMOUD','WAHEED','OIL','14','13-3/8\"','ABQAIQ','13000 M','200 M','100 C','130','30','15000PSI','2000PSI','CORING',NULL,7,NULL,'2018-12-27','2019-01-03',2,0,1),(21,'SDGM_6028',NULL,'PERF','1970-01-01',NULL,NULL,'ARAMCO','SAUDI-testing-1','SDGM_6028','SINO-3','1970-01-01','HOUSAM','GAMAL','','','','MAHMOUD','WAHEED','OIL','14','13-3/8\"','ABQAIQ','13000 M','200 M','100 C','130','30','15000PSI','2000PSI','CORING',NULL,1,NULL,'2018-12-27','2018-12-25',2,1,0),(22,'SDGM_202',NULL,'PERF','2018-02-14',NULL,NULL,'ARAMCO','SAUDI','SDGM_202','SINO-3','2018-12-28','HOUSAM','GAMAL','','','','MAHMOUD','WAHEED','OIL','14','13-3/8\"','ABQAIQ','13000 M','200 M','100 C','130','30','15000PSI','2000PSI','CORING',NULL,6,NULL,'2018-12-27','2019-01-05',2,0,1),(23,'SDGM_202',NULL,'PERF','2018-02-14',NULL,NULL,'ARAMCO','SAUDI','SDGM_202','SINO-3','2018-12-28','HOUSAM','GAMAL','','','','MAHMOUD','WAHEED','OIL','14','13-3/8\"','ABQAIQ','13000 M','200 M','100 C','130','30','15000PSI','2000PSI','CORING',NULL,6,NULL,'2018-12-27','2019-01-04',2,0,1),(24,'SDGM_101',NULL,'PERF','2018-02-14',NULL,NULL,'ARAMCO','SAUDI','SDGM_101','SINO-3','2018-12-28','HOUSAM','GAMAL','','','','MAHMOUD','WAHEED','OIL','14','13-3/8\"','ABQAIQ','13000 M','200 M','100 C','130','30','15000PSI','2000PSI','CORING',NULL,7,NULL,'2018-12-27','2018-12-31',2,0,1),(25,'SDGM_6028','6','PERF','1970-01-01',NULL,NULL,'ARAMCO','SAUDI-testing-1','SDGM_6028','SINO-3','1970-01-01','HOUSAM','GAMAL','','','','MAHMOUD','WAHEED','OIL','14','13-3/8\"','ABQAIQ','13000 M','200 M','100 C','130','30','15000PSI','2000PSI','CORING',NULL,6,NULL,'2019-01-04','2019-01-21',2,0,1),(26,'SDGM_101','6','PERF','2018-02-14',NULL,NULL,'ARAMCO','SAUDI','SDGM_101','SINO-3','2018-12-28','HOUSAM','GAMAL','','','','MAHMOUD','WAHEED','OIL','14','13-3/8\"','ABQAIQ','13000 M','200 M','100 C','130','30','15000PSI','2000PSI','CORING',NULL,6,NULL,'2019-01-16','2019-01-20',7,0,1),(27,'ABQQ','7','MECH','2018-02-14',NULL,NULL,'ARAMCO','SAUDI','ABQQ','MP-1','2018-11-22','HENRI','HANI','','','','YAHIA','AMIR','OIL','14','13-3/8\"','ABQAIQ','13000 M','200 M','100 C','130','30','15000PSI','2000PSI','CORING',NULL,6,NULL,'2019-01-24','2019-01-30',2,0,0),(28,'test','6','test','2019-02-01',NULL,NULL,'','','','','2019-02-14','','','','','','','','','','','','','','','','','','','',NULL,6,NULL,'2019-02-14','2019-03-05',2,0,0),(29,'ZALQ_4',NULL,'Coring','2018-02-14',NULL,NULL,'BAPCO','MANAMA','ZALQ_4','BP-1','2018-02-16','FAHAD','LORA','','','','M. GANNAS','CIRCI','GAS','14','13-3/8\"','ZALLAQ','1200 M','300 M','150 C','138','24','2000PSI','10,000PSI','CORING',NULL,3,NULL,'2019-03-09','2019-03-25',2,0,1),(30,'SDGM_202','8','PERF','2018-02-14','23.677906809300772','78.00124120625003','ARAMCO','SAUDI','SDGM_202','SINO-3','2018-12-28','HOUSAM','GAMAL','','','','MAHMOUD','WAHEED','OIL','14','13-3/8\"','ABQAIQ','13000 M','200 M','100 C','130','30','15000PSI','2000PSI','CORING',NULL,6,NULL,'2019-03-12','2019-03-26',2,0,0),(31,'ZALQ_4123456',NULL,'Coring','2018-02-14','23.153668682152187','80.37428808125003','BAPCO','MANAMA','ZALQ_4123456','BP-1','2018-02-16','FAHAD','LORA','','','','M. GANNAS','CIRCI','GAS','14','13-3/8\"','ZALLAQ','1200 M','300 M','150 C','138','24','2000PSI','10,000PSI','CORING',NULL,1,NULL,'2019-03-15','2019-03-28',2,0,0),(32,'oxyrich','8','Coring','2018-02-14','23.919158417917956','82.21999120625003','BAPCO','MANAMA','oxyrich','BP-1','2018-02-16','FAHAD','LORA','','','','M. GANNAS','CIRCI','GAS','14','13-3/8\"','ZALLAQ','1200 M','300 M','150 C','138','24','2000PSI','10,000PSI','CORING',NULL,1,NULL,'2019-04-04','2019-05-07',7,1,0),(33,'ZALQ_4',NULL,'Coring','2018-02-14','20.255162202499854','78.83620214375003','BAPCO','MANAMA','ZALQ_4','BP-1','2018-02-16','FAHAD','LORA','','','','M. GANNAS','CIRCI','GAS','14','13-3/8\"','ZALLAQ','1200 M','300 M','150 C','138','24','2000PSI','10,000PSI','CORING',NULL,1,NULL,'2019-04-18','2019-05-01',8,0,1),(34,'oxysip',NULL,'Coring','2018-02-14','22.911015882431034','72.06862401875003','BAPCO','MANAMA','oxysip','BP-1','2018-02-16','FAHAD','LORA','','','','M. GANNAS','CIRCI','GAS','14','13-3/8\"','ZALLAQ','1200 M','300 M','150 C','138','24','2000PSI','10,000PSI','CORING',NULL,1,NULL,'2019-04-18','2019-05-08',8,0,0);

--
-- Table structure for table `pl_dos_effected_assets`
--

CREATE TABLE `pl_dos_effected_assets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dos_id` int(11) DEFAULT NULL,
  `doscategory_id` int(11) DEFAULT NULL,
  `pro_name` varchar(250) DEFAULT NULL,
  `pro_part_number` varchar(250) DEFAULT NULL,
  `pro_expenditure` varchar(250) DEFAULT NULL,
  `pro_date_of_resolution` date DEFAULT NULL,
  `pro_resolution` varchar(250) DEFAULT NULL,
  `pro_alert` varchar(250) DEFAULT NULL,
  `tr_name` varchar(250) DEFAULT NULL,
  `tr_part_number` varchar(250) DEFAULT NULL,
  `tr_expenditure` varchar(250) DEFAULT NULL,
  `tr_date_of_resolution` date DEFAULT NULL,
  `tr_resolution` varchar(250) DEFAULT NULL,
  `tr_alert` varchar(250) DEFAULT NULL,
  `is_deleted` int(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_dos_effected_assets`
--

INSERT INTO `pl_dos_effected_assets` (`id`, `dos_id`, `doscategory_id`, `pro_name`, `pro_part_number`, `pro_expenditure`, `pro_date_of_resolution`, `pro_resolution`, `pro_alert`, `tr_name`, `tr_part_number`, `tr_expenditure`, `tr_date_of_resolution`, `tr_resolution`, `tr_alert`, `is_deleted`) VALUES (1,2,1,'test','test','teset','2018-11-28','','','','','','2018-11-29','','',0);

--
-- Table structure for table `pl_dos_extra`
--

CREATE TABLE `pl_dos_extra` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dos_id` int(11) DEFAULT NULL,
  `doscategory_id` int(11) DEFAULT NULL,
  `site` varchar(250) DEFAULT NULL,
  `well` varchar(250) DEFAULT NULL,
  `hq` varchar(250) DEFAULT NULL,
  `department` varchar(250) DEFAULT NULL,
  `depth` varchar(250) DEFAULT NULL,
  `csg` varchar(250) DEFAULT NULL,
  `exp_max_temp` varchar(250) DEFAULT NULL,
  `planned_job` varchar(250) DEFAULT NULL,
  `status` varchar(250) DEFAULT NULL,
  `truck` varchar(250) DEFAULT NULL,
  `tools_and_equipment` varchar(250) DEFAULT NULL,
  `cable` varchar(250) DEFAULT NULL,
  `supervisor` varchar(250) DEFAULT NULL,
  `support` varchar(250) DEFAULT NULL,
  `sales_rep` varchar(250) DEFAULT NULL,
  `scope` varchar(250) DEFAULT NULL,
  `purchase_order` varchar(250) DEFAULT NULL,
  `expected_revenue` varchar(250) DEFAULT NULL,
  `actual_revenue` varchar(250) DEFAULT NULL,
  `supervisor_comment` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_dos_extra`
--


--
-- Table structure for table `pl_dos_finding`
--

CREATE TABLE `pl_dos_finding` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `doscategory_id` int(11) DEFAULT NULL,
  `dos_id` int(11) DEFAULT NULL,
  `part_number` varchar(250) DEFAULT NULL,
  `name` varchar(250) DEFAULT NULL,
  `expenditure` int(3) DEFAULT NULL,
  `date_of_resolution` date DEFAULT NULL,
  `category` varchar(250) DEFAULT NULL,
  `alert` int(3) DEFAULT NULL,
  `address1` varchar(250) DEFAULT NULL,
  `address2` varchar(250) DEFAULT NULL,
  `city` varchar(250) DEFAULT NULL,
  `state` varchar(250) DEFAULT NULL,
  `post_code` varchar(250) DEFAULT NULL,
  `country` int(11) DEFAULT NULL,
  `is_deleted` int(3) DEFAULT '0' COMMENT '0= no; 1 = yes',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_dos_finding`
--

INSERT INTO `pl_dos_finding` (`id`, `doscategory_id`, `dos_id`, `part_number`, `name`, `expenditure`, `date_of_resolution`, `category`, `alert`, `address1`, `address2`, `city`, `state`, `post_code`, `country`, `is_deleted`) VALUES (1,1,2,'test','test',1,'2018-11-28','Discard after use',1,'','','test','test','456479',2,0);

--
-- Table structure for table `pl_dos_inspection`
--

CREATE TABLE `pl_dos_inspection` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `doscategory_id` int(11) DEFAULT NULL,
  `dos_id` int(11) DEFAULT NULL,
  `first_name` varchar(250) DEFAULT NULL,
  `last_name` varchar(250) DEFAULT NULL,
  `phase` varchar(250) DEFAULT NULL,
  `date_of_inspection` date DEFAULT NULL,
  `type_of_inspection` varchar(250) DEFAULT NULL,
  `is_alert` int(3) DEFAULT NULL COMMENT '0 = no; 1 = yes',
  `gender` int(3) NOT NULL,
  `street` varchar(500) DEFAULT NULL,
  `city` varchar(250) DEFAULT NULL,
  `state` varchar(250) DEFAULT NULL,
  `post_code` varchar(250) DEFAULT NULL,
  `country` varchar(250) DEFAULT NULL,
  `is_deleted` int(3) DEFAULT '0' COMMENT '0 = no; 1 = yes',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_dos_inspection`
--

INSERT INTO `pl_dos_inspection` (`id`, `doscategory_id`, `dos_id`, `first_name`, `last_name`, `phase`, `date_of_inspection`, `type_of_inspection`, `is_alert`, `gender`, `street`, `city`, `state`, `post_code`, `country`, `is_deleted`) VALUES (1,1,2,'Testing','testing','1','2018-11-24','Category 1',1,1,'test','test','test','456789','KSA',0);

--
-- Table structure for table `pl_dos_template`
--

CREATE TABLE `pl_dos_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dos_id` int(11) DEFAULT NULL,
  `template_id` int(11) DEFAULT NULL,
  `checklist` varchar(250) DEFAULT NULL,
  `is_deleted` int(3) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_dos_template`
--

INSERT INTO `pl_dos_template` (`id`, `dos_id`, `template_id`, `checklist`, `is_deleted`) VALUES (3,2,3,NULL,0),(4,4,3,NULL,0),(5,12,3,NULL,1),(6,13,3,NULL,1),(7,14,3,'1',1),(8,14,5,NULL,1),(9,14,4,NULL,1),(10,15,6,NULL,1),(11,15,7,NULL,1),(12,16,7,NULL,1),(13,27,8,NULL,0);

--
-- Table structure for table `pl_dosactivity`
--

CREATE TABLE `pl_dosactivity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dos_id` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `trucks` varchar(255) DEFAULT NULL,
  `tools_and_equipment` varchar(255) DEFAULT NULL,
  `cabel` varchar(255) DEFAULT NULL,
  `supervisor` varchar(255) DEFAULT NULL,
  `support` varchar(255) DEFAULT NULL,
  `sales_rep` varchar(255) DEFAULT NULL,
  `scope` varchar(255) DEFAULT NULL,
  `purchase_order` varchar(255) DEFAULT NULL,
  `actual_revenue` varchar(255) DEFAULT NULL,
  `supervisor_comments` varchar(255) DEFAULT NULL,
  `is_deleted` int(3) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_dosactivity`
--

INSERT INTO `pl_dosactivity` (`id`, `dos_id`, `status`, `trucks`, `tools_and_equipment`, `cabel`, `supervisor`, `support`, `sales_rep`, `scope`, `purchase_order`, `actual_revenue`, `supervisor_comments`, `is_deleted`) VALUES (1,14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(2,15,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(3,16,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(4,18,'6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(5,19,'7',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(6,20,'7',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(7,21,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(8,22,'6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(9,23,'6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(10,24,'7',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(11,25,'6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(12,26,'6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(13,27,'6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(14,28,'6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(15,29,'3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(16,30,'6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(17,31,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(18,32,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(19,33,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(20,34,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `pl_doscategory`
--

CREATE TABLE `pl_doscategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL,
  `dos_id` int(11) DEFAULT NULL,
  `progress` int(11) DEFAULT NULL,
  `created_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `is_deleted` int(11) DEFAULT '0' COMMENT '0= no; 1 = yes',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_doscategory`
--

INSERT INTO `pl_doscategory` (`id`, `category_id`, `dos_id`, `progress`, `created_date`, `end_date`, `is_deleted`) VALUES (1,1,2,NULL,'2018-10-25',NULL,0),(2,3,7,NULL,'2018-11-22',NULL,0),(3,3,7,NULL,'2018-11-22',NULL,0),(4,1,7,NULL,'2018-11-22',NULL,0);

--
-- Table structure for table `pl_doschat`
--

CREATE TABLE `pl_doschat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dos_id` int(11) DEFAULT NULL,
  `sender_id` int(11) DEFAULT NULL,
  `message_text` text,
  `sent_time` varchar(255) DEFAULT NULL,
  `is_deleted` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_doschat`
--

INSERT INTO `pl_doschat` (`id`, `dos_id`, `sender_id`, `message_text`, `sent_time`, `is_deleted`) VALUES (16,25,6,'hello','1547643829',0),(17,25,2,'hello','1547643883',0),(18,26,2,'hello','1547644141',0),(19,25,2,'test','1547702414',0),(20,25,2,'testset','1547702417',0),(21,25,2,'testte','1547702420',0),(22,32,2,'Hello testing','1555070326',0),(23,32,2,'test','1555070339',0),(24,30,2,'Hello Sukunj how are you ?','1555566950',0),(25,30,8,'I am doing well , how are you ?','1555566998',0),(26,30,2,'I am doing well.','1555567025',0);

--
-- Table structure for table `pl_doschecklist`
--

CREATE TABLE `pl_doschecklist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dos_id` int(11) DEFAULT NULL,
  `checklist_id` int(11) DEFAULT NULL,
  `job_number` varchar(255) DEFAULT NULL,
  `coordinator` varchar(255) DEFAULT NULL,
  `latitude` varchar(255) DEFAULT NULL,
  `longitude` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `trucks` varchar(255) DEFAULT NULL,
  `cabel` varchar(255) DEFAULT NULL,
  `supervisor` varchar(255) DEFAULT NULL,
  `supervisor_comments` varchar(255) DEFAULT NULL,
  `purchase_order` varchar(255) DEFAULT NULL,
  `expected_revenue` varchar(255) DEFAULT NULL,
  `actual_revenue` varchar(255) DEFAULT NULL,
  `is_deleted` int(3) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_doschecklist`
--

INSERT INTO `pl_doschecklist` (`id`, `dos_id`, `checklist_id`, `job_number`, `coordinator`, `latitude`, `longitude`, `status`, `trucks`, `cabel`, `supervisor`, `supervisor_comments`, `purchase_order`, `expected_revenue`, `actual_revenue`, `is_deleted`) VALUES (1,7,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(2,7,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(3,8,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(4,9,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(5,11,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(6,12,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(7,13,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(8,13,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(9,14,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(10,14,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(11,14,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(12,15,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(13,15,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(14,15,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(15,15,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(16,16,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(17,16,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(18,16,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(19,25,3,'test','test','23.838791014184086','76.68288183125003','6','test','test','test','test','4564','45646','5464',0),(20,25,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(21,27,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(22,27,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(23,27,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(24,28,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(25,28,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(26,29,4,NULL,NULL,NULL,NULL,'6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(27,29,3,'','','','','6','','','','','','','',0),(28,31,4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(29,31,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `pl_dossheet`
--

CREATE TABLE `pl_dossheet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dos_id` int(11) DEFAULT NULL,
  `doschecklist_id` int(11) DEFAULT NULL,
  `job_number` varchar(255) DEFAULT NULL,
  `coordinator` varchar(255) DEFAULT NULL,
  `latitude` varchar(255) DEFAULT NULL,
  `longitude` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `trucks` varchar(255) DEFAULT NULL,
  `cabel` varchar(255) DEFAULT NULL,
  `supervisor` varchar(255) DEFAULT NULL,
  `supervisor_comments` varchar(255) DEFAULT NULL,
  `purchase_order` varchar(255) DEFAULT NULL,
  `expected_revenue` varchar(255) DEFAULT NULL,
  `actual_revenue` varchar(255) DEFAULT NULL,
  `is_deleted` int(3) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_dossheet`
--

INSERT INTO `pl_dossheet` (`id`, `dos_id`, `doschecklist_id`, `job_number`, `coordinator`, `latitude`, `longitude`, `status`, `trucks`, `cabel`, `supervisor`, `supervisor_comments`, `purchase_order`, `expected_revenue`, `actual_revenue`, `is_deleted`) VALUES (4,7,2,'15111994','test','24.320243378346365','76.63893651875003','2','tyese','5444','test','test','45','78','98',1),(5,8,3,'123456','test','23.597390263831926','76.94655370625003','2','trello','trelo','test','test','478','784','564',1),(6,9,2,'test','456857','24.999176572196085','80.06667089375003','3','test','test','test','tested','45','87','60',1),(7,12,2,'789','test','22.627371271021108','75.54030370625003','4','test','test','testing','tested','456','789','132',1),(8,13,2,'Teting','sdfs','24.200049996580397','76.90260839375003','2','','','','','','','',1),(9,15,1,'','','','','1','','','','','','','',1),(10,15,2,'Teting','','','','2','','','','','','','',1);

--
-- Table structure for table `pl_equipment`
--

CREATE TABLE `pl_equipment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `equipment` varchar(255) DEFAULT NULL,
  `tracker` varchar(255) DEFAULT NULL,
  `equipment_usage` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  `is_deleted` int(3) DEFAULT '0' COMMENT '0=no; 1=yes',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_equipment`
--

INSERT INTO `pl_equipment` (`id`, `equipment`, `tracker`, `equipment_usage`, `status`, `message`, `is_deleted`) VALUES (1,'NUETRON','HOURS','210','HQ','300 HR CUTOFF',1),(2,'0124 PICK',NULL,NULL,NULL,NULL,1),(3,'CASING L',NULL,NULL,NULL,NULL,1),(4,'WINNER',NULL,NULL,NULL,NULL,1),(5,'ABC',NULL,NULL,NULL,NULL,1),(6,'TEST',NULL,NULL,NULL,NULL,1),(7,'OXYSIP',NULL,NULL,NULL,NULL,1),(8,'TEST',NULL,NULL,NULL,NULL,1),(9,'ABC',NULL,NULL,NULL,NULL,0),(10,'TEST',NULL,NULL,NULL,NULL,0),(11,'OXYSIP',NULL,NULL,NULL,NULL,0),(12,'WINNER',NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `pl_fields`
--

CREATE TABLE `pl_fields` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` varchar(250) DEFAULT NULL,
  `type` int(3) DEFAULT NULL,
  `multiplevalue` varchar(250) DEFAULT NULL,
  `value_for_progress` int(11) DEFAULT NULL,
  `units` int(11) DEFAULT NULL,
  `css` text,
  `is_deleted` int(3) DEFAULT '0' COMMENT '0= no; 1 = yes',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_fields`
--


--
-- Table structure for table `pl_personneltracker`
--

CREATE TABLE `pl_personneltracker` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `sap` varchar(255) DEFAULT NULL,
  `efficiency` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `days_tracker` varchar(255) DEFAULT NULL,
  `room_no` varchar(255) DEFAULT NULL,
  `cell_phone` varchar(255) DEFAULT NULL,
  `backtoback` varchar(255) DEFAULT NULL,
  `assignment` varchar(255) DEFAULT NULL,
  `manager` varchar(255) DEFAULT NULL,
  `is_deleted` int(3) DEFAULT '0' COMMENT '0=no; 1=yes',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_personneltracker`
--

INSERT INTO `pl_personneltracker` (`id`, `user_id`, `sap`, `efficiency`, `status`, `days_tracker`, `room_no`, `cell_phone`, `backtoback`, `assignment`, `manager`, `is_deleted`) VALUES (1,1,'213','95','on','27','test','','','','',0);

--
-- Table structure for table `pl_subcategory`
--

CREATE TABLE `pl_subcategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) DEFAULT NULL,
  `description` text,
  `is_deleted` int(3) DEFAULT '0' COMMENT '0 = no ; 1 = yes',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_subcategory`
--

INSERT INTO `pl_subcategory` (`id`, `name`, `description`, `is_deleted`) VALUES (1,'Testing','This is the first sub category.\r\nHello\r\nHiii',0),(2,'Sub category 1','Sub category 1\r\nSub category 2',0),(3,'Tested','Tested\r\nTested\r\nTested',0);

--
-- Table structure for table `pl_task`
--

CREATE TABLE `pl_task` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `description` text,
  `assigned_user` varchar(255) DEFAULT NULL,
  `type` int(3) DEFAULT NULL COMMENT '1=urgent; 2=normal',
  `due_date` date DEFAULT NULL,
  `is_deleted` int(3) DEFAULT '0' COMMENT '0=no; 1=yes',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_task`
--

INSERT INTO `pl_task` (`id`, `title`, `description`, `assigned_user`, `type`, `due_date`, `is_deleted`) VALUES (1,'test','test','6',1,'2019-03-28',0),(2,'Test','test','6',2,'2019-04-03',0),(3,'test','test','7',2,'2019-04-08',1),(4,'test','test','9',1,NULL,1),(5,'test','test','7',1,'2019-04-24',0),(6,'house keepig','clean the shop','7',2,'2019-04-12',0);

--
-- Table structure for table `pl_template`
--

CREATE TABLE `pl_template` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) DEFAULT NULL,
  `checklist` varchar(250) DEFAULT NULL,
  `permission` varchar(250) DEFAULT NULL,
  `is_deleted` int(3) DEFAULT '0' COMMENT '1 = yes ; 0 = no',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_template`
--

INSERT INTO `pl_template` (`id`, `name`, `checklist`, `permission`, `is_deleted`) VALUES (3,'Test','1,3',NULL,0),(4,'test_2','2',NULL,0),(5,'perf_temp','3',NULL,0),(6,'sukunj','1',NULL,0),(7,'perforations','4,3',NULL,0),(8,'CORING','2,1,4',NULL,0);

--
-- Table structure for table `pl_user_worktracker`
--

CREATE TABLE `pl_user_worktracker` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `detail` varchar(255) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `is_deleted` int(3) DEFAULT '0' COMMENT '0=no; 1= yes',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_user_worktracker`
--

INSERT INTO `pl_user_worktracker` (`id`, `user_id`, `detail`, `start_date`, `end_date`, `is_deleted`) VALUES (1,7,'test','2019-04-18 04:49:58','2019-04-18 04:50:07',0),(2,7,'testing','2019-04-18 04:50:13',NULL,0);

--
-- Table structure for table `pl_usercertification`
--

CREATE TABLE `pl_usercertification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `certification` varchar(255) DEFAULT NULL,
  `document` varchar(255) DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `is_deleted` int(3) DEFAULT '0' COMMENT '0=no; 1=yes',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_usercertification`
--

INSERT INTO `pl_usercertification` (`id`, `user_id`, `certification`, `document`, `due_date`, `is_deleted`) VALUES (1,1,'test123','12cb39836aa2e73814fde21823d9f570.jpg','2019-03-27',1),(2,1,'testing','2ca1e7c06afa7eff1b793733b47cc728.png','2019-03-28',1),(3,1,'tested','9f4ce3fd92424f292f2283f02b8d84ea.jpg','2019-03-27',1),(4,1,'abc','c5b8bd7c405d9e192ef4ba0cc8e7b2d3.jpg','2019-03-26',1),(5,1,'test','eda3f51fcf35cd79cc386a64739d4f33.jpg','2019-03-20',1),(6,7,'test','69fb2b538bc4339db194fda1c8baa7cb.png','2019-03-27',0),(7,7,'driving','ed4ffbcfdb112c456c77715fc1ea6278.png','2019-04-30',0);

--
-- Table structure for table `pl_vehiclechecklist`
--

CREATE TABLE `pl_vehiclechecklist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dos_id` int(11) DEFAULT NULL,
  `doschecklist_id` int(11) DEFAULT NULL,
  `driver_name` varchar(255) DEFAULT NULL,
  `driver_employee` varchar(255) DEFAULT NULL,
  `dept` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `vehicle_type` varchar(255) DEFAULT NULL,
  `vehicle_equipment_number` varchar(255) DEFAULT NULL,
  `initial_mileage` varchar(255) DEFAULT NULL,
  `final_mileage` varchar(255) DEFAULT NULL,
  `check_seat_belts` int(11) DEFAULT NULL COMMENT '1 = ok; 2 = fail; 3 = not applicable',
  `check_safety_equipment` int(11) DEFAULT NULL,
  `check_windshield_wipers` int(11) DEFAULT NULL,
  `check_glass_mirrors` int(11) DEFAULT NULL,
  `check_horn` int(11) DEFAULT NULL,
  `check_brakes` int(11) DEFAULT NULL,
  `check_parking_brake` int(11) DEFAULT NULL,
  `check_steering` int(11) DEFAULT NULL,
  `check_interior_lights` int(11) DEFAULT NULL,
  `check_air_conditioner` int(11) DEFAULT NULL,
  `check_seatbelts_defects` int(11) DEFAULT NULL,
  `ensure_fuel` int(11) DEFAULT NULL,
  `is_deleted` int(11) DEFAULT '0' COMMENT '0 = no; 1=yes',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pl_vehiclechecklist`
--

INSERT INTO `pl_vehiclechecklist` (`id`, `dos_id`, `doschecklist_id`, `driver_name`, `driver_employee`, `dept`, `date`, `vehicle_type`, `vehicle_equipment_number`, `initial_mileage`, `final_mileage`, `check_seat_belts`, `check_safety_equipment`, `check_windshield_wipers`, `check_glass_mirrors`, `check_horn`, `check_brakes`, `check_parking_brake`, `check_steering`, `check_interior_lights`, `check_air_conditioner`, `check_seatbelts_defects`, `ensure_fuel`, `is_deleted`) VALUES (1,28,24,'test','test','test','2019-02-27','test','test','test','test',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0),(2,29,26,'test','test','test','2019-04-02','','','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);

--
-- Dumping events for database 'perpsol_paperless'
--

--
-- Dumping routines for database 'perpsol_paperless'
--


