Revision 840abdb1
Added by Andreas Müller almost 9 years ago
| cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v35_36/SchemaUpdater_35_36.java | ||
|---|---|---|
| 16 | 16 |
import org.apache.log4j.Logger; |
| 17 | 17 |
|
| 18 | 18 |
import eu.etaxonomy.cdm.database.update.ColumnAdder; |
| 19 |
import eu.etaxonomy.cdm.database.update.ColumnNameChanger; |
|
| 19 | 20 |
import eu.etaxonomy.cdm.database.update.ISchemaUpdater; |
| 20 | 21 |
import eu.etaxonomy.cdm.database.update.ISchemaUpdaterStep; |
| 21 | 22 |
import eu.etaxonomy.cdm.database.update.MnTableRemover; |
| ... | ... | |
| 73 | 74 |
step = ColumnAdder.NewBooleanInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT, false); |
| 74 | 75 |
stepList.add(step); |
| 75 | 76 |
|
| 76 |
//#4843 TODO test
|
|
| 77 |
//#4843 |
|
| 77 | 78 |
//Allow NULL for DefinedTermBase_SupportedCategoricalEnumeration |
| 78 | 79 |
//.supportedcategoricalenumerations_id |
| 79 | 80 |
stepName = "Remove NOT NULL from supportedcategoricalenumerations_id"; |
| ... | ... | |
| 82 | 83 |
step = UniqueIndexDropper.NewInstance(tableName, oldColumnName, !INCLUDE_AUDIT); |
| 83 | 84 |
stepList.add(step); |
| 84 | 85 |
|
| 85 |
//#4843 TODO test
|
|
| 86 |
//#4843 |
|
| 86 | 87 |
//Allow NULL for DefinedTermBase_RecommendedModifierEnumeration |
| 87 | 88 |
//.recommendedmodifierenumeration_id |
| 88 | 89 |
stepName = "Remove NOT NULL from recommendedmodifierenumeration_id"; |
| ... | ... | |
| 150 | 151 |
referencedTables = new String[]{"TaxonNode","AgentBase","DefinedTermBase"};
|
| 151 | 152 |
columnTypes = new String[]{"int","int","int"};
|
| 152 | 153 |
step = TableCreator.NewAnnotatableInstance(stepName, tableName, columnNames, columnTypes, referencedTables, INCLUDE_AUDIT); |
| 154 |
stepList.add(step); |
|
| 155 |
|
|
| 156 |
//authorTeam -> authorship for TaxonNameBase #4332 |
|
| 157 |
stepName = "Rename TaxonNameBase.combinationAuthorTeam_id column"; |
|
| 158 |
tableName = "TaxonNameBase"; |
|
| 159 |
oldColumnName = "combinationAuthorTeam_id"; |
|
| 160 |
newColumnName = "combinationAuthorship_id"; |
|
| 161 |
step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT); |
|
| 162 |
stepList.add(step); |
|
| 163 |
|
|
| 164 |
//authorTeam -> authorship for TaxonNameBase #4332 |
|
| 165 |
stepName = "Rename TaxonNameBase.exCombinationAuthorTeam_id column"; |
|
| 166 |
tableName = "TaxonNameBase"; |
|
| 167 |
oldColumnName = "exCombinationAuthorTeam_id"; |
|
| 168 |
newColumnName = "exCombinationAuthorship_id"; |
|
| 169 |
step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT); |
|
| 170 |
stepList.add(step); |
|
| 171 |
|
|
| 172 |
//authorTeam -> authorship for TaxonNameBase #4332 |
|
| 173 |
stepName = "Rename TaxonNameBase.basionymAuthorTeam_id column"; |
|
| 174 |
tableName = "TaxonNameBase"; |
|
| 175 |
oldColumnName = "basionymAuthorTeam_id"; |
|
| 176 |
newColumnName = "basionymAuthorship_id"; |
|
| 177 |
step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT); |
|
| 178 |
stepList.add(step); |
|
| 179 |
|
|
| 180 |
//authorTeam -> authorship for TaxonNameBase #4332 |
|
| 181 |
stepName = "Rename TaxonNameBase.exBasionymAuthorTeam_id column"; |
|
| 182 |
tableName = "TaxonNameBase"; |
|
| 183 |
oldColumnName = "exBasionymAuthorTeam_id"; |
|
| 184 |
newColumnName = "exBasionymAuthorship_id"; |
|
| 185 |
step = ColumnNameChanger.NewIntegerInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT); |
|
| 153 | 186 |
stepList.add(step); |
| 154 | 187 |
|
| 155 | 188 |
return stepList; |
Also available in: Unified diff
rename authorTeam -> authorship #4332 for name authors