Add more information to the database

[mgalloy]

Add the following to the UCoMP database tables:

• SGS information
• CONTIN value — with values of "blue", "both" , "red", or "multiple"

Questions

• What else should be added?

[bberkeyU]

Should the wind speed/direction be included?

[mgalloy]

Wind speed/direction is already in ucomp_file.

[mgalloy]

The commands to add the SGS values:

alter table ucomp_raw add column sgsdeczr float after tu_c1pcb;
alter table ucomp_raw add column sgsdecs float after tu_c1pcb;
alter table ucomp_raw add column sgsdecv float after tu_c1pcb;
alter table ucomp_raw add column sgsrazr float after tu_c1pcb;
alter table ucomp_raw add column sgsras float after tu_c1pcb;
alter table ucomp_raw add column sgsrav float after tu_c1pcb;
alter table ucomp_raw add column sgsloop float after tu_c1pcb;
alter table ucomp_raw add column sgssums float after tu_c1pcb;
alter table ucomp_raw add column sgssumv float after tu_c1pcb;
alter table ucomp_raw add column sgsscint float after tu_c1pcb;
alter table ucomp_raw add column sgsdims float after tu_c1pcb;
alter table ucomp_raw add column sgsdimv float after tu_c1pcb;

[mgalloy]

To add the CONTIN value:

alter table ucomp_raw add column contin char (10) after wave_region;