• Home
• org.alliancegenome
• agr_curation_api
• v0.34.2
• source code
• v0.16.0.3__agr_curation_api.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.16.0.3__agr_curation_api.sql Maven / Gradle / Ivy

DROP INDEX slotannotation_informationcontententity_evidence_curie;

DROP INDEX idxpydgr8unpmiig9jnsm89f55br;

DROP INDEX idx2hm799bn7xal2pqoq6d4v8ik9;

CREATE INDEX ontologyterm_synonym_ontologyterm_curie_index ON ontologyterm_synonym USING btree (ontologyterm_curie);

CREATE INDEX crossreference_referencedcurie_index ON crossreference USING btree (referencedcurie);

CREATE INDEX resourcedescriptor_createdby_index ON resourcedescriptor USING btree (createdby_id);

CREATE INDEX resourcedescriptor_updatedby_index ON resourcedescriptor USING btree (updatedby_id);

CREATE INDEX resourcedescriptorpage_createdby_index ON resourcedescriptorpage USING btree (createdby_id);

CREATE INDEX resourcedescriptorpage_updatedby_index ON resourcedescriptorpage USING btree (updatedby_id);

CREATE INDEX organization_homepageresourcedescriptorpage_index ON organization USING btree (homepageresourcedescriptorpage_id);

CREATE INDEX vocabularyterm_vocabulary_id_index ON vocabularyterm USING btree (vocabulary_id);

CREATE INDEX vocabularytermset_name_index ON vocabularytermset USING btree (name);

CREATE INDEX vocabularytermset_createdby_id_index ON vocabularytermset USING btree (createdby_id);

CREATE INDEX vocabularytermset_updatedby_id_index ON vocabularytermset USING btree (updatedby_id);

CREATE INDEX vocabularytermset_vocabularytermsetvocabulary_id_index ON vocabularytermset USING btree (vocabularytermsetvocabulary_id);

CREATE INDEX vocabularytermset_vocabularyterm_vocabularytermsets_id_index ON vocabularytermset_vocabularyterm USING btree (vocabularytermsets_id);

CREATE INDEX vocabularytermset_vocabularyterm_memberterms_id_index ON vocabularytermset_vocabularyterm USING btree (memberterms_id);