db_bug.sql

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
Navicat MySQL Data Transfer

Source Server         : 111
Source Server Version : 50051
Source Host           : localhost:3306
Source Database       : db_bug

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

Date: 2017-09-06 09:07:14
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `t_bug`
-- ----------------------------
DROP TABLE IF EXISTS `t_bug`;
CREATE TABLE `t_bug` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(500) default NULL,
  `content` varchar(500) default NULL,
  `status` varchar(500) default NULL,
  `user_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_bug
-- ----------------------------
INSERT INTO `t_bug` VALUES ('1', '1111111111111111113', '111111111111111111333', '待修复', '1');
INSERT INTO `t_bug` VALUES ('2', '测试测试bug内容提交', '试测试bug内容提交试测试bug内容提交试测试bug内容提交', '待修复', '1');
INSERT INTO `t_bug` VALUES ('4', '666666666666', '11', '待修复', '1');
INSERT INTO `t_bug` VALUES ('6', '不能填加', '填加数据出错.', '待修复', '1');

-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(500) default NULL,
  `password` varchar(500) default NULL,
  `name` varchar(500) default NULL,
  `job` varchar(50) default NULL,
  `email` varchar(50) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES ('1', 'liusan', '000000', '刘三', '测试员', 'liusan@yahoo.cn');