 ALTER TABLE nanoparticle_entity_file
  DROP FOREIGN KEY FK_nanoparticle_entity_lab_file_lab_file;
 ALTER TABLE nanoparticle_entity_file
- DROP FOREIGN KEY FK_nanoparticle_entity_lab_file_nanoparticle_entity; 
-ALTER TABLE nanoparticle_entity_file ADD CONSTRAINT FK_nanoparticle_entity_file_file 
-	FOREIGN KEY (file_pk_id) REFERENCES file (file_pk_id);
-ALTER TABLE nanoparticle_entity_file ADD CONSTRAINT FK_nanoparticle_entity_file_nanoparticle_entity 
+ DROP FOREIGN KEY FK_nanoparticle_entity_lab_file_nanoparticle_entity;
+ALTER TABLE nanoparticle_entity_file ADD CONSTRAINT FK_nanoparticle_entity_file_file
+	FOREIGN KEY (file_pk_id) REFERENCES file (file_pk_id);
+ALTER TABLE nanoparticle_entity_file ADD CONSTRAINT FK_nanoparticle_entity_file_nanoparticle_entity
 	FOREIGN KEY (nanoparticle_entity_pk_id) REFERENCES nanoparticle_entity (nanoparticle_entity_pk_id)
 ;
 
 
-ALTER TABLE keyword_lab_file RENAME keyword_file; 
+ALTER TABLE keyword_lab_file RENAME keyword_file;
 ALTER TABLE canano.keyword_file
  DROP FOREIGN KEY FK_keyword_lab_file_keyword,
  DROP FOREIGN KEY FK_keyword_lab_file_lab_file,
  CHANGE lab_file_pk_id file_pk_id BIGINT(20) NOT NULL;
-ALTER TABLE keyword_file ADD CONSTRAINT FK_keyword_file_file 
-	FOREIGN KEY (file_pk_id) REFERENCES file (file_pk_id);
-ALTER TABLE keyword_file ADD CONSTRAINT FK_keyword_file_keyword 
+ALTER TABLE keyword_file ADD CONSTRAINT FK_keyword_file_file
+	FOREIGN KEY (file_pk_id) REFERENCES file (file_pk_id);
+ALTER TABLE keyword_file ADD CONSTRAINT FK_keyword_file_keyword
 	FOREIGN KEY (keyword_pk_id) REFERENCES keyword (keyword_pk_id);
-	
+
 
 ALTER TABLE functionalizing_entity_lab_file RENAME functionalizing_entity_file;
 ALTER TABLE functionalizing_entity_file
 	DROP FOREIGN KEY FK_functionalizing_entity_lab_file_functionalizing_entity;
 ALTER TABLE functionalizing_entity_file
-	DROP FOREIGN KEY FK_functionalizing_entity_lab_file_lab_file; 
-ALTER TABLE functionalizing_entity_file ADD CONSTRAINT FK_functionalizing_entity_file_file 
-	FOREIGN KEY (file_pk_id) REFERENCES file (file_pk_id);
-ALTER TABLE functionalizing_entity_file ADD CONSTRAINT FK_functionalizing_entity_file_functionalizing_entity 
+	DROP FOREIGN KEY FK_functionalizing_entity_lab_file_lab_file;
+ALTER TABLE functionalizing_entity_file ADD CONSTRAINT FK_functionalizing_entity_file_file
+	FOREIGN KEY (file_pk_id) REFERENCES file (file_pk_id);
+ALTER TABLE functionalizing_entity_file ADD CONSTRAINT FK_functionalizing_entity_file_functionalizing_entity
 	FOREIGN KEY (functionalizing_entity_pk_id) REFERENCES functionalizing_entity (functionalizing_entity_pk_id)
 ;
-	 
+
 ALTER TABLE nanoparticle_sample_publication
 	DROP FOREIGN KEY FK_nanoparticle_sample_publication_publication,
 	DROP FOREIGN KEY FK_nanoparticle_sample_publication_nanoparticle_sample
 ;
 
-ALTER TABLE nanoparticle_sample_publication 
+ALTER TABLE nanoparticle_sample_publication
 	DROP INDEX particle_sample_pk_id,
 	DROP INDEX file_pk_id
 ;

	KEY (organization_pk_id)
) TYPE=InnoDB
;
ALTER TABLE point_of_contact ADD CONSTRAINT FK_point_of_contact_organization 
	FOREIGN KEY (organization_pk_id) REFERENCES organization (organization_pk_id)
;


	KEY (poc_pk_id)
) TYPE=InnoDB
;
ALTER TABLE nanoparticle_sample_other_poc ADD CONSTRAINT FK_nanoparticle_sample_other_poc_nanoparticle_sample
	FOREIGN KEY (particle_sample_pk_id) REFERENCES nanoparticle_sample (particle_sample_pk_id)
;
ALTER TABLE nanoparticle_sample_other_poc ADD CONSTRAINT FK_nanoparticle_sample_other_poc_point_of_contact
