CREATE TABLE processes (
  id int(10) unsigned NOT NULL auto_increment,
  added bigint(20) NOT NULL default '0',
  userid bigint(20) NOT NULL default '0',
  batch_no varchar(255) NOT NULL default '',
  manufacturing_date bigint(20) NOT NULL default '0',
  isopropanol_batch_no varchar(255) NOT NULL default '',
  approved bigint(20) NOT NULL default '0',
  locked tinyint(4) NOT NULL default '0',
  filedata longblob NOT NULL,
  deleted smallint(6) NOT NULL default '0',
  measure_1_1 decimal(3,2) default NULL,
  measure_1_2 decimal(3,2) default NULL,
  measure_1_3 decimal(3,2) default NULL,
  measure_1_pattern int(11) default NULL,
  measure_2_1 decimal(3,2) default NULL,
  measure_2_2 decimal(3,2) default NULL,
  measure_2_3 decimal(3,2) default NULL,
  measure_2_pattern int(11) default NULL,
  measure_3_1 decimal(3,2) default NULL,
  measure_3_2 decimal(3,2) default NULL,
  measure_3_3 decimal(3,2) default NULL,
  measure_3_pattern int(11) default NULL,
  measure_4_1 decimal(3,2) default NULL,
  measure_4_2 decimal(3,2) default NULL,
  measure_4_3 decimal(3,2) default NULL,
  measure_4_pattern int(11) default NULL,
  measure_5_1 decimal(3,2) default NULL,
  measure_5_2 decimal(3,2) default NULL,
  measure_5_3 decimal(3,2) default NULL,
  measure_5_pattern int(11) default NULL,
  measure_6_1 decimal(3,2) default NULL,
  measure_6_2 decimal(3,2) default NULL,
  measure_6_3 decimal(3,2) default NULL,
  measure_6_pattern int(11) default NULL,
  measure_7_1 decimal(3,2) default NULL,
  measure_7_2 decimal(3,2) default NULL,
  measure_7_3 decimal(3,2) default NULL,
  measure_7_pattern int(11) default NULL,
  PRIMARY KEY  (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;