waveterm/wavesrv/db/migrations/000027_historyupdates.down.sql
Mike Sawka 2f7cce294c
big update to screen/session delete, and clear (#199)
* sync schema.sql with running schema

* remove incognito field from history table. also don't add empty FeState vars

* history updates, add festate, durationms, exitcode, status, and tags into history table

* update screen/session delete, and clear to no longer purge history items.  move deleted screens/sessions into a tombstone table.

* update schema

* fix alias -> fn

* quiet the security warning about an unchecked byte conversion. no real security issue here, but add a range check for good measure.
2023-12-27 13:11:53 -08:00

11 lines
339 B
SQL

ALTER TABLE history ADD COLUMN incognito boolean NOT NULL DEFAULT false;
ALTER TABLE history DROP COLUMN exitcode;
ALTER TABLE history DROP COLUMN durationms;
ALTER TABLE history DROP COLUMN festate;
ALTER TABLE history DROP COLUMN tags;
ALTER TABLE history DROP COLUMN status;
DROP TABLE session_tombstone;
DROP TABLE screen_tombstone;