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 | |
| 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')
| -rw-r--r-- | docs/sql/sqloper/mysql.sql | 1 | ||||
| -rw-r--r-- | docs/sql/sqloper/pgsql.sql | 3 | ||||
| -rw-r--r-- | docs/sql/sqloper/sqlite3.sql | 1 |
3 files changed, 4 insertions, 1 deletions
diff --git a/docs/sql/sqloper/mysql.sql b/docs/sql/sqloper/mysql.sql index 7c7d20d1d..a8cf14e65 100644 --- a/docs/sql/sqloper/mysql.sql +++ b/docs/sql/sqloper/mysql.sql @@ -1,5 +1,6 @@ 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, 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, diff --git a/docs/sql/sqloper/sqlite3.sql b/docs/sql/sqloper/sqlite3.sql index 0e54c1351..83aa20c6e 100644 --- a/docs/sql/sqloper/sqlite3.sql +++ b/docs/sql/sqloper/sqlite3.sql @@ -1,5 +1,6 @@ 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, |