CREATE TABLE IF NOT EXISTS `mdl_block_instances` (
  `id` bigint(10) unsigned NOT NULL auto_increment,
  `blockname` varchar(40) NOT NULL default '',
  `parentcontextid` bigint(10) unsigned NOT NULL,
  `showinsubcontexts` smallint(4) NOT NULL,
  `pagetypepattern` varchar(64) NOT NULL default '',
  `subpagepattern` varchar(16) default NULL,
  `defaultweight` smallint(3) NOT NULL default '0',
  `configdata` text,
  `defaultregion` varchar(16) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `mdl_blocinst_parshopagsub_ix` (`parentcontextid`,`showinsubcontexts`,`pagetypepattern`,`subpagepattern`)
) ;