/*
Navicat MySQL Data Transfer

Source Server         : ali
Source Server Version : 50527
Source Host           : 119.23.28.196:3306
Source Database       : zhihu_ssm

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

Date: 2019-07-12 14:26:42
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `answer`
-- ----------------------------
DROP TABLE IF EXISTS `answer`;
CREATE TABLE `answer` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `uid` int(30) DEFAULT NULL,
  `content` text COLLATE utf8_bin,
  `good_num` int(40) DEFAULT NULL,
  `bad_num` int(40) DEFAULT NULL,
  `comment_num` int(40) DEFAULT NULL,
  `collect` int(40) DEFAULT NULL,
  `time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `question_id` int(10) DEFAULT NULL,
  `answer_img` varchar(400) COLLATE utf8_bin DEFAULT NULL,
  `answer_state` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `articleid` (`uid`),
  KEY `question_answer` (`question_id`),
  CONSTRAINT `articleid` FOREIGN KEY (`uid`) REFERENCES `user` (`id`),
  CONSTRAINT `question_answer` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of answer
-- ----------------------------
INSERT INTO `answer` VALUES ('1', '1', 0xE5B9B4E896AA343077E5B7B2E7BB8FE7AE97E5BE88E9AB98E79A84E4BA86EFBC8CE68891E8A789E5BE97E8BF99E4B8AAE4B89CE8A5BFE5BE88E99ABEE5AE9AE4B989E38082E69C89E5BE88E5A49AE5BA94E5B18AE7949FE587ADE5809FE887AAE5B7B1E4B8B0E5AF8CE79A84E9A1B9E79BAEE7BB8FE58E86E38081E4B88DE99499E79A84E5ADA6E6A0A1E587BAE7949FE38081E59CA8E4B880E4BA9BE590ABE98791E9878FE6AF94E8BE83E9AB98E79A84E6AF94E8B59BE88EB7E5A596E79A84E7BB8FE58E86E68BBFE588B0E4BA86E5A4A7E58E827370E68896E88085737370E79A846F66666572E79A84E896AAE8B584E5B0B1E68EA5E8BF91E8BF99E4B8AAE695B0E4BA86E38082E4B88DE8BF874A617661E5BC80E58F91E5BA94E5B18AE7949FE79A84E896AAE8B584E8BF98E698AFE8A681E6AF94E7AE97E6B395E5B297E5B7A5E8B584E7A88DE5BEAEE890BDE5908EE4B880E782B9E38082, '12', '2', '5', '3', '2019-07-12 10:30:55', '1', '', '0');
INSERT INTO `answer` VALUES ('2', '3', 0xE79C9FE79A84E698AF2034307720E79A84E8AF9DEFBC8CE4B99FE4B88DE4BB85E4BB85E698AF204A61766120E79A84E79FA5E8AF86E5928CE7BB8FE9AA8CE79A84E4BBB7E580BCEFBC8CE8808CE698AFE8BF99E4B8AAE4BABAE79A84E7BBBCE59088E883BDE58A9BE79A84E4BBB7E580BCE380820D0AE4BDA0E68980E79C8BE588B0E79A842034307720E5B9B4E896AAE79A84204A61766120E4BB8EE4B89AE88085EFBC8CE4BDBFE794A8204A61766120E58FAAE698AF20E5BE88E8A1A8E99DA2E79A84E4B880E4B8AAE789B9E5BE81E380820D0A0D0AE4BBA5E4BDA0E79A84E4BE8BE5AD90EFBC8CE88BA5E68DA2E4B8AAE8A792E5BAA6EFBC8CE698AFE4B88DE698AFE58F88E8A681E997AEEFBC8CE6909EE5B9B6E58F91E79A84EFBC8CE5A682E4BD95E8BEBEE588B02034307720E5B9B4E896AAEFBC9F, '9', '6', '5', '5', '2019-07-12 11:55:12', '2', 'test123.jpg', '1');
INSERT INTO `answer` VALUES ('3', '2', 0xE4B880EFBC8CE5BD93E4B880E8BE86E6B1BDE8BDA6E6B1BDE8BDA6E796BEE9A9B0E8808CE69DA5E697B6EFBC8C0D0A0D0AE4B88DE7BB83E7AFAEE79083E79A84E4BABAE69292E885BFE5B0B1E8B791E380820D0A0D0AE7BB83E7AFAEE79083E79A84E4BABAE58F8CE6898BE5BCA0E5BC80EFBC8CE4B8A4E885BFE5BEAEE69BB2EFBC8CE59CA8E8A2ABE6B1BDE8BDA6E6929EE9A39EE697B6E4B880E8BEB9E58FA3E59090E9B29CE8A180E4B880E8BEB9E5A4A7E5968AEFBC8CE8BF9BE694BBE78AAFE8A784EFBC8120202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020202020200D0A0D0AE4BA8CEFBC8CE9AB98E7A9BAE59DA0E789A9E697B6E4B88DE7BB83E7AFAEE79083E79A84E4BABAE5BFABE9809FE8BAB2E5BC80E38082E7BB83E7AFAEE79083E79A84E4BABAE59091E59DA0E789A9E7A7BBE58AA8EFBC8CE8B5B7E8B7B3EFBC8CE58D95E6898BE691B8E588B0E59DA0E789A9E8AF95E59BBEE5B086E585B6E69082E59CA8E68080E9878CE38082E6898BE88782E4B880E8BEB9E596B7E8A180E4B880E8BEB9E5A4A7E5968AEFBC8CE5A5BDE69DBF, '12', '4', '3', '4', '2019-07-12 14:09:08', '3', 'test123.jpg', '1');
INSERT INTO `answer` VALUES ('4', '1', 0xE59DA4E59DA4E59DA420E59DA4E59DA4E59DA420E59DA4E59DA4E59DA420E59DA4E59DA4E59DA4, '4', '1', '1', '3', '2019-07-12 11:55:17', '3', 'jamsleams.jpg', '1');
INSERT INTO `answer` VALUES ('5', '2', 0xE6B996E4BABAE680BBE586A0E5869BE59180, '6', '1', '3', '2', '2019-07-12 11:55:21', '2', '20190711173725.jpg', '1');
INSERT INTO `answer` VALUES ('6', '2', 0xE58EA6E997A8E7BE8EE9A39F, '10', '3', '2', '1', '2019-07-12 11:55:25', '8', '20190711173725.jpg', '1');
INSERT INTO `answer` VALUES ('8', '5', 0xE4B88EE4BABAE7B1BBE79A84E68898E4BA89E5B7B2E7BB8FE8BF9BE8A18CE4BA86E4BA94E4B8AAE5A49AE6989FE69C9FE4BA86EFBC8C3430E4BD99E5A4A9E4BBA5E69DA5EFBC8CE68891E4BBACE697A0E697B6E697A0E588BBE4B88DE68BBCE5B0BDE887AAE5B7B1E79A84E7949FE591BDEFBC8CE59B9EE9A696E69C9BE58EBBEFBC8CE58B87E6B094E58FAFE59889EFBC8CE58DB4E58FAAE698AFE4B880E59CBAE7A9BAE8808CE5B7B2E380822020202020202020202020202020202020202020202020202020E28094E28094E78CB4E5AD90E983A8EFBC8CE799BEE5B281E995BFE88081E38082E4BA8BE68385E8B5B7E6BA90E4BA8EE4B880E58FAAE68890E4BA86E7B2BEE79A84E78CB4E5AD90EFBC8CE5AE83E8AFBBE4BA86E8B584E69CACE8AEBAE38082E5A4A7E5AEB6E983BDE79FA5E98193EFBC8CE78CB4E5AD90E8B79FE4BABAE7B1BBE69C89E79BB8E5908CE79A84E7A596E5AE97EFBC8CE79086E8AEBAE4B88AE8AEB2EFBC8CE78CB4E5AD90E4B99FE69C89E58F98E5BC82E587BAE4BABAE7B1BBE699BAE58A9BE79A84E58FAFE883BDE680A7E38082E8BF99E5A4A9EFBC8CE78CB4E5AD90E7B2BEE6898BE4B8ADE68FA1E79D80E58E9AE58E9AE79A84E4B889E58DB7E69CACE8B584E69CACE8AEBAEFBC8CE884B8E5BA9EE6969C3435C2B0E69C9DE79D80E5A4A9E7A9BAEFBC8CE58F8CE79CBCE59CA8E6989FE8BEB0E79A84E785A7E88080E4B88BE997AAE78381E79D80E58589E88A92E38082E2809CE4BABAE7B1BBEFBC8CE4B880E79BB4E4BBA5E69DA5E983BDE59CA8E58E8BE6A6A8E79D80E58AA8E789A9E4BBACE79A84E589A9E4BD99E4BBB7E580BCE38082E2809DE6ADA4E8AF9DE4B880E587BAEFBC8CE58AA8E789A9E7958CE697A0E4B88DE99C87E6838AEFBC8CE78BAEE5AD90E38081E88081E8998EE4BBA5E887B3E4BA8EE69886E899ABE983BDE7BAB7E7BAB7E7BFBBE8AF91E4BA86E78CB4E5AD90E7B2BEE587BAE78988E79A84E3808AE4BABAE7B1BBE8AEBAE3808BEFBC8CE58AA8E789A9E7958CE4BB8EE6ADA4E8A789E98692EFBC8CE99DA9E591BDE79A84E6B5AAE6BDAEE59CA8E4B896E7958CE88C83E59BB4E58685E7BFBBE6B68CEFBC8CE58AA8E789A9E4BBACE983BDE98089E68BA9E8B79FE99A8FE4BC9FE5A4A7E79A84E99DA9E591BDE5AFBCE5B888E78CB4E5AD90E7B2BEEFBC8CE5968AE587BAE982A3E58FA5E68CAFE5A58BE4BABAE5BF83E79A84E58FA3E58FB7EFBC9AE2809CE585A8E4B896E7958CE79A84E58AA8E789A9E4BBACEFBC8CE88194E59088E8B5B7E69DA5EFBC81E2809DE78CB4E5AD90E983A8E899BDE784B6E6AF94E8BE83E881AAE6988EEFBC8CE4BD86E698AFE68898E69697E58A9BE6AF94E8B5B7E78BAEE5AD90E983A8E5928CE88081E8998EE983A8E58DB4E698AFE79BB8E5B7AEE7949AE8BF9CE38082E59BA0E6ADA4EFBC8CE68898E4BA89E4B98BE5889DEFBC8CE78BAEE5AD90E4B88EE88081E8998EE58588E8BF9BE8A18CE4BA86E4B880E59CBAE7A7B0E99CB8E4B98BE4BA89EFBC8CE69C80E5908EE794B1E88081E8998EE5A4BAE5BE97E9B38CE5A4B4EFBC8CE5819AE4BA86E58AA8E789A9E88194E5869BE79A84E680BBE58FB8E4BBA4E38082E8998EE78E8BEFBC9AE2809CE68891E4BBACE7BCBAE5B091E4B880E4B8AAE5869BE5B888E38082E2809DE78CB4E7B2BEEFBC9AE2809CE68891E58FAFE4BBA5E4B8BAE5A4A7E78E8BE68EA8E4B8BEE4B880E983A8E38082E2809DE8998EE78E8BEFBC9AE2809CE593AAE4B880E983A8E58FAFE4BBA5E68B85E5BD93E6ADA4E9878DE4BBBBEFBC9FE2809DE78CB4E7B2BEE7AC91E8808CE4B88DE7AD94EFBC8CE68B8DE4BA86E68B8DE6898BEFBC8CE998B4E5BDB1E5A484E8B5B0E587BAE4B880E69DA1E9BB91E799BDE79BB8E997B4E79A84E78B97E69DA5E38082E79C8BE982A3E78B97EFBC8CE58F8CE79CBCE7B2BEE7A59EEFBC8CE8B5B0E8B7AFE7949FE9A38EE38082E4B8AAE5A4B4E4B88DE5A682E8998EE78E8BEFBC8CE58DB4E4B88EE78BBCE69C89E4B889E58886E79BB8E4BCBCE38082E79C9FE698AFE4B880E4B8AAE5A5BDE5869BE5B888EFBC81E78B97E68AABE79D80E4B880E8BAABE79B94E794B2EFBC8CE8B7AAE58092E59CA8E59CB0EFBC8CEFBC9AE2809CE68B9CE8A781E8998EE78E8BEFBC81E2809DE8998EE78E8BE8A781E4BA86EFBC8CE694BEE5A3B0E5A4A7E7AC91EFBC9AE2809CE5A4A9E58AA9E68891E4B99FEFBC81E5A4A9E58AA9E68891E4B99FEFBC81E68891E5B081E4BDA0E4B8BAE2809CE78B97E5A4B4E5869BE5B888E2809DEFBC8CE5A682E4BD95EFBC9FE2809DE78B97E590ACE4BA86EFBC8CE6849FE681A9E688B4E5BEB7EFBC9AE2809CE68891E887AAE5B9BCE4B88EE4BABAE7B1BBE7949FE6B4BBE59CA8E4B880E8B5B7EFBC8CE4BB96E4BBACE697A0E697B6E697A0E588BBE4B88DE6ACBAE8BEB1E68891EFBC8CE7AB9FE4B8BAE68891E8B5B7E4BA86E2809CE59388E5A3ABE5A587E2809DE8BF99E4B988E4B880E4B8AAE5908DE5AD97EFBC8CE68891E5AE9EE59CA8E4B88DE79498E38082E4BB8AE5A4A9EFBC8CE5A4A7E78E8BE684BFE5B081E68891E5819AE78B97E5A4B4E5869BE5B888EFBC8CE68891E4B880E5AE9AE69588E78B97E78B97E4B98BE58AB3EFBC8CE4B8BAE5A4A7E78E8BE8B5B4E6B1A4E8B988E781ABEFBC8CE59CA8E68980E4B88DE8BE9EEFBC81E2809DE4BA8EE698AFEFBC8CE59388E5A3ABE5A587E4BD9CE4B8BAE58AA8E789A9E88194E5869BE79A84E78B97E5A4B4E5869BE5B888EFBC8CE8998EE78E8BE4BD9CE4B8BAE680BBE58FB8E4BBA4EFBC8CE78BBCE983A8E4BD9CE4B8BAE58588E9948BEFBC8CE78BAEE5AD90E983A8E38081E8B1B9E983A8E38081E9B9B0E983A8E7AD89E7AD89E799BEE4BD99E983A8E5819AE4BA86E4B8BBE58A9BE5869BEFBC8CE4B880E4B8AAE5AE9EE58A9BE5BCBAE6A8AAE79A84E789A9E7A78DE88194E5869BE5BBBAE7AB8BE8B5B7E69DA5E4BA86E38082E8B5B7E5889DEFBC8CE789A9E7A78DE88194E5869BE59CA8E99D9EE6B4B2E68993E5BC80E4BA86E5B180E99DA2EFBC8CE99D9EE6B4B2E983A8E890BDE7BCBAE5B091E998B2E5A487E68EAAE696BDEFBC8CE789A9E7A78DE88194E5869BE58FAAE99C80E8A681E58F91E8B5B7E586B2E9948BE5B0B1E883BDE5A587E8A2ADE4B880E4B8AAE983A8E890BDEFBC8CE4BABAE7B1BBE4B880E697B6E997B4E69D9FE6898BE697A0E68EAAE38082E79C8BE79D80E59084E5AEB6E789A9E7A78DE58F96E5BE97E7BAB7E7BAB7E68898E58A9FEFBC8CE89A8AE5AD90E983A8E9878CE587A0E4B8AAE9A286E5A4B4E79A84E7A781E4B88BE9878CE59586E8AEAEE38082E4B880E58FAAE89A8AE5AD90E8AFB4EFBC9AE2809CE68891E4BBACE89A8AE5AD90E983A8E699BAE58A9BE4B88DE5BCB1E4BA8EE78CB4E7B2BEEFBC8CE68898E69697E58A9BE4B88DE5BCB1E4BA8EE8998EE78BAEEFBC8CE4B8BAE4BD95E68898E58A9FE6B2A1E69C89E68891E4BBACE79A84EFBC9FE2809DE58FA6E4B880E58FAAE89A8AE5AD90E59B9EE7AD94EFBC9AE2809CE68891E4BBACE79A84E4BD9CE794A8E899BDE5A4A7EFBC8CE58FAFE698AFE58FAAE59CA8E4BA8EE581B7E8A2ADE4B88EE587BAE585B6E4B88DE6848FEFBC8CE5B9B6E4B88DE5A682E8998EE78BAEE6ADA3E99DA2E99CB2E99DA2EFBC8CE58FAFE4BBA5E689ACE5908DE38082E2809DE4BA8EE698AFEFBC8CE89A8AE5AD90E6B4BEE981A3E4BDBFE88085EFBC8CE58EBBE8998EE78E8BE5A484E98280E58A9FEFBC8CE58DB4E8A2ABE8998EE78E8BE788AAE68B8DE6ADBBEFBC8CE2809CE5BCB1E89A8AE8808CE5B7B2EFBC8CE4B99FE695A2E98280E58A9FEFBC9FE2809DE89A8AE5AD90E983A8E4BB8EE6ADA4E5BF83E68080E681A8E6848FE38082E4B880E5A4A9EFBC8CE89A8AE78E8BE6ADA3E78BACE887AAE5969DE79D80E997B7E98592EFBC8CE997A8E58FA3E58FBDE58FBDE79A84E587A0E5A3B0E8B791E69DA5E4B880E58FAAE88081E9BCA0EFBC8CE58E9FE69DA5EFBC8CE698AFE4B88EE89A8AE5AD90E983A8E5908CE79785E79BB8E6809CE79A84E88081E9BCA0E983A8EFBC8CE88081E9BCA0E983A8E59CA8E5A49CE997B4E581B7E8A2ADE4BABAE7B1BBEFBC8CE7BB99E4BABAE7B1BBE980A0E68890E5A4A7E9878FE4BCA4E4BAA1E38082E58FAFE698AFEFBC8CE8998EE78E8BE58DB4E68A8AE58A9FE58AB3E58AA0E7BB99E8998EE78BAEE78BBCE7AD89E5A4A7E59E8BE58AA8E789A9EFBC8CE58886E6988EE698AFE68A8AE585B6E4BB96E58AA8E789A9E68E92E587BAE59CA8E5A496E4BA86E38082E2809CE89A8AE78E8BE8BF91E69DA5E58FAFE5A5BDEFBC9FE2809DE9BCA0E78E8BE997AEE38082E2809CE5A5BDE38082E2809DE89A8AE78E8BE8AFB4E38082E2809CE8998EE78E8BE5BE85E4BDA0E58FAFE585ACE5B9B3EFBC9FE2809DE9BCA0E78E8BE58F88E997AEE38082E2809CE8998EE78E8BE88BB1E6988EE79B96E4B896EFBC8CE5BE85E68891E7949AE698AFE585ACE5B9B3E38082E2809DE89A8AE78E8BE594AFE594AFE8AFBAE8AFBAE38082E58FAAE8A781E9BCA0E78E8BEFBC8CE4B880E68B8DE6A18CE5AD90EFBC8CE5A4A7E5969DEFBC9AE2809CE68891E590ACE997BBE89A8AE78E8BE88BB1E58B87E697A0E6958CEFBC8CE4B8BAE4BD95E4BB8AE697A5E8A681E7958FE7958FE7BCA9E7BCA9EFBC8CE4B88DE695A2E8AEB2E5AE9EE8AF9DEFBC81EFBC9FE2809DE89A8AE78E8BE995BFE58FB9EFBC9AE2809CE68891E4B880E7949FE58FAEE592ACE4BABAE7B1BBEFBC8CE4BCA0E692ADE796BEE79785EFBC8CE7BB99E4BABAE7B1BBE980A0E68890E5B7A8E5A4A7E68D9FE5A4B1EFBC8CE58FAFE5A682E4BB8AE280A6E280A6E59489EFBC8CE8B081E883BDE4B88DE681A8EFBC9FE5A588E4BD95E89A8AE5AD90E983A8E5AE9EE58A9BE4B88DE5A682E8998EE983A8EFBC8CE697A0E4BB8EE58F8DE68A97E38082E2809DE9BCA0E78E8BE68AACE5A4B4E5A4A7E7AC91EFBC8CEFBC9AE2809CE5A5BDEFBC81E5A5BDEFBC81E58FAAE8A681E89A8AE78E8BE69C89E8BF99E4BBBDE5BF83EFBC8CE68891E887AAE5BD93E9BC8EE58A9BE79BB8E58AA9EFBC81E2809DE5A4A7E68898E5889DE69C9FEFBC8CE789A9E7A78DE88194E5869BE68898E69E9CE8BE89E7858CEFBC8CE58FAAE698AFE7ACACE4BA8CE591A8EFBC8CE58F91E7949FE4BA86E4B880E4BBB6E4BA8BE38082E78BBCE983A8E59083E4BA86E7BE8AE983A8E79A84E7BE8AE38082E7BE8AE983A8E8AEA4E4B8BAEFBC8CE697A2E784B6E983BDE698AFE88194E5869BE4B8ADE79A84E4B880E983A8E58886EFBC8CE4B88DE8AFA5E5868DE5838FE4BBA5E5898DE4B880E6A0B7E887AAE79BB8E6AE8BE69D80EFBC8CE59BA0E6ADA4E58EBBE8998EE78E8BE5A484E8AF89E88BA6E38082E58FAFE588B0E4BA86E8998EE78E8BE79A84E890A5E5B890EFBC8CE58DB4E79C8BE8A781E8998EE78E8BE6ADA3E58FBCE79D80E4B880E6A0B9E7BE8AE885BFE59CA8E59583EFBC8CE4BA8EE698AFE4B98EEFBC8CE7BE8AE983A8E7A781E4B88BE9878CE88194E59088E585B6E4BB96E9A39FE88D89E58AA8E789A9EFBC8CE4B99FE69C89E4BA86E58F8DE58F9BE4B98BE5BF83E38082E68898E4BA89E588B0E4BA86E7ACACE58D81E5A4A9EFBC8CE4BABAE7B1BBE5B7B2E7BB8FE59B9EE8BF87E7A59EE69DA5EFBC8CE8B083E981A3E5869BE9989FEFBC8CE68AB5E68A97E789A9E7A78DE88194E5869BE38082E8998EE78BAEE899BDE5BCBAEFBC8CE58FAFE698AFE5BCBAE4B88DE8BF87E69EAAE782AEE992A2E99381EFBC8CE59BA0E6ADA4E68898E4BA89E5B1A1E68898E5B1A1E8B4A5E38082E8BF99E5A4A9EFBC8CE9BCA0E38081E89A8AE38081E7BE8AE38081E9B9BFE7AD89E983A8E79BB8E8819AE4B880E5A484EFBC8CE59586E8AEA8E58F8DE58F9BE5A4A7E4BA8BE38082E89A8AE78E8BEFBC9AE2809CE69C89E58F8DE58F9BE4B98BE5BF83EFBC8CE5A588E4BD95E697A0E58F8DE58F9BE4B98BE58A9BE38082E2809DE7BE8AE78E8BEFBC9AE2809CE4B8BAE4B98BE5A588E4BD95EFBC9FE2809DE9B9BFE78E8BE38081E78CAAE78E8BE7AD89E79A86E58FB9E681AFE38082E58FAAE8A781E9BCA0E78E8BE5B9B6E4B88DE6B2AEE4B8A7EFBC8CE8AFB4EFBC9AE2809CE8AFB8E78E8BE4B88DE5BF85E4B8A7E6B094E38082E2809DE8AFB8E78E8BE5BC82E58FA3E5908CE5A3B0EFBC9AE2809CE9BCA0E78E8BE69C89E4BB80E4B988E58A9EE6B395EFBC9FE2809DE8AF9DE99FB3E69CAAE890BDEFBC8CE58FAAE8A781E8BF9CE696B9E4B880E69E9DE9BB91E58E8BE58E8BE79A84E5869BE9989FEFBC8CE6BCABE5A4A9E9BB91E889B2EFBC8CE4BCBCE4B98EE883BDE591BCE9A38EE594A4E99BA8E38082E79C9FE698AFE4B880E694AFE5BCBAE5869BEFBC81E883BDE9A39EE5A4A9EFBC8CE883BDE98181E59CB0E38082E7A6BBE8BF91E4BA86EFBC8CE58E9FE69DA5E698AFE89F91E89E82E983A8EFBC81E8AFB8E78E8BE79A86E99DA2E99CB2E7AC91E6848FEFBC8CEFBC9AE2809CE69C89E6ADA4E5869BE9989FEFBC8CE4B88DE68481E697A0E58A9FE38082E2809DE68898E4BA89E7ACACE4B889E591A8EFBC8CE789A9E7A78DE88194E5869BE6ADA3E99DA2E68898E59CBAE88A82E88A82E6BA83E8B4A5EFBC8CE8998EE78E8BE5B7B2E6B2A1E69C89E883BDE58A9BE4B88EE4BABAE7B1BBE4B880E68898EFBC8CE4BA8EE698AFE8998EE78E8BE695B4E5A4A9E9A5AEE98592E4BD9CE4B990EFBC8CE4B88DE79086E68898E4BA8BEFBC8CE8808CE9BCA0E78E8BE6ADA4E697B6EFBC8CE5B7B2E69C89E4BA86E69D80E5BF83E38082E5A4A7E5AEB6E983BDE79FA5E98193EFBC8CE8998EE78E8BE788B1E59083E7BE8AE885BFE38082E4B8BAE4BA86E68EA5E8BF91E8998EE78E8BEFBC8CE6B688E999A4E8998EE78E8BE79A84E8ADA6E68395EFBC8CE7BE8AE78E8BE684BFE6848FE78CAEE587BAE887AAE5B7B1E79A84E7BE8AE885BFEFBC8CE78CAEE7BB99E8998EE78E8BEFBC8CE4BBA5E6B182E588BAE69D80E38082E6ADA3E5BD93E7BE8AE78E8BE8A681E8B584E696A9E4B880E885BFE4B98BE697B6EFBC8CE590ACE8A781E4B880E5A3B0E683A8E58FABE38082E5A496E587BAE4B880E79C8BEFBC8CE58E9FE69DA5E698AFE887AAE5B7B1E79A84E5ADA9E5AD90EFBC8CE7BE8AE983A8E79A84E78E8BE5AD90E5B7B2E7BB8FE887AAE696A9E4BA86E7BE8AE885BFE38082E7BE8AE78E8BE5AD90E5BCA5E79599E4B98BE99985EFBC8CE8AFB4EFBC9AE2809CE5ADA9E584BFE4B88DE5AD9DEFBC8CE887AAE6AE8BE8BAABE8BAAFE38082E5A588E4BD95E5ADA9E584BFE4B88DE5AD9DEFBC8CE4B88DE5BF8DE5AD90E6B091E4B88DE5AD9DE38082E684BFE4BBA5E887AAE5B7B1E4B98BE4B88DE5AD9DEFBC8CE5858DE58EBBE5AD90E6B091E4B88DE5AD9DEFBC81E2809DE7BE8AE78E8BE9998CE5A3B0E7979BE593ADE38082E4B880E697A5EFBC8CE8998EE78E8BE6ADA3E9A5AEE98592EFBC8CE6B2A1E69C89E4B88BE98592E9A5AEE9A39FE38082E7BE8AE78E8BE6ADA3E5A5BDE8BF9BE588B0E8998EE78E8BE890A5E5B890EFBC8CE98081E8BF9BE4B880E6A0B9E7BE8AE885BFE38082E8998EE78E8BE8A781E6ADA4EFBC8CE5969CE587BAE69C9BE5A496EFBC8CE5A4A7E58FA3E59583E4BA86E8B5B7E69DA5EFBC8CE8808CE7BE8AE78E8BE6ADA4E697B6EFBC8CE682B2E684A4E5BC82E5B8B8EFBC8CE6ACB2E8A681E68BBCE6ADBBE4B880E6908FEFBC8CE58DB4E8A2ABE4B880E69781E79A84E9B9BFE78E8BE68BA6E4B88BE38082E6ADA3E5BD93E7BE8AE78E8BE4B88EE9B9BFE78E8BE682B2E684A4E4B98BE697B6EFBC8CE8978FE4BA8EE69A97E5A484E79A84E9BCA0E78E8BE78E87E58588E58F91E99ABEEFBC8CEFBC9AE2809CE8A0A2E8998EE58F97E6ADBBEFBC81E2809DE4B880E58FAAE88081E9BCA0E6808EE4B988E6958CE5BE97E8BF87E88081E8998EEFBC9FE8998EE78E8BE68A8AE9BCA0E78E8BE68993E79A84E8B5B7E5889DE4B9B1E98083EFBC8CE98083E8B791E997B4EFBC8CE7BE8AE78E8BE5928CE9B9BFE78E8BE5A4A7E5969DEFBC9AE2809CE4BC91E4BCA4E9BCA0E78E8BEFBC81E2809DE8998EE78E8BE6ADA3E68481E68A93E4B88DE4BD8FE4BD93E6A0BCE8BE83E5B08FE79A84E88081E9BCA0EFBC8CE78EB0E59CA8E58DB4E8A681E59091E982A3E4B8A4E4B8AAE4BD93E6A0BCE5A4A7E4B880E58FB7E79A84E7BE8AE78E8BE9B9BFE78E8BE4B88BE6898BEFBC8CE7BE8AE5928CE9B9BFE593AAE9878CE698AFE88081E8998EE79A84E5AFB9E6898BEFBC9FE58FAAE8A781E8998EE78E8BE4B880E4B8AAE8998EE8B783EFBC8CE5A4A7E788AAE4B880E68B8DEFBC8CE9B9BFE78E8BE5B7B2E7BB8FE4B88DE79C81E4BABAE4BA8BE4BA86EFBC8CE58FAAE589A9E4B88BE7BE8AE78E8BE59CA8E8A792E890BDE889B2E889B2E58F91E68A96E38082E9BCA0E78E8BE8A781E6ADA4E4B880E5B995EFBC8CE79D80E680A5E4B887E58886EFBC8CE5A4A7E591BCEFBC9AE2809CE9878EE78CAAE4BD95E59CA8EFBC81E2809DE8998EE78E8BE6ADA3E8A681E586B2E59091E7BE8AE78E8BEFBC8CE58DB4E8A781E4B880E58FAAE9878EE78CAAE586B2E7A0B4E890A5E5B890EFBC8CE4B880E5A4B4E68BB1E9A39EE4BA86E8998EE78E8BEFBC8CE8998EE78E8BE5A4A7E68092EFBC8CE7BFBBE8BAABE8808CE8B5B7EFBC8CE58F88E8A681E586B2E9948BEFBC8CE5BFBDE784B6E997B4E9BCBBE5AD90E880B3E69CB5E58F91E79792EFBC8CE58E9FE69DA5E698AFE89F91E89E82E992BBE8BF9BE4BA86E8998EE78E8BE79A84E9BCBBE5AD90E5928CE880B3E69CB5E9878CEFBC8CE8998EE78E8BE5A496E5BDA2E899BDE5A881E6ADA6EFBC8CE8BAABE4BD93E58685E983A8E58DB4E58D81E58886E88486E5BCB1EFBC8CE8AEA9E89F91E89E82E8B791E4BA86E8BF9BE58EBBEFBC8CE58FAAE883BDE7BCB4E6A2B0E68A95E9998DE38082E8BF99E59CBAE5A4BAE4BD8DE4B98BE4BA89EFBC8CE69C80E5908EE4BBA5E9BCA0E78E8BE5A4BAE4BD8DE68890E58A9FE4B8BAE7BB93E69D9FEFBC8CE9BCA0E78E8BE5A4A7E5B081E69886E899ABE38081E59083E88D89E7AD89E58AA8E789A9EFBC8CE68993E58E8BE68E92E68CA4E9A39FE88289E58AA8E789A9EFBC8CE887AAE6ADA4EFBC8CE58AA8E789A9E4B88EE4BABAE7B1BBE79A84E68898E4BA89E8BF9BE585A5E7ACACE4BA8CE998B6E6AEB5E3808222, '11', '2', '3', '4', '2019-07-12 09:47:13', '9', '', '0');
INSERT INTO `answer` VALUES ('10', '1', 0xE593ADE4BA86E593ADE4BA86E593ADE4BA86, '5', '3', '0', '1', '2019-07-12 09:49:44', '22', null, '0');
INSERT INTO `answer` VALUES ('13', '2', 0xE9A298E79BAEE5B8A6E69C89E5ADA6E4B9A0E79A84746167EFBC8CE68980E4BBA5E7AD94E4B8BBE8AEA4E4B8BAE4B88DE99C80E789B9E588ABE6B7B1E585A5E58886E69E90E5A4A7E88491E7BB86E983A8E7BB93E69E84EFBC8CE58FAAE99C80E9809AE8BF87E8A7A3E9878AE7AE80E58D95E79A84E5A4A7E88491E5B7A5E4BD9CE69CBAE588B6E69DA5E8AFA0E9878AE4B880E4BA9BE58FAFE4BBA5E8AEA9E5AE83E4BF9DE68C81E9AB98E9809FE8BF90E8BDACE79A84E8A18CE4B8BAEFBC8CE6AF95E7AB9FE7949FE789A9E5ADA6E5B096E7ABAFE5BE88E5A49AE4B89CE8A5BFE983BDE6B2A1E69C89E5AE9AE8AEBAE38082E5BD93E784B6E88BA5E587BAE78EB0E6988EE698BEE79A84E99499E8AFAFEFBC8CE8BF98E8AFB7E79FA5E58F8BE58F8AE697B6E68C87E587BAE38082E28094E28094E28094E28094E6ADA3E69687E58886E589B2E7BABFE28094E28094E28094E28094E28094E68891E4BBACE58588E69DA5E79C8BE4B880E4B8AAE7B1BBE6AF94EFBC88E58FAAE698AFE5B8AEE58AA9E79086E8A7A3EFBC8CE4BDA0E88491E58685E79A84E68385E586B5E6AF94E8BF99E4B8AAE58FAFE5A48DE69D82E5BE97E5A49AEFBC89E4B880E4B8AAE4B88DE5A4A7E79A84E585ACE8B7AFE4BAA4E9809AE7BD91EFBC8CE88BA5E8A681E4BF9DE8AF81E59CA8E585B6E4B8ADE8A18CE9A9B6E8BDA6E8BE86E4BBACE79A84E9AB98E69588EFBC8CE8B5B7E7A081E8A681E6BBA1E8B6B3E5A49FE5A4A7E5A49FE5B9B2E58780EFBC8CE59BA0E4B8BAE8BDA6E8BE86E59FBAE695B0E8B68AE5A4A7EFBC8CE59CA8E59BBAE5AE9AE5A4A7E5B08FE79A84E585ACE8B7AFE4B88AEFBC8CE58FAFE883BDE58F91E7949FE79A84E4B88DE7A1AEE5AE9AE4BA8BE4BBB6E8B68AE5A49AEFBC8CE8808CE585ACE8B7AFE4B88AE79A84E8A18CE9A9B6E99A9CE7A28DE58F88E4BC9AE9998DE4BD8EE8BDA6E9809FEFBC8CE7BB93E69E9CE5B0B1E69893E980A0E68890E8BDA6E8BE86E68BA5E5A0B5E38082E78EB0E59CA8E68A8AE585ACE8B7AFE4BAA4E9809AE7BD91E68DA2E68890E5A4A7E88491E58685E7A59EE7BB8FE7BD91E7BB9CEFBC8CE798A6E5BCB1E79A84E7A59EE7BB8FE7BD91E7BB9CE887AAE784B6E697A0E6B395E68A8AE7949FE789A9E794B5E7A8B3E5AE9AE9AB98E69588E59CB0E4BCA0E98092E4BCA0E5AFBCEFBC8CE8BDA6E8BE86E68BA5E5A0B5E58F98E68890E4BA86E4BFA1E681AFE79A84E4B8A2E5A4B1E5928CE689ADE69BB2EFBC8CE5A4B1E58EBBE4BA86E588A4E5AE9AE4B8BAE6809DE88083E5BF85E8A681E69DA1E4BBB6E79A84E4BFA1E681AFEFBC8CE5A4A7E88491E5BF85E784B6E697A0E6B395E9AB98E9809FE8BF90E8A18CE38082E68980E4BBA5E8A681E8AEA9E5A4A7E88491E4BF9DE68C81E9AB98E9809FE8BF90E8A18CEFBC8CE5B0B1E8A681E6B182E7A59EE7BB8FE7BD91E7BB9CE5BCBAE5A3AEEFBC8CE5A4A7E88491E7BB86E8839EE7949FE5AD98E79A84E58685E78EAFE5A283E4BC98E8B68AE9A696E58588E8A7A3E586B3E8AEA9E7A59EE7BB8FE7BD91E7BB9CE5BCBAE5A3AEE8BF99E4B8AAE997AEE9A298EFBC8CE7AE80E58D95E59CB0E8AFB4EFBC8CE7BB8FE5B8B8E794A8E88491EFBC8CE7A59EE7BB8FE7BD91E7BB9CE5B0B1E4BC9AE5BCBAE5A3AEE4BA862E, '9', '2', '3', '0', '2019-07-12 09:33:35', '3', null, '0');
INSERT INTO `answer` VALUES ('14', '2', 0xE5A682E4BD95E8AEA9E5A4A7E88491E4BF9DE68C81E9AB98E9809FE8BF90E8A18CEFBC9FE4BF9DE68C81E5A4A7E88491E9AB98E9809FE8BF90E8A18CE794A8E69DA5E5B9B2E4BB80E4B988E794A8EFBC9FE8BF98E698AFE4BB85E4BB85E8BEBEE588B0E5A4A7E88491E79A84E9AB98E9809FE8BF90E8A18CE58DB3E58FAFEFBC9FE5A682E69E9CE4BB85E4BB85E8BFBDE6B182E5A4A7E88491E79A84E9AB98E9809FE8BF90E8A18CEFBC8CE69C89E4B880E4B8AAE58A9EE6B395E58FAFE4BBA5E8BEBEE588B0E38082E5B0B1E698AFE8AEA9E4B880E4B8AAE4BABAE5A484E59CA8E68190E683A7E78AB6E68081E38082E4BABAE59CA8E6838AE68190E79A84E78AB6E68081E4B88BEFBC8CE5A4B4E79AAEE58F91E9BABBE38082E5AFB9E591A8E59BB4E79A84E4B880E4B8BEE4B880E58AA8E69E81E585B6E6958FE6849FE38082E59CA8E8BF99E697B6E5A4A7E88491E79A84E8BF90E8A18CE9809FE5BAA6E4BC9AE8BEBEE588B0E69E81E585B6E38082E58FAFE4BBA5E5B09DE8AF95E4B880E4B88BEFBC8CE4B880E4B8AAE4BABAE6999AE4B88AE58EBBE788ACE788ACE5B1B1EFBC8CE69C80E5A5BDE69C89E587A0E4B8AAE59D9FE5A4B4E79A84E982A3E7A78DEFBC8CE59093E59093E887AAE5B7B1E38082E5A4A7E5A49AE695B0E983BDE698AFE5AEB3E68095E79A84E38082E4B880E5AEB3E68095EFBC8CE6B197E6AF9BE983BDE7AB96E8B5B7E69DA5E4BA86E38082E4BABAE59CA8E4B8A4E7A78DE78AB6E68081E4B88BE58FAFE4BBA5E4BF9DE68C81E9AB98E8BF90E8A18CE38082E4B880E698AFE68190E683A7E78AB6E68081EFBC8CE4BA8CE698AFE4BAA2E5A58BE78AB6E68081E38082E8BF99E698AFE4BABAE79A84E68385E7BBAAE79A84E4B8A4E4B8AAE69E81E7ABAFE38082E8BF99E4B8A4E7A78DE78AB6E68081E983BDE5B19EE4BA8EE9AB98E88097E883BDE78AB6E68081EFBC8CE68C81E7BBADE79A84E697B6E997B4E4B88DE995BFE38082E5B0B1E4BC9AE8BF9BE585A5E8BAABE5BF83E796B2E683ABE4B88DE5A0AAE79A84E78AB6E68081E38082E68A91E98381E88085E79A84E4BAA2E5A58BE78AB6E68081E4B98BE5908EEFBC8CE9809AE5B8B8E983BDE4BC9AE883A1E59083E997B7E79DA1E4B880E6AEB5E697B6E997B4E38082E6898DE883BDE8BEBEE68890E696B0E79A84E5B9B3E8A1A1E38082E4B880E58887E4BA8BE789A9E5928CE78EB0E8B1A1E983BDE981B5E5AE88E883BDE9878FE5AE88E68192E5AE9AE5BE8BE38082E59CA8E4B880E6AEB5E697B6E997B4E58685EFBC8CE5A4A7E88491E79A84E8BF90E8A18CE8BEBEE588B0E69E81E585B6EFBC8CE5BF85E784B6E99C80E8A681E5BE88E995BFE697B6E997B4E58EBBE4BFAEE5A48DE38082E5A682E69E9CE68A8AE5A4A7E88491E980BCE588B0E69E81E887B4E4B8B4E7958CE782B9EFBC8CE5B0B1E4BC9AE5AFB9E5A4A7E88491E980A0E68890E68D9FE4BCA4E38082E7B1BBE4BCBCE4BA8EE5BC80E8BDA6E4B88AE9AB98E9809FEFBC8CE6B2B9E997A8E79BB4E68EA5E8B8A9E588B0E5BA95EFBC8CE4B880E58FA3E6B094E8B791E4BA94E799BEE585ACE9878CE38082E8BF99E8BE86E8BDA6E5B0B1E79BB4E68EA5E5B0B1E68AA5E5BA9FE4BA86E38082E4B880E8BE86E8BDA6E7A1AEE5AE9EE883BDE8BEBEE588B0E6AF8FE5B08FE697B6323030E585ACE9878CEFBC8CE4BD86E5AE83E4B88DE883BDE8BF9EE7BBADE8A18CE9A9B6E4B889E4B8AAE5B08FE697B6E4BBA5E4B88AE38082E59FBAE69CACE8A784E5BE8BE698AF3AE8B791E79A84E5BFABE79A84EFBC8CE88090E58A9BE5B7AEE38082E88090E58A9BE5A5BDE79A84EFBC8CE8B791E79A84E685A2E38082E99D9EE8A681E7A1ACE5B9B2EFBC8CE5B0B1E4BC9AE68A98E5AFBFE38082, '20', '1', '0', '2', '2019-07-12 09:47:54', '3', null, '0');
INSERT INTO `answer` VALUES ('15', '2', 0xE68993E7AFAEE79083, '0', '0', '0', '0', '2019-07-11 23:38:03', '3', null, '0');
INSERT INTO `answer` VALUES ('17', '2', 0xE6B58BE8AF95, '0', '0', '0', '0', '2019-07-11 23:44:37', '3', null, '0');
INSERT INTO `answer` VALUES ('18', '2', 0xE58699, '0', '0', '0', '0', '2019-07-11 23:45:12', '3', null, '0');
INSERT INTO `answer` VALUES ('19', '2', 0xE591A2E59387, '0', '0', '0', '1', '2019-07-12 09:51:50', '3', null, '0');
INSERT INTO `answer` VALUES ('20', '2', 0x6F6B6F6B, '0', '0', '0', '1', '2019-07-12 09:51:42', '3', null, '0');
INSERT INTO `answer` VALUES ('21', '2', 0x313233, '6', '6', '0', '1', '2019-07-12 09:46:53', '3', null, '0');
INSERT INTO `answer` VALUES ('22', '2', 0xE6B58BE8AF957569, '0', '0', '0', '0', '2019-07-12 13:58:21', '3', null, '0');

-- ----------------------------
-- Table structure for `classify`
-- ----------------------------
DROP TABLE IF EXISTS `classify`;
CREATE TABLE `classify` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) COLLATE utf8_bin DEFAULT NULL,
  `from_id` int(10) DEFAULT NULL,
  `content` varchar(400) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of classify
-- ----------------------------
INSERT INTO `classify` VALUES ('1', '生活', '0', null);
INSERT INTO `classify` VALUES ('2', '体育', '0', null);
INSERT INTO `classify` VALUES ('3', '健康', '0', null);
INSERT INTO `classify` VALUES ('4', '学习', '0', null);
INSERT INTO `classify` VALUES ('5', '工作', '0', null);
INSERT INTO `classify` VALUES ('6', '旅游', '0', null);
INSERT INTO `classify` VALUES ('7', '美食', '0', null);
INSERT INTO `classify` VALUES ('8', '科学', '0', null);
INSERT INTO `classify` VALUES ('9', '娱乐', '0', null);
INSERT INTO `classify` VALUES ('10', '篮球', '2', null);
INSERT INTO `classify` VALUES ('11', '足球', '2', null);
INSERT INTO `classify` VALUES ('12', '羽毛球', '2', null);
INSERT INTO `classify` VALUES ('13', '软件工程', '4', null);
INSERT INTO `classify` VALUES ('14', '英语', '4', null);
INSERT INTO `classify` VALUES ('15', '数学', '4', null);
INSERT INTO `classify` VALUES ('17', '乔丹', '10', null);
INSERT INTO `classify` VALUES ('18', 'NBA', '10', null);
INSERT INTO `classify` VALUES ('19', '影视', '0', null);
INSERT INTO `classify` VALUES ('20', '时尚', '0', null);

-- ----------------------------
-- Table structure for `collect_article`
-- ----------------------------
DROP TABLE IF EXISTS `collect_article`;
CREATE TABLE `collect_article` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL,
  `aid` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `collect_user_id` (`uid`),
  KEY `collect_article_id` (`aid`),
  CONSTRAINT `collect_article_id` FOREIGN KEY (`aid`) REFERENCES `answer` (`id`),
  CONSTRAINT `collect_user_id` FOREIGN KEY (`uid`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of collect_article
-- ----------------------------
INSERT INTO `collect_article` VALUES ('1', '2', '1');
INSERT INTO `collect_article` VALUES ('2', '3', '1');
INSERT INTO `collect_article` VALUES ('3', '4', '1');
INSERT INTO `collect_article` VALUES ('4', '1', '2');
INSERT INTO `collect_article` VALUES ('5', '3', '2');
INSERT INTO `collect_article` VALUES ('6', '4', '2');
INSERT INTO `collect_article` VALUES ('7', '5', '2');
INSERT INTO `collect_article` VALUES ('8', '6', '2');
INSERT INTO `collect_article` VALUES ('9', '5', '2');
INSERT INTO `collect_article` VALUES ('11', '1', '3');
INSERT INTO `collect_article` VALUES ('12', '2', '3');
INSERT INTO `collect_article` VALUES ('13', '4', '3');
INSERT INTO `collect_article` VALUES ('14', '5', '3');
INSERT INTO `collect_article` VALUES ('15', '1', '4');
INSERT INTO `collect_article` VALUES ('16', '2', '4');
INSERT INTO `collect_article` VALUES ('17', '3', '4');
INSERT INTO `collect_article` VALUES ('18', '5', '4');
INSERT INTO `collect_article` VALUES ('19', '1', '5');
INSERT INTO `collect_article` VALUES ('20', '2', '5');
INSERT INTO `collect_article` VALUES ('21', '2', '6');
INSERT INTO `collect_article` VALUES ('22', '2', '21');
INSERT INTO `collect_article` VALUES ('23', '2', '8');
INSERT INTO `collect_article` VALUES ('25', '2', '14');
INSERT INTO `collect_article` VALUES ('26', '2', '14');
INSERT INTO `collect_article` VALUES ('27', '2', '10');
INSERT INTO `collect_article` VALUES ('28', '2', '20');
INSERT INTO `collect_article` VALUES ('29', '2', '19');

-- ----------------------------
-- Table structure for `comment`
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `aid` int(30) NOT NULL,
  `uid` int(30) NOT NULL,
  `content` varchar(400) COLLATE utf8_bin NOT NULL,
  `from_id` int(30) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `good_num` int(40) NOT NULL,
  `state` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `aid` (`aid`),
  KEY `commentuid` (`uid`),
  CONSTRAINT `aid` FOREIGN KEY (`aid`) REFERENCES `answer` (`id`),
  CONSTRAINT `commentuid` FOREIGN KEY (`uid`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of comment
-- ----------------------------
INSERT INTO `comment` VALUES ('1', '1', '1', '湖人总冠军', '0', '2019-07-09 01:09:33', '5', '0');
INSERT INTO `comment` VALUES ('2', '1', '2', '湖人牛皮', '1', '2019-07-09 08:30:11', '2', '0');
INSERT INTO `comment` VALUES ('3', '1', '3', '詹姆斯牛皮', '2', '2019-07-08 15:52:18', '1', '0');
INSERT INTO `comment` VALUES ('4', '1', '2', 'ad牛皮', '2', '2019-07-08 15:52:23', '3', '0');
INSERT INTO `comment` VALUES ('5', '1', '4', '湖人厉害了', '0', '2019-07-12 01:16:28', '3', '0');
INSERT INTO `comment` VALUES ('6', '2', '3', '评论表数据', '0', '2019-07-12 01:16:34', '3', '1');
INSERT INTO `comment` VALUES ('7', '2', '1', 'nba湖人总冠军', '0', '2019-07-09 08:34:02', '10', '1');
INSERT INTO `comment` VALUES ('8', '1', '2', '卡戴珊NBA最佳防守球员', '0', '2019-07-09 08:34:45', '17', '1');
INSERT INTO `comment` VALUES ('9', '1', '1', '鸡你太美', '3', '2019-07-12 01:45:15', '11', '1');
INSERT INTO `comment` VALUES ('10', '1', '3', '你太美', '1', '2019-07-09 08:36:11', '11', '1');
INSERT INTO `comment` VALUES ('11', '1', '1', '厦门礼佛那个', '1', '2019-07-11 19:19:58', '10', '1');
INSERT INTO `comment` VALUES ('12', '2', '2', '卡鲁尔', '0', '2019-07-12 01:44:03', '1', '0');
INSERT INTO `comment` VALUES ('13', '2', '3', '你好', '0', '2019-07-12 01:45:24', '1', '0');
INSERT INTO `comment` VALUES ('14', '2', '2', '你好', '3', '2019-07-11 19:26:17', '1', '0');
INSERT INTO `comment` VALUES ('16', '2', '1', 'ok', '0', '2019-07-12 01:44:21', '0', '0');
INSERT INTO `comment` VALUES ('17', '2', '2', '大帅哥', '1', '2019-07-12 00:25:52', '0', '0');
INSERT INTO `comment` VALUES ('18', '1', '2', '你很棒帮哦！', '3', '2019-07-12 01:34:33', '0', '0');
INSERT INTO `comment` VALUES ('19', '2', '2', '换了1', '1', '2019-07-12 01:38:27', '0', '1');
INSERT INTO `comment` VALUES ('20', '1', '2', '牛逼', '3', '2019-07-12 01:38:57', '0', '1');
INSERT INTO `comment` VALUES ('21', '3', '1', '你好你好你好hello！！！', '0', '2019-07-12 01:43:44', '3', '1');
INSERT INTO `comment` VALUES ('22', '2', '2', 'ok', '3', '2019-07-12 01:47:15', '0', '1');
INSERT INTO `comment` VALUES ('23', '1', '2', 'ces', '1', '2019-07-12 01:47:40', '0', '1');
INSERT INTO `comment` VALUES ('24', '13', '3', '说的真好', '0', '2019-07-12 01:49:00', '1', '0');
INSERT INTO `comment` VALUES ('25', '1', '2', '1234', '1', '2019-07-12 01:51:03', '0', '1');
INSERT INTO `comment` VALUES ('26', '13', '1', '好好学习', '3', '2019-07-12 01:59:14', '3', '0');
INSERT INTO `comment` VALUES ('27', '13', '2', '天天向上', '0', '2019-07-12 01:59:35', '5', '0');
INSERT INTO `comment` VALUES ('28', '8', '4', '快点滚去学习。', '0', '2019-07-12 02:05:59', '2', '1');
INSERT INTO `comment` VALUES ('29', '8', '2', '好滴', '4', '2019-07-12 02:07:20', '3', '1');
INSERT INTO `comment` VALUES ('30', '4', '1', '停止暴力', '0', '2019-07-12 02:08:30', '10', '1');
INSERT INTO `comment` VALUES ('31', '5', '2', 'niu', '0', '2019-07-12 02:26:22', '0', '0');
INSERT INTO `comment` VALUES ('32', '6', '2', 'ok', '0', '2019-07-12 02:26:40', '0', '0');
INSERT INTO `comment` VALUES ('33', '10', '2', 'asd', '0', '2019-07-12 02:27:06', '0', '0');
INSERT INTO `comment` VALUES ('34', '3', '2', '1', '0', '2019-07-12 02:29:09', '0', '0');
INSERT INTO `comment` VALUES ('35', '14', '2', 'niu', '0', '2019-07-12 02:36:39', '0', '0');
INSERT INTO `comment` VALUES ('36', '21', '2', '213', '0', '2019-07-12 08:45:02', '0', '0');
INSERT INTO `comment` VALUES ('37', '4', '2', 'ok', '1', '2019-07-12 08:45:12', '0', '1');
INSERT INTO `comment` VALUES ('38', '21', '2', '12', '2', '2019-07-12 08:52:33', '0', '1');
INSERT INTO `comment` VALUES ('39', '21', '2', '12', '2', '2019-07-12 08:52:54', '0', '1');
INSERT INTO `comment` VALUES ('40', '13', '2', '12', '1', '2019-07-12 08:53:11', '0', '1');
INSERT INTO `comment` VALUES ('41', '13', '2', '123', '1', '2019-07-12 08:53:26', '0', '1');
INSERT INTO `comment` VALUES ('42', '5', '2', '123', '0', '2019-07-12 08:53:39', '0', '0');
INSERT INTO `comment` VALUES ('43', '5', '2', '3', '0', '2019-07-12 08:54:05', '0', '0');
INSERT INTO `comment` VALUES ('44', '4', '2', 'oks', '1', '2019-07-12 08:54:53', '0', '0');
INSERT INTO `comment` VALUES ('45', '4', '2', 'okk', '1', '2019-07-12 08:55:10', '0', '1');
INSERT INTO `comment` VALUES ('46', '13', '2', 'asd', '3', '2019-07-12 08:55:18', '0', '1');
INSERT INTO `comment` VALUES ('47', '13', '2', 'okk', '1', '2019-07-12 08:55:31', '0', '1');
INSERT INTO `comment` VALUES ('48', '5', '2', '1', '0', '2019-07-12 08:55:57', '0', '0');
INSERT INTO `comment` VALUES ('49', '5', '2', '00', '0', '2019-07-12 08:56:32', '0', '0');
INSERT INTO `comment` VALUES ('50', '5', '2', '1', '0', '2019-07-12 08:57:12', '0', '1');
INSERT INTO `comment` VALUES ('51', '6', '2', '1', '0', '2019-07-12 08:57:24', '0', '1');
INSERT INTO `comment` VALUES ('58', '15', '2', '123', '0', '2019-07-12 09:02:01', '0', '0');
INSERT INTO `comment` VALUES ('60', '8', '2', '67', '4', '2019-07-12 09:03:56', '0', '1');
INSERT INTO `comment` VALUES ('61', '17', '2', '123', '0', '2019-07-12 09:06:04', '0', '0');
INSERT INTO `comment` VALUES ('62', '8', '2', 'dd', '4', '2019-07-12 09:07:28', '0', '1');
INSERT INTO `comment` VALUES ('63', '8', '2', '123', '4', '2019-07-12 09:08:15', '0', '1');
INSERT INTO `comment` VALUES ('64', '4', '2', '123', '1', '2019-07-12 09:08:37', '0', '1');
INSERT INTO `comment` VALUES ('65', '18', '2', '123', '0', '2019-07-12 09:08:46', '0', '0');
INSERT INTO `comment` VALUES ('66', '6', '2', '123', '0', '2019-07-12 09:09:13', '0', '0');
INSERT INTO `comment` VALUES ('67', '8', '2', '1', '0', '2019-07-12 09:44:41', '0', '0');
INSERT INTO `comment` VALUES ('68', '14', '2', '1', '0', '2019-07-12 09:52:13', '0', '0');
INSERT INTO `comment` VALUES ('69', '8', '2', '123', '0', '2019-07-12 12:44:30', '0', '0');
INSERT INTO `comment` VALUES ('70', '8', '2', '123', '0', '2019-07-12 12:45:44', '0', '0');
INSERT INTO `comment` VALUES ('71', '8', '2', '123', '2', '2019-07-12 12:51:59', '0', '1');
INSERT INTO `comment` VALUES ('72', '2', '2', '123', '3', '2019-07-12 12:52:22', '0', '1');
INSERT INTO `comment` VALUES ('73', '2', '2', '123', '3', '2019-07-12 12:52:31', '0', '1');
INSERT INTO `comment` VALUES ('74', '2', '2', '123', '1', '2019-07-12 12:53:46', '0', '0');
INSERT INTO `comment` VALUES ('75', '4', '2', '123', '1', '2019-07-12 12:54:14', '0', '0');
INSERT INTO `comment` VALUES ('76', '20', '2', '123', '0', '2019-07-12 12:54:24', '0', '0');
INSERT INTO `comment` VALUES ('77', '19', '2', 'test123456', '0', '2019-07-12 13:56:16', '0', '0');
INSERT INTO `comment` VALUES ('78', '1', '2', '策划书', '1', '2019-07-12 13:56:49', '0', '0');

-- ----------------------------
-- Table structure for `follow`
-- ----------------------------
DROP TABLE IF EXISTS `follow`;
CREATE TABLE `follow` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT NULL,
  `from_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fid` (`from_id`),
  CONSTRAINT `fid` FOREIGN KEY (`from_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of follow
-- ----------------------------
INSERT INTO `follow` VALUES ('1', '1', '2');
INSERT INTO `follow` VALUES ('2', '2', '3');
INSERT INTO `follow` VALUES ('3', '3', '1');
INSERT INTO `follow` VALUES ('5', '4', '2');
INSERT INTO `follow` VALUES ('6', '2', '1');
INSERT INTO `follow` VALUES ('7', '3', '2');
INSERT INTO `follow` VALUES ('8', '1', '3');
INSERT INTO `follow` VALUES ('9', '5', '1');
INSERT INTO `follow` VALUES ('10', '5', '2');

-- ----------------------------
-- Table structure for `follow_question`
-- ----------------------------
DROP TABLE IF EXISTS `follow_question`;
CREATE TABLE `follow_question` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(10) DEFAULT NULL,
  `question_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `question_follow` (`question_id`),
  KEY `uid_follow` (`uid`),
  CONSTRAINT `uid_follow` FOREIGN KEY (`uid`) REFERENCES `user` (`id`),
  CONSTRAINT `question_follow` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of follow_question
-- ----------------------------
INSERT INTO `follow_question` VALUES ('1', '1', '1');
INSERT INTO `follow_question` VALUES ('2', '2', '1');
INSERT INTO `follow_question` VALUES ('3', '2', '2');
INSERT INTO `follow_question` VALUES ('4', '2', '3');
INSERT INTO `follow_question` VALUES ('5', '1', '3');
INSERT INTO `follow_question` VALUES ('6', '3', '2');
INSERT INTO `follow_question` VALUES ('7', '1', '4');
INSERT INTO `follow_question` VALUES ('9', '5', '1');

-- ----------------------------
-- Table structure for `personalletter`
-- ----------------------------
DROP TABLE IF EXISTS `personalletter`;
CREATE TABLE `personalletter` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` int(30) NOT NULL,
  `from_id` int(30) NOT NULL,
  `content` varchar(255) COLLATE utf8_bin NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `letter_uid` (`uid`),
  CONSTRAINT `letter_uid` FOREIGN KEY (`uid`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of personalletter
-- ----------------------------
INSERT INTO `personalletter` VALUES ('1', '1', '2', '你好库呀，湖人总冠军，湖人厉害了，湖人牛皮！', '2019-07-05 09:26:42');
INSERT INTO `personalletter` VALUES ('2', '1', '3', '湖人总冠军!,湖人牛皮啊', '2019-07-05 11:19:37');
INSERT INTO `personalletter` VALUES ('3', '2', '1', '詹姆斯总冠军，湖人躺赢，小卡明天就来湖人了', '2019-07-05 09:32:14');
INSERT INTO `personalletter` VALUES ('4', '3', '1', '卡戴詹 湖人三巨头，厉害了', '2019-07-05 09:36:43');
INSERT INTO `personalletter` VALUES ('5', '2', '1', '老子裤子马，又帅又能打', '2019-07-05 11:18:17');
INSERT INTO `personalletter` VALUES ('6', '3', '2', '球哥，莺歌，哈特，拜拜了林类！在鹈鹕加油呀！', '2019-07-05 11:04:22');
INSERT INTO `personalletter` VALUES ('29', '2', '3', '(＾－＾)V', '2019-07-12 02:13:32');
INSERT INTO `personalletter` VALUES ('32', '2', '1', 'nihaoooooo', '2019-07-12 08:28:27');
INSERT INTO `personalletter` VALUES ('33', '2', '1', '123456', '2019-07-12 08:31:08');
INSERT INTO `personalletter` VALUES ('34', '2', '3', 'nihaooooaaaa', '2019-07-12 08:32:41');
INSERT INTO `personalletter` VALUES ('35', '2', '3', '123', '2019-07-12 08:38:03');
INSERT INTO `personalletter` VALUES ('36', '2', '3', '151', '2019-07-12 09:42:10');
INSERT INTO `personalletter` VALUES ('37', '2', '3', '爱神的箭', '2019-07-12 13:59:30');
INSERT INTO `personalletter` VALUES ('38', '2', '3', '爱神的箭', '2019-07-12 13:59:30');

-- ----------------------------
-- Table structure for `question`
-- ----------------------------
DROP TABLE IF EXISTS `question`;
CREATE TABLE `question` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `title` varchar(300) COLLATE utf8_bin DEFAULT NULL,
  `uid` int(50) DEFAULT NULL,
  `content_question` text COLLATE utf8_bin,
  `question_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `skim_num` int(40) DEFAULT NULL,
  `comment_num` int(40) DEFAULT NULL,
  `img` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `state` int(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `question_uid` (`uid`),
  CONSTRAINT `question_uid` FOREIGN KEY (`uid`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of question
-- ----------------------------
INSERT INTO `question` VALUES ('1', '搞 Java 的年薪 40W 是什么水平？', '2', 0xE5898DE6AEB5E697B6E997B4E8B79FE5908CE5ADA6E8818AE5A4A9EFBC8CE5A5B9E8AFB4E5A5B9E88081E585ACE59CA8E4B880E4B8AAE6B8B8E6888FE585ACE58FB8EFBC8CE5B9B4E896AA20343057EFBC8C4A61766120E5908EE58FB0E5BC80E58F91E38082E8BF99E698AFE4B880E4B8AAE4BB80E4B988E6A0B7E79A84E6B0B4E5B9B3EFBC8CE6B182E5A4A7E7A59EE8AFA6E7BB86E8AFB4E4B880E4B88BE38082E69CACE4BABAE79BAEE5898DE4B99FE698AFE6909E204A61766120E79A84EFBC8CE4B88DE79FA5E98193E588B0E8BF99E4B8AAE59CB0E6ADA5E8BF98E99C80E8A681E5A49AE4B985E38082, '2019-07-12 13:30:54', '18', '4', '106.jpg', '1');
INSERT INTO `question` VALUES ('2', 'HR通常提的一些面试问题是什么？怎么回答？', '2', 0xE69CACE4BABAE5A4A7E4B889EFBC8CE58786E5A487E689BEE4B880E4B8AAE69A91E69C9FE5AE9EE4B9A0EFBC8CE4BD86E6B2A1E69C89E99DA2E8AF95E7BB8FE58E86EFBC8CE68980E4BBA5E683B3E997AEE997AEE59084E4BD8DE6808EE4B988E59B9EE7AD94E4B880E4BA9BE99DA2E8AF95E5B8B8E997AEE79A84E997AEE9A298EFBC9F0D0AE697A0E68980E8B093E4B893E4B89AEFBC8CE58FAAE698AFE5A29EE58AA0E4B880E4BA9BE5AE9EE4B9A0E7BB8FE58E86E38082, '2019-07-12 13:30:49', '21', '2', '103.jpg', '1');
INSERT INTO `question` VALUES ('3', '一个不练篮球的人，和练篮球的人有什么区别？', '2', '', '2019-07-12 13:31:01', '55', '1', '106.jpg', '1');
INSERT INTO `question` VALUES ('4', '如何看待疑似发生在西安的校园暴力事件？', '3', '', '2019-07-12 12:21:42', '10', '1', 'test123.jpg', '1');
INSERT INTO `question` VALUES ('5', '如果昆虫变成原来的100倍大，会不会对人类社会形成冲击？', '3', 0xE58187E8AEBEE89A82E89A81E38081E89C98E89B9BE38081E89A8AE5AD90E7AD89E7AD89E8BF99E4BA9BE5B08FE69886E899ABE58F98E68890E58E9FE69DA5E79A84313030E5808DE5A4A7EFBC8CE4BC9AE4B88DE4BC9AE5BDB1E5938DE588B0E4BABAE7B1BBE79A84E6ADA3E5B8B8E7949FE6B4BBEFBC9FE5A682E69E9CE5BDB1E5938DEFBC8CE4BC9AE8AEA9E4BABAE7B1BBE7A4BEE4BC9AE58F91E7949FE6808EE6A0B7E79A84E58F98E58C96EFBC9FE58F88E8AFA5E5A682E4BD95E5BA94E5AFB9EFBC9F, '2019-07-12 13:30:40', '5', '0', '103.jpg', '1');
INSERT INTO `question` VALUES ('6', '为什么说 C 语言比 Java 难？', '3', 0xE983BDE8AFB4204320E8AFADE8A880E6AF94204A61766120E99ABEEFBC8CE58FAFE698AF204320E8AFADE8A880E58FAAE69C89E695B0E68DAEE7B1BBE59E8BE38081E8BF90E7AE97E7ACA6E38081E8A1A8E8BEBEE5BC8FE38081E8BE93E587BAE5928CE8BE93E585A5E587BDE695B0E38081E7A88BE5BA8FE7BB93E69E84E38081E68EA7E588B6E5BEAAE78EAFE38081E695B0E7BB84E38081E587BDE695B0E38081E68C87E99288E38081E7BB93E69E84E4BD93E38081E585B1E5908CE4BD93E38081E4BD8DE8BF90E7AE97E38081E9A284E5A484E79086E38081E69687E4BBB6E38081E582A8E5AD98E8BF99E4BA9BE4B89CE8A5BFE38082E8808C204A61766120E4B89CE8A5BFE5B0B1E5A4AAE5A49AE4BA86EFBC8C206A617661776562E79A84746F6D63617420EFBC8C68746D6CEFBC8C736572766C6574EFBC8C6A7370EFBC8C6A6176616265616EE380826A617661736520E79A84E8AFADE6B395EFBC8CE98089E68BA9EFBC8CE5BEAAE78EAFEFBC8CE696B9E6B395EFBC8CE695B0E7BB84EFBC8CE5AFB9E8B1A1E5928CE7B1BBEFBC8CE5AD97E7ACA6E4B8B2EFBC8CE7BBA7E689BFE5928CE5A49AE68081EFBC8CE59BBEE5BDA2E7958CE99DA2EFBC8CE5BC82E5B8B8E5A484E79086EFBC8CE68ABDE8B1A1E5928CE68EA5E58FA3EFBC8CE98092E5BD92E380826A6176616565E79A84207868746D6CEFBC8C6A7370EFBC8CE695B0E68DAEE5BA93EFBC8C73747275747332EFBC8C68696265726E617465EFBC8C737072696E67EFBC8C616A617820E7AD89E38082, '2019-07-12 01:35:08', '3', '0', null, '0');
INSERT INTO `question` VALUES ('7', '研究生还没入学，导师就要求七月初就去学校干活，我可以拒绝吗？', '3', 0xE4BB8AE5B9B4E5889AE88083E4B88AE79A84E7A094E7A9B6E7949FEFBC8CE5928CE5A5BDE69C8BE58F8BE8AEA1E58892E4BA86E5BE88E4B985EFBC8CE8BF99E4B8AAE69A91E58187E79A84E6AF95E4B89AE69785E8A18CE380820D0A0D0AE7BB93E69E9CE5889AE6898DE5AFBCE5B888E58F91E9809AE79FA5EFBC8CE8AEA9E4B883E69C88E5889DE58EBBE5ADA6E6A0A1E5B9B2E6B4BBEFBC8CE5A5BDE99ABEE8BF87EFBC8CE8BF98E6B2A1E69C89E585A5E5ADA6E5B0B1E5BC80E5A78BE58E8BE6A6A8E4BA86E59097EFBC9F0D0A0D0AE683B3E997AEE997AEE5A4A7E5AEB6EFBC8CE69C89E6B2A1E69C89E4BB80E4B988E59088E79086E79A84E5809FE58FA3EFBC8CE883BDE8B79FE5AFBCE5B888E8AFB7E4B880E4B8AAE69C88E79A84E58187E59097EFBC9F0D0A0D0AE4BBA5E58F8AE8BF99E6A0B7E5819AEFBC8CE5AFBCE5B888E4BC9AE5AFB9E68891E69C89E6848FE8A781E59097EFBC9FE5AFB9E4B98BE5908EE8BF99E4B8A4E4B889E5B9B4E68896E88085E6AF95E4B89AE4BC9AE69C89E4BB80E4B988E5BDB1E5938DE59097EFBC9F, '2019-07-12 12:43:52', '10', '0', null, '0');
INSERT INTO `question` VALUES ('8', '吃吃吃', '1', 0xE59083E5969DE68B89E69292, '2019-07-12 13:30:33', '60', '1', '101.jpg', '1');
INSERT INTO `question` VALUES ('9', '世界上所有的动物联手攻击人类，人类能否抵抗住？', '4', 0xE4BBA5E4B88BE698AFE5AFB9E58AA8E789A9E4B880E8AF8DE79A84E4B88DE5AE8CE695B4E8A7A3E9878AEFBC8CE8AFB7E58892E6B885E88C83E59BB4E5908EE5868DE8BF9BE8A18CE683B3E8B1A128E295AFE296BDE295B029E38082, '2019-07-12 13:30:37', '70', '1', '102.jpg', '1');
INSERT INTO `question` VALUES ('17', 'hhh', '1', 0x717171, '2019-07-11 00:52:31', '0', '0', null, '0');
INSERT INTO `question` VALUES ('22', 'qqq', '1', 0x707070, '2019-07-12 02:13:27', '33', '0', null, '0');
INSERT INTO `question` VALUES ('24', '你们开心吗', '2', 0xE8A681E694BEE58187E4BA86, '2019-07-12 00:28:46', '0', '0', null, '0');
INSERT INTO `question` VALUES ('25', '熬夜真的好吗', '2', 0xE6B2A1E58A9EE6B395EFBC8CE5BDA2E58ABFE68980E980BC, '2019-07-12 00:32:20', '0', '0', null, '0');
INSERT INTO `question` VALUES ('26', '累了吗', '2', 0x3132333435, '2019-07-12 00:34:09', '0', '0', null, '0');
INSERT INTO `question` VALUES ('27', '送达方式', '2', 0xE7ACACE4B889E696B9, '2019-07-12 00:37:31', '0', '0', null, '0');
INSERT INTO `question` VALUES ('28', 'sfdf', '2', 0x73667364323232, '2019-07-12 00:39:55', '0', '0', null, '0');
INSERT INTO `question` VALUES ('29', '滴滴滴', '2', 0xE9A1B6E9A1B6E9A1B6E9A1B6, '2019-07-12 00:51:49', '0', '0', null, '0');
INSERT INTO `question` VALUES ('30', 'sf45f', '2', 0x7366353664323232, '2019-07-12 00:52:35', '0', '0', null, '0');
INSERT INTO `question` VALUES ('31', 'sf45f', '2', 0x7366353664323232, '2019-07-12 00:52:53', '0', '0', null, '0');
INSERT INTO `question` VALUES ('32', '如何让大脑保持高速运行？', '1', 0xE5A682E9A298, '2019-07-12 01:47:37', '0', '0', null, '0');
INSERT INTO `question` VALUES ('33', '我要学习', '2', 0xE5ADA6E4B8AAE5B181, '2019-07-12 08:40:40', '0', '0', null, '0');
INSERT INTO `question` VALUES ('34', '测试工作', '2', 0x313233, '2019-07-12 08:42:06', '0', '0', null, '0');
INSERT INTO `question` VALUES ('35', '食物', '2', 0x313233, '2019-07-12 08:43:40', '0', '0', null, '0');

-- ----------------------------
-- Table structure for `questionclass`
-- ----------------------------
DROP TABLE IF EXISTS `questionclass`;
CREATE TABLE `questionclass` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `question_id` int(10) DEFAULT NULL,
  `classify_id` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `classify_id` (`classify_id`),
  KEY `question_id` (`question_id`),
  CONSTRAINT `question_id` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`),
  CONSTRAINT `classify_id` FOREIGN KEY (`classify_id`) REFERENCES `classify` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of questionclass
-- ----------------------------
INSERT INTO `questionclass` VALUES ('1', '1', '5');
INSERT INTO `questionclass` VALUES ('2', '2', '5');
INSERT INTO `questionclass` VALUES ('3', '3', '2');
INSERT INTO `questionclass` VALUES ('4', '4', '1');
INSERT INTO `questionclass` VALUES ('5', '5', '8');
INSERT INTO `questionclass` VALUES ('6', '6', '13');
INSERT INTO `questionclass` VALUES ('7', '7', '4');
INSERT INTO `questionclass` VALUES ('8', '8', '1');
INSERT INTO `questionclass` VALUES ('9', '9', '8');
INSERT INTO `questionclass` VALUES ('12', '8', '20');
INSERT INTO `questionclass` VALUES ('14', '22', '20');
INSERT INTO `questionclass` VALUES ('16', '24', '1');
INSERT INTO `questionclass` VALUES ('17', '25', '4');
INSERT INTO `questionclass` VALUES ('18', '26', '5');
INSERT INTO `questionclass` VALUES ('19', '27', '6');
INSERT INTO `questionclass` VALUES ('20', '28', '3');
INSERT INTO `questionclass` VALUES ('21', '29', '7');
INSERT INTO `questionclass` VALUES ('23', '31', '6');
INSERT INTO `questionclass` VALUES ('24', '17', '1');
INSERT INTO `questionclass` VALUES ('25', '33', '4');
INSERT INTO `questionclass` VALUES ('26', '34', '5');
INSERT INTO `questionclass` VALUES ('27', '35', '7');

-- ----------------------------
-- Table structure for `questioncomment`
-- ----------------------------
DROP TABLE IF EXISTS `questioncomment`;
CREATE TABLE `questioncomment` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `question_id` int(10) NOT NULL,
  `uid` int(10) NOT NULL,
  `content` varchar(400) COLLATE utf8_bin NOT NULL,
  `from_id` int(10) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `good_num` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `question_comment` (`question_id`),
  KEY `questioncomment_uid` (`uid`),
  CONSTRAINT `questioncomment_uid` FOREIGN KEY (`uid`) REFERENCES `user` (`id`),
  CONSTRAINT `question_comment` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of questioncomment
-- ----------------------------
INSERT INTO `questioncomment` VALUES ('1', '1', '1', '湖人牛皮', '0', '2019-07-02 10:04:53', '2');
INSERT INTO `questioncomment` VALUES ('2', '1', '2', '卡戴珊最佳防守球员', '1', '2019-07-02 10:06:00', '1');
INSERT INTO `questioncomment` VALUES ('3', '1', '3', 'nba最佳防守球员TT', '0', '2019-07-02 10:07:38', '1');
INSERT INTO `questioncomment` VALUES ('4', '1', '1', '不卡戴珊家族只剩下詹尼了', '3', '2019-07-04 09:14:55', '4');
INSERT INTO `questioncomment` VALUES ('5', '2', '1', '代码真好巧', '0', '2019-07-09 00:40:18', '15');

-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `phone` varchar(400) COLLATE utf8_bin DEFAULT NULL,
  `password` varchar(400) COLLATE utf8_bin DEFAULT NULL,
  `state` int(10) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '17750637502', 'E@CCLM', '1');
INSERT INTO `user` VALUES ('2', '13850045251', 'E@CCLM', '1');
INSERT INTO `user` VALUES ('3', '1607052135', 'E@CCLM', '1');
INSERT INTO `user` VALUES ('4', '150045251', 'E@A@L@', '1');
INSERT INTO `user` VALUES ('5', '1234564', 'E@CCLM', '1');
INSERT INTO `user` VALUES ('6', '16070486451', 'E@A@L@', '1');
INSERT INTO `user` VALUES ('7', '160706451', '', '0');
INSERT INTO `user` VALUES ('8', '13988880269', 'E@CCLM', '2');
INSERT INTO `user` VALUES ('12', '135151531', '', '0');
INSERT INTO `user` VALUES ('13', '18959262402', 'EFG@AB', '0');
INSERT INTO `user` VALUES ('14', '1205634063', 'EFDABG@DBG', '0');

-- ----------------------------
-- Table structure for `usermessage`
-- ----------------------------
DROP TABLE IF EXISTS `usermessage`;
CREATE TABLE `usermessage` (
  `id` int(30) NOT NULL AUTO_INCREMENT,
  `uid` int(30) NOT NULL,
  `sex` varchar(10) COLLATE utf8_bin DEFAULT NULL,
  `nick_name` varchar(30) COLLATE utf8_bin DEFAULT NULL,
  `dwell` varchar(60) COLLATE utf8_bin DEFAULT NULL,
  `introduce` varchar(400) COLLATE utf8_bin DEFAULT NULL,
  `email` varchar(60) COLLATE utf8_bin DEFAULT NULL,
  `answer` varchar(30) COLLATE utf8_bin DEFAULT '0',
  `article` varchar(30) COLLATE utf8_bin DEFAULT '0',
  `profession` varchar(30) COLLATE utf8_bin DEFAULT NULL,
  `img` varchar(400) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`),
  CONSTRAINT `uid` FOREIGN KEY (`uid`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of usermessage
-- ----------------------------
INSERT INTO `usermessage` VALUES ('1', '1', '男', 'xsl', '厦门', '1531', '610739389@qq.com', '1', '1', 'Java工程城市', '1455.jpg');
INSERT INTO `usermessage` VALUES ('2', '2', '男', '黄厦华', '厦门', '身高185', '23423423', '2', '2', '高级模特', '2019071473725.jpg');
INSERT INTO `usermessage` VALUES ('3', '3', '女', 'abc', 'English', 'eee', 'google123.com', '3', '3', '英语', '20190711173725.jpg');
INSERT INTO `usermessage` VALUES ('20', '5', '男', '方艺斌', '厦门', '软件工程师', '123457854@qq.com', '0', '0', 'java工程', '20190711114525.jpg');
INSERT INTO `usermessage` VALUES ('21', '4', '男', 'xushulong', '厦门', '1531', '610739389@qq.com', '1', '1', '12345', '20190711173725.jpg');
INSERT INTO `usermessage` VALUES ('22', '12', '男', '第12位用户', null, null, null, null, null, null, '2019071473725.jpg');
INSERT INTO `usermessage` VALUES ('23', '6', '男', '黄夏花', '厦门', 'Java工程师', '123141231@qq.com', '0', '0', 'Java工程师', '2019071473725.jpg');
INSERT INTO `usermessage` VALUES ('24', '13', '男', '第13位用户', null, null, null, null, null, null, null);
INSERT INTO `usermessage` VALUES ('25', '14', '男', '第14位用户', null, null, null, null, null, null, null);