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