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 = [("projects", "0011_auto_20190629_0943")] operations = [ migrations.AddField( model_name="project", name="_fts", field=models.TextField(blank=True, editable=False), ), migrations.RunSQL( search.fts("projects_project", ["title", "description", "_fts"])), ]
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 = [("contacts", "0006_auto_20190321_1445")] operations = [ migrations.AddField( model_name="person", name="_fts", field=models.TextField(blank=True, editable=False), ), migrations.RunSQL( search.fts( "contacts_person", ["given_name", "family_name", "address", "notes", "_fts"], )), ]
class Migration(migrations.Migration): dependencies = [("invoices", "0011_auto_20190404_1136")] operations = [ migrations.AddField( model_name="invoice", name="_fts", field=models.TextField(blank=True, editable=False), ), migrations.RunSQL( search.fts( "invoices_invoice", ["title", "description", "postal_address", "_fts"] ) ), ]
class Migration(migrations.Migration): dependencies = [ ("offers", "0009_offer_valid_until"), ] operations = [ migrations.AddField( model_name="offer", name="_fts", field=models.TextField(blank=True, editable=False), ), migrations.RunSQL( search.fts("offers_offer", ["title", "description", "postal_address", "_fts"])), migrations.RunPython(forwards), ]
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 = [ ("invoices", "0019_auto_20191002_1005"), ("credit_control", "0006_ledger_parser"), ] operations = [ migrations.AddField( model_name="creditentry", name="_fts", field=models.TextField(blank=True, editable=False), ), migrations.RunSQL( search.fts( "credit_control_creditentry", [ "reference_number", "total", "payment_notice", "notes", "_fts" ], )), ]
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']);" ), ]