Refactor m_sqloper to be a full opers.conf replacement (#983).

[user/henk/code/inspircd.git] / extras / m_sqloper.mysql.sql

diff --git a/extras/m_sqloper.mysql.sql b/extras/m_sqloper.mysql.sql
index f4349580682b2903d2f21156cb3214fb53c39b86..a8a2b7e1db9049dd81f361b5701493db9e23b495 100644 (file)
--- 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;