ALTER TABLE FILE_ENTRY RENAME TO PHOTOGRAPH;
ALTER TABLE PHOTOGRAPH ADD `KEY_NEXT` int(11);
ALTER TABLE PHOTOGRAPH ADD `KEY_PREVIOUS` int(11);
ALTER TABLE PHOTOGRAPH ADD `KEY_PENDING_HOLDER` int(11);
ALTER TABLE PHOTOGRAPH ADD `RAW_CONTENT` mediumblob;
ALTER TABLE PHOTOGRAPH ADD `PHOTO_TYPE` text;
ALTER TABLE PHOTOGRAPH ADD `STATE` text;
ALTER TABLE PHOTOGRAPH ADD `SUBMISSION` timestamp;
ALTER TABLE PHOTOGRAPH ADD `STATE_CHANGE` timestamp;
ALTER TABLE PHOTOGRAPH ADD `REJECTED_ACKNOWLEDGED` tinyint(1);
UPDATE PHOTOGRAPH SET STATE = "APPROVED";
UPDATE PHOTOGRAPH SET PHOTO_TYPE = "INSTITUTIONAL";
