diff options
Diffstat (limited to 'docs/sql/sqloper')
| -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, |