# Generated by Django 3.1.2 on 2020-11-07 16:53

from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Corvet',
            fields=[
                ('vin', models.CharField(max_length=17, primary_key=True, serialize=False, verbose_name='V.I.N.')),
                ('donnee_date_debut_garantie', models.DateTimeField(blank=True, null=True, verbose_name='Date d?but garantie')),
                ('donnee_date_entree_montage', models.DateTimeField(blank=True, null=True, verbose_name='Date entr?e montage')),
                ('donnee_ligne_de_produit', models.CharField(blank=True, max_length=200, verbose_name='LIGNE_DE_PRODUIT')),
                ('donnee_marque_commerciale', models.CharField(blank=True, max_length=200, verbose_name='MARQUE_COMMERCIALE')),
                ('donnee_silhouette', models.CharField(blank=True, max_length=200, verbose_name='SILHOUETTE')),
                ('donnee_genre_de_produit', models.CharField(blank=True, max_length=200, verbose_name='GENRE_DE_PRODUIT')),
                ('attribut_ddo', models.CharField(blank=True, max_length=200, verbose_name='KIT TELEPHONE MAIN LIBRE')),
                ('attribut_dgm', models.CharField(blank=True, max_length=200, verbose_name='COMBINE (CARACTERISTIQUES)')),
                ('attribut_dhb', models.CharField(blank=True, max_length=200, verbose_name='HAUT PARLEUR')),
                ('attribut_dhg', models.CharField(blank=True, max_length=200, verbose_name='COMMANDE AUTO-RADIO')),
                ('attribut_djq', models.CharField(blank=True, max_length=200, verbose_name='COMPACT DISQUE')),
                ('attribut_djy', models.CharField(blank=True, max_length=200, verbose_name='SYSTEME NAVIGATION')),
                ('attribut_dkx', models.CharField(blank=True, max_length=200, verbose_name='CARTOGRAPHIE POUR NAVIGATION')),
                ('attribut_dlx', models.CharField(blank=True, max_length=200, verbose_name='AFFICHEUR AV')),
                ('attribut_doi', models.CharField(blank=True, max_length=200, verbose_name='RECEPTION RADIO AMELIOREE')),
                ('attribut_dqm', models.CharField(blank=True, max_length=200, verbose_name='TYPAGE GMP')),
                ('attribut_dqs', models.CharField(blank=True, max_length=200, verbose_name='WIFI')),
                ('attribut_drc', models.CharField(blank=True, max_length=200, verbose_name='RECEPTEUR RADIO')),
                ('attribut_drt', models.CharField(blank=True, max_length=200, verbose_name='REGULATION CLIMAT/TEMPERATURE')),
                ('attribut_dti', models.CharField(blank=True, max_length=200, verbose_name='TUNER RADIO')),
                ('attribut_dun', models.CharField(blank=True, max_length=200, verbose_name='AMPLI EQUALISEUR')),
                ('attribut_dwl', models.CharField(blank=True, max_length=200, verbose_name='PACK RADIO/INFO/COMMUNICATION')),
                ('attribut_dwt', models.CharField(blank=True, max_length=200, verbose_name='PACK PREEQUIP. RADIO/COMMUNIC.')),
                ('attribut_dxj', models.CharField(blank=True, max_length=200, verbose_name='ECRAN VIDEO AR')),
                ('attribut_dyb', models.CharField(blank=True, max_length=200, verbose_name='VISION TETE HAUTE')),
                ('attribut_dym', models.CharField(blank=True, max_length=200, verbose_name='PRISE AUXILIAIRE PACK AUDIO')),
                ('attribut_dyr', models.CharField(blank=True, max_length=200, verbose_name='BOITIER TELEMATIQUE')),
                ('attribut_dzv', models.CharField(blank=True, max_length=200, verbose_name='AIDE A LA CONDUITE')),
                ('attribut_gg8', models.CharField(blank=True, max_length=200, verbose_name='PAYS PROGRAMME (ICP)')),
                ('electronique_14f', models.CharField(blank=True, max_length=200, verbose_name='RADIO HARD - Recepteur Radio')),
                ('electronique_14j', models.CharField(blank=True, max_length=200, verbose_name='CLIM HARD - Climatisation')),
                ('electronique_14k', models.CharField(blank=True, max_length=200, verbose_name='CMB HARD - Combine Planche de Bord')),
                ('electronique_14l', models.CharField(blank=True, max_length=200, verbose_name='EMF HARD - Ecran Multifonctions')),
                ('electronique_14r', models.CharField(blank=True, max_length=200, verbose_name='AAS HARD - Aide Au Stationnement')),
                ('electronique_14x', models.CharField(blank=True, max_length=200, verbose_name='BTEL HARD - Boitier Telematique (radio telephone)')),
                ('electronique_19z', models.CharField(blank=True, max_length=200, verbose_name='FMUX_HARD - FAÇADE MULTIPLEXÉ')),
                ('electronique_44f', models.CharField(blank=True, max_length=200, verbose_name='RADIO FOURN.NO.SERIE - Recepteur Radio')),
                ('electronique_44l', models.CharField(blank=True, max_length=200, verbose_name='EMF FOURN.NO.SERIE - Ecran Multifonctions')),
                ('electronique_44x', models.CharField(blank=True, max_length=200, verbose_name='BTEL FOURN.NO.SERIE - Boitier Telematique (radio telephone)')),
                ('electronique_54f', models.CharField(blank=True, max_length=200, verbose_name='RADIO FOURN.DATE.FAB - Recepteur Radio')),
                ('electronique_54k', models.CharField(blank=True, max_length=200, verbose_name='CMB FOURN.DATE.FAB - Combine Planche de Bord')),
                ('electronique_54l', models.CharField(blank=True, max_length=200, verbose_name='EMF FOURN.DATE.FAB - Ecran Multifonctions')),
                ('electronique_84f', models.CharField(blank=True, max_length=200, verbose_name='RADIO DOTE - Recepteur Radio')),
                ('electronique_84l', models.CharField(blank=True, max_length=200, verbose_name='EMF DOTE - Ecran Multifonctions')),
                ('electronique_84x', models.CharField(blank=True, max_length=200, verbose_name='BTEL DOTE - Boitier Telematique (radio telephone)')),
                ('electronique_94f', models.CharField(blank=True, max_length=200, verbose_name='RADIO SOFT - Recepteur Radio')),
                ('electronique_94l', models.CharField(blank=True, max_length=200, verbose_name='EMF SOFT - Ecran Multifonctions')),
                ('electronique_94x', models.CharField(blank=True, max_length=200, verbose_name='BTEL SOFT - Boitier Telematique (radio telephone)')),
                ('attribut_dat', models.CharField(blank=True, max_length=200, verbose_name='ANTENNE')),
                ('attribut_dcx', models.CharField(blank=True, max_length=200, verbose_name='COTE  CONDUITE/POSTE CONDUITE')),
                ('electronique_19h', models.CharField(blank=True, max_length=200, verbose_name='MDS HARD - Module de service telematique')),
                ('electronique_49h', models.CharField(blank=True, max_length=200, verbose_name='MDS FOURN.NO.SERIE - Module de service telematique')),
                ('electronique_64f', models.CharField(blank=True, max_length=200, verbose_name='RADIO FOURN.CODE - Recepteur Radio')),
                ('electronique_64x', models.CharField(blank=True, max_length=200, verbose_name='BTEL FOURN.CODE - Boitier Telematique (radio telephone)')),
                ('electronique_69h', models.CharField(blank=True, max_length=200, verbose_name='MDS FOURN.CODE - Module de service telematique')),
                ('electronique_89h', models.CharField(blank=True, max_length=200, verbose_name='MDS DOTE - Module de service telematique')),
                ('electronique_99h', models.CharField(blank=True, max_length=200, verbose_name='MDS SOFT - Module de service telematique')),
                ('electronique_14a', models.CharField(blank=True, max_length=200, verbose_name='CMM HARD - Calculateur Moteur Multifonction')),
                ('electronique_34a', models.CharField(blank=True, max_length=200, verbose_name='CMM SOFT LIVRE - Calculateur Moteur Multifonction')),
                ('electronique_44a', models.CharField(blank=True, max_length=200, verbose_name='CMM FOURN.NO.SERIE - Calculateur Moteur Multifonction')),
                ('electronique_54a', models.CharField(blank=True, max_length=200, verbose_name='CMM FOURN.DATE.FAB - Calculateur Moteur Multifonction')),
                ('electronique_64a', models.CharField(blank=True, max_length=200, verbose_name='CMM FOURN.CODE - Calculateur Moteur Multifonction')),
                ('electronique_84a', models.CharField(blank=True, max_length=200, verbose_name='CMM DOTE - Calculateur Moteur Multifonction')),
                ('electronique_94a', models.CharField(blank=True, max_length=200, verbose_name='CMM SOFT - Calculateur Moteur Multifonction')),
                ('electronique_p4a', models.CharField(blank=True, max_length=200, verbose_name='CMM EOBD - Calculateur Moteur Multifonction')),
                ('donnee_moteur', models.CharField(blank=True, max_length=200, verbose_name='MOTEUR')),
                ('donnee_transmission', models.CharField(blank=True, max_length=200, verbose_name='TRANSMISSION')),
                ('organes_10', models.CharField(blank=True, max_length=200, verbose_name='MOTEUR')),
                ('electronique_14b', models.CharField(blank=True, max_length=200, verbose_name='BSI HARD - Boitier Servitude Intelligent')),
                ('organes_20', models.CharField(blank=True, max_length=200, verbose_name='BOITE DE VITESSES')),
                ('electronique_44b', models.CharField(blank=True, max_length=200, verbose_name='BSI FOURN.NO.SERIE - Boitier Servitude Intelligent')),
                ('electronique_54b', models.CharField(blank=True, max_length=200, verbose_name='BSI FOURN.DATE.FAB - Boitier Servitude Intelligent')),
                ('electronique_64b', models.CharField(blank=True, max_length=200, verbose_name='BSI FOURN.CODE - Boitier Servitude Intelligent')),
                ('electronique_84b', models.CharField(blank=True, max_length=200, verbose_name='BSI DOTE - Boitier Servitude Intelligent')),
                ('electronique_94b', models.CharField(blank=True, max_length=200, verbose_name='BSI SOFT - Boitier Servitude Intelligent')),
                ('electronique_16p', models.CharField(blank=True, max_length=200, verbose_name='HDC HARD - Haut de Colonne de Direction (COM200x)')),
                ('electronique_46p', models.CharField(blank=True, max_length=200, verbose_name='HDC FOURN.NO.SERIE - Haut de Colonne de Direction (COM200x)')),
                ('electronique_56p', models.CharField(blank=True, max_length=200, verbose_name='HDC FOURN.DATE.FAB - Haut de Colonne de Direction (COM200x)')),
                ('electronique_66p', models.CharField(blank=True, max_length=200, verbose_name='HDC FOURN.CODE - Haut de Colonne de Direction (COM200x)')),
                ('electronique_16b', models.CharField(blank=True, max_length=200, verbose_name='BSM HARD - Boitier Servitude Moteur')),
                ('electronique_46b', models.CharField(blank=True, max_length=200, verbose_name='BSM FOURN.NO.SERIE - Boitier Servitude Moteur')),
                ('electronique_56b', models.CharField(blank=True, max_length=200, verbose_name='BSM FOURN.DATE.FAB - Boitier Servitude Moteur')),
                ('electronique_66b', models.CharField(blank=True, max_length=200, verbose_name='BSM FOURN.CODE - Boitier Servitude Moteur')),
                ('electronique_86b', models.CharField(blank=True, max_length=200, verbose_name='BSM DOTE - Boitier Servitude Moteur')),
                ('electronique_96b', models.CharField(blank=True, max_length=200, verbose_name='BSM SOFT - Boitier Servitude Moteur')),
            ],
            options={
                'verbose_name': 'données CORVET',
                'ordering': ['vin'],
            },
        ),
        migrations.CreateModel(
            name='Firmware',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('update_id', models.CharField(max_length=18, unique=True, verbose_name='SWL(UpdateID)')),
                ('version', models.CharField(max_length=200, verbose_name='UpdateVersion')),
                ('type', models.CharField(blank=True, max_length=100, verbose_name='UpdateType')),
                ('version_date', models.DateField(blank=True, null=True, verbose_name='MediaVersionDate')),
                ('ecu_type', models.CharField(choices=[('NAC_EUR_WAVE2', 'NAC_EUR_WAVE2'), ('NAC_EUR_WAVE1', 'NAC_EUR_WAVE1'), ('NAC_EUR_WAVE3', 'NAC_EUR_WAVE3'), ('NAC_EUR_WAVE4', 'NAV_EUR_WAVE4')], max_length=50, verbose_name='EcuType')),
                ('url', models.URLField(blank=True, max_length=500, verbose_name='lien de téléchargement')),
                ('is_active', models.BooleanField(default=False, verbose_name='actif')),
            ],
            options={
                'verbose_name': 'Firmwares Télématique',
                'ordering': ['-update_id'],
            },
        ),
        migrations.CreateModel(
            name='Product',
            fields=[
                ('reference', models.BigIntegerField(primary_key=True, serialize=False, verbose_name='code barre PSA')),
                ('name', models.CharField(choices=[('RT3', 'RT3'), ('RT4', 'RT4'), ('RT5', 'RT5'), ('RT6', 'RT6'), ('RT6v2', 'RT6 version 2'), ('SMEG', 'SMEG'), ('SMEGP', 'SMEG+ / SMEG+ IV1'), ('SMEGP2', 'SMEG+ IV2'), ('NG4', 'NG4'), ('RNEG', 'RNEG'), ('NAC1', 'NAC wave1'), ('NAC2', 'NAC wave2'), ('NAC3', 'NAC wave3'), ('NAC4', 'NAC wave4')], max_length=20, verbose_name='modèle')),
                ('current_cal', models.CharField(blank=True, max_length=10, verbose_name='calibration actuelle')),
                ('oe_reference', models.CharField(blank=True, max_length=200, verbose_name='référence OEM')),
                ('supplier_oe', models.CharField(blank=True, max_length=50, verbose_name='fabriquant')),
                ('type', models.CharField(choices=[('RAD', 'Radio'), ('NAV', 'Navigation')], max_length=3, verbose_name='type')),
                ('front', models.CharField(blank=True, max_length=2, verbose_name='façade')),
                ('dab', models.BooleanField(default=False, verbose_name='DAB')),
                ('cam', models.BooleanField(default=False, verbose_name='caméra de recul')),
                ('cd_version', models.CharField(blank=True, max_length=10, verbose_name='version CD')),
                ('media', models.CharField(blank=True, choices=[('N/A', 'Vide'), ('HDD', 'Disque Dur'), ('EMMC', 'eMMC'), ('SD8Go', 'Carte SD 8Go'), ('SD16Go', 'Carte SD 16Go'), ('SD8-16Go', 'Carte SD 8 ou 16 Go')], max_length=20, verbose_name='type de média')),
                ('lvds_con', models.IntegerField(blank=True, choices=[(1, '1'), (2, '2')], null=True, verbose_name="nombre d'LVDS")),
                ('usb_con', models.IntegerField(blank=True, choices=[(1, '1'), (2, '2'), (3, '3')], null=True, verbose_name="nombre d'USB")),
                ('front_pic', models.ImageField(blank=True, upload_to='psa')),
                ('setplate_pic', models.ImageField(blank=True, upload_to='psa')),
                ('rear_pic', models.ImageField(blank=True, upload_to='psa')),
                ('corvets', models.ManyToManyField(blank=True, related_name='products', to='psa.Corvet')),
            ],
            options={
                'verbose_name': 'Données Produit',
                'ordering': ['reference'],
            },
        ),
    ]
