2 bufferid INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
3 userid INTEGER NOT NULL,
5 networkid INTEGER NOT NULL,
6 buffername TEXT NOT NULL,
7 buffercname TEXT NOT NULL, -- CANONICAL BUFFER NAME (lowercase version)
8 buffertype INTEGER NOT NULL DEFAULT 0,
9 lastmsgid INTEGER NOT NULL DEFAULT 0,
10 lastseenmsgid INTEGER NOT NULL DEFAULT 0,
11 markerlinemsgid INTEGER NOT NULL DEFAULT 0,
13 joined INTEGER NOT NULL DEFAULT 0, -- BOOL
14 CHECK (lastseenmsgid <= lastmsgid)