• Home
• org.alliancegenome
• agr_curation_api
• v0.34.3
• source code
• v0.22.0.4__uberonterm_update.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.migration.v0.22.0.4__uberonterm_update.sql Maven / Gradle / Ivy

INSERT INTO anatomicalterm SELECT * FROM uberonterm;

INSERT INTO anatomicalterm_aud SELECT * FROM uberonterm_aud;

ALTER TABLE uberonterm
	DROP CONSTRAINT uberonterm_curie_fk;

ALTER TABLE uberonterm
    ADD CONSTRAINT uberonterm_curie_fk FOREIGN KEY (curie) REFERENCES anatomicalterm(curie);

ALTER TABLE uberonterm_aud
	DROP CONSTRAINT uberonterm_aud_curie_rev_fk;

ALTER TABLE uberonterm_aud
    ADD CONSTRAINT uberonterm_aud_curie_rev_fk FOREIGN KEY (curie, rev) REFERENCES anatomicalterm_aud(curie, rev);