ALTER TABLE Potential ADD COLUMN ImportBatchID int
GO

ALTER TABLE Student ADD COLUMN ImportBatchID int
GO

ALTER TABLE Bill ADD AutoPaymentID int
GO

CREATE TABLE [ImportLog](
[ImportBatchID]   COUNTER PRIMARY KEY  ,
[FileName] VarChar (100)  NULL ,
[FileSize] Int   NULL ,
[Rows] Int   NULL ,
[DataType] Int   NULL DEFAULT 0,
[DateAndTime] DateTime   NULL ,
[State] Int   NULL DEFAULT 1,
[UserID] Int   NULL ,
[TrueName] VarChar (50)  NULL)
GO

Update DBInfo set VersionID = '3.0', DateAndTime='2016-04-18'
GO









