From 4ec475ba10b65785277ed9dab5f99775289165b3 Mon Sep 17 00:00:00 2001
From: Dylan Frank <b00mx0r@aureus.pw>
Date: Fri, 6 Apr 2018 10:34:15 -0700
Subject: 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.
---
 extras/m_sqloper.mysql.sql | 11 +++++++----
 1 file changed, 7 insertions(+), 4 deletions(-)

(limited to 'extras/m_sqloper.mysql.sql')

diff --git a/extras/m_sqloper.mysql.sql b/extras/m_sqloper.mysql.sql
index f43495806..a8a2b7e1d 100644
--- a/extras/m_sqloper.mysql.sql
+++ b/extras/m_sqloper.mysql.sql
@@ -1,9 +1,12 @@
 CREATE TABLE ircd_opers (
   id bigint(20) NOT NULL auto_increment,
-  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 tinyint(1) NOT NULL DEFAULT 0,
   active tinyint(1) NOT NULL DEFAULT 1,
   PRIMARY KEY  (id)
 ) ENGINE=MyISAM;
-- 
cgit v1.2.3

