-- Spixer API - MySQL Migration - Part 1: Drop All Tables (Updated)

SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `user_roles`;
DROP TABLE IF EXISTS `user_tokens`;
DROP TABLE IF EXISTS `user_refresh_tokens`;
DROP TABLE IF EXISTS `guest_claim_tokens`;
DROP TABLE IF EXISTS `guest_profiles`;
DROP TABLE IF EXISTS `email_change_requests`;
DROP TABLE IF EXISTS `club_memberships`;
DROP TABLE IF EXISTS `registrations`;
DROP TABLE IF EXISTS `user_informations`;
DROP TABLE IF EXISTS `user_favorite_categories`;
DROP TABLE IF EXISTS `event_volunteers`;
DROP TABLE IF EXISTS `rankings`;
DROP TABLE IF EXISTS `checkpoint_assignments`;
DROP TABLE IF EXISTS `ranking_records`;
DROP TABLE IF EXISTS `payments`;
DROP TABLE IF EXISTS `price`;
DROP TABLE IF EXISTS `newsletter_subscribers`;
DROP TABLE IF EXISTS `entity_images`;
DROP TABLE IF EXISTS `stage_checkpoints`;
DROP TABLE IF EXISTS `stages`;
DROP TABLE IF EXISTS `events`;
DROP TABLE IF EXISTS `clubs`;
DROP TABLE IF EXISTS `federations`;
DROP TABLE IF EXISTS `category`;
DROP TABLE IF EXISTS `roles`;
DROP TABLE IF EXISTS `users`;

SET FOREIGN_KEY_CHECKS = 1;