audio recording gain

[kdarras]

Audio recording amplification settings affect the measured sound levels (#241 ). This field should be called "recording_gain" needs to be added to the recording table and it can only contain positive integers (dB). Later, we may have an additional "added_gain" field for post-recording gain.

Users must indicate audio recording gain settings during recording upload inside the form. The meta-data may contain this information so it might be automatically extracted from there (#424 ).

[kdarras]

Changing the date for a previously-entered meta-data row resulted in an error:

To avoid that edits of any pre-existing recording table rows results in this error, the easiest fix might be that we make this a non-required field (i.e., accepting NULL values).

[kdarras]

Recording table field headers are shifted relative to their columns before upload is finished:

[kdarras]

I also managed to input a negative value without error:

This should not be allowed as gain can only be a positive integer.

[kdarras]

Sorry, ¨0¨ should also be allowed. Gain just cannot be negative.

[kdarras]

Only positive values are inserted. Zeroes are currently ignored. Zero values should be inserted.

[kdarras]

fixed and working online

[kdarras]

completed in #511