# Generated by Django 3.2.7 on 2021-10-07 16:40 from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ] operations = [ migrations.CreateModel( name='Adbreak_history', fields=[ ('id_adbreak_history', models.AutoField(primary_key=True, serialize=False)), ('datetime', models.DateTimeField(blank=True, null=True)), ('day', models.DateField(blank=True, null=True)), ('time', models.TimeField(blank=True, null=True)), ('channel_name', models.CharField(blank=True, max_length=255, null=True)), ('duration', models.CharField(blank=True, max_length=255, null=True)), ], options={ 'db_table': 'Adbreak_history', 'managed': False, }, ), migrations.CreateModel( name='AdbreakHistory', fields=[ ('id_adbreak_history', models.AutoField(primary_key=True, serialize=False)), ('id_channel', models.IntegerField()), ('datetime', models.DateTimeField()), ('day', models.CharField(max_length=255)), ('time', models.CharField(max_length=255)), ('channel_name', models.CharField(max_length=255)), ('duration', models.CharField(max_length=255)), ], options={ 'db_table': 'Adbreak_history', 'managed': False, }, ), migrations.CreateModel( name='AdbreaPredict', fields=[ ('id_adbreak_history', models.AutoField(primary_key=True, serialize=False)), ('id_channel', models.IntegerField()), ('datetime', models.DateTimeField()), ('day', models.CharField(max_length=255)), ('time', models.CharField(max_length=255)), ('channel_name', models.CharField(max_length=255)), ('duration', models.CharField(max_length=255)), ], options={ 'db_table': 'Adbreak_predict', 'managed': False, }, ), migrations.CreateModel( name='Admins', fields=[ ('id_admin', models.AutoField(primary_key=True, serialize=False)), ('admin', models.CharField(blank=True, max_length=255, null=True)), ('password', models.CharField(blank=True, max_length=255, null=True)), ('name', models.CharField(blank=True, max_length=255, null=True)), ('datetime', models.DateTimeField(blank=True, null=True)), ], options={ 'db_table': 'Admins', 'managed': False, }, ), migrations.CreateModel( name='Adspots', fields=[ ('id_adpost', models.AutoField(primary_key=True, serialize=False)), ('adspot_name', models.CharField(blank=True, max_length=255, null=True)), ('original_filepath', models.CharField(blank=True, max_length=255, null=True)), ('encoded_filepath', models.CharField(blank=True, max_length=255, null=True)), ('duration', models.CharField(blank=True, max_length=255, null=True)), ('status', models.CharField(blank=True, max_length=255, null=True)), ('filename', models.CharField(blank=True, max_length=255, null=True)), ('datetime', models.DateTimeField(blank=True, null=True)), ], options={ 'db_table': 'Adspots', 'managed': False, }, ), migrations.CreateModel( name='AdspotsInAvail', fields=[ ('id_adsinavail', models.AutoField(primary_key=True, serialize=False)), ('positioninavail', models.IntegerField(blank=True, db_column='positionInAvail', null=True)), ('trafficid', models.IntegerField(blank=True, db_column='trafficId', null=True)), ], options={ 'db_table': 'Adspots_in_avail', 'managed': False, }, ), migrations.CreateModel( name='Agency', fields=[ ('id_agency', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(blank=True, max_length=255, null=True)), ('description', models.CharField(blank=True, max_length=255, null=True)), ('datetime', models.DateTimeField(blank=True, null=True)), ('is_deleted', models.IntegerField()), ], options={ 'db_table': 'Agency', 'managed': False, }, ), migrations.CreateModel( name='AuthGroup', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=150, unique=True)), ], options={ 'db_table': 'auth_group', 'managed': False, }, ), migrations.CreateModel( name='AuthGroupPermissions', fields=[ ('id', models.BigAutoField(primary_key=True, serialize=False)), ], options={ 'db_table': 'auth_group_permissions', 'managed': False, }, ), migrations.CreateModel( name='AuthPermission', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=255)), ('codename', models.CharField(max_length=100)), ], options={ 'db_table': 'auth_permission', 'managed': False, }, ), migrations.CreateModel( name='AuthUser', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('password', models.CharField(max_length=128)), ('last_login', models.DateTimeField(blank=True, null=True)), ('is_superuser', models.IntegerField()), ('username', models.CharField(max_length=150, unique=True)), ('first_name', models.CharField(max_length=150)), ('last_name', models.CharField(max_length=150)), ('email', models.CharField(max_length=254)), ('is_staff', models.IntegerField()), ('is_active', models.IntegerField()), ('date_joined', models.DateTimeField()), ], options={ 'db_table': 'auth_user', 'managed': False, }, ), migrations.CreateModel( name='AuthUserGroups', fields=[ ('id', models.BigAutoField(primary_key=True, serialize=False)), ], options={ 'db_table': 'auth_user_groups', 'managed': False, }, ), migrations.CreateModel( name='AuthUserUserPermissions', fields=[ ('id', models.BigAutoField(primary_key=True, serialize=False)), ], options={ 'db_table': 'auth_user_user_permissions', 'managed': False, }, ), migrations.CreateModel( name='Avails', fields=[ ('id_avail', models.AutoField(primary_key=True, serialize=False)), ('avail_start', models.CharField(blank=True, max_length=255, null=True)), ('availinwindow', models.CharField(blank=True, db_column='availInWindow', max_length=255, null=True)), ('datetime', models.DateTimeField(blank=True, null=True)), ], options={ 'db_table': 'Avails', 'managed': False, }, ), migrations.CreateModel( name='Brands', fields=[ ('id_brand', models.AutoField(primary_key=True, serialize=False)), ('brand_name', models.CharField(blank=True, max_length=255, null=True)), ('description', models.CharField(blank=True, max_length=255, null=True)), ('category', models.CharField(blank=True, max_length=255, null=True)), ('logo', models.CharField(blank=True, max_length=255, null=True)), ('status', models.CharField(blank=True, max_length=255, null=True)), ], options={ 'db_table': 'Brands', 'managed': False, }, ), migrations.CreateModel( name='Campaigns', fields=[ ('id_campaign', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(max_length=255)), ('pacing', models.BooleanField(blank=True, null=True)), ('start_day', models.CharField(max_length=255)), ('end_day', models.CharField(max_length=255)), ('volume', models.IntegerField(blank=True, null=True)), ('delivery', models.IntegerField(blank=True, null=True)), ('cpm', models.FloatField(blank=True, null=True)), ('general_rotation', models.IntegerField()), ('booked', models.BooleanField(blank=True, null=True)), ], options={ 'db_table': 'Campaigns', 'managed': False, }, ), migrations.CreateModel( name='ChannelCodec', fields=[ ('id_ch_codec', models.AutoField(primary_key=True, serialize=False)), ('ffmpeg_cmd', models.CharField(blank=True, db_column='FFmpeg_cmd', max_length=255, null=True)), ('ateme_cmd', models.CharField(blank=True, db_column='Ateme_cmd', max_length=255, null=True)), ], options={ 'db_table': 'Channel_codec', 'managed': False, }, ), migrations.CreateModel( name='Channels', fields=[ ('id_channel', models.AutoField(primary_key=True, serialize=False)), ('channel_name', models.CharField(blank=True, max_length=255, null=True)), ('channel_desc', models.CharField(blank=True, max_length=255, null=True)), ('channel_lang', models.CharField(blank=True, max_length=255, null=True)), ('channel_genre', models.CharField(blank=True, max_length=255, null=True)), ('ftp_channel_name', models.CharField(blank=True, max_length=255, null=True)), ('sfr_channel_name', models.CharField(blank=True, max_length=255, null=True)), ('networkname', models.CharField(blank=True, db_column='networkName', max_length=255, null=True)), ('zonename', models.CharField(blank=True, db_column='zoneName', max_length=255, null=True)), ('creation_datetime', models.DateTimeField(blank=True, null=True)), ('modif_datetime', models.DateTimeField(blank=True, null=True)), ], options={ 'db_table': 'Channels', 'managed': False, }, ), migrations.CreateModel( name='ChannelsZone', fields=[ ('id_zone_channel', models.AutoField(primary_key=True, serialize=False)), ('region', models.CharField(blank=True, max_length=255, null=True)), ('zonename', models.CharField(blank=True, max_length=255, null=True)), ], options={ 'db_table': 'Channels_zone', 'managed': False, }, ), migrations.CreateModel( name='CorsheadersCorsmodel', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('cors', models.CharField(max_length=255)), ], options={ 'db_table': 'corsheaders_corsmodel', 'managed': False, }, ), migrations.CreateModel( name='Day_times', fields=[ ('id_time', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(max_length=255)), ], options={ 'db_table': 'day_time', 'managed': False, }, ), migrations.CreateModel( name='DayTime', fields=[ ('id_time', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(max_length=255)), ('start', models.CharField(max_length=255)), ('end', models.CharField(max_length=255)), ], options={ 'db_table': 'Day_time', 'managed': False, }, ), migrations.CreateModel( name='DjangoAdminLog', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('action_time', models.DateTimeField()), ('object_id', models.TextField(blank=True, null=True)), ('object_repr', models.CharField(max_length=200)), ('action_flag', models.PositiveSmallIntegerField()), ('change_message', models.TextField()), ], options={ 'db_table': 'django_admin_log', 'managed': False, }, ), migrations.CreateModel( name='DjangoContentType', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('app_label', models.CharField(max_length=100)), ('model', models.CharField(max_length=100)), ], options={ 'db_table': 'django_content_type', 'managed': False, }, ), migrations.CreateModel( name='DjangoMigrations', fields=[ ('id', models.BigAutoField(primary_key=True, serialize=False)), ('app', models.CharField(max_length=255)), ('name', models.CharField(max_length=255)), ('applied', models.DateTimeField()), ], options={ 'db_table': 'django_migrations', 'managed': False, }, ), migrations.CreateModel( name='DjangoSession', fields=[ ('session_key', models.CharField(max_length=40, primary_key=True, serialize=False)), ('session_data', models.TextField()), ('expire_date', models.DateTimeField()), ], options={ 'db_table': 'django_session', 'managed': False, }, ), migrations.CreateModel( name='Impressions', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('tool_name', models.CharField(max_length=255)), ('total_users', models.IntegerField()), ('market_share_purcent', models.FloatField(blank=True, null=True)), ('region', models.CharField(max_length=255)), ], options={ 'db_table': 'SFR_market_share', 'managed': False, }, ), migrations.CreateModel( name='Jingles', fields=[ ('id_jingle', models.AutoField(primary_key=True, serialize=False)), ('jingle_name', models.CharField(max_length=255)), ('video_jingle', models.CharField(max_length=255)), ('md5_file', models.CharField(max_length=255)), ('creation_datetime', models.DateTimeField()), ('modif_datetime', models.DateTimeField()), ('status', models.IntegerField()), ('is_delete', models.IntegerField()), ], options={ 'db_table': 'Jingles', 'managed': False, }, ), migrations.CreateModel( name='Placement', fields=[ ('id_placement', models.AutoField(primary_key=True, serialize=False)), ], options={ 'db_table': 'Placement', 'managed': False, }, ), migrations.CreateModel( name='Playlists', fields=[ ('id_playlist', models.AutoField(primary_key=True, serialize=False)), ('version', models.CharField(blank=True, max_length=255, null=True)), ('broadcastdate', models.CharField(blank=True, max_length=255, null=True)), ('start_date', models.DateTimeField(blank=True, null=True)), ('end_date', models.DateTimeField(blank=True, null=True)), ('filepath', models.CharField(blank=True, max_length=255, null=True)), ('is_draft', models.IntegerField()), ('draft_version', models.IntegerField()), ('creation_datetime', models.DateTimeField(blank=True, null=True)), ], options={ 'db_table': 'Playlists', 'managed': False, }, ), migrations.CreateModel( name='Sfr_analytics', fields=[ ('id_impression', models.AutoField(primary_key=True, serialize=False)), ('sfr_channel_name', models.CharField(max_length=255)), ('day', models.DateField(blank=True, null=True)), ('region', models.CharField(max_length=255)), ('cible', models.CharField(max_length=255)), ('indicateur', models.CharField(max_length=255)), ('minute', models.TimeField(blank=True, null=True)), ('purcent', models.FloatField(blank=True, null=True)), ], options={ 'db_table': 'SFR_analytics', 'managed': False, }, ), migrations.CreateModel( name='Sfr_predict', fields=[ ('id_impression', models.AutoField(primary_key=True, serialize=False)), ('sfr_channel_name', models.CharField(max_length=255)), ('day', models.DateField(blank=True, null=True)), ('region', models.CharField(max_length=255)), ('cible', models.CharField(max_length=255)), ('indicateur', models.CharField(max_length=255)), ('minute', models.TimeField(blank=True, null=True)), ('purcent', models.FloatField(blank=True, null=True)), ], options={ 'db_table': 'SFR_predict', 'managed': False, }, ), migrations.CreateModel( name='SfrAnalytics', fields=[ ('id_impression', models.AutoField(primary_key=True, serialize=False)), ('sfr_channel_name', models.CharField(blank=True, max_length=255, null=True)), ('day', models.CharField(blank=True, max_length=255, null=True)), ('region', models.CharField(blank=True, max_length=255, null=True)), ('cible', models.CharField(blank=True, max_length=255, null=True)), ('indicateur', models.CharField(blank=True, max_length=255, null=True)), ('minute', models.CharField(blank=True, max_length=255, null=True)), ('purcent', models.CharField(blank=True, max_length=255, null=True)), ], options={ 'db_table': 'SFR_analytics', 'managed': False, }, ), migrations.CreateModel( name='Useraccess', fields=[ ('id_access', models.AutoField(primary_key=True, serialize=False)), ('api_key', models.CharField(blank=True, max_length=255, null=True)), ('ftp_prototype', models.CharField(blank=True, max_length=255, null=True)), ('ftp_server', models.CharField(blank=True, max_length=255, null=True)), ('ftp_port', models.CharField(blank=True, max_length=255, null=True)), ('ftp_user', models.CharField(blank=True, max_length=255, null=True)), ('ftp_password', models.CharField(blank=True, max_length=255, null=True)), ('openvpn_user', models.CharField(blank=True, max_length=255, null=True)), ('openvpn_password', models.CharField(blank=True, max_length=255, null=True)), ], options={ 'db_table': 'UserAccess', 'managed': False, }, ), migrations.CreateModel( name='Users', fields=[ ('id_user', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(blank=True, max_length=255, null=True)), ('type', models.CharField(blank=True, max_length=255, null=True)), ('email', models.CharField(blank=True, max_length=255, null=True)), ('userlogin', models.CharField(blank=True, max_length=255, null=True)), ('userpass', models.CharField(blank=True, max_length=255, null=True)), ('datetime', models.DateTimeField(blank=True, null=True)), ], options={ 'db_table': 'Users', 'managed': False, }, ), migrations.CreateModel( name='UsersAdvertisers', fields=[ ('id_user_advertiser', models.AutoField(primary_key=True, serialize=False)), ('status', models.CharField(blank=True, max_length=255, null=True)), ('datetime', models.DateTimeField(blank=True, null=True)), ], options={ 'db_table': 'Users_Advertisers', 'managed': False, }, ), migrations.CreateModel( name='Verifs', fields=[ ('id_verif', models.AutoField(primary_key=True, serialize=False)), ('networkname', models.CharField(max_length=255)), ('zonename', models.CharField(max_length=255)), ('broadcastDate', models.CharField(max_length=255)), ('trafficId', models.IntegerField()), ('spotId', models.CharField(max_length=255)), ('airTime', models.CharField(max_length=255)), ('airLength', models.CharField(max_length=255)), ('airStatuscode', models.CharField(max_length=255)), ('revision', models.IntegerField()), ('vercomplete', models.CharField(blank=True, db_column='verComplete', max_length=50, null=True)), ], options={ 'db_table': 'Verifs', 'managed': False, }, ), migrations.CreateModel( name='Windows', fields=[ ('id_window', models.AutoField(primary_key=True, serialize=False)), ('window_start', models.CharField(blank=True, max_length=255, null=True)), ('window_end', models.CharField(blank=True, max_length=255, null=True)), ('window_duration', models.CharField(blank=True, max_length=255, null=True)), ], options={ 'db_table': 'Windows', 'managed': False, }, ), ]