   `cpd_name` text,
   `cpd_id` int(11) unsigned DEFAULT NULL,
   `batch_ref` varchar(50) DEFAULT NULL,
-  `mwt` decimal(8,3) unsigned DEFAULT NULL,
+  `mwt` float unsigned DEFAULT NULL,
   `mass` float unsigned DEFAULT NULL,
   `mol` float unsigned DEFAULT NULL,
   `yield` float unsigned DEFAULT NULL,

  `tot_charge` int(3) NOT NULL,
  `num_atom` int(5) unsigned NOT NULL,
  `num_bond` int(5) unsigned NOT NULL,
  `mol_psa` decimal(10,2) unsigned NOT NULL,
  `is_chiral` int(1) unsigned NOT NULL,
  `density` float unsigned DEFAULT NULL,
  PRIMARY KEY (`compound_id`),

DROP TABLE IF EXISTS `compound_properties`;
CREATE TABLE IF NOT EXISTS `compound_properties` (
  `compound_id` int(11) unsigned NOT NULL,
  `mwt` float unsigned NOT NULL,
  `exact_mass` float unsigned NOT NULL,
  `clogp` float NOT NULL,
  `formula` text,
  `num_donor` int(10) unsigned NOT NULL,
  `num_acceptor` int(5) unsigned NOT NULL,
