From 20d0aee3f0bf987eb7e8999977bb25577df7b2d3 Mon Sep 17 00:00:00 2001
From: FChannel <>
Date: Thu, 13 May 2021 22:15:52 -0700
Subject: moved creating database schema into main program

---
 databaseschema.psql | 6 +++++-
 1 file changed, 5 insertions(+), 1 deletion(-)

(limited to 'databaseschema.psql')

diff --git a/databaseschema.psql b/databaseschema.psql
index d168882..7e2443c 100644
--- a/databaseschema.psql
+++ b/databaseschema.psql
@@ -205,4 +205,8 @@ CONSTRAINT fk_object FOREIGN KEY (object) REFERENCES cacheactivitystream(id)
 CREATE TABLE IF NOT EXISTS removed(
 id varchar(100),
 type varchar(25)
-);
\ No newline at end of file
+);
+
+
+ALTER TABLE activitystream ADD COLUMN IF NOT EXISTS tripcode varchar(50) default '';
+ALTER TABLE cacheactivitystream ADD COLUMN IF NOT EXISTS tripcode varchar(50) default '';
\ No newline at end of file
-- 
cgit v1.2.3


From 30714d5e76a94947a49487f526e48a996f1d9eaa Mon Sep 17 00:00:00 2001
From: FChannel <>
Date: Fri, 14 May 2021 09:46:04 -0700
Subject: tripcode empty fix

---
 databaseschema.psql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'databaseschema.psql')

diff --git a/databaseschema.psql b/databaseschema.psql
index 7e2443c..eac2c34 100644
--- a/databaseschema.psql
+++ b/databaseschema.psql
@@ -209,4 +209,4 @@ 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 '';
\ No newline at end of file
+ALTER TABLE cacheactivitystream ADD COLUMN IF NOT EXISTS tripcode varchar(50) default '';
-- 
cgit v1.2.3


From b4e551b3db5a5fc69befeffb7fba17b50dc2e258 Mon Sep 17 00:00:00 2001
From: FChannel <>
Date: Sun, 30 May 2021 17:00:51 -0700
Subject: added pem keys to users accounts

---
 databaseschema.psql | 8 +++++++-
 1 file changed, 7 insertions(+), 1 deletion(-)

(limited to 'databaseschema.psql')

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
-- 
cgit v1.2.3


From 869b0262ac1c69fe41cc8d6bc59bd47f6e48f685 Mon Sep 17 00:00:00 2001
From: FChannel <>
Date: Sun, 30 May 2021 17:41:12 -0700
Subject: added publickeypem to actor activity requests

---
 databaseschema.psql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'databaseschema.psql')

diff --git a/databaseschema.psql b/databaseschema.psql
index 686e682..a9ede23 100644
--- a/databaseschema.psql
+++ b/databaseschema.psql
@@ -212,7 +212,8 @@ ALTER TABLE cacheactivitystream ADD COLUMN IF NOT EXISTS tripcode varchar(50) de
 
 CREATE TABLE IF NOT EXISTS publicKeyPem(
 id varchar(100) UNIQUE,
+owner varchar(100),
 file varchar(100)
 );
 
-ALTER TABLE actor ADD COLUMN IF NOT EXISTS publicKeyPem varchar(100) default '';
\ No newline at end of file
+ALTER TABLE actor ADD COLUMN IF NOT EXISTS publicKeyPem varchar(100) default '';
-- 
cgit v1.2.3


From 6b265b0a8c2e45422f4a4601e041d44e5cef1c1b Mon Sep 17 00:00:00 2001
From: FChannel <>
Date: Sat, 19 Jun 2021 18:26:14 -0700
Subject: added sensitive content checkbox for upload

---
 databaseschema.psql | 3 +++
 1 file changed, 3 insertions(+)

(limited to 'databaseschema.psql')

diff --git a/databaseschema.psql b/databaseschema.psql
index a9ede23..e12813e 100644
--- a/databaseschema.psql
+++ b/databaseschema.psql
@@ -217,3 +217,6 @@ file varchar(100)
 );
 
 ALTER TABLE actor ADD COLUMN IF NOT EXISTS publicKeyPem varchar(100) default '';
+
+ALTER TABLE activitystream ADD COLUMN IF NOT EXISTS sensitive boolean default false;
+ALTER TABLE cacheactivitystream ADD COLUMN IF NOT EXISTS sensitive boolean default false;
\ No newline at end of file
-- 
cgit v1.2.3