Add IsOnEventMap flag to Event Types

[kutting]

Currently, the Mozu.EventMap2Get stored proc specifically filters event ids. So when new event types are created they may not flow to the event map without changing the code. Instead, add a flag to the Event.EventType table to indicate whether or not the event should be on the map. Change the CRUD in the Event Manager to manage the flag, and change the Stored Proc to check the flag instead of the event ids.

[kutting]

alter table event.eventtype add IsOnEventMap bit

update event.eventtype set IsOnEventMap = 0 update event.eventtype set IsOnEventMap = 1 where EventTypeId in ( 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1010, 1011, 1023, 1026, 1032, 1033, 1034)

ALTER TABLE event.eventtype ALTER COLUMN IsOnEventMap bit NOT NULL

[kutting]

Event.EventTypeInsert Event.EventTypeUpdate Event.EventTypeGet Mozu.EventMap2Get