# Generated by Django 4.2.13 on 2025-08-12 10:30 from django.conf import settings from django.db import migrations, models import django.db.models.deletion import uuid class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('campaigns', '0001_initial'), ] operations = [ migrations.CreateModel( name='VastResponseGo', fields=[ ('created_at', models.DateTimeField(auto_now_add=True, help_text='Timestamp when this object was created', verbose_name='Created At')), ('updated_at', models.DateTimeField(auto_now=True, help_text='Timestamp when this object was last modified', verbose_name='Updated At')), ('id', models.UUIDField(default=uuid.uuid4, editable=False, help_text='Unique identifier for this object', primary_key=True, serialize=False)), ('is_deleted', models.BooleanField(default=False, help_text='Whether this object has been soft-deleted', verbose_name='Is Deleted')), ('deleted_at', models.DateTimeField(blank=True, help_text='Timestamp when this object was soft-deleted', null=True, verbose_name='Deleted At')), ('ad_id', models.CharField(blank=True, db_column='AD_id', max_length=20, null=True)), ('tracking_start', models.TextField(blank=True, db_column='Tracking_start', null=True)), ('tracking_firstquartile', models.TextField(blank=True, db_column='Tracking_firstQuartile', null=True)), ('tracking_midpoint', models.TextField(blank=True, db_column='Tracking_midpoint', null=True)), ('tracking_thirdquartile', models.TextField(blank=True, db_column='Tracking_thirdQuartile', null=True)), ('tracking_complete', models.TextField(blank=True, db_column='Tracking_complete', null=True)), ('impression_double_click', models.TextField(blank=True, null=True)), ('impression_sprintserve', models.TextField(blank=True, null=True)), ('tracking_start_status', models.TextField(blank=True, null=True)), ('tracking_firstquartile_status', models.TextField(blank=True, null=True)), ('tracking_midpoint_status', models.TextField(blank=True, null=True)), ('tracking_thirdquartile_status', models.TextField(blank=True, null=True)), ('impression_sprintserve_status', models.TextField(blank=True, null=True)), ('impression_double_click_status', models.TextField(blank=True, null=True)), ('tracking_completed_status', models.TextField(blank=True, null=True)), ('datetime_timestamp', models.DateTimeField(blank=True, null=True)), ('datetime_string', models.CharField(blank=True, max_length=20, null=True)), ('status', models.TextField(blank=True, null=True)), ('vast_url', models.TextField(blank=True, null=True)), ('media_file', models.TextField(blank=True, null=True)), ('adspot_link', models.TextField(blank=True, null=True)), ('ad_spot', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='campaigns.adspots')), ('created_by', models.ForeignKey(blank=True, help_text='User who created this object', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_created', to=settings.AUTH_USER_MODEL, verbose_name='Created By')), ('deleted_by', models.ForeignKey(blank=True, help_text='User who soft-deleted this object', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_deleted', to=settings.AUTH_USER_MODEL, verbose_name='Deleted By')), ('updated_by', models.ForeignKey(blank=True, help_text='User who last modified this object', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_updated', to=settings.AUTH_USER_MODEL, verbose_name='Updated By')), ], options={ 'db_table': 'VAST_response_GO', }, ), migrations.CreateModel( name='VastResponse2910', fields=[ ('created_at', models.DateTimeField(auto_now_add=True, help_text='Timestamp when this object was created', verbose_name='Created At')), ('updated_at', models.DateTimeField(auto_now=True, help_text='Timestamp when this object was last modified', verbose_name='Updated At')), ('id', models.UUIDField(default=uuid.uuid4, editable=False, help_text='Unique identifier for this object', primary_key=True, serialize=False)), ('is_deleted', models.BooleanField(default=False, help_text='Whether this object has been soft-deleted', verbose_name='Is Deleted')), ('deleted_at', models.DateTimeField(blank=True, help_text='Timestamp when this object was soft-deleted', null=True, verbose_name='Deleted At')), ('ad_id', models.CharField(blank=True, db_column='AD_id', max_length=20, null=True)), ('tracking_start', models.TextField(blank=True, db_column='Tracking_start', null=True)), ('tracking_firstquartile', models.TextField(blank=True, db_column='Tracking_firstQuartile', null=True)), ('tracking_midpoint', models.TextField(blank=True, db_column='Tracking_midpoint', null=True)), ('tracking_thirdquartile', models.TextField(blank=True, db_column='Tracking_thirdQuartile', null=True)), ('tracking_complete', models.TextField(blank=True, db_column='Tracking_complete', null=True)), ('datetime_timestamp', models.DateTimeField(blank=True, null=True)), ('datetime_string', models.CharField(blank=True, max_length=20, null=True)), ('status', models.TextField(blank=True, null=True)), ('vast_url', models.TextField(blank=True, null=True)), ('impression_double_click', models.TextField(blank=True, null=True)), ('impression_sprintserve', models.TextField(blank=True, null=True)), ('tracking_start_status', models.TextField(blank=True, null=True)), ('tracking_firstquartile_status', models.TextField(blank=True, null=True)), ('tracking_midpoint_status', models.TextField(blank=True, null=True)), ('tracking_thirdquartile_status', models.TextField(blank=True, null=True)), ('impression_sprintserve_status', models.TextField(blank=True, null=True)), ('impression_double_click_status', models.TextField(blank=True, null=True)), ('tracking_completed_status', models.TextField(blank=True, null=True)), ('media_file', models.TextField(blank=True, null=True)), ('adspot_link', models.TextField(blank=True, null=True)), ('created_by', models.ForeignKey(blank=True, help_text='User who created this object', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_created', to=settings.AUTH_USER_MODEL, verbose_name='Created By')), ('deleted_by', models.ForeignKey(blank=True, help_text='User who soft-deleted this object', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_deleted', to=settings.AUTH_USER_MODEL, verbose_name='Deleted By')), ('updated_by', models.ForeignKey(blank=True, help_text='User who last modified this object', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_updated', to=settings.AUTH_USER_MODEL, verbose_name='Updated By')), ], options={ 'db_table': 'VAST_RESPONSE_29_10', }, ), migrations.CreateModel( name='VastResponse', fields=[ ('created_at', models.DateTimeField(auto_now_add=True, help_text='Timestamp when this object was created', verbose_name='Created At')), ('updated_at', models.DateTimeField(auto_now=True, help_text='Timestamp when this object was last modified', verbose_name='Updated At')), ('id', models.UUIDField(default=uuid.uuid4, editable=False, help_text='Unique identifier for this object', primary_key=True, serialize=False)), ('is_deleted', models.BooleanField(default=False, help_text='Whether this object has been soft-deleted', verbose_name='Is Deleted')), ('deleted_at', models.DateTimeField(blank=True, help_text='Timestamp when this object was soft-deleted', null=True, verbose_name='Deleted At')), ('ad_id', models.CharField(blank=True, db_column='AD_id', max_length=20, null=True)), ('tracking_start', models.TextField(blank=True, db_column='Tracking_start', null=True)), ('tracking_firstquartile', models.TextField(blank=True, db_column='Tracking_firstQuartile', null=True)), ('tracking_midpoint', models.TextField(blank=True, db_column='Tracking_midpoint', null=True)), ('tracking_thirdquartile', models.TextField(blank=True, db_column='Tracking_thirdQuartile', null=True)), ('tracking_complete', models.TextField(blank=True, db_column='Tracking_complete', null=True)), ('datetime_timestamp', models.DateTimeField(blank=True, null=True)), ('datetime_string', models.CharField(blank=True, max_length=20, null=True)), ('status', models.TextField(blank=True, null=True)), ('vast_url', models.TextField(blank=True, null=True)), ('impression_double_click', models.TextField(blank=True, null=True)), ('impression_sprintserve', models.TextField(blank=True, null=True)), ('tracking_start_status', models.TextField(blank=True, null=True)), ('tracking_firstquartile_status', models.TextField(blank=True, null=True)), ('tracking_midpoint_status', models.TextField(blank=True, null=True)), ('tracking_thirdquartile_status', models.TextField(blank=True, null=True)), ('impression_sprintserve_status', models.TextField(blank=True, null=True)), ('impression_double_click_status', models.TextField(blank=True, null=True)), ('tracking_completed_status', models.TextField(blank=True, null=True)), ('ad_spot', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='vast_responses', to='campaigns.adspots')), ('created_by', models.ForeignKey(blank=True, help_text='User who created this object', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_created', to=settings.AUTH_USER_MODEL, verbose_name='Created By')), ('deleted_by', models.ForeignKey(blank=True, help_text='User who soft-deleted this object', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_deleted', to=settings.AUTH_USER_MODEL, verbose_name='Deleted By')), ('updated_by', models.ForeignKey(blank=True, help_text='User who last modified this object', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_updated', to=settings.AUTH_USER_MODEL, verbose_name='Updated By')), ], options={ 'db_table': 'VAST_response', }, ), migrations.CreateModel( name='Trackinglink', fields=[ ('created_at', models.DateTimeField(auto_now_add=True, help_text='Timestamp when this object was created', verbose_name='Created At')), ('updated_at', models.DateTimeField(auto_now=True, help_text='Timestamp when this object was last modified', verbose_name='Updated At')), ('id', models.UUIDField(default=uuid.uuid4, editable=False, help_text='Unique identifier for this object', primary_key=True, serialize=False)), ('is_deleted', models.BooleanField(default=False, help_text='Whether this object has been soft-deleted', verbose_name='Is Deleted')), ('deleted_at', models.DateTimeField(blank=True, help_text='Timestamp when this object was soft-deleted', null=True, verbose_name='Deleted At')), ('spot', models.CharField(max_length=250)), ('url', models.CharField(max_length=500)), ('status_code', models.IntegerField(blank=True, null=True)), ('request_count', models.IntegerField(blank=True, null=True)), ('created_by', models.ForeignKey(blank=True, help_text='User who created this object', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_created', to=settings.AUTH_USER_MODEL, verbose_name='Created By')), ('deleted_by', models.ForeignKey(blank=True, help_text='User who soft-deleted this object', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_deleted', to=settings.AUTH_USER_MODEL, verbose_name='Deleted By')), ('updated_by', models.ForeignKey(blank=True, help_text='User who last modified this object', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_updated', to=settings.AUTH_USER_MODEL, verbose_name='Updated By')), ], options={ 'db_table': 'TrackingLink', }, ), migrations.CreateModel( name='AlmaAds', fields=[ ('created_at', models.DateTimeField(auto_now_add=True, help_text='Timestamp when this object was created', verbose_name='Created At')), ('updated_at', models.DateTimeField(auto_now=True, help_text='Timestamp when this object was last modified', verbose_name='Updated At')), ('id', models.UUIDField(default=uuid.uuid4, editable=False, help_text='Unique identifier for this object', primary_key=True, serialize=False)), ('is_deleted', models.BooleanField(default=False, help_text='Whether this object has been soft-deleted', verbose_name='Is Deleted')), ('deleted_at', models.DateTimeField(blank=True, help_text='Timestamp when this object was soft-deleted', null=True, verbose_name='Deleted At')), ('name', models.CharField(blank=True, max_length=255, null=True)), ('ads_path', models.CharField(blank=True, max_length=255, null=True)), ('duration', models.CharField(blank=True, max_length=255, null=True)), ('created_by', models.ForeignKey(blank=True, help_text='User who created this object', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_created', to=settings.AUTH_USER_MODEL, verbose_name='Created By')), ('deleted_by', models.ForeignKey(blank=True, help_text='User who soft-deleted this object', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_deleted', to=settings.AUTH_USER_MODEL, verbose_name='Deleted By')), ('updated_by', models.ForeignKey(blank=True, help_text='User who last modified this object', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_updated', to=settings.AUTH_USER_MODEL, verbose_name='Updated By')), ], options={ 'db_table': 'Alma_Ads', }, ), migrations.CreateModel( name='AdslotsVisionr', fields=[ ('created_at', models.DateTimeField(auto_now_add=True, help_text='Timestamp when this object was created', verbose_name='Created At')), ('updated_at', models.DateTimeField(auto_now=True, help_text='Timestamp when this object was last modified', verbose_name='Updated At')), ('id', models.UUIDField(default=uuid.uuid4, editable=False, help_text='Unique identifier for this object', primary_key=True, serialize=False)), ('is_deleted', models.BooleanField(default=False, help_text='Whether this object has been soft-deleted', verbose_name='Is Deleted')), ('deleted_at', models.DateTimeField(blank=True, help_text='Timestamp when this object was soft-deleted', null=True, verbose_name='Deleted At')), ('adid', models.CharField(db_column='AdId', max_length=255)), ('subid', models.CharField(db_column='SubId', max_length=255)), ('start', models.TimeField(db_column='Start')), ('end', models.TimeField(blank=True, db_column='End', null=True)), ('startts', models.BigIntegerField(blank=True, db_column='StartTs', null=True)), ('endts', models.BigIntegerField(blank=True, db_column='EndTs', null=True)), ('cut', models.IntegerField(blank=True, db_column='Cut', null=True)), ('scenario', models.TextField(blank=True, db_column='Scenario', null=True)), ('duration', models.IntegerField(blank=True, db_column='Duration', null=True)), ('ispub', models.IntegerField(blank=True, db_column='IsPub', null=True)), ('title', models.TextField(blank=True, db_column='Title', null=True)), ('replacementadid', models.CharField(blank=True, db_column='ReplacementAdId', max_length=255, null=True)), ('replacementpath', models.CharField(blank=True, db_column='ReplacementPath', max_length=255, null=True)), ('replacementduration', models.IntegerField(blank=True, db_column='ReplacementDuration', null=True)), ('status', models.CharField(blank=True, db_column='Status', max_length=50, null=True)), ('updatesent', models.IntegerField(blank=True, db_column='UpdateSent', null=True)), ('playlistdate', models.DateField(blank=True, db_column='PlaylistDate', null=True)), ('channel_id', models.IntegerField(blank=True, db_column='Channel_ID', null=True)), ('created_by', models.ForeignKey(blank=True, help_text='User who created this object', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_created', to=settings.AUTH_USER_MODEL, verbose_name='Created By')), ('deleted_by', models.ForeignKey(blank=True, help_text='User who soft-deleted this object', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_deleted', to=settings.AUTH_USER_MODEL, verbose_name='Deleted By')), ('updated_by', models.ForeignKey(blank=True, help_text='User who last modified this object', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='%(class)s_updated', to=settings.AUTH_USER_MODEL, verbose_name='Updated By')), ], options={ 'db_table': 'AdSlots_VisionR', 'unique_together': {('subid', 'playlistdate')}, }, ), ]