From d80a7f1ba4f23d343101903180e49a93b6f0416c Mon Sep 17 00:00:00 2001 From: Edward Date: Wed, 29 Apr 2015 12:05:58 +0800 Subject: [PATCH] sql/core_notify.sql --- sql/core_notify.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/sql/core_notify.sql b/sql/core_notify.sql index a25f6e1c..ea8ff408 100644 --- a/sql/core_notify.sql +++ b/sql/core_notify.sql @@ -33,4 +33,6 @@ ALTER TABLE core_notify add index lookup_d (person_id, msgid, ontable); -- used by email / tracker to handle alises - we have to be carefull adding to this table... -ALTER TABLE core_notify ENGINE=InnoDB; \ No newline at end of file +ALTER TABLE core_notify ENGINE=InnoDB; + +ALTER TABLE core_notify ADD COLUMN person_table VARCHAR(256) NOT NULL DEFAULT ''; \ No newline at end of file -- 2.39.2