# Generated manually - SQL migration to force creation of translation fields
from django.db import migrations


class Migration(migrations.Migration):

    dependencies = [
        ('core', '0002_add_service_translation_fields'),
    ]

    operations = [
        # Utiliser RunSQL pour forcer la création des colonnes
        migrations.RunSQL(
            # SQL pour créer les colonnes
            sql="""
            ALTER TABLE core_service ADD COLUMN titre_fr VARCHAR(200);
            ALTER TABLE core_service ADD COLUMN titre_en VARCHAR(200);
            ALTER TABLE core_service ADD COLUMN description_courte_fr TEXT;
            ALTER TABLE core_service ADD COLUMN description_courte_en TEXT;
            ALTER TABLE core_service ADD COLUMN description_complete_fr TEXT;
            ALTER TABLE core_service ADD COLUMN description_complete_en TEXT;
            """,
            # SQL pour supprimer les colonnes (pour reverse migration)
            reverse_sql="""
            ALTER TABLE core_service DROP COLUMN titre_fr;
            ALTER TABLE core_service DROP COLUMN titre_en;
            ALTER TABLE core_service DROP COLUMN description_courte_fr;
            ALTER TABLE core_service DROP COLUMN description_courte_en;
            ALTER TABLE core_service DROP COLUMN description_complete_fr;
            ALTER TABLE core_service DROP COLUMN description_complete_en;
            """,
        ),
    ]