All pastes #564071 Raw Edit

Untitled

public text v1 · immutable
·published 2007-06-13 12:58 UTC
rendered paste body
/*
MySQL Data Transfer
Source Host: localhost
Source Database: jjj
Target Host: localhost
Target Database: jjj
Date: 13.6.2007 15:21:46
*/


DROP TABLE "playercreateinfo_skill";

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for playercreateinfo_skill
-- ----------------------------
CREATE TABLE `playercreateinfo_skill` (
  `race` tinyint(3) unsigned NOT NULL default '0',
  `class` tinyint(3) unsigned NOT NULL default '0',
  `Skill` mediumint(8) unsigned NOT NULL default '0',
  `Note` varchar(255) default NULL,
  PRIMARY KEY  (`race`,`class`,`Skill`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records 
-- ----------------------------
INSERT INTO `playercreateinfo_skill` VALUES ('1', '1', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '2', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '4', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '5', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '8', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '9', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '1', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '3', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '4', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '7', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '9', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('3', '1', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('3', '2', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('3', '3', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('3', '4', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('3', '5', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('4', '1', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('4', '3', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('4', '4', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('4', '5', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('4', '11', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('5', '1', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('5', '4', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('5', '5', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('5', '8', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('5', '9', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('6', '1', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('6', '3', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('6', '7', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('6', '11', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('7', '1', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('7', '4', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('7', '8', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('7', '9', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '1', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '3', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '4', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '5', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '7', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '8', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '8', '6', 'Frost');
INSERT INTO `playercreateinfo_skill` VALUES ('5', '8', '6', 'Frost');
INSERT INTO `playercreateinfo_skill` VALUES ('7', '8', '6', 'Frost');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '8', '6', 'Frost');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '8', '8', 'Fire');
INSERT INTO `playercreateinfo_skill` VALUES ('5', '8', '8', 'Fire');
INSERT INTO `playercreateinfo_skill` VALUES ('7', '8', '8', 'Fire');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '8', '8', 'Fire');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '1', '26', 'Arms');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '1', '26', 'Arms');
INSERT INTO `playercreateinfo_skill` VALUES ('3', '1', '26', 'Arms');
INSERT INTO `playercreateinfo_skill` VALUES ('4', '1', '26', 'Arms');
INSERT INTO `playercreateinfo_skill` VALUES ('5', '1', '26', 'Arms');
INSERT INTO `playercreateinfo_skill` VALUES ('6', '1', '26', 'Arms');
INSERT INTO `playercreateinfo_skill` VALUES ('7', '1', '26', 'Arms');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '1', '26', 'Arms');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '4', '38', 'Combat');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '4', '38', 'Combat');
INSERT INTO `playercreateinfo_skill` VALUES ('3', '4', '38', 'Combat');
INSERT INTO `playercreateinfo_skill` VALUES ('4', '4', '38', 'Combat');
INSERT INTO `playercreateinfo_skill` VALUES ('5', '4', '38', 'Combat');
INSERT INTO `playercreateinfo_skill` VALUES ('7', '4', '38', 'Combat');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '4', '38', 'Combat');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '3', '51', 'Survival');
INSERT INTO `playercreateinfo_skill` VALUES ('3', '3', '51', 'Survival');
INSERT INTO `playercreateinfo_skill` VALUES ('4', '3', '51', 'Survival');
INSERT INTO `playercreateinfo_skill` VALUES ('6', '3', '51', 'Survival');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '3', '51', 'Survival');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '5', '56', 'Holy');
INSERT INTO `playercreateinfo_skill` VALUES ('3', '5', '56', 'Holy');
INSERT INTO `playercreateinfo_skill` VALUES ('4', '5', '56', 'Holy');
INSERT INTO `playercreateinfo_skill` VALUES ('5', '5', '56', 'Holy');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '5', '56', 'Holy');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '2', '594', 'Holy');
INSERT INTO `playercreateinfo_skill` VALUES ('3', '2', '594', 'Holy');
INSERT INTO `playercreateinfo_skill` VALUES ('3', '1', '101', 'Dwarven Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('3', '2', '101', 'Dwarven Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('3', '3', '101', 'Dwarven Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('3', '4', '101', 'Dwarven Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('3', '5', '101', 'Dwarven Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('6', '1', '124', 'Tauren Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('6', '3', '124', 'Tauren Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('6', '7', '124', 'Tauren Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('6', '11', '124', 'Tauren Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '1', '125', 'Orc Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '3', '125', 'Orc Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '4', '125', 'Orc Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '7', '125', 'Orc Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '9', '125', 'Orc Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('4', '1', '126', 'Night Elf Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('4', '3', '126', 'Night Elf Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('4', '4', '126', 'Night Elf Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('4', '5', '126', 'Night Elf Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('4', '11', '126', 'Night Elf Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '3', '163', 'Marksmanship');
INSERT INTO `playercreateinfo_skill` VALUES ('3', '3', '163', 'Marksmanship');
INSERT INTO `playercreateinfo_skill` VALUES ('4', '3', '163', 'Marksmanship');
INSERT INTO `playercreateinfo_skill` VALUES ('6', '3', '163', 'Marksmanship');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '3', '163', 'Marksmanship');
INSERT INTO `playercreateinfo_skill` VALUES ('5', '1', '220', 'Racial - Undead');
INSERT INTO `playercreateinfo_skill` VALUES ('5', '4', '220', 'Racial - Undead');
INSERT INTO `playercreateinfo_skill` VALUES ('5', '5', '220', 'Racial - Undead');
INSERT INTO `playercreateinfo_skill` VALUES ('5', '8', '220', 'Racial - Undead');
INSERT INTO `playercreateinfo_skill` VALUES ('5', '9', '220', 'Racial - Undead');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '4', '253', 'Assassination');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '4', '253', 'Assassination');
INSERT INTO `playercreateinfo_skill` VALUES ('3', '4', '253', 'Assassination');
INSERT INTO `playercreateinfo_skill` VALUES ('4', '4', '253', 'Assassination');
INSERT INTO `playercreateinfo_skill` VALUES ('5', '4', '253', 'Assassination');
INSERT INTO `playercreateinfo_skill` VALUES ('7', '4', '253', 'Assassination');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '4', '253', 'Assassination');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '9', '354', 'Demonology');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '9', '354', 'Demonology');
INSERT INTO `playercreateinfo_skill` VALUES ('5', '9', '354', 'Demonology');
INSERT INTO `playercreateinfo_skill` VALUES ('7', '9', '354', 'Demonology');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '7', '374', 'Restoration');
INSERT INTO `playercreateinfo_skill` VALUES ('6', '7', '374', 'Restoration');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '7', '374', 'Restoration');
INSERT INTO `playercreateinfo_skill` VALUES ('4', '11', '573', 'Restoration');
INSERT INTO `playercreateinfo_skill` VALUES ('6', '11', '573', 'Restoration');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '7', '375', 'Elemental Combat');
INSERT INTO `playercreateinfo_skill` VALUES ('6', '7', '375', 'Elemental Combat');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '7', '375', 'Elemental Combat');
INSERT INTO `playercreateinfo_skill` VALUES ('4', '11', '574', 'Balance');
INSERT INTO `playercreateinfo_skill` VALUES ('6', '11', '574', 'Balance');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '9', '593', 'Destruction');
INSERT INTO `playercreateinfo_skill` VALUES ('2', '9', '593', 'Destruction');
INSERT INTO `playercreateinfo_skill` VALUES ('5', '9', '593', 'Destruction');
INSERT INTO `playercreateinfo_skill` VALUES ('7', '9', '593', 'Destruction');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '1', '733', 'Racial - Troll');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '3', '733', 'Racial - Troll');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '4', '733', 'Racial - Troll');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '5', '733', 'Racial - Troll');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '7', '733', 'Racial - Troll');
INSERT INTO `playercreateinfo_skill` VALUES ('8', '8', '733', 'Racial - Troll');
INSERT INTO `playercreateinfo_skill` VALUES ('7', '1', '753', 'Racial - Gnome');
INSERT INTO `playercreateinfo_skill` VALUES ('7', '4', '753', 'Racial - Gnome');
INSERT INTO `playercreateinfo_skill` VALUES ('7', '8', '753', 'Racial - Gnome');
INSERT INTO `playercreateinfo_skill` VALUES ('7', '9', '753', 'Racial - Gnome');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '1', '754', 'Racial - Human');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '2', '754', 'Racial - Human');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '4', '754', 'Racial - Human');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '5', '754', 'Racial - Human');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '8', '754', 'Racial - Human');
INSERT INTO `playercreateinfo_skill` VALUES ('1', '9', '754', 'Racial - Human');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '2', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '2', '594', 'Holy (Paladin)');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '2', '756', 'Blood Elf Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '3', '51', 'Survival');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '3', '163', 'Marksmanship');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '3', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '3', '756', 'Blood Elf Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '4', '38', 'Combat');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '4', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '4', '253', 'Assassination');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '4', '756', 'Blood Elf Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '5', '56', 'Holy (Priest)');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '5', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '5', '756', 'Blood Elf Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '8', '6', 'Frost');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '8', '8', 'Fire');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '8', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '8', '756', 'Blood Elf Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '9', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '9', '354', 'Demonology');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '9', '593', 'Destruction');
INSERT INTO `playercreateinfo_skill` VALUES ('10', '9', '756', 'Blood Elf Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '1', '26', 'Arms');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '1', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '1', '760', 'Draenei Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '2', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '2', '594', 'Holy (Paladin)');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '2', '760', 'Draenei Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '3', '51', 'Survival');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '3', '163', 'Marksmanship');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '3', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '3', '760', 'Draenei Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '5', '56', 'Holy (Priest)');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '5', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '5', '760', 'Draenei Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '7', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '7', '374', 'Restoration (Shaman)');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '7', '375', 'Elemental Combat');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '7', '760', 'Draenei Racial');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '8', '6', 'Frost');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '8', '8', 'Fire');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '8', '183', 'GENERIC (DND)');
INSERT INTO `playercreateinfo_skill` VALUES ('11', '8', '760', 'Draenei Racial');