Revision e0f2ff33
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 | ||
---|---|---|
18 | 18 |
import eu.etaxonomy.cdm.database.update.ClassBaseTypeUpdater; |
19 | 19 |
import eu.etaxonomy.cdm.database.update.ColumnAdder; |
20 | 20 |
import eu.etaxonomy.cdm.database.update.ColumnNameChanger; |
21 |
import eu.etaxonomy.cdm.database.update.ColumnTypeChanger; |
|
21 | 22 |
import eu.etaxonomy.cdm.database.update.ISchemaUpdater; |
22 | 23 |
import eu.etaxonomy.cdm.database.update.ISchemaUpdaterStep; |
23 | 24 |
import eu.etaxonomy.cdm.database.update.SchemaUpdaterBase; |
... | ... | |
202 | 203 |
step = ColumnAdder.NewIntegerInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT, !NOT_NULL, referencedTable); |
203 | 204 |
stepList.add(step); |
204 | 205 |
|
206 |
//#6720 Make individual count a string |
|
207 |
stepName = "Make individual count a string"; |
|
208 |
tableName = "SpecimenOrObservationBase"; |
|
209 |
String columnName = "individualCount"; |
|
210 |
int size = 255; |
|
211 |
step = ColumnTypeChanger.NewInt2StringInstance(stepName, tableName, columnName, size, INCLUDE_AUDIT, null, !NOT_NULL); |
|
212 |
stepList.add(step); |
|
213 |
|
|
205 | 214 |
|
206 | 215 |
//7276 Make User.emailAddress a unique field |
207 | 216 |
//TODO H2 / PostGreSQL / SQL Server |
208 | 217 |
//User.email unique |
209 | 218 |
stepName = "Update User.emailAdress unique index"; |
210 | 219 |
tableName = "UserAccount"; |
211 |
String columnName = "emailAddress";
|
|
220 |
columnName = "emailAddress"; |
|
212 | 221 |
step = UsernameConstraintUpdater.NewInstance(stepName, tableName, columnName); |
213 | 222 |
stepList.add(step); |
214 | 223 |
|
Also available in: Unified diff
ref #6720 make individualCount a string