 DROP TABLE IF EXISTS `compound_properties`;
 CREATE TABLE IF NOT EXISTS `compound_properties` (
   `compound_id` int(11) unsigned NOT NULL,
-  `mwt` decimal(8,3) unsigned NOT NULL,
-  `exact_mass` decimal(10,5) unsigned NOT NULL,
-  `clogp` decimal(5,2) 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,

  `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`),

  `cpd_type` varchar(50) DEFAULT NULL,
  `supplier` varchar(50) DEFAULT NULL,
  `batch_ref` varchar(50) DEFAULT NULL,
  `mwt` float unsigned DEFAULT NULL,
  `mass` float unsigned DEFAULT NULL,
  `vol` float unsigned DEFAULT NULL,
  `mol` float unsigned DEFAULT NULL,
  `density` float unsigned DEFAULT NULL,
  `equiv` float unsigned DEFAULT '1',
  `limiting` int(1) unsigned NOT NULL DEFAULT '0',
  `notes` text,
  `formula` varchar(50) DEFAULT NULL,
