From f166ef0a70339bc6a81ae86f4c084312f9d80443 Mon Sep 17 00:00:00 2001
From: Sadie Powell
Date: Mon, 1 Jul 2024 18:28:18 +0100
Subject: Fix some minor issues with the sqloper schemas.

- Only create the pgsql table if it doesn't exist.
- Separate the active column out from others.
---
 docs/sql/sqloper/pgsql.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

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

diff --git a/docs/sql/sqloper/pgsql.sql b/docs/sql/sqloper/pgsql.sql
index a572fe4a8..fe9c2857f 100644
--- a/docs/sql/sqloper/pgsql.sql
+++ b/docs/sql/sqloper/pgsql.sql
@@ -4,8 +4,9 @@ CREATE TYPE "autologin" AS ENUM (
   'never'
 );
 
-CREATE TABLE "ircd_opers" (
+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,
-- 
cgit v1.3.1-10-gc9f91

