From e3c513be28262e681c6b4fc8e1795ff621c42523 Mon Sep 17 00:00:00 2001
From: Michael Andreen <harv@ruin.nu>
Date: Tue, 6 Nov 2007 09:32:45 +0100
Subject: [PATCH] more r24 changes

---
 database/multi-targets.sql |  3 ---
 database/r24.sql           | 22 ++++++++++++++++++++++
 2 files changed, 22 insertions(+), 3 deletions(-)
 delete mode 100644 database/multi-targets.sql
 create mode 100644 database/r24.sql

diff --git a/database/multi-targets.sql b/database/multi-targets.sql
deleted file mode 100644
index 23e3316..0000000
--- a/database/multi-targets.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-ALTER TABLE ship_stats RENAME COLUMN target TO t1;
-ALTER TABLE ship_stats ADD t2 text;
-ALTER TABLE ship_stats ADD t3 text;
diff --git a/database/r24.sql b/database/r24.sql
new file mode 100644
index 0000000..395f714
--- /dev/null
+++ b/database/r24.sql
@@ -0,0 +1,22 @@
+ALTER TABLE ship_stats RENAME COLUMN target TO t1;
+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();
+*/
-- 
2.39.2