diff options
| -rw-r--r-- | sql/characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/7845_characters_mail.sql | 5 |
2 files changed, 6 insertions, 1 deletions
diff --git a/sql/characters.sql b/sql/characters.sql index a36764752e6..6ba3d402170 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -1682,7 +1682,7 @@ CREATE TABLE `mail` ( `sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier', `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier', `subject` longtext, - `itemTextId` int(11) unsigned NOT NULL default '0', + `body` longtext, `has_items` tinyint(3) unsigned NOT NULL default '0', `expire_time` bigint(40) NOT NULL default '0', `deliver_time` bigint(40) NOT NULL default '0', 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`; |