Nathan.fooo ba482a30a3
chore: recreate snapshot table & remove old data (#4322)
* chore: recreate snapshot table & remove old data

* chore: disable test

* chore: fmt
2024-01-07 13:59:39 +08:00

15 lines
453 B
SQL

-- Your SQL goes here
-- Drop the table if it exists
DROP TABLE IF EXISTS rocksdb_backup;
DROP TABLE IF EXISTS collab_snapshot;
-- Recreate the table
CREATE TABLE collab_snapshot (
id TEXT NOT NULL PRIMARY KEY DEFAULT '',
object_id TEXT NOT NULL DEFAULT '',
title TEXT NOT NULL DEFAULT '',
desc TEXT NOT NULL DEFAULT '',
collab_type TEXT NOT NULL DEFAULT '',
timestamp BIGINT NOT NULL DEFAULT 0,
data BLOB NOT NULL DEFAULT (x'')
);