if not exists(select * from syscolumns where name = 'FAC05' and object_Name(id)='FAC1')
begin
  Alter table FAC1
  Add FAC05 varchar(64)
end
go

if not exists(select * from syscolumns where name = 'FAC05' and object_Name(id)='FAC2')
begin
  Alter table FAC2
  Add FAC05 varchar(64)
end
go

if not exists(select * from syscolumns where name = 'VAC74' and object_Name(id)='VAC1')
begin
Alter table VAC1
Add VAC74 varchar(20)
end
go

if not exists(select * from syscolumns where name = 'VAC75' and object_Name(id)='VAC1')
begin
Alter table VAC1
Add VAC75 varchar(64)
end
go

if not exists(select * from syscolumns where name = 'VAC76' and object_Name(id)='VAC1')
begin
Alter table VAC1
Add VAC76 varchar(1)
end
go

if not exists(select * from syscolumns where name = 'VAC77' and object_Name(id)='VAC1')
begin
Alter table VAC1
Add VAC77 varchar(20)
end
go

if not exists(select * from syscolumns where name = 'VAC78' and object_Name(id)='VAC1')
begin
Alter table VAC1
Add VAC78 datetime
end
go


if not exists(select * from syscolumns where name = 'FAF40' and object_Name(id)='FAF1')
Alter table FAF1
Add FAF40 tinyint default(0) with values
GO