vsbridge_product_indexer mview subscription on cataloginventory_stock_status table non-functional after full reindex

[hnsr]

When cataloginventory_stock_status is fully reindexed, the table is swapped with a copy for locking/performance reasons. However, due to this, any triggers set on this table are lost. This means the mview subcription for the vsbridge_product_indexer on this table becomes non-functional

Steps to reproduce:

• Check that cataloginventory_stock_status has triggers (SHOW TRIGGERS LIKE 'cataloginventory_stock_status';)
• Trigger full reindex of cataloginventory_stock index
• Check that cataloginventory_stock_status has triggers, they should now be gone

I am unsure what the correct solution is here, maybe subscribing to index tables isn't the best solution here and we should subscribe to the cataloginventory_stock_item table instead, or find a clean way to ensure triggers are recreated