DocumentRevisions-100 的数据库结构

CREATE TABLE files (
    file_row_id     INTEGER PRIMARY KEY ASC,
    file_name       TEXT,
    file_parent_id  INTEGER,
    file_path       TEXT,
    file_inode      INTEGER,
    file_last_seen  INTEGER NOT NULL DEFAULT 0,
    file_status     INTEGER NOT NULL DEFAULT 1,
    file_storage_id INTEGER NOT NULL
);

CREATE TABLE generations (
    generation_id         INTEGER PRIMARY KEY ASC,
    generation_storage_id INTEGER NOT NULL,
    generation_name       TEXT NOT NULL,
    generation_client_id  TEXT NOT NULL,
    generation_path       TEXT UNIQUE,
    generation_options    INTEGER NOT NULL DEFAULT 1,
    generation_status     INTEGER NOT NULL DEFAULT 1,
    generation_add_time   INTEGER NOT NULL DEFAULT 0,
    generation_size       INTEGER NOT NULL DEFAULT 0
);

CREATE TABLE storage (
    storage_id      INTEGER PRIMARY KEY ASC AUTOINCREMENT,
    storage_options INTEGER NOT NULL DEFAULT 1,
    storage_status  INTEGER NOT NULL DEFAULT 1
);