Project

General

Profile

Revision 456e8082

ID456e8082d371049c9ec7729ad9cc668f21907d57
Parent 8c760302
Child cb61174c

Added by Andreas Müller over 8 years ago

Sicilia -> Sicily #2766

View differences:

cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v31_33/SchemaUpdater_31_33.java
115 115
		//#3540
116 116
		stepName = "Update introduced: adventitious (casual) label";
117 117
		String query = " UPDATE representation r " + 
118
				" SET r.abbreviatedlabel = ia " +
118
				" SET r.abbreviatedlabel = 'ia' " +
119 119
				" WHERE r.abbreviatedlabel = 'id' AND r.label = 'introduced: adventitious (casual)' ";
120 120
		step = SimpleSchemaUpdaterStep.NewInstance(stepName, query);
121 121
		stepList.add(step);
......
144 144
		
145 145
		//TODO add columns GenBankAccessionNumber(String) and GenBankUri (URI) to Sequence
146 146
		
147
		//
147
		//update Sicilia -> Sicily
148
		//#3540
149
		stepName = "Update Sicilia -> Sicily";
150
		query = " UPDATE representation r " + 
151
				" SET r.label = 'Sicily', r.text = 'Sicily' " +
152
				" WHERE (r.abbreviatedlabel = 'SIC-SI'  OR r.abbreviatedlabel = 'SIC')  AND r.label = 'Sicilia' ";
153
		step = SimpleSchemaUpdaterStep.NewInstance(stepName, query);
154
		stepList.add(step);
148 155
		
149 156
		return stepList;
150 157
	}

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)