From a8ebafe86f8f6a5573693832c68ffdca29abd8c1 Mon Sep 17 00:00:00 2001
From: Stelios Fragkakis <52996999+stelfrag@users.noreply.github.com>
Date: Fri, 15 Jul 2022 11:46:56 +0300
Subject: Add constrains to the host table

---
 database/sqlite/sqlite_db_migration.c | 14 +++++++-------
 database/sqlite/sqlite_functions.c    | 11 ++++++-----
 2 files changed, 13 insertions(+), 12 deletions(-)

diff --git a/database/sqlite/sqlite_db_migration.c b/database/sqlite/sqlite_db_migration.c
index ce9c8fe501..196e5a875e 100644
--- a/database/sqlite/sqlite_db_migration.c
+++ b/database/sqlite/sqlite_db_migration.c
@@ -35,13 +35,13 @@ const char *database_migrate_v1_v2[] = {
 };
 
 const char *database_migrate_v2_v3[] = {
-    "ALTER TABLE host ADD memory_mode INT;",
-    "ALTER TABLE host ADD abbrev_timezone TEXT;",
-    "ALTER TABLE host ADD utc_offset INT;",
-    "ALTER TABLE host ADD program_name TEXT;",
-    "ALTER TABLE host ADD program_version TEXT;",
-    "ALTER TABLE host ADD entries INT;",
-    "ALTER TABLE host ADD health_enabled INT;",
+    "ALTER TABLE host ADD memory_mode INT NOT NULL DEFAULT 0;",
+    "ALTER TABLE host ADD abbrev_timezone TEXT NOT NULL DEFAULT 'unknown';",
+    "ALTER TABLE host ADD utc_offset INT NOT NULL DEFAULT 0;",
+    "ALTER TABLE host ADD program_name TEXT NOT NULL DEFAULT 'unknown';",
+    "ALTER TABLE host ADD program_version TEXT NOT NULL DEFAULT 'unknown';",
+    "ALTER TABLE host ADD entries INT NOT NULL DEFAULT 0;",
+    "ALTER TABLE host ADD health_enabled INT NOT NULL DEFAULT 0;",
     NULL
 };
 
diff --git a/database/sqlite/sqlite_functions.c b/database/sqlite/sqlite_functions.c
index 7a62d3a8b6..f100a393cc 100644
--- a/database/sqlite/sqlite_functions.c
+++ b/database/sqlite/sqlite_functions.c
@@ -6,11 +6,12 @@
 #define DB_METADATA_VERSION 3
 
 const char *database_config[] = {
-    "CREATE TABLE IF NOT EXISTS host(host_id BLOB PRIMARY KEY, hostname TEXT, "
-    "registry_hostname TEXT, update_every INT, "
-    "os TEXT, timezone TEXT, tags TEXT, hops INT"
-    "memory_mode INT, abbrev_timezone TEXT, utc_offset INT, program_name TEXT, program_version TEXT, entries INT,"
-    "health_enabled INT);",
+    "CREATE TABLE IF NOT EXISTS host(host_id BLOB PRIMARY KEY, hostname TEXT NOT NULL, "
+    "registry_hostname TEXT NOT NULL, update_every INT NOT NULL, "
+    "os TEXT NOT NULL, timezone TEXT NOT NULL, tags TEXT NOT NULL, hops INT NOT NULL,"
+    "memory_mode INT, abbrev_timezone TEXT, utc_offset INT NOT NULL, "
+    "program_name TEXT NOT NULL, program_version TEXT NOT NULL, entries INT,"
+    "health_enabled INT NOT NULL);",
 
     "CREATE TABLE IF NOT EXISTS chart(chart_id blob PRIMARY KEY, host_id blob, type text, id text, name text, "
     "family text, context text, title text, unit text, plugin text, module text, priority int, update_every int, "
-- 
cgit v1.2.3