X-Git-Url: https://git.quassel-irc.org/?a=blobdiff_plain;f=src%2Fcore%2FSQL%2FPostgreSQL%2F18%2Fsetup_040_network.sql;fp=src%2Fcore%2FSQL%2FPostgreSQL%2F18%2Fsetup_040_network.sql;h=0000000000000000000000000000000000000000;hb=7d30b18136eecbdf2089e5d5877c7e41c6f4bcb6;hp=8515c95ff56df230d49476adb676fbec30f2a550;hpb=3a5df5589e3cbefcaad966ba23643d58d4ec9768;p=quassel.git

diff --git a/src/core/SQL/PostgreSQL/18/setup_040_network.sql b/src/core/SQL/PostgreSQL/18/setup_040_network.sql
deleted file mode 100644
index 8515c95f..00000000
--- a/src/core/SQL/PostgreSQL/18/setup_040_network.sql
+++ /dev/null
@@ -1,28 +0,0 @@
-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),
-       usesasl boolean NOT NULL DEFAULT FALSE,
-       saslaccount varchar(128),
-       saslpassword 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)
-)