# -*- coding: utf-8 -*- from __future__ import unicode_literals import datetime import django.core.validators import django.db.models.deletion from django.db import migrations, models class Migration(migrations.Migration): dependencies = [("gestioncof", "0007_alter_club")] operations = [ migrations.CreateModel( name="Account", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ( "trigramme", models.CharField( max_length=3, validators=[ django.core.validators.RegexValidator(regex="^[^a-z]{3}$") ], unique=True, ), ), ( "balance", models.DecimalField(decimal_places=2, default=0, max_digits=6), ), ("frozen", models.BooleanField(default=False)), ( "promo", models.IntegerField( null=True, blank=True, choices=[ (1980, 1980), (1981, 1981), (1982, 1982), (1983, 1983), (1984, 1984), (1985, 1985), (1986, 1986), (1987, 1987), (1988, 1988), (1989, 1989), (1990, 1990), (1991, 1991), (1992, 1992), (1993, 1993), (1994, 1994), (1995, 1995), (1996, 1996), (1997, 1997), (1998, 1998), (1999, 1999), (2000, 2000), (2001, 2001), (2002, 2002), (2003, 2003), (2004, 2004), (2005, 2005), (2006, 2006), (2007, 2007), (2008, 2008), (2009, 2009), (2010, 2010), (2011, 2011), (2012, 2012), (2013, 2013), (2014, 2014), (2015, 2015), (2016, 2016), ], default=2015, ), ), ("nickname", models.CharField(max_length=255, blank=True, default="")), ( "password", models.CharField( max_length=255, blank=True, null=True, unique=True, default=None ), ), ( "cofprofile", models.OneToOneField( on_delete=django.db.models.deletion.PROTECT, related_name="account_kfet", to="gestioncof.CofProfile", ), ), ], ), migrations.CreateModel( name="AccountNegative", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ( "start", models.DateTimeField( default=datetime.datetime(2016, 8, 2, 10, 22, 1, 569492) ), ), ("balance_offset", models.DecimalField(decimal_places=2, max_digits=6)), ( "authorized_overdraft", models.DecimalField(decimal_places=2, default=0, max_digits=6), ), ("comment", models.CharField(max_length=255, blank=True)), ( "account", models.OneToOneField( on_delete=django.db.models.deletion.PROTECT, related_name="negative", to="kfet.Account", ), ), ], ), migrations.CreateModel( name="Article", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("name", models.CharField(max_length=45)), ("is_sold", models.BooleanField(default=True)), ("price", models.DecimalField(decimal_places=2, max_digits=6)), ("stock", models.IntegerField(default=0)), ], ), migrations.CreateModel( name="ArticleCategory", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("name", models.CharField(max_length=45)), ], ), migrations.CreateModel( name="ArticleRule", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("ratio", models.PositiveSmallIntegerField()), ( "article_on", models.OneToOneField( on_delete=django.db.models.deletion.PROTECT, related_name="rule_on", to="kfet.Article", ), ), ( "article_to", models.OneToOneField( on_delete=django.db.models.deletion.PROTECT, related_name="rule_to", to="kfet.Article", ), ), ], ), migrations.CreateModel( name="Checkout", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("name", models.CharField(max_length=45)), ("valid_from", models.DateTimeField()), ("valid_to", models.DateTimeField()), ("balance", models.DecimalField(decimal_places=2, max_digits=6)), ("is_protected", models.BooleanField(default=False)), ( "created_by", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="+", to="kfet.Account", ), ), ], ), migrations.CreateModel( name="CheckoutTransfer", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("amount", models.DecimalField(decimal_places=2, max_digits=6)), ( "from_checkout", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="transfers_from", to="kfet.Checkout", ), ), ( "to_checkout", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="transfers_to", to="kfet.Checkout", ), ), ], ), migrations.CreateModel( name="Inventory", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("at", models.DateTimeField(auto_now_add=True)), ], ), migrations.CreateModel( name="InventoryArticle", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("stock_old", models.IntegerField()), ("stock_new", models.IntegerField()), ("stock_error", models.IntegerField(default=0)), ( "article", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, to="kfet.Article" ), ), ( "inventory", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, to="kfet.Inventory" ), ), ], ), migrations.CreateModel( name="Operation", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ( "type", models.CharField( max_length=8, choices=[ ("purchase", "Achat"), ("deposit", "Charge"), ("withdraw", "Retrait"), ], ), ), ("amount", models.DecimalField(decimal_places=2, max_digits=6)), ("on_checkout", models.BooleanField(default=True)), ( "canceled_at", models.DateTimeField(blank=True, null=True, default=None), ), ("addcost_amount", models.DecimalField(decimal_places=2, max_digits=6)), ( "addcost_for", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, blank=True, related_name="addcosts", to="kfet.Account", null=True, default=None, ), ), ( "article", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, blank=True, related_name="operations", to="kfet.Article", null=True, default=None, ), ), ( "canceled_by", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, blank=True, related_name="+", to="kfet.Account", null=True, default=None, ), ), ], ), migrations.CreateModel( name="OperationGroup", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("at", models.DateTimeField(auto_now_add=True)), ("amount", models.IntegerField()), ("is_cof", models.BooleanField(default=False)), ("comment", models.CharField(max_length=255, blank=True, default="")), ( "checkout", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="operations", to="kfet.Checkout", ), ), ( "on_acc", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="operations", to="kfet.Account", ), ), ( "valid_by", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, blank=True, related_name="+", to="kfet.Account", null=True, default=True, ), ), ], ), migrations.CreateModel( name="Order", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("at", models.DateTimeField(auto_now_add=True)), ("amount", models.DecimalField(decimal_places=2, max_digits=6)), ], ), migrations.CreateModel( name="OrderArticle", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("quantity_ordered", models.IntegerField()), ("quantity_received", models.IntegerField()), ( "article", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, to="kfet.Article" ), ), ( "order", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, to="kfet.Order" ), ), ], ), migrations.CreateModel( name="Statement", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("balance_old", models.DecimalField(decimal_places=2, max_digits=6)), ("balance_new", models.DecimalField(decimal_places=2, max_digits=6)), ("amount_taken", models.DecimalField(decimal_places=2, max_digits=6)), ("amount_error", models.DecimalField(decimal_places=2, max_digits=6)), ("at", models.DateTimeField(auto_now_add=True)), ( "by", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="+", to="kfet.Account", ), ), ( "checkout", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="statements", to="kfet.Checkout", ), ), ], ), migrations.CreateModel( name="Supplier", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("name", models.CharField(max_length=45)), ("address", models.TextField()), ("email", models.EmailField(max_length=254)), ("phone", models.CharField(max_length=10)), ("comment", models.TextField()), ], ), migrations.CreateModel( name="SupplierArticle", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ( "box_type", models.CharField( max_length=7, choices=[ ("caisse", "Caisse"), ("carton", "Carton"), ("palette", "Palette"), ("fût", "Fût"), ], ), ), ("box_capacity", models.PositiveSmallIntegerField()), ("price_HT", models.DecimalField(decimal_places=4, max_digits=7)), ("TVA", models.DecimalField(decimal_places=2, max_digits=4)), ("rights", models.DecimalField(decimal_places=4, max_digits=7)), ( "article", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, to="kfet.Article" ), ), ( "supplier", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, to="kfet.Supplier" ), ), ], ), migrations.CreateModel( name="Transfer", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("amount", models.DecimalField(decimal_places=2, max_digits=6)), ( "canceled_at", models.DateTimeField(blank=True, null=True, default=None), ), ( "canceled_by", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, blank=True, related_name="+", to="kfet.Account", null=True, default=None, ), ), ( "from_acc", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="transfers_from", to="kfet.Account", ), ), ], ), migrations.CreateModel( name="TransferGroup", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("at", models.DateTimeField(auto_now_add=True)), ("comment", models.CharField(max_length=255, blank=True, default="")), ( "valid_by", models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, blank=True, related_name="+", to="kfet.Account", null=True, default=None, ), ), ], ), migrations.AddField( model_name="transfer", name="group", field=models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="transfers", to="kfet.TransferGroup", ), ), migrations.AddField( model_name="transfer", name="to_acc", field=models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="transfers_to", to="kfet.Account", ), ), migrations.AddField( model_name="supplier", name="articles", field=models.ManyToManyField( related_name="suppliers", through="kfet.SupplierArticle", to="kfet.Article", ), ), migrations.AddField( model_name="order", name="articles", field=models.ManyToManyField( related_name="orders", through="kfet.OrderArticle", to="kfet.Article" ), ), migrations.AddField( model_name="order", name="supplier", field=models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="orders", to="kfet.Supplier", ), ), migrations.AddField( model_name="operation", name="group", field=models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="+", to="kfet.OperationGroup", ), ), migrations.AddField( model_name="inventory", name="articles", field=models.ManyToManyField( related_name="inventories", through="kfet.InventoryArticle", to="kfet.Article", ), ), migrations.AddField( model_name="inventory", name="by", field=models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="+", to="kfet.Account", ), ), migrations.AddField( model_name="inventory", name="order", field=models.OneToOneField( on_delete=django.db.models.deletion.PROTECT, blank=True, related_name="inventory", to="kfet.Order", null=True, default=None, ), ), migrations.AddField( model_name="article", name="category", field=models.ForeignKey( on_delete=django.db.models.deletion.PROTECT, related_name="articles", to="kfet.ArticleCategory", ), ), ]