@@ -, +, @@ SuggestionsUseValues is added: Use the new worflow (atomic update) --- .../atomicupdate/bug_9223-add_suggestionsusevalues_syspref.sql | 1 + installer/data/mysql/updatedatabase.pl | 7 ------- 2 files changed, 1 insertion(+), 7 deletions(-) create mode 100644 installer/data/mysql/atomicupdate/bug_9223-add_suggestionsusevalues_syspref.sql --- a/installer/data/mysql/atomicupdate/bug_9223-add_suggestionsusevalues_syspref.sql +++ a/installer/data/mysql/atomicupdate/bug_9223-add_suggestionsusevalues_syspref.sql @@ -0,0 +1, @@ +INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('SuggestionsUseValues', 'itemtypes', 'Suggestions can be submitted using the following authorized values:','itemtypes|ccode|loc|none','Choice') --- a/installer/data/mysql/updatedatabase.pl +++ a/installer/data/mysql/updatedatabase.pl @@ -10814,13 +10814,6 @@ if ( CheckVersion($DBversion) ) { SetVersion($DBversion); } -$DBversion = "3.19.00.XXX"; -if ( CheckVersion($DBversion) ) { - $dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ('SuggestionsUseValues', 'itemtypes', 'Suggestions can be submitted using the following authorized values:','itemtypes|ccode|loc|none','Choice')"); - print "Upgrade to $DBversion done (Bug 9223: Add SuggestionsUseValues syspref)\n"; - SetVersion ($DBversion); -} - # DEVELOPER PROCESS, search for anything to execute in the db_update directory # SEE bug 13068 # if there is anything in the atomicupdate, read and execute it. --