CREATE TABLE [dbo].[Finger](
[FingerID] [Int]   NOT NULL ,
[FingerCode] [VarChar] (4000)  NULL ,
[Action] [Int]   NULL ,
[DateAndTime] [DateTime]   NULL ,

CONSTRAINT [PK_Finger] PRIMARY KEY CLUSTERED 
(
	[FingerID] ASC
))
GO

ALTER TABLE Student ADD FingerState int
GO

ALTER TABLE Student ADD FingerCode VarChar(4000)
GO

ALTER TABLE Users ADD FingerState int
GO

ALTER TABLE Users ADD FingerCode VarChar(4000)
GO

update Student set FingerState = 1,FingerCode = ''
GO

update Users set FingerState = 1,FingerCode = ''
GO

ALTER TABLE DBInfo ADD LastFingerDate datetime
GO

Update DBInfo set DateAndTime='2011-09-22',LastFingerDate='2011-09-22'
GO