-- phpMyAdmin SQL Dump
-- version 2.6.1-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost:3306
-- Generation Time: Apr 21, 2014 at 01:30 PM
-- Server version: 4.1.10
-- PHP Version: 4.3.10
-- 
-- Database: `ctecomco_prepl`
-- 

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

-- 
-- Table structure for table `p_jhsmast`
-- 

CREATE TABLE `p_jhsmast` (
  `jhssno` int(11) NOT NULL auto_increment,
  `jhsyear` int(4) NOT NULL default '0',
  `jhsmon` int(2) NOT NULL default '0',
  `jhsempsno` int(11) NOT NULL default '0',
  `jhsjobsno` int(11) NOT NULL default '0',
  `jhsjobcost` double(12,2) NOT NULL default '0.00',
  `jhsempmm` int(11) NOT NULL default '0',
  `jhsjobmm` int(11) NOT NULL default '0',
  `jhsucdnew` varchar(20) NOT NULL default '',
  `jhsentddt` date NOT NULL default '0000-00-00',
  `jhsenttime` time NOT NULL default '00:00:00',
  `jhsucdame` varchar(20) NOT NULL default '',
  `jhsameddt` date NOT NULL default '0000-00-00',
  `jhsametime` time NOT NULL default '00:00:00',
  PRIMARY KEY  (`jhsyear`,`jhsmon`,`jhsempsno`,`jhsjobsno`),
  UNIQUE KEY `jhssno` (`jhssno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1268 ;