if exists(select * from syscolumns where id=object_id('GIS_工程角色管理表') and name='解决方案') BEGIN 

alter table [dbo].[GIS_工程角色管理表] alter column [解决方案] nvarchar(1024) 
 END
GO
if exists(select * from syscolumns where id=object_id('GIS_工程角色管理表') and name='工程名') BEGIN 

alter table [dbo].[GIS_工程角色管理表] alter column [工程名] nvarchar(1024) 
 END
GO
if exists(select * from syscolumns where id=object_id('GIS_工程角色管理表') and name='关联角色') BEGIN 

alter table [dbo].[GIS_工程角色管理表] alter column [关联角色] nvarchar(1024) 
 END
GO
if not exists(select * from syscolumns where id=object_id('PointAddressEntry') and name='点位分组ID') BEGIN 

alter table [dbo].[PointAddressEntry] add [点位分组ID] [int] 
END
GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SCADA_SensorRealTimeTemp]') AND type in (N'U'))
 BEGIN
 CREATE TABLE [dbo].[SCADA_SensorRealTimeTemp](
 [SensorID] varchar(50) NOT NULL ,
 [PV] [float] NOT NULL ,
 [PT] [datetime] NOT NULL ,
 [Date] varchar(50)  
 ) ON [PRIMARY]
 END
 GO
if not exists(select * from syscolumns where id=object_id('SCADA_SensorRealTimeTemp') and name='SensorID') BEGIN 

alter table [dbo].[SCADA_SensorRealTimeTemp] add [SensorID] varchar(50) 
END
GO
if not exists(select * from syscolumns where id=object_id('SCADA_SensorRealTimeTemp') and name='PV') BEGIN 

alter table [dbo].[SCADA_SensorRealTimeTemp] add [PV] [float] 
END
GO
if not exists(select * from syscolumns where id=object_id('SCADA_SensorRealTimeTemp') and name='PT') BEGIN 

alter table [dbo].[SCADA_SensorRealTimeTemp] add [PT] [datetime] 
END
GO
if not exists(select * from syscolumns where id=object_id('SCADA_SensorRealTimeTemp') and name='Date') BEGIN 

alter table [dbo].[SCADA_SensorRealTimeTemp] add [Date] varchar(50) 
END
GO

IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[配置_点表分组配置表]') AND type in (N'U'))
 BEGIN
 CREATE TABLE [dbo].[配置_点表分组配置表](
 [ID] [int] IDENTITY(1,1)NOT NULL ,
 [分组名称] varchar(50)  ,
 [分组排序] [int]  ,
 [分组说明] varchar(200)  
 ) ON [PRIMARY]
 END
 GO
if not exists(select * from syscolumns where id=object_id('配置_点表分组配置表') and name='ID') BEGIN 

alter table [dbo].[配置_点表分组配置表] add [ID] [int] 
END
GO
if not exists(select * from syscolumns where id=object_id('配置_点表分组配置表') and name='分组名称') BEGIN 

alter table [dbo].[配置_点表分组配置表] add [分组名称] varchar(50) 
END
GO
if not exists(select * from syscolumns where id=object_id('配置_点表分组配置表') and name='分组排序') BEGIN 

alter table [dbo].[配置_点表分组配置表] add [分组排序] [int] 
END
GO
if not exists(select * from syscolumns where id=object_id('配置_点表分组配置表') and name='分组说明') BEGIN 

alter table [dbo].[配置_点表分组配置表] add [分组说明] varchar(200) 
END
GO
if exists(select * from syscolumns where id=object_id('配置_视频信息表') and name='刻录机名称') BEGIN 

alter table [dbo].[配置_视频信息表] alter column [刻录机名称] varchar(200) 
 END
GO
if not exists(select * from syscolumns where id=object_id('配置_视频信息表') and name='默认通道') BEGIN 

alter table [dbo].[配置_视频信息表] add [默认通道] varchar(200) 
END
GO
if exists(select * from syscolumns where id=object_id('配置_视频信息表') and name='播放方式') BEGIN 

alter table [dbo].[配置_视频信息表] alter column [播放方式] varchar(255) 
 END
GO
if not exists(select * from syscolumns where id=object_id('设备_巡维保计划表') and name='是否删除') BEGIN 

alter table [dbo].[设备_巡维保计划表] add [是否删除] [int] 
END
GO
if not exists(select * from syscolumns where id=object_id('设备_巡维保任务表') and name='是否删除') BEGIN 

alter table [dbo].[设备_巡维保任务表] add [是否删除] [int] 
END
GO
if exists(select * from syscolumns where id=object_id('数据_实时_水厂') and name='站点在线状态') BEGIN 

alter table [dbo].[数据_实时_水厂] alter column [站点在线状态] [real] 
 END
GO
if exists(select * from syscolumns where id=object_id('数据_实时_水源井') and name='站点在线状态') BEGIN 

alter table [dbo].[数据_实时_水源井] alter column [站点在线状态] [real] 
 END
GO