From 38417ef2f618e86522cbf46ac3e494a962b448ec Mon Sep 17 00:00:00 2001
From: Shauren <none@none>
Date: Sat, 12 Jun 2010 17:21:21 +0200
Subject: Added forgotten field to `item_set_names` since this data come from
 WDB

--HG--
branch : trunk
---
 sql/base/world_database.sql               | 1 +
 sql/updates/8589_world_item_set_names.sql | 1 +
 2 files changed, 2 insertions(+)
 create mode 100644 sql/updates/8589_world_item_set_names.sql

(limited to 'sql')

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';
-- 
cgit v1.2.3