rendered paste bodyCREATE 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;