# Generated by Django 5.0.1 on 2025-10-04 02:27 import django.contrib.auth.models import django.contrib.auth.validators import django.core.validators import django.db.models.deletion import uuid from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0012_alter_user_first_name_max_length'), ] operations = [ migrations.CreateModel( name='Category', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('name', models.CharField(max_length=100)), ('slug', models.SlugField(unique=True)), ('icon', models.ImageField(blank=True, null=True, upload_to='categories/')), ('order', models.IntegerField(default=0)), ], options={ 'verbose_name': 'Catégorie', 'verbose_name_plural': 'Catégories', 'ordering': ['order', 'name'], }, ), migrations.CreateModel( name='Exhibition', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('title', models.CharField(max_length=200)), ('slug', models.SlugField(unique=True)), ('start_date', models.DateField()), ('end_date', models.DateField()), ('is_active', models.BooleanField(default=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ], options={ 'verbose_name': 'Exposition', 'verbose_name_plural': 'Expositions', 'ordering': ['-start_date'], }, ), migrations.CreateModel( name='Language', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('code', models.CharField(max_length=5, unique=True)), ('name', models.CharField(max_length=50)), ('native_name', models.CharField(max_length=50)), ('is_active', models.BooleanField(default=True)), ('order', models.IntegerField(default=0)), ], options={ 'verbose_name': 'Langue', 'verbose_name_plural': 'Langues', 'ordering': ['order', 'name'], }, ), migrations.CreateModel( name='VirtualRoom', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('name', models.CharField(max_length=200)), ('slug', models.SlugField(unique=True)), ('description', models.TextField(blank=True)), ('floor', models.IntegerField(default=0)), ('order', models.IntegerField(default=0)), ('panorama_image', models.ImageField(help_text='Image panoramique 360°', upload_to='virtual_tour/panoramas/')), ('thumbnail', models.ImageField(blank=True, upload_to='virtual_tour/thumbnails/')), ('ambient_audio', models.FileField(blank=True, upload_to='virtual_tour/audio/')), ('is_entrance', models.BooleanField(default=False)), ('is_active', models.BooleanField(default=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ], options={ 'verbose_name': 'Salle virtuelle', 'verbose_name_plural': 'Salles virtuelles', 'ordering': ['floor', 'order'], }, ), migrations.CreateModel( name='User', fields=[ ('password', models.CharField(max_length=128, verbose_name='password')), ('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')), ('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')), ('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')), ('first_name', models.CharField(blank=True, max_length=150, verbose_name='first name')), ('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')), ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('role', models.CharField(choices=[('visitor', 'Visiteur'), ('content_moderator', 'Modérateur Contenu'), ('museum_admin', 'Administrateur Musée')], default='visitor', max_length=20)), ('date_joined', models.DateTimeField(auto_now_add=True)), ('is_active', models.BooleanField(default=True)), ('preferred_language', models.CharField(default='fr', max_length=5)), ('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.group', verbose_name='groups')), ('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.permission', verbose_name='user permissions')), ], options={ 'verbose_name': 'Utilisateur', 'verbose_name_plural': 'Utilisateurs', }, managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.CreateModel( name='Artwork', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('reference_code', models.CharField(max_length=50, unique=True)), ('qr_code', models.ImageField(blank=True, null=True, upload_to='artworks/qr_codes/')), ('origin', models.CharField(blank=True, max_length=200)), ('period', models.CharField(blank=True, max_length=100)), ('acquisition_date', models.DateField(blank=True, null=True)), ('status', models.CharField(choices=[('draft', 'Brouillon'), ('published', 'Publié'), ('archived', 'Archivé')], default='draft', max_length=20)), ('is_published', models.BooleanField(default=False)), ('is_featured', models.BooleanField(default=False)), ('view_count', models.IntegerField(default=0)), ('favorites_count', models.IntegerField(default=0)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('created_by', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='created_artworks', to=settings.AUTH_USER_MODEL)), ('category', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='artworks', to='artworks.category')), ('exhibitions', models.ManyToManyField(blank=True, related_name='artworks', to='artworks.exhibition')), ], options={ 'verbose_name': 'Œuvre', 'verbose_name_plural': 'Œuvres', 'ordering': ['-created_at'], }, ), migrations.CreateModel( name='ArtworkTranslation', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('language', models.CharField(max_length=5)), ('title', models.CharField(max_length=200)), ('description', models.TextField()), ('historical_context', models.TextField(blank=True)), ('cultural_significance', models.TextField(blank=True)), ('artist', models.CharField(blank=True, max_length=200)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('artwork', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='translations', to='artworks.artwork')), ], options={ 'verbose_name': "Traduction d'œuvre", 'verbose_name_plural': "Traductions d'œuvres", }, ), migrations.CreateModel( name='AudioGuide', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('audio_file', models.FileField(upload_to='artworks/audio/', validators=[django.core.validators.FileExtensionValidator(['mp3', 'wav', 'ogg'])])), ('duration', models.IntegerField(default=0)), ('narrator', models.CharField(blank=True, max_length=100)), ('created_at', models.DateTimeField(auto_now_add=True)), ('artwork_translation', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='audio_guides', to='artworks.artworktranslation')), ], options={ 'verbose_name': 'Guide audio', 'verbose_name_plural': 'Guides audio', }, ), migrations.CreateModel( name='CategoryTranslation', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('language', models.CharField(max_length=5)), ('name', models.CharField(max_length=100)), ('description', models.TextField(blank=True)), ('category', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='translations', to='artworks.category')), ], options={ 'verbose_name': 'Traduction de catégorie', 'verbose_name_plural': 'Traductions de catégories', }, ), migrations.CreateModel( name='Comment', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('content', models.TextField()), ('is_approved', models.BooleanField(default=False)), ('is_flagged', models.BooleanField(default=False)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('artwork', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='comments', to='artworks.artwork')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='comments', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'Commentaire', 'verbose_name_plural': 'Commentaires', 'ordering': ['-created_at'], }, ), migrations.CreateModel( name='ExhibitionTranslation', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('language', models.CharField(max_length=5)), ('title', models.CharField(max_length=200)), ('description', models.TextField()), ('exhibition', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='translations', to='artworks.exhibition')), ], options={ 'verbose_name': "Traduction d'exposition", 'verbose_name_plural': "Traductions d'expositions", }, ), migrations.CreateModel( name='Favorite', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('created_at', models.DateTimeField(auto_now_add=True)), ('artwork', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='favorited_by', to='artworks.artwork')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='favorites', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'Favori', 'verbose_name_plural': 'Favoris', 'ordering': ['-created_at'], }, ), migrations.CreateModel( name='Media', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('media_type', models.CharField(choices=[('image', 'Image'), ('video', 'Vidéo'), ('audio', 'Audio')], max_length=10)), ('file', models.FileField(upload_to='artworks/media/')), ('thumbnail', models.ImageField(blank=True, null=True, upload_to='artworks/thumbnails/')), ('caption', models.CharField(blank=True, max_length=200)), ('size', models.IntegerField(default=0)), ('order', models.IntegerField(default=0)), ('language', models.CharField(blank=True, max_length=5)), ('uploaded_at', models.DateTimeField(auto_now_add=True)), ('artwork', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='media', to='artworks.artwork')), ], options={ 'verbose_name': 'Média', 'verbose_name_plural': 'Médias', 'ordering': ['order', 'uploaded_at'], }, ), migrations.CreateModel( name='Statistics', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('date', models.DateField(unique=True)), ('total_visits', models.IntegerField(default=0)), ('unique_visitors', models.IntegerField(default=0)), ('qr_scans', models.IntegerField(default=0)), ('avg_time_per_artwork', models.FloatField(default=0.0)), ('most_viewed_artwork', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='artworks.artwork')), ], options={ 'verbose_name': 'Statistique', 'verbose_name_plural': 'Statistiques', 'ordering': ['-date'], }, ), migrations.CreateModel( name='RoomVisit', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('entered_at', models.DateTimeField(auto_now_add=True)), ('duration', models.IntegerField(default=0, help_text='Temps passé en secondes')), ('room', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='artworks.virtualroom')), ], options={ 'ordering': ['entered_at'], }, ), migrations.CreateModel( name='RoomConnection', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('hotspot_x', models.FloatField(help_text='Position X du hotspot (0-360 degrés)')), ('hotspot_y', models.FloatField(help_text='Position Y du hotspot (-90 à 90 degrés)')), ('label', models.CharField(help_text='Ex: "Vers la salle des masques"', max_length=100)), ('icon', models.CharField(choices=[('arrow', 'Flèche'), ('door', 'Porte')], default='arrow', max_length=50)), ('from_room', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='exits', to='artworks.virtualroom')), ('to_room', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='entrances', to='artworks.virtualroom')), ], options={ 'verbose_name': 'Connexion entre salles', 'verbose_name_plural': 'Connexions entre salles', }, ), migrations.CreateModel( name='ArtworkHotspot', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('hotspot_x', models.FloatField(help_text='Position X (0-360 degrés)')), ('hotspot_y', models.FloatField(help_text='Position Y (-90 à 90 degrés)')), ('animation_type', models.CharField(choices=[('pulse', 'Pulsation'), ('glow', 'Lueur'), ('bounce', 'Rebond')], default='pulse', max_length=20)), ('is_active', models.BooleanField(default=True)), ('artwork', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='hotspots', to='artworks.artwork')), ('room', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='artwork_hotspots', to='artworks.virtualroom')), ], options={ 'verbose_name': "Hotspot d'œuvre", 'verbose_name_plural': "Hotspots d'œuvres", }, ), migrations.CreateModel( name='VirtualTourSession', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('session_key', models.CharField(max_length=100)), ('started_at', models.DateTimeField(auto_now_add=True)), ('ended_at', models.DateTimeField(blank=True, null=True)), ('duration', models.IntegerField(default=0, help_text='Durée en secondes')), ('device_type', models.CharField(choices=[('desktop', 'Ordinateur'), ('mobile', 'Mobile'), ('tablet', 'Tablette'), ('vr', 'Casque VR')], default='desktop', max_length=20)), ('artworks_viewed', models.ManyToManyField(blank=True, to='artworks.artwork')), ('rooms_visited', models.ManyToManyField(through='artworks.RoomVisit', to='artworks.virtualroom')), ('user', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'Session de tour virtuel', 'verbose_name_plural': 'Sessions de tour virtuel', 'ordering': ['-started_at'], }, ), migrations.AddField( model_name='roomvisit', name='session', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='artworks.virtualtoursession'), ), migrations.CreateModel( name='Visit', fields=[ ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('session_id', models.CharField(blank=True, max_length=100)), ('ip_address', models.GenericIPAddressField(blank=True, null=True)), ('user_agent', models.TextField(blank=True)), ('source', models.CharField(default='web', max_length=20)), ('visited_at', models.DateTimeField(auto_now_add=True)), ('artwork', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='visits', to='artworks.artwork')), ('user', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='visits', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name': 'Visite', 'verbose_name_plural': 'Visites', 'ordering': ['-visited_at'], }, ), migrations.AddIndex( model_name='artworktranslation', index=models.Index(fields=['artwork', 'language'], name='artworks_ar_artwork_141473_idx'), ), migrations.AlterUniqueTogether( name='artworktranslation', unique_together={('artwork', 'language')}, ), migrations.AlterUniqueTogether( name='categorytranslation', unique_together={('category', 'language')}, ), migrations.AddIndex( model_name='artwork', index=models.Index(fields=['reference_code'], name='artworks_ar_referen_52c9e1_idx'), ), migrations.AddIndex( model_name='artwork', index=models.Index(fields=['status', 'is_published'], name='artworks_ar_status_d62249_idx'), ), migrations.AddIndex( model_name='artwork', index=models.Index(fields=['-view_count'], name='artworks_ar_view_co_2fe271_idx'), ), migrations.AlterUniqueTogether( name='exhibitiontranslation', unique_together={('exhibition', 'language')}, ), migrations.AlterUniqueTogether( name='favorite', unique_together={('user', 'artwork')}, ), migrations.AlterUniqueTogether( name='roomconnection', unique_together={('from_room', 'to_room')}, ), migrations.AlterUniqueTogether( name='artworkhotspot', unique_together={('room', 'artwork')}, ), migrations.AddIndex( model_name='visit', index=models.Index(fields=['artwork', '-visited_at'], name='artworks_vi_artwork_c63abe_idx'), ), migrations.AddIndex( model_name='visit', index=models.Index(fields=['user', '-visited_at'], name='artworks_vi_user_id_4f057e_idx'), ), ]