/*
Navicat MySQL Data Transfer

Source Server         : Local
Source Server Version : 50612
Source Host           : localhost:3306
Source Database       : ishop

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

Date: 2014-03-14 13:39:12
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for account_bonus
-- ----------------------------
DROP TABLE IF EXISTS `account_bonus`;
CREATE TABLE `account_bonus` (
  `id` int(50) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `price` int(250) NOT NULL,
  `type` enum('DC','MD') NOT NULL DEFAULT 'DC',
  `bonus_type` enum('silver_expire','gold_expire','money_drop_rate_expire','marriage_fast_expire','fish_mind_expire','autoloot_expire','safebox_expire') NOT NULL,
  `description` mediumtext NOT NULL,
  `big_description` mediumtext NOT NULL,
  `img_url` varchar(255) DEFAULT NULL,
  `img_url_big` varchar(255) DEFAULT NULL,
  `time` int(255) DEFAULT NULL,
  `visible` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for bonus_costume
-- ----------------------------
DROP TABLE IF EXISTS `bonus_costume`;
CREATE TABLE `bonus_costume` (
  `bonus_id` int(10) NOT NULL,
  `value_bonus` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for buy_log
-- ----------------------------
DROP TABLE IF EXISTS `buy_log`;
CREATE TABLE `buy_log` (
  `account_id` int(50) NOT NULL,
  `item_id` int(50) NOT NULL,
  `item_count` int(50) NOT NULL,
  `date` bigint(50) NOT NULL,
  `ip` varchar(250) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for categorie
-- ----------------------------
DROP TABLE IF EXISTS `categorie`;
CREATE TABLE `categorie` (
  `id_cat` int(10) NOT NULL AUTO_INCREMENT,
  `name_cat` varchar(255) NOT NULL,
  `type_cat` enum('MD','DC') NOT NULL DEFAULT 'DC',
  PRIMARY KEY (`id_cat`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for item_list
-- ----------------------------
DROP TABLE IF EXISTS `item_list`;
CREATE TABLE `item_list` (
  `item_id` int(50) NOT NULL AUTO_INCREMENT,
  `item_vnum` int(50) NOT NULL,
  `item_name` varbinary(255) NOT NULL,
  `item_count` int(10) DEFAULT NULL,
  `item_count2` int(10) DEFAULT NULL,
  `item_count3` int(10) DEFAULT NULL,
  `item_count4` int(10) DEFAULT NULL,
  `item_desc` mediumtext CHARACTER SET latin1 NOT NULL,
  `item_desc_big` mediumtext NOT NULL,
  `item_type` enum('MD','DC') CHARACTER SET latin1 NOT NULL,
  `item_img` varchar(255) CHARACTER SET latin1 NOT NULL,
  `item_img_big` varchar(255) CHARACTER SET latin1 NOT NULL,
  `item_cat` int(50) NOT NULL,
  `item_price` int(50) DEFAULT NULL,
  `item_price2` int(50) DEFAULT NULL,
  `item_price3` int(50) DEFAULT NULL,
  `item_price4` int(50) DEFAULT NULL,
  `item_stack` int(1) NOT NULL,
  `item_sexe_restrict` enum('FEMALE','NONE','MALE') CHARACTER SET latin1 DEFAULT NULL,
  `item_race_restrict` enum('ASSASSIN','SHAMANE','SURA','NONE','WARRIOR') CHARACTER SET latin1 DEFAULT NULL,
  `item_level_restrict` int(50) DEFAULT NULL,
  `item_time` int(50) DEFAULT NULL,
  `item_time_socket` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `item_costume_bonus` int(10) DEFAULT NULL,
  `item_visible` int(10) NOT NULL,
  PRIMARY KEY (`item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for select_char
-- ----------------------------
DROP TABLE IF EXISTS `select_char`;
CREATE TABLE `select_char` (
  `account_id` int(50) NOT NULL,
  `pid_id` int(50) NOT NULL,
  PRIMARY KEY (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
