X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=database%2Fbigint.sql;fp=database%2Fbigint.sql;h=0761cf5f85605163f7cf3a20937ed7f4da26de1b;hp=396e4fbf30ca636944fa8a6343ffa4a1657c3c37;hb=e1450c026acb6bff904eb5a3b893dc5f270ba0a1;hpb=de8c64f530cd5d3da8ea97e1a0f4ea3b3d4f4a6e 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;