[dbo].[al_ui

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	2:24:47 PM Friday, March 21, 2008
Last Modified	2:24:47 PM Friday, March 21, 2008

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_al_ui_cache: page_id\control_id\cache_key$	page_id	varchar(40)	40
$Cluster Primary Key PK_al_ui_cache: page_id\control_id\cache_key$	control_id	varchar(500)	500
	cache_action	int	4
$Cluster Primary Key PK_al_ui_cache: page_id\control_id\cache_key$	cache_key	varchar(160)	160
	cache_value	image	max
	class_name	varchar(100)	100
	last_update_date	int	4

	Name	Columns	Unique
$Cluster Primary Key PK_al_ui_cache: page_id\control_id\cache_key$	PK_al_ui_cache	page_id, control_id, cache_key

Type	Action	Owning Principal
Grant	Delete	swcmadmin
Grant	Insert	swcmadmin
Grant	Delete	uapmadmin
Grant	Insert	uapmadmin
Grant	Delete	uapmbatch
Grant	Insert	uapmbatch
Grant	Delete	uapmreporting
Grant	Insert	uapmreporting
Grant	Delete	uapmadmin_group
Grant	Insert	uapmadmin_group
Grant	Delete	uapmbatch_group
Grant	Insert	uapmbatch_group
Grant	Delete	uapmreporting_group
Grant	Insert	uapmreporting_group
Grant	Select	uapmadmin_group
Grant	Update	uapmadmin_group
Grant	Select	uapmbatch_group
Grant	Update	uapmbatch_group
Grant	Select	uapmreporting_group
Grant	Update	uapmreporting_group
Grant	Select	uapmadmin
Grant	Update	uapmadmin
Grant	Select	uapmbatch
Grant	Update	uapmbatch
Grant	Select	uapmreporting
Grant	Update	uapmreporting
Grant	Select	swcmadmin
Grant	Update	swcmadmin

SQL Script

CREATE TABLE [dbo].[al_ui_cache]
(
[page_id] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[control_id] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[cache_action] [int] NOT NULL,
[cache_key] [varchar] (160) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[cache_value] [image] NULL,
[class_name] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[last_update_date] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_ui_cache] ADD CONSTRAINT [PK_al_ui_cache] PRIMARY KEY CLUSTERED ([page_id], [control_id], [cache_key]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[al_ui_cache] TO [swcmadmin]
GRANT INSERT ON  [dbo].[al_ui_cache] TO [swcmadmin]
GRANT DELETE ON  [dbo].[al_ui_cache] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[al_ui_cache] TO [swcmadmin]
GRANT SELECT ON  [dbo].[al_ui_cache] TO [uapmadmin]
GRANT INSERT ON  [dbo].[al_ui_cache] TO [uapmadmin]
GRANT DELETE ON  [dbo].[al_ui_cache] TO [uapmadmin]
GRANT UPDATE ON  [dbo].[al_ui_cache] TO [uapmadmin]
GRANT SELECT ON  [dbo].[al_ui_cache] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[al_ui_cache] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[al_ui_cache] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[al_ui_cache] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[al_ui_cache] TO [uapmbatch]
GRANT INSERT ON  [dbo].[al_ui_cache] TO [uapmbatch]
GRANT DELETE ON  [dbo].[al_ui_cache] TO [uapmbatch]
GRANT UPDATE ON  [dbo].[al_ui_cache] TO [uapmbatch]
GRANT SELECT ON  [dbo].[al_ui_cache] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[al_ui_cache] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[al_ui_cache] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[al_ui_cache] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[al_ui_cache] TO [uapmreporting]
GRANT INSERT ON  [dbo].[al_ui_cache] TO [uapmreporting]
GRANT DELETE ON  [dbo].[al_ui_cache] TO [uapmreporting]
GRANT UPDATE ON  [dbo].[al_ui_cache] TO [uapmreporting]
GRANT SELECT ON  [dbo].[al_ui_cache] TO [uapmreporting_group]
GRANT INSERT ON  [dbo].[al_ui_cache] TO [uapmreporting_group]
GRANT DELETE ON  [dbo].[al_ui_cache] TO [uapmreporting_group]
GRANT UPDATE ON  [dbo].[al_ui_cache] TO [uapmreporting_group]
GO