X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=database%2Fr100.sql;fp=database%2Fr100.sql;h=d4f50de04852b4e75a69ace4d3d5d975887c31b7;hp=feebfdf157e39964efe2e4d975fa00f8b4444983;hb=75707e9b9cb6a816379ac2a8ac0c215a4bbe2545;hpb=202d442fc929b5e4cea904406dc546098516fde1 diff --git a/database/r100.sql b/database/r100.sql index feebfdf..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;