CREATE TABLE [dbo].[wtdbpvqueryinfo]
(
[sequence_number] [int] NOT NULL,
[query_name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[identifier] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[operator] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[attribute] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[type] [int] NOT NULL,
[value] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[enabled] [tinyint] NOT NULL,
[schema_name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[logical_op] [int] NULL,
[reserved] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[weight] [int] NULL,
[start_group] [int] NULL,
[end_group] [int] NULL,
[include_subclasses] [tinyint] NOT NULL CONSTRAINT [DF__wtdbpvque__inclu__0E44D4E4] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wtdbpvqueryinfo] ADD CONSTRAINT [XPKwtdbpvqueryinfo] PRIMARY KEY CLUSTERED ([query_name], [sequence_number]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[wtdbpvqueryinfo] TO [uniadmin]
GRANT INSERT ON [dbo].[wtdbpvqueryinfo] TO [uniadmin]
GRANT DELETE ON [dbo].[wtdbpvqueryinfo] TO [uniadmin]
GRANT UPDATE ON [dbo].[wtdbpvqueryinfo] TO [uniadmin]
GRANT SELECT ON [dbo].[wtdbpvqueryinfo] TO [uniuser]
GRANT SELECT ON [dbo].[wtdbpvqueryinfo] TO [wvadmin]
GRANT INSERT ON [dbo].[wtdbpvqueryinfo] TO [wvadmin]
GRANT DELETE ON [dbo].[wtdbpvqueryinfo] TO [wvadmin]
GRANT UPDATE ON [dbo].[wtdbpvqueryinfo] TO [wvadmin]
GRANT SELECT ON [dbo].[wtdbpvqueryinfo] TO [wvuser]
GO