Alter Table [Search] ADD Version Decimal (18,2) CONSTRAINT [DF_Search_Version] Default (0)
GO

Alter Table [Search] ADD AppID int CONSTRAINT [DF_Search_AppID] Default (0)
GO

Alter Table [Search] ADD Source int CONSTRAINT [DF_Search_Source] Default (0)
GO

Alter Table [Search] ADD Author VarChar(255)
GO

Update Search set Version = 0
GO

Update Search set AppID = 0
GO

Update Search set Source = 0
GO

Update DBInfo set DateAndTime='2014-01-11'
GO














