 delete from canano.common_lookup
 where value = 'review article'
 ;
-
-
--- End of script
ADD CONSTRAINT FK_author_publication_author FOREIGN KEY (author_pk_id) REFERENCES canano.author (author_pk_id) ON UPDATE RESTRICT ON DELETE RESTRICT,
ADD CONSTRAINT FK_author_publication_publication FOREIGN KEY (publication_pk_id) REFERENCES canano.publication (publication_pk_id) ON UPDATE RESTRICT ON DELETE RESTRICT;


-- fix errors in functionalizing_entity and activation_method tables
update canano.functionalizing_entity fe, canano.activation_method am
set fe.activation_method_pk_id = null
where am.activation_method_pk_id = fe.activation_method_pk_id

DROP FOREIGN KEY FK_author_publication_publication,
CHANGE document_author_pk_id author_pk_id BIGINT(20) NOT NULL;

SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;

UPDATE csm_protection_element
