#!/bin/sh

PERL=/usr/bin/perl

$PERL -pi -e 's/(AUTO_INCREMENT=[0-9]+ )*DEFAULT CHARSET=(latin1|utf8)/DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci/' $1
$PERL -pi -e 's/ COLLATE=utf8_unicode_ci COLLATE=utf8_unicode_ci/ COLLATE=utf8_unicode_ci/' $1
$PERL -pi -e 's/ collate utf8_unicode_ci//' $1
$PERL -pi -e 's/ character set (latin1|utf8)//' $1

exit 0