summaryrefslogtreecommitdiff
path: root/util/sql/all.sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2010-12-18 19:28:08 +0100
committerYorhel <git@yorhel.nl>2010-12-18 19:31:57 +0100
commita129097a782ced2f2c3622f239809a937ecdb7d4 (patch)
tree627c0b6d0834de24b3e1d447a20f05605f1848ca /util/sql/all.sql
parent84017ee51424de8ada6f5e93d943dc1b4584e855 (diff)
RFC-01: Implemented (most) of the SQL part
- Created vnlists table - Converted rlists.vstat into that table - Added triggers to make sure that there is always a corresponding row in vnlists for every row in rlists. - Added a check on vnlists for the 'listdel' notify
Diffstat (limited to 'util/sql/all.sql')
-rw-r--r--util/sql/all.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/util/sql/all.sql b/util/sql/all.sql
index 4408c6df..8f55ed88 100644
--- a/util/sql/all.sql
+++ b/util/sql/all.sql
@@ -96,6 +96,9 @@ CREATE TRIGGER vn_vnsearch_notify AFTER UPDATE ON releases FOR EACH ROW
WHEN (NEW.hidden IS DISTINCT FROM OLD.hidden OR NEW.latest IS DISTINCT FROM OLD.latest)
EXECUTE PROCEDURE vn_vnsearch_notify();
+CREATE CONSTRAINT TRIGGER update_vnlist_rlist AFTER DELETE ON vnlists DEFERRABLE FOR EACH ROW EXECUTE PROCEDURE update_vnlist_rlist();
+CREATE CONSTRAINT TRIGGER update_vnlist_rlist AFTER INSERT ON rlists DEFERRABLE FOR EACH ROW EXECUTE PROCEDURE update_vnlist_rlist();
+
-- Sequences used for ID generation of items not in the DB
CREATE SEQUENCE covers_seq;