X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=database%2Fviews%2Favailable_ships.sql;fp=database%2Fviews%2Favailable_ships.sql;h=98fee4b0f542ffbe46d75627c9d3804063532ff1;hp=e7d70b7d95315cf8c3c798792103891287473606;hb=33a44a03fa129739264f7ccd983e38c96c11a677;hpb=a482ae605a2ecb265854e6a02672524bbae2ae7a

diff --git a/database/views/available_ships.sql b/database/views/available_ships.sql
index e7d70b7..98fee4b 100644
--- a/database/views/available_ships.sql
+++ b/database/views/available_ships.sql
@@ -14,7 +14,7 @@ FROM users u JOIN (
 		FROM ticks
 			CROSS JOIN fleets f
 		WHERE tick <= t
-			AND name IN ('Main','Advanced Unit')
+			AND name IN ('Main', 'Advanced Unit', 'Military')
 			AND mission = 'Full fleet'
 		ORDER BY t,pid,mission,tick DESC, fid DESC
 	) f