-- along with MoLe. If not, see <https://www.gnu.org/licenses/>.
pragma foreign_keys=off;
delete from transaction_accounts where not exists (select 1 from accounts a where a.profile=transaction_accounts.profile and a.name=transaction_accounts.account_name);
-- along with MoLe. If not, see <https://www.gnu.org/licenses/>.
pragma foreign_keys=off;
delete from transaction_accounts where not exists (select 1 from accounts a where a.profile=transaction_accounts.profile and a.name=transaction_accounts.account_name);