diff options
| author |  Sadie Powell | 2024-07-01 18:28:18 +0100 |
|---|---|---|
| committer | Sadie Powell | 2024-07-01 18:33:07 +0100 |
| commit | f166ef0a70339bc6a81ae86f4c084312f9d80443 (patch) | |
| tree | 99fb7b1add1aa913a83c06595b0629e2cfef858a /docs/sql/sqloper/pgsql.sql | |
| parent | Add a DBML schema for the sqloper module and update the tables. (diff) | |
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.
Diffstat (limited to 'docs/sql/sqloper/pgsql.sql')
| -rw-r--r-- | docs/sql/sqloper/pgsql.sql | 3 |
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, |