CREATE TABLE `processes_measure` ( `id` int(11) NOT NULL auto_increment, `process_id` int(11) NOT NULL, `line` tinyint(4) NOT NULL, `val_pattern` int(11) NOT NULL, `val_1` decimal(3,2) NOT NULL, `val_2` decimal(3,2) NOT NULL, `val_3` decimal(3,2) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;