Quote:
Navicat MySQL Data Transfer
Source Server : ragnarok
Source S' at line 1
[Err] /*
Navicat MySQL Data Transfer
Source Server : ragnarok
Source Server Version : 50140
Source Host : localhost:3306
Source Database : pokemon
Target Server Type : MYSQL
Target Server Version : 50140
File Encoding : 65001
Date: 2015-01-17 20:56:24
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `pn_bag`
-- ----------------------------
DROP TABLE IF EXISTS `pn_bag`;
CREATE TABLE `pn_bag` (
`member` int(11) NOT NULL,
`item` int(11) NOT NULL,
`quantity` int(11) NOT NULL,
PRIMARY KEY (`member`,`item`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;
-- ----------------------------
-- Records of pn_bag
-- ----------------------------
INSERT INTO `pn_bag` VALUES ('7', '35', '5');
INSERT INTO `pn_bag` VALUES ('8', '35', '5');
INSERT INTO `pn_bag` VALUES ('9', '35', '5');
INSERT INTO `pn_bag` VALUES ('10', '35', '5');
INSERT INTO `pn_bag` VALUES ('10', '206', '1');
INSERT INTO `pn_bag` VALUES ('11', '1', '6');
INSERT INTO `pn_bag` VALUES ('11', '35', '2');
INSERT INTO `pn_bag` VALUES ('11', '202', '1');
INSERT INTO `pn_bag` VALUES ('11', '206', '4');
INSERT INTO `pn_bag` VALUES ('12', '35', '28');
INSERT INTO `pn_bag` VALUES ('12', '97', '2');
INSERT INTO `pn_bag` VALUES ('12', '168', '3');
INSERT INTO `pn_bag` VALUES ('12', '606', '1');
INSERT INTO `pn_bag` VALUES ('13', '35', '23');
INSERT INTO `pn_bag` VALUES ('13', '200', '1');
INSERT INTO `pn_bag` VALUES ('13', '202', '8');
INSERT INTO `pn_bag` VALUES ('13', '206', '24');
INSERT INTO `pn_bag` VALUES ('13', '207', '5');
INSERT INTO `pn_bag` VALUES ('14', '1', '10');
INSERT INTO `pn_bag` VALUES ('14', '2', '3');
INSERT INTO `pn_bag` VALUES ('14', '35', '2');
INSERT INTO `pn_bag` VALUES ('14', '36', '6');
INSERT INTO `pn_bag` VALUES ('14', '85', '26');
INSERT INTO `pn_bag` VALUES ('14', '91', '18');
INSERT INTO `pn_bag` VALUES ('14', '200', '2');
INSERT INTO `pn_bag` VALUES ('14', '202', '6');
INSERT INTO `pn_bag` VALUES ('14', '203', '2');
INSERT INTO `pn_bag` VALUES ('14', '206', '59');
INSERT INTO `pn_bag` VALUES ('14', '207', '24');
INSERT INTO `pn_bag` VALUES ('14', '209', '4');
INSERT INTO `pn_bag` VALUES ('14', '353', '1');
INSERT INTO `pn_bag` VALUES ('14', '483', '1');
INSERT INTO `pn_bag` VALUES ('14', '603', '1');
INSERT INTO `pn_bag` VALUES ('15', '35', '5');
INSERT INTO `pn_bag` VALUES ('16', '2', '4');
INSERT INTO `pn_bag` VALUES ('16', '36', '14');
INSERT INTO `pn_bag` VALUES ('16', '168', '1');
INSERT INTO `pn_bag` VALUES ('16', '200', '1');
INSERT INTO `pn_bag` VALUES ('16', '206', '30');
INSERT INTO `pn_bag` VALUES ('16', '610', '1');
INSERT INTO `pn_bag` VALUES ('17', '2', '4');
INSERT INTO `pn_bag` VALUES ('17', '35', '5');
INSERT INTO `pn_bag` VALUES ('17', '36', '5');
INSERT INTO `pn_bag` VALUES ('17', '85', '10');
INSERT INTO `pn_bag` VALUES ('17', '200', '1');
INSERT INTO `pn_bag` VALUES ('17', '206', '16');
INSERT INTO `pn_bag` VALUES ('18', '1', '2');
INSERT INTO `pn_bag` VALUES ('18', '35', '5');
INSERT INTO `pn_bag` VALUES ('18', '36', '14');
INSERT INTO `pn_bag` VALUES ('18', '202', '1');
INSERT INTO `pn_bag` VALUES ('18', '206', '12');
INSERT INTO `pn_bag` VALUES ('18', '207', '9');
INSERT INTO `pn_bag` VALUES ('19', '35', '5');
INSERT INTO `pn_bag` VALUES ('20', '35', '5');
INSERT INTO `pn_bag` VALUES ('20', '200', '5');
INSERT INTO `pn_bag` VALUES ('20', '201', '1');
INSERT INTO `pn_bag` VALUES ('20', '204', '1');
INSERT INTO `pn_bag` VALUES ('20', '206', '10');
-- ----------------------------
-- Table structure for `pn_bans`
-- ----------------------------
DROP TABLE IF EXISTS `pn_bans`;
CREATE TABLE `pn_bans` (
`playername` varchar(12) NOT NULL,
`ip` varchar(16) NOT NULL,
PRIMARY KEY (`playername`,`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of pn_bans
-- ----------------------------
INSERT INTO `pn_bans` VALUES ('esmeralda', '186.130.37.87');
-- ----------------------------
-- Table structure for `pn_box`
-
[Err] 1005 - Can't create table 'pokenet.pn_cheatlog' (errno: 150)
[Err] CREATE TABLE `pn_cheatlog` (
`playerid` int(11) NOT NULL,
`date` varchar(25) NOT NULL,
`message` varchar(255) DEFAULT NULL,
PRIMARY KEY (`playerid`,`date`),
KEY `player_cheat_idx` (`playerid`),
CONSTRAINT `player_cheat_fk` FOREIGN KEY (`playerid`) REFERENCES `pn_members` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of pn_cheatlog
-- ----------------------------
-- ----------------------------
-- Table structure for `pn_friends`
-- ----------------------------
DROP TABLE IF EXISTS `pn_friends`;
CREATE TABLE `pn_friends` (
`id` int(11) NOT NULL,
`friendId` int(11) NOT NULL,
PRIMARY KEY (`id`,`friendId`),
KEY `player_friend_idx` (`id`),
KEY `friend_idx` (`friendId`),
CONSTRAINT `firend_fk` FOREIGN KEY (`friendId`) REFERENCES `pn_members` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `player_friend_fk` FOREIGN KEY (`id`) REFERENCES `pn_members` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of pn_friends
-- ----------------------------
-- ----------------------------
-- Table structure for `pn_members`
-- ----------------------------
DROP TABLE IF EXISTS `pn_members`;
CREATE TABLE `pn_members` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(12) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`dob` varchar(12) DEFAULT NULL,
`email` varchar(32) DEFAULT NULL,
`lastLoginTime` varchar(42) DEFAULT NULL,
`lastLoginServer` varchar(24) CHARACTER SET utf8 DEFAULT NULL,
`lastLoginIP` varchar(24) DEFAULT NULL,
`lastLanguageUsed` tinyint(4) DEFAULT NULL,
`sprite` smallint(6) DEFAULT NULL,
`party` int(11) DEFAULT NULL,
`money` int(11) DEFAULT NULL,
`npcMul` varchar(6) DEFAULT NULL,
`skHerb` int(11) DEFAULT NULL,
`skCraft` int(11) DEFAULT NULL,
`skFish` int(11) DEFAULT NULL,
`skTrain` int(11) DEFAULT NULL,
`skCoord` int(11) DEFAULT NULL,
`skBreed` int(11) DEFAULT NULL,
`x` smallint(6) DEFAULT NULL,
`y` smallint(6) DEFAULT NULL,
`mapX` tinyint(4) DEFAULT NULL,
`mapY` tinyint(4) DEFAULT NULL,
`bag` int(11) DEFAULT NULL,
`badges` varchar(50) DEFAULT NULL,
`healX` int(11) DEFAULT NULL,
`healY` int(11) DEFAULT NULL,
`healMapX` int(11) DEFAULT NULL,
`healMapY` int(11) DEFAULT NULL,
`isSurfing` varchar(5) DEFAULT NULL,
`adminLevel` tinyint(3) unsigned DEFAULT NULL,
`muted` varchar(5) DEFAULT '',
`pokedexId` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `username_idx` (`username`),
KEY `dex_id_idx` (`pokedexId`),
CONSTRAINT `dex_id` FOREIGN KEY (`pokedexId`) REFERENCES `pn_pokedex` (`pokedexId`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of pn_members
-- ----------------------------
INSERT INTO `pn_members` VALUES ('7', 'Rabbit', '5485054D8E695E3937AAB2B9ED25BD4E5E4B96A7367C0DD34E3A28F15529C4CF166144853FDEAF8D8C7329EB9B0E94F26B9BC0173724091CA7F4BAD238073BD6', '19/11/1991', 'conejo@hotmail.com', '1411001019121', 'null', '190.179.166.5', '5', '11', '7', '1000', null, '0', '0', '0', '0', '0', '0', '480', '312', '3', '1', null, '000000000000000000000000000000000000000000', '512', '440', '3', '1', 'false', '0', 'false', '7');
INSERT INTO `pn_members` VALUES ('8', 'conejoo', 'D8A1DF1061EE535737033D413401B09DFB5311C9B9E0E10F5E81E2ED1DD89EA297940106FE15896B96EF9721974E48903745D79AC279ADA669382AA4F66460AA', '19/11/1991', 'conejoo@hotmail.com', '0', 'null', null, null, '11', '8', '1000', null, '0', '0', '0', '0', '0', '0', '512', '440', '3', '1', null, '00000000000000000000000000000000000000000000000000', '512', '440', '3', '1', 'false', '0', 'false', '8');
INSERT INTO `pn_members` VALUES ('9', 'snupy', 'C6FA7EA0869822AF694C319A8F915F6CD2EBC35F79706A72499355589CDD0E41ADBD99D59164C36B29E6327983D6D846948AF2EA8519A0E68BE8C86B78C2E90A', '19/11/1991', 'f3re@hotmail.com', '1411021396439'
[Err] 1146 - Table 'pokenet.pn_pokedex' doesn't exist
[Err] -- ----------------------------
-- Records of pn_pokedex
-- ----------------------------
INSERT INTO `pn_pokedex` VALUES ('6', '6', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `pn_pokedex` VALUES ('7', '7', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0',
[Msg] Finished - Unsuccessfully
--------------------------------------------------
Any help?