2 networkid serial NOT NULL PRIMARY KEY,
3 userid integer NOT NULL REFERENCES quasseluser (userid) ON DELETE CASCADE,
4 networkname TEXT NOT NULL,
5 identityid integer REFERENCES identity (identityid) ON DELETE SET NULL,
6 encodingcodec TEXT NOT NULL DEFAULT 'ISO-8859-15',
7 decodingcodec TEXT NOT NULL DEFAULT 'ISO-8859-15',
9 userandomserver boolean NOT NULL DEFAULT FALSE,
11 useautoidentify boolean NOT NULL DEFAULT FALSE,
12 autoidentifyservice TEXT,
13 autoidentifypassword TEXT,
14 usesasl boolean NOT NULL DEFAULT FALSE,
17 useautoreconnect boolean NOT NULL DEFAULT TRUE,
18 autoreconnectinterval integer NOT NULL DEFAULT 0,
19 autoreconnectretries integer NOT NULL DEFAULT 0,
20 unlimitedconnectretries boolean NOT NULL DEFAULT FALSE,
21 rejoinchannels boolean NOT NULL DEFAULT FALSE,
22 connected boolean NOT NULL DEFAULT FALSE,
23 usermode TEXT, -- user mode to restore
24 awaymessage TEXT, -- away message to restore (empty if not away)
25 attachperform text, -- perform list for on attach
26 detachperform text, -- perform list for on detach
27 usecustomessagerate boolean NOT NULL DEFAULT FALSE, -- Custom rate limiting
28 messagerateburstsize INTEGER NOT NULL DEFAULT 5, -- Maximum messages at once
29 messageratedelay INTEGER NOT NULL DEFAULT 2200, -- Delay between future messages (milliseconds)
30 unlimitedmessagerate boolean NOT NULL DEFAULT FALSE, -- Disable rate limits
31 UNIQUE (userid, networkname)