Adds a test to ensure that dropping a table is transactional

[cloutiertyler]

Description of Changes

This adds a test to ensure that dropping a table is transactional and can be rolled back.

This is currently failing and should be made to pass.

API and ABI breaking changes

If this is an API or ABI breaking change, please apply the corresponding GitHub label.

Expected complexity level and risk

How complicated do you think these changes are? Grade on a scale from 1 to 5, where 1 is a trivial change, and 5 is a deep-reaching and complex change.

1

[CLAassistant]

All committers have signed the CLA.

[Centril]

I've updated the tests here to compile with the latest master and I've cherry-picked the tests over to https://github.com/clockworklabs/SpacetimeDB/pull/2685 which make the tests pass.