📋 Detaylı Analiz v4

Migration Taşıma Planı - Tablo Bazlı

29 Aralık 2025

📊 Özet

35
Taşınacak (Tek Modül)
3
Cross-Module (Kalacak)
1
Duplicate (Silinecek)

🛒 Modules/Shop (8 dosya)

Tablolar: shop_products, shop_carts, shop_cart_items, shop_currencies, shop_categories

✓
2025_10_14_000000_create_shop_product_chat_placeholders_table.php
→ shop_product_chat_placeholders
✓
2025_10_30_142400_add_soft_deletes_to_shop_carts_table.php
→ shop_carts, shop_cart_items
✓
2025_10_30_144439_create_shop_currencies_table.php
→ shop_currencies
✓
2025_10_30_144543_add_currency_id_to_shop_tables.php
→ shop_products, shop_carts, shop_cart_items
✓
2025_10_30_185655_rename_currency_to_currency_code_in_shop_carts_table.php
→ shop_carts
✓
2025_10_30_200601_add_is_auto_update_to_shop_currencies_table.php
→ shop_currencies
✓
2025_10_30_211814_add_last_updated_at_to_shop_currencies_table.php
→ shop_currencies
⚠
2025_11_23_000001_rename_shop_tables_to_universal.php
→ CROSS-MODULE: subscription_plans, subscriptions, coupons, coupon_usages, customer_addresses
Karar: Shop'ta kalabilir (eski shop_ tablolarını rename ediyor)

🛍️ Modules/Cart (3 dosya)

Tablolar: carts, cart_items, orders, addresses, cart_addresses

⚠️ NOT: shop_carts ≠ carts (farklı tablolar!)

✓
2025_11_14_060949_add_display_and_currency_fields_to_cart_items.php
→ cart_items (Cart modülü tablosu)
✓
2025_11_14_062634_add_address_fields_to_carts.php
→ carts (Cart modülü tablosu)
✓
2025_12_12_041443_add_indexes_for_slow_queries_cart_addresses.php
→ cart_addresses (Cart modülü tablosu)

🎵 Modules/Muzibu (10 dosya)

Tablolar: muzibu_*, songs, albums, artists, playlists, genres, sectors, radios, song_plays

✓
2025_11_10_223740_add_description_to_muzibu_sectors_table.php
→ muzibu_sectors
✓
2025_11_11_050254_add_hls_fields_to_muzibu_songs_table.php
→ muzibu_songs
✓
2025_11_12_001526_add_search_indexes_to_muzibu_tables.php
→ muzibu_songs, muzibu_artists, muzibu_albums, vb.
✓
2025_11_24_000001_create_muzibu_corporate_accounts_table.php
→ muzibu_corporate_accounts
✓
2025_11_29_040130_add_encryption_to_songs.php
→ muzibu_songs
ℹ
2025_12_05_201240_add_last_played_song_to_users_table.php
→ users tablosu AMA Muzibu feature (last_played_song_id)
Karar: Muzibu'ya git (feature-specific)
✓
2025_12_06_042550_drop_metadata_from_muzibu_songs_table.php
→ muzibu_songs
✓
2025_12_06_044035_drop_redundant_fields_from_muzibu_songs.php
→ muzibu_songs
✓
2025_12_06_044715_drop_virtual_search_columns_from_muzibu_tables.php
→ muzibu_songs, muzibu_artists, vb.
✓
2025_12_29_203727_add_browser_platform_to_song_plays.php
→ song_plays

🔍 Modules/SeoManagement (3 dosya)

Tablolar: seo_settings

✓
2025_07_19_000001_create_seo_settings_table.php
→ seo_settings
✓
2025_07_19_000002_create_tenant_seo_settings_table.php
→ seo_settings (tenant version)
✓
2025_11_15_163014_add_author_fields_to_seo_settings_table.php
→ seo_settings

🖼️ Modules/MediaManagement (3 dosya)

Tablolar: media

✓
2025_02_15_192501_create_media_table.php
→ media
✗
2025_02_15_192502_create_media_table.php
→ DUPLICATE - SİLİNECEK
✓
2025_10_18_200441_fix_media_table_id_auto_increment.php
→ media
✓
2025_11_15_004152_add_ai_generation_fields_to_media_library_items_table.php
→ media

🔎 Modules/Search (5 dosya)

Tablolar: search_queries

✓
2025_10_18_210135_create_search_queries_table.php
✓
2025_10_18_215152_add_is_visible_to_search_queries.php
✓
2025_10_22_035611_add_popular_and_hidden_columns_to_search_queries_table.php
✓
2025_10_22_041315_add_indexes_to_search_queries_new_columns.php
✓
2025_10_29_031319_add_slug_to_search_queries_table.php

📦 Modules/WidgetManagement (2 dosya)

Tablolar: tenant_widgets, widget_items

✓
2025_12_04_024730_add_position_and_indexes_to_tenant_widgets_table.php
✓
2025_12_04_024805_add_indexes_to_widget_items_table.php

📝 Modules/Blog (1 dosya)

Tablolar: blogs, blog_ai_drafts

✓
2025_11_14_050744_create_blog_ai_drafts_table.php

📧 Modules/Mail (1 dosya)

Tablolar: mail_templates

✓
2025_11_24_061210_add_display_order_to_mail_templates_table.php

💳 Modules/Subscription (3 dosya)

Tablolar: subscriptions, subscription_plans

ℹ
2025_12_23_050000_add_subscription_expires_at_to_users_table.php
→ users tablosu AMA Subscription feature
✓
2025_12_23_050001_update_subscriptions_status_column.php
→ subscriptions
✓
2025_12_23_060000_add_subscription_expires_at_to_tenant_users_table.php
→ users (tenant)

⚠️ KALACAK - Cross-Module (3 dosya)

Birden fazla modülü etkileyen dosyalar database/migrations'da kalacak:

2025_11_30_000258_add_performance_indexes_to_shop_products_and_blogs.php
→ shop_products (Shop) + blogs (Blog) + sessions (Core)
2025_11_23_000001_rename_shop_tables_to_universal.php
→ subscription_plans, subscriptions, coupons, coupon_usages, customer_addresses
Alternatif: Shop'a taşınabilir (eski shop_ tablolarını rename)
2025_12_12_041445_add_indexes_for_slow_queries_activity_log.php
→ activity_log (Core tablo)

📋 Final Özet Tablosu

Modül Dosya Tablolar
🛒 Shop8shop_products, shop_carts, shop_cart_items, shop_currencies
🛍️ Cart3carts, cart_items, cart_addresses
🎵 Muzibu10muzibu_*, song_plays, users (feature)
🔍 SeoManagement3seo_settings
🖼️ MediaManagement3media
🔎 Search5search_queries
📦 WidgetManagement2tenant_widgets, widget_items
📝 Blog1blog_ai_drafts
📧 Mail1mail_templates
💳 Subscription3subscriptions, users (feature)
⚠️ Cross-Module3Kalacak
🗑️ Duplicate1Silinecek
TOPLAM43

✅ Onay

Plan doğru mu? "UYGUNDUR" dersen taşımaya başlayalım.

Dikkat: Her dosya hem ana klasöre hem tenant/ klasörüne kopyalanacak.