Oracle/single/sys_Moment.sql · APIJSON/APIJSON-Demo

代码拉取完成,页面将自动刷新

扫描微信二维码支付

取消

支付完成

richgiteeai

Watch

不关注关注所有动态仅关注版本发行动态关注但不提醒动态

7 Star 85 Fork 46

APIJSON/APIJSON-Demo

代码 Pull Requests 0 统计流水线

服务

加入 Gitee

与超过 1400万开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)

免费加入

已有帐号? 立即登录

文件

master

分支 (1)

标签 (35)

管理

master

7.1.0

7.1.5

7.0.3

6.2.0

6.0.0

5.4.0

5.3.0

5.2.5

5.2.0

5.1.5

5.1.0

5.0.0

4.9.1

4.8.3

4.8.0

4.7.3

4.7.2

4.7.1

4.7.0

4.6.7

克隆/下载

HTTPS SSH SVN SVN+SSH 下载ZIP

提示

下载代码请复制以下命令到终端执行

为确保你提交的代码身份被 Gitee 正确识别,请执行以下命令完成配置

git config --global user.name userName 
git config --global user.email userEmail

初次使用 SSH 协议进行代码克隆、推送等操作时,需按下述提示完成 SSH 配置

1 生成 RSA 密钥

2 获取 RSA 公钥内容,并配置到 SSH公钥中

在 Gitee 上使用 SVN,请访问使用指南

使用 HTTPS 协议时,命令行会出现如下账号密码验证步骤。基于安全考虑,Gitee 建议配置并使用私人令牌替代登录密码进行克隆、推送等操作

Username for 'https://gitee.com': userName

Password for 'https://userName@gitee.com': # 私人令牌

分支 1

标签 35

APIJSON-Demo

Oracle

single

sys_Moment.sql

sys_Moment.sql 26.49 KB

-- 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

一键复制编辑原始数据按行查看历史

TommyLemon 提交于 2021年09月03日 01:31 +08:00 . Create 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