[dbo].[ci_ambiguity_twaci]
CREATE TABLE [dbo].[ci_ambiguity_twaci]
(
[id] [int] 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_twaci] ADD CONSTRAINT [PK_ci_ambiguity_twaci] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ci_ambiguity_twaci_x01] ON [dbo].[ci_ambiguity_twaci] ([ambiguity]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[ci_ambiguity_twaci] TO [service_desk_admin_group]
GRANT INSERT ON [dbo].[ci_ambiguity_twaci] TO [service_desk_admin_group]
GRANT DELETE ON [dbo].[ci_ambiguity_twaci] TO [service_desk_admin_group]
GRANT UPDATE ON [dbo].[ci_ambiguity_twaci] TO [service_desk_admin_group]
GRANT SELECT ON [dbo].[ci_ambiguity_twaci] TO [service_desk_ro_group]
GO
EXEC sp_addextendedproperty N'Comment', N'Added r12.5', 'SCHEMA', N'dbo', 'TABLE', N'ci_ambiguity_twaci', NULL, NULL
GO
