diff options
| author | Yorhel <git@yorhel.nl> | 2010-11-10 21:47:54 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2010-11-10 21:47:54 +0100 |
| commit | 85f1ad4cefe5ac3e3c0ff9f05d8da4a9c20d9812 (patch) | |
| tree | 4049e95ea37a6df2f9bd5c7dda2a7ae822e5f691 /util | |
| parent | aecbeeb6564e9e21630ec933a56fe488c6b0b66d (diff) | |
Multi::RG: Use dotted line to indicate unofficial status in VN relations
Also fixed a minor bug with no change notification being sent to Multi
when only the official flag has been changed.
Diffstat (limited to 'util')
| -rw-r--r-- | util/sql/func.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/util/sql/func.sql b/util/sql/func.sql index 922d1af8..371e3ed0 100644 --- a/util/sql/func.sql +++ b/util/sql/func.sql @@ -496,7 +496,7 @@ BEGIN -- 3. EXISTS(SELECT 1 FROM vn_rev v1, vn_rev v2 WHERE v2.title <> v1.title AND v1.id = OLD.latest AND v2.id = NEW.latest) -- 4. (not-really-readable method of comparing two query results) - OR EXISTS(SELECT vid2, relation FROM vn_relations WHERE vid1 = OLD.latest EXCEPT SELECT vid2, relation FROM vn_relations WHERE vid1 = NEW.latest) + OR EXISTS(SELECT vid2, relation, official FROM vn_relations WHERE vid1 = OLD.latest EXCEPT SELECT vid2, relation, official FROM vn_relations WHERE vid1 = NEW.latest) OR (SELECT COUNT(*) FROM vn_relations WHERE vid1 = OLD.latest) <> (SELECT COUNT(*) FROM vn_relations WHERE vid1 = NEW.latest) ) THEN |