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

diff --git a/database/r100.sql b/database/r100.sql
index b5f644c..debbc44 100644
--- a/database/r100.sql
+++ b/database/r100.sql
@@ -29,9 +29,12 @@ DROP FUNCTION covop_alert(integer, integer, integer, integer, govs, integer);
 \i functions/find_planet_id.sql
 \i functions/find_planet_id.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;
 \d ship_stats
 
 DROP TYPE race;
 DROP TYPE govs;
 
+
 \i functions/hostile_alliances.sql