CREATE TABLE [dbo].[DashboardPortlet]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[DashboardLayoutID] [int] NOT NULL,
[PortletTypeID] [int] NOT NULL,
[RowIndex] [int] NOT NULL,
[ColumnIndex] [int] NOT NULL,
[IsCollapsed] [bit] NOT NULL CONSTRAINT [DF_DashboardPortlet_IsCollapsed] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DashboardPortlet] ADD CONSTRAINT [PK_DashboardPortlet_ID] PRIMARY KEY NONCLUSTERED ([ID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DashboardPortlet] ADD CONSTRAINT [FK_DashboardPortlet_DashboardLayoutID_DashboardLayout_ID] FOREIGN KEY ([DashboardLayoutID]) REFERENCES [dbo].[DashboardLayout] ([ID]) ON DELETE CASCADE ON UPDATE CASCADE
GO