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 lastseenmsgid integer NOT NULL DEFAULT 0,
10 markerlinemsgid integer NOT NULL DEFAULT 0,
12 joined boolean NOT NULL DEFAULT FALSE, -- BOOL
13 UNIQUE(userid, networkid, buffercname)