EDIT

bug #6343

Updated by Andreas Müller almost 6 years ago

Updatescript for TermVocabularies of OrderedTerms which are not OrderedVocabularies. 

 See also https://dev.e-taxonomy.eu/redmine/issues/4821#note-8  

 === 

 Otherwise the terms of the following types need to be unordered (see #7340) 

 Therefore the following script needs to run for them: 

 ~~~ sql 
 UPDATE TermVocabulary 
 SET DTYPE = 'TermVocabulary' 
 WHERE termType IN ('SEX', 'DMO', 'MO', 'STG', 'SCO'); 

 UPDATE DefinedTermBase 
 SET orderIndex = NULL 
 WHERE termType IN ('SEX', 'DMO', 'MO', 'STG', 'SCO'); 
 ~~~ 

 Also we may want to set the uri and some iso fields to NULL where empty (see #7445): 

 ~~~ sql 
 UPDATE DefinedTermBase TermVocabulary 
 SET uri = null NULL 
 WHERE Trim(uri) uri = ''; 

 UPDATE DefinedTermBase 
 SET iso639_1 uri = null NULL 
 WHERE Trim(iso639_1) = ''; 

 UPDATE DefinedTermBase 
 SET iso3166_A2 = null 
 WHERE Trim(iso3166_A2) = ''; 

 UPDATE TermVocabulary 
 SET uri = null 
 WHERE Trim(uri) = ''; 
 ~~~ 

 I did run these scripts on production, integration and test.

Back