X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2F14%2Fsetup_040_network.sql;fp=src%2Fcore%2FSQL%2FPostgreSQL%2F14%2Fsetup_040_network.sql;h=87f48b444907a99ac400ad8a47e6eebf3c24f306;hp=0000000000000000000000000000000000000000;hb=029c6d402af7b00b320dd5ce48f230783a88957a;hpb=7082ea3159aaaea098b34c204d5123a3dca3753a

diff --git a/src/core/SQL/PostgreSQL/14/setup_040_network.sql b/src/core/SQL/PostgreSQL/14/setup_040_network.sql
new file mode 100644
index 00000000..87f48b44
--- /dev/null
+++ b/src/core/SQL/PostgreSQL/14/setup_040_network.sql
@@ -0,0 +1,25 @@
+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)
+)