From de1ede1ebcbfb18d38bbe44343b69936476ccca6 Mon Sep 17 00:00:00 2001
From: Sadie Powell
Date: Mon, 1 Jul 2024 12:06:45 +0100
Subject: Fix the log_sql module schema allowing null columns.

---
 docs/sql/log_sql/sqlite3.sql | 9 ++++-----
 1 file changed, 4 insertions(+), 5 deletions(-)

(limited to 'docs/sql/log_sql/sqlite3.sql')

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
 );
-
-- 
cgit v1.3.1-10-gc9f91