From 4718cec54aad3e95fed207d81e099df685553cb8 Mon Sep 17 00:00:00 2001
From: Sadie Powell
Date: Mon, 1 Jul 2024 12:57:04 +0100
Subject: Add a DBML schema for the sqloper module and update the tables.

---
 docs/sql/sqloper/mysql.sql | 43 +++++++++++++++++++++++++++++++------------
 1 file changed, 31 insertions(+), 12 deletions(-)

(limited to 'docs/sql/sqloper/mysql.sql')

diff --git a/docs/sql/sqloper/mysql.sql b/docs/sql/sqloper/mysql.sql
index 83dfa68a6..7c7d20d1d 100644
--- a/docs/sql/sqloper/mysql.sql
+++ b/docs/sql/sqloper/mysql.sql
@@ -1,12 +1,31 @@
-CREATE TABLE ircd_opers (
-  id bigint(20) NOT NULL auto_increment,
-  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=InnoDB;
+CREATE TABLE IF NOT EXISTS `ircd_opers` (
+  `active` bool NOT NULL DEFAULT true,
+  `name` text NOT NULL,
+  `password` text NOT NULL,
+  `host` text NOT NULL,
+  `type` text NOT NULL,
+
+  `autologin` ENUM ('strict', 'relaxed', 'never'),
+  `class` text,
+  `hash` text,
+  `maxchans` bigint,
+  `nopassword` bool,
+  `vhost` text,
+
+  `commands` text,
+  `privs` text,
+  `chanmodes` text,
+  `usermodes` text,
+  `snomasks` text,
+
+  `account` text,
+  `autojoin` text,
+  `automotd` bool,
+  `fingerprint` text,
+  `level` bigint,
+  `modes` text,
+  `motd` bool,
+  `override` text,
+  `sslonly` bool,
+  `swhois` text
+);
-- 
cgit v1.3.1-10-gc9f91

