/* Add OccurrencesThreshold and OccurrencesThresholdIntervalInMins columns for SNMP Traps Alert Rule */
ALTER TABLE [SnmpTrapAlertRule] ADD [OccurrencesThreshold] int NOT NULL
	constraint SnmpTrapAlertRule_OccurrencesThreshold DEFAULT (1) 
GO

ALTER TABLE [SnmpTrapAlertRule] ADD [OccurrencesThresholdIntervalInMins] int NULL
GO

/* Syslog Alert: Changes for Occurrence Tracking */
CREATE TABLE [SyslogAlertRuleOccurrences] (
  [AlertRuleID] int NOT NULL
, [DeviceID] int NOT NULL
, [TimestampTicks] bigint NOT NULL
, [EventCount] int NOT NULL
);
GO

/* SNMP Trap Alert: Changes for Occurrence Tracking */
CREATE TABLE [SnmpTrapAlertRuleOccurrences] (
  [AlertRuleID] int NOT NULL
, [DeviceID] int NOT NULL
, [TimestampTicks] bigint NOT NULL
, [EventCount] int NOT NULL
);
GO	

