forked from Tencent/APIJSON
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsys_Comment.sql
More file actions
55 lines (48 loc) · 17.9 KB
/
sys_Comment.sql
File metadata and controls
55 lines (48 loc) · 17.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
-- MySQL dump 10.13 Distrib 5.7.12, for osx10.9 (x86_64)
--
-- Host: 39.108.143.172 Database: sys
-- ------------------------------------------------------
-- Server version 5.7.19-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `Comment`
--
DROP TABLE IF EXISTS `Comment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `Comment` (
`id` bigint(15) NOT NULL COMMENT '唯一标识',
`toId` bigint(15) DEFAULT NULL COMMENT '被回复的id',
`userId` bigint(15) NOT NULL COMMENT '评论人id',
`momentId` bigint(15) NOT NULL COMMENT '动态id',
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
`content` varchar(1000) NOT NULL COMMENT '内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='评论';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `Comment`
--
LOCK TABLES `Comment` WRITE;
/*!40000 ALTER TABLE `Comment` DISABLE KEYS */;
INSERT INTO `Comment` VALUES (4,0,38710,470,'2017-02-01 11:20:50','This is a Content...-4'),(13,0,82005,58,'2017-02-01 11:20:50','This is a Content...-13'),(22,221,82001,470,'2017-02-01 11:20:50','测试修改评论'),(44,0,82003,170,'2017-02-01 11:20:50','This is a Content...-44'),(45,0,93793,301,'2017-02-01 11:20:50','This is a Content...-45'),(47,4,70793,470,'2017-02-01 11:20:50','This is a Content...-47'),(51,45,82003,301,'2017-02-01 11:20:50','This is a Content...-51'),(54,0,82004,170,'2017-02-01 11:20:50','This is a Content...-54'),(68,0,82005,371,'2017-02-01 11:20:50','This is a Content...-68'),(76,45,93793,301,'2017-02-01 11:20:50','This is a Content...-76'),(77,13,93793,58,'2017-02-01 11:20:50','This is a Content...-77'),(97,13,82006,58,'2017-02-01 11:20:50','This is a Content...-97'),(99,44,70793,170,'2017-02-01 11:20:50','This is a Content...-99'),(110,0,93793,371,'2017-02-01 11:23:24','This is a Content...-110'),(114,0,82001,371,'2017-03-02 05:56:06','This is a Content...-114'),(115,0,38710,371,'2017-03-02 05:56:06','This is a Content...-115'),(116,0,70793,371,'2017-03-02 05:56:06','This is a Content...-116'),(120,0,93793,301,'2017-03-02 05:56:06','This is a Content...-110'),(124,0,82001,301,'2017-03-02 05:56:06','This is a Content...-114'),(157,NULL,93793,371,'2017-02-01 11:20:50','This is a Content...-157'),(158,0,93793,301,NULL,'This is a Content...-157'),(160,0,82001,235,'2017-03-02 05:56:06','This is a Content...-160'),(162,0,93793,12,'2017-03-06 05:03:45','This is a Content...-162'),(163,0,82001,235,'2017-03-02 05:56:06','This is a Content...-163'),(164,0,93793,12,'2017-03-06 05:03:45','This is a Content...-164'),(167,NULL,82001,58,'2017-03-25 11:48:41','Nice!'),(168,1490442545077,82001,235,'2017-03-25 11:49:14','???'),(172,162,82001,12,'2017-03-25 12:22:58','OK'),(173,NULL,38710,58,'2017-03-25 12:25:13','Good'),(174,172,38710,1488691759538,'2017-03-25 12:26:00','what?'),(175,0,38710,12,'2017-03-25 12:26:53','Java is the best program language!'),(176,166,38710,15,'2017-03-25 12:28:03','thank you'),(178,NULL,38710,511,'2017-03-25 12:30:55','wbw'),(182,110,82001,371,'2017-03-26 06:12:52','hahaha'),(188,97,82001,58,'2017-03-26 07:21:32','1646'),(190,0,82001,58,'2017-03-26 07:22:13','dbdj'),(191,176,82001,592,'2017-03-26 07:49:29','zbsj'),(192,0,82001,592,'2017-03-26 07:49:35','sjsj'),(200,0,82001,592,'2017-03-27 03:20:16','oooo'),(202,166,82001,592,'2017-03-29 03:01:08','eej'),(203,178,82001,592,'2017-03-29 03:01:14','znsk'),(204,169,82001,592,'2017-03-29 03:01:32','ghh'),(205,177,82001,592,'2017-03-29 03:01:37','hhh'),(206,54,82001,170,'2017-03-29 03:04:23','ejej'),(209,13,82001,58,'2017-03-29 03:05:59','hehj'),(300,97,82001,58,'2017-03-29 03:06:07','hj'),(301,194,82001,235,'2017-03-29 03:06:24','jj'),(304,195,82001,592,'2017-03-29 04:48:28','eej'),(305,188,82001,592,'2017-03-29 04:48:32','ssh'),(307,161,82001,592,'2017-03-29 04:48:51','ejej'),(308,0,82001,592,'2017-03-29 04:49:02','eheh'),(4001,0,82001,58,'2017-03-29 08:39:52','I would like to say …'),(1490776944301,0,82001,58,'2017-03-29 08:42:24','hello'),(1490776966828,173,82001,58,'2017-03-29 08:42:46','me too'),(1490777876202,192,82001,592,'2017-03-29 08:57:56','ghh'),(1490777905437,0,82001,543,'2017-03-29 08:58:25','rr'),(1490778122719,175,82001,12,'2017-03-29 09:02:02','Yeah! I think so!'),(1490778494751,1490778122719,82001,12,'2017-03-29 09:08:14','reply Android82001'),(1490778681337,166,82001,12,'2017-03-29 09:11:21','gg'),(1490780759866,99,82001,170,'2017-03-29 09:45:59','99'),(1490781009548,51,82001,301,'2017-03-29 09:50:09','3'),(1490781032005,45,82001,301,'2017-03-29 09:50:32','93793'),(1490781817044,209,38710,58,'2017-03-29 10:03:37','82001'),(1490781850893,1490776966828,38710,58,'2017-03-29 10:04:10','haha!'),(1490781857242,190,38710,58,'2017-03-29 10:04:17','nice'),(1490781865407,1490781857242,38710,58,'2017-03-29 10:04:25','wow'),(1490781899147,197,38710,12,'2017-03-29 10:04:59','kaka'),(1490794439561,1490778681337,82001,12,'2017-03-29 13:33:59','gg?'),(1490794610632,172,82001,12,'2017-03-29 13:36:50','All right'),(1490794937137,1490794919957,82001,12,'2017-03-29 13:42:17','All right ok ok'),(1490794953438,1490794937137,82001,12,'2017-03-29 13:42:33','All right ok ok ll'),(1490796241178,0,38710,58,'2017-03-29 14:04:01','Anything else?'),(1490796629591,175,38710,12,'2017-03-29 14:10:29','well'),(1490798710678,110,38710,371,'2017-03-29 14:45:10','110'),(1490800971064,175,38710,12,'2017-03-29 15:22:51','I do'),(1490848396072,175,82001,12,'2017-03-30 04:33:16','Lemon'),(1490848581424,166,82001,12,'2017-03-30 04:36:21','82001ejej'),(1490850764448,162,82001,12,'2017-03-30 05:12:44','-162'),(1490850844016,0,82001,12,'2017-03-30 05:14:04','I like it'),(1490850876656,1490800971064,82001,12,'2017-03-30 05:14:36','I do so'),(1490854894566,175,82001,12,'2017-03-30 06:21:34','it does be a good lang'),(1490863443219,1490850844016,82002,12,'2017-03-30 08:44:03','me too!'),(1490863469638,0,82002,15,'2017-03-30 08:44:29','Just do it'),(1490863507114,4,82003,470,'2017-03-30 08:45:07','yes'),(1490863563124,0,82003,704,'2017-03-30 08:46:03','I want one'),(1490863651493,0,70793,595,'2017-03-30 08:47:31','wow'),(1490863661426,1490780759866,70793,170,'2017-03-30 08:47:41','66'),(1490863676989,0,70793,12,'2017-03-30 08:47:56','Shy'),(1490863711703,0,70793,511,'2017-03-30 08:48:31','I hope I can join'),(1490863717947,178,70793,511,'2017-03-30 08:48:37','what?'),(1490863783276,1490863711703,93793,511,'2017-03-30 08:49:43','haha welcome'),(1490863903900,0,82006,470,'2017-03-30 08:51:43','SOGA'),(1490863915675,0,82006,235,'2017-03-30 08:51:55','Good boy'),(1490863938712,0,82006,12,'2017-03-30 08:52:18','Handsome!'),(1490863978239,1490796241178,82006,58,'2017-03-30 08:52:58','there still remains a question…'),(1490864016738,0,82006,511,'2017-03-30 08:53:36','I want to have a try!'),(1490864023700,0,82006,543,'2017-03-30 08:53:43','oops'),(1490864039264,0,82006,551,'2017-03-30 08:53:59','Wonderful!'),(1490864060358,308,82006,592,'2017-03-30 08:54:20','I an little girl'),(1490864075725,1490864060358,82006,592,'2017-03-30 08:54:35','do you like me?'),(1490864152008,0,82006,58,'2017-03-30 08:55:52','U R ugly( ´?` )'),(1490864254400,1490863915675,82044,235,'2017-03-30 08:57:34','And I have no idea'),(1490864276824,0,82044,12,'2017-03-30 08:57:56','Oh my God!'),(1490864292184,1490864152008,82044,58,'2017-03-30 08:58:12','haha!'),(1490864379424,1490863938712,82001,12,'2017-03-30 08:59:39','Thank you~'),(1490864400210,1490864276824,82001,12,'2017-03-30 09:00:00','Amazing, isnt it?'),(1490874908570,1490864023700,82055,543,'2017-03-30 11:55:08','yeah'),(1490874930994,1490777905437,82055,543,'2017-03-30 11:55:30','yy'),(1490874968779,0,82055,12,'2017-03-30 11:56:08','I love it'),(1490875033494,0,82055,301,'2017-03-30 11:57:13','More Comments'),(1490875040761,158,82055,301,'2017-03-30 11:57:20','157'),(1490875046704,120,82055,301,'2017-03-30 11:57:26','110'),(1490875660259,1490863469638,82055,15,'2017-03-30 12:07:40','I prove wht you said(??????)'),(1490879678127,0,82001,543,'2017-03-30 13:14:38','Baby you are a firework!'),(1490973736662,1490973715568,70793,170,'2017-03-31 15:22:16','Hello, I am a fresh man'),(1490973890875,1490864039264,93793,551,'2017-03-31 15:24:50','While I donot think so…'),(1491014830404,1490864016738,82001,511,'2017-04-01 02:47:10','Have a nice day!'),(1491119615611,1490864023700,82001,543,'2017-04-02 07:53:35','$$'),(1491119670185,68,82001,371,'2017-04-02 07:54:30','Leave a word'),(1491119695580,0,82001,371,'2017-04-02 07:54:55','leave a word'),(1491130701902,0,38710,511,'2017-04-02 10:58:21','Thanks for your supports (-^?^-)'),(1491209763162,0,82001,1491200468898,'2017-04-03 08:56:03','How do you do'),(1491277552385,0,82001,58,'2017-04-04 03:45:52','Seven'),(1491312382941,0,82001,1491200468898,'2017-04-04 13:26:22','Wow'),(1491312438951,1490863651493,82001,595,'2017-04-04 13:27:18','WaKaKa!'),(1491709064513,0,82001,551,'2017-04-09 03:37:44','soga'),(1491740899179,0,82001,470,'2017-04-09 12:28:19','www'),(1491798370749,0,82002,551,'2017-04-10 04:26:10','Nice!'),(1491798499667,115,82002,371,'2017-04-10 04:28:19','I do not understand…'),(1491830543193,0,82001,170,'2017-04-10 13:22:23','What is the hell?'),(1492932228287,1491209763162,38710,1491200468898,'2017-04-23 07:23:48','fine,thanks'),(1493094307810,0,82001,551,'2017-04-25 04:25:04','删除或修改数据请先创建，不要动原来的，谢谢'),(1493094307910,0,82001,551,'2017-04-25 04:26:04','用POST新增数据'),(1493186363132,1490850764448,82001,12,'2017-04-26 05:59:23','sndnd'),(1502632433970,0,82002,1493835799335,'2017-08-13 13:53:53','just have fun!'),(1508053783278,0,82001,1508053762227,'2017-10-15 07:49:43','可以的'),(1508072695833,0,82003,1508072633830,'2017-10-15 13:04:55','心疼地抱住自己(๑´ㅂ`๑)'),(1508227456407,0,82001,15,'2017-10-17 08:04:16','hsh'),(1508227498578,1491798370749,82001,551,'2017-10-17 08:04:58','g'),(1508461493442,0,82001,1508072491570,'2017-10-20 01:04:53','hi'),(1508461508559,1508461493442,82001,1508072491570,'2017-10-20 01:05:08','她'),(1508462026394,1490850844016,82001,12,'2017-10-20 01:13:46','欧'),(1508492585904,1508462026394,82001,12,'2017-10-20 09:43:05','my god'),(1509003045509,0,82001,1508072633830,'2017-10-26 07:30:45','hhh'),(1509346549158,0,82001,170,'2017-10-30 06:55:49','呵呵'),(1509346556395,0,82001,170,'2017-10-30 06:55:56','测试'),(1509346606036,0,82001,15,'2017-10-30 06:56:46','测'),(1509518079106,0,82001,1508073178489,'2017-11-01 06:34:39','哦哦哦'),(1510795816462,162,82001,12,'2017-11-16 01:30:16','赞'),(1510795933629,0,82001,1508073178489,'2017-11-16 01:32:13','cc'),(1510813284894,0,82001,12,'2017-11-16 06:21:24','asdasdasdas'),(1510813295700,162,82001,12,'2017-11-16 06:21:35','adsdasdasdasd'),(1511347414308,1508461493442,82001,1508072491570,'2017-11-22 10:43:34','好东西'),(1511347442055,1508461493442,82001,1508072491570,'2017-11-22 10:44:02','凸透镜'),(1511374269759,99,82001,170,'2017-11-22 18:11:09','记录里'),(1511374274194,0,82001,170,'2017-11-22 18:11:14','哦哦哦'),(1511407695342,0,1511407581570,371,'2017-11-23 03:28:15','好的'),(1511407702981,157,1511407581570,371,'2017-11-23 03:28:22','你好'),(1511878024415,0,1511761906715,12,'2017-11-28 14:07:04','你今年'),(1511878031610,1511878024415,1511761906715,12,'2017-11-28 14:07:11','不鸟你'),(1512035094555,0,82001,12,'2017-11-30 09:44:54','呵呵呵'),(1512035117021,0,82001,32,'2017-11-30 09:45:17','图片看不了啊'),(1512038831617,1512035117021,82001,32,'2017-11-30 10:47:11','代码截屏都是2k分辨率的，并且还放在GitHub上，可以等一会儿，或者更新下ZBLibray(图片加载库从UIL换成了Glide)就行'),(1512039030970,1512035117021,82001,32,'2017-11-30 10:50:30','一般九宫格图片都是压缩图，分辨率在300*300左右，加载很快，点击放大后才是原图，1080P左右'),(1512531859019,0,1512531601485,1512314438990,'2017-12-06 03:44:19','666'),(1512533520832,1512531859019,38710,1512314438990,'2017-12-06 04:12:00','嘿嘿'),(1513656045399,0,82001,1508072633830,'2017-12-19 04:00:45','444444'),(1514279193860,0,82001,1493835799335,'2017-12-26 09:06:33','11'),(1514425784231,0,82001,704,'2017-12-28 01:49:44','你信'),(1514425796195,0,82001,1513094436910,'2017-12-28 01:49:56','一起'),(1514473034425,1514425796195,93793,1513094436910,'2017-12-28 14:57:14','干啥？'),(1514478784653,0,82001,1513094436910,'2017-12-28 16:33:04','bug很多'),(1514506206319,1514478784653,38710,1513094436910,'2017-12-29 00:10:06','碰到哪些了呢？欢迎指出，尽快解决^_^'),(1514617131036,0,82005,1513094436910,'2017-12-30 06:58:51','口子'),(1514858592813,0,82001,1514858533480,'2018-01-02 02:03:12','铁人'),(1514858640958,0,38710,1514858533480,'2018-01-02 02:04:00','斯塔克工业'),(1514858707767,0,70793,1514858533480,'2018-01-02 02:05:07','壕友乎？'),(1514960689780,0,82001,1514017444961,'2018-01-03 06:24:49','666'),(1514960713300,0,82001,1513094436910,'2018-01-03 06:25:13','1'),(1514960744185,1512531859019,82001,1512314438990,'2018-01-03 06:25:44','哇'),(1515057852156,0,82001,58,'2018-01-04 09:24:12','你说'),(1515057857464,0,82001,58,'2018-01-04 09:24:17','你说'),(1515057861094,0,82001,58,'2018-01-04 09:24:21','蓉蓉'),(1515057864174,1515057857464,82001,58,'2018-01-04 09:24:24','哦轻松'),(1515057869554,0,82001,58,'2018-01-04 09:24:29',',王者荣耀'),(1515297469382,0,82001,1491200468898,'2018-01-07 03:57:49','哦哦'),(1515297549419,1490863563124,82001,704,'2018-01-07 03:59:09','哦哦'),(1515313792063,162,82001,12,'2018-01-07 08:29:52','you'),(1515313823155,164,82001,12,'2018-01-07 08:30:23','you'),(1515772556113,0,82001,1514017444961,'2018-01-12 15:55:56','回老家了'),(1516190557098,0,82001,1513094436910,'2018-01-17 12:02:37','哦婆婆'),(1516629533520,0,82001,1508072633830,'2018-01-22 13:58:53','小臭臭'),(1516686985310,0,82001,1516086423441,'2018-01-23 05:56:25','hologram'),(1516687072270,1516629533520,82001,1508072633830,'2018-01-23 05:57:52','咯我就'),(1516687437251,1516686985310,82001,1516086423441,'2018-01-23 06:03:57','你家里好哦'),(1516691119239,1516686985310,38710,1516086423441,'2018-01-23 07:05:19','我喜欢Hololens嘿嘿'),(1516780129884,0,82001,1516086423441,'2018-01-24 07:48:49','aaa'),(1516783920998,0,82001,1513094436910,'2018-01-24 08:52:00','这个是实时的吗'),(1516785657724,0,82001,1516086423441,'2018-01-24 09:20:57','hj'),(1516805226757,1516785657724,38710,1516086423441,'2018-01-24 14:47:06','滑稽？'),(1516805340593,1516783920998,38710,1513094436910,'2018-01-24 14:49:00','看怎么定义 实时 。这个是仿微信朋友圈列表和QQ空间说说详情，在线同步的，但没做推送，所以不是QQ微信聊天那种即时通讯。'),(1516843720270,1516780129884,82001,1516086423441,'2018-01-25 01:28:40','ghj'),(1516862537978,1515057869554,70793,58,'2018-01-25 06:42:17','绝地逃亡吃鸡'),(1516874359484,1515772556113,70793,1514017444961,'2018-01-25 09:59:19','恭喜恭喜'),(1516931850067,0,82001,1516086423441,'2018-01-26 01:57:30','1111111111111'),(1516951734010,1514506206319,82001,1513094436910,'2018-01-26 07:28:54','火锅'),(1516951754620,0,82001,1513094436910,'2018-01-26 07:29:14','凤飞飞刚刚好'),(1516951826863,0,82001,170,'2018-01-26 07:30:26','黑珍珠'),(1517193267472,1513656045399,82001,1508072633830,'2018-01-29 02:34:27','1'),(1517193278459,0,82001,1508072633830,'2018-01-29 02:34:38','112'),(1517229342303,0,82001,1516086423441,'2018-01-29 12:35:42','几号抢的'),(1517234768450,1517229342303,93793,1516086423441,'2018-01-29 14:06:08','9号'),(1517303775429,1490863903900,82001,470,'2018-01-30 09:16:15','？？？'),(1517375165233,0,82001,1508053762227,'2018-01-31 05:06:05','666'),(1517730034960,0,82001,170,'2018-02-04 07:40:34','陌陌陌陌'),(1518365470893,44,82001,170,'2018-02-11 16:11:10','野蜂飞舞'),(1518614899681,0,82001,301,'2018-02-14 13:28:19','https://goo.gl/search/JJB+Sports\nJJB Sports,'),(1518845194470,0,82001,1514017444961,'2018-02-17 05:26:34','ok'),(1518845210488,0,82001,1514017444961,'2018-02-17 05:26:50','ok2'),(1519719341810,0,82001,1516086423441,'2018-02-27 08:15:41','我也想抢一张'),(1519793574249,1519719341810,93793,1516086423441,'2018-02-28 04:52:54','哈哈，春运都过了啊'),(1519813825959,0,82001,1516086423441,'2018-02-28 10:30:25','距P民'),(1519974842508,0,82001,1516086423441,'2018-03-02 07:14:02','1111'),(1519974868848,1516691119239,82001,1516086423441,'2018-03-02 07:14:28','1111'),(1519979533242,0,82001,1508072633830,'2018-03-02 08:32:13','hj'),(1520230811348,0,82001,1520067429123,'2018-03-05 06:20:11','厉害了'),(1520231250819,0,82001,12,'2018-03-05 06:27:30','浑身难受呢'),(1520264640815,0,70793,1520242333325,'2018-03-05 15:44:00','兰博基尼'),(1520330788006,0,1520242280259,1514017444961,'2018-03-06 10:06:28','八组'),(1520332892486,NULL,82001,15,'2018-03-06 10:41:32','测试新增评论'),(1520578804491,0,82001,1520230883762,'2018-03-09 07:00:04','同'),(1520578814684,1520578804491,82001,1520230883762,'2018-03-09 07:00:14','就你那'),(1520578823259,0,82001,1520230883762,'2018-03-09 07:00:23','桶方便面'),(1520578883309,0,82001,12,'2018-03-09 07:01:23','我用流量');
/*!40000 ALTER TABLE `Comment` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2018-03-10 20:22:26