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]
GO