TRUNCATE TABLE pal_SurfaceAction

SET IDENTITY_INSERT [dbo].[pal_SurfaceAction] ON 
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (1, 1, N'VAT', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (2, 1, N'Age', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (3, 1, N'Gender', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (4, 2, N'Copy', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (5, 3, N'Visible', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (6, 4, N'Surface Save', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (7, 1, N'Divide', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (8, 1, N'Lookup', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (9, 5, N'Surface Item Code', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (10, 6, N'Sum', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (11, 7, N'Text Colour', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (12, 8, N'Average', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (13, 1, N'Ranking', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (14, 8, N'Distinction Count', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (15, 8, N'Sum', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (16, 8, N'Difference', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (17, 8, N'Failed Count', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (18, 8, N'Passed Count', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (19, 1, N'Lookup Field', 1)
INSERT [dbo].[pal_SurfaceAction] ([recId], [actionType], [action], [isActive]) VALUES (20, 1, N'Percentage', 1)
SET IDENTITY_INSERT [dbo].[pal_SurfaceAction] OFF

