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?
1 Like
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!