create table Fingerprints
(
	ID 		varchar(50) primary key,
	fingerprint10N 	varchar(4000),
	MachineID	varchar(15),
	DeptID		varchar(15),
	Finger1		varchar(50),
	Finger2		varchar(50),
	LastUpdatetime	DATEtime,
	status		integer DEFAULT -1,
	IsAdmin		integer DEFAULT -1,
	SearchChar	varchar(3),
	DateTimeStamp	Datetime,
	Disabled	integer DEFAULT -1,
	Name		varchar(40)		,
	BranchCode	varchar(50),
	ExpiryDate	DATEtime,
	IsMember	integer DEFAULT -1,
	PIN		varchar(5),
	IsPIN		integer DEFAULT -1,
	
)

Insert into Fingerprints
(
	id,
	fingerprint10n,
	machineid,
	deptid,
	finger1,
	finger2,
	lastupdatetime,
	status,
	isadmin,
	searchchar,
	datetimestamp,
	disabled,
	name,
	branchcode ,
	expirydate,
	ismember,
	pin,
	ispin 
)  
values
(
	'1001',
	 'h', 
	'1556',
	'5', 'h'
	,'h'
	,
	 '08/19/2004',
	-1,
	-1,
	'ABC', 
	'01/01/2001',
	-1,
	'PP',
	'40',
	'01/01/2004',
	-1,
	'41028',
	-1
)	  


