CREATE TABLE [dbo].[tbl_UserWFDispatchCategory](
	[FK_UserId] [varchar](10) NOT NULL,
	[FK_DispatchCode] [varchar](10) NULL
) ON [PRIMARY]

GO

CREATE TABLE [dbo].[tbl_WFDispatchCustomBoardUserDefaults](
	[FK_UserId] [varchar](10) NOT NULL,
	[WFCustomBoardID] [int] NOT NULL,
	[DefaultValue] [varchar](300) NOT NULL,
	[Exclude] [nchar](1) NULL
) ON [PRIMARY]

GO

CREATE TABLE [dbo].[tbl_WFDispatchCategory](
	[DispatchCode] [varchar](10) NOT NULL,
	[DispatchDescription] [nvarchar](50) NULL,
	[CustomBoard] [nchar](1) NOT NULL,
	[CustomBoardFields] [varchar](250) NOT NULL,
	[DefaultSortColumn] [nvarchar](50) NOT NULL,
	[DefaultSortDirection] [nchar](1) NOT NULL,
	[WorkflowGridCache] [ntext] NULL,
	[WorkflowColumnsCache] [nvarchar](2000) NULL,
 CONSTRAINT [PK_tbl_WFDispatchCategory] PRIMARY KEY CLUSTERED 
(
	[DispatchCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[tbl_WFDispatchCategory] ADD  CONSTRAINT [DF_tbl_WFDispatchCategory_CustomBoard]  DEFAULT ('N') FOR [CustomBoard]
GO

ALTER TABLE [dbo].[tbl_WFDispatchCategory] ADD  CONSTRAINT [DF_tbl_WFDispatchCategory_CustomBoardFields]  DEFAULT ('') FOR [CustomBoardFields]
GO

ALTER TABLE [dbo].[tbl_WFDispatchCategory] ADD  CONSTRAINT [DF_tbl_WFDispatchCategory_DefaultSortColumn]  DEFAULT ('') FOR [DefaultSortColumn]
GO

ALTER TABLE [dbo].[tbl_WFDispatchCategory] ADD  CONSTRAINT [DF_tbl_WFDispatchCategory_DefaultSortDirection]  DEFAULT (N'D') FOR [DefaultSortDirection]
GO

CREATE TABLE [dbo].[tbl_WFCustomDispatchBoardColumns](
	[WFCustomBoardID] [int] IDENTITY(1,1) NOT NULL,
	[SetupName] [varchar](100) NOT NULL,
	[ColumnName] [varchar](100) NOT NULL,
	[FieldName] [varchar](100) NOT NULL,
	[FieldType] [varchar](15) NOT NULL,
	[Sortable] [nchar](1) NOT NULL,
	[SortType] [varchar](25) NOT NULL,
	[Alignment] [varchar](10) NOT NULL,
	[MaxDisplayCharacters] [int] NOT NULL,
	[DefaultWidth] [nvarchar](5) NOT NULL,
	[DataTooltip] [varchar](100) NOT NULL,
	[ExactMatch] [nchar](1) NULL,
 CONSTRAINT [PK_tbl_WFCustomDispatchBoardColumns] PRIMARY KEY CLUSTERED 
(
	[WFCustomBoardID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[tbl_WFCustomDispatchBoardColumns] ADD  CONSTRAINT [DF_tbl_WFCustomDispatchBoardColumns_SetupName]  DEFAULT ('') FOR [SetupName]
GO

ALTER TABLE [dbo].[tbl_WFCustomDispatchBoardColumns] ADD  CONSTRAINT [DF_tbl_WFCustomDispatchBoardColumns_FieldType]  DEFAULT ('') FOR [FieldType]
GO

ALTER TABLE [dbo].[tbl_WFCustomDispatchBoardColumns] ADD  CONSTRAINT [DF_tbl_WFCustomDispatchBoardColumns_Sortable]  DEFAULT ('Y') FOR [Sortable]
GO

ALTER TABLE [dbo].[tbl_WFCustomDispatchBoardColumns] ADD  CONSTRAINT [DF_tbl_WFCustomDispatchBoardColumnss_SortType]  DEFAULT ('text') FOR [SortType]
GO

ALTER TABLE [dbo].[tbl_WFCustomDispatchBoardColumns] ADD  CONSTRAINT [DF_tbl_WFCustomDispatchBoardColumns_Alignment]  DEFAULT ('left') FOR [Alignment]
GO

ALTER TABLE [dbo].[tbl_WFCustomDispatchBoardColumns] ADD  CONSTRAINT [DF_tbl_WFCustomDispatchBoardColumns_MaxDisplayCharacters]  DEFAULT ((-1)) FOR [MaxDisplayCharacters]
GO

ALTER TABLE [dbo].[tbl_WFCustomDispatchBoardColumns] ADD  CONSTRAINT [DF_tbl_WFCustomDispatchBoardColumns_DefaultWidth]  DEFAULT (N'10%') FOR [DefaultWidth]
GO