create table Log
(
	srNo int identity(1,1) Primary Key, 
	LogID varchar(10) Not Null,
	logdate datetime Not Null, 
	logtime datetime Not Null, 
	type varchar(50),
	Success int,

	logDD varchar(4) Not Null,
	logMM varchar(4) Not Null,
	logYYYY varchar(6) Not Null,
 	logHH varchar(4) Not Null,
	logNN varchar(4) Not Null, 
	logSS varchar(4) Not Null, 
	logAMPM varchar(4) Not Null,
	machineID varchar(12) Not Null,
	LogSrNo int,
	ExcuseID varchar(50),
	DeptID varchar(15),


)


INSERT INTO LOG VALUES ('1111','06/14/2004','12:05', 'IN' ,1,14,06,2004,12,05,46,'PM',0,0,1, ' ')
