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