This message was deleted.
# general
a
This message was deleted.
c
Schema for kine table in sqlite:
Copy code
CREATE TABLE kine
            (
                id INTEGER PRIMARY KEY AUTOINCREMENT,
                name INTEGER,
                created INTEGER,
                deleted INTEGER,
                create_revision INTEGER,
                prev_revision INTEGER,
                lease INTEGER,
                value BLOB,
                old_value BLOB
            );
CREATE TABLE sqlite_sequence(name,seq);
CREATE INDEX kine_name_index ON kine (name);
CREATE INDEX kine_name_id_index ON kine (name,id);
CREATE INDEX kine_id_deleted_index ON kine (id,deleted);
CREATE INDEX kine_prev_revision_index ON kine (prev_revision);
CREATE UNIQUE INDEX kine_name_prev_revision_uindex ON kine (name, prev_revision);