AppFlowy/frontend/rust-lib/flowy-database/migrations/2021-09-22-074638_revision/up.sql

-- Your SQL goes here
CREATE TABLE rev_table (
    id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    doc_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,
    ty INTEGER NOT NULL DEFAULT 0
);