nooutput(<<END);
# Every row in dists and routes must refer to two existing rows in islands:
- SELECT * FROM $tab d LEFT JOIN islands ON (d.$end=islandid)
+ SELECT * FROM $tab d LEFT JOIN islands ON d.$end=islandid
WHERE islandname IS NULL;
END
# Every pair of islands must have an entry in dists:
SELECT * FROM islands ia JOIN islands ib LEFT JOIN dists
- ON (ia.islandid=aiid and ib.islandid=biid)
+ ON ia.islandid=aiid and ib.islandid=biid
WHERE dist IS NULL;
# Every stall and upload must refer to an island: