aboutsummaryrefslogtreecommitdiff
path: root/docs/sql/sqloper/pgsql.sql
diff options
context:
space:
mode:
Diffstat (limited to 'docs/sql/sqloper/pgsql.sql')
-rw-r--r--docs/sql/sqloper/pgsql.sql3
1 files changed, 2 insertions, 1 deletions
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,