2 bufferid serial PRIMARY KEY,
3 userid integer NOT NULL REFERENCES quasseluser (userid) ON DELETE CASCADE,
5 networkid integer NOT NULL REFERENCES network (networkid) ON DELETE CASCADE,
6 buffername varchar(128) NOT NULL,
7 buffercname varchar(128) 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 boolean NOT NULL DEFAULT FALSE, -- BOOL
14 UNIQUE(userid, networkid, buffercname),
15 CHECK (buffer.lastseenmsgid <= buffer.lastmsgid)