﻿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