Code:
/*
MySQL Data Transfer
Source Host: localhost
Source Database: ascent2
Target Host: localhost
Target Database: ascent2
Date: 12/13/2007 3:07:31 PM
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for playercreateinfo
-- ----------------------------
CREATE TABLE `playercreateinfo` (
`Index` tinyint(3) unsigned NOT NULL auto_increment,
`race` tinyint(3) unsigned NOT NULL default '0',
`factiontemplate` int(10) unsigned NOT NULL default '0',
`class` tinyint(3) unsigned NOT NULL default '0',
`mapID` int(10) unsigned NOT NULL default '0',
`zoneID` int(10) unsigned NOT NULL default '0',
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`displayID` smallint(5) unsigned NOT NULL default '0',
`BaseStrength` tinyint(3) unsigned NOT NULL default '0',
`BaseAgility` tinyint(3) unsigned NOT NULL default '0',
`BaseStamina` tinyint(3) unsigned NOT NULL default '0',
`BaseIntellect` tinyint(3) unsigned NOT NULL default '0',
`BaseSpirit` tinyint(3) unsigned NOT NULL default '0',
`BaseHealth` int(10) unsigned NOT NULL default '0',
`BaseMana` int(10) unsigned NOT NULL default '0',
`BaseRage` int(10) unsigned NOT NULL default '0',
`BaseFocus` int(10) unsigned NOT NULL default '0',
`BaseEnergy` int(10) unsigned NOT NULL default '0',
`attackpower` int(10) unsigned NOT NULL default '0',
`mindmg` float NOT NULL default '0',
`maxdmg` float NOT NULL default '0',
PRIMARY KEY (`Index`)
) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=latin1 COMMENT='Player System';
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `playercreateinfo` VALUES ('1', '1', '1', '1', '0', '12', '-8949.95', '-132.493', '83.5312', '49', '23', '20', '22', '20', '20', '60', '0', '1000', '0', '0', '29', '5', '6');
INSERT INTO `playercreateinfo` VALUES ('2', '2', '2', '1', '1', '14', '-618.518', '-4251.67', '38.718', '51', '26', '17', '24', '17', '23', '80', '0', '1000', '0', '0', '35', '6', '7');
INSERT INTO `playercreateinfo` VALUES ('3', '3', '3', '1', '0', '1', '-6240.32', '331.033', '382.758', '53', '25', '16', '25', '19', '19', '90', '0', '1000', '0', '0', '33', '5', '6');
INSERT INTO `playercreateinfo` VALUES ('4', '4', '4', '1', '1', '141', '10311.3', '832.463', '1326.41', '55', '20', '25', '21', '20', '20', '50', '0', '1000', '0', '0', '23', '4', '5');
INSERT INTO `playercreateinfo` VALUES ('5', '5', '5', '1', '0', '85', '1676.35', '1677.45', '121.67', '57', '22', '18', '23', '18', '25', '70', '0', '1000', '0', '0', '27', '4', '5');
INSERT INTO `playercreateinfo` VALUES ('6', '6', '6', '1', '1', '215', '-2917.58', '-257.98', '52.9968', '59', '28', '15', '24', '15', '22', '80', '0', '1000', '0', '0', '39', '6', '7');
INSERT INTO `playercreateinfo` VALUES ('7', '7', '115', '1', '0', '1', '-6237.02', '329.659', '382.703', '1563', '18', '23', '21', '23', '20', '50', '0', '1000', '0', '0', '19', '3', '4');
INSERT INTO `playercreateinfo` VALUES ('8', '8', '116', '1', '1', '14', '-618.518', '-4251.67', '38.718', '1478', '24', '22', '23', '16', '21', '70', '0', '1000', '0', '0', '31', '5', '6');
INSERT INTO `playercreateinfo` VALUES ('9', '1', '1', '2', '0', '12', '-8949.95', '-132.493', '83.5312', '49', '22', '20', '22', '20', '21', '58', '80', '0', '0', '0', '27', '4', '5');
INSERT INTO `playercreateinfo` VALUES ('10', '3', '3', '2', '0', '1', '-6240.32', '331.033', '382.758', '53', '24', '16', '25', '19', '20', '88', '79', '0', '0', '0', '31', '5', '6');
INSERT INTO `playercreateinfo` VALUES ('11', '2', '2', '3', '1', '14', '-618.518', '-4251.67', '38.718', '51', '23', '20', '23', '17', '24', '76', '82', '0', '0', '0', '25', '4', '5');
INSERT INTO `playercreateinfo` VALUES ('12', '3', '3', '3', '0', '1', '-6240.32', '331.033', '382.758', '53', '22', '19', '24', '19', '20', '86', '84', '0', '0', '0', '23', '4', '5');
INSERT INTO `playercreateinfo` VALUES ('15', '4', '4', '3', '1', '141', '10311.3', '832.463', '1326.41', '55', '17', '28', '20', '20', '21', '46', '85', '0', '0', '0', '27', '4', '5');
INSERT INTO `playercreateinfo` VALUES ('16', '6', '6', '3', '1', '215', '-2917.58', '-257.98', '52.9968', '59', '25', '18', '23', '15', '23', '76', '80', '0', '0', '0', '25', '4', '5');
INSERT INTO `playercreateinfo` VALUES ('17', '8', '116', '3', '1', '14', '-618.518', '-4251.67', '38.718', '1478', '21', '25', '22', '16', '22', '66', '81', '0', '0', '0', '28', '5', '6');
INSERT INTO `playercreateinfo` VALUES ('18', '1', '1', '4', '0', '12', '-8949.95', '-132.493', '83.5312', '49', '21', '23', '21', '20', '20', '55', '0', '0', '0', '100', '26', '4', '5');
INSERT INTO `playercreateinfo` VALUES ('19', '2', '2', '4', '1', '14', '-618.518', '-4251.67', '38.718', '51', '24', '20', '23', '17', '23', '75', '0', '0', '0', '100', '26', '4', '5');
INSERT INTO `playercreateinfo` VALUES ('20', '3', '3', '4', '0', '1', '-6240.32', '331.033', '382.758', '53', '23', '19', '24', '19', '19', '85', '0', '0', '0', '100', '24', '4', '5');
INSERT INTO `playercreateinfo` VALUES ('21', '4', '4', '4', '1', '141', '10311.3', '832.463', '1326.41', '55', '18', '28', '20', '20', '20', '45', '0', '0', '0', '100', '28', '5', '6');
INSERT INTO `playercreateinfo` VALUES ('22', '5', '5', '4', '0', '85', '1676.35', '1677.45', '121.67', '57', '20', '21', '22', '18', '25', '65', '0', '0', '0', '100', '23', '4', '5');
INSERT INTO `playercreateinfo` VALUES ('23', '7', '115', '4', '0', '1', '-6237.02', '329.659', '382.703', '1563', '16', '26', '20', '23', '20', '45', '0', '0', '0', '100', '24', '4', '5');
INSERT INTO `playercreateinfo` VALUES ('24', '8', '116', '4', '1', '14', '-618.518', '-4251.67', '38.718', '1478', '22', '25', '22', '16', '21', '65', '0', '0', '0', '100', '29', '5', '6');
INSERT INTO `playercreateinfo` VALUES ('25', '1', '1', '5', '0', '12', '-8949.95', '-132.493', '83.5312', '49', '20', '20', '20', '22', '23', '52', '160', '0', '0', '0', '10', '2', '3');
INSERT INTO `playercreateinfo` VALUES ('26', '3', '3', '5', '0', '1', '-6240.32', '331.033', '382.758', '53', '22', '16', '23', '21', '22', '82', '145', '0', '0', '0', '12', '2', '3');
INSERT INTO `playercreateinfo` VALUES ('27', '4', '4', '5', '1', '141', '10311.3', '832.463', '1326.41', '55', '17', '25', '19', '22', '23', '51', '160', '0', '0', '0', '7', '2', '2');
INSERT INTO `playercreateinfo` VALUES ('28', '5', '5', '5', '0', '85', '1676.35', '1677.45', '121.67', '57', '19', '18', '21', '20', '28', '62', '130', '0', '0', '0', '9', '2', '3');
INSERT INTO `playercreateinfo` VALUES ('29', '8', '116', '5', '1', '14', '-618.518', '-4251.67', '38.718', '1478', '21', '22', '21', '18', '24', '62', '128', '0', '0', '0', '11', '2', '3');
INSERT INTO `playercreateinfo` VALUES ('30', '2', '2', '7', '1', '14', '-618.518', '-4251.67', '38.718', '51', '24', '17', '23', '18', '25', '77', '73', '0', '0', '0', '30', '5', '6');
INSERT INTO `playercreateinfo` VALUES ('31', '6', '6', '7', '1', '215', '-2917.58', '-257.98', '52.9968', '59', '26', '15', '23', '16', '24', '77', '71', '0', '0', '0', '34', '5', '6');
INSERT INTO `playercreateinfo` VALUES ('32', '8', '116', '7', '1', '14', '-618.518', '-4251.67', '38.718', '1478', '22', '22', '22', '17', '23', '67', '72', '0', '0', '0', '26', '4', '5');
INSERT INTO `playercreateinfo` VALUES ('34', '1', '1', '8', '0', '12', '-8949.95', '-132.493', '83.5312', '49', '20', '20', '20', '23', '22', '52', '165', '0', '0', '0', '10', '2', '3');
INSERT INTO `playercreateinfo` VALUES ('35', '5', '5', '8', '0', '85', '1676.35', '1677.45', '121.67', '57', '19', '18', '21', '21', '27', '62', '135', '0', '0', '0', '9', '2', '3');
INSERT INTO `playercreateinfo` VALUES ('36', '7', '115', '8', '0', '1', '-6237.02', '329.659', '382.703', '1563', '15', '23', '19', '26', '22', '51', '210', '0', '0', '0', '5', '1', '2');
INSERT INTO `playercreateinfo` VALUES ('37', '8', '116', '8', '1', '14', '-618.518', '-4251.67', '38.718', '1478', '21', '22', '21', '19', '23', '62', '119', '0', '0', '0', '11', '2', '3');
INSERT INTO `playercreateinfo` VALUES ('38', '1', '1', '9', '0', '12', '-8949.95', '-132.493', '83.5312', '49', '20', '20', '21', '22', '22', '53', '140', '0', '0', '0', '10', '2', '3');
INSERT INTO `playercreateinfo` VALUES ('39', '2', '2', '9', '1', '14', '-618.518', '-4251.67', '38.718', '51', '23', '17', '23', '19', '25', '73', '109', '0', '0', '0', '13', '2', '3');
INSERT INTO `playercreateinfo` VALUES ('40', '5', '5', '9', '0', '85', '1676.35', '1677.45', '121.67', '57', '19', '18', '22', '20', '27', '63', '110', '0', '0', '0', '9', '2', '3');
INSERT INTO `playercreateinfo` VALUES ('41', '7', '115', '9', '0', '1', '-6237.02', '329.659', '382.703', '1563', '15', '23', '20', '25', '22', '43', '185', '0', '0', '0', '5', '1', '2');
INSERT INTO `playercreateinfo` VALUES ('42', '4', '4', '11', '1', '141', '10311.3', '832.463', '1326.41', '55', '18', '25', '19', '22', '22', '53', '100', '0', '0', '0', '16', '3', '4');
INSERT INTO `playercreateinfo` VALUES ('43', '6', '6', '11', '1', '215', '-2917.58', '-257.98', '52.9968', '59', '26', '15', '22', '17', '24', '74', '67', '0', '0', '0', '32', '5', '6');
INSERT INTO `playercreateinfo` VALUES ('44', '11', '1629', '1', '530', '3524', '-3961.64', '-13931.2', '100.615', '16125', '24', '17', '21', '21', '22', '50', '0', '1000', '0', '0', '31', '5', '6');
INSERT INTO `playercreateinfo` VALUES ('45', '11', '1629', '2', '530', '3524', '-3961.64', '-13931.2', '100.615', '16125', '23', '17', '21', '21', '23', '48', '95', '0', '0', '0', '29', '5', '6');
INSERT INTO `playercreateinfo` VALUES ('46', '11', '1629', '3', '530', '3524', '-3961.64', '-13931.2', '100.615', '16125', '21', '20', '20', '21', '23', '46', '100', '0', '0', '0', '23', '4', '5');
INSERT INTO `playercreateinfo` VALUES ('47', '11', '1629', '5', '530', '3524', '-3961.64', '-13931.2', '100.615', '16125', '21', '17', '19', '23', '25', '51', '175', '0', '0', '0', '11', '2', '3');
INSERT INTO `playercreateinfo` VALUES ('48', '11', '1629', '7', '530', '3524', '-3961.64', '-13931.2', '100.615', '16125', '22', '17', '20', '22', '24', '47', '105', '0', '0', '0', '26', '4', '5');
INSERT INTO `playercreateinfo` VALUES ('49', '11', '1629', '8', '530', '3524', '-3961.64', '-13931.2', '100.615', '16125', '21', '17', '19', '24', '24', '51', '180', '0', '0', '0', '11', '2', '3');
INSERT INTO `playercreateinfo` VALUES ('50', '10', '1610', '2', '530', '3430', '10349.6', '-6357.29', '33.4026', '15476', '19', '22', '20', '24', '20', '38', '140', '0', '0', '0', '21', '4', '4');
INSERT INTO `playercreateinfo` VALUES ('51', '10', '1610', '3', '530', '3430', '10349.6', '-6357.29', '33.4026', '15476', '17', '25', '19', '24', '20', '45', '145', '0', '0', '0', '24', '4', '5');
INSERT INTO `playercreateinfo` VALUES ('52', '10', '1610', '4', '530', '3430', '10349.6', '-6357.29', '33.4026', '15476', '18', '25', '19', '24', '19', '44', '0', '0', '0', '100', '25', '4', '5');
INSERT INTO `playercreateinfo` VALUES ('53', '10', '1610', '5', '530', '3430', '10349.6', '-6357.29', '33.4026', '15476', '17', '22', '18', '26', '22', '50', '220', '0', '0', '0', '7', '2', '2');
INSERT INTO `playercreateinfo` VALUES ('54', '10', '1610', '8', '530', '3430', '10349.6', '-6357.29', '33.4026', '15476', '17', '22', '18', '27', '21', '50', '225', '0', '0', '0', '7', '2', '2');
INSERT INTO `playercreateinfo` VALUES ('55', '10', '1610', '9', '530', '3430', '10349.6', '-6357.29', '33.4026', '15476', '17', '22', '19', '26', '21', '42', '200', '0', '0', '0', '7', '2', '2');