﻿if not Exists(SELECT * FROM information_schema.tables where Table_name = 'Campaign')
begin
	create table Campaign
	(
		ID	int primary key identity(1,1),
		Mat_ID	bigint references dbo.matter(ID) not null,
		Title	nvarchar(max),
		CallerIdNum	nvarchar(100),
		FromDate	DateTime not null,
		ToDate	DateTime not null,
		Dom_ID_Status	int references domain (ID) not null,
		ChannelCount	int not null,
		RetryCount	int not null,
		Trunk	nvarchar(200) null,
		Context	nvarchar(200) null,
		Exten	nvarchar(200) null,
		Priority	int not null,
		Dom_ID_IsContext	int references domain (ID) not null, -- کانتکست است یا اپلیکیشن
		[Application]	nvarchar(200) null,
		Data	nvarchar(1000) null,
		Description	nvarchar(1000)
	)
end;
if not Exists(SELECT * FROM information_schema.tables where Table_name = 'CampaignItem')
begin
	create table CampaignItem
	(
		ID	int primary key identity(1,1),
		Campaign_ID	int references Campaign (ID) not null,
		PhoneNumber	nvarchar(20),
		Dom_ID_Status	int references domain (ID) not null,
		Dom_ID_CallResult	int references domain (ID) not null,
		CallDate	DateTime null,
		AnswerDate	DateTime null,
		HangupDate	DateTime null,
		NumberOfAttempts	int not null,

		SystemTitle	nvarchar(max) null,
		UniqueId	nvarchar(64) null
	)
end
