Convert alliance and galaxies score/value to bigint

[ndwebbie.git] / database / bigint.sql

diff --git a/database/bigint.sql b/database/bigint.sql
new file mode 100644 (file)
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;