Autocrypt database schema. More...

#include "config.h"
#include <stddef.h>
#include <sqlite3.h>
#include "private.h"
#include "mutt/lib.h"

Include dependency graph for schema.c:

Functions
int	mutt_autocrypt_schema_init (void)
	Set up an Autocrypt database.

int	mutt_autocrypt_schema_update (void)
	Update the version number of the Autocrypt database schema.

Detailed Description

Autocrypt database schema.

Authors

Richard Russon
Kevin J. McCarthy

Copyright: This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 2 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program. If not, see http://www.gnu.org/licenses/.

Definition in file schema.c.

Function Documentation

◆ mutt_autocrypt_schema_init()

int mutt_autocrypt_schema_init ( void )

Set up an Autocrypt database.

Return values

0	Success
-1	Error

Definition at line 41 of file schema.c.

{
  char *errmsg = NULL;
 
  const char *schema = "BEGIN TRANSACTION; "
 
                       "CREATE TABLE account ("
                       "email_addr text primary key not null, "
                       "keyid text, "
                       "keydata text, "
                       "prefer_encrypt int, "
                       "enabled int);"
 
                       "CREATE TABLE peer ("
                       "email_addr text primary key not null, "
                       "last_seen int, "
                       "autocrypt_timestamp int, "
                       "keyid text, "
                       "keydata text, "
                       "prefer_encrypt int, "
                       "gossip_timestamp int, "
                       "gossip_keyid text, "
                       "gossip_keydata text);"
 
                       "CREATE TABLE peer_history ("
                       "peer_email_addr text not null, "
                       "email_msgid text, "
                       "timestamp int, "
                       "keydata text);"
 
                       "CREATE INDEX peer_history_email "
                       "ON peer_history ("
                       "peer_email_addr);"
 
                       "CREATE TABLE gossip_history ("
                       "peer_email_addr text not null, "
                       "sender_email_addr text, "
                       "email_msgid text, "
                       "timestamp int, "
                       "gossip_keydata text);"
 
                       "CREATE INDEX gossip_history_email "
                       "ON gossip_history ("
                       "peer_email_addr);"
 
                       "CREATE TABLE schema ("
                       "version int);"
 
                       "INSERT into schema (version) values (1);"
 
                       "COMMIT TRANSACTION";
 
  if (sqlite3_exec(AutocryptDB, schema, NULL, NULL, &errmsg) != SQLITE_OK)
  {
    mutt_debug(LL_DEBUG1, "mutt_autocrypt_schema_init() returned %s\n", errmsg);
    sqlite3_free(errmsg);
    return -1;
  }
  return 0;
}

Here is the caller graph for this function:

◆ mutt_autocrypt_schema_update()

int mutt_autocrypt_schema_update ( void )

Update the version number of the Autocrypt database schema.