Changeset 95 in code for trunk/schema.sql

Timestamp:

Mar 13, 2020, 2:12:44 PM (5 years ago)

Author:

contact

Message:

Add support for SASL authentication

We now store SASL credentials in the database and automatically populate
them on NickServ REGISTER/IDENTIFY.

References: ​https://todo.sr.ht/~emersion/jounce/10

File:

• trunk/schema.sql (modified) (1 diff)

trunk/schema.sql

@@ -12 +12 @@
         realname VARCHAR(255),
         pass VARCHAR(255),
+        sasl_mechanism VARCHAR(255),
+        sasl_plain_username VARCHAR(255),
+        sasl_plain_password VARCHAR(255),
         FOREIGN KEY(user) REFERENCES User(username),
         UNIQUE(user, addr, nick)