Messages.dat - Revision history

AyrA at 08:08, 28 August 2013

2013-08-28T08:08:26Z

AyrA at 08:04, 28 August 2013

2013-08-28T08:04:25Z

AyrA: /* knownnodes */ added link

2013-06-12T20:53:48Z

knownnodes: added link

AyrA: added link

2013-06-12T20:52:58Z

added link

AyrA: Added SQL Code

2013-06-06T21:05:54Z

Added SQL Code

AyrA: Created page with "Messages.dat is an SQLite database containing messages and some configuration. == Tables == === inbox === Contains Messages that were successfully decrypted. Contains tra..."

2013-06-06T09:47:56Z

Created page with "Messages.dat is an SQLite database containing messages and some configuration. == Tables == === inbox === Contains Messages that were successfully decrypted. Contains tra..."

New page

Messages.dat is an [[SQLite]] database containing messages and some configuration.

== Tables ==
=== inbox ===
Contains Messages that were successfully decrypted. Contains trashed received messages too.
=== sent ===
Contains Messages that were sent. Contains trashed sent messages too.
=== subscriptions ===
Contains Addresses the user is subscribed to.
=== addressbook ===
Contains the users address book
=== blacklist ===
Contains blacklisted addresses
=== whitelist ===
Contains whitelisted addresses
=== inventory ===
Contains pubkeys and messages received
=== knownnodes ===
Empty table. Will probably contain known nodes once the system is developed and deployed further.
=== settings ===
Contains some settings, currently the version (probably of the database) and the time the database was last cleaned up
=== pubkeys ===
Contains public keys created by the user and the time it was last transmitted.

== Deleted messages ==
Internally a message is deleted by setting its folder to "trash" but leaving it in its table.
The current version has an option to delete trashed messages definitely, this also shrinks the database. Allows the user to clean up the database more than once per month.

← Older revision		Revision as of 08:08, 28 August 2013
Line 107:		Line 107:
	Internally a message is deleted by setting its folder to "trash" but leaving it in its table.		Internally a message is deleted by setting its folder to "trash" but leaving it in its table.
	The current version has an option to delete trashed messages definitely, this also shrinks the database. Allows the user to clean up the database more than once per month.		The current version has an option to delete trashed messages definitely, this also shrinks the database. Allows the user to clean up the database more than once per month.
		+
		+
		+	[[Category:DAT Files]]

@@ Line 1: / Line 1: @@
 Messages.dat is an [[SQLite]] database containing [[Message|messages]] and some configuration.
 == Tables ==
 Below is a list of Tables and their creation SQL command.

@@ Line 77: / Line 77: @@
 === knownnodes ===
-Empty table. Will probably contain known nodes once the system is developed and deployed further.
+Empty table. Will probably contain known nodes once the system is developed and deployed further. Currently the [[knownnodes.dat]] is used instead.
 <pre>CREATE TABLE knownnodes (
      timelastseen int,

@@ Line 4: / Line 4: @@
 === inbox ===
 Contains Messages that were successfully decrypted. Contains trashed received messages too.
 === sent ===
 Contains Messages that were sent. Contains trashed sent messages too.
 === subscriptions ===
 Contains Addresses the user is subscribed to.
 === addressbook ===
 Contains the users address book
 === blacklist ===
 Contains blacklisted addresses
 === whitelist ===
 Contains whitelisted addresses
 === inventory ===
 Contains pubkeys and messages received
 === knownnodes ===
 Empty table. Will probably contain known nodes once the system is developed and deployed further.
 === settings ===
 Contains some settings, currently the version (probably of the database) and the time the database was last cleaned up
 === pubkeys ===
 Contains public keys created by the user and the time it was last transmitted.
 == Deleted messages ==
 Internally a message is deleted by setting its folder to "trash" but leaving it in its table.
 The current version has an option to delete trashed messages definitely, this also shrinks the database. Allows the user to clean up the database more than once per month.