/* MySQL Data Transfer Source Host: localhost Source Database: mangos Target Host: localhost Target Database: mangos Date: 15.09.2010 16:05:49 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for 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', `orientation` float NOT NULL default '0', PRIMARY KEY (`race`,`class`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- ---------------------------- -- Records -- ---------------------------- INSERT INTO `playercreateinfo` VALUES ('1', '1', '0', '12', '-8964.6', '513.078', '96.3554', '0'); INSERT INTO `playercreateinfo` VALUES ('1', '2', '0', '12', '-8964.6', '513.078', '96.3554', '0'); INSERT INTO `playercreateinfo` VALUES ('1', '4', '0', '12', '-8964.6', '513.078', '96.3554', '0'); INSERT INTO `playercreateinfo` VALUES ('1', '5', '0', '12', '-8964.6', '513.078', '96.3554', '0'); INSERT INTO `playercreateinfo` VALUES ('1', '8', '0', '12', '-8964.6', '513.078', '96.3554', '0'); INSERT INTO `playercreateinfo` VALUES ('1', '9', '0', '12', '-8964.6', '513.078', '96.3554', '0'); INSERT INTO `playercreateinfo` VALUES ('2', '1', '1', '14', '1470.97', '-4418.7', '25.2355', '0'); INSERT INTO `playercreateinfo` VALUES ('2', '3', '1', '14', '1470.97', '-4418.7', '25.2355', '0'); INSERT INTO `playercreateinfo` VALUES ('2', '4', '1', '14', '1470.97', '-4418.7', '25.2355', '0'); INSERT INTO `playercreateinfo` VALUES ('2', '7', '1', '14', '1470.97', '-4418.7', '25.2355', '0'); INSERT INTO `playercreateinfo` VALUES ('2', '9', '1', '14', '1470.97', '-4418.7', '25.2355', '0'); INSERT INTO `playercreateinfo` VALUES ('3', '1', '0', '1', '-8964.6', '513.078', '96.3554', '6.17716'); INSERT INTO `playercreateinfo` VALUES ('3', '2', '0', '1', '-8964.6', '513.078', '96.3554', '6.17716'); INSERT INTO `playercreateinfo` VALUES ('3', '3', '0', '1', '-8964.6', '513.078', '96.3554', '6.17716'); INSERT INTO `playercreateinfo` VALUES ('3', '4', '0', '1', '-8964.6', '513.078', '96.3554', '6.17716'); INSERT INTO `playercreateinfo` VALUES ('3', '5', '0', '1', '-8964.6', '513.078', '96.3554', '6.17716'); INSERT INTO `playercreateinfo` VALUES ('4', '1', '0', '141', '-8964.6', '513.078', '96.3554', '5.69632'); INSERT INTO `playercreateinfo` VALUES ('4', '3', '0', '141', '-8964.6', '513.078', '96.3554', '5.69632'); INSERT INTO `playercreateinfo` VALUES ('4', '4', '0', '141', '-8964.6', '513.078', '96.3554', '5.69632'); INSERT INTO `playercreateinfo` VALUES ('4', '5', '0', '141', '-8964.6', '513.078', '96.3554', '5.69632'); INSERT INTO `playercreateinfo` VALUES ('4', '11', '0', '141', '-8964.6', '513.078', '96.3554', '5.69632'); INSERT INTO `playercreateinfo` VALUES ('5', '1', '1', '85', '1470.97', '-4418.7', '25.2355', '2.70526'); INSERT INTO `playercreateinfo` VALUES ('5', '4', '1', '85', '1470.97', '-4418.7', '25.2355', '2.70526'); INSERT INTO `playercreateinfo` VALUES ('5', '5', '1', '85', '1470.97', '-4418.7', '25.2355', '2.70526'); INSERT INTO `playercreateinfo` VALUES ('5', '8', '1', '85', '1470.97', '-4418.7', '25.2355', '2.70526'); INSERT INTO `playercreateinfo` VALUES ('5', '9', '1', '85', '1470.97', '-4418.7', '25.2355', '2.70526'); INSERT INTO `playercreateinfo` VALUES ('6', '1', '1', '215', '1470.97', '-4418.7', '25.2355', '0'); INSERT INTO `playercreateinfo` VALUES ('6', '3', '1', '215', '1470.97', '-4418.7', '25.2355', '0'); INSERT INTO `playercreateinfo` VALUES ('6', '7', '1', '215', '1470.97', '-4418.7', '25.2355', '0'); INSERT INTO `playercreateinfo` VALUES ('6', '11', '1', '215', '1470.97', '-4418.7', '25.2355', '0'); INSERT INTO `playercreateinfo` VALUES ('7', '1', '0', '1', '-8964.6', '513.078', '96.3554', '0'); INSERT INTO `playercreateinfo` VALUES ('7', '9', '0', '1', '-8964.6', '513.078', '96.3554', '0'); INSERT INTO `playercreateinfo` VALUES ('7', '8', '0', '1', '-8964.6', '513.078', '96.3554', '0'); INSERT INTO `playercreateinfo` VALUES ('7', '4', '0', '1', '-8964.6', '513.078', '96.3554', '0'); INSERT INTO `playercreateinfo` VALUES ('8', '1', '1', '14', '1470.97', '-4418.7', '25.2355', '0'); INSERT INTO `playercreateinfo` VALUES ('8', '3', '1', '14', '1470.97', '-4418.7', '25.2355', '0'); INSERT INTO `playercreateinfo` VALUES ('8', '4', '1', '14', '1470.97', '-4418.7', '25.2355', '0'); INSERT INTO `playercreateinfo` VALUES ('8', '5', '1', '14', '1470.97', '-4418.7', '25.2355', '0'); INSERT INTO `playercreateinfo` VALUES ('8', '7', '1', '14', '1470.97', '-4418.7', '25.2355', '0'); INSERT INTO `playercreateinfo` VALUES ('8', '8', '1', '14', '1470.97', '-4418.7', '25.2355', '0'); INSERT INTO `playercreateinfo` VALUES ('10', '2', '1', '3431', '1470.97', '-4418.7', '25.2355', '5.31605'); INSERT INTO `playercreateinfo` VALUES ('10', '3', '1', '3431', '1470.97', '-4418.7', '25.2355', '5.31605'); INSERT INTO `playercreateinfo` VALUES ('10', '4', '1', '3431', '1470.97', '-4418.7', '25.2355', '5.31605'); INSERT INTO `playercreateinfo` VALUES ('10', '5', '1', '3431', '1470.97', '-4418.7', '25.2355', '5.31605'); INSERT INTO `playercreateinfo` VALUES ('10', '8', '1', '3431', '1470.97', '-4418.7', '25.2355', '5.31605'); INSERT INTO `playercreateinfo` VALUES ('10', '9', '1', '3431', '1470.97', '-4418.7', '25.2355', '5.31605'); INSERT INTO `playercreateinfo` VALUES ('11', '1', '0', '3526', '-8964.6', '513.078', '96.3554', '2.08364'); INSERT INTO `playercreateinfo` VALUES ('11', '2', '0', '3526', '-8964.6', '513.078', '96.3554', '2.08364'); INSERT INTO `playercreateinfo` VALUES ('11', '3', '0', '3526', '-8964.6', '513.078', '96.3554', '2.08364'); INSERT INTO `playercreateinfo` VALUES ('11', '5', '0', '3526', '-8964.6', '513.078', '96.3554', '2.08364'); INSERT INTO `playercreateinfo` VALUES ('11', '7', '0', '3526', '-8964.6', '513.078', '96.3554', '2.08364'); INSERT INTO `playercreateinfo` VALUES ('11', '8', '0', '3526', '-8964.6', '513.078', '96.3554', '2.08364'); INSERT INTO `playercreateinfo` VALUES ('11', '6', '609', '4298', '2358.17', '-5663.21', '426.027', '3.65997'); INSERT INTO `playercreateinfo` VALUES ('10', '6', '609', '4298', '2355.84', '-5664.77', '426.028', '3.65997'); INSERT INTO `playercreateinfo` VALUES ('8', '6', '609', '4298', '2355.05', '-5661.7', '426.026', '3.65997'); INSERT INTO `playercreateinfo` VALUES ('7', '6', '609', '4298', '2355.05', '-5661.7', '426.026', '3.65997'); INSERT INTO `playercreateinfo` VALUES ('6', '6', '609', '4298', '2358.17', '-5663.21', '426.027', '3.65997'); INSERT INTO `playercreateinfo` VALUES ('5', '6', '609', '4298', '2356.21', '-5662.21', '426.026', '3.65997'); INSERT INTO `playercreateinfo` VALUES ('4', '6', '609', '4298', '2356.21', '-5662.21', '426.026', '3.65997'); INSERT INTO `playercreateinfo` VALUES ('3', '6', '609', '4298', '2358.44', '-5666.9', '426.023', '3.65997'); INSERT INTO `playercreateinfo` VALUES ('2', '6', '609', '4298', '2358.44', '-5666.9', '426.023', '3.65997'); INSERT INTO `playercreateinfo` VALUES ('1', '6', '609', '4298', '2355.84', '-5664.77', '426.028', '3.65997');