﻿if not Exists(SELECT * FROM information_schema.tables where Table_name = 'Page')
begin
	Create Table dbo.Page
	(
		ID	int Primary key,
		Mat_ID	bigint references dbo.Matter(ID) null,
		Dom_ID_RowType	int references dbo.Domain(ID) not null,
		Page_ID	int references dbo.Page(ID) null,
		Code	int null,
		Title	nvarchar(400) null,
		SubTitle	nvarchar(2000) null,
		Name	nvarchar(400) null,
		Head	nvarchar(max) null,
		Body	nvarchar(max) null,
		Style	nvarchar(max) null,
		Url	nvarchar(1999) null,
		PictureUrl	nvarchar(1999) null,
		Thumbnail	nvarchar(1999) null,
		Amount	float null,
		Price	decimal(19,4) null,
		[Percent]	float null,
		Priority	int null,
		Tarikh	int null,
		Saat	int null,
		Duration	int null,
		FromDate	int null,
		ToDate	int null,
		Dom_ID	int references dbo.Domain(ID) null,
		Dom_ID_Status	int references dbo.Domain(ID) null,
		Value	nvarchar(max) null,
		[Description]	nvarchar(max) null,
		SystemTitle	nvarchar(max) null,
		Icon	nvarchar(500) null,
		Cta	nvarchar(500) null,
		Tag	nvarchar(max) null
	)
end