- Notifications
You must be signed in to change notification settings - Fork 268
/
Copy pathsys_Moment.sql
65 lines (56 loc) · 26.5 KB
/
sys_Moment.sql
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
56
57
58
59
60
61
62
63
64
65
-- SQLINES DEMO *** Distrib 5.7.17, for macos10.12 (x86_64)
--
-- SQLINES DEMO *** Database: sys
-- SQLINES DEMO *** -------------------------------------
-- SQLINES DEMO *** 7.33-log
/* SQLINES DEMO *** ARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/* SQLINES DEMO *** ARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/* SQLINES DEMO *** LLATION_CONNECTION=@@COLLATION_CONNECTION */;
/* SQLINES DEMO *** tf8 */;
/* SQLINES DEMO *** ME_ZONE=@@TIME_ZONE */;
/* SQLINES DEMO *** NE='+00:00' */;
/* SQLINES DEMO *** IQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/* SQLINES DEMO *** REIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/* SQLINES DEMO *** L_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/* SQLINES DEMO *** L_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- SQLINES DEMO *** or table `Moment`
--
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE Moment';
EXCEPTION
WHEN OTHERS THEN NULL;
END;
/
/* SQLINES DEMO *** cs_client = @@character_set_client */;
/* SQLINES DEMO *** er_set_client = utf8 */;
-- SQLINES LICENSE FOR EVALUATION USE ONLY
CREATE TABLE Moment (
id number(19) NOT NULL ,
userId number(19) NOT NULL ,
date timestamp(0) DEFAULT SYSTIMESTAMP NULL ,
content varchar2(300) DEFAULT NULL ,
praiseUserIdList json NOT NULL ,
pictureList json NOT NULL ,
PRIMARY KEY (id)
) ;
COMMENT ON TABLE Moment IS '动态'
CREATE INDEX userId ON Moment (userId,date);
/* SQLINES DEMO *** er_set_client = @saved_cs_client */;
--
-- SQLINES DEMO *** table `Moment`
--
LOCK TABLES Moment WRITE;
/* SQLINES DEMO *** `Moment` DISABLE KEYS */;
INSERT INTO Moment SELECT 12,70793,'2017-02-08 08:06:11','APIJSON,let interfaces and documents go to hell !','[70793, 93793, 82044, 82040, 82055, 90814, 38710, 82002, 82006, 1508072105320, 82001]','["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg", "http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg", "https://camo.githubusercontent.com/788c0a7e11a4f5aadef3c886f028c79b4808613a/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343932353935372d313732303737333630382e6a7067", "http://static.oschina.net/uploads/img/201604/22172507_Pz9Y.png", "https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067", "https://camo.githubusercontent.com/f513fa631bd780dc0ec3cf2663777e356dc3664f/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343733323232332d3337333933303233322e6a7067", "https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067", "https://camo.githubusercontent.com/f513fa631bd780dc0ec3cf2663777e356dc3664f/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343733323232332d3337333933303233322e6a7067"]' FROM dual UNION ALL SELECT 15,70793,'2017-02-08 08:06:11','APIJSON is a JSON Transmission Structure Protocol…','[82002, 70793, 38710, 93793]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 32,82002,'2017-02-08 08:06:11','tst','[38710, 82001, 82005]','["https://camo.githubusercontent.com/f513fa631bd780dc0ec3cf2663777e356dc3664f/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343733323232332d3337333933303233322e6a7067", "https://camo.githubusercontent.com/5f5c4e0c4dc539c34e8eae8ac0cbc6dccdfee5d3/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343533333831362d323032373434343231382e6a7067", "http://static.oschina.net/uploads/img/201604/22172508_mpwj.jpg"]' FROM dual UNION ALL SELECT 58,90814,'2017-02-01 11:14:31','This is a Content...-435','[38710, 82003, 82005, 93793, 82006, 82044, 82001]','["http://static.oschina.net/uploads/img/201604/22172507_aMmH.jpg"]' FROM dual UNION ALL SELECT 170,70793,'2017-02-01 11:14:31','This is a Content...-73','[82044, 82002, 82001]','["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg", "http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg", "http://static.oschina.net/uploads/img/201604/22172508_mpwj.jpg"]' FROM dual UNION ALL SELECT 235,38710,'2017-02-08 08:06:11','APIJSON,let interfaces and documents go to hell !','[82001]','["http://static.oschina.net/uploads/img/201604/22172508_mpwj.jpg", "http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000"]' FROM dual UNION ALL SELECT 301,93793,'2017-02-01 11:14:31','This is a Content...-301','[38710, 93793, 82003, 82005, 82040, 82055, 82002, 82001]','["http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg"]' FROM dual UNION ALL SELECT 371,82002,'2017-02-01 11:14:31','This is a Content...-371','[90814, 93793, 82003, 82005, 82006, 82040, 82002, 82001]','["http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg", "http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg", "https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067", "http://static.oschina.net/uploads/img/201604/22172507_aMmH.jpg", "http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg"]' FROM dual UNION ALL SELECT 470,38710,'2017-02-01 11:14:31','This is a Content...-470','[]','["http://static.oschina.net/uploads/img/201604/22172507_Pz9Y.png"]' FROM dual UNION ALL SELECT 511,38710,'2017-02-08 08:06:11',NULL,'[70793, 93793, 82001]','["https://camo.githubusercontent.com/f513fa631bd780dc0ec3cf2663777e356dc3664f/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343733323232332d3337333933303233322e6a7067", "http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg", "https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067", "http://static.oschina.net/uploads/img/201604/22172507_rrZ5.jpg", "http://static.oschina.net/uploads/img/201604/22172507_aMmH.jpg", "https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067"]' FROM dual UNION ALL SELECT 543,93793,'2017-02-08 08:06:11',NULL,'[82001]','["https://camo.githubusercontent.com/5f5c4e0c4dc539c34e8eae8ac0cbc6dccdfee5d3/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343533333831362d323032373434343231382e6a7067", "https://camo.githubusercontent.com/c98b1c86af136745cc4626c6ece830f76de9ee83/687474703a2f2f696d61676573323031352e636e626c6f67732e636f6d2f626c6f672f3636303036372f3230313630342f3636303036372d32303136303431343232343930383036362d313837323233393236352e6a7067", "http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg", "http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg", "http://static.oschina.net/uploads/img/201604/22172508_eGDi.jpg"]' FROM dual UNION ALL SELECT 551,70793,'2017-02-08 08:06:11','test','[82001]','["http://static.oschina.net/uploads/img/201604/22172507_Pz9Y.png"]' FROM dual UNION ALL SELECT 595,38710,'2017-03-05 05:29:19',NULL,'[70793, 82002, 82001]','["http://common.cnblogs.com/images/icon_weibo_24.png", "http://static.oschina.net/uploads/user/19/39085_50.jpg"]' FROM dual UNION ALL SELECT 704,38710,'2017-03-12 09:39:44','APIJSON is a JSON Transmission Structure Protocol…','[82003, 82002, 82001]','["http://static.oschina.net/uploads/user/629/1258821_50.jpg?t=1378063141000", "http://static.oschina.net/uploads/user/1332/2664107_50.jpg?t=1457405500000"]' FROM dual UNION ALL SELECT 1491200468898,38710,'2017-04-03 06:21:08','APIJSON, let interfaces go to hell!','[82001]','["http://static.oschina.net/uploads/user/998/1997902_50.jpg?t=1407806577000", "http://static.oschina.net/uploads/user/1200/2400261_50.png?t=1439638750000"]' FROM dual UNION ALL SELECT 1493835799335,38710,'2017-05-03 18:23:19','APIJSON is a JSON Transmission Structure Protocol…','[82002, 82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1508053762227,82003,'2017-10-15 07:49:22','我也试试','[1515565976140, 82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1508072491570,82002,'2017-10-15 13:01:31','有点冷~','[82001, 82002]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1508072633830,93793,'2017-10-15 13:03:53','天凉了n有男朋友的抱男盆友n有女朋友的抱女朋友n而我就比较牛逼了n我不冷。','[82005, 82002, 70793, 38710, 82045, 82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1508073178489,82045,'2017-10-15 13:12:58','发动态','[82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1512314438990,38710,'2017-12-03 15:20:38','APIJSON iOS-Swift版发布，自动生成请求代码,欢迎使用^_^ n https://github.com/TommyLemon/APIJSON','[82002, 70793, 1512531601485, 82001]','["https://images2018.cnblogs.com/blog/660067/201712/660067-20171203231829476-1202860128.jpg"]' FROM dual UNION ALL SELECT 1513094436910,38710,'2017-12-12 16:00:36','APIJSON-Python已发布，欢迎体验^_^nhttps://github.com/TommyLemon/APIJSON','[82005, 82001]','["https://raw.githubusercontent.com/TommyLemon/APIJSON/master/picture/APIJSON_Auto_get.jpg", "https://raw.githubusercontent.com/TommyLemon/APIJSON/master/picture/APIJSON_Auto_code.jpg", "https://raw.githubusercontent.com/TommyLemon/APIJSON/master/picture/APIJSON_Auto_doc.jpg"]' FROM dual UNION ALL SELECT 1514017444961,82002,'2017-12-23 08:24:04','123479589679','[82002, 1520242280259, 82001, 70793, 1524042900591, 1528264711016]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1514858533480,82056,'2018-01-02 02:02:13','I am the Iron Man','[82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1516086423441,93793,'2018-01-16 07:07:03','抢到票了，开心ପ( ˘ᵕ˘ ) ੭ ☆','[93793, 38710, 82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1520242333325,1520242280259,'2018-03-05 09:32:13','法拉利','[1520242280259, 70793, 82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1523935589834,1523626157302,'2018-04-17 03:26:29','by第一条动态','[]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1523936332614,1523626157302,'2018-04-17 03:38:52','by第二条','[82001, 1523935772553]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1524178455305,1524042900591,'2018-04-19 22:54:15','早上好啊','[1524042900591, 38710, 82003, 82001, 1523626157302]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1524298780222,1524298730523,'2018-04-21 08:19:40','e说点什么吧~','[82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1524826652626,1524298730523,'2018-04-27 10:57:32','说点什么吧~哈哈哈','[82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1527498273102,1527498229991,'2018-05-28 09:04:33','说点什么吧~yui','[82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1527821296110,1527495857924,'2018-06-01 02:48:16','这是我的商品1号','[1527821445610, 82003, 82001]','["http://pic31.nipic.com/20130710/13151003_093759013311_2.jpg", "https://cbu01.alicdn.com/img/ibank/2013/514/580/740085415_2101098104.310x310.jpg"]' FROM dual UNION ALL SELECT 1527830331780,1527495857924,'2018-06-01 05:18:51','各种购物袋','[38710, 82002, 1527495857924, 82003]','["https://cbu01.alicdn.com/img/ibank/2018/292/335/8058533292_57202994.310x310.jpg", "https://cbu01.alicdn.com/img/ibank/2018/089/747/8586747980_1843977904.310x310.jpg", "https://cbu01.alicdn.com/img/ibank/2016/025/123/3012321520_471514049.310x310.jpg", "https://cbu01.alicdn.com/img/ibank/2017/729/995/4800599927_69233977.310x310.jpg", "https://cbu01.alicdn.com/img/ibank/2016/377/263/3755362773_609022431.310x310.jpg"]' FROM dual UNION ALL SELECT 1527830474378,1527495857924,'2018-06-01 05:21:14','电视机','[1527495857924, 82001]','["https://cbu01.alicdn.com/img/ibank/2017/231/077/4524770132_781046171.310x310.jpg"]' FROM dual UNION ALL SELECT 1528251335464,1528250827953,'2018-06-06 02:15:35','meiyou','[1528250827953]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1528260617722,1528255497767,'2018-06-06 04:50:17','。。。。','[]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1528269822710,1528264711016,'2018-06-06 07:23:42','hhhhhhh','[1528250827953, 82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1528269988360,1528250827953,'2018-06-06 07:26:28','为什么发动态默认会有这两张图片啊？不可以选择自己的图片','[1528250827953]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1528274037224,1528250827953,'2018-06-06 08:33:57','说点什么吧~hgdsryh','[]','["https://image.baidu.com/search/detail?ct=503316480&z=0&ipn=d&word=%E4%BA%91%E5%8D%97%E9%A3%8E%E6%99%AF%E5%9B%BE%E7%89%87&step_word=&hs=0&pn=0&spn=0&di=163958046450&pi=0&rn=1&tn=baiduimagedetail&is=0%2C0&istype=2&ie=utf-8&oe=utf-8&in=&cl=2&lm=-1&st=-1&cs=1403824732%2C1921310327&os=1571651475%2C3950546936&simid=3426978648%2C550887139&adpicid=0&lpn=0&ln=1985&fr=&fmq=1528273681226_R&fm=result&ic=0&s=undefined&se=&sme=&tab=0&width=&height=&face=undefined&ist=&jit=&cg=&bdtype=0&oriquery=&objurl=http%3A%2F%2Fpic1.win4000.com%2Fwallpaper%2F3%2F57a2a41f57d09.jpg&fromurl=ippr_z2C%24qAzdH3FAzdH3Fooo_z%26e3Botg9aaa_z%26e3Bv54AzdH3Fowssrwrj6_kt2_88an88_8_z%26e3Bip4s&gsm=0&rpstart=0&rpnum=0&islist=&querylist=", "https://image.baidu.com/search/detail?ct=503316480&z=0&ipn=d&word=%E4%BA%91%E5%8D%97%E9%A3%8E%E6%99%AF%E5%9B%BE%E7%89%87&step_word=&hs=0&pn=12&spn=0&di=105575240210&pi=0&rn=1&tn=baiduimagedetail&is=0%2C0&istype=2&ie=utf-8&oe=utf-8&in=&cl=2&lm=-1&st=-1&cs=832573604%2C2847830718&os=1862795828%2C1682403963&simid=4268934412%2C608274877&adpicid=0&lpn=0&ln=1985&fr=&fmq=1528273681226_R&fm=result&ic=0&s=undefined&se=&sme=&tab=0&width=&height=&face=undefined&ist=&jit=&cg=&bdtype=0&oriquery=&objurl=http%3A%2F%2Fi0.szhomeimg.com%2FUploadFiles%2FBBS%2F2006%2F08%2F05%2F24752199_79122.91.jpg&fromurl=ippr_z2C%24qAzdH3FAzdH3Fkkf_z%26e3Bfzi54j_z%26e3Bv54AzdH3Fna-ccbaa-1jpwts-d90cd8ll-a-8_z%26e3Bip4s&gsm=0&rpstart=0&rpnum=0&islist=&querylist="]' FROM dual UNION ALL SELECT 1528356378455,1528264711016,'2018-06-07 07:26:18','去旅游嘛～','[82001]','[]' FROM dual UNION ALL SELECT 1528356421201,1528264711016,'2018-06-07 07:27:01','(ง •̀_•́)ง','[]','[]' FROM dual UNION ALL SELECT 1528356496939,1528356470041,'2018-06-07 07:28:16','(๑•ั็ω•็ั๑)','[]','[]' FROM dual UNION ALL SELECT 1528462217322,1528339692804,'2018-06-08 12:50:17','有没有小姐姐准备端午出游的？n地点:北戴河','[]','["https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1531072366455&di=c0d4b15b2c4b70aad49e6ae747f60742&imgtype=0&src=http%3A%2F%2Fpic1.win4000.com%2Fwallpaper%2F3%2F57a2a41f57d09.jpg", "https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1531072499167&di=5b5621d117edbc5d344a03ba0a6b580b&imgtype=0&src=http%3A%2F%2Fi0.szhomeimg.com%2FUploadFiles%2FBBS%2F2006%2F08%2F05%2F24752199_79122.91.jpg"]' FROM dual UNION ALL SELECT 1528676875139,1528339692804,'2018-06-11 00:27:55','123456','[82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1531062713966,82002,'2018-07-08 15:11:53','云南好美啊( ◞˟૩˟)◞','[82001, 82005, 38710, 70793, 93793, 82003, 1531969715979]','["https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1531072366455&di=c0d4b15b2c4b70aad49e6ae747f60742&imgtype=0&src=http%3A%2F%2Fpic1.win4000.com%2Fwallpaper%2F3%2F57a2a41f57d09.jpg", "https://timgsa.baidu.com/timg?image&quality=80&size=b9999_10000&sec=1531072499167&di=5b5621d117edbc5d344a03ba0a6b580b&imgtype=0&src=http%3A%2F%2Fi0.szhomeimg.com%2FUploadFiles%2FBBS%2F2006%2F08%2F05%2F24752199_79122.91.jpg"]' FROM dual UNION ALL SELECT 1531969818357,1531969715979,'2018-07-19 03:10:18','http://q18idc.com','[1531969715979, 82001, 38710, 1534926301956]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1533908589726,1533835176109,'2018-08-10 13:43:09','我的','[82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1535781636403,1532188114543,'2018-09-01 06:00:36','这是一个测试','[82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1536064087117,1532188114543,'2018-09-04 12:28:07','说点什么吧~奥哈达','[]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1536805585275,82003,'2018-09-13 02:26:25','iPhone Xs发布了，大家怎么看？','[82002, 82005, 70793, 82003, 82001]','["https://pic1.zhimg.com/80/v2-e129b40810070443add1c28e6185c894_hd.jpg"]' FROM dual UNION ALL SELECT 1541557989440,38710,'2018-11-07 02:33:09','自动化接口和文档 APIJSON 3.0.0 发布nhttps://www.oschina.net/news/101548/apijson-3-0-released','[82001]','["https://raw.githubusercontent.com/TommyLemon/StaticResources/master/APIJSON_Auto_get.jpg"]' FROM dual UNION ALL SELECT 1544276216289,1544276209348,'2018-12-08 13:36:56','说点什么吧~ey','[1544276209348]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1545187924367,1544503822963,'2018-12-19 02:52:04','说哼哼唧唧点什么吧~','[1544503822963, 82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1548145750536,82003,'2019-01-22 08:29:10','APIJSON,let interfaces and documents go to hell !','[82001]','[]' FROM dual UNION ALL SELECT 1553096819293,1553095415917,'2019-03-20 15:46:59','说点什么吧~睡觉觉很喜欢','[82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1556387217941,82002,'2019-04-27 17:46:57','说点什么吧~啦啦啦','[82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1557415707105,82003,'2019-05-09 15:28:27','APIJSON,let interfaces and documents go to hell !','[82001]','[]' FROM dual UNION ALL SELECT 1557754680146,82012,'2019-05-13 13:38:00','马云:工作上要有996的精神，生活上要669，也就是6天6次关键要“久”。大家怎么看？','[]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1558798664043,82003,'2019-05-25 15:37:44','测试新增动态','[82001]','["http://static.oschina.net/uploads/user/48/96331_50.jpg"]' FROM dual UNION ALL SELECT 1559129731896,1559129626356,'2019-05-29 11:35:31','xfshter','[]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1561949917622,82002,'2019-07-01 02:58:37','测试新增动态','[82001]','["http://static.oschina.net/uploads/user/48/96331_50.jpg"]' FROM dual UNION ALL SELECT 1563605336326,1563605318975,'2019-07-20 06:48:56','说点什么吧~死','[82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1568086574157,70793,'2019-09-10 03:36:14','今天天气不错，到处都是提拉米苏雪','[]','[]' FROM dual UNION ALL SELECT 1568087960391,70793,'2019-09-10 03:59:20','今天天气不错，到处都是提拉米苏雪','[82001]','[]' FROM dual UNION ALL SELECT 1568087960412,70793,'2019-09-10 03:59:20','今天天气不错，到处都是提拉米苏雪','[]','[]' FROM dual UNION ALL SELECT 1572177746393,82002,'2019-10-27 12:02:26','APIJSON,let interfaces and documents go to hell !','[82001]','[]' FROM dual UNION ALL SELECT 1577855941093,38710,'2020-01-01 05:19:01','大家新年快乐鸭～','[82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1583574596245,82003,'2020-03-07 09:49:56','测试新增动态','[82001]','["http://static.oschina.net/uploads/user/48/96331_50.jpg"]' FROM dual UNION ALL SELECT 1594127400223,82002,'2020-07-07 13:10:00','APIJSON,let interfaces and documents go to hell !','[82001]','[]' FROM dual UNION ALL SELECT 1594385349411,82002,'2020-07-10 12:49:09','APIJSON,let interfaces and documents go to hell !','[82001]','[]' FROM dual UNION ALL SELECT 1594385350586,82003,'2020-07-10 12:49:10','APIJSON,let interfaces and documents go to hell !','[]','[]' FROM dual UNION ALL SELECT 1600092541649,82001,'2020-09-14 14:09:01','豆包今天三个月了，还是那个小憨憨，早晨吃了一小段鲣鱼，一个鹌鹑蛋黄拌在猫粮里，很爱吃的，体重1.6kg(*≧▽≦)ﾉｼ))','[82003, 82002, 82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1600494829398,82001,'2020-09-19 05:53:49','APIJSON,let interfaces and documents go to hell !','[82001]','[]' FROM dual UNION ALL SELECT 1605684016176,82001,'2020-11-18 07:20:16','APIJSON, let interfaces go to hell!','[82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1606312076474,82002,'2020-11-25 13:47:56',NULL,'[82001]','[]' FROM dual UNION ALL SELECT 1608215822376,82003,'2020-12-17 14:37:02','APIJSON,let interfaces and documents go to hell !','[]','[]' FROM dual UNION ALL SELECT 1609375791054,38710,'2020-12-31 00:49:51','今天天气不错，到处都是提拉米苏雪','[]','[]' FROM dual UNION ALL SELECT 1611503147421,82002,'2021-01-24 15:45:47','APIJSON,let interfaces and documents go to hell !','[82001]','[]' FROM dual UNION ALL SELECT 1617562878095,82002,'2021-04-04 19:01:18','test','[82002, 82001]','["http://abc.com/2.png"]' FROM dual UNION ALL SELECT 1618588574794,82003,'2021-04-16 15:56:14','今天天气不错，到处都是提拉米苏雪ddd','[82001, 82003]','[]' FROM dual UNION ALL SELECT 1619511788855,82002,'2021-04-27 08:23:08','注释可省略，但如果未省略则前面两个空格必须；清空文本内容可查看规则。','[82003, 82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1619511861462,82003,'2021-04-27 08:24:21','对象关系映射- 维基百科，自由的百科全书','[82003, 82001]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual UNION ALL SELECT 1624275321377,82001,'2021-06-21 11:35:21','说点什么吧~1111','[]','["http://static.oschina.net/uploads/user/1218/2437072_100.jpg?t=1461076033000", "http://common.cnblogs.com/images/icon_weibo_24.png"]' FROM dual;
/* SQLINES DEMO *** `Moment` ENABLE KEYS */;
UNLOCK TABLES;
/* SQLINES DEMO *** NE=@OLD_TIME_ZONE */;
/* SQLINES DEMO *** E=@OLD_SQL_MODE */;
/* SQLINES DEMO *** _KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/* SQLINES DEMO *** CHECKS=@OLD_UNIQUE_CHECKS */;
/* SQLINES DEMO *** ER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/* SQLINES DEMO *** ER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/* SQLINES DEMO *** ON_CONNECTION=@OLD_COLLATION_CONNECTION */;
/* SQLINES DEMO *** ES=@OLD_SQL_NOTES */;
-- SQLINES DEMO *** 2021-06-21 23:26:45
