From f89af1145d350b1516659f6b2c7ab1e49522da19 Mon Sep 17 00:00:00 2001
From: Julien Dessaux
Date: Sun, 3 Sep 2023 23:01:18 +0200
Subject: [javascript] refactored ships and systems database interface

---
 nodejs/database/002_ships.sql | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

(limited to 'nodejs/database/002_ships.sql')

diff --git a/nodejs/database/002_ships.sql b/nodejs/database/002_ships.sql
index 3ead742..32b6ffb 100644
--- a/nodejs/database/002_ships.sql
+++ b/nodejs/database/002_ships.sql
@@ -1,6 +1,5 @@
 CREATE TABLE ships (
        id INTEGER PRIMARY KEY,
-       data JSON NOT NULL,
-       updated DATE DEFAULT NULL
+       data JSON NOT NULL
 );
 CREATE UNIQUE INDEX ships_data_symbol ON ships (json_extract(data, '$.symbol'));
-- 
cgit v1.2.3