-----------------------20151118诊断--------------------------------------------------
if exists(select * from syscolumns where object_id('LAB1')=id and name='LAB18' and length= 128)
alter table LAB1 alter column LAB18 varchar(256)
go
if exists(select * from syscolumns where object_id('LAB2')=id and name='LAB18' and length= 128)
alter table LAB2 alter column LAB18 varchar(256)
go
if exists(select * from syscolumns where object_id('VBL1')=id and name='VBL02' and length= 20)
alter table VBL1 alter column VBL02 varchar(30)
go
if exists(select * from syscolumns where object_id('VBL2')=id and name='VBL02' and length= 20)
alter table VBL2 alter column VBL02 varchar(30)
go
-----------------------20171208--------------------------------------------------
if not exists(select * from syscolumns where id=object_id('LAA1_2') and name='BCE01A')
alter table LAA1_2 add BCE01A int
go
if not exists(select * from syscolumns where id=OBJECT_ID('LAA1_2') and name='BCE01D')
alter table LAA1_2 add BCE01D int
go
if not exists(select * from syscolumns where id=OBJECT_ID('LAA1_2') and name='BCE03D')
alter table LAA1_2 add BCE03D varchar(20)
go
if not exists(select * from syscolumns where id=OBJECT_ID('LAA1_2') and name='LAA48')
alter table LAA1_2 add LAA48 datetime
go
if not exists(select * from syscolumns where id=OBJECT_ID('LAA1_2') and name='BCE01E')
alter table LAA1_2 add BCE01E int
go
if not exists(select * from syscolumns where id=OBJECT_ID('LAA1_2') and name='BCE03E')
alter table LAA1_2 add BCE03E varchar(20)
go
if not exists(select * from syscolumns where id=OBJECT_ID('LAA1_2') and name='LAA51')
alter table LAA1_2 add LAA51 datetime
go

--dev
if exists(select * from syscolumns where id = object_id('VBI2_dev') and name = 'VBI35' and xtype = 56)
begin
  declare @DefName varchar(255)
  set @DefName = (select object_name(cdefault) from syscolumns where id = object_id('VBI2_dev') and name = 'VBI35')
  if @DefName is not null
    exec ('ALTER TABLE VBI2_dev drop CONSTRAINT ' + @DefName)

  alter table VBI2_dev alter column VBI35 numeric(18,4)

  if @DefName is not null
    exec ('ALTER TABLE VBI2_dev add CONSTRAINT ' + @DefName + ' DEFAULT (0) FOR VBI35')
end
go
if exists(select * from syscolumns where object_id('FAF2')=id and name='FAF18' and length= 32)
alter table FAF2 alter column FAF18 varchar(64)
go

if not exists(select * from syscolumns where name = 'FAF41' and object_Name(id)='FAF2')
begin
Alter table FAF2
Add FAF41 tinyint default(0) with values
end
go

if not exists(select * from syscolumns where name = 'CBM28' and object_Name(id)='CBM2_dev')
begin
  alter table CBM2_dev add CBM28 varchar(64) --代办人姓名
  alter table CBM2_dev add CBM29 varchar(20) --代办人身份证号
end
go
if not exists(select * from syscolumns where name = 'CBM30' and object_Name(id)='CBM2_dev')
alter table CBM2_dev add CBM30 datetime
go
if not exists(select * from syscolumns where name = 'Crypt' and object_Name(id)='VAF2_dev')
  alter table VAF2_dev add Crypt tinyint default(0) with values
go
if not exists(select * from syscolumns where name = 'VAJ72' and object_Name(id)='VAJ2_dev')  
  alter table VAJ2_dev add VAJ72 tinyint default(0)
go
if not exists(select * from syscolumns where name = 'VBQ36' and object_Name(id)='VBQ2_dev')
 alter table VBQ2_dev add VBQ36 datetime
if not exists(select * from syscolumns where name = 'VBQ37' and object_Name(id)='VBQ2_dev') 
 alter table VBQ2_dev add VBQ37 datetime  
go
alter table VBU3 alter column VCB04 varchar(64)
alter table VCA1 alter column VCB04 varchar(64)
alter table VCA3 alter column VCB04 varchar(64)
GO
if not exists(select * from syscolumns where name = 'VCJ41' and object_Name(id)='VCJ1')
  alter table VCJ1 add VCJ41 varchar(64) --平台预约挂号编号
go  
if not exists(select * from syscolumns where name = 'VCJ42' and object_Name(id)='VCJ1')
  alter table VCJ1 add VCJ42 varchar(20) --平台预约取号密码
go