# # ThumbsPlus Database Creation Script for MySQL Database Server # # # This script creates a ThumbsPlus database, named "thumbs", for use with # a MySQL database server. # this script is based on work by # J.D. Hodges, Scott R. Senay, Phillip Crews, JPB, Uwe Zimmermann CREATE DATABASE "thumbsplus"; USE "thumbsplus"; #====================================================================================== # Create / Build The Database Table / Table Structures #====================================================================================== #-------------------------------------------------------------------------------------- # Table structure for table "DatabaseInfo" #-------------------------------------------------------------------------------------- CREATE TABLE "DatabaseInfo" ( "thumbnail_width" INT(11) NOT NULL, "thumbnail_height" INT(11) NOT NULL, "thumbnail_type" INT(11) NOT NULL, "compress" INT(11) NOT NULL, "alias" VARCHAR(255) DEFAULT NULL, "like_style" INT(11) NOT NULL DEFAULT '1' ) ENGINE=InnoDB; #-------------------------------------------------------------------------------------- # Table structure for table "CurrentUsers" #-------------------------------------------------------------------------------------- CREATE TABLE "CurrentUsers" ( "uid" VARCHAR(255) NOT NULL, "starttime" INT(11) DEFAULT NULL, "lasttime" INT(11) DEFAULT NULL, PRIMARY KEY ("uid") ) ENGINE=InnoDB; #-------------------------------------------------------------------------------------- # Table structure for table "FindCriteria" #-------------------------------------------------------------------------------------- CREATE TABLE "FindCriteria" ( "idList" INT(11) NOT NULL, "key" VARCHAR(255) NOT NULL, "value" VARCHAR(255) DEFAULT NULL, PRIMARY KEY ("idList","key") ) ENGINE=InnoDB; #-------------------------------------------------------------------------------------- # Table structure for table "FoundLists" #-------------------------------------------------------------------------------------- CREATE TABLE "FoundLists" ( "idList" INT(11) NOT NULL DEFAULT '0', "ListName" VARCHAR(255) NOT NULL DEFAULT '', "TableName" VARCHAR(255) NOT NULL DEFAULT '', "SQLText" TEXT, PRIMARY KEY ("idList"), UNIQUE KEY ("ListName") ) ENGINE=InnoDB; #-------------------------------------------------------------------------------------- # Table structure for table "FoundThumbs" #-------------------------------------------------------------------------------------- CREATE TABLE "FoundThumbs" ( "idList" INT(11) NOT NULL, "idThumb" INT(11) NOT NULL, "flags" INT(11) DEFAULT NULL, PRIMARY KEY ("idList","idThumb") ) ENGINE=InnoDB; #-------------------------------------------------------------------------------------- # Table structure for table "Gallery" #-------------------------------------------------------------------------------------- CREATE TABLE "Gallery" ( "idGallery" INT(11) NOT NULL AUTO_INCREMENT, "name" VARCHAR(255) DEFAULT NULL, "sortorder" INT(11) DEFAULT NULL, "descend" SMALLINT(6) DEFAULT NULL, PRIMARY KEY ("idGallery") ) ENGINE=InnoDB; #-------------------------------------------------------------------------------------- # Table structure for table "Keyword" #-------------------------------------------------------------------------------------- CREATE TABLE "Keyword" ( "idKeyword" INT(11) NOT NULL AUTO_INCREMENT, "Keyword" VARCHAR(255) NOT NULL, PRIMARY KEY ("idKeyword"), UNIQUE KEY ("Keyword") ) ENGINE=InnoDB; #-------------------------------------------------------------------------------------- # Table structure for table "Volume" #-------------------------------------------------------------------------------------- CREATE TABLE "Volume" ( "idVol" INT(11) NOT NULL AUTO_INCREMENT, "vtype" INT(11) NOT NULL, "serialno" INT(11) DEFAULT NULL, "maxcomplen" INT(11) DEFAULT NULL, "vchar" INT(11) DEFAULT NULL, "filesystem" VARCHAR(255) DEFAULT NULL, "label" VARCHAR(255) DEFAULT NULL, "netname" VARCHAR(255) DEFAULT NULL, "alias" VARCHAR(255) DEFAULT NULL, PRIMARY KEY ("idVol") ) ENGINE=InnoDB; #-------------------------------------------------------------------------------------- # Table structure for table "Path" #-------------------------------------------------------------------------------------- CREATE TABLE "Path" ( "idPath" INT(11) NOT NULL AUTO_INCREMENT, "idVol" INT(11) NOT NULL, "pathtype" INT(11) NOT NULL, "name" VARCHAR(255) NOT NULL, PRIMARY KEY ("idPath"), INDEX ("idVol"), UNIQUE KEY ("idVol","name") ) ENGINE=InnoDB; #-------------------------------------------------------------------------------------- # Table structure for table "Thumbnail" #-------------------------------------------------------------------------------------- CREATE TABLE "Thumbnail" ( "idThumb" INT(11) NOT NULL AUTO_INCREMENT, "idPath" INT(11) NOT NULL, "idFiletype" INT(11) DEFAULT NULL, "file_time" INT(11) DEFAULT NULL, "thumbnail_time" INT(11) DEFAULT NULL, "filesize" INT(11) DEFAULT NULL, "checksum" INT(11) DEFAULT NULL, "width" INT(11) DEFAULT NULL, "height" INT(11) DEFAULT NULL, "horiz_res" INT(11) DEFAULT NULL, "vert_res" INT(11) DEFAULT NULL, "colortype" SMALLINT(6) DEFAULT NULL, "colordepth" SMALLINT(6) DEFAULT NULL, "gamma" SMALLINT(6) DEFAULT NULL, "thumbnail_width" SMALLINT(6) NOT NULL, "thumbnail_height" SMALLINT(6) NOT NULL, "thumbnail_type" INT(11) DEFAULT NULL, "thumbnail_size" INT(11) DEFAULT NULL, "name" VARCHAR(255) DEFAULT NULL, "Thumbnail" LONGBLOB, "annotation" TEXT, "metric1" TINYBLOB, "metric2" TINYBLOB, "metric3" TINYBLOB, PRIMARY KEY ("idThumb"), INDEX ("idPath"), INDEX ("name"), INDEX ("idPath","name") ) ENGINE=InnoDB; #-------------------------------------------------------------------------------------- # Table structure for table "GalleryThumb" #-------------------------------------------------------------------------------------- CREATE TABLE "GalleryThumb" ( "idGallery" INT(11) NOT NULL, "idThumb" INT(11) NOT NULL, "seq" INT(11) DEFAULT NULL, PRIMARY KEY ("idGallery","idThumb"), INDEX ("idGallery","seq"), INDEX ("idThumb") ) ENGINE=InnoDB; #-------------------------------------------------------------------------------------- # Table structure for table "ThumbnailKeyword" #-------------------------------------------------------------------------------------- CREATE TABLE "ThumbnailKeyword" ( "idThumb" INT(11) NOT NULL, "idKeyword" INT(11) NOT NULL, PRIMARY KEY ("idThumb","idKeyword"), INDEX ("idKeyword") ) ENGINE=InnoDB; #====================================================================================== # Create user fields #====================================================================================== #-------------------------------------------------------------------------------------- # Table structure for table "UserFields" #-------------------------------------------------------------------------------------- CREATE TABLE "UserFields" ( "idThumbUDF" INT(11) NOT NULL, PRIMARY KEY ("idThumbUDF") ) ENGINE=InnoDB; #-------------------------------------------------------------------------------------- # Table structure for table "UserFieldsInfo" #-------------------------------------------------------------------------------------- CREATE TABLE "UserFieldsInfo" ( "Version" INT(11) NOT NULL, "FieldName" VARCHAR(255) NOT NULL, "ColName" VARCHAR(255) NOT NULL, "ColType" SMALLINT(6) NOT NULL, "ColLength" SMALLINT(6) DEFAULT NULL, "FieldSeq" SMALLINT(6) NOT NULL AUTO_INCREMENT, PRIMARY KEY ("Version","FieldName"), UNIQUE KEY ("FieldSeq") ) ENGINE=InnoDB; #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - # user fields describing thumbnails #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - # # ALTER TABLE "UserFields" ADD COLUMN "uf_MD5" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'MD5', 'uf_MD5', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Jpeg_Quality" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Jpeg Quality', 'uf_Jpeg_Quality', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Jpeg_Sampling" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Jpeg Sampling', 'uf_Jpeg_Sampling', 12, 45, 0); #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - # EXIF user fields #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - # # ALTER TABLE "UserFields" ADD COLUMN "uf_Aperture" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Aperture', 'uf_Aperture', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Artist" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Artist', 'uf_Artist', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Brightness" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Brightness', 'uf_Brightness', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Camera_make" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Camera make', 'uf_Camera_make', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Camera_model" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Camera model', 'uf_Camera_model', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Camera_version" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Camera version', 'uf_Camera_version', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_CFA_pattern" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'CFA pattern', 'uf_CFA_pattern', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Colorspace" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Colorspace', 'uf_Colorspace', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Component_configuration" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Component configuration', 'uf_Component_configuration', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Compressed_pixel_size" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Compressed pixel size', 'uf_Compressed_pixel_size', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Contrast" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Contrast', 'uf_Contrast', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Copyright" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Copyright', 'uf_Copyright', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Custom_rendered" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Custom rendered', 'uf_Custom_rendered', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Device_setting_descr" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Device setting descr', 'uf_Device_setting_descr', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Digital_zoom_ratio" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Digital zoom ratio', 'uf_Digital_zoom_ratio', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Digitized_datetime" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Digitized date/time', 'uf_Digitized_datetime', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Digitized_datetime_subsecs" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Digitized date/time subsecs', 'uf_Digitized_datetime_subsecs', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_EXIF_Height" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'EXIF Height', 'uf_EXIF_Height', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_EXIF_Interop_Offset" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'EXIF Interop Offset', 'uf_EXIF_Interop_Offset', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_EXIF_version" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'EXIF version', 'uf_EXIF_version', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_EXIF_Width" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'EXIF Width', 'uf_EXIF_Width', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Exposure_bias" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Exposure bias', 'uf_Exposure_bias', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Exposure_index" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Exposure index', 'uf_Exposure_index', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Exposure_mode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Exposure mode', 'uf_Exposure_mode', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Exposure_program" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Exposure program', 'uf_Exposure_program', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Exposure_time" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Exposure time', 'uf_Exposure_time', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_File_source" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'File source', 'uf_File_source', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Flash" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Flash', 'uf_Flash', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_FlashPix_version" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'FlashPix version', 'uf_FlashPix_version', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Focal_length" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Focal length', 'uf_Focal_length', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Focal_length_35mm" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Focal length (35mm)', 'uf_Focal_length_35mm', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Focal_plane_unit" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Focal plane unit', 'uf_Focal_plane_unit', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Focal_plane_XRes" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Focal plane X-Res', 'uf_Focal_plane_XRes', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Focal_plane_YRes" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Focal plane Y-Res', 'uf_Focal_plane_YRes', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Frequency_response" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Frequency response', 'uf_Frequency_response', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Fstop" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'F-stop', 'uf_Fstop', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Gain_control" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Gain control', 'uf_Gain_control', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Image_description" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Image description', 'uf_Image_description', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Image_height" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Image height', 'uf_Image_height', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Image_unique_ID" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Image unique ID', 'uf_Image_unique_ID', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Image_width" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Image width', 'uf_Image_width', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_ISO_speed" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'ISO speed', 'uf_ISO_speed', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_JPEG_format" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'JPEG format', 'uf_JPEG_format', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_JPEG_format_len" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'JPEG format len', 'uf_JPEG_format_len', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_JPEG_proc" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'JPEG proc', 'uf_JPEG_proc', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Light_source" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Light source', 'uf_Light_source', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Maker_note" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Maker note', 'uf_Maker_note', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Maximum_aperture" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Maximum aperture', 'uf_Maximum_aperture', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Metering_mode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Metering mode', 'uf_Metering_mode', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Modified_datetime" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Modified date/time', 'uf_Modified_datetime', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Modified_datetime_subsecs" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Modified date/time subsecs', 'uf_Modified_datetime_subsecs', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_OECF" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'OECF', 'uf_OECF', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Orientation" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Orientation', 'uf_Orientation', 12, 45, 0); ALTER TABLE "UserFields" ADD COLUMN "uf_Original_datetime" VARCHAR(45); INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Original Date/Time', 'uf_Original_datetime', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Original_datetime_subsecs" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Original date/time subsecs', 'uf_Original_datetime_subsecs', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Primary_chromaticities" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Primary chromaticities', 'uf_Primary_chromaticities', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Reference_blackwhite" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Reference black/white', 'uf_Reference_blackwhite', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Resolution_unit" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Resolution unit', 'uf_Resolution_unit', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Saturation" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Saturation', 'uf_Saturation', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Scene_capture_type" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Scene capture type', 'uf_Scene_capture_type', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Scene_type" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Scene type', 'uf_Scene_type', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Sensing_method" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Sensing method', 'uf_Sensing_method', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Sharpness" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Sharpness', 'uf_Sharpness', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Shutter_speed" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Shutter speed', 'uf_Shutter_speed', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Spectral_sensitivity" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Spectral sensitivity', 'uf_Spectral_sensitivity', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Subject_area" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Subject area', 'uf_Subject_area', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Subject_distance" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Subject distance', 'uf_Subject_distance', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Subject_distance_range" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Subject distance range', 'uf_Subject_distance_range', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Subject_location" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Subject location', 'uf_Subject_location', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Transfer_function" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Transfer function', 'uf_Transfer_function', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_User_comment" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'User comment', 'uf_User_comment', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_White_balance" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'White balance', 'uf_White_balance', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_White_point" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'White point', 'uf_White_point', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_X_resolution" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'X resolution', 'uf_X_resolution', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Y_resolution" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Y resolution', 'uf_Y_resolution', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_YCbCr_positioning" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'YCbCr positioning', 'uf_YCbCr_positioning', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_YCbCr_subsampling" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'YCbCr sub-sampling', 'uf_YCbCr_subsampling', 12, 45, 0); #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - # Canon-specific EXIF fields #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - # # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_AF_point" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon AF point', 'uf_Canon_AF_point', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_burst_sequence" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon burst sequence', 'uf_Canon_burst_sequence', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_contrast" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon contrast', 'uf_Canon_contrast', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_digital_zoom" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon digital zoom', 'uf_Canon_digital_zoom', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_drive_mode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon drive mode', 'uf_Canon_drive_mode', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_easy_shooting_mode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon easy shooting mode', 'uf_Canon_easy_shooting_mode', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_exposure_mode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon exposure mode', 'uf_Canon_exposure_mode', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_firmware_version" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon firmware version', 'uf_Canon_firmware_version', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_flash_activity" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon flash activity', 'uf_Canon_flash_activity', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_flash_bias" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon flash bias', 'uf_Canon_flash_bias', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_flash_details" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon flash details', 'uf_Canon_flash_details', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_flash_mode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon flash mode', 'uf_Canon_flash_mode', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_focal_length_units" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon focal length units', 'uf_Canon_focal_length_units', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_focus_mode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon focus mode', 'uf_Canon_focus_mode', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_focus_type" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon focus type', 'uf_Canon_focus_type', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_G1_focus_mode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon G1 focus mode', 'uf_Canon_G1_focus_mode', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_image_number" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon image number', 'uf_Canon_image_number', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_image_size" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon image size', 'uf_Canon_image_size', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_ISO" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon ISO', 'uf_Canon_ISO', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_long_focal_length" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon long focal length', 'uf_Canon_long_focal_length', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_macro_mode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon macro mode', 'uf_Canon_macro_mode', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_metering_mode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon metering mode', 'uf_Canon_metering_mode', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_owner_name" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon owner name', 'uf_Canon_owner_name', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_quality" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon quality', 'uf_Canon_quality', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_saturation" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon saturation', 'uf_Canon_saturation', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_selftimer" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon self-timer', 'uf_Canon_selftimer', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_serial_number" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon serial number', 'uf_Canon_serial_number', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_sharpness" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon sharpness', 'uf_Canon_sharpness', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_short_focal_length" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon short focal length', 'uf_Canon_short_focal_length', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_subject_distance" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon subject distance', 'uf_Canon_subject_distance', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Canon_white_balance" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Canon white balance', 'uf_Canon_white_balance', 12, 45, 0); #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - # GPS-specific EXIF fields #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - # # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Altitude" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Altitude', 'uf_GPS_Altitude', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Altitude_Ref" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Altitude Ref', 'uf_GPS_Altitude_Ref', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Degree_of_Precision" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Degree of Precision', 'uf_GPS_Degree_of_Precision', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Dest_Bearing" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Dest Bearing', 'uf_GPS_Dest_Bearing', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Dest_Bearing_Ref" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Dest Bearing Ref', 'uf_GPS_Dest_Bearing_Ref', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Dest_Distance" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Dest Distance', 'uf_GPS_Dest_Distance', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Dest_Distance_Ref" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Dest Distance Ref', 'uf_GPS_Dest_Distance_Ref', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Dest_Latitude" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Dest Latitude', 'uf_GPS_Dest_Latitude', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Dest_Latitude_Ref" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Dest Latitude Ref', 'uf_GPS_Dest_Latitude_Ref', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Dest_Longitude" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Dest Longitude', 'uf_GPS_Dest_Longitude', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Dest_Longitude_Ref" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Dest Longitude Ref', 'uf_GPS_Dest_Longitude_Ref', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Image_Direction" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Image Direction', 'uf_GPS_Image_Direction', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Image_Direction_Ref" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Image Direction Ref', 'uf_GPS_Image_Direction_Ref', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Latitude" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Latitude', 'uf_GPS_Latitude', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Latitude_Ref" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Latitude Ref', 'uf_GPS_Latitude_Ref', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Longitude" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Longitude', 'uf_GPS_Longitude', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Longitude_Ref" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Longitude Ref', 'uf_GPS_Longitude_Ref', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Map_Datum" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Map Datum', 'uf_GPS_Map_Datum', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Measure_Mode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Measure Mode', 'uf_GPS_Measure_Mode', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Satellites" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Satellites', 'uf_GPS_Satellites', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Speed" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Speed', 'uf_GPS_Speed', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Speed_Ref" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Speed Ref', 'uf_GPS_Speed_Ref', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Status" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Status', 'uf_GPS_Status', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Tag_Version" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Tag Version', 'uf_GPS_Tag_Version', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Time_Stamp" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Time Stamp', 'uf_GPS_Time_Stamp', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Tracking" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Tracking', 'uf_GPS_Tracking', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_GPS_Tracking_Ref" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'GPS Tracking Ref', 'uf_GPS_Tracking_Ref', 12, 45, 0); #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - # Minolta-specific EXIF fields #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - # # ALTER TABLE "UserFields" ADD COLUMN "uf_Minolta_contrast" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Minolta contrast', 'uf_Minolta_contrast', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Minolta_macro_mode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Minolta macro mode', 'uf_Minolta_macro_mode', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Minolta_saturation" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Minolta saturation', 'uf_Minolta_saturation', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Minolta_white_balance" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Minolta white balance', 'uf_Minolta_white_balance', 12, 45, 0); #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - # Nikon-specific EXIF fields #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - # # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_AF_focus_pos" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon AF focus pos', 'uf_Nikon_AF_focus_pos', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_auxiliary_lens" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon auxiliary lens', 'uf_Nikon_auxiliary_lens', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_color_mode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon color mode', 'uf_Nikon_color_mode', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_contrast_curve" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon contrast curve', 'uf_Nikon_contrast_curve', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_digital_zoom" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon digital zoom', 'uf_Nikon_digital_zoom', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_firmware_rev" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon firmware rev', 'uf_Nikon_firmware_rev', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_flash_compensation" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon flash compensation', 'uf_Nikon_flash_compensation', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_flash_mode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon flash mode', 'uf_Nikon_flash_mode', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_flash_setting" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon flash setting', 'uf_Nikon_flash_setting', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_focus_mode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon focus mode', 'uf_Nikon_focus_mode', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_hue_adjust" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon hue adjust', 'uf_Nikon_hue_adjust', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_image_adjustment" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon image adjustment', 'uf_Nikon_image_adjustment', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_ISO_HI_mode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon ISO HI mode', 'uf_Nikon_ISO_HI_mode', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_ISO_selection" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon ISO selection', 'uf_Nikon_ISO_selection', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_ISO_speed" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon ISO speed', 'uf_Nikon_ISO_speed', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_lens" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon lens', 'uf_Nikon_lens', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_lens_type" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon lens type', 'uf_Nikon_lens_type', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_light_type" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon light type', 'uf_Nikon_light_type', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_manual_focus_dist" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon manual focus dist', 'uf_Nikon_manual_focus_dist', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_quality" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon quality', 'uf_Nikon_quality', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_sharpening" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon sharpening', 'uf_Nikon_sharpening', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_tone_compensation" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon tone compensation', 'uf_Nikon_tone_compensation', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_white_bal_coef" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon white bal coef', 'uf_Nikon_white_bal_coef', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_white_bal_fine" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon white bal fine', 'uf_Nikon_white_bal_fine', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Nikon_white_balance" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Nikon white balance', 'uf_Nikon_white_balance', 12, 45, 0); #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - # Olympus-specific EXIF fields #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - # # ALTER TABLE "UserFields" ADD COLUMN "uf_Olympus_unknown_1" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Olympus (unknown 1)', 'uf_Olympus_unknown_1', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Olympus_unknown_2" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Olympus (unknown 2)', 'uf_Olympus_unknown_2', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Olympus_unknown_3" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Olympus (unknown 3)', 'uf_Olympus_unknown_3', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Olympus_camera_ID" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Olympus camera ID', 'uf_Olympus_camera_ID', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Olympus_digital_zoom" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Olympus digital zoom', 'uf_Olympus_digital_zoom', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Olympus_firmware_ver" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Olympus firmware ver', 'uf_Olympus_firmware_ver', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Olympus_jpeg_quality" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Olympus jpeg quality', 'uf_Olympus_jpeg_quality', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Olympus_macro_mode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Olympus macro mode', 'uf_Olympus_macro_mode', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Olympus_more_data" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Olympus more data', 'uf_Olympus_more_data', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Olympus_picture_info" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Olympus picture info', 'uf_Olympus_picture_info', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Olympus_special_mode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Olympus special mode', 'uf_Olympus_special_mode', 12, 45, 0); #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - # IPTC user fields (english) #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - # # ALTER TABLE "UserFields" ADD COLUMN "uf_Byline" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'By-line', 'uf_Byline', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Byline_Title" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'By-line Title', 'uf_Byline_Title', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Caption" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Caption', 'uf_Caption', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Category" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Category', 'uf_Category', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_City" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'City', 'uf_City', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Contact" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Contact', 'uf_Contact', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Copyright_Notice" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Copyright Notice', 'uf_Copyright_Notice', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Country_Name" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Country Name', 'uf_Country_Name', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Credit" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Credit', 'uf_Credit', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Date_Created" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Date Created', 'uf_Date_Created', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Edit_Status" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Edit Status', 'uf_Edit_Status', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Expiration_Date" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Expiration Date', 'uf_Expiration_Date', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Expiration_Time" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Expiration Time', 'uf_Expiration_Time', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Fixture_Identifier" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Fixture Identifier', 'uf_Fixture_Identifier', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Headline" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Headline', 'uf_Headline', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Image_Type" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Image Type', 'uf_Image_Type', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Keyword" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Keyword', 'uf_Keyword', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Language_Identifier" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Language Identifier', 'uf_Language_Identifier', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Object_Cycle" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Object Cycle', 'uf_Object_Cycle', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Object_Name" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Object Name', 'uf_Object_Name', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Original_Transmission_Ref" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Original Transmission Ref', 'uf_Original_Transmission_Ref', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Originating_Program" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Originating Program', 'uf_Originating_Program', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Primary_Location_Code" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Primary Location Code', 'uf_Primary_Location_Code', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Program_Version" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Program Version', 'uf_Program_Version', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_ProvinceState" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Province-State', 'uf_ProvinceState', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Record_Version" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Record Version', 'uf_Record_Version', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Release_Date" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Release Date', 'uf_Release_Date', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Release_Time" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Release Time', 'uf_Release_Time', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Source" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Source', 'uf_Source', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Special_Instructions" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Special Instructions', 'uf_Special_Instructions', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Sublocation" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Sublocation', 'uf_Sublocation', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Supplemental_Category" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Supplemental Category', 'uf_Supplemental_Category', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Time_Created" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Time Created', 'uf_Time_Created', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Urgency" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Urgency', 'uf_Urgency', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_WriterEditor" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Writer/Editor ', 'uf_WriterEditor', 12, 45, 0); #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - # IPTC user fields (german) #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - # # ALTER TABLE "UserFields" ADD COLUMN "uf_Ablaufdatum" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Ablaufdatum', 'uf_Ablaufdatum', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Ablaufzeit" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Ablaufzeit', 'uf_Ablaufzeit', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Autor" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Autor', 'uf_Autor', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_BearbeiteStatus" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Bearbeite Status', 'uf_BearbeiteStatus', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Bildrechte" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Bildrechte', 'uf_Bildrechte', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Bildtyp" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Bildtyp', 'uf_Bildtyp', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_CopyrightVermerk" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Copyright Vermerk', 'uf_CopyrightVermerk', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_DatensatzVersion" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Datensatz-Version', 'uf_DatensatzVersion', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Dringlichkeit" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Dringlichkeit', 'uf_Dringlichkeit', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Erstellungsdatum" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Erstellungsdatum', 'uf_Erstellungsdatum', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Erstellungszeitpunkt" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Erstellungszeitpunkt', 'uf_Erstellungszeitpunkt', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_ErweiterteAngaben" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Erweiterte Angaben', 'uf_ErweiterteAngaben', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_FunktionDesAutors" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Funktion des Autors (Byline Title)', 'uf_FunktionDesAutors', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Kategorie" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Kategorie', 'uf_Kategorie', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_KennungFixtureID)" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Kennung (Fixture-ID)', 'uf_KennungFixtureID)', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Kontakt" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Kontakt', 'uf_Kontakt', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Land" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Land', 'uf_Land', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_NameDesAutors" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Name des Autors (Byline)', 'uf_NameDesAutors', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Objektbeschreibung" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Objektbeschreibung', 'uf_Objektbeschreibung', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Objektname" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Objektname', 'uf_Objektname', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Objektzyklus" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Objektzyklus', 'uf_Objektzyklus', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_PrimaererLocationCode" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Primärer Location-Code', 'uf_PrimaererLocationCode', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Programmversion" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Programmversion', 'uf_Programmversion', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_ProvinzBundesland" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Provinz/Bundesland', 'uf_ProvinzBundesland', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Quelle" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Quelle', 'uf_Quelle', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Schluesselwoerter" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Schlüsselwörter', 'uf_Schluesselwoerter', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_SpracheID" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Sprache-ID', 'uf_SpracheID', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Ort" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Ort', 'uf_Ort', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_SubLocation" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Sub-Location', 'uf_SubLocation', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_UnterstuetzteKategorien" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Unterstützte Kategorien', 'uf_UnterstuetzteKategorien', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Ursprungssoftware" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Ursprungssoftware', 'uf_Ursprungssoftware', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_UrspruenglicheUebertragungsreferenz" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Ursprüngliche Übertragungsreferenz', 'uf_UrspruenglicheUebertragungsreferenz', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_VeroeffentlichtAm" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Veröffentlicht am', 'uf_VeroeffentlichtAm', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_VeroeffentlichtUm" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Veröffentlicht um', 'uf_VeroeffentlichtUm', 12, 45, 0); # ALTER TABLE "UserFields" ADD COLUMN "uf_Ueberschrift" VARCHAR(45); # INSERT INTO "UserFieldsInfo" VALUES ( 0, 'Überschrift', 'uf_Ueberschrift', 12, 45, 0); #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - #- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - INSERT INTO "DatabaseInfo" VALUES ( 104, 104, 6, 90, 'Thumbs', 1); ALTER TABLE "UserFieldsInfo" CHANGE "FieldSeq" "FieldSeq" SMALLINT(6) DEFAULT NULL; ALTER TABLE "UserFieldsInfo" DROP INDEX "FieldSeq"; UPDATE "UserFieldsInfo" SET "FieldSeq" = "FieldSeq"-1; # # *** END OF SCRIPT *** #