CREATE TABLE [dbo].[keit_templates]
(
[id] [int] NOT NULL,
[template_name] [nvarchar] (254) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[description] [nvarchar] (254) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[exp_sub_cat] [int] NULL,
[exp_sec_cat] [int] NULL,
[exp_all_docs] [int] NULL,
[exp_filter] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[exp_attmnt] [int] NULL,
[exp_index_doc] [int] NULL,
[override_pub] [int] NULL,
[override_unpub] [int] NULL,
[override_defaults] [int] NULL,
[err_threshold] [int] NULL,
[field_list] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cat_list] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[default_list] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[status_id] [int] NULL,
[doc_template_id] [int] NULL,
[priority_id] [int] NULL,
[owner_id] [binary] (16) NULL,
[author_id] [binary] (16) NULL,
[subject_expert_id] [binary] (16) NULL,
[assignee_id] [binary] (16) NULL,
[expiration_date] [int] NULL,
[review_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,
[last_mod_by] [binary] (16) NULL,
[last_mod_dt] [int] NULL,
[tenant] [binary] (16) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[keit_templates] ADD CONSTRAINT [pk__keit_templates__7406ab4b] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [keit_templates_x0] ON [dbo].[keit_templates] ([template_name]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [keit_templates_x1] ON [dbo].[keit_templates] ([tenant]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[keit_templates] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[keit_templates] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[keit_templates] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[keit_templates] TO [service_desk_admin_group]
GO
EXEC sp_addextendedproperty N'Comment', N'Added r12', 'SCHEMA', N'dbo', 'TABLE', N'keit_templates', NULL, NULL
GO