CREATE TABLE [dbo].[ci_ambiguity_ci]
(
[id] [binary] (16) NOT NULL,
[last_update_date] [int] NULL,
[ambiguity] [int] NULL,
[count_resource_name] [int] NULL,
[count_serial_number] [int] NULL,
[count_dns_name] [int] NULL,
[count_mac_address] [int] NULL,
[count_resource_tag] [int] NULL,
[count_host_name] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ci_ambiguity_ci] ADD CONSTRAINT [PK_ci_ambiguity_ci] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ci_ambiguity_ci_x01] ON [dbo].[ci_ambiguity_ci] ([ambiguity]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[ci_ambiguity_ci] TO [service_desk_admin_group]
GRANT INSERT ON [dbo].[ci_ambiguity_ci] TO [service_desk_admin_group]
GRANT DELETE ON [dbo].[ci_ambiguity_ci] TO [service_desk_admin_group]
GRANT UPDATE ON [dbo].[ci_ambiguity_ci] TO [service_desk_admin_group]
GRANT SELECT ON [dbo].[ci_ambiguity_ci] TO [service_desk_ro_group]
GO
EXEC sp_addextendedproperty N'Comment', N'Added r12.5', 'SCHEMA', N'dbo', 'TABLE', N'ci_ambiguity_ci', NULL, NULL
GO