From e1450c026acb6bff904eb5a3b893dc5f270ba0a1 Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Sat, 3 Oct 2020 17:44:30 +0200 Subject: [PATCH] Also change gain_day to bigint --- database/bigint.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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; -- 2.39.2