From bd2fb50c819c2b180758308ef3751e7ea73e6ab7 Mon Sep 17 00:00:00 2001
From: Julien Dessaux
Date: Mon, 17 Feb 2025 00:40:43 +0100
Subject: [golang] implement shipyards visits

---
 golang/pkg/database/sql/001_trading.sql | 7 ++++++-
 1 file changed, 6 insertions(+), 1 deletion(-)

(limited to 'golang/pkg/database/sql/001_trading.sql')

diff --git a/golang/pkg/database/sql/001_trading.sql b/golang/pkg/database/sql/001_trading.sql
index 68f2568..89dd77c 100644
--- a/golang/pkg/database/sql/001_trading.sql
+++ b/golang/pkg/database/sql/001_trading.sql
@@ -10,7 +10,12 @@ CREATE TABLE markets (
 );
 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
-- 
cgit v1.2.3

