NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
''Example of enumcategory with duplicates (Query 1)'' <br/> <br/>
[[Image: Duplicate enumvalue2.png | 1000px]] <br/>
# Open table '''imsmaenum''' with Navicat and sort on '''enumcategory'''
# Compare the result set from '''before''' the upgrade scripts with current records
# Delete the new rows, in the example created with user '''migration''', by selecting the row and clicking on delete button# Set '''isactive''' to t (TRUE) on the old rows if the country had them as active in 5.08.04
# Repeat 2- 4 until all are done and run Query 2 as double-check of no duplicates remain.
{{NavBox Upgrade}}