/****** Object:  Table [dbo].[publ_ShoppingListSearchHistory]    Script Date: 2020/02/07 17:04:41 ******/

USE [Framework_REAP-1]
IF((SELECT COUNT(*) FROM dbo.pal_Surface WHERE name = 'ShoppingListSearchHistory') = 1)
BEGIN

UPDATE pal_Surface SET isPublished = 1 WHERE name = 'ShoppingListSearchHistory';
END;

IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'publ_ShoppingListSearchHistory')
BEGIN

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[publ_ShoppingListSearchHistory](
	[itemID] [int] NOT NULL,
	[isActive] [bit] NULL,
	[surfaceId] [int] NOT NULL,
	[ParentSurfaceItemId] [int] NULL,
	[ShoppingListSearchHistory_ProductSearchHistory_FileExtension] [varchar](50) NULL,
	[ShoppingListSearchHistory_ProductSearchHistory_SearchName] [varchar](max) NULL,
	[ShoppingListSearchHistory_ProductSearchHistory_DateCreated] [datetime] NULL,
	[ShoppingListSearchHistory_ProductSearchHistory_ViewData] [varchar](max) NULL,
	[ShoppingListSearchHistory_ProductSearchHistory_SearchAgain] [varchar](max) NULL,
	[ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber] [varchar](max) NULL,
	[ShoppingListSearchHistory_ProductSearchHistory_RetailerName] [varchar](max) NULL,
	[recId] [int] IDENTITY(1,1) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[recId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[publ_ShoppingListSearchHistory] ON 

INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (40345, 1, 3101, 0, N'', N'', NULL, NULL, NULL, N'', N'', 1)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (45870, 1, 3101, 0, N'', N'', NULL, NULL, NULL, N'', N'', 2)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (45871, 1, 3101, 0, N'', N'', NULL, NULL, NULL, N'', N'', 3)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (45872, 1, 3101, 0, N'', N'', NULL, NULL, NULL, N'', N'', 4)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (45873, 1, 3101, 0, N'', N'', NULL, NULL, NULL, N'', N'', 5)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (58303, 1, 3101, 58302, N'.xlsx', N'S0001_refresh', CAST(N'2020-01-20T00:00:00.000' AS DateTime), NULL, NULL, N'S0001', N'Southern Superspar', 6)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (58525, 1, 3101, 58302, N'.xlsx', N'S0001_dry', CAST(N'2020-01-20T00:00:00.000' AS DateTime), NULL, NULL, N'S0001', N'Southern Superspar', 7)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (58797, 1, 3101, 58302, N'.xlsx', N'S0001_haba', CAST(N'2020-01-20T00:00:00.000' AS DateTime), NULL, NULL, N'S0001', N'Southern Superspar', 8)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (59350, 1, 3101, 58302, N'.xlsx', N'S0001_house', CAST(N'2020-01-20T00:00:00.000' AS DateTime), NULL, NULL, N'S0001', N'Southern Superspar', 9)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (59645, 1, 3101, 58302, N'.xlsx', N'S0001_perish', CAST(N'2020-01-20T00:00:00.000' AS DateTime), NULL, NULL, N'S0001', N'Southern Superspar', 10)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (59851, 1, 3101, 58302, N'.xlsx', N'S0001_sweets snacks', CAST(N'2020-01-20T00:00:00.000' AS DateTime), NULL, NULL, N'S0001', N'Southern Superspar', 11)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (75724, 1, 3101, 75723, N'.xlsx', N'S0002_drygoods  04022020', CAST(N'2020-02-04T00:00:00.000' AS DateTime), NULL, NULL, N'S0002', N'Southern Superspar', 12)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (75929, 1, 3101, 75723, N'.xlsx', N'S0002_drygoods1', CAST(N'2020-02-04T00:00:00.000' AS DateTime), NULL, NULL, N'S0002', N'Southern Superspar', 13)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (76213, 1, 3101, 76196, N'.xlsx', N'S0003_haba 2020', CAST(N'2020-02-04T00:00:00.000' AS DateTime), NULL, NULL, N'S0003', N'Southern Superspar', 14)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (76417, 1, 3101, 76415, N'.xlsx', N'S0004_haba 04022020', CAST(N'2020-02-04T00:00:00.000' AS DateTime), NULL, NULL, N'S0004', N'Southern Superspar', 15)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (76795, 1, 3101, 76415, N'.xlsx', N'S0004_dry 04022020', CAST(N'2020-02-04T00:00:00.000' AS DateTime), NULL, NULL, N'S0004', N'Southern Superspar', 16)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (76996, 1, 3101, 76415, N'.xlsx', N'S0004_dry', CAST(N'2020-02-04T00:00:00.000' AS DateTime), NULL, NULL, N'S0004', N'Southern Superspar', 17)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (77441, 1, 3101, 76415, N'.xlsx', N'S0004_refresh', CAST(N'2020-02-05T00:00:00.000' AS DateTime), NULL, NULL, N'S0004', N'Southern Superspar', 18)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (78046, 1, 3101, 76415, N'.xlsx', N'S0004_house', CAST(N'2020-02-05T00:00:00.000' AS DateTime), NULL, NULL, N'S0004', N'Southern Superspar', 19)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (78452, 1, 3101, 76415, N'.xlsx', N'S0004_house01', CAST(N'2020-02-05T00:00:00.000' AS DateTime), NULL, NULL, N'S0004', N'Southern Superspar', 20)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (78666, 1, 3101, 76415, N'.xlsx', N'S0004_test', CAST(N'2020-02-05T00:00:00.000' AS DateTime), NULL, NULL, N'S0004', N'Southern Superspar', 21)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (78797, 1, 3101, 76415, N'.xlsx', N'S0004_house02', CAST(N'2020-02-05T00:00:00.000' AS DateTime), NULL, NULL, N'S0004', N'Southern Superspar', 22)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (79019, 1, 3101, 76415, N'.xlsx', N'S0004_perish', CAST(N'2020-02-05T00:00:00.000' AS DateTime), NULL, NULL, N'S0004', N'Southern Superspar', 23)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (79272, 1, 3101, 76415, N'.xlsx', N'S0004_house03', CAST(N'2020-02-05T00:00:00.000' AS DateTime), NULL, NULL, N'S0004', N'Southern Superspar', 24)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (79475, 1, 3101, 76415, N'.xlsx', N'S0004_house test', CAST(N'2020-02-05T00:00:00.000' AS DateTime), NULL, NULL, N'S0004', N'Southern Superspar', 25)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (79492, 1, 3101, 76415, N'.xlsx', N'S0004_house 03', CAST(N'2020-02-05T00:00:00.000' AS DateTime), NULL, NULL, N'S0004', N'Southern Superspar', 26)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (81425, 1, 3101, 81424, N'.xlsx', N'S0005_06-02-2020-black-cat', CAST(N'2020-02-06T00:00:00.000' AS DateTime), NULL, NULL, N'S0005', N'Dylan Test Retailer', 27)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (81436, 1, 3101, 81424, N'.xlsx', N'S0005_06-02-2020-ace', CAST(N'2020-02-06T00:00:00.000' AS DateTime), NULL, NULL, N'S0005', N'Dylan Test Retailer', 28)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (81448, 1, 3101, 81447, N'.xlsx', N'S0006_07-02-2020-test1', CAST(N'2020-02-07T00:00:00.000' AS DateTime), NULL, NULL, N'S0006', N'Dylan Test Retailer', 29)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (81469, 1, 3101, 81468, N'.xlsx', N'S0007_07-02-2020-test1', CAST(N'2020-02-07T00:00:00.000' AS DateTime), NULL, NULL, N'S0007', N'Dylan Test Retailer', 30)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (81495, 1, 3101, 81494, N'.xlsx', N'S0008_07-02-2020-test1', CAST(N'2020-02-07T00:00:00.000' AS DateTime), NULL, NULL, N'S0008', N'DorotejaTestRetailer', 31)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (81519, 1, 3101, 81518, N'.xlsx', N'S0009_07-02-2020-test1', CAST(N'2020-02-07T00:00:00.000' AS DateTime), NULL, NULL, N'S0009', N'DorotejaTestRetailer', 32)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (81544, 1, 3101, 81543, N'.xlsx', N'S0010_07-02-2020-test1', CAST(N'2020-02-07T00:00:00.000' AS DateTime), NULL, NULL, N'S0010', N'DorotejaTestRetailer', 33)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (81565, 1, 3101, 81543, N'.xlsx', N'S0010_07-02-2020-test2', CAST(N'2020-02-07T00:00:00.000' AS DateTime), NULL, NULL, N'S0010', N'DorotejaTestRetailer', 34)
INSERT [dbo].[publ_ShoppingListSearchHistory] ([itemID], [isActive], [surfaceId], [ParentSurfaceItemId], [ShoppingListSearchHistory_ProductSearchHistory_FileExtension], [ShoppingListSearchHistory_ProductSearchHistory_SearchName], [ShoppingListSearchHistory_ProductSearchHistory_DateCreated], [ShoppingListSearchHistory_ProductSearchHistory_ViewData], [ShoppingListSearchHistory_ProductSearchHistory_SearchAgain], [ShoppingListSearchHistory_ProductSearchHistory_ShoppingListNumber], [ShoppingListSearchHistory_ProductSearchHistory_RetailerName], [recId]) VALUES (81573, 1, 3101, 81543, N'.xlsx', N'S0010_07-02-2020-test3', CAST(N'2020-02-07T00:00:00.000' AS DateTime), NULL, NULL, N'S0010', N'DorotejaTestRetailer', 35)
SET IDENTITY_INSERT [dbo].[publ_ShoppingListSearchHistory] OFF

END;