Merges pull request #3

Off of Amazon!!!

1 files changed, 157 insertions, 0 deletions

diff --git a/carer/mtwerk/migrations/0001_initial.py b/carer/mtwerk/migrations/0001_initial.py
new file mode 100644
index 0000000..d5c856a
--- /dev/null
+++ b/carer/mtwerk/migrations/0001_initial.py
@@ -0,0 +1,157 @@
+# Generated by Django 5.2.7 on 2025-10-28 22:06
+
+import django.db.models.deletion
+from django.db import migrations, models
+
+
+class Migration(migrations.Migration):
+
+    initial = True
+
+    dependencies = [
+    ]
+
+    operations = [
+        migrations.CreateModel(
+            name='Hit',
+            fields=[
+                ('id', models.BigAutoField(primary_key=True, serialize=False)),
+                ('amt_hit_id', models.CharField(max_length=30, unique=True)),
+                ('amt_group_id', models.CharField(max_length=30)),
+                ('status', models.SmallIntegerField()),
+                ('review_status', models.SmallIntegerField()),
+                ('creation_time', models.DateTimeField()),
+                ('expiration', models.DateTimeField()),
+                ('created_at', models.DateTimeField(auto_now_add=True)),
+                ('modified_at', models.DateTimeField(auto_now=True)),
+                ('max_assignments', models.IntegerField(default=1)),
+                ('assignment_pending_count', models.IntegerField(default=0)),
+                ('assignment_available_count', models.IntegerField(default=0)),
+                ('assignment_completed_count', models.IntegerField(default=0)),
+            ],
+            options={
+                'db_table': 'mtwerk_hit',
+            },
+        ),
+        migrations.CreateModel(
+            name='Assignment',
+            fields=[
+                ('id', models.BigAutoField(primary_key=True, serialize=False)),
+                ('amt_assignment_id', models.CharField(max_length=30, unique=True)),
+                ('amt_worker_id', models.CharField(max_length=30)),
+                ('status', models.SmallIntegerField()),
+                ('auto_approval_time', models.DateTimeField(null=True)),
+                ('accept_time', models.DateTimeField(null=True)),
+                ('submit_time', models.DateTimeField(null=True)),
+                ('approval_time', models.DateTimeField(null=True)),
+                ('rejection_time', models.DateTimeField(null=True)),
+                ('requester_feedback', models.CharField(max_length=1024, null=True)),
+                ('created_at', models.DateTimeField(auto_now_add=True)),
+                ('modified_at', models.DateTimeField(auto_now=True)),
+                ('tsid', models.UUIDField(null=True)),
+                ('hit', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='mtwerk.hit')),
+            ],
+            options={
+                'db_table': 'mtwerk_assignment',
+            },
+        ),
+        migrations.CreateModel(
+            name='HitType',
+            fields=[
+                ('id', models.AutoField(primary_key=True, serialize=False)),
+                ('amt_hit_type_id', models.CharField(max_length=30, unique=True)),
+                ('title', models.CharField(max_length=200)),
+                ('description', models.CharField(max_length=2000)),
+                ('reward', models.DecimalField(decimal_places=2, max_digits=8)),
+                ('assignment_duration', models.PositiveIntegerField()),
+                ('auto_approval_delay', models.PositiveIntegerField()),
+                ('keywords', models.CharField(max_length=256)),
+                ('min_active', models.IntegerField(default=0)),
+            ],
+            options={
+                'db_table': 'mtwerk_hittype',
+                'indexes': [models.Index(fields=['amt_hit_type_id'], name='mtwerk_hitt_amt_hit_05dd10_idx'), models.Index(fields=['min_active'], name='mtwerk_hitt_min_act_e18222_idx')],
+            },
+        ),
+        migrations.AddField(
+            model_name='hit',
+            name='hit_type',
+            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='mtwerk.hittype'),
+        ),
+        migrations.CreateModel(
+            name='Question',
+            fields=[
+                ('id', models.AutoField(primary_key=True, serialize=False)),
+                ('url', models.URLField()),
+                ('height', models.IntegerField(default=1200)),
+            ],
+            options={
+                'db_table': 'mtwerk_question',
+                'unique_together': {('url', 'height')},
+            },
+        ),
+        migrations.AddField(
+            model_name='hit',
+            name='question',
+            field=models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='mtwerk.question'),
+        ),
+        migrations.CreateModel(
+            name='Bonus',
+            fields=[
+                ('id', models.BigAutoField(primary_key=True, serialize=False)),
+                ('payout_event_id', models.UUIDField(unique=True)),
+                ('amt_worker_id', models.CharField(max_length=30, null=True)),
+                ('amount', models.DecimalField(decimal_places=2, max_digits=10)),
+                ('grant_time', models.DateTimeField()),
+                ('reason', models.CharField(max_length=1024)),
+                ('assignment', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='mtwerk.assignment')),
+            ],
+            options={
+                'indexes': [models.Index(fields=['amt_worker_id'], name='mtwerk_bonu_amt_wor_77d514_idx'), models.Index(fields=['grant_time'], name='mtwerk_bonu_grant_t_d43c6c_idx')],
+            },
+        ),
+        migrations.AddIndex(
+            model_name='assignment',
+            index=models.Index(fields=['amt_worker_id'], name='mtwerk_assi_amt_wor_7dbe42_idx'),
+        ),
+        migrations.AddIndex(
+            model_name='assignment',
+            index=models.Index(fields=['status'], name='mtwerk_assi_status_4e01de_idx'),
+        ),
+        migrations.AddIndex(
+            model_name='assignment',
+            index=models.Index(fields=['submit_time'], name='mtwerk_assi_submit__429d3e_idx'),
+        ),
+        migrations.AddIndex(
+            model_name='assignment',
+            index=models.Index(fields=['created_at'], name='mtwerk_assi_created_9292fa_idx'),
+        ),
+        migrations.AddIndex(
+            model_name='assignment',
+            index=models.Index(fields=['modified_at'], name='mtwerk_assi_modifie_44f1d0_idx'),
+        ),
+        migrations.AddIndex(
+            model_name='assignment',
+            index=models.Index(fields=['tsid'], name='mtwerk_assi_tsid_bd796d_idx'),
+        ),
+        migrations.AddIndex(
+            model_name='hit',
+            index=models.Index(fields=['status'], name='mtwerk_hit_status_ae726f_idx'),
+        ),
+        migrations.AddIndex(
+            model_name='hit',
+            index=models.Index(fields=['review_status'], name='mtwerk_hit_review__a9f420_idx'),
+        ),
+        migrations.AddIndex(
+            model_name='hit',
+            index=models.Index(fields=['creation_time'], name='mtwerk_hit_creatio_48e0fd_idx'),
+        ),
+        migrations.AddIndex(
+            model_name='hit',
+            index=models.Index(fields=['created_at'], name='mtwerk_hit_created_f1614b_idx'),
+        ),
+        migrations.AddIndex(
+            model_name='hit',
+            index=models.Index(fields=['modified_at'], name='mtwerk_hit_modifie_45c2ed_idx'),
+        ),
+    ]