Revision 87f6f730
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 | ||
|---|---|---|
| 97 | 97 |
Integer defaultValue = null; |
| 98 | 98 |
boolean notNull = false; |
| 99 | 99 |
step = ColumnAdder.NewIntegerInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT, defaultValue, notNull); |
| 100 |
stepList.add(step); |
|
| 100 | 101 |
|
| 101 | 102 |
//SingleReadAlignment leftCutPosition |
| 102 |
stepName = "Add firstSeqPosition";
|
|
| 103 |
stepName = "Add leftCutPosition";
|
|
| 103 | 104 |
tableName = "SingleReadAlignment"; |
| 104 | 105 |
newColumnName = "leftCutPosition"; |
| 105 | 106 |
step = ColumnAdder.NewIntegerInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT, defaultValue, notNull); |
| 107 |
stepList.add(step); |
|
| 106 | 108 |
|
| 107 |
|
|
| 108 |
//SingleReadAlignment leftCutPosition |
|
| 109 |
stepName = "Add firstSeqPosition"; |
|
| 109 |
//SingleReadAlignment rightCutPosition |
|
| 110 |
stepName = "Add rightCutPosition"; |
|
| 110 | 111 |
tableName = "SingleReadAlignment"; |
| 111 | 112 |
newColumnName = "rightCutPosition"; |
| 112 | 113 |
step = ColumnAdder.NewIntegerInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT, defaultValue, notNull); |
| 114 |
stepList.add(step); |
|
| 113 | 115 |
|
| 114 | 116 |
//DescriptionElementBase_StateData |
| 115 | 117 |
stepName = "Simplify DescriptionElementBase_StateData"; |
| 116 | 118 |
tableName = "DescriptionElementBase_StateData"; |
| 117 |
newColumnName = "rightCutPosition";
|
|
| 119 |
newColumnName = "categoricaldata_id";
|
|
| 118 | 120 |
step = MnTableRemover.NewInstance(stepName, |
| 119 | 121 |
tableName, |
| 120 |
"categoricaldata_id",
|
|
| 122 |
newColumnName,
|
|
| 121 | 123 |
"DescriptionElementBase_id", |
| 122 | 124 |
"statedata_id", |
| 123 | 125 |
"DescriptionElementBase", |
| 124 | 126 |
"StateData", |
| 125 | 127 |
INCLUDE_AUDIT); |
| 128 |
stepList.add(step); |
|
| 126 | 129 |
|
| 130 |
//DescriptionElementBase_StatisticalMeasurementValue |
|
| 131 |
stepName = "Simplify DescriptionElementBase_StatisticalMeasurementValue"; |
|
| 132 |
tableName = "DescriptionElementBase_StatisticalMeasurementValue"; |
|
| 133 |
newColumnName = "quantitativedata_id"; |
|
| 134 |
step = MnTableRemover.NewInstance(stepName, |
|
| 135 |
tableName, |
|
| 136 |
newColumnName, |
|
| 137 |
"DescriptionElementBase_id", |
|
| 138 |
"statisticalvalues_id", |
|
| 139 |
"DescriptionElementBase", |
|
| 140 |
"StatisticalMeasurementValue", |
|
| 141 |
INCLUDE_AUDIT); |
|
| 142 |
stepList.add(step); |
|
| 127 | 143 |
|
| 128 | 144 |
return stepList; |
| 129 | 145 |
} |
Also available in: Unified diff
Simplify table structure for CategoricalData-StateData and and QuantitativeData_StatisticalMeasurementValue #4841 - fixing update script for MySQL