nairobi 8b94d404d3 fix: floor arcaea's profile potential (#1746) ...

* fix: flooring profile potential

* fix: on conflict do nothing

2026-09-27 12:18:01 +01:00

..

20260301154256_genesis.sql

fix: crosshost

2026-05-11 17:48:14 +00:00

20260508212500_import_status.sql

fix: import status polling was hopelessly invalid

2026-05-08 21:51:49 +01:00

20260510120000_one_default_table_per_game_rm.sql

fix: a lot of seeds apply fixes

2026-05-10 20:02:49 +01:00

20260511181145_import_session_session_id_on_delete_cascade.sql

fix: crosshost

2026-05-11 17:48:14 +00:00

20260511200000_notification_orphans_restored_kind.sql

feat: notify users when orphans resolve

2026-05-11 18:03:08 +00:00

20260516120000_quest_proposals.sql

dasdatmeespresso

2026-05-16 19:53:23 +00:00

20260516190000_quest_submitter_permission.sql

dasdatmeespresso

2026-05-16 19:53:23 +00:00

20260517120000_clear_showcase_orphan_refs.sql

fix: new migration; fix broken showcase stats

2026-05-17 20:26:30 +00:00

20260518160000_chart_leaderboard_materialized.sql

fix: db optimisations, 2

2026-05-18 11:30:50 +00:00

20260518210000_pg_observability_pg_stat_statements.sql

fix: a first miscellany of postgres fixes

2026-05-18 11:54:18 +00:00

20260518221500_score_game_chart_id_idx.sql

fix: a first miscellany of postgres fixes

2026-05-18 11:54:18 +00:00

20260518224500_score_session_id_idx.sql

fix: postgresfixes 2

2026-05-18 12:07:36 +00:00

20260523071801_Colour_class_updates_for_maimai_DX_and_CHUNITHM.sql

Add new color classes for maimai DX and CHUNITHM (#1561)

2026-05-23 15:42:08 +01:00

20260523120000_import_timestop.sql

feat: import timestops (#1574)

2026-05-24 13:06:13 +01:00

20260524120000_chart_playcount.sql

feat: highly optimise playcount-based queries (#1572)

2026-05-24 01:04:25 +01:00

20260524140000_import_provided_class.sql

feat: pick your own dan, if you want (#1575)

2026-05-24 15:19:53 +01:00

20260525194600_recalc_arcaea.sql

feat: better arcaea judgement cell + ptt calculation fixes (#1589)

2026-05-26 18:25:16 +01:00

20260602000000_recalc_sdvx.sql

fix: and add a migration for sdvx recalc

2026-06-01 23:34:22 +00:00

20260606160000_import_id_lookup_indexes.sql

feat: add some really big indexes (60% of database load lol) (#1645)

2026-06-06 21:38:44 +01:00

20260611091144_statement_level_dirty_enqueues.sql

Fix deadlocks caused by rederiving scores (#1659)

2026-06-12 13:30:36 +01:00

20260612120000_pb_dirty_committed_and_calculated_at.sql

feat: maybe stabilise pb cleaning (#1662)

2026-06-13 11:22:35 +01:00

20260612162243_goal_id_on_update_cascade.sql

fix: sdvx goals maxxive + ensure this is easier to fix in future (#1661)

2026-06-13 11:04:29 +01:00

20260615024243_only_rebuild_leaderboard_score_change.sql

only rebuild chart leaderboard when ranking changes (#1671)

2026-06-16 19:06:27 +01:00

20260618150000_score_view.sql

fix: robustify committed=false and add partman (#1686)

2026-06-18 20:16:53 +01:00

20260618160000_action_partition.sql

fix: robustify committed=false and add partman (#1686)

2026-06-18 20:16:53 +01:00

20260618170000_game_stats_snapshot_partition.sql

fix: robustify committed=false and add partman (#1686)

2026-06-18 20:16:53 +01:00

20260618180000_game_stats_snapshot_copy.sql

fix: robustify committed=false and add partman (#1686)

2026-06-18 20:16:53 +01:00

20260618190000_import_goal_float_progress.sql

fix: Possibly fix the committed=false issue (#1687)

2026-06-18 22:09:25 +01:00

20260713222852_import_cg_xxx_iidx.sql

fix: update import_type enum to support the new types (#1717)

2026-07-13 23:30:52 +01:00

20260830000000_arcaea_inscribed.sql

feat: arcaea 7.0 (#1736)

2026-09-16 20:44:45 +01:00

20260917000000_arcaea_precision_adjustment.sql

fix: floor arcaea's profile potential (#1746)

2026-09-27 12:18:01 +01:00