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)