IF (OBJECT_ID('FK_pal_SurfaceField_pal_SurfaceFieldType', 'F') IS NOT NULL)
BEGIN
	ALTER TABLE [dbo].[pal_SurfaceField] DROP CONSTRAINT [FK_pal_SurfaceField_pal_SurfaceFieldType]
END

TRUNCATE TABLE [pal_SurfaceFieldType]

SET IDENTITY_INSERT [dbo].[pal_SurfaceFieldType] ON 

INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (1, N'Tab', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (2, N'Group', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (3, N'Text', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (4, N'Number', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (5, N'Decimal', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (6, N'Picklist', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (7, N'Date', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (8, N'Checkbox', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (9, N'RadioButtonList', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (10, N'Button', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (11, N'Grid', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (12, N'Attachment', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (13, N'Relational Field', 0)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (14, N'Formula Field', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (15, N'Time', 0)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (16, N'Header Group', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (17, N'Image', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (18, N'Content', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (19, N'Placeholder', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (20, N'Caption', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (21, N'Note', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (22, N'Debtors', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (23, N'Mediswitch', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (24, N'Composite', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (25, N'Address', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (26, N'CheckboxList', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (27, N'Sales', 1)
INSERT [dbo].[pal_SurfaceFieldType] ([recId], [surfaceFieldType], [isActive]) VALUES (28, N'Control', 1)

SET IDENTITY_INSERT [dbo].[pal_SurfaceFieldType] OFF

