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,
12 bufferactivity integer NOT NULL DEFAULT 0,
13 highlightcount integer NOT NULL DEFAULT 0,
15 joined boolean NOT NULL DEFAULT FALSE, -- BOOL
17 UNIQUE(userid, networkid, buffercname),
18 CHECK (buffer.lastseenmsgid <= buffer.lastmsgid)