/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50139
Source Host           : localhost:3306
Source Database       : wonderking

Target Server Type    : MYSQL
Target Server Version : 50139
File Encoding         : 65001

Date: 2010-03-01 22:30:05
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `accounts`
-- ----------------------------
DROP TABLE IF EXISTS `accounts`;
CREATE TABLE `accounts` (
  `ID` int(11) NOT NULL DEFAULT '0',
  `Username` char(32) DEFAULT NULL,
  `Password` char(20) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of accounts
-- ----------------------------
INSERT INTO `accounts` VALUES ('1', 'admin', '123123');

-- ----------------------------
-- Table structure for `items`
-- ----------------------------
DROP TABLE IF EXISTS `items`;
CREATE TABLE `items` (
  `PlayerID` smallint(2) NOT NULL DEFAULT '0',
  `ItemID` smallint(2) DEFAULT NULL,
  `Count` smallint(2) DEFAULT NULL,
  `Position` tinyint(1) unsigned DEFAULT NULL,
  `HasAttributes` tinyint(1) unsigned DEFAULT NULL,
  `IsEquipment` tinyint(1) unsigned DEFAULT NULL,
  `Level` tinyint(1) unsigned DEFAULT NULL,
  `RareType` tinyint(1) unsigned DEFAULT NULL,
  `AddOption` tinyint(1) unsigned DEFAULT NULL,
  `AddOption2` tinyint(1) unsigned DEFAULT NULL,
  `AddOption3` tinyint(1) unsigned DEFAULT NULL,
  `Option` smallint(2) DEFAULT NULL,
  `Option2` smallint(2) DEFAULT NULL,
  `Option3` smallint(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of items
-- ----------------------------
INSERT INTO `items` VALUES ('1', '393', '55', '0', '0', '0', null, null, null, null, null, null, null, null);
INSERT INTO `items` VALUES ('1', '3222', '1', '0', '1', '0', '11', '3', '1', '6', '4', '152', '24', '36');

-- ----------------------------
-- Table structure for `players`
-- ----------------------------
DROP TABLE IF EXISTS `players`;
CREATE TABLE `players` (
  `ID` smallint(6) NOT NULL,
  `UserID` int(11) NOT NULL,
  `Name` char(20) NOT NULL,
  `Level` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `Money` bigint(20) DEFAULT NULL,
  `HP` smallint(6) NOT NULL DEFAULT '0',
  `MP` smallint(6) NOT NULL DEFAULT '0',
  `MaxHP` smallint(6) NOT NULL DEFAULT '0',
  `MaxMP` smallint(6) NOT NULL DEFAULT '0',
  `Map` smallint(6) NOT NULL DEFAULT '0',
  `Str` smallint(6) NOT NULL DEFAULT '0',
  `Dex` smallint(6) NOT NULL DEFAULT '0',
  `Int` smallint(6) NOT NULL DEFAULT '0',
  `Luck` smallint(6) NOT NULL DEFAULT '0',
  `Vit` smallint(6) NOT NULL DEFAULT '0',
  `Wis` smallint(6) NOT NULL DEFAULT '0',
  `Job1` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `Job2` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `Job3` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `Job4` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `X` smallint(6) NOT NULL DEFAULT '0',
  `Y` smallint(6) NOT NULL DEFAULT '0',
  `Hair` smallint(6) NOT NULL,
  `Eyes` smallint(6) NOT NULL,
  `SP` smallint(6) NOT NULL DEFAULT '0',
  `AP` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of players
-- ----------------------------
INSERT INTO `players` VALUES ('1', '1', 'Admin', '200', '1000000', '900', '100', '900', '100', '300', '999', '999', '999', '999', '999', '999', '3', '9', '17', '0', '400', '536', '15', '37', '999', '999');

-- ----------------------------
-- Procedure structure for `ChangePassword`
-- ----------------------------
DROP PROCEDURE IF EXISTS `ChangePassword`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `ChangePassword`(IN `User` char(32),IN `Pass` varchar(20))
BEGIN
   UPDATE Accounts SET Password = Pass WHERE Username = User;
END
;;
DELIMITER ;

-- ----------------------------
-- Procedure structure for `FullLogin`
-- ----------------------------
DROP PROCEDURE IF EXISTS `FullLogin`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `FullLogin`(IN `User` char(32),IN  `Pass` char(20))
BEGIN
  select ID from Accounts where Username = User and Password = Pass;
END
;;
DELIMITER ;

-- ----------------------------
-- Procedure structure for `GetItems`
-- ----------------------------
DROP PROCEDURE IF EXISTS `GetItems`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `GetItems`(IN `pID` smallint, IN `bool` tinyint)
BEGIN
	select * from Items where PlayerID = pID and IsEquipment = bool;
END
;;
DELIMITER ;

-- ----------------------------
-- Procedure structure for `GetPlayer`
-- ----------------------------
DROP PROCEDURE IF EXISTS `GetPlayer`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `GetPlayer`(IN `uID` int, IN `pName` char(20))
BEGIN
     select * from Players where UserID = uID and Name = pName;
END
;;
DELIMITER ;

-- ----------------------------
-- Procedure structure for `GetPlayers`
-- ----------------------------
DROP PROCEDURE IF EXISTS `GetPlayers`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `GetPlayers`(IN `uID` int)
BEGIN
     select * from Players where UserID = uID;
END
;;
DELIMITER ;

-- ----------------------------
-- Procedure structure for `Login`
-- ----------------------------
DROP PROCEDURE IF EXISTS `Login`;
DELIMITER ;;
CREATE DEFINER=`root`@`localhost` PROCEDURE `Login`(IN User char(32))
BEGIN
  select ID,Password from Accounts where Username = User;
END
;;
DELIMITER ;