diff options
author | Julien Dessaux | 2023-06-15 01:02:03 +0200 |
---|---|---|
committer | Julien Dessaux | 2023-06-15 01:02:03 +0200 |
commit | 93e6e02bcafaac0a57b7c1d98dca5ba52f32684b (patch) | |
tree | 965134bd28dab9acf6c313a78ea1099e60126406 /database/003_surveys.sql | |
parent | Fixed api errors and some async issues (diff) | |
download | spacetraders-93e6e02bcafaac0a57b7c1d98dca5ba52f32684b.tar.gz spacetraders-93e6e02bcafaac0a57b7c1d98dca5ba52f32684b.tar.bz2 spacetraders-93e6e02bcafaac0a57b7c1d98dca5ba52f32684b.zip |
Began implementing surveying
Diffstat (limited to 'database/003_surveys.sql')
-rw-r--r-- | database/003_surveys.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/database/003_surveys.sql b/database/003_surveys.sql new file mode 100644 index 0000000..0548796 --- /dev/null +++ b/database/003_surveys.sql @@ -0,0 +1,6 @@ +CREATE TABLE surveys ( + id INTEGER PRIMARY KEY, + data JSON NOT NULL +); +CREATE INDEX surveys_data_symbol on surveys (json_extract(data, '$.symbol')); +CREATE INDEX surveys_data_expiration on surveys (json_extract(data, '$.expiration')); |