Revert "Revert "Add transactional tests. Remove #reset_database. Add random order.""

This reverts commit 85eef29db24167148e506a1c6a910d45810164f8.
continuing to work on transactional tests.
Fix failing mysql tests

mysql doesn't allow creating a table in a transaction.  Tests with table
creation are done outside of a transaction and manually cleaned up.
Fixing mysql tests:  missed one
Clean up after messy apps controller test

It had to be non-transactional because of after commit hooks, and was
creating a user behind the scenes.  All better now.
probably fixes cc tests

reset database after every non-transactional test case
make one more test case non-transactional
Last attempt at fixing the parallel specs. Promise