summaryrefslogtreecommitdiff
path: root/makima/migrations/20260205200000_fix_decimal_to_float.sql
diff options
context:
space:
mode:
authorsoryu <soryu@soryu.co>2026-02-05 02:18:39 +0000
committersoryu <soryu@soryu.co>2026-02-05 02:18:39 +0000
commit5205db1f26cff0b59c567915966ed1dd892ab472 (patch)
treea71473b1f9ec4931cdebc1d016f4428f21d7b685 /makima/migrations/20260205200000_fix_decimal_to_float.sql
parent41897cc090bdeacca881ecd75cc19c4e0926fd58 (diff)
downloadsoryu-5205db1f26cff0b59c567915966ed1dd892ab472.tar.gz
soryu-5205db1f26cff0b59c567915966ed1dd892ab472.zip
Fixup: SQL type
Diffstat (limited to 'makima/migrations/20260205200000_fix_decimal_to_float.sql')
-rw-r--r--makima/migrations/20260205200000_fix_decimal_to_float.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/makima/migrations/20260205200000_fix_decimal_to_float.sql b/makima/migrations/20260205200000_fix_decimal_to_float.sql
new file mode 100644
index 0000000..499cd6f
--- /dev/null
+++ b/makima/migrations/20260205200000_fix_decimal_to_float.sql
@@ -0,0 +1,11 @@
+-- Fix type mismatches: DECIMAL -> DOUBLE PRECISION for f64 compatibility
+-- DECIMAL/NUMERIC maps to rust_decimal::Decimal, not f64
+
+ALTER TABLE chains
+ ALTER COLUMN default_pass_threshold TYPE DOUBLE PRECISION;
+
+ALTER TABLE contract_evaluations
+ ALTER COLUMN overall_score TYPE DOUBLE PRECISION;
+
+ALTER TABLE chain_contract_definitions
+ ALTER COLUMN pass_threshold TYPE DOUBLE PRECISION;