Schema changes for SASL support

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

diff --git a/src/core/SQL/PostgreSQL/15/setup_040_network.sql b/src/core/SQL/PostgreSQL/16/setup_040_network.sql
similarity index 91%
rename from src/core/SQL/PostgreSQL/15/setup_040_network.sql
rename to src/core/SQL/PostgreSQL/16/setup_040_network.sql
index 87f48b4..8515c95 100644 (file)
--- a/src/core/SQL/PostgreSQL/15/setup_040_network.sql
+++ b/src/core/SQL/PostgreSQL/16/setup_040_network.sql
@@ -11,6 +11,9 @@ CREATE TABLE network (
        useautoidentify boolean NOT NULL DEFAULT FALSE,
        autoidentifyservice varchar(128),
        autoidentifypassword varchar(128),
        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,
        useautoreconnect boolean NOT NULL DEFAULT TRUE,
        autoreconnectinterval integer NOT NULL DEFAULT 0,
        autoreconnectretries integer NOT NULL DEFAULT 0,