diff options
| author | FChannel0 <77419041+FChannel0@users.noreply.github.com> | 2021-07-03 16:16:22 -0700 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-07-03 16:16:22 -0700 |
| commit | 875ee4c53d79918ac87d1ce3e208ad27db6c0a90 (patch) | |
| tree | fef9e3a94b09f356711fce887a42d405338dffb8 /databaseschema.psql | |
| parent | 9bd4e03d926c045dc82ce844cb02b078843ce787 (diff) | |
| parent | fc8b4d6517213a371e26938ff2c0319d5e5f459a (diff) | |
Merge pull request #27 from knotteye/master
Home page improvements and news system
Diffstat (limited to 'databaseschema.psql')
| -rw-r--r-- | databaseschema.psql | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/databaseschema.psql b/databaseschema.psql index e12813e..43767f3 100644 --- a/databaseschema.psql +++ b/databaseschema.psql @@ -216,7 +216,13 @@ owner varchar(100), file varchar(100) ); +CREATE TABLE IF NOT EXISTS newsItem( +title text, +content text, +time bigint +); + 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 +ALTER TABLE cacheactivitystream ADD COLUMN IF NOT EXISTS sensitive boolean default false; |