Revision ef4f2e8e
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 | ||
|---|---|---|
| 1 | 1 |
// $Id$ |
| 2 | 2 |
/** |
| 3 | 3 |
* Copyright (C) 2007 EDIT |
| 4 |
* European Distributed Institute of Taxonomy
|
|
| 4 |
* European Distributed Institute of Taxonomy |
|
| 5 | 5 |
* http://www.e-taxonomy.eu |
| 6 |
*
|
|
| 6 |
* |
|
| 7 | 7 |
* The contents of this file are subject to the Mozilla Public License Version 1.1 |
| 8 | 8 |
* See LICENSE.TXT at the top of this package for the full license terms. |
| 9 | 9 |
*/ |
| ... | ... | |
| 19 | 19 |
import eu.etaxonomy.cdm.database.update.ISchemaUpdater; |
| 20 | 20 |
import eu.etaxonomy.cdm.database.update.ISchemaUpdaterStep; |
| 21 | 21 |
import eu.etaxonomy.cdm.database.update.SchemaUpdaterBase; |
| 22 |
import eu.etaxonomy.cdm.database.update.UniqueIndexDropper; |
|
| 22 | 23 |
import eu.etaxonomy.cdm.database.update.v34_35.SchemaUpdater_341_35; |
| 23 | 24 |
|
| 24 | 25 |
/** |
| ... | ... | |
| 62 | 63 |
// boolean includeCdmBaseAttributes = false; |
| 63 | 64 |
|
| 64 | 65 |
List<ISchemaUpdaterStep> stepList = new ArrayList<ISchemaUpdaterStep>(); |
| 65 |
|
|
| 66 |
|
|
| 66 | 67 |
//add hasMoreMembers |
| 67 | 68 |
stepName = "Add hasMoreMembers to Team"; |
| 68 | 69 |
tableName = "AgentBase"; |
| 69 | 70 |
newColumnName = "hasMoreMembers"; |
| 70 | 71 |
step = ColumnAdder.NewBooleanInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT, false); |
| 71 | 72 |
stepList.add(step); |
| 72 |
|
|
| 73 |
|
|
| 74 |
//#4843 TODO test |
|
| 75 |
//Allow NULL for DefinedTermBase_SupportedCategoricalEnumeration |
|
| 76 |
//.supportedcategoricalenumerations_id |
|
| 77 |
stepName = "Remove NOT NULL from supportedcategoricalenumerations_id"; |
|
| 78 |
tableName = "DefinedTermBase_SupportedCategoricalEnumeration"; |
|
| 79 |
oldColumnName = "supportedcategoricalenumerations_id"; |
|
| 80 |
step = UniqueIndexDropper.NewInstance(tableName, oldColumnName, !INCLUDE_AUDIT); |
|
| 81 |
stepList.add(step); |
|
| 82 |
|
|
| 83 |
//#4843 TODO test |
|
| 84 |
//Allow NULL for DefinedTermBase_RecommendedModifierEnumeration |
|
| 85 |
//.recommendedmodifierenumeration_id |
|
| 86 |
stepName = "Remove NOT NULL from recommendedmodifierenumeration_id"; |
|
| 87 |
tableName = "DefinedTermBase_RecommendedModifierEnumeration"; |
|
| 88 |
oldColumnName = "recommendedmodifierenumeration_id"; |
|
| 89 |
step = UniqueIndexDropper.NewInstance(tableName, oldColumnName, ! INCLUDE_AUDIT); |
|
| 90 |
stepList.add(step); |
|
| 91 |
|
|
| 92 |
|
|
| 73 | 93 |
return stepList; |
| 74 | 94 |
} |
| 75 |
|
|
| 95 |
|
|
| 76 | 96 |
|
| 77 | 97 |
@Override |
| 78 | 98 |
public ISchemaUpdater getNextUpdater() {
|
Also available in: Unified diff
update script for removing unique key on supportedCategoricalEnums and recommendedModifierEnums #4843