/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50505
Source Host           : localhost:3306
Source Database       : energybasedb

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

Date: 2016-08-09 10:05:11
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for hisdata
-- ----------------------------
DROP TABLE IF EXISTS `hisdata`;
CREATE TABLE `hisdata` (
  `userID` varchar(150) NOT NULL,
  `stage` varchar(150) NOT NULL,
  `saveTime` datetime NOT NULL,
  `data` mediumtext NOT NULL,
  `operation` varchar(255) NOT NULL,
  PRIMARY KEY (`userID`,`stage`,`saveTime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of hisdata
-- ----------------------------

-- ----------------------------
-- Table structure for operationtable
-- ----------------------------
DROP TABLE IF EXISTS `operationtable`;
CREATE TABLE `operationtable` (
  `userid` varchar(150) NOT NULL,
  `stage` varchar(150) NOT NULL,
  `operation` varchar(255) NOT NULL,
  `data` text,
  PRIMARY KEY (`userid`,`stage`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of operationtable
-- ----------------------------
INSERT INTO `operationtable` VALUES ('Hntj', 'a', 'non', '');