if not Exists(SELECT * FROM information_schema.tables where Table_name = 'Post') begin create table dbo.Post ( ID int Primary key identity(1,1), Post_ID int references dbo.Post(ID) null, Mat_ID bigint references dbo.matter(ID) not null, Dom_ID_RowType int references dbo.Domain(ID) not null, Pro_ID_Group int references dbo.otherproperties(ID) null, OrginalPic nvarchar(1000) null, MediumPic nvarchar(1000) null, ThumbnailPic nvarchar(1000) null, Name nvarchar(400) null, Title nvarchar(400) null, SubTitle nvarchar(400) null, Tag nvarchar(400) null, Content nvarchar(max), Style nvarchar(max), -- استایل Dom_ID_Status int references dbo.Domain(ID) not null, TarikhSabt int not null, SaatSabt int not null, Kar_ID_Creator int references dbo.karbar(ID) null, ) end ; if not Exists(SELECT * FROM information_schema.tables where Table_name = 'MatterStatistic') begin create table dbo.MatterStatistic ( ID int Primary key identity(1,1), Mat_ID bigint references dbo.matter(ID) not null, Dom_ID_RowType int references dbo.Domain(ID) not null, Value nvarchar(max) null, Quantity int null, Tarikh int null, [Description] nvarchar(max) null, Dom_ID_Status int references dbo.Domain(ID) null, TarikhSabt int not null, SaatSabt int not null, ) end