Project

General

Profile

« Previous | Next » 

Revision 25ab030b

Added by Andreas Müller almost 8 years ago

Add preferred stable URI to SpecimenOrObservation #5606

View differences:

cdmlib-model/src/main/java/eu/etaxonomy/cdm/model/occurrence/SpecimenOrObservationBase.java
9 9

  
10 10
package eu.etaxonomy.cdm.model.occurrence;
11 11

  
12
import java.net.URI;
12 13
import java.util.ArrayList;
13 14
import java.util.Collection;
14 15
import java.util.HashMap;
......
165 166
    @Min(0)
166 167
    private Integer individualCount;
167 168

  
169
    //preferred stable identifer (URI) #5606
170
    @XmlElement(name = "PreferredStableUri")
171
    @Field(analyze = Analyze.NO)
172
    @Type(type="uriUserType")
173
    private URI preferredStableUri;
174

  
168 175
    // the verbatim description of this occurrence. Free text usable when no atomised data is available.
169 176
    // in conjunction with titleCache which serves as the "citation" string for this object
170 177
    @XmlElement(name = "Description")
cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v36_40/SchemaUpdater_36_40.java
15 15

  
16 16
import org.apache.log4j.Logger;
17 17

  
18
import eu.etaxonomy.cdm.database.update.ColumnAdder;
18 19
import eu.etaxonomy.cdm.database.update.ISchemaUpdater;
19 20
import eu.etaxonomy.cdm.database.update.ISchemaUpdaterStep;
20 21
import eu.etaxonomy.cdm.database.update.SchemaUpdaterBase;
......
61 62

  
62 63
		List<ISchemaUpdaterStep> stepList = new ArrayList<ISchemaUpdaterStep>();
63 64

  
64

  
65
        //#5606
66
        //Add preferred stable URI to SpecimenOrObservation
67
        stepName = "Add preferred stable URI to SpecimenOrObservation";
68
        tableName = "SpecimenOrObservationBase";
69
        newColumnName = "preferredStableUri";
70
        step = ColumnAdder.NewClobInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT);
71
        stepList.add(step);
65 72

  
66 73
		return stepList;
67 74
	}
cdmlib-test/src/main/resources/dbscripts/001-cdm.h2.sql
3845 3845
    TITLECACHE VARCHAR(255),
3846 3846
    PUBLISH BOOLEAN,
3847 3847
    INDIVIDUALCOUNT INTEGER,
3848
	PREFERREDSTABLEURI CLOB,
3848 3849
    ACCESSIONNUMBER VARCHAR(255),
3849 3850
    BARCODE VARCHAR(255),
3850 3851
    CATALOGNUMBER VARCHAR(255),
......
3887 3888
    TITLECACHE VARCHAR(255),
3888 3889
    PUBLISH BOOLEAN,
3889 3890
    INDIVIDUALCOUNT INTEGER,
3891
    PREFERREDSTABLEURI CLOB,
3890 3892
    ACCESSIONNUMBER VARCHAR(255),
3891 3893
    BARCODE VARCHAR(255),
3892 3894
    CATALOGNUMBER VARCHAR(255),

Also available in: Unified diff