Revision d47acaf2
Added by Andreas Müller about 11 years ago
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
update script for genbank accession removal #3552