if not exists(select * from sys.indexes i where i.name = 'IX_T_INTEGRATION_MESSAGE_LOG_LoggedAt')
CREATE NONCLUSTERED INDEX [IX_T_INTEGRATION_MESSAGE_LOG_LoggedAt] ON [ISZL].[T_INTEGRATION_MESSAGE_LOG]
(
	[LoggedAt] DESC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

if not exists(select * from sys.indexes i where i.name = 'UIX_T_INTEGRATION_MESSAGE_LOG_InputMessageID')
CREATE UNIQUE NONCLUSTERED INDEX [UIX_T_INTEGRATION_MESSAGE_LOG_InputMessageID] ON [ISZL].[T_INTEGRATION_MESSAGE_LOG]
(
	[InputMessageID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

if not exists(select * from sys.indexes i where i.name = 'UIX_T_INTEGRATION_MESSAGE_LOG_OutputMessageID')
CREATE NONCLUSTERED INDEX [UIX_T_INTEGRATION_MESSAGE_LOG_OutputMessageID] ON [ISZL].[T_INTEGRATION_MESSAGE_LOG]
(
	[OutputMessageID] 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) ON [PRIMARY]
GO
