﻿IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Bargeh' AND  COLUMN_NAME = 'Mat_ID')
begin
	alter table Bargeh add Mat_ID	bigint references Matter (ID) not null default -1
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'People' AND  COLUMN_NAME = 'Mat_ID')
begin
	alter table People add Mat_ID	bigint references Matter (ID) not null default -1
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Kala' AND  COLUMN_NAME = 'Mat_ID')
begin
	alter table Kala add Mat_ID	bigint references Matter (ID) not null default -1
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DaryaftPardakht' AND  COLUMN_NAME = 'Mat_ID')
begin
	alter table DaryaftPardakht add Mat_ID	bigint references Matter (ID) not null default -1
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'GardesheChek' AND  COLUMN_NAME = 'Mat_ID')
begin
	alter table GardesheChek add Mat_ID	bigint references Matter (ID) not null default -1
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Karbar' AND  COLUMN_NAME = 'Mat_ID')
begin
	alter table Karbar add Mat_ID	bigint references Matter (ID) not null default -1
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'KalaDarAnbar' AND  COLUMN_NAME = 'Mat_ID')
begin
	alter table KalaDarAnbar add Mat_ID	bigint references Matter (ID) not null default -1
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'ProductDetail' AND  COLUMN_NAME = 'Mat_ID')
begin
	alter table ProductDetail add Mat_ID	bigint references Matter (ID) null
end
;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'RepairDetail' AND  COLUMN_NAME = 'Mat_ID')
begin
	alter table RepairDetail add Mat_ID	bigint references Matter (ID) not null default -1
end
