Also change gain_day to bigint

[ndwebbie.git] / database / bigint.sql

diff --git a/database/bigint.sql b/database/bigint.sql
index 396e4fbf30ca636944fa8a6343ffa4a1657c3c37..0761cf5f85605163f7cf3a20937ed7f4da26de1b 100644 (file)
--- a/database/bigint.sql
+++ b/database/bigint.sql
@@ -1,6 +1,6 @@
 BEGIN;
        DROP VIEW alliance_resources;
-       ALTER TABLE alliance_stats ALTER COLUMN score TYPE bigint;
-       ALTER TABLE galaxies ALTER COLUMN score TYPE bigint, ALTER COLUMN value TYPE bigint;
+       ALTER TABLE alliance_stats ALTER COLUMN score TYPE bigint, ALTER COLUMN score_gain_day TYPE bigint;
+       ALTER TABLE galaxies ALTER COLUMN score TYPE bigint, ALTER COLUMN value TYPE bigint, ALTER COLUMN score_gain_day TYPE bigint, ALTER COLUMN value_gain_day TYPE bigint;
        \ir views/alliances_resources.sql
 commit;