IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES 
           WHERE TABLE_NAME = N'pal_SalesItemType')
BEGIN
CREATE TABLE [dbo].[pal_SalesItemType](
	[recId] [int] IDENTITY(1,1) NOT NULL,
	[itemType] [varchar](50) NULL,
	[isActive] [bit] NULL CONSTRAINT [DF_pal_SalesItemType_isActive]  DEFAULT ((0)),
 CONSTRAINT [PK_pal_SalesItemType] 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]

SET IDENTITY_INSERT [dbo].[pal_SalesItemType] ON 
INSERT [dbo].[pal_SalesItemType] ([recId], [itemType], [isActive]) VALUES (1, N'Service', 1)
INSERT [dbo].[pal_SalesItemType] ([recId], [itemType], [isActive]) VALUES (2, N'Physical', 1)
SET IDENTITY_INSERT [dbo].[pal_SalesItemType] OFF

END

