From c03240d79b58c3e30f45b6effdb7b438bd539349 Mon Sep 17 00:00:00 2001 From: n0n4m3 Date: Sun, 11 Apr 2010 11:35:46 +0400 Subject: Add sql for drop mail column 'itemtextid' and add new column 'body'. --HG-- branch : trunk --- sql/characters.sql | 2 +- sql/updates/7845_characters_mail.sql | 5 +++++ 2 files changed, 6 insertions(+), 1 deletion(-) create mode 100644 sql/updates/7845_characters_mail.sql (limited to 'sql') 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`; -- cgit v1.2.3