-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Apr 24, 2017 at 06:22 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 `closeoutplans`
-- 

CREATE TABLE `closeoutplans` (
  `cplan_id` int(11) NOT NULL auto_increment,
  `companyID` int(11) NOT NULL,
  `cplan_project_id` int(11) NOT NULL,
  `cplan_sow_id` varchar(11) NOT NULL,
  `cplan_type` varchar(20) NOT NULL,
  `cplan_title` varchar(500) NOT NULL,
  `cplan_no` varchar(50) NOT NULL,
  `cplan_creation_date` varchar(10) NOT NULL,
  `cplan_walkdate` varchar(11) NOT NULL,
  `cplan_walktime` varchar(11) NOT NULL,
  `cplan_status` tinyint(4) NOT NULL default '1',
  `cplan_inputby` varchar(50) NOT NULL,
  `cplan_presented_to` varchar(50) NOT NULL,
  `cplan_presented_toto` varchar(100) NOT NULL,
  `cplan_desc` longtext NOT NULL,
  `cpla_percentage` tinyint(11) NOT NULL,
  `Cplan_Approver` varchar(20) NOT NULL,
  PRIMARY KEY  (`cplan_id`),
  KEY `discipline_company_id` (`companyID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

-- 
-- Dumping data for table `closeoutplans`
-- 

INSERT INTO `closeoutplans` (`cplan_id`, `companyID`, `cplan_project_id`, `cplan_sow_id`, `cplan_type`, `cplan_title`, `cplan_no`, `cplan_creation_date`, `cplan_walkdate`, `cplan_walktime`, `cplan_status`, `cplan_inputby`, `cplan_presented_to`, `cplan_presented_toto`, `cplan_desc`, `cpla_percentage`, `Cplan_Approver`) VALUES 
(1, 3, 1, '12', 'Final Handover', 'sddvc', '14', '2017-04-12', '2017-04-12', '22:00', 1, 'Jignesh', 'dscdcvsd', 'Inserted', 'Description ', 10, 'Team'),
(2, 3, 1, '5', 'Substantial Completi', 'Handover Plan Title', '5', '2017-04-12', '2017-04-12', '17:05', 2, 'Jignesh', 'dscdcvsd', 'Inserted', 'Description', 10, 'Vendor'),
(3, 3, 1, '11', 'Substantial Completi', 'sddvc', '8', '2017-04-12', '2017-04-12', '22:07', 1, 'Jignesh', '', '', 'dcfdv fvg', 0, 'Consultant'),
(4, 3, 1, '5', 'Substantial Completi', 'Title', '5', '2017-04-12', '2017-04-12', '22:00', 2, 'Jignesh', '', '', 'Introduction', 0, 'Vendor'),
(5, 3, 1, '12', 'Final Handover', 'Plan ', '10', '2017-04-18', '2017-04-18', '2017-10-18', 1, 'Jignesh', '', '', 'Introduction', 0, 'Client'),
(6, 3, 1, '5', 'Substantial Completi', 'Plan ', '10', '2017-04-20', '2017-04-20', '2017-04-20', 1, 'Jignesh', '', '', 'Description', 0, 'Consultant'),
(7, 3, 1, '5', 'Partial Handover', 'Plan ', '2', '2017-04-21', '2017-04-21', '2017-04-21', 1, 'Jignesh', '', '', 'Description', 0, 'Client'),
(8, 3, 1, '11', 'Substantial Completi', 'Plan ', '4', '2017-04-21', '2017-04-21', '2017-04-21', 1, 'Jignesh', '', '', 'Description', 0, 'Client'),
(9, 3, 1, '5', 'Substantial Completi', 'Plan ', '3', '2017-04-21', '2017-04-21', '2017-04-21', 1, 'Jignesh', '', '', 'Introduction', 0, 'Consultant'),
(10, 3, 1, '11', 'Substantial Completi', 'Plan ', '4', '2017-04-21', '2017-04-21', '2017-04-21', 1, 'Jignesh', '', '', 'Introduction', 0, 'Consultant'),
(11, 3, 1, '11', 'Substantial Completi', 'Plan ', '5', '2017-04-21', '2017-04-21', '2017-04-21', 1, 'Jignesh', '', '', 'Introduction', 0, 'Consultant'),
(12, 3, 1, '11', 'Final Handover', 'Introduction', '2', '2017-04-21', '2017-04-21', '2017-04-21', 1, 'Jignesh', '', '', 'Introduction', 0, 'Consultant'),
(13, 3, 1, '11', 'Substantial Completi', 'Introduction', '3', '2017-04-21', '2017-04-21', '2017-04-21', 1, 'Jignesh', '', '', 'vIntroduction', 0, 'Client'),
(14, 3, 1, '11', 'Substantial Completi', 'Plan ', '3', '2017-04-21', '2017-04-21', '2017-04-21', 1, 'Jignesh', '', '', 'Introduction', 0, 'Client'),
(15, 3, 38, '11', 'Substantial Completi', 'Plan ', '3', '2017-04-21', '2017-04-21', '2017-04-21', 1, 'Jignesh', '', '', 'Introduction', 0, 'Client');
