chiark
/
gitweb
/
~yarrgweb
/
ypp-sc-tools.db-live.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Can compact ids and remove obsolete commodities
[ypp-sc-tools.db-live.git]
/
yarrg
/
CommodsDatabase.pm
diff --git
a/yarrg/CommodsDatabase.pm
b/yarrg/CommodsDatabase.pm
index 6ed0b742f6d3d3f2d9d00c78515de2cb6bc327b6..d978358e4460e70c6e6e676b53a93817550238d3 100644
(file)
--- a/
yarrg/CommodsDatabase.pm
+++ b/
yarrg/CommodsDatabase.pm
@@
-188,7
+188,7
@@
END
nooutput(<<END);
# Every row in dists and routes must refer to two existing rows in islands:
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
WHERE islandname IS NULL;
END
@@
-198,7
+198,7
@@
END
# Every pair of islands must have an entry in dists:
SELECT * FROM islands ia JOIN islands ib LEFT JOIN dists
# 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:
WHERE dist IS NULL;
# Every stall and upload must refer to an island: