diff options
author | Eelco Dolstra <e.dolstra@tudelft.nl> | 2010-02-24T14·39+0000 |
---|---|---|
committer | Eelco Dolstra <e.dolstra@tudelft.nl> | 2010-02-24T14·39+0000 |
commit | 6baa2a2f5ef5b11859b95f453338efaf7c5b2724 (patch) | |
tree | 9614f430442178147d3026b77ff773750383d877 /src/libstore/schema.sql | |
parent | 9fd85c94de90ec91ccf8a4bf04e8911e6e3e483b (diff) |
Diffstat (limited to 'src/libstore/schema.sql')
-rw-r--r-- | src/libstore/schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/libstore/schema.sql b/src/libstore/schema.sql index 4adad34b700e..7438632edbd9 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; |