AppFlowy/frontend/rust-lib/flowy-database/migrations/2022-03-04-101530_flowy-grid/up.sql

-- Your SQL goes here
CREATE TABLE kv_table (
   key TEXT NOT NULL PRIMARY KEY,
   value BLOB NOT NULL DEFAULT (x'')
);

CREATE TABLE grid_rev_table (
   id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
   object_id TEXT NOT NULL DEFAULT '',
   base_rev_id BIGINT NOT NULL DEFAULT 0,
   rev_id BIGINT NOT NULL DEFAULT 0,
   data BLOB NOT NULL DEFAULT (x''),
   state INTEGER NOT NULL DEFAULT 0
);