/*
 Navicat MySQL Data Transfer

 Source Server         : 127.0.0.1
 Source Server Version : 50621
 Source Host           : localhost
 Source Database       : nhooo

 Target Server Version : 50621
 File Encoding         : utf-8

 Date: 05/13/2017 19:07:12 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `nhooo_tbl`
-- ----------------------------
DROP TABLE IF EXISTS `nhooo_tbl`;
CREATE TABLE `nhooo_tbl` (
  `nhooo_id` int(11) NOT NULL AUTO_INCREMENT,
  `nhooo_title` varchar(100) NOT NULL,
  `nhooo_author` varchar(40) NOT NULL,
  `submission_date` date DEFAULT NULL,
  PRIMARY KEY (`nhooo_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `nhooo_tbl`
-- ----------------------------
BEGIN;
INSERT INTO `nhooo_tbl` VALUES ('1', '学习 PHP', '基础教程', '2017-04-12'), ('2', '学习 MySQL', '基础教程', '2017-04-12'), ('3', '学习 Java', 'NHOOO.COM', '2015-05-01'), ('4', '学习 Python', 'NHOOO.COM', '2016-03-06'), ('5', '学习 C', 'FK', '2017-04-05');
COMMIT;

-- ----------------------------
--  Table structure for `tcount_tbl`
-- ----------------------------
DROP TABLE IF EXISTS `tcount_tbl`;
CREATE TABLE `tcount_tbl` (
  `nhooo_author` varchar(255) NOT NULL DEFAULT '',
  `nhooo_count` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `tcount_tbl`
-- ----------------------------
BEGIN;
INSERT INTO `tcount_tbl` VALUES ('基础教程', '10'), ('NHOOO.COM ', '20'), ('Google', '22');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
