From 7d5ee81628a08dd560f7fdaa5b4d5a3f5ce3fb95 Mon Sep 17 00:00:00 2001
From: zotlabs <mike@macgirvin.com>
Date: Tue, 25 Apr 2017 21:52:24 -0700
Subject: database support for client side e2ee for private mail

---
 install/schema_postgres.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'install/schema_postgres.sql')

diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index be72a85e1..0328040f4 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -751,6 +751,7 @@ CREATE TABLE "mail" (
   "to_xchan" text NOT NULL DEFAULT '',
   "account_id" bigint  NOT NULL DEFAULT '0',
   "channel_id" bigint  NOT NULL DEFAULT '0',
+  "mail_mimetype char(64) NOT NULL DEFAULT '0',
   "title" text NOT NULL,
   "body" text NOT NULL,
   "sig" text NOT NULL,
@@ -763,6 +764,7 @@ CREATE TABLE "mail" (
   "mail_seen" smallint NOT NULL DEFAULT '0',
   "mail_recalled" smallint NOT NULL DEFAULT '0',
   "mail_obscured" smallint NOT NULL DEFAULT '0',
+  "mail_raw" smallint NOT NULL DEFAULT '0',
   "created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "expires" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   PRIMARY KEY ("id")
-- 
cgit v1.2.3

