[Release] Ivillis Flyff Website

/*
Navicat MySQL Data Transfer

Source Server         : root
Source Server Version : 50527
Source Host           : localhost:3306
Source Database       : flyff2

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

Date: 2013-05-18 02:17:47
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `acc_flyff`
-- ----------------------------
DROP TABLE IF EXISTS `acc_flyff`;
CREATE TABLE `acc_flyff` (
  `af_id` int(11) NOT NULL AUTO_INCREMENT,
  `u_id` int(11) NOT NULL,
  `acc_id` varchar(32) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`af_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of acc_flyff
-- ----------------------------

-- ----------------------------
-- Table structure for `activations`
-- ----------------------------
DROP TABLE IF EXISTS `activations`;
CREATE TABLE `activations` (
  `a_id` int(11) NOT NULL AUTO_INCREMENT,
  `u_id` int(11) DEFAULT NULL,
  `a_string` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
  PRIMARY KEY (`a_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of activations
-- ----------------------------

-- ----------------------------
-- Table structure for `beta_register`
-- ----------------------------
DROP TABLE IF EXISTS `beta_register`;
CREATE TABLE `beta_register` (
  `a_id` int(11) NOT NULL AUTO_INCREMENT,
  `a_email` text,
  `a_key` varchar(26) DEFAULT NULL,
  PRIMARY KEY (`a_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of beta_register
-- ----------------------------

-- ----------------------------
-- Table structure for `cash_history`
-- ----------------------------
DROP TABLE IF EXISTS `cash_history`;
CREATE TABLE `cash_history` (
  `ch_id` int(11) NOT NULL AUTO_INCREMENT,
  `u_id` int(11) NOT NULL,
  `ch_cash_before` int(11) NOT NULL,
  `ch_cash_after` int(11) NOT NULL,
  `ch_cash_diff` int(11) NOT NULL,
  `ch_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ch_reason` varchar(128) NOT NULL,
  PRIMARY KEY (`ch_id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cash_history
-- ----------------------------

-- ----------------------------
-- Table structure for `shop_items`
-- ----------------------------
DROP TABLE IF EXISTS `shop_items`;
CREATE TABLE `shop_items` (
  `si_id` int(11) NOT NULL AUTO_INCREMENT,
  `si_item_id` int(11) NOT NULL,
  `si_item_cnt` int(11) NOT NULL DEFAULT '1',
  `si_name` varchar(32) NOT NULL,
  `si_desc` text NOT NULL,
  `si_price` int(11) NOT NULL,
  `si_cat` int(11) NOT NULL DEFAULT '1',
  `si_icon` varchar(32) NOT NULL DEFAULT 'img/item/default.png',
  `si_kind` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`si_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shop_items
-- ----------------------------

-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `u_id` int(11) NOT NULL AUTO_INCREMENT,
  `u_name` varchar(16) CHARACTER SET latin1 DEFAULT NULL,
  `u_password` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
  `u_email` text CHARACTER SET latin1,
  `u_secret_question` varchar(64) CHARACTER SET latin1 DEFAULT NULL,
  `u_secret_answer` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
  `u_regDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `u_lastLogin` datetime DEFAULT NULL,
  `u_session` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
  `u_cash` int(11) DEFAULT '0',
  `u_cash2` int(11) DEFAULT '0',
  `u_lvl` int(11) DEFAULT NULL,
  `u_banned` int(11) DEFAULT NULL,
  `u_vote1` datetime DEFAULT NULL,
  `u_vote2` datetime DEFAULT NULL,
  `u_vote3` datetime DEFAULT NULL,
  `u_beta` int(2) DEFAULT '0',
  PRIMARY KEY (`u_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of users
-- ----------------------------