IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Bargeh' AND  COLUMN_NAME = 'FC_ID')
begin
	alter table Bargeh Add FC_ID int References Finance_Cycle (ID) not null Default -1
end
go
IF not EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DaryaftPardakht' AND  COLUMN_NAME = 'FC_ID')
begin
	alter table DaryaftPardakht Add FC_ID int References Finance_Cycle (ID) not null Default -1
end
go
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Bargeh' AND  COLUMN_NAME = 'Pro_ID_VahedMali')
begin
	alter table Bargeh Add Pro_ID_VahedMali int References OtherProperties (ID) not null Default -1
end
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'DaryaftPardakht' AND  COLUMN_NAME = 'Pro_ID_VahedMali')
begin
	alter table DaryaftPardakht Add Pro_ID_VahedMali int References OtherProperties (ID) not null Default -1
end
go
IF not EXISTS(SELECT ID FROM Finance_Cycle WHERE ID = 26)
begin
	insert into Finance_Cycle(ID,Code,Title,TarikhAz,TarikhEla,Serial,Is_Current,Is_Close)
	values(26,1395,'سال مالی 1395',13950101,13951230,95,0,0)
end
go
IF not EXISTS(SELECT ID FROM Finance_Cycle WHERE ID = 27)
begin
	insert into Finance_Cycle(ID,Code,Title,TarikhAz,TarikhEla,Serial,Is_Current,Is_Close)
	values(27,1396,'سال مالی 1396',13960101,13961229,96,0,0)
end
go
IF not EXISTS(SELECT ID FROM Finance_Cycle WHERE ID = 28)
begin
	insert into Finance_Cycle(ID,Code,Title,TarikhAz,TarikhEla,Serial,Is_Current,Is_Close)
	values(28,1397,'سال مالی 1397',13970101,13971229,97,0,0)
end
go
IF not EXISTS(SELECT ID FROM Finance_Cycle WHERE ID = 29)
begin
	insert into Finance_Cycle(ID,Code,Title,TarikhAz,TarikhEla,Serial,Is_Current,Is_Close)
	values(29,1398,'سال مالی 1398',13980101,13981229,98,0,0)
end
go
IF not EXISTS(SELECT ID FROM Finance_Cycle WHERE ID = 30)
begin
	insert into Finance_Cycle(ID,Code,Title,TarikhAz,TarikhEla,Serial,Is_Current,Is_Close)
	values(30,1399,'سال مالی 1399',13990101,13991230,99,0,0)
end
IF not EXISTS(SELECT ID FROM Finance_Cycle WHERE ID = 31)
begin
	insert into Finance_Cycle(ID,Code,Title,TarikhAz,TarikhEla,Serial,Is_Current,Is_Close)
	values(31,1400,'سال مالی 1400',14000101,14001229,00,0,0)
end