if Exists(SELECT * FROM information_schema.tables where Table_name = 'GroohAccountMali')
begin
	print 'true'
end
else
begin
create table GroohAccountMali
(
	ID	int primary key,
	Code	nvarchar(30),
	Title	nvarchar(200),
	Dom_ID_Noe		int references Domain (ID) not null,
	CodeKarbar	int references Karbar(Code) not null,
	TarikhSabt	int not null,
	SaatSabt	smallint not null
)
end
go
if Exists(SELECT * FROM information_schema.tables where Table_name = 'GroohAccountItem')
begin
	print 'true'
end
else
begin
create table GroohAccountItem
(
	ID	int primary key,
	Code	nvarchar(30),
	Title	nvarchar(200),
	Dom_ID_Level		int references Domain (ID) not null,
	Description nvarchar(300),
	CodeKarbar	int references Karbar(Code) not null,
	TarikhSabt	int not null,
	SaatSabt	smallint not null
)
end
go
if Exists(SELECT * FROM information_schema.tables where Table_name = 'AccountItem')
begin
	print 'true'
end
else
begin
create table AccountItem
(
	ID	int primary key,
	Code	nvarchar(30),
	Title	nvarchar(200),
	Gro_Hesab_ID	int references GroohAccountMali(ID),
	Gro_AI_ID		int references GroohAccountItem (ID),
	Dom_ID_Level		int references Domain (ID) not null,
	Dom_ID_Type		int references Domain (ID), -- کل/معین/شناسایی/...؛
	Dom_ID_Status	int references Domain (ID),
	--AI_ID	int references AccountItem(ID),
	Value	nvarchar(300),
	Priority int,
	Description nvarchar(300),
	CodeKarbar	int references Karbar(Code) not null,
	TarikhSabt	int not null,
	SaatSabt	smallint not null
)
end
go
if Exists(SELECT * FROM information_schema.tables where Table_name = 'AccountDependency')
begin
	print 'true'
end
else
begin
create table AccountDependency
(
	ID	int primary key,
	AD_ID int references AccountDependency (ID),
	AI_ID_Base	int references AccountItem(ID) not null,
	AI_ID	int references AccountItem(ID),
	Gro_ID	int references GroohAccountItem(ID),
	Dom_ID_Level	int references Domain (ID) not null,
	Dom_ID_Type	int references Domain (ID) not null,
	Dom_ID_Status	int references Domain (ID) not null,
	Description		nvarchar(300),
	CodeKarbar		int references Karbar(Code) not null,
	TarikhSabt	int not null,
	SaatSabt	smallint not null
)

end
go

AddDomains 446,47,'متفرقه','None',9,'',1
go

AddDomains 447,null,'نوع سطوح حساب','NoeAccountItem',0,'',1
go
AddDomains 448,447,'کل','Kol',1,'',1
go
AddDomains 449,447,'معین','Moin',2,'',1
go
AddDomains 450,447,'تفصیلی1','Tafsili1',3,'',1
go
AddDomains 451,447,'تفصیلی2','Tafsili2',4,'',1
go
AddDomains 452,447,'تفصیلی3','Tafsili3',5,'',1
go
AddDomains 453,447,'تفصیلی4','Tafsili4',6,'',1
go


AddDomains 454,null,'وضعیت','NoeVaziat',0,'',1
go
AddDomains 455,454,'فعال','Active',1,'',1
go
AddDomains 456,454,'غیرفعال','DeActive',2,'',1
go


AddDomains 457,null,'نوع ارتباط','NoeRelation',0,'',1
go
AddDomains 458,457,'کد','Code',1,'',1
go
AddDomains 459,457,'جدول','Table',1,'',1
go