﻿IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'License' AND  COLUMN_NAME = 'InternalClientIPServer')
begin
alter table dbo.License add InternalClientIPServer	nvarchar(200) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'License' AND  COLUMN_NAME = 'InternalClientServerName')
begin
alter table dbo.License add InternalClientServerName	nvarchar(400) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'License' AND  COLUMN_NAME = 'InternalClientDababaseName')
begin
alter table dbo.License add InternalClientDababaseName	nvarchar(400) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'License' AND  COLUMN_NAME = 'InternalClientUserName')
begin
alter table dbo.License add InternalClientUserName	nvarchar(400) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'License' AND  COLUMN_NAME = 'InternalClientPassword')
begin
alter table dbo.License add InternalClientPassword	nvarchar(400) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'License' AND  COLUMN_NAME = 'ExternalClientIPServer')
begin
alter table dbo.License add ExternalClientIPServer	nvarchar(200) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'License' AND  COLUMN_NAME = 'ExternalClientServerName')
begin
alter table dbo.License add ExternalClientServerName	nvarchar(400) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'License' AND  COLUMN_NAME = 'ExternalClientDababaseName')
begin
alter table dbo.License add ExternalClientDababaseName	nvarchar(400) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'License' AND  COLUMN_NAME = 'ExternalClientUserName')
begin
alter table dbo.License add ExternalClientUserName	nvarchar(400) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'License' AND  COLUMN_NAME = 'ExternalClientPassword')
begin
alter table dbo.License add ExternalClientPassword	nvarchar(400) null
end