X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=database%2Fbigint.sql;fp=database%2Fbigint.sql;h=396e4fbf30ca636944fa8a6343ffa4a1657c3c37;hp=0000000000000000000000000000000000000000;hb=de8c64f530cd5d3da8ea97e1a0f4ea3b3d4f4a6e;hpb=ec198a21465e578fe2f2a49c4ece32ad78d2d4d5

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;