libpurple/resources/sqlitehistoryadapter/01-schema.sql@8cf1d11b59c1 (annotated)
libpurple/resources/sqlitehistoryadapter/01-schema.sql
Mon, 13 May 2024 23:28:20 -0500
- author
- Elliott Sales de Andrade <quantum.analyst@gmail.com>
- date
- Mon, 13 May 2024 23:28:20 -0500
- changeset 42767
- 8cf1d11b59c1
- parent 41804
- 36c3c3cd2402
- permissions
- -rw-r--r--
Use g_set_str everywhere
This simplifies many setters.
Testing Done:
Ran `ninja turtles`
Reviewed at https://reviews.imfreedom.org/r/3182/
|
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 | ); |
