# -*- coding: utf-8 -*-
# Generated by Django 1.11.5 on 2017-12-11 03:26
from __future__ import unicode_literals

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('parametros', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='Color',
            fields=[
                ('col_idcolor', models.CharField(max_length=5, primary_key=True, serialize=False, verbose_name='Código de Color')),
                ('col_detalle', models.CharField(max_length=15, verbose_name='Detalle')),
                ('col_abrevia', models.CharField(max_length=10, verbose_name='Abreviatura')),
                ('col_indicad', models.CharField(default=1, max_length=1, verbose_name='Indicador')),
                ('col_statreg', models.BooleanField(default=True, verbose_name='Status del Registro')),
            ],
        ),
        migrations.CreateModel(
            name='Division',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('div_detalle', models.CharField(max_length=20, verbose_name='Detalle')),
                ('div_abrevia', models.CharField(max_length=10, verbose_name='Abreviatura')),
                ('div_indicad', models.IntegerField(default=1, verbose_name='Un indicador')),
                ('div_statreg', models.BooleanField(default=True, verbose_name='Status del Registro')),
            ],
        ),
        migrations.CreateModel(
            name='Existencia',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('exs_product', models.CharField(db_index=True, editable=False, max_length=13, unique=True, verbose_name='Cód. Producto')),
                ('exs_detalle', models.CharField(editable=False, max_length=45, verbose_name='Detalle del Producto')),
                ('exs_abrevia', models.CharField(editable=False, max_length=25, verbose_name='Abreviatura del Producto')),
                ('exs_tabtall', models.CharField(blank=True, editable=False, max_length=5, null=True, verbose_name='Tabla de Tallas')),
                ('exs_saldinc', models.DecimalField(blank=True, decimal_places=4, max_digits=11, null=True, verbose_name='Saldo inicial')),
                ('exs_ingreso', models.DecimalField(blank=True, decimal_places=4, max_digits=11, null=True, verbose_name='Ingresos')),
                ('exs_egresos', models.DecimalField(blank=True, decimal_places=4, max_digits=11, null=True, verbose_name='Egresos')),
                ('exs_saldact', models.DecimalField(blank=True, decimal_places=4, max_digits=11, null=True, verbose_name='Saldo Actual')),
                ('exs_comprom', models.DecimalField(blank=True, decimal_places=4, max_digits=11, null=True, verbose_name='S.Compromet.(Ped. de Client)')),
                ('exs_xconfir', models.DecimalField(blank=True, decimal_places=4, max_digits=11, null=True, verbose_name='S. x confirm.(Ped.a Proveed)')),
                ('exs_dsponib', models.DecimalField(blank=True, decimal_places=4, max_digits=11, null=True, verbose_name='Saldo disponible')),
                ('exs_feching', models.DateTimeField(blank=True, null=True, verbose_name='Fecha de ult. Ingreso')),
                ('exs_fechegr', models.DateTimeField(blank=True, null=True, verbose_name='Fecha Ult. Egreso')),
                ('exs_fechinv', models.DateTimeField(blank=True, null=True, verbose_name='Fecha de inventario')),
                ('exs_costant', models.DecimalField(blank=True, decimal_places=4, max_digits=15, null=True, verbose_name='Costo promedio Anterior')),
                ('exs_dispant', models.DecimalField(blank=True, decimal_places=4, max_digits=15, null=True, verbose_name='Disponible Anterior')),
                ('exs_costact', models.DecimalField(blank=True, decimal_places=4, max_digits=15, null=True, verbose_name='Costo Actual')),
                ('exs_cosprom', models.DecimalField(blank=True, decimal_places=4, max_digits=15, null=True, verbose_name='Costo promedio Actual')),
                ('exs_distrib', models.DecimalField(blank=True, decimal_places=4, max_digits=15, null=True, verbose_name='Distribuidor')),
                ('exs_mayoris', models.DecimalField(blank=True, decimal_places=4, max_digits=15, null=True, verbose_name='Mayorista')),
                ('exs_detalls', models.DecimalField(blank=True, decimal_places=4, max_digits=15, null=True, verbose_name='Detallista')),
                ('exs_publico', models.DecimalField(blank=True, decimal_places=4, max_digits=15, null=True, verbose_name='Publico')),
                ('exs_special', models.DecimalField(blank=True, decimal_places=4, max_digits=15, null=True, verbose_name='Especial')),
                ('exs_imgprod', models.ImageField(blank=True, upload_to='productos')),
                ('exs_statreg', models.BooleanField(default=True, verbose_name='Status del Registro')),
            ],
        ),
        migrations.CreateModel(
            name='Marca',
            fields=[
                ('mrk_idmarca', models.CharField(max_length=5, primary_key=True, serialize=False, verbose_name='Código de  Marca')),
                ('mrk_detalle', models.CharField(max_length=15, verbose_name='Detalle')),
                ('mrk_abrevia', models.CharField(max_length=5, verbose_name='Abreviatura')),
                ('mrk_indicad', models.CharField(default=1, max_length=1, verbose_name='Indicador')),
                ('mrk_statreg', models.BooleanField(default=True, verbose_name='Status del Registro')),
            ],
        ),
        migrations.CreateModel(
            name='Modelo',
            fields=[
                ('mod_idmodel', models.CharField(max_length=5, primary_key=True, serialize=False, verbose_name='Código de Modelo')),
                ('mod_detalle', models.CharField(max_length=20, verbose_name='Detalle')),
                ('mod_abrevia', models.CharField(max_length=10, verbose_name='Abreviatura')),
                ('mod_statreg', models.BooleanField(default=True, verbose_name='Status del Registro')),
                ('mod_idmarca', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='inventarios.Marca')),
            ],
        ),
        migrations.CreateModel(
            name='Tabtalla',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('jgo_idtalla', models.CharField(max_length=2, verbose_name='Código de la Tabla')),
                ('jgo_medid01', models.CharField(blank=True, max_length=6, null=True, verbose_name='Talla-01')),
                ('jgo_medid02', models.CharField(blank=True, max_length=6, null=True, verbose_name='Talla-02')),
                ('jgo_medid03', models.CharField(blank=True, max_length=6, null=True, verbose_name='Talla-03')),
                ('jgo_medid04', models.CharField(blank=True, max_length=6, null=True, verbose_name='Talla-04')),
                ('jgo_medid05', models.CharField(blank=True, max_length=6, null=True, verbose_name='Talla-05')),
                ('jgo_medid06', models.CharField(blank=True, max_length=6, null=True, verbose_name='Talla-06')),
                ('jgo_medid07', models.CharField(blank=True, max_length=6, null=True, verbose_name='Talla-07')),
                ('jgo_medid08', models.CharField(blank=True, max_length=6, null=True, verbose_name='Talla-08')),
                ('jgo_medid09', models.CharField(blank=True, max_length=6, null=True, verbose_name='Talla-09')),
                ('jgo_medid10', models.CharField(blank=True, max_length=6, null=True, verbose_name='Talla-10')),
                ('jgo_medid11', models.CharField(blank=True, max_length=6, null=True, verbose_name='Talla-11')),
                ('jgo_medid12', models.CharField(blank=True, max_length=6, null=True, verbose_name='Talla-12')),
                ('jgo_medid13', models.CharField(blank=True, max_length=6, null=True, verbose_name='Talla-13')),
                ('jgo_divisio', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='inventarios.Division')),
            ],
        ),
        migrations.CreateModel(
            name='Tipoproducto',
            fields=[
                ('tpo_idtipos', models.CharField(default='I', max_length=1, primary_key=True, serialize=False, verbose_name='Cód. Tipo/Producto')),
                ('tpo_detalle', models.CharField(max_length=20, verbose_name='Detalle')),
                ('tpo_abrevia', models.CharField(max_length=10, verbose_name='Abreviatura')),
            ],
        ),
        migrations.CreateModel(
            name='Unidad',
            fields=[
                ('und_idunida', models.CharField(max_length=5, primary_key=True, serialize=False, verbose_name='Cód. Unidad')),
                ('und_detalle', models.CharField(max_length=20, verbose_name='Detalle')),
            ],
        ),
        migrations.CreateModel(
            name='Saldoxtalla',
            fields=[
                ('tex_product', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='inventarios.Existencia', verbose_name='Saldo x talla')),
                ('tex_inici01', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. inici-01')),
                ('tex_inici02', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. inici-02')),
                ('tex_inici03', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. inici-03')),
                ('tex_inici04', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. inici-04')),
                ('tex_inici05', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. inici-05')),
                ('tex_inici06', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. inici-06')),
                ('tex_inici07', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. inici-07')),
                ('tex_inici08', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. inici-08')),
                ('tex_inici09', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. inici-09')),
                ('tex_inici10', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. inici-10')),
                ('tex_inici11', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. inici-11')),
                ('tex_inici12', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. inici-12')),
                ('tex_inici13', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. inici-13')),
                ('tex_ingre01', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. ingre-01')),
                ('tex_ingre02', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. ingre-02')),
                ('tex_ingre03', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. ingre-03')),
                ('tex_ingre04', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. ingre-04')),
                ('tex_ingre05', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. ingre-05')),
                ('tex_ingre06', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. ingre-06')),
                ('tex_ingre07', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. ingre-07')),
                ('tex_ingre08', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. ingre-08')),
                ('tex_ingre09', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. ingre-09')),
                ('tex_ingre10', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. ingre-10')),
                ('tex_ingre11', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. ingre-11')),
                ('tex_ingre12', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. ingre-12')),
                ('tex_ingre13', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. ingre-13')),
                ('tex_egres01', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. egres-01')),
                ('tex_egres02', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. egres-02')),
                ('tex_egres03', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. egres-03')),
                ('tex_egres04', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. egres-04')),
                ('tex_egres05', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. egres-05')),
                ('tex_egres06', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. egres-06')),
                ('tex_egres07', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. egres-07')),
                ('tex_egres08', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. egres-08')),
                ('tex_egres09', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. egres-09')),
                ('tex_egres10', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. egres-10')),
                ('tex_egres11', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. egres-11')),
                ('tex_egres12', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. egres-12')),
                ('tex_egres13', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. egres-13')),
                ('tex_actua01', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. actua-01')),
                ('tex_actua02', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. actua-02')),
                ('tex_actua03', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. actua-03')),
                ('tex_actua04', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. actua-04')),
                ('tex_actua05', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. actua-05')),
                ('tex_actua06', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. actua-06')),
                ('tex_actua07', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. actua-07')),
                ('tex_actua08', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. actua-08')),
                ('tex_actua09', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. actua-09')),
                ('tex_actua10', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. actua-10')),
                ('tex_actua11', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. actua-11')),
                ('tex_actua12', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. actua-12')),
                ('tex_actua13', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. actua-13')),
                ('tex_compr01', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. compr-01')),
                ('tex_compr02', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. compr-02')),
                ('tex_compr03', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. compr-03')),
                ('tex_compr04', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. compr-04')),
                ('tex_compr05', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. compr-05')),
                ('tex_compr06', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. compr-06')),
                ('tex_compr07', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. compr-07')),
                ('tex_compr08', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. compr-08')),
                ('tex_compr09', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. compr-09')),
                ('tex_compr10', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. compr-10')),
                ('tex_compr11', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. compr-11')),
                ('tex_compr12', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. compr-12')),
                ('tex_compr13', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. compr-13')),
                ('tex_xconf01', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. xconf-01')),
                ('tex_xconf02', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. xconf-02')),
                ('tex_xconf03', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. xconf-03')),
                ('tex_xconf04', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. xconf-04')),
                ('tex_xconf05', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. xconf-05')),
                ('tex_xconf06', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. xconf-06')),
                ('tex_xconf07', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. xconf-07')),
                ('tex_xconf08', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. xconf-08')),
                ('tex_xconf09', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. xconf-09')),
                ('tex_xconf10', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. xconf-10')),
                ('tex_xconf11', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. xconf-11')),
                ('tex_xconf12', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. xconf-12')),
                ('tex_xconf13', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. xconf-13')),
                ('tex_dispo01', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. dispo-01')),
                ('tex_dispo02', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. dispo-02')),
                ('tex_dispo03', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. dispo-03')),
                ('tex_dispo04', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. dispo-04')),
                ('tex_dispo05', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. dispo-05')),
                ('tex_dispo06', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. dispo-06')),
                ('tex_dispo07', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. dispo-07')),
                ('tex_dispo08', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. dispo-08')),
                ('tex_dispo09', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. dispo-09')),
                ('tex_dispo10', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. dispo-10')),
                ('tex_dispo11', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. dispo-11')),
                ('tex_dispo12', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. dispo-12')),
                ('tex_dispo13', models.DecimalField(decimal_places=4, max_digits=11, null=True, verbose_name='Cant. dispo-13')),
            ],
        ),
        migrations.AddField(
            model_name='modelo',
            name='mod_tabtall',
            field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='inventarios.Tabtalla'),
        ),
        migrations.AddField(
            model_name='existencia',
            name='exs_idcolor',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='inventarios.Color'),
        ),
        migrations.AddField(
            model_name='existencia',
            name='exs_iddivis',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='inventarios.Division'),
        ),
        migrations.AddField(
            model_name='existencia',
            name='exs_idmarca',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='inventarios.Marca'),
        ),
        migrations.AddField(
            model_name='existencia',
            name='exs_idmodel',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='inventarios.Modelo'),
        ),
        migrations.AddField(
            model_name='existencia',
            name='exs_idunida',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='inventarios.Unidad'),
        ),
        migrations.AddField(
            model_name='existencia',
            name='exs_sucursa',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='parametros.Sucursal'),
        ),
        migrations.AddField(
            model_name='existencia',
            name='exs_tpoprod',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='inventarios.Tipoproducto'),
        ),
    ]
