[dbo].[usm_search

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	21
Created	11:07:44 AM Wednesday, March 07, 2007
Last Modified	11:09:15 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
search_node_id	varchar(50)	50
params	varchar(1024)	1024
search_limit	int	4
default_param	varchar(64)	64
bucket_size	int	4
table_name	varchar(512)	512
order_by	varchar(64)	64
param_domain	varchar(64)	64
param_parent_domain	varchar(64)	64
criteria	varchar(1024)	1024

	Name	Columns	Unique
	XPKusm_search_node	search_node_id

Type	Action	Owning Principal
Grant	Delete	usmgroup
Grant	Insert	usmgroup
Grant	Select	usmgroup
Grant	Update	usmgroup

SQL Script

CREATE TABLE [dbo].[usm_search_node]
(
[search_node_id] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[params] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[search_limit] [int] NULL,
[default_param] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[bucket_size] [int] NULL,
[table_name] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[order_by] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[param_domain] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[param_parent_domain] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[criteria] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_search_node] ADD CONSTRAINT [XPKusm_search_node] PRIMARY KEY CLUSTERED ([search_node_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usm_search_node] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_search_node] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_search_node] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_search_node] TO [usmgroup]
GO