# Generated by Django 4.2.7 on 2023-12-22 09:21
import django.contrib.auth.models
import django.contrib.auth.validators
from django.db import migrations, models
import django.db.models.deletion
import django.utils.timezone
[docs]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0012_alter_user_first_name_max_length'),
]
operations = [
migrations.CreateModel(
name='Bottle',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('size', models.CharField(max_length=40)),
('cl', models.DecimalField(decimal_places=2, max_digits=5)),
],
),
migrations.CreateModel(
name='Country',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('country', models.CharField(default='', max_length=30)),
],
options={
'ordering': ['country'],
},
),
migrations.CreateModel(
name='LocationType',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('location_type', models.CharField(max_length=50)),
('location_max_qty', models.IntegerField(default='1')),
('location_note', models.CharField(default='', max_length=100, null=True)),
],
),
migrations.CreateModel(
name='ShipUnit',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('ship_unit', models.CharField(max_length=40)),
('qty', models.IntegerField()),
],
),
migrations.CreateModel(
name='Style',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=40)),
],
),
migrations.CreateModel(
name='Location',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(default='', max_length=20)),
('location_qty', models.IntegerField(default='0')),
('type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.locationtype')),
],
options={
'ordering': ['type', 'name'],
},
),
migrations.CreateModel(
name='Addition',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(default='', max_length=55)),
('year', models.CharField(default='-', max_length=4)),
('price', models.DecimalField(blank=True, decimal_places=2, default='.00', help_text='Price for the Ship Qty i.e. case', max_digits=5, null=True)),
('abv', models.DecimalField(blank=True, decimal_places=2, default='.00', max_digits=5, null=True)),
('source', models.CharField(blank=True, max_length=50, null=True)),
('duty', models.DecimalField(decimal_places=2, default='.00', max_digits=5, null=True)),
('vat', models.BooleanField(default=True)),
('quantity', models.PositiveIntegerField()),
('delivery_qty', models.PositiveIntegerField()),
('order_ref', models.CharField(blank=True, default='', max_length=50, null=True)),
('ship_costs', models.DecimalField(blank=True, decimal_places=2, default='.00', max_digits=5, null=True)),
('expected_delivery', models.DateField(auto_now_add=True)),
('addition_status', models.CharField(choices=[('Ordered', 'Ordered'), ('Received', 'Received'), ('Part Allocated', 'Part Allocated'), ('Put Away', 'Put Away'), ('Tried', 'Tried'), ('Drunk', 'Drunk')], max_length=14)),
('allocation_qty', models.PositiveIntegerField(blank=True, default='0')),
('country', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.country')),
('delivery_unit', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='Del_Unit', to='core.shipunit')),
('size', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.bottle')),
('style', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.style')),
('wine_location', models.ManyToManyField(blank=True, to='core.location')),
],
),
migrations.CreateModel(
name='User',
fields=[
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('password', models.CharField(max_length=128, verbose_name='password')),
('last_login', models.DateTimeField(blank=True, null=True, verbose_name='last login')),
('is_superuser', models.BooleanField(default=False, help_text='Designates that this user has all permissions without explicitly assigning them.', verbose_name='superuser status')),
('username', models.CharField(error_messages={'unique': 'A user with that username already exists.'}, help_text='Required. 150 characters or fewer. Letters, digits and @/./+/-/_ only.', max_length=150, unique=True, validators=[django.contrib.auth.validators.UnicodeUsernameValidator()], verbose_name='username')),
('first_name', models.CharField(blank=True, max_length=150, verbose_name='first name')),
('last_name', models.CharField(blank=True, max_length=150, verbose_name='last name')),
('is_staff', models.BooleanField(default=False, help_text='Designates whether the user can log into this admin site.', verbose_name='staff status')),
('is_active', models.BooleanField(default=True, help_text='Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')),
('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')),
('role', models.CharField(choices=[('G', 'Guest'), ('M', 'Member'), ('A', 'Admin')], default='G', max_length=1)),
('email', models.EmailField(max_length=254, verbose_name='email')),
('account', models.CharField(max_length=100)),
('groups', models.ManyToManyField(blank=True, help_text='The groups this user belongs to. A user will get all permissions granted to each of their groups.', related_name='user_set', related_query_name='user', to='auth.group', verbose_name='groups')),
('user_permissions', models.ManyToManyField(blank=True, help_text='Specific permissions for this user.', related_name='user_set', related_query_name='user', to='auth.permission', verbose_name='user permissions')),
],
options={
'verbose_name': 'user',
'verbose_name_plural': 'users',
'abstract': False,
},
managers=[
('objects', django.contrib.auth.models.UserManager()),
],
),
]