[cohesion].[serveradmin_ui

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	61
Created	9:08:38 PM Wednesday, August 20, 2008
Last Modified	9:08:39 PM Wednesday, August 20, 2008

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

	Name	Columns	Unique
	PK__serveradmin_ui_t__74794A92	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] (50) 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] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[groups] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[active_groups] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [cohesion].[serveradmin_ui_table] ADD CONSTRAINT [PK__serveradmin_ui_t__74794A92] PRIMARY KEY CLUSTERED ([host_id]) ON [PRIMARY]
GO