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, usesasl INTEGER NOT NULL DEFAULT 0, -- BOOL saslaccount TEXT, saslpassword 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 usecustomessagerate INTEGER NOT NULL DEFAULT 0, -- BOOL - Custom rate limiting messagerateburstsize INTEGER NOT NULL DEFAULT 5, -- Maximum messages at once messageratedelay INTEGER NOT NULL DEFAULT 2200, -- Delay between future messages (milliseconds) unlimitedmessagerate INTEGER NOT NULL DEFAULT 0, -- BOOL - Disable rate limits UNIQUE (userid, networkname) )