005_Indices_verify.mysql

SELECT
    EXISTS (
        SELECT
            *
        FROM
            information_schema.columns
        WHERE
            table_name = 'ftQueueItem' AND column_name = 'cbReceiptReference' AND data_type = 'varchar' AND character_maximum_length = 450
    ) as ftQueueItem_cbReceiptReference_dataType,

    EXISTS (
        SELECT
            index_name
        FROM
            information_schema.statistics
        WHERE
            table_name = 'ftQueueItem'
            and index_name = 'idx_ftQueueItem_Timestamp'
    ) as idx_ftQueueItem_Timestamp,
    
    EXISTS (
        SELECT
            index_name
        FROM
            information_schema.statistics
        WHERE
            table_name = 'ftQueueItem'
            and index_name = 'idx_ftQueueItem_cbReceiptReference'
    ) as idx_ftQueueItem_cbReceiptReference,
    
    EXISTS (
        SELECT
            index_name
        FROM
            information_schema.statistics
        WHERE
            table_name = 'ftActionJournal'
            and index_name = 'idx_ftActionJournal_Timestamp'
    ) as idx_ftActionJournal_Timestamp,

    EXISTS (
        SELECT
            index_name
        FROM
            information_schema.statistics
        WHERE
            table_name = 'ftReceiptJournal'
            and index_name = 'idx_ftReceiptJournal_Timestamp'
    ) as idx_ftReceiptJournal_Timestamp,

    EXISTS (
        SELECT
            index_name
        FROM
            information_schema.statistics
        WHERE
            table_name = 'ftJournalAT'
            and index_name = 'idx_ftJournalAT_Timestamp'
    ) as idx_ftJournalAT_Timestamp,

    EXISTS (
        SELECT
            index_name
        FROM
            information_schema.statistics
        WHERE
            table_name = 'ftJournalDE'
            and index_name = 'idx_ftJournalDE_Timestamp'
    ) as idx_ftJournalDE_Timestamp,

    EXISTS (
        SELECT
            index_name
        FROM
            information_schema.statistics
        WHERE
            table_name = 'ftJournalFR'
            and index_name = 'idx_ftJournalFR_Timestamp'
    ) as idx_ftJournalFR_Timestamp,
    
    (
        SELECT
            IF (CurrentVersion = '005_Indices', true, false)
        FROM
            ftDatabaseSchema
    ) as ftDatabase_schema_version;