2023_05_12/Air_mis/Sellers/migrations/0001_initial.py

# Generated by Django 4.0.4 on 2023-04-28 17:08

from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='Flight',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('number', models.CharField(max_length=10)),
                ('F_seat_num', models.IntegerField()),
                ('C_seat_num', models.IntegerField()),
                ('Y_seat_num', models.IntegerField()),
                ('sta_point', models.CharField(max_length=20)),
                ('stopover_point', models.CharField(max_length=20)),
                ('stopover_hour', models.IntegerField()),
                ('stopover_minute', models.IntegerField()),
                ('fin_point', models.CharField(max_length=20)),
                ('Type', models.IntegerField()),
                ('income', models.DecimalField(decimal_places=2, default=0, max_digits=15)),
                ('status', models.CharField(default='未起飞', max_length=10)),
                ('add_time', models.DateTimeField(auto_now_add=True)),
                ('tye', models.CharField(max_length=5)),
            ],
        ),
        migrations.CreateModel(
            name='Message',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('content', models.CharField(max_length=500)),
                ('from_id', models.IntegerField()),
                ('to_id', models.IntegerField()),
                ('status', models.IntegerField()),
                ('add_time', models.DateTimeField(auto_now_add=True)),
            ],
        ),
        migrations.CreateModel(
            name='Order',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('flight', models.CharField(max_length=10)),
                ('start_point', models.CharField(max_length=20)),
                ('final_point', models.CharField(max_length=20)),
                ('stopover_point', models.CharField(max_length=20)),
                ('starting_time', models.DateTimeField()),
                ('final_time', models.DateTimeField()),
                ('be_price', models.DecimalField(decimal_places=2, max_digits=8)),
                ('discount', models.IntegerField()),
                ('true_price', models.DecimalField(decimal_places=2, max_digits=8)),
                ('berth', models.CharField(max_length=10)),
                ('Type', models.IntegerField()),
                ('add_time', models.DateTimeField(auto_now_add=True)),
                ('status', models.CharField(max_length=10)),
                ('ticket_id', models.IntegerField()),
                ('user_id', models.IntegerField()),
                ('new_ticket_id', models.IntegerField(default=0)),
            ],
        ),
        migrations.CreateModel(
            name='Tickets',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('flight', models.CharField(max_length=10)),
                ('start_point', models.CharField(max_length=20)),
                ('final_point', models.CharField(max_length=20)),
                ('starting_time', models.DateTimeField()),
                ('final_time', models.DateTimeField()),
                ('F_price', models.DecimalField(decimal_places=2, max_digits=8)),
                ('F_quantity', models.IntegerField()),
                ('F_discount', models.IntegerField()),
                ('C_price', models.DecimalField(decimal_places=2, max_digits=8)),
                ('C_quantity', models.IntegerField()),
                ('C_discount', models.IntegerField()),
                ('Y_price', models.DecimalField(decimal_places=2, max_digits=8)),
                ('Y_quantity', models.IntegerField()),
                ('Y_discount', models.IntegerField()),
                ('Type', models.IntegerField()),
                ('flight_id', models.IntegerField()),
            ],
        ),
    ]