--- /dev/null
+create TABLE buffer (
+ bufferid serial PRIMARY KEY,
+ userid integer NOT NULL REFERENCES quasseluser (userid) ON DELETE CASCADE,
+ groupid integer,
+ networkid integer NOT NULL REFERENCES network (networkid) ON DELETE CASCADE,
+ buffername varchar(128) NOT NULL,
+ buffercname varchar(128) NOT NULL, -- CANONICAL BUFFER NAME (lowercase version)
+ buffertype integer NOT NULL DEFAULT 0,
+ lastseenmsgid integer NOT NULL DEFAULT 0,
+ markerlinemsgid integer NOT NULL DEFAULT 0,
+ key varchar(128),
+ joined boolean NOT NULL DEFAULT FALSE, -- BOOL
+ UNIQUE(userid, networkid, buffercname)
+)