X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=database%2Fr100.sql;h=d4f50de04852b4e75a69ace4d3d5d975887c31b7;hb=75707e9b9cb6a816379ac2a8ac0c215a4bbe2545;hp=debbc44804e276ab6d7146474efb35f2893c02bb;hpb=7ec7b824749bb077086f6eeeabe3be6ffad39c66;p=ndwebbie.git

diff --git a/database/r100.sql b/database/r100.sql
index debbc44..d4f50de 100644
--- a/database/r100.sql
+++ b/database/r100.sql
@@ -27,7 +27,7 @@ ALTER TABLE planets ADD FOREIGN KEY (gov) REFERENCES governments(gov) ON UPDATE
 DROP FUNCTION IF EXISTS find_planet_id(text,text,text,race);
 DROP FUNCTION covop_alert(integer, integer, integer, integer, govs, integer);
 \i functions/find_planet_id.sql
-\i functions/find_planet_id.sql
+\i functions/covop_alert.sql
 ALTER TABLE ship_stats ADD FOREIGN KEY (race) REFERENCES races(race) ON UPDATE CASCADE ON DELETE CASCADE;
 ALTER TABLE ship_stats ADD COLUMN cloaked BOOLEAN NOT NULL DEFAULT false, ADD COLUMN baseeta INTEGER NOT NULL DEFAULT 0;
 ALTER TABLE ship_stats ALTER COLUMN cloaked DROP DEFAULT, ALTER COLUMN baseeta DROP DEFAULT, ALTER COLUMN guns DROP DEFAULT, ALTER COLUMN eres DROP DEFAULT;
@@ -36,5 +36,6 @@ ALTER TABLE ship_stats ALTER COLUMN cloaked DROP DEFAULT, ALTER COLUMN baseeta D
 DROP TYPE race;
 DROP TYPE govs;
 
+ALTER TABLE incomings DROP CONSTRAINT incomings_call_key, ADD CONSTRAINT incomings_unique_key UNIQUE (call, pid, fleet, eta);
 
 \i functions/hostile_alliances.sql