Project

General

Profile

« Previous | Next » 

Revision be50704c

Added by Andreas Müller almost 8 years ago

Increase length of symbol and inverseSymbol #5734

View differences:

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