-- Migration: Drop old tables for megido72-portal.com
-- Description: Clean up old ballers.jp tables before creating new megido72 tables

DROP TABLE IF EXISTS blog_posts CASCADE;
DROP TABLE IF EXISTS articles CASCADE;
DROP TABLE IF EXISTS categories CASCADE;
DROP TABLE IF EXISTS newsletter_subscribers CASCADE;

-- Drop old indexes if they exist
DROP INDEX IF EXISTS idx_articles_slug;
DROP INDEX IF EXISTS idx_articles_external_id;
DROP INDEX IF EXISTS idx_articles_category;
DROP INDEX IF EXISTS idx_articles_publication_date;
DROP INDEX IF EXISTS idx_articles_featured;
DROP INDEX IF EXISTS idx_articles_is_active;
DROP INDEX IF EXISTS idx_articles_reading_time;
DROP INDEX IF EXISTS idx_articles_content_hash;
DROP INDEX IF EXISTS idx_articles_language;
DROP INDEX IF EXISTS idx_articles_word_count;
DROP INDEX IF EXISTS idx_categories_external_id;
DROP INDEX IF EXISTS idx_categories_slug;
DROP INDEX IF EXISTS idx_categories_japanese;
DROP INDEX IF EXISTS idx_newsletter_email;
DROP INDEX IF EXISTS idx_newsletter_active;
