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/sqlite3.sql | 41 +++++++++++++++++++++++++++++++----------
 1 file changed, 31 insertions(+), 10 deletions(-)

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

diff --git a/docs/sql/sqloper/sqlite3.sql b/docs/sql/sqloper/sqlite3.sql
index 6aec5a118..0e54c1351 100644
--- a/docs/sql/sqloper/sqlite3.sql
+++ b/docs/sql/sqloper/sqlite3.sql
@@ -1,10 +1,31 @@
-CREATE TABLE ircd_opers (
-id integer primary key,
-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);
+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" CHECK ("autologin" IN ('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

