SQLite Web: jinse.db

id

Primary key. INTEGER

live_id

TEXT NOT NULL

title

TEXT

content

TEXT

content_prefix

TEXT

published_date

TEXT

link_name

TEXT

link

TEXT

grade

INTEGER

created_at

TEXT

created_at_unix

INTEGER

created_at_zh

TEXT

updated_at

TEXT

source

TEXT

category

INTEGER

reading

INTEGER (default 0

flag

TEXT

attribute

TEXT

up_counts

INTEGER

down_counts

INTEGER

comment_count

INTEGER

highlight_color

TEXT

images

TEXT

extra_type

INTEGER

extra

TEXT

is_show_comment

INTEGER

is_forbid_comment

INTEGER

show_source_name

TEXT

vote_id

INTEGER

vote

TEXT

zan_status

TEXT

readings

TEXT

word_blocks

TEXT

raw_data

{"id": 165384, "content": "【黑客威胁曝光明星的法律事务信息 并索要比特币赎金】纽约一知名娱乐法律事务所遭到勒索软件攻击后，数十位全球大牌音乐和电影明星（包括Lady Gaga、Elton John、Robert DeNiro和麦当娜）的私人法律事务面临曝光的风险。据报道，Grubman Shire Meiselas&amp;Sacks已经受到REvil勒索软件（也被称为Sodinokibi）的攻击，攻击者威胁要分9次发布高达756GB的被盗数据。被盗数据包括保密合同、电话号码、电子邮件地址、个人通信、保密协议等。犯罪分子索要的赎金数额无从得知，但要求以比特币支付。经查询，黑客的暗网站点已经发布了麦当娜、Christina Aguilera的法律合同以及该公司电脑文件夹系统的截图。（Cointelegraph）", "content_prefix": "黑客威胁曝光明星的法律事务信息 并索要比特币赎金", "link_name": "", "link": "", "grade": 4, "sort": "", "category": 0, "highlight_color": "", "images": [{"width": 859, "height": 339, "thumbnail": "https://img.jinse.com/jinse_1588906524478458249_live-rb.png", "url": "https://img.jinse.com/jinse_1588906524478458249_live-rb.png"}], "created_at": 1588906161, "created_at_zh": "2020-05-08", "attribute": "", "up_counts": 329, "down_counts": 93, "zan_status": "", "readings": [], "extra_type": 0, "extra": null, "prev": null, "next": null, "word_blocks": [], "is_show_comment": 1, "is_forbid_comment": 0, "comment_count": 0, "analyst_user": null, "show_source_name": "", "vote_id": 0, "vote": null, "date": "2020-05-08"}

TEXT

saved_at

TIMESTAMP (default CURRENT_TIMESTAMP

Update row 333104 in lives