Hi, I think the new simulations (v3.5+) might be missing some information that was present in the older sims. In particular, I have been using the ‘note’ column to identify deep drilling fields etc, but in the new simulations this column appears to be empty?
Yes, sorry about that, we modified the scheme so note
became scheduler_note
.
If you want to update an old database to the new schema, from the command line:
sqlite3 some_simulation_file_v3.x_10yrs.db "ALTER TABLE observations ADD scheduler_note VARCHAR;" "UPDATE observations SET scheduler_note=note;" ".exit"
1 Like
Ah great, I see! Apologies, I didn’t see scheduler_note
, thanks for the snippet!