db.migration.v0.27.0.2__add_ontology_counts.sql Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of agr_curation_api Show documentation

This software is for using the curation api as a library

There is a newer version: v0.35.0

ALTER TABLE ontologyterm
   ADD COLUMN childcount int,
   ADD COLUMN descendantcount int;

ALTER TABLE ontologyterm_aud
   ADD COLUMN childcount int,
   ADD COLUMN descendantcount int;