CREATE TABLE [dbo].[SmsReceive](
[SMSID] [Int]  IDENTITY(1,1) NOT NULL ,
[Mobile] [NVarChar] (50)  NULL ,
[Msg] [NVarChar] (4000)  NULL ,
[RepTime] [DateTime]   NULL ,
[ClientID] [Int]   NULL CONSTRAINT [DF_SmsReceive_ClientID]  DEFAULT (0),
[ClientName] [NVarChar] (50)  NULL ,
[UserID] [Int]   NULL CONSTRAINT [DF_SmsReceive_UserID]  DEFAULT (0),
[IsRead] [Int]   NULL CONSTRAINT [DF_SmsReceive_IsRead]  DEFAULT (0),

CONSTRAINT [PK_SmsReceive] PRIMARY KEY CLUSTERED 
(
	[SMSID] ASC
))
GO

Alter Table [BillItem] ADD [Favorable] [Money] NULL CONSTRAINT [DF_BillItem_Favorable]  DEFAULT (0)
GO

Update BillItem set Favorable = 0 where Favorable is null
GO

Update DBInfo set DateAndTime='2012-01-08'
GO
