added pem keys to users accounts

1 files changed, 7 insertions, 1 deletions

diff --git a/databaseschema.psql b/databaseschema.psql
index eac2c34..686e682 100644
--- a/databaseschema.psql
+++ b/databaseschema.psql
@@ -207,6 +207,12 @@ id varchar(100),
 type varchar(25)
 );
 
-
 ALTER TABLE activitystream ADD COLUMN IF NOT EXISTS tripcode varchar(50) default '';
 ALTER TABLE cacheactivitystream ADD COLUMN IF NOT EXISTS tripcode varchar(50) default '';
+
+CREATE TABLE IF NOT EXISTS publicKeyPem(
+id varchar(100) UNIQUE,
+file varchar(100)
+);
+
+ALTER TABLE actor ADD COLUMN IF NOT EXISTS publicKeyPem varchar(100) default '';
\ No newline at end of file