CREATE TABLE [dbo].[skeletons]
(
[id] [int] NOT NULL,
[user_def_id] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[active_state] [int] NULL,
[active_state_date] [int] NULL,
[hits] [int] NULL,
[sd_accepted_hits] [int] NULL,
[status_id] [int] NULL,
[priority_id] [int] NULL,
[doc_type_id] [int] NULL,
[ext_doc_id] [int] NULL,
[initiator_id] [binary] (16) NULL,
[initiator] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[owner_id] [binary] (16) NULL,
[author_id] [binary] (16) NULL,
[subject_expert_id] [binary] (16) NULL,
[assignee_id] [binary] (16) 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,
[sd_product_id] [int] NULL,
[sd_asset_id] [binary] (16) NULL,
[sd_rootcause_id] [int] NULL,
[sd_priority_id] [int] NULL,
[sd_severity_id] [int] NULL,
[sd_impact_id] [int] NULL,
[sd_urgency_id] [int] NULL,
[created_via] [int] NULL,
[read_pgroup] [int] NULL,
[write_pgroup] [int] NULL,
[primary_index] [int] NULL,
[kd_permission_index_id] [int] NULL,
[inherit_permission] [int] NULL,
[current_action_id] [int] NULL,
[resolution_short] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[resolution_length] [int] NULL,
[doc_template_id] [int] NULL,
[custom1] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[custom2] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[custom3] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[custom4] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[custom5] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[custom_num1] [float] NULL,
[custom_num2] [float] NULL,
[bu_result] [float] NULL,
[expire_notification_sent] [int] NULL,
[published_date] [int] NULL,
[wf_template] [int] NULL,
[doc_version] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ver_count] [int] NULL,
[ver_cross_ref_id] [int] NULL,
[ver_comment] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[locked_by_id] [binary] (16) NULL,
[word_count_total] [int] NULL,
[wordcount] [int] NULL,
[title] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[summary] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[problem] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[resolution] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[notes] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[fullwords] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[shortwords] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[wordcounts] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[wordspans] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[wordplaces] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[wordorders] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_mod_dt] [int] NULL,
[indexed] [int] NULL CONSTRAINT [DF__skeletons__index__4FE7AFB8] DEFAULT ((0)),
[parent_cr] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[parent_iss] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[total_weight] [float] NULL,
[user_slv_cnt] [int] NULL,
[vote_count] [int] NULL,
[avg_rating] [float] NULL,
[faq_sym] [int] NULL,
[doc_uuid] [binary] (16) NULL,
[flg_cnt] [int] NULL,
[last_hit_date] [int] NULL,
[last_vote_date] [int] NULL,
[rework_ver] [int] NULL,
[skip_auto_policies] [int] NULL,
[sd_problem] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ticket_avoided_cnt] [int] NULL,
[persid] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[qa_status] [int] NULL,
[file_id] [int] NULL,
[file_type] [int] NULL,
[tenant] [binary] (16) NULL,
[ks_type] [int] NULL,
[problem_short] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_mod_by] [binary] (16) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[skeletons] ADD CONSTRAINT [XPKskeletons] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x1] ON [dbo].[skeletons] ([active_state], [status_id], [id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x0] ON [dbo].[skeletons] ([active_state], [status_id], [read_pgroup], [owner_id], [assignee_id], [id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x61] ON [dbo].[skeletons] ([active_state], [status_id], [tenant], [bu_result], [modify_date], [id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x18] ON [dbo].[skeletons] ([assignee_id], [active_state], [read_pgroup], [id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x2] ON [dbo].[skeletons] ([author_id], [id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x51] ON [dbo].[skeletons] ([bu_result], [modify_date], [read_pgroup], [active_state], [status_id], [id], [tenant]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x3] ON [dbo].[skeletons] ([bu_result], [modify_date], [read_pgroup], [owner_id], [assignee_id], [active_state], [status_id], [id], [tenant]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x42] ON [dbo].[skeletons] ([current_action_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x6] ON [dbo].[skeletons] ([doc_type_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x58] ON [dbo].[skeletons] ([doc_uuid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x8] ON [dbo].[skeletons] ([expiration_date]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x53] ON [dbo].[skeletons] ([hits], [modify_date], [read_pgroup], [active_state], [status_id], [id], [tenant]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x10] ON [dbo].[skeletons] ([hits], [modify_date], [read_pgroup], [owner_id], [assignee_id], [active_state], [status_id], [id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x35] ON [dbo].[skeletons] ([indexed]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x11] ON [dbo].[skeletons] ([inherit_permission], [kd_permission_index_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x13] ON [dbo].[skeletons] ([kd_permission_index_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x60] ON [dbo].[skeletons] ([ks_type]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x54] ON [dbo].[skeletons] ([last_hit_date]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x55] ON [dbo].[skeletons] ([last_vote_date]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x17] ON [dbo].[skeletons] ([owner_id], [active_state], [read_pgroup], [id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x19] ON [dbo].[skeletons] ([primary_index]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x21] ON [dbo].[skeletons] ([published_date], [read_pgroup], [modify_date], [owner_id], [assignee_id], [id], [tenant]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x57] ON [dbo].[skeletons] ([rework_ver]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x52] ON [dbo].[skeletons] ([sd_accepted_hits], [modify_date], [read_pgroup], [active_state], [status_id], [id], [tenant]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x24] ON [dbo].[skeletons] ([sd_accepted_hits], [modify_date], [read_pgroup], [owner_id], [assignee_id], [active_state], [status_id], [id], [tenant]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x59] ON [dbo].[skeletons] ([skip_auto_policies]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x50] ON [dbo].[skeletons] ([tenant]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x12] ON [dbo].[skeletons] ([user_def_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x56] ON [dbo].[skeletons] ([ver_cross_ref_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [skeletons_x32] ON [dbo].[skeletons] ([wf_template]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[skeletons] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[skeletons] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[skeletons] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[skeletons] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[skeletons] TO [service_desk_ro_group]
GO