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'),
),
]
