144 lines
7.8 KiB
Python
144 lines
7.8 KiB
Python
# Generated by Django 5.2.7 on 2026-04-11 01:16
|
|
|
|
import core.models
|
|
import django.db.models.deletion
|
|
import django.utils.timezone
|
|
import uuid
|
|
from django.db import migrations, models
|
|
|
|
|
|
class Migration(migrations.Migration):
|
|
|
|
initial = True
|
|
|
|
dependencies = [
|
|
]
|
|
|
|
operations = [
|
|
migrations.CreateModel(
|
|
name='Business',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('name', models.CharField(max_length=160)),
|
|
('slug', models.SlugField(unique=True)),
|
|
('industry', models.CharField(default='Home Services', max_length=120)),
|
|
('primary_city', models.CharField(max_length=120)),
|
|
('primary_state', models.CharField(max_length=2)),
|
|
('google_review_url', models.URLField(blank=True)),
|
|
('is_active', models.BooleanField(default=True)),
|
|
('created_at', models.DateTimeField(auto_now_add=True)),
|
|
],
|
|
options={
|
|
'verbose_name_plural': 'businesses',
|
|
'ordering': ['name'],
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='Customer',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('full_name', models.CharField(max_length=160)),
|
|
('email', models.EmailField(blank=True, max_length=254)),
|
|
('phone', models.CharField(blank=True, max_length=40)),
|
|
('city', models.CharField(max_length=120)),
|
|
('state', models.CharField(max_length=2)),
|
|
('created_at', models.DateTimeField(auto_now_add=True)),
|
|
('business', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='customers', to='core.business')),
|
|
],
|
|
options={
|
|
'ordering': ['full_name'],
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='Job',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('service_type', models.CharField(max_length=120)),
|
|
('description', models.TextField(blank=True)),
|
|
('technician_name', models.CharField(blank=True, max_length=120)),
|
|
('city', models.CharField(max_length=120)),
|
|
('state', models.CharField(max_length=2)),
|
|
('completed_at', models.DateField(default=django.utils.timezone.localdate)),
|
|
('project_value', models.DecimalField(blank=True, decimal_places=2, max_digits=10, null=True)),
|
|
('status', models.CharField(choices=[('completed', 'Completed'), ('review_requested', 'Review requested'), ('proof_ready', 'Proof ready')], default='completed', max_length=32)),
|
|
('is_verified', models.BooleanField(default=True)),
|
|
('created_at', models.DateTimeField(auto_now_add=True)),
|
|
('updated_at', models.DateTimeField(auto_now=True)),
|
|
('business', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='jobs', to='core.business')),
|
|
('customer', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='jobs', to='core.customer')),
|
|
],
|
|
options={
|
|
'ordering': ['-completed_at', '-created_at'],
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='JobMedia',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('media_type', models.CharField(choices=[('before', 'Before'), ('after', 'After')], max_length=16)),
|
|
('file', models.FileField(blank=True, upload_to=core.models.job_media_upload_path)),
|
|
('caption', models.CharField(blank=True, max_length=140)),
|
|
('display_order', models.PositiveSmallIntegerField(default=0)),
|
|
('job', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='media', to='core.job')),
|
|
],
|
|
options={
|
|
'verbose_name_plural': 'job media',
|
|
'ordering': ['display_order', 'id'],
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='ProofCard',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('customer_display_name', models.CharField(max_length=160)),
|
|
('is_anonymized', models.BooleanField(default=False)),
|
|
('testimonial_quote', models.TextField(blank=True)),
|
|
('rating', models.PositiveSmallIntegerField(blank=True, null=True)),
|
|
('status', models.CharField(choices=[('draft', 'Draft'), ('published', 'Published'), ('hidden', 'Hidden')], default='draft', max_length=16)),
|
|
('is_featured', models.BooleanField(default=False)),
|
|
('attached_widget_label', models.CharField(blank=True, max_length=120)),
|
|
('attached_pages', models.CharField(blank=True, max_length=200)),
|
|
('published_at', models.DateTimeField(blank=True, null=True)),
|
|
('created_at', models.DateTimeField(auto_now_add=True)),
|
|
('updated_at', models.DateTimeField(auto_now=True)),
|
|
('job', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='proof_card', to='core.job')),
|
|
],
|
|
options={
|
|
'ordering': ['-is_featured', '-updated_at'],
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='ReviewRequest',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('token', models.UUIDField(default=uuid.uuid4, editable=False, unique=True)),
|
|
('status', models.CharField(choices=[('sent', 'Sent'), ('viewed', 'Viewed'), ('responded', 'Responded')], default='sent', max_length=20)),
|
|
('channel', models.CharField(choices=[('email', 'Email'), ('sms', 'SMS'), ('manual', 'Manual share')], default='email', max_length=16)),
|
|
('sent_at', models.DateTimeField(default=django.utils.timezone.now)),
|
|
('last_opened_at', models.DateTimeField(blank=True, null=True)),
|
|
('reviewed_at', models.DateTimeField(blank=True, null=True)),
|
|
('delivery_note', models.CharField(blank=True, max_length=200)),
|
|
('job', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='review_request', to='core.job')),
|
|
],
|
|
options={
|
|
'ordering': ['-sent_at'],
|
|
},
|
|
),
|
|
migrations.CreateModel(
|
|
name='Feedback',
|
|
fields=[
|
|
('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
|
|
('experience', models.CharField(choices=[('great', 'Great'), ('good', 'Good'), ('okay', 'Okay'), ('bad', 'Bad')], max_length=12)),
|
|
('rating', models.PositiveSmallIntegerField(blank=True, null=True)),
|
|
('testimonial', models.TextField(blank=True)),
|
|
('follow_up_required', models.BooleanField(default=False)),
|
|
('is_public_approved', models.BooleanField(default=False)),
|
|
('created_at', models.DateTimeField(auto_now_add=True)),
|
|
('review_request', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, related_name='feedback', to='core.reviewrequest')),
|
|
],
|
|
options={
|
|
'ordering': ['-created_at'],
|
|
},
|
|
),
|
|
]
|