alter table `PARTY` add `OID_PERSONAL_PHOTOGRAPH` bigint unsigned;
create table `PHOTOGRAPH_CONTENT` (`UPDATE_ENTITY` text, `OID_PHOTOGRAPH` bigint unsigned, `OID` bigint unsigned, `CONTENT` blob, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `CREATION_ENTITY_DATE` text, `CREATION_ENTITY` text, `SIZE` text, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_PHOTOGRAPH), index (OID_ROOT_DOMAIN_OBJECT)) type=InnoDB, character set latin1;
create table `PHOTOGRAPH` (`OID` bigint unsigned, `CONTENT_TYPE` text, `STATE` text, `OID_NEXT` bigint unsigned, `PHOTO_TYPE` text, `OID_APPROVER` bigint unsigned, `CREATION_ENTITY_DATE` text, `CREATION_ENTITY` text, `OID_REJECTOR` bigint unsigned, `UPDATE_ENTITY` text, `STATE_CHANGE` timestamp NULL default NULL, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `SUBMISSION` timestamp NULL default NULL, `OID_PERSON` bigint unsigned, `OID_PREVIOUS` bigint unsigned, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_APPROVER), index (OID_REJECTOR), index (OID_ROOT_DOMAIN_OBJECT)) type=InnoDB, character set latin1;
alter table `PHOTOGRAPH` add `OID_PENDING_HOLDER` bigint unsigned, add index (OID_PENDING_HOLDER);
