Add a DBML schema for the sqloper module and update the tables.

1 files changed, 36 insertions, 12 deletions

diff --git a/docs/sql/sqloper/pgsql.sql b/docs/sql/sqloper/pgsql.sql
index 954bc84fa..a572fe4a8 100644
--- a/docs/sql/sqloper/pgsql.sql
+++ b/docs/sql/sqloper/pgsql.sql
@@ -1,13 +1,37 @@
-CREATE TABLE ircd_opers (
-    "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" smallint NOT NULL DEFAULT 0,
-    "active" smallint NOT NULL DEFAULT 1
+CREATE TYPE "autologin" AS ENUM (
+  'strict',
+  'relaxed',
+  'never'
+);
+
+CREATE TABLE "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" autologin,
+  "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
 );
-ALTER TABLE ONLY ircd_opers
-    ADD CONSTRAINT ircd_opers_pkey PRIMARY KEY (id);