libpurple/resources/sqlitehistoryadapter/01-schema.sql@5323c0b51ddc (annotated)
libpurple/resources/sqlitehistoryadapter/01-schema.sql
Wed, 25 May 2022 23:52:45 -0500
- author
- Elliott Sales de Andrade <quantum.analyst@gmail.com>
- date
- Wed, 25 May 2022 23:52:45 -0500
- changeset 41408
- 5323c0b51ddc
- parent 41090
- 741992355ead
- child 41804
- 36c3c3cd2402
- permissions
- -rw-r--r--
Remove prpl-gtalk from XMPP console
It no longer exists, and complicates the code a bit.
|
41090
741992355ead
GSoC History API including sqlite history adapter
James Culver <rewtguy@gmail.com>
parents:
diff
changeset
|
1 | CREATE TABLE IF NOT EXISTS message_log |
|
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 | ); |
