-- eme_label_images
-- Essig Museum of Entomology - Elib database
-- 2011-02-22

DROP TABLE eme_label_images;

CREATE TABLE eme_label_images (

seq_num               INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY, 
DateFirstEntered      date,          
EnteredBy             varchar(128), 
DateLastModified      date,	       
ModifiedBy            varchar(128),

location              varchar(255),
URI                   varchar(255) unique,
filename              varchar(255) unique,
databased             tinyint,               # 1 = databased in Essig specimen database; 0 = not databased
                                             # there is a script in bin/eme that can be used to update this
notes                 varchar(255),	     # misc. processing notes
CatalogNumberNumeric  int unsigned,	     # updated via cron; added Jan 12, 2012

sentForTranscribing   tinyint                # 1 = sent to zooniverse; 0 or NULL = not sent


);


create index eme_label_images_filename on eme_label_images (filename);
create index eme_label_images_location on eme_label_images (location);
create index eme_label_images_catnum on eme_label_images (CatalogNumberNumeric);


#insert into eme_label_images values
#(0, '2011-02-23', 'Joyce Gross', NULL, NULL, '/data3/essig_labels/510000', 'http://essigdb.berkeley.edu/labels/510000/EMEC510291 Agapostemon femoratus.jpg', 'EMEC510291 Agapostemon femoratus.jpg', 0, 'test file');

#insert into eme_label_images values
#(0, '2011-02-23', 'Joyce Gross', NULL, NULL, '/data3/essig_labels/510000', 'http://essigdb.berkeley.edu/labels/510000/EMEC10003798 Agapostemon femoratus.jpg', 'EMEC10003798 Agapostemon femoratus.jpg', 0, 'test file');