IF OBJECT_ID(N'dbo.pdd_GoodsQualities', N'U') IS NULL
BEGIN
    THROW 50001, 'dbo.pdd_GoodsQualities does not exist', 1;
END;

IF NOT EXISTS (
    SELECT 1
    FROM sys.indexes
    WHERE object_id = OBJECT_ID(N'dbo.pdd_GoodsQualities')
      AND name = N'IX_pdd_GoodsQualities_goodsId_createTime_id'
)
BEGIN
    CREATE NONCLUSTERED INDEX IX_pdd_GoodsQualities_goodsId_createTime_id
        ON dbo.pdd_GoodsQualities (goodsId, createTime DESC, id DESC)
        INCLUDE (
            qltyRfndOrdrCntRto1m,
            rankQltyRfndOrdrCntRto1mStage,
            rankQltyRfndOrdrCntRto1mStplStage
        );
END;