class Migration(migrations.Migration):
dependencies = [("logbook", "0005_auto_20190312_1254")]
operations = [
migrations.RunSQL(search.drop_old_fts("logbook_loggedcost")),
migrations.RunSQL(search.drop_old_fts("logbook_loggedhours")),
migrations.RunSQL(search.create_structure("logbook_loggedcost")),
migrations.RunSQL(search.create_structure("logbook_loggedhours")),
migrations.RunSQL(search.fts("logbook_loggedcost", ["description"])),
migrations.RunSQL(search.fts("logbook_loggedhours", ["description"])),
]
class Migration(migrations.Migration):
dependencies = [("contacts", "0005_auto_20190321_1025")]
operations = [
migrations.RunSQL(search.drop_old_shit("contacts_organization")),
migrations.RunSQL(search.drop_old_shit("contacts_person")),
migrations.RunSQL(search.create_structure("contacts_organization")),
migrations.RunSQL(search.create_structure("contacts_person")),
migrations.RunSQL(search.fts("contacts_organization", ["name"])),
migrations.RunSQL(
search.fts("contacts_person",
["given_name", "family_name", "address", "notes"])),
]
class Migration(migrations.Migration):
dependencies = [("invoices", "0009_auto_20190321_0833")]
operations = [
migrations.RunSQL(search.drop_old_shit("invoices_invoice")),
migrations.RunSQL(search.drop_old_shit("invoices_recurringinvoice")),
migrations.RunSQL(search.create_structure("invoices_invoice")),
migrations.RunSQL(
search.create_structure("invoices_recurringinvoice")),
migrations.RunSQL(
search.fts("invoices_invoice",
["title", "description", "postal_address"])),
migrations.RunSQL(
search.fts("invoices_recurringinvoice",
["title", "description", "postal_address"])),
]
class Migration(migrations.Migration):
dependencies = [("awt", "0003_auto_20190312_1254")]
operations = [
migrations.RunSQL(search.create_structure("awt_absence")),
migrations.RunSQL(search.fts("awt_absence", ["description"])),
migrations.RunSQL("UPDATE awt_absence SET id=id"),
]
class Migration(migrations.Migration):
dependencies = [("projects", "0006_auto_20190312_1254")]
operations = [
migrations.RunSQL(search.drop_old_shit("projects_project")),
migrations.RunSQL(search.create_structure("projects_project")),
migrations.RunSQL(
search.fts("projects_project", ["title", "description"])),
]
class Migration(migrations.Migration):
dependencies = [("offers", "0003_auto_20190304_2247")]
operations = [
migrations.RunSQL(search.drop_old_fts("offers_offer")),
migrations.RunSQL(search.create_structure("offers_offer")),
migrations.RunSQL(
search.fts("offers_offer", ["title", "description", "postal_address"])
),
]
class Migration(migrations.Migration):
dependencies = [("credit_control", "0002_auto_20190308_1752")]
operations = [
migrations.RunSQL(search.drop_old_shit("credit_control_creditentry")),
migrations.RunSQL(
search.create_structure("credit_control_creditentry")),
migrations.RunSQL(
search.fts(
"credit_control_creditentry",
["reference_number", "total", "payment_notice", "notes"],
)),
]
class Migration(migrations.Migration):
dependencies = [
("projects", "0017_project_cost_center"),
]
operations = [
migrations.RunSQL(search.create_structure("projects_service")),
migrations.RunSQL(
search.fts("projects_service", ["title", "description"])),
migrations.RunSQL(
"SELECT audit_audit_table('projects_service', ARRAY['fts_document', 'position']);"
),
migrations.RunSQL("UPDATE projects_service SET id=id"),
]
class Migration(migrations.Migration):
dependencies = [
("deals", "0001_initial"),
]
operations = [
migrations.RunSQL(search.drop_old_shit("deals_deal")),
migrations.RunSQL(search.create_structure("deals_deal")),
migrations.RunSQL(
search.fts(
"deals_deal",
["title", "description", "closing_notice", "_fts"],
)),
migrations.RunSQL(
"SELECT audit_audit_table('deals_valuetype');"
"SELECT audit_audit_table('deals_value');"
"SELECT audit_audit_table('deals_deal', ARRAY['_fts', 'fts_document']);"
),
]
class Migration(migrations.Migration):
dependencies = [
("contacts", "0012_person_date_of_birth"),
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
("projects", "0018_auto_20200402_2212"),
]
operations = [
migrations.CreateModel(
name="Campaign",
fields=[
(
"id",
models.AutoField(
auto_created=True,
primary_key=True,
serialize=False,
verbose_name="ID",
),
),
("title", models.CharField(max_length=200, verbose_name="title")),
(
"description",
models.TextField(blank=True, verbose_name="description"),
),
("_fts", models.TextField(blank=True, editable=False)),
(
"customer",
models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to="contacts.organization",
verbose_name="customer",
),
),
(
"owned_by",
models.ForeignKey(
on_delete=django.db.models.deletion.PROTECT,
to=settings.AUTH_USER_MODEL,
verbose_name="responsible",
),
),
],
options={
"verbose_name": "campaign",
"verbose_name_plural": "campaigns",
"ordering": ["-id"],
},
),
migrations.AddField(
model_name="project",
name="campaign",
field=models.ForeignKey(
blank=True,
null=True,
on_delete=django.db.models.deletion.PROTECT,
related_name="projects",
to="projects.campaign",
verbose_name="campaign",
),
),
migrations.RunSQL(search.create_structure("projects_campaign")),
migrations.RunSQL(
search.fts("projects_campaign", ["title", "description", "_fts"])
),
migrations.RunSQL(
"SELECT audit_audit_table('projects_campaign', ARRAY['fts_document', '_fts']);"
),
]
