From: Michael Andreen <harv@ruin.nu>
Date: Sat, 3 Oct 2020 15:30:08 +0000 (+0200)
Subject: Convert alliance and galaxies score/value to bigint
X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=commitdiff_plain;h=de8c64f530cd5d3da8ea97e1a0f4ea3b3d4f4a6e

Convert alliance and galaxies score/value to bigint
---

diff --git a/database/bigint.sql b/database/bigint.sql
new file mode 100644
index 0000000..396e4fb
--- /dev/null
+++ b/database/bigint.sql
@@ -0,0 +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;
+	\ir views/alliances_resources.sql
+commit;