CREATE TABLE [dbo].[RPReportParams]
(
[ReportParamID] [int] NOT NULL IDENTITY(1, 1),
[ParamName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DisplayName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ReportID] [int] NOT NULL,
[TypeID] [int] NOT NULL,
[TypeValue] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TypeValue2] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TypeValue3] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TypeValue4] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OrderValue] [int] NULL,
[DisplayOrderValue] [int] NULL,
[Hide] [bit] NOT NULL CONSTRAINT [DF_RPReportParams_Hide] DEFAULT ((0)),
[LdBaseID] [int] NULL,
[Required] [bit] NOT NULL CONSTRAINT [DF_RPReportParams_Required] DEFAULT ((0)),
[Type2ID] [int] NOT NULL CONSTRAINT [DF_RPReportParams_Type2ID] DEFAULT ((2)),
[AddSingleQuotes] [bit] NOT NULL CONSTRAINT [DF_RPReportParams_AddSingleQuotes] DEFAULT ((0)),
[NoPreview] [bit] NOT NULL CONSTRAINT [DF_RPReportParams_NoPreview] DEFAULT ((0)),
[RememberMe] [bit] NOT NULL CONSTRAINT [DF_RPReportParams_RememberMe] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPReportParams] ADD CONSTRAINT [PK_RPReportParams] PRIMARY KEY CLUSTERED ([ReportParamID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPReportParams] ADD CONSTRAINT [FK_RPReportParams_ReportID_RPReports] FOREIGN KEY ([ReportID]) REFERENCES [dbo].[RPReports] ([ReportID])
GO
ALTER TABLE [dbo].[RPReportParams] ADD CONSTRAINT [FK_RPReportParams_Type2ID_RPReportParamTypes2] FOREIGN KEY ([Type2ID]) REFERENCES [dbo].[RPReportParamTypes2] ([ParamTypeID])
GO
ALTER TABLE [dbo].[RPReportParams] ADD CONSTRAINT [FK_RPReportParams_TypeID_RPReportParamTypesEx] FOREIGN KEY ([TypeID]) REFERENCES [dbo].[RPReportParamTypesEx] ([ParamTypeID])
GO