CREATE TABLE [dbo].[Update](
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [Message] [ntext] NULL,
    [IsComplete] [bit] NOT NULL,
    [ServerId] [int] NOT NULL,
    [Version] [nvarchar](150) NOT NULL,
    [PublishDate] [nvarchar](50) NOT NULL,
    [ChangelogUrl] [nvarchar](1000) NOT NULL,
    [Description] [nvarchar](2048) NOT NULL,
    [IsDisplayed] [bit] NOT NULL,
CONSTRAINT [PK__Update__3214EC07341759A5] PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

ALTER TABLE dbo.Server ADD UpdateMode varchar(255) NULL
GO

ALTER TABLE dbo.Server ADD CONSTRAINT
	Server_PRIMARY PRIMARY KEY CLUSTERED
	(
	ServerId
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]


BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_Server
	(
	ServerId int NOT NULL IDENTITY (1, 1),
	Name varchar(50) NOT NULL,
	UserName varchar(50) NOT NULL,
	Password nvarchar(512) NOT NULL,
	Host varchar(50) NOT NULL,
	ComputerName varchar(255) NULL,
	OperatingSystem varchar(255) NULL,
	Processor varchar(255) NULL,
	VhostPath varchar(255) NULL,
	Is64BitOperatingSystem bit NULL,
	MemorySize bigint NULL,
	ServerStatus int NULL,
	LicenseName nvarchar(1024) NULL,
	LicenseExpireDate datetime2(7) NULL,
	PrivateKey varchar(255) NULL,
	Version varchar(50) NULL,
	BackupPath varchar(1024) NULL,
	SharedFolderUser varchar(50) NULL,
	SharedFolderPassword varchar(255) NULL,
	UpdateMode varchar(255) NULL
	)  ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_Server SET (LOCK_ESCALATION = TABLE)
GO
SET IDENTITY_INSERT dbo.Tmp_Server ON
GO
IF EXISTS(SELECT * FROM dbo.Server)
	 EXEC('INSERT INTO dbo.Tmp_Server (ServerId, Name, UserName, Password, Host, ComputerName, OperatingSystem, Processor, VhostPath, Is64BitOperatingSystem, MemorySize, ServerStatus, LicenseName, LicenseExpireDate, PrivateKey, Version, BackupPath, SharedFolderUser, SharedFolderPassword, UpdateMode)
		SELECT ServerId, Name, UserName, Password, Host, ComputerName, OperatingSystem, Processor, VhostPath, Is64BitOperatingSystem, MemorySize, CONVERT(int, ServerStatus), LicenseName, LicenseExpireDate, PrivateKey, Version, BackupPath, SharedFolderUser, SharedFolderPassword, UpdateMode FROM dbo.Server WITH (HOLDLOCK TABLOCKX)')
GO
SET IDENTITY_INSERT dbo.Tmp_Server OFF
GO
DROP TABLE dbo.Server
GO
EXECUTE sp_rename N'dbo.Tmp_Server', N'Server', 'OBJECT'
GO
ALTER TABLE dbo.Server ADD CONSTRAINT
	Server_PRIMARY PRIMARY KEY CLUSTERED
	(
	ServerId
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO
COMMIT


ALTER TABLE dbo.[Update] ADD
	CompleteDate datetime2(7) NULL
GO