CREATE TABLE [dbo].[mit_host]
(
[host_id] [int] NOT NULL,
[host_name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[host_domain] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[os_type] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[os_version] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[manageit_home] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[mit_host] ADD CONSTRAINT [XPKmit_host] PRIMARY KEY CLUSTERED ([host_id]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[mit_host] TO [udmadmin_group]
GRANT INSERT ON [dbo].[mit_host] TO [udmadmin_group]
GRANT DELETE ON [dbo].[mit_host] TO [udmadmin_group]
GRANT UPDATE ON [dbo].[mit_host] TO [udmadmin_group]
GO
[dbo].[mit_host]
