|
Revision 1016, 1.1 KB
(checked in by goldfd, 4 years ago)
|
|
added a database migration to add the 'Figure' and 'Field Notes' image types. It also updates the image abbreviations to match those listed on the wiki. It fills the description field for the image_types as well.
|
| Line | |
|---|
| 1 | --Adds the comment values to the image types that have them
|
|---|
| 2 | --Adds two new image types
|
|---|
| 3 | insert into image_type values(nextval('image_type_seq'), 'Figure', 'FIG','Miscellaneous figure, may be composite');
|
|---|
| 4 | insert into image_type values(nextval('image_type_seq'), 'Field Notes', 'FIELDNOTES','Scanned/digital field notes');
|
|---|
| 5 | update image_type set comments = 'Map (geologic or otherwise) with sample locations' where abbreviation = 'MAP';
|
|---|
| 6 | update image_type set comments = 'Geologic cross section with sample locations' where abbreviation = 'XC';
|
|---|
| 7 | update image_type set comments = 'Field photo of outcrop or sample location', abbreviation = 'FIELDPHOTO' where abbreviation = 'FP';
|
|---|
| 8 | update image_type set comments = 'General sample imagery' where abbreviation = 'PHOTO';
|
|---|
| 9 | update image_type set comments = 'Special image of entire thin section' where abbreviation = 'TSS';
|
|---|
| 10 | update image_type set comments = 'Element name (or combo) is required for X-ray maps' where abbreviation = 'XRM';
|
|---|
| 11 | update image_type set comments = 'Hand sketch or drawing', abbreviation = 'DRAWING' where abbreviation = 'Drawing'; |
|---|
