CREATE TABLE [dbo].[usm_report_data]
(
[report_data_id] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[name] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[status] [int] NULL CONSTRAINT [DF__usm_repor__statu__09602436] DEFAULT ((0)),
[type] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[db_id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[comment] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[time_stamp] [datetime] NULL,
[pre_actions] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[query_string] [ntext] COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[post_actions] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[page_functions] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[report_functions] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[fields] [ntext] COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[data1] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[data2] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[delimiter] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[class] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[report_variable_string] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[folder] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[owner] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[reg_join_query_string] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pvt_row_fields] [ntext] COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pvt_column_fields] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pvt_data_fields] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pvt_aggregate_fields] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dblock_type] [int] NULL,
[pvt_totals] [int] NULL,
[pvt_aggregate_type] [int] NULL,
[pvt_data] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pvt_empty_cell_value] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pvt_error_value] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pvt_orig_fields] [ntext] COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pvt_sort_order] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[bucket_no] [int] NULL,
[bucket_size] [int] NULL,
[pvt_col_sort_order] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[get_variables_page] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[comments] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_report_data] ADD CONSTRAINT [XPKusm_report_data] PRIMARY KEY CLUSTERED ([report_data_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_report_data] ADD CONSTRAINT [$usm_r_r000028bf00000000] FOREIGN KEY ([db_id]) REFERENCES [dbo].[usm_db] ([db_id])
GO
ALTER TABLE [dbo].[usm_report_data] ADD CONSTRAINT [$usm_r_r00002f1300000000] FOREIGN KEY ([db_id]) REFERENCES [dbo].[usm_db] ([db_id])
GO
GRANT SELECT ON  [dbo].[usm_report_data] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_report_data] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_report_data] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_report_data] TO [usmgroup]
GO