first version of postgres backend

[quassel.git] / src / core / SQL / PostgreSQL / 14 / setup_040_network.sql

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 (file)
index 0000000..87f48b4
--- /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)
+)