From: Michael Andreen <harv@ruin.nu>
Date: Sat, 3 Oct 2020 15:44:30 +0000 (+0200)
Subject: Also change gain_day to bigint
X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=commitdiff_plain;h=e1450c026acb6bff904eb5a3b893dc5f270ba0a1

Also change gain_day to bigint
---

diff --git a/database/bigint.sql b/database/bigint.sql
index 396e4fb..0761cf5 100644
--- 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;