Revision 3310d6a0
Added by Andreas Müller almost 6 years ago
| cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v47_49/SchemaUpdater_47_49.java | ||
|---|---|---|
| 153 | 153 |
tableName = "AgentBase"; |
| 154 | 154 |
String oldColumnName = "lastname"; |
| 155 | 155 |
newColumnName = "familyName"; |
| 156 |
step = ColumnNameChanger.NewClobInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT); |
|
| 156 |
int size = 255; |
|
| 157 |
step = ColumnNameChanger.NewVarCharInstance(stepName, tableName, oldColumnName, newColumnName, size, INCLUDE_AUDIT); |
|
| 157 | 158 |
stepList.add(step); |
| 158 | 159 |
|
| 159 | 160 |
//... firstName |
| ... | ... | |
| 161 | 162 |
tableName = "AgentBase"; |
| 162 | 163 |
oldColumnName = "firstname"; |
| 163 | 164 |
newColumnName = "givenName"; |
| 164 |
step = ColumnNameChanger.NewClobInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT); |
|
| 165 |
size = 255; |
|
| 166 |
step = ColumnNameChanger.NewVarCharInstance(stepName, tableName, oldColumnName, newColumnName, size, INCLUDE_AUDIT); |
|
| 165 | 167 |
stepList.add(step); |
| 166 | 168 |
|
| 167 | 169 |
//#7210 Add salt field for User |
| ... | ... | |
| 199 | 201 |
stepName = "Make individual count a string"; |
| 200 | 202 |
tableName = "SpecimenOrObservationBase"; |
| 201 | 203 |
String columnName = "individualCount"; |
| 202 |
int size = 255;
|
|
| 204 |
size = 255; |
|
| 203 | 205 |
step = ColumnTypeChanger.NewInt2StringInstance(stepName, tableName, columnName, size, INCLUDE_AUDIT, null, !NOT_NULL); |
| 204 | 206 |
stepList.add(step); |
| 205 | 207 |
|
Also available in: Unified diff
ref #7238 fix datatype for renaming Person.lastname and firstname