tests: fix 'a foreign key constraint fails' when running tests on mysql

UserNotification needs to be deleted before Notification because there are
foreign key references in UserNotification to Notification.