Add Full fleet from Military scan

[ndwebbie.git] / database / views / available_ships.sql

diff --git a/database/views/available_ships.sql b/database/views/available_ships.sql
index e7d70b7d95315cf8c3c798792103891287473606..98fee4b0f542ffbe46d75627c9d3804063532ff1 100644 (file)
--- 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