class Migration(migrations.Migration):
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('proso_ab', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Answer',
fields=[
('id',
models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)),
('time', models.DateTimeField(default=datetime.datetime.now)),
('response_time', models.IntegerField()),
('ab_values_initialized', models.BooleanField(default=False)),
('ip_address',
models.CharField(default=None,
max_length=39,
null=True,
blank=True)),
('ab_values', models.ManyToManyField(to='proso_ab.Value')),
],
options={},
bases=(models.Model, ),
),
migrations.CreateModel(
name='Audit',
fields=[
('id',
models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)),
('key', models.CharField(max_length=50)),
('value', models.FloatField()),
('time', models.DateTimeField(default=datetime.datetime.now)),
],
options={},
bases=(models.Model, ),
),
migrations.CreateModel(
name='Item',
fields=[
('id',
models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)),
],
options={},
bases=(models.Model, ),
),
migrations.CreateModel(
name='Variable',
fields=[
('id',
models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)),
('key', models.CharField(max_length=50)),
('value', models.FloatField()),
('audit', models.BooleanField(default=True)),
('updated',
models.DateTimeField(default=datetime.datetime.now)),
('item_primary',
models.ForeignKey(related_name=b'item_primary_variables',
default=None,
blank=True,
to='proso_models.Item',
null=True)),
('item_secondary',
models.ForeignKey(related_name=b'item_secondary_variables',
default=None,
blank=True,
to='proso_models.Item',
null=True)),
('user',
models.ForeignKey(default=None,
blank=True,
to=settings.AUTH_USER_MODEL,
null=True)),
],
options={},
bases=(models.Model, ),
),
migrations.AlterUniqueTogether(
name='variable',
unique_together=set([('key', 'user', 'item_primary',
'item_secondary')]),
),
migrations.AlterIndexTogether(
name='variable',
index_together=set([
('key', 'user', 'item_primary'), ('key', 'user'),
('key', 'user', 'item_primary', 'item_secondary'),
('key', 'item_primary')
]),
),
migrations.AddField(
model_name='audit',
name='item_primary',
field=models.ForeignKey(related_name=b'item_primary_audits',
default=None,
blank=True,
to='proso_models.Item',
null=True),
preserve_default=True,
),
migrations.AddField(
model_name='audit',
name='item_secondary',
field=models.ForeignKey(related_name=b'item_secondary_audits',
default=None,
blank=True,
to='proso_models.Item',
null=True),
preserve_default=True,
),
migrations.AddField(
model_name='audit',
name='user',
field=models.ForeignKey(default=None,
blank=True,
to=settings.AUTH_USER_MODEL,
null=True),
preserve_default=True,
),
migrations.AlterIndexTogether(
name='audit',
index_together=set([
('key', 'user', 'item_primary'), ('key', 'user'),
('key', 'user', 'item_primary', 'item_secondary'),
('key', 'item_primary')
]),
),
migrations.AddField(
model_name='answer',
name='item',
field=models.ForeignKey(related_name=b'item_answers',
to='proso_models.Item'),
preserve_default=True,
),
migrations.AddField(
model_name='answer',
name='item_answered',
field=models.ForeignKey(related_name=b'item_answered_answers',
default=None,
blank=True,
to='proso_models.Item',
null=True),
preserve_default=True,
),
migrations.AddField(
model_name='answer',
name='item_asked',
field=models.ForeignKey(related_name=b'item_asked_answers',
to='proso_models.Item'),
preserve_default=True,
),
migrations.AddField(
model_name='answer',
name='user',
field=models.ForeignKey(to=settings.AUTH_USER_MODEL),
preserve_default=True,
),
]
class Migration(migrations.Migration):
dependencies = [
('lava_scheduler_app', '0031_add_worker_state_and_health'),
]
operations = [
migrations.AddField(
model_name='device',
name='health',
field=models.IntegerField(choices=[(0, 'Good'), (1, 'Unknown'),
(2, 'Looping'), (3, 'Bad'),
(4, 'Maintenance'),
(5, 'Retired')],
default=1),
),
migrations.AddField(
model_name='device',
name='state',
field=models.IntegerField(choices=[(0, 'Idle'), (1, 'Reserved'),
(2, 'Running')],
default=0,
editable=False),
),
migrations.AddField(
model_name='testjob',
name='health',
field=models.IntegerField(choices=[(0, 'Unknown'), (1, 'Complete'),
(2, 'Incomplete'),
(3, 'Canceled')],
default=0),
),
migrations.AddField(
model_name='testjob',
name='state',
field=models.IntegerField(choices=[
(0, 'Submitted'), (1, 'Scheduling'), (2, 'Scheduled'),
(3, 'Running'), (4, 'Canceling'), (5, 'Finished')
],
default=0,
editable=False),
),
migrations.AlterField(
model_name='testjob',
name='actual_device',
field=models.ForeignKey(
blank=True,
default=None,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='testjobs',
to='lava_scheduler_app.Device'),
),
migrations.AlterIndexTogether(
name='testjob',
index_together=set([('health', 'state', 'requested_device_type')]),
),
migrations.RunPython(set_device_state_health,
revert_set_device_state_health),
migrations.RunPython(set_testjob_state_health,
revert_set_testjob_state_health),
]
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(db_index=True, max_length=50)),
('slug', models.SlugField(max_length=55)),
],
options={
'verbose_name': 'category',
'verbose_name_plural': 'categories',
'ordering': ('name', ),
},
),
migrations.CreateModel(
name='Product',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(db_index=True, max_length=300)),
('slug', models.SlugField(max_length=320)),
('price', models.DecimalField(decimal_places=2,
max_digits=10)),
('period', models.CharField(max_length=25)),
('main_image', models.ImageField(upload_to='products/main')),
('available', models.BooleanField(default=True)),
('created', models.DateTimeField(auto_now_add=True)),
('update', models.DateTimeField(auto_now=True)),
('description', models.TextField()),
('itinerary', models.TextField()),
('q_and_a', models.TextField(blank=True)),
('category',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='products',
to='shop.Category')),
],
options={
'ordering': ('name', ),
},
),
migrations.CreateModel(
name='ProductImage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('image',
models.ImageField(blank=True, upload_to='products/detail')),
('product',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='images',
to='shop.Product')),
],
),
migrations.AlterIndexTogether(
name='product',
index_together=set([('id', 'slug')]),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('taggit', '0002_auto_20150616_2121'),
('flatpages', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Category',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(db_index=True, max_length=200, unique=True)),
('name_ru',
models.CharField(db_index=True,
max_length=200,
null=True,
unique=True)),
('name_uk',
models.CharField(db_index=True,
max_length=200,
null=True,
unique=True)),
('slug', models.SlugField(max_length=200, unique=True)),
('image', models.ImageField(blank=True,
upload_to='category/')),
('description', models.TextField(blank=True)),
('description_ru', models.TextField(blank=True, null=True)),
('description_uk', models.TextField(blank=True, null=True)),
('lft',
models.PositiveIntegerField(db_index=True, editable=False)),
('rght',
models.PositiveIntegerField(db_index=True, editable=False)),
('tree_id',
models.PositiveIntegerField(db_index=True, editable=False)),
('level',
models.PositiveIntegerField(db_index=True, editable=False)),
('parent',
mptt.fields.TreeForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='children',
to='shop.Category')),
],
options={
'verbose_name': 'Категория',
'verbose_name_plural': 'Категории',
'ordering': ('tree_id', 'name'),
},
),
migrations.CreateModel(
name='Polygraphy',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('slug', models.SlugField(default='True', max_length=400)),
('image', models.ImageField(blank=True,
upload_to='polygraphy/')),
('description', models.TextField(blank=True)),
('keywords',
models.TextField(blank=True, help_text='Ключивые слова')),
('flatpage',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='flatpages.FlatPage')),
],
options={
'verbose_name': 'Полиграфия',
'verbose_name_plural': 'Полиграфия',
},
),
migrations.CreateModel(
name='Product',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(db_index=True,
help_text='Название товара',
max_length=400)),
('name_ru',
models.CharField(db_index=True,
help_text='Название товара',
max_length=400,
null=True)),
('name_uk',
models.CharField(db_index=True,
help_text='Название товара',
max_length=400,
null=True)),
('slug', models.SlugField(max_length=400)),
('provider',
models.CharField(help_text='Поставщик', max_length=20)),
('vendor_code',
models.CharField(help_text='Артикул, парт номер',
max_length=200,
unique=True)),
('vendor',
models.CharField(blank=True,
help_text='Производитель',
max_length=200)),
('type_product',
models.CharField(blank=True,
help_text='Тип товара',
max_length=200)),
('image', models.ImageField(blank=True, upload_to='product/')),
('format_fild',
models.CharField(blank=True,
choices=[('A0', 'A0'), ('A1', 'A1'),
('A2', 'A2'), ('A3', 'A3'),
('A4', 'A4'), ('A5', 'A5'),
('A6', 'A6'), ('A7', 'A7'),
('A8', 'A8'), ('A9', 'A9'),
('A10', 'A10')],
help_text='A3,A4',
max_length=50)),
('color_fild',
models.CharField(blank=True,
choices=[('BW', 'BW'), ('Color', 'Color')],
help_text='BW, Color',
max_length=50)),
('specifications',
ckeditor.fields.RichTextField(
blank=True, help_text='Характеристики товара')),
('specifications_ru',
ckeditor.fields.RichTextField(
blank=True, help_text='Характеристики товара',
null=True)),
('specifications_uk',
ckeditor.fields.RichTextField(
blank=True, help_text='Характеристики товара',
null=True)),
('description',
models.TextField(blank=True, help_text='Описание товара')),
('price',
models.DecimalField(blank=True,
decimal_places=2,
help_text='Цена входящая',
max_digits=10)),
('stock',
models.PositiveIntegerField(blank=True,
default=1,
help_text='Остатоки')),
('available',
models.BooleanField(default=True,
help_text='Доступен ли к заказу')),
('start_action',
models.DateField(blank=True,
default=django.utils.timezone.now,
null=True)),
('end_action',
models.DateField(blank=True,
default=django.utils.timezone.now,
null=True)),
('action', models.BooleanField(default=False,
help_text='Акции')),
('discount',
models.DecimalField(blank=True,
decimal_places=2,
default=Decimal('0.00'),
help_text='Цена со скидкой',
max_digits=10)),
('created',
models.DateTimeField(auto_now_add=True,
help_text='дата создания')),
('updated',
models.DateTimeField(auto_now=True,
help_text='дата обновления')),
('accessories',
models.ManyToManyField(blank=True,
editable=False,
related_name='_product_accessories_+',
to='shop.Product')),
('category',
models.ForeignKey(
help_text=
'Каталог товара (расходные материалы, компьютеры и комплетующие и т д)',
on_delete=django.db.models.deletion.CASCADE,
related_name='product',
to='shop.Category')),
('tags',
taggit.managers.TaggableManager(
blank=True,
help_text='Список тегов, разделенных запятыми',
through='taggit.TaggedItem',
to='taggit.Tag',
verbose_name='Tags')),
],
options={
'verbose_name': 'Товар',
'verbose_name_plural': 'Товары',
'ordering': ('name', ),
},
),
migrations.CreateModel(
name='Services',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(db_index=True, max_length=400)),
('name_ru',
models.CharField(db_index=True, max_length=400, null=True)),
('name_uk',
models.CharField(db_index=True, max_length=400, null=True)),
('slug', models.SlugField(max_length=400)),
('vendor_code', models.CharField(blank=True, max_length=200)),
('vendor',
models.CharField(blank=True,
help_text='Производитель',
max_length=200)),
('vendor_model',
models.CharField(blank=True,
help_text='Модель',
max_length=200)),
('image', models.ImageField(blank=True, upload_to='service/')),
('description', models.TextField(blank=True)),
('description_ru', models.TextField(blank=True, null=True)),
('description_uk', models.TextField(blank=True, null=True)),
('keywords',
models.TextField(blank=True, help_text='Ключивые слова')),
('price', models.DecimalField(decimal_places=2,
max_digits=10)),
('created', models.DateTimeField(auto_now_add=True)),
('updated', models.DateTimeField(auto_now=True)),
('accessories',
models.ManyToManyField(blank=True,
editable=False,
to='shop.Product')),
('category',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='services',
to='shop.Category')),
],
options={
'verbose_name': 'Услуга',
'verbose_name_plural': 'Услуги',
'ordering': ('name', ),
},
),
migrations.AlterIndexTogether(
name='services',
index_together={('id', 'slug')},
),
migrations.AlterIndexTogether(
name='product',
index_together={('id', 'slug')},
),
migrations.AlterUniqueTogether(
name='category',
unique_together={('parent', 'slug')},
),
]
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(db_index=True, max_length=150)),
('slug', models.SlugField(max_length=150, unique=True)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
],
options={
'verbose_name': 'category',
'verbose_name_plural': 'categories',
'ordering': ('name', ),
},
),
migrations.CreateModel(
name='Product',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(db_index=True, max_length=100)),
('slug', models.SlugField(max_length=100)),
('description', models.TextField(blank=True)),
('location', models.CharField(max_length=100)),
('price', models.DecimalField(decimal_places=2,
max_digits=10)),
('price_off',
models.DecimalField(decimal_places=2, max_digits=10)),
('available', models.BooleanField(default=True)),
('stock', models.PositiveIntegerField()),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('image',
models.ImageField(blank=True, upload_to='products/%Y/%m/%d')),
('category',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='products',
to='store.Category')),
],
options={
'ordering': ('name', ),
},
),
migrations.CreateModel(
name='State',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(db_index=True, max_length=150)),
('slug', models.SlugField(max_length=150, unique=True)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
],
options={
'verbose_name': 'category',
'verbose_name_plural': 'categories',
'ordering': ('name', ),
},
),
migrations.AddField(
model_name='cart',
name='state',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='products',
to='store.State'),
),
migrations.AlterIndexTogether(
name='cart',
index_together={('id', 'slug')},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
("contacts", "0046_reset_1"),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
("channels", "0052_reset_3"),
("schedules", "0003_reset_1"),
("orgs", "0029_reset_1"),
]
operations = [
migrations.CreateModel(
name="Broadcast",
fields=[
("id",
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID")),
(
"recipient_count",
models.IntegerField(
help_text=
"Number of urns which received this broadcast",
null=True,
verbose_name="Number of recipients",
),
),
("text",
models.TextField(help_text="The message to send out",
max_length=640,
verbose_name="Text")),
(
"status",
models.CharField(
choices=[
("I", "Initializing"),
("P", "Pending"),
("Q", "Queued"),
("W", "Wired"),
("S", "Sent"),
("D", "Delivered"),
("H", "Handled"),
("E", "Error Sending"),
("F", "Failed Sending"),
("R", "Resent message"),
],
default="I",
help_text="The current status for this broadcast",
max_length=1,
verbose_name="Status",
),
),
(
"language_dict",
models.TextField(
help_text="The localized versions of the broadcast",
null=True,
verbose_name="Translations"),
),
(
"base_language",
models.CharField(
blank=True,
help_text=
"The language used to send this to contacts without a language",
max_length=4,
null=True,
),
),
("is_active",
models.BooleanField(
default=True,
help_text="Whether this broadcast is active")),
(
"created_on",
models.DateTimeField(
auto_now_add=True,
db_index=True,
help_text="When this broadcast was created"),
),
("modified_on",
models.DateTimeField(
auto_now=True,
help_text="When this item was last modified")),
(
"purged",
models.BooleanField(
default=False,
help_text=
"If the messages for this broadcast have been purged"),
),
(
"channel",
models.ForeignKey(
help_text="Channel to use for message sending",
null=True,
on_delete=django.db.models.deletion.CASCADE,
to="channels.Channel",
verbose_name="Channel",
),
),
(
"contacts",
models.ManyToManyField(
help_text=
"Individual contacts included in this message",
related_name="addressed_broadcasts",
to="contacts.Contact",
verbose_name="Contacts",
),
),
(
"created_by",
models.ForeignKey(
help_text="The user which originally created this item",
on_delete=django.db.models.deletion.CASCADE,
related_name="msgs_broadcast_creations",
to=settings.AUTH_USER_MODEL,
),
),
(
"groups",
models.ManyToManyField(
help_text="The groups to send the message to",
related_name="addressed_broadcasts",
to="contacts.ContactGroup",
verbose_name="Groups",
),
),
(
"modified_by",
models.ForeignKey(
help_text="The user which last modified this item",
on_delete=django.db.models.deletion.CASCADE,
related_name="msgs_broadcast_modifications",
to=settings.AUTH_USER_MODEL,
),
),
(
"org",
models.ForeignKey(
help_text="The org this broadcast is connected to",
on_delete=django.db.models.deletion.CASCADE,
to="orgs.Org",
verbose_name="Org",
),
),
(
"parent",
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name="children",
to="msgs.Broadcast",
verbose_name="Parent",
),
),
],
),
migrations.CreateModel(
name="BroadcastRecipient",
fields=[
("id",
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID")),
(
"purged_status",
models.CharField(
help_text=
"Used when broadcast is purged to record contact's message's state",
max_length=1,
null=True,
),
),
("broadcast",
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to="msgs.Broadcast")),
("contact",
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to="contacts.Contact")),
],
options={"db_table": "msgs_broadcast_recipients"},
),
migrations.CreateModel(
name="ExportMessagesTask",
fields=[
("id",
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID")),
(
"is_active",
models.BooleanField(
default=True,
help_text=
"Whether this item is active, use this instead of deleting"
),
),
(
"created_on",
models.DateTimeField(
auto_now_add=True,
help_text="When this item was originally created"),
),
("modified_on",
models.DateTimeField(
auto_now=True,
help_text="When this item was last modified")),
(
"start_date",
models.DateField(
blank=True,
help_text="The date for the oldest message to export",
null=True),
),
(
"end_date",
models.DateField(
blank=True,
help_text="The date for the newest message to export",
null=True),
),
("task_id", models.CharField(max_length=64, null=True)),
(
"is_finished",
models.BooleanField(
default=False,
help_text="Whether this export is finished running"),
),
(
"uuid",
models.CharField(
help_text=
"The uuid used to name the resulting export file",
max_length=36,
null=True),
),
(
"created_by",
models.ForeignKey(
help_text="The user which originally created this item",
on_delete=django.db.models.deletion.CASCADE,
related_name="msgs_exportmessagestask_creations",
to=settings.AUTH_USER_MODEL,
),
),
("groups", models.ManyToManyField(to="contacts.ContactGroup")),
],
options={"abstract": False},
),
migrations.CreateModel(
name="Label",
fields=[
("id",
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID")),
(
"is_active",
models.BooleanField(
default=True,
help_text=
"Whether this item is active, use this instead of deleting"
),
),
(
"created_on",
models.DateTimeField(
auto_now_add=True,
help_text="When this item was originally created"),
),
("modified_on",
models.DateTimeField(
auto_now=True,
help_text="When this item was last modified")),
(
"uuid",
models.CharField(
db_index=True,
default=temba.utils.models.generate_uuid,
help_text="The unique identifier for this object",
max_length=36,
unique=True,
verbose_name="Unique Identifier",
),
),
("name",
models.CharField(help_text="The name of this label",
max_length=64,
verbose_name="Name")),
(
"label_type",
models.CharField(
choices=[("F", "Folder of labels"),
("L", "Regular label")],
default="L",
help_text="Label type",
max_length=1,
),
),
(
"visible_count",
models.PositiveIntegerField(
default=0,
help_text=
"Number of non-archived messages with this label"),
),
(
"created_by",
models.ForeignKey(
help_text="The user which originally created this item",
on_delete=django.db.models.deletion.CASCADE,
related_name="msgs_label_creations",
to=settings.AUTH_USER_MODEL,
),
),
(
"folder",
models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name="children",
to="msgs.Label",
verbose_name="Folder",
),
),
(
"modified_by",
models.ForeignKey(
help_text="The user which last modified this item",
on_delete=django.db.models.deletion.CASCADE,
related_name="msgs_label_modifications",
to=settings.AUTH_USER_MODEL,
),
),
("org",
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to="orgs.Org")),
],
managers=[("all_objects", django.db.models.manager.Manager())],
),
migrations.CreateModel(
name="Msg",
fields=[
("id",
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID")),
(
"text",
models.TextField(
help_text="The actual message content that was sent",
max_length=640,
verbose_name="Text"),
),
(
"priority",
models.IntegerField(
default=500,
help_text=
"The priority for this message to be sent, higher is higher priority"
),
),
(
"created_on",
models.DateTimeField(
db_index=True,
help_text="When this message was created",
verbose_name="Created On"),
),
(
"modified_on",
models.DateTimeField(
auto_now=True,
help_text="When this message was last modified",
null=True,
verbose_name="Modified On",
),
),
(
"sent_on",
models.DateTimeField(
blank=True,
help_text="When this message was sent to the endpoint",
null=True,
verbose_name="Sent On",
),
),
(
"queued_on",
models.DateTimeField(
blank=True,
help_text=
"When this message was queued to be sent or handled.",
null=True,
verbose_name="Queued On",
),
),
(
"direction",
models.CharField(
choices=[("I", "Incoming"), ("O", "Outgoing")],
help_text=
"The direction for this message, either incoming or outgoing",
max_length=1,
verbose_name="Direction",
),
),
(
"status",
models.CharField(
choices=[
("I", "Initializing"),
("P", "Pending"),
("Q", "Queued"),
("W", "Wired"),
("S", "Sent"),
("D", "Delivered"),
("H", "Handled"),
("E", "Error Sending"),
("F", "Failed Sending"),
("R", "Resent message"),
],
db_index=True,
default="P",
help_text="The current status for this message",
max_length=1,
verbose_name="Status",
),
),
(
"visibility",
models.CharField(
choices=[("V", "Visible"), ("A", "Archived"),
("D", "Deleted")],
db_index=True,
default="V",
help_text=
"The current visibility of this message, either visible, archived or deleted",
max_length=1,
verbose_name="Visibility",
),
),
(
"has_template_error",
models.BooleanField(
default=False,
help_text=
"Whether data for variable substitution are missing",
verbose_name="Has Template Error",
),
),
(
"msg_type",
models.CharField(
choices=[("I", "Inbox Message"), ("F", "Flow Message"),
("V", "IVR Message")],
help_text="The type of this message",
max_length=1,
null=True,
verbose_name="Message Type",
),
),
(
"msg_count",
models.IntegerField(
default=1,
help_text=
"The number of messages that were used to send this message, calculated on Twilio channels",
verbose_name="Message Count",
),
),
(
"error_count",
models.IntegerField(
default=0,
help_text=
"The number of times this message has errored",
verbose_name="Error Count"),
),
(
"next_attempt",
models.DateTimeField(
auto_now_add=True,
help_text=
"When we should next attempt to deliver this message",
verbose_name="Next Attempt",
),
),
(
"external_id",
models.CharField(
blank=True,
help_text=
"External id used for integrating with callbacks from other APIs",
max_length=255,
null=True,
verbose_name="External ID",
),
),
(
"media",
models.URLField(
blank=True,
help_text=
"The media associated with this message if any",
max_length=255,
null=True,
),
),
(
"broadcast",
models.ForeignKey(
blank=True,
help_text=
"If this message was sent to more than one recipient",
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name="msgs",
to="msgs.Broadcast",
verbose_name="Broadcast",
),
),
(
"channel",
models.ForeignKey(
help_text=
"The channel object that this message is associated with",
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name="msgs",
to="channels.Channel",
verbose_name="Channel",
),
),
(
"contact",
models.ForeignKey(
help_text=
"The contact this message is communicating with",
on_delete=django.db.models.deletion.CASCADE,
related_name="msgs",
to="contacts.Contact",
verbose_name="Contact",
),
),
(
"contact_urn",
models.ForeignKey(
help_text="The URN this message is communicating with",
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name="msgs",
to="contacts.ContactURN",
verbose_name="Contact URN",
),
),
(
"labels",
models.ManyToManyField(
help_text="Any labels on this message",
related_name="msgs",
to="msgs.Label",
verbose_name="Labels",
),
),
(
"org",
models.ForeignKey(
help_text="The org this message is connected to",
on_delete=django.db.models.deletion.CASCADE,
related_name="msgs",
to="orgs.Org",
verbose_name="Org",
),
),
(
"response_to",
models.ForeignKey(
blank=True,
db_index=False,
help_text=
"The message that this message is in reply to",
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name="responses",
to="msgs.Msg",
verbose_name="Response To",
),
),
(
"topup",
models.ForeignKey(
blank=True,
help_text=
"The topup that this message was deducted from",
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name="msgs",
to="orgs.TopUp",
),
),
],
options={"ordering": ["-created_on", "-pk"]},
),
migrations.CreateModel(
name="SystemLabel",
fields=[
("id",
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID")),
(
"label_type",
models.CharField(
choices=[
("I", "Inbox"),
("W", "Flows"),
("A", "Archived"),
("O", "Outbox"),
("S", "Sent"),
("X", "Failed"),
("E", "Scheduled"),
("C", "Calls"),
],
max_length=1,
),
),
("count",
models.IntegerField(
default=0,
help_text="Number of items with this system label")),
(
"org",
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name="system_labels",
to="orgs.Org"),
),
],
),
migrations.AddField(
model_name="exportmessagestask",
name="label",
field=models.ForeignKey(
null=True,
on_delete=django.db.models.deletion.CASCADE,
to="msgs.Label"),
),
migrations.AddField(
model_name="exportmessagestask",
name="modified_by",
field=models.ForeignKey(
help_text="The user which last modified this item",
on_delete=django.db.models.deletion.CASCADE,
related_name="msgs_exportmessagestask_modifications",
to=settings.AUTH_USER_MODEL,
),
),
migrations.AddField(
model_name="exportmessagestask",
name="org",
field=models.ForeignKey(
help_text="The organization of the user.",
on_delete=django.db.models.deletion.CASCADE,
to="orgs.Org"),
),
migrations.AddField(
model_name="broadcast",
name="recipients",
field=models.ManyToManyField(
help_text="The contacts which received this message",
related_name="broadcasts",
through="msgs.BroadcastRecipient",
to="contacts.Contact",
verbose_name="Recipients",
),
),
migrations.AddField(
model_name="broadcast",
name="schedule",
field=models.OneToOneField(
help_text="Our recurring schedule if we have one",
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name="broadcast",
to="schedules.Schedule",
verbose_name="Schedule",
),
),
migrations.AddField(
model_name="broadcast",
name="urns",
field=models.ManyToManyField(
help_text="Individual URNs included in this message",
related_name="addressed_broadcasts",
to="contacts.ContactURN",
verbose_name="URNs",
),
),
migrations.AlterIndexTogether(name="systemlabel",
index_together=set([("org", "label_type")
])),
migrations.AlterUniqueTogether(name="label",
unique_together=set([("org", "name")])),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Aircraft',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('aircraft_type', models.CharField(db_index=True, max_length=10, unique=True)),
('turbine', models.NullBooleanField()),
('piston', models.NullBooleanField()),
('requires_type', models.NullBooleanField()),
('tailwheel', models.NullBooleanField()),
('simple', models.NullBooleanField()),
('compleks', models.NullBooleanField(verbose_name='Complex')),
('high_performance', models.NullBooleanField()),
('superr', models.NullBooleanField(verbose_name='Super')),
('heavy', models.NullBooleanField(verbose_name='Heavy >300k lbs')),
('large', models.NullBooleanField(verbose_name='Large 41k-300k lbs')),
('medium', models.NullBooleanField(verbose_name='Meduim 12.5-41k lbs')),
('small', models.NullBooleanField(verbose_name='Small <12.5k lbs')),
('light_sport', models.NullBooleanField(verbose_name='LSA <1320 lbs')),
('image', models.FileField(blank=True, default=None, null=True, upload_to='aircraft/')),
('config_error', models.CharField(blank=True, max_length=100, null=True)),
('power_error', models.CharField(blank=True, max_length=100, null=True)),
('weight_error', models.CharField(blank=True, max_length=100, null=True)),
('category_error', models.CharField(blank=True, max_length=100, null=True)),
('class_error', models.CharField(blank=True, max_length=100, null=True)),
],
options={
'verbose_name_plural': 'Aircraft',
'ordering': ['aircraft_type'],
},
),
migrations.CreateModel(
name='AircraftCategory',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('aircraft_category', models.CharField(max_length=30)),
],
options={
'verbose_name_plural': 'Aircraft Categories',
},
),
migrations.CreateModel(
name='AircraftClass',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('aircraft_class', models.CharField(max_length=30)),
],
options={
'verbose_name_plural': 'Aircraft Classes',
},
),
migrations.CreateModel(
name='Approach',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('approach_type', models.CharField(choices=[('ILS', 'ILS'), ('CATII', 'CAT II'), ('CATIII', 'CAT III'), ('GPS', 'GPS'), ('RNAV', 'RNAV'), ('LOC', 'LOC'), ('VOR', 'VOR'), ('NDB', 'NDB'), ('LOC BC', 'LOC BC'), ('SDF', 'SDF'), ('LDA', 'LDA'), ('TACAN', 'TACAN'), ('MLS', 'MLS')], max_length=15, verbose_name='Approach Type')),
('number', models.PositiveIntegerField(blank=True, null=True, verbose_name='Number')),
],
options={
'verbose_name_plural': 'Approaches',
'ordering': ['approach_type'],
},
),
migrations.CreateModel(
name='Endorsement',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('endorsement', models.CharField(default='', max_length=30)),
('total', models.DecimalField(blank=True, db_index=True, decimal_places=1, default=0, max_digits=6, null=True)),
('user', models.ForeignKey(default=1, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
options={
'ordering': ['-total'],
},
),
migrations.CreateModel(
name='Flight',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('date', models.DateField(db_index=True)),
('route', models.CharField(max_length=50)),
('legs', models.PositiveIntegerField(null=True)),
('duration', models.DecimalField(decimal_places=1, max_digits=3, null=True, validators=[django.core.validators.MinValueValidator(0.0, 'Must be a positive number > 0.1')])),
('landings_day', models.PositiveIntegerField(blank=True, null=True, verbose_name='Day Ldg')),
('landings_night', models.PositiveIntegerField(blank=True, null=True, verbose_name='Night Ldg')),
('night', models.FloatField(blank=True, null=True, validators=[django.core.validators.MinValueValidator(0.0, 'Must be a positive number > 0.1')])),
('instrument', models.FloatField(blank=True, null=True, validators=[django.core.validators.MinValueValidator(0.0, 'Must be a positive number > 0.1')], verbose_name='Inst')),
('cross_country', models.NullBooleanField(verbose_name='XCountry')),
('second_in_command', models.NullBooleanField(verbose_name='SIC')),
('pilot_in_command', models.NullBooleanField(verbose_name='PIC')),
('simulated_instrument', models.FloatField(blank=True, null=True, validators=[django.core.validators.MinValueValidator(0.0, 'Must be a positive number > 0.1')], verbose_name='Sim Inst')),
('instructor', models.NullBooleanField(verbose_name='CFI')),
('dual', models.NullBooleanField()),
('remarks', models.CharField(blank=True, max_length=500, null=True)),
('simulator', models.NullBooleanField(verbose_name='Sim')),
('solo', models.NullBooleanField()),
('route_data', picklefield.fields.PickledObjectField(blank=True, editable=False, null=True)),
('map_error', models.CharField(blank=True, max_length=100, null=True)),
('duplicate_error', models.CharField(blank=True, max_length=100, null=True)),
('aircraft_type_error', models.CharField(blank=True, max_length=100, null=True)),
('registration_error', models.CharField(blank=True, max_length=100, null=True)),
('crew_error', models.CharField(blank=True, max_length=100, null=True)),
('aircraft_type', models.ForeignKey(blank=True, default=None, null=True, on_delete=django.db.models.deletion.SET_NULL, to='flights.Aircraft')),
],
options={
'ordering': ['-date'],
},
),
migrations.CreateModel(
name='Holding',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('hold', models.BooleanField(default=False)),
('flight_object', models.ForeignKey(blank=True, default=None, null=True, on_delete=django.db.models.deletion.SET_NULL, to='flights.Flight', verbose_name='Flight')),
],
),
migrations.CreateModel(
name='MapData',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(default='', max_length=500)),
('city', models.CharField(db_index=True, default='', max_length=500)),
('state', models.CharField(db_index=True, default='', max_length=500)),
('country', models.CharField(db_index=True, default='', max_length=500)),
('iata', models.CharField(db_index=True, default='', max_length=4)),
('icao', models.CharField(db_index=True, default='', max_length=4)),
('latitude', models.FloatField(blank=True, default=0, null=True)),
('longitude', models.FloatField(blank=True, default=0, null=True)),
('elevation', models.IntegerField(blank=True, default=0, null=True)),
],
options={
'verbose_name_plural': 'Map Data',
'ordering': ['city', 'state', 'country'],
},
),
migrations.CreateModel(
name='Power',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('role', models.CharField(db_index=True, default='', max_length=5)),
('turbine', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True)),
('piston', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True)),
('user', models.ForeignKey(default=1, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name_plural': 'Power',
'ordering': ['-role'],
},
),
migrations.CreateModel(
name='Profile',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('company', models.CharField(default='', max_length=50)),
('signature', models.FileField(upload_to=flights.models.user_directory_path)),
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Regs',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('reg_type', models.CharField(db_index=True, default='', max_length=5, verbose_name='Reg')),
('pilot_in_command', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True, verbose_name='PIC')),
('second_in_command', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True, verbose_name='SIC')),
('user', models.ForeignKey(default=1, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name_plural': 'Regs',
},
),
migrations.CreateModel(
name='Stat',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('aircraft_type', models.CharField(max_length=10)),
('total_time', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, verbose_name='Time')),
('pilot_in_command', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True, verbose_name='PIC')),
('second_in_command', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True, verbose_name='SIC')),
('cross_country', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True, verbose_name='XC')),
('instructor', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True, verbose_name='CFI')),
('dual', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True)),
('solo', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True)),
('instrument', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True, verbose_name='Inst')),
('night', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True)),
('simulated_instrument', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True, verbose_name='Sim Inst')),
('simulator', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True, verbose_name='Sim')),
('landings_day', models.PositiveIntegerField(blank=True, default=0, null=True, verbose_name='Day Ldg')),
('landings_night', models.PositiveIntegerField(blank=True, default=0, null=True, verbose_name='Night Ldg')),
('last_flown', models.DateField(blank=True, db_index=True, null=True)),
('last_30', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True, verbose_name='30')),
('last_60', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True, verbose_name='60')),
('last_90', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True, verbose_name='90')),
('last_180', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True, verbose_name='6mo')),
('last_yr', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True, verbose_name='12mo')),
('last_2yr', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True, verbose_name='24')),
('ytd', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True, verbose_name='YDT')),
('user', models.ForeignKey(default=1, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
options={
'ordering': ['-last_flown'],
},
),
migrations.CreateModel(
name='TailNumber',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('registration', models.CharField(db_index=True, max_length=10, unique=True)),
('is_121', models.NullBooleanField()),
('is_135', models.NullBooleanField()),
('is_91', models.NullBooleanField()),
('reg_error', models.CharField(blank=True, max_length=50, null=True)),
('aircraft', models.ForeignKey(default=None, on_delete=django.db.models.deletion.CASCADE, to='flights.Aircraft')),
('user', models.ForeignKey(default=1, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name_plural': 'Tailnumbers',
'ordering': ['aircraft', 'registration'],
},
),
migrations.CreateModel(
name='Total',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('total', models.CharField(default='', max_length=20)),
('total_time', models.DecimalField(blank=True, db_index=True, decimal_places=1, default=0, max_digits=6, null=True, verbose_name='Time')),
('pilot_in_command', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True, verbose_name='PIC')),
('second_in_command', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True, verbose_name='SIC')),
('cross_country', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True, verbose_name='XC')),
('instructor', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True, verbose_name='CFI')),
('dual', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True)),
('solo', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True)),
('instrument', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True, verbose_name='Inst')),
('night', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True)),
('simulated_instrument', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True, verbose_name='Sim Inst')),
('simulator', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True, verbose_name='Sim')),
('landings_day', models.PositiveIntegerField(blank=True, default=0, null=True, verbose_name='Day Ldg')),
('landings_night', models.PositiveIntegerField(blank=True, default=0, null=True, verbose_name='Night Ldg')),
('landings_total', models.PositiveIntegerField(blank=True, default=0, null=True, verbose_name='Total Ldg')),
('last_flown', models.DateField(blank=True, null=True)),
('last_30', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True, verbose_name='30')),
('last_60', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True, verbose_name='60')),
('last_90', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True, verbose_name='90')),
('last_180', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True, verbose_name='6mo')),
('last_yr', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True, verbose_name='12mo')),
('last_2yr', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True, verbose_name='24')),
('ytd', models.DecimalField(blank=True, decimal_places=1, max_digits=6, null=True, verbose_name='YDT')),
('user', models.ForeignKey(default=1, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
options={
'ordering': ['-total_time'],
},
),
migrations.CreateModel(
name='Weight',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('weight', models.CharField(default='', max_length=20)),
('total', models.DecimalField(blank=True, decimal_places=1, default=0, max_digits=6, null=True)),
('user', models.ForeignKey(default=1, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name_plural': 'Weight',
},
),
migrations.AlterIndexTogether(
name='mapdata',
index_together=set([('iata', 'icao')]),
),
migrations.AddField(
model_name='flight',
name='registration',
field=models.ForeignKey(blank=True, default=None, null=True, on_delete=django.db.models.deletion.SET_NULL, to='flights.TailNumber'),
),
migrations.AddField(
model_name='flight',
name='user',
field=models.ForeignKey(default=1, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
),
migrations.AddField(
model_name='approach',
name='flight_object',
field=models.ForeignKey(blank=True, default=None, null=True, on_delete=django.db.models.deletion.SET_NULL, to='flights.Flight', verbose_name='Flight'),
),
migrations.AddField(
model_name='aircraft',
name='aircraft_category',
field=models.ForeignKey(blank=True, default=None, null=True, on_delete=django.db.models.deletion.CASCADE, to='flights.AircraftCategory'),
),
migrations.AddField(
model_name='aircraft',
name='aircraft_class',
field=models.ForeignKey(blank=True, default=None, null=True, on_delete=django.db.models.deletion.CASCADE, to='flights.AircraftClass'),
),
migrations.AddField(
model_name='aircraft',
name='user',
field=models.ForeignKey(default=1, on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
),
migrations.AlterIndexTogether(
name='flight',
index_together=set([('route', 'date', 'duration')]),
),
]
class Migration(migrations.Migration):
dependencies = [
('contenttypes', '0002_remove_content_type_name'),
('djsend', '0038_auto_20170104_1448'),
]
operations = [
migrations.CreateModel(
name='XABBlock',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('global_settings_id',
models.PositiveIntegerField(
help_text=
'Which configuration object among your configs of the above type is this block attached to?'
)),
('name',
models.CharField(
help_text='A short name to describe this block',
max_length=24)),
('position_in_timeline',
models.PositiveSmallIntegerField(
blank=True,
help_text=
'This number is used by the global setting this object is part of to build its timeline. It represents the ordinal position in which this block should come.',
null=True)),
('reprise',
models.PositiveSmallIntegerField(
blank=True,
help_text=
"If set, indicates that this block is a reprise of the n'th block, where n is the value of the field",
null=True)),
('length',
models.PositiveIntegerField(
blank=True,
help_text=
"How many individual trials of this type should there be. You can leave blank if you don't need it",
null=True)),
('type',
models.CharField(
help_text=
"This will be passed as the 'type' parameter to jsPsych. It tells it which plugin to use to render these trials.",
max_length=26)),
('has_practice',
models.BooleanField(
default=False,
help_text=
'Check if you want to mark this block to need a practice block before, useful to guide client-side JS code.'
)),
('extra_params',
jsonfield.fields.JSONField(blank=True, null=True)),
('is_html',
models.BooleanField(
default=False,
help_text=
'If stimulus is an HTML-formatted string, this parameter needs to be set to true.'
)),
('left_key',
models.CharField(
default='q',
help_text=
'Which key the subject should press to indicate that the target is on the left side.',
max_length=2)),
('right_key',
models.CharField(
default='p',
help_text=
'Which key the subject should press to indicate that the target is on the right side.',
max_length=2)),
('prompt',
models.CharField(
blank=True,
help_text=
'The intention is that it can be used to provide a reminder about the action the subject is supposed to take (e.g. which key to press).',
max_length=256)),
('prompt_en',
models.CharField(
blank=True,
help_text=
'The intention is that it can be used to provide a reminder about the action the subject is supposed to take (e.g. which key to press).',
max_length=256,
null=True)),
('prompt_fr',
models.CharField(
blank=True,
help_text=
'The intention is that it can be used to provide a reminder about the action the subject is supposed to take (e.g. which key to press).',
max_length=256,
null=True)),
('prompt_es',
models.CharField(
blank=True,
help_text=
'The intention is that it can be used to provide a reminder about the action the subject is supposed to take (e.g. which key to press).',
max_length=256,
null=True)),
('timing_x',
models.IntegerField(
default=1000,
help_text=
'How long to show the X stimulus for in milliseconds.')),
('timing_xab_gap',
models.IntegerField(
default=1000,
help_text=
'How long to show a blank screen in between X and AB in milliseconds.'
)),
('timing_ab',
models.IntegerField(
default=-1,
help_text=
'How long to show A and B in milliseconds. If the value of this parameter is -1, then the stimuli will remain on the screen until a response is given.'
)),
('timing_response',
models.IntegerField(
default=-1,
help_text=
'The maximum duration to wait for a response, measured from the onset of the AB portion of the trial. If -1, then the trial will wait indefinitely for a response.'
)),
('global_settings_type',
models.ForeignKey(
help_text=
'What kind of global configuration is this object part of?',
on_delete=django.db.models.deletion.CASCADE,
to='contenttypes.ContentType')),
('save_with',
models.ForeignKey(
help_text=
"Choose the data model that will be used to save all trials that have their 'type' parameter equal to what you wrote above. If You have different block-setting objects (like this one) that have the same 'type' but different 'save_with', then there is no guarantee which data-model will be used. This is because I think there is no real reason why two different 'categorization' blocks should be saved with different data-models: even if they have wildly different stimuli or timing settings, they should return the same kind of data.",
on_delete=django.db.models.deletion.CASCADE,
related_name='created_xabblocks',
to='contenttypes.ContentType')),
],
options={
'abstract': False,
},
),
migrations.AlterIndexTogether(
name='xabblock',
index_together=set([('global_settings_type', 'global_settings_id')
]),
),
]
class Migration(migrations.Migration):
dependencies = [
('shop', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='CategoryTranslation',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('language_code',
models.CharField(db_index=True,
max_length=15,
verbose_name='Language')),
('name', models.CharField(db_index=True, max_length=200)),
('slug', models.SlugField(max_length=200, unique=True)),
],
options={
'verbose_name': 'category Translation',
'db_table': 'shop_category_translation',
'db_tablespace': '',
'managed': True,
'default_permissions': (),
},
),
migrations.CreateModel(
name='ProductTranslation',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('language_code',
models.CharField(db_index=True,
max_length=15,
verbose_name='Language')),
('name', models.CharField(db_index=True, max_length=200)),
('slug', models.SlugField(max_length=200)),
('description', models.TextField(blank=True)),
],
options={
'verbose_name': 'product Translation',
'db_table': 'shop_product_translation',
'db_tablespace': '',
'managed': True,
'default_permissions': (),
},
),
migrations.AlterModelOptions(
name='category',
options={
'verbose_name': 'category',
'verbose_name_plural': 'categories'
},
),
migrations.AlterModelOptions(
name='product',
options={},
),
migrations.RemoveField(
model_name='category',
name='name',
),
migrations.RemoveField(
model_name='category',
name='slug',
),
migrations.AlterIndexTogether(
name='product',
index_together=set(),
),
migrations.AddField(
model_name='producttranslation',
name='master',
field=models.ForeignKey(
editable=False,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='translations',
to='shop.Product'),
),
migrations.AddField(
model_name='categorytranslation',
name='master',
field=models.ForeignKey(
editable=False,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='translations',
to='shop.Category'),
),
migrations.RemoveField(
model_name='product',
name='description',
),
migrations.RemoveField(
model_name='product',
name='name',
),
migrations.RemoveField(
model_name='product',
name='slug',
),
migrations.AlterUniqueTogether(
name='producttranslation',
unique_together={('language_code', 'master')},
),
migrations.AlterUniqueTogether(
name='categorytranslation',
unique_together={('language_code', 'master')},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('documents', '0005_auto_20160616_1938'),
]
operations = [
migrations.CreateModel(
name='Transcript',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=255)),
('description', models.TextField(blank=True, null=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('case',
models.OneToOneField(
on_delete=django.db.models.deletion.PROTECT,
related_name='transcript',
to='documents.DocumentCase')),
],
),
migrations.CreateModel(
name='TranscriptPage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('seq_number', models.IntegerField(db_index=True)),
('volume_seq_number', models.IntegerField(db_index=True)),
('date', models.DateTimeField(blank=True, null=True)),
('page_number', models.IntegerField(blank=True, null=True)),
('page_label',
models.CharField(blank=True, max_length=10, null=True)),
('xml', models.TextField()),
('transcript',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='pages',
to='transcripts.Transcript')),
],
),
migrations.CreateModel(
name='TranscriptVolume',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('volume_number', models.IntegerField()),
('description', models.TextField(blank=True, null=True)),
('transcript',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
related_name='volumes',
to='transcripts.Transcript')),
],
),
migrations.AddField(
model_name='transcriptpage',
name='volume',
field=models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
related_name='pages',
to='transcripts.TranscriptVolume'),
),
migrations.AlterUniqueTogether(
name='transcriptpage',
unique_together=set([('volume', 'volume_seq_number'),
('transcript', 'seq_number')]),
),
migrations.AlterIndexTogether(
name='transcriptpage',
index_together=set([('volume', 'volume_seq_number'),
('transcript', 'seq_number')]),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Db_account',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user', models.CharField(max_length=30)),
('passwd', models.CharField(max_length=255)),
('db_account_role',
models.CharField(choices=[('read', 'read'),
('write', 'write'),
('read_write', 'read_write'),
('admin', 'admin'), ('all', 'all')],
default='all',
max_length=30)),
('tags', models.CharField(db_index=True, max_length=80)),
('create_user', models.CharField(max_length=50, null=True)),
('create_date', models.DateTimeField(auto_now_add=True)),
('update_user', models.CharField(max_length=50, null=True)),
('update_date', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Db_database_permission',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('permission',
models.CharField(choices=[('read', 'read'),
('write', 'write'),
('read_write', 'read_write'),
('admin', 'admin'), ('all', 'all')],
default='read',
max_length=20)),
('create_user', models.CharField(max_length=50, null=True)),
('create_date', models.DateTimeField(auto_now_add=True)),
('update_user', models.CharField(max_length=50, null=True)),
('update_date', models.DateTimeField(auto_now=True)),
('account',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Db_database_permission_detail',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('permission_detail',
models.CharField(max_length=500, null=True)),
('black_table', models.CharField(max_length=500, null=True)),
('create_user', models.CharField(max_length=50, null=True)),
('create_date', models.DateTimeField(auto_now_add=True)),
('update_user', models.CharField(max_length=50, null=True)),
('update_date', models.DateTimeField(auto_now=True)),
('permission',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='myapp.Db_database_permission')),
],
),
migrations.CreateModel(
name='Db_group',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('groupname', models.CharField(max_length=30, unique=True)),
('account',
models.ManyToManyField(to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Db_instance',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('ip', models.CharField(max_length=30)),
('port', models.CharField(max_length=10)),
('db_type', models.CharField(default='mysql', max_length=30)),
('comments', models.CharField(max_length=100, null=True)),
('status',
models.CharField(choices=[('Idle', 'Idle'),
('InUse', 'InUse')],
max_length=20)),
('create_user', models.CharField(max_length=50, null=True)),
('create_date', models.DateTimeField(auto_now_add=True)),
('update_user', models.CharField(max_length=50, null=True)),
('update_date', models.DateTimeField(auto_now=True)),
('admin_user',
models.ManyToManyField(to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Db_name',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('dbtag', models.CharField(max_length=80)),
('dbname', models.CharField(max_length=30)),
('create_user', models.CharField(max_length=50, null=True)),
('create_date', models.DateTimeField(auto_now_add=True)),
('update_user', models.CharField(max_length=50, null=True)),
('update_date', models.DateTimeField(auto_now=True)),
('dbaccount',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='myapp.Db_account')),
],
),
migrations.CreateModel(
name='Incep_error_log',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('task_id', models.IntegerField(default=0, null=True)),
('myid', models.IntegerField()),
('stage', models.CharField(max_length=20)),
('errlevel', models.IntegerField()),
('stagestatus', models.CharField(max_length=40)),
('errormessage', models.TextField()),
('sqltext', models.TextField()),
('affectrow', models.IntegerField()),
('sequence', models.CharField(db_index=True, max_length=30)),
('backup_db', models.CharField(max_length=100)),
('execute_time', models.CharField(max_length=20)),
('sqlsha', models.CharField(max_length=50)),
('create_time', models.DateTimeField(db_index=True)),
('finish_time', models.DateTimeField()),
],
),
migrations.CreateModel(
name='Instance_account_admin',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('account',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
('db_account',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='myapp.Db_account')),
],
),
migrations.CreateModel(
name='Login_log',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user', models.CharField(max_length=35)),
('ipaddr', models.CharField(max_length=35)),
('action', models.CharField(max_length=20)),
('create_time', models.DateTimeField(db_index=True)),
],
),
migrations.CreateModel(
name='MySQL_monitor',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('tag', models.CharField(max_length=20)),
('monitor', models.SmallIntegerField(default=1)),
('check_longsql', models.SmallIntegerField(default=0)),
('longsql_time', models.SmallIntegerField(default=1200)),
('longsql_autokill', models.SmallIntegerField(default=0)),
('check_active', models.SmallIntegerField(default=0)),
('active_threshold', models.SmallIntegerField(default=30)),
('check_connections', models.SmallIntegerField(default=0)),
('connection_threshold', models.IntegerField(default=1000)),
('check_delay', models.SmallIntegerField(default=0)),
('delay_threshold', models.IntegerField(default=3600)),
('check_slave', models.SmallIntegerField(default=0)),
('replchannel', models.CharField(default='0', max_length=30)),
('alarm_times', models.SmallIntegerField(default=3)),
('alarm_interval', models.SmallIntegerField(default=60)),
('mail_to', models.CharField(max_length=255)),
('account',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='myapp.Db_account')),
('instance',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to='myapp.Db_instance')),
],
options={
'db_table': 'mysql_monitor',
},
),
migrations.CreateModel(
name='Oper_log',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user', models.CharField(max_length=35)),
('ipaddr', models.CharField(max_length=35)),
('dbtag', models.CharField(max_length=35)),
('dbname', models.CharField(max_length=300)),
('sqltext', models.TextField()),
('sqltype', models.CharField(max_length=20)),
('create_time', models.DateTimeField(db_index=True)),
('login_time', models.DateTimeField()),
('group_id', models.IntegerField()),
('host_id', models.IntegerField()),
],
),
migrations.CreateModel(
name='Task',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user', models.CharField(max_length=35)),
('instance', models.CharField(max_length=100)),
('db_account_role', models.CharField(max_length=15)),
('dbtag', models.CharField(max_length=35)),
('sqltext', models.TextField()),
('create_time', models.DateTimeField(db_index=True)),
('update_time', models.DateTimeField()),
('status', models.CharField(db_index=True, max_length=20)),
('sqlsha', models.TextField()),
('sche_time', models.DateTimeField(db_index=True, null=True)),
('specification', models.CharField(default='',
max_length=100)),
('operator', models.CharField(default='', max_length=35)),
('backup_status', models.SmallIntegerField(default=1)),
],
),
migrations.CreateModel(
name='Upload',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('username', models.CharField(max_length=40)),
('filename', models.FileField(upload_to='upload_sql')),
],
),
migrations.CreateModel(
name='User_profile',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('select_limit', models.IntegerField(default=200)),
('export_limit', models.IntegerField(default=200)),
('task_email', models.IntegerField(db_index=True)),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'permissions':
(('can_mysql_query', 'can see mysql_query view'),
('can_log_query', 'can see log_query view'),
('can_see_execview', 'can see mysql exec view'),
('can_see_inception', 'can see inception view'),
('can_see_metadata',
'can see meta_data view'), ('can_see_mysqladmin',
'can see mysql_admin view'),
('can_export', 'can export csv'), ('can_insert_mysql',
'can insert mysql'),
('can_update_mysql',
'can update mysql'), ('can_delete_mysql',
'can delete mysql'),
('can_create_mysql', 'can create mysql'), ('can_drop_mysql',
'can drop mysql'),
('can_truncate_mysql',
'can truncate mysql'), ('can_alter_mysql',
'can alter mysql'),
('can_query_mongo', 'can query mongo'), ('can_see_taskview',
'can see task view'),
('can_admin_task',
'can admin task'), ('can_delete_task',
'can delete task'), ('can_update_task',
'can update task'),
('can_query_pri',
'can query pri'), ('can_set_pri',
'can set pri'), ('can_oper_saltapi',
'can oper saltapi')),
},
),
migrations.AlterIndexTogether(
name='oper_log',
index_together=set([('dbtag', 'sqltype', 'create_time')]),
),
migrations.AddField(
model_name='db_group',
name='dbname',
field=models.ManyToManyField(to='myapp.Db_name'),
),
migrations.AddField(
model_name='db_database_permission',
name='db_name',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='myapp.Db_name'),
),
migrations.AddField(
model_name='db_account',
name='instance',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='myapp.Db_instance'),
),
migrations.AlterUniqueTogether(
name='db_instance',
unique_together=set([('ip', 'port')]),
),
migrations.AlterUniqueTogether(
name='db_account',
unique_together=set([('instance', 'db_account_role')]),
),
]
class Migration(migrations.Migration):
dependencies = [
('proso_common', '0002_auto_20150416_0929'),
('proso_models', '0005_answer_config'),
]
operations = [
migrations.CreateModel(
name='EnvironmentInfo',
fields=[
('id',
models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)),
('status',
models.IntegerField(default=1,
choices=[(0, 'disabled'), (1, 'loading'),
(2, 'enabled'), (3, 'active')])),
('revision', models.IntegerField()),
('load_progress', models.IntegerField(default=0)),
('updated', models.DateTimeField(auto_now=True)),
('created', models.DateTimeField(auto_now_add=True)),
('config', models.ForeignKey(to='proso_common.Config')),
],
options={},
bases=(models.Model, ),
),
migrations.AlterUniqueTogether(
name='environmentinfo',
unique_together=set([('config', 'revision')]),
),
migrations.AddField(
model_name='audit',
name='info',
field=models.ForeignKey(default=None,
blank=True,
to='proso_models.EnvironmentInfo',
null=True),
preserve_default=True,
),
migrations.AddField(
model_name='variable',
name='info',
field=models.ForeignKey(default=None,
blank=True,
to='proso_models.EnvironmentInfo',
null=True),
preserve_default=True,
),
migrations.AlterUniqueTogether(
name='variable',
unique_together=set([('info', 'key', 'user', 'item_primary',
'item_secondary')]),
),
migrations.AlterIndexTogether(
name='audit',
index_together=set([('info', 'key'), ('info', 'key', 'user'),
('info', 'key', 'user', 'item_primary'),
('info', 'key', 'user', 'item_primary',
'item_secondary'),
('info', 'key', 'item_primary')]),
),
migrations.AlterIndexTogether(
name='variable',
index_together=set([('info', 'key'), ('info', 'key', 'user'),
('info', 'key', 'user', 'item_primary'),
('info', 'key', 'user', 'item_primary',
'item_secondary'),
('info', 'key', 'item_primary')]),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('auth', '0008_alter_user_username_max_length'),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Comments',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('comments', models.TextField(max_length=400)),
('pro_id', models.IntegerField(default=0)),
],
),
migrations.CreateModel(
name='Profile',
fields=[
('bio', tinymce.models.HTMLField()),
('profile_photo',
pyuploadcare.dj.models.ImageField(blank=True)),
('user',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
primary_key=True,
serialize=False,
to=settings.AUTH_USER_MODEL)),
('phone_number', models.CharField(max_length=10)),
],
),
migrations.CreateModel(
name='Projects',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(max_length=20)),
('design', models.IntegerField(default=0)),
('usability', models.IntegerField(default=0)),
('content', models.IntegerField(default=0)),
('image_landing', models.ImageField(upload_to='landing/')),
('description',
tinymce.models.HTMLField(blank=True, max_length=200)),
('link',
url_or_relative_url_field.fields.URLOrRelativeURLField()),
('pub_date', models.DateTimeField(auto_now_add=True)),
('profile',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Rates',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('design',
models.IntegerField(
default=0,
validators=[django.core.validators.MaxValueValidator(10)
])),
('usability',
models.IntegerField(
default=0,
validators=[django.core.validators.MaxValueValidator(10)
])),
('content', models.IntegerField(default=0, validators=[10])),
('project', models.IntegerField(default=0)),
('user',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
options={
'ordering': ['-id'],
},
),
migrations.AddField(
model_name='comments',
name='user',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL),
),
migrations.AlterUniqueTogether(
name='rates',
unique_together=set([('user', 'design', 'usability', 'content',
'project')]),
),
migrations.AlterIndexTogether(
name='rates',
index_together=set([('user', 'design', 'usability', 'content',
'project')]),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='BrowserBotsLauncherSessionCode',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('code', models.CharField(max_length=10)),
('is_only_record',
models.BooleanField(default=True, unique=True)),
],
),
migrations.CreateModel(
name='ChatMessage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('channel', models.CharField(max_length=255)),
('nickname', models.CharField(max_length=255)),
('body', models.TextField()),
('timestamp', models.FloatField(default=time.time)),
],
),
migrations.CreateModel(
name='CompletedGroupWaitPage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('page_index', models.PositiveIntegerField()),
('id_in_subsession', models.PositiveIntegerField(default=0)),
],
),
migrations.CreateModel(
name='CompletedSubsessionWaitPage',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('page_index', models.PositiveIntegerField()),
],
),
migrations.CreateModel(
name='FailedSessionCreation',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('pre_create_id',
models.CharField(db_index=True, max_length=100)),
('message', models.CharField(max_length=300)),
('traceback', models.TextField(default='')),
],
),
migrations.CreateModel(
name='PageCompletion',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('app_name', models.CharField(max_length=300)),
('page_index', models.PositiveIntegerField()),
('page_name', models.CharField(max_length=300)),
('time_stamp', models.PositiveIntegerField()),
('seconds_on_page', models.PositiveIntegerField()),
('subsession_pk', models.PositiveIntegerField()),
('auto_submitted', models.BooleanField()),
],
),
migrations.CreateModel(
name='PageTimeout',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('page_index', models.PositiveIntegerField()),
('expiration_time', models.FloatField()),
],
),
migrations.CreateModel(
name='Participant',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('vars', otree.db.serializedfields._PickleField(default=dict)),
('label', otree.db.models.StringField(max_length=50,
null=True)),
('id_in_session',
otree.db.models.PositiveIntegerField(null=True)),
('payoff', otree.db.models.CurrencyField(default=0,
null=True)),
('time_started', otree.db.models.DateTimeField(null=True)),
('mturk_assignment_id',
otree.db.models.StringField(max_length=50, null=True)),
('mturk_worker_id',
otree.db.models.StringField(max_length=50, null=True)),
('_index_in_subsessions',
otree.db.models.PositiveIntegerField(default=0, null=True)),
('_index_in_pages',
otree.db.models.PositiveIntegerField(db_index=True,
default=0,
null=True)),
('_waiting_for_ids',
otree.db.models.StringField(max_length=300, null=True)),
('code',
otree.db.models.StringField(
default=otree.common_internal.random_chars_8,
max_length=16,
null=True,
unique=True)),
('visited',
otree.db.models.BooleanField(choices=[(True, 'Yes'),
(False, 'No')],
db_index=True,
default=False)),
('ip_address',
otree.db.models.GenericIPAddressField(null=True)),
('_last_page_timestamp',
otree.db.models.PositiveIntegerField(null=True)),
('_last_request_timestamp',
otree.db.models.PositiveIntegerField(null=True)),
('is_on_wait_page',
otree.db.models.BooleanField(choices=[(True, 'Yes'),
(False, 'No')],
default=False)),
('_current_page_name',
otree.db.models.StringField(max_length=200,
null=True,
verbose_name='page')),
('_current_app_name',
otree.db.models.StringField(max_length=200,
null=True,
verbose_name='app')),
('_round_number',
otree.db.models.PositiveIntegerField(null=True)),
('_current_form_page_url',
otree.db.models.URLField(null=True)),
('_max_page_index',
otree.db.models.PositiveIntegerField(null=True)),
('_browser_bot_finished',
otree.db.models.BooleanField(choices=[(True, 'Yes'),
(False, 'No')],
default=False)),
('_is_bot',
otree.db.models.BooleanField(choices=[(True, 'Yes'),
(False, 'No')],
default=False)),
('is_browser_bot',
otree.db.models.BooleanField(choices=[(True, 'Yes'),
(False, 'No')],
default=False)),
],
options={
'ordering': ['pk'],
},
bases=(otree.models.varsmixin._SaveTheChangeWithCustomFieldSupport,
otree_save_the_change.mixins.SaveTheChange, models.Model),
),
migrations.CreateModel(
name='ParticipantLockModel',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('participant_code',
models.CharField(max_length=16, unique=True)),
('locked', models.BooleanField(default=False)),
],
),
migrations.CreateModel(
name='ParticipantRoomVisit',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('room_name', models.CharField(max_length=50)),
('participant_label', models.CharField(max_length=200)),
('tab_unique_id', models.CharField(max_length=20,
unique=True)),
('last_updated', models.FloatField()),
],
),
migrations.CreateModel(
name='ParticipantToPlayerLookup',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('participant_code', models.CharField(max_length=20)),
('page_index', models.PositiveIntegerField()),
('app_name', models.CharField(max_length=300)),
('player_pk', models.PositiveIntegerField()),
('subsession_pk', models.PositiveIntegerField()),
('session_pk', models.PositiveIntegerField()),
('url', models.CharField(max_length=300)),
('participant',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='otree.Participant')),
],
),
migrations.CreateModel(
name='RoomToSession',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('room_name', models.CharField(max_length=255, unique=True)),
],
),
migrations.CreateModel(
name='Session',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('vars', otree.db.serializedfields._PickleField(default=dict)),
('config',
otree.db.serializedfields._PickleField(default=dict,
null=True)),
('label',
otree.db.models.StringField(
blank=True,
help_text='For internal record-keeping',
max_length=300,
null=True)),
('experimenter_name',
otree.db.models.StringField(
blank=True,
help_text='For internal record-keeping',
max_length=300,
null=True)),
('ready_for_browser',
otree.db.models.BooleanField(choices=[(True, 'Yes'),
(False, 'No')],
default=False)),
('code',
otree.db.models.StringField(
default=otree.common_internal.random_chars_8,
max_length=16,
null=True,
unique=True)),
('mturk_HITId',
otree.db.models.StringField(
blank=True,
help_text='Hit id for this session on MTurk',
max_length=300,
null=True)),
('mturk_HITGroupId',
otree.db.models.StringField(
blank=True,
help_text='Hit id for this session on MTurk',
max_length=300,
null=True)),
('mturk_num_participants',
otree.db.models.IntegerField(
default=-1,
help_text='Number of participants on MTurk',
null=True)),
('mturk_use_sandbox',
otree.db.models.BooleanField(
choices=[(True, 'Yes'), (False, 'No')],
default=True,
help_text=
'Should this session be created in mturk sandbox?')),
('mturk_expiration', otree.db.models.FloatField(null=True)),
('archived',
otree.db.models.BooleanField(choices=[(True, 'Yes'),
(False, 'No')],
db_index=True,
default=False)),
('comment',
otree.db.models.LongStringField(blank=True, null=True)),
('_anonymous_code',
otree.db.models.StringField(
db_index=True,
default=otree.common_internal.random_chars_10,
max_length=10,
null=True)),
('_pre_create_id',
otree.db.models.StringField(db_index=True,
max_length=255,
null=True)),
('is_demo',
otree.db.models.BooleanField(choices=[(True, 'Yes'),
(False, 'No')],
default=False)),
('_admin_report_app_names',
otree.db.models.LongStringField(default='', null=True)),
('_admin_report_num_rounds',
otree.db.models.StringField(default='',
max_length=255,
null=True)),
('num_participants',
otree.db.models.PositiveIntegerField(null=True)),
],
options={
'ordering': ['pk'],
},
bases=(otree.models.varsmixin._SaveTheChangeWithCustomFieldSupport,
otree_save_the_change.mixins.SaveTheChange, models.Model),
),
migrations.CreateModel(
name='UndefinedFormModel',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
],
),
migrations.AddField(
model_name='roomtosession',
name='session',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='otree.Session'),
),
migrations.AddField(
model_name='participant',
name='session',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='otree.Session'),
),
migrations.AddField(
model_name='pagetimeout',
name='participant',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='otree.Participant'),
),
migrations.AddField(
model_name='pagecompletion',
name='participant',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='otree.Participant'),
),
migrations.AddField(
model_name='pagecompletion',
name='session',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='otree.Session'),
),
migrations.AddField(
model_name='completedsubsessionwaitpage',
name='session',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='otree.Session'),
),
migrations.AddField(
model_name='completedgroupwaitpage',
name='session',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='otree.Session'),
),
migrations.AddField(
model_name='chatmessage',
name='participant',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='chat_messages_core',
to='otree.Participant'),
),
migrations.AlterUniqueTogether(
name='participanttoplayerlookup',
unique_together=set([('participant', 'page_index')]),
),
migrations.AlterIndexTogether(
name='participanttoplayerlookup',
index_together=set([('participant', 'page_index')]),
),
migrations.AlterIndexTogether(
name='participant',
index_together=set([('session', 'mturk_worker_id',
'mturk_assignment_id')]),
),
migrations.AlterIndexTogether(
name='pagetimeout',
index_together=set([('participant', 'page_index')]),
),
migrations.AlterIndexTogether(
name='completedsubsessionwaitpage',
index_together=set([('page_index', 'session')]),
),
migrations.AlterIndexTogether(
name='completedgroupwaitpage',
index_together=set([('page_index', 'session', 'id_in_subsession')
]),
),
migrations.AlterIndexTogether(
name='chatmessage',
index_together=set([('channel', 'timestamp')]),
),
]
class Migration(migrations.Migration):
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('catalog', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Kit',
fields=[
('id',
models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)),
('name',
models.CharField(default=b'', unique=True, max_length=255)),
('description', models.CharField(default=b'', max_length=255)),
],
options={
'ordering': ['name'],
},
bases=(models.Model, ),
),
migrations.CreateModel(
name='KitItem',
fields=[
('id',
models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)),
('quantity',
models.IntegerField(
default=1,
help_text=
b'Number of this item to include in a package when making the package from this kit.'
)),
('catalog_item', models.ForeignKey(to='catalog.CatalogItem')),
('kit',
models.ForeignKey(related_name=b'items', to='shipments.Kit')),
],
options={
'ordering': ['kit', 'catalog_item'],
},
bases=(models.Model, ),
),
migrations.CreateModel(
name='Location',
fields=[
('id',
models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)),
('longitude',
models.DecimalField(max_digits=13, decimal_places=10)),
('latitude',
models.DecimalField(max_digits=13, decimal_places=10)),
('altitude',
models.DecimalField(default=None,
null=True,
max_digits=13,
decimal_places=6,
blank=True)),
('accuracy',
models.DecimalField(default=None,
null=True,
max_digits=13,
decimal_places=6,
blank=True)),
('when', models.DateTimeField()),
],
options={
'ordering': ['-when'],
},
bases=(models.Model, ),
),
migrations.CreateModel(
name='Package',
fields=[
('id',
models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)),
('name', models.CharField(default=b'', max_length=255)),
('description', models.CharField(default=b'', max_length=255)),
('number_in_shipment',
models.IntegerField(
help_text=
b'The number assigned to this package in the shipment. Packages in a shipment are numbered, starting with 1. '
)),
('status',
models.IntegerField(default=1,
null=True,
blank=True,
choices=[(1, b'In progress'),
(2, b'Ready for pickup'),
(3, b'Picked up'),
(4, b'In transit'),
(5, b'Received'),
(6, b'Overdue'), (7, b'Lost'),
(8, b'Canceled')])),
('code', models.CharField(unique=True, max_length=45)),
('kit',
models.ForeignKey(blank=True, to='shipments.Kit', null=True)),
],
options={
'ordering': ['shipment', 'number_in_shipment', 'name'],
},
bases=(models.Model, ),
),
migrations.CreateModel(
name='PackageItem',
fields=[
('id',
models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)),
('description', models.CharField(max_length=255, blank=True)),
('unit', models.CharField(max_length=255, blank=True)),
('price_usd',
models.DecimalField(
decimal_places=2,
default=Decimal('0.00'),
max_digits=10,
validators=[
django.core.validators.MinValueValidator(0.0)
],
help_text=b'Price of one unit in US dollars',
verbose_name=b'Price USD')),
('price_local',
models.DecimalField(
decimal_places=4,
default=Decimal('0.00'),
max_digits=10,
validators=[
django.core.validators.MinValueValidator(0.0)
],
help_text=b'Price of one unit in TRY',
verbose_name=b'Price TRY')),
('weight',
models.FloatField(
default=0.0,
help_text=b'Weight of one unit',
validators=[
django.core.validators.MinValueValidator(0.0)
])),
('quantity', models.IntegerField(default=1)),
('catalog_item',
models.ForeignKey(blank=True,
to='catalog.CatalogItem',
null=True)),
('donor',
models.ForeignKey(on_delete=django.db.models.deletion.PROTECT,
blank=True,
to='catalog.Donor',
null=True)),
('donor_t1',
models.ForeignKey(related_name=b't1_package_items',
on_delete=django.db.models.deletion.PROTECT,
blank=True,
to='catalog.DonorCode',
null=True)),
('item_category',
models.ForeignKey(related_name=b'shipments_packageitem_items',
on_delete=django.db.models.deletion.PROTECT,
db_column=b'item_category',
blank=True,
to='catalog.ItemCategory',
null=True)),
('package',
models.ForeignKey(related_name=b'items',
on_delete=django.db.models.deletion.PROTECT,
to='shipments.Package')),
('supplier',
models.ForeignKey(related_name=b'package_items',
on_delete=django.db.models.deletion.PROTECT,
blank=True,
to='catalog.Supplier',
null=True)),
],
options={},
bases=(models.Model, ),
),
migrations.CreateModel(
name='Shipment',
fields=[
('id',
models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)),
('description', models.CharField(default=b'', max_length=255)),
('shipment_date',
models.DateField(default=datetime.date.today)),
('store_release', models.CharField(default=b'',
max_length=45)),
('date_in_transit', models.DateField(null=True, blank=True)),
('date_picked_up', models.DateField(null=True, blank=True)),
('date_expected', models.DateField(null=True, blank=True)),
('date_received', models.DateField(null=True, blank=True)),
('status',
models.IntegerField(default=1,
choices=[(1, b'In progress'),
(2, b'Ready for pickup'),
(3, b'Picked up'),
(4, b'In transit'),
(5, b'Received'),
(6, b'Overdue'), (7, b'Lost'),
(8, b'Canceled')])),
('acceptable', models.BooleanField(default=False)),
('status_note', models.TextField(blank=True)),
('donor', models.CharField(max_length=45,
null=True,
blank=True)),
('partner', models.ForeignKey(to=settings.AUTH_USER_MODEL)),
('transporter',
models.ForeignKey(blank=True,
to='catalog.Transporter',
null=True)),
],
options={},
bases=(shipments.models.ShipmentMixin, models.Model),
),
migrations.CreateModel(
name='WorldBorder',
fields=[
('id',
models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)),
('name', models.CharField(max_length=50)),
('area', models.IntegerField()),
('pop2005',
models.IntegerField(verbose_name=b'Population 2005')),
('fips',
models.CharField(max_length=2, verbose_name=b'FIPS Code')),
('iso2',
models.CharField(max_length=2, verbose_name=b'2 Digit ISO')),
('iso3',
models.CharField(max_length=3, verbose_name=b'3 Digit ISO')),
('un',
models.IntegerField(verbose_name=b'United Nations Code')),
('region', models.IntegerField(verbose_name=b'Region Code')),
('subregion',
models.IntegerField(verbose_name=b'Sub-Region Code')),
('lon', models.FloatField()),
('lat', models.FloatField()),
('mpoly',
django.contrib.gis.db.models.fields.MultiPolygonField(
srid=4326)),
],
options={
'ordering': ['name'],
},
bases=(models.Model, ),
),
migrations.AddField(
model_name='package',
name='shipment',
field=models.ForeignKey(
related_name=b'packages',
on_delete=django.db.models.deletion.PROTECT,
to='shipments.Shipment'),
preserve_default=True,
),
migrations.AlterUniqueTogether(
name='package',
unique_together=set([('shipment', 'number_in_shipment')]),
),
migrations.AlterIndexTogether(
name='package',
index_together=set([('shipment', 'number_in_shipment')]),
),
migrations.AddField(
model_name='location',
name='country',
field=models.ForeignKey(blank=True,
to='shipments.WorldBorder',
null=True),
preserve_default=True,
),
migrations.AddField(
model_name='location',
name='package',
field=models.ForeignKey(related_name=b'locations',
to='shipments.Package'),
preserve_default=True,
),
migrations.CreateModel(
name='PackageDBView',
fields=[],
options={
'db_table': 'packages_view',
'managed': False,
},
bases=(models.Model, ),
),
migrations.CreateModel(
name='ShipmentDBView',
fields=[],
options={
'db_table': 'shipments_view',
'managed': False,
},
bases=(shipments.models.ShipmentMixin, models.Model),
),
]
class Migration(migrations.Migration):
dependencies = [
('gallery', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='NotifyReceiver',
fields=[
('id',
models.AutoField(primary_key=True,
auto_created=True,
serialize=False,
verbose_name='ID')),
('email',
models.EmailField(verbose_name='e-mail', max_length=254)),
],
options={
'verbose_name': 'notification receiver',
'verbose_name_plural': 'notification receivers',
},
),
migrations.CreateModel(
name='OrderRecord',
fields=[
('id',
models.AutoField(primary_key=True,
auto_created=True,
serialize=False,
verbose_name='ID')),
('order_price',
libs.valute_field.fields.ValuteField(
verbose_name='price per item')),
('count',
models.PositiveIntegerField(verbose_name='quantity')),
],
options={
'verbose_name': 'product',
'verbose_name_plural': 'products',
},
),
migrations.CreateModel(
name='ShopCategory',
fields=[
('id',
models.AutoField(primary_key=True,
auto_created=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(verbose_name='title',
max_length=128)),
('slug',
libs.autoslug.AutoSlugField(populate_from='title',
unique=True,
verbose_name='slug')),
('product_count',
models.PositiveIntegerField(
default=0,
help_text='count of immediate visible products',
editable=False)),
('total_product_count',
models.PositiveIntegerField(
default=0,
help_text='count of visible products',
editable=False)),
('is_visible',
models.BooleanField(verbose_name='visible',
default=True,
db_index=True)),
('created',
models.DateTimeField(verbose_name='create date',
default=django.utils.timezone.now,
editable=False)),
('updated',
models.DateTimeField(verbose_name='change date',
auto_now=True)),
('sort_order',
models.IntegerField(verbose_name='order', default=0)),
('lft',
models.PositiveIntegerField(db_index=True, editable=False)),
('rght',
models.PositiveIntegerField(db_index=True, editable=False)),
('tree_id',
models.PositiveIntegerField(db_index=True, editable=False)),
('level',
models.PositiveIntegerField(db_index=True, editable=False)),
('parent',
mptt.fields.TreeForeignKey(blank=True,
related_name='children',
verbose_name='parent category',
to='shop.ShopCategory',
null=True)),
],
options={
'verbose_name': 'category',
'verbose_name_plural': 'categories',
},
),
migrations.CreateModel(
name='ShopConfig',
fields=[
('id',
models.AutoField(primary_key=True,
auto_created=True,
serialize=False,
verbose_name='ID')),
('header',
models.CharField(verbose_name='header', max_length=128)),
('updated',
models.DateTimeField(verbose_name='change date',
auto_now=True)),
],
options={
'verbose_name': 'settings',
'default_permissions': ('change', ),
},
),
migrations.CreateModel(
name='ShopOrder',
fields=[
('id',
models.AutoField(primary_key=True,
auto_created=True,
serialize=False,
verbose_name='ID')),
('uuid',
models.UUIDField(verbose_name='UUID',
default=uuid.uuid4,
editable=False,
unique=True)),
('session',
models.CharField(verbose_name='session',
max_length=64,
editable=False)),
('is_confirmed',
models.BooleanField(verbose_name='confirmed',
default=False,
editable=False)),
('confirm_date',
models.DateTimeField(verbose_name='confirm date',
null=True,
editable=False)),
('is_cancelled',
models.BooleanField(verbose_name='cancelled', default=False)),
('cancel_date',
models.DateTimeField(verbose_name='cancel date',
null=True,
editable=False)),
('is_checked',
models.BooleanField(verbose_name='checked', default=False)),
('check_date',
models.DateTimeField(verbose_name='check date',
null=True,
editable=False)),
('is_paid',
models.BooleanField(verbose_name='paid', default=False)),
('pay_date',
models.DateTimeField(verbose_name='pay date',
null=True,
editable=False)),
('is_archived',
models.BooleanField(verbose_name='archived', default=False)),
('archivation_date',
models.DateTimeField(verbose_name='archivation date',
null=True,
editable=False)),
('products_cost',
libs.valute_field.fields.ValuteField(
verbose_name='products cost', editable=False)),
('created',
models.DateTimeField(verbose_name='create date',
default=django.utils.timezone.now,
editable=False)),
],
options={
'verbose_name': 'order',
'verbose_name_plural': 'orders',
'ordering': ('-created', ),
},
),
migrations.CreateModel(
name='ShopProduct',
fields=[
('id',
models.AutoField(primary_key=True,
auto_created=True,
serialize=False,
verbose_name='ID')),
('title', models.CharField(verbose_name='title',
max_length=128)),
('slug',
libs.autoslug.AutoSlugField(populate_from='title',
unique=True,
verbose_name='slug')),
('description',
ckeditor.fields.CKEditorField(verbose_name='description',
blank=True)),
('price',
libs.valute_field.fields.ValuteField(verbose_name='price')),
('is_visible',
models.BooleanField(verbose_name='visible', default=True)),
('created',
models.DateTimeField(verbose_name='create date',
default=django.utils.timezone.now,
editable=False)),
('updated',
models.DateTimeField(verbose_name='change date',
auto_now=True)),
('category',
models.ForeignKey(related_name='immediate_products',
verbose_name='category',
to='shop.ShopCategory')),
],
options={
'ordering': ('-created', ),
'verbose_name_plural': 'products',
'verbose_name': 'product',
},
),
migrations.CreateModel(
name='ShopProductGallery',
fields=[
('id',
models.AutoField(primary_key=True,
auto_created=True,
serialize=False,
verbose_name='ID')),
],
options={
'verbose_name': 'gallery',
'abstract': False,
'verbose_name_plural': 'galleries',
'default_permissions': (),
},
),
migrations.CreateModel(
name='ShopProductGalleryImageItem',
fields=[
('galleryitembase_ptr',
models.OneToOneField(auto_created=True,
to='gallery.GalleryItemBase',
primary_key=True,
parent_link=True,
serialize=False)),
('image',
gallery.fields.GalleryImageField(
verbose_name='image',
upload_to=gallery.models.generate_filepath,
storage=libs.storages.media_storage.MediaStorage())),
('image_crop',
models.CharField(verbose_name='stored_crop',
max_length=32,
blank=True,
editable=False)),
],
options={
'verbose_name': 'image item',
'abstract': False,
'ordering': ('object_id', 'sort_order', 'created'),
'verbose_name_plural': 'image items',
'default_permissions': (),
},
bases=('gallery.galleryitembase', ),
),
migrations.AddField(
model_name='shopproduct',
name='gallery',
field=gallery.fields.GalleryField(
blank=True,
on_delete=django.db.models.deletion.SET_NULL,
verbose_name='gallery',
to='shop.ShopProductGallery',
null=True),
),
migrations.AddField(
model_name='orderrecord',
name='order',
field=models.ForeignKey(related_name='records',
verbose_name='order',
to='shop.ShopOrder'),
),
migrations.AddField(
model_name='orderrecord',
name='product',
field=models.ForeignKey(
on_delete=django.db.models.deletion.SET_NULL,
verbose_name='product',
to='shop.ShopProduct',
null=True),
),
migrations.AddField(
model_name='notifyreceiver',
name='config',
field=models.ForeignKey(to='shop.ShopConfig',
related_name='receivers'),
),
migrations.AlterIndexTogether(
name='shopproduct',
index_together=set([('category', 'is_visible')]),
),
migrations.AlterUniqueTogether(
name='orderrecord',
unique_together=set([('order', 'product')]),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('users', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='Checkpoint',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('zone', models.SmallIntegerField()),
('time', models.FloatField()),
('stage_time', models.FloatField()),
('velocity', models.FloatField(blank=True, null=True)),
],
),
migrations.CreateModel(
name='Map',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('name', models.CharField(max_length=50, unique=True)),
('author', models.CharField(blank=True, max_length=50)),
('type', models.IntegerField()),
('checkpoints', models.SmallIntegerField()),
('bonuses', models.SmallIntegerField()),
('difficulty', models.SmallIntegerField()),
('prevent_prehop', models.SmallIntegerField()),
('enable_baked_triggers', models.BooleanField()),
('active', models.BooleanField()),
],
),
migrations.CreateModel(
name='Server',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('address', models.CharField(max_length=32, unique=True)),
('name', models.CharField(blank=True, max_length=60)),
('date_created', models.DateTimeField()),
('current_map', models.CharField(blank=True, max_length=50)),
('bots_enabled', models.IntegerField()),
('key', models.CharField(blank=True, max_length=128)),
],
),
migrations.CreateModel(
name='Spawn',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('zone', models.SmallIntegerField()),
('type', models.SmallIntegerField()),
('origin', models.CharField(max_length=80)),
('angle', models.CharField(max_length=80)),
('velocity', models.CharField(max_length=80)),
],
),
migrations.CreateModel(
name='Time',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('type', models.SmallIntegerField()),
('stage', models.SmallIntegerField()),
('time', models.FloatField()),
('rank', models.IntegerField()),
('date_created', models.DateTimeField()),
('date_updated', models.DateTimeField()),
('completions', models.IntegerField()),
('best_rank', models.IntegerField()),
('date_demoted', models.DateTimeField()),
],
),
migrations.CreateModel(
name='Zone',
fields=[
('id', models.AutoField(primary_key=True, serialize=False)),
('start', models.CharField(max_length=80)),
('end', models.CharField(max_length=80)),
('type', models.IntegerField()),
('value', models.IntegerField()),
('limit_speed', models.BooleanField()),
('target_name', models.CharField(blank=True, max_length=32)),
('filter_name', models.CharField(blank=True, max_length=32)),
],
),
migrations.CreateModel(
name='MapConfiguration',
fields=[
('map',
models.OneToOneField(
on_delete=django.db.models.deletion.CASCADE,
primary_key=True,
serialize=False,
to='records.Map')),
('config',
models.CharField(blank=True, max_length=20000, null=True)),
],
),
migrations.AddField(
model_name='zone',
name='map',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, to='records.Map'),
),
migrations.AddField(
model_name='time',
name='map',
field=models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT, to='records.Map'),
),
migrations.AddField(
model_name='time',
name='player',
field=models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='users.Player'),
),
migrations.AddField(
model_name='time',
name='server',
field=models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='records.Server'),
),
migrations.AddField(
model_name='spawn',
name='map',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE, to='records.Map'),
),
migrations.AddField(
model_name='checkpoint',
name='map',
field=models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT, to='records.Map'),
),
migrations.AddField(
model_name='checkpoint',
name='player',
field=models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='users.Player'),
),
migrations.AlterUniqueTogether(
name='time',
unique_together={('map', 'player', 'stage', 'type')},
),
migrations.AlterIndexTogether(
name='time',
index_together={('map', 'type', 'stage')},
),
migrations.AlterUniqueTogether(
name='spawn',
unique_together={('map', 'zone', 'type')},
),
migrations.AlterUniqueTogether(
name='checkpoint',
unique_together={('player', 'map', 'zone')},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
]
operations = [
migrations.CreateModel(
name='DbConfig',
fields=[
('id', models.AutoField(primary_key=True, serialize=False, verbose_name='主键ID')),
('host', models.CharField(max_length=128, verbose_name='数据库地址')),
('port', models.IntegerField(default=3306, verbose_name='数据库端口')),
('character', models.CharField(choices=[('utf8', 'utf8'), ('utf8mb4', 'utf8mb4')], default='utf8', max_length=32, verbose_name='表字符集')),
('use_type', models.SmallIntegerField(choices=[(0, 'SQL审核'), (1, 'SQL查询')], default=0, verbose_name='用途')),
('rds_type', models.SmallIntegerField(choices=[(0, '华为云RDS'), (1, '阿里云RDS'), (2, '自建RDS')], default=2, verbose_name='数据库的类型')),
('rds_category', models.SmallIntegerField(choices=[(1, 'mysql'), (2, 'tidb')], default=1, verbose_name='数据库类别')),
('comment', models.CharField(max_length=128, null=True, verbose_name='主机描述')),
('created_at', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('updated_at', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
],
options={
'verbose_name': 'DB主机配置',
'verbose_name_plural': 'DB主机配置',
'db_table': 'yasql_dbconfig',
'default_permissions': (),
},
),
migrations.CreateModel(
name='DbEnvironment',
fields=[
('id', models.AutoField(primary_key=True, serialize=False, verbose_name='主键ID')),
('name', models.CharField(max_length=128, unique=True, verbose_name='名称')),
('created_at', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('updated_at', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
],
options={
'verbose_name': 'DB环境',
'verbose_name_plural': 'DB环境',
'db_table': 'yasql_db_environment',
'default_permissions': (),
},
),
migrations.CreateModel(
name='DbOrders',
fields=[
('id', models.AutoField(primary_key=True, serialize=False, verbose_name='主键ID')),
('title', models.CharField(max_length=64, verbose_name='工单标题')),
('order_id', models.CharField(blank=True, default='', max_length=128, verbose_name='工单号')),
('demand', models.CharField(blank=True, max_length=256, verbose_name='需求描述')),
('is_hide', models.CharField(blank=True, default='OFF', max_length=10, verbose_name='是否隐藏')),
('remark', models.CharField(choices=[('立即执行', '立即执行'), ('窗口执行', '窗口执行'), ('上线执行', '上线执行')], max_length=16, verbose_name='工单备注')),
('rds_category', models.SmallIntegerField(choices=[(1, 'mysql'), (2, 'tidb')], default=1, verbose_name='数据库类别')),
('sql_type', models.CharField(choices=[('DDL', 'DDL工单'), ('DML', 'DML工单'), ('EXPORT', '导出工单')], default='DML', max_length=30, verbose_name='工单类型')),
('file_format', models.CharField(blank=True, choices=[('xlsx', 'xlsx格式'), ('csv', 'csv格式')], max_length=30, verbose_name='导出工单的文件格式')),
('applicant', models.CharField(max_length=30, verbose_name='工单申请人')),
('department', models.CharField(blank=True, max_length=128, verbose_name='申请人所在的部门')),
('auditor', models.CharField(max_length=512, verbose_name='工单审核人')),
('executor', models.CharField(blank=True, max_length=512, null=True, verbose_name='工单执行人')),
('closer', models.CharField(blank=True, max_length=512, null=True, verbose_name='工单关闭人')),
('reviewer', models.CharField(max_length=512, verbose_name='工单复核人')),
('email_cc', models.CharField(blank=True, max_length=2048, null=True, verbose_name='抄送人')),
('database', models.CharField(max_length=32, verbose_name='库名')),
('progress', models.SmallIntegerField(choices=[(0, '待审核'), (1, '已驳回'), (2, '已批准'), (3, '处理中'), (4, '已完成'), (5, '已关闭'), (6, '已复核'), (7, '已勾住')], default=0, verbose_name='进度')),
('contents', models.TextField(default='', verbose_name='工单内容')),
('created_at', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('updated_at', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('cid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='sqlorders.DbConfig', verbose_name='数据库')),
('env', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='sqlorders.DbEnvironment', verbose_name='环境')),
],
options={
'verbose_name': 'DB工单记录',
'verbose_name_plural': 'DB工单记录',
'db_table': 'yasql_dborders',
'default_permissions': (),
},
),
migrations.CreateModel(
name='ReleaseVersions',
fields=[
('id', models.AutoField(primary_key=True, serialize=False, verbose_name='主键id')),
('username', models.CharField(default='', max_length=128, verbose_name='创建用户')),
('version', models.CharField(default='', max_length=128, unique=True, verbose_name='版本号')),
('expire_time', models.DateField(verbose_name='截止上线日期')),
('created_at', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('updated_at', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
],
options={
'verbose_name': '工单发布版本号',
'verbose_name_plural': '工单发布版本号',
'db_table': 'yasql_release_versions',
'default_permissions': (),
},
),
migrations.CreateModel(
name='DbOrdersExecuteTasks',
fields=[
('id', models.AutoField(primary_key=True, serialize=False, verbose_name='主键id')),
('applicant', models.CharField(blank=True, max_length=30, null=True, verbose_name='工单申请人')),
('task_id', models.CharField(max_length=128, verbose_name='任务ID')),
('sql_type', models.CharField(choices=[('DDL', 'DDL工单'), ('DML', 'DML工单'), ('EXPORT', '导出工单')], default='DML', max_length=30, verbose_name='工单类型')),
('executor', models.CharField(default='', max_length=30, verbose_name='工单执行人')),
('sql', models.TextField(default='', verbose_name='执行的SQL')),
('progress', models.SmallIntegerField(choices=[(0, '未执行'), (1, '已完成'), (2, '处理中'), (3, '失败'), (4, '暂停')], default=0, verbose_name='执行进度')),
('affected_rows', models.IntegerField(default=0, verbose_name='影响行数')),
('consuming_time', models.DecimalField(decimal_places=3, default=0.0, max_digits=10, verbose_name='耗时')),
('execute_log', models.TextField(default='', verbose_name='执行的日志')),
('rollback_sql', models.TextField(default='', verbose_name='回滚的SQL')),
('file_format', models.CharField(choices=[('xlsx', 'xlsx'), ('csv', 'csv'), ('txt', 'txt')], default='xlsx', max_length=30, verbose_name='导出的文件格式')),
('execute_time', models.DateTimeField(auto_now=True, verbose_name='工单执行时间')),
('created_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('order', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='sqlorders.DbOrders', verbose_name='关联工单id')),
],
options={
'verbose_name': 'DB工单执行任务',
'verbose_name_plural': 'DB工单执行任务',
'db_table': 'yasql_dborders_execute_tasks',
'default_permissions': (),
'index_together': {('task_id',), ('progress',)},
},
),
migrations.AddField(
model_name='dborders',
name='version',
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='sqlorders.ReleaseVersions', verbose_name='上线版本号'),
),
migrations.CreateModel(
name='DbExportFiles',
fields=[
('id', models.AutoField(primary_key=True, serialize=False, verbose_name='主键id')),
('file_name', models.CharField(default='', max_length=200, unique=True, verbose_name='文件名')),
('file_size', models.IntegerField(default=0, verbose_name='文件大小，单位B')),
('files', models.FileField(upload_to='export/')),
('encryption_key', models.CharField(default='', max_length=128, verbose_name='加密密钥')),
('content_type', models.CharField(default='', max_length=100, verbose_name='文件的类型')),
('created_at', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('task', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='sqlorders.DbOrdersExecuteTasks', verbose_name='关联执行任务的主键id')),
],
options={
'verbose_name': 'DB导出文件',
'verbose_name_plural': 'DB导出文件',
'db_table': 'yasql_db_export_files',
'default_permissions': (),
},
),
migrations.AddField(
model_name='dbconfig',
name='env',
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='sqlorders.DbEnvironment', verbose_name='环境'),
),
migrations.CreateModel(
name='DbSchemas',
fields=[
('id', models.AutoField(primary_key=True, serialize=False, verbose_name='主键ID')),
('schema', models.CharField(default='', max_length=64, verbose_name='库名')),
('created_at', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
('updated_at', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
('cid', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.SET_NULL, to='sqlorders.DbConfig', verbose_name='数据库')),
],
options={
'verbose_name': 'DB库',
'verbose_name_plural': 'DB库',
'db_table': 'yasql_dbschemas',
'default_permissions': (),
'unique_together': {('cid', 'schema')},
},
),
migrations.AlterUniqueTogether(
name='dborders',
unique_together={('order_id',)},
),
migrations.AlterIndexTogether(
name='dborders',
index_together={('progress',), ('remark',), ('title',), ('database',), ('applicant',)},
),
migrations.AlterUniqueTogether(
name='dbconfig',
unique_together={('host', 'port', 'use_type')},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('apps', '__first__'),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Attribute',
fields=[
('attribute_id',
models.CharField(max_length=32,
primary_key=True,
serialize=False,
validators=[
django.core.validators.RegexValidator(
'\\A[a-z][a-z0-9_]+\\Z',
'Invalid id')
])),
('type',
models.CharField(choices=[('string', 'string'),
('boolean', 'boolean'),
('relation', 'relation'),
('reverse', 'reverse'),
('number', 'number'),
('inet', 'inet'),
('macaddr', 'macaddr'),
('date', 'date'),
('supernet', 'supernet'),
('domain', 'domain')],
max_length=32)),
('multi', models.BooleanField(default=False)),
('hovertext', models.TextField(blank=True, default='')),
('group', models.CharField(default='other', max_length=32)),
('help_link',
models.CharField(blank=True, max_length=255, null=True)),
('readonly', models.BooleanField(default=False)),
('clone', models.BooleanField(default=False)),
('regexp',
models.CharField(
max_length=1024,
validators=[
django.core.validators.RegexValidator(
'\\A\\\\A.*\\\\Z\\Z',
'You must wrap your pattern in "\\A" and "\\Z" to force line matching'
)
])),
('reversed_attribute',
models.ForeignKey(blank=True,
db_index=False,
limit_choices_to={'type': 'relation'},
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='reversed_attribute_set',
to='serverdb.Attribute')),
],
options={
'db_table': 'attribute',
'ordering': ['attribute_id'],
},
),
migrations.CreateModel(
name='Change',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('change_on',
models.DateTimeField(db_index=True,
default=django.utils.timezone.now)),
('changes_json', models.TextField()),
('app',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.PROTECT,
to='apps.Application')),
('user',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.PROTECT,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='ChangeAdd',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('server_id', models.IntegerField(db_index=True)),
('attributes_json', models.TextField()),
],
),
migrations.CreateModel(
name='ChangeCommit',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('change_on',
models.DateTimeField(db_index=True,
default=django.utils.timezone.now)),
('app',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.PROTECT,
to='apps.Application')),
('user',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.PROTECT,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='ChangeDelete',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('server_id', models.IntegerField(db_index=True)),
('attributes_json', models.TextField()),
('commit',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='serverdb.ChangeCommit')),
],
),
migrations.CreateModel(
name='ChangeUpdate',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('server_id', models.IntegerField(db_index=True)),
('updates_json', models.TextField()),
('commit',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='serverdb.ChangeCommit')),
],
),
migrations.CreateModel(
name='Server',
fields=[
('server_id',
models.AutoField(primary_key=True, serialize=False)),
('hostname',
models.CharField(
max_length=64,
unique=True,
validators=[
django.core.validators.RegexValidator(
'\\A(\\*\\.)?([a-z0-9]+[\\.\\-])*[a-z0-9]+\\Z',
'Invalid hostname')
])),
('intern_ip',
netfields.fields.InetAddressField(blank=True,
max_length=39,
null=True)),
],
options={
'db_table': 'server',
},
),
migrations.CreateModel(
name='ServerBooleanAttribute',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('attribute',
models.ForeignKey(limit_choices_to={'type': 'boolean'},
on_delete=django.db.models.deletion.CASCADE,
to='serverdb.Attribute')),
('server',
models.ForeignKey(db_index=False,
on_delete=django.db.models.deletion.CASCADE,
to='serverdb.Server')),
],
options={
'db_table': 'server_boolean_attribute',
},
),
migrations.CreateModel(
name='ServerDateAttribute',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('value', models.DateField()),
('attribute',
models.ForeignKey(db_index=False,
limit_choices_to={'type': 'date'},
on_delete=django.db.models.deletion.CASCADE,
to='serverdb.Attribute')),
('server',
models.ForeignKey(db_index=False,
on_delete=django.db.models.deletion.CASCADE,
to='serverdb.Server')),
],
options={
'db_table': 'server_date_attribute',
},
),
migrations.CreateModel(
name='ServerInetAttribute',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('value', netfields.fields.InetAddressField(max_length=39)),
('attribute',
models.ForeignKey(db_index=False,
limit_choices_to={'type': 'inet'},
on_delete=django.db.models.deletion.CASCADE,
to='serverdb.Attribute')),
('server',
models.ForeignKey(db_index=False,
on_delete=django.db.models.deletion.CASCADE,
to='serverdb.Server')),
],
options={
'db_table': 'server_inet_attribute',
},
),
migrations.CreateModel(
name='ServerMACAddressAttribute',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('value', netfields.fields.MACAddressField()),
('attribute',
models.ForeignKey(db_index=False,
limit_choices_to={'type': 'macaddr'},
on_delete=django.db.models.deletion.CASCADE,
to='serverdb.Attribute')),
('server',
models.ForeignKey(db_index=False,
on_delete=django.db.models.deletion.CASCADE,
to='serverdb.Server')),
],
options={
'db_table': 'server_macaddr_attribute',
},
),
migrations.CreateModel(
name='ServerNumberAttribute',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('value', models.DecimalField(decimal_places=0,
max_digits=65)),
('attribute',
models.ForeignKey(db_index=False,
limit_choices_to={'type': 'number'},
on_delete=django.db.models.deletion.CASCADE,
to='serverdb.Attribute')),
('server',
models.ForeignKey(db_index=False,
on_delete=django.db.models.deletion.CASCADE,
to='serverdb.Server')),
],
options={
'db_table': 'server_number_attribute',
},
),
migrations.CreateModel(
name='ServerRelationAttribute',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('attribute',
models.ForeignKey(db_index=False,
limit_choices_to={'type': 'relation'},
on_delete=django.db.models.deletion.CASCADE,
to='serverdb.Attribute')),
('server',
models.ForeignKey(db_index=False,
on_delete=django.db.models.deletion.CASCADE,
to='serverdb.Server')),
('value',
models.ForeignKey(
db_column='value',
db_index=False,
on_delete=django.db.models.deletion.PROTECT,
related_name='relation_attribute_servers',
related_query_name='relation_attribute_server',
to='serverdb.Server')),
],
options={
'db_table': 'server_relation_attribute',
},
),
migrations.CreateModel(
name='ServerStringAttribute',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('value', models.CharField(max_length=1024)),
('attribute',
models.ForeignKey(db_index=False,
limit_choices_to={'type': 'string'},
on_delete=django.db.models.deletion.CASCADE,
to='serverdb.Attribute')),
('server',
models.ForeignKey(db_index=False,
on_delete=django.db.models.deletion.CASCADE,
to='serverdb.Server')),
],
options={
'db_table': 'server_string_attribute',
},
),
migrations.CreateModel(
name='Servertype',
fields=[
('servertype_id',
models.CharField(max_length=32,
primary_key=True,
serialize=False,
validators=[
django.core.validators.RegexValidator(
'\\A[a-z][a-z0-9_]+\\Z',
'Invalid id')
])),
('description', models.CharField(max_length=1024)),
('ip_addr_type',
models.CharField(choices=[('null', 'null'), ('host', 'host'),
('loadbalancer', 'loadbalancer'),
('network', 'network')],
max_length=32)),
],
options={
'db_table': 'servertype',
'ordering': ['servertype_id'],
},
),
migrations.CreateModel(
name='ServertypeAttribute',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('required', models.BooleanField(default=False)),
('default_value',
models.CharField(blank=True, max_length=255, null=True)),
('default_visible', models.BooleanField(default=False)),
('attribute',
models.ForeignKey(db_index=False,
on_delete=django.db.models.deletion.CASCADE,
related_name='servertype_attributes',
to='serverdb.Attribute')),
('consistent_via_attribute',
models.ForeignKey(
blank=True,
db_column='consistent_via_attribute_id',
db_index=False,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='consistent_via_servertype_attributes',
to='serverdb.Attribute')),
('related_via_attribute',
models.ForeignKey(
blank=True,
db_index=False,
limit_choices_to=models.
Q(type__in=['relation', 'reverse', 'supernet', 'domain']),
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='related_via_servertype_attributes',
to='serverdb.Attribute')),
('servertype',
models.ForeignKey(db_index=False,
on_delete=django.db.models.deletion.CASCADE,
related_name='attributes',
to='serverdb.Servertype')),
],
options={
'db_table': 'servertype_attribute',
'ordering': ['servertype', 'attribute'],
},
),
migrations.AddField(
model_name='server',
name='servertype',
field=models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to='serverdb.Servertype'),
),
migrations.AddField(
model_name='changeadd',
name='commit',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='serverdb.ChangeCommit'),
),
migrations.AddField(
model_name='attribute',
name='target_servertype',
field=models.ForeignKey(
blank=True,
db_index=False,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='serverdb.Servertype'),
),
migrations.AlterUniqueTogether(
name='servertypeattribute',
unique_together={('servertype', 'attribute')},
),
migrations.AlterUniqueTogether(
name='serverstringattribute',
unique_together={('server', 'attribute', 'value')},
),
migrations.AlterIndexTogether(
name='serverstringattribute',
index_together={('attribute', 'value')},
),
migrations.AlterUniqueTogether(
name='serverrelationattribute',
unique_together={('server', 'attribute', 'value')},
),
migrations.AlterIndexTogether(
name='serverrelationattribute',
index_together={('attribute', 'value')},
),
migrations.AlterUniqueTogether(
name='servernumberattribute',
unique_together={('server', 'attribute', 'value')},
),
migrations.AlterIndexTogether(
name='servernumberattribute',
index_together={('attribute', 'value')},
),
migrations.AlterUniqueTogether(
name='servermacaddressattribute',
unique_together={('server', 'attribute', 'value')},
),
migrations.AlterIndexTogether(
name='servermacaddressattribute',
index_together={('attribute', 'value')},
),
migrations.AlterUniqueTogether(
name='serverinetattribute',
unique_together={('server', 'attribute', 'value')},
),
migrations.AlterIndexTogether(
name='serverinetattribute',
index_together={('attribute', 'value')},
),
migrations.AlterUniqueTogether(
name='serverdateattribute',
unique_together={('server', 'attribute', 'value')},
),
migrations.AlterIndexTogether(
name='serverdateattribute',
index_together={('attribute', 'value')},
),
migrations.AlterUniqueTogether(
name='serverbooleanattribute',
unique_together={('server', 'attribute')},
),
migrations.AlterIndexTogether(
name='serverbooleanattribute',
index_together={('attribute', )},
),
migrations.AlterUniqueTogether(
name='changeupdate',
unique_together={('commit', 'server_id')},
),
migrations.AlterUniqueTogether(
name='changedelete',
unique_together={('commit', 'server_id')},
),
migrations.AlterUniqueTogether(
name='changeadd',
unique_together={('commit', 'server_id')},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Brand',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=30)),
],
),
migrations.CreateModel(
name='Category',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(db_index=True, max_length=30)),
('slug', models.SlugField(max_length=150, unique=True)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Product',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(db_index=True, max_length=80)),
('slug', models.SlugField(max_length=150, unique=True)),
('price', models.DecimalField(decimal_places=2,
max_digits=1000)),
('hight', models.PositiveIntegerField()),
('width', models.PositiveIntegerField()),
('image',
models.ImageField(
height_field='hight',
upload_to=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='products',
to='Product.Category'),
width_field='width')),
('store', models.PositiveIntegerField()),
('shirt_size',
models.CharField(blank=True,
choices=[('S', 'Small'), ('M', 'Medium'),
('L', 'Large')],
max_length=1,
null=True)),
('T_shirt_size',
models.CharField(blank=True,
choices=[('S', 'Small'), ('M', 'Medium'),
('L', 'Large')],
max_length=1,
null=True)),
('shoe_size',
models.CharField(blank=True,
choices=[('38', '38'), ('39', '39'),
('40', '40'), ('41', '42'),
('42', '42')],
max_length=1,
null=True)),
('author',
models.CharField(blank=True, max_length=30, null=True)),
('detail', models.TextField(blank=True, null=True)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('brand_name',
models.ForeignKey(null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='Brand',
to='Product.Brand')),
('category',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='products',
to='Product.Category')),
],
options={
'ordering': ('name', ),
},
),
migrations.AlterIndexTogether(
name='product',
index_together={('id', 'slug')},
),
]
class Migration(migrations.Migration):
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('website', '0016_auto_20190311_1301'),
]
operations = [
migrations.CreateModel(
name='Category',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(db_index=True, max_length=150)),
('slug', models.SlugField(max_length=150, unique=True)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
],
options={
'verbose_name': 'category',
'verbose_name_plural': 'categories',
'ordering': ('name', ),
},
),
migrations.CreateModel(
name='Movie',
fields=[
('name', models.TextField(primary_key=True, serialize=False)),
('cost', models.IntegerField(default=100)),
],
),
migrations.CreateModel(
name='Product',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(db_index=True, max_length=100)),
('slug', models.SlugField(max_length=100)),
('description', models.TextField(blank=True)),
('price', models.DecimalField(decimal_places=2,
max_digits=10)),
('available', models.BooleanField(default=True)),
('stock', models.PositiveIntegerField()),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField(auto_now=True)),
('img', models.ImageField(upload_to='')),
('category',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='products',
to='website.Category')),
],
options={
'ordering': ('name', ),
},
),
migrations.CreateModel(
name='TicketBook',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('date', models.DateField(auto_now=True)),
('amount', models.IntegerField(default=0)),
('movie',
models.ForeignKey(default=None,
on_delete=django.db.models.deletion.CASCADE,
to='website.Movie')),
('user',
models.ForeignKey(default=None,
on_delete=django.db.models.deletion.CASCADE,
to=settings.AUTH_USER_MODEL)),
],
),
migrations.AlterIndexTogether(
name='product',
index_together={('id', 'slug')},
),
]
class Migration(migrations.Migration):
dependencies = [
('auditcare', '0002_uniques'),
]
operations = [
migrations.AlterField(
model_name='accessaudit',
name='path',
field=corehq.util.models.TruncatingCharField(blank=True,
default='',
max_length=255),
),
migrations.AlterField(
model_name='navigationeventaudit',
name='params',
field=corehq.util.models.TruncatingCharField(blank=True,
default='',
max_length=4096),
),
migrations.AlterField(
model_name='navigationeventaudit',
name='path',
field=corehq.util.models.TruncatingCharField(blank=True,
default='',
max_length=255),
),
migrations.RunSQL("""
ALTER INDEX auditcare_accessaudit_user_event_date_c06ba8d2_idx
RENAME TO auditcare_a_user_58e671_idx;
ALTER INDEX auditcare_accessaudit_domain_event_date_81983947_idx
RENAME TO auditcare_a_domain_5a6b57_idx;
ALTER INDEX auditcare_navigationeventaudit_user_event_date_6dff2cf3_idx
RENAME TO auditcare_n_user_d3ff7f_idx;
ALTER INDEX auditcare_navigationeventaudit_domain_event_date_0808ba14_idx
RENAME TO auditcare_n_domain_c90cfb_idx;
""",
reverse_sql="""
ALTER INDEX auditcare_a_user_58e671_idx
RENAME TO auditcare_accessaudit_user_event_date_c06ba8d2_idx;
ALTER INDEX auditcare_a_domain_5a6b57_idx
RENAME TO auditcare_accessaudit_domain_event_date_81983947_idx;
ALTER INDEX auditcare_n_user_d3ff7f_idx
RENAME TO auditcare_navigationeventaudit_user_event_date_6dff2cf3_idx;
ALTER INDEX auditcare_n_domain_c90cfb_idx
RENAME TO auditcare_navigationeventaudit_domain_event_date_0808ba14_idx;
"""),
migrations.SeparateDatabaseAndState(
database_operations=[],
state_operations=[
migrations.AlterIndexTogether(name='accessaudit',
index_together=set()),
migrations.AlterIndexTogether(name='navigationeventaudit',
index_together=set()),
migrations.AddIndex(
model_name='accessaudit',
index=models.Index(fields=['user', 'event_date'],
name="auditcare_a_user_58e671_idx"),
),
migrations.AddIndex(
model_name='accessaudit',
index=models.Index(fields=['domain', 'event_date'],
name="auditcare_a_domain_5a6b57_idx"),
),
migrations.AddIndex(
model_name='navigationeventaudit',
index=models.Index(fields=['user', 'event_date'],
name="auditcare_n_user_d3ff7f_idx"),
),
migrations.AddIndex(
model_name='navigationeventaudit',
index=models.Index(fields=['domain', 'event_date'],
name="auditcare_n_domain_c90cfb_idx"),
),
],
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Diary',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('content', models.TextField(max_length=800)),
('create_time', models.IntegerField()),
],
),
migrations.CreateModel(
name='Group',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=20)),
('create_time', models.IntegerField()),
],
),
migrations.CreateModel(
name='Test',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=20)),
],
),
migrations.CreateModel(
name='User',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('username', models.CharField(max_length=50, unique=True)),
('age', models.SmallIntegerField(default=0)),
('phone',
models.IntegerField(blank=True,
db_index=True,
default=0,
max_length=11)),
('email',
models.EmailField(blank=True,
default='',
max_length=254,
unique=True)),
('info', models.TextField(max_length=500)),
('create_time', models.DateTimeField(auto_now_add=True)),
('updata_time', models.DateTimeField(auto_now=True)),
],
),
migrations.CreateModel(
name='Userprofile',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('birthday',
models.CharField(blank=True, default='', max_length=100)),
('user',
models.OneToOneField(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='app.User')),
],
),
migrations.AlterIndexTogether(
name='user',
index_together={('username', 'phone')},
),
migrations.AddField(
model_name='group',
name='user',
field=models.ManyToManyField(related_name='group', to='app.User'),
),
migrations.AddField(
model_name='diary',
name='user',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='diary',
to='app.User'),
),
]
class Migration(migrations.Migration):
replaces = [('music_publisher', '0003_dataimport'), ('music_publisher', '0004_auto_20200520_1335'), ('music_publisher', '0005_work__work_id'), ('music_publisher', '0006_auto_20200615_1026'), ('music_publisher', '0007_auto_20200629_1558'), ('music_publisher', '0008_auto_20200708_1318'), ('music_publisher', '0009_auto_20200710_1043')]
dependencies = [
('music_publisher', '0002_version20'),
]
operations = [
migrations.CreateModel(
name='DataImport',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('filename', models.CharField(editable=False, max_length=60)),
('report', models.TextField(editable=False)),
('date', models.DateTimeField(auto_now_add=True)),
],
options={
'verbose_name': 'Data Import',
'ordering': ('-date', '-id'),
},
),
migrations.AlterModelOptions(
name='artist',
options={'ordering': ('last_name', 'first_name', '-id'), 'verbose_name': 'Performing Artist', 'verbose_name_plural': 'Performing Artists'},
),
migrations.AlterModelOptions(
name='label',
options={'ordering': ('name',), 'verbose_name_plural': 'Music Labels'},
),
migrations.AlterModelOptions(
name='work',
options={'ordering': ('-id',), 'verbose_name': 'Musical Work'},
),
migrations.AlterModelOptions(
name='writer',
options={'ordering': ('last_name', 'first_name', 'ipi_name', '-id'), 'verbose_name_plural': ' Writers'},
),
migrations.AlterField(
model_name='alternatetitle',
name='title',
field=models.CharField(db_index=True, max_length=60, validators=[music_publisher.validators.CWRFieldValidator('title')]),
),
migrations.AlterField(
model_name='artist',
name='first_name',
field=models.CharField(blank=True, max_length=30, validators=[music_publisher.validators.CWRFieldValidator('name')]),
),
migrations.AlterField(
model_name='artist',
name='last_name',
field=models.CharField(db_index=True, max_length=45, validators=[music_publisher.validators.CWRFieldValidator('name')]),
),
migrations.AlterField(
model_name='label',
name='name',
field=models.CharField(max_length=60, unique=True, validators=[music_publisher.validators.CWRFieldValidator('name')]),
),
migrations.AlterField(
model_name='release',
name='cd_identifier',
field=models.CharField(blank=True, max_length=15, null=True, unique=True, validators=[music_publisher.validators.CWRFieldValidator('name')], verbose_name='CD identifier'),
),
migrations.AlterField(
model_name='release',
name='release_title',
field=models.CharField(blank=True, max_length=60, null=True, validators=[music_publisher.validators.CWRFieldValidator('title')], verbose_name='Release (album) title '),
),
migrations.AlterField(
model_name='work',
name='title',
field=models.CharField(db_index=True, max_length=60, validators=[music_publisher.validators.CWRFieldValidator('title')]),
),
migrations.AlterField(
model_name='writer',
name='first_name',
field=models.CharField(blank=True, max_length=30, validators=[music_publisher.validators.CWRFieldValidator('name')]),
),
migrations.AlterField(
model_name='writer',
name='ipi_base',
field=models.CharField(blank=True, max_length=15, null=True, validators=[music_publisher.validators.CWRFieldValidator('ipi_base')], verbose_name='IPI Base #'),
),
migrations.AlterField(
model_name='writer',
name='ipi_name',
field=models.CharField(blank=True, max_length=11, null=True, unique=True, validators=[music_publisher.validators.CWRFieldValidator('ipi_name')], verbose_name='IPI Name #'),
),
migrations.AlterField(
model_name='writer',
name='last_name',
field=models.CharField(db_index=True, max_length=45, validators=[music_publisher.validators.CWRFieldValidator('name')]),
),
migrations.AlterField(
model_name='writer',
name='mr_society',
field=models.CharField(blank=True, choices=[('226', 'AACIMH (HONDURAS)'), ('253', 'AAS (AZERBAIJAN)'), ('217', 'ABRAC (BRAZIL)'), ('201', 'ABRAMUS (BRAZIL)'), ('288', 'ABYROY (KAZAKHSTAN)'), ('107', 'ACAM (COSTA RICA)'), ('210', 'ACCESS COPYRIGHT (CANADA)'), ('306', 'ACCS (TRINIDAD AND TOBAGO)'), ('103', 'ACDAM (CUBA)'), ('76', 'ACEMLA (PUERTO RICO)'), ('260', 'ACS (UNITED KINGDOM)'), ('1', 'ACUM (ISRAEL)'), ('148', 'ADAGP (FRANCE)'), ('230', 'ADAVIS (CUBA)'), ('2', 'ADDAF (BRAZIL)'), ('250', 'AEI-GUATEMALA (GUATEMALA)'), ('3', 'AEPI (GREECE)'), ('4', 'AGADU (URUGUAY)'), ('289', 'AIPA (SLOVENIA)'), ('122', 'AKKA-LAA (LATVIA)'), ('5', 'AKM (AUSTRIA)'), ('127', 'ALBAUTOR (ALBANIA)'), ('54', 'ALCS (UNITED KINGDOM)'), ('30', 'AMAR (BRAZIL)'), ('12', 'AMCOS (AUSTRALIA)'), ('162', 'AMPAL (AUSTRALIA)'), ('17', 'AMRA (UNITED STATES)'), ('273', 'AMUS (BOSNIA AND HERZEGOVINA)'), ('218', 'ANACIM (BRAZIL)'), ('15', 'APA (PARAGUAY)'), ('7', 'APDAYC (PERU)'), ('163', 'APG-Japan (JAPAN)'), ('8', 'APRA (AUSTRALIA)'), ('164', 'APSAV (PERU)'), ('14', 'ARGENTORES (ARGENTINA)'), ('209', 'ARMAUTHOR NGO (ARMENIA)'), ('320', 'ARMONIA (FRANCE)'), ('149', 'ARS (UNITED STATES)'), ('236', 'ARTEGESTION (ECUADOR)'), ('9', 'ARTISJUS (HUNGARY)'), ('10', 'ASCAP (UNITED STATES)'), ('251', 'ASDACS (AUSTRALIA)'), ('219', 'ASSIM (BRAZIL)'), ('281', 'ATHINA- SADA - S.A.D.A. (GREECE)'), ('220', 'ATIDA (BRAZIL)'), ('141', 'ATN (CHILE)'), ('11', 'AUSTRO-MECHANA (AUME) (AUSTRIA)'), ('275', 'AUTODIAHIRISI (GREECE)'), ('166', 'AUTORARTE (VENEZUELA)'), ('231', 'AUTVIS (BRAZIL)'), ('203', 'AWGACS (AUSTRALIA)'), ('290', 'AZDG (AZERBAIJAN)'), ('202', 'AsDAC (MOLDOVA, REPUBLIC OF)'), ('274', 'AuPO CINEMA (UKRAINE)'), ('45', 'BBDA (BURKINA FASO)'), ('47', 'BCDA (CONGO)'), ('18', 'BGDA (GUINEA)'), ('132', 'BILD-KUNST (GERMANY)'), ('157', 'BILDRECHT GmbH (AUSTRIA)'), ('19', 'BMDA (MOROCCO)'), ('21', 'BMI (UNITED STATES)'), ('125', 'BNDA (NIGER)'), ('151', 'BONO (NORWAY)'), ('238', 'BSCAP (BELIZE)'), ('37', 'BUBEDRA (BENIN)'), ('6', 'BUCADA (CENTRAL AFRICAN REPUBLIC)'), ('23', 'BUMA (NETHERLANDS)'), ('16', 'BUMDA (MALI)'), ('24', "BURIDA (COTE D'IVOIRE)"), ('130', 'BUTODRA (TOGO)'), ('266', 'BeAT (BRUNEI DARUSSALAM)'), ('152', 'Bildupphovsrätt (Visual Copyright Society) (SWEDEN)'), ('168', 'CA (AUSTRALIA)'), ('283', 'CAPASSO (SOUTH AFRICA)'), ('264', 'CARCC (CANADA)'), ('26', 'CASH (HONG KONG)'), ('777', 'CELAS (GERMANY/UK)'), ('108', 'CHA (TAIWAN, CHINESE TAIPEI)'), ('316', 'CIS-Net AVI (FRANCE)'), ('312', 'CISAC (FRANCE)'), ('239', 'CMC (CAMEROON)'), ('88', 'CMRRA (CANADA)'), ('252', 'COLCCMA (TAIWAN, CHINESE TAIPEI)'), ('106', 'COMPASS (SINGAPORE)'), ('169', 'COSCAP (BARBADOS)'), ('124', 'COSOMA (MALAWI)'), ('268', 'COSON (NIGERIA)'), ('223', 'COSOTA (TANZANIA, UNITED REPUBLIC OF)'), ('284', 'COSOZA (ZANZIBAR)'), ('96', 'COTT (TRINIDAD AND TOBAGO)'), ('170', 'CPSN (NEPAL)'), ('171', 'CREAIMAGEN (CHILE)'), ('212', 'CSCS (CANADA)'), ('315', 'CSI (FRANCE)'), ('175', 'CopyRo (ROMANIA)'), ('248', 'DAC (ARGENTINA)'), ('296', 'DACIN-SARA (ROMANIA)'), ('153', 'DACS (UNITED KINGDOM)'), ('142', 'DALRO (SOUTH AFRICA)'), ('240', 'DAMA (SPAIN)'), ('276', 'DASC (COLOMBIA)'), ('293', 'DBCA (BRAZIL)'), ('172', 'DGA (UNITED STATES)'), ('271', 'DHFR (CROATIA)'), ('31', 'DILIA (CZECH REPUBLIC)'), ('173', 'DIRECTORES (MEXICO)'), ('145', 'DIRECTORS UK (UNITED KINGDOM)'), ('310', 'DIVA (HONG KONG)'), ('213', 'DRCC (CANADA)'), ('116', 'EAU (ESTONIA)'), ('308', 'ECAD (BRAZIL)'), ('214', 'ECCO (SAINT LUCIA)'), ('322', 'EVA (BELGIUM)'), ('147', 'FILMAUTOR (BULGARIA)'), ('174', 'FILMJUS (HUNGARY)'), ('32', 'FILSCAP (PHILIPPINES)'), ('222', 'FONOPERU (PERU)'), ('313', 'FastTrack DCN (FRANCE)'), ('261', 'GAI Uz (UZBEKISTAN)'), ('204', 'GCA (former SSA) (GEORGIA)'), ('297', 'GEDAR (BRAZIL)'), ('35', 'GEMA (GERMANY)'), ('635', 'GEMA-US (Additional CIS-Net Node)'), ('301', 'GESAC (BELGIUM)'), ('232', 'GESTOR (CZECH REPUBLIC)'), ('285', 'GHAMRO (GHANA)'), ('778', 'GMR ()'), ('144', 'HAA (CROATIA)'), ('111', 'HDS-ZAMP (CROATIA)'), ('34', 'HFA (UNITED STATES)'), ('154', 'HUNGART (HUNGARY)'), ('319', 'ICE Services AB (SWEDEN)'), ('229', 'ICG (UNITED STATES)'), ('314', 'IDA (FRANCE)'), ('128', 'IMRO (IRELAND)'), ('317', 'INTL-REP (FRANCE)'), ('36', 'IPRS (INDIA)'), ('247', 'IVARO (IRELAND)'), ('176', 'JACAP (JAMAICA)'), ('270', 'JASPAR (JAPAN)'), ('38', 'JASRAC (JAPAN)'), ('109', 'KCI (INDONESIA)'), ('40', 'KODA (DENMARK)'), ('118', 'KOMCA (KOREA, REPUBLIC OF)'), ('138', 'KOPIOSTO (FINLAND)'), ('287', 'KORRA (KOREA)'), ('178', 'KOSA (KOREA, REPUBLIC OF)'), ('179', 'KUVASTO (FINLAND)'), ('177', 'KazAK (KAZAKSTAN)'), ('215', 'Kyrgyzpatent (KYRGYZSTAN)'), ('110', 'LATGA-A (LITHUANIA)'), ('302', 'LATINAUTOR (URUGUAY)'), ('120', 'LIRA (NETHERLANDS)'), ('28', 'LITA (SLOVAKIA)'), ('41', 'LITERAR-MECHANA (AUSTRIA)'), ('309', 'LatinNet (SPAIN)'), ('265', 'MACA (MACAU)'), ('104', 'MACP (MALAYSIA)'), ('105', 'MASA (RMS) (MAURITIUS)'), ('44', 'MCPS (UNITED KINGDOM)'), ('311', 'MCPS-PRS Alliance (UNITED KINGDOM)'), ('119', 'MCSC (CHINA)'), ('43', 'MCSK (KENYA)'), ('22', 'MCSN (NIGERIA)'), ('126', 'MCT (THAILAND)'), ('117', 'MESAM (TURKEY)'), ('307', 'MIS@ASIA (SINGAPORE)'), ('272', 'MOSCAP (MONGOLIA)'), ('258', 'MRCSN (NEPAL)'), ('200', 'MSG (TURKEY)'), ('39', 'MUSICAUTOR (BULGARIA)'), ('707', 'MusicMark (USA)'), ('161', 'MÜST (TAIWAN, CHINESE TAIPEI)'), ('102', 'NASCAM (NAMIBIA)'), ('48', 'NCB (DENMARK)'), ('160', 'NCIP (BELARUS)'), ('241', 'NICAUTOR (NICARAGUA)'), ('181', 'NMPA (UNITED STATES)'), ('303', 'NORD-DOC (SWEDEN)'), ('286', 'ODDA (DJIBOUTI)'), ('291', 'OFA (SERBIA)'), ('33', 'OMDA (MADAGASCAR)'), ('49', 'ONDA (ALGERIA)'), ('298', 'OOA-S (CZECH REPUBLIC)'), ('50', 'OSA (CZECH REPUBLIC)'), ('82', 'OTPDA (TUNISIA)'), ('888', 'PAECOL (Additional CIS-Net Node)'), ('249', 'PAM CG (MONTENEGRO)'), ('182', 'PAPPRI (INDONESIA)'), ('256', 'PICTORIGHT (NETHERLANDS)'), ('51', 'PROLITTERIS (SWITZERLAND)'), ('52', 'PRS (UNITED KINGDOM)'), ('321', 'PUBLISHERS ()'), ('779', 'Polaris Nordic (SCANDINAVIA)'), ('94', 'RAO (RUSSIAN FEDERATION)'), ('294', 'REDES (COLOMBIA)'), ('228', 'ROMS (RUSSIAN FEDERATION)'), ('277', 'RSAU (RWANDA)'), ('278', 'RUR (RUSSIA)'), ('55', 'SABAM (BELGIUM)'), ('221', 'SABEM (BRAZIL)'), ('56', 'SACD (FRANCE)'), ('58', 'SACEM (FRANCE)'), ('758', 'SACEM-LIBAN (Additional CIS-Net Node)'), ('658', 'SACEM-US (Additional CIS-Net Node)'), ('233', 'SACEMLUXEMBOURG (LUXEMBOURG)'), ('235', 'SACENC (FRANCE)'), ('57', 'SACERAU (EGYPT)'), ('242', 'SACIM (EL SALVADOR)'), ('183', 'SACK (KOREA, REPUBLIC OF)'), ('59', 'SACM (MEXICO)'), ('263', 'SACS (SEYCHELLES)'), ('60', 'SACVEN (VENEZUELA)'), ('131', 'SADA (GREECE)'), ('61', 'SADAIC (ARGENTINA)'), ('62', 'SADEMBRA (BRAZIL)'), ('135', 'SADH (GREECE)'), ('243', 'SADIA (ANGOLA)'), ('295', 'SAGCRYT (MEXICO)'), ('225', 'SAIF (FRANCE)'), ('63', 'SAMRO (SOUTH AFRICA)'), ('280', 'SANASTO (FINLAND)'), ('184', 'SARTEC (CANADA)'), ('244', 'SASUR (SURINAME)'), ('257', 'SAVA (ARGENTINA)'), ('65', 'SAYCE (ECUADOR)'), ('84', 'SAYCO (COLOMBIA)'), ('112', 'SAZAS (SLOVENIA)'), ('66', 'SBACEM (BRAZIL)'), ('67', 'SBAT (BRAZIL)'), ('73', 'SCAM (FRANCE)'), ('29', 'SCD (CHILE)'), ('299', 'SCM-COOPERATIVA (CAPE VERDE)'), ('279', 'SDADV (ANDORRA)'), ('259', 'SDCSI (IRELAND)'), ('68', 'SDRM (FRANCE)'), ('71', 'SESAC Inc. (UNITED STATES)'), ('245', 'SETEM (TURKEY)'), ('192', 'SFF (SWEDEN)'), ('199', 'SFP-ZAPA (POLAND)'), ('208', 'SGA (GUINEA-BISSAU)'), ('227', 'SGACEDOM (DOMINICAN REPUBLIC)'), ('72', 'SGAE (SPAIN)'), ('672', 'SGAE-NY (Additional CIS-Net Node)'), ('186', 'SGDL (FRANCE)'), ('318', 'SGS ()'), ('74', 'SIAE (ITALY)'), ('86', 'SICAM (BRAZIL)'), ('262', 'SINEBIR (TURKEY)'), ('134', 'SLPRS (SRI LANKA)'), ('187', 'SNAC (FRANCE)'), ('129', 'SOBODAYCOM (BOLIVIA)'), ('101', 'SOCAN (CANADA)'), ('254', 'SOCILADRA (CAMEROON)'), ('189', 'SOCINPRO (BRAZIL)'), ('25', 'SODAV (SENEGAL)'), ('20', 'SODRAC (CANADA)'), ('137', 'SOFAM (BELGIUM)'), ('70', 'SOGEM (MEXICO)'), ('64', 'SOKOJ (SERBIA AND MONTENEGRO)'), ('155', 'SOMAAP (MEXICO)'), ('224', 'SOMAS (MOZAMBIQUE)'), ('304', 'SONGCODE (UNITED STATES)'), ('190', 'SOPE (GREECE)'), ('85', 'SOZA (SLOVAKIA)'), ('69', 'SPA (PORTUGAL)'), ('146', 'SPAC (PANAMA)'), ('87', 'SPACEM (FRANCE)'), ('191', 'SPACQ (CANADA)'), ('216', 'SQN (BOSNIA AND HERZEGOVINA)'), ('91', 'SSA (SWITZERLAND)'), ('77', 'STEF (ICELAND)'), ('78', 'STEMRA (NETHERLANDS)'), ('79', 'STIM (SWEDEN)'), ('80', 'SUISA (SWITZERLAND)'), ('75', 'SUISSIMAGE (SWITZERLAND)'), ('775', 'Solar EMI (GERMANY/UK)'), ('776', 'Solar Sony (GERMANY/UK)'), ('237', 'TALI (ISRAEL)'), ('143', 'TEATERAUTOR (BULGARIA)'), ('89', 'TEOSTO (FINLAND)'), ('90', 'TONO (NORWAY)'), ('207', "The Author's Registry Inc. (UNITED STATES)"), ('193', 'The Society of Authors (SOA) (UNITED KINGDOM)'), ('140', 'UACRR (UKRAINE)'), ('93', 'UBC (BRAZIL)'), ('115', 'UCMR-ADA (ROMANIA)'), ('194', 'UFFICIO GIURIDICO (HOLY SEE (VATICAN CITY STATE))'), ('206', 'UFW (FINLAND)'), ('282', 'UNAC-SA (ANGOLA)'), ('267', 'UPRAVIS (RUSSIAN FEDERATION)'), ('234', 'UPRS (UGANDA)'), ('156', 'VAGA (UNITED STATES)'), ('246', 'VCPMC (VIET NAM)'), ('121', 'VDFS (AUSTRIA)'), ('158', 'VEGAP (SPAIN)'), ('195', 'VEVAM (NETHERLANDS)'), ('95', 'VG WORT (GERMANY)'), ('159', 'VISCOPY (AUSTRALIA)'), ('139', 'VISDA (DENMARK)'), ('269', 'WAMI (INDONESIA)'), ('196', 'WGA (UNITED STATES)'), ('197', 'WGJ (JAPAN)'), ('300', 'WID Centre (UNITED STATES)'), ('97', 'ZAIKS (POLAND)'), ('133', 'ZAMCOPS (ZAMBIA)'), ('136', 'ZAMP - Macédoine (MACEDONIA)'), ('198', 'ZAMP Association of Slovenia (SLOVENIA)'), ('98', 'ZIMURA (ZIMBABWE)'), ('292', 'ZPAP (POLAND)')], max_length=3, null=True, validators=[music_publisher.validators.CWRFieldValidator('pr_society')], verbose_name='Mechanical rights society'),
),
migrations.AlterField(
model_name='writer',
name='pr_society',
field=models.CharField(blank=True, choices=[('226', 'AACIMH (HONDURAS)'), ('253', 'AAS (AZERBAIJAN)'), ('217', 'ABRAC (BRAZIL)'), ('201', 'ABRAMUS (BRAZIL)'), ('288', 'ABYROY (KAZAKHSTAN)'), ('107', 'ACAM (COSTA RICA)'), ('210', 'ACCESS COPYRIGHT (CANADA)'), ('306', 'ACCS (TRINIDAD AND TOBAGO)'), ('103', 'ACDAM (CUBA)'), ('76', 'ACEMLA (PUERTO RICO)'), ('260', 'ACS (UNITED KINGDOM)'), ('1', 'ACUM (ISRAEL)'), ('148', 'ADAGP (FRANCE)'), ('230', 'ADAVIS (CUBA)'), ('2', 'ADDAF (BRAZIL)'), ('250', 'AEI-GUATEMALA (GUATEMALA)'), ('3', 'AEPI (GREECE)'), ('4', 'AGADU (URUGUAY)'), ('289', 'AIPA (SLOVENIA)'), ('122', 'AKKA-LAA (LATVIA)'), ('5', 'AKM (AUSTRIA)'), ('127', 'ALBAUTOR (ALBANIA)'), ('54', 'ALCS (UNITED KINGDOM)'), ('30', 'AMAR (BRAZIL)'), ('12', 'AMCOS (AUSTRALIA)'), ('162', 'AMPAL (AUSTRALIA)'), ('17', 'AMRA (UNITED STATES)'), ('273', 'AMUS (BOSNIA AND HERZEGOVINA)'), ('218', 'ANACIM (BRAZIL)'), ('15', 'APA (PARAGUAY)'), ('7', 'APDAYC (PERU)'), ('163', 'APG-Japan (JAPAN)'), ('8', 'APRA (AUSTRALIA)'), ('164', 'APSAV (PERU)'), ('14', 'ARGENTORES (ARGENTINA)'), ('209', 'ARMAUTHOR NGO (ARMENIA)'), ('320', 'ARMONIA (FRANCE)'), ('149', 'ARS (UNITED STATES)'), ('236', 'ARTEGESTION (ECUADOR)'), ('9', 'ARTISJUS (HUNGARY)'), ('10', 'ASCAP (UNITED STATES)'), ('251', 'ASDACS (AUSTRALIA)'), ('219', 'ASSIM (BRAZIL)'), ('281', 'ATHINA- SADA - S.A.D.A. (GREECE)'), ('220', 'ATIDA (BRAZIL)'), ('141', 'ATN (CHILE)'), ('11', 'AUSTRO-MECHANA (AUME) (AUSTRIA)'), ('275', 'AUTODIAHIRISI (GREECE)'), ('166', 'AUTORARTE (VENEZUELA)'), ('231', 'AUTVIS (BRAZIL)'), ('203', 'AWGACS (AUSTRALIA)'), ('290', 'AZDG (AZERBAIJAN)'), ('202', 'AsDAC (MOLDOVA, REPUBLIC OF)'), ('274', 'AuPO CINEMA (UKRAINE)'), ('45', 'BBDA (BURKINA FASO)'), ('47', 'BCDA (CONGO)'), ('18', 'BGDA (GUINEA)'), ('132', 'BILD-KUNST (GERMANY)'), ('157', 'BILDRECHT GmbH (AUSTRIA)'), ('19', 'BMDA (MOROCCO)'), ('21', 'BMI (UNITED STATES)'), ('125', 'BNDA (NIGER)'), ('151', 'BONO (NORWAY)'), ('238', 'BSCAP (BELIZE)'), ('37', 'BUBEDRA (BENIN)'), ('6', 'BUCADA (CENTRAL AFRICAN REPUBLIC)'), ('23', 'BUMA (NETHERLANDS)'), ('16', 'BUMDA (MALI)'), ('24', "BURIDA (COTE D'IVOIRE)"), ('130', 'BUTODRA (TOGO)'), ('266', 'BeAT (BRUNEI DARUSSALAM)'), ('152', 'Bildupphovsrätt (Visual Copyright Society) (SWEDEN)'), ('168', 'CA (AUSTRALIA)'), ('283', 'CAPASSO (SOUTH AFRICA)'), ('264', 'CARCC (CANADA)'), ('26', 'CASH (HONG KONG)'), ('777', 'CELAS (GERMANY/UK)'), ('108', 'CHA (TAIWAN, CHINESE TAIPEI)'), ('316', 'CIS-Net AVI (FRANCE)'), ('312', 'CISAC (FRANCE)'), ('239', 'CMC (CAMEROON)'), ('88', 'CMRRA (CANADA)'), ('252', 'COLCCMA (TAIWAN, CHINESE TAIPEI)'), ('106', 'COMPASS (SINGAPORE)'), ('169', 'COSCAP (BARBADOS)'), ('124', 'COSOMA (MALAWI)'), ('268', 'COSON (NIGERIA)'), ('223', 'COSOTA (TANZANIA, UNITED REPUBLIC OF)'), ('284', 'COSOZA (ZANZIBAR)'), ('96', 'COTT (TRINIDAD AND TOBAGO)'), ('170', 'CPSN (NEPAL)'), ('171', 'CREAIMAGEN (CHILE)'), ('212', 'CSCS (CANADA)'), ('315', 'CSI (FRANCE)'), ('175', 'CopyRo (ROMANIA)'), ('248', 'DAC (ARGENTINA)'), ('296', 'DACIN-SARA (ROMANIA)'), ('153', 'DACS (UNITED KINGDOM)'), ('142', 'DALRO (SOUTH AFRICA)'), ('240', 'DAMA (SPAIN)'), ('276', 'DASC (COLOMBIA)'), ('293', 'DBCA (BRAZIL)'), ('172', 'DGA (UNITED STATES)'), ('271', 'DHFR (CROATIA)'), ('31', 'DILIA (CZECH REPUBLIC)'), ('173', 'DIRECTORES (MEXICO)'), ('145', 'DIRECTORS UK (UNITED KINGDOM)'), ('310', 'DIVA (HONG KONG)'), ('213', 'DRCC (CANADA)'), ('116', 'EAU (ESTONIA)'), ('308', 'ECAD (BRAZIL)'), ('214', 'ECCO (SAINT LUCIA)'), ('322', 'EVA (BELGIUM)'), ('147', 'FILMAUTOR (BULGARIA)'), ('174', 'FILMJUS (HUNGARY)'), ('32', 'FILSCAP (PHILIPPINES)'), ('222', 'FONOPERU (PERU)'), ('313', 'FastTrack DCN (FRANCE)'), ('261', 'GAI Uz (UZBEKISTAN)'), ('204', 'GCA (former SSA) (GEORGIA)'), ('297', 'GEDAR (BRAZIL)'), ('35', 'GEMA (GERMANY)'), ('635', 'GEMA-US (Additional CIS-Net Node)'), ('301', 'GESAC (BELGIUM)'), ('232', 'GESTOR (CZECH REPUBLIC)'), ('285', 'GHAMRO (GHANA)'), ('778', 'GMR ()'), ('144', 'HAA (CROATIA)'), ('111', 'HDS-ZAMP (CROATIA)'), ('34', 'HFA (UNITED STATES)'), ('154', 'HUNGART (HUNGARY)'), ('319', 'ICE Services AB (SWEDEN)'), ('229', 'ICG (UNITED STATES)'), ('314', 'IDA (FRANCE)'), ('128', 'IMRO (IRELAND)'), ('317', 'INTL-REP (FRANCE)'), ('36', 'IPRS (INDIA)'), ('247', 'IVARO (IRELAND)'), ('176', 'JACAP (JAMAICA)'), ('270', 'JASPAR (JAPAN)'), ('38', 'JASRAC (JAPAN)'), ('109', 'KCI (INDONESIA)'), ('40', 'KODA (DENMARK)'), ('118', 'KOMCA (KOREA, REPUBLIC OF)'), ('138', 'KOPIOSTO (FINLAND)'), ('287', 'KORRA (KOREA)'), ('178', 'KOSA (KOREA, REPUBLIC OF)'), ('179', 'KUVASTO (FINLAND)'), ('177', 'KazAK (KAZAKSTAN)'), ('215', 'Kyrgyzpatent (KYRGYZSTAN)'), ('110', 'LATGA-A (LITHUANIA)'), ('302', 'LATINAUTOR (URUGUAY)'), ('120', 'LIRA (NETHERLANDS)'), ('28', 'LITA (SLOVAKIA)'), ('41', 'LITERAR-MECHANA (AUSTRIA)'), ('309', 'LatinNet (SPAIN)'), ('265', 'MACA (MACAU)'), ('104', 'MACP (MALAYSIA)'), ('105', 'MASA (RMS) (MAURITIUS)'), ('44', 'MCPS (UNITED KINGDOM)'), ('311', 'MCPS-PRS Alliance (UNITED KINGDOM)'), ('119', 'MCSC (CHINA)'), ('43', 'MCSK (KENYA)'), ('22', 'MCSN (NIGERIA)'), ('126', 'MCT (THAILAND)'), ('117', 'MESAM (TURKEY)'), ('307', 'MIS@ASIA (SINGAPORE)'), ('272', 'MOSCAP (MONGOLIA)'), ('258', 'MRCSN (NEPAL)'), ('200', 'MSG (TURKEY)'), ('39', 'MUSICAUTOR (BULGARIA)'), ('707', 'MusicMark (USA)'), ('161', 'MÜST (TAIWAN, CHINESE TAIPEI)'), ('102', 'NASCAM (NAMIBIA)'), ('48', 'NCB (DENMARK)'), ('160', 'NCIP (BELARUS)'), ('241', 'NICAUTOR (NICARAGUA)'), ('181', 'NMPA (UNITED STATES)'), ('303', 'NORD-DOC (SWEDEN)'), ('286', 'ODDA (DJIBOUTI)'), ('291', 'OFA (SERBIA)'), ('33', 'OMDA (MADAGASCAR)'), ('49', 'ONDA (ALGERIA)'), ('298', 'OOA-S (CZECH REPUBLIC)'), ('50', 'OSA (CZECH REPUBLIC)'), ('82', 'OTPDA (TUNISIA)'), ('888', 'PAECOL (Additional CIS-Net Node)'), ('249', 'PAM CG (MONTENEGRO)'), ('182', 'PAPPRI (INDONESIA)'), ('256', 'PICTORIGHT (NETHERLANDS)'), ('51', 'PROLITTERIS (SWITZERLAND)'), ('52', 'PRS (UNITED KINGDOM)'), ('321', 'PUBLISHERS ()'), ('779', 'Polaris Nordic (SCANDINAVIA)'), ('94', 'RAO (RUSSIAN FEDERATION)'), ('294', 'REDES (COLOMBIA)'), ('228', 'ROMS (RUSSIAN FEDERATION)'), ('277', 'RSAU (RWANDA)'), ('278', 'RUR (RUSSIA)'), ('55', 'SABAM (BELGIUM)'), ('221', 'SABEM (BRAZIL)'), ('56', 'SACD (FRANCE)'), ('58', 'SACEM (FRANCE)'), ('758', 'SACEM-LIBAN (Additional CIS-Net Node)'), ('658', 'SACEM-US (Additional CIS-Net Node)'), ('233', 'SACEMLUXEMBOURG (LUXEMBOURG)'), ('235', 'SACENC (FRANCE)'), ('57', 'SACERAU (EGYPT)'), ('242', 'SACIM (EL SALVADOR)'), ('183', 'SACK (KOREA, REPUBLIC OF)'), ('59', 'SACM (MEXICO)'), ('263', 'SACS (SEYCHELLES)'), ('60', 'SACVEN (VENEZUELA)'), ('131', 'SADA (GREECE)'), ('61', 'SADAIC (ARGENTINA)'), ('62', 'SADEMBRA (BRAZIL)'), ('135', 'SADH (GREECE)'), ('243', 'SADIA (ANGOLA)'), ('295', 'SAGCRYT (MEXICO)'), ('225', 'SAIF (FRANCE)'), ('63', 'SAMRO (SOUTH AFRICA)'), ('280', 'SANASTO (FINLAND)'), ('184', 'SARTEC (CANADA)'), ('244', 'SASUR (SURINAME)'), ('257', 'SAVA (ARGENTINA)'), ('65', 'SAYCE (ECUADOR)'), ('84', 'SAYCO (COLOMBIA)'), ('112', 'SAZAS (SLOVENIA)'), ('66', 'SBACEM (BRAZIL)'), ('67', 'SBAT (BRAZIL)'), ('73', 'SCAM (FRANCE)'), ('29', 'SCD (CHILE)'), ('299', 'SCM-COOPERATIVA (CAPE VERDE)'), ('279', 'SDADV (ANDORRA)'), ('259', 'SDCSI (IRELAND)'), ('68', 'SDRM (FRANCE)'), ('71', 'SESAC Inc. (UNITED STATES)'), ('245', 'SETEM (TURKEY)'), ('192', 'SFF (SWEDEN)'), ('199', 'SFP-ZAPA (POLAND)'), ('208', 'SGA (GUINEA-BISSAU)'), ('227', 'SGACEDOM (DOMINICAN REPUBLIC)'), ('72', 'SGAE (SPAIN)'), ('672', 'SGAE-NY (Additional CIS-Net Node)'), ('186', 'SGDL (FRANCE)'), ('318', 'SGS ()'), ('74', 'SIAE (ITALY)'), ('86', 'SICAM (BRAZIL)'), ('262', 'SINEBIR (TURKEY)'), ('134', 'SLPRS (SRI LANKA)'), ('187', 'SNAC (FRANCE)'), ('129', 'SOBODAYCOM (BOLIVIA)'), ('101', 'SOCAN (CANADA)'), ('254', 'SOCILADRA (CAMEROON)'), ('189', 'SOCINPRO (BRAZIL)'), ('25', 'SODAV (SENEGAL)'), ('20', 'SODRAC (CANADA)'), ('137', 'SOFAM (BELGIUM)'), ('70', 'SOGEM (MEXICO)'), ('64', 'SOKOJ (SERBIA AND MONTENEGRO)'), ('155', 'SOMAAP (MEXICO)'), ('224', 'SOMAS (MOZAMBIQUE)'), ('304', 'SONGCODE (UNITED STATES)'), ('190', 'SOPE (GREECE)'), ('85', 'SOZA (SLOVAKIA)'), ('69', 'SPA (PORTUGAL)'), ('146', 'SPAC (PANAMA)'), ('87', 'SPACEM (FRANCE)'), ('191', 'SPACQ (CANADA)'), ('216', 'SQN (BOSNIA AND HERZEGOVINA)'), ('91', 'SSA (SWITZERLAND)'), ('77', 'STEF (ICELAND)'), ('78', 'STEMRA (NETHERLANDS)'), ('79', 'STIM (SWEDEN)'), ('80', 'SUISA (SWITZERLAND)'), ('75', 'SUISSIMAGE (SWITZERLAND)'), ('775', 'Solar EMI (GERMANY/UK)'), ('776', 'Solar Sony (GERMANY/UK)'), ('237', 'TALI (ISRAEL)'), ('143', 'TEATERAUTOR (BULGARIA)'), ('89', 'TEOSTO (FINLAND)'), ('90', 'TONO (NORWAY)'), ('207', "The Author's Registry Inc. (UNITED STATES)"), ('193', 'The Society of Authors (SOA) (UNITED KINGDOM)'), ('140', 'UACRR (UKRAINE)'), ('93', 'UBC (BRAZIL)'), ('115', 'UCMR-ADA (ROMANIA)'), ('194', 'UFFICIO GIURIDICO (HOLY SEE (VATICAN CITY STATE))'), ('206', 'UFW (FINLAND)'), ('282', 'UNAC-SA (ANGOLA)'), ('267', 'UPRAVIS (RUSSIAN FEDERATION)'), ('234', 'UPRS (UGANDA)'), ('156', 'VAGA (UNITED STATES)'), ('246', 'VCPMC (VIET NAM)'), ('121', 'VDFS (AUSTRIA)'), ('158', 'VEGAP (SPAIN)'), ('195', 'VEVAM (NETHERLANDS)'), ('95', 'VG WORT (GERMANY)'), ('159', 'VISCOPY (AUSTRALIA)'), ('139', 'VISDA (DENMARK)'), ('269', 'WAMI (INDONESIA)'), ('196', 'WGA (UNITED STATES)'), ('197', 'WGJ (JAPAN)'), ('300', 'WID Centre (UNITED STATES)'), ('97', 'ZAIKS (POLAND)'), ('133', 'ZAMCOPS (ZAMBIA)'), ('136', 'ZAMP - Macédoine (MACEDONIA)'), ('198', 'ZAMP Association of Slovenia (SLOVENIA)'), ('98', 'ZIMURA (ZIMBABWE)'), ('292', 'ZPAP (POLAND)')], max_length=3, null=True, validators=[music_publisher.validators.CWRFieldValidator('pr_society')], verbose_name='Performance rights society'),
),
migrations.AlterField(
model_name='writer',
name='sr_society',
field=models.CharField(blank=True, choices=[('226', 'AACIMH (HONDURAS)'), ('253', 'AAS (AZERBAIJAN)'), ('217', 'ABRAC (BRAZIL)'), ('201', 'ABRAMUS (BRAZIL)'), ('288', 'ABYROY (KAZAKHSTAN)'), ('107', 'ACAM (COSTA RICA)'), ('210', 'ACCESS COPYRIGHT (CANADA)'), ('306', 'ACCS (TRINIDAD AND TOBAGO)'), ('103', 'ACDAM (CUBA)'), ('76', 'ACEMLA (PUERTO RICO)'), ('260', 'ACS (UNITED KINGDOM)'), ('1', 'ACUM (ISRAEL)'), ('148', 'ADAGP (FRANCE)'), ('230', 'ADAVIS (CUBA)'), ('2', 'ADDAF (BRAZIL)'), ('250', 'AEI-GUATEMALA (GUATEMALA)'), ('3', 'AEPI (GREECE)'), ('4', 'AGADU (URUGUAY)'), ('289', 'AIPA (SLOVENIA)'), ('122', 'AKKA-LAA (LATVIA)'), ('5', 'AKM (AUSTRIA)'), ('127', 'ALBAUTOR (ALBANIA)'), ('54', 'ALCS (UNITED KINGDOM)'), ('30', 'AMAR (BRAZIL)'), ('12', 'AMCOS (AUSTRALIA)'), ('162', 'AMPAL (AUSTRALIA)'), ('17', 'AMRA (UNITED STATES)'), ('273', 'AMUS (BOSNIA AND HERZEGOVINA)'), ('218', 'ANACIM (BRAZIL)'), ('15', 'APA (PARAGUAY)'), ('7', 'APDAYC (PERU)'), ('163', 'APG-Japan (JAPAN)'), ('8', 'APRA (AUSTRALIA)'), ('164', 'APSAV (PERU)'), ('14', 'ARGENTORES (ARGENTINA)'), ('209', 'ARMAUTHOR NGO (ARMENIA)'), ('320', 'ARMONIA (FRANCE)'), ('149', 'ARS (UNITED STATES)'), ('236', 'ARTEGESTION (ECUADOR)'), ('9', 'ARTISJUS (HUNGARY)'), ('10', 'ASCAP (UNITED STATES)'), ('251', 'ASDACS (AUSTRALIA)'), ('219', 'ASSIM (BRAZIL)'), ('281', 'ATHINA- SADA - S.A.D.A. (GREECE)'), ('220', 'ATIDA (BRAZIL)'), ('141', 'ATN (CHILE)'), ('11', 'AUSTRO-MECHANA (AUME) (AUSTRIA)'), ('275', 'AUTODIAHIRISI (GREECE)'), ('166', 'AUTORARTE (VENEZUELA)'), ('231', 'AUTVIS (BRAZIL)'), ('203', 'AWGACS (AUSTRALIA)'), ('290', 'AZDG (AZERBAIJAN)'), ('202', 'AsDAC (MOLDOVA, REPUBLIC OF)'), ('274', 'AuPO CINEMA (UKRAINE)'), ('45', 'BBDA (BURKINA FASO)'), ('47', 'BCDA (CONGO)'), ('18', 'BGDA (GUINEA)'), ('132', 'BILD-KUNST (GERMANY)'), ('157', 'BILDRECHT GmbH (AUSTRIA)'), ('19', 'BMDA (MOROCCO)'), ('21', 'BMI (UNITED STATES)'), ('125', 'BNDA (NIGER)'), ('151', 'BONO (NORWAY)'), ('238', 'BSCAP (BELIZE)'), ('37', 'BUBEDRA (BENIN)'), ('6', 'BUCADA (CENTRAL AFRICAN REPUBLIC)'), ('23', 'BUMA (NETHERLANDS)'), ('16', 'BUMDA (MALI)'), ('24', "BURIDA (COTE D'IVOIRE)"), ('130', 'BUTODRA (TOGO)'), ('266', 'BeAT (BRUNEI DARUSSALAM)'), ('152', 'Bildupphovsrätt (Visual Copyright Society) (SWEDEN)'), ('168', 'CA (AUSTRALIA)'), ('283', 'CAPASSO (SOUTH AFRICA)'), ('264', 'CARCC (CANADA)'), ('26', 'CASH (HONG KONG)'), ('777', 'CELAS (GERMANY/UK)'), ('108', 'CHA (TAIWAN, CHINESE TAIPEI)'), ('316', 'CIS-Net AVI (FRANCE)'), ('312', 'CISAC (FRANCE)'), ('239', 'CMC (CAMEROON)'), ('88', 'CMRRA (CANADA)'), ('252', 'COLCCMA (TAIWAN, CHINESE TAIPEI)'), ('106', 'COMPASS (SINGAPORE)'), ('169', 'COSCAP (BARBADOS)'), ('124', 'COSOMA (MALAWI)'), ('268', 'COSON (NIGERIA)'), ('223', 'COSOTA (TANZANIA, UNITED REPUBLIC OF)'), ('284', 'COSOZA (ZANZIBAR)'), ('96', 'COTT (TRINIDAD AND TOBAGO)'), ('170', 'CPSN (NEPAL)'), ('171', 'CREAIMAGEN (CHILE)'), ('212', 'CSCS (CANADA)'), ('315', 'CSI (FRANCE)'), ('175', 'CopyRo (ROMANIA)'), ('248', 'DAC (ARGENTINA)'), ('296', 'DACIN-SARA (ROMANIA)'), ('153', 'DACS (UNITED KINGDOM)'), ('142', 'DALRO (SOUTH AFRICA)'), ('240', 'DAMA (SPAIN)'), ('276', 'DASC (COLOMBIA)'), ('293', 'DBCA (BRAZIL)'), ('172', 'DGA (UNITED STATES)'), ('271', 'DHFR (CROATIA)'), ('31', 'DILIA (CZECH REPUBLIC)'), ('173', 'DIRECTORES (MEXICO)'), ('145', 'DIRECTORS UK (UNITED KINGDOM)'), ('310', 'DIVA (HONG KONG)'), ('213', 'DRCC (CANADA)'), ('116', 'EAU (ESTONIA)'), ('308', 'ECAD (BRAZIL)'), ('214', 'ECCO (SAINT LUCIA)'), ('322', 'EVA (BELGIUM)'), ('147', 'FILMAUTOR (BULGARIA)'), ('174', 'FILMJUS (HUNGARY)'), ('32', 'FILSCAP (PHILIPPINES)'), ('222', 'FONOPERU (PERU)'), ('313', 'FastTrack DCN (FRANCE)'), ('261', 'GAI Uz (UZBEKISTAN)'), ('204', 'GCA (former SSA) (GEORGIA)'), ('297', 'GEDAR (BRAZIL)'), ('35', 'GEMA (GERMANY)'), ('635', 'GEMA-US (Additional CIS-Net Node)'), ('301', 'GESAC (BELGIUM)'), ('232', 'GESTOR (CZECH REPUBLIC)'), ('285', 'GHAMRO (GHANA)'), ('778', 'GMR ()'), ('144', 'HAA (CROATIA)'), ('111', 'HDS-ZAMP (CROATIA)'), ('34', 'HFA (UNITED STATES)'), ('154', 'HUNGART (HUNGARY)'), ('319', 'ICE Services AB (SWEDEN)'), ('229', 'ICG (UNITED STATES)'), ('314', 'IDA (FRANCE)'), ('128', 'IMRO (IRELAND)'), ('317', 'INTL-REP (FRANCE)'), ('36', 'IPRS (INDIA)'), ('247', 'IVARO (IRELAND)'), ('176', 'JACAP (JAMAICA)'), ('270', 'JASPAR (JAPAN)'), ('38', 'JASRAC (JAPAN)'), ('109', 'KCI (INDONESIA)'), ('40', 'KODA (DENMARK)'), ('118', 'KOMCA (KOREA, REPUBLIC OF)'), ('138', 'KOPIOSTO (FINLAND)'), ('287', 'KORRA (KOREA)'), ('178', 'KOSA (KOREA, REPUBLIC OF)'), ('179', 'KUVASTO (FINLAND)'), ('177', 'KazAK (KAZAKSTAN)'), ('215', 'Kyrgyzpatent (KYRGYZSTAN)'), ('110', 'LATGA-A (LITHUANIA)'), ('302', 'LATINAUTOR (URUGUAY)'), ('120', 'LIRA (NETHERLANDS)'), ('28', 'LITA (SLOVAKIA)'), ('41', 'LITERAR-MECHANA (AUSTRIA)'), ('309', 'LatinNet (SPAIN)'), ('265', 'MACA (MACAU)'), ('104', 'MACP (MALAYSIA)'), ('105', 'MASA (RMS) (MAURITIUS)'), ('44', 'MCPS (UNITED KINGDOM)'), ('311', 'MCPS-PRS Alliance (UNITED KINGDOM)'), ('119', 'MCSC (CHINA)'), ('43', 'MCSK (KENYA)'), ('22', 'MCSN (NIGERIA)'), ('126', 'MCT (THAILAND)'), ('117', 'MESAM (TURKEY)'), ('307', 'MIS@ASIA (SINGAPORE)'), ('272', 'MOSCAP (MONGOLIA)'), ('258', 'MRCSN (NEPAL)'), ('200', 'MSG (TURKEY)'), ('39', 'MUSICAUTOR (BULGARIA)'), ('707', 'MusicMark (USA)'), ('161', 'MÜST (TAIWAN, CHINESE TAIPEI)'), ('102', 'NASCAM (NAMIBIA)'), ('48', 'NCB (DENMARK)'), ('160', 'NCIP (BELARUS)'), ('241', 'NICAUTOR (NICARAGUA)'), ('181', 'NMPA (UNITED STATES)'), ('303', 'NORD-DOC (SWEDEN)'), ('286', 'ODDA (DJIBOUTI)'), ('291', 'OFA (SERBIA)'), ('33', 'OMDA (MADAGASCAR)'), ('49', 'ONDA (ALGERIA)'), ('298', 'OOA-S (CZECH REPUBLIC)'), ('50', 'OSA (CZECH REPUBLIC)'), ('82', 'OTPDA (TUNISIA)'), ('888', 'PAECOL (Additional CIS-Net Node)'), ('249', 'PAM CG (MONTENEGRO)'), ('182', 'PAPPRI (INDONESIA)'), ('256', 'PICTORIGHT (NETHERLANDS)'), ('51', 'PROLITTERIS (SWITZERLAND)'), ('52', 'PRS (UNITED KINGDOM)'), ('321', 'PUBLISHERS ()'), ('779', 'Polaris Nordic (SCANDINAVIA)'), ('94', 'RAO (RUSSIAN FEDERATION)'), ('294', 'REDES (COLOMBIA)'), ('228', 'ROMS (RUSSIAN FEDERATION)'), ('277', 'RSAU (RWANDA)'), ('278', 'RUR (RUSSIA)'), ('55', 'SABAM (BELGIUM)'), ('221', 'SABEM (BRAZIL)'), ('56', 'SACD (FRANCE)'), ('58', 'SACEM (FRANCE)'), ('758', 'SACEM-LIBAN (Additional CIS-Net Node)'), ('658', 'SACEM-US (Additional CIS-Net Node)'), ('233', 'SACEMLUXEMBOURG (LUXEMBOURG)'), ('235', 'SACENC (FRANCE)'), ('57', 'SACERAU (EGYPT)'), ('242', 'SACIM (EL SALVADOR)'), ('183', 'SACK (KOREA, REPUBLIC OF)'), ('59', 'SACM (MEXICO)'), ('263', 'SACS (SEYCHELLES)'), ('60', 'SACVEN (VENEZUELA)'), ('131', 'SADA (GREECE)'), ('61', 'SADAIC (ARGENTINA)'), ('62', 'SADEMBRA (BRAZIL)'), ('135', 'SADH (GREECE)'), ('243', 'SADIA (ANGOLA)'), ('295', 'SAGCRYT (MEXICO)'), ('225', 'SAIF (FRANCE)'), ('63', 'SAMRO (SOUTH AFRICA)'), ('280', 'SANASTO (FINLAND)'), ('184', 'SARTEC (CANADA)'), ('244', 'SASUR (SURINAME)'), ('257', 'SAVA (ARGENTINA)'), ('65', 'SAYCE (ECUADOR)'), ('84', 'SAYCO (COLOMBIA)'), ('112', 'SAZAS (SLOVENIA)'), ('66', 'SBACEM (BRAZIL)'), ('67', 'SBAT (BRAZIL)'), ('73', 'SCAM (FRANCE)'), ('29', 'SCD (CHILE)'), ('299', 'SCM-COOPERATIVA (CAPE VERDE)'), ('279', 'SDADV (ANDORRA)'), ('259', 'SDCSI (IRELAND)'), ('68', 'SDRM (FRANCE)'), ('71', 'SESAC Inc. (UNITED STATES)'), ('245', 'SETEM (TURKEY)'), ('192', 'SFF (SWEDEN)'), ('199', 'SFP-ZAPA (POLAND)'), ('208', 'SGA (GUINEA-BISSAU)'), ('227', 'SGACEDOM (DOMINICAN REPUBLIC)'), ('72', 'SGAE (SPAIN)'), ('672', 'SGAE-NY (Additional CIS-Net Node)'), ('186', 'SGDL (FRANCE)'), ('318', 'SGS ()'), ('74', 'SIAE (ITALY)'), ('86', 'SICAM (BRAZIL)'), ('262', 'SINEBIR (TURKEY)'), ('134', 'SLPRS (SRI LANKA)'), ('187', 'SNAC (FRANCE)'), ('129', 'SOBODAYCOM (BOLIVIA)'), ('101', 'SOCAN (CANADA)'), ('254', 'SOCILADRA (CAMEROON)'), ('189', 'SOCINPRO (BRAZIL)'), ('25', 'SODAV (SENEGAL)'), ('20', 'SODRAC (CANADA)'), ('137', 'SOFAM (BELGIUM)'), ('70', 'SOGEM (MEXICO)'), ('64', 'SOKOJ (SERBIA AND MONTENEGRO)'), ('155', 'SOMAAP (MEXICO)'), ('224', 'SOMAS (MOZAMBIQUE)'), ('304', 'SONGCODE (UNITED STATES)'), ('190', 'SOPE (GREECE)'), ('85', 'SOZA (SLOVAKIA)'), ('69', 'SPA (PORTUGAL)'), ('146', 'SPAC (PANAMA)'), ('87', 'SPACEM (FRANCE)'), ('191', 'SPACQ (CANADA)'), ('216', 'SQN (BOSNIA AND HERZEGOVINA)'), ('91', 'SSA (SWITZERLAND)'), ('77', 'STEF (ICELAND)'), ('78', 'STEMRA (NETHERLANDS)'), ('79', 'STIM (SWEDEN)'), ('80', 'SUISA (SWITZERLAND)'), ('75', 'SUISSIMAGE (SWITZERLAND)'), ('775', 'Solar EMI (GERMANY/UK)'), ('776', 'Solar Sony (GERMANY/UK)'), ('237', 'TALI (ISRAEL)'), ('143', 'TEATERAUTOR (BULGARIA)'), ('89', 'TEOSTO (FINLAND)'), ('90', 'TONO (NORWAY)'), ('207', "The Author's Registry Inc. (UNITED STATES)"), ('193', 'The Society of Authors (SOA) (UNITED KINGDOM)'), ('140', 'UACRR (UKRAINE)'), ('93', 'UBC (BRAZIL)'), ('115', 'UCMR-ADA (ROMANIA)'), ('194', 'UFFICIO GIURIDICO (HOLY SEE (VATICAN CITY STATE))'), ('206', 'UFW (FINLAND)'), ('282', 'UNAC-SA (ANGOLA)'), ('267', 'UPRAVIS (RUSSIAN FEDERATION)'), ('234', 'UPRS (UGANDA)'), ('156', 'VAGA (UNITED STATES)'), ('246', 'VCPMC (VIET NAM)'), ('121', 'VDFS (AUSTRIA)'), ('158', 'VEGAP (SPAIN)'), ('195', 'VEVAM (NETHERLANDS)'), ('95', 'VG WORT (GERMANY)'), ('159', 'VISCOPY (AUSTRALIA)'), ('139', 'VISDA (DENMARK)'), ('269', 'WAMI (INDONESIA)'), ('196', 'WGA (UNITED STATES)'), ('197', 'WGJ (JAPAN)'), ('300', 'WID Centre (UNITED STATES)'), ('97', 'ZAIKS (POLAND)'), ('133', 'ZAMCOPS (ZAMBIA)'), ('136', 'ZAMP - Macédoine (MACEDONIA)'), ('198', 'ZAMP Association of Slovenia (SLOVENIA)'), ('98', 'ZIMURA (ZIMBABWE)'), ('292', 'ZPAP (POLAND)')], max_length=3, null=True, validators=[music_publisher.validators.CWRFieldValidator('pr_society')], verbose_name='Synchronization rights society'),
),
migrations.AddField(
model_name='work',
name='_work_id',
field=models.CharField(blank=True, editable=False, max_length=14, null=True, unique=True, validators=[music_publisher.validators.CWRFieldValidator('name')], verbose_name='Work ID'),
),
migrations.AlterModelOptions(
name='work',
options={'ordering': ('-id',), 'permissions': (('can_process_royalties', 'Can perform royalty calculations'),), 'verbose_name': 'Musical Work'},
),
migrations.AlterModelOptions(
name='alternatetitle',
options={'ordering': ('-suffix', 'title'), 'verbose_name': 'Alternative Title'},
),
migrations.AlterModelOptions(
name='commercialrelease',
options={'verbose_name': 'Commercial Release', 'verbose_name_plural': 'Commercial Releases'},
),
migrations.AlterModelOptions(
name='cwrexport',
options={'ordering': ('-id',), 'verbose_name': 'CWR Export', 'verbose_name_plural': 'CWR Exports'},
),
migrations.AlterModelOptions(
name='label',
options={'verbose_name': 'Music Label'},
),
migrations.AlterModelOptions(
name='libraryrelease',
options={'verbose_name': 'Library Release', 'verbose_name_plural': 'Library Releases'},
),
migrations.AlterModelOptions(
name='recording',
options={'ordering': ('-id',), 'verbose_name': 'Recording', 'verbose_name_plural': 'Recordings'},
),
migrations.AlterModelOptions(
name='release',
options={'verbose_name': 'Release'},
),
migrations.AlterModelOptions(
name='track',
options={'ordering': ('release', 'cut_number'), 'verbose_name': 'Track'},
),
migrations.AlterModelOptions(
name='writer',
options={'ordering': ('last_name', 'first_name', 'ipi_name', '-id'), 'verbose_name': 'Writer', 'verbose_name_plural': 'Writers'},
),
migrations.AlterModelOptions(
name='writerinwork',
options={'ordering': ('-controlled', 'writer__last_name', 'writer__first_name', '-id'), 'verbose_name': 'Writer in Work', 'verbose_name_plural': 'Writers in Work'},
),
migrations.AlterField(
model_name='work',
name='library_release',
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='works', to='music_publisher.LibraryRelease', verbose_name='Library release'),
),
migrations.AlterField(
model_name='work',
name='original_title',
field=models.CharField(blank=True, db_index=True, help_text='Use only for modification of existing works.', max_length=60, validators=[music_publisher.validators.CWRFieldValidator('work_title')], verbose_name='Title of original work'),
),
migrations.AlterField(
model_name='workacknowledgement',
name='remote_work_id',
field=models.CharField(blank=True, db_index=True, max_length=20, verbose_name='Remote work ID'),
),
migrations.AlterField(
model_name='writer',
name='ipi_base',
field=models.CharField(blank=True, max_length=15, null=True, validators=[music_publisher.validators.CWRFieldValidator('ipi_base')], verbose_name='IPI base #'),
),
migrations.AlterField(
model_name='writer',
name='ipi_name',
field=models.CharField(blank=True, max_length=11, null=True, unique=True, validators=[music_publisher.validators.CWRFieldValidator('ipi_name')], verbose_name='IPI name #'),
),
migrations.AlterIndexTogether(
name='workacknowledgement',
index_together={('society_code', 'remote_work_id')},
),
migrations.CreateModel(
name='OriginalPublishingAgreement',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
],
options={
'managed': True,
},
),
migrations.AlterModelOptions(
name='originalpublishingagreement',
options={'managed': False},
),
migrations.AlterModelOptions(
name='library',
options={'ordering': ('name',), 'verbose_name': 'Music Library', 'verbose_name_plural': 'Music Libraries'},
),
migrations.AddField(
model_name='writer',
name='original_publishing_agreement',
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, to='music_publisher.OriginalPublishingAgreement', verbose_name='Original Agreement'),
),
migrations.AddField(
model_name='writerinwork',
name='original_publishing_agreement',
field=models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, to='music_publisher.OriginalPublishingAgreement', verbose_name='Original Agreement'),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='AnaCategory',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(db_index=True,
max_length=150,
verbose_name='kategori adı')),
('slug',
models.SlugField(
help_text=
'Burası yalnızca site-dizaynı için. Dokunmayınız!',
max_length=150,
unique=True,
verbose_name='internet adresi')),
('sayfa_durumu',
models.BooleanField(
default=False,
help_text=
'1500-2500 gibi sayfa sayısı varsa işaretlenecek',
verbose_name='Sayfa Sayısı Var mı?')),
('bireysel_mi',
models.BooleanField(
default=False,
help_text=
'Öğrencilerle beraber oynanMAyacaksa işaretlenecek!!!',
verbose_name='Bireysel mi')),
('sadece_madalyalı_mı',
models.BooleanField(
default=False,
help_text=
'Herhangi bir oyun olmaksızın bir kategori ise işaretlenecek Örneğin; sadece madalya için',
verbose_name='Sadece Madalya mı')),
('sıralama_sayısı',
models.PositiveIntegerField(verbose_name='Sıralama Sayısı')),
('aktif',
models.BooleanField(
default=False,
help_text=
'Sitede görünmesini istiyorsanız işaretleyiniz!!!',
verbose_name='Aktif mi?')),
('indirim_miktarı',
models.PositiveIntegerField(default=0,
verbose_name='İndirim miktarı')),
('arka_plan_renk',
models.CharField(choices=[('btn-primary', 'mavi'),
('btn-secondary', 'gri'),
('btn-success', 'yeşil'),
('btn-danger', 'kırmızı'),
('btn-warning', 'turuncu'),
('btn-info', 'açık mavi'),
('btn-light', 'ince beyaz'),
('btn-dark', 'koyu siyah'),
('btn-white', 'kalın beyaz'),
('btn-link', 'sadece mavi link')],
default='btn-primary',
max_length=50,
verbose_name='Anakategori arka plan rengi')),
],
options={
'verbose_name': 'Ana-Kategori',
'verbose_name_plural': 'Ana-Kategoriler',
'ordering': ('sıralama_sayısı', ),
},
),
migrations.CreateModel(
name='Category',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(db_index=True,
max_length=150,
verbose_name='kategori adı')),
('slug',
models.SlugField(max_length=150,
unique=True,
verbose_name='internet adresi')),
('image1',
models.ImageField(blank=True,
null=True,
upload_to='',
verbose_name='Küçültülmüş Kategori Resmi')),
('image2',
models.ImageField(blank=True,
null=True,
upload_to='',
verbose_name='Gerçek Kategori Resmi')),
('sayi',
models.PositiveIntegerField(verbose_name='Sıralama Sayısı')),
('madalyalı_mı',
models.BooleanField(default=True,
verbose_name='Madalyalı mı')),
('sayfa_sayısı',
models.CharField(choices=[('a', 0), ('a', 1000), ('b', 1500),
('c', 2500)],
max_length=1,
verbose_name='sayfa sayısı')),
('aktif',
models.BooleanField(
default=False,
help_text=
'Sitede görünmesini istiyorsanız işaretleyiniz!!!',
verbose_name='Aktif mi?')),
('ana_kategori',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='altkategoriler',
to='shop.AnaCategory',
verbose_name='Ana Kategori')),
],
options={
'verbose_name': 'Kategori',
'verbose_name_plural': 'Kategoriler',
'ordering': ('sayi', ),
},
),
migrations.CreateModel(
name='Product',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name',
models.CharField(db_index=True,
max_length=100,
verbose_name='ürün adı')),
('slug',
models.SlugField(max_length=100,
verbose_name='internet adresi')),
('description',
ckeditor.fields.RichTextField(
blank=True, verbose_name='Ürün açıklaması')),
('price',
models.DecimalField(decimal_places=2,
max_digits=10,
verbose_name='gerçek fiyat')),
('degisiklik',
models.IntegerField(default=0, verbose_name='degisiklik')),
('agırlık', models.FloatField(default=0,
verbose_name='Ağırlık')),
('ogrenci_sayisi',
models.CharField(choices=[('a', 0), ('b', 10), ('c', 15),
('d', 20), ('e', 25), ('f', 30),
('g', 35), ('h', 40), ('i', 45)],
max_length=1)),
('anasayfada_gosterilsin_mi',
models.BooleanField(
default=False,
help_text=
'Anasayfada gösterilmesi istenen ürünler için işaretlenecektir.',
verbose_name='AnaSayfada gösterilsin mi?')),
('aktif',
models.BooleanField(
default=False,
help_text=
'Sitede görünmesini istiyorsanız işaretleyiniz!!!',
verbose_name='Aktif mi?')),
('sıralama_sayısı',
models.PositiveIntegerField(
default=0, verbose_name='Anasayfa Sıralama Sayısı')),
('category',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='shop.Category',
verbose_name='kategori')),
],
options={
'verbose_name': 'Ürün',
'verbose_name_plural': 'Ürünler',
'ordering': ('sıralama_sayısı', ),
},
),
migrations.CreateModel(
name='Resim',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('isim',
models.CharField(max_length=100, verbose_name='resim adı')),
('sıralama_sayısı',
models.PositiveIntegerField(default=0,
verbose_name='Sıralama Sayısı')),
],
options={
'verbose_name': 'Resim-Grubu',
'verbose_name_plural': 'Resim-Grupları',
'ordering': ('sıralama_sayısı', 'isim'),
},
),
migrations.CreateModel(
name='TekliResim',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('isim',
models.CharField(max_length=100, verbose_name='resim adı')),
('image1', models.ImageField(upload_to='',
verbose_name='resim')),
],
options={
'verbose_name': 'Resim',
'verbose_name_plural': 'Resimler',
'ordering': ('isim', ),
},
),
migrations.AddField(
model_name='resim',
name='resimler',
field=models.ManyToManyField(blank=True,
to='shop.TekliResim',
verbose_name='resimler'),
),
migrations.AddField(
model_name='category',
name='nasıl_uygulanır_resimleri',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='nasil',
to='shop.Resim',
verbose_name='Nasıl Uygulanır Resimleri'),
),
migrations.AddField(
model_name='category',
name='odul_buttonu_resimleri',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='odul',
to='shop.Resim',
verbose_name='Kişiye özel Ödül Butonu Resimleri'),
),
migrations.AlterIndexTogether(
name='product',
index_together={('id', 'slug')},
),
]
class Migration(migrations.Migration):
initial = True
dependencies = []
operations = [
migrations.CreateModel(
name='Bot',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('name', models.CharField(max_length=40, unique=True)),
('token', models.CharField(max_length=50, unique=True)),
('token_slug', models.SlugField(unique=True)),
('root_handlerconf',
models.CharField(default='', max_length=100)),
('_me', models.JSONField(blank=True, null=True)),
('_webhook_info', models.JSONField(blank=True, null=True)),
('update_successful', models.BooleanField(default=True)),
('me_update_datetime',
models.DateTimeField(blank=True, null=True)),
('webhook_update_datetime',
models.DateTimeField(blank=True, null=True)),
],
),
migrations.CreateModel(
name='CallbackQuery',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('callback_query_id', models.CharField(max_length=100)),
('chat_instance', models.CharField(max_length=100)),
('inline_message_id',
models.CharField(blank=True, max_length=100)),
('data', models.CharField(blank=True, max_length=100)),
('game_short_name', models.CharField(blank=True,
max_length=100)),
('bot',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='django_chatbot.bot')),
],
options={
'ordering': ['callback_query_id'],
},
),
migrations.CreateModel(
name='Chat',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('chat_id', models.BigIntegerField()),
('type', models.CharField(max_length=255)),
('title', models.CharField(blank=True, max_length=255)),
('username', models.CharField(blank=True, max_length=255)),
('first_name', models.CharField(blank=True, max_length=255)),
('last_name', models.CharField(blank=True, max_length=255)),
('_photo', models.JSONField(blank=True, null=True)),
('bio', models.CharField(blank=True, max_length=255)),
('description', models.TextField(blank=True)),
('invite_link', models.CharField(blank=True, max_length=255)),
('_permissions', models.JSONField(blank=True, null=True)),
('slow_mode_delay', models.IntegerField(blank=True,
null=True)),
('sticker_set_name',
models.CharField(blank=True, max_length=255)),
('can_set_sticker_set', models.BooleanField(default=False)),
('linked_chat_id', models.BigIntegerField(blank=True,
null=True)),
('_location', models.JSONField(blank=True, null=True)),
('bot',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='django_chatbot.bot')),
],
),
migrations.CreateModel(
name='Form',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('_form', models.TextField()),
],
),
migrations.CreateModel(
name='Message',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('direction',
models.CharField(choices=[('in', 'in'), ('out', 'out')],
default='in',
max_length=3)),
('message_id', models.BigIntegerField()),
('date', models.DateTimeField()),
('forward_from_message_id',
models.BigIntegerField(blank=True, null=True)),
('forward_signature',
models.CharField(blank=True, max_length=255)),
('forward_sender_name',
models.CharField(blank=True, max_length=255)),
('forward_date', models.DateTimeField(blank=True, null=True)),
('edit_date', models.DateTimeField(blank=True, null=True)),
('media_group_id', models.CharField(blank=True,
max_length=255)),
('author_signature',
models.CharField(blank=True, max_length=255)),
('text', models.TextField(blank=True)),
('_entities', models.JSONField(blank=True, null=True)),
('_animation', models.JSONField(blank=True, null=True)),
('_audio', models.JSONField(blank=True, null=True)),
('_document', models.JSONField(blank=True, null=True)),
('_photo', models.JSONField(blank=True, null=True)),
('_sticker', models.JSONField(blank=True, null=True)),
('_video', models.JSONField(blank=True, null=True)),
('_video_note', models.JSONField(blank=True, null=True)),
('_voice', models.JSONField(blank=True, null=True)),
('caption', models.CharField(blank=True, max_length=1024)),
('_caption_entities', models.JSONField(blank=True, null=True)),
('_contact', models.JSONField(blank=True, null=True)),
('_dice', models.JSONField(blank=True, null=True)),
('_game', models.JSONField(blank=True, null=True)),
('_poll', models.JSONField(blank=True, null=True)),
('_venue', models.JSONField(blank=True, null=True)),
('_location', models.JSONField(blank=True, null=True)),
('new_chat_title', models.CharField(blank=True,
max_length=255)),
('_new_chat_photo', models.CharField(blank=True,
max_length=255)),
('delete_chat_photo', models.BooleanField(default=True)),
('group_chat_created', models.BooleanField(default=True)),
('supergroup_chat_created', models.BooleanField(default=True)),
('channel_chat_created', models.BooleanField(default=True)),
('migrate_to_chat_id',
models.BigIntegerField(blank=True, null=True)),
('migrate_from_chat_id',
models.BigIntegerField(blank=True, null=True)),
('_invoice', models.JSONField(blank=True, null=True)),
('_successful_payment', models.JSONField(blank=True,
null=True)),
('connected_website',
models.CharField(blank=True, max_length=255)),
('_passport_data', models.JSONField(blank=True, null=True)),
('_proximity_alert_triggered',
models.JSONField(blank=True, null=True)),
('_reply_markup', models.JSONField(blank=True, null=True)),
('extra', models.JSONField(default=dict)),
('chat',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
related_name='messages',
to='django_chatbot.chat')),
('form',
models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='django_chatbot.form')),
],
options={
'ordering': ['message_id', 'chat'],
},
),
migrations.CreateModel(
name='User',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('user_id', models.BigIntegerField(db_index=True,
unique=True)),
('is_bot', models.BooleanField(default=False)),
('first_name', models.CharField(blank=True, max_length=40)),
('last_name', models.CharField(blank=True, max_length=40)),
('username', models.CharField(blank=True, max_length=40)),
('language_code', models.CharField(blank=True, max_length=2)),
('can_join_groups', models.BooleanField(default=False)),
('can_read_all_group_messages',
models.BooleanField(default=False)),
('supports_inline_queries',
models.BooleanField(default=False)),
],
),
migrations.CreateModel(
name='Update',
fields=[
('id',
models.AutoField(auto_created=True,
primary_key=True,
serialize=False,
verbose_name='ID')),
('handler', models.CharField(blank=True, max_length=100)),
('update_id', models.BigIntegerField(db_index=True,
unique=True)),
('type',
models.CharField(choices=[
('message', 'Message'),
('edited_message', 'Edited message'),
('channel_post', 'Channel post'),
('edited_channel_post', 'Edited channel post')
],
default='message',
max_length=20)),
('bot',
models.ForeignKey(on_delete=django.db.models.deletion.CASCADE,
to='django_chatbot.bot')),
('callback_query',
models.OneToOneField(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='django_chatbot.callbackquery')),
('message',
models.ForeignKey(blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
related_name='updates',
to='django_chatbot.message')),
],
options={
'ordering': ['message_id'],
},
),
migrations.AddField(
model_name='message',
name='forward_from',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='forwarded_messages',
to='django_chatbot.user'),
),
migrations.AddField(
model_name='message',
name='forward_from_chat',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='forwarded_messages',
to='django_chatbot.chat'),
),
migrations.AddField(
model_name='message',
name='from_user',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='messages',
to='django_chatbot.user'),
),
migrations.AddField(
model_name='message',
name='left_chat_member',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='messages_left_chat',
to='django_chatbot.user'),
),
migrations.AddField(
model_name='message',
name='new_chat_members',
field=models.ManyToManyField(related_name='messages_new_chat',
to='django_chatbot.User'),
),
migrations.AddField(
model_name='message',
name='pinned_message',
field=models.OneToOneField(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='pinned_to',
to='django_chatbot.message'),
),
migrations.AddField(
model_name='message',
name='reply_to_message',
field=models.OneToOneField(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='reply_message',
to='django_chatbot.message'),
),
migrations.AddField(
model_name='message',
name='sender_chat',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
to='django_chatbot.chat'),
),
migrations.AddField(
model_name='message',
name='via_bot',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='bot_messages',
to='django_chatbot.user'),
),
migrations.AddField(
model_name='chat',
name='pinned_message',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.SET_NULL,
related_name='pinned_to_chats',
to='django_chatbot.message'),
),
migrations.AddField(
model_name='callbackquery',
name='from_user',
field=models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
to='django_chatbot.user'),
),
migrations.AddField(
model_name='callbackquery',
name='message',
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.CASCADE,
to='django_chatbot.message'),
),
migrations.AlterUniqueTogether(
name='message',
unique_together={('message_id', 'chat')},
),
migrations.AlterIndexTogether(
name='message',
index_together={('message_id', 'chat')},
),
migrations.AddIndex(
model_name='chat',
index=models.Index(fields=['bot', 'chat_id'],
name='django_chat_bot_id_f78e25_idx'),
),
migrations.AlterUniqueTogether(
name='chat',
unique_together={('bot', 'chat_id')},
),
]
class Migration(migrations.Migration):
dependencies = [
('model', '0001_initial'),
]
operations = [
migrations.CreateModel(
name='PerformanceDatum',
fields=[
('id',
models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)),
('job_id', models.PositiveIntegerField(db_index=True)),
('result_set_id', models.PositiveIntegerField(db_index=True)),
('value', models.FloatField()),
('push_timestamp', models.DateTimeField(db_index=True)),
('repository', models.ForeignKey(to='model.Repository')),
],
options={
'db_table': 'performance_datum',
},
),
migrations.CreateModel(
name='PerformanceFramework',
fields=[
('id',
models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)),
('name', models.SlugField(unique=True, max_length=255)),
],
options={
'db_table': 'performance_framework',
},
),
migrations.CreateModel(
name='PerformanceSignature',
fields=[
('id',
models.AutoField(verbose_name='ID',
serialize=False,
auto_created=True,
primary_key=True)),
('signature_hash',
models.CharField(
db_index=True,
unique=True,
max_length=40,
validators=[
django.core.validators.MinLengthValidator(40)
])),
('suite', models.CharField(max_length=80)),
('test', models.CharField(max_length=80, blank=True)),
('extra_properties',
jsonfield.fields.JSONField(max_length=1024)),
('framework',
models.ForeignKey(to='perf.PerformanceFramework')),
('option_collection',
models.ForeignKey(to='model.OptionCollection')),
('platform', models.ForeignKey(to='model.MachinePlatform')),
],
options={
'db_table': 'performance_signature',
},
),
migrations.AddField(
model_name='performancedatum',
name='signature',
field=models.ForeignKey(to='perf.PerformanceSignature'),
),
migrations.AlterUniqueTogether(
name='performancedatum',
unique_together=set([('repository', 'job_id', 'result_set_id',
'signature', 'push_timestamp')]),
),
migrations.AlterIndexTogether(
name='performancedatum',
index_together=set([('repository', 'result_set_id'),
('repository', 'signature', 'push_timestamp'),
('repository', 'job_id')]),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Answer',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('description', models.TextField(max_length=2000)),
('create_date', models.DateTimeField(auto_now_add=True)),
('update_date', models.DateTimeField(blank=True, null=True)),
('votes', models.IntegerField(default=0)),
('is_accepted', models.BooleanField(default=False)),
],
options={
'verbose_name': 'Answer',
'verbose_name_plural': 'Answers',
'ordering': ('-is_accepted', '-votes', 'create_date'),
},
),
migrations.CreateModel(
name='Question',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('title', models.CharField(max_length=255)),
('description', models.TextField(max_length=2000)),
('create_date', models.DateTimeField(auto_now_add=True)),
('update_date', models.DateTimeField(auto_now_add=True)),
('favorites', models.IntegerField(default=0)),
('has_accepted_answer', models.BooleanField(default=False)),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
options={
'verbose_name': 'Question',
'verbose_name_plural': 'Questions',
'ordering': ('-update_date',),
},
),
migrations.CreateModel(
name='Tag',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('tag', models.CharField(max_length=50)),
('question', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='lan_complain.Question')),
],
options={
'verbose_name': 'Tag',
'verbose_name_plural': 'Tags',
},
),
migrations.AddField(
model_name='answer',
name='question',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='lan_complain.Question'),
),
migrations.AddField(
model_name='answer',
name='user',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL),
),
migrations.AlterUniqueTogether(
name='tag',
unique_together=set([('tag', 'question')]),
),
migrations.AlterIndexTogether(
name='tag',
index_together=set([('tag', 'question')]),
),
]
class Migration(migrations.Migration):
initial = True
dependencies = [
('taggit', '0002_auto_20150616_2121'),
('contenttypes', '0002_remove_content_type_name'),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='AccountProfile',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('demozoo0_id', models.IntegerField(blank=True, null=True, verbose_name=b'Demozoo v0 ID')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL, unique=True)),
],
options={
'ordering': ['user__username'],
},
),
migrations.CreateModel(
name='CaptchaQuestion',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('question', models.TextField(help_text=b'HTML is allowed. Keep questions factual and simple - remember that our potential users are not always followers of mainstream demoparty culture')),
('answer', models.CharField(help_text=b'Answers are not case sensitive (the correct answer will be accepted regardless of capitalisation)', max_length=255)),
],
),
migrations.CreateModel(
name='Edit',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('action_type', models.CharField(max_length=100)),
('focus_object_id', models.PositiveIntegerField()),
('focus2_object_id', models.PositiveIntegerField(blank=True, null=True)),
('description', models.TextField()),
('timestamp', models.DateTimeField(auto_now_add=True)),
('admin_only', models.BooleanField(default=False)),
('focus2_content_type', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, related_name='edits_as_focus2', to='contenttypes.ContentType')),
('focus_content_type', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='edits', to='contenttypes.ContentType')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='edits', to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='Membership',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('is_current', models.BooleanField(default=True)),
('data_source', models.CharField(blank=True, max_length=32, null=True)),
],
),
migrations.CreateModel(
name='Nick',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=255)),
('abbreviation', models.CharField(blank=True, help_text=b"(optional - only if there's one that's actively being used. Don't just make one up!)", max_length=255)),
('differentiator', models.CharField(blank=True, help_text=b'hint text to distinguish from other groups/sceners with the same name - e.g. platform or country', max_length=32)),
],
options={
'ordering': ['name'],
},
),
migrations.CreateModel(
name='NickVariant',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=255)),
('nick', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='variants', to='demoscene.Nick')),
],
options={
'ordering': ['name'],
},
),
migrations.CreateModel(
name='Releaser',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('name', models.CharField(max_length=255)),
('is_group', models.BooleanField(db_index=True)),
('notes', models.TextField(blank=True)),
('demozoo0_id', models.IntegerField(blank=True, null=True, verbose_name=b'Demozoo v0 ID')),
('location', models.CharField(blank=True, max_length=255)),
('country_code', models.CharField(blank=True, max_length=5)),
('latitude', models.FloatField(blank=True, null=True)),
('longitude', models.FloatField(blank=True, null=True)),
('woe_id', models.BigIntegerField(blank=True, null=True)),
('geonames_id', models.BigIntegerField(blank=True, null=True)),
('first_name', models.CharField(blank=True, max_length=255)),
('show_first_name', models.BooleanField(default=True)),
('surname', models.CharField(blank=True, max_length=255)),
('show_surname', models.BooleanField(default=True)),
('real_name_note', models.TextField(blank=True, default=b'', help_text=b'Details of any correspondence / decision about whether this name should be public', verbose_name=b'Permission note')),
('data_source', models.CharField(blank=True, max_length=32, null=True)),
('created_at', models.DateTimeField(auto_now_add=True)),
('updated_at', models.DateTimeField()),
],
options={
'ordering': ['name'],
'permissions': (('view_releaser_real_names', 'Can view non-public real names'),),
},
bases=(models.Model, lib.prefetch_snooping.ModelWithPrefetchSnooping),
),
migrations.CreateModel(
name='ReleaserExternalLink',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('link_class', models.CharField(max_length=100)),
('parameter', models.CharField(max_length=255)),
('releaser', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='external_links', to='demoscene.Releaser')),
],
options={
'ordering': ['link_class'],
},
),
migrations.CreateModel(
name='SceneID',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('sceneid', models.IntegerField()),
('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
],
),
migrations.CreateModel(
name='TagDescription',
fields=[
('tag', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, primary_key=True, related_name='description', serialize=False, to='taggit.Tag')),
('description', models.TextField(help_text=b"HTML is allowed. Keep this to a couple of sentences at most - it's used in tooltips as well as the tag listing page")),
],
),
migrations.AddField(
model_name='nick',
name='releaser',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='nicks', to='demoscene.Releaser'),
),
migrations.AddField(
model_name='membership',
name='group',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='member_memberships', to='demoscene.Releaser'),
),
migrations.AddField(
model_name='membership',
name='member',
field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='group_memberships', to='demoscene.Releaser'),
),
migrations.AlterUniqueTogether(
name='releaserexternallink',
unique_together=set([('link_class', 'parameter', 'releaser')]),
),
migrations.AlterUniqueTogether(
name='nick',
unique_together=set([('releaser', 'name')]),
),
migrations.AlterIndexTogether(
name='edit',
index_together=set([('focus2_content_type', 'focus2_object_id'), ('focus_content_type', 'focus_object_id')]),
),
]
class Migration(migrations.Migration):
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
('contenttypes', '0002_remove_content_type_name'),
('projects', '0045_rolepermissionassignment_uuid'),
]
operations = [
migrations.CreateModel(
name='ModelPrivilege',
fields=[
('id',
models.UUIDField(default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False)),
('is_owner',
models.BooleanField(
db_index=True,
default=False,
verbose_name=
'Whether the user is owner of this entity (and can therefore edit, delete, ...) this entity'
)),
('can_view',
models.BooleanField(
default=False,
verbose_name='Whether the user can view this entity or not'
)),
('can_edit',
models.BooleanField(
default=False,
verbose_name='Whether the user can edit this entity or not'
)),
('can_delete',
models.BooleanField(
default=False,
verbose_name=
'Whether the user can delete this entity or not')),
('can_restore',
models.BooleanField(
default=False,
verbose_name=
'Whether the user can restore this entity or not')),
('object_id',
models.UUIDField(
verbose_name='Object id of the assigned entity')),
('content_type',
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='model_privileges',
to='contenttypes.ContentType',
verbose_name='Content type of the assigned entity')),
('user',
models.ForeignKey(
on_delete=django.db.models.deletion.CASCADE,
related_name='model_privileges',
to=settings.AUTH_USER_MODEL,
verbose_name='User for this entity permission assignment')
),
],
options={
'ordering': ['is_owner', 'user__username'],
},
bases=(models.Model,
django_changeset.models.mixins.RevisionModelMixin,
eric.core.admin.is_deleteable.IsDeleteableMixin),
),
migrations.AlterField(
model_name='rolepermissionassignment',
name='id',
field=models.UUIDField(default=uuid.uuid4,
editable=False,
primary_key=True,
serialize=False),
),
migrations.AlterIndexTogether(
name='modelprivilege',
index_together=set([('content_type', 'object_id')]),
),
]
