CREATE TABLE IF NOT EXISTS `MeasureMethod` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(255) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

ALTER TABLE `Measure` ADD `Method` INT NULL ,
ADD INDEX ( `Method` ) ;

ALTER TABLE `Measure` ADD FOREIGN KEY ( `Method` ) REFERENCES `MeasureMethod` (
`Id`
) ON DELETE RESTRICT ON UPDATE RESTRICT ;
