aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorShauren <none@none>2010-06-12 17:21:21 +0200
committerShauren <none@none>2010-06-12 17:21:21 +0200
commit38417ef2f618e86522cbf46ac3e494a962b448ec (patch)
treee06ce09cb2527eb8232d57c752cd93758c68d6c8
parent057ea32adf16064a787e36fe63c1fc0634072153 (diff)
Added forgotten field to `item_set_names` since this data come from WDB
--HG-- branch : trunk
-rw-r--r--sql/base/world_database.sql1
-rw-r--r--sql/updates/8589_world_item_set_names.sql1
2 files changed, 2 insertions, 0 deletions
diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql
index 9b577fd3179..3edddb8cd7a 100644
--- a/sql/base/world_database.sql
+++ b/sql/base/world_database.sql
@@ -2759,6 +2759,7 @@ CREATE TABLE `item_set_names` (
`entry` mediumint(8) unsigned NOT NULL,
`name` varchar(255) character set utf8 NOT NULL default '',
`InventoryType` tinyint(3) unsigned NOT NULL default '0',
+ `WDBVerified` smallint(5) signed NOT NULL DEFAULT '1',
PRIMARY KEY (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
diff --git a/sql/updates/8589_world_item_set_names.sql b/sql/updates/8589_world_item_set_names.sql
new file mode 100644
index 00000000000..2edcc160c65
--- /dev/null
+++ b/sql/updates/8589_world_item_set_names.sql
@@ -0,0 +1 @@
+ALTER TABLE `item_set_names` ADD COLUMN `WDBVerified` smallint(5) signed NOT NULL DEFAULT '1';