CREATE TABLE [dbo].[usm_portal_content]
(
[portal_content_id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[title] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[stylesheet_url] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[refresh_time] [int] NULL,
[full_size] [int] NULL CONSTRAINT [DF__usm_porta__full___68F354A4] DEFAULT ((0)),
[x] [int] NULL,
[y] [int] NULL,
[width] [int] NULL,
[height] [int] NULL,
[row] [int] NULL,
[col] [int] NULL,
[separate_window] [int] NULL CONSTRAINT [DF__usm_porta__separ__69E778DD] DEFAULT ((0)),
[portal_template_id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dash_id] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[is_label] [tinyint] NULL,
[new_window] [int] NULL CONSTRAINT [DF__usm_porta__new_w__6ADB9D16] DEFAULT ((0)),
[params] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[is_hidden] [int] NULL CONSTRAINT [DF__usm_porta__is_hi__6BCFC14F] DEFAULT ((0)),
[data1] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[data2] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[data3] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[resize] [int] NULL CONSTRAINT [DF__usm_porta__resiz__6CC3E588] DEFAULT ((0)),
[irow] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_portal_content] ADD CONSTRAINT [XPKusm_portal_content] PRIMARY KEY CLUSTERED ([portal_content_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_portal_content] ADD CONSTRAINT [$usm_p_r0000283300000000] FOREIGN KEY ([portal_template_id]) REFERENCES [dbo].[usm_portal_template] ([portal_template_id])
GO
ALTER TABLE [dbo].[usm_portal_content] ADD CONSTRAINT [$usm_p_r0000283d00000000] FOREIGN KEY ([dash_id]) REFERENCES [dbo].[usm_dash] ([dash_id])
GO
ALTER TABLE [dbo].[usm_portal_content] ADD CONSTRAINT [$usm_p_r00002fef00000000] FOREIGN KEY ([dash_id]) REFERENCES [dbo].[usm_dash] ([dash_id])
GO
ALTER TABLE [dbo].[usm_portal_content] ADD CONSTRAINT [$usm_p_r00002ff900000000] FOREIGN KEY ([portal_template_id]) REFERENCES [dbo].[usm_portal_template] ([portal_template_id])
GO
GRANT SELECT ON  [dbo].[usm_portal_content] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_portal_content] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_portal_content] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_portal_content] TO [usmgroup]
GO