FreeRx: INN / drug mismatch

[jeromecc]

Possible regressions from FMF 0.9.0 -> FMF 0.9.8 / FHIO 0.9.9

• error with INN names & dosages:
  • paracetamol -> propacetamol
  • atorvastatine 20 -> atrovastatine 21,69

Caused by update of database scheme (<= 0.8.4 not compatible with recent versions)?

[jeromecc]

Propacetamol (ATC N02BE05) and Paracetamol (N02BE01) are members of the same ATC group: N02BE Anilides FreeRx code needs to be updated to use this way of retrieving INN from the database:

1. DID aka Drug ID) -> MID aka Molecule ID (t4 COMPO): SELECT `f3` FROM `t4` WHERE `f2` = "DID";
   2. MID -> INN (t3 MOLS): SELECT `f3` FROM `t3` WHERE `f1` = "MID";