CREATE TABLE [dbo].[SHBulkUpdateLinks]
(
[LinkID] [int] NOT NULL IDENTITY(1, 1),
[ListDialogType] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdateDescription] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdateTableName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdateTableIDField] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[LookUpCtrlType] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SetDescription] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SetFieldName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AdditionalUpdate] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SHBulkUpdateLinks_AdditionalUpdate] DEFAULT (''),
[AdditionalUpdateWhere] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SHBulkUpdateLinks_AdditionalUpdateWhere] DEFAULT (''),
[AdditionalUpdateIDField] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SHBulkUpdateLinks_AdditionalUpdateIDField] DEFAULT (''),
[DataTypeID] [int] NOT NULL,
[Length] [int] NOT NULL CONSTRAINT [DF_SHBulkUpdateLinks_Length] DEFAULT ((0)),
[CalcFormat] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CalcDecPlaces] [int] NOT NULL CONSTRAINT [DF_SHBulkUpdateLinks_CalcDecPlaces] DEFAULT ((0)),
[ShowCalc] [bit] NOT NULL CONSTRAINT [DF_SHBulkUpdateLinks_ShowCalc] DEFAULT ((0)),
[LastUpdateFieldName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UpdatorIDFieldName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UpdateWhere] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsHidden] [bit] NOT NULL CONSTRAINT [DF_SHBulkUpdateLinks_IsHidden] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHBulkUpdateLinks] ADD CONSTRAINT [FK_SHBulkUpdateLinks_DataTypeID_LdDataTypes] FOREIGN KEY ([DataTypeID]) REFERENCES [dbo].[LdDataTypes] ([DataTypeID])
GO
ALTER TABLE [dbo].[SHBulkUpdateLinks] ADD CONSTRAINT [FK_SHBulkUpdateLinks_ListDialogType_ListDialogTypes] FOREIGN KEY ([ListDialogType]) REFERENCES [dbo].[ListDialogTypes] ([DialogType])
GO
ALTER TABLE [dbo].[SHBulkUpdateLinks] ADD CONSTRAINT [FK_SHBulkUpdateLinks_LookUpCtrlType_LookUpCtrlTypes] FOREIGN KEY ([LookUpCtrlType]) REFERENCES [dbo].[LookUpCtrlTypes] ([Type])
GO