Naive SpecRun statistics store database indices

SpecRun.Indices.sql

use SpecRun

create nonclustered index idx_events on
    [Events] (Id, EventSourceId, Sequence, TimeStamp)
        include (Version, Name, Data)

create nonclustered index idx_eventsources on
    [EventSources] (Id, Type, Version)

create nonclustered index idx_pipelinestate on
    [PipelineState] (PipelineName, BatchId, LastProcessedEventId)

create nonclustered index idx_testitems on
    [TestItems] ([Id], [ProjectId], [LastExecution], [CreatedAt], [LastResult_Code], [State_Code], [SuccessFactor_Value], [SuccessFactor_TrendCode])
        include ([Path], [LastResult_Value], [State_Value], [SuccessFactor_TrendValue], [TestHistory])