[cohesion].[serveradmin_ui

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	62
Created	2:16:16 PM Monday, September 14, 2009
Last Modified	2:16:16 PM Monday, September 14, 2009

Name	Data Type	Max Length (Bytes)
host_id	int	4
servername	varchar(90)	90
ip_address	varchar(300)	300
host_status	varchar(50)	50
osname	varchar(50)	50
accessmode	varchar(20)	20
users	varchar(255)	255
active_users	varchar(50)	50
groups	varchar(255)	255
active_groups	varchar(50)	50
server_groups	varchar(4000)	4000

	Name	Columns	Unique
	PK__serveradmin_ui_t__2F9A1060	host_id

SQL Script

CREATE TABLE [cohesion].[serveradmin_ui_table]
(
[host_id] [int] NOT NULL,
[servername] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ip_address] [varchar] (300) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[host_status] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[osname] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[accessmode] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[users] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[active_users] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[groups] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[active_groups] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[server_groups] [varchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[serveradmin_ui_table] ADD CONSTRAINT [PK__serveradmin_ui_t__2F9A1060] PRIMARY KEY CLUSTERED ([host_id]) ON [PRIMARY]
GO