From d7f4526a00dba2c6a97bc4c231f57c7aa179a691 Mon Sep 17 00:00:00 2001
From: zotlabs <mike@macgirvin.com>
Date: Wed, 12 Apr 2017 17:32:28 -0700
Subject: backend infrastructure for 'channel protection password'; which will
 be used to optionally encrypt export files and resolve channel/identity
 ownership/hijacking disputes

---
 install/schema_postgres.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

(limited to 'install/schema_postgres.sql')

diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index e78425828..1a5fe942f 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -170,7 +170,7 @@ CREATE TABLE "attach" (
   "is_photo" smallint NOT NULL DEFAULT '0',
   "os_storage" smallint NOT NULL DEFAULT '0',
   "os_path" text NOT NULL,
-  "display_path" text NOT NULL,
+4  "display_path" text NOT NULL,
   "content" bytea NOT NULL,
   "created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
   "edited" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00',
@@ -280,6 +280,8 @@ CREATE TABLE "channel" (
   "channel_removed" smallint NOT NULL DEFAULT '0',
   "channel_system" smallint NOT NULL DEFAULT '0',
   "channel_moved" text NOT NULL DEFAULT '',
+  "channel_password" varchar(255) NOT NULL,
+  "channel_salt" varchar(255) NOT NULL,
   PRIMARY KEY ("channel_id"),
   UNIQUE ("channel_address")
 );
-- 
cgit v1.2.3

