--- /dev/null
+CREATE TABLE network (
+ networkid serial NOT NULL PRIMARY KEY,
+ userid integer NOT NULL REFERENCES quasseluser (userid) ON DELETE CASCADE,
+ networkname varchar(32) NOT NULL,
+ identityid integer REFERENCES identity (identityid) ON DELETE SET NULL,
+ encodingcodec varchar(32) NOT NULL DEFAULT 'ISO-8859-15',
+ decodingcodec varchar(32) NOT NULL DEFAULT 'ISO-8859-15',
+ servercodec varchar(32),
+ userandomserver boolean NOT NULL DEFAULT FALSE,
+ perform TEXT,
+ useautoidentify boolean NOT NULL DEFAULT FALSE,
+ autoidentifyservice varchar(128),
+ autoidentifypassword varchar(128),
+ useautoreconnect boolean NOT NULL DEFAULT TRUE,
+ autoreconnectinterval integer NOT NULL DEFAULT 0,
+ autoreconnectretries integer NOT NULL DEFAULT 0,
+ unlimitedconnectretries boolean NOT NULL DEFAULT FALSE,
+ rejoinchannels boolean NOT NULL DEFAULT FALSE,
+ connected boolean NOT NULL DEFAULT FALSE,
+ usermode varchar(32), -- user mode to restore
+ awaymessage varchar(256), -- 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)
+)