1 files changed, 6 insertions, 3 deletions
diff --git a/golang/pkg/database/sql/001_trading.sql b/golang/pkg/database/sql/001_trading.sql
index 68f2568..e218962 100644
--- a/golang/pkg/database/sql/001_trading.sql
+++ b/golang/pkg/database/sql/001_trading.sql
@@ -4,13 +4,16 @@ CREATE TABLE agents (
 );
 CREATE TABLE markets (
   id INTEGER PRIMARY KEY,
-  systemSymbol TEXT NOT NULL,
   data JSON NOT NULL,
   updated DATE NOT NULL
 );
-CREATE INDEX markets_systemSymbol on markets (systemSymbol);
 CREATE UNIQUE INDEX markets_data_symbol on markets(json_extract(data, '$.symbol'));
-
+CREATE TABLE shipyards (
+       id INTEGER PRIMARY KEY,
+       data JSON NOT NULL,
+       updated DATE DEFAULT NULL
+);
+CREATE UNIQUE INDEX shipyards_data_symbol on shipyards (json_extract(data, '$.symbol'));
 CREATE TABLE systems (
   id INTEGER PRIMARY KEY,
   data JSON NOT NULL