CREATE TABLE [dbo].[e2e_apm_host]
(
[host_id] [int] NULL,
[host_name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mac_address] [varchar] (14) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[mach_type] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[local_name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[host_resolved] [int] NULL,
[ip] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[os] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[aro_server] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[last_contact] [int] NULL,
[startup_time] [int] NULL,
[file_version] [int] NULL,
[thresh_version] [int] NULL,
[remark] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [ix_e2e_apm_host] ON [dbo].[e2e_apm_host] ([mac_address], [local_name]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[e2e_apm_host] TO [apmadmin]
GRANT INSERT ON  [dbo].[e2e_apm_host] TO [apmadmin]
GRANT DELETE ON  [dbo].[e2e_apm_host] TO [apmadmin]
GRANT UPDATE ON  [dbo].[e2e_apm_host] TO [apmadmin]
GO