summaryrefslogtreecommitdiff
path: root/extras/m_sqloper.sqlite3.sql
diff options
context:
space:
mode:
authorDylan Frank <b00mx0r@aureus.pw>2018-04-06 10:34:15 -0700
committerPeter Powell <petpow@saberuk.com>2018-04-06 18:34:15 +0100
commit4ec475ba10b65785277ed9dab5f99775289165b3 (patch)
tree63f05ba29fbfd0149b8bab84c64f4ad0ef22f85c /extras/m_sqloper.sqlite3.sql
parentd04db003df83ddfdc2b5b9ae0e360335d88ae769 (diff)
Refactor m_sqloper to be a full opers.conf replacement (#983).
m_sqloper now supports dynamic fields, works with m_sslinfo, and works with /stats o.
Diffstat (limited to 'extras/m_sqloper.sqlite3.sql')
-rw-r--r--extras/m_sqloper.sqlite3.sql11
1 files changed, 7 insertions, 4 deletions
diff --git a/extras/m_sqloper.sqlite3.sql b/extras/m_sqloper.sqlite3.sql
index 1c607e664..6aec5a118 100644
--- a/extras/m_sqloper.sqlite3.sql
+++ b/extras/m_sqloper.sqlite3.sql
@@ -1,7 +1,10 @@
CREATE TABLE ircd_opers (
id integer primary key,
-username text,
-password text,
-hostname text,
-type text,
+name text NOT NULL,
+password text NOT NULL,
+hash text,
+host text NOT NULL,
+type text NOT NULL,
+fingerprint text,
+autologin integer NOT NULL DEFAULT 0,
active integer NOT NULL DEFAULT 1);