[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DATABASE `PokeAres`;
DROP TABLE IF EXISTS `pn_bag`;
CREATE TABLE `pn_bag` (
' at line 1
[Err] CREATE DATABASE IF NOT EXISTS `PokeAres`;
USE DATABASE `PokeAres`;
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,
UNIQUE KEY `memberitem` (`member`,`item`),
KEY `Memberid` (`member`)
) ENGINE=MyISAM DEFAULT CHARSET=ascii;
-- ----------------------------
-- Table structure for `pn_bans`
-- ----------------------------
DROP TABLE IF EXISTS `pn_bans`;
CREATE TABLE `pn_bans` (
`ip` varchar(48) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of pn_bans
-- ----------------------------
-- ----------------------------
-- Table structure for `pn_history`
-- ----------------------------
DROP TABLE IF EXISTS `pn_history`;
CREATE TABLE `pn_history` (
`member` int(11) NOT NULL,
`action` int(11) NOT NULL,
`with` int(11) NOT NULL,
`timestamp` datetime DEFAULT NULL,
`details` varchar(256) DEFAULT NULL,
UNIQUE KEY `memberitem` (`member`,`action`),
KEY `Memberid` (`member`)
) ENGINE=MyISAM DEFAULT CHARSET=ascii;
-- ----------------------------
-- Records of pn_history
-- ----------------------------
-- ----------------------------
-- 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(16) DEFAULT NULL,
`lastLanguageUsed` int(11) DEFAULT NULL,
`sprite` int(11) DEFAULT NULL,
`party` int(11) DEFAULT NULL,
`money` int(11) DEFAULT NULL,
`npcMul` varchar(24) 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` int(11) DEFAULT NULL,
`y` int(11) DEFAULT NULL,
`mapX` int(11) DEFAULT NULL,
`mapY` int(11) 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` int(11) DEFAULT NULL,
`muted` varchar(5) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for `pn_party`
-- ----------------------------
DROP TABLE IF EXISTS `pn_party`;
CREATE TABLE `pn_party` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`member` int(11) DEFAULT NULL,
`pokemon0` int(11) DEFAULT NULL,
`pokemon1` int(11) DEFAULT NULL,
`pokemon2` int(11) DEFAULT NULL,
`pokemon3` int(11) DEFAULT NULL,
`pokemon4` int(11) DEFAULT NULL,
`pokemon5` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Table structure for `pn_pokemon`
-- ----------------------------
DROP TABLE IF EXISTS `pn_pokemon`;
CREATE TABLE `pn_pokemon` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(24) DEFAULT NULL,
`speciesName` varchar(32) DEFAULT NULL,
`exp` varchar(32) DEFAULT NULL,
`baseExp` int(11) DEFAULT NULL,
`expType` varchar(16) DEFAULT NULL,
`isFainted` varchar(5) DEFAULT NULL,
`level` int(11) DEFAULT NULL,
`happiness` int(11) DEFAULT NULL,
`gender` int(11) DEFAULT NULL,
`nature` varchar(24) DEFAULT NULL,
`abilityName` varchar(24) DEFAULT NULL,
`itemName` varchar(28) DEFAULT NULL,
`isShiny` varchar(5) DEFAULT NULL,
`originalTrainerName` varchar(12) DEFAULT NULL,
`currentTrainerName` varchar(12) DEFAULT NULL,
`contestStats` varchar(255) DEFAULT NULL,
`move0` varchar(32) DEFAULT NULL,
`move1` varchar(32) DEFAULT
[Msg] Finished - Unsuccessfully