Difference SQL

Created Diff never expires
8 removals
207 lines
2 additions
201 lines
-- --------------------------------------------------------
-- --------------------------------------------------------
-- Host: 127.0.0.1
-- Host: 127.0.0.1
-- Server version: 5.5.9-log - MySQL Community Server (GPL)
-- Server version: 5.5.9-log - MySQL Community Server (GPL)
-- Server OS: Win32
-- Server OS: Win32
-- HeidiSQL Version: 9.4.0.5125
-- HeidiSQL Version: 9.4.0.5125
-- --------------------------------------------------------
-- --------------------------------------------------------


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;




-- Dumping database structure for mop_world
-- Dumping database structure for mop_world
CREATE DATABASE IF NOT EXISTS `mop_world` /*!40100 DEFAULT CHARACTER SET latin1 */;
CREATE DATABASE IF NOT EXISTS `mop_world` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `mop_world`;
USE `mop_world`;


-- Dumping structure for table mop_world.battle_pay_entry
-- Dumping structure for table mop_world.battle_pay_entry
CREATE TABLE IF NOT EXISTS `battle_pay_entry` (
CREATE TABLE IF NOT EXISTS `battle_pay_entry` (
`id` int(10) unsigned NOT NULL DEFAULT '0',
`id` int(10) unsigned NOT NULL DEFAULT '0',
`productId` int(10) unsigned NOT NULL DEFAULT '0',
`productId` int(10) unsigned NOT NULL DEFAULT '0',
`groupId` int(10) unsigned NOT NULL DEFAULT '0',
`groupId` int(10) unsigned NOT NULL DEFAULT '0',
`idx` int(10) NOT NULL DEFAULT '0',
`idx` int(10) NOT NULL DEFAULT '0',
`title` varchar(50) NOT NULL,
`title` varchar(50) NOT NULL,
`description` varchar(500) NOT NULL,
`description` varchar(500) NOT NULL,
`icon` int(10) unsigned NOT NULL DEFAULT '0',
`icon` int(10) unsigned NOT NULL DEFAULT '0',
`displayId` int(10) unsigned NOT NULL DEFAULT '0',
`displayId` int(10) unsigned NOT NULL DEFAULT '0',
`banner` tinyint(3) unsigned NOT NULL DEFAULT '0',
`banner` tinyint(3) unsigned NOT NULL DEFAULT '0',
`flags` int(10) unsigned NOT NULL DEFAULT '0',
`flags` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- Dumping data for table mop_world.battle_pay_entry: 34 rows
-- Dumping data for table mop_world.battle_pay_entry: 34 rows
DELETE FROM `battle_pay_entry`;
DELETE FROM `battle_pay_entry`;
/*!40000 ALTER TABLE `battle_pay_entry` DISABLE KEYS */;
/*!40000 ALTER TABLE `battle_pay_entry` DISABLE KEYS */;
INSERT INTO `battle_pay_entry` (`id`, `productId`, `groupId`, `idx`, `title`, `description`, `icon`, `displayId`, `banner`, `flags`) VALUES
INSERT INTO `battle_pay_entry` (`id`, `productId`, `groupId`, `idx`, `title`, `description`, `icon`, `displayId`, `banner`, `flags`) VALUES
(44, 44, 2, 0, 'Experience Potion (300%)', 'Experience Potion', 0, 0, 2, 0),
(44, 44, 2, 0, 'Experience Potion (300%)', 'Experience Potion', 0, 0, 2, 0),
(1, 83, 1, 0, 'Level 90 Character Boost', 'There comes a time in every hero\'s quest when they need a little boost to help get them over the hump and back into the action. With a level 90 character boost, you can grant one character a one-time boost to level 90 instantly.', 614740, 0, 2, 0),
(1, 83, 1, 0, 'Level 90 Character Boost', 'There comes a time in every hero\'s quest when they need a little boost to help get them over the hump and back into the action. With a level 90 character boost, you can grant one character a one-time boost to level 90 instantly.', 614740, 0, 2, 0),
(3, 3, 2, 0, 'Experience Potion (100%)', 'Experience Potion', 0, 0, 2, 0),
(3, 3, 2, 0, 'Experience Potion (100%)', 'Experience Potion', 0, 0, 2, 0),
(4, 4, 4, 0, 'Foror\'s Crate of Storage', 'Bag 36 Slots', 0, 0, 0, 0),
(4, 4, 4, 0, 'Foror\'s Crate of Storage', 'Bag 36 Slots', 0, 0, 0, 0),
(5, 5, 3, 0, 'Mini Teleporter', 'Pet', 913566, 0, 2, 0),
(5, 5, 3, 0, 'Perky Pug', 'A Store Pet', 913566, 0, 2, 0),
(6, 6, 5, 0, 'Thunderfury, Blessed Blade of the Windseeker', 'Legendary Weapon', 135349, 0, 2, 0),
(6, 6, 5, 0, 'Thunderfury, Blessed Blade of the Windseeker', 'Legendary Weapon', 135349, 0, 2, 0),
(7, 7, 6, 0, '25,000 Gold', 'Gold', 133786, 0, 2, 0),
(8, 8, 6, 0, '100,000 Gold', 'Gold', 133784, 0, 2, 0),
(9, 9, 5, 0, 'Legendary Cloak : Qian-Le, Courage of Niuzao', 'Legendary Cloak', 0, 0, 2, 0),
(9, 9, 5, 0, 'Legendary Cloak : Qian-Le, Courage of Niuzao', 'Legendary Cloak', 0, 0, 2, 0),
(10, 10, 5, 0, 'Legendary Cloak : Xing-Ho, Breath of Yu\'lon', 'Legendary Cloak', 0, 0, 2, 0),
(10, 10, 5, 0, 'Legendary Cloak : Xing-Ho, Breath of Yu\'lon', 'Legendary Cloak', 0, 0, 2, 0),
(11, 11, 5, 0, 'Legendary Cloak : Jina-Kang, Kindness of Chi-Ji', 'Legendary Cloak', 0, 0, 2, 0),
(11, 11, 5, 0, 'Legendary Cloak : Jina-Kang, Kindness of Chi-Ji', 'Legendary Cloak', 0, 0, 2, 0),
(12, 12, 5, 0, 'Legendary Cloak : Fen-Yu, Fury of Xuen', 'Legendary Cloak', 0, 0, 2, 0),
(12, 12, 5, 0, 'Legendary Cloak : Fen-Yu, Fury of Xuen', 'Legendary Cloak', 0, 0, 2, 0),
(13, 13, 5, 0, 'Legendary Cloak : Gong-Lu, Strength of Xuen', 'Legendary Cloak', 0, 0, 2, 0),
(13, 13, 5, 0, 'Legendary Cloak : Gong-Lu, Strength of Xuen', 'Legendary Cloak', 0, 0, 2, 0),
(14, 14, 5, 0, 'Legendary Cloak : Qian-Ying, Fortitude of Niuzao', 'Legendary Cloak', 0, 0, 2, 0),
(14, 14, 5, 0, 'Legendary Cloak : Qian-Ying, Fortitude of Niuzao', 'Legendary Cloak', 0, 0, 2, 0),
(18, 18, 8, 0, 'Heart of the Aspects', 'A Store Mount', 576138, 0, 2, 0),
(18, 18, 8, 0, 'Heart of the Aspects', 'A Store Mount', 576138, 0, 2, 0),
(19, 19, 8, 0, 'Iron Skyreaver', 'A Store Mount', 943739, 0, 2, 0),
(19, 19, 8, 0, 'Iron Skyreaver', 'A Store Mount', 943739, 0, 2, 0),
(20, 20, 8, 0, 'Armored Bloodwing', 'A Store Mount', 804461, 0, 2, 0),
(20, 20, 8, 0, 'Armored Bloodwing', 'A Store Mount', 804461, 0, 2, 0),
(17, 17, 8, 0, 'Celestial Steed', 'A Store Mount', 369225, 0, 2, 0),
(17, 17, 8, 0, 'Celestial Steed', 'A Store Mount', 369225, 0, 2, 0),
(21, 21, 8, 0, 'Swift Windsteed', 'A Store Mount', 773250, 0, 2, 0),
(21, 21, 8, 0, 'Swift Windsteed', 'A Store Mount', 773250, 0, 2, 0),
(22, 22, 8, 0, 'Tyrael\'s Charger', 'A Store Mount', 577318, 0, 2, 0),
(22, 22, 8, 0, 'Tyrael\'s Charger', 'A Store Mount', 577318, 0, 2, 0),
(23, 23, 8, 0, 'Winged Guardian', 'A Store Mount', 526356, 0, 2, 0),
(23, 23, 8, 0, 'Winged Guardian', 'A Store Mount', 526356, 0, 2, 0),
(24, 24, 8, 0, 'Enchanted Fey Dragon', 'A Store Mount', 841541, 0, 2, 0),
(24, 24, 8, 0, 'Enchanted Fey Dragon', 'A Store Mount', 841541, 0, 2, 0),
(25, 25, 3, 0, 'Alterac Brew-Pup', 'A Store Pet', 930453, 0, 2, 0),
(25, 25, 3, 0, 'Alterac Brew-Pup', 'A Store Pet', 930453, 0, 2, 0),
(26, 26, 3, 0, 'Lil KT', 'A Store Pet', 134514, 0, 2, 0),
(26, 26, 3, 0, 'Lil KT', 'A Store Pet', 134514, 0, 2, 0),
(27, 27, 3, 0, 'Soul of the Aspects', 'A Store Pet', 574806, 0, 2, 0),
(27, 27, 3, 0, 'Soul of the Aspects', 'A Store Pet', 574806, 0, 2, 0),
(28, 28, 3, 0, 'Lil Ragnaros', 'A Store Pet', 254652, 0, 2, 0),
(28, 28, 3, 0, 'Lil Ragnaros', 'A Store Pet', 254652, 0, 2, 0),
(29, 29, 3, 0, 'Cinder Kitten', 'A Store Pet', 666530, 0, 2, 0),
(29, 29, 3, 0, 'Cinder Kitten', 'A Store Pet', 666530, 0, 2, 0),
(30, 30, 3, 0, 'Cenarion Hatchling', 'A Store Pet', 656241, 0, 2, 0),
(30, 30, 3, 0, 'Cenarion Hatchling', 'A Store Pet', 656241, 0, 2, 0),
(31, 31, 3, 0, 'Lil XT', 'A Store Pet', 254104, 0, 2, 0),
(31, 31, 3, 0, 'Lil XT', 'A Store Pet', 254104, 0, 2, 0),
(16, 16, 8, 0, 'Grinning Reaver', 'A Store Mount', 986420, 0, 2, 0),
(16, 16, 8, 0, 'Grinning Reaver', 'A Store Mount', 986420, 0, 2, 0),
(15, 15, 8, 0, 'Warforged Nightmare', 'A Store Mount', 986419, 0, 2, 0),
(15, 15, 8, 0, 'Warforged Nightmare', 'A Store Mount', 986419, 0, 2, 0),
(32, 32, 8, 0, 'Imperial Quilen', 'A Store Mount', 644374, 0, 2, 0),
(32, 32, 8, 0, 'Imperial Quilen', 'A Store Mount', 644374, 0, 2, 0),
(33, 33, 8, 0, 'Hearthsteed', 'A Store Mount', 853211, 0, 2, 0),
(33, 33, 8, 0, 'Hearthsteed', 'A Store Mount', 853211, 0, 2, 0),
(34, 34, 8, 0, 'Armored Dread Raven', 'A Store Mount', 952015, 0, 2, 0);
(34, 34, 8, 0, 'Armored Dread Raven', 'A Store Mount', 952015, 0, 2, 0);
/*!40000 ALTER TABLE `battle_pay_entry` ENABLE KEYS */;
/*!40000 ALTER TABLE `battle_pay_entry` ENABLE KEYS */;


-- Dumping structure for table mop_world.battle_pay_group
-- Dumping structure for table mop_world.battle_pay_group
CREATE TABLE IF NOT EXISTS `battle_pay_group` (
CREATE TABLE IF NOT EXISTS `battle_pay_group` (
`id` int(10) unsigned NOT NULL DEFAULT '0',
`id` int(10) unsigned NOT NULL DEFAULT '0',
`idx` int(10) unsigned NOT NULL DEFAULT '0',
`idx` int(10) unsigned NOT NULL DEFAULT '0',
`name` varchar(16) NOT NULL,
`name` varchar(16) NOT NULL,
`icon` int(10) unsigned NOT NULL DEFAULT '0',
`icon` int(10) unsigned NOT NULL DEFAULT '0',
`type` tinyint(3) unsigned NOT NULL DEFAULT '0',
`type` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`idx`,`name`)
UNIQUE KEY `id` (`idx`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- Dumping data for table mop_world.battle_pay_group: 7 rows
-- Dumping data for table mop_world.battle_pay_group: 7 rows
DELETE FROM `battle_pay_group`;
DELETE FROM `battle_pay_group`;
/*!40000 ALTER TABLE `battle_pay_group` DISABLE KEYS */;
/*!40000 ALTER TABLE `battle_pay_group` DISABLE KEYS */;
INSERT INTO `battle_pay_group` (`id`, `idx`, `name`, `icon`, `type`) VALUES
INSERT INTO `battle_pay_group` (`id`, `idx`, `name`, `icon`, `type`) VALUES
(1, 1, 'Featured', 939376, 1),
(1, 1, 'Featured', 939376, 1),
(2, 2, 'Consumables', 236883, 0),
(2, 2, 'Consumables', 236883, 0),
(3, 3, 'Pets', 939380, 0),
(3, 3, 'Pets', 939380, 0),
(4, 4, 'Bags', 940857, 0),
(4, 4, 'Bags', 940857, 0),
(5, 5, 'Legendaries', 940868, 0),
(5, 5, 'Legendaries', 940868, 0),
(6, 6, 'Currencies', 133785, 0),
(6, 6, 'Currencies', 133785, 0),
(8, 8, 'Mounts', 939379, 0);
(8, 8, 'Mounts', 939379, 0);
/*!40000 ALTER TABLE `battle_pay_group` ENABLE KEYS */;
/*!40000 ALTER TABLE `battle_pay_group` ENABLE KEYS */;


-- Dumping structure for table mop_world.battle_pay_product
-- Dumping structure for table mop_world.battle_pay_product
CREATE TABLE IF NOT EXISTS `battle_pay_product` (
CREATE TABLE IF NOT EXISTS `battle_pay_product` (
`id` int(10) unsigned NOT NULL DEFAULT '0',
`id` int(10) unsigned NOT NULL DEFAULT '0',
`title` varchar(50) NOT NULL,
`title` varchar(50) NOT NULL,
`description` varchar(500) NOT NULL,
`description` varchar(500) NOT NULL,
`icon` int(10) unsigned NOT NULL DEFAULT '0',
`icon` int(10) unsigned NOT NULL DEFAULT '0',
`price` int(10) unsigned NOT NULL DEFAULT '0',
`price` int(10) unsigned NOT NULL DEFAULT '0',
`discount` int(10) unsigned NOT NULL DEFAULT '0',
`discount` int(10) unsigned NOT NULL DEFAULT '0',
`displayId` int(10) unsigned NOT NULL DEFAULT '0',
`displayId` int(10) unsigned NOT NULL DEFAULT '0',
`type` tinyint(3) unsigned NOT NULL DEFAULT '0',
`type` tinyint(3) unsigned NOT NULL DEFAULT '0',
`choiceType` tinyint(3) unsigned NOT NULL DEFAULT '0',
`choiceType` tinyint(3) unsigned NOT NULL DEFAULT '0',
`flags` int(10) unsigned NOT NULL DEFAULT '0',
`flags` int(10) unsigned NOT NULL DEFAULT '0',
`flagsInfo` int(10) unsigned NOT NULL DEFAULT '0',
`flagsInfo` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- Dumping data for table mop_world.battle_pay_product: 34 rows
-- Dumping data for table mop_world.battle_pay_product: 34 rows
DELETE FROM `battle_pay_product`;
DELETE FROM `battle_pay_product`;
/*!40000 ALTER TABLE `battle_pay_product` DISABLE KEYS */;
/*!40000 ALTER TABLE `battle_pay_product` DISABLE KEYS */;
INSERT INTO `battle_pay_product` (`id`, `title`, `description`, `icon`, `price`, `discount`, `displayId`, `type`, `choiceType`, `flags`, `flagsInfo`) VALUES
INSERT INTO `battle_pay_product` (`id`, `title`, `description`, `icon`, `price`, `discount`, `displayId`, `type`, `choiceType`, `flags`, `flagsInfo`) VALUES
(44, 'Experience Potion (300%)', 'Experience Potion', 236884, 500, 0, 0, 0, 1, 47, 0),
(44, 'Experience Potion (300%)', 'Experience Potion', 236884, 500, 0, 0, 0, 1, 47, 0),
(83, 'Level 90 Character Boost', 'Boost your character to level 90!', 614740, 2000, 0, 0, 2, 1, 975, 0),
(83, 'Level 90 Character Boost', 'Boost your character to level 90!', 614740, 2000, 0, 0, 2, 1, 975, 0),
(3, 'Experience Potion (100%)', 'Experience Potion', 236883, 175, 0, 0, 0, 1, 47, 0),
(3, 'Experience Potion (100%)', 'Experience Potion', 236883, 175, 0, 0, 0, 1, 47, 0),
(4, 'Foror\'s Crate of Resist Storage', 'Bag', 133633, 500, 0, 0, 0, 1, 47, 0),
(4, 'Foror\'s Crate of Resist Storage', 'Bag', 133633, 500, 0, 0, 0, 1, 47, 0),
(5, 'Mini Teleporter', 'Teleporter', 913566, 5, 0, 38484, 0, 1, 47, 0),
(5, 'Perky Pug', 'A Store Pet', 913566, 5, 0, 38484, 0, 1, 47, 0),
(6, 'Thunderfury, Blessed Blade of the Windseeker', 'Legendary Weapon', 135349, 10000, 0, 0, 0, 1, 47, 0),
(6, 'Thunderfury, Blessed Blade of the Windseeker', 'Legendary Weapon', 135349, 10000, 0, 0, 0, 1, 47, 0),
(7, '25,000 Gold', 'Gold', 133786, 500, 0, 0, 0, 1, 47, 0),
(8, '100,000 Gold', 'Gold', 133784, 2000, 0, 0, 0, 1, 47, 0),
(9, 'Legendary Cloak : Qian-Le, Courage of Niuzao', 'Legendary Cloak', 852265, 10000, 0, 0, 0, 1, 47, 0),
(9, 'Legendary Cloak : Qian-Le, Courage of Niuzao', 'Legendary Cloak', 852265, 10000, 0, 0, 0, 1, 47, 0),
(10, 'Legendary Cloak : Xing-Ho, Breath of Yu\'lon', 'Legendary Cloak', 852263, 10000, 0, 0, 0, 1, 47, 0),
(10, 'Legendary Cloak : Xing-Ho, Breath of Yu\'lon', 'Legendary Cloak', 852263, 10000, 0, 0, 0, 1, 47, 0),
(11, 'Legendary Cloak : Jina-Kang, Kindness of Chi-Ji', 'Legendary Cloak', 874780, 10000, 0, 0, 0, 1, 47, 0),
(11, 'Legendary Cloak : Jina-Kang, Kindness of Chi-Ji', 'Legendary Cloak', 874780, 10000, 0, 0, 0, 1, 47, 0),
(12, 'Legendary Cloak : Fen-Yu, Fury of Xuen', 'Legendary Cloak', 852267, 10000, 0, 0, 0, 1, 47, 0),
(12, 'Legendary Cloak : Fen-Yu, Fury of Xuen', 'Legendary Cloak', 852267, 10000, 0, 0, 0, 1, 47, 0),
(13, 'Legendary Cloak : Gong-Lu, Strength of Xuen', 'Legendary Cloak', 852267, 10000, 0, 0, 0, 1, 47, 0),
(13, 'Legendary Cloak : Gong-Lu, Strength of Xuen', 'Legendary Cloak', 852267, 10000, 0, 0, 0, 1, 47, 0),
(14, 'Legendary Cloak : Qian-Ying, Fortitude of Niuzao', 'Legendary Cloak', 852265, 10000, 0, 0, 0, 1, 47, 0),
(14, 'Legendary Cloak : Qian-Ying, Fortitude of Niuzao', 'Legendary Cloak', 852265, 10000, 0, 0, 0, 1, 47, 0),
(17, 'Celestial Steed', 'A Store Mount', 369225, 25000, 0, 31958, 0, 1, 47, 0),
(17, 'Celestial Steed', 'A Store Mount', 369225, 25000, 0, 31958, 0, 1, 47, 0),
(18, 'Heart of the Aspects', 'A Store Mount', 576138, 25000, 0, 40029, 0, 1, 47, 0),
(18, 'Heart of the Aspects', 'A Store Mount', 576138, 25000, 0, 40029, 0, 1, 47, 0),
(19, 'Iron Skyreaver', 'A Store Mount', 943739, 25000, 0, 53038, 0, 1, 47, 0),
(19, 'Iron Skyreaver', 'A Store Mount', 943739, 25000, 0, 53038, 0, 1, 47, 0),
(25, 'Alterac Brew-Pup', 'A Store Pet', 930453, 1500, 0, 51988, 0, 1, 47, 0),
(25, 'Alterac Brew-Pup', 'A Store Pet', 930453, 1500, 0, 51988, 0, 1, 47, 0),
(20, 'Armored Bloodwing', 'A Store Mount', 804461, 25000, 0, 48020, 0, 1, 47, 0),
(20, 'Armored Bloodwing', 'A Store Mount', 804461, 25000, 0, 48020, 0, 1, 47, 0),
(23, 'Winged Guardian', 'A Store Mount', 526356, 25000, 0, 38260, 0, 1, 47, 0),
(23, 'Winged Guardian', 'A Store Mount', 526356, 25000, 0, 38260, 0, 1, 47, 0),
(22, 'Tyrael\'s Charger', 'A Store Mount', 577318, 25000, 0, 39530, 0, 1, 47, 0),
(22, 'Tyrael\'s Charger', 'A Store Mount', 577318, 25000, 0, 39530, 0, 1, 47, 0),
(21, 'Swift Windsteed', 'A Store Mount', 773250, 25000, 0, 46729, 0, 1, 47, 0),
(21, 'Swift Windsteed', 'A Store Mount', 773250, 25000, 0, 46729, 0, 1, 47, 0),
(24, 'Enchanted Fey Dragon', 'A Store Mount', 841541, 25000, 0, 48714, 0, 1, 47, 0),
(24, 'Enchanted Fey Dragon', 'A Store Mount', 841541, 25000, 0, 48714, 0, 1, 47, 0),
(26, 'Lil KT', 'A Store Pet', 134514, 1500, 0, 30507, 0, 1, 47, 0),
(26, 'Lil KT', 'A Store Pet', 134514, 1500, 0, 30507, 0, 1, 47, 0),
(27, 'Soul of the Aspects', 'A Store Pet', 574806, 1500, 0, 40019, 0, 1, 47, 0),
(27, 'Soul of the Aspects', 'A Store Pet', 574806, 1500, 0, 40019, 0, 1, 47, 0),
(28, 'Lil Ragnaros', 'A Store Pet', 254652, 1500, 0, 37541, 0, 1, 47, 0),
(28, 'Lil Ragnaros', 'A Store Pet', 254652, 1500, 0, 37541, 0, 1, 47, 0),
(29, 'Cinder Kitten', 'A Store Pet', 666530, 1500, 0, 46720, 0, 1, 47, 0),
(29, 'Cinder Kitten', 'A Store Pet', 666530, 1500, 0, 46720, 0, 1, 47, 0),
(30, 'Cenarion Hatchling', 'A Store Pet', 656241, 1500, 0, 16943, 0, 1, 47, 0),
(30, 'Cenarion Hatchling', 'A Store Pet', 656241, 1500, 0, 16943, 0, 1, 47, 0),
(31, 'Lil XT', 'A Store Pet', 254104, 1500, 0, 32031, 0, 1, 47, 0),
(31, 'Lil XT', 'A Store Pet', 254104, 1500, 0, 32031, 0, 1, 47, 0),
(16, 'Grinning Reaver', 'A Store Mount', 986420, 25000, 0, 55907, 0, 1, 47, 0),
(16, 'Grinning Reaver', 'A Store Mount', 986420, 25000, 0, 55907, 0, 1, 47, 0),
(15, 'Warforged Nightmare', 'A Store Mount', 986419, 25000, 0, 55896, 0, 1, 47, 0),
(15, 'Warforged Nightmare', 'A Store Mount', 986419, 25000, 0, 55896, 0, 1, 47, 0),
(32, 'Imperial Quilen', 'A Store Mount', 644374, 25000, 0, 43254, 0, 1, 47, 0),
(32, 'Imperial Quilen', 'A Store Mount', 644374, 25000, 0, 43254, 0, 1, 47, 0),
(33, 'Hearthsteed', 'A Store Mount', 853211, 25000, 0, 48931, 0, 1, 47, 0),
(33, 'Hearthsteed', 'A Store Mount', 853211, 25000, 0, 48931, 0, 1, 47, 0),
(34, 'Armored Dread Raven', 'A Store Mount', 952015, 25000, 0, 53774, 0, 1, 47, 0);
(34, 'Armored Dread Raven', 'A Store Mount', 952015, 25000, 0, 53774, 0, 1, 47, 0);
/*!40000 ALTER TABLE `battle_pay_product` ENABLE KEYS */;
/*!40000 ALTER TABLE `battle_pay_product` ENABLE KEYS */;


-- Dumping structure for table mop_world.battle_pay_product_items
-- Dumping structure for table mop_world.battle_pay_product_items
CREATE TABLE IF NOT EXISTS `battle_pay_product_items` (
CREATE TABLE IF NOT EXISTS `battle_pay_product_items` (
`id` int(10) unsigned NOT NULL DEFAULT '0',
`id` int(10) unsigned NOT NULL DEFAULT '0',
`itemId` int(10) unsigned NOT NULL DEFAULT '0',
`itemId` int(10) unsigned NOT NULL DEFAULT '0',
`count` int(10) unsigned NOT NULL DEFAULT '0',
`count` int(10) unsigned NOT NULL DEFAULT '0',
`productId` int(10) unsigned NOT NULL DEFAULT '0',
`productId` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
PRIMARY KEY (`id`),
UNIQUE KEY `productId` (`itemId`,`productId`)
UNIQUE KEY `productId` (`itemId`,`productId`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- Dumping data for table mop_world.battle_pay_product_items: 34 rows
-- Dumping data for table mop_world.battle_pay_product_items: 34 rows
DELETE FROM `battle_pay_product_items`;
DELETE FROM `battle_pay_product_items`;
/*!40000 ALTER TABLE `battle_pay_product_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `battle_pay_product_items` DISABLE KEYS */;
INSERT INTO `battle_pay_product_items` (`id`, `itemId`, `count`, `productId`) VALUES
INSERT INTO `battle_pay_product_items` (`id`, `itemId`, `count`, `productId`) VALUES
(83, 0, 0, 83),
(83, 0, 0, 83),
(44, 86574, 1, 44),
(44, 86574, 1, 44),
(3, 103557, 1, 3),
(3, 103557, 1, 3),
(4, 23162, 1, 4),
(4, 23162, 1, 4),
(5, 49912, 1, 5),
(5, 49912, 1, 5),
(6, 19019, 1, 6),
(6, 19019, 1, 6),
(7, 926019, 1, 7),
(8, 926020, 1, 8),
(9, 102245, 1, 9),
(9, 102245, 1, 9),
(10, 102246, 1, 10),
(10, 102246, 1, 10),
(11, 102247, 1, 11),
(11, 102247, 1, 11),
(12, 102248, 1, 12),
(12, 102248, 1, 12),
(13, 102249, 1, 13),
(13, 102249, 1, 13),
(14, 102250, 1, 14),
(14, 102250, 1, 14),
(17, 54811, 1, 17),
(17, 54811, 1, 17),
(22, 76755, 1, 22),
(22, 76755, 1, 22),
(21, 92724, 1, 21),
(21, 92724, 1, 21),
(20, 95341, 1, 20),
(20, 95341, 1, 20),
(19, 107951, 1, 19),
(19, 107951, 1, 19),
(18, 78924, 1, 18),
(18, 78924, 1, 18),
(23, 69846, 1, 23),
(23, 69846, 1, 23),
(24, 97989, 1, 24),
(24, 97989, 1, 24),
(25, 106240, 1, 25),
(25, 106240, 1, 25),
(26, 49693, 1, 26),
(26, 49693, 1, 26),
(27, 78916, 1, 27),
(27, 78916, 1, 27),
(28, 68385, 1, 28),
(28, 68385, 1, 28),
(29, 92707, 1, 29),
(29, 92707, 1, 29),
(30, 70099, 1, 30),
(30, 70099, 1, 30),
(31, 54847, 1, 31),
(31, 54847, 1, 31),
(16, 112327, 1, 16),
(16, 112327, 1, 16),
(15, 112326, 1, 15),
(15, 112326, 1, 15),
(32, 85870, 1, 32),
(32, 85870, 1, 32),
(33, 98618, 1, 33),
(33, 98618, 1, 33),
(34, 109013, 1, 34);
(34, 109013, 1, 34);
/*!40000 ALTER TABLE `battle_pay_product_items` ENABLE KEYS */;
/*!40000 ALTER TABLE `battle_pay_product_items` ENABLE KEYS */;


/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;