greater_wms/container/migrations/0022_containerdetaillogmodel_and_more.py

# Generated by Django 4.1.2 on 2025-06-03 00:29

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


class Migration(migrations.Migration):

    dependencies = [
        ('container', '0021_out_batch_detail_last_out_goods_qty'),
    ]

    operations = [
        migrations.CreateModel(
            name='ContainerDetailLogModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('log_type', models.CharField(choices=[('create', '创建'), ('update', '更新'), ('delete', '删除'), ('out', '出库'), ('status_change', '状态变更')], max_length=20, verbose_name='日志类型')),
                ('old_goods_qty', models.IntegerField(blank=True, null=True, verbose_name='原数量')),
                ('old_goods_out_qty', models.IntegerField(blank=True, null=True, verbose_name='原出库数量')),
                ('old_status', models.IntegerField(blank=True, choices=[(0, '空盘'), (1, '组盘'), (2, '在库'), (3, '已出库')], null=True, verbose_name='原状态')),
                ('new_goods_qty', models.IntegerField(blank=True, null=True, verbose_name='新数量')),
                ('new_goods_out_qty', models.IntegerField(blank=True, null=True, verbose_name='新出库数量')),
                ('new_status', models.IntegerField(blank=True, choices=[(0, '空盘'), (1, '组盘'), (2, '在库'), (3, '已出库')], null=True, verbose_name='新状态')),
                ('creater', models.CharField(max_length=50, verbose_name='操作人')),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='操作时间')),
            ],
            options={
                'verbose_name': '容器明细变更日志',
                'verbose_name_plural': '容器明细变更日志',
                'db_table': 'container_detail_log',
                'ordering': ['-create_time'],
            },
        ),
        migrations.AddIndex(
            model_name='containerdetailmodel',
            index=models.Index(fields=['container'], name='container_d_contain_125dbf_idx'),
        ),
        migrations.AddIndex(
            model_name='containerdetailmodel',
            index=models.Index(fields=['batch'], name='container_d_batch_i_165f57_idx'),
        ),
        migrations.AddIndex(
            model_name='containerdetailmodel',
            index=models.Index(fields=['goods_code'], name='container_d_goods_c_24ac97_idx'),
        ),
        migrations.AddIndex(
            model_name='containerdetailmodel',
            index=models.Index(fields=['status'], name='container_d_status_a3efbb_idx'),
        ),
        migrations.AddField(
            model_name='containerdetaillogmodel',
            name='container_detail',
            field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='logs', to='container.containerdetailmodel'),
        ),
    ]