1 files changed, 2 insertions, 1 deletions
diff --git a/loader/sql/schema.sql b/loader/sql/schema.sql
index ff8e5d3..b6cf49f 100644
--- a/loader/sql/schema.sql
+++ b/loader/sql/schema.sql
@@ -11,7 +11,8 @@ CREATE TABLE messages (
    date timestamptz NOT NULL,
    has_attachment boolean NOT NULL,
    messageid text NOT NULL,
-   bodytxt text NOT NULL
+   bodytxt text NOT NULL,
+   rawtxt text NOT NULL
 );
 CREATE INDEX idx_messages_threadid ON messages(threadid);
 CREATE UNIQUE INDEX idx_messages_msgid ON messages(messageid);