diff options
| author | Julien Dessaux | 2023-07-04 19:37:50 +0200 |
|---|---|---|
| committer | Julien Dessaux | 2023-07-04 19:37:50 +0200 |
| commit | 78c5467c4ac39869314c686d1d026482e7b3fd8f (patch) | |
| tree | 154bc89cd8f9ea87e93d7d638e41f6557daddf22 /haskell/src/SpaceTraders/Database.hs | |
| parent | [haskell] Implemented contract (diff) | |
| download | spacetraders-78c5467c4ac39869314c686d1d026482e7b3fd8f.tar.gz spacetraders-78c5467c4ac39869314c686d1d026482e7b3fd8f.tar.bz2 spacetraders-78c5467c4ac39869314c686d1d026482e7b3fd8f.zip | |
[haskell] Implemented ship
Diffstat (limited to '')
| -rw-r--r-- | haskell/src/SpaceTraders/Database.hs | 17 |
1 files changed, 9 insertions, 8 deletions
diff --git a/haskell/src/SpaceTraders/Database.hs b/haskell/src/SpaceTraders/Database.hs index fdc32d3..ac3aa7b 100644 --- a/haskell/src/SpaceTraders/Database.hs +++ b/haskell/src/SpaceTraders/Database.hs @@ -14,23 +14,24 @@ migrations :: [S.Query] migrations = [ [r|CREATE TABLE schema_version ( version INTEGER NOT NULL - ); - |], + );|], [r|CREATE TABLE tokens ( id INTEGER PRIMARY KEY, data TEXT NOT NULL - ); - |], + );|], [r|CREATE TABLE agents ( id INTEGER PRIMARY KEY, data TEXT NOT NULL - ); - |], + );|], [r|CREATE TABLE contracts ( id INTEGER PRIMARY KEY, data TEXT NOT NULL - ); - |]] + );|], + [r|CREATE TABLE ships ( + id INTEGER PRIMARY KEY, + data TEXT NOT NULL + );|], + [r|CREATE UNIQUE INDEX ships_data_symbol ON ships (json_extract(data, '$.symbol'));|]] close :: S.Connection -> IO () close conn = S.close conn |