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,
11 joined boolean NOT NULL DEFAULT FALSE, -- BOOL
12 UNIQUE(userid, networkid, buffercname)