CREATE TABLE [dbo].[usm_analysis]
(
[analysis_id] [int] NOT NULL,
[report_group_id] [int] NULL,
[category] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[access_group] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[commandlineargs] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[analyze_period] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[analyze_title] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[analyze_job_id] [int] NULL,
[url] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[created] [int] NULL,
[modified] [int] NULL,
[analyze_status] [tinyint] NULL,
[release_status] [tinyint] NULL,
[period_start] [int] NULL,
[period_stop] [int] NULL,
[period_type] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[analysis_layout_set_id] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_analysis] ADD CONSTRAINT [XPKusm_analysis] PRIMARY KEY CLUSTERED ([analysis_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_analysis_idx_03] ON [dbo].[usm_analysis] ([access_group], [analyze_job_id], [release_status], [analyze_status], [period_start]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_analysis_idx_04] ON [dbo].[usm_analysis] ([report_group_id], [access_group], [release_status], [period_start], [period_type], [analyze_status]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_analysis_idx_02] ON [dbo].[usm_analysis] ([report_group_id], [category], [release_status], [period_start], [period_type], [analyze_status]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usm_analysis_idx_01] ON [dbo].[usm_analysis] ([url], [access_group], [release_status], [period_start]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_analysis] ADD CONSTRAINT [$usm_a_r0000206300000000] FOREIGN KEY ([report_group_id]) REFERENCES [dbo].[usm_report_group] ([report_group_id])
GO
ALTER TABLE [dbo].[usm_analysis] ADD CONSTRAINT [$usm_a_r0000206d00000000] FOREIGN KEY ([analyze_job_id]) REFERENCES [dbo].[usm_analyze_job] ([analyze_job_id])
GO
GRANT SELECT ON  [dbo].[usm_analysis] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_analysis] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_analysis] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_analysis] TO [usmgroup]
GO