/quassel-0.7.3/src/core/SQL/SQLite/17/setup_020_network.sql

 1CREATE TABLE network (
 2       networkid INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 3       userid INTEGER NOT NULL,
 4       networkname TEXT NOT NULL,
 5       identityid INTEGER NOT NULL DEFAULT 1,
 6       encodingcodec TEXT NOT NULL DEFAULT "ISO-8859-15",
 7       decodingcodec TEXT NOT NULL DEFAULT "ISO-8859-15",
 8       servercodec TEXT NOT NULL DEFAULT "",
 9       userandomserver INTEGER NOT NULL DEFAULT 0, -- BOOL
10       perform TEXT,
11       useautoidentify INTEGER NOT NULL DEFAULT 0, -- BOOL
12       autoidentifyservice TEXT,
13       autoidentifypassword TEXT,
14       usesasl INTEGER NOT NULL DEFAULT 0, -- BOOL
15       saslaccount TEXT,
16       saslpassword TEXT,
17       useautoreconnect INTEGER NOT NULL DEFAULT 0, -- BOOL
18       autoreconnectinterval INTEGER NOT NULL DEFAULT 0,
19       autoreconnectretries INTEGER NOT NULL DEFAULT 0,
20       unlimitedconnectretries INTEGER NOT NULL DEFAULT 0, -- BOOL
21       rejoinchannels INTEGER NOT NULL DEFAULT 0, -- BOOL
22       connected INTEGER NOT NULL DEFAULT 0, -- BOOL
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       UNIQUE (userid, networkname)
28)