diff options
Diffstat (limited to 'haskell/src/SpaceTraders/Database.hs')
-rw-r--r-- | haskell/src/SpaceTraders/Database.hs | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/haskell/src/SpaceTraders/Database.hs b/haskell/src/SpaceTraders/Database.hs index ac3aa7b..4fffb07 100644 --- a/haskell/src/SpaceTraders/Database.hs +++ b/haskell/src/SpaceTraders/Database.hs @@ -31,7 +31,12 @@ migrations = [ id INTEGER PRIMARY KEY, data TEXT NOT NULL );|], - [r|CREATE UNIQUE INDEX ships_data_symbol ON ships (json_extract(data, '$.symbol'));|]] + [r|CREATE UNIQUE INDEX ships_data_symbol ON ships (json_extract(data, '$.symbol'));|], + [r|CREATE TABLE systems ( + id INTEGER PRIMARY KEY, + data TEXT NOT NULL + );|], + [r|CREATE UNIQUE INDEX systems_data_symbol ON systems (json_extract(data, '$.symbol'));|]] close :: S.Connection -> IO () close conn = S.close conn |