lua script for mysql workbench to clear charset and collation

gistfile1.lua

function clearCharSetAndCollation()
  
  local schemata = grtV.getGlobal("/wb/doc/physicalModels/0/catalog/schemata")
  local s

  local tables
  local t

  for s=1, grtV.getn(schemata) do
    print(schemata[s].name .. "\n")
    
    tables = schemata[s].tables
    for t=1, grtV.getn(tables) do
      print("    " .. tables[t].name .. "\n")
      
      tables[t].defaultCharacterSetName = ""
      tables[t].defaultCollationName = ""
    end
    
  end
  
  return 1
  
end