 insert into common_lookup(name,attribute, value) values ('Condition', 'name','Lyophilization');
 insert into common_lookup(name,attribute, value) values ('Condition', 'name','Sonication');
 insert into common_lookup(name,attribute, value) values ('Condition', 'name','Electromagnetic Radiation');
+
 insert into common_lookup(name,attribute, value) values ('Lyophilization', 'property','time');
 insert into common_lookup(name,attribute, value) values ('Solvent Media', 'property','with serum');
 insert into common_lookup(name,attribute, value) values ('Solvent Media', 'property','ion concentration');

set attribute='datumName'
where attribute='derivedDatumName';

delete from common_lookup
where name in ('CFU_GM', 'Hemolysis', 'PlateletAggregation', 'CellViability')
and attribute='datumName';

insert into common_lookup(name,attribute, value) values ('bandwidth', 'unit','Hz');
insert into common_lookup(name,attribute, value) values ('frequency', 'unit','Hz');
insert into common_lookup(name,attribute, value) values ('wavelength', 'unit','nm');
insert into common_lookup(name,attribute,value) values ('dimension', 'unit', ' nm');
insert into common_lookup(name,attribute,value) values ('luminescence signal', 'unit', 'volt');

update common_lookup
set name='Datum'
