

ALTER TABLE LessonTime ADD COLUMN ExeAbsent int default 0
GO

ALTER TABLE StuClass ADD COLUMN LastSelectDate datetime
GO

ALTER TABLE wx_Remind ADD COLUMN firstDATA memo
GO

ALTER TABLE wx_Remind ADD COLUMN remarkDATA memo
GO

Update LessonTime set ExeAbsent = 0 where ExeAbsent is null
GO

CREATE TABLE [AsynUpdate](
[DataType] Int   NULL ,
[KeyID] Int   NULL ,
[Action] Int   NULL ,
[DateAndTime] DateTime   NULL ,
[UserID] Int   NULL ,
[UpdateCount] Int   NULL DEFAULT 0,
[Errors] Int   NULL DEFAULT 0,
primary  key(DataType,KeyID))
GO

Update DBInfo set VersionID = '5.0', DateAndTime='2019-05-31'
GO