Skip to content

message_x.db

lzb112 edited this page Feb 10, 2026 · 3 revisions

消息数据

从新版微信来看,现在不再是所有消息都存在一个表里面了,拆开了在每个联系人都有自己的聊天记录表。接着一个联系人的表会出现在多个dbfile里面,所以有单读一个dbfile会导致读取数据不全

image ``` CREATE TABLE "Msg_ec7acfb41448af5ec95fe36592ff3746" ( "local_id" INTEGER, "server_id" INTEGER, "local_type" INTEGER, "sort_seq" INTEGER, "real_sender_id" INTEGER, "create_time" INTEGER, "status" INTEGER, "upload_status" INTEGER, "download_status" INTEGER, "server_seq" INTEGER, "origin_source" INTEGER, "source" TEXT, "message_content" TEXT, "compress_content" TEXT, "packed_info_data" BLOB, "WCDB_CT_message_content" INTEGER DEFAULT NULL, "WCDB_CT_source" INTEGER DEFAULT NULL, PRIMARY KEY("local_id" AUTOINCREMENT) ); ``` -- 主要关注 real_sender_id 、message_content 、WCDB_CT_message_content

Clone this wiki locally