summaryrefslogtreecommitdiff
path: root/database/002_ships.sql
diff options
context:
space:
mode:
Diffstat (limited to 'database/002_ships.sql')
-rw-r--r--database/002_ships.sql6
1 files changed, 0 insertions, 6 deletions
diff --git a/database/002_ships.sql b/database/002_ships.sql
deleted file mode 100644
index 629f739..0000000
--- a/database/002_ships.sql
+++ /dev/null
@@ -1,6 +0,0 @@
-CREATE TABLE ships (
- id INTEGER PRIMARY KEY,
- data JSON NOT NULL,
- updated DATE DEFAULT NULL
-);
-CREATE UNIQUE INDEX ships_data_symbol on ships (json_extract(data, '$.symbol'));