text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : localhost
  Source Server Version : 50621
  Source Host           : localhost:3306
  Source Database       : name_info
  
  Target Server Type    : MYSQL
  Target Server Version : 50621
  File Encoding         : 65001
  
  Date: 2015-05-01 10:54:35
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for name
  -- ----------------------------
  DROP TABLE IF EXISTS `name`;
  CREATE TABLE `name` (
    `num` int(5) NOT NULL,
    `epic` varchar(10) NOT NULL,
    `name` varchar(50) NOT NULL,
    `url` varchar(50) NOT NULL,
    `sector` varchar(100) NOT NULL,
    `industory` varchar(100) NOT NULL,
    PRIMARY KEY (`num`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Table structure for name100
  -- ----------------------------
  DROP TABLE IF EXISTS `name100`;
  CREATE TABLE `name100` (
    `num` int(5) NOT NULL,
    `epic` varchar(10) NOT NULL,
    `name` varchar(50) NOT NULL,
    `url` varchar(50) NOT NULL,
    `sector` varchar(100) NOT NULL,
    `industory` varchar(100) NOT NULL,
    PRIMARY KEY (`num`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  