-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Apr 24, 2017 at 06:09 AM
-- Server version: 5.0.41
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `safeaccidents`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `handover_plan_detail`
-- 

CREATE TABLE `handover_plan_detail` (
  `handover_plan_id` int(11) NOT NULL auto_increment,
  `detail_cplan_id` int(11) NOT NULL,
  `detail_completion` varchar(4) NOT NULL,
  `detail_type` varchar(20) NOT NULL,
  `detail_location_id` int(11) NOT NULL,
  `detail_gwb_id` int(11) NOT NULL,
  `detail_mwbs_id` int(11) NOT NULL,
  `detail_wbs_id1` int(11) NOT NULL,
  `detail_wbs_id2` int(11) NOT NULL,
  `detail_item_id` int(11) NOT NULL,
  `detail_sub_item_id` int(11) NOT NULL,
  `detail_dwg_id` int(11) NOT NULL,
  `detail_dwg_name_location_id` int(11) NOT NULL,
  `detail_specs_id` int(11) NOT NULL,
  `detail_description` text NOT NULL,
  `detail_date` date NOT NULL,
  `detail_company_id` int(11) NOT NULL,
  `detail_status` int(11) NOT NULL,
  `detail_prepared_by` varchar(30) NOT NULL,
  PRIMARY KEY  (`handover_plan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

-- 
-- Dumping data for table `handover_plan_detail`
-- 

INSERT INTO `handover_plan_detail` (`handover_plan_id`, `detail_cplan_id`, `detail_completion`, `detail_type`, `detail_location_id`, `detail_gwb_id`, `detail_mwbs_id`, `detail_wbs_id1`, `detail_wbs_id2`, `detail_item_id`, `detail_sub_item_id`, `detail_dwg_id`, `detail_dwg_name_location_id`, `detail_specs_id`, `detail_description`, `detail_date`, `detail_company_id`, `detail_status`, `detail_prepared_by`) VALUES 
(7, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '2017-04-22', 3, 2, 'Jignesh'),
(8, 0, '20', 'Exclusions', 2, 21, 12, 18, 29, 70, 258, 12, 2, 1, 'Description', '2017-04-22', 3, 1, 'Jignesh'),
(9, 5, '25', 'Exclusions', 2, 21, 12, 18, 29, 72, 270, 13, 1, 5, 'Description', '2017-04-22', 3, 1, 'Jignesh'),
(10, 1, '25', 'Inclusions', 0, 21, 12, 18, 29, 70, 257, 0, 0, 0, 'Description', '2017-04-22', 3, 1, 'Jignesh');
