From de8c64f530cd5d3da8ea97e1a0f4ea3b3d4f4a6e Mon Sep 17 00:00:00 2001
From: Michael Andreen <harv@ruin.nu>
Date: Sat, 3 Oct 2020 17:30:08 +0200
Subject: [PATCH] Convert alliance and galaxies score/value to bigint

---
 database/bigint.sql | 6 ++++++
 1 file changed, 6 insertions(+)
 create mode 100644 database/bigint.sql

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;
-- 
2.39.2