def set_up_test_model( self, app_label, second_model=False, third_model=False, index=False, multicol_index=False, related_model=False, mti_model=False, proxy_model=False, manager_model=False, unique_together=False, options=False, db_table=None, index_together=False, constraints=None, ): """Creates a test model state and database table.""" # Make the "current" state. model_options = { 'swappable': 'TEST_SWAP_MODEL', 'index_together': [['weight', 'pink']] if index_together else [], 'unique_together': [['pink', 'weight']] if unique_together else [], } if options: model_options['permissions'] = [('can_groom', 'Can groom')] if db_table: model_options['db_table'] = db_table operations = [migrations.CreateModel( 'Pony', [ ('id', models.AutoField(primary_key=True)), ('pink', models.IntegerField(default=3)), ('weight', models.FloatField()), ], options=model_options, )] if index: operations.append(migrations.AddIndex( 'Pony', models.Index(fields=['pink'], name='pony_pink_idx'), )) if multicol_index: operations.append(migrations.AddIndex( 'Pony', models.Index(fields=['pink', 'weight'], name='pony_test_idx'), )) if constraints: for constraint in constraints: operations.append(migrations.AddConstraint('Pony', constraint)) if second_model: operations.append(migrations.CreateModel( 'Stable', [ ('id', models.AutoField(primary_key=True)), ] )) if third_model: operations.append(migrations.CreateModel( 'Van', [ ('id', models.AutoField(primary_key=True)), ] )) if related_model: operations.append(migrations.CreateModel( 'Rider', [ ('id', models.AutoField(primary_key=True)), ('pony', models.ForeignKey('Pony', models.CASCADE)), ('friend', models.ForeignKey('self', models.CASCADE, null=True)) ], )) if mti_model: operations.append(migrations.CreateModel( 'ShetlandPony', fields=[ ('pony_ptr', models.OneToOneField( 'Pony', models.CASCADE, auto_created=True, parent_link=True, primary_key=True, to_field='id', serialize=False, )), ('cuteness', models.IntegerField(default=1)), ], bases=['%s.Pony' % app_label], )) if proxy_model: operations.append(migrations.CreateModel( 'ProxyPony', fields=[], options={'proxy': True}, bases=['%s.Pony' % app_label], )) if manager_model: from .models import FoodManager, FoodQuerySet operations.append(migrations.CreateModel( 'Food', fields=[ ('id', models.AutoField(primary_key=True)), ], managers=[ ('food_qs', FoodQuerySet.as_manager()), ('food_mgr', FoodManager('a', 'b')), ('food_mgr_kwargs', FoodManager('x', 'y', 3, 4)), ] )) return self.apply_operations(app_label, ProjectState(), operations)
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0011_update_proxy_permissions'), ] operations = [ migrations.CreateModel( name='Producer', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=50)), ], ), migrations.CreateModel( name='Product', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=50)), ('composition', models.CharField(max_length=255)), ('barcode', models.BigIntegerField()), ('image', models.ImageField(upload_to='images/products')), ('producer', models.ForeignKey( on_delete=django.db.models.deletion.DO_NOTHING, related_name='products', to='api.Producer')), ], ), migrations.CreateModel( name='Store', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('address', models.CharField(max_length=100)), ('name', models.CharField(blank=True, max_length=100)), ('long', models.DecimalField(decimal_places=6, default=0, max_digits=9)), ('lat', models.DecimalField(decimal_places=6, default=0, max_digits=9)), ], ), migrations.CreateModel( name='StoreChain', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=50)), ], ), migrations.CreateModel( name='Transaction', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('date', models.DateTimeField(auto_now_add=True)), ('transaction_amount', models.DecimalField(decimal_places=6, default=0, max_digits=9)), ('vendor_name', models.CharField(max_length=150)), ], ), migrations.CreateModel( name='TransactionItem', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('product_name', models.CharField(max_length=100)), ('price', models.DecimalField(decimal_places=6, default=0, max_digits=9)), ('amount', models.PositiveIntegerField()), ('transaction', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='transaction_items', to='api.Transaction')), ], ), migrations.CreateModel( name='StoreItem', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('amount', models.PositiveIntegerField()), ('price', models.FloatField()), ('product', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='store_items', to='api.Product')), ('store', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='store_items', to='api.Store')), ], ), migrations.AddField( model_name='store', name='store_chain', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='stores', to='api.StoreChain'), ), migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(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')), ('phone_number', models.CharField( max_length=15, unique=True, validators=[ django.core.validators.RegexValidator( message= "Phone number must be entered in the format: '+999999999'. Up to 15 digits allowed.", regex='^\\+?1?\\d{9,15}$') ])), ('name', models.CharField(blank=True, max_length=100)), ('age', models.PositiveIntegerField(null=True)), ('date_joined', models.DateTimeField(auto_now_add=True)), ('is_active', models.BooleanField(default=True)), ('is_verified', models.BooleanField(default=False)), ('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={ 'abstract': False, }, managers=[ ('objects', api.managers.UserManager()), ], ), migrations.AddConstraint( model_name='storeitem', constraint=models.UniqueConstraint(fields=('product', 'store'), name='one_product_per_store'), ), migrations.AddConstraint( model_name='product', constraint=models.UniqueConstraint(fields=('barcode', ), name='product_barcode'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0012_alter_user_first_name_max_length'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(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')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('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')), ('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()), ], ), migrations.CreateModel( name='DailyIntakesReport', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('date', models.DateField()), ('daily_norm_potassium_mg', models.PositiveIntegerField(blank=True, null=True)), ('daily_norm_proteins_mg', models.PositiveIntegerField(blank=True, null=True)), ('daily_norm_sodium_mg', models.PositiveIntegerField(blank=True, null=True)), ('daily_norm_phosphorus_mg', models.PositiveIntegerField(blank=True, null=True)), ('daily_norm_energy_kcal', models.PositiveIntegerField(blank=True, null=True)), ('daily_norm_liquids_ml', models.PositiveIntegerField(blank=True, null=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='+', to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Product', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name_lt', models.CharField(max_length=128, unique=True)), ('name_en', models.CharField(max_length=128, null=True)), ('kind', models.CharField(choices=[('Unknown', 'Unknown'), ('Food', 'Food'), ('Drink', 'Drink')], default='Unknown', max_length=16)), ('potassium_mg', models.DecimalField(decimal_places=2, max_digits=7, validators=[django.core.validators.MinValueValidator(Decimal('0'))])), ('proteins_mg', models.DecimalField(decimal_places=2, max_digits=7, validators=[django.core.validators.MinValueValidator(Decimal('0'))])), ('sodium_mg', models.DecimalField(decimal_places=2, max_digits=7, validators=[django.core.validators.MinValueValidator(Decimal('0'))])), ('phosphorus_mg', models.DecimalField(decimal_places=2, max_digits=7, validators=[django.core.validators.MinValueValidator(Decimal('0'))])), ('energy_kcal', models.PositiveSmallIntegerField()), ('liquids_ml', models.PositiveSmallIntegerField()), ('raw_id', models.CharField(blank=True, editable=False, max_length=64, null=True, unique=True)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ], options={ 'ordering': ('-pk',), }, ), migrations.CreateModel( name='UserProfile', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('gender', models.CharField(choices=[('Male', 'Male'), ('Female', 'Female')], max_length=8)), ('birthday', models.DateField()), ('height_cm', models.PositiveSmallIntegerField()), ('weight_kg', models.DecimalField(decimal_places=1, max_digits=4, validators=[django.core.validators.MinValueValidator(Decimal('10'))])), ('chronic_kidney_disease_years', models.PositiveSmallIntegerField()), ('chronic_kidney_disease_stage', models.CharField(choices=[('Unknown', 'Unknown'), ('Stage1', 'Stage1'), ('Stage2', 'Stage2'), ('Stage3', 'Stage3'), ('Stage4', 'Stage4'), ('Stage5', 'Stage5')], max_length=16)), ('dialysis_type', models.CharField(choices=[('Unknown', 'Unknown'), ('PeriotonicDialysis', 'Periotonicdialysis'), ('Hemodialysis', 'Hemodialysis'), ('PostTransplant', 'Posttransplant'), ('NotPerformed', 'Notperformed')], max_length=32)), ('diabetes_years', models.PositiveSmallIntegerField(blank=True, null=True)), ('diabetes_type', models.CharField(choices=[('Unknown', 'Unknown'), ('Type1', 'Type1'), ('Type2', 'Type2'), ('No', 'No')], default='Unknown', max_length=16)), ('diabetes_complications', models.CharField(choices=[('Unknown', 'Unknown'), ('No', 'No'), ('Yes', 'Yes')], default='Unknown', max_length=8)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='profile', to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Intake', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('consumed_at', models.DateTimeField()), ('amount_g', models.PositiveSmallIntegerField(validators=[django.core.validators.MinValueValidator(1)])), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('daily_report', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='intakes', to='core.dailyintakesreport')), ('product', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='intakes', to='core.product')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='+', to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='DailyHealthStatus', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('date', models.DateField()), ('systolic_blood_pressure', models.PositiveSmallIntegerField(blank=True, null=True)), ('diastolic_blood_pressure', models.PositiveSmallIntegerField(blank=True, null=True)), ('weight_kg', models.DecimalField(blank=True, decimal_places=1, max_digits=4, null=True, validators=[django.core.validators.MinValueValidator(Decimal('10'))])), ('glucose', models.DecimalField(blank=True, decimal_places=2, max_digits=7, null=True, validators=[django.core.validators.MinValueValidator(Decimal('0'))])), ('urine_ml', models.PositiveSmallIntegerField(blank=True, null=True)), ('swelling_difficulty', models.CharField(choices=[('Unknown', 'Unknown'), ('0+', 'Difficulty0'), ('1+', 'Difficulty1'), ('2+', 'Difficulty2'), ('3+', 'Difficulty3'), ('4+', 'Difficulty4')], default='Unknown', max_length=16)), ('well_feeling', models.CharField(choices=[('Unknown', 'Unknown'), ('Perfect', 'Perfect'), ('Good', 'Good'), ('Average', 'Average'), ('Bad', 'Bad'), ('VeryBad', 'Verybad')], default='Unknown', max_length=16)), ('appetite', models.CharField(choices=[('Unknown', 'Unknown'), ('Perfect', 'Perfect'), ('Good', 'Good'), ('Average', 'Average'), ('Bad', 'Bad'), ('VeryBad', 'Verybad')], default='Unknown', max_length=16)), ('shortness_of_breath', models.CharField(choices=[('Unknown', 'Unknown'), ('No', 'No'), ('Light', 'Light'), ('Average', 'Average'), ('Severe', 'Severe'), ('Backbreaking', 'Backbreaking')], default='Unknown', max_length=16)), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='+', to=settings.AUTH_USER_MODEL)), ], ), migrations.AddIndex( model_name='intake', index=models.Index(fields=['user', '-consumed_at'], name='core_intake_user_id_1c31fd_idx'), ), migrations.AddConstraint( model_name='dailyintakesreport', constraint=models.UniqueConstraint(fields=('user', 'date'), name='unique_user_date_daily_intakes_report'), ), migrations.AddConstraint( model_name='dailyhealthstatus', constraint=models.UniqueConstraint(fields=('user', 'date'), name='unique_user_date_daily_health_status'), ), ]
class Migration(migrations.Migration): replaces = [('char_info', '0005_auto_20190519_1146'), ('char_info', '0006_auto_20190519_1202')] dependencies = [ ('char_info', '0004_auto_20190516_2030'), ] operations = [ migrations.AlterField( model_name='character', name='gender', field=models.CharField(blank=True, choices=[('Male', 'Male'), ('Female', 'Female'), ('Unknown', 'Unknown'), ('?', '?')], max_length=10, null=True), ), migrations.AddConstraint( model_name='appearance', constraint=models.UniqueConstraint(fields=('character', 'media'), name='unique_appearance'), ), migrations.AddConstraint( model_name='chapter', constraint=models.UniqueConstraint(fields=('media', 'number'), name='unique_chapter'), ), migrations.AddConstraint( model_name='character', constraint=models.UniqueConstraint(fields=('first_name', 'last_name'), name='unique_character'), ), migrations.AddConstraint( model_name='media', constraint=models.UniqueConstraint(fields=('english_name', 'media_type'), name='unique_media'), ), migrations.AddConstraint( model_name='murder', constraint=models.UniqueConstraint(fields=('murderer', 'murdered', 'chapter'), name='unique_murder'), ), migrations.AddConstraint( model_name='quote', constraint=models.UniqueConstraint(fields=('character', 'quote', 'media'), name='unique_quote'), ), migrations.AddConstraint( model_name='talent', constraint=models.UniqueConstraint(fields=('character', 'media', 'talent'), name='unique_talent'), ), migrations.AlterField( model_name='character', name='birth_month', field=models.PositiveSmallIntegerField(blank=True, choices=[(1, 'January'), (2, 'February'), (3, 'March'), (4, 'April'), (5, 'May'), (6, 'June'), (7, 'July'), (8, 'August'), (9, 'September'), (10, 'October'), (11, 'November'), (12, 'December')], null=True), ), migrations.AddConstraint( model_name='character', constraint=models.CheckConstraint(check=models.Q( ('birth_day__gte', 1), ('birth_day__lte', 31)), name='birth_day_limit'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='Group', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=200)), ], ), migrations.CreateModel( name='Post', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('text', models.TextField()), ('pub_date', models.DateTimeField(auto_now_add=True, verbose_name='Дата публикации')), ('author', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='posts', to=settings.AUTH_USER_MODEL)), ('group', models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='posts', to='api.group')), ], ), migrations.CreateModel( name='Follow', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('following', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='following', to=settings.AUTH_USER_MODEL)), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='follower', to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Comment', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('text', models.TextField()), ('created', models.DateTimeField(auto_now_add=True, db_index=True, verbose_name='Дата добавления')), ('author', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='comments', to=settings.AUTH_USER_MODEL)), ('post', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='comments', to='api.post')), ], ), migrations.AddConstraint( model_name='follow', constraint=models.UniqueConstraint(fields=('user', 'following'), name='unique_following'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('clinics', '0001_initial'), ('users', '0001_initial'), ] operations = [ migrations.AddField( model_name='specialization', name='doctor', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='specializations', to='users.Doctor'), ), migrations.AddField( model_name='specialization', name='typeOf', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='clinics.AppointmentType'), ), migrations.AddField( model_name='pricelist', name='appointmentType', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='prices', to='clinics.AppointmentType'), ), migrations.AddField( model_name='pricelist', name='clinic', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='prices', to='clinics.Clinic'), ), migrations.AddField( model_name='operatingroom', name='clinic', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='operating_rooms', to='clinics.Clinic'), ), migrations.AddField( model_name='healthcard', name='patient', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='health_card', to='users.Patient'), ), migrations.AddField( model_name='doctorrating', name='doctor', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='ratings', to='users.Doctor'), ), migrations.AddField( model_name='doctorrating', name='patient', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='users.Patient'), ), migrations.AddField( model_name='clinicrating', name='clinic', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='ratings', to='clinics.Clinic'), ), migrations.AddField( model_name='clinicrating', name='patient', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='users.Patient'), ), migrations.AddField( model_name='appointment', name='clinic', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='appointments', to='clinics.Clinic'), ), migrations.AddField( model_name='appointment', name='doctor', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='appointments', to='users.Doctor'), ), migrations.AddField( model_name='appointment', name='operatingRoom', field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.CASCADE, to='clinics.OperatingRoom'), ), migrations.AddField( model_name='appointment', name='patient', field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.CASCADE, related_name='appointments', to='users.Patient'), ), migrations.AddField( model_name='appointment', name='typeOf', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='clinics.AppointmentType'), ), migrations.AddConstraint( model_name='pricelist', constraint=models.UniqueConstraint( fields=('clinic', 'appointmentType'), name='unique appointment type price for clinic'), ), migrations.AlterUniqueTogether( name='operatingroom', unique_together={('clinic', 'name')}, ), migrations.AddConstraint( model_name='doctorrating', constraint=models.UniqueConstraint( fields=('doctor', 'patient'), name='one doctor rating per patient'), ), migrations.AddConstraint( model_name='clinicrating', constraint=models.UniqueConstraint( fields=('clinic', 'patient'), name='one clinic rating per patient'), ), migrations.AddConstraint( model_name='appointment', constraint=models.UniqueConstraint( fields=('clinic', 'date', 'time', 'doctor'), name='unique doctor date time for a clinic'), ), ]
class Migration(migrations.Migration): dependencies = [ ('auth', '0011_update_proxy_permissions'), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('restaurantratingapi', '0001_initial'), ] operations = [ migrations.CreateModel( name='CheckIn', fields=[ ('check_in_id', models.AutoField(primary_key=True, serialize=False)), ('date', models.DateTimeField(auto_now_add=True)), ], options={ 'db_table': 'check_in', 'managed': True, }, ), migrations.CreateModel( name='Dish', fields=[ ('dish_id', models.AutoField(primary_key=True, serialize=False)), ('dish_name', models.CharField(max_length=50)), ('status', models.PositiveIntegerField()), ('created_on', models.DateTimeField(auto_now_add=True)), ('updated_on', models.DateTimeField(auto_now=True, null=True)), ('created_by', models.ForeignKey(db_column='created_by', on_delete=django.db.models.deletion.DO_NOTHING, related_name='dish_created_by', to=settings.AUTH_USER_MODEL)), ('updated_by', models.ForeignKey(blank=True, db_column='updated_by', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='dish_updated_by', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'dish', 'managed': True, }, ), migrations.CreateModel( name='EditComponent', fields=[ ('component_id', models.SmallAutoField(primary_key=True, serialize=False)), ('component_name', models.CharField(max_length=255)), ('confirmation_point_level', models.PositiveIntegerField()), ], options={ 'db_table': 'edit_component', 'managed': True, }, ), migrations.CreateModel( name='EditHistory', fields=[ ('history_id', models.AutoField(primary_key=True, serialize=False)), ('current_value', models.CharField(max_length=255)), ('requested_value', models.CharField(max_length=255)), ('status', models.PositiveIntegerField()), ('created_on', models.DateTimeField(auto_now_add=True)), ('updated_on', models.DateTimeField(auto_now=True, null=True)), ('confirmed_by', models.ForeignKey(db_column='confirmed_by', on_delete=django.db.models.deletion.DO_NOTHING, related_name='edit_history_confirmed_by', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'edit_history', 'managed': True, }, ), migrations.CreateModel( name='Meal', fields=[ ('meal_id', models.AutoField(primary_key=True, serialize=False)), ('meal_name', models.CharField(max_length=50)), ], options={ 'db_table': 'meal', 'managed': True, }, ), migrations.CreateModel( name='Rating', fields=[ ('rating_id', models.BigAutoField(primary_key=True, serialize=False)), ('dish_rating', models.PositiveIntegerField(blank=True, null=True)), ('price_rating', models.PositiveIntegerField(blank=True, null=True)), ('service_rating', models.PositiveIntegerField(blank=True, null=True)), ('verified', models.PositiveIntegerField()), ('created_on', models.DateTimeField(auto_now_add=True)), ('updated_on', models.DateTimeField(auto_now=True, null=True)), ], options={ 'db_table': 'rating', 'managed': True, }, ), migrations.CreateModel( name='Reporting', fields=[ ('reporting_id', models.AutoField(primary_key=True, serialize=False)), ('message', models.TextField(blank=True, null=True)), ('created_on', models.DateTimeField(auto_now_add=True)), ('updated_on', models.DateTimeField(auto_now=True, null=True)), ('reporter', models.ForeignKey(db_column='reporter', on_delete=django.db.models.deletion.DO_NOTHING, related_name='reporting_type_reporter', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'reporting', 'managed': True, }, ), migrations.CreateModel( name='Restaurant', fields=[ ('restaurant_id', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(max_length=255)), ('address', models.CharField(max_length=255)), ('longitude', models.FloatField(null=True)), ('latitude', models.FloatField(null=True)), ('phone_number', models.CharField(blank=True, max_length=50, null=True, validators=[django.core.validators.RegexValidator(message="Phone number must be entered in the format: '+999999999'. Up to 15 digits allowed.", regex='^\\+?1?\\d{9,15}$')])), ('claimed', models.PositiveIntegerField()), ('code', models.CharField(max_length=50)), ('created_on', models.DateTimeField(auto_now_add=True)), ('updated_on', models.DateTimeField(auto_now=True, null=True)), ('claimed_by', models.ForeignKey(blank=True, db_column='claimed_by', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to=settings.AUTH_USER_MODEL)), ('created_by', models.ForeignKey(db_column='created_by', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='restaurant_created_by', to=settings.AUTH_USER_MODEL)), ('updated_by', models.ForeignKey(blank=True, db_column='updated_by', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='restaurant_updated_by', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'restaurant', 'managed': True, }, ), migrations.CreateModel( name='AddedDishRating', fields=[ ('rating', models.OneToOneField(db_column='rating_id', on_delete=django.db.models.deletion.CASCADE, primary_key=True, related_name='added_dish_rating_rating', serialize=False, to='restaurantratingapi.Rating')), ('longitude', models.FloatField(blank=True, null=True)), ('latitude', models.FloatField(blank=True, null=True)), ('updated_on', models.DateTimeField(blank=True, null=True)), ], options={ 'db_table': 'added_dish_rating', 'managed': True, }, ), migrations.CreateModel( name='AddedRating', fields=[ ('rating', models.OneToOneField(db_column='rating_id', on_delete=django.db.models.deletion.CASCADE, primary_key=True, related_name='added_rating_rating', serialize=False, to='restaurantratingapi.Rating')), ('longitude', models.FloatField(blank=True, null=True)), ('latitude', models.FloatField(blank=True, null=True)), ('updated_on', models.DateTimeField(auto_now=True, null=True)), ], options={ 'db_table': 'added_rating', 'managed': True, }, ), migrations.CreateModel( name='CustomerCheckIn', fields=[ ('check_in', models.OneToOneField(db_column='check_in_id', on_delete=django.db.models.deletion.DO_NOTHING, primary_key=True, related_name='customer_check_in_check_in', serialize=False, to='restaurantratingapi.CheckIn')), ], options={ 'db_table': 'customer_check_in', 'managed': True, }, ), migrations.CreateModel( name='RestaurantComponentReporting', fields=[ ('reporting', models.OneToOneField(db_column='reporting_id', on_delete=django.db.models.deletion.CASCADE, primary_key=True, related_name='resraurant_component_reporting_reporting', serialize=False, to='restaurantratingapi.Reporting')), ], options={ 'db_table': 'restaurant_component_reporting', 'managed': True, }, ), migrations.CreateModel( name='RestaurantReporting', fields=[ ('reporting', models.OneToOneField(db_column='reporting_id', on_delete=django.db.models.deletion.CASCADE, primary_key=True, related_name='restaurant_reporting_reporting', serialize=False, to='restaurantratingapi.Reporting')), ], options={ 'db_table': 'restaurant_reporting', 'managed': True, }, ), migrations.CreateModel( name='Review', fields=[ ('rating', models.OneToOneField(db_column='rating_id', on_delete=django.db.models.deletion.DO_NOTHING, primary_key=True, related_name='review_rating', serialize=False, to='restaurantratingapi.Rating')), ('message', models.TextField(blank=True, null=True)), ('attachment', models.ImageField(blank=True, null=True, upload_to='')), ('upvote_count', models.PositiveIntegerField()), ('report_count', models.PositiveIntegerField(db_column='report count')), ('updated_on', models.DateTimeField(auto_now=True, null=True)), ], options={ 'db_table': 'review', 'managed': True, }, ), migrations.CreateModel( name='ReviewReplyReporting', fields=[ ('reporting', models.OneToOneField(db_column='reporting_id', on_delete=django.db.models.deletion.DO_NOTHING, primary_key=True, related_name='review_reply_reporting_reporting', serialize=False, to='restaurantratingapi.Reporting')), ], options={ 'db_table': 'review_reply_reporting', 'managed': True, }, ), migrations.CreateModel( name='ReviewReporting', fields=[ ('reporting', models.OneToOneField(db_column='reporting_id', on_delete=django.db.models.deletion.CASCADE, primary_key=True, related_name='review_reporting_reporting', serialize=False, to='restaurantratingapi.Reporting')), ], options={ 'db_table': 'review_reporting', 'managed': True, }, ), migrations.CreateModel( name='WarningLevel', fields=[ ('warning_level', models.AutoField(primary_key=True, serialize=False)), ('warning_level_name', models.CharField(max_length=50)), ('allocated_points', models.PositiveIntegerField()), ('created_on', models.DateTimeField(auto_now_add=True)), ('updated_on', models.DateTimeField(auto_now=True)), ('created_by', models.ForeignKey(db_column='created_by', on_delete=django.db.models.deletion.DO_NOTHING, related_name='warning_level_created_by', to=settings.AUTH_USER_MODEL)), ('updated_by', models.ForeignKey(blank=True, db_column='updated_by', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='warning_level_updated_by', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'warning_level', 'managed': True, }, ), migrations.CreateModel( name='Warning', fields=[ ('warning_id', models.AutoField(primary_key=True, serialize=False)), ('message', models.TextField()), ('created_on', models.DateTimeField(auto_now_add=True)), ('updated_on', models.DateTimeField(auto_now=True)), ('created_by', models.ForeignKey(db_column='created_by', on_delete=django.db.models.deletion.DO_NOTHING, related_name='warning_created_by', to=settings.AUTH_USER_MODEL)), ('updated_by', models.ForeignKey(blank=True, db_column='updated_by', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='warning_updated_by', to=settings.AUTH_USER_MODEL)), ('warning_level', models.ForeignKey(db_column='warning_level', on_delete=django.db.models.deletion.DO_NOTHING, related_name='warning_warning_level', to='restaurantratingapi.WarningLevel')), ], options={ 'db_table': 'warning', 'managed': True, }, ), migrations.CreateModel( name='UserLevel', fields=[ ('level_number', models.PositiveSmallIntegerField(primary_key=True, serialize=False)), ('points_level', models.PositiveIntegerField()), ('allocated_comfirmation_points', models.PositiveIntegerField()), ('created_on', models.DateTimeField(auto_now_add=True)), ('updated_on', models.DateTimeField(auto_now=True, null=True)), ('created_by', models.ForeignKey(blank=True, db_column='created_by', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='user_level_reated_by', to=settings.AUTH_USER_MODEL)), ('updated_by', models.ForeignKey(blank=True, db_column='updated_by', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='user_level_updated_by', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'user_level', 'managed': True, }, ), migrations.CreateModel( name='UserEditHistoryConfirmation', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('confirmation_points', models.IntegerField()), ('created_on', models.DateTimeField(auto_now_add=True)), ('history', models.ForeignKey(db_column='history_id', on_delete=django.db.models.deletion.DO_NOTHING, related_name='user_edit_history_confirmation_history', to='restaurantratingapi.EditHistory')), ('user', models.ForeignKey(db_column='user_id', on_delete=django.db.models.deletion.DO_NOTHING, related_name='user_edit_history_confirmation_user', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'user_edit_history_confirmation', 'managed': True, }, ), migrations.CreateModel( name='UserEditHistoryComponent', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created_on', models.DateTimeField(auto_now_add=True)), ('updated_on', models.DateTimeField(auto_now=True, null=True)), ('component', models.ForeignKey(db_column='component_id', on_delete=django.db.models.deletion.CASCADE, related_name='user_edit_history_component_component', to='restaurantratingapi.EditComponent')), ('history', models.ForeignKey(db_column='history_id', on_delete=django.db.models.deletion.CASCADE, related_name='user_edit_history_component_history', to='restaurantratingapi.EditHistory')), ('restaurant', models.ForeignKey(db_column='restaurant_id', on_delete=django.db.models.deletion.CASCADE, related_name='user_edit_history_component_restaurant', to='restaurantratingapi.Restaurant')), ('user', models.ForeignKey(db_column='user_id', on_delete=django.db.models.deletion.DO_NOTHING, related_name='user_edit_history_component_user', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'user_edit_history_component', 'managed': True, }, ), migrations.CreateModel( name='Token', fields=[ ('token_number', models.CharField(max_length=10, primary_key=True, serialize=False)), ('created_on', models.DateTimeField(auto_now_add=True)), ('created_by', models.ForeignKey(db_column='created_by', on_delete=django.db.models.deletion.DO_NOTHING, related_name='token_created_by', to=settings.AUTH_USER_MODEL)), ('restaurant', models.ForeignKey(db_column='restaurant_id', on_delete=django.db.models.deletion.DO_NOTHING, related_name='token_restaurant', to='restaurantratingapi.Restaurant')), ], options={ 'db_table': 'token', 'managed': True, }, ), migrations.CreateModel( name='RestaurantMeal', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created_on', models.DateTimeField(auto_now_add=True)), ('updated_on', models.DateTimeField(auto_now=True, null=True)), ('created_by', models.ForeignKey(db_column='created_by', on_delete=django.db.models.deletion.DO_NOTHING, related_name='restaurant_meal_created_by', to=settings.AUTH_USER_MODEL)), ('meal', models.OneToOneField(on_delete=django.db.models.deletion.PROTECT, to='restaurantratingapi.Meal')), ('restaurant', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='restaurantratingapi.Restaurant')), ('updated_by', models.ForeignKey(blank=True, db_column='updated_by', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='restaurant_meal_updated_by', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'restaurant_meal', 'managed': True, }, ), migrations.CreateModel( name='RestaurantDish', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('status', models.PositiveIntegerField()), ('created_on', models.DateTimeField(auto_now_add=True)), ('updated_on', models.DateTimeField(auto_now=True, null=True)), ('added_by', models.ForeignKey(db_column='added_by', null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='restaurant_dish_added_by', to=settings.AUTH_USER_MODEL)), ('dish', models.ForeignKey(db_column='dish_id', on_delete=django.db.models.deletion.PROTECT, related_name='restaurant_dish_dish', to='restaurantratingapi.Dish')), ('restaurant', models.ForeignKey(db_column='restaurant_id', on_delete=django.db.models.deletion.CASCADE, related_name='restaurant_dish_restaurant', to='restaurantratingapi.Restaurant')), ('updated_by', models.ForeignKey(blank=True, db_column='updated_by', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='restaurant_dish_updated_by', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'restaurant_dish', 'managed': True, }, ), migrations.CreateModel( name='ReportingType', fields=[ ('reporting_type_id', models.AutoField(primary_key=True, serialize=False)), ('reporting_type_name', models.CharField(max_length=50)), ('created_on', models.DateTimeField(auto_now_add=True)), ('updated_on', models.DateTimeField(auto_now=True, null=True)), ('created_by', models.ForeignKey(db_column='created_by', on_delete=django.db.models.deletion.DO_NOTHING, related_name='report_type_created_by', to=settings.AUTH_USER_MODEL)), ('updated_by', models.ForeignKey(blank=True, db_column='updated_by', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='report_updated_by', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'reporting_type', 'managed': True, }, ), migrations.AddField( model_name='reporting', name='reporting_type', field=models.ForeignKey(db_column='reporting_type', on_delete=django.db.models.deletion.DO_NOTHING, related_name='reporting_reporting_type', to='restaurantratingapi.ReportingType'), ), migrations.AddField( model_name='reporting', name='updated_by', field=models.ForeignKey(blank=True, db_column='updated_by', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='reporting_type_updated_by', to=settings.AUTH_USER_MODEL), ), migrations.CreateModel( name='Reply', fields=[ ('reply_id', models.AutoField(primary_key=True, serialize=False)), ('message', models.TextField()), ('created_on', models.DateTimeField(auto_now_add=True)), ('updated_on', models.DateTimeField(auto_now_add=True, null=True)), ('created_by', models.ForeignKey(db_column='created_by', on_delete=django.db.models.deletion.DO_NOTHING, related_name='reply_created_by', to=settings.AUTH_USER_MODEL)), ('rating', models.ForeignKey(db_column='rating_id', on_delete=django.db.models.deletion.CASCADE, related_name='reply_rating', to='restaurantratingapi.Rating')), ('updated_by', models.ForeignKey(blank=True, db_column='updated_by', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='reply_updated_by', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'reply', 'managed': True, }, ), migrations.CreateModel( name='CustomUser', fields=[ ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, serialize=False, to=settings.AUTH_USER_MODEL)), ('account_status', models.PositiveSmallIntegerField()), ('email_code', models.CharField(max_length=255)), ('email_verified', models.PositiveSmallIntegerField()), ('birthday', models.DateField()), ('gender', models.PositiveSmallIntegerField()), ('address', models.CharField(max_length=255)), ('phone_number', models.CharField(max_length=50)), ('profile_picture', models.ImageField(null=True, upload_to='')), ('updated_on', models.DateTimeField(auto_now=True, null=True)), ('level_number', models.ForeignKey(db_column='level_number', on_delete=django.db.models.deletion.PROTECT, to='restaurantratingapi.UserLevel')), ('role_id', models.ForeignKey(db_column='role_id', on_delete=django.db.models.deletion.PROTECT, to='restaurantratingapi.UserRole')), ('updated_by', models.ForeignKey(blank=True, db_column='updated_by', null=True, on_delete=django.db.models.deletion.CASCADE, related_name='custom_user_updated_by', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'custom_user', 'managed': True, }, ), migrations.CreateModel( name='ContributionType', fields=[ ('contribution_type_id', models.AutoField(primary_key=True, serialize=False)), ('contribution_name', models.CharField(max_length=50)), ('allocated_points', models.PositiveIntegerField()), ('created_on', models.DateTimeField(auto_now_add=True)), ('updated_on', models.DateTimeField(auto_now=True, null=True)), ('created_by', models.ForeignKey(db_column='created_by', on_delete=django.db.models.deletion.DO_NOTHING, related_name='contribution_type_created_by', to=settings.AUTH_USER_MODEL)), ('updated_by', models.ForeignKey(blank=True, db_column='updated_by', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='contribution_type_updated_by', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'contribution_type', 'managed': True, }, ), migrations.CreateModel( name='Contribution', fields=[ ('contribution_id', models.AutoField(primary_key=True, serialize=False)), ('created_on', models.DateTimeField(auto_now_add=True)), ('contribution_type', models.ForeignKey(db_column='contribution_type', on_delete=django.db.models.deletion.DO_NOTHING, related_name='contribution_contribution_type', to='restaurantratingapi.ContributionType')), ('user', models.ForeignKey(db_column='user_id', on_delete=django.db.models.deletion.CASCADE, related_name='contribution_user', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'contribution', 'managed': True, }, ), migrations.CreateModel( name='UserReporting', fields=[ ('reporting', models.OneToOneField(db_column='reporting_id', on_delete=django.db.models.deletion.CASCADE, primary_key=True, related_name='user_reporting_reporting', serialize=False, to='restaurantratingapi.Reporting')), ('reporte', models.ForeignKey(db_column='reporte_id', on_delete=django.db.models.deletion.DO_NOTHING, related_name='user_reporting_reporte', to=settings.AUTH_USER_MODEL)), ], options={ 'db_table': 'user_reporting', 'managed': True, }, ), migrations.AddConstraint( model_name='useredithistoryconfirmation', constraint=models.UniqueConstraint(fields=('user_id', 'history_id'), name='unique_user_edit_history_confirmation'), ), migrations.AddConstraint( model_name='useredithistorycomponent', constraint=models.UniqueConstraint(fields=('user_id', 'history_id', 'restaurant_id', 'component_id'), name='unique_user_edit_history_component'), ), migrations.AddField( model_name='reviewreporting', name='rating', field=models.ForeignKey(db_column='rating_id', on_delete=django.db.models.deletion.DO_NOTHING, related_name='review_reporting_rating', to='restaurantratingapi.Rating'), ), migrations.AddField( model_name='reviewreplyreporting', name='reply', field=models.ForeignKey(db_column='reply_id', on_delete=django.db.models.deletion.DO_NOTHING, related_name='review_reply_reporting_reply', to='restaurantratingapi.Reply'), ), migrations.AddField( model_name='review', name='updated_by', field=models.ForeignKey(blank=True, db_column='updated_by', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='review_updated_by', to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='restaurantreporting', name='restaurant', field=models.ForeignKey(db_column='restaurant_id', on_delete=django.db.models.deletion.DO_NOTHING, related_name='restaurant_reporting_reporte', to='restaurantratingapi.Restaurant'), ), migrations.AddConstraint( model_name='restaurantmeal', constraint=models.UniqueConstraint(fields=('meal', 'restaurant'), name='unique_restaurant_meal'), ), migrations.AddConstraint( model_name='restaurantdish', constraint=models.UniqueConstraint(fields=('dish_id', 'restaurant_id', 'added_by'), name='unique_restaurant_dish'), ), migrations.AddField( model_name='restaurantcomponentreporting', name='component', field=models.ForeignKey(db_column='component_id', on_delete=django.db.models.deletion.DO_NOTHING, related_name='restaurant_component_reporting_component', to='restaurantratingapi.EditComponent'), ), migrations.AddField( model_name='restaurantcomponentreporting', name='restaurant', field=models.ForeignKey(db_column='restaurant_id', on_delete=django.db.models.deletion.DO_NOTHING, related_name='restaurant_component_reporting_reporte', to='restaurantratingapi.Restaurant'), ), migrations.AddField( model_name='customercheckin', name='restaurant', field=models.ForeignKey(db_column='restaurant_id', on_delete=django.db.models.deletion.DO_NOTHING, related_name='customer_check_in_restaurant', to='restaurantratingapi.Restaurant'), ), migrations.AddField( model_name='customercheckin', name='user', field=models.ForeignKey(db_column='user_id', on_delete=django.db.models.deletion.DO_NOTHING, related_name='customer_check_in_user_id', to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='addedrating', name='restaurant', field=models.ForeignKey(db_column='restaurant_id', on_delete=django.db.models.deletion.DO_NOTHING, related_name='added_rating_restaurant', to='restaurantratingapi.Restaurant'), ), migrations.AddField( model_name='addedrating', name='token_number', field=models.ForeignKey(blank=True, db_column='token_number', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='added_rating_token', to='restaurantratingapi.Token'), ), migrations.AddField( model_name='addedrating', name='user', field=models.ForeignKey(db_column='user_id', on_delete=django.db.models.deletion.DO_NOTHING, related_name='added_rating_user', to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='addeddishrating', name='dish', field=models.ForeignKey(db_column='dish_id', on_delete=django.db.models.deletion.DO_NOTHING, related_name='added_dish_rating_dish', to='restaurantratingapi.Dish'), ), migrations.AddField( model_name='addeddishrating', name='restaurant', field=models.ForeignKey(db_column='restaurant_id', on_delete=django.db.models.deletion.DO_NOTHING, related_name='added_dish_rating_restaurant', to='restaurantratingapi.Restaurant'), ), migrations.AddField( model_name='addeddishrating', name='token_number', field=models.ForeignKey(blank=True, db_column='token_number', null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='added_dish_rating_token', to='restaurantratingapi.Token'), ), migrations.AddField( model_name='addeddishrating', name='user', field=models.ForeignKey(db_column='user_id', on_delete=django.db.models.deletion.DO_NOTHING, related_name='added_dish_rating_user', to=settings.AUTH_USER_MODEL), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='Poll', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=1024, verbose_name='Poll title')), ('created', models.DateTimeField(auto_now_add=True, verbose_name='Poll created datetime')), ('start_date', models.DateField(verbose_name='Poll start date')), ('finish_date', models.DateField(verbose_name='Poll finish date')), ('description', models.CharField(max_length=8192, verbose_name='Poll description')), ], options={ 'verbose_name': 'Poll', 'verbose_name_plural': 'Polls', }, ), migrations.CreateModel( name='Question', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('text', models.CharField(max_length=4096, verbose_name='Question text')), ('type', models.CharField(choices=[('T', 'Text'), ('C', 'One choice'), ('M', 'Multipal choices')], default='T', max_length=1, verbose_name='Question type')), ('poll', models.ForeignKey( on_delete=django.db.models.deletion.DO_NOTHING, related_name='questions', to='polls.Poll')), ], options={ 'verbose_name': 'Question', 'verbose_name_plural': 'Questions', }, ), migrations.CreateModel( name='Choice', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('text', models.CharField(max_length=4096, verbose_name='Choice text')), ('question', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='choices', to='polls.Question')), ], options={ 'verbose_name': 'Choice', 'verbose_name_plural': 'Choices', }, ), migrations.CreateModel( name='AnswerGateway', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created', models.DateTimeField( auto_now_add=True, verbose_name="User's answers created datetime")), ('poll', models.ForeignKey( on_delete=django.db.models.deletion.DO_NOTHING, to='polls.Poll')), ('user', models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.DO_NOTHING, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Answer', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('value', models.CharField(blank=True, max_length=4096, null=True, verbose_name="User's answer text")), ('answer_gateway', models.ForeignKey( on_delete=django.db.models.deletion.DO_NOTHING, related_name='answers', to='polls.AnswerGateway')), ('choices', models.ManyToManyField(blank=True, null=True, to='polls.Choice')), ('question', models.ForeignKey( on_delete=django.db.models.deletion.DO_NOTHING, to='polls.Question')), ], options={ 'verbose_name': 'Answer', 'verbose_name_plural': 'Answers', }, ), migrations.AddConstraint( model_name='question', constraint=models.CheckConstraint( check=models.Q(type__in=('T', 'C', 'M')), name='%(app_label)s_%(class)s_type_valid'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ("auth", "0012_alter_user_first_name_max_length"), ] operations = [ migrations.CreateModel( name="User", fields=[ ( "id", models.AutoField( 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"), ), ( "email", models.EmailField(blank=True, max_length=254, verbose_name="email address"), ), ( "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"), ), ("token", models.CharField(blank=True, max_length=500, null=True)), ("admin", models.BooleanField(blank=True, null=True)), ( "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()), ], ), migrations.CreateModel( name="Schema", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("name", models.CharField(blank=True, max_length=500, null=True)), ("version", models.PositiveIntegerField()), ( "description", models.CharField(blank=True, max_length=5000, null=True), ), ("csv", models.FileField(blank=True, null=True, upload_to="")), ( "user", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="schemas", to=settings.AUTH_USER_MODEL, ), ), ], ), migrations.CreateModel( name="Block", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("nav", models.CharField(blank=True, max_length=5000, null=True)), ( "help_text", models.CharField(blank=True, help_text="AKA help", max_length=5000, null=True), ), ( "display_text", models.CharField(blank=True, help_text="AKA title", max_length=5000, null=True), ), ( "example_text", models.CharField(blank=True, help_text="AKA example", max_length=5000, null=True), ), ( "block_type", models.CharField( blank=True, choices=[ ("page-heading", "Page Heading"), ("section-heading", "Section Heading"), ("subsection-heading", "Subsection Heading"), ("paragraph", "Paragraph"), ("question-label", "Question Label"), ("short-text-input", "Short Text Input"), ("long-text-input", "Long Text Input"), ("file-input", "File Input"), ("contributors-input", "Contributors Input"), ("single-select-input", "Single Select Input"), ("multi-select-input", "Multi-select Input"), ("select-input-option", "Select Input Option"), ("select-other-option", "Select Other Option"), ], max_length=50000, null=True, ), ), ( "options", django.contrib.postgres.fields.ArrayField( base_field=models.CharField(max_length=100), blank=True, help_text="Enter as comma separated list", null=True, size=None, ), ), ("required", models.BooleanField(null=True)), ("index", models.PositiveIntegerField(blank=True, null=True)), ( "schema", models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="blocks", to="web.schema", ), ), ], ), migrations.AddConstraint( model_name="block", constraint=models.CheckConstraint( check=models.Q( models.Q(_negated=True, block_type="page-heading"), models.Q( ("example_text__isnull", True), ("block_type", "page-heading"), ("help_text__isnull", True), ), _connector="OR", ), name="check_page_heading", ), ), migrations.AddConstraint( model_name="block", constraint=models.CheckConstraint( check=models.Q( models.Q(_negated=True, block_type="section-heading"), models.Q( ("example_text__isnull", True), ("block_type", "section-heading"), ("help_text__isnull", True), ), _connector="OR", ), name="check_section_heading", ), ), migrations.AddConstraint( model_name="block", constraint=models.CheckConstraint( check=models.Q( models.Q(_negated=True, block_type="file-input"), models.Q( ("display_text__isnull", True), ("example_text__isnull", True), ("block_type", "file-input"), ("help_text__isnull", True), ), _connector="OR", ), name="check_file_input", ), ), migrations.AlterUniqueTogether( name="block", unique_together={("schema", "index")}, ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('recipes', '__first__'), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='Subscribe', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('author', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='following', to=settings.AUTH_USER_MODEL, verbose_name='Автор')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='follower', to=settings.AUTH_USER_MODEL, verbose_name='Подписчик')), ], options={ 'verbose_name': 'Подписка', 'verbose_name_plural': 'Подписки', }, ), migrations.CreateModel( name='Purchase', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('recipe', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='purchases', to='recipes.recipe', verbose_name='Рецепт')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='purchases', to=settings.AUTH_USER_MODEL, verbose_name='Пользователь')), ], options={ 'verbose_name': 'Корзина', 'verbose_name_plural': 'Корзины', }, ), migrations.CreateModel( name='Favorite', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('recipe', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='favorites', to='recipes.recipe', verbose_name='Рецепт')), ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='favorites', to=settings.AUTH_USER_MODEL, verbose_name='Пользователь')), ], options={ 'verbose_name': 'Избранный рецепт', 'verbose_name_plural': 'Избранные рецепты', }, ), migrations.AddConstraint( model_name='subscribe', constraint=models.UniqueConstraint(fields=('user', 'author'), name='unique_subscription'), ), migrations.AddConstraint( model_name='purchase', constraint=models.UniqueConstraint(fields=('user', 'recipe'), name='unique_purchase'), ), migrations.AddConstraint( model_name='favorite', constraint=models.UniqueConstraint(fields=('user', 'recipe'), name='unique_favorite'), ), ]
class Migration(migrations.Migration): dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('api', '0003_add_gta_field_parser'), ] operations = [ migrations.CreateModel( name='Feature', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=255, unique=True)), ], ), migrations.CreateModel( name='FeatureMapping', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=255)), ('public', models.BooleanField(default=False)), ('official', models.BooleanField(default=False)), ], ), migrations.CreateModel( name='FeatureMappingRule', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ], ), migrations.CreateModel( name='Milestone', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=255, unique=True)), ], ), migrations.CreateModel( name='TestScenario', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=255, unique=True)), ], ), migrations.AlterModelOptions( name='resultgroupnew', options={'verbose_name': 'Result Group', 'verbose_name_plural': 'Result Groups'}, ), migrations.AddConstraint( model_name='item', constraint=models.UniqueConstraint(fields=('name', 'args'), name='unique_item_composite_constraint'), ), migrations.AddField( model_name='featuremappingrule', name='feature', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.Feature'), ), migrations.AddField( model_name='featuremappingrule', name='mapping', field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='api.FeatureMapping'), ), migrations.AddField( model_name='featuremappingrule', name='milestone', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.Milestone'), ), migrations.AddField( model_name='featuremappingrule', name='scenario', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.TestScenario'), ), migrations.AddField( model_name='featuremapping', name='component', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.Component'), ), migrations.AddField( model_name='featuremapping', name='os', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.Os'), ), migrations.AddField( model_name='featuremapping', name='owner', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL), ), migrations.AddField( model_name='featuremapping', name='platform', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='api.Platform'), ), migrations.AddConstraint( model_name='featuremappingrule', constraint=models.UniqueConstraint(fields=('milestone', 'feature', 'scenario', 'mapping'), name='unique_featuremappingrule_composite_constraint'), ), migrations.AddConstraint( model_name='featuremapping', constraint=models.UniqueConstraint(fields=('name', 'owner'), name='unique_featuremapping_composite_constraint'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="Prober", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("name", models.CharField(max_length=64)), ], ), migrations.CreateModel( name="ProbeTarget", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("destination", models.CharField(max_length=64, unique=True)), ("interval", models.PositiveIntegerField()), ("probe_count", models.PositiveIntegerField(default=10)), ], ), migrations.CreateModel( name="ProbeResult", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ("start_time", models.DateTimeField()), ("end_time", models.DateTimeField()), ("target", models.CharField(max_length=64)), ( "probe", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, to="probes.Prober", ), ), ], ), migrations.AddField( model_name="prober", name="targets", field=models.ManyToManyField(to="probes.ProbeTarget"), ), migrations.AddField( model_name="prober", name="user", field=models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL), ), migrations.CreateModel( name="ProbeHop", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("ip", models.CharField(max_length=64, null=True)), ("dns_name", models.CharField(max_length=128, null=True)), ("response_time", models.PositiveIntegerField()), ("ttl", models.PositiveIntegerField()), ("responded", models.BooleanField()), ( "result", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="hops", to="probes.ProbeResult", ), ), ], ), migrations.AddConstraint( model_name="prober", constraint=models.UniqueConstraint(fields=("user", "name"), name="only 1 user per prober"), ), migrations.RunPython(seed, migrations.RunPython.noop), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0011_update_proxy_permissions'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(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')), ('first_name', models.CharField(blank=True, max_length=30, 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')), ('date_joined', models.DateTimeField(default=django.utils.timezone.now, verbose_name='date joined')), ('email', models.EmailField(max_length=254, unique=True, verbose_name='email address')), ('company', models.CharField(blank=True, max_length=40, verbose_name='Компания')), ('position', models.CharField(blank=True, max_length=40, verbose_name='Должность')), ('is_active', models.BooleanField( default=False, help_text= 'Designates whether this user should be treated as active. Unselect this instead of deleting accounts.', verbose_name='active')), ('type', models.CharField(choices=[('shop', 'Магазин'), ('buyer', 'Покупатель')], default='buyer', max_length=5, verbose_name='Тип пользователя')), ('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': 'Пользователь', 'verbose_name_plural': 'Список пользователей', 'ordering': ('email', ), }, managers=[ ('objects', backend.models.UserManager()), ], ), migrations.CreateModel( name='Category', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=40, verbose_name='Название')), ], options={ 'verbose_name': 'Категория', 'verbose_name_plural': 'Список категорий', 'ordering': ('-name', ), }, ), migrations.CreateModel( name='Contact', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('city', models.CharField(max_length=50, verbose_name='Город')), ('street', models.CharField(max_length=100, verbose_name='Улица')), ('house', models.CharField(blank=True, max_length=15, verbose_name='Дом')), ('structure', models.CharField(blank=True, max_length=15, verbose_name='Корпус')), ('building', models.CharField(blank=True, max_length=15, verbose_name='Строение')), ('apartment', models.CharField(blank=True, max_length=15, verbose_name='Квартира')), ('phone', models.CharField(max_length=20, verbose_name='Телефон')), ('user', models.ForeignKey(blank=True, on_delete=django.db.models.deletion.CASCADE, related_name='contacts', to=settings.AUTH_USER_MODEL, verbose_name='Пользователь')), ], options={ 'verbose_name': 'Контакты пользователя', 'verbose_name_plural': 'Список контактов пользователя', }, ), migrations.CreateModel( name='Order', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('status', models.CharField(choices=[('cart', 'В корзине'), ('new', 'Новый'), ('confirmed', 'Подтвержден'), ('assembled', 'Собран'), ('sent', 'Отправлен'), ('delivered', 'Доставлен'), ('canceled', 'Отменен')], default='cart', max_length=15, verbose_name='Статус')), ('created', models.DateTimeField(auto_now_add=True)), ('updated', models.DateTimeField(auto_now=True)), ('contact', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='backend.Contact', verbose_name='Контакт')), ('user', models.ForeignKey(blank=True, on_delete=django.db.models.deletion.CASCADE, related_name='orders', to=settings.AUTH_USER_MODEL, verbose_name='Пользователь')), ], options={ 'verbose_name': 'Заказ', 'verbose_name_plural': 'Список заказов', 'ordering': ('-created', ), }, ), migrations.CreateModel( name='Parameter', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=40, verbose_name='Название')), ], options={ 'verbose_name': 'Имя параметра', 'verbose_name_plural': 'Список имен параметров', 'ordering': ('-name', ), }, ), migrations.CreateModel( name='Product', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=80, verbose_name='Название')), ('model', models.CharField(blank=True, max_length=80, verbose_name='Модель')), ('external_id', models.PositiveIntegerField(verbose_name='Внешний ИД')), ('quantity', models.PositiveIntegerField(verbose_name='Количество')), ('price', models.PositiveIntegerField(verbose_name='Цена')), ('price_rrc', models.PositiveIntegerField( verbose_name='Рекомендуемая розничная цена')), ('category', models.ForeignKey(blank=True, on_delete=django.db.models.deletion.CASCADE, related_name='products', to='backend.Category', verbose_name='Категория')), ], options={ 'verbose_name': 'Продукт', 'verbose_name_plural': 'Список продуктов', 'ordering': ('category', '-name'), }, ), migrations.CreateModel( name='Shop', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=50, verbose_name='Название')), ('url', models.URLField(blank=True, null=True, verbose_name='Ссылка на файл прайса')), ('state', models.BooleanField(default=True, verbose_name='Cтатус получения заказов')), ('user', models.OneToOneField( blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, verbose_name='Пользователь')), ], options={ 'verbose_name': 'Магазин', 'verbose_name_plural': 'Список магазинов', 'ordering': ('-name', ), }, ), migrations.CreateModel( name='ProductParameter', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('value', models.CharField(max_length=100, verbose_name='Значение')), ('parameter', models.ForeignKey(blank=True, on_delete=django.db.models.deletion.CASCADE, related_name='parameter', to='backend.Parameter', verbose_name='Параметр')), ('product', models.ForeignKey(blank=True, on_delete=django.db.models.deletion.CASCADE, related_name='product_parameters', to='backend.Product', verbose_name='Информация о продукте')), ], options={ 'verbose_name': 'Параметр', 'verbose_name_plural': 'Список параметров', }, ), migrations.AddField( model_name='product', name='shop', field=models.ForeignKey( blank=True, on_delete=django.db.models.deletion.CASCADE, related_name='products_info', to='backend.Shop', verbose_name='Магазин'), ), migrations.CreateModel( name='OrderItem', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('product_name', models.CharField(max_length=80, verbose_name='Название товара')), ('external_id', models.PositiveIntegerField(verbose_name='Внешний ИД')), ('quantity', models.PositiveIntegerField(default=1, verbose_name='Количество')), ('price', models.PositiveIntegerField(default=0, verbose_name='Цена')), ('total_amount', models.PositiveIntegerField(default=0, verbose_name='Общая стоимость')), ('category', models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='backend.Category', verbose_name='Категория товара')), ('order', models.ForeignKey(blank=True, on_delete=django.db.models.deletion.CASCADE, related_name='ordered_items', to='backend.Order', verbose_name='Заказ')), ('shop', models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='backend.Shop', verbose_name='магазин')), ], options={ 'verbose_name': 'Заказанная позиция', 'verbose_name_plural': 'Список заказанных позиций', }, ), migrations.CreateModel( name='ConfirmEmailToken', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created_at', models.DateTimeField( auto_now_add=True, verbose_name='When was this token generated')), ('key', models.CharField(db_index=True, max_length=64, unique=True, verbose_name='Key')), ('user', models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='confirm_email_tokens', to=settings.AUTH_USER_MODEL, verbose_name= 'The User which is associated to this password reset token' )), ], options={ 'verbose_name': 'Токен подтверждения Email', 'verbose_name_plural': 'Токены подтверждения Email', }, ), migrations.AddField( model_name='category', name='shops', field=models.ManyToManyField(blank=True, related_name='categories', to='backend.Shop', verbose_name='Магазины'), ), migrations.AddConstraint( model_name='productparameter', constraint=models.UniqueConstraint( fields=('product', 'parameter'), name='unique_product_parameter'), ), migrations.AddConstraint( model_name='product', constraint=models.UniqueConstraint(fields=('shop', 'category', 'external_id'), name='unique_product_info'), ), migrations.AddConstraint( model_name='orderitem', constraint=models.UniqueConstraint(fields=('order_id', 'product_name'), name='unique_order_item'), ), ]
class Migration(migrations.Migration): dependencies = [ ('metadata', '0001_squashed_0010_auto_20180613_1553'), ('company', '0099_delete_companieshousecompany'), ] operations = [ migrations.CreateModel( name='CompanyExportCountry', fields=[ ('created_on', models.DateTimeField(auto_now_add=True, db_index=True, null=True)), ('modified_on', models.DateTimeField(auto_now=True, null=True)), ('id', models.UUIDField(default=uuid.uuid4, primary_key=True, serialize=False)), ('status', models.CharField(choices=[ ('not_interested', 'Not interested'), ('currently_exporting', 'Currently exporting to'), ('future_interest', 'Future country of interest') ], max_length=255)), ('company', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='export_countries', to='company.Company')), ('country', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='companies_with_interest', to='metadata.Country')), ('created_by', models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('modified_by', models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ], options={ 'verbose_name_plural': 'company export countries', }, ), migrations.AddConstraint( model_name='companyexportcountry', constraint=models.UniqueConstraint(fields=('country', 'company'), name='unique_country_company'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0011_update_proxy_permissions'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(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=30, 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')), ('email', models.EmailField( help_text= 'Your email address will not be made public and will not be used for communications. It will only be used as your authentication identifier.', max_length=254, unique=True)), ('github', models.CharField( blank=True, help_text= 'Your GitHub username if you have one and want to link to it', max_length=100, validators=[ django.contrib.auth.validators. UnicodeUsernameValidator ])), ('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()), ], ), migrations.CreateModel( name='Competitor', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('is_public', models.BooleanField()), ('name', models.SlugField()), ('last_version', models.PositiveIntegerField()), ], ), migrations.CreateModel( name='Environment', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=100)), ('slug', models.SlugField(unique=True)), ('description', models.TextField()), ('num_matches_in_duel', models.PositiveIntegerField()), ('memory_limit', models.CharField(max_length=50)), ('cpu_limit', models.FloatField()), ('image', models.CharField(max_length=100)), ], ), migrations.CreateModel( name='Revision', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('version_number', models.PositiveIntegerField()), ('created_at', models.DateTimeField(auto_now_add=True)), ('zip_file', models.FileField( upload_to=core.models.zip_file_path, validators=[ django.core.validators.FileExtensionValidator(['zip']) ])), ('publish_state', models.CharField(choices=[('PUBLISH_SKIPPED', ''), ('PUBLISH_SCHEDULED', ''), ('PUBLISH_RUNNING', ''), ('PUBLISH_FAILED', ''), ('PUBLISH_COMPLETED', '')], max_length=100)), ('publish_started_at', models.DateTimeField(null=True)), ('publish_ended_at', models.DateTimeField(null=True)), ('publish_error_msg', models.CharField(blank=True, max_length=200)), ('publish_url', models.CharField(blank=True, max_length=200, validators=[ django.core.validators.RegexValidator( '^https://github.com/') ])), ('image_state', models.CharField(choices=[('IMAGE_SCHEDULED', ''), ('IMAGE_RUNNING', ''), ('IMAGE_FAILED', ''), ('IMAGE_COMPLETED', '')], default='IMAGE_SCHEDULED', max_length=100)), ('image_started_at', models.DateTimeField(null=True)), ('image_ended_at', models.DateTimeField(null=True)), ('image_error_msg', models.CharField(blank=True, max_length=200)), ('image_name', models.CharField(blank=True, max_length=200)), ('image_logs', models.FilePathField( null=True, path='/app/data/media/revision_image_logs/')), ('test_state', models.CharField(choices=[('TEST_SCHEDULED', ''), ('TEST_RUNNING', ''), ('TEST_FAILED', ''), ('TEST_COMPLETED', '')], default='TEST_SCHEDULED', max_length=100)), ('test_started_at', models.DateTimeField(null=True)), ('test_ended_at', models.DateTimeField(null=True)), ('test_error_msg', models.CharField(blank=True, max_length=200)), ('test_logs', models.FilePathField( null=True, path='/app/data/media/revision_test_logs/')), ('competitor', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='core.Competitor')), ], ), migrations.CreateModel( name='Tournament', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('edition', models.PositiveIntegerField()), ('started_at', models.DateTimeField(auto_now_add=True)), ('state', models.CharField(choices=[('RUNNING', ''), ('FAILED', ''), ('COMPLETED', '')], default='RUNNING', max_length=100)), ('ended_at', models.DateTimeField(null=True)), ('environment', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Environment')), ], ), migrations.CreateModel( name='TournamentParticipant', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('wins', models.PositiveIntegerField()), ('losses', models.PositiveIntegerField()), ('draws', models.PositiveIntegerField()), ('points', models.PositiveIntegerField()), ('total_score', models.FloatField()), ('ranking', models.PositiveIntegerField()), ('revision', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Revision')), ('tournament', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Tournament')), ], ), migrations.AddField( model_name='tournament', name='participants', field=models.ManyToManyField(through='core.TournamentParticipant', to='core.Revision'), ), migrations.CreateModel( name='Duel', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('state', models.CharField(choices=[('SCHEDULED', ''), ('RUNNING', ''), ('FAILED', ''), ('COMPLETED', '')], default='SCHEDULED', max_length=100)), ('created_at', models.DateTimeField(auto_now_add=True)), ('started_at', models.DateTimeField(null=True)), ('ended_at', models.DateTimeField(null=True)), ('logs', models.FilePathField(null=True, path='/app/data/media/duel_logs/')), ('results', models.FilePathField(null=True, path='/app/data/media/duel_results/')), ('result', models.CharField(blank=True, choices=[('ERROR', ''), ('PLAYER_1_WIN', ''), ('PLAYER_2_WIN', ''), ('DRAW', '')], max_length=100)), ('error_msg', models.CharField(blank=True, max_length=200)), ('num_matches', models.PositiveIntegerField(null=True)), ('player_1_errors', models.PositiveIntegerField(null=True)), ('player_2_errors', models.PositiveIntegerField(null=True)), ('other_errors', models.PositiveIntegerField(null=True)), ('player_1_wins', models.PositiveIntegerField(null=True)), ('player_2_wins', models.PositiveIntegerField(null=True)), ('draws', models.PositiveIntegerField(null=True)), ('player_1_score', models.FloatField(null=True)), ('player_2_score', models.FloatField(null=True)), ('player_1', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='player_1', to='core.Revision')), ('player_2', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='player_2', to='core.Revision')), ('tournament', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='core.Tournament')), ], ), migrations.AddField( model_name='competitor', name='environment', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to='core.Environment'), ), migrations.AddField( model_name='competitor', name='submitter', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL), ), migrations.AddConstraint( model_name='revision', constraint=models.UniqueConstraint(fields=('competitor', 'version_number'), name='unique_competitor'), ), migrations.AddConstraint( model_name='competitor', constraint=models.UniqueConstraint(fields=('environment', 'name'), name='unique_environment'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('system', '0001_initial'), ] operations = [ migrations.CreateModel( name='Dissertation', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=500)), ('description', models.TextField()), ('is_approved', models.BooleanField(default=False)), ('created_at', django_jalali.db.models.jDateTimeField(auto_now_add=True)), ('jury_date', django_jalali.db.models.jDateField()), ], ), migrations.CreateModel( name='Student', fields=[], options={ 'proxy': True, 'indexes': [], 'constraints': [], }, bases=('system.user', ), ), migrations.CreateModel( name='StudentFields', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('entry_at', models.DateField(auto_now_add=True)), ('is_graduated', models.BooleanField(default=False)), ('is_daily', models.BooleanField(default=True)), ('describtion', models.CharField(blank=True, max_length=300)), ('group', models.ForeignKey( on_delete=django.db.models.deletion.DO_NOTHING, to='system.group')), ('orientation', models.ForeignKey( on_delete=django.db.models.deletion.DO_NOTHING, to='system.orientation')), ('student', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, to='student.student')), ], ), migrations.CreateModel( name='JuryRequest', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('status', models.IntegerField(choices=[(0, 'Rejected'), (1, 'Accepted'), (2, 'In Progress')], default=2)), ('jury_date', models.DateField()), ('created_at', models.DateField(auto_now_add=True)), ('supervisor_ok', models.BooleanField(default=False)), ('supervisor_quote', models.CharField(blank=True, max_length=400)), ('manager_ok', models.BooleanField(default=False)), ('manager_quote', models.CharField(blank=True, max_length=400)), ('staff_ok', models.BooleanField(default=False)), ('staff_quote', models.CharField(blank=True, max_length=400)), ('dissertation', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, to='student.dissertation')), ('student', models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, to='student.student')), ], ), migrations.CreateModel( name='DissertationReport', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=400)), ('summary', models.CharField(max_length=500)), ('problems', models.CharField(max_length=500)), ('proceedings', models.CharField(max_length=500)), ('created_at', models.DateField(auto_now_add=True)), ('supervisor_ok', models.BooleanField(default=False)), ('manager_ok', models.BooleanField(default=False)), ('supervisor_quote', models.CharField(blank=True, max_length=400)), ('manager_quote', models.CharField(blank=True, max_length=400)), ('disserta', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='student.dissertation')), ], ), migrations.AddField( model_name='dissertation', name='student', field=models.OneToOneField( on_delete=django.db.models.deletion.CASCADE, to='student.student'), ), migrations.CreateModel( name='AchievementReport', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('grade_average', models.JSONField()), ('status', models.IntegerField(choices=[(0, 'Rejected'), (1, 'Accepted'), (2, 'In Progress')], default=2)), ('report_id', models.CharField(blank=True, max_length=20)), ('created_at', models.DateField(auto_now_add=True)), ('supervisor_ok', models.BooleanField(default=False)), ('manager_ok', models.BooleanField(default=False)), ('supervisor_quote', models.CharField(blank=True, max_length=400)), ('manager_quote', models.CharField(blank=True, max_length=400)), ('disserta', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='student.dissertationreport')), ('student', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='student.student')), ], ), migrations.AddConstraint( model_name='achievementreport', constraint=models.UniqueConstraint(fields=('student', 'disserta'), name='report'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='Board', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=50)), ('owner', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='boards', to=settings.AUTH_USER_MODEL)), ], options={ 'ordering': ['id'], }, ), migrations.CreateModel( name='Tag', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=255)), ('board', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='tags', to='tasks.board')), ], ), migrations.CreateModel( name='Task', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.CharField(max_length=255)), ('body', models.TextField(blank=True)), ('priority', models.CharField(choices=[('High', 'High'), ('Medium', 'Medium'), ('Low', 'Low')], default='Medium', max_length=10)), ('created', models.DateTimeField(default=django.utils.timezone.now)), ('completed', models.BooleanField(default=False)), ('important', models.BooleanField(default=False)), ('inbox', models.BooleanField(default=False)), ('board', models.ForeignKey(blank=True, on_delete=django.db.models.deletion.CASCADE, related_name='tasks', to='tasks.board')), ('owner', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='tasks', to=settings.AUTH_USER_MODEL)), ('tags', models.ManyToManyField(blank=True, related_name='tasks', to='tasks.Tag')), ], options={ 'ordering': ['-created'], }, ), migrations.AddConstraint( model_name='tag', constraint=models.UniqueConstraint(fields=('name', 'board'), name='unique_name_board'), ), ]
class Migration(migrations.Migration): dependencies = [ ("customers", "0011_add_intended_use_to_boat"), ] operations = [ migrations.RemoveField( model_name="boat", name="boat_is_inspected", ), migrations.RemoveField( model_name="boat", name="boat_is_insured", ), migrations.CreateModel( name="BoatCertificate", fields=[ ( "id", models.UUIDField( default=uuid.uuid4, editable=False, primary_key=True, serialize=False, ), ), ( "file", models.FileField( blank=True, null=True, storage=django.core.files.storage.FileSystemStorage(), upload_to=customers.models.get_boat_media_folder, verbose_name="certificate file", ), ), ( "certificate_type", models.CharField( choices=[ ("inspection", "Inspection"), ("insurance", "Insurance"), ], max_length=16, verbose_name="certificate type", ), ), ( "valid_until", models.DateField(blank=True, null=True, verbose_name="valid until"), ), ( "checked_at", models.DateField(default=django.utils.timezone.now, verbose_name="checked at"), ), ( "checked_by", models.CharField(blank=True, max_length=100, null=True, verbose_name="checked by"), ), ( "boat", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="certificates", to="customers.Boat", verbose_name="boat", ), ), ], ), migrations.AddConstraint( model_name="boatcertificate", constraint=models.UniqueConstraint(fields=("boat_id", "certificate_type"), name="unique_boat_certificate"), ), ]
class Migration(migrations.Migration): initial = True dependencies = [] operations = [ migrations.CreateModel( name='Category', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(default='', max_length=120, unique=True)), ], ), migrations.CreateModel( name='Modifier', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(default='', max_length=120, unique=True)), ('price', models.DecimalField(decimal_places=2, max_digits=10)), ], ), migrations.CreateModel( name='Service', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(default='', max_length=120, unique=True)), ('price', models.DecimalField(decimal_places=2, max_digits=10)), ('category', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='services.category')), ], ), migrations.CreateModel( name='ServMod', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('modifier', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='services.modifier')), ('service', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='services.service')), ], ), migrations.AddConstraint( model_name='servmod', constraint=models.UniqueConstraint(fields=('service', 'modifier'), name='unique-modifier'), ), ]
class Migration(migrations.Migration): dependencies = [ ("posthog", "0084_person_uuid"), ] operations = [ migrations.CreateModel( name="Organization", fields=[ ( "id", models.UUIDField( default=posthog.models.utils.uuid1_macless, editable=False, primary_key=True, serialize=False, ), ), ("name", models.CharField(max_length=64)), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ], options={ "abstract": False, }, ), migrations.AddField( model_name="annotation", name="scope", field=models.CharField( choices=[ ("dashboard_item", "dashboard item"), ("project", "project"), ("organization", "organization"), ], default="dashboard_item", max_length=24, ), ), migrations.AddField( model_name="user", name="current_team", field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="teams_currently+", to="posthog.Team", ), ), migrations.AlterField( model_name="annotation", name="apply_all", field=models.BooleanField(null=True), ), migrations.AlterField( model_name="annotation", name="creation_type", field=models.CharField( choices=[("USR", "user"), ("GIT", "GitHub")], default="USR", max_length=3, ), ), migrations.AlterField( model_name="personalapikey", name="team", field=models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="personal_api_keys", to="posthog.Team", ), ), migrations.AlterField( model_name="team", name="api_token", field=models.CharField( default=posthog.models.utils.generate_random_token, max_length=200, null=True, ), ), migrations.AlterField( model_name="team", name="name", field=models.CharField(default="Default", max_length=200, null=True), ), migrations.AlterField( model_name="team", name="uuid", field=models.UUIDField(default=posthog.models.utils.uuid1_macless, editable=False, unique=True), ), migrations.AlterField( model_name="user", name="distinct_id", field=models.CharField(blank=True, max_length=200, null=True, unique=True), ), migrations.AlterField( model_name="user", name="temporary_token", field=models.CharField(blank=True, max_length=200, null=True, unique=True), ), migrations.CreateModel( name="OrganizationMembership", fields=[ ( "id", models.UUIDField( default=posthog.models.utils.uuid1_macless, editable=False, primary_key=True, serialize=False, ), ), ( "level", models.PositiveSmallIntegerField(choices=[ (1, "member"), (8, "administrator") ], default=1), ), ("joined_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "organization", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="memberships", related_query_name="membership", to="posthog.Organization", ), ), ( "user", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="organization_memberships", related_query_name="organization_membership", to=settings.AUTH_USER_MODEL, ), ), ], ), migrations.CreateModel( name="OrganizationInvite", fields=[ ( "id", models.UUIDField( default=posthog.models.utils.uuid1_macless, editable=False, primary_key=True, serialize=False, ), ), ("uses", models.PositiveIntegerField(default=0)), ( "max_uses", models.PositiveIntegerField(blank=True, default=None, null=True), ), ( "target_email", models.EmailField( blank=True, db_index=True, default=None, max_length=254, null=True, ), ), ("created_at", models.DateTimeField(auto_now_add=True)), ("updated_at", models.DateTimeField(auto_now=True)), ( "created_by", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="organization_invites", related_query_name="organization_invite", to=settings.AUTH_USER_MODEL, ), ), ( "last_used_by", models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="+", to=settings.AUTH_USER_MODEL, ), ), ( "organization", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="invites", related_query_name="invite", to="posthog.Organization", ), ), ], ), migrations.AddField( model_name="organization", name="members", field=models.ManyToManyField( related_name="organizations", related_query_name="organization", through="posthog.OrganizationMembership", to=settings.AUTH_USER_MODEL, ), ), migrations.AddField( model_name="annotation", name="organization", field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.CASCADE, to="posthog.Organization", ), ), migrations.AddField( model_name="team", name="organization", field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.CASCADE, related_name="teams", related_query_name="team", to="posthog.Organization", ), ), migrations.AddField( model_name="user", name="current_organization", field=models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name="users_currently+", to="posthog.Organization", ), ), migrations.AddConstraint( model_name="organizationmembership", constraint=models.UniqueConstraint( fields=("organization_id", "user_id"), name="unique_organization_membership", ), ), migrations.AddConstraint( model_name="organizationinvite", constraint=models.CheckConstraint( check=models.Q( uses__lte=django.db.models.expressions.F("max_uses")), name="max_uses_respected", ), ), migrations.RunPython(forwards_func, reverse_func), ]
class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='Asignatura', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('codigo', models.CharField(blank=True, max_length=10, null=True)), ('siglas', models.CharField(max_length=10, null=True)), ('nombre', models.CharField(max_length=100, null=True)), ('nivel', models.IntegerField(blank=True, null=True)), ('semestre', models.IntegerField(blank=True, null=True)), ], ), migrations.CreateModel( name='Carrera', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('nombre', models.CharField(max_length=50)), ('siglas', models.CharField(blank=True, max_length=5)), ('semestres', models.IntegerField(blank=True, null=True)), ], ), migrations.CreateModel( name='Catedra', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('descripcion', models.CharField(default='', max_length=50)), ('seccion', models.CharField(choices=[('MI', 'MI'), ('MJ', 'MJ'), ('MK', 'MK'), ('ML', 'ML'), ('MM', 'MM'), ('MN', 'MN'), ('TQ', 'TQ'), ('TR', 'TR'), ('TS', 'TS'), ('TT', 'TT'), ('TU', 'TU'), ('TV', 'TV'), ('TW', 'TW'), ('NA', 'NA'), ('NB', 'NB'), ('NC', 'NC'), ('ND', 'ND'), ('NE', 'NE'), ('NF', 'NF'), ('NG', 'NG'), ('NH', 'NH')], max_length=5, null=True)), ('fecha_desde', models.DateField(blank=True, null=True)), ('fecha_hasta', models.DateField(blank=True, null=True)), ('fecha_1par', models.DateField(blank=True, null=True, verbose_name='Fecha Primer Parcial')), ('hora_1par', models.TimeField(blank=True, null=True, verbose_name='Hora Primer Parcial')), ('fecha_2par', models.DateField(blank=True, null=True, verbose_name='Fecha Segundo Parcial')), ('hora_2par', models.TimeField(blank=True, null=True, verbose_name='Hora Segundo Parcial')), ('fecha_1final', models.DateField(blank=True, null=True, verbose_name='Fecha Primer Final')), ('hora_1final', models.TimeField(blank=True, null=True, verbose_name='Hora Primer Final')), ('fecha_2final', models.DateField(blank=True, null=True, verbose_name='Fecha Segundo Final')), ('hora_2final', models.TimeField(blank=True, null=True, verbose_name='Hora Segundo Final')), ('asignaturas', models.ManyToManyField(to='academico.Asignatura')), ], options={ 'permissions': [('view_own_catedra', 'Puede ver catedras propias')], }, ), migrations.CreateModel( name='Contenido', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('titulo', models.CharField(max_length=100)), ], options={ 'ordering': ['titulo'], }, ), migrations.CreateModel( name='Departamento', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('nombre', models.CharField(max_length=50)), ('siglas', models.CharField(max_length=10)), ], ), migrations.CreateModel( name='Docente', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('cedula', models.BigIntegerField(unique=True)), ('titulo', models.CharField(max_length=10)), ('titulo_grado', models.CharField(max_length=10)), ('posgrado', models.CharField(blank=True, max_length=10, null=True)), ('apellido', models.CharField(max_length=30)), ('nombre', models.CharField(max_length=30)), ('categoria_docente', models.IntegerField(null=True)), ('user', models.OneToOneField(null=True, on_delete=django.db.models.deletion.PROTECT, to=settings.AUTH_USER_MODEL)), ], ), migrations.CreateModel( name='Periodo', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('numero', models.IntegerField(choices=[(1, 'Primer'), (2, 'Segundo')])), ('year', models.IntegerField(verbose_name='Año')), ('p_lec_desde', models.DateField()), ('p_lect_hasta', models.DateField()), ('par1_desde', models.DateField(blank=True, null=True)), ('par1_hasta', models.DateField(blank=True, null=True)), ('par2_desde', models.DateField(blank=True, null=True)), ('par2_hasta', models.DateField(blank=True, null=True)), ('fin1_desde', models.DateField(blank=True, null=True)), ('fin1_hasta', models.DateField(blank=True, null=True)), ('fin2_desde', models.DateField(blank=True, null=True)), ('fin2_hasta', models.DateField(blank=True, null=True)), ], ), migrations.CreateModel( name='RegistroCatedra', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('fecha', models.DateField(null=True)), ('hora_desde', models.TimeField(null=True)), ('hora_hasta', models.TimeField(null=True)), ('clase_teoria', models.BooleanField(default=False, verbose_name='Teoria')), ('clase_practica', models.BooleanField(default=False, verbose_name='Practica')), ('clase_laboratorio', models.BooleanField(default=False, verbose_name='Laborat.')), ('clase_taller', models.BooleanField(default=False, verbose_name='Taller')), ('contenidos_observacion', models.TextField(blank=True, default='', verbose_name='Observaciones del contenido')), ('met_exposicion', models.BooleanField(default=False, verbose_name='Exposición')), ('met_trabajo_ind_grp', models.BooleanField(default=False, verbose_name='Trabajo individual y/o grupal')), ('met_res_ejercicios', models.BooleanField(default=False, verbose_name='Resolucion de ejercicios')), ('met_eval', models.BooleanField(default=False, verbose_name='Evaluacion')), ('met_otros', models.TextField(blank=True, null=True, verbose_name='Especificar otros metodos utilizados')), ('med_pizarra', models.BooleanField(default=False, verbose_name='Pizarra')), ('med_video', models.BooleanField(default=False, verbose_name='Video')), ('med_pc', models.BooleanField(default=False, verbose_name='PC - Proyector Multimedia')), ('med_equip', models.BooleanField(default=False, verbose_name='Equipos de Laboratorio')), ('med_bibli', models.BooleanField(default=False, verbose_name='Mat. Bibliograficos')), ('med_prog', models.BooleanField(default=False, verbose_name='Programas utilitarios')), ('med_otros', models.TextField(blank=True, default='', verbose_name='Especificar otros medios auxiliares')), ('catedra', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='academico.Catedra')), ('contenidos_desarrollados', models.ManyToManyField(blank=True, to='academico.Contenido')), ('docente', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='academico.Docente')), ], options={ 'permissions': [('view_own_registrocatedra', 'Puede ver registros de catedra propios'), ('add_own_registrocatedra', 'Puede añadir registros de catedra propios')], }, ), migrations.CreateModel( name='Plan', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('year', models.IntegerField(default=0, verbose_name='Año')), ('asignatura', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='academico.Asignatura')), ], ), migrations.CreateModel( name='Horario', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('dia', models.IntegerField(choices=[(1, 'Lunes'), (2, 'Martes'), (3, 'Miercoles'), (4, 'Jueves'), (5, 'Viernes'), (6, 'Sabado')])), ('fecha', models.DateField(blank=True, null=True)), ('hora_desde', models.TimeField()), ('hora_hasta', models.TimeField()), ('catedra', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='academico.Catedra')), ], ), migrations.CreateModel( name='GrupoHomologas', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('descripcion', models.CharField(max_length=50)), ('asignatura_primaria', models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, related_name='asignatura_primaria', to='academico.Asignatura')), ], ), migrations.CreateModel( name='Enfasis', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('nombre', models.CharField(max_length=50)), ('siglas', models.CharField(max_length=5)), ('carrera', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='academico.Carrera')), ], ), migrations.AddField( model_name='contenido', name='plan', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='academico.Plan'), ), migrations.AddField( model_name='catedra', name='docentes', field=models.ManyToManyField(to='academico.Docente'), ), migrations.AddField( model_name='catedra', name='periodo', field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='academico.Periodo'), ), migrations.AddField( model_name='asignatura', name='carrera', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='academico.Carrera'), ), migrations.AddField( model_name='asignatura', name='departamento', field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.PROTECT, to='academico.Departamento'), ), migrations.AddField( model_name='asignatura', name='enfasis', field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, to='academico.Enfasis'), ), migrations.AddField( model_name='asignatura', name='grupohomologas', field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, to='academico.GrupoHomologas'), ), migrations.AddField( model_name='asignatura', name='prerequisito', field=models.ManyToManyField(blank=True, related_name='_asignatura_prerequisito_+', to='academico.Asignatura'), ), migrations.CreateModel( name='Alumno', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('cedula', models.BigIntegerField(unique=True)), ('nombre', models.CharField(max_length=30)), ('apellido', models.CharField(max_length=30)), ('correo', models.EmailField(blank=True, max_length=254, unique=True)), ('user', models.OneToOneField(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, to=settings.AUTH_USER_MODEL)), ], ), migrations.AddConstraint( model_name='registrocatedra', constraint=models.UniqueConstraint(fields=('fecha', 'catedra', 'docente'), name='unique_registrocatedra'), ), migrations.AlterUniqueTogether( name='plan', unique_together={('asignatura', 'year')}, ), ]
class Migration(migrations.Migration): initial = True dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name="Category", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ( "name", models.CharField(max_length=20, unique=True, verbose_name="Категория"), ), ("slug", models.SlugField(unique=True)), ], options={ "verbose_name": "Категория", "verbose_name_plural": "Категории", }, ), migrations.CreateModel( name="Genre", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ( "name", models.CharField(max_length=20, unique=True, verbose_name="Жанр"), ), ("slug", models.SlugField(unique=True)), ], options={ "verbose_name": "Жанр", "verbose_name_plural": "Жанры", }, ), migrations.CreateModel( name="Title", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ( "name", models.CharField(max_length=50, verbose_name="Наименование"), ), ( "year", models.PositiveIntegerField( validators=[ django.core.validators.MinValueValidator(1900), django.core.validators.MaxValueValidator(2021), ], verbose_name="Год", ), ), ( "description", models.TextField(blank=True, default="", null=True), ), ("rating", models.IntegerField(null=True)), ( "category", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="titles", to="api.Category", verbose_name="Категория", ), ), ( "genre", models.ManyToManyField( related_name="titles", to="api.Genre", verbose_name="Жанр", ), ), ], options={ "verbose_name": "Тайтл", "verbose_name_plural": "Тайтлы", }, ), migrations.CreateModel( name="Review", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("text", models.TextField()), ( "score", models.PositiveSmallIntegerField(validators=[ django.core.validators.MinValueValidator(1), django.core.validators.MaxValueValidator(10), ]), ), ( "pub_date", models.DateTimeField( auto_now=True, db_index=True, verbose_name="Дата написания поста", ), ), ( "author", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="reviews", to=settings.AUTH_USER_MODEL, ), ), ( "title", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="reviews", to="api.Title", ), ), ], options={ "ordering": ["pub_date"], }, ), migrations.CreateModel( name="Comment", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("text", models.TextField(verbose_name="Текст комменатария")), ( "pub_date", models.DateTimeField( auto_now_add=True, db_index=True, verbose_name="Дата публикации коммментария", ), ), ( "author", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="comments", to=settings.AUTH_USER_MODEL, ), ), ( "review", models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name="comments", to="api.Review", ), ), ], options={ "ordering": ["pub_date"], }, ), migrations.AddConstraint( model_name="review", constraint=models.UniqueConstraint(fields=("author", "title"), name="unique_title_review"), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ] operations = [ migrations.CreateModel( name='Bank', fields=[ ('City', models.CharField(max_length=255, verbose_name='City')), ('Bank_Name', models.CharField(max_length=255, primary_key=True, serialize=False, verbose_name='Bank_Name')), ('Asset', models.FloatField(default=0.0, verbose_name='Asset')), ], options={ 'db_table': 'Bank', }, ), migrations.CreateModel( name='CheckAccount', fields=[ ('CAccount_ID', models.CharField(max_length=255, primary_key=True, serialize=False, verbose_name='CAccount_ID')), ('CAccount_Balance', models.FloatField(default=0.0, verbose_name='CAccount_Balance')), ('CAccount_Open_Date', models.DateTimeField(verbose_name='CAccount_Open_Date')), ('CAccount_Overdraft', models.FloatField(verbose_name='CAccount_Overdraft')), ('CAccount_Open_Bank_Name', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='BankManagement.Bank')), ], options={ 'db_table': 'CheckAccount', }, ), migrations.CreateModel( name='Customer', fields=[ ('Customer_ID', models.CharField(max_length=18, primary_key=True, serialize=False, verbose_name='Customer_ID')), ('Customer_Name', models.CharField(max_length=255, verbose_name='Customer_Name')), ('Customer_Phone_Number', models.DecimalField(decimal_places=0, max_digits=11, verbose_name='Customer_Phone_Number')), ('Customer_Address', models.CharField(max_length=255, verbose_name='Customer_Address')), ('Contact_Person_Name', models.CharField(max_length=255, verbose_name='Contact_Person_Name')), ('Contact_Person_Phone_Number', models.DecimalField(decimal_places=0, max_digits=11, verbose_name='Contact_Person_Name')), ('Contact_Person_Email', models.CharField(max_length=255, verbose_name='Contact_Person_Email')), ('Contact_Person_Relationship', models.CharField(max_length=255, verbose_name='Contact_Person_Relationship')), ], options={ 'db_table': 'Customer', }, ), migrations.CreateModel( name='Department', fields=[ ('Department_ID', models.CharField(max_length=255, primary_key=True, serialize=False, verbose_name='Department_ID')), ('Department_Manger_ID', models.DecimalField(decimal_places=0, max_digits=18, verbose_name='Department_Manger_ID')), ('Department_Name', models.CharField(max_length=255, verbose_name='Department_Name')), ('Department_Type', models.IntegerField(verbose_name='Department_Type')), ('Bank_Name', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='BankManagement.Bank')), ], options={ 'db_table': 'Department', }, ), migrations.CreateModel( name='Loan', fields=[ ('Loan_ID', models.CharField(max_length=255, primary_key=True, serialize=False, verbose_name='Loan_ID')), ('Loan_Total', models.FloatField(verbose_name='Loan_Total')), ('Loan_Status', models.CharField(default='0', max_length=1, verbose_name='Loan_Status')), ('Bank_Name', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='BankManagement.Bank')), ], options={ 'db_table': 'Loan', }, ), migrations.CreateModel( name='SavingAccount', fields=[ ('SAccount_ID', models.CharField(max_length=255, primary_key=True, serialize=False, verbose_name='SAccount_ID')), ('SAccount_Balance', models.FloatField(default=0.0, verbose_name='SAccount_Balance')), ('SAccount_Open_Date', models.DateTimeField(verbose_name='SAccount_Open_Date')), ('SAccount_Last_Access_Date', models.DateTimeField(auto_now=True, verbose_name='SAccount_Last_Access_Date')), ('SAccount_Interest_Rate', models.FloatField(verbose_name='SAccount_Interest_Rate')), ('SAccount_Currency_Type', models.CharField(max_length=255, verbose_name='SAccount_Currency_Type')), ('SAccount_Open_Bank_Name', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='BankManagement.Bank')), ], options={ 'db_table': 'SavingAccount', }, ), migrations.CreateModel( name='LoanRelease', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('Loan_Release_ID', models.CharField(max_length=255, verbose_name='Loan_Release_ID')), ('Loan_Release_Date', models.DateTimeField(verbose_name='Loan_Release_Date')), ('Loan_Release_Amount', models.FloatField(verbose_name='Loan_Release_Amount')), ('Loan_ID', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='BankManagement.Loan')), ], options={ 'db_table': 'LoanRelease', }, ), migrations.CreateModel( name='Employee', fields=[ ('Employee_ID', models.CharField(max_length=18, primary_key=True, serialize=False, verbose_name='Employee_ID')), ('Employee_Name', models.CharField(max_length=255, verbose_name='Employee_Name')), ('Employee_Phone_Number', models.DecimalField(decimal_places=0, max_digits=11, verbose_name='Employee_Phone_Number')), ('Employee_Address', models.CharField(max_length=255, verbose_name='Employee_Address')), ('Employee_Hire_Date', models.DateTimeField(verbose_name='Employee_Hire_Date')), ('Employee_Type', models.IntegerField(verbose_name='Employee_Type')), ('Bank_Name', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='BankManagement.Bank')), ('Department_ID', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='BankManagement.Department')), ], options={ 'db_table': 'Employee', }, ), migrations.CreateModel( name='CustomerToSA', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('SAccount_Last_Access_Date', models.DateTimeField(auto_now=True, verbose_name='SAccount_Last_Access_Date')), ('Customer_ID', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='BankManagement.Customer')), ('SAccount_ID', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='BankManagement.SavingAccount')), ('SAccount_Open_Bank_Name', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='BankManagement.Bank')), ], options={ 'db_table': 'CustomerToSA', }, ), migrations.CreateModel( name='CustomerToLoan', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('Customer_ID', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='BankManagement.Customer')), ('Loan_ID', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='BankManagement.Loan')), ], options={ 'db_table': 'CustomerToLoan', }, ), migrations.CreateModel( name='CustomerToCA', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('CAccount_Last_Access_Date', models.DateTimeField(auto_now=True, verbose_name='CAccount_Last_Access_Date')), ('CAccount_ID', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='BankManagement.CheckAccount')), ('CAccount_Open_Bank_Name', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='BankManagement.Bank')), ('Customer_ID', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='BankManagement.Customer')), ], options={ 'db_table': 'CustomerToCA', }, ), migrations.AddField( model_name='customer', name='Employee_ID', field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='BankManagement.Employee'), ), migrations.AddConstraint( model_name='loanrelease', constraint=models.UniqueConstraint(fields=('Loan_ID', 'Loan_Release_ID'), name='LoanRelease Fake Primary Key'), ), migrations.AddConstraint( model_name='customertosa', constraint=models.UniqueConstraint(fields=('Customer_ID', 'SAccount_Open_Bank_Name'), name='One customer is only allowed to open one SA in one bank'), ), migrations.AddConstraint( model_name='customertosa', constraint=models.UniqueConstraint(fields=('SAccount_ID', 'Customer_ID'), name='CustomerToSA Fake Primary Key'), ), migrations.AddConstraint( model_name='customertoloan', constraint=models.UniqueConstraint(fields=('Loan_ID', 'Customer_ID'), name='Primary key'), ), migrations.AddConstraint( model_name='customertoca', constraint=models.UniqueConstraint(fields=('Customer_ID', 'CAccount_Open_Bank_Name'), name='One customer is only allowed to open one CA in one bank'), ), migrations.AddConstraint( model_name='customertoca', constraint=models.UniqueConstraint(fields=('CAccount_ID', 'Customer_ID'), name='CustomerToCA Fake Primary Key'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('auth', '0012_alter_user_first_name_max_length'), ] operations = [ migrations.CreateModel( name='User', fields=[ ('id', models.AutoField(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')), ('email', models.EmailField(blank=True, max_length=254, verbose_name='email address')), ('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')), ('user_uuid', models.CharField(blank=True, max_length=36)), ('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')), ], managers=[ ('objects', django.contrib.auth.models.UserManager()), ], ), migrations.AddConstraint( model_name='user', constraint=models.UniqueConstraint(fields=('email', ), name='make Email unique'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [] operations = [ migrations.CreateModel( name='CallEndRecord', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('call_id', models.CharField(max_length=50, unique=True, verbose_name='Call Unique ID')), ('timestamp', models.DateTimeField(blank=True, verbose_name='Timestamp')), ('price', models.DecimalField(blank=True, decimal_places=2, max_digits=5, null=True, verbose_name='Price')), ], ), migrations.CreateModel( name='CallStartRecord', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('call_id', models.CharField(max_length=50, unique=True, verbose_name='Call Unique ID')), ('timestamp', models.DateTimeField(blank=True, verbose_name='Timestamp')), ('source', models.CharField(max_length=30, verbose_name='Source')), ('destination', models.CharField( max_length=11, validators=[ django.core.validators.MinLengthValidator(10), django.core.validators.MaxLengthValidator(11), django.core.validators.RegexValidator( message='Destination must contain only numbers.', regex='^\\d+$') ], verbose_name='Destination')), ], ), migrations.AddConstraint( model_name='callstartrecord', constraint=models.UniqueConstraint( fields=('call_id', ), name='callstartrecord_unique_callid'), ), migrations.AddConstraint( model_name='callendrecord', constraint=models.UniqueConstraint( fields=('call_id', ), name='callendrecord_unique_callid'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('roulette', '0020_auto_20201028_1411_squashed_0026_auto_20201117_1643'), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('account', '0002_auto_20201212_1549'), ] operations = [ migrations.CreateModel( name='TimeSlot', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('start_time', models.DateTimeField( validators=[scheduling.validators.validate_start_time])), ('duration', models.DurationField( validators=[scheduling.validators.validate_duration])), ('weekly', models.BooleanField(default=True)), ('owner', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, to_field='uuid')), ], ), migrations.CreateModel( name='HistoricalAppointment', fields=[ ('id', models.IntegerField(auto_created=True, blank=True, db_index=True, verbose_name='ID')), ('start_time', models.DateTimeField( validators=[scheduling.validators.validate_start_time])), ('duration', models.DurationField( validators=[scheduling.validators.validate_duration])), ('topic', models.CharField(blank=True, max_length=255)), ('confirmation_request_time', models.DateTimeField(blank=True, editable=False)), ('status', models.TextField(choices=[ ('REQUESTED', 'Requested'), ('CONFIRMED', 'Confirmed'), ('OWNER_REJECTED', 'Owner Rejected'), ('INVITEE_REJECTED', 'Invitee Rejected'), ('OWNER_STARTED', 'Owner Started'), ('INVITEE_STARTED', 'Invitee Started'), ('BOTH_STARTED', 'Both Started') ], default='REQUESTED')), ('history_id', models.AutoField(primary_key=True, serialize=False)), ('history_date', models.DateTimeField()), ('history_change_reason', models.CharField(max_length=100, null=True)), ('history_type', models.CharField(choices=[('+', 'Created'), ('~', 'Changed'), ('-', 'Deleted')], max_length=1)), ('history_user', models.ForeignKey( null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='+', to=settings.AUTH_USER_MODEL)), ('meeting', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='roulette.meeting')), ('owner', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to=settings.AUTH_USER_MODEL, to_field='uuid')), ('subject', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='account.subject')), ('timeslot', models.ForeignKey( blank=True, db_constraint=False, null=True, on_delete=django.db.models.deletion.DO_NOTHING, related_name='+', to='scheduling.timeslot')), ], options={ 'verbose_name': 'historical appointment', 'ordering': ('-history_date', '-history_id'), 'get_latest_by': 'history_date', }, bases=(simple_history.models.HistoricalChanges, models.Model), ), migrations.CreateModel( name='Appointment', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('start_time', models.DateTimeField( validators=[scheduling.validators.validate_start_time])), ('duration', models.DurationField( validators=[scheduling.validators.validate_duration])), ('topic', models.CharField(blank=True, max_length=255)), ('confirmation_request_time', models.DateTimeField(auto_now_add=True)), ('status', models.TextField(choices=[ ('REQUESTED', 'Requested'), ('CONFIRMED', 'Confirmed'), ('OWNER_REJECTED', 'Owner Rejected'), ('INVITEE_REJECTED', 'Invitee Rejected'), ('OWNER_STARTED', 'Owner Started'), ('INVITEE_STARTED', 'Invitee Started'), ('BOTH_STARTED', 'Both Started') ], default='REQUESTED')), ('invitee_rejects', models.ManyToManyField(blank=True, related_name='rejected_appointments', to=settings.AUTH_USER_MODEL)), ('meeting', models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='roulette.meeting')), ('owner', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, to_field='uuid')), ('subject', models.ForeignKey( blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='account.subject')), ('timeslot', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='scheduling.timeslot')), ], managers=[ ('all_objects', django.db.models.manager.Manager()), ], ), migrations.AddConstraint( model_name='appointment', constraint=models.UniqueConstraint( condition=models.Q(models.Q(('status', 'OWNER_REJECTED'), ('status', 'INVITEE_REJECTED'), _connector='OR'), _negated=True), fields=('timeslot', 'start_time'), name='unique_appointment_timeslot_start_time'), ), ]
class Migration(migrations.Migration): dependencies = [ ('carefreg', '0003_auto_20200420_1612'), ] operations = [ migrations.AlterField( model_name='department', name='abbreviated_name', field=models.CharField(max_length=3, unique=True, verbose_name='Аббревиатура'), ), migrations.CreateModel( name='RelDeviceDepartment', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('rel_date', models.DateField(db_index=True, verbose_name='Дата')), ('comment', models.CharField(blank=True, max_length=150, verbose_name='Комментарий')), ('device', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='carefreg.Device', verbose_name='Устройство')), ('owner_dept', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='carefreg.Department', verbose_name='Отдел')), ], ), migrations.CreateModel( name='RelCartridgeDevice', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('rel_date', models.DateField(db_index=True, verbose_name='Дата')), ('comment', models.CharField(blank=True, max_length=150, verbose_name='Комментарий')), ('cartridge', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='carefreg.Cartridge', verbose_name='Картридж')), ('owner_device', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='carefreg.Device', verbose_name='Устройство')), ], ), migrations.AddConstraint( model_name='reldevicedepartment', constraint=models.UniqueConstraint( fields=('rel_date', 'device'), name='rel_device_department__unique_date_device'), ), migrations.AddConstraint( model_name='reldevicedepartment', constraint=models.UniqueConstraint( fields=('rel_date', 'device', 'owner_dept'), name='rel_device_department__unique_date_device_owner_dept'), ), migrations.AddConstraint( model_name='relcartridgedevice', constraint=models.UniqueConstraint( fields=('rel_date', 'cartridge'), name='rel_cartridge_device__unique_date_cartridge'), ), migrations.AddConstraint( model_name='relcartridgedevice', constraint=models.UniqueConstraint( fields=('rel_date', 'cartridge', 'owner_device'), name='rel_cartridge_device__unique_date_cartridge_owner_device' ), ), ]
class Migration(migrations.Migration): dependencies = [ ("aidants_connect_habilitation", "0004_auto_20220118_1050"), ] operations = [ migrations.AlterField( model_name="organisationrequest", name="manager_email", field=models.EmailField( default=None, max_length=150, null=True, verbose_name="Email du responsable", ), ), migrations.AlterField( model_name="organisationrequest", name="manager_first_name", field=models.CharField( default=None, max_length=150, null=True, verbose_name="Prénom du responsable", ), ), migrations.AlterField( model_name="organisationrequest", name="manager_last_name", field=models.CharField( default=None, max_length=150, null=True, verbose_name="Nom du responsable", ), ), migrations.AlterField( model_name="organisationrequest", name="manager_phone", field=phonenumber_field.modelfields.PhoneNumberField( blank=True, default=None, max_length=128, null=True, region=None, verbose_name="Téléphone du responsable", ), ), migrations.AlterField( model_name="organisationrequest", name="manager_profession", field=models.CharField( default=None, max_length=150, null=True, verbose_name="Profession du responsable", ), ), migrations.CreateModel( name="DataPrivacyOfficer", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("first_name", models.CharField(max_length=150, verbose_name="Prénom")), ("last_name", models.CharField(max_length=150, verbose_name="Nom")), ("email", models.EmailField(max_length=150, verbose_name="Email")), ( "profession", models.CharField(max_length=150, verbose_name="Profession"), ), ( "phone", phonenumber_field.modelfields.PhoneNumberField( blank=True, max_length=128, region=None, verbose_name="Téléphone", ), ), ], options={ "abstract": False, }, ), migrations.CreateModel( name="Manager", fields=[ ( "id", models.AutoField( auto_created=True, primary_key=True, serialize=False, verbose_name="ID", ), ), ("first_name", models.CharField(max_length=150, verbose_name="Prénom")), ("last_name", models.CharField(max_length=150, verbose_name="Nom")), ("email", models.EmailField(max_length=150, verbose_name="Email")), ( "profession", models.CharField(max_length=150, verbose_name="Profession"), ), ( "phone", phonenumber_field.modelfields.PhoneNumberField( blank=True, max_length=128, region=None, verbose_name="Téléphone", ), ), ("address", models.TextField(verbose_name="Adresse")), ( "zipcode", models.CharField(max_length=10, verbose_name="Code Postal"), ), ( "city", models.CharField(max_length=255, verbose_name="Ville"), ), ( "is_aidant", models.BooleanField(default=False, verbose_name="C'est aussi un aidant"), ), ], options={ "abstract": False, }, ), migrations.AddField( model_name="organisationrequest", name="data_privacy_officer", field=models.OneToOneField( default=None, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="organisation", to="aidants_connect_habilitation.dataprivacyofficer", verbose_name="Délégué à la protection des données", ), ), migrations.AddField( model_name="organisationrequest", name="manager", field=models.OneToOneField( default=None, null=True, on_delete=django.db.models.deletion.CASCADE, related_name="organisation", to="aidants_connect_habilitation.manager", verbose_name="Responsable", ), ), migrations.RunPython(populate_manager_table, reverse_code=reverse_populate_manager_table), migrations.RemoveField( model_name="organisationrequest", name="manager_email", ), migrations.RemoveField( model_name="organisationrequest", name="manager_first_name", ), migrations.RemoveField( model_name="organisationrequest", name="manager_last_name", ), migrations.RemoveField( model_name="organisationrequest", name="manager_phone", ), migrations.RemoveField( model_name="organisationrequest", name="manager_profession", ), migrations.AlterField( model_name="aidantrequest", name="profession", field=models.CharField(max_length=150, verbose_name="Profession"), ), migrations.AlterField( model_name="issuer", name="email", field=models.EmailField(max_length=150, verbose_name="Email"), ), migrations.AddConstraint( model_name="organisationrequest", constraint=models.CheckConstraint( check=models.Q( ("draft_id__isnull", False), models.Q(("draft_id__isnull", True), ("manager__isnull", False)), _connector="OR", ), name="manager_set", ), ), migrations.AddConstraint( model_name="organisationrequest", constraint=models.CheckConstraint( check=models.Q( ("draft_id__isnull", False), models.Q( ("draft_id__isnull", True), ("data_privacy_officer__isnull", False), ), _connector="OR", ), name="data_privacy_officer_set", ), ), ]
class Migration(migrations.Migration): dependencies = [ migrations.swappable_dependency(settings.AUTH_USER_MODEL), ('user_profile', '0001_initial'), ] operations = [ migrations.CreateModel( name='Track', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('title', models.TextField()), ('artist', models.TextField(blank=True)), ('album', models.TextField(blank=True)), ('duration', models.DurationField()), ], ), migrations.CreateModel( name='TrackUri', fields=[ ('uri', models.TextField(primary_key=True, serialize=False)), ('deleted', models.BooleanField(default=False)), ('track', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='uris', to='user_profile.track')), ], ), migrations.CreateModel( name='UserPlaylist', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('uri', models.TextField()), ('title', models.TextField(default='Unknown playlist')), ('enabled', models.BooleanField(default=True)), ('last_synchronized', models.DateTimeField(default=django.utils.timezone.now)), ], ), migrations.CreateModel( name='UserTrack', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('date_added', models.DateTimeField()), ('track_uri', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='user_tracks', to='user_profile.trackuri')), ('user_playlist', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='user_tracks', to='user_profile.userplaylist')), ], ), migrations.AddField( model_name='userplaylist', name='tracks', field=models.ManyToManyField(related_name='user_playlists', through='user_profile.UserTrack', to='user_profile.TrackUri'), ), migrations.AddField( model_name='userplaylist', name='user', field=models.ForeignKey( on_delete=django.db.models.deletion.CASCADE, related_name='playlists', to=settings.AUTH_USER_MODEL), ), migrations.AddConstraint( model_name='usertrack', constraint=models.UniqueConstraint( fields=('track_uri', 'user_playlist'), name='unique_track_uri_user_playlist'), ), migrations.AddConstraint( model_name='userplaylist', constraint=models.UniqueConstraint(fields=('user', 'uri'), name='unique_user_uri'), ), ]
class Migration(migrations.Migration): initial = True dependencies = [ ('contenttypes', '0002_remove_content_type_name'), ('authentication', '0003_workspace_active_sso'), ('definitions', '0001_initial'), ] operations = [ migrations.CreateModel( name='Run', fields=[ ('id', models.CharField(db_index=True, default=utils.mixins.models.uuid4_hex, max_length=32, editable=False, primary_key=True, unique=True)), ('revision_count', models.PositiveIntegerField(default=0)), ('created_at', models.DateTimeField( auto_now_add=True, help_text='Timestamp for when the run was created.')), ('started_at', models.DateTimeField( default=None, help_text= 'Timestamp for when run queued actual processing tasks.', null=True)), ('finished_at', models.DateTimeField( default=None, help_text= 'Timestamp for when run finished calculating all revisions.', null=True)), ('datastore', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='run_history', to='definitions.Datastore')), ('workspace', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='run_history', to='authentication.Workspace')), ], options={ 'abstract': False, }, ), migrations.CreateModel( name='RunTask', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('meta_task_id', models.CharField(help_text='Task ID for Celery', max_length=512, null=True)), ('status', models.CharField(choices=[('SUCCESS', 'SUCCESS'), ('FAILURE', 'FAILURE'), ('PENDING', 'PENDING'), ('REVOKED', 'REVOKED')], default='PENDING', max_length=10)), ('started_at', models.DateTimeField( default=None, help_text='Timestamp for when the task started', null=True)), ('finished_at', models.DateTimeField( default=None, help_text='Timestamp for when the task finished', null=True)), ('storage_path', models.CharField(max_length=512, unique=True)), ('run', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='tasks', to='revisioner.Run')), ], ), migrations.CreateModel( name='RevisionerError', fields=[ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('task_fcn', models.CharField(default=None, max_length=40, null=True)), ('exc_type', models.CharField(default=None, max_length=40, null=True)), ('exc_stacktrace', models.TextField(default=None, null=True)), ('run', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='errors', to='revisioner.Run')), ('task', models.OneToOneField( default=None, null=True, on_delete=django.db.models.deletion.CASCADE, to='revisioner.RunTask')), ], options={ 'db_table': 'revisioner_error', }, ), migrations.CreateModel( name='Revision', fields=[ ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('revision_id', models.CharField(max_length=40, primary_key=True, serialize=False, unique=True)), ('resource_id', models.CharField(max_length=30, null=True)), ('parent_resource_id', models.CharField(max_length=30, null=True)), ('action', models.IntegerField( choices=[(1, 'Created'), (2, 'Modified'), (3, 'Dropped')])), ('metadata', django.contrib.postgres.fields.jsonb.JSONField(default=dict)), ('checksum', models.CharField(max_length=32)), ('first_seen_on', models.DateTimeField()), ('applied_on', models.DateTimeField(default=None, null=True)), ('first_seen_run', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='original_revisions', to='revisioner.Run')), ('parent_resource_revision', models.ForeignKey(db_constraint=False, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='revisions', to='revisioner.Revision')), ('parent_resource_type', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='+', to='contenttypes.ContentType')), ('resource_type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='+', to='contenttypes.ContentType')), ('run', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='revisions', to='revisioner.Run')), ('workspace', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='+', to='authentication.Workspace')), ], managers=[ ('objects', app.revisioner.managers.RevisionManager()), ], ), migrations.AddConstraint( model_name='revision', constraint=models.UniqueConstraint( fields=('workspace_id', 'checksum'), name='unique_revision_checksum'), ), ]