# Generated by Django 5.0.14 on 2026-02-04 22:11

import colorfield.fields
import django.db.models.deletion
import django_ckeditor_5.fields
import image_factory.models
import traduction.mixins
from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('config', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='University',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('order', models.PositiveSmallIntegerField(default=0, verbose_name='Order')),
                ('created_at', models.DateTimeField(auto_now_add=True)),
                ('updated_at', models.DateTimeField(auto_now=True)),
                ('image', models.ImageField(blank=True, null=True, upload_to=image_factory.models.get_image_upload_path, verbose_name='Image')),
                ('name', models.CharField(max_length=200, verbose_name='Nom')),
                ('slug', models.SlugField(blank=True, max_length=200, unique=True, verbose_name='Slug')),
                ('abbreviation', models.CharField(blank=True, max_length=20, verbose_name='Abreviation')),
                ('city', models.CharField(max_length=100, verbose_name='Ville')),
                ('address', models.TextField(blank=True, verbose_name='Adresse complete')),
                ('latitude', models.DecimalField(blank=True, decimal_places=6, max_digits=9, null=True, verbose_name='Latitude')),
                ('longitude', models.DecimalField(blank=True, decimal_places=6, max_digits=9, null=True, verbose_name='Longitude')),
                ('logo', models.ImageField(blank=True, null=True, upload_to='universities/logos/', verbose_name='Logo')),
                ('description', django_ckeditor_5.fields.CKEditor5Field(verbose_name='Description')),
                ('short_description', models.CharField(blank=True, max_length=300, verbose_name='Description courte')),
                ('website', models.URLField(blank=True, verbose_name='Site web')),
                ('email', models.EmailField(blank=True, max_length=254, verbose_name='Email')),
                ('phone', models.CharField(blank=True, max_length=30, verbose_name='Telephone')),
                ('founded_year', models.PositiveIntegerField(blank=True, null=True, verbose_name='Annee de fondation')),
                ('ranking_position', models.PositiveIntegerField(blank=True, null=True, verbose_name='Classement mondial')),
                ('is_coordinator', models.BooleanField(default=False, verbose_name='Universite coordinatrice')),
                ('is_active', models.BooleanField(default=True, verbose_name='Active')),
                ('color', colorfield.fields.ColorField(default='#1e3a5f', image_field=None, max_length=25, samples=None, verbose_name='Couleur')),
                ('country', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='Pays', to='config.country', verbose_name="Pays de l'Universite")),
            ],
            options={
                'verbose_name': 'Universite',
                'verbose_name_plural': 'Universites',
                'ordering': ['order', 'name'],
            },
            bases=(traduction.mixins.TranslatableMixin, models.Model),
        ),
        migrations.CreateModel(
            name='IndustrialPartner',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('order', models.PositiveSmallIntegerField(default=0, verbose_name='Order')),
                ('name', models.CharField(max_length=200, verbose_name='Nom')),
                ('logo', models.ImageField(blank=True, null=True, upload_to='partners/industrial/', verbose_name='Logo')),
                ('website', models.URLField(blank=True, verbose_name='Site web')),
                ('description', models.TextField(blank=True, verbose_name='Description')),
                ('is_active', models.BooleanField(default=True, verbose_name='Actif')),
                ('universities', models.ManyToManyField(blank=True, related_name='industrial_partners', to='universities.university', verbose_name='Universites partenaires')),
            ],
            options={
                'verbose_name': 'Partenaire industriel',
                'verbose_name_plural': 'Partenaires industriels',
                'ordering': ['order', 'name'],
            },
            bases=(traduction.mixins.TranslatableMixin, models.Model),
        ),
        migrations.CreateModel(
            name='UniversityDepartment',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('name', models.CharField(max_length=200, verbose_name='Nom du departement')),
                ('description', models.TextField(blank=True, verbose_name='Description')),
                ('specialization', models.CharField(blank=True, max_length=200, verbose_name='Specialisation')),
                ('website', models.URLField(blank=True, verbose_name='Site web')),
                ('university', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='departments', to='universities.university', verbose_name='Universite')),
            ],
            options={
                'verbose_name': 'Departement',
                'verbose_name_plural': 'Departements',
                'ordering': ['university', 'name'],
            },
            bases=(traduction.mixins.TranslatableMixin, models.Model),
        ),
        migrations.CreateModel(
            name='UniversityStatistic',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('value', models.PositiveIntegerField(verbose_name='Valeur')),
                ('year', models.PositiveIntegerField(blank=True, null=True, verbose_name='Annee')),
                ('stat_type', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='university_statistics', to='config.stattype', verbose_name='Type de statistique')),
                ('university', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='statistics', to='universities.university', verbose_name='Universite')),
            ],
            options={
                'verbose_name': 'Statistique universite',
                'verbose_name_plural': 'Statistiques universites',
                'unique_together': {('university', 'stat_type', 'year')},
            },
        ),
    ]