+CREATE TABLE network (
+ networkid INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+ userid INTEGER NOT NULL,
+ networkname TEXT NOT NULL,
+ identityid INTEGER NOT NULL DEFAULT 1,
+ encodingcodec TEXT NOT NULL DEFAULT "ISO-8859-15",
+ decodingcodec TEXT NOT NULL DEFAULT "ISO-8859-15",
+ servercodec TEXT NOT NULL DEFAULT "",
+ userandomserver INTEGER NOT NULL DEFAULT 0, -- BOOL
+ perform TEXT,
+ useautoidentify INTEGER NOT NULL DEFAULT 0, -- BOOL
+ autoidentifyservice TEXT,
+ autoidentifypassword TEXT,
+ useautoreconnect INTEGER NOT NULL DEFAULT 0, -- BOOL
+ autoreconnectinterval INTEGER NOT NULL DEFAULT 0,
+ autoreconnectretries INTEGER NOT NULL DEFAULT 0,
+ unlimitedconnectretries INTEGER NOT NULL DEFAULT 0, -- BOOL
+ rejoinchannels INTEGER NOT NULL DEFAULT 0, -- BOOL
+ connected INTEGER NOT NULL DEFAULT 0, -- BOOL
+ usermode TEXT, -- user mode to restore
+ awaymessage TEXT, -- away message to restore (empty if not away)
+ attachperform TEXT, -- perform list for on attach
+ detachperform TEXT, -- perform list for on detach
+ UNIQUE (userid, networkname)
+)