Project

General

Profile

Revision d47acaf2

IDd47acaf2a9ecc06bd54bac7d52cad7c8241354eb
Parent 9fdefe59
Child 6500a613

Added by Andreas Müller over 8 years ago

update script for genbank accession removal #3552

View differences:

cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v31_33/SchemaUpdater_31_33.java
138 138

  
139 139
		//TODO update datatype->CLOB for URIs. (DefinedTerms, TermVocabulary, Reference
140 140
		//Rights, MediaRepresentationPart, GenBankAccession, ) #3345
141
		
142
		//TODO remove table Sequence_GenBankAccession
143
		
144
		//TODO remove table GenBankAccession
145
		
146
		//TODO add columns GenBankAccessionNumber(String) and GenBankUri (URI) to Sequence
147
		
141
				
148 142
		//update Sicilia -> Sicily
149 143
		//#3540
150 144
		stepName = "Update Sicilia -> Sicily";
......
246 240
		step = SimpleSchemaUpdaterStep.NewInstance(stepName, updateSql);
247 241
		stepList.add(step);
248 242
		
249
		//TODO update molecular data #3340
243
		//remove table Sequence_GenBankAccession #3552
244
		stepName = "Remove table Sequence_GenBankAccession";
245
		tableName = "Sequence_GenBankAccession";
246
		TableDroper.NewInstance(stepName, tableName, INCLUDE_AUDIT);
247
		stepList.add(step);
248
		
249
		//remove table GenBankAccession #3552
250
		stepName = "Remove table GenBankAccession";
251
		tableName = "GenBankAccession";
252
		TableDroper.NewInstance(stepName, tableName, INCLUDE_AUDIT);
253
		stepList.add(step);
254
		
255
		//TODO (read first #3360) add columns GeneticAccessionNumber(String) to Sequence 
256

  
257
		//TODO update molecular data #3360
258
		
250 259
		
251 260
		//add MediaSpecimen column #3614
252 261
		stepName = "Add mediaSpecimen column to SpecimenOrObservationBase";
......
259 268
		
260 269
		//remove DescriptionBase_Feature  #2202
261 270
		stepName = "Remove table DescriptionBase_Feature";
262
		TableDroper.NewInstance(stepName, "DescriptionBase_Feature", INCLUDE_AUDIT);
271
		tableName = "DescriptionBase_Feature";
272
		TableDroper.NewInstance(stepName, tableName, INCLUDE_AUDIT);
263 273
		stepList.add(step);
264 274
		
265 275
		return stepList;

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)