/*
	column
*/
alter table [WindowsEventNT6Monitor]
add
    [DetailsSearchOptions]  ntext	NULL 
go

alter table [WindowsEventNT6AlertRule]
add
    [DetailsSearchOptions]  ntext	null 
go


alter table [WindowsEventNT6Alert]
add
    [Details]					nvarchar(100)			NULL 
go
alter table [WindowsEventNT6Alert]
alter column
    [Details]					ntext			NOT NULL 
go

/*
	PK
*/
alter table [WindowsEventNT6Monitor]
add
	constraint WindowsEventNT6Monitor_PK primary key (WindowsEventNT6MonitorID)
go

alter table WindowsEventNT6MonitorSource
add
	constraint WindowsEventNT6MonitorSource_PK primary key (WindowsEventNT6MonitorID, EventSource)
go


alter table WindowsEventNT6MonitorLevel
add
	constraint WindowsEventNT6MonitorSeverity_PK primary key (WindowsEventNT6MonitorID, LevelID)

go

alter table [WindowsEventNT6AlertRule]
add
	--constraint [WindowsEventNT6AlertRule_PK] primary key clustered ([AlertRuleID]),
	constraint [WindowsEventNT6AlertRule_PK] primary key ([AlertRuleID])
go


alter table [WindowsEventNT6Alert]
add
	constraint WindowsEventNT6Alert_PK primary key (WindowsEventNT6AlertGuid)
go


alter table WindowsEventMonitoringBookmark 
add
	constraint WindowsEventMonitoringBookmark_PK primary key (DeviceID, EventLogName)
go


