X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;ds=sidebyside;f=database%2Ftriggers.sql;h=9e9fd5649ea8efe76ec9a4fbd0f5a2830db23786;hb=8518049dc07ba0554aea4224d6c195bbacd9b8a6;hp=2e6b44c86c641774142f44d658a5723c7f444cad;hpb=677178daefe481e0144a2fc08ee2744839b450ad;p=ndwebbie.git

diff --git a/database/triggers.sql b/database/triggers.sql
index 2e6b44c..9e9fd56 100644
--- a/database/triggers.sql
+++ b/database/triggers.sql
@@ -83,31 +83,3 @@ BEGIN
 	RETURN NEW;
 END;
 $_X$ LANGUAGE plpgsql;
-
-CREATE OR REPLACE FUNCTION updated_target() RETURNS trigger
-    AS $_X$
-DECLARE
-	target INTEGER;
-BEGIN
-	IF TG_OP = 'INSERT' OR TG_OP = 'UPDATE' THEN
-		target := NEW.target;
-	ELSIF TG_OP = 'DELETE' THEN
-		target := OLD.target;
-	END IF;
-	UPDATE raid_targets SET modified = NOW() WHERE id = target;
-	RETURN NEW;
-END;
-$_X$ LANGUAGE plpgsql;
-
-CREATE OR REPLACE FUNCTION unclaim_target() RETURNS trigger
-    AS $_X$
-BEGIN
-	IF OLD.launched THEN
-		UPDATE users
-		SET attack_points = attack_points - 1
-		WHERE uid = OLD.uid;
-	END IF;
-	RETURN NEW;
-END;
-$_X$ LANGUAGE plpgsql;
-