aboutsummaryrefslogtreecommitdiff
path: root/src/libstore
diff options
context:
space:
mode:
authorEelco Dolstra <e.dolstra@tudelft.nl>2010-02-24 14:39:52 +0000
committerEelco Dolstra <e.dolstra@tudelft.nl>2010-02-24 14:39:52 +0000
commit6baa2a2f5ef5b11859b95f453338efaf7c5b2724 (patch)
tree9614f430442178147d3026b77ff773750383d877 /src/libstore
parent9fd85c94de90ec91ccf8a4bf04e8911e6e3e483b (diff)
Diffstat (limited to 'src/libstore')
-rw-r--r--src/libstore/schema.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/libstore/schema.sql b/src/libstore/schema.sql
index 4adad34b7..7438632ed 100644
--- a/src/libstore/schema.sql
+++ b/src/libstore/schema.sql
@@ -22,7 +22,7 @@ create index if not exists IndexReference on Refs(reference);
-- ValidPaths to cause a foreign key constraint violation (due to `on
-- delete restrict' on the `reference' column). Therefore, explicitly
-- get rid of self-references.
-create trigger DeleteSelfRefs before delete on ValidPaths
+create trigger if not exists DeleteSelfRefs before delete on ValidPaths
begin
delete from Refs where referrer = old.id and reference = old.id;
end;