/*
MySQL Data Transfer
Source Host: localhost
Source Database: mangos
Target Host: localhost
Target Database: mangos
Date: 03.04.2010 21:22:21
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for playercreateinfo
-- ----------------------------
DROP TABLE IF EXISTS `playercreateinfo`;
CREATE TABLE `playercreateinfo` (
  `race` tinyint(3) unsigned NOT NULL default '0',
  `class` tinyint(3) unsigned NOT NULL default '0',
  `map` smallint(5) unsigned NOT NULL default '0',
  `zone` mediumint(8) unsigned NOT NULL default '0',
  `position_x` float NOT NULL default '0',
  `position_y` float NOT NULL default '0',
  `position_z` float NOT NULL default '0',
  PRIMARY KEY  (`race`,`class`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Альянс в Штормграде
-- ----------------------------
-- Человек
INSERT INTO `playercreateinfo` VALUES ('1', '1', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('1', '2', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('1', '4', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('1', '5', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('1', '8', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('1', '9', '0', '12', '-8964.6', '513.078', '96.3554');

-- Дворф
INSERT INTO `playercreateinfo` VALUES ('3', '1', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('3', '2', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('3', '3', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('3', '4', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('3', '5', '0', '12', '-8964.6', '513.078', '96.3554');

-- Ночной эльф
INSERT INTO `playercreateinfo` VALUES ('4', '1', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('4', '3', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('4', '4', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('4', '5', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('4', '11', '0', '12', '-8964.6', '513.078', '96.3554');

-- Гном
INSERT INTO `playercreateinfo` VALUES ('7', '1', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('7', '9', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('7', '8', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('7', '4', '0', '12', '-8964.6', '513.078', '96.3554');

-- Дреней
INSERT INTO `playercreateinfo` VALUES ('11', '1', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('11', '2', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('11', '3', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('11', '5', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('11', '7', '0', '12', '-8964.6', '513.078', '96.3554');
INSERT INTO `playercreateinfo` VALUES ('11', '8', '0', '12', '-8964.6', '513.078', '96.3554');


-- ----------------------------
-- Орда в Оргримаре
-- ----------------------------
-- Орк
INSERT INTO `playercreateinfo` VALUES ('2', '1', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('2', '3', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('2', '4', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('2', '7', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('2', '9', '1', '14', '1470.97', '-4418.7', '25.2355');

-- Нежить
INSERT INTO `playercreateinfo` VALUES ('5', '1', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('5', '4', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('5', '5', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('5', '8', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('5', '9', '1', '14', '1470.97', '-4418.7', '25.2355');

-- Таурен
INSERT INTO `playercreateinfo` VALUES ('6', '1', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('6', '3', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('6', '7', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('6', '11', '1', '14', '1470.97', '-4418.7', '25.2355');

-- Троль
INSERT INTO `playercreateinfo` VALUES ('8', '1', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('8', '3', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('8', '4', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('8', '5', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('8', '7', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('8', '8', '1', '14', '1470.97', '-4418.7', '25.2355');

-- Кровавый Эльф
INSERT INTO `playercreateinfo` VALUES ('10', '2', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('10', '3', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('10', '4', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('10', '5', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('10', '8', '1', '14', '1470.97', '-4418.7', '25.2355');
INSERT INTO `playercreateinfo` VALUES ('10', '9', '1', '14', '1470.97', '-4418.7', '25.2355');

-- ----------------------------
-- Рыцари Смерти на своём месте
-- ----------------------------
INSERT INTO `playercreateinfo` VALUES ('11', '6', '609', '4298', '2358.17', '-5663.21', '426.027');
INSERT INTO `playercreateinfo` VALUES ('10', '6', '609', '4298', '2355.84', '-5664.77', '426.028');
INSERT INTO `playercreateinfo` VALUES ('8', '6', '609', '4298', '2355.05', '-5661.7', '426.026');
INSERT INTO `playercreateinfo` VALUES ('7', '6', '609', '4298', '2355.05', '-5661.7', '426.026');
INSERT INTO `playercreateinfo` VALUES ('6', '6', '609', '4298', '2358.17', '-5663.21', '426.027');
INSERT INTO `playercreateinfo` VALUES ('5', '6', '609', '4298', '2356.21', '-5662.21', '426.026');
INSERT INTO `playercreateinfo` VALUES ('4', '6', '609', '4298', '2356.21', '-5662.21', '426.026');
INSERT INTO `playercreateinfo` VALUES ('3', '6', '609', '4298', '2358.44', '-5666.9', '426.023');
INSERT INTO `playercreateinfo` VALUES ('2', '6', '609', '4298', '2358.44', '-5666.9', '426.023');
INSERT INTO `playercreateinfo` VALUES ('1', '6', '609', '4298', '2355.84', '-5664.77', '426.028');