X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Fr24.sql;h=bc04b9da0412042dd3ad3178be4470117254a9f7;hb=b38002a1035bbdf3da505db7eccb2d706138da68;hp=395f7146a07e67ae3b33e67ecc26cd80b54f3f1c;hpb=e3c513be28262e681c6b4fc8e1795ff621c42523;p=ndwebbie.git

diff --git a/database/r24.sql b/database/r24.sql
index 395f714..bc04b9d 100644
--- a/database/r24.sql
+++ b/database/r24.sql
@@ -3,20 +3,3 @@ ALTER TABLE ship_stats ADD t2 text;
 ALTER TABLE ship_stats ADD t3 text;
 /*scan_id has gotten bigger*/
 ALTER TABLE scans ALTER COLUMN scan_id TYPE NUMERIC(10);
-
-/*Changes when target is unclaimed */
-/*
-CREATE OR REPLACE FUNCTION unclaim_target()
-  RETURNS "trigger" AS
-$BODY$my $query = spi_prepare('UPDATE raid_targets SET modified = NOW() WHERE id = $1','int4');
-my $target = $_TD->{new}{target};
-$target = $_TD->{old}{target} IF ($_TD->{event} eq 'DELETE');
-spi_exec_prepared($query,$target);
-spi_freeplan($query);$BODY$
-  LANGUAGE 'plperl' VOLATILE;
-ALTER FUNCTION updated_target() OWNER TO ndawn;
-
-CREATE TRIGGER unclaim_target AFTER DELETE
-   ON raid_claims FOR EACH ROW
-   EXECUTE PROCEDURE PUBLIC.unclaim_target();
-*/