araxiaonline/OneDB
3
0
Fork 0
mirror of https://github.com/araxiaonline/OneDB.git synced 2026-06-13 03:02:22 -04:00
Code Issues Packages Projects Releases Wiki Activity
Files
master
OneDB/fullDB/playercreateinfo_skills.sql
Zyres e8e78d2b63 Update to new version
2021-11-01 22:08:20 +01:00

36 lines
14 KiB
SQL
Raw Permalink Blame History

/*
SQLyog Professional v13.1.7 (64 bit)
MySQL - 8.0.21 : Database - asc_world_new
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
/*Table structure for table `playercreateinfo_skills` */
CREATE TABLE `playercreateinfo_skills` (
`build` smallint NOT NULL DEFAULT '15595',
`raceMask` int unsigned NOT NULL DEFAULT '0',
`classMask` int unsigned NOT NULL DEFAULT '0',
`skillid` smallint unsigned NOT NULL DEFAULT '0',
`level` smallint unsigned NOT NULL DEFAULT '0',
`note` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`build`,`raceMask`,`classMask`,`skillid`),
UNIQUE KEY `unique_index` (`build`,`raceMask`,`classMask`,`skillid`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Player System';
/*Data for the table `playercreateinfo_skills` */
insert into `playercreateinfo_skills`(`build`,`raceMask`,`classMask`,`skillid`,`level`,`note`) values (5875,0,0,95,0,'Misc: Defense'),(5875,0,0,162,0,'Weapon: Unarmed'),(5875,0,0,183,0,'Misc: GENERIC (DND)'),(5875,0,0,415,0,'Armor: Cloth'),(5875,0,1,26,0,'Warrior: Arms'),(5875,0,1,256,0,'Warrior: Fury'),(5875,0,1,257,0,'Warrior: Protection'),(5875,0,2,594,0,'Paladin: Holy'),(5875,0,2,267,0,'Paladin: Protection'),(5875,0,2,184,0,'Paladin: Retribution'),(5875,0,4,50,0,'Hunter: Beast Mastery'),(5875,0,4,163,0,'Hunter: Marksmanship'),(5875,0,4,51,0,'Hunter: Survival'),(5875,0,8,38,0,'Rogue: Combat'),(5875,0,8,253,0,'Rogue: Assassination'),(5875,0,8,39,0,'Rogue: Subtlety'),(5875,0,16,56,0,'Priest: Holy'),(5875,0,16,613,0,'Priest: Discipline'),(5875,0,16,78,0,'Priest: Shadow'),(5875,0,64,375,0,'Shaman: Elemental'),(5875,0,64,373,0,'Shaman: Enhancement'),(5875,0,64,374,0,'Shaman: Restoration'),(5875,0,128,237,0,'Mage: Arcane'),(5875,0,128,8,0,'Mage: Fire'),(5875,0,128,6,0,'Mage: Frost'),(5875,0,256,355,0,'Warlock: Affliction'),(5875,0,256,354,0,'Warlock: Demonology'),(5875,0,256,593,0,'Warlock: Destruction'),(5875,0,1024,574,0,'Druid: Balance'),(5875,0,1024,134,0,'Druid: Feral Combat'),(5875,0,1024,573,0,'Druid: Restoration'),(5875,6,1,172,0,'Weapon: Two-Handed Axes (Warrior)'),(5875,128,1,176,0,'Weapon: Thrown (Warrior)'),(5875,91,1,43,0,'Weapon: Swords (Warrior)'),(5875,109,1,54,0,'Weapon: Maces (Warrior)'),(5875,0,3,413,0,'Armor: Mail'),(5875,0,1103,414,0,'Armor: Leather'),(5875,0,67,433,0,'Armor: Shield'),(5875,1,0,754,0,'Racial: Human'),(5875,77,0,98,0,'Language: Common'),(5875,4,0,101,0,'Racial: Dwarf'),(5875,4,0,111,0,'Language: Dwarven'),(5875,8,0,126,0,'Racial: Night Elf'),(5875,8,0,113,0,'Language: Darnassian'),(5875,64,0,753,0,'Racial: Gnome'),(5875,64,0,313,0,'Language: Gnomish'),(5875,2,0,125,0,'Racial: Orc'),(5875,178,0,109,0,'Language: Orcish'),(5875,16,0,220,0,'Racial: Undead'),(5875,16,0,673,0,'Language: Gutterspeak'),(5875,32,0,124,0,'Racial: Tauren'),(5875,32,0,115,0,'Language: Taurahe'),(5875,128,0,733,0,'Racial: Troll'),(5875,128,0,315,0,'Language: Troll'),(5875,216,1,173,0,'Weapon: Daggers (Warrior)'),(5875,167,1,44,0,'Weapon: Axes (Warrior)'),(5875,32,1,160,0,'Weapon: Two-Handed Maces (Warrior)'),(5875,16,1,55,0,'Weapon: Two-Handed Swords (Warrior)'),(5875,0,2,54,0,'Weapon: Maces (Paladin)'),(5875,0,2,160,0,'Weapon: Two-Handed Maces (Paladin)'),(5875,166,4,44,0,'Weapon: Axes (Hunter)'),(5875,138,4,45,0,'Weapon: Bows (Hunter)'),(5875,8,4,173,0,'Weapon: Daggers (Hunter)'),(5875,36,4,46,0,'Weapon: Guns (Hunter)'),(5875,0,8,173,0,'Weapon: Daggers (Rogue)'),(5875,0,8,176,0,'Weapon: Thrown (Rogue)'),(5875,0,16,54,0,'Weapon: Maces (Priest)'),(5875,0,16,228,0,'Weapon: Wands (Priest)'),(5875,0,64,54,0,'Weapon: Maces (Shaman)'),(5875,0,64,136,0,'Weapon: Staves (Shaman)'),(5875,0,128,136,0,'Weapon: Staves (Mage)'),(5875,0,128,228,0,'Weapon: Wands (Mage)'),(5875,0,256,173,0,'Weapon: Daggers (Warlock)'),(5875,0,256,228,0,'Weapon: Wands (Warlock)'),(5875,8,1024,173,0,'Weapon: Daggers (Druid)'),(5875,32,1024,54,0,'Weapon: Maces (Druid)'),(5875,0,1024,136,0,'Weapon: Staves (Druid)'),(8606,0,0,95,0,'Misc: Defense'),(8606,0,0,162,0,'Weapon: Unarmed'),(8606,0,0,183,0,'Misc: GENERIC (DND)'),(8606,0,0,415,0,'Armor: Cloth'),(8606,0,1,26,0,'Warrior: Arms'),(8606,0,1,256,0,'Warrior: Fury'),(8606,0,1,257,0,'Warrior: Protection'),(8606,0,2,594,0,'Paladin: Holy'),(8606,0,2,267,0,'Paladin: Protection'),(8606,0,2,184,0,'Paladin: Retribution'),(8606,0,4,50,0,'Hunter: Beast Mastery'),(8606,0,4,163,0,'Hunter: Marksmanship'),(8606,0,4,51,0,'Hunter: Survival'),(8606,0,8,38,0,'Rogue: Combat'),(8606,0,8,253,0,'Rogue: Assassination'),(8606,0,8,39,0,'Rogue: Subtlety'),(8606,0,16,56,0,'Priest: Holy'),(8606,0,16,613,0,'Priest: Discipline'),(8606,0,16,78,0,'Priest: Shadow'),(8606,0,64,375,0,'Shaman: Elemental'),(8606,0,64,373,0,'Shaman: Enhancement'),(8606,0,64,374,0,'Shaman: Restoration'),(8606,0,128,237,0,'Mage: Arcane'),(8606,0,128,8,0,'Mage: Fire'),(8606,0,128,6,0,'Mage: Frost'),(8606,0,256,355,0,'Warlock: Affliction'),(8606,0,256,354,0,'Warlock: Demonology'),(8606,0,256,593,0,'Warlock: Destruction'),(8606,0,1024,574,0,'Druid: Balance'),(8606,0,1024,134,0,'Druid: Feral Combat'),(8606,0,1024,573,0,'Druid: Restoration'),(8606,32,1,160,0,'Weapon: Two-Handed Maces (Warrior)'),(8606,6,1,172,0,'Weapon: Two-Handed Axes (Warrior)'),(8606,128,1,176,0,'Weapon: Thrown (Warrior)'),(8606,1115,1,43,0,'Weapon: Swords (Warrior)'),(8606,0,3,413,0,'Armor: Mail'),(8606,0,1103,414,0,'Armor: Leather'),(8606,0,67,433,0,'Armor: Shield'),(8606,1,0,754,0,'Racial: Human'),(8606,1101,0,98,0,'Language: Common'),(8606,4,0,101,0,'Racial: Dwarf'),(8606,4,0,111,0,'Language: Dwarven'),(8606,8,0,126,0,'Racial: Night Elf'),(8606,8,0,113,0,'Language: Darnassian'),(8606,64,0,753,0,'Racial: Gnome'),(8606,64,0,313,0,'Language: Gnomish'),(8606,1024,0,760,0,'Racial: Draenei'),(8606,1024,0,759,0,'Language: Draenei'),(8606,2,0,125,0,'Racial: Orc'),(8606,690,0,109,0,'Language: Orcish'),(8606,16,0,220,0,'Racial: Undead'),(8606,16,0,673,0,'Language: Gutterspeak'),(8606,32,0,124,0,'Racial: Tauren'),(8606,32,0,115,0,'Language: Taurahe'),(8606,128,0,733,0,'Racial: Troll'),(8606,128,0,315,0,'Language: Troll'),(8606,512,0,756,0,'Racial: Blood Elf'),(8606,512,0,137,0,'Language: Thalassian'),(8606,1133,1,54,0,'Weapon: Maces (Warrior)'),(8606,216,1,173,0,'Weapon: Daggers (Warrior)'),(8606,167,1,44,0,'Weapon: Axes (Warrior)'),(8606,1040,1,55,0,'Weapon: Two-Handed Swords (Warrior)'),(8606,1029,2,54,0,'Weapon: Maces (Paladin)'),(8606,512,2,43,0,'Weapon: Swords (Paladin)'),(8606,1029,2,160,0,'Weapon: Two-Handed Maces (Paladin)'),(8606,512,2,55,0,'Weapon: Two-Handed Swords (Paladin)'),(8606,166,4,44,0,'Weapon: Axes (Hunter)'),(8606,650,4,45,0,'Weapon: Bows (Hunter)'),(8606,1024,4,226,0,'Weapon: Crossbows (Hunter)'),(8606,520,4,173,0,'Weapon: Daggers (Hunter)'),(8606,36,4,46,0,'Weapon: Guns (Hunter)'),(8606,1024,4,43,0,'Weapon: Swords (Hunter)'),(8606,0,8,173,0,'Weapon: Daggers (Rogue)'),(8606,0,8,176,0,'Weapon: Thrown (Rogue)'),(8606,0,16,54,0,'Weapon: Maces (Priest)'),(8606,0,16,228,0,'Weapon: Wands (Priest)'),(8606,0,64,54,0,'Weapon: Maces (Shaman)'),(8606,0,64,136,0,'Weapon: Staves (Shaman)'),(8606,0,128,136,0,'Weapon: Staves (Mage)'),(8606,0,128,228,0,'Weapon: Wands (Mage)'),(8606,0,256,173,0,'Weapon: Daggers (Warlock)'),(8606,0,256,228,0,'Weapon: Wands (Warlock)'),(8606,8,1024,173,0,'Weapon: Daggers (Druid)'),(8606,32,1024,54,0,'Weapon: Maces (Druid)'),(8606,0,1024,136,0,'Weapon: Staves (Druid)'),(12340,0,0,95,0,'Defense'),(12340,0,0,162,0,'Unarmed'),(12340,0,0,183,0,'GENERIC (DND)'),(12340,0,0,415,0,'Cloth'),(12340,0,0,777,0,'Mounts'),(12340,0,0,778,0,'Companion Pets'),(12340,0,1,26,0,'Warrior - Arms'),(12340,0,1,256,0,'Warrior - Fury'),(12340,0,1,257,0,'Warrior - Protection'),(12340,0,2,184,0,'Paladin - Retribution'),(12340,0,2,267,0,'Paladin - Protection'),(12340,0,2,594,0,'Paladin - Holy'),(12340,0,4,50,0,'Hunter - Beast Mastery'),(12340,0,4,51,0,'Hunter - Survival'),(12340,0,4,163,0,'Hunter - Marksmanship'),(12340,0,8,38,0,'Rogue - Combat'),(12340,0,8,39,0,'Rogue - Subtlety'),(12340,0,8,176,0,'Thrown'),(12340,0,8,253,0,'Rogue - Assassination'),(12340,0,16,56,0,'Priest - Holy'),(12340,0,16,78,0,'Priest - Shadow'),(12340,0,16,613,0,'Priest - Discipline'),(12340,0,32,129,4,'Death Knight - First Aid'),(12340,0,32,229,0,'Polearms'),(12340,0,32,293,0,'Plate'),(12340,0,32,762,0,'Death Knight - Riding'),(12340,0,32,770,0,'Death Knight - Blood'),(12340,0,32,771,0,'Death Knight - Frost'),(12340,0,32,772,0,'Death Knight - Unholy'),(12340,0,35,55,0,'Two-Handed Swords'),(12340,0,35,413,0,'Mail'),(12340,0,37,44,0,'Axes'),(12340,0,37,172,0,'Two-Handed Axes'),(12340,0,39,43,0,'Swords'),(12340,0,40,118,0,'Dual Wield'),(12340,0,64,373,0,'Shaman - Enhancement'),(12340,0,64,374,0,'Shaman - Restoration'),(12340,0,64,375,0,'Shaman - Elemental'),(12340,0,67,433,0,'Shield'),(12340,0,128,6,0,'Mage - Frost'),(12340,0,128,8,0,'Mage - Fire'),(12340,0,128,237,0,'Mage - Arcane'),(12340,0,256,354,0,'Warlock - Demonology'),(12340,0,256,355,0,'Warlock - Affliction'),(12340,0,256,593,0,'Warlock - Destruction'),(12340,0,400,228,0,'Wands'),(12340,0,1024,134,0,'Druid - Feral'),(12340,0,1024,573,0,'Druid - Restoration'),(12340,0,1024,574,0,'Druid - Balance'),(12340,0,1107,54,0,'Maces'),(12340,0,1135,414,0,'Leather'),(12340,0,1488,136,0,'Staves'),(12340,1,0,754,0,'Human - Racial'),(12340,2,0,125,0,'Orc - Racial'),(12340,4,0,101,0,'Dwarf - Racial'),(12340,4,0,111,0,'Language: Dwarven'),(12340,8,0,113,0,'Language: Darnassian'),(12340,8,0,126,0,'Night Elf - Racial'),(12340,16,0,220,0,'Undead - Racial'),(12340,16,0,673,0,'Language: Forsaken'),(12340,32,0,115,0,'Language: Taurahe'),(12340,32,0,124,0,'Tauren - Racial'),(12340,36,4,46,0,'Guns'),(12340,64,0,313,0,'Language: Gnomish'),(12340,64,0,753,0,'Gnome - Racial'),(12340,128,0,315,0,'Language: Troll'),(12340,128,0,733,0,'Troll - Racial'),(12340,512,0,137,0,'Language: Thalassian'),(12340,512,0,756,0,'Blood Elf - Racial'),(12340,650,4,45,0,'Bows'),(12340,690,0,109,0,'Language: Orcish'),(12340,735,1293,173,0,'Daggers'),(12340,1024,0,759,0,'Language: Draenei'),(12340,1024,0,760,0,'Draenei - Racial'),(12340,1024,4,226,0,'Crossbows'),(12340,1061,3,160,0,'Two-Handed Maces'),(12340,1101,0,98,0,'Language: Common'),(15595,0,0,95,0,'Defense'),(15595,0,0,162,0,'Unarmed'),(15595,0,0,183,0,'GENERIC (DND)'),(15595,0,0,415,0,'Cloth'),(15595,0,0,777,0,'Mounts'),(15595,0,0,778,0,'Companion Pets'),(15595,0,1,26,0,'Warrior - Arms'),(15595,0,1,256,0,'Warrior - Fury'),(15595,0,1,257,0,'Warrior - Protection'),(15595,0,2,184,0,'Paladin - Retribution'),(15595,0,2,267,0,'Paladin - Protection'),(15595,0,2,594,0,'Paladin - Holy'),(15595,0,1123,160,0,'Two-Handed Maces'),(15595,0,13,45,0,'Bows'),(15595,0,13,46,0,'Guns'),(15595,0,4,50,0,'Hunter - Beast Mastery'),(15595,0,4,51,0,'Hunter - Survival'),(15595,0,4,163,0,'Hunter - Marksmanship'),(15595,0,13,226,0,'Crossbows'),(15595,0,8,38,0,'Rogue - Combat'),(15595,0,8,39,0,'Rogue - Subtlety'),(15595,0,9,176,0,'Thrown'),(15595,0,8,253,0,'Rogue - Assassination'),(15595,0,16,56,0,'Priest - Holy'),(15595,0,16,78,0,'Priest - Shadow'),(15595,0,16,613,0,'Priest - Discipline'),(15595,0,32,129,4,'Death Knight - First Aid'),(15595,0,1063,229,0,'Polearms'),(15595,0,32,293,0,'Plate'),(15595,0,32,762,0,'Death Knight - Riding'),(15595,0,32,770,0,'Death Knight - Blood'),(15595,0,32,771,0,'Death Knight - Frost'),(15595,0,32,772,0,'Death Knight - Unholy'),(15595,0,35,55,0,'Two-Handed Swords'),(15595,0,35,413,0,'Mail'),(15595,0,111,44,0,'Axes'),(15595,0,103,172,0,'Two-Handed Axes'),(15595,0,175,43,0,'Swords'),(15595,0,40,118,0,'Dual Wield'),(15595,0,64,373,0,'Shaman - Enhancement'),(15595,0,64,374,0,'Shaman - Restoration'),(15595,0,64,375,0,'Shaman - Elemental'),(15595,0,67,433,0,'Shield'),(15595,0,128,6,0,'Mage - Frost'),(15595,0,128,8,0,'Mage - Fire'),(15595,0,128,237,0,'Mage - Arcane'),(15595,0,256,354,0,'Warlock - Demonology'),(15595,0,256,355,0,'Warlock - Affliction'),(15595,0,256,593,0,'Warlock - Destruction'),(15595,0,400,228,0,'Wands'),(15595,0,1024,134,0,'Druid - Feral'),(15595,0,1024,573,0,'Druid - Restoration'),(15595,0,1024,574,0,'Druid - Balance'),(15595,0,1147,54,0,'Maces'),(15595,0,1135,414,0,'Leather'),(15595,0,1501,173,0,'Daggers'),(15595,0,1493,136,0,'Staves'),(15595,1,0,754,0,'Human - Racial'),(15595,2,0,125,0,'Orc - Racial'),(15595,4,0,101,0,'Dwarf - Racial'),(15595,4,0,111,0,'Language: Dwarven'),(15595,8,0,113,0,'Language: Darnassian'),(15595,8,0,126,0,'Night Elf - Racial'),(15595,16,0,220,0,'Undead - Racial'),(15595,16,0,673,0,'Language: Forsaken'),(15595,32,0,115,0,'Language: Taurahe'),(15595,32,0,124,0,'Tauren - Racial'),(15595,64,0,313,0,'Language: Gnomish'),(15595,64,0,753,0,'Gnome - Racial'),(15595,128,0,315,0,'Language: Troll'),(15595,128,0,733,0,'Troll - Racial'),(15595,256,0,790,0,'Racial - Goblin'),(15595,256,0,792,0,'Language: Goblin'),(15595,512,0,137,0,'Language: Thalassian'),(15595,512,0,756,0,'Blood Elf - Racial'),(15595,946,0,109,0,'Language: Orcish'),(15595,1024,0,759,0,'Language: Draenei'),(15595,1024,0,760,0,'Draenei - Racial'),(15595,2097152,0,789,0,'Racial - Worgen'),(15595,2097152,0,791,0,'Language: Worgen'),(15595,2098253,0,98,0,'Language: Common'),(15595,0,0,810,0,'All - Glyphs'),(15595,0,256,802,0,'Warlock - General'),(15595,0,64,801,0,'Shaman - General'),(15595,0,2,800,0,'Paladin - General'),(15595,0,128,799,0,'Mage - General'),(15595,0,1024,798,0,'Druid - General'),(15595,0,8,797,0,'Rogue - General'),(15595,0,32,796,0,'Death Knight - General'),(15595,0,4,795,0,'Hunter - General'),(15595,0,1,803,0,'Warrior - General'),(15595,0,16,804,0,'Priest - General'),(15595,0,1101,473,0,'Fist Weapons');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
Reference in New Issue View Git Blame Copy Permalink