USE [FSLibrary]
GO

SET ANSI_PADDING ON
GO

/****** Object:  Index [tbl_GS1_BatchMessage_Idx1]    Script Date: 5/4/2020 1:08:00 PM ******/
CREATE CLUSTERED INDEX [tbl_GS1_BatchMessage_Idx1] ON [dbo].[tbl_GS1_BatchMessages]
(
	[ownerType] ASC,
	[ownerId] ASC,
	[clientName] ASC,
	[GLN] 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


USE [FSLibrary]
GO

SET ANSI_PADDING ON
GO

/****** Object:  Index [tbl_GS1_BatchMessage_Idx2]    Script Date: 5/4/2020 1:08:18 PM ******/
CREATE NONCLUSTERED INDEX [tbl_GS1_BatchMessage_Idx2] ON [dbo].[tbl_GS1_BatchMessages]
(
	[messageCode] ASC,
	[createDate] ASC,
	[batchid] ASC
)
INCLUDE([ownerType],[ownerId],[clientName],[GLN]) 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