fix: drop old notes column from lead and prospect
diff --git a/erpnext/patches/v14_0/migrate_existing_lead_notes_as_per_the_new_format.py b/erpnext/patches/v14_0/migrate_existing_lead_notes_as_per_the_new_format.py
index 6ba5a9f..032aecc 100644
--- a/erpnext/patches/v14_0/migrate_existing_lead_notes_as_per_the_new_format.py
+++ b/erpnext/patches/v14_0/migrate_existing_lead_notes_as_per_the_new_format.py
@@ -3,7 +3,7 @@
def execute():
- for doctype in ("Lead", "Prospect"):
+ for doctype in ("Lead", "Prospect", "Opportunity"):
if not frappe.db.has_column(doctype, "notes"):
continue
@@ -19,3 +19,5 @@
doc = frappe.get_doc(doctype, d.name)
doc.append("notes", {"note": d.notes, "added_by": d.modified_by, "added_on": d.modified})
doc.update_child_table("notes")
+
+ frappe.db.sql_ddl(f"alter table `tab{doctype}` drop column `notes`")