CREATE TABLE [dbo].[usp_preferences]
(
[id] [int] NOT NULL,
[analyst_id] [binary] (16) NULL,
[arc_docs_to_display] [int] NULL,
[user_def_id] [int] NULL,
[author] [int] NULL,
[status] [int] NULL,
[owner] [int] NULL,
[subject_expert] [int] NULL,
[initiator] [int] NULL,
[assignee] [int] NULL,
[priority] [int] NULL,
[doc_type] [int] NULL,
[creation_date] [int] NULL,
[modify_date] [int] NULL,
[start_date] [int] NULL,
[expiration_date] [int] NULL,
[review_date] [int] NULL,
[last_accepted_date] [int] NULL,
[published_date] [int] NULL,
[bu_result] [int] NULL,
[product] [int] NULL,
[item] [int] NULL,
[sd_rootcause] [int] NULL,
[sd_priority] [int] NULL,
[sd_severity] [int] NULL,
[sd_impact] [int] NULL,
[sd_urgency] [int] NULL,
[sd_accepted_hits] [int] NULL,
[created_via] [int] NULL,
[primary_index] [int] NULL,
[current_action] [int] NULL,
[doc_template] [int] NULL,
[wf_template] [int] NULL,
[doc_version] [int] NULL,
[custom1] [int] NULL,
[custom2] [int] NULL,
[custom3] [int] NULL,
[custom4] [int] NULL,
[custom5] [int] NULL,
[custom_num1] [int] NULL,
[custom_num2] [int] NULL,
[one_b_docs_to_display] [int] NULL,
[one_b_search_type] [int] NULL,
[one_b_doc_view_mode] [int] NULL,
[one_b_hide_details] [int] NULL,
[doc_id] [int] NULL,
[hits] [int] NULL,
[inbox_counter] [int] NULL,
[one_b_word_parts] [int] NULL,
[one_b_match_type] [int] NULL,
[one_b_search_fields] [int] NULL,
[one_b_search_order] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[web_suppress_tour] [int] NULL,
[web_last_login] [int] NULL,
[web_popup1_height] [int] NULL,
[web_popup1_width] [int] NULL,
[web_popup2_height] [int] NULL,
[web_popup2_width] [int] NULL,
[web_popup3_height] [int] NULL,
[web_popup3_width] [int] NULL,
[web_popup4_height] [int] NULL,
[web_popup4_width] [int] NULL,
[web_toolbar_tab] [int] NULL,
[web_preferences] [int] NULL,
[last_mod_dt] [int] NULL,
[sd_search_fields_cr] [int] NULL,
[sd_search_fields_iss] [int] NULL,
[globalsd_active_zone] [int] NULL,
[classic_resultset_context] [int] NULL,
[kt_report_card_past_days] [int] NULL,
[kt_report_card_screen_default] [int] NULL,
[web_role_id] [int] NULL,
[tenant] [binary] (16) NULL,
[last_mod_by] [binary] (16) NULL,
[use_default_role] [int] NULL,
[sa_analyst_localization] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usp_preferences] ADD CONSTRAINT [XPKusp_preferences] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [usp_preferences_x0] ON [dbo].[usp_preferences] ([analyst_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usp_preferences_x1] ON [dbo].[usp_preferences] ([tenant]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usp_preferences] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[usp_preferences] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[usp_preferences] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[usp_preferences] TO [service_desk_admin_group]
GO