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.

1 files changed, 9 insertions, 6 deletions

diff --git a/extras/m_sqloper.postgresql.sql b/extras/m_sqloper.postgresql.sql
index 4244abc22..0b3cdb8dc 100644
--- a/extras/m_sqloper.postgresql.sql
+++ b/extras/m_sqloper.postgresql.sql
@@ -1,10 +1,13 @@
 CREATE TABLE ircd_opers (
-    id serial NOT NULL,
-    username text,
-    "password" text,
-    hostname text,
-    "type" text,
-    active boolean NOT NULL DEFAULT 1
+    "id" serial NOT NULL,
+    "name" text NOT NULL,
+    "password" text NOT NULL,
+    "hash" text,
+    "host" text NOT NULL,
+    "type" text NOT NULL,
+    "fingerprint" text,
+    "autologin" boolean NOT NULL DEFAULT 0,
+    "active" boolean NOT NULL DEFAULT 1
 );
 ALTER TABLE ONLY ircd_opers
     ADD CONSTRAINT ircd_opers_pkey PRIMARY KEY (id);