Add sql for drop mail column 'itemtextid' and add new column 'body'.

--HG--
branch : trunk

1 files changed, 5 insertions, 0 deletions

diff --git a/sql/updates/7845_characters_mail.sql b/sql/updates/7845_characters_mail.sql
new file mode 100644
index 00000000000..124322380c5
--- /dev/null
+++ b/sql/updates/7845_characters_mail.sql
@@ -0,0 +1,5 @@
+ALTER TABLE `mail` ADD COLUMN `body` longtext CHARSET utf8 COLLATE utf8_general_ci NULL after `subject`;
+
+UPDATE `mail` LEFT JOIN `item_text` ON `mail`.`itemtextid` = `item_text`.`id` SET `mail`.`body`=`item_text`.`text`;
+DELETE item_text FROM mail, item_text WHERE mail.itemtextid = item_text.id;
+ALTER TABLE `mail` DROP COLUMN `itemtextid`;