# Generated by Django 4.0.6 on 2022-08-31 23:08

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Article',
            fields=[
                ('id_article', models.AutoField(primary_key=True, serialize=False)),
                ('ref_dilicom_article', models.CharField(max_length=200, null=True)),
                ('nom_article', models.CharField(max_length=200, null=True)),
                ('description_article', models.TextField(null=True)),
                ('poids_article', models.IntegerField(null=True)),
                ('code_EAN13_article', models.CharField(max_length=200, null=True)),
                ('disponibilite_article', models.CharField(max_length=200, null=True)),
                ('prix_HT_article', models.FloatField(null=True)),
                ('prix_TTC_article', models.FloatField(null=True)),
                ('date_creation_article', models.DateField(default='2022-08-31', null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Collection',
            fields=[
                ('id_collection', models.AutoField(primary_key=True, serialize=False)),
                ('nom_collection', models.CharField(max_length=200, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Contributeur',
            fields=[
                ('id_contributeur', models.AutoField(primary_key=True, serialize=False)),
                ('nom_contributeur', models.CharField(max_length=200, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Distributeur',
            fields=[
                ('id_distrib', models.AutoField(primary_key=True, serialize=False)),
                ('nom_distrib', models.CharField(max_length=200, null=True)),
                ('adresse_distrib', models.CharField(max_length=200, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Editeur',
            fields=[
                ('id_editeur', models.AutoField(primary_key=True, serialize=False)),
                ('nom_editeur', models.CharField(max_length=200, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Operation',
            fields=[
                ('id_operation', models.AutoField(primary_key=True, serialize=False)),
                ('date_operation', models.DateField(default='2022-08-31', null=True)),
                ('utilisateur', models.TextField()),
            ],
        ),
        migrations.CreateModel(
            name='Type_article',
            fields=[
                ('id_type_article', models.AutoField(primary_key=True, serialize=False)),
                ('libelle_type_article', models.CharField(max_length=200, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Participation',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('role', models.CharField(max_length=200, null=True)),
                ('id_article', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='dilicom.article')),
                ('id_contributeur', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='dilicom.contributeur')),
            ],
        ),
        migrations.CreateModel(
            name='Edition',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('id_article', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='dilicom.article')),
                ('id_editeur', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='dilicom.editeur')),
            ],
        ),
        migrations.CreateModel(
            name='Distribution',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('statut_dist', models.IntegerField(null=True)),
                ('id_article', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='dilicom.article')),
                ('id_distrib', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='dilicom.distributeur')),
            ],
        ),
        migrations.AddField(
            model_name='article',
            name='id_collection',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='dilicom.collection'),
        ),
        migrations.AddField(
            model_name='article',
            name='id_type_article',
            field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='dilicom.type_article'),
        ),
    ]