diff options
| author |  Sadie Powell | 2024-07-01 12:06:45 +0100 |
|---|---|---|
| committer | Sadie Powell | 2024-07-01 12:06:45 +0100 |
| commit | de1ede1ebcbfb18d38bbe44343b69936476ccca6 (patch) | |
| tree | da8165e873fec12549ecbb7ac873d8e30dc6be32 /docs/sql/log_sql | |
| parent | Fix a typo in the example config. (diff) | |
Fix the log_sql module schema allowing null columns.
Diffstat (limited to 'docs/sql/log_sql')
| -rw-r--r-- | docs/sql/log_sql/mysql.sql | 7 | ||||
| -rw-r--r-- | docs/sql/log_sql/pgsql.sql | 7 | ||||
| -rw-r--r-- | docs/sql/log_sql/schema.dbml | 6 | ||||
| -rw-r--r-- | docs/sql/log_sql/sqlite3.sql | 9 |
4 files changed, 13 insertions, 16 deletions
diff --git a/docs/sql/log_sql/mysql.sql b/docs/sql/log_sql/mysql.sql index 278bf3789..90ed4d60e 100644 --- a/docs/sql/log_sql/mysql.sql +++ b/docs/sql/log_sql/mysql.sql @@ -1,6 +1,5 @@ CREATE TABLE IF NOT EXISTS `ircd_log` ( - `time` datetime, - `type` varchar(50), - `message` text + `time` datetime NOT NULL, + `type` varchar(50) NOT NULL, + `message` text NOT NULL ); - diff --git a/docs/sql/log_sql/pgsql.sql b/docs/sql/log_sql/pgsql.sql index cfe3b3681..8f0e15bf9 100644 --- a/docs/sql/log_sql/pgsql.sql +++ b/docs/sql/log_sql/pgsql.sql @@ -1,6 +1,5 @@ CREATE TABLE IF NOT EXISTS "ircd_log" ( - "time" datetime, - "type" varchar(50), - "message" text + "time" datetime NOT NULL, + "type" varchar(50) NOT NULL, + "message" text NOT NULL ); - diff --git a/docs/sql/log_sql/schema.dbml b/docs/sql/log_sql/schema.dbml index 1d5155200..fe5d44c5f 100644 --- a/docs/sql/log_sql/schema.dbml +++ b/docs/sql/log_sql/schema.dbml @@ -1,5 +1,5 @@ Table ircd_log { - time datetime - type varchar(50) - message text + time datetime [not null] + type varchar(50) [not null] + message text [not null] } diff --git a/docs/sql/log_sql/sqlite3.sql b/docs/sql/log_sql/sqlite3.sql index 791712704..8f0e15bf9 100644 --- a/docs/sql/log_sql/sqlite3.sql +++ b/docs/sql/log_sql/sqlite3.sql @@ -1,6 +1,5 @@ -CREATE TABLE "ircd_log" ( - "time" datetime, - "type" varchar(50), - "message" text +CREATE TABLE IF NOT EXISTS "ircd_log" ( + "time" datetime NOT NULL, + "type" varchar(50) NOT NULL, + "message" text NOT NULL ); - |