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/mysql.sql   | 7 +++----
 docs/sql/log_sql/pgsql.sql   | 7 +++----
 docs/sql/log_sql/schema.dbml | 6 +++---
 docs/sql/log_sql/sqlite3.sql | 9 ++++-----
 4 files changed, 13 insertions(+), 16 deletions(-)

(limited to 'docs/sql/log_sql')

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