Revision be50704c
Added by Andreas Müller over 8 years ago
cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/common/DefinedTermBase.java | ||
---|---|---|
171 | 171 |
private String idInVocabulary; //the unique identifier/name this term uses in its given vocabulary #3479 |
172 | 172 |
|
173 | 173 |
@XmlElement(name = "symbol") |
174 |
@Column(length=10)
|
|
174 |
@Column(length=30)
|
|
175 | 175 |
//the symbol to be used in String representations for this term #5734 |
176 | 176 |
//this term can be changed by the database instance even if the term is not managed by this instance as it is only for representation and has no semantic or identifying character |
177 | 177 |
//empty string is explicitly allowed and should be distinguished from NULL! |
cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/common/RelationshipTermBase.java | ||
---|---|---|
82 | 82 |
private Set<Representation> inverseRepresentations = new HashSet<Representation>(); |
83 | 83 |
|
84 | 84 |
@XmlElement(name = "inverseSymbol") |
85 |
@Column(length=10)
|
|
85 |
@Column(length=30)
|
|
86 | 86 |
//the symbol to be used in String representations for the reverse representation of this term #5734 |
87 | 87 |
//this term can be changed by the database instance even if the term is not managed by this instance as it is only for representation and has no semantic or identifying character |
88 | 88 |
//empty string is explicitly allowed and should be distinguished from NULL! |
cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v36_40/SchemaUpdater_36_40.java | ||
---|---|---|
113 | 113 |
stepName = "Add symbols to terms"; |
114 | 114 |
tableName = "DefinedTermBase"; |
115 | 115 |
newColumnName = "symbol"; |
116 |
step = ColumnAdder.NewStringInstance(stepName, tableName, newColumnName, 10, INCLUDE_AUDIT);
|
|
116 |
step = ColumnAdder.NewStringInstance(stepName, tableName, newColumnName, 30, INCLUDE_AUDIT);
|
|
117 | 117 |
stepList.add(step); |
118 | 118 |
|
119 | 119 |
stepName = "Update symbols for terms"; |
... | ... | |
126 | 126 |
stepName = "Add inverse symbol to terms"; |
127 | 127 |
tableName = "DefinedTermBase"; |
128 | 128 |
newColumnName = "inverseSymbol"; |
129 |
step = ColumnAdder.NewStringInstance(stepName, tableName, newColumnName, 10, INCLUDE_AUDIT);
|
|
129 |
step = ColumnAdder.NewStringInstance(stepName, tableName, newColumnName, 30, INCLUDE_AUDIT);
|
|
130 | 130 |
stepList.add(step); |
131 | 131 |
|
132 | 132 |
stepName = "Update symbols for terms"; |
cdmlib-test/src/main/resources/dbscripts/001-cdm.h2.sql | ||
---|---|---|
907 | 907 |
UPDATED TIMESTAMP, |
908 | 908 |
TERMTYPE VARCHAR(4), |
909 | 909 |
IDINVOCABULARY VARCHAR(255), |
910 |
SYMBOL VARCHAR(10),
|
|
911 |
INVERSESYMBOL VARCHAR(10),
|
|
910 |
SYMBOL VARCHAR(30),
|
|
911 |
INVERSESYMBOL VARCHAR(30),
|
|
912 | 912 |
LSID_AUTHORITY VARCHAR(255), |
913 | 913 |
LSID_LSID VARCHAR(255), |
914 | 914 |
LSID_NAMESPACE VARCHAR(255), |
... | ... | |
960 | 960 |
UPDATED TIMESTAMP, |
961 | 961 |
TERMTYPE VARCHAR(4), |
962 | 962 |
IDINVOCABULARY VARCHAR(255), |
963 |
SYMBOL VARCHAR(10),
|
|
964 |
INVERSESYMBOL VARCHAR(10),
|
|
963 |
SYMBOL VARCHAR(30),
|
|
964 |
INVERSESYMBOL VARCHAR(30),
|
|
965 | 965 |
LSID_AUTHORITY VARCHAR(255), |
966 | 966 |
LSID_LSID VARCHAR(255), |
967 | 967 |
LSID_NAMESPACE VARCHAR(255), |
Also available in: Unified diff
Increase length of symbol and inverseSymbol #5734