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

diff --git a/database/r100.sql b/database/r100.sql
index debbc44..feebfdf 100644
--- a/database/r100.sql
+++ b/database/r100.sql
@@ -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