Core/Pools: Implemented quest pooling

Core/DBLayer: Added GetNumRows() method to PreparedResultSet

--HG--
branch : trunk

2 files changed, 14 insertions, 0 deletions

diff --git a/sql/updates/9920_characters_pool_quest_save.sql b/sql/updates/9920_characters_pool_quest_save.sql
new file mode 100644
index 00000000000..ca1bfdafd16
--- /dev/null
+++ b/sql/updates/9920_characters_pool_quest_save.sql
@@ -0,0 +1,6 @@
+DROP TABLE IF EXISTS `pool_quest_save`;
+CREATE TABLE `pool_quest_save` (
+  `pool_id` int(10) unsigned NOT NULL DEFAULT '0',
+  `quest_id` int(10) unsigned NOT NULL DEFAULT '0',
+  PRIMARY KEY (`pool_id`,`quest_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/sql/updates/9920_world_pool_quest.sql b/sql/updates/9920_world_pool_quest.sql
new file mode 100644
index 00000000000..b8a326b38d3
--- /dev/null
+++ b/sql/updates/9920_world_pool_quest.sql
@@ -0,0 +1,8 @@
+DROP TABLE IF EXISTS `pool_quest`;
+CREATE TABLE `pool_quest` (
+  `entry` int(10) unsigned NOT NULL DEFAULT '0',
+  `pool_entry` mediumint(8) unsigned NOT NULL DEFAULT '0',
+  `description` varchar(255) DEFAULT NULL,
+  PRIMARY KEY (`entry`),
+  KEY `idx_guid` (`entry`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8;