Alter Table [Sending] ADD App Int CONSTRAINT [DF_Sending_App]  DEFAULT (0)
GO

Alter Table [SmsReceive] ADD App Int CONSTRAINT [DF_SmsReceive_App]  DEFAULT (0)
GO

Alter Table [Student] ADD LastAppLoginTime DateTime
GO

Update Sending set App=0
GO

Update SmsReceive set App=0
GO

CREATE TABLE [dbo].[EvalTeacher](
[EvalTeacherID] [Int]  IDENTITY(1,1) NOT NULL ,
[TeacherID] [Int]   NULL ,
[TeacherName] [NVarChar] (255)  NULL ,
[Level] [Int]   NULL ,
[Content] [NVarChar] (255)  NULL ,
[DateAndTime] [DateTime]   NULL CONSTRAINT [DF_EvalTeacher_DateAndTime]  DEFAULT (getdate()),
[Teach] [Int]   NULL CONSTRAINT [DF_EvalTeacher_Teach]  DEFAULT (0),
[StudentID] [Int]   NULL ,
[StudentName] [NVarChar] (255)  NULL ,

CONSTRAINT [PK_EvalTeacher] PRIMARY KEY CLUSTERED 
(
	[EvalTeacherID] ASC
))
GO

Update DBInfo set DateAndTime='2014-07-02'
GO














