CREATE NONCLUSTERED INDEX [a_id_c_date] ON [dbo].[t_A_Contact]
(
	[s_id] ASC
)
INCLUDE ( 	[a_id],
	[c_date]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
GO


CREATE NONCLUSTERED INDEX [ContactFields] ON [dbo].[t_A_Contact]
(
	[ct_id] ASC,
	[c_date] ASC
)
INCLUDE ( 	[c_id],
	[a_id],
	[u_id],
	[s_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [ContactMail] ON [dbo].[t_A_Contact]
(
	[m_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [ContactTTID_Date] ON [dbo].[t_A_Contact]
(
	[tt_id] ASC,
	[c_date] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [ContactUID_Date] ON [dbo].[t_A_Contact]
(
	[u_id] ASC,
	[c_date] ASC
)
INCLUDE ( 	[c_time1],
	[c_time2]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
GO

ALTER TABLE [dbo].[t_A_Contact] ADD  CONSTRAINT [PK__t_A_Cont__213EE77462C8CD8D] PRIMARY KEY CLUSTERED 
(
	[c_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [t_A_Contact_CTID_SID] ON [dbo].[t_A_Contact]
(
	[ct_id] ASC,
	[s_id] ASC
)
INCLUDE ( 	[c_id],
	[a_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [t_A_Contact_Index] ON [dbo].[t_A_Contact]
(
	[a_id] ASC
)
INCLUDE ( 	[c_date],
	[c_nextDate],
	[c_description]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [taskCompleted] ON [dbo].[t_A_Contact]
(
	[c_taskCompleted] ASC
)
INCLUDE ( 	[a_id],
	[tt_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [v_a_agentCParent] ON [dbo].[t_A_Contact]
(
	[c_parent] ASC
)
INCLUDE ( 	[c_id]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 100) ON [PRIMARY]
GO

create table t_A_TaskType
	(
		tt_id int identity(1, 1) primary key,
		i_id_source int,
		s_id int,
		tt_order int,
		i_id_source2 int,
		i_id_grouping int
	)

	create table t_A_Agent
	(
		a_id int identity(1, 1) primary key,
		i_id_source int,
		s_id int,
		u_id int,
		t_id_calltask int
	)

	create table t_A_Contact
	(
		c_id int identity(1, 1) primary key,
		a_id int, 
		c_taskCompleted int
	)