VbzCart/docs/coding/integrity checks

Table-specific checks:

• Template:L/vc/table

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>

Package lines whose Order Line is either not set or nonexistent(!): <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</mysql>