Drop not needed table 'item_text', add new column 'text' in table 'item_instance'. Original patch by Vladimir.

--HG--
branch : trunk

3 files changed, 3 insertions, 23 deletions

diff --git a/sql/characters.sql b/sql/characters.sql
index 1cee28f6ad5..4242d535997 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -1605,6 +1605,7 @@ CREATE TABLE `item_instance` (
   `guid` int(11) unsigned NOT NULL default '0',
   `owner_guid` int(11) unsigned NOT NULL default '0',
   `data` longtext,
+  `text` longtext,
   PRIMARY KEY  (`guid`),
   KEY `idx_owner_guid` (`owner_guid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System';
@@ -1643,29 +1644,6 @@ LOCK TABLES `item_refund_instance` WRITE;
 /*!40000 ALTER TABLE `item_refund_instance` DISABLE KEYS */;
 /*!40000 ALTER TABLE `item_refund_instance` ENABLE KEYS */;
 UNLOCK TABLES;
-                      
---
--- Table structure for table `item_text`
---
-
-DROP TABLE IF EXISTS `item_text`;
-/*!40101 SET @saved_cs_client     = @@character_set_client */;
-/*!40101 SET character_set_client = utf8 */;
-CREATE TABLE `item_text` (
-  `id` int(11) unsigned NOT NULL default '0',
-  `text` longtext,
-  PRIMARY KEY  (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
-/*!40101 SET character_set_client = @saved_cs_client */;
-
---
--- Dumping data for table `item_text`
---
-
-LOCK TABLES `item_text` WRITE;
-/*!40000 ALTER TABLE `item_text` DISABLE KEYS */;
-/*!40000 ALTER TABLE `item_text` ENABLE KEYS */;
-UNLOCK TABLES;
 
 --
 -- Table structure for table `mail`
diff --git a/sql/updates/7904_characters_item_instance.sql b/sql/updates/7904_characters_item_instance.sql
new file mode 100644
index 00000000000..95cd7bca248
--- /dev/null
+++ b/sql/updates/7904_characters_item_instance.sql
@@ -0,0 +1 @@
+ALTER TABLE `item_instance` ADD COLUMN `text` longtext AFTER `data`;
diff --git a/sql/updates/7904_characters_item_text.sql b/sql/updates/7904_characters_item_text.sql
new file mode 100644
index 00000000000..517a4a04026
--- /dev/null
+++ b/sql/updates/7904_characters_item_text.sql
@@ -0,0 +1 @@
+DROP TABLE IF EXISTS `item_text`;