DDL sql execution error upon 1.9 to 2.0 migration

According to the discussion http://moodle.org/mod/forum/discuss.php?d=150223, following the result of the SQL query suggested by Eloy:

– phpMyAdmin SQL Dump
– version 2.11.8.1deb5+lenny4
– http://www.phpmyadmin.net
–
-- Host: 192.168.1.12
– Generato il: 18 Mag, 2010 at 06:58 PM
– Versione MySQL: 5.0.51
– Versione PHP: 5.2.13-0.dotdeb.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

–
-- Database: `moodle20`
–

– --------------------------------------------------------

–
-- Struttura della tabella `mdl_block_instances`
–

CREATE TABLE IF NOT EXISTS `mdl_block_instances` (
`id` int(10) NOT NULL auto_increment,
`blockid` int(10) NOT NULL default '0',
`blockname` varchar(40) collate utf8_unicode_ci default NULL,
`contextid` bigint(10) unsigned default NULL,
`showinsubcontexts` smallint(4) default NULL,
`pageid` int(10) NOT NULL default '0',
`pagetypepattern` varchar(20) collate utf8_unicode_ci NOT NULL default '',
`subpagepattern` varchar(16) collate utf8_unicode_ci default NULL,
`defaultregion` varchar(16) collate utf8_unicode_ci NOT NULL default '',
`defaultweight` smallint(3) NOT NULL default '0',
`visible` tinyint(1) NOT NULL default '0',
`configdata` text collate utf8_unicode_ci,
PRIMARY KEY (`id`),
KEY `pageid` (`pageid`),
KEY `pagetype` (`pagetypepattern`),
KEY `mdl_blocinst_blo_ix` (`blockid`)
) Engine=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4788 ;

–
-- Dump dei dati per la tabella `mdl_block_instances`
–

INSERT INTO `mdl_block_instances` (`id`, `blockid`, `blockname`, `contextid`, `showinsubcontexts`, `pageid`, `pagetypepattern`, `subpagepattern`, `defaultregion`, `defaultweight`, `visible`, `configdata`) VALUES
(598, 23, NULL, 15, 0, 64, 'course-view-*', NULL, 'side-post', 1, 1, 'Tzo4OiJzdGRDbGFzcyI6NDp7czo1OiJ0aXRsZSI7czozMDoiUml2b2xnaSB1bmEgZG9tYW5kYSBhaSBkb2NlbnRpIjtzOjg6Imxpbmt0ZXh0IjtzOjE3OiJTY3JpdmkgbGEgZG9tYW5kYSI7czoxMToiZGlzcGxheXR5cGUiO3M6MToiMCI7czo3OiJzdWJqZWN0IjtzOjA6IiI7fQ=='),
(592, 24, NULL, 15, 0, 64, 'course-view-*', NULL, 'side-pre', 0, 1, ''),
(591, 28, NULL, 203, 0, 1, 'site-index', NULL, 'side-pre', 6, 1, ''),
(262, 24, NULL, 11, 0, 29, 'course-view-*', NULL, 'side-pre', 0, 1, ''),
(303, 24, NULL, 9, 0, 26, 'course-view-*', NULL, 'side-pre', 1, 1, ''),
(304, 23, NULL, 9, 0, 26, 'course-view-*', NULL, 'side-post', 1, 1, ''),
(305, 24, NULL, 18, 0, 31, 'course-view-*', NULL, 'side-pre', 0, 1, ''),
(306, 23, NULL, 18, 0, 31, 'course-view-*', NULL, 'side-post', 2, 1, ''),
(352, 24, NULL, 27, 0, 35, 'course-view-*', NULL, 'side-pre', 0, 1, ''),
(417, 24, NULL, 35, 0, 41, 'course-view-*', NULL, 'side-pre', 0, 1, ''),
(736, 24, NULL, 46, 0, 79, 'course-view-*', NULL, 'side-pre', 0, 1, ''),
(751, 24, NULL, 44, 0, 77, 'course-view-*', NULL, 'side-pre', 0, 1, ''),
(747, 24, NULL, 45, 0, 78, 'course-view-*', NULL, 'side-pre', 0, 1, ''),
(762, 24, NULL, 2875, 0, 7, 'blog-index', NULL, 'side-post', 2, 1, ''),
(803, 24, NULL, 16, 0, 65, 'course-view-*', NULL, 'side-post', 1, 1, '');