From 312ef2eb5792cd145d6829e2abc017dd304c5819 Mon Sep 17 00:00:00 2001
From: Julien Dessaux
Date: Wed, 19 Feb 2025 00:19:58 +0100
Subject: [golang] implement trading and contracting

---
 golang/pkg/database/sql/001_trading.sql | 2 --
 1 file changed, 2 deletions(-)

(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 89dd77c..e218962 100644
--- a/golang/pkg/database/sql/001_trading.sql
+++ b/golang/pkg/database/sql/001_trading.sql
@@ -4,11 +4,9 @@ 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,
-- 
cgit v1.2.3

