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

ALTER TABLE affectedgenomicmodel
	ADD COLUMN subtype_id bigint;
	
ALTER TABLE affectedgenomicmodel
	ADD CONSTRAINT affectedgenomicmodel_subtype_id_fk
		FOREIGN KEY (subtype_id) REFERENCES vocabularyterm (id);
		
ALTER TABLE affectedgenomicmodel_aud
	ADD COLUMN subtype_id bigint;
	
INSERT INTO vocabulary (id, name)
	VALUES
		(nextval('hibernate_sequence'), 'Affected genomic model subtypes');
		
INSERT INTO vocabularyterm (id, name, vocabulary_id)
	SELECT nextval('hibernate_sequence'), 'fish', id FROM vocabulary WHERE name = 'Affected genomic model subtypes';

INSERT INTO vocabularyterm (id, name, vocabulary_id)
	SELECT nextval('hibernate_sequence'), 'genotype', id FROM vocabulary WHERE name = 'Affected genomic model subtypes';

INSERT INTO vocabularyterm (id, name, vocabulary_id)
	SELECT nextval('hibernate_sequence'), 'strain', id FROM vocabulary WHERE name = 'Affected genomic model subtypes';