diff options
| author | n0n4m3 <none@none> | 2010-04-11 11:35:46 +0400 |
|---|---|---|
| committer | n0n4m3 <none@none> | 2010-04-11 11:35:46 +0400 |
| commit | c03240d79b58c3e30f45b6effdb7b438bd539349 (patch) | |
| tree | 36b47e9f8dc5ff5b61df61e45c37977f9529e116 | |
| parent | 0d48d3bd8c0569968a8775b471752782831e8b03 (diff) | |
Add sql for drop mail column 'itemtextid' and add new column 'body'.
--HG--
branch : trunk
| -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`; |