mirror of
https://github.com/mautrix/whatsapp.git
synced 2026-05-16 02:26:53 -04:00
10 lines
344 B
SQL
10 lines
344 B
SQL
-- v7 (compatible with v3+): Add cache for avatar URLs when using direct media
|
|
CREATE TABLE whatsapp_avatar_cache (
|
|
entity_jid TEXT NOT NULL,
|
|
avatar_id TEXT NOT NULL,
|
|
direct_path TEXT NOT NULL,
|
|
expiry BIGINT NOT NULL,
|
|
gone BOOLEAN NOT NULL DEFAULT false,
|
|
|
|
PRIMARY KEY (entity_jid, avatar_id)
|
|
);
|