TBroTeam / TBro

Visualization and management of denovo transcriptomes
https://tbroteam.github.io/TBro/
10 stars 6 forks source link

The cvterm "fullname" is not added. #26

Closed iimog closed 8 years ago

iimog commented 8 years ago

In the current version of CHADO there is no cvterm named "fullname". This is required for adding Synonyms of type "fullname" in contrast to "symbol" to the database. The phing-commit-modifications or phing-update-modifications should check if the cvterm fullname exists and otherwise create it. fullname should be added to the cvterm.php file. A temporary fix is to add a dbxref and the cvterm manually like this:

INSERT INTO dbxref (db_id, accession) VALUES (82, 'fullname') RETURNING *
-- using the returned dbxref_id
INSERT INTO cvterm (cv_id, name, is_obsolete, is_relationshiptype, dbxref_id) VALUES (12, 'fullname', 0, 1, 102571)