CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET latin1 */;

DROP TABLE IF EXISTS `test`.`table1`;
CREATE TABLE  `test`.`table1` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `data` varchar(45) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `test`.`table2`;
CREATE TABLE  `test`.`table2` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `fk_to_table1` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `Index_1` (`fk_to_table1`),
  CONSTRAINT `FK:table2:table1` FOREIGN KEY (`fk_to_table1`) REFERENCES `table1` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;