VbzCart/coding/integrity checks
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Table-specific checks:
Cross-table checks
Package lines and order lines which don't agree about what ID_Item they're tracking: <mysql>SELECT
*
FROM
ord_pkg_lines AS pl
JOIN
ord_lines AS ol ON pl.ID_OrdLine = ol.ID
WHERE
ol.ID_Item != pl.ID_Item</mysql>
