CREATE TABLE [dbo].[usm_report_dataview]
(
[report_dataview_id] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[description] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[report_data_id] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[comment] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[type] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[time_stamp] [datetime] NULL,
[status] [int] NULL,
[legend] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[report_style_chart] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[report_style_table] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[bucket_size] [int] NULL,
[data1] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[data2] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[column_rules] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dataview_type] [int] NULL,
[dataobject_string] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[external_cmd] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[external_file_name] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[external_params] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[external_format] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[external_cleanup] [int] NULL CONSTRAINT [DF__usm_repor__exter__0C3C90E1] DEFAULT ((0)),
[delimiter] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[refresh_time] [int] NULL,
[print_settings] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[folder] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[owner] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[get_variables_page] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pre_actions] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[post_actions] [nvarchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[bucket_no] [int] NULL,
[path] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[file_name] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[guinode_id] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[metering_string] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[name] [nvarchar] (128) 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_dataview] ADD CONSTRAINT [XPKusm_report_dataview] PRIMARY KEY CLUSTERED ([report_dataview_id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_report_dataview] ADD CONSTRAINT [$usm_r_r000028c900000000] FOREIGN KEY ([guinode_id]) REFERENCES [dbo].[usm_guinode] ([guinode_id])
GO
ALTER TABLE [dbo].[usm_report_dataview] ADD CONSTRAINT [$usm_r_r000028d300000000] FOREIGN KEY ([report_data_id]) REFERENCES [dbo].[usm_report_data] ([report_data_id])
GO
ALTER TABLE [dbo].[usm_report_dataview] ADD CONSTRAINT [$usm_r_r0000300d00000000] FOREIGN KEY ([report_data_id]) REFERENCES [dbo].[usm_report_data] ([report_data_id])
GO
GRANT SELECT ON  [dbo].[usm_report_dataview] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_report_dataview] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_report_dataview] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_report_dataview] TO [usmgroup]
GO