Code:
/* Warrior Gear */
insert into `playercreateinfo_item` (`race`, `class`, `itemid`, `amount`) 
values
/* Bag */
('1','1','51809','3'), /* Human */
('2','1','51809','3'), /* Orc */
('3','1','51809','3'), /* Dwarf */
('4','1','51809','3'), /* Night Elf */
('5','1','51809','3'), /* Undead */
('6','1','51809','3'), /* Tauren */
('7','1','51809','3'), /* Gnome */
('8','1','51809','3'), /* Troll */
('11','1','51809','3'), /* Draenei */
/* Ammo Pouch */
('1','1','44447','1'), /* Human */
('2','1','44447','1'), /* Orc */
('3','1','44447','1'), /* Dwarf */
('4','1','44447','1'), /* Night Elf */
('5','1','44447','1'), /* Undead */
('6','1','44447','1'), /* Tauren */
('7','1','44447','1'), /* Gnome */
('8','1','44447','1'), /* Troll */
('11','1','44447','1'), /* Draenei */
/* Head */
('1','1','51227','1'), /* Human */
('2','1','51227','1'), /* Orc */
('3','1','51227','1'), /* Dwarf */
('4','1','51227','1'), /* Night Elf */
('5','1','51227','1'), /* Undead */
('6','1','51227','1'), /* Tauren */
('7','1','51227','1'), /* Gnome */
('8','1','51227','1'), /* Troll */
('11','1','51227','1'), /* Draenei */
/* Neck */
('1','1','50728','1'), /* Human */
('2','1','50728','1'), /* Orc */
('3','1','50728','1'), /* Dwarf */
('4','1','50728','1'), /* Night Elf */
('5','1','50728','1'), /* Undead */
('6','1','50728','1'), /* Tauren */
('7','1','50728','1'), /* Gnome */
('8','1','50728','1'), /* Troll */
('11','1','50728','1'), /* Draenei */
/* Shoulder */
('1','1','51229','1'), /* Human */
('2','1','51229','1'), /* Orc */
('3','1','51229','1'), /* Dwarf */
('4','1','51229','1'), /* Night Elf */
('5','1','51229','1'), /* Undead */
('6','1','51229','1'), /* Tauren */
('7','1','51229','1'), /* Gnome */
('8','1','51229','1'), /* Troll */
('11','1','51229','1'), /* Draenei */
/* Back */
('1','1','47545','1'), /* Human */
('2','1','47546','1'), /* Orc */
('3','1','47545','1'), /* Dwarf */
('4','1','47545','1'), /* Night Elf */
('5','1','47546','1'), /* Undead */
('6','1','47546','1'), /* Tauren */
('7','1','47545','1'), /* Gnome */
('8','1','47546','1'), /* Troll */
('11','1','47545','1'), /* Draenei */
/* Chest */
('1','1','50965','1'), /* Human */
('2','1','50965','1'), /* Orc */
('3','1','50965','1'), /* Dwarf */
('4','1','50965','1'), /* Night Elf */
('5','1','50965','1'), /* Undead */
('6','1','50965','1'), /* Tauren */
('7','1','50965','1'), /* Gnome */
('8','1','50965','1'), /* Troll */
('11','1','50965','1'), /* Draenei */
/* Wrist */
('1','1','46967','1'), /* Human */
('2','1','47414','1'), /* Orc */
('3','1','46967','1'), /* Dwarf */
('4','1','46967','1'), /* Night Elf */
('5','1','47414','1'), /* Undead */
('6','1','47414','1'), /* Tauren */
('7','1','46967','1'), /* Gnome */
('8','1','47414','1'), /* Troll */
('11','1','46967','1'), /* Draenei */
/* Hands */
('1','1','50977','1'), /* Human */
('2','1','50977','1'), /* Orc */
('3','1','50977','1'), /* Dwarf */
('4','1','50977','1'), /* Night Elf */
('5','1','50977','1'), /* Undead */
('6','1','50977','1'), /* Tauren */
('7','1','50977','1'), /* Gnome */
('8','1','50977','1'), /* Troll */
('11','1','50977','1'), /* Draenei */
/* Waist */
('1','1','47002','1'), /* Human */
('2','1','47429','1'), /* Orc */
('3','1','47002','1'), /* Dwarf */
('4','1','47002','1'), /* Night Elf */
('5','1','47429','1'), /* Undead */
('6','1','47429','1'), /* Tauren */
('7','1','47002','1'), /* Gnome */
('8','1','47429','1'), /* Troll */
('11','1','47002','1'), /* Draenei */
/* Legs */
('1','1','49903','1'), /* Human */
('2','1','49903','1'), /* Orc */
('3','1','49903','1'), /* Dwarf */
('4','1','49903','1'), /* Night Elf */
('5','1','49903','1'), /* Undead */
('6','1','49903','1'), /* Tauren */
('7','1','49903','1'), /* Gnome */
('8','1','49903','1'), /* Troll */
('11','1','49903','1'), /* Draenei */
/* Feet */
('1','1','50639','1'), /* Human */
('2','1','50639','1'), /* Orc */
('3','1','50639','1'), /* Dwarf */
('4','1','50639','1'), /* Night Elf */
('5','1','50639','1'), /* Undead */
('6','1','50639','1'), /* Tauren */
('7','1','50639','1'), /* Gnome */
('8','1','50639','1'), /* Troll */
('11','1','50639','1'), /* Draenei */
/* Ring */
('1','1','50657','1'), /* Human */
('2','1','50657','1'), /* Orc */
('3','1','50657','1'), /* Dwarf */
('4','1','50657','1'), /* Night Elf */
('5','1','50657','1'), /* Undead */
('6','1','50657','1'), /* Tauren */
('7','1','50657','1'), /* Gnome */
('8','1','50657','1'), /* Troll */
('11','1','50657','1'), /* Draenei */
/* Ring */
('1','1','50693','1'), /* Human */
('2','1','50693','1'), /* Orc */
('3','1','50693','1'), /* Dwarf */
('4','1','50693','1'), /* Night Elf */
('5','1','50693','1'), /* Undead */
('6','1','50693','1'), /* Tauren */
('7','1','50693','1'), /* Gnome */
('8','1','50693','1'), /* Troll */
('11','1','50693','1'), /* Draenei */
/* Trinket */
('1','1','47131','1'), /* Human */
('2','1','47464','1'), /* Orc */
('3','1','47131','1'), /* Dwarf */
('4','1','47131','1'), /* Night Elf */
('5','1','47464','1'), /* Undead */
('6','1','47464','1'), /* Tauren */
('7','1','47131','1'), /* Gnome */
('8','1','47464','1'), /* Troll */
('11','1','47131','1'), /* Draenei */
/* Trinket */
('1','1','50343','1'), /* Human */
('2','1','50343','1'), /* Orc */
('3','1','50343','1'), /* Dwarf */
('4','1','50343','1'), /* Night Elf */
('5','1','50343','1'), /* Undead */
('6','1','50343','1'), /* Tauren */
('7','1','50343','1'), /* Gnome */
('8','1','50343','1'), /* Troll */
('11','1','50343','1'), /* Draenei */
/* Ranged */
('1','1','47521','1'), /* Human */
('2','1','47523','1'), /* Orc */
('3','1','47521','1'), /* Dwarf */
('4','1','47521','1'), /* Night Elf */
('5','1','47523','1'), /* Undead */
('6','1','47523','1'), /* Tauren */
('7','1','47521','1'), /* Gnome */
('8','1','47523','1'), /* Troll */
('11','1','47521','1'), /* Draenei */
/* Main Hand */
('1','1','49623','1'), /* Human */
('2','1','49623','1'), /* Orc */
('3','1','49623','1'), /* Dwarf */
('4','1','49623','1'), /* Night Elf */
('5','1','49623','1'), /* Undead */
('6','1','49623','1'), /* Tauren */
('7','1','49623','1'), /* Gnome */
('8','1','49623','1'), /* Troll */
('11','1','49623','1'), /* Draenei */
/* Off Hand */
('1','1','50709','1'), /* Human */
('2','1','50709','1'), /* Orc */
('3','1','50709','1'), /* Dwarf */
('4','1','50709','1'), /* Night Elf */
('5','1','50709','1'), /* Undead */
('6','1','50709','1'), /* Tauren */
('7','1','50709','1'), /* Gnome */
('8','1','50709','1'), /* Troll */
('11','1','50709','1'), /* Draenei */
/* Tabard */
('1','1','45574','1'), /* Human */
('2','1','45581','1'), /* Orc */
('3','1','45577','1'), /* Dwarf */
('4','1','45579','1'), /* Night Elf */
('5','1','45583','1'), /* Undead */
('6','1','45584','1'), /* Tauren */
('7','1','45578','1'), /* Gnome */
('8','1','45582','1'), /* Troll */
('11','1','45580','1'); /* Draenei */

I placed this here because you can use it as a template to start your class with full gear.

The only one missing from the Warrior class, of course, is the Blood elf which is Race 10.



Code:
Class
1 = Warrior
2 = Paladin
3 = Hunter
4 = Rogue
5 = Priest
6 = Death Knight
7 = Shaman
8 = Mage
9 = Warlock
11 = Druid

Race
1 = Human
2 = Orc
3 = Dwarf
4 = Night Elf
5 = Undead
6 = Tauren
7 = Gnome
8 = Troll
10 = Blood Elf
11 = Draenei