libpurple/resources/sqlitehistoryadapter/01-schema.sql@099e1dfb856b (annotated)
libpurple/resources/sqlitehistoryadapter/01-schema.sql
Sun, 10 Aug 2025 23:44:08 +0800
- author
- Gong Zhile <gongzl@stu.hebust.edu.cn>
- date
- Sun, 10 Aug 2025 23:44:08 +0800
- branch
- purple_conversation_find_message_by_id
- changeset 43309
- 099e1dfb856b
- parent 41804
- 36c3c3cd2402
- permissions
- -rw-r--r--
Add Purple.Conversation.find_message_by_id
The method was added so that a protocol or plugin could easily lookup
for the reference for a message. This will be especially useful when a
protocol received a quoted message but only with an id.
|
41804
36c3c3cd2402
Add some api for handling SQLite3 migrations
Gary Kramlich <grim@reaperworld.com>
parents:
41090
diff
changeset
|
1 | CREATE TABLE message_log |
|
41090
741992355ead
GSoC History API including sqlite history adapter
James Culver <rewtguy@gmail.com>
parents:
diff
changeset
|
2 | ( |
|
741992355ead
GSoC History API including sqlite history adapter
James Culver <rewtguy@gmail.com>
parents:
diff
changeset
|
3 | protocol TEXT NOT NULL, -- examples: slack, xmpp, irc, discord |
|
741992355ead
GSoC History API including sqlite history adapter
James Culver <rewtguy@gmail.com>
parents:
diff
changeset
|
4 | account TEXT NOT NULL, -- example: grim@reaperworld.com@milwaukee.slack.com |
|
741992355ead
GSoC History API including sqlite history adapter
James Culver <rewtguy@gmail.com>
parents:
diff
changeset
|
5 | conversation_id TEXT NOT NULL, -- example: #general |
|
741992355ead
GSoC History API including sqlite history adapter
James Culver <rewtguy@gmail.com>
parents:
diff
changeset
|
6 | message_id TEXT NOT NULL, -- exampe: 14fdjakafjakl1155 |
|
741992355ead
GSoC History API including sqlite history adapter
James Culver <rewtguy@gmail.com>
parents:
diff
changeset
|
7 | author TEXT NULL, -- could be null for status messages |
|
741992355ead
GSoC History API including sqlite history adapter
James Culver <rewtguy@gmail.com>
parents:
diff
changeset
|
8 | author_name_color TEXT NULL, |
|
741992355ead
GSoC History API including sqlite history adapter
James Culver <rewtguy@gmail.com>
parents:
diff
changeset
|
9 | author_alias TEXT NULL, |
|
741992355ead
GSoC History API including sqlite history adapter
James Culver <rewtguy@gmail.com>
parents:
diff
changeset
|
10 | recipient TEXT NULL, |
|
741992355ead
GSoC History API including sqlite history adapter
James Culver <rewtguy@gmail.com>
parents:
diff
changeset
|
11 | content_type TEXT NULL CHECK(content_type IN ('plain', 'html', 'markdown', 'bbcode')), |
|
741992355ead
GSoC History API including sqlite history adapter
James Culver <rewtguy@gmail.com>
parents:
diff
changeset
|
12 | content TEXT NULL, -- must be UTF8 string |
|
741992355ead
GSoC History API including sqlite history adapter
James Culver <rewtguy@gmail.com>
parents:
diff
changeset
|
13 | raw_content TEXT NULL, -- the message as came from the protocol |
|
741992355ead
GSoC History API including sqlite history adapter
James Culver <rewtguy@gmail.com>
parents:
diff
changeset
|
14 | protocol_timestamp TEXT, -- according to protocol, could be wrong |
|
741992355ead
GSoC History API including sqlite history adapter
James Culver <rewtguy@gmail.com>
parents:
diff
changeset
|
15 | client_timestamp DATETIME, -- when it "landed" in libpurple |
|
741992355ead
GSoC History API including sqlite history adapter
James Culver <rewtguy@gmail.com>
parents:
diff
changeset
|
16 | log_version INTEGER DEFAULT 1 NOT NULL |
|
741992355ead
GSoC History API including sqlite history adapter
James Culver <rewtguy@gmail.com>
parents:
diff
changeset
|
17 | ); |
