IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Mahdoodiat' AND  COLUMN_NAME = 'ID')
begin
	select * into tm from Mahdoodiat;
	drop table Mahdoodiat;
end
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Mahdoodiat' AND  COLUMN_NAME = 'ID')
begin
	create table dbo.Mahdoodiat
	(
		ID	int primary key identity(1,1),
		Kar_ID	int references Karbar(ID) not null,
		Amaliat_ID	int references AmaliateSystem(ID) not null,
		IsAllowed	bit not null
	);
	insert into Mahdoodiat select Kar_ID,Amaliat_ID,IsAllowed from tm;
end;
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'BarCode' AND  COLUMN_NAME = 'ID')
	select * into tb from BarCode;
	drop table BarCode;
begin
end
IF not EXISTS( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'BarCode' AND  COLUMN_NAME = 'ID')
begin
	create table dbo.BarCode
	(
		ID	int primary key identity(1,1),
		Kal_ID	int references Kala(ID) not null,
		Code	nvarchar(100) not null
	);
	insert into BarCode select CodeKala,Code from tb;
end