Alter Table [Course] ADD LessonMinute int CONSTRAINT [DF_Course_LessonMinute] Default (0)
GO

Alter Table [Class] ADD LastArrangeDate datetime
GO

Alter Table [StuClass] ADD ExpiryDate datetime
GO

Alter Table [Storeroom] ADD Sell int CONSTRAINT [DF_Storeroom_Sell] Default (0)
GO

Update Course set LessonMinute = 0
GO

Update Class set LastArrangeDate = EndDate
GO

Update Storeroom set Sell = 1
GO

Update DBInfo set DateAndTime='2014-06-06'
GO














