summaryrefslogtreecommitdiff
path: root/docs/sql/log_sql/sqlite3.sql
diff options
context:
space:
mode:
authorGravatar Sadie Powell2024-07-01 12:06:45 +0100
committerGravatar Sadie Powell2024-07-01 12:06:45 +0100
commitde1ede1ebcbfb18d38bbe44343b69936476ccca6 (patch)
treeda8165e873fec12549ecbb7ac873d8e30dc6be32 /docs/sql/log_sql/sqlite3.sql
parentFix a typo in the example config. (diff)
Fix the log_sql module schema allowing null columns.
Diffstat (limited to 'docs/sql/log_sql/sqlite3.sql')
-rw-r--r--docs/sql/log_sql/sqlite3.sql9
1 files changed, 4 insertions, 5 deletions
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
);
-