Reworked the systems handling and caching with sqlite

1 files changed, 3 insertions, 3 deletions

diff --git a/database/001_systems.sql b/database/001_systems.sql
index 8448955..9ad76b1 100644
--- a/database/001_systems.sql
+++ b/database/001_systems.sql
@@ -1,6 +1,6 @@
 CREATE TABLE systems (
        id INTEGER PRIMARY KEY,
-       symbol TEXT NOT NULL UNIQUE,
-       data TEXT NOT NULL,
-       updated DATE DEFAULT (datetime('now'))
+       data JSON NOT NULL,
+       updated DATE DEFAULT NULL
 );
+CREATE UNIQUE INDEX systems_data_symbol on systems (json_extract(data, '$.symbol'));