View source for VbzCart/docs/coding/integrity checks

Table-specific checks:
* {{l/vc/table|cat_items/integrity checks}}
==Cross-table checks==
Package Lines and Order Lines which don't agree about what ID_Item they're tracking:
<source lang=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</source>
Package lines whose Order Line is either not set or nonexistent(!):
<source lang=mysql>SELECT 
    pl.*
FROM
    ord_pkg_lines AS pl
        LEFT JOIN
    ord_lines AS ol ON pl.ID_OrdLine = ol.ID
WHERE
    ol.ID IS NULL</source>