Elep

# Generated by Django 4.1.5 on 2023-03-03 18:26

from django.db import migrations, models
import django.db.models.deletion
import picklefield.fields

class Migration(migrations.Migration):

initial = True

dependencies = [
    ]

operations = [
        migrations.CreateModel(
            name='MappingDetail',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('warehouse', models.CharField(max_length=255)),
                ('retention_database', models.CharField(max_length=255)),
                ('database', models.CharField(max_length=255)),
                ('schema', models.CharField(max_length=255)),
                ('table', models.CharField(max_length=255)),
                ('direct_list', picklefield.fields.PickledObjectField(editable=False)),
                ('direct_mapping_list', picklefield.fields.PickledObjectField(editable=False)),
                ('snowflake_static', picklefield.fields.PickledObjectField(editable=False)),
                ('max_id', models.IntegerField()),
                ('client_id', models.CharField(max_length=255)),
                ('subdomain', models.CharField(max_length=255)),
            ],
        ),
        migrations.CreateModel(
            name='SnowflakeAuthentication',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('account', models.CharField(max_length=255)),
                ('user', models.CharField(max_length=255)),
                ('password', models.CharField(max_length=255)),
                ('role', models.CharField(choices=[('accountadmin', 'accountadmin'), ('orgadmin', 'orgadmin')], max_length=255)),
                ('sf_user_id', models.CharField(max_length=255)),
            ],
        ),
        migrations.CreateModel(
            name='SyncMappingRecord',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('event_number', models.IntegerField()),
                ('created_on', models.DateTimeField()),
                ('mapping_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='snowflake_connector.mappingdetail')),
                ('snowflake_id', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='snowflake_connector.snowflakeauthentication')),
            ],
        ),
        migrations.AddField(
            model_name='mappingdetail',
            name='snowflake_id',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='snowflake_connector.snowflakeauthentication'),
        ),
    ]