dbug

[mir.git] / dbscripts / dupetrigger / postgresql.sript

diff --git a/dbscripts/dupetrigger/postgresql.sript b/dbscripts/dupetrigger/postgresql.sript
index 69b3d36..220016b 100755 (executable)
--- a/dbscripts/dupetrigger/postgresql.sript
+++ b/dbscripts/dupetrigger/postgresql.sript
@@ -1,5 +1,7 @@
 \connect - postgres
 DROP FUNCTION dupecheck();
-DROP TRIGGER dupetrigger ON comment;
-CREATE FUNCTION dupecheck() RETURNS OPAQUE AS '/path/to/dupetrigger.so' LANGUAGE 'C';
-CREATE TRIGGER dupetrigger BEFORE INSERT OR UPDATE ON comment FOR EACH ROW EXECUTE PROCEDURE dupecheck();
+DROP TRIGGER commdupetrigger ON comment;
+DROP TRIGGER contentdupetrigger ON content;
+CREATE FUNCTION dupecheck() RETURNS OPAQUE AS '/pub/Dokumente/Indymedia/de-tech/Mir/src/dupetrigger.so' LANGUAGE 'C';
+CREATE TRIGGER contentdupetrigger BEFORE INSERT OR UPDATE ON content FOR EACH ROW EXECUTE PROCEDURE dupecheck("no", "title", "subtitle", "creator", "description", "content_data");
+CREATE TRIGGER commdupetrigger BEFORE INSERT OR UPDATE ON comment FOR EACH ROW EXECUTE PROCEDURE dupecheck("no", "creator", "to_media", "description", "title");