if not exists (select * from sys.indexes where name='CI_SubscriptionEvent_EventProcessed_SubscriptionID' AND object_id = OBJECT_ID('dbo.SubscriptionEvent'))
    create clustered index CI_SubscriptionEvent_EventProcessed_SubscriptionID on dbo.SubscriptionEvent (EventProcessed asc, SubscriptionID asc);