1 files changed, 31 insertions, 10 deletions
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
+);