[Dolibarr-bugtrack] [bug #33881] can delete products with supplier refs, or subproducts

[Laurent Destailleur]

Update of bug #33881 (project dolibarr):

                  Status:          Ready For Test => In Progress            

    _______________________________________________________

Follow-up Comment #1:

Constraint must also be added into migrate process:

--V4.1 DELETE FROM llx_product_fournisseur where fk_product NOT IN (SELECT
rowid from llx_product);

ALTER TABLE llx_product_fournisseur ADD CONSTRAINT
fk_product_fournisseur_fk_product    FOREIGN KEY (fk_product)    REFERENCES
llx_product (rowid);

    _______________________________________________________

Reply to this item at:

  <http://savannah.nongnu.org/bugs/?33881>

_______________________________________________
  Message posté via/par Savannah
  http://savannah.nongnu.org/