diff options
author | Stelios Fragkakis <52996999+stelfrag@users.noreply.github.com> | 2022-07-15 11:46:56 +0300 |
---|---|---|
committer | Stelios Fragkakis <52996999+stelfrag@users.noreply.github.com> | 2022-07-15 12:05:51 +0300 |
commit | a8ebafe86f8f6a5573693832c68ffdca29abd8c1 (patch) | |
tree | 23c2e2e4615eee4be347f242db1390a86a0279a0 | |
parent | 2e67e2abcfeb34d776e058fd1c11c52b271bee2d (diff) |
Add constrains to the host table
-rw-r--r-- | database/sqlite/sqlite_db_migration.c | 14 | ||||
-rw-r--r-- | 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, " |