CREATE TABLE [dbo].[user_preferences]
(
[preference_userid] [int] NOT NULL,
[preference_type] [int] NOT NULL,
[product_code] [int] NOT NULL,
[preference_value] [char] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[datetime_updated] [datetime] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[user_preferences] ADD CONSTRAINT [XPKuser_preferences] PRIMARY KEY CLUSTERED ([preference_userid], [preference_type], [product_code]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [user_preferences_idx_01] ON [dbo].[user_preferences] ([preference_userid], [product_code]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[user_preferences] TO [cmew_admin]
GRANT INSERT ON [dbo].[user_preferences] TO [cmew_admin]
GRANT DELETE ON [dbo].[user_preferences] TO [cmew_admin]
GRANT UPDATE ON [dbo].[user_preferences] TO [cmew_admin]
GRANT SELECT ON [dbo].[user_preferences] TO [cmew_rdr]
GO
[dbo].[user_preferences]
