buffername TEXT NOT NULL,
buffercname TEXT NOT NULL, -- CANONICAL BUFFER NAME (lowercase version)
buffertype INTEGER NOT NULL DEFAULT 0,
- lastmsgid INTEGER NOT NULL DEFAULT 0,
+ lastmsgid INTEGER NOT NULL DEFAULT 0,
lastseenmsgid INTEGER NOT NULL DEFAULT 0,
markerlinemsgid INTEGER NOT NULL DEFAULT 0,
key TEXT,
joined INTEGER NOT NULL DEFAULT 0, -- BOOL
- ALTER TABLE buffer_new RENAME TO buffer;
+ CHECK (lastseenmsgid <= lastmsgid)
)