db.migration.v0.9.0.1__agr_curation_api.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

DROP TABLE allele_genegenomiclocation;

DROP TABLE allele_genegenomiclocation_aud;

DROP TABLE gene_genegenomiclocation;

DROP TABLE gene_genegenomiclocation_aud;

DROP TABLE genegenomiclocation;

DROP TABLE genegenomiclocation_aud;

ALTER TABLE bulkload
	RENAME COLUMN status TO bulkloadstatus;

ALTER TABLE bulkload_aud
	RENAME COLUMN status TO bulkloadstatus;

ALTER TABLE bulkloadfile
	RENAME COLUMN status TO bulkloadstatus;

ALTER TABLE bulkloadfile_aud
	RENAME COLUMN status TO bulkloadstatus;
	
ALTER TABLE bulkfmsload
	RENAME COLUMN datatype TO fmsdatatype;

ALTER TABLE bulkfmsload_aud
	RENAME COLUMN datatype TO fmsdatatype;
	
ALTER TABLE bulkfmsload
	RENAME COLUMN datasubtype TO fmsdatasubtype;

ALTER TABLE bulkfmsload_aud
	RENAME COLUMN datasubtype TO fmsdatasubtype;
	
ALTER TABLE bulkurlload
	RENAME COLUMN url to bulkloadurl;
	
ALTER TABLE bulkurlload_aud
	RENAME COLUMN url to bulkloadurl;
	
ALTER TABLE gene
	DROP COLUMN automatedgenedescription,
	DROP COLUMN genesynopsis,
	DROP COLUMN genesynopsisurl;
	
ALTER TABLE gene_aud
	DROP COLUMN automatedgenedescription,
	DROP COLUMN genesynopsis,
	DROP COLUMN genesynopsisurl;
	
ALTER TABLE allele
	DROP COLUMN description,
	DROP COLUMN feature_type;
	
ALTER TABLE allele_aud
	DROP COLUMN description,
	DROP COLUMN feature_type;
	
INSERT INTO phenotypeterm
	SELECT curie FROM mpterm;
	
INSERT INTO phenotypeterm_aud
	SELECT curie, rev FROM mpterm_aud;

ALTER TABLE synonym
	ALTER COLUMN name TYPE varchar(2000);

ALTER TABLE synonym_aud
	ALTER COLUMN name TYPE varchar(2000);
	
INSERT INTO synonym (id, name)
	SELECT nextval('hibernate_sequence'), synonyms FROM ontologyterm_synonyms;
	
ALTER TABLE ontologyterm_synonyms
	ADD synonyms_id bigint;
	
ALTER TABLE ontologyterm_synonyms_aud
	ADD synonyms_id bigint;

UPDATE ontologyterm_synonyms
	SET synonyms_id = synonym.id
	FROM synonym
	WHERE synonym.name = ontologyterm_synonyms.synonyms;
	
UPDATE ontologyterm_synonyms_aud
	SET synonyms_id = synonym.id
	FROM synonym
	WHERE synonym.name = ontologyterm_synonyms_aud.synonyms;

ALTER TABLE ontologyterm_synonyms
	DROP synonyms;

ALTER TABLE ontologyterm_synonyms_aud
	DROP synonyms;
		
ALTER TABLE ontologyterm_synonyms
	RENAME TO ontologyterm_synonym;
		
ALTER TABLE ontologyterm_synonyms_aud
	RENAME TO ontologyterm_synonym_aud;
	
ALTER TABLE diseaseannotation
	ADD alliancecurie varchar(255);
		
ALTER TABLE diseaseannotation_aud
	ADD alliancecurie varchar(255);