#--------------------------------------------------------------------------------------------------------
# Task 11403. - Please implement the fixes/revisions | 07/12/2010
#--------------------------------------------------------------------------------------------------------

ALTER TABLE `ie_DGrade` CHANGE `id` `id` CHAR( 2 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE `ie_DGrade` CHANGE `title` `title` CHAR( 2 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;

INSERT INTO `ie_DGrade` (`id` ,`title` ,`sorter`)VALUES ('9', '9', '10');
INSERT INTO `ie_DGrade` (`id` ,`title` ,`sorter`)VALUES ('10', '10', '11');
INSERT INTO `ie_DGrade` (`id` ,`title` ,`sorter`)VALUES ('11', '11', '12');
INSERT INTO `ie_DGrade` (`id` ,`title` ,`sorter`)VALUES ('12', '12', '13');

OPTIMIZE TABLE `ie_DGrade` ;