296 lines
19 KiB
Python
296 lines
19 KiB
Python
# Generated by Django 4.0.3 on 2022-06-11 14:05
|
|
|
|
from django.db import migrations, models
|
|
import django.db.models.deletion
|
|
import django.utils.timezone
|
|
import receipe.models
|
|
|
|
|
|
class Migration(migrations.Migration):
|
|
|
|
initial = True
|
|
|
|
dependencies = [
|
|
]
|
|
|
|
operations = [
|
|
migrations.CreateModel(
|
|
name='Allergenes',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('name', models.CharField(max_length=50, verbose_name='allergene name')),
|
|
],
|
|
),
|
|
migrations.CreateModel(
|
|
name='Article',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('name', models.CharField(max_length=50, verbose_name='article name')),
|
|
('EAN', receipe.models.CharNullField(blank=True, max_length=50, null=True, unique=True, verbose_name='EAN')),
|
|
('offlink', models.URLField(blank=True, null=True, verbose_name='Open Food Fact link')),
|
|
('quantityPerPackage', models.PositiveIntegerField(blank=True, null=True, verbose_name='quantity per packages')),
|
|
('unit', receipe.models.CharNullField(blank=True, max_length=2, null=True, verbose_name='unit')),
|
|
('novaGroup', models.PositiveIntegerField(blank=True, null=True, verbose_name='NOVA group')),
|
|
('nutritionGrade', models.CharField(blank=True, max_length=1, null=True, verbose_name='nutri grade')),
|
|
('MwSt', models.PositiveIntegerField(blank=True, null=True, verbose_name='taxes')),
|
|
('created', models.DateTimeField(db_index=True, default=django.utils.timezone.now, verbose_name='created')),
|
|
('modified', models.DateTimeField(auto_now=True, db_index=True, verbose_name='modified')),
|
|
('nutritionImage', models.FilePathField(default=None, editable=False, help_text='Nutrition image filename in storage', max_length=1024, null=True, unique=True, verbose_name='nutriton image filepath')),
|
|
('ingredientsImage', models.FilePathField(default=None, editable=False, help_text='Ingredients image filename in storage', max_length=1024, null=True, unique=True, verbose_name='ingredients image filepath')),
|
|
('frontImage', models.FilePathField(default=None, editable=False, help_text='Front image filename in storage', max_length=1024, null=True, unique=True, verbose_name='front image filepath')),
|
|
('allergenes', models.ManyToManyField(blank=True, to='receipe.allergenes')),
|
|
],
|
|
),
|
|
migrations.CreateModel(
|
|
name='Brand',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('name', models.CharField(max_length=50, verbose_name='brand name')),
|
|
],
|
|
),
|
|
migrations.CreateModel(
|
|
name='EMBs',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('name', models.CharField(max_length=50, verbose_name='emb name')),
|
|
],
|
|
),
|
|
migrations.CreateModel(
|
|
name='Ingredients',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('name', models.CharField(max_length=50, verbose_name='ingredient name')),
|
|
],
|
|
),
|
|
migrations.CreateModel(
|
|
name='Labels',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('name', models.CharField(max_length=50, verbose_name='label name')),
|
|
],
|
|
),
|
|
migrations.CreateModel(
|
|
name='ManufacturingPlaces',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('name', models.CharField(max_length=50, verbose_name='manufacturing places name')),
|
|
],
|
|
),
|
|
migrations.CreateModel(
|
|
name='OriginIngredients',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('name', models.CharField(max_length=50, verbose_name='origin of igredients')),
|
|
],
|
|
),
|
|
migrations.CreateModel(
|
|
name='Packaging',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('name', models.CharField(max_length=50, verbose_name='packaging name')),
|
|
],
|
|
),
|
|
migrations.CreateModel(
|
|
name='ReceipeImage',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('checksum', models.CharField(editable=False, help_text='The checksum of the original image.', max_length=32, unique=True, verbose_name='checksum')),
|
|
('thrashed_checksum', models.CharField(editable=False, help_text='The checksum of the thrashed image.', max_length=32, unique=True, verbose_name='threshed checksum')),
|
|
('filename', models.FilePathField(default=None, editable=False, help_text='Current filename in storage', max_length=1024, null=True, unique=True, verbose_name='filename')),
|
|
('filename_trashed', models.FilePathField(default=None, editable=False, help_text='Current filename of the modified picture in storage', max_length=1024, null=True, unique=True, verbose_name='filename trashed')),
|
|
('created', models.DateTimeField(db_index=True, default=django.utils.timezone.now, verbose_name='created')),
|
|
('modified', models.DateTimeField(auto_now=True, db_index=True, verbose_name='modified')),
|
|
('added', models.DateTimeField(db_index=True, default=django.utils.timezone.now, editable=False, verbose_name='added')),
|
|
],
|
|
),
|
|
migrations.CreateModel(
|
|
name='Traces',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('name', models.CharField(max_length=50, verbose_name='trace name')),
|
|
],
|
|
),
|
|
migrations.CreateModel(
|
|
name='NutritionalValues',
|
|
fields=[
|
|
('article', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='receipe.article')),
|
|
('energy', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='energy')),
|
|
('energyUnit', models.CharField(max_length=2)),
|
|
('fat', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='fat')),
|
|
('fatUnit', models.CharField(max_length=2)),
|
|
('saturatedFat', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='saturatedFat')),
|
|
('saturatedFatUnit', models.CharField(max_length=2)),
|
|
('carbohydrate', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='carbohydrate')),
|
|
('carbohydrateUnit', models.CharField(max_length=2)),
|
|
('sugars', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='sugars')),
|
|
('sugarsUnit', models.CharField(max_length=2)),
|
|
('dietaryFiber', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='dietaryFiber')),
|
|
('dietaryFiberUnit', models.CharField(max_length=2)),
|
|
('proteins', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='proteins')),
|
|
('proteinsUnit', models.CharField(max_length=2)),
|
|
('salt', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='salt')),
|
|
('saltUnit', models.CharField(max_length=2)),
|
|
('sodium', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='sodium')),
|
|
('sodiumUnit', models.CharField(max_length=2)),
|
|
('vitamin_a', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='vitamin_a')),
|
|
('vitamin_aUnit', models.CharField(max_length=2)),
|
|
('vitamin_b1', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='vitamin_b1')),
|
|
('vitamin_b1mUnit', models.CharField(max_length=2)),
|
|
('vitamin_b2', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='vitamin_b2')),
|
|
('vitamin_b2Unit', models.CharField(max_length=2)),
|
|
('vitamin_b3', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='vitamin_b3')),
|
|
('vitamin_b3Unit', models.CharField(max_length=2)),
|
|
('vitamin_b5', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='vitamin_b5')),
|
|
('vitamin_b5Unit', models.CharField(max_length=2)),
|
|
('vitamin_b7', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='vitamin_b7')),
|
|
('vitamin_b7Unit', models.CharField(max_length=2)),
|
|
('vitamin_b9', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='vitamin_b9')),
|
|
('vitamin_b9Unit', models.CharField(max_length=2)),
|
|
('vitamin_b12', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='vitamin_b12')),
|
|
('vitamin_b12Unit', models.CharField(max_length=2)),
|
|
('vitamin_c', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='vitamin_c')),
|
|
('vitamin_cUnit', models.CharField(max_length=2)),
|
|
('vitamin_d', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='vitamin_d')),
|
|
('vitamin_dUnit', models.CharField(max_length=2)),
|
|
('vitamin_e', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='vitamin_e')),
|
|
('vitamin_eUnit', models.CharField(max_length=2)),
|
|
('vitamin_k', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='vitamin_k')),
|
|
('vitamin_kUnit', models.CharField(max_length=2)),
|
|
('potassium', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='potassium')),
|
|
('potassiumUnit', models.CharField(max_length=2)),
|
|
('calcium', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='calcium')),
|
|
('calciumUnit', models.CharField(max_length=2)),
|
|
('magnesium', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='magnesium')),
|
|
('magnesiumUnit', models.CharField(max_length=2)),
|
|
('iron', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='iron')),
|
|
('ironUnit', models.CharField(max_length=2)),
|
|
('zinc', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='zinc')),
|
|
('zincUnit', models.CharField(max_length=2)),
|
|
('sulfat', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='sulfat')),
|
|
('sulfatUnit', models.CharField(max_length=2)),
|
|
('chlorid', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='chlorid')),
|
|
('chloridUnit', models.CharField(max_length=2)),
|
|
('hydrogencarbonat', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='hydrogencarbonat')),
|
|
('hydrogencarbonatUnit', models.CharField(max_length=2)),
|
|
],
|
|
),
|
|
migrations.CreateModel(
|
|
name='Purchase',
|
|
fields=[
|
|
('purchase_date', models.DateField(verbose_name='purchase date')),
|
|
('payment_type', models.CharField(default='EC', max_length=10, verbose_name='payment type')),
|
|
('total_price', models.DecimalField(decimal_places=2, default=0, max_digits=7, verbose_name='total price')),
|
|
('created', models.DateTimeField(db_index=True, default=django.utils.timezone.now, verbose_name='created')),
|
|
('modified', models.DateTimeField(auto_now=True, db_index=True, verbose_name='modified')),
|
|
('receipeImage', models.OneToOneField(blank=True, on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to='receipe.receipeimage')),
|
|
],
|
|
),
|
|
migrations.CreateModel(
|
|
name='PackagingArticle',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('weight', models.PositiveIntegerField(verbose_name='weight')),
|
|
('article_id', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='receipe.article', verbose_name='purchase id')),
|
|
('packaging_id', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='receipe.packaging', verbose_name='article id')),
|
|
],
|
|
),
|
|
migrations.CreateModel(
|
|
name='Market',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('name', models.CharField(max_length=50, verbose_name='market name')),
|
|
('street', models.CharField(max_length=50, verbose_name='street name')),
|
|
('street_number', models.PositiveIntegerField(verbose_name='street number')),
|
|
('zip_code', models.CharField(max_length=5, verbose_name='zip code')),
|
|
('city', models.CharField(max_length=50, verbose_name='city')),
|
|
('phone', receipe.models.CharNullField(blank=True, max_length=50, null=True, verbose_name='phone number')),
|
|
('created', models.DateTimeField(db_index=True, default=django.utils.timezone.now, verbose_name='created')),
|
|
('modified', models.DateTimeField(auto_now=True, db_index=True, verbose_name='modified')),
|
|
('articles', models.ManyToManyField(blank=True, to='receipe.article')),
|
|
],
|
|
),
|
|
migrations.CreateModel(
|
|
name='Category',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('name', models.CharField(max_length=50, unique=True, verbose_name='category name')),
|
|
('parent', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='receipe.category')),
|
|
],
|
|
),
|
|
migrations.CreateModel(
|
|
name='ArticleMaps',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('receipeString', models.CharField(max_length=50, verbose_name='receipe string')),
|
|
('location_x', models.PositiveIntegerField(verbose_name='x coordiante in image')),
|
|
('location_y', models.PositiveIntegerField(verbose_name='y coordiante in image')),
|
|
('location_h', models.PositiveIntegerField(verbose_name='height in image')),
|
|
('location_w', models.PositiveIntegerField(verbose_name='width in image')),
|
|
('article', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='receipe.article', verbose_name='article id')),
|
|
('receipeImage', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='receipe.receipeimage')),
|
|
],
|
|
),
|
|
migrations.AddField(
|
|
model_name='article',
|
|
name='brand',
|
|
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='receipe.brand', verbose_name='brand id'),
|
|
),
|
|
migrations.AddField(
|
|
model_name='article',
|
|
name='category',
|
|
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='receipe.category', verbose_name='category id'),
|
|
),
|
|
migrations.AddField(
|
|
model_name='article',
|
|
name='embs',
|
|
field=models.ManyToManyField(blank=True, to='receipe.embs'),
|
|
),
|
|
migrations.AddField(
|
|
model_name='article',
|
|
name='ingredients',
|
|
field=models.ManyToManyField(blank=True, to='receipe.ingredients'),
|
|
),
|
|
migrations.AddField(
|
|
model_name='article',
|
|
name='manufacturingPlaces',
|
|
field=models.ManyToManyField(blank=True, to='receipe.manufacturingplaces'),
|
|
),
|
|
migrations.AddField(
|
|
model_name='article',
|
|
name='originIngredients',
|
|
field=models.ManyToManyField(blank=True, to='receipe.originingredients'),
|
|
),
|
|
migrations.AddField(
|
|
model_name='article',
|
|
name='packaging',
|
|
field=models.ManyToManyField(blank=True, through='receipe.PackagingArticle', to='receipe.packaging'),
|
|
),
|
|
migrations.AddField(
|
|
model_name='article',
|
|
name='traces',
|
|
field=models.ManyToManyField(blank=True, to='receipe.traces'),
|
|
),
|
|
migrations.CreateModel(
|
|
name='PurchaseArticle',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('quantity', models.PositiveIntegerField(verbose_name='quantity')),
|
|
('net_weight', models.DecimalField(decimal_places=3, max_digits=7, verbose_name='net weight')),
|
|
('price', models.DecimalField(decimal_places=2, max_digits=7, verbose_name='price')),
|
|
('inSale', models.BooleanField(verbose_name='in sale')),
|
|
('article_id', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='receipe.article', verbose_name='article id')),
|
|
('purchase_id', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='receipe.purchase', verbose_name='purchase id')),
|
|
],
|
|
),
|
|
migrations.AddField(
|
|
model_name='purchase',
|
|
name='articles',
|
|
field=models.ManyToManyField(through='receipe.PurchaseArticle', to='receipe.article'),
|
|
),
|
|
migrations.AddField(
|
|
model_name='purchase',
|
|
name='market',
|
|
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='receipe.market', verbose_name='market id'),
|
|
),
|
|
]
|