diff options
| author | FChannel <> | 2021-05-13 22:15:52 -0700 |
|---|---|---|
| committer | FChannel <> | 2021-05-13 22:15:52 -0700 |
| commit | 20d0aee3f0bf987eb7e8999977bb25577df7b2d3 (patch) | |
| tree | 959643896353dc654a1f0be2c0c34b3a221ebf1b /databaseschema.psql | |
| parent | bd637f0f0d601d4aa5cb2dcfdf132060b4cf172c (diff) | |
moved creating database schema into main program
Diffstat (limited to 'databaseschema.psql')
| -rw-r--r-- | databaseschema.psql | 6 |
1 files changed, 5 insertions, 1 deletions
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 |