SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS alignment_keys;
DROP TABLE IF EXISTS alignments;
DROP TABLE IF EXISTS authkeys;
DROP TABLE IF EXISTS broods;
DROP TABLE IF EXISTS individuals;
DROP TABLE IF EXISTS encryption_keys;
DROP TABLE IF EXISTS organisation_encryption_keys;
DROP TABLE IF EXISTS organisations;
DROP TABLE IF EXISTS roles;
DROP TABLE IF EXISTS sharing_groups;
DROP TABLE IF EXISTS sgo;
DROP TABLE IF EXISTS tags;
DROP TABLE IF EXISTS user_keys;
DROP TABLE IF EXISTS users;
SET FOREIGN_KEY_CHECKS=1;