CREATE TABLE [cohesion].[cdnodesconfdatatab_ui_table]
(
[difftext] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[changetext] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[description] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[compname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[refcompname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[comprefr] [datetime] NULL,
[refcomprefr] [datetime] NULL,
[parcompname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[nodeid] [int] NULL,
[refnodeid] [int] NULL,
[compid] [int] NULL,
[nodename] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[refnodename] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[compnameversionnest] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[category] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[query] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[type] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[db] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[dbserver] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[name] [varchar] (90) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[value] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[refvalue] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[rowkeyid] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [cohesion].[cdnodesconfdatatab_ui_table] ADD CONSTRAINT [PK__cdnodesconfdatat__72910220] PRIMARY KEY CLUSTERED ([rowkeyid]) ON [PRIMARY]
GO